ViolationProduct.php 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600
  1. <?php
  2. namespace App\Http\Controllers\Manager\Process;
  3. use App\Http\Controllers\Controller;
  4. use App\Http\Requests\Manager\Process\ViolationProduct as Request;
  5. use App\Models\Manager\Process\ViolationProduct as ViolationProductModel;
  6. use App\Jobs\Manager\Process\ViolationProductJobs;
  7. use App\Models\Manager\Personnel\Employee as EmployeeModel;
  8. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  9. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  10. use PhpOffice\PhpSpreadsheet\Style\Alignment;
  11. use App\Models\Manager\Process\ViolationProductMember as ViolationProductMemberModel;
  12. /**
  13. * 违规处理-违规商品
  14. * @author 唐远望
  15. * @version 1.0
  16. * @date 2025-12-08
  17. */
  18. class ViolationProduct extends Controller
  19. {
  20. /**
  21. * 列表
  22. * @author 唐远望
  23. * @version 1.0
  24. * @date 2025-12-08
  25. *
  26. */
  27. public function list(Request $request, ViolationProductModel $ViolationProductModel, EmployeeModel $EmployeeModel, ViolationProductMemberModel $ViolationProductMemberModel)
  28. {
  29. $request->scene('list')->validate();
  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. $product_name = request('product_name', '');
  37. $product_names = request('product_names', '');
  38. $first_responsible_person = request('first_responsible_person', '');
  39. $responsible_person = request('responsible_person', '');
  40. $platform = request('platform', '');
  41. $company_name = request('company_name', '');
  42. $company_names = request('company_names', '');
  43. $store_name = request('store_name', '');
  44. $store_names = request('store_names', '');
  45. $source_responsible_person = request('source_responsible_person', '');
  46. $processing_status = request('processing_status', '');
  47. $product_specs = request('product_specs', '');
  48. $online_posting_count = request('online_posting_count', '');
  49. $category_name = request('category_name', '');
  50. // 时间条件
  51. if ($start_time) $map[] = ['insert_time', '>=', strtotime($start_time)];
  52. if ($end_time) $map[] = ['insert_time', '<=', strtotime($end_time)];
  53. // 其他条件
  54. if ($product_name) $map[] = ['product_name', 'like', "%$product_name%"];
  55. if ($store_name) $map[] = ['store_name', 'like', "%$store_name%"];
  56. if ($category_name) $map[] = ['category_name', 'like', "%$category_name%"];
  57. if ($company_name) $map[] = ['company_name', 'like', "%$company_name%"];
  58. //多选平台查询
  59. if ($platform && is_string($platform)) {
  60. $platform = explode(',', $platform);
  61. $ViolationProductModel = $ViolationProductModel->whereIn('platform', $platform);
  62. }
  63. //多选处理状态查询
  64. if ($processing_status && is_string($processing_status)) {
  65. $processing_status = explode(',', $processing_status);
  66. $ViolationProductModel = $ViolationProductModel->whereIn('processing_status', $processing_status);
  67. }
  68. //多选状态查询
  69. if ($status && is_string($status)) {
  70. $status = explode(',', $status);
  71. $ViolationProductModel = $ViolationProductModel->whereIn('status', $status);
  72. }
  73. //多选店铺名称查询
  74. if ($store_names && is_string($store_names)) {
  75. $store_names = explode(',', $store_names);
  76. $ViolationProductModel = $ViolationProductModel->whereIn('store_name', $store_names);
  77. }
  78. //多选违规挂网次数查询
  79. if ($online_posting_count && is_string($online_posting_count)) {
  80. $online_posting_count = explode(',', $online_posting_count);
  81. $ViolationProductModel = $ViolationProductModel->whereIn('online_posting_count', $online_posting_count);
  82. }
  83. //多选规格查询
  84. if ($product_specs && is_string($product_specs)) {
  85. $product_specs = explode(',', $product_specs);
  86. $ViolationProductModel = $ViolationProductModel->whereIn('product_specs', $product_specs);
  87. }
  88. //多选商品查询
  89. if ($product_names && is_string($product_names)) {
  90. $product_names = explode(',', $product_names);
  91. $ViolationProductModel = $ViolationProductModel->whereIn('product_name', $product_names);
  92. }
  93. //多选公司查询
  94. if ($company_names && is_string($company_names)) {
  95. $company_names = explode(',', $company_names);
  96. $ViolationProductModel = $ViolationProductModel->whereIn('company_name', $company_names);
  97. }
  98. //多选第一责任人
  99. if ($first_responsible_person && is_string($first_responsible_person)) {
  100. $first_responsible_person = explode(',', $first_responsible_person);
  101. $subQuery = $ViolationProductMemberModel->whereIn('employee_id', $first_responsible_person)->distinct('violation_product_logid')->select('violation_product_logid');
  102. $ViolationProductModel = $ViolationProductModel->whereIn('id', function ($query1) use ($subQuery) {
  103. $query1->select('violation_product_logid')->fromSub($subQuery, 'sub1');
  104. });
  105. }
  106. //多选责任人
  107. if ($responsible_person && is_string($responsible_person)) {
  108. $responsible_person = explode(',', $responsible_person);
  109. $subQuery = $ViolationProductMemberModel->whereIn('employee_id', $responsible_person)->distinct('violation_product_logid')->select('violation_product_logid');
  110. $ViolationProductModel = $ViolationProductModel->whereIn('id', function ($query1) use ($subQuery) {
  111. $query1->select('violation_product_logid')->fromSub($subQuery, 'sub1');
  112. });
  113. }
  114. //多选溯源责任人
  115. if ($source_responsible_person && is_string($source_responsible_person)) {
  116. $source_responsible_person = explode(',', $source_responsible_person);
  117. $subQuery = $ViolationProductMemberModel->whereIn('employee_id', $source_responsible_person)->distinct('violation_product_logid')->select('violation_product_logid');
  118. $ViolationProductModel = $ViolationProductModel->whereIn('id', function ($query1) use ($subQuery) {
  119. $query1->select('violation_product_logid')->fromSub($subQuery, 'sub1');
  120. });
  121. }
  122. $result = $ViolationProductModel
  123. ->where($map)
  124. ->orderByDesc('id')
  125. ->paginate($limit)->toarray();
  126. // 分配数据
  127. if (!$result) json_send(['code' => 'success', 'msg' => '获取成功', 'data' => []]);
  128. if (isset($result['data']) && count($result['data']) > 0) {
  129. foreach ($result['data'] as $key => $value) {
  130. //查询第一责任人名称
  131. $first_responsible_person = explode(',', $value['first_responsible_person']);
  132. $first_responsible_person_name = $EmployeeModel->whereIn('id', $first_responsible_person)->pluck('name')->toarray();
  133. $result['data'][$key]['first_responsible_person_name'] = $first_responsible_person_name;
  134. //查询责任人名称
  135. $responsible_person = explode(',', $value['responsible_person']);
  136. $responsible_person_name = $EmployeeModel->whereIn('id', $responsible_person)->pluck('name')->toarray();
  137. $result['data'][$key]['responsible_person_name'] = $responsible_person_name;
  138. //查询来源责任人名称
  139. $source_responsible_person = explode(',', $value['source_responsible_person']);
  140. $source_responsible_person_name = $EmployeeModel->whereIn('id', $source_responsible_person)->pluck('name')->toarray();
  141. $result['data'][$key]['source_responsible_person_name'] = $source_responsible_person_name;
  142. }
  143. }
  144. // 加载模板
  145. return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]);
  146. }
  147. /**
  148. * 列表导出
  149. * @author 唐远望
  150. * @version 1.0
  151. * @date 2025-06-17
  152. */
  153. public function export_excel(Request $request, ViolationProductModel $ViolationProductModel, EmployeeModel $EmployeeModel, ViolationProductMemberModel $ViolationProductMemberModel)
  154. {
  155. $request->scene('export_excel')->validate();
  156. // 查询条件
  157. $map = [];
  158. $limit = request('limit', config('page_num', 10));
  159. $status = request('status', '');
  160. $start_time = request('start_time', '');
  161. $end_time = request('end_time', '');
  162. $product_name = request('product_name', '');
  163. $product_names = request('product_names', '');
  164. $first_responsible_person = request('first_responsible_person', '');
  165. $responsible_person = request('responsible_person', '');
  166. $platform = request('platform', '');
  167. $company_name = request('company_name', '');
  168. $store_name = request('store_name', '');
  169. $store_names = request('store_names', '');
  170. $source_responsible_person = request('source_responsible_person', '');
  171. $processing_status = request('processing_status', '');
  172. $product_specs = request('product_specs', '');
  173. $online_posting_count = request('online_posting_count', '');
  174. $category_name = request('category_name', '');
  175. // 时间条件
  176. if ($start_time) $map[] = ['insert_time', '>=', strtotime($start_time)];
  177. if ($end_time) $map[] = ['insert_time', '<=', strtotime($end_time)];
  178. // 其他条件
  179. if ($product_name) $map[] = ['product_name', 'like', "%$product_name%"];
  180. if ($store_name) $map[] = ['store_name', 'like', "%$store_name%"];
  181. if ($category_name) $map[] = ['category_name', 'like', "%$category_name%"];
  182. //多选平台查询
  183. if ($platform && is_string($platform)) {
  184. $platform = explode(',', $platform);
  185. $ViolationProductModel = $ViolationProductModel->whereIn('platform', $platform);
  186. }
  187. //多选处理状态查询
  188. if ($processing_status && is_string($processing_status)) {
  189. $processing_status = explode(',', $processing_status);
  190. $ViolationProductModel = $ViolationProductModel->whereIn('processing_status', $processing_status);
  191. }
  192. //多选状态查询
  193. if ($status && is_string($status)) {
  194. $status = explode(',', $status);
  195. $ViolationProductModel = $ViolationProductModel->whereIn('status', $status);
  196. }
  197. //多选店铺名称查询
  198. if ($store_names && is_string($store_names)) {
  199. $store_names = explode(',', $store_names);
  200. $ViolationProductModel = $ViolationProductModel->whereIn('store_name', $store_names);
  201. }
  202. //多选违规挂网次数查询
  203. if ($online_posting_count && is_string($online_posting_count)) {
  204. $online_posting_count = explode(',', $online_posting_count);
  205. $ViolationProductModel = $ViolationProductModel->whereIn('online_posting_count', $online_posting_count);
  206. }
  207. //多选规格查询
  208. if ($product_specs && is_string($product_specs)) {
  209. $product_specs = explode(',', $product_specs);
  210. $ViolationProductModel = $ViolationProductModel->whereIn('product_specs', $product_specs);
  211. }
  212. //多选商品查询
  213. if ($product_names && is_string($product_names)) {
  214. $product_names = explode(',', $product_names);
  215. $ViolationProductModel = $ViolationProductModel->whereIn('product_name', $product_names);
  216. }
  217. //多选公司查询
  218. if ($company_name && is_string($company_name)) {
  219. $company_name = explode(',', $company_name);
  220. $ViolationProductModel = $ViolationProductModel->whereIn('company_name', $company_name);
  221. }
  222. //多选第一责任人
  223. if ($first_responsible_person && is_string($first_responsible_person)) {
  224. $first_responsible_person = explode(',', $first_responsible_person);
  225. $subQuery = $ViolationProductMemberModel->whereIn('employee_id', $first_responsible_person)->distinct('violation_product_logid')->select('violation_product_logid');
  226. $ViolationProductModel = $ViolationProductModel->whereIn('id', function ($query1) use ($subQuery) {
  227. $query1->select('violation_product_logid')->fromSub($subQuery, 'sub1');
  228. });
  229. }
  230. //多选责任人
  231. if ($responsible_person && is_string($responsible_person)) {
  232. $responsible_person = explode(',', $responsible_person);
  233. $subQuery = $ViolationProductMemberModel->whereIn('employee_id', $responsible_person)->distinct('violation_product_logid')->select('violation_product_logid');
  234. $ViolationProductModel = $ViolationProductModel->whereIn('id', function ($query1) use ($subQuery) {
  235. $query1->select('violation_product_logid')->fromSub($subQuery, 'sub1');
  236. });
  237. }
  238. //多选溯源责任人
  239. if ($source_responsible_person && is_string($source_responsible_person)) {
  240. $source_responsible_person = explode(',', $source_responsible_person);
  241. $subQuery = $ViolationProductMemberModel->whereIn('employee_id', $source_responsible_person)->distinct('violation_product_logid')->select('violation_product_logid');
  242. $ViolationProductModel = $ViolationProductModel->whereIn('id', function ($query1) use ($subQuery) {
  243. $query1->select('violation_product_logid')->fromSub($subQuery, 'sub1');
  244. });
  245. }
  246. $result = $ViolationProductModel
  247. ->where($map)
  248. ->orderByDesc('id')
  249. ->get()->toarray();
  250. // 分配数据
  251. if (!$result) return json_send(['code' => 'error', 'msg' => '暂无数据']);
  252. // 处理责任人展示信息
  253. $list_data = $this->processing_responsible_person($result);
  254. // 导出数据
  255. $this->export_download($list_data);
  256. }
  257. /**
  258. * 处理责任人展示信息
  259. * @author 唐远望
  260. * @version 1.0
  261. * @date 2025-12-17
  262. */
  263. public function processing_responsible_person($result)
  264. {
  265. $EmployeeModel = new EmployeeModel();
  266. //获取所有员工
  267. $employeee_data = $EmployeeModel->select(['id', 'name'])->get()->toarray();
  268. $employeee_list = [];
  269. if (!empty($employeee_data)) {
  270. foreach ($employeee_data as $key => $value) {
  271. $employeee_list[$value['id']] = $value['name'];
  272. }
  273. }
  274. if (isset($result) && count($result) > 0) {
  275. foreach ($result as $key => $value) {
  276. //查询第一责任人名称
  277. $first_responsible_person = $value['first_responsible_person'] != '' ? explode(',', $value['first_responsible_person']) : [];
  278. $first_responsible_person_name = [];
  279. if (!empty($first_responsible_person)) {
  280. foreach ($first_responsible_person as $k => $v) {
  281. if (isset($employeee_list[$v])) {
  282. $first_responsible_person_name[] = $employeee_list[$v];
  283. }
  284. }
  285. }
  286. $result[$key]['first_responsible_person_name'] = $first_responsible_person_name;
  287. //查询责任人名称
  288. $responsible_person = $value['responsible_person'] != '' ? explode(',', $value['responsible_person']) : [];
  289. $responsible_person_name = [];
  290. if (!empty($responsible_person)) {
  291. foreach ($responsible_person as $k => $v) {
  292. if (isset($employeee_list[$v])) {
  293. $responsible_person_name[] = $employeee_list[$v];
  294. }
  295. }
  296. }
  297. $result[$key]['responsible_person_name'] = $responsible_person_name;
  298. //查询来源责任人名称
  299. $source_responsible_person = $value['source_responsible_person'] != '' ? explode(',', $value['source_responsible_person']) : [];
  300. $source_responsible_person_name = [];
  301. if (!empty($source_responsible_person)) {
  302. foreach ($source_responsible_person as $k => $v) {
  303. if (isset($employeee_list[$v])) {
  304. $source_responsible_person_name[] = $employeee_list[$v];
  305. }
  306. }
  307. }
  308. $result[$key]['source_responsible_person_name'] = $source_responsible_person_name;
  309. }
  310. }
  311. return $result;
  312. }
  313. /**
  314. * 导出下载
  315. * @author 唐远望
  316. * @version 1.0
  317. * @date 2025-06-17
  318. */
  319. public function export_download($data)
  320. {
  321. // 创建一个新的 Spreadsheet 对象
  322. $spreadsheet = new Spreadsheet();
  323. $sheet = $spreadsheet->getActiveSheet();
  324. //合并单元格
  325. $sheet->mergeCells('A1:Q1');
  326. $sheet->setCellValue('A1', '禁止挂网商品导出(导出时间:' . date('Y-m-d H:i:s', time()) . ')'); // 设置合并后的单元格内容
  327. // 获取合并后的单元格样式对象
  328. $style = $sheet->getStyle('A1');
  329. // 设置水平居中和垂直居中
  330. $style->getAlignment()->setHorizontal(Alignment::HORIZONTAL_CENTER)->setVertical(Alignment::VERTICAL_CENTER);
  331. // 然后设置行高以适应两行文本
  332. $sheet->getRowDimension(1)->setRowHeight(40); // 设置行高,单位是磅(point)
  333. // 设置表头
  334. $sheet->setCellValue('A2', '第一责任人');
  335. $sheet->setCellValue('B2', '责任人');
  336. $sheet->setCellValue('C2', '平台');
  337. $sheet->setCellValue('D2', '商品分类');
  338. $sheet->setCellValue('E2', '商品名称');
  339. $sheet->setCellValue('F2', '商品规格');
  340. $sheet->setCellValue('G2', '累计挂网次数');
  341. $sheet->setCellValue('H2', '连续挂网次数');
  342. $sheet->setCellValue('I2', '链接地址');
  343. $sheet->setCellValue('J2', '店铺名称');
  344. $sheet->setCellValue('K2', '公司名称');
  345. $sheet->setCellValue('L2', '公司分类');
  346. $sheet->setCellValue('M2', '信用代码');
  347. $sheet->setCellValue('N2', '省份');
  348. $sheet->setCellValue('O2', '城市');
  349. $sheet->setCellValue('P2', '溯源责任人');
  350. $sheet->setCellValue('Q2', '处理状态');
  351. $sheet->setCellValue('R2', '任务状态');
  352. $sheet->setCellValue('S2', '记录时间');
  353. $platform_data = [
  354. '0' => '全部',
  355. '1' => '淘宝',
  356. '2' => '京东',
  357. '3' => '拼多多',
  358. '4' => '美团',
  359. '5' => '药师帮',
  360. '6' => '1药城',
  361. '7' => '药久久',
  362. ];
  363. $processing_status_text = [
  364. '1' => '待处理',
  365. ];
  366. $status_text = [
  367. '0' => '有效',
  368. '1' => '无效',
  369. ];
  370. // 填充数据
  371. $row = 3; // 从第2行开始
  372. foreach ($data as $item) {
  373. $first_responsible_person_name = !empty($item['first_responsible_person_name']) ? implode(',', $item['first_responsible_person_name']) : '';
  374. $responsible_person_name = !empty($item['responsible_person_name']) ? implode(',', $item['responsible_person_name']) : '';
  375. $source_responsible_person_name = !empty($item['source_responsible_person_name']) ? implode(',', $item['source_responsible_person_name']) : '';
  376. $sheet->setCellValue('A' . $row, $first_responsible_person_name);
  377. $sheet->setCellValue('B' . $row, $responsible_person_name);
  378. $sheet->setCellValue('C' . $row, isset($platform_data[$item['platform']]) ? $platform_data[$item['platform']] : '');
  379. $sheet->setCellValue('D' . $row, $item['category_name']);
  380. $sheet->setCellValue('E' . $row, $item['product_name']);
  381. $sheet->setCellValue('F' . $row, $item['product_specs']);
  382. $sheet->setCellValue('G' . $row, $item['online_posting_count']);
  383. $sheet->setCellValue('H' . $row, $item['continuous_listing_count']);
  384. $sheet->setCellValue('I' . $row, $item['link_url']);
  385. $sheet->setCellValue('J' . $row, $item['store_name']);
  386. $sheet->setCellValue('K' . $row, $item['company_name']);
  387. $sheet->setCellValue('L' . $row, $item['company_category_name']);
  388. $sheet->setCellValue('M' . $row, $item['social_credit_code']);
  389. $sheet->setCellValue('N' . $row, $item['province_name']);
  390. $sheet->setCellValue('O' . $row, $item['city_name']);
  391. $sheet->setCellValue('P' . $row, $source_responsible_person_name);
  392. $sheet->setCellValue('Q' . $row, isset($processing_status_text[$item['processing_status']]) ? $processing_status_text[$item['processing_status']] : '');
  393. $sheet->setCellValue('R' . $row, isset($status_text[$item['status']]) ? $status_text[$item['status']] : '');
  394. $sheet->setCellValue('S' . $row, date('Y-m-d H:i:s', $item['insert_time']));
  395. $row++;
  396. }
  397. foreach (range('A', 'P') as $column) {
  398. $sheet->getColumnDimension($column)->setAutoSize(true);
  399. }
  400. // 生成 Excel 文件
  401. $writer = new Xlsx($spreadsheet);
  402. // 直接输出到浏览器(下载)
  403. $filename = '禁止挂网商品数据' . date('YmdHis') . '.xlsx';
  404. header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
  405. header('Content-Disposition: attachment;filename="' . $filename . '"');
  406. header('Cache-Control: max-age=0');
  407. $writer->save('php://output');
  408. exit;
  409. }
  410. /**
  411. * 详情
  412. * @author 唐远望
  413. * @version 1.0
  414. * @date 2025-12-08
  415. */
  416. public function detail(Request $request, ViolationProductModel $ViolationProductModel, EmployeeModel $EmployeeModel)
  417. {
  418. $request->scene('detail')->validate();
  419. // 接收参数
  420. $id = request('id', 0);
  421. $map = ['id' => $id];
  422. $data = $ViolationProductModel->where($map)->first();
  423. if (!$data) return json_send(['code' => 'error', 'msg' => '记录不存在']);
  424. //查询第一责任人名称
  425. $first_responsible_person = explode(',', $data->first_responsible_person);
  426. $first_responsible_person_name = $EmployeeModel->whereIn('id', $first_responsible_person)->pluck('name')->toarray();
  427. $data->first_responsible_person_name = $first_responsible_person_name;
  428. //查询责任人名称
  429. $responsible_person = explode(',', $data->responsible_person);
  430. $responsible_person_name = $EmployeeModel->whereIn('id', $responsible_person)->pluck('name')->toarray();
  431. $data->responsible_person_name = $responsible_person_name;
  432. //查询来源责任人名称
  433. $source_responsible_person = explode(',', $data->source_responsible_person);
  434. $source_responsible_person_name = $EmployeeModel->whereIn('id', $source_responsible_person)->pluck('name')->toarray();
  435. $data->source_responsible_person_name = $source_responsible_person_name;
  436. // 加载模板
  437. return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $data]);
  438. }
  439. /**
  440. * 添加
  441. * @author 唐远望
  442. * @version 1.0
  443. * @date 2025-12-08
  444. *
  445. */
  446. public function add(Request $request, ViolationProductModel $ViolationProductModel)
  447. {
  448. $request->scene('add')->validate();
  449. // 接收数据
  450. $all_data = request()->all();
  451. $store_scope = request('store_scope', '');
  452. $all_data['store_scope'] = $store_scope;
  453. //查询是否存在
  454. $map = ['product_name' => $all_data['product_name'], 'product_specs' => $all_data['product_specs']];
  455. $data = $ViolationProductModel->where($map)->first();
  456. if ($data) return json_send(['code' => 'error', 'msg' => '记录已存在']);
  457. // 写入数据表
  458. $result = $ViolationProductModel->addLowPriceGoods($all_data);
  459. // 如果操作失败
  460. if (!$result) return json_send(['code' => 'error', 'msg' => '新增失败']);
  461. // 告知结果
  462. return json_send(['code' => 'success', 'msg' => '新增成功']);
  463. }
  464. /**
  465. * 修改
  466. * @author 唐远望
  467. * @version 1.0
  468. * @date 2025-12-08
  469. *
  470. */
  471. public function edit(Request $request, ViolationProductModel $ViolationProductModel)
  472. {
  473. $request->scene('edit')->validate();
  474. // 接收参数
  475. $id = request('id', 0);
  476. // 接收数据
  477. $all_data = request()->all();
  478. $store_scope = request('store_scope', '');
  479. $all_data['store_scope'] = $store_scope;
  480. //查询是否存在
  481. $map = ['product_name' => $all_data['product_name'], 'product_specs' => $all_data['product_specs']];
  482. $data = $ViolationProductModel->where($map)->where('id', '!=', $id)->first();
  483. if ($data) return json_send(['code' => 'error', 'msg' => '记录已存在']);
  484. // 更新数据表
  485. $where = ['id' => $id];
  486. $result = $ViolationProductModel->updateLowPriceGoods($where, $all_data);
  487. // 如果操作失败
  488. if (!$result) return json_send(['code' => 'error', 'msg' => '修改失败']);
  489. // 告知结果
  490. return json_send(['code' => 'success', 'msg' => '修改成功']);
  491. }
  492. /**
  493. * 修改状态
  494. * @author 唐远望
  495. * @version 1.0
  496. * @date 2025-12-08
  497. *
  498. */
  499. public function set_status(Request $request, ViolationProductModel $ViolationProductModel)
  500. {
  501. // 验证参数
  502. $request->scene('set_status')->validate();
  503. // 接收数据
  504. $id = request('id', 0);
  505. $status = request('status', 0);
  506. // 查询用户
  507. $where = ['id' => $id];
  508. // 执行修改
  509. $result = $ViolationProductModel->changeStatus($where, $status);
  510. // 提示新增失败
  511. if (!$result) return json_send(['code' => 'error', 'msg' => '设置失败']);
  512. // 告知结果
  513. return json_send(['code' => 'success', 'msg' => '设置成功']);
  514. }
  515. /**
  516. * 修改处理状态
  517. * @author 唐远望
  518. * @version 1.0
  519. * @date 2025-12-08
  520. *
  521. */
  522. public function set_processing_status(Request $request, ViolationProductModel $ViolationProductModel)
  523. {
  524. // 验证参数
  525. $request->scene('set_processing_status')->validate();
  526. // 接收数据
  527. $id = request('id', 0);
  528. $processing_status = request('processing_status', 0);
  529. // 查询用户
  530. $where = ['id' => $id];
  531. // 执行修改
  532. $result = $ViolationProductModel->changeProcessingStatus($where, $processing_status);
  533. // 提示新增失败
  534. if (!$result) return json_send(['code' => 'error', 'msg' => '设置失败']);
  535. // 告知结果
  536. return json_send(['code' => 'success', 'msg' => '设置成功']);
  537. }
  538. /**
  539. * 删除
  540. * @author 唐远望
  541. * @version 1.0
  542. * @date 2025-12-08
  543. *
  544. */
  545. public function delete(Request $request, ViolationProductModel $ViolationProductModel)
  546. {
  547. // 验证参数
  548. $request->scene('delete')->validate();
  549. // 接收数据
  550. $id = request('id', 0);
  551. // 查询用户
  552. $where = ['id' => $id];
  553. // 执行删除
  554. $result = $ViolationProductModel->deleteLowPriceGoods($where);
  555. // 提示删除失败
  556. if (!$result) return json_send(['code' => 'error', 'msg' => '删除失败']);
  557. // 告知结果
  558. return json_send(['code' => 'success', 'msg' => '删除成功']);
  559. }
  560. /**
  561. * 执行数据清洗
  562. * @author 唐远望
  563. * @version 1.0
  564. * @date 2025-12-11
  565. *
  566. */
  567. public function data_cleaning(Request $request)
  568. {
  569. // 验证参数
  570. $request->scene('data_cleaning')->validate();
  571. $access_token = request('access_token', '');
  572. $admin_id = $access_token['uid'];
  573. $message_data = ['page' => '1', 'limit' => 50, 'admin_id' => $admin_id];
  574. ViolationProductJobs::dispatch($message_data);
  575. // ViolationProductJobs::dispatchSync($message_data);
  576. // 告知结果
  577. return json_send(['code' => 'success', 'msg' => '执行成功']);
  578. }
  579. }