first(); // if($source->infocontent != '混合数据'){ // $where[] = array('st_zq_local_league.source', '=', $source->infocontent); // } if (is_array ($where) && count ($where) > 0){ $data = $this //->join('st_zq_local_league','st_zq_league.id','=','st_zq_local_league.lg_id') ->select('st_zq_league.id','st_zq_league.name_chinese','st_zq_league.area_id','st_zq_league.country_id','st_zq_league.status','st_zq_league.utime') ->orderby('st_zq_league.utime','desc') ->where($where) //->distinct('st_zq_league.id') ->paginate ($list); }else{ $data = $this ->select('st_zq_league.id','st_zq_league.name_chinese','st_zq_league.area_id','st_zq_league.country_id','st_zq_league.status','st_zq_league.utime') ->orderby('st_zq_league.utime','desc') //->distinct('st_zq_league.id') ->paginate ($list); } if (!$data) { return -5040000102; //无相关信息 } //地区 $area = \App\Models\StAreaCountry::where('pid','0')->get(); // $str = ''; // for($a=0;$aid.'">'.$area[$a]->name.''; // } //国家 $country = \App\Models\StAreaCountry::where('pid','<>','0')->get(); for($i=0;$ilg_id = $data[$i]->id; if($data[$i]->status == '-1'){ $data[$i]->league_status = '未启用'; } if($data[$i]->status == '1'){ $data[$i]->league_status = '启用'; } // $data[$i]->area = ''.$str.''; // $data[$i]->country = ''; $str = 0; $str1 = 0; if($data[$i]->area_id == '0'){ $data[$i]->area = '无'; }else{ for($b=0;$bid == $data[$i]->area_id){ $str = 1; $data[$i]->area = $area[$b]->name; } } if($str == 0){$data[$i]->area = '无';} } if($data[$i]->country_id == 0){ $data[$i]->country = '无'; }else{ for($c=0;$cid == $data[$i]->country_id){ $str1 = 1; $data[$i]->country = $country[$c]->name; } } if($str1 == 0){$data[$i]->country = '无';} } } return $data->toArray(); } //所有赛事id function allleague() { $data = $this->select('id','name_chinese')->get(); if (!$data) { return -5040000102; //无相关信息 } return $data->toArray(); } //赛事信息 function onlyleague($lg_id){ $data=$this->where('lg_id',$lg_id)->first(); if (!$data) { return -5040000102; //无相关信息 } return $data->toArray(); } //测试冠军联赛数据 function get_league_gj_info($list = 10, $page, $where = '') { if (is_array ($where) && count ($where) > 0){ $data = $this ->join('st_zq_odds','st_zq_odds.lg_id','=','st_zq_league.id') ->select('st_zq_league.id','st_zq_league.name_chinese','st_zq_league.area_id','st_zq_league.country_id','st_zq_league.status','st_zq_league.utime') ->where($where) ->orderby('st_zq_league.utime','desc') ->distinct('st_zq_league.name_chinese') ->paginate ($list); }else{ $data = $this ->join('st_zq_odds','st_zq_odds.lg_id','=','st_zq_league.id') ->select('st_zq_league.id','st_zq_league.name_chinese','st_zq_league.area_id','st_zq_league.country_id','st_zq_league.status','st_zq_league.utime') ->orderby('st_zq_league.utime','desc') ->distinct('st_zq_league.name_chinese') ->paginate ($list); } if (!$data) { return -5040000102; //无相关信息 } //地区 $area = \App\Models\StAreaCountry::where('pid','0')->get(); //国家 $country = \App\Models\StAreaCountry::where('pid','<>','0')->get(); for($i=0;$ilg_id = $data[$i]->id; if($data[$i]->status == '-1'){ $data[$i]->league_status = '未启用'; } if($data[$i]->status == '1'){ $data[$i]->league_status = '启用'; } $str = 0; $str1 = 0; if($data[$i]->area_id == '0'){ $data[$i]->area = '无'; }else{ for($b=0;$bid == $data[$i]->area_id){ $str = 1; $data[$i]->area = $area[$b]->name; } } if($str == 0){$data[$i]->area = '无';} } if($data[$i]->country_id == 0){ $data[$i]->country = '无'; }else{ for($c=0;$cid == $data[$i]->country_id){ $str1 = 1; $data[$i]->country = $country[$c]->name; } } if($str1 == 0){$data[$i]->country = '无';} } } return $data->toArray(); } //统计条数 function countnum($where){ $allcount = \App\Models\SoccerLeague::where($where)->select('id')->get(); for ($i=0; $i < count($allcount); $i++) { $whe = array( 'lg_id' => $allcount[$i]['id'], 'type' => 1, ); $countodds[] = \App\Models\SoccerOdds::where($whe)->count(); } return $count = count($countodds) - array_count_values($countodds)[0]; } }