UserService.php 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818
  1. <?php
  2. namespace App\JsonRpc;
  3. use App\Model\ImContact;
  4. use App\Model\Role;
  5. use App\Model\RoleLog;
  6. use App\Model\RoleUser;
  7. use App\Model\User;
  8. use App\Model\UserInfo;
  9. use App\Model\UserLogin;
  10. use App\Model\WebsiteGroup;
  11. use App\Model\Wechat;
  12. use App\Model\UserImp;
  13. use App\Tools\Result;
  14. use Hamcrest\Arrays\IsArray;
  15. use Hyperf\DbConnection\Db;
  16. use Hyperf\RpcServer\Annotation\RpcService;
  17. use App\Model\ImGroupMember;
  18. #[RpcService(name: "UserService", protocol: "jsonrpc-http", server: "jsonrpc-http")]
  19. class UserService implements UserServiceInterface
  20. {
  21. /**
  22. * @param string $name
  23. * @param int $gender
  24. * @return string
  25. */
  26. public function createUser(array $data): array
  27. {
  28. //同步imp的用戶信息
  29. if (isset($data['type']) && $data['type'] == 'imp') {
  30. //獲取user的id,user_name,avatar,nickname,組成數據,批量插入imp users中,如果已經存在則替換,密碼用111111加密,加密算法是bcrypt
  31. // 获取所有用户数据
  32. $users = User::query()->select('id', 'user_name', 'avatar', 'nickname', 'email')->get()->toArray();
  33. if (!empty($users)) {
  34. $insertData = [];
  35. $now = date('Y-m-d H:i:s');
  36. // 准备插入数据
  37. foreach ($users as $user) {
  38. $insertData[] = [
  39. 'id' => $user['id'],
  40. 'mobile' => $user['user_name'], // user_name映射到mobile
  41. 'nickname' => $user['nickname'] ?? $user['user_name'], // 如果nickname为空则使用user_name
  42. 'avatar' => $user['avatar'] ?? '',
  43. 'password' => password_hash('111111', PASSWORD_BCRYPT), // 使用bcrypt加密密码
  44. 'gender' => 3, // 默认未知性别
  45. 'motto' => '',
  46. 'email' => $user['email'] ?? '',
  47. 'birthday' => '',
  48. 'is_robot' => 2, // 非机器人
  49. 'status' => 1, // 正常状态
  50. 'created_at' => $now,
  51. 'updated_at' => $now,
  52. ];
  53. }
  54. // 批量插入或替换
  55. try {
  56. // 使用replace into语法,如果主键存在则替换
  57. $sql = "REPLACE INTO users (id, mobile, nickname, avatar, password, gender, motto, email, birthday, is_robot, status, created_at, updated_at) VALUES ";
  58. $values = [];
  59. foreach ($insertData as $row) {
  60. $values[] = "('" . implode("', '", array_map(fn($v) => addslashes($v), $row)) . "')";
  61. }
  62. $sql .= implode(', ', $values);
  63. // 使用imp数据库连接执行SQL
  64. Db::connection('imp')->statement($sql);
  65. } catch (\Throwable $e) {
  66. // 记录错误但不中断主流程
  67. var_dump('同步imp用户失败: ' . $e->getMessage());
  68. }
  69. return Result::success(['同步imp用户成功']);
  70. }
  71. }
  72. Db::beginTransaction();
  73. try {
  74. $dataUserReq = [
  75. 'user_name' => $data['user_name'],
  76. 'password' => md5(md5($data['password']) . $data['salt']),
  77. 'avatar' => $data['avatar'] ?? 'https://img.bjzxtw.org.cn/master/image/userDefault.jpg',
  78. 'type_id' => $data['type_id'] ?? '20000',
  79. 'mobile' => $data['mobile'] ?? '', //手机号
  80. 'status' => $data['status'] ?? 1,
  81. 'email' => $data['email'] ?? '',
  82. 'salt' => $data['salt'],
  83. 'admin_id' => isset($data['admin_id']) && $data['admin_id'] != '' ? $data['admin_id'] : 0,
  84. // 'level_id'=>$data['level_id']??0, //会员等级
  85. 'nickname' => $data['nickname'] ?? $data['user_name'], //把账号同步到昵称里面
  86. 'last_login_ip' => $data['last_login_ip'] ?? '',
  87. 'sszq' => $data['sszq'] ?? '',
  88. ];
  89. $data['other'] = is_array($data['other']) ? json_encode($data['other'] ?? []) : $data['other'];
  90. $data['city_arr_id'] = is_array($data['city_arr_id']) ? json_encode($data['city_arr_id'] ?? []) : $data['city_arr_id'];
  91. $data['address_arr_id'] = is_array($data['address_arr_id']) ? json_encode($data['address_arr_id'] ?? []) : $data['address_arr_id'];
  92. var_dump("user:", $dataUserReq);
  93. $userid = User::query()->insertGetId($dataUserReq);
  94. if (!$userid) {
  95. Db::rollBack();
  96. return Result::error('创建用户失败');
  97. }
  98. // $data['administrative_unit_arr_id'] = is_array($data['administrative_unit_arr_id']) ? json_encode($data['administrative_unit_arr_id'] ?? []): $data['administrative_unit_arr_id'];
  99. $dataUserInfoReq = [
  100. 'user_id' => $userid,
  101. 'id_card' => $data['id_card'] ?? '',
  102. 'gender' => $data['gender'] ?? 0,
  103. 'real_name' => $data['real_name'] ?? '',
  104. 'business_name' => $data['business_name'] ?? '',
  105. 'job' => $data['job'] ?? '',
  106. 'city_id' => $data['city_id'] ?? 0,
  107. 'birthday' => $data['birthday'] ?? '',
  108. 'number' => $data['number'] ?? '',
  109. 'city_arr_id' => $data['city_arr_id'] ?? '',
  110. 'from_time' => $data['from_time'] ?? null,
  111. 'to_time' => $data['to_time'] ?? null,
  112. 'long_time' => $data['long_time'] ?? 0,
  113. 'native_place_id' => $data['native_place_id'] ?? 0,
  114. 'native_place_arr_id' => $data['native_place_arr_id'] ?? '',
  115. 'qq' => $data['qq'] ?? '',
  116. 'zip_code' => $data['zip_code'] ?? '',
  117. 'address_arr_id' => $data['address_arr_id'] ?? '',
  118. 'address_id' => $data['address_id'] ?? 0,
  119. 'address' => $data['address'] ?? '',
  120. 'other' => $data['other'] ?? '',
  121. 'remark' => $data['remark'] ?? '',
  122. 'fax' => $data['fax'] ?? '',
  123. 'position' => $data['position'] ?? '',
  124. 'legal_person_real_name' => $data['legal_person_real_name'] ?? '',
  125. 'legal_person_mobile' => $data['legal_person_mobile'] ?? '',
  126. 'legal_person_id_card' => $data['legal_person_id_card'] ?? '',
  127. 'administrative_unit_arr_id' => $data['administrative_unit_arr_id'] ?? '',
  128. 'administrative_unit_id' => $data['administrative_unit_id'] ?? 0,
  129. 'department_id' => $data['department_id'] ?? 0,
  130. 'department_arr_id' => $data['department_arr_id'] ?? '',
  131. // 企业会员 相关 公司信息
  132. 'company_hy_id' => $data['company_hy_id'] ?? 0,
  133. 'company_size' => $data['company_size'] ?? 0,
  134. 'company_nature' => $data['company_nature'] ?? 0,
  135. 'introduction' => $data['introduction'] ?? '',
  136. 'company_url' => $data['company_url'] ?? '',
  137. ];
  138. // return Result::success($dataUserInfoReq);
  139. $userInfoId = UserInfo::query()->insertGetId($dataUserInfoReq);
  140. if (!$userInfoId) {
  141. Db::rollBack();
  142. return Result::error('创建用户信息失败');
  143. }
  144. $roleUserData = [
  145. 'role_id' => isset($data['role_id']) && $data['role_id'] != '' ? $data['role_id'] : 0,
  146. 'user_id' => $userid,
  147. 'admin_user_id' => isset($data['admin_id']) && $data['admin_id'] != '' ? $data['admin_id'] : 0,
  148. ];
  149. // return Result::success($roleUserData);
  150. $roleUserId = RoleUser::query()->insertGetId($roleUserData);
  151. if (!$roleUserId) {
  152. Db::rollBack();
  153. return Result::error('创建用户角色失败');
  154. }
  155. // var_dump("userInfo:", $userInfoId);
  156. //处理imp
  157. $impUserData = [
  158. 'id' => $userid, // 将在后面获取
  159. 'mobile' => $data['user_name'],
  160. 'nickname' => $data['nickname'] ?? $data['user_name'],
  161. 'avatar' => $data['avatar'] ?? 'https://img.bjzxtw.org.cn/master/image/userDefault.jpg',
  162. 'gender' => $data['gender'] ?? 3,
  163. 'password' => password_hash('111111', PASSWORD_BCRYPT),
  164. 'motto' => '',
  165. 'email' => $data['email'] ?? '',
  166. 'birthday' => $data['birthday'] ?? '',
  167. 'is_robot' => 2,
  168. 'status' => isset($data['status']) && $data['status'] === 0 ? 2 : ($data['status'] ?? 1), // 当status为0时设置为2,其他情况保持正常
  169. 'created_at' => date('Y-m-d H:i:s'),
  170. 'updated_at' => date('Y-m-d H:i:s')
  171. ];
  172. // return Result::success($impUserData);
  173. // 使用 REPLACE INTO 实现存在则替换的逻辑
  174. $impUserId = Db::connection('imp')->table('users')->updateOrInsert(
  175. ['mobile' => $data['user_name']],
  176. $impUserData
  177. );
  178. if (!$impUserId) {
  179. Db::rollBack();
  180. return Result::error('创建imp用户失败');
  181. }
  182. Db::commit();
  183. return Result::success(["id" => $userid]);
  184. } catch (\Throwable $ex) {
  185. Db::rollBack();
  186. // var_dump($ex->getMessage());
  187. return Result::error($ex->getMessage(), 0);
  188. }
  189. }
  190. /**
  191. * @return array
  192. */
  193. public function getUserList(array $data): array
  194. {
  195. $where = [];
  196. if (isset($data['keyword']) && $data['keyword']) {
  197. array_push($where, ['user.user_name', 'like', '%' . $data['keyword'] . '%']);
  198. }
  199. if (isset($data['type_id']) && $data['type_id']) {
  200. array_push($where, ['user.type_id', '=', $data['type_id']]);
  201. }
  202. if (isset($data['status']) && $data['status'] != '' && intval($data['status']) >= 0) {
  203. array_push($where, ['user.status', '=', $data['status']]);
  204. }
  205. $result = User::where($where)
  206. ->leftJoin('user_info', 'user.id', '=', 'user_info.user_id')
  207. ->leftJoin("user_info as user_infoA", 'user.admin_id', "user_infoA.user_id")
  208. ->leftJoin("role_user", 'role_user.user_id', "user.id")
  209. ->leftJoin("role", 'role.id', "role_user.role_id")
  210. ->orderBy("user.id", "desc")->paginate(
  211. intval($data['pageSize']),
  212. [
  213. 'user.id',
  214. 'user.admin_id',
  215. 'user.user_name',
  216. 'user_info.real_name',
  217. 'user.mobile',
  218. 'user.type_id',
  219. 'user.created_at',
  220. 'user.status',
  221. 'user_infoA.real_name as admin_real_name',
  222. 'role.role_name',
  223. ],
  224. 'page',
  225. intval($data['page'])
  226. );
  227. $count = $result->total();
  228. if (empty($result)) {
  229. return Result::error("没有数据", 0);
  230. }
  231. $rep = $result->items();
  232. //1:个人会员 2:政务会员 3:企业会员 4:调研员 10000:管理员 20000:游客
  233. $type = ['1' => "个人会员", '2' => "政务会员", '3' => "企业会员", '4' => '调研员', '10000' => '管理员', '20000' => '游客'];
  234. if ($rep) {
  235. foreach ($rep as $k => $v) {
  236. $rep[$k]['type_name'] = $type[$v['type_id']];
  237. // $rep[$k]['gender_name'] = $gender[$v['gender']];
  238. // $rep[$k]['status_name'] = $status[$v['status']];
  239. // $rep[$k]['city_id'] = $v['city_id']?json_decode($v['city_id']):[];
  240. }
  241. }
  242. $data = [
  243. 'rows' => $rep,
  244. 'count' => $count,
  245. ];
  246. return Result::success($data);
  247. }
  248. /**
  249. * @param int $id
  250. * @return array
  251. */
  252. public function getUserInfo(int $id): array
  253. {
  254. $userInfo = Db::table('user')
  255. ->leftJoin('user_info', 'user.id', '=', 'user_info.user_id')
  256. ->leftJoin('role_user', 'role_user.user_id', '=', 'user.id')
  257. ->select(
  258. 'user.*',
  259. 'user_info.id as user_info_id',
  260. 'user_info.real_name',
  261. 'user_info.id_card',
  262. 'user_info.birthday',
  263. 'user_info.gender',
  264. 'user_info.city_id',
  265. 'user_info.business_name',
  266. 'user_info.job',
  267. 'user_info.number',
  268. 'user_info.city_arr_id',
  269. 'user_info.from_time',
  270. 'user_info.to_time',
  271. 'user_info.long_time',
  272. 'user_info.native_place_id',
  273. 'user_info.native_place_arr_id',
  274. 'user_info.qq',
  275. 'user_info.zip_code',
  276. 'user_info.address_arr_id',
  277. 'user_info.address_id',
  278. 'user_info.address',
  279. 'user_info.other',
  280. 'user_info.remark',
  281. 'user_info.fax',
  282. 'user_info.position',
  283. 'user_info.legal_person_real_name',
  284. 'user_info.legal_person_mobile',
  285. 'user_info.legal_person_id_card',
  286. 'user_info.administrative_unit_arr_id',
  287. 'user_info.administrative_unit_id',
  288. // 企业会员 相关 公司信息
  289. 'user_info.company_hy_id',
  290. 'user_info.company_size',
  291. 'user_info.company_nature',
  292. 'user_info.introduction',
  293. 'user_info.company_url',
  294. 'role_user.role_id',
  295. 'user_info.department_id',
  296. 'user_info.department_arr_id',
  297. )
  298. ->where('user.id', '=', $id)->first();
  299. $userInfoImp = UserImp::where(['id' => $id])->first();
  300. // $impUsers = Db::connection('imp')->select('SHOW TABLES');
  301. // var_dump($impUsers);
  302. if (empty($userInfo)) {
  303. return Result::error("找不到用户", 0, []);
  304. }
  305. // $userInfo = array_merge($userInfo, $impUsers);
  306. return Result::success($userInfo);
  307. }
  308. /**
  309. * 检测用户是否存在
  310. * @param array $data
  311. * @return array
  312. */
  313. public function verifyUserInfo(array $data): array
  314. {
  315. var_dump("进不进来");
  316. if (isset($data['id'])) {
  317. $data[] = ['id', "!=", $data['id']];
  318. unset($data['id']);
  319. }
  320. $userInfo = User::query()->where($data)->first();
  321. if (empty($userInfo)) {
  322. return Result::error("找不到用户", 0);
  323. }
  324. return Result::success($userInfo->toArray());
  325. }
  326. /**
  327. * @param array $data
  328. * @return array
  329. */
  330. public function createUserLogin(array $data): array
  331. {
  332. $id = UserLogin::insertGetId($data);
  333. if (empty($id)) {
  334. return Result::error("创建登录日志失败", 0);
  335. }
  336. return Result::success(["id" => $id]);
  337. }
  338. /**
  339. * 更新用户信息和userInfo
  340. * @param array $data
  341. * @return array
  342. */
  343. public function updateUser(array $data): array
  344. {
  345. var_dump($data, "----------------------");
  346. Db::beginTransaction();
  347. try {
  348. $userInfos = User::where(['id' => $data['id']])->first(); //查询用户昵称
  349. $dataUserReq = [
  350. 'user_name' => $data['user_name'],
  351. 'avatar' => $data['avatar'] ?? '',
  352. 'type_id' => $data['type_id'] ?? '20000',
  353. 'mobile' => $data['mobile'] ?? '', //手机号
  354. 'status' => $data['status'] ?? 1,
  355. 'email' => $data['email'] ?? '',
  356. 'admin_id' => $data['admin_id'],
  357. 'nickname' => $userInfos['nickname'] ?? $data['user_name'], //存在昵称同步一下,不存在取账号
  358. 'last_login_ip' => $data['last_login_ip'] ?? '',
  359. 'sszq' => $data['sszq'] ?? '', //网站标识
  360. ];
  361. $userRep = User::where(['id' => $data['id']])->update($dataUserReq);
  362. //插入 imp users
  363. $dataImpUserReq = [
  364. 'mobile' => $data['user_name'],
  365. ];
  366. // 只有在数据存在时才设置字段,避免设置空值
  367. if (!empty($data['nickname'])) {
  368. $dataImpUserReq['nickname'] = $data['nickname'];
  369. }
  370. if (!empty($data['avatar'])) {
  371. $dataImpUserReq['avatar'] = $data['avatar'];
  372. }
  373. if (!empty($data['email'])) {
  374. $dataImpUserReq['email'] = $data['email'];
  375. }
  376. UserImp::where(['id' => $data['id']])->update($dataImpUserReq);
  377. $data['other'] = is_array($data['other']) ? json_encode($data['other'] ?? []) : $data['other'];
  378. $data['city_arr_id'] = is_array($data['city_arr_id']) ? json_encode($data['city_arr_id'] ?? []) : $data['city_arr_id'];
  379. $data['address_arr_id'] = is_array($data['address_arr_id']) ? json_encode($data['address_arr_id'] ?? []) : $data['address_arr_id'];
  380. var_dump("修改user:", $userRep);
  381. $dataUserInfoReq = [
  382. 'id_card' => $data['id_card'] ?? '',
  383. 'gender' => $data['gender'] ?? 0,
  384. 'real_name' => $data['real_name'] ?? '',
  385. 'job' => $data['job'] ?? '',
  386. 'city_id' => $data['city_id'] ?? 0,
  387. 'birthday' => $data['birthday'] ?? '',
  388. 'number' => $data['number'] ?? '',
  389. 'city_arr_id' => $data['city_arr_id'] ?? '',
  390. 'from_time' => $data['from_time'] ?? null,
  391. 'business_name' => $data['business_name'] ?? '',
  392. 'to_time' => $data['to_time'] ?? null,
  393. 'long_time' => $data['long_time'] ?? 0,
  394. 'native_place_id' => $data['native_place_id'] ?? 0,
  395. 'native_place_arr_id' => $data['native_place_arr_id'] ?? '',
  396. 'qq' => $data['qq'] ?? '',
  397. 'zip_code' => $data['zip_code'] ?? '',
  398. 'address_arr_id' => $data['address_arr_id'] ?? '',
  399. 'address_id' => $data['address_id'] ?? 0,
  400. 'address' => $data['address'] ?? '',
  401. 'other' => $data['other'] ?? '',
  402. 'remark' => $data['remark'] ?? '',
  403. 'fax' => $data['fax'] ?? '',
  404. 'position' => $data['position'] ?? '',
  405. 'legal_person_real_name' => $data['legal_person_real_name'] ?? '',
  406. 'legal_person_mobile' => $data['legal_person_mobile'] ?? '',
  407. 'legal_person_id_card' => $data['legal_person_id_card'] ?? '',
  408. 'administrative_unit_arr_id' => $data['administrative_unit_arr_id'] ?? '',
  409. 'administrative_unit_id' => $data['administrative_unit_id'] ?? 0,
  410. 'department_id' => $data['department_id'] ?? 0,
  411. 'department_arr_id' => $data['department_arr_id'] ?? '',
  412. // 企业会员 相关 公司信息
  413. 'company_hy_id' => $data['company_hy_id'] ?? 0,
  414. 'company_size' => $data['company_size'] ?? 0,
  415. 'company_nature' => $data['company_nature'] ?? 0,
  416. 'introduction' => $data['introduction'] ?? '',
  417. 'company_url' => $data['company_url'] ?? '',
  418. ];
  419. $userInfoRep = UserInfo::where(['user_id' => $data['id']])->update($dataUserInfoReq);
  420. var_dump("修改userInfo:", $userInfoRep);
  421. $roleUserData = [
  422. 'role_id' => $data['role_id'],
  423. 'admin_user_id' => $data['admin_id'],
  424. ];
  425. $resultRoleUserRep = RoleUser::where(['user_id' => $data['id']])->update($roleUserData);
  426. var_dump("修改用户角色权限:", $resultRoleUserRep);
  427. //处理imp
  428. Db::commit();
  429. } catch (\Throwable $ex) {
  430. Db::rollBack();
  431. var_dump($ex->getMessage());
  432. return Result::error("修改失败", 0);
  433. }
  434. $result = [
  435. 'user' => $userRep,
  436. 'userInfo' => $userInfoRep,
  437. ];
  438. return $result ? Result::success($result) : Result::error("修改失败", 0);
  439. }
  440. /**
  441. * @param array $data
  442. * @return array
  443. */
  444. public function updateUserInfo(array $data): array
  445. {
  446. return [];
  447. }
  448. /**
  449. * @param array $data
  450. * @return array|int
  451. */
  452. public function resetPassword(array $data): array
  453. {
  454. $where = [
  455. 'id' => $data['id'],
  456. ];
  457. $data = [
  458. 'password' => md5(md5($data['password']) . $data['salt']),
  459. 'salt' => $data['salt'],
  460. ];
  461. $result = User::where($where)->update($data);
  462. if ($result) {
  463. return Result::error("修改失败", 0);
  464. } else {
  465. return Result::success([]);
  466. }
  467. }
  468. /**
  469. * @param int $id
  470. * @return array
  471. */
  472. public function delUser(int $id): array
  473. {
  474. Db::beginTransaction();
  475. try {
  476. // User::where(['id' => $id])->delete();
  477. // UserInfo::where(['user_id' => $id])->delete();
  478. Db::commit();
  479. } catch (\Throwable $ex) {
  480. Db::rollBack();
  481. return Result::error("删除失败", 0);
  482. }
  483. return Result::success([]);
  484. }
  485. /**
  486. * @param array $data
  487. * @return array
  488. */
  489. public function addRole(array $data): array
  490. {
  491. Db::beginTransaction();
  492. try {
  493. $data['sort'] = intval($data['sort']) ?? 0;
  494. Role::insertGetId($data);
  495. $logData = [
  496. 'user_id' => $data['user_id'],
  497. 'data' => json_encode($data),
  498. 'type' => 1,
  499. ];
  500. RoleLog::insertGetId($logData);
  501. Db::commit();
  502. } catch (\Throwable $ex) {
  503. Db::rollBack();
  504. return Result::error("新增失败", 0);
  505. }
  506. return Result::success([]);
  507. }
  508. /**
  509. * @param array $data
  510. * @return array
  511. */
  512. public function delRole(array $data): array
  513. {
  514. Db::beginTransaction();
  515. try {
  516. $count = RoleUser::where(['role_id' => $data['id']])->count();
  517. if($count>0){
  518. Db::rollBack();
  519. return Result::error("请先删除该角色下的用户", 0);
  520. }
  521. $roleInfo = Role::where(['id' => $data['id']])->first();
  522. $logData = [
  523. 'user_id' => $data['user_id'],
  524. 'data' => json_encode($roleInfo->toArray()),
  525. 'type' => 2,
  526. ];
  527. RoleLog::insertGetId($logData);
  528. RoleUser::where(['role_id' => $data['id']])->delete();
  529. $result = Role::where(['id' => $data['id']])->delete();
  530. Db::commit();
  531. } catch (\Throwable $ex) {
  532. Db::rollBack();
  533. return Result::error("删除失败", 0);
  534. }
  535. return Result::success($result);
  536. }
  537. /**
  538. * @param array $data
  539. * @return array
  540. */
  541. public function updateRole(array $data): array
  542. {
  543. Db::beginTransaction();
  544. try {
  545. $result = Role::where(['id' => $data['id']])->update($data);
  546. $logData = [
  547. 'user_id' => $data['user_id'],
  548. 'data' => json_encode($data),
  549. 'type' => 3,
  550. ];
  551. RoleLog::insertGetId($logData);
  552. Db::commit();
  553. } catch (\Throwable $ex) {
  554. Db::rollBack();
  555. return Result::error("更新失败");
  556. }
  557. return Result::success($result);
  558. }
  559. /**
  560. * @param array $data
  561. * @return array
  562. */
  563. public function roleInfo(array $data): array
  564. {
  565. $roleInfo = Role::where(['id' => $data['id']])->first();
  566. if ($roleInfo) {
  567. return Result::success($roleInfo->toArray());
  568. } else {
  569. return Result::error("没有数据");
  570. }
  571. }
  572. /**
  573. * @param array $data
  574. * @return array
  575. */
  576. public function roleList(array $data): array
  577. {
  578. $where = [];
  579. if (isset($data['keyword']) && $data['keyword']) {
  580. array_push($where, ['role.role_name', 'like', '%' . $data['keyword'] . '%']);
  581. }
  582. $result = Role::withCount('users')->where($where)->limit($data['pageSize'])->offset(($data['page'] - 1) * $data['pageSize'])->get();
  583. $count = Role::where($where)->count();
  584. if (empty($result)) {
  585. return Result::error("没有数据", 0);
  586. }
  587. $data = [
  588. 'rows' => $result->toArray(),
  589. 'count' => $count,
  590. ];
  591. return Result::success($data);
  592. }
  593. /**
  594. * 获取小程序注册信息
  595. * @param array $data
  596. * @return array
  597. */
  598. public function getWechatInfo(array $data): array
  599. {
  600. $where = [
  601. 'purePhoneNumber' => $data['purePhoneNumber'],
  602. 'openid' => $data['openid'],
  603. ];
  604. $result = Wechat::where($where)->first();
  605. var_dump($result);
  606. if ($result) {
  607. return Result::success($result);
  608. } else {
  609. return Result::error('没有数据');
  610. }
  611. }
  612. /**
  613. * 添加小程序 注册信息
  614. * @param array $data
  615. * @return array
  616. */
  617. public function addWechatInfo(array $data): array
  618. {
  619. $result = Wechat::insertGetId($data);
  620. if ($result) {
  621. return Result::success($result);
  622. } else {
  623. return Result::error('添加失败');
  624. }
  625. }
  626. /**
  627. * 修改密码
  628. * @param array $data
  629. * @return array
  630. */
  631. public function changePassword(array $data): array
  632. {
  633. Db::beginTransaction();
  634. $userInfo = User::where(['id' => $data['user_id']])->first();
  635. // return Result::success($userInfo);
  636. try {
  637. $dataUserReq = [
  638. 'password' => md5(md5($data['new_password1']) . $userInfo['salt']),
  639. ];
  640. if ($userInfo['password'] != md5(md5($data['password']) . $userInfo['salt'])) {
  641. Db::rollBack();
  642. return Result::error('您输入的密码错误');
  643. }
  644. $userRep = User::where(['id' => $data['user_id']])->update($dataUserReq);
  645. $dataImpUserReq = [
  646. password_hash($data['new_password1'], PASSWORD_BCRYPT), // 使用bcrypt加密密码
  647. ];
  648. UserImp::where(['id' => $data['id']])->update($dataImpUserReq);
  649. Db::commit();
  650. } catch (\Throwable $ex) {
  651. Db::rollBack();
  652. var_dump($ex->getMessage());
  653. return Result::error("创建失败", 0);
  654. }
  655. return Result::success([]);
  656. }
  657. /**
  658. * 修改用户状态
  659. * @param array $data
  660. * @return array
  661. */
  662. public function upUserStatus(array $data): array
  663. {
  664. $where = [
  665. 'id' => $data['id'],
  666. ];
  667. $result = User::where($where)->update($data);
  668. if ($result) {
  669. return Result::success($result);
  670. } else {
  671. return Result::error('修改失败');
  672. }
  673. }
  674. /**
  675. * 修改用户头像昵称
  676. * @param array $data
  677. * @return array
  678. */
  679. public function updateUserAvatarNickname(array $data): array
  680. {
  681. Db::beginTransaction();
  682. try {
  683. $where1 = [
  684. 'id' => $data['user_id'],
  685. ];
  686. $updateData = [];
  687. if (!empty($data['nickname'])) {
  688. $updateData['nickname'] = $data['nickname'];
  689. }
  690. if (!empty($data['avatar'])) {
  691. $updateData['avatar'] = $data['avatar'];
  692. }
  693. $result = User::where($where1)->update($updateData);
  694. //imp
  695. $dataImpUserReq = [
  696. 'nickname' => $data['nickname'], // 如果nickname为空则使用user_name
  697. 'avatar' => $data['avatar'] ?? '',
  698. ];
  699. if (empty($data['nickname'])) {
  700. unset($dataImpUserReq['nickname']);
  701. }
  702. if (empty($data['avatar'])) {
  703. unset($dataImpUserReq['avatar']);
  704. }
  705. UserImp::where(['id' => $data['user_id']])->update($dataImpUserReq);
  706. $updateData = [];
  707. $where = [
  708. 'user_id' => $data['user_id'],
  709. ];
  710. if (!empty($data['real_name'])) {
  711. $updateData = ['real_name' => $data['real_name']];
  712. }
  713. $result = UserInfo::where($where)->update($updateData);
  714. $result = User::where($where1)->first();
  715. Db::commit();
  716. return Result::success($result);
  717. } catch (\Throwable $ex) {
  718. Db::rollBack();
  719. var_dump($ex->getMessage());
  720. return Result::error("创建失败", 0);
  721. }
  722. }
  723. /**
  724. * 获取网站组信息
  725. * @param array $data
  726. * @return array
  727. */
  728. public function getWebsiteGroupInfo(array $data): array
  729. {
  730. $result = WebsiteGroup::where(['id' => $data['id']])->first();
  731. if ($result) {
  732. return Result::success($result);
  733. } else {
  734. return Result::error('查询失败');
  735. }
  736. }
  737. /**
  738. * 根据类型获取用户列表
  739. */
  740. public function getTypeUserList(array $data): array
  741. {
  742. $result = User::when($data, function ($query) use ($data) {
  743. if (isset($data['type_id']) && $data['type_id']) {
  744. $query->where('type_id', $data['type_id']);
  745. }
  746. })->where('status', 1)->get();
  747. if ($result) {
  748. return Result::success($result);
  749. } else {
  750. return Result::error('查询失败');
  751. }
  752. }
  753. /**
  754. * 获取群里面的用户,不包含子集
  755. */
  756. public function getImGroupMember(array $data): array
  757. {
  758. $result = ImGroupMember::leftjoin("im_group", "im_group.id", "=", "im_group_member.group_id")->when($data, function ($query) use ($data) {
  759. if (isset($data['user_id']) && $data['user_id']) {
  760. $query->where('im_group_member.user_id', '<>', $data['user_id']);
  761. }
  762. })
  763. ->where('im_group_member.group_id', $data['group_id'])
  764. ->select("im_group_member.*", "im_group.group_name")
  765. ->get();
  766. return Result::success($result??[]);
  767. }
  768. /**
  769. * @param array $data
  770. * @return array
  771. */
  772. public function getImContact(array $data): array
  773. {
  774. $result = ImContact::where($data)->first();
  775. return Result::success($result??[]);
  776. }
  777. }