crm/database/migrations/20221004111323_add_field_to_portrait_field_table.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\CustomerPortraitFieldSelect;

class AddFieldToPortraitFieldTable 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()
    {
        $defaultFields = [
            [
            'name'=>'基本信息',
            'keyname'=>'basic_info',
            'sort'=>1,
            'value'=>[
                ['name' => '姓名', 'type'=>1,'isedit' =>1,'keyname'=>'name','isdel' =>1,'status' => 0, 'select' =>null,'unity'=>'','is_status'=>1,'isedit_type'=>1,'sort'=>1],
                ['name' => '手机号', 'type'=>2,'isedit' => 1,'keyname'=>'phone','isdel' =>1, 'status' => 0, 'select' => null,'unity'=>'','is_status'=>1,'isedit_type'=>1,'sort'=>2],
                ['name' => '性别', 'type'=>3,'isedit' => 1, 'keyname'=>'sex','isdel' =>1,'status' => 0, 'select' => ['男', '女'],'unity'=>'','is_status'=>1,'isedit_type'=>1,'sort'=>3],
                ['name' => '客户等级','type'=>3,'isedit' => 1,'keyname'=>'level', 'isdel' =>1,'status' => 0, 'select' => ['A类', 'B类', 'C类','D类'],'unity'=>'','is_status'=>1,'isedit_type'=>1,'sort'=>5],
                ['name' => '装修意向', 'type'=>3,'isedit' =>0, 'keyname'=>'intention','isdel' =>1,'status' => 0, 'select' => ['非常高', '高', '中', '低'],'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>6],
                ['name' => '是否添加微信', 'type'=>3,'isedit'=>0,'keyname'=>'wechat','isdel' =>1, 'status' => 0, 'select' => ['是', '否'],'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>20],
                ['name' => '客户关注点', 'type'=>4,'isedit'=>0,'keyname'=>'follow','isdel' =>1, 'status' => 0, 'select' => ['服务流程', '设计方案', '施工质量', '施工材料', '工期长短', '售后服务', '其他'],'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>18],
                ['name' => '客户痛点', 'type'=>4,'isedit'=>0,'keyname'=>'point','isdel' =>1, 'status' => 0, 'select' => ['工艺', '环保', '质量', '恶意增项', '工期延期', '其他'],'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>19],
                ['name' => '客户来源', 'type'=>3,'isedit'=>1,'keyname'=>'source_id','isdel' =>1, 'status' => 0, 'select' => null,'unity'=>'','is_status'=>1,'isedit_type'=>1,'sort'=>9],
                ['name' => '是否首次装修', 'type'=>3,'isedit'=>0,'keyname'=>'first','isdel' =>1, 'status' => 0, 'select' => ['是', '否'],'unity'=>'','is_status'=>1,'isedit_type'=>1,'sort'=>10],
                ['name' => '年龄', 'type'=>3,'isedit'=>0,'keyname'=>'age_range','isdel' =>1, 'status' => 0, 'select' => ['20岁以下', '20-30岁', '30-40岁', '40-50岁', '50-60岁', '60岁以上'],'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>4],
                ['name' => '当前所在区域', 'type'=>3,'isedit'=>0,'keyname'=>'current_region','isdel' =>1, 'status' => 0, 'select' => ['其他'],'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>8],
                ['name' => '加微类型', 'type'=>3,'isedit'=>1,'keyname'=>'add_wechat_type','isdel' =>1, 'status' => 0, 'select' => ['常规加微','社群加微'],'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>11],
                ['name' => '加微时间', 'type'=>5,'isedit'=>1,'keyname'=>'add_wechat_time','isdel' =>1, 'status' => 0, 'select' => ['常规加微','社群加微'],'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>12],
                ['name' => '建群情况', 'type'=>4,'isedit'=>0,'keyname'=>'group_building','isdel' =>1, 'status' => 0, 'select' => ['1对1小群', '临时大群', '社群'],'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>13],
                ['name' => '直播情况', 'type'=>4,'isedit'=>1,'keyname'=>'live_broadcast','isdel' =>1, 'status' => 0, 'select' => ['1对1业务直播', '1对1设计直播', '一对多直播'],'unity'=>'','is_status'=>1,'isedit_type'=>1,'sort'=>14],
                ['name' => '业务直播人员', 'type'=>1,'isedit'=>1,'keyname'=>'live_broadcast_business','isdel' =>1, 'status' => 0, 'select' => null,'unity'=>'','is_status'=>1,'isedit_type'=>1,'sort'=>15],
                ['name' => '设计直播人员', 'type'=>1,'isedit'=>1,'keyname'=>'live_broadcast_design','isdel' =>1, 'status' => 0, 'select' => null,'unity'=>'','is_status'=>1,'isedit_type'=>1,'sort'=>16],
                ['name' => '直播人员', 'type'=>1,'isedit'=>1,'keyname'=>'live_broadcast_personnel','isdel' =>1, 'status' => 0, 'select' => null,'unity'=>'','is_status'=>1,'isedit_type'=>1,'sort'=>17],
                ['name' => '谈单时长', 'type'=>1,'isedit'=>0,'keyname'=>'talking_about_single_time','isdel' =>1, 'status' => 0, 'select' => null,'unity'=>'分钟','is_status'=>0,'isedit_type'=>1,'sort'=>21],
                ['name' => '消费水平', 'type'=>3,'isedit'=>0,'keyname'=>'consumption_capacity','isdel' =>1, 'status' => 0, 'select' => ['高', '中', '低'],'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>7]
                ]
            ],
            [
                'name'=>'房屋信息',
                'keyname'=>'house_info',
                'sort'=>2,
                'value' => [
                    ['name' => '小区名称', 'type'=>1,'isedit'=>0,'keyname'=>'community_name','isdel' =>1, 'status' => 0, 'select' => null,'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>1],
                    ['name' => '门牌单元号', 'type'=>1,'isedit'=>0,'keyname'=>'unit_number','isdel' =>1, 'status' => 0, 'select' => null,'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>2],
                    ['name' => '请选择房屋户型', 'type'=>3,'isedit'=>0,'keyname'=>'housetype_arrow','isdel' =>1, 'status' => 0, 'select' => ['1居室', '2居室', '3居室', '4居室', '其他'],'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>5],
                    ['name' => '面积', 'type'=>1,'isedit'=>0,'keyname'=>'square','isdel' =>1,'status' => 0, 'select' => null,'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>4],
                    ['name' => '装修预算', 'type'=>2,'isedit'=>0,'keyname'=>'budget','isdel' =>1, 'status' => 0, 'select' => null,'unity'=>'万元','is_status'=>0,'isedit_type'=>1,'sort'=>11],
                    ['name' => '请选择倾向风格', 'type'=>3,'isedit'=>0,'keyname'=>'deco_style','isdel' =>1, 'status' => 0, 'select' => null,'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>6],
                    ['name' => '客户喜欢的色调', 'type'=>3,'isedit'=>0,'keyname'=>'like_color','isdel' =>1, 'status' => 0, 'select' => ['黄色调', '红色调', '蓝色调', '橙色调', '绿色调', '紫色调', '白色调', '灰色调'],'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>16],
                    ['name' => '房屋类型', 'type'=>3,'isedit'=>1,'keyname'=>'house_type','isdel' =>1,'status' => 0, 'select' => ['现房', '期房', '二手房'],'unity'=>'','is_status'=>1,'isedit_type'=>1,'sort'=>7],
                    ['name' => '房屋状态', 'type'=>3,'isedit'=>0,'keyname'=>'house_status','isdel' =>1, 'status' => 0, 'select' => ['毛坯', '精装', '老房'],'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>9],
                    ['name' => '房屋结构', 'type'=>3,'isedit'=>0,'keyname'=>'house_structure','isdel' =>1, 'status' => 0, 'select' => ['公寓', '商品房', '别墅', '自建'],'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>14],
                    ['name' => '预计交房时间', 'type'=>5,'isedit'=>1,'keyname'=>'house_delivery_time','isdel' =>1, 'status' => 0, 'select' => null,'unity'=>'','is_status'=>1,'isedit_type'=>1,'sort'=>8],
                    ['name' => '预计装修时间', 'type'=>5,'isedit'=>1,'keyname'=>'plan_deco_time','isdel' =>1, 'status' => 0, 'select' => null,'unity'=>'','is_status'=>1,'isedit_type'=>1,'sort'=>10],
                    ['name' => '装修方式', 'type'=>3,'isedit'=>0,'keyname'=>'decoration_mode','isdel' =>1, 'status' => 0, 'select' => ['半包', '整装', '套餐'],'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>15],
                    ['name' => '客户其它需求', 'type'=>1,'isedit'=>0,'keyname'=>'customer_demand','isdel' =>1, 'status' => 0, 'select' => null,'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>17],
                    ['name' => '房屋用途', 'type'=>3,'isedit'=>0,'keyname'=>'housing_use','isdel' =>1, 'status' => 0, 'select' => ['自用', '出租'],'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>12],
                    ['name' => '房屋位置', 'type'=>1,'isedit'=>1,'keyname'=>'house_location','isdel' =>1, 'status' => 0, 'select' => null,'unity'=>'','is_status'=>1,'isedit_type'=>1,'sort'=>3],
                    ['name' => '其他房屋信息', 'type'=>1,'isedit'=>0,'keyname'=>'remarks_on_other_house_information','isdel' =>1, 'status' => 0, 'select' => null,'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>18],
                    ['name' => '周边配套', 'type'=>4,'isedit'=>0,'keyname'=>'peripheral_supporting','isdel' =>1, 'status' => 0, 'select' => ['商业', '教育', '交通', '资源', '其他'],'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>13]
                ]
            ],
            [
            'name'=>'家庭信息',
            'keyname'=>'family_info',
            'sort'=>3,
            'value'=> [
                ['name' => '家庭结构', 'type'=>3,'isedit'=>0,'keyname'=>'family_structure','isdel' =>1, 'status' => 0, 'select' => ['新婚夫妇', '三口之家', '四口之家', '其他'],'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>6,'sort'=>1],
                ['name' => '家庭成员意见', 'type'=>3,'isedit'=>0,'keyname'=>'family_opinion','isdel' =>1, 'status' => 0, 'select' => ['非常满意', '满意', '一般', '不满意'],'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>3],
                ['name' => '决策人', 'type'=>3,'isedit'=>0,'keyname'=>'decision_maker','isdel' =>1, 'status' => 0, 'select' => ['老婆', '丈夫', '父亲', '孩子'],'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>2],
                ['name' => '客户爱好', 'type'=>1,'isedit'=>0,'keyname'=>'hobby','isdel' =>1, 'status' => 0, 'select' => null,'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>7],
                ['name' => '客户空闲时段', 'type'=>1,'isedit'=>0,'keyname'=>'free_time','isdel' =>1, 'status' => 0, 'select' => null,'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>8],
                ['name' => '汽车价格', 'type'=>2,'isedit'=>0,'keyname'=>'car_price','isdel' =>1, 'status' => 0, 'select' => null,'unity'=>'元','is_status'=>0,'isedit_type'=>1,'sort'=>5],
                ['name' => '房屋价格', 'type'=>2,'isedit'=>0,'keyname'=>'hourse_price','isdel' =>1, 'status' => 0, 'select' => null,'unity'=>'元','is_status'=>0,'isedit_type'=>1,'sort'=>4],
                ['name' => '买小区的原因', 'type'=>1,'isedit'=>0,'keyname'=>'buying_community','isdel' =>1, 'status' => 0, 'select' => null,'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>6]
            ]
            ],
            [
            'name'=>'关注点',
            'keyname'=>'behavioral_info',
            'sort'=>4,
            'value' => [
                ['name' => '重视环保', 'type'=>3,'isedit'=>0,'keyname'=>'environmental_requirements','isdel' =>1, 'status' => 0, 'select' => ['非常重视', '重视', '一般', '不重视'],'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>1],
                ['name' => '关注的工艺', 'type'=>3,'isedit'=>0,'keyname'=>'workmanship','isdel' =>1, 'status' => 0, 'select' => ['水电工艺', '木工工艺', '泥工工艺', '油漆工艺', '吊顶工艺', '防水工艺'],'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>3],
                ['name' => '重视设计', 'type'=>3,'isedit'=>0,'keyname'=>'design','isdel' =>1, 'status' => 0, 'select' => ['非常重视', '重视', '一般', '不重视'],'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>2],
                ['name' => '关注房屋的空间', 'type'=>4,'isedit'=>0,'keyname'=>'space_design','isdel' =>1, 'status' => 0, 'select' => ['客厅', '卧室', '卫生间', '厨房', '阳台', '其他'],'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>4]
            ]
            ],
            [
            'name'=>'客户满意度',
            'keyname'=>'evaluate_info',
            'sort'=>5,
            'value' => [
                ['name' => '设计师服务', 'type'=>3,'isedit'=>0,'keyname'=>'service_satisfaction','isdel' =>1, 'status' => 0, 'select' => ['非常好', '好', '一般', '不满意'],'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>1],
                ['name' => '报价满意度', 'type'=>3,'isedit'=>0,'keyname'=>'quotation_satisfaction','isdel' =>1, 'status' => 0, 'select' => ['非常好', '好', '一般', '不满意'],'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>2],
                ['name' => '方案满意度', 'type'=>3,'isedit'=>0,'keyname'=>'program_satisfaction','isdel' =>1, 'status' => 0, 'select' => ['非常好', '好', '一般', '不满意'],'unity'=>'','is_status'=>0,'isedit_type'=>1,'sort'=>3]
    
            ]
            ]
        ];
        $fieldmod = new CustomerPortraitFieldSelect;
        $list= Company::field('id,root_id,company_name')->select()->toArray();
        foreach($list as $p=>$m){
            $root_id=$m['root_id'];
        foreach($defaultFields as $key=>$val){
            $parent = CustomerPortraitField::create([
                'name' => $val['name'],
                'pid' => 0,
                'type' => 1,
                'isedit' => 0,
                'root_id' => $root_id,
                'status'=>0,
                'isdel'=>1,
                'keyname'=>$val['keyname'],
                'sort'=>$val['sort']
            ]);
            $pid=$parent->id;
            
            foreach($val['value'] as $k=>$v){
                $add=['name'=>$v['name'],'pid'=>$pid,'type'=>$v['type'],'isedit'=>$v['isedit'],'root_id'=>$root_id,'status'=>$v['status'],'isdel'=>$v['isdel'],'keyname'=>$v['keyname'],'unity'=>$v['unity'],'is_status'=>$v['is_status'],'isedit_type'=>$v['isedit_type'],'sort'=>$v['sort']];
                $cp=CustomerPortraitField::create($add);
                $all=[];
                if(!empty($v['select'])){
                    foreach($v['select'] as $e=>$r){
                        $all[]=['name'=>$r,'pid'=>$cp->id];
                    }
                    $childObjs = $fieldmod->saveAll($all);
                }
    
            }
        }
        }
    }
}