qimall/console/migrations/M240607154322UpdateLinkIcon.php

<?php

namespace app\migrations;

use yii\db\Migration;

/**
 * Class M240607154322UpdateLinkIcon
 */
class M240607154322UpdateLinkIcon extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        try {
            $sql = <<<SQL
                UPDATE qimall_link SET `icon` = '/diy/icon-set/mall-index.png' WHERE `route` = '/pages/index/index';
                UPDATE qimall_link SET `icon` = '/diy/icon-set/all-menu.png' WHERE `route` = '/pages/menu/index';
                UPDATE qimall_link SET `icon` = '/diy/icon-set/cart.png' WHERE `route` = '/pages/cart/index';
                UPDATE qimall_link SET `icon` = '/diy/icon-set/my-order.png' WHERE `route` = '/plugins/pages/order/list?tabIndex=0';
                UPDATE qimall_link SET `icon` = '/diy/icon-set/order-1.png' WHERE `route` = '/plugins/pages/order/list?tabIndex=1';
                UPDATE qimall_link SET `icon` = '/diy/icon-set/order-2.png' WHERE `route` = '/plugins/pages/order/list?tabIndex=2';
                UPDATE qimall_link SET `icon` = '/diy/icon-set/order-3.png' WHERE `route` = '/plugins/pages/order/list?tabIndex=3';
                UPDATE qimall_link SET `icon` = '/diy/icon-set/order-4.png' WHERE `route` = '/plugins/pages/order/list?tabIndex=4';
                UPDATE qimall_link SET `icon` = '/diy/icon-set/order-5.png' WHERE `route` = '/plugins/pages/refund/list';
                UPDATE qimall_link SET `icon` = '/diy/icon-set/my-order.png' WHERE `route` = '/pages/user/index';
                UPDATE qimall_link SET `icon` = '/diy/icon-set/collect.png' WHERE `route` = '/plugins/pages/center/keep';
                UPDATE qimall_link SET `icon` = '/diy/icon-set/user-recharge.png' WHERE `route` = '/plugins/pages/center/recharge/recharge';
                UPDATE qimall_link SET `icon` = '/diy/icon-set/balance-index.png' WHERE `route` = '/plugins/pages/assets/balance/index';
                UPDATE qimall_link SET `icon` = '/diy/icon-set/currency-index.png' WHERE `route` = '/plugins/pages/assets/currency/index';
                UPDATE qimall_link SET `icon` = '/diy/icon-set/withdraw-edit.png' WHERE `route` = '/plugins/pages/assets/withdraw/edit?from=2';
                UPDATE qimall_link SET `icon` = '/diy/icon-set/user-info.png' WHERE `route` = '/plugins/pages/settings/userInfo';
                UPDATE qimall_link SET `icon` = '/diy/icon-set/address.png' WHERE `route` = '/plugins/pages/settings/address';
                UPDATE qimall_link SET `icon` = '/diy/icon-set/my-client.png' WHERE `route` = 'plugins/public/promotion/client';
                UPDATE qimall_link SET `icon` = '/diy/icon-set/qr-code.png' WHERE `route` = '/plugins/poster/index';
                UPDATE qimall_link SET `icon` = '/diy/icon-set/promotion.png' WHERE `route` = '/plugins/public/promotion/index';
                UPDATE qimall_link SET `icon` = '/diy/icon-set/video-course.png' WHERE `route` = '/plugins/course/details?id=';
                UPDATE qimall_link SET `icon` = '/diy/icon-set/transfer-money.png' WHERE `route` = '/plugins/pages/assets/balance/transferMoney?modal_type=score';
                UPDATE qimall_link SET `icon` = '/diy/icon-set/write-off.png' WHERE `route` = '/plugins4/WriteOff/index';
                UPDATE qimall_link SET `icon` = '/diy/icon-set/all-menu.png' WHERE `route` = '/plugins3/menu/index';
SQL;
            $this->execute($sql);
        } catch (\Exception $e) {

        }
    }

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

        return false;
    }
}