ball/app/workerapi/logic/TrainingWorkerTaskLogic.php

<?php
namespace app\workerapi\logic;

use app\common\logic\BaseLogic;
use app\common\model\shops\ShopOrderGoods;
use app\common\model\shops\ShopOrders;
use app\common\model\training\TrainingWorkerTask;
use think\facade\Db;


/**
 * TrainingWorkerTaskLogic逻辑
 * Class TrainingWorkerTaskLogic
 * @package app\workerapi\logic\works
 */
class TrainingWorkerTaskLogic extends BaseLogic
{




    /**
     * @notes 验证是否购买
     * @param array $params
     * @return bool
     * @author whitef
     * @date 2024/07/10 15:06
     */
    public static function upTaskOrder($masterWorkerId): bool
    {
        $task = TrainingWorkerTask::where('master_worker_id',$masterWorkerId)->findOrEmpty();
        if (!$task->isEmpty() && $task->shop_orders_id == 0) {
            //shop_goods_id  INT ( 10 ) DEFAULT 0  NOT NULL COMMENT '商品id(套餐)',
            //shop_orders_id int(10) NOT NULL DEFAULT '0' COMMENT '购买单号id',
            // 检查是否已经购买套餐
            $sn_orders = ShopOrders::where('worker_id',$masterWorkerId)->where('pay_status',1)->where('refund_status',0)->column('id','sn');
            if (!empty($sn_orders)) {
                $shopOrderGoods = ShopOrderGoods::whereIn('sn',array_keys($sn_orders))->where('shop_goods_id',$task->shop_goods_id)->findOrEmpty();
                if (!$shopOrderGoods->isEmpty()) {
                    $task->shop_orders_id = $sn_orders[$shopOrderGoods->sn];
                    $task->save();
                    return true;
                }
            }
        }
        return false;
    }


}