crm/database/migrations/20230503104406_save_oldtwo_empvslog_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\CustomerPortraitField;
use app\model\Company;
use app\model\CompanyVrshow;
use app\model\CustomerVisitLog;

class SaveOldtwoEmpvslogCustomerEmployeeId extends Migrator
{
    public function change()
    {
        //修改水晶石的梁庆尤原客户的vslog所属员工id为新交接的员工王武id
        CustomerVisitLog::where([['customer_employee_id','=',8870]])->update(['customer_employee_id'=>6256]);
        //修改水晶石的陆夏光原客户的vslog所属员工id为新交接的员工王雷id
        CustomerVisitLog::where([['customer_employee_id','=',10035]])->update(['customer_employee_id'=>4333]);
        //修改水晶石的陆经理原客户的vslog所属员工id为新交接的员工王雷id
        CustomerVisitLog::where([['customer_employee_id','=',9185]])->update(['customer_employee_id'=>4333]);
    }

}