qimall/console/migrations/M230712024155InsertQimallRabcAuthItem.php

<?php

namespace app\migrations;

use yii\db\Migration;

/**
 * Class M230712024155InsertQimallRabcAuthItem
 */
class M230712024155InsertQimallRabcAuthItem extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        try {
            $sql="INSERT INTO `qimall_rbac_auth_item` ( `name`, `title`, `app_id`, `addons_name`, `pid`, `level`, `is_addon`, `sort`, `tree`, `status`, `created_at`, `updated_at`, `cate_id`) VALUES ( 'admin/setting/notice-del', '删除', 'backend', '', 3848, 3, 0, 999, 'tr_0 tr_3413 tr_3848 ', 1, 1689129573, 1689129573, 1);";
            $this->execute($sql);

            $sql="INSERT INTO `qimall_rbac_auth_item` ( `name`, `title`, `app_id`, `addons_name`, `pid`, `level`, `is_addon`, `sort`, `tree`, `status`, `created_at`, `updated_at`, `cate_id`) VALUES ( 'admin/setting/notice-edit', '新增/编辑', 'backend', '', 3848, 3, 0, 999, 'tr_0 tr_3413  tr_3848', 1, 1689129562, 1689129585, 1);";
            $this->execute($sql);

            $sql="INSERT INTO `qimall_rbac_auth_item` ( `name`, `title`, `app_id`, `addons_name`, `pid`, `level`, `is_addon`, `sort`, `tree`, `status`, `created_at`, `updated_at`, `cate_id`) VALUES ( 'admin/task/executed-record-del', '删除', 'backend', '', 274262, 3, 0, 999, 'tr_0tr_2499 tr_274262 ', 1, 1689128073, 1689128073, 1);";
            $this->execute($sql);

            $sql="INSERT INTO `qimall_rbac_auth_item` ( `name`, `title`, `app_id`, `addons_name`, `pid`, `level`, `is_addon`, `sort`, `tree`, `status`, `created_at`, `updated_at`, `cate_id`) VALUES ( 'admin/task/executed-detail', '查看详情', 'backend', '', 274262, 3, 0, 999, 'tr_0tr_2499 tr_274262 ', 1, 1689128049, 1689128049, 1);";
            $this->execute($sql);

            $sql="INSERT INTO `qimall_rbac_auth_item` ( `name`, `title`, `app_id`, `addons_name`, `pid`, `level`, `is_addon`, `sort`, `tree`, `status`, `created_at`, `updated_at`, `cate_id`) VALUES ( 'admin/task/delete', '删除', 'backend', '', 274261, 3, 0, 999, 'tr_0tr_2499 tr_274261 ', 1, 1689128024, 1689128024, 1);";
            $this->execute($sql);

            $sql="INSERT INTO `qimall_rbac_auth_item` ( `name`, `title`, `app_id`, `addons_name`, `pid`, `level`, `is_addon`, `sort`, `tree`, `status`, `created_at`, `updated_at`, `cate_id`) VALUES ( 'admin/task/edit', '新增/编辑', 'backend', '', 274261, 3, 0, 999, 'tr_0tr_2499 tr_274261 ', 1, 1689127985, 1689127985, 1);";
            $this->execute($sql);

            $sql="INSERT INTO `qimall_rbac_auth_item` ( `name`, `title`, `app_id`, `addons_name`, `pid`, `level`, `is_addon`, `sort`, `tree`, `status`, `created_at`, `updated_at`, `cate_id`) VALUES ( 'admin/task/executed-list', '任务记录', 'backend', '', 2499, 2, 0, 999, 'tr_0tr_2499 ', 1, 1689127965, 1689127965, 1);";
            $this->execute($sql);

            $sql="INSERT INTO `qimall_rbac_auth_item` ( `name`, `title`, `app_id`, `addons_name`, `pid`, `level`, `is_addon`, `sort`, `tree`, `status`, `created_at`, `updated_at`, `cate_id`) VALUES ( 'admin/task/index', '任务列表', 'backend', '', 2499, 2, 0, 999, 'tr_0tr_2499 ', 1, 1689127943, 1689127943, 1);";
            $this->execute($sql);

            $sql="INSERT INTO `qimall_rbac_auth_item` ( `name`, `title`, `app_id`, `addons_name`, `pid`, `level`, `is_addon`, `sort`, `tree`, `status`, `created_at`, `updated_at`, `cate_id`) VALUES ( 'admin/account/del', '删除', 'backend', '', 2264, 4, 0, 999, 'tr_0 tr_2278 tr_2262 tr_2264 ', 1, 1689127130, 1689127130, 1);";
            $this->execute($sql);

