zhijiayun/app/Jobs/Manager/Process/ViolationCompanyJobs.php

<?php

namespace App\Jobs\Manager\Process;

use Illuminate\Bus\Queueable;
use Illuminate\Contracts\Queue\ShouldBeUnique;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Foundation\Bus\Dispatchable;
use Illuminate\Queue\InteractsWithQueue;
use Illuminate\Queue\SerializesModels;
use App\Facades\Servers\Logs\Log;
use App\Models\Manager\WashConfig\ViolationCompany as ViolationCompanyModel;
use App\Models\Manager\Process\ExecuteLog as ExecuteLogModel;
use App\Jobs\Manager\Process\ViolationCompanyDataJobs;

/**
 * 数据清洗-违规挂网公司配置队列
 * @author  唐远望
 * @version 1.0
 * @date  2025-12-11
 */
class ViolationCompanyJobs implements ShouldQueue
{
    use Dispatchable, InteractsWithQueue, Queueable, SerializesModels;
    
    public $tries = 3; // 限制重试次数
    public $timeout = 600; // 10分钟超时

    protected $message_data;
    /**
     * Create a new job instance.
     *
     * @return void
     */
    public function __construct(array $message_data)
    {
        $this->message_data = $message_data;
    }

    /**
     * Execute the job.
     *
     * @return void
     */
    public function handle()
    {
        try {
            $start_time = time() - 60 * 5; // 开始时间 5分钟之前
            $end_time = time(); //结束时间
            $ViolationCompanyModel = new ViolationCompanyModel();
            $limit = isset($this->message_data['limit']) ? $this->message_data['limit'] : 50;
            $page = isset($this->message_data['page']) ? $this->message_data['page'] : 1;
            $executeLog_id = isset($this->message_data['executeLog_id']) ? $this->message_data['executeLog_id'] : 0;
            $admin_id = isset($this->message_data['admin_id']) ? $this->message_data['admin_id'] : 0;
            $is_admin = isset($this->message_data['is_admin']) ? $this->message_data['is_admin'] : 0;
            $company_id = isset($this->message_data['company_id']) ? $this->message_data['company_id'] : 0;
            if($page == 1){
                $ExecuteLogModel = new ExecuteLogModel();
                $insert_data =['company_id'=>$company_id,'name' =>'违规挂网公司店铺', 'code' => 'ViolationCompanyJobs', 'admin_id' => $admin_id,'is_admin' => $is_admin];
                $executeLog_id=$ExecuteLogModel->addExecuteLog_content($insert_data);
            }
            $ViolationCompanyModel = $ViolationCompanyModel->leftjoin('washconfig_company_category', 'washconfig_company_category.id', '=', 'washconfig_violation_company.category_id')
                ->where('washconfig_violation_company.status', 0)->where('company_type', 1)->select(['washconfig_violation_company.*','washconfig_company_category.name as category_name']);
            if($company_id){
                $ViolationCompanyModel = $ViolationCompanyModel->where('washconfig_violation_company.company_id', $company_id);
            }
            $totle_page = 0;
            $list_config_data = $ViolationCompanyModel->paginate($limit, ['*'], 'page', $page)->toarray();
            if (!$list_config_data || empty($list_config_data['data'])) {
                if($page == 1 && $executeLog_id){
                    $ExecuteLogModel->where('id', $executeLog_id)->update(['status' => 0,'update_time'=> time()]);
                }
                return true;
            }
            $totle_page = $list_config_data['last_page'];
            $list_data = $list_config_data['data'];
            foreach ($list_data as $key => $value) {
                $message_data = [
                    'company_id' => $value['company_id'],
                    'id' => $value['id'],
                    'platform' => $value['platform'],
                    'company_type' => $value['company_type'],
                    'company_name' => $value['company_name'],
                    'social_credit_code' => $value['social_credit_code'],
                    'executeLog_id' => $executeLog_id,
                    'company_category_name' => $value['category_name'],
                    'specify_responsible_person' => $value['specify_responsible_person'],
                    'item_totle_page' => $totle_page,
                    'item_now_page' => $page,
                    'start_time' => $start_time,
                    'end_time' => $end_time,
                ];
                ViolationCompanyDataJobs::dispatch($message_data);
                // ViolationCompanyDataJobs::dispatchSync($message_data);
            }
            $now_message_data = [
                'limit' => $limit,
                'page' => $page + 1,
                'executeLog_id' => $executeLog_id,
            ];
            ViolationCompanyJobs::dispatch($now_message_data)->delay(now()->addSeconds(3));
        } catch (\Exception $e) {
            Log::info('job_error', '数据清洗-违规挂网公司队列失败', ['data' => $this->message_data, 'error' => $e->getMessage()]);
        }
    }


    public function failed(\Throwable $exception)
    {
        Log::info('job_error', '数据清洗-违规挂网公司队列完全失败', ['data' => $this->message_data, 'error' => $exception->getMessage()]);
    }
}