<?php

use think\migration\Migrator;
use think\migration\db\Column;
use app\model\CustomerPortraitField;
class UpdateDataToCustomerPortraitField extends Migrator
{
    /**
     * Change Method.
     *
     * Write your reversible migrations using this method.
     *
     * More information on writing migrations is available here:
     * http://docs.phinx.org/en/latest/migrations.html#the-abstractmigration-class
     *
     * The following commands can be used in this method and Phinx will
     * automatically reverse them when rolling back:
     *
     *    createTable
     *    renameTable
     *    addColumn
     *    renameColumn
     *    addIndex
     *    addForeignKey
     *
     * Remember to call "create()" or "update()" and NOT "save()" when working
     * with the Table class.
     */
    public function change()
    {
        $field = CustomerPortraitField::where([['keyname','=','group_building']])->select()->toArray();
        $save = [];
        foreach ($field as $v) {
            $save[] = [
                'name' => '建群时间',
                'pid' => $v['pid'],
                'type' => 5,
                'isedit' => 1,
                'isdel' => 1,
                'root_id' => $v['root_id'],
                'status' => $v['status'],
                'keyname' => 'group_building_date',
                'is_status' => 0,
                'isedit_type' => 1,
                'sort' => $v['sort']+1,
                'isadd' => $v['isadd'],
                'is_must' => 1
            ];
        }
        if($save) CustomerPortraitField::insertAll($save);
    }
}