            $sql="INSERT INTO `qimall_rbac_auth_item` ( `name`, `title`, `app_id`, `addons_name`, `pid`, `level`, `is_addon`, `sort`, `tree`, `status`, `created_at`, `updated_at`, `cate_id`) VALUES ( 'admin/account/edit', '新增/编辑', 'backend', '', 2264, 4, 0, 999, 'tr_0 tr_2278 tr_2262  tr_2264', 1, 1689127115, 1689127239, 1);";
            $this->execute($sql);

            $sql="INSERT INTO `qimall_rbac_auth_item` ( `name`, `title`, `app_id`, `addons_name`, `pid`, `level`, `is_addon`, `sort`, `tree`, `status`, `created_at`, `updated_at`, `cate_id`) VALUES ( 'admin/account/edit', '新增/编辑', 'backend', '', 2264, 4, 0, 999, 'tr_0 tr_2278 tr_2262  tr_2264', 1, 1689127115, 1689127239, 1);";
            $this->execute($sql);

            $sql="UPDATE qimall_rbac_auth_item set name = 'admin/setting/index',title = '系统设置' where id = 3414";
            $this->execute($sql);

            $sql="INSERT INTO `qimall_rbac_auth_item` ( `name`, `title`, `app_id`, `addons_name`, `pid`, `level`, `is_addon`, `sort`, `tree`, `status`, `created_at`, `updated_at`, `cate_id`) VALUES ( 'mall/data-census/driving-window', '总裁驾驶窗', 'backend', '', 2816, 2, 0, 999, 'tr_0tr_2816 ', 1, 1689130872, 1689130872, 2);";
            $this->execute($sql);

            $sql="INSERT INTO `qimall_rbac_auth_item` ( `name`, `title`, `app_id`, `addons_name`, `pid`, `level`, `is_addon`, `sort`, `tree`, `status`, `created_at`, `updated_at`, `cate_id`) VALUES ( 'mall/data-census/flowan-alyse', '流量分析', 'backend', '', 274269, 3, 0, 999, 'tr_0tr_2816 tr_274269 ', 1, 1689131666, 1689131666, 2);";
            $this->execute($sql);

            $sql="INSERT INTO `qimall_rbac_auth_item` ( `name`, `title`, `app_id`, `addons_name`, `pid`, `level`, `is_addon`, `sort`, `tree`, `status`, `created_at`, `updated_at`, `cate_id`) VALUES ( 'mall/data-census/goods-statistics', '商品数据', 'backend', '', 274269, 3, 0, 999, 'tr_0tr_2816 tr_274269 ', 1, 1689131684, 1689131684, 2);";
            $this->execute($sql);

            $sql="INSERT INTO `qimall_rbac_auth_item` ( `name`, `title`, `app_id`, `addons_name`, `pid`, `level`, `is_addon`, `sort`, `tree`, `status`, `created_at`, `updated_at`, `cate_id`) VALUES ( 'mall/statistics/car-user-data', '会员分析', 'backend', '', 274269, 3, 0, 999, 'tr_0tr_2816 tr_274269 ', 1, 1689131699, 1689131699, 2);";
            $this->execute($sql);


            $sql="INSERT INTO `qimall_rbac_auth_item` ( `name`, `title`, `app_id`, `addons_name`, `pid`, `level`, `is_addon`, `sort`, `tree`, `status`, `created_at`, `updated_at`, `cate_id`) VALUES ( 'mall/statistics/car-user-trad-data', '交易数据', 'backend', '', 274269, 3, 0, 999, 'tr_0tr_2816 tr_274269 ', 1, 1689131712, 1689131712, 2);";          $this->execute($sql);

            $sql="INSERT INTO `qimall_rbac_auth_item` ( `name`, `title`, `app_id`, `addons_name`, `pid`, `level`, `is_addon`, `sort`, `tree`, `status`, `created_at`, `updated_at`, `cate_id`) VALUES ( 'mall/statistics/car-analysis', '价值分析', 'backend', '', 274269, 3, 0, 999, 'tr_0tr_2816 tr_274269 ', 1, 1689131743, 1689131743, 2);";
            $this->execute($sql);

            $sql="update qimall_rbac_auth_item set title='新增/编辑' where name ='mall/diy/edit'";
            $this->execute($sql);
            $sql="update qimall_rbac_auth_item set title='新增/编辑' where name ='mall/goods/edit'";
            $this->execute($sql);
            $sql="update qimall_rbac_auth_item set title='新增/编辑' where name ='mall/cate/edit'";
            $this->execute($sql);

        }catch (\Exception $e){

        }

    }

    /**
     * {@inheritdoc}
     */
    public function safeDown()
    {
        echo "M230712024155InsertQimallRabcAuthItem cannot be reverted.\n";

        return false;
    }

    /*
    // Use up()/down() to run migration code without a transaction.
    public function up()
    {

    }

    public function down()
    {
        echo "M230712024155InsertQimallRabcAuthItem cannot be reverted.\n";

        return false;
    }
    */
}