| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102 | <?phpnamespace App\Console\Commands\Transfer;use App\Transfer\Company;use Illuminate\Console\Command;class TransferOther extends Command{    /**     * The name and signature of the console command.     *     * @var string     */    protected $signature = 'aix:transfer-other';    /**     * 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("清除企业数据表:companys");        //DB::table('companys')->delete();        $this->info("清除企业数据表:companyImg");        //DB::table('companyImg')->delete();        ///其它需要清除的表        $this->info("开始转移数据...");        $total = Company::where(['utype' => 1])->count();        $bar=$this->output->createProgressBar($total);        Company::where(['utype' => 1])->orderBy('uid', 'asc')->chunk(500, function ($companys) use ($bar) {            $company_array=[];            $company_job_array=[];            $company_img_array=[];            /** @var Company $company */            foreach ($companys as $company) {                //处理企业表                $this->handleCompany($company, $company_array);                //处理职业                $this->handleCompanyJob($company->jobs, $company_job_array);                //处理套餐                //处理企业图片...            }            //批量插入数据;            $bar->advance(500);        });        $bar->finish();        $this->line("  完成!");        $this->info("转移企业数据成功.");    }    public function handleCompany($company, &$result_array)    {        $data['id']=$company->uid;        $data['id']="xx";        $data['id']="xx";        $data['id']="xx";        $data['id']="xx";        $result_array[]= $data;    }    public function handleCompanyJob($jobs, &$result_array)    {        foreach ($jobs as $job) {            $data['id']=$job->uid;            $data['id']="xx";            $data['id']="xx";            $data['id']="xx";            $data['id']="xx";            $result_array[]= $data;        }    }}
 |