sports_web/Application/Sports/Controller/RollingBall.php

<?php
/**
 * Created by PhpStorm.
 * User: Jonlin
 * Date: 2019/3/21
 * Time: 14:07
 */
namespace App\Sports\Controller;

use BaseController\Controller;
use \System\Model;

class RollingBall extends Controller{
    public function init() {
        $this->commonFunction =  C()->get('commonFunction');
    }

    /**
     * @throws \Exception
     * 首页足球滚球
     */
    public function zqrollingball(){
        $models = $this->commonFunction->getModels('zq',1);

        $model_result = $models['model_result'];
        $model_match = $models['model_match'];
        $model_league = $models['model_league'];
        $result_record = $models['model_result_record'];

        //获取 滚球查询条件
        $where = $this->commonFunction->getState('StRollBall',$model_match);

//        $result =lm($model_match,"Sports")
//            ->join($model_result,$model_result.'.match_id',$model_match.'.id')
//            ->join($model_league,$model_league.'.id',$model_match.'.lg_id')
//            ->select($model_match.'.id as match_id',$model_match.'.tag','match_date as start_date',$model_match.'.match_time as start_time',$model_match.'.home_team',$model_match.'.guest_team','home_score','guest_score',$model_result.'.match_time','match_process')
//            ->where([[$model_league.'.name_chinese','!=','']])
//            ->where($where)
//            ->get()
//            ->toarray();

        $result =lm($model_match,"Sports")
            ->join($model_league,$model_league.'.id',$model_match.'.lg_id')
            ->select($model_match.'.id as match_id',$model_match.'.tag','match_date as start_date',$model_match.'.match_time as start_time',$model_match.'.home_team',$model_match.'.guest_team')
            ->where([[$model_league.'.name_chinese','!=','']])
            ->where($where)
            ->get()
            ->toarray();
        foreach ($result as $k=>$v){
            $v['home_score'] = 0;
            $v['guest_score'] = 0;
            $v['match_time'] = 0;
            $v['match_process'] = '';

            $result[$k] = $v;
        }

        $data = [
            'game_code'=>'zq',
            'gameName'=>'足球',
            'matchData'=>$result
        ];

        return $data;

    }

    /**
     * @throws \Exception
     * 首页篮球滚球
     */
    public function lqrollingball(){
        $models = $this->commonFunction->getModels('lq',1);

        $model_result = $models['model_result'];
        $model_match = $models['model_match'];
        $model_league = $models['model_league'];
        //获取 滚球查询条件
        $where = $this->commonFunction->getState('StRollBall',$model_match);
//        $result =lm($model_match,"Sports")
//            ->join($model_result,$model_result.'.match_id',$model_match.'.id')
//            ->join($model_league,$model_league.'.id',$model_match.'.lg_id')
//            ->select($model_match.'.id as match_id',$model_match.'.tag','match_date as start_date',$model_match.'.match_time as start_time',$model_match.'.home_team',$model_match.'.guest_team','home_score','guest_score',$model_result.'.match_time','match_process')
//            ->where($where)
//            ->where([[$model_league.'.name_chinese','!=','']])
//            ->get()
//            ->toarray();
        $result =lm($model_match,"Sports")
            ->join($model_league,$model_league.'.id',$model_match.'.lg_id')
            ->select($model_match.'.id as match_id',$model_match.'.tag','match_date as start_date',$model_match.'.match_time as start_time',$model_match.'.home_team',$model_match.'.guest_team')
            ->where($where)
            ->where([[$model_league.'.name_chinese','!=','']])
            ->get()
            ->toarray();

        foreach ($result as $k=>$v){
            $v['home_score'] = 0;
            $v['guest_score'] = 0;
            $v['match_time'] = 0;
            $v['match_process'] = '';

            $result[$k] = $v;
        }

        $data = [
            'game_code'=>'lq',
            'gameName'=>'篮球',
            'matchData'=>$result
        ];
        return $data;
    }

