Employee.php 6.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185
  1. <?php
  2. namespace App\Http\Controllers\Manager\Personnel;
  3. use App\Http\Controllers\Controller;
  4. use App\Http\Requests\Manager\Personnel\Employee as Request;
  5. use App\Models\Manager\Personnel\Employee as EmployeeModel;
  6. /**
  7. * @author 唐远望
  8. * @version 1.0
  9. * @date 2025-12-04
  10. */
  11. class Employee extends Controller
  12. {
  13. /**
  14. * 列表
  15. * @author 唐远望
  16. * @version 1.0
  17. * @date 2025-12-04
  18. *
  19. */
  20. public function list(Request $request, EmployeeModel $EmployeeModel)
  21. {
  22. $request->scene('list')->validate();
  23. // 查询条件
  24. $map = [];
  25. $limit = request('limit', config('page_num', 10));
  26. $status = request('status', '');
  27. $start_time = request('start_time', '');
  28. $end_time = request('end_time', '');
  29. $name = request('name', '');
  30. $mobile = request('mobile', '');
  31. $department_id = request('department_id', '');
  32. $role_id = request('role_id', '');
  33. $open_notice = request('open_notice', '');
  34. $employee_code = request('employee_code', '');
  35. // 时间条件
  36. if ($start_time) $map[] = ['insert_time', '>=', strtotime($start_time)];
  37. if ($end_time) $map[] = ['insert_time', '<=', strtotime($end_time)];
  38. // 其他条件
  39. if ($status) $map[] = ['status', '=', $status];
  40. if ($name) $map[] = ['name', 'like', "%$name%"];
  41. if ($mobile) $map[] = ['mobile', 'like', "%$mobile%"];
  42. if ($department_id) $map[] = ['department_id', '=', $department_id];
  43. if ($role_id) $map[] = ['role_id', '=', $role_id];
  44. if ($open_notice) $map[] = ['open_notice', '=', $open_notice];
  45. if ($employee_code) $map[] = ['employee_code', 'like', "%$employee_code%"];
  46. $field = ['id','employee_code', 'name','mobile', 'department_id', 'role_id', 'city_ids', 'open_notice','insert_time','update_time','status'];
  47. // 查询数据
  48. $result = $EmployeeModel->query()
  49. ->where($map)
  50. ->select($field)
  51. ->orderByDesc('id')
  52. ->paginate($limit);
  53. // 分配数据
  54. if (!$result) return json_send(['code' => 'error', 'msg' => '暂无数据']);
  55. // 加载模板
  56. return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]);
  57. }
  58. /**
  59. * 详情
  60. * @author 唐远望
  61. * @version 1.0
  62. * @date 2025-12-04
  63. */
  64. public function detail(Request $request, EmployeeModel $EmployeeModel)
  65. {
  66. $request->scene('detail')->validate();
  67. // 接收参数
  68. $id = request('id', 0);
  69. $map = ['id' => $id];
  70. $field = ['id','employee_code', 'name','mobile', 'department_id', 'role_id', 'city_ids', 'open_notice','insert_time','update_time','status'];
  71. $data = $EmployeeModel->where($map)->select($field)->first();
  72. if (!$data) return json_send(['code' => 'error', 'msg' => '记录不存在']);
  73. // 加载模板
  74. return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $data]);
  75. }
  76. /**
  77. * 添加
  78. * @author 唐远望
  79. * @version 1.0
  80. * @date 2025-12-04
  81. *
  82. */
  83. public function add(Request $request, EmployeeModel $EmployeeModel)
  84. {
  85. $request->scene('add')->validate();
  86. // 接收数据
  87. $all_data = request()->all();
  88. //查询是否存在
  89. $map = ['name' => $all_data['name']];
  90. $data = $EmployeeModel->where($map)->first();
  91. if ($data) return json_send(['code' => 'error', 'msg' => '员工姓名记录已存在']);
  92. $map = ['mobile' => $all_data['mobile']];
  93. $data = $EmployeeModel->where($map)->first();
  94. if ($data) return json_send(['code' => 'error', 'msg' => '员工手机号记录已存在']);
  95. // 写入数据表
  96. $result = $EmployeeModel->addEmployee($all_data);
  97. // 如果操作失败
  98. if (!$result) return json_send(['code' => 'error', 'msg' => '新增失败']);
  99. // 告知结果
  100. return json_send(['code' => 'success', 'msg' => '新增成功']);
  101. }
  102. /**
  103. * 修改
  104. * @author 唐远望
  105. * @version 1.0
  106. * @date 2025-12-04
  107. *
  108. */
  109. public function edit(Request $request, EmployeeModel $EmployeeModel)
  110. {
  111. $request->scene('edit')->validate();
  112. // 接收参数
  113. $id = request('id', 0);
  114. // 接收数据
  115. $all_data = request()->all();
  116. //查询是否存在
  117. $map = ['name' => $all_data['name']];
  118. $data = $EmployeeModel->where($map)->where('id', '!=', $id)->first();
  119. if ($data) return json_send(['code' => 'error', 'msg' => '员工姓名记录已存在']);
  120. $map = ['mobile' => $all_data['mobile']];
  121. $data = $EmployeeModel->where($map)->where('id', '!=', $id)->first();
  122. if ($data) return json_send(['code' => 'error', 'msg' => '员工手机号记录已存在']);
  123. // 更新数据表
  124. $where = ['id' => $id];
  125. $result = $EmployeeModel->updateEmployee($where, $all_data);
  126. // 如果操作失败
  127. if (!$result) return json_send(['code' => 'error', 'msg' => '修改失败']);
  128. // 告知结果
  129. return json_send(['code' => 'success', 'msg' => '修改成功']);
  130. }
  131. /**
  132. * 修改状态
  133. * @author 唐远望
  134. * @version 1.0
  135. * @date 2025-12-04
  136. *
  137. */
  138. public function set_status(Request $request, EmployeeModel $EmployeeModel)
  139. {
  140. // 验证参数
  141. $request->scene('set_status')->validate();
  142. // 接收数据
  143. $id = request('id', 0);
  144. $status = request('status', 0);
  145. // 查询用户
  146. $where = ['id' => $id];
  147. // 执行修改
  148. $result = $EmployeeModel->changeStatus($where, $status);
  149. // 提示新增失败
  150. if (!$result) return json_send(['code' => 'error', 'msg' => '设置失败']);
  151. // 告知结果
  152. return json_send(['code' => 'success', 'msg' => '设置成功']);
  153. }
  154. /**
  155. * 删除
  156. * @author 唐远望
  157. * @version 1.0
  158. * @date 2025-12-04
  159. *
  160. */
  161. public function delete(Request $request, EmployeeModel $EmployeeModel)
  162. {
  163. // 验证参数
  164. $request->scene('delete')->validate();
  165. // 接收数据
  166. $id = request('id', 0);
  167. // 查询用户
  168. $where = ['id' => $id];
  169. // 执行删除
  170. $result = $EmployeeModel->deleteEmployee($where);
  171. // 提示删除失败
  172. if (!$result) return json_send(['code' => 'error', 'msg' => '删除失败']);
  173. // 告知结果
  174. return json_send(['code' => 'success', 'msg' => '删除成功']);
  175. }
  176. }