crm/database/migrations/20230526105806_save_old_visitlog_customer_employee_id.php

<?php

use app\model\Grant;
use app\model\Permission;
use think\migration\Migrator;
use think\migration\db\Column;
use app\model\CustomerVisitLog;

class SaveOldVisitlogCustomerEmployeeId extends Migrator
{
    public function change()
    {
        $state1 = CustomerVisitLog::changeState('已到店','chaos');
        $state2 = CustomerVisitLog::changeState('已交定','chaos');
        $state3 = CustomerVisitLog::changeState('已签单','chaos');
        $state4 = CustomerVisitLog::changeState('已量房','chaos');
        $state5 = CustomerVisitLog::changeState('已到场','chaos');
        $list = CustomerVisitLog::where([['customer_employee_id','=',0],['state','in',array_merge($state1,$state2,$state3,$state4,$state5)]])->column('id,employee_id,org_id');
        foreach($list as $key=>$val){
            $all[] = ['id'=>$val['id'],'customer_employee_id'=>$val['employee_id'],'customer_org_id'=>$val['org_id']];
        }
        $mod = new CustomerVisitLog;
        $mod->saveAll($all);
    }

}