order('id', 'asc')->select()->toArray(); $list = []; foreach ($rows as $r) { $list[] = [ 'id' => (int) $r['id'], 'name' => $r['name'], 'code' => $r['code'], 'remark' => $r['remark'], 'status' => (int) $r['status'], ]; } return json(['code' => 0, 'msg' => 'ok', 'data' => ['list' => $list]]); } public function save() { $id = (int) $this->request->post('id', 0); $name = trim((string) $this->request->post('name', '')); $code = trim((string) $this->request->post('code', '')); $remark = trim((string) $this->request->post('remark', '')); $status = (int) $this->request->post('status', 1); if ($name === '') { return json(['code' => 400, 'msg' => '名称必填', 'data' => []]); } $now = date('Y-m-d H:i:s'); if ($id <= 0) { Db::name('sys_role')->insert([ 'name' => $name, 'code' => $code, 'remark' => $remark, 'status' => $status, 'create_time' => $now, 'update_time' => $now, ]); } else { Db::name('sys_role')->where('id', $id)->update([ 'name' => $name, 'code' => $code, 'remark' => $remark, 'status' => $status, 'update_time' => $now, ]); } return json(['code' => 0, 'msg' => '已保存', 'data' => []]); } public function delete(int $id) { if ($id === 1) { return json(['code' => 400, 'msg' => '不能删除超级角色', 'data' => []]); } Db::name('sys_role_menu')->where('role_id', $id)->delete(); Db::name('sys_role')->where('id', $id)->delete(); return json(['code' => 0, 'msg' => '已删除', 'data' => []]); } /** 某角色已选菜单 id */ public function menuIds(int $id) { $ids = Db::name('sys_role_menu')->where('role_id', $id)->column('menu_id'); return json(['code' => 0, 'msg' => 'ok', 'data' => ['menu_ids' => array_map('intval', $ids)]]); } /** 保存角色-菜单 */ public function saveMenus(int $id) { $menuIds = $this->request->post('menu_ids', []); if (!is_array($menuIds)) { return json(['code' => 400, 'msg' => 'menu_ids 须为数组', 'data' => []]); } Db::name('sys_role_menu')->where('role_id', $id)->delete(); foreach ($menuIds as $mid) { $mid = (int) $mid; if ($mid <= 0) { continue; } Db::name('sys_role_menu')->insert(['role_id' => $id, 'menu_id' => $mid]); } return json(['code' => 0, 'msg' => '已保存权限', 'data' => []]); } }