get('page', 1)); $pageSize = intval($request->get('pageSize', 10)); $keyword = format_string($request->get('keyword', '')); $roleStatus = $request->get('role_status', ''); $rows = SysRole::select('*') ->when($keyword != '', function ($query) use ($keyword) { $query->where('role_name', 'like', '%' . $keyword . '%'); }) ->when($roleStatus != '', function ($query) use ($roleStatus) { $query->where('role_status', $roleStatus); }) ->orderBy('role_addtimes', 'DESC') // ->forPage($page, $pageSize) ->get() ->toArray(); $total = SysRole::when($keyword != '', function ($query) use ($keyword) { $query->where('role_name', 'like', '%' . $keyword . '%'); })->count(); foreach ($rows as &$row) { if (!empty($row['role_permission']) && is_json($row['role_permission'])) { $row['role_permission'] = json_decode($row['role_permission']); } } return json_success('', compact('rows', 'page', 'pageSize', 'total')); } /** * @Desc 角色详情 * @Author Gorden * @Date 2024/2/20 16:37 * * @param $id * @return \support\Response */ public static function roleInfo($id) { $role = SysRole::find($id); if (!$role) { return json_fail('角色不存在'); } $role = $role->toArray(); return json_success('', $role); } /** * @Desc 添加角色 * @Author Gorden * @Date 2024/2/20 16:02 * * @param $params * @return \support\Response */ public static function insertRole($params) { try { Db::beginTransaction(); $data = [ 'role_superior_id' => $params['role_superior_id'] ?? 0, 'role_status' => $params['role_status'], 'role_category' => $params['role_category'], 'role_name' => $params['role_name'], 'role_remark' => $params['role_remark'] ? format_string($params['role_remark']) : null, 'role_extend_json' => $params['role_extend_json'] ?? null, 'role_permission' => '[]', 'role_addtimes' => time() ]; $roleId = SysRole::insertGetId($data); $path = '/0/'; if (!empty($params['role_superior_id'])) { $superior = SysRole::find($params['role_superior_id']); dump($superior); if (!isset($superior->role_path)) { Db::rollBack(); return json_fail("上级角色不存在"); } $path = $superior->role_path; } SysRole::where('role_id', $roleId)->update(['role_path' => $path . $roleId . '/']); Db::commit(); } catch (\Exception $e) { Db::rollBack(); dump($e->getMessage()); return json_fail('角色添加失败'); } return json_success('角色添加成功'); } /** * @Desc 修改角色 * @Author Gorden * @Date 2024/2/20 16:02 * * @param $id * @param $params * @return \support\Response */ public static function updateRole($id, $params) { $role = SysRole::find($id); $oldPath = $role->role_path; if (!$role) { return json_fail('角色不存在'); } try { Db::beginTransaction(); $data = [ 'role_superior_id' => $params['role_superior_id'] ?? 0, 'role_status' => $params['role_status'], 'role_category' => $params['role_category'], 'role_name' => $params['role_name'], 'role_remark' => $params['role_remark'] ? format_string($params['role_remark']) : null, 'role_extend_json' => $params['role_extend_json'] ?? '{}', ]; if ($data['role_superior_id'] == 0) { $data['role_path'] = '/0/' . $id . '/'; } else if ($data['role_superior_id'] != $role->role_superior_id) { $superior = SysRole::find($data['role_superior_id']); $data['role_path'] = $superior->role_path . $id . '/'; $child = SysRole::where('role_path', 'like', $oldPath . '%')->get(); dump($child); foreach ($child as $item) { $childPath = str_replace($oldPath, $data['role_path'], $item->role_path); SysRole::where('role_id', $item->role_id)->update(['role_path'=>$childPath]); } } dump($data); if (!SysRole::where('role_id', $id)->update($data)) { Db::rollBack(); throw new \Exception('角色修改失败'); } Db::commit(); } catch (\Exception $e) { Db::rollBack(); return json_fail($e->getMessage()); } return json_success('角色修改成功'); } public static function updatePermission($id, $params) { $role = SysRole::find($id); if (!$role) { return json_fail('角色不存在'); } try { $data = [ 'role_permission' => $params['role_permission'], ]; SysRole::where('role_id', $id)->update($data); } catch (\Exception $e) { return json_fail($e->getMessage()); } return json_success('角色修改成功'); } /** * @Desc 删除角色 * @Author Gorden * @Date 2024/2/20 16:40 * * @param $id * @return \support\Response */ public static function delRole($params) { try { if (!SysRole::whereIn('role_id', $params['role_id'])->delete()) { throw new \Exception('角色删除失败'); } } catch (\Exception $e) { return json_fail('角色删除失败'); } return json_success('角色删除成功'); } /** * @Desc 修改角色状态 * @Author Gorden * @Date 2024/2/20 16:50 * * @param $id * @param $roleStatus * @return \support\Response */ public static function updateStatus($id, $roleStatus) { try { if (!SysRole::where('role_id', $id)->update(['role_status' => $roleStatus])) { throw new \Exception('角色状态修改失败'); } } catch (\Exception $e) { return json_fail('角色状态修改失败'); } return json_success('角色状态修改成功'); } /** * @Desc 检查角色是否存在 * @Author Gorden * @Date 2024/2/21 13:36 * * @param $roleId * @return bool */ public static function checkRoleExist($roleId) { return SysRole::where('role_id', $roleId)->exists(); } }