qimall/console/migrations/M240809143855DeleteRegion.php

<?php

namespace app\migrations;

use yii\db\Migration;

/**
 * 删除杭州下江干区-下城区
 * Class M240809143855DeleteRegion
 */
class M240809143855DeleteRegion extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        try {
            $sql = "select * from qimall_region where name in ('江干区', '下城区') and parent_id = 922 and level = 3";
            $res = $this->db->createCommand($sql)->queryAll();
            if($res){// 数据存在则删除这两个区域
                foreach ($res as $item){
                    $sql = "delete from qimall_region where id = {$item['id']}";
                    $this->execute($sql);
                }
            }
        } catch (\Exception $e) {

        }
    }

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

        return false;
    }
}