qimall/console/migrations/M230529103356InsertQimallMenu.php

<?php

namespace app\migrations;

use common\models\user\MemberLabel;
use yii\db\Migration;

/**
 * Class M230529103356InsertQimallMenu
 */
class M230529103356InsertQimallMenu extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        try {
            // 生成菜单
            $sql = "UPDATE `qimall_menu` SET `title` = '会员标签',`pid` = 34, `level` = 1, `tree` = 'tr_0 tr_34 ' WHERE `id` = 2076;";
            $sql.= "INSERT INTO `qimall_menu`(`title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES
('会员分析', 'backend', 2, '', 0, 34, 'mall/user-member-label/index', '', 1, 1, 999, NULL, 'tr_0 tr_34', 1, 1682058236, 1682058236),
('价值标签', 'backend', 2, '', 0, 2076, 'mall/member-label/value-label', '', 2, 1, 999, NULL, 'tr_0 tr_34 tr_2076', 1, 1682058236, 1682058236),
('会员等级', 'backend', 2, '', 0, 2076, 'mall/member-label/user-level', '', 2, 1, 999, NULL, 'tr_0 tr_34 tr_2076', 1, 1682058236, 1682058236),
('渠道等级', 'backend', 2, '', 0, 2076, 'mall/member-label/agent-level', '', 2, 1, 999, NULL, 'tr_0 tr_34 tr_2076' , 1, 1682058236, 1682058236),
('复购标签', 'backend', 2, '', 0, 2076, 'mall/member-label/repurchase', '', 2, 1, 999, NULL, 'tr_0 tr_34 tr_2076', 1, 1682058236, 1682058236),
('活跃标签', 'backend', 2, '', 0, 2076, 'mall/member-label/active', '', 2, 1, 999, NULL, 'tr_0 tr_34 tr_2076', 1, 1682058236, 1682058236),
('收入标签', 'backend', 2, '', 0, 2076, 'mall/member-label/income', '', 2, 1, 999, NULL, 'tr_0 tr_34 tr_2076', 1, 1682058236, 1682058236),
('分享标签', 'backend', 2, '', 0, 2076, 'mall/member-label/share', '', 2, 1, 999, NULL, 'tr_0 tr_34 tr_2076', 1, 1682058236, 1682058236),
('退款标签', 'backend', 2, '', 0, 2076, 'mall/member-label/refund', '', 2, 1, 999, NULL, 'tr_0 tr_34 tr_2076', 1, 1682058236, 1682058236),
('会员年龄', 'backend', 2, '', 0, 2076, 'mall/member-label/user-age', '', 2, 1, 999, NULL, 'tr_0 tr_34 tr_2076', 1, 1682058236, 1682058236),
('推广标签', 'backend', 2, '', 0, 2076, 'mall/member-label/poppularize', '', 2, 1, 999, NULL, 'tr_0 tr_34 tr_2076', 1, 1682058236, 1682058236),
('领导标签', 'backend', 2, '', 0, 2076, 'mall/member-label/lead', '', 2, 1, 999, NULL, 'tr_0 tr_34 tr_2076', 1, 1682058236, 1682058236),
('智能标签', 'backend', 2, '', 0, 2076, 'mall/user-label/index', '', 2, 1, 999, NULL, 'tr_0 tr_34 tr_2076', 1, 1682058236, 1682058236);";
            $this->execute($sql);

            MemberLabel::createRbacItems();// 生成标签权限
        } catch (\Exception $e) {
            \Yii::error('会员标签迁移失败：' . $e->getMessage());
        }
    }

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

        return false;
    }

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

    }

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

        return false;
    }
    */
}