<?php

namespace app\migrations;

use yii\db\Migration;

/**
 * Class M230906092335UpdateQimallAddons
 */
class M230906092335UpdateQimallAddons extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        try {
            $sql="UPDATE qimall_addons set title = '渠道分红', brief_introduction='渠道作战，让销量翻番' where name = 'Agent';";
            $this->execute($sql);
            $sql ="UPDATE qimall_addons set title = '渠道数据' where name = 'TeamData';";
            $this->execute($sql);
            $sql = "UPDATE qimall_addons set  brief_introduction='渠道业绩阶梯奖励' where name = 'Achievement';";
            $this->execute($sql);
            $sql = "UPDATE qimall_addons set  brief_introduction='三三复制渠道快速裂变' where name = 'Rebate';";
            $this->execute($sql);
            $sql = "UPDATE qimall_addons set  brief_introduction='生成授权证书，代理快速发展渠道' where name = 'Certificate';";
            $this->execute($sql);
            $sql ="UPDATE qimall_global_var_map set title = '渠道分红' where name = 'Agent';";
            $this->execute($sql);
            $sql = "UPDATE qimall_global_var_map set title = '渠道奖励' where name = 'team';";
            $this->execute($sql);
            $sql = "UPDATE qimall_global_var_map set title = '渠道业绩额外奖励' where name = 'team_achievement_extra';";
            $this->execute($sql);
            $sql="UPDATE qimall_global_var_map set title = '渠道补贴' where name = 'team_subsidy';";
            $this->execute($sql);
        }catch (\Exception $e){

        }

    }

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

        return false;
    }

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

    }

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

        return false;
    }
    */
}