ViolationProduct.php 8.2 KB

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