<?php
namespace App\Sports\Model;

use \System\Model;

/**
 * Class Account
 * @package App\Sports\Model
 * 用户账号
 */
class St_zq_competition extends Model
{

    protected $table = 'st_zq_competition';

    /**
     * @param array $where 条件
     * @param string $select 字段
     * @param string $sort 排序字段
     * @param string $orderby 排序方式
     * @return mixed
     * 获取赛事数据
     */
    public static function getMatchData($where=[],$select='id',$sort='id',$orderby='asc'){
        $matchData = self::select($select)->where($where)->orderBy($sort,$orderby)->get();
        return $matchData;
    }

    //获取各球类 赛事关联赛事结果数据
    public static function getMatchDataAll($source,$models,$where){
        $model_match = $models['model_match'];
        $model_result = $models['model_result'];

        $data = lm($model_match,"Sports")
            ->leftjoin($model_result,$model_result.'.match_id',$model_match.'.match_id')
            ->select($model_match.'.lg_id',$model_match.'.match_id',$model_match.'.tag','match_date',$model_match.'.match_time',$model_match.'.home_team',$model_match.'.guest_team','home_score','guest_score',$model_result.'.match_time as a_time','match_process')
            ->where($model_match.'.source',$source['source'])
            ->where($where)
            ->get()
            ->toarray();

        return $data;
    }

    //获取赛事下 滚球盘默认赔率
    public static function getMatchOdds($source,$models){
        $model_odds = $models['model_odds'];
        $oddsData= lm($model_odds,"Sports")
            ->select($model_odds.'.match_id',$model_odds.'.id','p_code','odds_code',$model_odds.'.status','odds','condition','odds_only','sort')
            ->where($model_odds.'.source',$source['source'])
            ->where([$model_odds.'.type'=>0])//查询滚球赔率
            //->where($model_odds.'.expire_time','>',date("Y-m-d H:i:s"))
            ->where(function($query)use ($model_odds){
                $query->where($model_odds.'.odds_code','concede_home')
                    ->orWhere(function($query)use ($model_odds){
                        $query->where($model_odds.'.odds_code','concede_guest');
                    })
                    ->orWhere(function($query)use ($model_odds){
                        $query->where($model_odds.'.odds_code','size_home');
                    })
                    ->orWhere(function($query)use ($model_odds){
                        $query->where($model_odds.'.odds_code','size_guest');
                    })
                    ->orWhere(function($query)use ($model_odds){
                        $query->where($model_odds.'.odds_code','capot_home');
                    })
                    ->orWhere(function($query)use ($model_odds){
                        $query->where($model_odds.'.odds_code','capot_dogfall');
                    })
                    ->orWhere(function($query)use ($model_odds){
                        $query->where($model_odds.'.odds_code','capot_guest');
                    });
            })
            ->get()
            ->toarray();

        return $oddsData;
    }
}