0) { $data = $this ->join('money_details','money_details.info_identity','=','money_buy_str.info_identity') ->select('money_buy_str.id','money_buy_str.account_name','money_buy_str.order_id','money_buy_str.str_type','money_buy_str.money','money_buy_str.prize_money','money_buy_str.status','money_buy_str.money_time','money_buy_str.settle_status','money_buy_str.game_status','money_buy_str.gain_money','money_details.money_cash','money_buy_str.batch_id') ->where($where) ->orderby('money_buy_str.money_time','desc') ->paginate ($list); } else { $data = $this ->join('money_details','money_details.info_identity','=','money_buy_str.info_identity') ->select('money_buy_str.id','money_buy_str.account_name','money_buy_str.order_id','money_buy_str.str_type','money_buy_str.money','money_buy_str.prize_money','money_buy_str.status','money_buy_str.money_time','money_buy_str.settle_status','money_buy_str.game_status','money_buy_str.gain_money','money_details.money_cash','money_buy_str.batch_id') ->orderby('money_buy_str.money_time','desc') ->paginate ($list); } if (!$data < 0) { return -2021052003; // } for($i=0;$istatus==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]->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 = '未中奖'; } //$str_type = str_replace('*', '串', $data[$i]->str_type); $mun = explode('串',$data[$i]->str_type); $data[$i]->detail_content = $data[$i]->settle_status.'：'.$mun[0].' [ 详情 ]'; //反水 $data[$i]->water_return = '0'; $water_return_money = \App\Models\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]->money_match_time = '投注：'.$data[$i]->money_time; //用户投注后账户金额 $data[$i]->frozen_cash = ''; $data[$i]->frozen_cash = $water_return_money->money_cash; //用户投注前账户金额 $data[$i]->available_cash = $data[$i]->money_cash+$data[$i]->money; $data[$i]->account = $data[$i]->available_cash.' '.$data[$i]->account_name.' '.$data[$i]->frozen_cash; if($data[$i]->settle_status == '未结算'){ $result = array(); $matchs = \App\Models\MoneyBuyMatch::where('batch_id',$data[$i]->batch_id)->where('bet_type','2')->get(); for($j=0;$jresult; } if(in_array(0,$result)){ $data[$i]->settle_status = $data[$i]->settle_status.'
结算 '; }else{ $data[$i]->settle_status = $data[$i]->settle_status.'
结算 '; } }else if($data[$i]->settle_status == '已结算'){ // $data[$i]->settle_status = $data[$i]->settle_status.'
重新结算 '; $data[$i]->settle_status = $data[$i]->settle_status.'
已结算 '; } } 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; } //获取串关注单详情信息 function getdetailinfo($id) { $res = $this->where('id',$id)->first(); $data = \App\Models\MoneyBuyMatch::where('batch_id',$res->batch_id)->where('bet_type','2')->get(); $game_type = \App\Models\StGameType::get(); for($i=0;$igame_code.'_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; } $odds_code = \App\Models\Matchcode::where('odds_code',$data[$i]->odds_code)->first(); if(!empty($odds_code)){ $data[$i]->odds_code = $odds_code->odds_name; } $data[$i]->home_guest = $data[$i]->home_team.' VS '.$data[$i]->guest_team; for($j=0;$jgame_code == $game_type[$j]->game_code){ $data[$i]->game_type = $game_type[$j]->game_name; } } if($data[$i]->status == 0){ $data[$i]->status = '未结算'; }else if($data[$i]->status == 1){ $data[$i]->status = '已结算'; } if($data[$i]->result == -1){ $data[$i]->result = '输'; }else if($data[$i]->result == 0){ $data[$i]->result = '未处理'; }else if($data[$i]->result == 1){ $data[$i]->result = '赢'; }else if($data[$i]->result == 2){ $data[$i]->result = '平'; }else if($data[$i]->result == 3){ $data[$i]->result = '赢半平半'; }else if($data[$i]->result == 4){ $data[$i]->result = '输半平半'; } } return $data->toArray(); } }