sports_admin/app/Models/Stlqresult.php

<?php

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

    function resultbklist($list = 10, $page, $where = '', $orwhere = '')
    {
        if (is_array ($where) && count ($where) > 0) { 
            $data = $this->join('st_lq_league','st_lq_result.lg_id','=','st_lq_league.lg_id')->select($this->table.'.id',$this->table.'.lg_id',$this->table.'.home_team',$this->table.'.guest_team',$this->table.'.home_rate',$this->table.'.guest_rate',$this->table.'.home_score',$this->table.'.guest_score',$this->table.'.all_goal',$this->table.'.status',$this->table.'.first_score',$this->table.'.last_score',$this->table.'.match_score',$this->table.'.match_winer',$this->table.'.update_time',$this->table.'.match_time',$this->table.'.match_process',$this->table.'.tag',$this->table.'.match_id',$this->table.'.u_home_score',$this->table.'.u_guest_score','st_lq_league.name_chinese')->orderby($this->table.'.id','desc')->where($where)->orwhere($orwhere)->paginate ($list); 
        } else {
            $data = $this->join('st_lq_league','st_lq_result.lg_id','=','st_lq_league.lg_id')->select($this->table.'.id',$this->table.'.lg_id',$this->table.'.home_team',$this->table.'.guest_team',$this->table.'.home_rate',$this->table.'.guest_rate',$this->table.'.home_score',$this->table.'.guest_score',$this->table.'.all_goal',$this->table.'.status',$this->table.'.first_score',$this->table.'.last_score',$this->table.'.match_score',$this->table.'.match_winer',$this->table.'.update_time',$this->table.'.match_time',$this->table.'.match_process',$this->table.'.tag',$this->table.'.match_id',$this->table.'.u_home_score',$this->table.'.u_guest_score','st_lq_league.name_chinese')->orderby($this->table.'.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_team = $data[$i]->home_team.' <br> '.$data[$i]->guest_team;
            $data[$i]->u_home_guest_score = $data[$i]->u_home_score.' <br> '.$data[$i]->u_guest_score;
        }

        return $data->toArray ();

	}



}

?>