join('money_details','money_details.info_identity','=','money_buy_simplex.info_identity') ->join('st_'.$type.'_competition','st_'.$type.'_competition.match_id','=','money_buy_simplex.match_id') ->join('st_'.$type.'_league','st_'.$type.'_competition.lg_id','=','st_'.$type.'_league.lg_id') ->select('money_buy_simplex.id','money_buy_simplex.account_name','money_buy_simplex.order_id','money_buy_simplex.money','money_buy_simplex.prize_money','money_buy_simplex.status','money_buy_simplex.money_time','money_buy_simplex.settle_status','money_buy_simplex.gain_money','money_buy_simplex.game_code','money_buy_simplex.match_id','money_buy_simplex.game_status','st_'.$type.'_competition.home_team','st_'.$type.'_competition.guest_team','st_'.$type.'_competition.match_date','st_'.$type.'_competition.match_time','st_'.$type.'_competition.lg_id','money_details.money_cash','money_buy_simplex.batch_id','st_'.$type.'_league.name_chinese') ->where($where) ->orderby('money_buy_simplex.money_time','desc') ->paginate ($list); if (!$data < 0) { return -2021052003; // } for($i=0;$isettle_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 = '输'; } $data[$i]->match_id_order = ''.$data[$i]->match_id.'
'.$data[$i]->order_id; $data[$i]->league = $data[$i]->name_chinese; //反水 $data[$i]->water_return = '0'; $water_return_money = DB::table('money_details')->where('trade_id',$data[$i]->order_id)->where('trade_type','7')->first(); if(!empty($water_return_money)){ $data[$i]->water_return = $water_return_money->money; } $data[$i]->result = $data[$i]->water_return+$data[$i]->gain_money; $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.'
'.$data[$i]->match_time; //用户投注后账户金额 $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.'
'.$data[$i]->account_name.'
'.$data[$i]->frozen_cash; $content = DB::table('money_buy_match')->where('batch_id',$data[$i]->batch_id)->where('match_id',$data[$i]->match_id)->get(); if($content[0]->result == '0'){ $data[$i]->game_status = $data[$i]->game_status.'
结算 '; }else{ if($data[$i]->game_status == '未处理'){ $data[$i]->game_status = $data[$i]->game_status.'
结算 '; }else{ //$data[$i]->game_status = $data[$i]->game_status.'
重新结算 '; $data[$i]->game_status = $data[$i]->game_status.'
已结算 '; } } for($j=0;$jodds_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. '￥'.$content[$j]->bet_money.'@'.$content[$j]->odds.'
'; } } 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('settle_status','2')->sum('gain_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('settle_status','2')->sum('gain_money'); } return $data; } }