sports_admin/app/Models/SoccerLeague.php

<?php
/**
 * Created by PhpStorm.
 * User: Jonlin
 * Date: 2019/3/29
 * Time: 9:27
 */

namespace App\Models;
use Illuminate\Support\Facades\DB;
use App\Lib\Biz\Sport\Common as commonFunction;

class SoccerLeague extends BaseModel {
    protected $table = "st_zq_league";
    public $timestamps = false;

    function getinfo($list = 10, $page, $where = '')
    {
        // $source = \App\Models\Setinfo::where('id','1000')->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;$a<count($area);$a++){
//            $str .= '<option value="'.$area[$a]->id.'">'.$area[$a]->name.'</option>';
//        }
        //国家
        $country = \App\Models\StAreaCountry::where('pid','<>','0')->get();

        for($i=0;$i<count($data);$i++){
            $data[$i]->lg_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 = '<select name="area" id="area" lay-filter="sect"><option value="-1"></option>'.$str.'</select>';
//            $data[$i]->country = '<select name="country" id="country"></select>';
            $str = 0;
            $str1 = 0;
            if($data[$i]->area_id == '0'){
                $data[$i]->area = '无';
            }else{
                for($b=0;$b<count($area);$b++){
                    if($area[$b]->id == $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;$c<count($country);$c++){
                    if($country[$c]->id == $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;$i<count($data);$i++){
            $data[$i]->lg_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;$b<count($area);$b++){
                    if($area[$b]->id == $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;$c<count($country);$c++){
                    if($country[$c]->id == $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];
    }

}