sports_admin/app/Models/Stzqresult.php

<?php

namespace App\Models;
use Illuminate\Support\Facades\DB;
class Stzqresult extends BaseModel
{
	protected $table = 'st_zq_result';
	public $timestamps = false;


	// function resultlist($list = 10, $page, $where = '',$orwhere = '')
 //    {
 //        if (is_array ($where) && count ($where) > 0) {
 //            $data = $this->join('st_zq_league','st_zq_result.lg_id','=','st_zq_league.lg_id')->select('st_zq_result.id','st_zq_result.lg_id','st_zq_result.home_team','st_zq_result.guest_team','st_zq_result.home_rate','st_zq_result.guest_rate','st_zq_result.first_score','st_zq_result.status','st_zq_result.last_score','st_zq_result.match_score','st_zq_result.match_winer','st_zq_result.update_time','st_zq_result.match_time','st_zq_result.match_process',$this->table.'.home_score',$this->table.'.guest_score',$this->table.'.u_guest_score',$this->table.'.u_home_score','st_zq_league.name_chinese as saisname')->orderby('st_zq_result.id','desc')->where($where)->orwhere($orwhere)->paginate ($list);
 //        } else {
 //            $data = $this->join('st_zq_league','st_zq_result.lg_id','=','st_zq_league.lg_id')->select('st_zq_result.id','st_zq_result.lg_id','st_zq_result.home_team','st_zq_result.guest_team','st_zq_result.home_rate','st_zq_result.guest_rate','st_zq_result.first_score','st_zq_result.status','st_zq_result.last_score','st_zq_result.match_score','st_zq_result.match_winer','st_zq_result.update_time','st_zq_result.match_time','st_zq_result.match_process',$this->table.'.home_score',$this->table.'.guest_score',$this->table.'.u_guest_score',$this->table.'.u_home_score','st_zq_league.name_chinese as saisname')->orderby('st_zq_result.id','desc')->paginate ($list);
 //        }

 //        for($i=0;$i<count($data);$i++){
 //            if($data[$i]->status==0){
 //                $data[$i]->status = '未开始';
 //            }else if($data[$i]->status==1){
 //                $data[$i]->status = '进行中';
 //            }else if($data[$i]->status==2){
 //                $data[$i]->status = '已结束';
 //            }
 //            $data[$i]->home_guest = $data[$i]->home_rate.' <br> '.$data[$i]->guest_rate;
 //            $data[$i]->shome_guest = $data[$i]->home_score.' <br> '.$data[$i]->guest_score;
 //        }

 //        return $data->toArray ();

	// }
    
    function resultlist($list = 10, $page, $where = '',$orwhere = '')
    {
        if (is_array ($where) && count ($where) > 0) {
            $data = $this->join('st_zq_league','st_zq_result.lg_id','=','st_zq_league.lg_id')->join('st_zq_competition','st_zq_competition.match_id','=','st_zq_result.match_id')->select($this->table.'.id',$this->table.'.home_team',$this->table.'.guest_team',$this->table.'.match_id','st_zq_result.guest_team','st_zq_result.home_rate','st_zq_result.guest_rate','st_zq_result.first_score','st_zq_result.status','st_zq_result.last_score','st_zq_result.match_score','st_zq_result.match_winer','st_zq_result.update_time','st_zq_competition.match_time','st_zq_result.match_process',$this->table.'.home_score',$this->table.'.guest_score',$this->table.'.u_guest_score',$this->table.'.u_home_score','st_zq_league.name_chinese as saisname')->orderby('st_zq_result.id','desc')->where($where)->orwhere($orwhere)->paginate ($list);
        } else { 
            $this->join('st_zq_league','st_zq_result.lg_id','=','st_zq_league.lg_id')->join('st_zq_competition','st_zq_competition.match_id','=','st_zq_result.match_id')->select($this->table.'.id',$this->table.'.home_team',$this->table.'.guest_team',$this->table.'.match_id','st_zq_result.guest_team','st_zq_result.home_rate','st_zq_result.guest_rate','st_zq_result.first_score','st_zq_result.status','st_zq_result.last_score','st_zq_result.match_score','st_zq_result.match_winer','st_zq_result.update_time','st_zq_competition.match_time','st_zq_result.match_process',$this->table.'.home_score',$this->table.'.guest_score',$this->table.'.u_guest_score',$this->table.'.u_home_score','st_zq_league.name_chinese as saisname')->orderby('st_zq_result.id','desc')->paginate ($list);
        }

        for($i=0;$i<count($data);$i++){
            if($data[$i]->status==0){
                $data[$i]->status = '未开始';
            }else if($data[$i]->status==1){
                $data[$i]->status = '进行中';
            }else if($data[$i]->status==2){
                $data[$i]->status = '已结束';
            }
            $data[$i]->home_guest = $data[$i]->home_rate.' <br> '.$data[$i]->guest_rate;
            $data[$i]->shome_guest = $data[$i]->home_score.' <br> '.$data[$i]->guest_score;
        }

        return $data->toArray ();

    }

    //地区联赛赛事查询
    function alldiqu(){
        $data = $this->join('st_zq_league','st_zq_result.lg_id','=','st_zq_league.id')->select('st_zq_result.id','st_zq_result.lg_id','st_zq_result.home_team','st_zq_result.guest_team','st_zq_result.home_rate','st_zq_result.guest_rate','st_zq_result.first_score','st_zq_result.status','st_zq_result.last_score','st_zq_result.match_score','st_zq_result.match_winer','st_zq_result.update_time','st_zq_result.match_time','st_zq_result.match_process','st_zq_league.name_chinese as saisname')->orderby('st_zq_result.id','desc')->get();
        return $data->toArray ();   
    }

    //更新
    function updateInfo($data, $id)
    {
        $res = $this->where ('id', $id)->update ($data);
        if (!$res) {
            return -7010101202; //更新失败
        }
        return 1;
    }

    


}

?>