qimall/addons/BlindBox/console/controllers/IndexController.php

<?php

namespace addons\BlindBox\console\controllers;

use addons\BlindBox\common\models\BlindBoxBonusLog;
use addons\BlindBox\common\models\BlindBoxBonusLogDetail;

use addons\BlindBox\common\models\BlindBoxUser;
use common\enums\StatusEnum;
use common\models\mall\Mall;
use yii\console\Controller;

class IndexController extends Controller
{


    public function actionSettlement()
    {
        try {
//            $malls = Mall::getEnableMallList();
//            foreach ($malls as $mall) {
//                BlindBoxBonusLogDetail::settlement($mall['id']);
//            }
        } catch (\Exception $e) {
            return false;
        }
    }

    public function actionTy(){
        $params = [
            'where' => [['status'=>StatusEnum::ENABLED]],
        ];
        $list = BlindBoxBonusLogDetail::lists($params,false);
        foreach ($list as $item){
           $model = BlindBoxBonusLog::findOne(['id'=>$item['bonus_log_id']]);
           $item->user_id = $model->user_id;
            $res = $item->save();
            var_dump($res);
        }
    }
    public function actionTx(){
        $params = [
            'where' => [['status'=>StatusEnum::ENABLED]],
            'select' => 'user_id,sum(order_bonus) as order_bonus',
            'group' => 'user_id'
        ];
        $list = BlindBoxBonusLogDetail::lists($params);
        foreach ($list as $item){
            $model = BlindBoxUser::findOne(['user_id' => $item['user_id']]);
            if (empty($model)) continue;
            $model->frozen_commission = $item['order_bonus'];
            $res = $model->save();
            var_dump($res);
        }
    }


}