qimall/addons/Course/console/migrations/M241231162520UpldateAddonsCourseActivity.php

<?php

namespace addons\Course\console\migrations;

use addons\Course\common\models\AddonsCourseActivity;
use common\enums\AddonsEnum;
use common\models\mall\MallAddons;
use yii\db\Migration;

/**
 * Class M240425023506UploadShippingInfo
 */
class M241231162520UpldateAddonsCourseActivity extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        try {
            $malls = \common\models\mall\Mall::getEnableMallList();
            $mall_ids = array_column($malls, 'id');

            $static_url = \Yii::$app->services->setting->get('system.static_url') ?? '';
            $logo_url = $static_url . '/static/addons/course/activity_default_logo.png';

            foreach ($mall_ids as $mall_id) {
                if (MallAddons::isInstall($mall_id, AddonsEnum::ADDONS_NAME_COURSE)) {
                    AddonsCourseActivity::updateAll(['logo' => $logo_url], ['mall_id' => $mall_id, 'status' => [0, 1]]);
                }
            }
        } catch (\Exception $e) {
            var_dump($e->getMessage());
        }
    }

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

        return false;
    }

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

    }

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

        return false;
    }
    */
}