crm/database/migrations/20230518171606_add_office_statistics_permission.php

<?php

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

class AddOfficeStatisticsPermission 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()
    {
        $pid = (new Permission())->where('auth_name', '=', '线上巡店')->value('id');
        $data['pid'] = $pid;
        $data['auth_name'] = '总经办报表';
        $data['uri'] = 'statistics/officeStatistics';
        $data['is_menu'] = 0;
        $data['sort'] = 50;
        $data['relation'] = 'statistics/officeStatistics,statistics/office_table_data';
        $result = Permission::create($data);
        // 要添加权限的企业
        $c = [941, 1847, 1977]; // 馨居尚组织跟id 菡萏怡景组织跟id 臻品软装组织跟id
        foreach($c as $k=>$v){
            $grant = Grant::where([['root_id','=',$v],['type','=','m']])->find();
            $permission = array_merge(json_decode(json_encode($grant->permission), true),[$result->id]);
            asort($permission);
            $grant->permission = array_values($permission);
            $grant->save();
        }
    }
}