NN2023021801/app/api/command/GetUserTeamMoney.php

<?php
declare (strict_types = 1);

namespace app\api\command;

use AlibabaCloud\SDK\OSS\OSS\SelectObjectRequest\body\selectRequest;
use app\api\services\ThirdPayServices;
use app\api\services\UserServices;
use app\common\model\BoxMidHandleModel;
use app\common\model\BoxModel;
use app\common\model\CouponAreaModel;
use app\common\model\CouponPlanLogModel;
use app\common\model\CouponPlanModel;
use app\common\model\MoneyLogModel;
use app\common\model\ShopGoodsModel;
use app\common\model\UserModel;
use PhpOffice\PhpSpreadsheet\IOFactory;
use think\console\Command;
use think\console\Input;
use think\console\Output;
use think\db\Where;
use think\Exception;
use think\facade\Db;

class GetUserTeamMoney extends Command
{
    protected function configure()
    {
        // 获取用户今日奖金
        $this->setName('get_user_team_money')
            ->setDescription('the get_user_team_money command');
    }

    protected function execute(Input $input, Output $output)
    {


        Db::startTrans();
        try {

//            $list = Db::name('money_log')->whereDay('create_at', 'today')->field('uid')->where('type', 'in', '5,7')->group('uid')->select();

            $list = Db::name('user')->where('today_money', '>', 0)->select();
            foreach ($list as $key=>$val){
                edit_user_money(6, $val['id'], $val['today_money']);
                // 累计奖金
                Db::name('user')->where('id', $val['id'])->inc('todayaward_money', floatval($val['today_money']))->update();
            }

            Db::name('user')->where('today_money', '>', 0)->save(['today_money'=>0]);
            Db::commit();
        }catch (\Exception $e){
            Db::rollback();

            $output->writeln('key'.$e->getMessage());
            return 22;
        }

        return 22;


    }

}