ViolationCompanyJobs.php 4.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108
  1. <?php
  2. namespace App\Jobs\Manager\Process;
  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\WashConfig\ViolationCompany as ViolationCompanyModel;
  11. use App\Models\Manager\Process\ExecuteLog as ExecuteLogModel;
  12. use App\Jobs\Manager\Process\ViolationCompanyDataJobs;
  13. /**
  14. * 数据清洗-违规挂网公司配置队列
  15. * @author 唐远望
  16. * @version 1.0
  17. * @date 2025-12-11
  18. */
  19. class ViolationCompanyJobs implements ShouldQueue
  20. {
  21. use Dispatchable, InteractsWithQueue, Queueable, SerializesModels;
  22. public $tries = 3; // 限制重试次数
  23. public $timeout = 600; // 10分钟超时
  24. protected $message_data;
  25. /**
  26. * Create a new job instance.
  27. *
  28. * @return void
  29. */
  30. public function __construct(array $message_data)
  31. {
  32. $this->message_data = $message_data;
  33. }
  34. /**
  35. * Execute the job.
  36. *
  37. * @return void
  38. */
  39. public function handle()
  40. {
  41. try {
  42. $ViolationCompanyModel = new ViolationCompanyModel();
  43. $limit = isset($this->message_data['limit']) ? $this->message_data['limit'] : 50;
  44. $page = isset($this->message_data['page']) ? $this->message_data['page'] : 1;
  45. $executeLog_id = isset($this->message_data['executeLog_id']) ? $this->message_data['executeLog_id'] : 0;
  46. $admin_id = isset($this->message_data['admin_id']) ? $this->message_data['admin_id'] : 0;
  47. $is_admin = isset($this->message_data['is_admin']) ? $this->message_data['is_admin'] : 0;
  48. $company_id = isset($this->message_data['company_id']) ? $this->message_data['company_id'] : 0;
  49. if($page == 1){
  50. $ExecuteLogModel = new ExecuteLogModel();
  51. $insert_data =['company_id'=>$company_id,'name' =>'违规挂网公司店铺', 'code' => 'ViolationCompanyJobs', 'admin_id' => $admin_id,'is_admin' => $is_admin];
  52. $executeLog_id=$ExecuteLogModel->addExecuteLog_content($insert_data);
  53. }
  54. $ViolationCompanyModel = $ViolationCompanyModel->leftjoin('washconfig_company_category', 'washconfig_company_category.id', '=', 'washconfig_violation_company.category_id')
  55. ->where('washconfig_violation_company.status', 0)->where('company_type', 1)->select(['washconfig_violation_company.*','washconfig_company_category.name as category_name']);
  56. if($company_id){
  57. $ViolationCompanyModel = $ViolationCompanyModel->where('washconfig_violation_company.company_id', $company_id);
  58. }
  59. $totle_page = 0;
  60. $list_config_data = $ViolationCompanyModel->paginate($limit, ['*'], 'page', $page)->toarray();
  61. if (!$list_config_data || empty($list_config_data['data'])) {
  62. if($page == 1 && $executeLog_id){
  63. $ExecuteLogModel->where('id', $executeLog_id)->update(['status' => 0,'update_time'=> time()]);
  64. }
  65. return true;
  66. }
  67. $totle_page = $list_config_data['last_page'];
  68. $list_data = $list_config_data['data'];
  69. foreach ($list_data as $key => $value) {
  70. $message_data = [
  71. 'company_id' => $value['company_id'],
  72. 'id' => $value['id'],
  73. 'platform' => $value['platform'],
  74. 'company_type' => $value['company_type'],
  75. 'company_name' => $value['company_name'],
  76. 'social_credit_code' => $value['social_credit_code'],
  77. 'executeLog_id' => $executeLog_id,
  78. 'company_category_name' => $value['category_name'],
  79. 'specify_responsible_person' => $value['specify_responsible_person'],
  80. 'item_totle_page' => $totle_page,
  81. 'item_now_page' => $page,
  82. ];
  83. ViolationCompanyDataJobs::dispatch($message_data);
  84. // ViolationCompanyDataJobs::dispatchSync($message_data);
  85. }
  86. $now_message_data = [
  87. 'limit' => $limit,
  88. 'page' => $page + 1,
  89. 'executeLog_id' => $executeLog_id,
  90. ];
  91. ViolationCompanyJobs::dispatch($now_message_data)->delay(now()->addSeconds(1));
  92. } catch (\Exception $e) {
  93. Log::info('job_error', '数据清洗-违规挂网公司队列失败', ['data' => $this->message_data, 'error' => $e->getMessage()]);
  94. }
  95. }
  96. public function failed(\Throwable $exception)
  97. {
  98. Log::info('job_error', '数据清洗-违规挂网公司队列完全失败', ['data' => $this->message_data, 'error' => $exception->getMessage()]);
  99. }
  100. }