0) { $data = $this->join('money_details','money_details.info_identity','=','money_buy_str.info_identity') ->select('money_buy_str.id','money_buy_str.order_id','money_buy_str.account_name','money_buy_str.game_name','money_buy_str.money','money_buy_str.prize_money','money_buy_str.water_status','money_buy_str.money_time','money_buy_str.settle_status','money_details.money_cash') ->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.order_id','money_buy_str.account_name','money_buy_str.game_name','money_buy_str.money','money_buy_str.prize_money','money_buy_str.water_status','money_buy_str.money_time','money_buy_str.settle_status','money_details.money_cash') ->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]->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]->game_name = str_replace('*', '串', $data[$i]->game_name); $mun = explode('串',$data[$i]->game_name); $data[$i]->detail_content = $data[$i]->settle_status.'：'.$mun[0].' [ 详情 ]'; $data[$i]->money_match_time = '投注：'.$data[$i]->money_time; $data[$i]->frozen_cash = $data[$i]->money_cash; $data[$i]->available_cash = $data[$i]->money_cash+$data[$i]->money.'.00'; $data[$i]->account = $data[$i]->available_cash.' '.$data[$i]->account_name.' '.$data[$i]->frozen_cash; $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'); if (!empty($where) && is_array($where)) { $data['all_money'] = $this->where($where)->sum('money'); $data['all_prize_money'] = $this->where($where)->sum('prize_money'); } return $data; } //获取串关注单详情信息 function getdetailinfo($id) { $res = $this->where('id',$id)->first(); $data = DB::table('st_bet_str')->where('id',$res->bet_str_id)->first(); $codes = json_decode($data->bet_srt_all, true); for($i=0;$iwhere('odds_code',$codes[$i]['ganame'])->first(); $codes[$i]['odds_code'] = $oddscode->odds_name; $type = DB::table('st_game_type')->where('game_code',$codes[$i]['ballId'])->first(); $codes[$i]['game_type'] = $type->game_name; } return $codes; } }