crm/database/migrations/20220813084001_update_data_to_train_class_orders.php

<?php

use think\migration\Migrator;
use think\migration\db\Column;
use app\model\TrainClassCate;
use app\model\TrainType;
use app\model\TrainClassAssign;
use app\model\TrainClass;
use app\model\TrainCourse;
use app\model\TrainCourseView;
use app\model\TrainDoneLog;
use app\model\TrainSumup;
use app\model\TrainThumbLog;
use app\model\Camp;
use app\model\CampPlan;
use app\model\CampEmployee;
use app\model\DayStudySetting;
use app\model\DayStudy;
use app\model\Recruit;
class UpdateDataToTrainClassOrders 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()
    {
        //添加排序字段
        $this->table('train_class_cate')
        ->addColumn('order', 'integer',['limit'  => 1,'comment'=>'排序','default'=>0])
        ->update();

        //要修改的店面，装企数字化系统941
        $root_id = 941;

        //,
        $arr = ['销冠分享','网销培训','社群培训','市场培训','营销工具'];

        $where[] = ['root_id','=',$root_id];
        $where[] = ['pid','=',0];

        $cate = TrainClassCate::where($where)->select()->toArray();

        foreach ($cate as $key => $val) {
            $order = array_search($val['name'],$arr);
            $order = $order===false ? 50 : $order;
            TrainClassCate::where('id',$val['id'])->update(['order'=>$order]);
        }

        // //装企数字化系统 课程培训数据覆盖馨居尚
        // //要删除数据的表
        // //fl_train_type，课件场景

        // $del_root_id = 628;//要删除数据的店面

        // $del_where[] = ['root_id','=',$del_root_id];

        // //课件表
        // TrainType::where($del_where)->delete();//课件场景--复制数据
        // TrainCourse::where($del_where)->delete();//课件--复制数据
        // TrainCourseView::where($del_where)->delete();//课件浏览记录
        
        // //课程表
        // TrainClass::where($del_where)->delete();//课程--复制数据
        // TrainClassAssign::where($del_where)->delete();//课程指派记录
        // TrainClassCate::where($del_where)->delete();//课程分类--复制数据
        // TrainDoneLog::where($del_where)->delete();//课程培训记录
        // TrainSumup::where($del_where)->delete();//感悟
        // TrainThumbLog::where($del_where)->delete();//点赞

        // //新兵训练营表
        // Camp::where($del_where)->delete();//训练营
        // CampPlan::where($del_where)->delete();//训练计划
        // CampEmployee::where($del_where)->delete();//训练营指派

        // //每日学练表
        // DayStudySetting::where($del_where)->delete();
        // DayStudy::where($del_where)->delete();

        // //招聘管理表
        // Recruit::where($del_where)->delete();


        // //复制数据
        // $copy_where = ['root_id','=',$root_id];
        
        // //课件分类
        // $train_type = TrainType::where($copy_where)->select()->toArray();
        // foreach ($train_type as $k => $v) {
        //     $train_type[$k]['from_root_id'] = $v['id'];
        //     $train_type[$k]['root_id'] = $del_root_id;
        //     unset($train_type[$k]['id']);
        // }
        // TrainType::insertAll($train_type);

        // //课件
        // $train_course = TrainCourse::where($copy_where)->column('*');
        // foreach ($train_course as $k1 => $v1) {
        //     $query = [];
        //     $query[] = ['root_id','=',$del_root_id];
        //     $query[] = ['from_root_id','=',$v1['type_id']];
        //     $train_course[$k1]['type_id'] = TrainType::where($query)->value('id');
        //     $train_course[$k1]['view'] = $v1['id'];
        //     unset($train_course[$k1]['id']);
        //     $train_course[$k1]['root_id'] = $del_root_id;
        //     unset($query);
        // }
        // TrainCourse::insertAll($train_course);

        // //课程分类
        // $train_class_cate = TrainClassCate::where($copy_where)->select()->toArray();
        
        // foreach ($train_class_cate as $k2 => $v2) {
        //     $train_class_cate[$k2]['son'] = [];
        //     //查询是否存在
        //     if ($v['pid']==0) {
        //         foreach ($train_class_cate as $k3 => $v3) {
        //             if ($v2['id']==$v3['pid']) {
        //                 $train_class_cate[$k2]['son'][] = $v3;
        //             }
        //         }
        //     }
        // }
        // foreach ($train_class_cate as $k4 => $v4) {
        //     if ($v4['pid']==0) {
        //         //查询一级是否存在
        //         $query = [];
        //         $query[] = ['root_id','=',$del_root_id];
        //         $query[] = ['name','=',$v4['name']];
        //         $query[] = ['pid','=',0];
        //         $find = TrainClassCate::where($query)->findOrEmpty();
        //         unset($query);
        //         if ($find->isEmpty()) {
        //             $save = [];
        //             $save['root_id'] = $del_root_id;
        //             $save['name'] = $v4['name'];
        //             $pid = TrainClassCate::insertGetId($save);
        //             unset($save);
        //             if ($v4['son']) {
        //                 $saves = [];
        //                 foreach ($v4['son'] as $k5 => $v5) {
        //                     $saves[] = [
        //                         'pid' => $pid,
        //                         'root_id' => $del_root_id,
        //                         'name' => $v5['name']
        //                     ];
        //                 }
        //                 if($saves) TrainClassCate::insertAll($saves);
        //                 unset($saves);
        //             }
        //         }else{
        //             $pid = $find->id;
        //             if ($v4['son']) {
        //                 $saves = [];
        //                 foreach ($v4['son'] as $k6 => $v6) {
        //                     //查询二级是否存在
        //                     $query = [];
                            
        //                     $query[] = ['root_id','=',$del_root_id];
        //                     $query[] = ['name','=',$v4['name']];
        //                     $query[] = ['pid','=',$pid];
        //                     $find = TrainClassCate::where($query)->findOrEmpty();
        //                     if ($find->isEmpty()) {
        //                         $saves[] = [
        //                             'pid' => $pid,
        //                             'root_id' => $del_root_id,
        //                             'name' => $v6['name']
        //                         ];
        //                     }

        //                 }

        //                 if($saves) TrainClassCate::insertAll($saves);
        //                 unset($saves);
        //             }
        //         }
        //     }
        // }

        // //课程
        // $train_class = TrainClass::where($copy_where)->select()->toArray();
        // foreach ($train_class as $k7 => $v7) {
            
        // }
        



    }
}