123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240 |
- <?php
- namespace app\admin\service\sys_manage;
- use app\model\SysRole;
- use support\Db;
- use support\Request;
- class RoleService
- {
- /**
- * @Desc 角色列表
- * @Author Gorden
- * @Date 2024/2/20 16:29
- *
- * @param $page
- * @param $limit
- * @param $keyword
- * @return \support\Response
- */
- public static function roleList(Request $request)
- {
- $page = intval($request->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();
- }
- }
|