kwaiAD/app/Models/JxStarVideoF...

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class JxStarVideoFlowOrderList extends Model
{
    public $timestamps = false;
    protected $table = 'jx_star_video_flow_order_list';
    protected static $unguarded = true;

    #流量助推：星视频订单数据入库队列
    const JUXING_STAR_VIDEO_FLOW_ORDER_INDB_LIST = 'juxingStarVideoFlowOrderIndbList';

    public static function getOrderListQuery($adverIds, $keyword, $type, $status, $taskIds, $stDate, $enDate, $supplementOrderIds = null, $platform=null) {
        $model = JxStarVideoFlowOrderList::query();

        if(!empty($stDate)) $model->where('created_at', '>=', $stDate.' 00:00:00');
        if(!empty($enDate)) $model->where('created_at', '<=', $enDate.' 23:59:59');
        if(!empty($adverIds)) $model->whereIn('advertiser_id', $adverIds);
        if(is_numeric($status)) $model->where('status', $status);
        if(!empty($supplementOrderIds)) $model->whereIn('supplement_order_id', $supplementOrderIds);
        if(is_numeric($platform)) $model->where('platform', $platform);
        switch($type) {
            case 1: # 订单ID
                $model->where('order_id', 'like', '%'.$keyword.'%');
                break;
            case 2: # 助推订单ID
                $model->where('supplement_order_id', 'like', '%'.$keyword.'%');
                break;
            case 3: # 任务ID
                $model->where('task_id', 'like', '%'.$keyword.'%');
                break;
            case 4: # 达人ID
                $model->where('user_id', 'like', '%'.$keyword.'%');
                break;
            case 5: # 任务名称
                $model->whereIn('task_id', $taskIds);
                break;
        }

        return $model->where('enable', 1);
    }

    public static function updateData($advertiserId, $supplementOrderIdList, $updateData) {
        return self::query()->where('advertiser_id', $advertiserId)->whereIn('supplement_order_id', $supplementOrderIdList)->update($updateData);
    }
}