UserService.php 9.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278
  1. <?php
  2. namespace app\admin\service\sys_manage;
  3. use app\model\Member;
  4. use app\model\SysUser;
  5. use support\Db;
  6. use support\Request;
  7. class UserService
  8. {
  9. /**
  10. * @Desc 用户列表
  11. * @Author Gorden
  12. * @Date 2024/2/21 14:46
  13. *
  14. * @param $page
  15. * @param $limit
  16. * @param $keywords
  17. * @return \support\Response
  18. */
  19. public static function userList(Request $request)
  20. {
  21. $page = $request->get('page', 1);
  22. $pageSize = $request->get('pageSize', 10);
  23. $username = $request->get('username', '');
  24. $rows = SysUser::with('role')
  25. ->select('join_user_role_id', 'join_user_dept_id', 'user_id', 'user_status', 'user_category', 'user_name', 'user_login_name', 'user_mobile', 'user_remark', 'user_extend_json', 'user_addtimes')
  26. ->when($username != '', function ($query) use ($username) {
  27. $query->where('user_name', 'like', '%' . $username . '%');
  28. })
  29. ->orderBy('user_addtimes', 'DESC')
  30. ->forPage($page, $pageSize)
  31. ->get()
  32. ->toArray();
  33. foreach($rows as &$item){
  34. if(!empty($item['user_extend_json'])){
  35. $extendJson = json_decode($item['user_extend_json'],true);
  36. $item['avatar'] = !empty($extendJson['avatar']) ? getenv('STORAGE_DOMAIN').$extendJson['avatar'] : '';
  37. $item['info'] = $extendJson['info'] ?? '';
  38. }
  39. }
  40. $total = SysUser::when($username != '', function ($query) use ($username) {
  41. $query->where('user_name', 'like', '%' . $username . '%');
  42. })->count();
  43. return json_success('', compact('rows', 'page', 'pageSize', 'total'));
  44. }
  45. public static function selectTeacherList(Request $request)
  46. {
  47. $roleId = "28";
  48. $user = SysUser::where('join_user_role_id',$roleId)
  49. ->select('user_id','user_name')
  50. ->get()
  51. ->toArray();
  52. return json_success('',$user);
  53. }
  54. /**
  55. * @Desc 用户详情
  56. * @Author Gorden
  57. * @Date 2024/2/21 14:52
  58. *
  59. * @param $id
  60. * @return \support\Response
  61. */
  62. public static function userInfo($id)
  63. {
  64. $user = SysUser::select('join_user_role_id', 'join_user_dept_id', 'user_status', 'user_category', 'user_name', 'user_login_name', 'user_mobile', 'user_remark', 'user_extend_json', 'user_addtimes')
  65. ->where('user_id', $id)
  66. ->first();
  67. if (!$user) {
  68. return json_fail('用户不存在');
  69. }
  70. $user = $user->toArray();
  71. $member = Member::with([
  72. 'cert'=>function($query){
  73. $query->select('join_cert_member_id','member_cert_name');
  74. }
  75. ])->whereJsonContains('member_json->user->user_id',$id)
  76. ->first();
  77. $memberTitle = $member->cert ? $member->cert->member_cert_name.'-'.$member->member_mobile : $member->member_mobile;
  78. $user['member_id'] = $member['member_id'];
  79. $user['memberList'] = [
  80. [
  81. 'key'=>$member->member_id,
  82. 'value'=>$memberTitle
  83. ]
  84. ];
  85. $user['permission'] = [];
  86. if(!empty($member->member_json)){
  87. $memberJson = json_decode($member->member_json,true);
  88. if(isset($memberJson['user']) && isset($memberJson['user']['permission'])){
  89. $user['permission'] = $memberJson['user']['permission'];
  90. }
  91. }
  92. return json_success('', $user);
  93. }
  94. /**
  95. * @Desc 添加用户
  96. * @Author Gorden
  97. * @Date 2024/2/21 13:50
  98. *
  99. * @param $params
  100. * @return \support\Response
  101. */
  102. public static function insertUser($params)
  103. {
  104. try {
  105. $data = [
  106. 'user_id' => self::generateUserId(),
  107. 'join_user_role_id' => $params['join_user_role_id'] ?? 0,
  108. 'join_user_dept_id' => $params['join_user_dept_id'] ?? 0,
  109. 'user_status' => $params['user_status'] ?? '',
  110. 'user_category' => $params['user_category'] ?? '',
  111. 'user_name' => $params['user_name'] ?? '',
  112. 'user_login_name' => $params['user_login_name'] ?? '',
  113. 'user_login_pass' => md5(sha1($params['user_login_pass'])),
  114. 'user_mobile' => $params['user_mobile'] ?? '',
  115. 'user_remark' => $params['user_remark'] ?? '',
  116. // 'user_extend_json' => !empty($params['user_extend_json']) ? $params['user_extend_json'] : '{}',
  117. 'user_addtimes' => time()
  118. ];
  119. $extendJson['avatar'] = str_replace(getenv('STORAGE_DOMAIN'),'',$params['avatar']);
  120. $extendJson['info'] = $params['info'];
  121. $data['user_extend_json'] = json_encode($extendJson);
  122. if (!SysUser::insert($data)) {
  123. throw new \Exception('添加用户失败');
  124. }
  125. } catch (\Exception $e) {
  126. dump($e->getMessage());
  127. return json_fail('添加用户失败');
  128. }
  129. return json_success('添加用户成功');
  130. }
  131. /**
  132. * @Desc 修改用户
  133. * @Author Gorden
  134. * @Date 2024/2/21 14:06
  135. *
  136. * @param $id
  137. * @param $params
  138. * @return \support\Response
  139. */
  140. public static function updateUser($id, $params)
  141. {
  142. try {
  143. $data = [
  144. 'join_user_role_id' => $params['join_user_role_id'],
  145. 'join_user_dept_id' => $params['join_user_dept_id'],
  146. 'user_login_name' => $params['user_login_name'],
  147. 'user_status' => $params['user_status'],
  148. 'user_category' => $params['user_category'],
  149. 'user_name' => $params['user_name'],
  150. 'user_remark' => $params['user_remark'],
  151. // 'user_extend_json' => !empty($params['user_extend_json']) ? $params['user_extend_json'] : '{}'
  152. ];
  153. $user = SysUser::where('user_id', $id)->first();
  154. if(!empty($user->user_extend_json)){
  155. $extendJson = json_decode($user->user_extend_json,true);
  156. }else{
  157. $extendJson = [];
  158. }
  159. $extendJson['avatar'] = str_replace(getenv('STORAGE_DOMAIN'),'',$params['avatar']);
  160. $extendJson['info'] = $params['info'];
  161. $data['user_extend_json'] = json_encode($extendJson);
  162. // 密码变动
  163. if (!empty($params['user_login_pass'])) {
  164. $data['user_login_pass'] = md5(sha1($params['user_login_pass']));
  165. }
  166. SysUser::where('user_id', $id)->update($data);
  167. } catch (\Exception $e) {
  168. dump($e->getMessage());
  169. return json_fail('修改用户失败');
  170. }
  171. return json_success('修改用户成功');
  172. }
  173. /**
  174. * @Desc 修改用户状态
  175. * @Author Gorden
  176. * @Date 2024/2/21 15:03
  177. *
  178. * @param $id
  179. * @param $params
  180. * @return \support\Response
  181. */
  182. public static function updateStatus($id, $params)
  183. {
  184. try {
  185. if (!SysUser::where('user_id', $id)->update(['user_status' => $params['user_status']])) {
  186. throw new \Exception('用户状态修改失败');
  187. }
  188. } catch (\Exception $e) {
  189. return json_fail('用户状态修改失败');
  190. }
  191. return json_success('用户状态修改成功');
  192. }
  193. /**
  194. * @Desc 修改密码
  195. * @Author Gorden
  196. * @Date 2024/4/19 10:01
  197. *
  198. * @param $id
  199. * @param $params
  200. * @return \support\Response
  201. */
  202. public static function updatePassword($id, $params)
  203. {
  204. if ($params['user_login_pass'] != $params['confirmNewPassword']) {
  205. return json_fail('两次密码不一致');
  206. }
  207. $user = SysUser::where('user_id', $id)->first();
  208. if (md5(sha1($params['userPassword'])) != $user->user_login_pass) {
  209. return json_fail('原密码错误');
  210. }
  211. try {
  212. SysUser::where('user_id', $id)->update(['user_login_pass' => md5(sha1($params['user_login_pass']))]);
  213. return json_success('密码修改成功');
  214. } catch (\Exception $e) {
  215. dump($e->getMessage());
  216. return json_fail('密码修改失败');
  217. }
  218. }
  219. /**
  220. * @Desc 删除用户
  221. * @Author Gorden
  222. * @Date 2024/2/21 15:11
  223. *
  224. * @param $id
  225. * @return \support\Response
  226. */
  227. public static function delUser(Request $request)
  228. {
  229. $ids = $request->post('user_id');
  230. if (!$ids) {
  231. return json_fail("数据错误");
  232. }
  233. try {
  234. if (is_array($ids)) {
  235. SysUser::whereIn('user_id', $ids)->delete();
  236. } else {
  237. SysUser::where('user_id', $ids)->delete();
  238. }
  239. } catch (\Exception $e) {
  240. return json_fail('删除用户失败');
  241. }
  242. return json_success('删除用户成功');
  243. }
  244. public static function checkUserExist($account)
  245. {
  246. return SysUser::where('user_login_name', $account)->exists();
  247. }
  248. public static function generateUserId()
  249. {
  250. $random = random_string(8,'up');
  251. return 'UR' . date('YmdHis') . $random;
  252. }
  253. }