<?php

namespace 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;
        }
    }

}