    public function wqrollingball(){
        $models = $this->commonFunction->getModels('wq',1);

        $model_result = $models['model_result'];
        $model_match = $models['model_match'];
        $model_league = $models['model_league'];
        //获取 滚球查询条件
        $where = $this->commonFunction->getState('StRollBall',$model_match);
//        $result =lm($model_match,"Sports")
//            ->join($model_result,$model_result.'.match_id',$model_match.'.id')
//            ->join($model_league,$model_league.'.id',$model_match.'.lg_id')
//            ->select($model_match.'.id as match_id',$model_match.'.tag','match_date as start_date',$model_match.'.match_time as start_time','home_player_name','guest_player_name','first_inning_score','second_inning_score','third_inning_score',$model_result.'.match_time','match_process')
//            ->where($where)
//            ->where([[$model_league.'.name_chinese','!=','']])
//            ->get()
//            ->toarray();
        $result =lm($model_match,"Sports")
            ->join($model_league,$model_league.'.id',$model_match.'.lg_id')
            ->select($model_match.'.id as match_id',$model_match.'.tag','match_date as start_date',$model_match.'.match_time as start_time',$model_match.'.home_team as home_player_name',$model_match.'.guest_team as guest_player_name')
            ->where($where)
            ->where([[$model_league.'.name_chinese','!=','']])
            ->get()
            ->toarray();

        foreach ($result as $k=>$v){
            $v['first_inning_score'] = 0;
            $v['second_inning_score'] = 0;
            $v['third_inning_score'] = 0;
            $v['match_time'] = 0;
            $v['match_process'] = '';

            $result[$k] = $v;
        }

        $data = [
            'game_code'=>'wq',
            'gameName'=>'网球',
            'matchData'=>$result
        ];
        return $data;
    }

    public function bqrollingball(){
        $models = $this->commonFunction->getModels('bq',1);

        $model_result = $models['model_result'];
        $model_match = $models['model_match'];
        $model_league = $models['model_league'];
        //获取 滚球查询条件
        $where = $this->commonFunction->getState('StRollBall',$model_match);
//        $result =lm($model_match,"Sports")
//            ->join($model_result,$model_result.'.match_id',$model_match.'.id')
//            ->join($model_league,$model_league.'.id',$model_match.'.lg_id')
//            ->select($model_match.'.id as match_id',$model_match.'.tag','match_date as start_date',$model_match.'.match_time as start_time',$model_match.'.home_team',$model_match.'.guest_team','home_score','guest_score',$model_result.'.match_time','match_process')
//            ->where($where)
//            ->where([[$model_league.'.name_chinese','!=','']])
//            ->get()
//            ->toarray();
        $result =lm($model_match,"Sports")
            ->join($model_league,$model_league.'.id',$model_match.'.lg_id')
            ->select($model_match.'.id as match_id',$model_match.'.tag','match_date as start_date',$model_match.'.match_time as start_time',$model_match.'.home_team',$model_match.'.guest_team')
            ->where($where)
            ->where([[$model_league.'.name_chinese','!=','']])
            ->get()
            ->toarray();

        foreach ($result as $k=>$v){
            $v['home_score'] = 0;
            $v['guest_score'] = 0;
            $v['match_time'] = 0;
            $v['match_process'] = '';

            $result[$k] = $v;
        }


        $data = [
            'game_code'=>'bq',
            'gameName'=>'棒球',
            'matchData'=>$result
        ];
        return $data;

    }

    /**
     * 获取所有球类滚球
     */
    public function getRollingBall(){
        $zqRollingBall = $this->zqrollingball();
        $lqRollingBall = $this->lqrollingball();
        $wqRollingBall = $this->wqrollingball();
        $bqRollingBall = $this->bqrollingball();

        $data = [
            'zqData' =>$zqRollingBall,
            'lqData' =>$lqRollingBall,
            'wqData' =>$wqRollingBall,
            'bqData' =>$bqRollingBall,
        ];

        Render($data, '1', lang('Tips','Sports')->get('success'));
    }
}