jucai/app/Console/Commands/Transfer/TransNewJobs.php

<?php

namespace App\Console\Commands\Transfer;

use App\Models\MemberInfo;
use App\Models\MembersLog;
use App\Models\MembersPoint;
use App\Models\PersonalServiceStick;
use App\Models\PersonalServiceStickLog;
use App\Models\PersonalServiceTag;
use App\Models\PersonalServiceTagLog;
use App\Models\PersonFavorite;
use App\Models\PersonFocusCompany;
use App\Models\PersonJobsSubscribe;
use App\Models\Resume;
use App\Models\ResumeCredent;
use App\Models\ResumeEducation;
use App\Models\ResumeLanguage;
use App\Models\ResumeTrain;
use App\Models\ResumeWork;
use App\Models\SubsiteResume;
use App\Models\Thirdlogin;
use App\Models\ViewJob;
use App\Transfer\CompanyStatistics;
use App\Transfer\Jobs;
use App\Transfer\Member;
use App\Transfer\MemberBind;
use App\Transfer\MemberLog;
use App\Transfer\Msg;
use App\Transfer\PersonalFavorite;
use App\Transfer\PersonalFocusCompany;
use App\Transfer\PersonalJobsApply;
use App\Transfer\PersonalJobsSubscribe;
use App\Transfer\PersonalStickLog;
use App\Transfer\PersonalTagLog;
use App\Transfer\ResumeImg;
use App\Transfer\ViewJobs;
use App\Transfer\ViewResume;
use Illuminate\Console\Command;
use Illuminate\Support\Facades\DB;

class TransNewJobs extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'aix:transfer-jobs-new';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = '转移旧系统市辖区职位数据';

    /**
     * Create a new command instance.
     *
     * @return void
     */
    public function __construct()
    {
        parent::__construct();
    }

    /**
     * Execute the console command.
     *
     * @return mixed
     */
    public function handle()
    {
        $this->info("开始更新职位市辖区数据...");
        $total = Jobs::where('sdistrict',556)->get()->count();
        $bar=$this->output->createProgressBar($total);
        Jobs::where('sdistrict',556)->orderBy('id', 'asc')->chunk(1000, function ($jobs) use ($bar) {
            $jobs_arr = [];
            $this->handelJobs($jobs, $jobs_arr);

            if ($jobs_arr) {
                \App\Models\Jobs::whereIn('id',$jobs_arr)->update(['district'=>'11.129.1311']);
            }
            $bar->advance(1000);
        });
        $bar->finish();
        $this->line("  完成!");
        $this->info("更新职位市辖区数据成功.");
    }

    public function handelJobs($jobs, &$jobs_arr)
    {
        if (!$jobs->isEmpty()) {
            foreach ($jobs as $job) {
                $jobs_arr[] = $job->id;
            }
        }

    }




}