getTypeData = new GetmatchData(); $this->getOddsData = new GetOddsData(); $this->commonFunction = C()->get('commonFunction'); } //各球类玩法列表及数量 public function gameList(){ $type = $_REQUEST['type'];//状态代码 $game_code= $_REQUEST['game_code'];//球类代码 $p_code= $_REQUEST['p_code'];//父级玩法代码 try { if(empty($type) ){ throw new \Exception(Render([], '10001', lang('Tips','Sports')->get('PARAM_ERROR'))); } switch ($type){ case 'StRollBall'://滚球 $this->getRollBall($type,$game_code,$p_code); break; case 'StSoon'://即将 $this->Other($type,$game_code,$p_code); break; case 'StToday'://今日 $this->Other($type,$game_code,$p_code); break; case 'StMorningPlate'://早盘 $this->Other($type,$game_code,$p_code); break; case 'StStringScene'://串场 $this->Other($type,$game_code,$p_code); break; default: throw new \Exception(Render([], '10002', lang('Tips','Sports')->get('PARAM_ERROR'))); } Render([], '1', lang('Tips','Sports')->get('success')); } catch (\Exception $e) { echo $e->getMessage(); } } //获取滚球 public function getRollBall($type,$game_code,$p_code){ //根据球类代码及玩法代码 获取相关赛事赔率数据 if(!empty($game_code) and !empty($p_code)){ $matchData = $this->getMatchData($type,$game_code,$p_code); Render($matchData, '1', lang('Tips','Sports')->get('success')); } $game = lm('GameType', 'Sports')->select('game_code')->where('status',1)->get()->toArray(); // $gameData = []; // foreach ($game as $k=>$v){ // if($v['game_code'] !='gj'){ // $where = $this->commonFunction->getState($type); // $models = $this->commonFunction->getModels($v['game_code'],1); // $matchNum = lm($models['model_league'],"Sports") // ->join($models['model_match'],$models['model_match'].'.lg_id',$models['model_league'].'.lg_id') // ->where($models['model_match'].'.source',$this->source['source']) // ->where($where) // ->count("*"); // //获取满足状态的球类 // if($matchNum != 0){ // $gameData[$v['game_code']] = $matchNum; // } // } // } // $gameData['all_num'] = array_sum($gameData); // $data[] = $gameData; // Render($data, '1', lang('Tips','Sports')->get('success')); $gameData = []; foreach ($game as $k=>$v){ if($v['game_code'] !='gj'){ $where = $this->commonFunction->getState($type); $models = $this->commonFunction->getModels($v['game_code'],1); $matchNum = lm($models['model_league'],"Sports") ->join($models['model_match'],$models['model_match'].'.lg_id',$models['model_league'].'.lg_id') ->where($models['model_match'].'.source',$this->source['source']) ->where($where) ->count("*"); //获取满足状态的球类 if($matchNum != 0){ $gameData[$k]['game_code'] = $v['game_code']; $gameData[$k]['game_num'] = $matchNum; } } } sort($gameData); $num = []; foreach ($gameData as $kk=>$vv){ $num[] = $vv['game_num']; } $gameData[]['all_num'] = array_sum($num); Render($gameData, '1', lang('Tips','Sports')->get('success')); } //获取非滚球数据 public function Other($type,$game_code,$p_code){ //根据球类代码及玩法代码 获取相关赛事赔率数据 if(!empty($game_code) and !empty($p_code)){ $matchData = $this->getMatchData($type,$game_code,$p_code); Render($matchData, '1', lang('Tips','Sports')->get('success')); } //根据状态获取所有球类/玩法下赛事数量 $game = lm('GameType', 'Sports')->select('game_code')->where('status',1)->get()->toArray(); $oddsCodeNum = []; foreach ($game as $k=>$v) { if ($v['game_code'] != 'gj') { //获取各球类下父级玩法赛事数量 $oddsCodeNum[$k] = $this->getMatchData($type,$v['game_code'],''); } } $matchDataNum = []; foreach ($oddsCodeNum as $k => $v){ foreach ($v as $kk=>$vv){ $matchDataNum[] = $vv; } } Render($matchDataNum, '1', lang('Tips','Sports')->get('success')); } //获取赛事数据 public function getMatchData($type,$game_code,$p_code=''){ //$p_code 获取具体玩法下的赛事数据 $where = $this->commonFunction->getState($type); $models = $this->commonFunction->getModels($game_code,1); $select = [$models['model_match'].'.match_id']; if($p_code){ $select = [$models['model_league'].'.lg_id',$models['model_league'].'.name_chinese as leagueName',$models['model_match'].'.match_id','home_team','guest_team','match_date','match_time','tag']; } $matchNum = lm($models['model_league'],"Sports") ->join($models['model_match'],$models['model_match'].'.lg_id',$models['model_league'].'.lg_id') // ->select($models['model_league'].'.lg_id',$models['model_league'].'.name_chinese as leagueName',$models['model_match'].'.match_id','home_team','guest_team','match_date','match_time','tag') ->select($select) ->where($models['model_match'].'.source',$this->source['source']) ->where($where) ->get()->toArray(); $oddsCodeNum = $this->getOddsData($game_code,$models['model_odds'],$matchNum,$p_code); if($p_code){ $match_odds = []; foreach ($oddsCodeNum as $k=>$v){ foreach ($matchNum as $kk=>$vv){ if($v['match_id'] == $vv['match_id']){ $match_odds[$kk]['lg_id'] = $vv['lg_id']; $match_odds[$kk]['leagueName'] = $vv['leagueName']; $match_odds[$kk]['match_id'] = $vv['match_id']; $match_odds[$kk]['home_team'] = $vv['home_team']; $match_odds[$kk]['guest_team'] = $vv['guest_team']; $match_odds[$kk]['match_date'] = $vv['match_date']; $match_odds[$kk]['match_time'] = $vv['match_time']; $match_odds[$kk]['tag'] = $vv['tag']; $match_odds[$kk]['oddsData'][] = $v; } } } //排序 sort($match_odds); $data = []; foreach ($matchNum as $k=>$v){ foreach ($match_odds as $kk=>$vv){ if($v['lg_id'] == $vv['lg_id']){ $data[$k]['lg_id'] = $v['lg_id']; $data[$k]['leagueName'] = $v['leagueName']; $data[$k]['matchData'][] = $vv; } } } //去重 $data = $this->uniquArr($data,'lg_id'); return $data; } return $oddsCodeNum; } //根据match_id获取赔率数据 public function getOddsData($game_code,$model_odds,$match_ids,$p_code=''){ $match_id = []; foreach ($match_ids as $k => $v){ $match_id[] = $v['match_id']; } $select = ['match_id','p_code']; $whereOr = []; if($p_code){ $whereOr = [['p_code','=',$p_code],['sort','=',0]]; $select = ['match_id','id','p_code','odds_code','condition','odds','odds_only','sort','status']; } $oddsData = lm($model_odds,"Sports") // ->select('match_id','p_code')( ->select($select) ->whereIn('match_id', $match_id) ->where('source',$this->source['source']) ->where($whereOr) ->get() ->toArray(); if($p_code){ return $oddsData; } //按父级玩法分组 $oddsCode = []; foreach ($oddsData as $kk=>$vv){ $oddsCode[$vv['p_code']][]= $vv; } // 去重 获取每个玩法下的赛事数量 $oddsCodeNum = []; $game_num = count($match_ids); foreach ($oddsCode as $kkk=>$vvv){ $oddsCodeNum[$kkk]['game_code'] = $game_code; $oddsCodeNum[$kkk]['game_num'] = $game_num; $oddsCodeNum[$kkk]['p_code'] = $kkk; $oddsCodeNum[$kkk]['code_num'] = count($this->uniquArr($vvv,'match_id')); } sort($oddsCodeNum); return $oddsCodeNum; } /** * 二维数组根据某个字段去重 * @param array $array 二维数组 * @para array 去重后的数组 */ function uniquArr($array,$key){ $result = array(); foreach($array as $k=>$val){ $code = false; foreach($result as $_val){ if($_val[$key] == $val[$key]){ $code = true; break; } } if(!$code){ $result[]=$val; } } return $result; } }