Company.php 9.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243
  1. <?php
  2. namespace App\Http\Controllers\Manager\External;
  3. use App\Http\Controllers\Controller;
  4. use App\Http\Requests\Manager\External\Company as Request;
  5. use App\Models\Manager\External\Company as CompanyModel;
  6. use Illuminate\Support\Facades\DB;
  7. use Illuminate\Support\Carbon;
  8. /**
  9. * 外部-公司管理
  10. * @author 唐远望
  11. * @version 1.0
  12. * @date 2026-02-03
  13. */
  14. class Company extends Controller
  15. {
  16. /**
  17. * 列表
  18. * @author 唐远望
  19. * @version 1.0
  20. * @date 2026-02-03
  21. *
  22. */
  23. public function list(Request $request, CompanyModel $CompanyModel)
  24. {
  25. $request->scene('list')->validate();
  26. // 查询条件
  27. $map = [];
  28. $limit = request('limit', config('page_num', 10));
  29. $status = request('status', '');
  30. $start_time = request('start_time', '');
  31. $end_time = request('end_time', '');
  32. $company_name = request('company_name', '');
  33. // 时间条件
  34. if ($start_time) $map[] = ['insert_time', '>=', strtotime($start_time)];
  35. if ($end_time) $map[] = ['insert_time', '<=', strtotime($end_time)];
  36. // 其他条件
  37. if (is_numeric($status)) $map[] = ['status', '=', $status];
  38. if ($company_name) $map[] = ['company_name', 'like', "%$company_name%"];
  39. // 查询数据
  40. $result = $CompanyModel->query()
  41. ->where($map)
  42. ->orderByDesc('id')
  43. ->paginate($limit)->toarray();
  44. // 分配数据
  45. if (!$result) return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => []]);
  46. // 加载模板
  47. return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]);
  48. }
  49. /**
  50. * 全部
  51. * @author 唐远望
  52. * @version 1.0
  53. * @date 2026-02-03
  54. *
  55. */
  56. public function all(Request $request, CompanyModel $CompanyModel)
  57. {
  58. $request->scene('all')->validate();
  59. // 查询条件
  60. $map = [];
  61. $status = request('status', '');
  62. $start_time = request('start_time', '');
  63. $end_time = request('end_time', '');
  64. $company_name = request('company_name', '');
  65. // 时间条件
  66. if ($start_time) $map[] = ['insert_time', '>=', strtotime($start_time)];
  67. if ($end_time) $map[] = ['insert_time', '<=', strtotime($end_time)];
  68. // 其他条件
  69. if (is_numeric($status)) $map[] = ['status', '=', $status];
  70. if ($company_name) $map[] = ['company_name', 'like', "%$company_name%"];
  71. // 查询数据
  72. $result = $CompanyModel->query()
  73. ->where($map)
  74. ->orderByDesc('id')
  75. ->get();
  76. // 分配数据
  77. if (!$result) return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => []]);
  78. // 加载模板
  79. return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]);
  80. }
  81. /**
  82. * 详情
  83. * @author 唐远望
  84. * @version 1.0
  85. * @date 2026-02-03
  86. */
  87. public function detail(Request $request, CompanyModel $CompanyModel)
  88. {
  89. $request->scene('detail')->validate();
  90. // 接收参数
  91. $id = request('id', 0);
  92. $map = ['id' => $id];
  93. // 权限判断
  94. $data = $CompanyModel->where($map)->first();
  95. if (!$data) return json_send(['code' => 'error', 'msg' => '记录不存在']);
  96. // 加载模板
  97. return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $data]);
  98. }
  99. /**
  100. * 添加
  101. * @author 唐远望
  102. * @version 1.0
  103. * @date 2026-02-03
  104. *
  105. */
  106. public function add(Request $request, CompanyModel $CompanyModel)
  107. {
  108. $request->scene('add')->validate();
  109. $all_data = request()->all();
  110. //查询是否存在
  111. $map = ['social_credit_code' => $all_data['social_credit_code']];
  112. $data = $CompanyModel->where($map)->first();
  113. if ($data) return json_send(['code' => 'error', 'msg' => '记录已存在']);
  114. // 写入数据表
  115. $result = $CompanyModel->addCompany($all_data);
  116. // 如果操作失败
  117. if (!$result) return json_send(['code' => 'error', 'msg' => '新增失败']);
  118. // 记录行为
  119. $admin_id = request('access_token.uid', 0); //用户ID
  120. $is_admin = request('access_token.is_admin'); //是否管理员操作 0=是1=否
  121. $table_name = $CompanyModel->getTable();
  122. $notes_type = 1; //操作类型,1添加,2修改,3=删除
  123. $this->addAdminHistory('外部-公司管理', 0, $admin_id, $is_admin, $table_name, $notes_type, [], $all_data, '新增了公司' . $all_data['company_name'] . '信息');
  124. // 告知结果
  125. return json_send(['code' => 'success', 'msg' => '新增成功']);
  126. }
  127. /**
  128. * 修改
  129. * @author 唐远望
  130. * @version 1.0
  131. * @date 2026-02-03
  132. *
  133. */
  134. public function edit(Request $request, CompanyModel $CompanyModel)
  135. {
  136. $request->scene('edit')->validate();
  137. // 接收参数
  138. $id = request('id', 0);
  139. // 接收数据
  140. $all_data = request()->all();
  141. //查询是否存在
  142. $map = ['social_credit_code' => $all_data['social_credit_code']];
  143. $data = $CompanyModel->where($map)->where('id', '!=', $id)->first();
  144. if ($data) return json_send(['code' => 'error', 'msg' => '记录已存在']);
  145. // 更新数据表
  146. $where = ['id' => $id];
  147. $Company = $CompanyModel->where($where)->first();
  148. if (!$Company) return json_send(['code' => 'error', 'msg' => '记录不存在']);
  149. $oldData = $Company->toarray();
  150. $result = $CompanyModel->editCompany_content($Company, $all_data);
  151. // 如果操作失败
  152. if (!$result) return json_send(['code' => 'error', 'msg' => '修改失败']);
  153. // 记录行为
  154. $admin_id = request('access_token.uid', 0); //用户ID
  155. $is_admin = request('access_token.is_admin'); //是否管理员操作 0=是1=否
  156. $table_name = $CompanyModel->getTable();
  157. $notes_type = 2; //操作类型,1添加,2修改,3=删除
  158. $this->addAdminHistory('外部-公司管理', 0, $admin_id, $is_admin, $table_name, $notes_type, $oldData, $all_data, '修改了公司' . $oldData['company_name'] . '信息');
  159. // 告知结果
  160. return json_send(['code' => 'success', 'msg' => '修改成功']);
  161. }
  162. /**
  163. * 修改状态
  164. * @author 唐远望
  165. * @version 1.0
  166. * @date 2026-02-03
  167. *
  168. */
  169. public function set_status(Request $request, CompanyModel $CompanyModel)
  170. {
  171. // 验证参数
  172. $request->scene('set_status')->validate();
  173. $is_admin = request('access_token.is_admin', '0');
  174. // 接收数据
  175. $id = request('id', 0);
  176. $status = request('status', 0);
  177. $where = ['id' => $id];
  178. $Company = $CompanyModel->where($where)->first();
  179. if (!$Company) return json_send(['code' => 'error', 'msg' => '记录不存在']);
  180. // 执行修改
  181. $result = $CompanyModel->changeStatus($Company, $status);
  182. // 提示新增失败
  183. if (!$result) return json_send(['code' => 'error', 'msg' => '设置失败']);
  184. // 记录行为
  185. $admin_id = request('access_token.uid', 0); //用户ID
  186. $table_name = $CompanyModel->getTable();
  187. $notes_type = 2; //操作类型,1添加,2修改,3=删除
  188. $this->addAdminHistory('外部-公司管理', 0, $admin_id, $is_admin, $table_name, $notes_type, [], ['status' => $status], '修改了公司' . $Company->company_name . '状态');
  189. // 告知结果
  190. return json_send(['code' => 'success', 'msg' => '设置成功']);
  191. }
  192. /**
  193. * 删除
  194. * @author 唐远望
  195. * @version 1.0
  196. * @date 2026-02-03
  197. *
  198. */
  199. public function delete(Request $request, CompanyModel $CompanyModel)
  200. {
  201. // 验证参数
  202. $request->scene('delete')->validate();
  203. // 接收数据
  204. $id = request('id', 0);
  205. // 查询用户
  206. $where = ['id' => $id];
  207. // 执行删除
  208. $Company = $CompanyModel->where($where)->first();
  209. if (!$Company) {
  210. return json_send(['code' => 'error', 'msg' => '删除失败,记录不存在']);
  211. }
  212. DB::beginTransaction();
  213. try {
  214. $Company->delete();
  215. // 记录行为
  216. $admin_id = request('access_token.uid', 0); //用户ID
  217. $is_admin = request('access_token.is_admin'); //是否管理员操作 0=是1=否
  218. $table_name = $CompanyModel->getTable();
  219. $notes_type = 3; //操作类型,1添加,2修改,3=删除
  220. $this->addAdminHistory('外部-公司管理', 0, $admin_id, $is_admin, $table_name, $notes_type, $Company->toarray(), [], '删除了公司' . $Company->company_name . '信息');
  221. // 告知结果
  222. DB::commit();
  223. return json_send(['code' => 'success', 'msg' => '删除成功']);
  224. // 成功处理...
  225. } catch (\Exception $e) {
  226. DB::rollBack();
  227. // 错误处理...
  228. return json_send(['code' => 'error', 'msg' => '删除失败']);
  229. }
  230. }
  231. }