ControlGoods.php 7.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170
  1. <?php
  2. namespace App\Http\Controllers\Api\Process;
  3. use App\Http\Controllers\Api\Api;
  4. use App\Http\Requests\Api\Process\ControlGoods as Request;
  5. use App\Models\Api\Process\ControlGoods as ControlGoodsModel;
  6. use App\Models\Api\Personnel\Employee as EmployeeModel;
  7. /**
  8. * 违规处理-强管控商品
  9. * @author 唐远望
  10. * @version 1.0
  11. * @date 2025-12-09
  12. */
  13. class ControlGoods extends Api
  14. {
  15. /**
  16. * 列表
  17. * @author 唐远望
  18. * @version 1.0
  19. * @date 2025-12-09
  20. *
  21. */
  22. public function list(Request $request, ControlGoodsModel $ControlGoodsModel, EmployeeModel $EmployeeModel)
  23. {
  24. $user_info = $this->checkLogin();
  25. if (!$user_info) return json_send(['code' => 'error', 'msg' => '请先登录']);
  26. $user_id = $user_info['uid'];
  27. $request->scene('list')->validate();
  28. // 查询条件
  29. $map = [];
  30. $limit = request('limit', config('page_num', 10));
  31. $status = request('status', '');
  32. $start_time = request('start_time', '');
  33. $end_time = request('end_time', '');
  34. $product_name = request('product_name', '');
  35. $first_responsible_person = request('first_responsible_person', '');
  36. $responsible_person = request('responsible_person', '');
  37. $platform = request('platform', '');
  38. $company_name = request('company_name', '');
  39. $store_name = request('store_name', '');
  40. $source_responsible_person = request('source_responsible_person', '');
  41. $processing_status = request('processing_status', '');
  42. // 时间条件
  43. if ($start_time) $map[] = ['insert_time', '>=', strtotime($start_time)];
  44. if ($end_time) $map[] = ['insert_time', '<=', strtotime($end_time)];
  45. // 其他条件
  46. if ($status) $map[] = ['status', '=', $status];
  47. if ($product_name) $map[] = ['product_name', 'like', "%$product_name%"];
  48. if ($first_responsible_person) $map[] = ['first_responsible_person', 'like', "%$first_responsible_person%"];
  49. if ($responsible_person) $map[] = ['responsible_person', 'like', "%$responsible_person%"];
  50. if ($platform) $map[] = ['platform', 'like', "%$platform%"];
  51. if ($company_name) $map[] = ['company_name', 'like', "%$company_name%"];
  52. if ($store_name) $map[] = ['store_name', 'like', "%$store_name%"];
  53. if ($source_responsible_person) $map[] = ['source_responsible_person', 'like', "%$source_responsible_person%"];
  54. if ($processing_status) $map[] = ['processing_status', '=', $processing_status];
  55. // 查询数据
  56. $map1 = array_merge($map, [['first_responsible_person', 'like', "%,$user_id,%"]]);
  57. $map2 = array_merge($map, [['responsible_person', 'like', "%,$user_id,%"]]);
  58. $map3 = array_merge($map, [['source_responsible_person', 'like', "%,$user_id,%"]]);
  59. $result = $ControlGoodsModel->query()
  60. ->where($map1)
  61. ->orWhere($map2)
  62. ->orWhere($map3)
  63. ->orderByDesc('id')
  64. ->paginate($limit)->toarray();
  65. // 分配数据
  66. if (!$result) return json_send(['code' => 'error', 'msg' => '暂无数据']);
  67. if (isset($result['data']) && count($result['data']) > 0) {
  68. foreach ($result['data'] as $key => $value) {
  69. //查询第一责任人名称
  70. $first_responsible_person = explode(',', $value['first_responsible_person']);
  71. $first_responsible_person_name = $EmployeeModel->whereIn('id', $first_responsible_person)->pluck('name')->toarray();
  72. $result['data'][$key]['first_responsible_person_name'] = $first_responsible_person_name;
  73. //查询责任人名称
  74. $responsible_person = explode(',', $value['responsible_person']);
  75. $responsible_person_name = $EmployeeModel->whereIn('id', $responsible_person)->pluck('name')->toarray();
  76. $result['data'][$key]['responsible_person_name'] = $responsible_person_name;
  77. //查询来源责任人名称
  78. $source_responsible_person = explode(',', $value['source_responsible_person']);
  79. $source_responsible_person_name = $EmployeeModel->whereIn('id', $source_responsible_person)->pluck('name')->toarray();
  80. $result['data'][$key]['source_responsible_person_name'] = $source_responsible_person_name;
  81. }
  82. }
  83. // 加载模板
  84. return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]);
  85. }
  86. /**
  87. * 详情
  88. * @author 唐远望
  89. * @version 1.0
  90. * @date 2025-12-09
  91. */
  92. public function detail(Request $request, ControlGoodsModel $ControlGoodsModel, EmployeeModel $EmployeeModel)
  93. {
  94. $user_info = $this->checkLogin();
  95. if (!$user_info) return json_send(['code' => 'error', 'msg' => '请先登录']);
  96. $request->scene('detail')->validate();
  97. // 接收参数
  98. $id = request('id', 0);
  99. $map = ['id' => $id];
  100. $data = $ControlGoodsModel->where($map)->first();
  101. if (!$data) return json_send(['code' => 'error', 'msg' => '记录不存在']);
  102. //查询第一责任人名称
  103. $first_responsible_person = explode(',', $data->first_responsible_person);
  104. $first_responsible_person_name = $EmployeeModel->whereIn('id', $first_responsible_person)->pluck('name')->toarray();
  105. $data->first_responsible_person_name = $first_responsible_person_name;
  106. //查询责任人名称
  107. $responsible_person = explode(',', $data->responsible_person);
  108. $responsible_person_name = $EmployeeModel->whereIn('id', $responsible_person)->pluck('name')->toarray();
  109. $data->responsible_person_name = $responsible_person_name;
  110. //查询来源责任人名称
  111. $source_responsible_person = explode(',', $data->source_responsible_person);
  112. $source_responsible_person_name = $EmployeeModel->whereIn('id', $source_responsible_person)->pluck('name')->toarray();
  113. $data->source_responsible_person_name = $source_responsible_person_name;
  114. // 加载模板
  115. return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $data]);
  116. }
  117. /**
  118. * 修改状态
  119. * @author 唐远望
  120. * @version 1.0
  121. * @date 2025-12-09
  122. *
  123. */
  124. public function set_status(Request $request, ControlGoodsModel $ControlGoodsModel)
  125. {
  126. // 验证参数
  127. $request->scene('set_status')->validate();
  128. // 接收数据
  129. $id = request('id', 0);
  130. $status = request('status', 0);
  131. // 查询用户
  132. $where = ['id' => $id];
  133. // 执行修改
  134. $result = $ControlGoodsModel->changeStatus($where, $status);
  135. // 提示新增失败
  136. if (!$result) return json_send(['code' => 'error', 'msg' => '设置失败']);
  137. // 告知结果
  138. return json_send(['code' => 'success', 'msg' => '设置成功']);
  139. }
  140. /**
  141. * 修改处理状态
  142. * @author 唐远望
  143. * @version 1.0
  144. * @date 2025-12-09
  145. *
  146. */
  147. public function set_processing_status(Request $request, ControlGoodsModel $ControlGoodsModel)
  148. {
  149. // 验证参数
  150. $request->scene('set_processing_status')->validate();
  151. // 接收数据
  152. $id = request('id', 0);
  153. $processing_status = request('processing_status', 0);
  154. // 查询用户
  155. $where = ['id' => $id];
  156. // 执行修改
  157. $result = $ControlGoodsModel->changeProcessingStatus($where, $processing_status);
  158. // 提示新增失败
  159. if (!$result) return json_send(['code' => 'error', 'msg' => '设置失败']);
  160. // 告知结果
  161. return json_send(['code' => 'success', 'msg' => '设置成功']);
  162. }
  163. }