qimall/addons/BusinessBonus/console/migrations/M250619164012InitTableAddonsBusinessBonusUpgradeCondition.php

<?php

namespace addons\BusinessBonus\console\migrations;

use addons\BusinessBonus\common\models\BusinessBonusUpgradeCondition;
use yii\db\Migration;

/**
 * Class M250616163010AlterTableAddonsBusinessBonusUpgradeCondition
 */
class M250619164012InitTableAddonsBusinessBonusUpgradeCondition extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        try {
            $model = BusinessBonusUpgradeCondition::find()
                ->where([
                    'status' => 1,
                    'mall_id' => 920,
                    'business_bonus_level' => 5
                ]);

            foreach ($model->batch(500) as $list) {
                foreach ($list as $item) {
                    $checked_condition_values = [
                        ["key" =>"0","value" => [], "is_need_conditional" => 1, "is_inviter" =>1],
                        ["key" =>"1","value" => [], "is_audit" => 0],
                        ["key" =>"2","value" => [],"nums" =>0],
                        ["key" =>"3","value" => [],"nums" => 0, "level" => null],
                    ];
                    $checked_condition_keys = [];

                    if ($item['upgrade_type']  == 1) {
                        $item->is_condition_upgrade = 1;
                        $checked_condition_values = [
                            ["key" =>"0","value" => [], "is_need_conditional" => 2, "is_inviter" =>1],
                            ["key" =>"1","value" => [], "is_audit" => 0],
                            ["key" =>"2","value" => [],"nums" =>0],
                            ["key" =>"3","value" => [],"nums" => 0, "level" => null],
                        ];
                        $checked_condition_keys = [0];
                    }
                    if ($item['upgrade_type']  == 2) {
                        $item->is_condition_upgrade = 1;
                        $checked_condition_values = [
                            ["key" =>"0","value" => [], "is_need_conditional" => 1, "is_inviter" =>1],
                            ["key" =>"1","value" => [], "is_audit" => $item['is_audit']],
                            ["key" =>"2","value" => [],"nums" =>0],
                            ["key" =>"3","value" => [],"nums" => 0, "level" => null],
                        ];
                        $checked_condition_keys = [0, 1];
                    }

                    if ($item['upgrade_type']  == 3) {
                        $item->is_buy_goods_upgrade = 1;
                        $item->buy_goods_upgrade_type = 1;
                        $item->buy_goods_upgrade_method = 2;
                        $checked_condition_values = [
                            ["key" =>"0","value" => [], "is_need_conditional" => 1, "is_inviter" =>1],
                            ["key" =>"1","value" => [], "is_audit" => 0],
                            ["key" =>"2","value" => [],"nums" =>0],
                            ["key" =>"3","value" => [],"nums" => 0, "level" => null],
                        ];
                        $checked_condition_keys = [];
                    }

                    if ($item['upgrade_type']  == 6) {
                        $item->is_buy_goods_upgrade = 1;
                        $item->buy_goods_upgrade_type = 1;
                        $item->buy_goods_upgrade_method = 2;

                        $upgrade_store_goods_list = json_decode($item['upgrade_store_goods_list'], true);
                        if ($upgrade_store_goods_list['store_goods_type'] == 1) {
                            $item['buy_goods_upgrade_method'] = 1;
                        } else {
                            $item['buy_goods_upgrade_method'] = 2;
                        }
                    }

                    $item->checked_condition_values = json_encode($checked_condition_values);
                    $item->checked_condition_keys = json_encode($checked_condition_keys);

                    if (!$item->save()) throw new \Exception("初始化招商员升级条件失败");
                }
            }
        } catch (\Exception $e) {
            var_dump($e->getMessage());
        }

    }

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

        return false;
    }

}