<?php

namespace app\migrations;

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

/**
 * Class M230601092416UpdateQimallRegion
 */
class M230601092416UpdateQimallRegion extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        try {
            // 生成菜单
            $sql = "UPDATE `qimall_region` SET `name` = '信都区', `initial` = 'X' WHERE `id` = 106;
UPDATE `qimall_town` SET `name` = '白岸乡' WHERE `id` = 2527;
UPDATE `qimall_town` SET `name` = '北小庄乡' WHERE `id` = 2528;
UPDATE `qimall_town` SET `name` = '城计头乡' WHERE `id` = 2529;
UPDATE `qimall_town` SET `name` = '达活泉街道' WHERE `id` = 2530;
UPDATE `qimall_town` SET `name` = '钢铁路街道' WHERE `id` = 2531;
UPDATE `qimall_town` SET `name` = '皇寺镇' WHERE `id` = 2532;
UPDATE `qimall_town` SET `name` = '会宁镇' WHERE `id` = 2533;
UPDATE `qimall_town` SET `name` = '翼家村乡' WHERE `id` = 2534;
UPDATE `qimall_town` SET `name` = '将军墓镇' WHERE `id` = 2535;
UPDATE `qimall_town` SET `name` = '浆水镇' WHERE `id` = 2536;
UPDATE `qimall_town` SET `name` = '李村镇' WHERE `id` = 2537;
UPDATE `qimall_town` SET `name` = '龙泉寺乡' WHERE `id` = 2538;
UPDATE `qimall_town` SET `name` = '路罗镇' WHERE `id` = 2539;
UPDATE `qimall_town` SET `name` = '南大郭镇' WHERE `id` = 2540;
UPDATE `qimall_town` SET `name` = '南石门镇' WHERE `id` = 2541;
UPDATE `qimall_town` SET `name` = '泉西街道' WHERE `id` = 2542;
UPDATE `qimall_town` SET `name` = '宋家庄镇' WHERE `id` = 2543;
INSERT INTO `qimall_town`(`id`, `district_id`, `adcode`, `name`, `created_at`, `updated_at`) VALUES 
(38986, 106, 130104, '太子井乡', 1594555298, 1594555298),
(38987, 106, 130104, '团结路街道', 1594555298, 1594555298),
(38988, 106, 130104, '西黄村镇', 1594555298, 1594555298),
(38989, 106, 130104, '羊范镇', 1594555298, 1594555298),
(38990, 106, 130104, '章村街道', 1594555298, 1594555298),
(38991, 106, 130104, '张宽街道', 1594555298, 1594555298),
(38992, 106, 130104, '中华大街街道', 1594555298, 1594555298),
(38993, 106, 130104, '中兴路街道', 1594555298, 1594555298);";
            $this->execute($sql);
        } catch (\Exception $e) {
            \Yii::error('地区表数据迁移失败：' . $e->getMessage());
        }
    }

    /**
     * {@inheritdoc}
     */
    public function safeDown()
    {
        echo "M230601092416UpdateQimallRegion 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;
    }
    */
}