crm/database/migrations/20220721082310_update_grent_company_per.php

<?php

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

class UpdateGrentCompanyPer 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()
    {
        $per_ids1 = Permission::where([['auth_name', 'in', ['企业话术库', '集团大学', '集团管理', '店面管理', '品牌管理', '课件添加', '课件删除', '课程添加', '课程删除', '集团课程', '店面课程', '店面话术']]])->order('id asc')->column('id');
        $per_ids2 = Permission::where([['auth_name', '=', '每日朋友圈'], ['uri', '=', 'material/group_wechat_list']])->value('id');

        $par_id = Permission::where('auth_name', '=', '企业话术库')->value('id');
        $find = Permission::where([['auth_name', '=', '话术管理'], ['uri', '=', 'talkskill/groupTalkskillLabel']])->findOrEmpty();
        if ($find->isEmpty()) {
            $data = [
                'pid' => $par_id,
                'auth_name'=> '话术管理',
                'uri' => 'talkskill/groupTalkskillLabel',
                'is_menu' => 1,
                'sort'=> 50,
                'relation' => 'talkskill/cate_talkskill_list,talkskill/importing,talkskill/talkskilladd,talkskill/cate_talkskill_add,talkskill/cate_talkskill_edit,talkskill/add_talkskill,talkskill/label_list,talkskill/groupTalkskillList,talkskill/talkskilldel,talkskill/talkskilldetail,talkskill/talkskill_delete,talkskill/groupShareCompany,talkskill/groupAssignAdd,talkskill/system'
            ];
            $per_ids3 = Permission::insertGetId($data);
        } else {
            $per_ids3 = $find['id'];
        }
        $grant = Grant::where([['name', '=', '集团管理员'], ['root_id', '=', 0]])->find();
        $per_ids = array_merge($per_ids1, [intval($per_ids2), intval($per_ids3)]);
        $grant->permission = array_values(array_filter(array_unique($per_ids)));
        $grant->save();
    }
}