Roles.php 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343
  1. <?php
  2. namespace App\Http\Controllers\Manager\Personnel;
  3. use App\Http\Controllers\Controller;
  4. use App\Http\Requests\Manager\Personnel\Roles as Request;
  5. use App\Models\Manager\Personnel\Roles as RolesModel;
  6. use App\Models\Manager\Personnel\Employee as EmployeeModel;
  7. use App\Models\Manager\Personnel\RolesAuthRule as RolesAuthRuleModel;
  8. use App\Models\Manager\Menu as MenuModel;
  9. /**
  10. * 人员信息管理-角色管理
  11. * @author 唐远望
  12. * @version 1.0
  13. * @date 2025-12-05
  14. */
  15. class Roles extends Controller
  16. {
  17. /**
  18. * 列表
  19. * @author 唐远望
  20. * @version 1.0
  21. * @date 2025-12-05
  22. *
  23. */
  24. public function list(Request $request, RolesModel $RolesModel, RolesAuthRuleModel $RolesAuthRuleModel)
  25. {
  26. $request->scene('list')->validate();
  27. $admin_company_id = request('admin_company_id', '0');
  28. $company_id = request('access_token.company_id', '0');
  29. $is_admin = request('access_token.is_admin', '0'); //是否管理员操作 0=是1=否
  30. // 查询条件
  31. $map = [];
  32. $limit = request('limit', config('page_num', 10));
  33. $status = request('status', '');
  34. $start_time = request('start_time', '');
  35. $end_time = request('end_time', '');
  36. $name = request('name', '');
  37. // 权限判断
  38. if ($is_admin != 1 && $company_id != 0) {
  39. $map[] = ['company_id', '=', $company_id];
  40. } else {
  41. $map[] = ['company_id', '=', $admin_company_id];
  42. }
  43. // 时间条件
  44. if ($start_time) $map[] = ['insert_time', '>=', strtotime($start_time)];
  45. if ($end_time) $map[] = ['insert_time', '<=', strtotime($end_time)];
  46. // 其他条件
  47. if (is_numeric($status)) $map[] = ['status', '=', $status];
  48. if ($name) $map[] = ['name', 'like', "%$name%"];
  49. // 查询数据
  50. $result = $RolesModel->query()
  51. ->where($map)
  52. ->orderByDesc('id')
  53. ->paginate($limit)->toArray();
  54. // 分配数据
  55. if (!$result) return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => []]);
  56. foreach ($result['data'] as $key => $value) {
  57. $menu_ids = $RolesAuthRuleModel->where('role_id', $value['id'])->get(['menu_id'])->toArray();
  58. $result['data'][$key]['menu_ids'] = !empty($menu_ids) ? array_column($menu_ids, 'menu_id') : [];
  59. }
  60. // 加载模板
  61. return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]);
  62. }
  63. /**
  64. * 所有角色
  65. * @author 唐远望
  66. * @version 1.0
  67. * @date 2025-12-08
  68. *
  69. */
  70. public function all(RolesModel $RolesModel)
  71. {
  72. $map = [];
  73. $admin_company_id = request('admin_company_id', '0');
  74. $company_id = request('access_token.company_id', '0');
  75. $is_admin = request('access_token.is_admin', '0'); //是否管理员操作 0=是1=否
  76. $status = request('status', '0');
  77. $start_time = request('start_time', '');
  78. $end_time = request('end_time', '');
  79. $name = request('name', '');
  80. // 权限判断
  81. if ($is_admin != 1 && $company_id != 0) {
  82. $map[] = ['company_id', '=', $company_id];
  83. } else {
  84. $map[] = ['company_id', '=', $admin_company_id];
  85. }
  86. // 时间条件
  87. if ($start_time) $map[] = ['insert_time', '>=', strtotime($start_time)];
  88. if ($end_time) $map[] = ['insert_time', '<=', strtotime($end_time)];
  89. // 其他条件
  90. if ($name) $map[] = ['name', 'like', "%$name%"];
  91. if (is_numeric($status)) $map[] = ['status', '=', $status];
  92. // 查询数据
  93. $result = $RolesModel->query()
  94. ->where($map)
  95. ->orderByDesc('id')
  96. ->get();
  97. // 分配数据
  98. if (!$result) return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => []]);
  99. // 加载模板
  100. return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]);
  101. }
  102. /**
  103. * 详情
  104. * @author 唐远望
  105. * @version 1.0
  106. * @date 2025-12-05
  107. */
  108. public function detail(Request $request, RolesModel $RolesModel, RolesAuthRuleModel $RolesAuthRuleModel, MenuModel $MenuModel)
  109. {
  110. $request->scene('detail')->validate();
  111. $admin_company_id = request('admin_company_id', '0');
  112. $company_id = request('access_token.company_id', '0');
  113. $is_admin = request('access_token.is_admin', '0'); //是否管理员操作 0=是1=否
  114. // 接收参数
  115. $id = request('id', 0);
  116. $map = ['id' => $id];
  117. // 权限判断
  118. if ($is_admin != 1 && $company_id != 0) {
  119. $map['company_id'] = $company_id;
  120. } else {
  121. $map['company_id'] = $admin_company_id;
  122. }
  123. $data = $RolesModel->where($map)->first();
  124. if (!$data) return json_send(['code' => 'error', 'msg' => '记录不存在']);
  125. $menu_ids = $RolesAuthRuleModel->where('role_id', $id)->get(['menu_id'])->toArray();
  126. $data->menu_ids = !empty($menu_ids) ? array_column($menu_ids, 'menu_id') : [];
  127. $menu_data = !empty($data->menu_ids) ? $MenuModel->query()->whereIn('id',$data->menu_ids)->select(['id', 'title', 'module', 'url', 'icon', 'type', 'pid'])->get()->toArray() : [];
  128. $menu_info = !empty($menu_data) ? array_sort(list_to_tree($menu_data), 'module', SORT_ASC) : [];
  129. $data->menu_info = $menu_info;
  130. // 加载模板
  131. return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $data]);
  132. }
  133. /**
  134. * 添加
  135. * @author 唐远望
  136. * @version 1.0
  137. * @date 2025-12-05
  138. *
  139. */
  140. public function add(Request $request, RolesModel $RolesModel)
  141. {
  142. $request->scene('add')->validate();
  143. $admin_company_id = request('admin_company_id', '0');
  144. $company_id = request('access_token.company_id', '0');
  145. $is_admin = request('access_token.is_admin', '0'); //是否管理员操作 0=是1=否
  146. // 接收数据
  147. $all_data = request()->all();
  148. $menu_ids = request('menu_ids', '');
  149. $store_scope = request('store_scope', '');
  150. $all_data['store_scope'] = $store_scope;
  151. $all_data['menu_ids'] = $menu_ids;
  152. //查询是否存在
  153. $map = ['name' => $all_data['name']];
  154. // 权限判断
  155. if ($is_admin != 1 && $company_id != 0) {
  156. $map['company_id'] = $company_id;
  157. $all_data['company_id'] = $company_id;
  158. } else {
  159. $map['company_id'] = $admin_company_id;
  160. $all_data['company_id'] = $admin_company_id;
  161. }
  162. $data = $RolesModel->where($map)->first();
  163. if ($data) return json_send(['code' => 'error', 'msg' => '记录已存在']);
  164. // 写入数据表
  165. $result = $RolesModel->addRoles($all_data);
  166. // 如果操作失败
  167. if (!$result) return json_send(['code' => 'error', 'msg' => '新增失败']);
  168. // 记录行为
  169. $admin_id = request('access_token.uid', 0); //用户ID
  170. $table_name = $RolesModel->getTable();
  171. $notes_type = 1; //操作类型,1添加,2修改,3=删除
  172. $this->addAdminHistory('人员信息管理-角色管理', $company_id, $admin_id, $is_admin, $table_name, $notes_type, [], $all_data, '新增了角色' . $all_data['name'] . '信息');
  173. // 告知结果
  174. return json_send(['code' => 'success', 'msg' => '新增成功']);
  175. }
  176. /**
  177. * 修改
  178. * @author 唐远望
  179. * @version 1.0
  180. * @date 2025-12-05
  181. *
  182. */
  183. public function edit(Request $request, RolesModel $RolesModel)
  184. {
  185. $request->scene('edit')->validate();
  186. $admin_company_id = request('admin_company_id', '0');
  187. $company_id = request('access_token.company_id', '0');
  188. $is_admin = request('access_token.is_admin', '0'); //是否管理员操作 0=是1=否
  189. // 接收参数
  190. $id = request('id', 0);
  191. $menu_ids = request('menu_ids', '');
  192. $all_data = request()->all();
  193. $store_scope = request('store_scope', '');
  194. $all_data['store_scope'] = $store_scope;
  195. $all_data['menu_ids'] = $menu_ids;
  196. //查询是否存在
  197. $map = ['name' => $all_data['name']];
  198. // 权限判断
  199. if ($is_admin != 1 && $company_id != 0) {
  200. $map['company_id'] = $company_id;
  201. $all_data['company_id'] = $company_id;
  202. } else {
  203. $map['company_id'] = $admin_company_id;
  204. $all_data['company_id'] = $admin_company_id;
  205. }
  206. $data = $RolesModel->where($map)->where('id', '!=', $id)->first();
  207. if ($data) return json_send(['code' => 'error', 'msg' => '记录已存在']);
  208. // 更新数据表
  209. $where = ['id' => $id];
  210. if ($is_admin != 1 && $company_id != 0) {
  211. $where['company_id'] = $company_id;
  212. } else {
  213. $where['company_id'] = $admin_company_id;
  214. }
  215. $Roles = $RolesModel->where($where)->first();
  216. if (!$Roles) return json_send(['code' => 'error', 'msg' => '记录不存在']);
  217. $oldData = $Roles->toArray();
  218. $result = $RolesModel->updateRoles($Roles, $all_data);
  219. // 如果操作失败
  220. if (!$result) return json_send(['code' => 'error', 'msg' => '修改失败']);
  221. // 记录行为
  222. $admin_id = request('access_token.uid', 0); //用户ID
  223. $table_name = $RolesModel->getTable();
  224. $notes_type = 2; //操作类型,1添加,2修改,3=删除
  225. $this->addAdminHistory('人员信息管理-角色管理', $company_id, $admin_id, $is_admin, $table_name, $notes_type, $oldData, $all_data, '修改了角色' . $oldData['name'] . '信息');
  226. // 告知结果
  227. return json_send(['code' => 'success', 'msg' => '修改成功']);
  228. }
  229. /**
  230. * 修改状态
  231. * @author 唐远望
  232. * @version 1.0
  233. * @date 2025-12-05
  234. *
  235. */
  236. public function set_status(Request $request, RolesModel $RolesModel, EmployeeModel $EmployeeModel)
  237. {
  238. // 验证参数
  239. $request->scene('set_status')->validate();
  240. $admin_company_id = request('admin_company_id', '0');
  241. $company_id = request('access_token.company_id', '0');
  242. $is_admin = request('access_token.is_admin', '0'); //是否管理员操作 0=是1=否
  243. // 接收数据
  244. $id = request('id', 0);
  245. $status = request('status', 0);
  246. if ($status == 1) {
  247. // 查询是否有员工使用该角色
  248. $employee_where = ['role_id' => $id];
  249. // 权限判断
  250. if ($is_admin != 1 && $company_id != 0) {
  251. $employee_where['company_id'] = $company_id;
  252. } else {
  253. $employee_where['company_id'] = $admin_company_id;
  254. }
  255. $employee_data = $EmployeeModel->where($employee_where)->first();
  256. if ($employee_data) return json_send(['code' => 'error', 'msg' => '该角色已被使用,不能禁用']);
  257. }
  258. // 查询用户
  259. $where = ['id' => $id];
  260. // 执行修改
  261. if ($is_admin != 1 && $company_id != 0) {
  262. $where['company_id'] = $company_id;
  263. } else {
  264. $where['company_id'] = $admin_company_id;
  265. }
  266. $Roles = $RolesModel->where($where)->first();
  267. if (!$Roles) {
  268. return json_send(['code' => 'error', 'msg' => '记录不存在']);
  269. }
  270. $Roles->status = $status;
  271. $Roles->update_time = time();
  272. $result = $Roles->save();
  273. // 提示新增失败
  274. if (!$result) return json_send(['code' => 'error', 'msg' => '设置失败']);
  275. // 记录行为
  276. $admin_id = request('access_token.uid', 0); //用户ID
  277. $table_name = $RolesModel->getTable();
  278. $notes_type = 2; //操作类型,1添加,2修改,3=删除
  279. $this->addAdminHistory('人员信息管理-角色管理', $company_id, $admin_id, $is_admin, $table_name, $notes_type, [], ['status' => $status], '修改了角色' . $Roles->name . '状态');
  280. // 告知结果
  281. return json_send(['code' => 'success', 'msg' => '设置成功']);
  282. }
  283. /**
  284. * 删除
  285. * @author 唐远望
  286. * @version 1.0
  287. * @date 2025-12-05
  288. *
  289. */
  290. public function delete(Request $request, RolesModel $RolesModel, EmployeeModel $EmployeeModel)
  291. {
  292. // 验证参数
  293. $request->scene('delete')->validate();
  294. $admin_company_id = request('admin_company_id', '0');
  295. $company_id = request('access_token.company_id', '0');
  296. $is_admin = request('access_token.is_admin', '0');
  297. // 接收数据
  298. $id = request('id', 0);
  299. // 查询用户
  300. $employee_where = ['role_id' => $id];
  301. if ($is_admin != 1 && $company_id != 0) {
  302. $employee_where['company_id'] = $company_id;
  303. } else {
  304. $employee_where['company_id'] = $admin_company_id;
  305. }
  306. // 查询是否有员工使用该角色
  307. $employee_data = $EmployeeModel->where($employee_where)->first();
  308. if ($employee_data) return json_send(['code' => 'error', 'msg' => '该角色已被使用,不能删除']);
  309. // 查询用户
  310. $where = ['id' => $id];
  311. if ($is_admin != 1 && $company_id != 0) {
  312. $where['company_id'] = $company_id;
  313. } else {
  314. $where['company_id'] = $admin_company_id;
  315. }
  316. // 执行删除
  317. $Roles = $RolesModel->where($where)->first();
  318. if (!$Roles) {
  319. return json_send(['code' => 'error', 'msg' => '记录不存在']);
  320. }
  321. $result = $Roles->delete();
  322. // 提示删除失败
  323. if (!$result) return json_send(['code' => 'error', 'msg' => '删除失败']);
  324. // 记录行为
  325. $admin_id = request('access_token.uid', 0); //用户ID
  326. $is_admin = request('access_token.is_admin'); //是否管理员操作 0=是1=否
  327. $table_name = $RolesModel->getTable();
  328. $notes_type = 3; //操作类型,1添加,2修改,3=删除
  329. $this->addAdminHistory('人员信息管理-角色管理', $company_id, $admin_id, $is_admin, $table_name, $notes_type, $Roles->toarray(), [], '删除了角色' . $Roles->name . '信息');
  330. // 告知结果
  331. return json_send(['code' => 'success', 'msg' => '删除成功']);
  332. }
  333. }