JdTmaoProductJobs.php 3.6 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495
  1. <?php
  2. namespace App\Jobs\Manager\CollectData\JdTmao;
  3. use Illuminate\Bus\Queueable;
  4. use Illuminate\Contracts\Queue\ShouldBeUnique;
  5. use Illuminate\Contracts\Queue\ShouldQueue;
  6. use Illuminate\Foundation\Bus\Dispatchable;
  7. use Illuminate\Queue\InteractsWithQueue;
  8. use Illuminate\Queue\SerializesModels;
  9. use App\Facades\Servers\Logs\Log;
  10. use App\Models\Manager\CollectData\JdTmao\Product as JdTmaoProductModel;
  11. use App\Jobs\Manager\CollectData\JdTmao\JdTmaoStoreJobs;
  12. /**
  13. * 采集数据-京东天猫数据同步
  14. * @author 唐远望
  15. * @version 1.0
  16. * @date 2026-02-06
  17. */
  18. class JdTmaoProductJobs implements ShouldQueue
  19. {
  20. use Dispatchable, InteractsWithQueue, Queueable, SerializesModels;
  21. protected $message_data;
  22. /**
  23. * Create a new job instance.
  24. *
  25. * @return void
  26. */
  27. public function __construct(array $message_data)
  28. {
  29. $this->message_data = $message_data;
  30. }
  31. /**
  32. * Execute the job.
  33. *
  34. * @return void
  35. */
  36. public function handle()
  37. {
  38. $page = isset($this->message_data['page']) ? $this->message_data['page'] : 1;
  39. $limit = isset($this->message_data['limit']) ? $this->message_data['limit'] : 50;
  40. $field = [
  41. 'platform_name', // 平台名称
  42. 'drugname', // 商品名称
  43. 'format_drugname', //药品标准名称
  44. 'specification', //规格
  45. 'format_spec', // 规格标准
  46. 'production_date', // 生产日期
  47. 'validity_date', // 有效期
  48. 'total_price', // 价格
  49. 'number', //盒数
  50. 'min_price', //单价
  51. 'stock_quantity', //库存数量
  52. 'sales', //销量
  53. 'purchase_limit', //采购限制
  54. 'approval', //批准文号
  55. 'scrape_date', //抓取时间
  56. 'update_time', //更新时间
  57. 'product_id', //商品ID
  58. 'url', //商品链接
  59. 'store_name', //店铺名称
  60. 'company_name', //公司名称
  61. 'province_name', //省份名称
  62. 'city_name', //城市名称
  63. 'credit_code', // 统一社会信用代码
  64. ];
  65. try {
  66. $JdTmaoProductModel = new JdTmaoProductModel();
  67. //获取分页数据,多个字段进行分组去重
  68. $list_config_data = $JdTmaoProductModel->where([['update_time', '<', date('Y-m-d H:i:s', time() - 86400)]])
  69. ->orderby('update_time', 'desc')->paginate($limit, $field, 'page', $page)->toarray();
  70. if (!$list_config_data || empty($list_config_data['data'])) {
  71. $totle_data = isset($this->message_data['total']) ? $this->message_data['total'] : 0;
  72. Log::info('job_info', '采集数据-京东天猫数据同步队列,执行完毕', ['data' => ['page' => $page, 'limit' => $limit, 'totle' => $totle_data], 'message' => '没有数据可同步']);
  73. return true;
  74. }
  75. $total = $list_config_data['total'];
  76. $request_data['data'] = $list_config_data['data'];
  77. $request_data['queue_page'] = $page;
  78. $request_data['queue_limit'] = $limit;
  79. $request_data['queue_total'] = $total;
  80. JdTmaoStoreJobs::dispatch($request_data);
  81. // JdTmaoStoreJobs::dispatchSync($request_data);
  82. Log::info('job_info', '采集数据-京东天猫数据同步队列日志', ['data' => ['page' => $page, 'limit' => $limit, 'totle' => $total]]);
  83. } catch (\Exception $e) {
  84. print_r($e->getMessage());exit;
  85. Log::info('job_error', '采集数据-京东天猫数据同步队列失败', ['error' => $e->getMessage()]);
  86. }
  87. }
  88. }