LowPriceGoods.php 27 KB

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