sports_admin/app/Models/SportsNoteList.php

<?php
/**
 * Created by PhpStorm.
 * User: Jonlin
 * Date: 2019/4/9
 * Time: 9:18
 */
namespace App\Models;
use Illuminate\Support\Facades\DB;
class SportsNoteList extends BaseModel {
    protected $table = "money_buy";
    public $timestamps = false;

    function getinfo($list = 10, $page, $where = '',$type)
    {
        if (is_array ($where) && count ($where) > 0) {
            $data = $this
                ->join('st_'.$type.'_competition','st_'.$type.'_competition.match_id','=','money_buy.match_id')
                ->join('money_details','money_details.info_identity','=','money_buy.info_identity')
                //->join('st_game_type','st_game_type.game_code','=','money_buy.game_name')
                ->where($where)
                ->where('money_buy.game_name', $type)
                ->orderby('money_buy.money_time','desc')
                ->paginate ($list);
        } else {
            $data = $this
                ->join('st_'.$type.'_competition','st_'.$type.'_competition.match_id','=','money_buy.match_id')
                ->join('money_details','money_details.info_identity','=','money_buy.info_identity')
                ->where('money_buy.game_name', $type)
                ->orderby('money_buy.money_time','desc')
                ->paginate ($list);
        }
        if (!$data < 0) {
            return -2021052003; //
        }
        for($i=0;$i<count($data);$i++){
            if($data[$i]->status==1){
                $data[$i]->status = '投注';
            }else if($data[$i]->status==2){
                $data[$i]->status = '追号';
            }else if($data[$i]->status==4){
                $data[$i]->status = '撤单';
            }
            if($data[$i]->water_status==1){
                $data[$i]->water_status = '未回水';
            }else if($data[$i]->water_status==2){
                $data[$i]->water_status = '已回水';
            }
            if($data[$i]->settle_status==1){
                $data[$i]->settle_status = '未结算';
            }else if($data[$i]->settle_status==2){
                $data[$i]->settle_status = '已结算';
            }
            if($data[$i]->game_status==0){
                $data[$i]->game_status = '待开奖';
            }else if($data[$i]->game_status==1){
                $data[$i]->game_status = '中奖';
            }else if($data[$i]->game_status==2){
                $data[$i]->game_status = '未中奖';
            }
            if($data[$i]->member_type==1){
                $data[$i]->member_type = '普通会员';
            }else if($data[$i]->member_type==2){
                $data[$i]->member_type = '超级会员';
            }
            $data[$i]->match_id_order = '<span>'.$data[$i]->match_id.'</span><br>'.$data[$i]->order_id;

            $data[$i]->home_guest = $data[$i]->home_team.' VS '.$data[$i]->guest_team;
            $data[$i]->match_time = '开赛：'.$data[$i]->match_date.' '.$data[$i]->match_time;
            $data[$i]->money_match_time = '投注：'.$data[$i]->money_time.'<br>'.$data[$i]->match_time;

            $league = DB::table('st_'.$type.'_league')->where('lg_id',$data[$i]->lg_id)->first();
            if(!empty($league)){
                $data[$i]->league = $league->name_chinese;
            }else{
                $data[$i]->league = $data[$i]->lg_id;
            }
            //用户投注后账户金额
            $data[$i]->frozen_cash = $data[$i]->money_cash;
            //用户投注前账户金额
            $data[$i]->available_cash = $data[$i]->money+$data[$i]->money_cash.'.00';
            $data[$i]->account = $data[$i]->available_cash.'<br><span>'.$data[$i]->account_name.'</span><br>'.$data[$i]->frozen_cash;

            $codes = json_decode($data[$i]->codes, true);
            $data[$i]->content = '';
            for($j=0;$j<count($codes);$j++){
                $odds_code = $codes[$j]['odds_code'];
                $result = DB::table('st_odds_code')->where('odds_code',$odds_code)->first();
                if(!empty($result)){
                    $odds_name = $result->odds_name;
                }else{
                    $odds_name = $odds_code;
                }
                $data[$i]->content = $data[$i]->content.$odds_name.  '￥'.$codes[$j]['bet_amount'].'<br>';

            }

        }
        return $data->toArray();

    }

    //投注金额汇总统计
    function MoneyCount($where = '') {
        $data = array();
        $data['all_money'] = $this->sum('money');
        $data['all_prize_money'] = $this->sum('prize_money');
        $data['alraedy_prize_money'] = $this->where('game_status','1')->sum('prize_money');
        if (!empty($where) && is_array($where)) {
            $data['all_money'] = $this->where($where)->sum('money');
            $data['all_prize_money'] = $this->where($where)->sum('prize_money');
            $data['alraedy_prize_money'] = $this->where($where)->where('game_status','1')->sum('prize_money');
        }

        return $data;
    }


}