'待审核',1=>'已通过',2=>'驳回']; $arr2 = ['sign'=>'签到彩金','first_save'=>'首冲彩金','upgrade'=>'晋级彩金']; $id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; $uid = isset($data['uid']) ? $data['uid'] : ''; $money_type = isset($data['money_type']) ? $data['money_type'] : ''; //资金类型 $data_codes = lm("lottery_money_log", "Commons")->where('account_identity', $id_one)->where('id', $uid)->first(); $data_codes['vip_name'] = lm("dc_user_grade", "Commons")->where('grade', $data_codes['grade'])->first()['name']; $data_codes['list'] = lm("lottery_money_log", "Commons")->where('lottery_money_type', $money_type)->where('account_identity', $id_one)->select('lottery_money_type','create_time','status','id')->orderBy('create_time','desc')->get()->toArray(); $data=$data_codes->toArray(); $data['status_name']=$arr1[$data_codes['status']]; $data['money_type_name']=$arr2[$data_codes['lottery_money_type']]; foreach ($data['list'] as $key =>$value){ $data['list'][$key]['lottery_money_type']=$arr2[$value['lottery_money_type']]; $data['list'][$key]['status_name']=$arr1[$value['status']]; $data['list'][$key]['status']=$value['status']; } return $data; } /** * cToUpgrade * @param $data * @return array * 由 ikeke 修改于2018-12-10 修改内容:数据输出时的结构对于 APP 端不友好解析不出来 */ function cToUpgrade($data){ $obj_money_log=lm("lottery_money_log", "commons"); $arr1 = [0=>'待审核',1=>'已通过',2=>'驳回']; $id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; //用户唯一id $create_time = isset($data['create_time']) ? $data['create_time'] : ''; $page = isset($data['page']) ? $data['page'] : '1'; $where = ''; $time = date("Y-m-d 00:00:00",strtotime($create_time)); $timeday= date("Y-m-d 23:59:59",strtotime($create_time)); $yesterday1= date("Y-m-d 00:00:00",strtotime("-1 day",strtotime($create_time))); $yesterday2= date("Y-m-d 23:59:59",strtotime("-1 day",strtotime($create_time))); $tomorrow1= date("Y-m-d 00:00:00",strtotime("1 day",strtotime($create_time))); $tomorrow2= date("Y-m-d 23:59:59",strtotime("1 day",strtotime($create_time))); if (preg_match('/^(\d{4}-\d{2}-\d{2})?$/',$create_time)){ $where .="create_time >= '{$time}' and create_time <= '{$timeday}'"; }else{ return -5005; } $where .=" AND account_identity='{$id_one}'"; $list = 10; $first = ($page - 1) * $list; $row =$obj_money_log->orderBy('create_time', 'desc')->whereRaw($where)->offset($first)->select('lottery_money_name','money','status','create_time','id','lottery_money_type')->limit($list)->get(); if (!$row) { return -5004; } $rows['lists'] = $row->toArray(); foreach($rows['lists'] as $key =>$value){ $rows['lists'][$key]['status_name']=$arr1[$value['status']]; } //前一天 和 后一天 $yesterday ="account_identity='{$id_one}' AND create_time >'{$yesterday1}' AND create_time <= '{$yesterday2}'"; $tomorrow="account_identity='{$id_one}' AND create_time >= '{$tomorrow1}' AND create_time <= '{$tomorrow2}'"; //统计 $where_s = "lottery_money_type ='sign' AND account_identity='{$id_one}' AND {$where}"; $where_f = "lottery_money_type ='first_save' AND account_identity='{$id_one}' AND {$where}"; $where_u = "lottery_money_type ='upgrade' AND account_identity='{$id_one}' AND {$where}"; //前一天 和 后一天 $rows['yesterdayCount']=$obj_money_log->whereRaw($yesterday)->sum('money'); $rows['tomorrow']=$obj_money_log->whereRaw($tomorrow)->sum('money'); $rows['countS']=$obj_money_log->whereRaw($where)->sum('money'); $rows['signCount']=$obj_money_log->whereRaw($where_s)->sum('money'); $rows['firstCount']=$obj_money_log->whereRaw($where_f)->sum('money'); $rows['upgradeCount']=$obj_money_log->whereRaw($where_u)->sum('money'); if ($rows['lists']){ $rows['is_k']=1; }else{ $rows['is_k']=0; } return $rows; } /* * 账号明细记录 */ function Winning($data) { $time = date("Y-m-d 00:00:00",time()); $id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; //用户唯一id $status = isset($data['status']) ? $data['status'] : ''; //资金状态 $money_type = isset($data['trade_type']) ? $data['trade_type'] : ''; //资金类型 $page = isset($data['page']) ? $data['page'] : '1'; //资金类型 $money_time = isset($data['money_time']) ? $data['money_time'] : ''; //添加时间 $field = isset($data['field']) ? $data['field'] : 'money_time'; //排序字段 $orderby = isset($data['orderby']) ? $data['orderby'] : 'desc'; //排序 if (empty($id_one)) { return -4010; } $arrmt = explode('|', $money_type); if(isset($arrmt[1])){ $money_type = $arrmt[1]; } $arr = [ //向数据库追加数组 然后循环出来 'trade_type' => $money_type, 'status' => $status, 'account_identity' => $id_one, ]; $where = 'status = 1'; $timeday= date("Y-m-d 23:59:59"); $week=date("Y-m-d 23:59:59",strtotime("last week")); $month=date("Y-m-d 23:59:59",strtotime("last month")); $twomonth=date("Y-m-d 23:59:59",strtotime("-0 year -2 month -0 day")); $sixmonth=date("Y-m-d 23:59:59",strtotime("-0 year -6 month -0 day")); if(is_array($money_time) && count($money_time)==2){ $time = date('Y-m-d 00:00:00',strtotime($money_time[0])); $timeday = date('Y-m-d 23:59:59',strtotime($money_time[1])); $where .=" AND money_time >='{$time}' AND money_time <= '{$timeday}'"; }else if(is_array($money_time) && count($money_time)==1 && !empty($money_time[0])){ $time = date('Y-m-d 00:00:00',strtotime($money_time[0])); $timeday = date('Y-m-d 23:59:59',strtotime($money_time[0])); $where .=" AND money_time >='{$time}' AND money_time <= '{$timeday}'"; }else if (!empty($money_time)){ switch ($money_time){ case 1: $where .=" AND money_time >='{$time}' AND money_time < '{$timeday}'"; break; case 2: $where .=" AND money_time >= '{$week}' and money_time < '{$time}'"; break; case 3: $where .=" AND money_time >='{$month}' and money_time < '{$time}'"; break; case 4: $where .=" AND money_time >='{$twomonth}' and money_time < '{$time}'"; break; case 5: $where .=" AND money_time >='{$sixmonth}' and money_time < '{$time}'"; break; default: break; } } foreach ($arr as $key => $value) { //循环数组 if($key=='trade_type' && !empty($value)){ $where .= " AND {$key} in ({$value}) "; //获取值 }else if ($value != '' && $key != 'a.id' && $key != 'b.id') { //判断条件 $where .= " AND {$key}='{$value}'"; //获取值 } } $where = str_replace('19-1,19-2', '19', $where); $where = str_replace('19-1', '19', $where); $where = str_replace('19-2', '19', $where); $list = 20; //获取总页数 //return $where; $count_list = lm("money_details", "commons")->whereRaw($where)->count(); $count_page = ceil($count_list / $list); $first = ($page - 1) * $list; $rows = lm("money_details", "commons") ->orderBy('money_time', 'desc')->whereRaw($where)->offset($first)->limit($list)->orderby($field,$orderby)->get(); if (!$rows) { return -5004; } $rows = $rows->toArray(); $money_type = $this->GetMonetType(); $Winning = $this->GetStatus(); foreach ($Winning as $key => $v) { foreach ($rows as $k => $val) { if ($val['status'] == $key) { $val['is_status']=$val['status']; $val['status'] = lang()->get($v); $rowr[] = $val; } } } foreach ($rowr as $k => $v) { if(in_array($v['trade_type'], array(1,2,3))){ $buyinfo = lm('Money_buy','Commons')->select('game_name')->where('order_id',$v['trade_id'])->first(); if(!$buyinfo || count($buyinfo->toArray())<1){ $buyinfo = lm('SixMoney_buy','Commons')->select('game_name')->where('order_id',$v['trade_id'])->first(); if($buyinfo && isset($buyinfo->game_name))$v['gname'] = $buyinfo->game_name; }else{ $v['gname'] = $buyinfo->game_name; } } foreach ($money_type as $key => $val) { if ($v['trade_type'] == $key) { $v['trade_type_id'] = $v['trade_type']; if($v['trade_type']==19){ if($v['money_type']==1){ $v['trade_type'] = '额度转入'; }else{ $v['trade_type'] = '额度转出'; } }else{ $v['trade_type'] = lang()->get($val['name']); } if($v['money_type']==1){ $v['money'] = '+'. $v['money']; }else{ $v['money'] = '-'. $v['money']; } $ro[] = $v; } } } return $ro; } /*统计账户分类总额*/ public function AccountSum($data){ $time = date("Y-m-d 00:00:00",time()); $id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; //用户唯一id $money_type = isset($data['trade_type']) ? $data['trade_type'] : ''; //资金类型 $page = isset($data['page']) ? $data['page'] : '1'; //资金类型 $money_time = isset($data['money_time']) ? $data['money_time'] : ''; //添加时间 if (empty($id_one)) { return -4010; } $arrmt = explode('|', $money_type); if(isset($arrmt[1])){ $money_type = $arrmt[1]; } $arr = [ //向数据库追加数组 然后循环出来 'trade_type' => $money_type, 'account_identity' => $id_one, ]; $where = 'status = 1'; $timeday= date("Y-m-d 23:59:59"); $week=date("Y-m-d 23:59:59",strtotime("last week")); $month=date("Y-m-d 23:59:59",strtotime("last month")); $twomonth=date("Y-m-d 23:59:59",strtotime("-0 year -2 month -0 day")); $sixmonth=date("Y-m-d 23:59:59",strtotime("-0 year -6 month -0 day")); if(is_array($money_time) && count($money_time)==2){ $time = date('Y-m-d 00:00:00',strtotime($money_time[0])); $timeday = date('Y-m-d 23:59:59',strtotime($money_time[1])); $where .=" AND money_time >='{$time}' AND money_time <= '{$timeday}'"; }else if (!empty($money_time) && !empty($money_time[0]) && !is_numeric($money_time[0])){ $time = date('Y-m-d 00:00:00',strtotime($money_time[0])); $timeday = date('Y-m-d 23:59:59',strtotime($money_time[0])); $where .=" AND money_time >='{$time}' AND money_time <= '{$timeday}'"; }else if (!empty($money_time)){ switch ($money_time){ case 1: $where .=" AND money_time >='{$time}' AND money_time < '{$timeday}'"; break; case 2: $where .=" AND money_time >= '{$week}' and money_time < '{$time}'"; break; case 3: $where .=" AND money_time >='{$month}' and money_time < '{$time}'"; break; case 4: $where .=" AND money_time >='{$twomonth}' and money_time < '{$time}'"; break; case 5: $where .=" AND money_time >='{$sixmonth}' and money_time < '{$time}'"; break; default: break; } } foreach ($arr as $key => $value) { //循环数组 if($key=='trade_type' && !empty($value)){ $where .= " AND {$key} in ({$value}) "; //获取值 }else if ($value != '' && $key != 'a.id' && $key != 'b.id') { //判断条件 $where .= " AND {$key}='{$value}'"; //获取值 } } $list = 10; $first = ($page - 1) * $list; //获取总页数 $sql = "SELECT sum(money),trade_type,money_type FROM money_details where " . $where . " group by trade_type,money_type"; $res = S ('DB')->select ($sql); $res = json_encode($res); $res = json_decode($res,1); $ttype = $this->Tradetype(); $sum = array(); for($i=1;$i<23;$i++){ if($i==19){ $sum['19-1']=0; $sum['19-2']=0; }else{ $sum[$i]=0; } } foreach ($res as $k => $v) { if($v['trade_type']==22){ if($v['money_type']==1){ $sum[$v['trade_type']] += $v['sum']; }else{ $sum[$v['trade_type']] -= $v['sum']; } }else if($v['trade_type']==19){ $tk = $v['trade_type'] . '-' . $v['money_type']; $sum[$tk] = $v['sum'] + $sum[$tk]; }else{ $sum[$v['trade_type']] = $v['sum'] + $sum[$v['trade_type']]; } } return $sum; } //交易类型 private function Tradetype(){ return array( '1' => '投注', '2' => '追号', '3' => '撤单', '4' => '中奖', '5' => '提现', '6' => '在线充值', '7' => '返水', '8' => '回水', '9' => '管理员扣款', '10' => '佣金提成', '11' => '后台充值', '12' => '活动', '13' => '充值赠送', '14' => '汇款', '15' => '冻结提现', '16' => '红包打赏', '19' => '额度转账', '19-1' => '额度转入', '19-2' => '额度转出', '22' => '代理代充', ); } /*** * 六合投注列表 * @param $data * @return mixed */ public function SixBettingRecord($data) { $id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; //用户唯一id $status = isset($data['status']) ? $data['status'] : ''; //资金状态 $order_id = isset($data['order_id']) ? $data['order_id'] : ''; //资金类型 $game_status = isset($data['game_status']) ? $data['game_status'] : ''; //资金类型 $page = isset($data['page']) ? $data['page'] : '1'; //资金类型 //return $page; $play_num = ""; if (empty($id_one)) { return -4010; } $arr = [ //向数据库追加数组 然后循环出来 'status' => $status, 'account_identity' => $id_one, 'order_id' => $order_id, 'game_status' => $game_status, ]; $where = '1 = 1'; foreach ($arr as $key => $value) { //循环数组 if ($value != '' && $key != 'a.id' && $key != 'b.id') { //判断条件 $where .= " AND {$key}='{$value}'"; //获取值 } } $list = 10; //获取总页数 $count_list = lm("sixMoney_buy", "commons")->whereRaw($where)->count(); $count_page = ceil($count_list / $list); $first = ($page - 1) * $list; $code_data = lm("sixMoney_buy", "commons") ->whereRaw($where)->orderBy('money_time', 'desc') ->offset($first)->limit($list)->get(); if (!$code_data) { return -5004; } $code_data = $code_data->toArray(); foreach ($code_data as $k=>$v){ $data_codes = lm($v['game_name'], "Commons")->select('status')->where('info_no', $v['game_no'])->first(); if ($data_codes){ $data_codes=$data_codes->toArray(); $code_data[$k]['gamed_status']=$data_codes['status']; } } $Winning = $this->GetMoneyStatus(); $Status = $this->GetWinStatus(); foreach ($code_data as $k => $val) { $val['game_type'] = lang()->get($val['game_name']); foreach ($Winning as $key => $v) { //return $val['status']; if ($val['status'] == $key) { $val['status'] = lang()->get($v); $row[] = $val; } } } foreach ($Status as $key => $v) { foreach ($row as $k => $val) { if ($val['game_status'] == $key) { $val['game_status'] = lang()->get($v); $index = $val['id']; $rowy[$index] = $val; //$aa[]=$val; } } } rsort($rowy); return $rowy; } /* * 投注记录 */ public function BettingRecord($data) { $id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; //用户唯一id $status = isset($data['status']) ? $data['status'] : ''; //资金状态 $order_id = isset($data['order_id']) ? $data['order_id'] : ''; //资金类型 $game_status = isset($data['game_status']) ? $data['game_status'] : ''; //资金类型 $game_name = isset($data['game_name']) ? $data['game_name'] : ''; //资金类型 $page = isset($data['page']) ? $data['page'] : '1'; //资金类型 //return $page; $play_num = ""; if (empty($id_one)) { return -4010; } $arr = [ //向数据库追加数组 然后循环出来 'status' => $status, 'account_identity' => $id_one, 'order_id' => $order_id, 'game_status' => $game_status, 'game_name' => $game_name, ]; $account = lm("game_type", "commons"); $game = $account->where("status", "=", "1")->get()->toArray(); //return $game; $where = '1 = 1'; foreach ($arr as $key => $value) { //循环数组 if ($value != '' && $key != 'a.id' && $key != 'b.id') { //判断条件 $where .= " AND {$key}='{$value}'"; //获取值 } } //return $where; //$code_data = lm("money_buy", "commons")->whereRaw($where)->get(); $list = 10; //获取总页数 $count_list = lm("money_buy", "commons")->whereRaw($where)->count(); $count_page = ceil($count_list / $list); $first = ($page - 1) * $list; //$code_datas = $accountd->orderBy('money_time', 'desc')->whereRaw($where)->offset($first)->limit($list)->get(); $code_data = lm("money_buy", "commons") ->whereRaw($where)->orderBy('money_time', 'desc') ->offset($first)->limit($list)->get(); if (!$code_data) { return -5004; } $code_data = $code_data->toArray(); $Winning = $this->GetMoneyStatus(); $Status = $this->GetWinStatus(); foreach ($code_data as $k => $val) { $val['game_type'] = lang()->get($val['game_name']); foreach ($Winning as $key => $v) { //return $val['status']; if ($val['status'] == $key) { $val['status'] = lang()->get($v); $row[] = $val; } } } foreach ($Status as $key => $v) { foreach ($row as $k => $val) { if ($val['game_status'] == $key) { $val['game_status'] = lang()->get($v); $index = $val['id']; $rowy[$index] = $val; //$aa[]=$val; } } } rsort($rowy); return $rowy; } /* * 长龙近期投注记录 */ public function LongBetRecords($data) { $id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; //用户唯一id $status = isset($data['status']) ? $data['status'] : ''; //资金状态 $game_status = isset($data['game_status']) ? $data['game_status'] : ''; //资金类型 $game_name = isset($data['game_name']) ? $data['game_name'] : ''; //资金类型 $page = isset($data['page']) ? $data['page'] : '1'; //资金类型 //return $page; $play_num = ""; if (empty($id_one)) { return -4010; } $arr = [ //向数据库追加数组 然后循环出来 'status' => $status, 'account_identity' => $id_one, 'game_status' => $game_status, 'game_name' => $game_name, ]; //$gamelist = lm("game_type", "commons")->select('name','table_name')->where("status", "=", "1")->get()->toArray(); //print_r($gamelist);exit; $where = '1 = 1'; foreach ($arr as $key => $value) { //循环数组 if ($value != '' && $key != 'a.id' && $key != 'b.id') { //判断条件 $where .= " AND {$key}='{$value}'"; //获取值 } } $list = 10; //获取总页数 $count_list = lm("money_buy", "commons")->whereRaw($where)->count(); $count_page = ceil($count_list / $list); $first = ($page - 1) * $list; $code_data = lm("money_buy", "commons")->select('game_name','game_no','money','prize_money','game_status','order_id','money_time','status') ->whereRaw($where)->orderBy('money_time', 'desc') ->offset($first)->limit($list)->get(); if (!$code_data) { return -5004; } $code_data = $code_data->toArray(); //print_r($code_data); $Status = array("1" => "win", "2" => "notwin", "0" => "audit", "3" => "killorder"); foreach ($code_data as $k => $val) { $code_data[$k]['game_type'] = lang()->get($val['game_name']); $code_data[$k]['game_status'] = $val['status']==4?'已撤单':lang()->get($Status[$val['game_status']]); } //rsort($code_data); return $code_data; } //即时开奖游戏记录 public function CurBetRecord($data){ $id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; //用户唯一id $game_name = isset($data['game_name']) ? $data['game_name'] : ''; //资金状态 if (empty($game_name)) { return ""; } $play_num = ""; if (empty($id_one)) { return -4010; } $code_data = lm($game_name, "commons")->orderBy('create_time', 'desc')->where('account_identity',$id_one)->get(); if (empty($code_data)) { return ""; } else { $code_data = $code_data->toArray(); } return $code_data; } /* * 投注未开奖 */ public function NotBetRecord($data) { $id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; //用户唯一id $game_name = isset($data['game_name']) ? $data['game_name'] : ''; //资金状态 if (empty($game_name)) { return ""; } $no = isset($data['no']) ? $data['no'] : ''; //资金类型 $delstatus = isset($data['delstatus']) ? $data['delstatus'] : '1'; $status = isset($data['status']) ? $data['status'] : '0'; $play_num = ""; if (empty($id_one)) { return -4010; } $game = new \Biz\Game\GameQuery; $no = $game->getNo($game_name); $arr = [ //向数据库追加数组 然后循环出来 'no' => $no, 'status' => $status, 'account_identity' => $id_one, 'delstatus' => $delstatus, ]; $where = '1 = 1'; foreach ($arr as $key => $value) { //循环数组 if ($value != '' && $key != 'a.id' && $key != 'b.id') { //判断条件 $where .= " AND {$key}='{$value}'"; //获取值 } } $name = $game_name . "_buy"; $code_data = lm($name, "commons")->orderBy('open_time', 'desc')->whereRaw($where)->get(); if (empty($code_data)) { return ""; } else { $code_data = lm($name, "commons")->orderBy('open_time', 'desc')->whereRaw($where)->get()->toArray(); } //return $game_name; //var_dump($code_data); foreach ($code_data as $o => $v) { $tab_name = "bjpk10Parse"; $nums = C()->get($tab_name); $data_paramt = json_decode($v['codes'], 1); //var_dump($data_paramt); //echo 1; if (array_key_exists("head_three", $data_paramt)) { $paramt = $this->CodeData($data_paramt,3,$game_name); } elseif (array_key_exists("head_two", $data_paramt)) { $paramt = $this->CodeData($data_paramt,2,$game_name); //return $data_paramt; } elseif (array_key_exists("specialthree", $data_paramt)) { $paramt = $this->CodesDatas($data_paramt,3,$game_name); } elseif (array_key_exists("fivestar", $data_paramt)) { $paramt = $this->CodesDatas($data_paramt,5,$game_name); } elseif (array_key_exists("fourstar", $data_paramt)) { $paramt = $this->CodesDatas($data_paramt,4,$game_name); //return $data_paramt; } elseif (array_key_exists("behindthreestar", $data_paramt)) { $paramt = $this->CodesDatas($data_paramt,3,$game_name); //return $data_paramt; } elseif (array_key_exists("frontthreestar", $data_paramt)) { $paramt = $this->CodesDatas($data_paramt,3,$game_name); //return $data_paramt; } elseif (array_key_exists("fronttwostar", $data_paramt)) { $paramt = $this->CodesDatas($data_paramt,2,$game_name); //return $data_paramt; } else { $datat = [ 'codes' => $v['codes'], ]; $paramt = $nums->change($datat,$game_name); } /*echo '
';
print_r($data_paramt);
print_r($paramt);*/
foreach ($paramt as $v) {
//var_dump($v);
$CodeDate = lang()->get($v['codeDate']);
$play_num .= $v['codes'] . "(¥" . $v['money'] . ") ";
}
$code_data[$o]['num'] = count($paramt);
$code_data[$o]['codeDate'] = $CodeDate;
$code_data[$o]['coded'] = $play_num;
$play_num = "";
}
return $code_data;
}
/*
* 中奖记录
*/
function Profit($data)
{
//$id_one = $_SESSION['uinfo']['account_identity'];
//return 1111;
$id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; //用户唯一id
if (empty($id_one)) {
return -4010;
}
$arr = [ //向数据库追加数组 然后循环出来
'account_identity' => $id_one,
];
$where = '1 = 1';
foreach ($arr as $key => $value) {
//循环数组
if ($value != '' && $key != 'a.id' && $key != 'b.id') { //判断条件
$where .= " AND {$key}='{$value}'"; //获取值
}
}
$rows = lm("money_prize", "commons")->orderBy('money_time', 'desc')->whereRaw($where)->get();
//return $rows;
if (count($rows) != 0) {
$rows = lm("money_prize", "commons")->orderBy('money_time', 'desc')->whereRaw($where)->get()->toArray();
$account = lm("game_type", "commons");
$game = $account->where("status", "=", "1")->get()->toArray();
foreach ($rows as $k => $val) {
foreach ($game as $v) {
if ($v['name'] == $val['game_name']) {
$tal_name = $v['table_name'] . "_buy";
$dat = lm($tal_name, "commons")->where("order_id", $val['buy_identity'])->first();
if (count($dat) != 0) {
$dat = lm($tal_name, "commons")->where("order_id", $val['buy_identity'])->first()->toArray();
$rows[$k]['no'] = $dat['no'];
$rows[$k]['bet_money'] = "-" . $dat['money'];
} else {
$rows[$k]['no'] = 0;
$rows[$k]['bet_money'] = 0;
}
}
}
}
} else {
return "";
}
$Winning = $this->GetStatus();
foreach ($Winning as $key => $v) {
foreach ($rows as $k => $val) {
if ($val['status'] == $key) {
$val['status'] = lang()->get($v);
$val['trade_type'] = lang()->get("Winning");
$val['money'] = "+" . $val['money'];
$rowr[] = $val;
}
}
}
$len = count($rowr);
for ($i = 0; $i < $len; $i++) {
for ($j = $len; $j < $len - $i; $j--) {
if ($rowr[$i]['money_time'] > $rowr[$j]['money_time']) {
$temp = $rowr[$i];
$rowr[$j] = $rowr[$i];
$rowr[$i] = $temp;
}
}
}
return $rowr;
}
//资金流水订单详情
function MorderDetail($order_id){
$info = lm('money_details','Commons')->where('trade_id',$order_id)->first();
if($info && count($info->toArray())>0){
$info = $info->toArray();
$ttype = $this->Tradetype();
$info['tradename'] = $ttype[$info['trade_type']];
$info['money_time'] = date('Y-m-d H:i:s',strtotime($info['money_time']));
$td = explode('订单号', $info['trade_desc']);
if($info['trade_type']==22){
if($info['money_type'] == 2)$info['trade_desc'] = str_replace('代理'.$info['account_name'].'为下级', '您为', $td[0]);
if($info['money_type'] == 1)$info['trade_desc'] = str_replace('下级会员'.$info['account_name'], '您', $td[0]);
}else if($info['trade_type']==12){
if($info['money_type']==1){
$info['trade_desc'] = '系统为您添加活动金额:' . $info['money'] . '元。';
}else{
$info['trade_desc'] = '系统为您扣除活动金额:' . $info['money'] . '元。';
}
}else if($info['trade_type']==13){
$info['trade_desc'] = '系统为您充值赠送:' . $info['money'] . '元。';
}else if($info['trade_type']==14){
$info['trade_desc'] = '您汇款充值:' . $info['money'] . '元。';
}else if($info['trade_type']==11){
$info['trade_desc'] = '系统为您添加金额' . $info['money'] . '元;';
}else if($info['trade_type']==9){
$info['trade_desc'] = '系统为您扣除金额' . $info['money'] . '元;';
}else{
$td[0] = str_replace($info['account_name'], '您', $td[0]);
$td[0] = str_replace('反水', '返水', $td[0]);
$info['trade_desc'] = $td[0];
}
return $info;
}
return -4047;
}
/*
* 提现记录
*/
function Recharge($data)
{
//$id_one = $_SESSION['uinfo']['account_identity'];
$id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; //用户唯一id
//return $id_one;
$status = isset($data['status']) ? $data['status'] : ''; //资金状态
$order_id = isset($data['order_id']) ? $data['order_id'] : ''; //资金状态
$page = isset($data['page']) ? $data['page'] : '1'; //资金类型
if (empty($id_one)) {
return -4010;
}
$arr = [ //向数据库追加数组 然后循环出来
'status' => $status,
'account_identity' => $id_one,
'order_id' => $order_id,
];
$where = '1 = 1';
foreach ($arr as $key => $value) {
//循环数组
if ($value != '' && $key != 'a.id' && $key != 'b.id') { //判断条件
$where .= " AND {$key}='{$value}'"; //获取值
}
}
$list = 30;
//获取总页数
$count_list = lm("money_recharge", "commons")->whereRaw($where)->count();
$count_page = ceil($count_list / $list);
$first = ($page - 1) * $list;
//$code_datas = $accountd->orderBy('money_time', 'desc')->whereRaw($where)->offset($first)->limit($list)->get();
$rows = lm("money_recharge", "commons")
->whereRaw($where)->orderBy('apply_time', 'desc')
->offset($first)->limit($list)->get();
if (!$rows) {
return -5004;
}
$rows = $rows->toArray();
$Winning = $this->GetStatus();
foreach ($Winning as $key => $v) {
foreach ($rows as $k => $val) {
if ($val['status'] == $key) {
$val['statud'] = lang()->get($v);
$val['trade_type'] = lang()->get("Recharge");
$val['money'] = "+" . $val['money'];
$index = strtotime($val['apply_time']);
$rowr[$index] = $val;
}
}
}
rsort($rowr);
return $rowr;
}
/*
* 充值记录
*/
function Withdrawals($data)
{
//$id_one = $_SESSION['uinfo']['account_identity'];
$id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; //用户唯一id
$status = isset($data['status']) ? $data['status'] : ''; //资金状态
$order_id = isset($data['order_id']) ? $data['order_id'] : ''; //资金状态
$page = isset($data['page']) ? $data['page'] : '1'; //资金类型
//return 1;
if (empty($id_one)) {
return -4010;
}
$arr = [ //向数据库追加数组 然后循环出来
'status' => $status,
'account_identity' => $id_one,
'order_id' => $order_id,
];
$where = '1 = 1';
foreach ($arr as $key => $value) {
//循环数组
if ($value != '' && $key != 'a.id' && $key != 'b.id') { //判断条件
$where .= " AND {$key}='{$value}'"; //获取值
}
}
$list = 30;
//获取总页数
$count_list = lm("money_take", "commons")->whereRaw($where)->count();
$count_page = ceil($count_list / $list);
$first = ($page - 1) * $list;
//$code_datas = $accountd->orderBy('money_time', 'desc')->whereRaw($where)->offset($first)->limit($list)->get();
$rows = lm("money_take", "commons")
->whereRaw($where)->orderBy('apply_time', 'desc')
->offset($first)->limit($list)->get();
if (!$rows) {
return -5004;
}
$rows = $rows->toArray();
//return $rows;
$Winning = $this->GetStatus();
foreach ($Winning as $key => $v) {
foreach ($rows as $k => $val) {
if ($val['status'] == $key) {
$val['status'] = lang()->get($v);
$val['trade_type'] = lang()->get("Withdrawals");
$val['money'] = "-" . $val['money'];
$index = strtotime($val['apply_time']);
$rowr[$index] = $val;
}
}
}
rsort($rowr);
return $rowr;
}
//充值记录新
public function saveMoneyRecord($data){
//todo 建议按年计算数据
$time = date("Y-m-d 00:00:00",time());
//$id_one = $_SESSION['uinfo']['account_identity'];
$id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; //用户唯一id
//return $id_one;
$status = isset($data['status']) ? $data['status'] : ''; //资金状态
$order_id = isset($data['order_id']) ? $data['order_id'] : ''; //资金状态
$page = isset($data['page']) ? $data['page'] : '1'; //资金类型
$money_time = isset($data['money_time']) ? $data['money_time'] : ''; //添加时间
$time = isset($data['time']) ? $data['time'] : ''; //添加时间
if (empty($id_one)) {
return -4010;
}
if (!empty($time)) {//qtx 2018-12-20
$newtime = explode('~',$time);
if(count($newtime) ==2){
$new_time1 = $newtime[0];
$new_time2 = $newtime[1];
}else{
$new_time1 = $newtime[0];
$new_time2 = $newtime[0];
}
}
$arr = [ //向数据库追加数组 然后循环出来
'status' => $status,
'account_identity' => $id_one,
'order_id' => $order_id
];
$where = '1 = 1';
if(!empty($new_time1) && !empty($new_time2)){
//$where .= " AND complete_time >= '".$new_time1." 00:00:00' AND complete_time <='".$new_time2." 23:59:59'"; //添加时间
$where .= " AND apply_time >= '".$new_time1." 00:00:00' AND apply_time <='".$new_time2." 23:59:59' AND recharge_type in('汇款','汇款赠送','活动充值','后台充值','后台充值赠送','在线充值','在线充值赠送')"; //添加时间
}
//dump($where);
$timeday= date("Y-m-d 23:59:59");
$week=date("Y-m-d 23:59:59",strtotime("last week"));
$month=date("Y-m-d 23:59:59",strtotime("last month"));
$twomonth=date("Y-m-d 23:59:59",strtotime("-0 year -2 month -0 day"));
$sixmonth=date("Y-m-d 23:59:59",strtotime("-0 year -6 month -0 day"));
if (!empty($money_time)){
switch ($money_time){
case 1:
$where .=" AND apply_time >='{$time}' AND apply_time < '{$timeday}'";
break;
case 2:
$where .=" AND apply_time >= '{$week}' and apply_time < '{$time}'";
break;
case 3:
$where .=" AND apply_time >='{$month}' and apply_time < '{$time}'";
break;
case 4:
$where .=" AND apply_time >='{$twomonth}' and apply_time < '{$time}'";
break;
case 5:
$where .=" AND apply_time >='{$sixmonth}' and apply_time < '{$time}'";
break;
default:
break;
}
}
foreach ($arr as $key => $value) {
//循环数组
if ($value != '' && $key != 'a.id' && $key != 'b.id') { //判断条件
$where .= " AND {$key}='{$value}'"; //获取值
}
}
$rows = lm("money_recharge", "commons")
->whereRaw($where)
->orderBy('apply_time', 'desc')
->get();
if (!$rows) {
return -5004;
}
$rows = $rows->toArray();
$month = $total = 0;
$year = 0;
$ym = 0;
//2019-1-1 anton liu 修改
$months = [];
$statusType = $this->GetStatus();
foreach ($rows as $k => $v){
$ym = date('Ym',strtotime($v['apply_time']));
$month = date('m',strtotime($v['apply_time']));
$year = date('Y',strtotime($v['apply_time']));
if($v['status'] == 1){
$months[$ym]['total'] +=$v['money'];
}
$months[$ym]['month'] = $month;
$months[$ym]['year'] = $year;
$months[$ym]['ym'] = $year . '年' . intval($month);
$months[$ym]['sort'] = intval($ym);
$v['is_status'] = $v['status'];
$v['status'] = lang()-> get($statusType[$v['status']]);
$v['trade_type'] = lang()-> get("Withdrawals");
$v['pass_time'] = $v["apply_time"];
$months[$ym]['info'][] =$v;
}
array_multisort(array_column($months,'sort'), SORT_DESC,$months);
return $months;
}
//取款记录新
public function takeMoneyRecord($data){
$id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; //用户唯一id
$status = isset($data['status']) ? $data['status'] : ''; //资金状态
$order_id = isset($data['order_id']) ? $data['order_id'] : ''; //资金状态
$time = isset($data['time']) ? $data['time'] : ''; //添加时间
if (empty($id_one)) {
return -4010;
}
$arr = [ //向数据库追加数组 然后循环出来
'status' => $status,
'account_identity' => $id_one,
'order_id' => $order_id,
];
if (!empty($time)) {//qtx 2018-12-20
$newtime = explode('~',$time);
if(count($newtime) ==2){
$new_time1 = $newtime[0];
$new_time2 = $newtime[1];
}else{
$new_time1 = $newtime[0];
$new_time2 = $newtime[0];
}
}
$where = '1 = 1';
if(!empty($new_time1) && !empty($new_time2)){
$where .= " AND apply_time >= '".$new_time1." 00:00:00' AND apply_time <'".$new_time2." 23:59:59'"; //添加时间
}
//$where = "apply_time > '".date('Y')."-01-01 00:00:00'";
foreach ($arr as $key => $value) {
//循环数组
if ($value != '' && $key != 'a.id' && $key != 'b.id') { //判断条件
$where .= " AND {$key}='{$value}'"; //获取值
}
}
//todo 建议按年计算数据
$rows = lm("money_take", "commons")->whereRaw($where)->orderBy('id', 'desc')->get();
if (!$rows) {
return -5004;
}
$rows = $rows->toArray();
$month = $total = $status =0;
$statusType = $this->GetStatus();
//分月
$res =[];
foreach($rows as $r){
//$m = $r['apply_time']?date('Y年n',strtotime($r['apply_time'])):date('Y年n',strtotime($r['apply_time']));
$m = $r['apply_time']?date('n',strtotime($r['apply_time'])):date('n',strtotime($r['apply_time']));
$res["$m "][]=$r;
}
$_data=[];
foreach ($res as $d=>$x){
$_data[$d]['month']=date('Y',strtotime($x[0]['apply_time'])).'年'.$d.'月';
foreach ($x as $r){
$_data[$d]['total'] +=$r['status']==1?$r['money']:0;
$r['is_status'] = $r['status'] ;
$r['status'] = lang()-> get($statusType[$r['status']]);
$r['trade_type'] = lang()-> get("Withdrawals");
$_data[$d]['info'][]=$r;
}
}
//
// foreach ($rows as $v){
// if($month==date('m',strtotime($v['pass_time']))&&$status==1){
// $total +=$v['money'];
// }else{
// $total =$v['money'];
// $month =$v['pass_time']?date('m',strtotime($v['pass_time'])):date('m',strtotime($v['apply_time']));
// $status = $v['status'];
// }
//
// $retarray[$month]['total'] = $total;
// $retarray[$month]['month'] = $month;
// $v['is_status'] = $v['status'] ;
// $v['status'] = lang()-> get($statusType[$v['status']]);
// $v['trade_type'] = lang()-> get("Withdrawals");
// $v['pass_time'] = $v["pass_time"];
// $retarray[$month]['info'][] =$v;
// }
//
// rsort($retarray);
if(count($_data)>0){
return $_data;
}else{
//Render('',-5004);
return -5004;
}
}
/*
* 回水记录
*/
function Backwater($data)
{
//$id_one = $_SESSION['uinfo']['account_identity'];
$id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; //用户唯一id
$status = isset($data['status']) ? $data['status'] : ''; //资金状态
if (empty($id_one)) {
return -4010;
}
$arr = [ //向数据库追加数组 然后循环出来
'status' => $status,
'account_identity' => $id_one,
];
$where = '1 = 1';
foreach ($arr as $key => $value) {
//循环数组
if ($value != '' && $key != 'a.id' && $key != 'b.id') { //判断条件
$where .= " AND {$key}='{$value}'"; //获取值
}
}
$rows = lm("money_return", "commons")->whereRaw($where)->get();
if (count($rows) != 0) {
$rows = lm("money_return", "commons")->whereRaw($where)->get()->toArray();
} else {
return "";
}
$Winning = $this->GetStatus();
foreach ($Winning as $key => $v) {
foreach ($rows as $k => $val) {
if ($val['status'] == $key) {
$val['status'] = lang()->get($v);
$val['trade_type'] = lang()->get("backwater");
$val['money'] = "+" . $val['money'];
$rowr[] = $val;
}
}
}
return $rowr;
}
/*
* 投注详情显示
*/
function Details($data)
{
$play_num = "";
$order_id = isset($data['order_id']) ? $data['order_id'] : '';
$game_name = isset($data['game_name']) ? $data['game_name'] : '';
if (empty($order_id)) {
return -2001;
}
if($game_name=='zbdetail'){
$dinfo = lm('Money_buy','Commons')->where('order_id',$order_id)->first();
if(!$dinfo || count($dinfo->toArray())<1){
$dinfo = lm('SixMoney_buy','Commons')->where('order_id',$order_id)->first();
}
if(!$dinfo || count($dinfo->toArray())<1)return -2138;
$game_name = $dinfo->game_name;
}
$account = lm("game_type", "commons");
$game = $account->where("status", "=", "1")->get()->toArray();
foreach ($game as $v) {
if ($v['table_name'] == $game_name) {
//注单信息
$account = lm($v['table_name'] . "_buy", "commons");
$identity_no = $account->where("order_id", $order_id)->first();//投注表当前订单信息
if (count($identity_no) != 0) {
$identity_no = $identity_no->toArray();
} else {
return "";
}
//当期游戏信息
$value_no = lm($v['table_name'], "commons")->where("identity", $identity_no['game_identity'])->first();
if($value_no){
$value_no=$value_no->toArray();
}
$value_no['name'] = $v['table_name'];
$value_no['betstatus'] = $identity_no['status'];
if ($identity_no['status'] != '0') {
if($v['table_name'] == 'sixlottery' || $v['table_name'] == 'sfsixlottery'){
$dat = lm('sixMoney_buy', "commons")->where('order_id', $identity_no['order_id'])->first();
}else{
$dat = lm('money_buy', "commons")->where('order_id', $identity_no['order_id'])->first();
}
if (count($dat) != 0) {
$dat = $dat->toArray();
$value_no['win_money'] = $dat['prize_money'];
} else {
$value_no['win_money'] = 0;
}
}
$data_codes = lm('Sixlottery', "Commons")->select('status')->where('info_no', $identity_no['no'])->first();
if ($data_codes){
$data_codes=$data_codes->toArray();
$value_no['gamed_status']=$data_codes['status'];
}
$sfsixdata_codes = lm('Sfsixlottery', "Commons")->select('status')->where('info_no', $identity_no['no'])->first();
if ($sfsixdata_codes){
$sfsixdata_codes=$sfsixdata_codes->toArray();
$value_no['gamed_status']=$sfsixdata_codes['status'];
}
//print_r($dat);
$Winning = $this->GetWinStatus();
foreach ($Winning as $k => $t) {
if ($identity_no['delstatus'] == 1) {
if ($identity_no['status'] == $k) {
//return $t;
$value_no['whetherwin'] = lang()->get($t);
}
} else {
$value_no['whetherwin'] = lang()->get($Winning[3]);
}
}
$back = lm('money_back', "Commons")->where('buy_identity', $order_id)->first();
if (!empty($back)) {
$back = lm('money_back', "Commons")->where('buy_identity', $order_id)->first()->toArray();
$value_no['back_money'] = $back['money'];
}
$value_no['icon'] = $v['icon'];
$value_no['link'] = $v['link'];
$value_no['game_type'] = $v['name'];
$value_no['order_id'] = $identity_no['order_id'];
$value_no['money'] = $identity_no['money'];
$value_no['open_time'] = $identity_no['open_time'];
$tab_name = "bjpk10Parse";
$nums = C()->get($tab_name);
//print_r($dat);
// print_r($value_no);
$prizecodes = (isset($dat['prize']))?json_decode($dat['prize'],1):'';//开奖号码
$data_paramt = json_decode($identity_no['codes'], 1);//投注号码
//计算可重复号码组合注数
$regrouptype = $this->reGrouptype();
$grouparr = array();
foreach ($data_paramt as $key => $value) {
if(in_array($key, $regrouptype)){
foreach ($value as $sk => $sv) {
$seatarr = explode('_',$sk);
$val2=$sv;
if(isset($val2['settings'])){
unset($val2['settings']);
}
if(isset($grouparr[$seatarr[0]])){
$grouparr[$seatarr[0]] += count(val2);
}else{
$grouparr[$seatarr[0]] = count(val2);
}
}
}
foreach ($value as $ke => $val) {
foreach ($val as $k => $v) {
if($k ==='settings'){
$value_no['multiple'] = $v['multiple'];
}
}
}
}
$pgarr = array();
if(!empty($prizecodes)){
foreach ($prizecodes as $key => $value) {
if(in_array($key, $regrouptype)){
foreach ($value as $sk => $sv) {
$seatarr = explode('_',$sk);
$val2 = $sv;
if (isset($val2['settings'])) {
unset($val2['settings']);
}
if(isset($pgarr[$seatarr[0]])){
$pgarr[$seatarr[0]] += count(val2);
}else{
$pgarr[$seatarr[0]] = count(val2);
}
}
}
}
}
$paramt = $this->CodesDetails($data_paramt,$game_name,$identity_no);
//玩法分类注单金额
$ptmoney = array();
$prize_amt = $this->PrizeDetails($prizecodes,$game_name);
$parr = array();
if(is_array($prize_amt) && count($prize_amt)>0){
foreach ($prize_amt as $k => $v) {
$parr[$v['codeDate']][] = $v['codes'];
}
}
if (is_array($paramt)){
foreach ($paramt as $k=>$v){
$ptmoney[$v['codeDate']] = (isset($ptmoney[$v['codeDate']]))?($ptmoney[$v['codeDate']]+$v['money']):$v['money'];
if(in_array($v['codes'], $parr[$v['codeDate']])){
$paramt[$k]['isp'] = '中奖';
}else if($dat['game_status']==0){
$paramt[$k]['isp'] = '待开奖';
}else{
$paramt[$k]['isp'] = '未中奖';
}
if ($v['codeDate'] == 'series_twoborn' || $v['codeDate'] == 'series_fiveborn' || $v['codeDate'] == 'series_fourborn' || $v['codeDate'] == 'series_threeborn') {
$paramt[$k]['codes']=rtrim($v['codes'], ',');
}
}
$error_game_arr = ['ssc','pk10'];
$right_lang = ['mix'=>'大小单双'];
$listdata = [];
foreach ($paramt as $i=>$v) {
$listdata[$i]=$v;
$chcodes = $this->ChangeLan($game_name,$v['codes']);
$chcodes = empty($chcodes)?$v['codes']:$chcodes;
$play_num .= $chcodes . "(¥" . $v['money'] . ")" . ' ' . $v['isp'] . '
';
$CodeDate = $v['codeDate'];
$CodeDates = lang($game_name)->get($v['codeDate']);
//语言包修正---blues
foreach ($error_game_arr as $e){
if(strpos($game_name,$e)!==false){
$CodeDates = $right_lang[$v['codeDate']]??$CodeDates;
}
}
$value_no['ptypename'] = $CodeDates;
if (empty($value_no['CodeDates'])) {
$n = explode('-',$chcodes);
if(empty($n[0])){
$value_no['CodeDates'] =$chcodes;
}else{
$value_no['CodeDates'] = $n[0];
}
}
}
}else{
$CodeDate='';
$CodeDates='';
}
if (array_key_exists("general_pass", $data_paramt) || array_key_exists("join_born", $data_paramt)) {
$value_no['num'] = 1;
}else{
if(empty($grouparr)){
$value_no['num'] = count($paramt);
}else{
$value_no['num'] = 1;
foreach($grouparr as $k=>$v){
$value_no['num'] *= $v;
}
}
}
if(count($data_paramt) > 1){
$value_no['ptypename'] = '混合';
$value_no['CodeDates'] = '混合';
}
$value_no['details'] = $play_num;
$value_no['showlist'] = $listdata;
$value_no['opencodes'] = $data_paramt;
$value_no['CodeDate'] = $CodeDate;
//$value_no['CodeDates'] = $CodeDates;
}
}
$value_no['ptmoney'] = $ptmoney;
unset($value_no['prizes']);
return $value_no;
}
private function ChangeLan($gamename,$codes){
$codes = is_array($codes)?$codes:explode(',', $codes);
$res = array();
foreach ($codes as $value) {
$res[] = is_numeric($value)?$value:lang($gamename)->get($value);
}
return implode(',', $res);
}
//可重复号码玩法组合
private function reGrouptype(){
return array(
'fronttwostar',
'fourstar',
'frontthreestar',
'behindthreestar',
'fivestar'
);
}
/*
* PC投注记录
*/
public function PcBettingRecord($data,$c=-1)
{
$id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; //用户唯一id
$time1 = isset($data['time1']) ? $data['time1'] : ''; //资金状态
$time2 = isset($data['time2']) ? $data['time2'] : ''; //资金类型
$no = isset($data['no']) ? $data['no'] : ''; //资金类型
//return $no;
$game_type = isset($data['game']) ? $data['game'] : ''; //资金类型
$status = isset($data['status']) ? $data['status'] : '';
$money_time = isset($data['money_time']) ? $data['money_time'] : '';
$id = isset($data['id']) ? $data['id'] : '';
$order_id = isset($data['order_id']) ? $data['order_id'] : '';
$page = isset($data['page']) ? $data['page'] : 2;
$arrd = [ //向数据库追加数组 然后循环出来
'a.open_time' => $time1,
'b.open_time' => $time2,
'game_no' => $no,
'id' => $id,
'order_id' => $order_id,
'account_identity' => $id_one,
'status' => $status,
'game_name' => $game_type,
'money_time' => $money_time,
];
if (empty($id_one)) {
return -4010;
}
// $account = lm("game_type", "commons");
// $game = $account->where("status", "1")->get()->toArray();
//return $game;
$play_num = "";
$where = '1 = 1';
$accountd = lm('money_buy', "commons");
foreach ($arrd as $key => $value) {
//循环数组
if ($value != '' && $key != 'a.open_time' && $key != 'b.open_time') { //判断条件
$where .= " AND {$key}='{$value}'"; //获取值
}
if ($value != '' && $key == 'a.open_time') {
$where .= " AND money_time>='{$time1}'";
}
if ($value != '' && $key == 'b.open_time') {
$where .= " AND money_time<='{$time2}'";
}
}
//return $where;
$list = 10;
//统计总额
$total = $accountd->whereRaw($where)->sum('money');
if($c==1){
$countMoney = empty($total)?0:$total;
return $countMoney;
}
//获取总页数
$count_list = $accountd->whereRaw($where)->count();
$count_page = ceil($count_list / $list);
$first = ($page - 1) * $list;
$code_datas = $accountd->orderBy('money_time', 'desc')->whereRaw($where)->offset($first)->limit($list)->get();//注单信息
if (!empty($code_datas)) {
$code_data = $code_datas->toArray();
} else {
return "";
}
//return $code_data;
foreach ($code_data as $k => $v) {
$data_codes = lm($v['game_name'], "Commons")->select('status','codes', 'extra')->where('info_no', $v['game_no'])->first();
$v['game_type'] = lang()->get($v['game_name']);
if (!empty($data_codes)) {
//开奖派奖号码
if ($v['game_name'] == "xy28" || $v['game_name'] == "jnd28"|| $v['game_name'] == "gpxy28" || $v['game_name'] == "gpjnd28" || $v['game_name'] == "xjp28" || $v['game_name'] == "hs28" || $v['game_name'] == "tw28" || $v['game_name'] == "dj28"|| $v['game_name'] == "one28") {
$v['wing_codes'] = $data_codes->extra;
} else {
$v['wing_codes'] = $data_codes->codes;//
}
$v['gamed_status'] = $data_codes->status;
}
$datu[] = $v;
}
if (empty($datu)) {
return "";
}
foreach ($datu as $key => $val) {
if ($val['game_name'] == "xy28" || $val['game_name'] == "jnd28" || $val['game_name'] == 'hs28' || $val['game_name'] == "gpxy28" || $val['game_name'] == "gpjnd28" || $val['game_name'] == "tw28" || $val['game_name'] == "dj28" || $val['game_name'] == "xjp28"|| $val['game_name'] == "one28") {
$params = json_decode($val['wing_codes'], 1);
$datu[$key]['wing_codes'] = $params['code'];
}
}
foreach ($datu as $val){
$rowt[]=$this->dataChange($val,$game_type);
}
$dat = [
'total'=> $total,
'data' => $rowt,
'count_page' => $count_page,
'page' => $page,
//'where' => $datu,
];
return $dat;
// return 1;
}
/*
* PC六合投注记录
*/
public function PcSixlotteryRecord($data)
{
$id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; //用户唯一id
$time1 = isset($data['time1']) ? $data['time1'] : ''; //资金状态
$time2 = isset($data['time2']) ? $data['time2'] : ''; //资金类型
$no = isset($data['no']) ? $data['no'] : ''; //资金类型
//return $no;
$game_type = isset($data['game']) ? $data['game'] : ''; //资金类型
$status = isset($data['status']) ? $data['status'] : '';
$money_time = isset($data['money_time']) ? $data['money_time'] : '';
$id = isset($data['id']) ? $data['id'] : '';
$order_id = isset($data['order_id']) ? $data['order_id'] : '';
$page = isset($data['page']) ? $data['page'] : 2;
$arrd = [ //向数据库追加数组 然后循环出来
'a.open_time' => $time1,
'b.open_time' => $time2,
'game_no' => $no,
'id' => $id,
'order_id' => $order_id,
'account_identity' => $id_one,
'status' => $status,
'game_name' => $game_type,
'money_time' => $money_time,
];
if (empty($id_one)) {
return -4010;
}
// $account = lm("game_type", "commons");
// $game = $account->where("status", "1")->get()->toArray();
//return $game;
$play_num = "";
$where = '1 = 1';
$accountd = lm('SixMoney_buy', "commons");
foreach ($arrd as $key => $value) {
//循环数组
if ($value != '' && $key != 'a.open_time' && $key != 'b.open_time') { //判断条件
$where .= " AND {$key}='{$value}'"; //获取值
}
if ($value != '' && $key == 'a.open_time') {
$where .= " AND money_time>='{$time1}'";
}
if ($value != '' && $key == 'b.open_time') {
$where .= " AND money_time<='{$time2}'";
}
}
//return $where;
$list = 10;
//获取总页数
$count_list = $accountd->whereRaw($where)->count();
$count_page = ceil($count_list / $list);
$first = ($page - 1) * $list;
$code_datas = $accountd->orderBy('money_time', 'desc')->whereRaw($where)->offset($first)->limit($list)->get();//注单信息
if (!empty($code_datas)) {
$code_data = $code_datas->toArray();
} else {
return "";
}
//return $code_data;
foreach ($code_data as $k => $v) {
$data_codes = lm($v['game_name'], "Commons")->select('status','codes', 'extra')->where('info_no', $v['game_no'])->first();
$v['game_type'] = lang()->get($v['game_name']);
if (!empty($data_codes)) {
//开奖派奖号码
$v['wing_codes'] = $data_codes->codes;//
$v['gamed_status'] = $data_codes->status;
}
$datu[] = $v;
}
if (empty($datu)) {
return "";
}
foreach ($datu as $val){
$rowt[]=$this->dataChange($val,$game_type);
}
$dat = [
'data' => $rowt,
'count_page' => $count_page,
'page' => $page,
//'where' => $datu,
];
return $dat;
// return 1;
}
/*
* pc投注详情
*/
public function PcBettingDetails($data)
{
$id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; //用户唯一id
$time1 = isset($data['time1']) ? $data['time1'] : ''; //资金状态
$time2 = isset($data['time2']) ? $data['time2'] : ''; //资金类型
$no = isset($data['no']) ? $data['no'] : ''; //资金类型
//return $no;
$game_type = isset($data['game']) ? $data['game'] : ''; //资金类型
$status = isset($data['status']) ? $data['status'] : '';
$money_time = isset($data['money_time']) ? $data['money_time'] : '';
$id = isset($data['id']) ? $data['id'] : '';
$order_id = isset($data['order_id']) ? $data['order_id'] : '';
$page = isset($data['page']) ? $data['page'] : 2;
$arrd = [ //向数据库追加数组 然后循环出来
'a.open_time' => $time1,
'b.open_time' => $time2,
'game_no' => $no,
'id' => $id,
'order_id' => $order_id,
'account_identity' => $id_one,
'status' => $status,
'game_name' => $game_type,
'money_time' => $money_time,
];
if (empty($id_one)) {
return -4010;
}
// $account = lm("game_type", "commons");
// $game = $account->where("status", "1")->get()->toArray();
//return $game;
$play_num = "";
$where = '1 = 1';
$accountd = lm('money_buy', "commons");
foreach ($arrd as $key => $value) {
//循环数组
if ($value != '' && $key != 'a.open_time' && $key != 'b.open_time') { //判断条件
$where .= " AND {$key}='{$value}'"; //获取值
}
if ($value != '' && $key == 'a.open_time') {
$where .= " AND money_time>='{$time1}'";
}
if ($value != '' && $key == 'b.open_time') {
$where .= " AND money_time<='{$time2}'";
}
}
//return $where;
$list = 10;
//获取总页数
$count_list = $accountd->whereRaw($where)->count();
$count_page = ceil($count_list / $list);
$first = ($page - 1) * $list;
$code_datas = $accountd->orderBy('money_time', 'desc')->whereRaw($where)->offset($first)->limit($list)->get();//注单信息
if (!empty($code_datas)) {
$code_data = $code_datas->toArray();
} else {
return "";
}
//return $code_data;
foreach ($code_data as $k => $v) {
$data_codes = lm($v['game_name'], "Commons")->select('status','codes', 'extra')->where('info_no', $v['game_no'])->first();
$v['game_type'] = lang()->get($v['game_name']);
if (!empty($data_codes)) {
//开奖派奖号码
if ($v['game_name'] == "xy28" || $v['game_name'] == "jnd28" || $v['game_name'] == "gpxy28" || $v['game_name'] == "gpjnd28" || $v['game_name'] == "tw28" || $v['game_name'] == "xjp28" || $v['game_name'] == "dj28" || $v['game_name'] == "hs28") {
$v['wing_codes'] = $data_codes->extra;
} else {
$v['wing_codes'] = $data_codes->codes;//
}
$v['gamed_status'] = $data_codes->status;//
}
$datu = $v;
}
if ($datu['game_name'] == "xy28" || $datu['game_name'] == "jnd28" || $datu['game_name'] == 'hs28' || $datu['game_name'] == "gpxy28" || $datu['game_name'] == "gpjnd28" || $datu['game_name'] == "xjp28" || $datu['game_name'] == "tw28" || $datu['game_name'] == "dj28" ) {
$params = json_decode($datu['wing_codes'], 1);
$datu['wing_codes'] = $params['code'];
}
if (empty($datu)) {
return "";
}
return $datu;
}
/*
* pc六合投注详情PcSixlotteryRecord
*/
public function PcSixlotteryDetails($data)
{
$id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; //用户唯一id
$time1 = isset($data['time1']) ? $data['time1'] : ''; //资金状态
$time2 = isset($data['time2']) ? $data['time2'] : ''; //资金类型
$no = isset($data['no']) ? $data['no'] : ''; //资金类型
//return $no;
$game_type = isset($data['game']) ? $data['game'] : ''; //资金类型
$status = isset($data['status']) ? $data['status'] : '';
$money_time = isset($data['money_time']) ? $data['money_time'] : '';
$id = isset($data['id']) ? $data['id'] : '';
$order_id = isset($data['order_id']) ? $data['order_id'] : '';
$page = isset($data['page']) ? $data['page'] : 2;
$arrd = [ //向数据库追加数组 然后循环出来
'a.open_time' => $time1,
'b.open_time' => $time2,
'game_no' => $no,
'id' => $id,
'order_id' => $order_id,
'account_identity' => $id_one,
'status' => $status,
'game_name' => $game_type,
'money_time' => $money_time,
];
if (empty($id_one)) {
return -4010;
}
// $account = lm("game_type", "commons");
// $game = $account->where("status", "1")->get()->toArray();
//return $game;
$play_num = "";
$where = '1 = 1';
$accountd = lm('SixMoney_buy', "commons");
foreach ($arrd as $key => $value) {
//循环数组
if ($value != '' && $key != 'a.open_time' && $key != 'b.open_time') { //判断条件
$where .= " AND {$key}='{$value}'"; //获取值
}
if ($value != '' && $key == 'a.open_time') {
$where .= " AND money_time>='{$time1}'";
}
if ($value != '' && $key == 'b.open_time') {
$where .= " AND money_time<='{$time2}'";
}
}
//return $where;
$list = 10;
//获取总页数
$count_list = $accountd->whereRaw($where)->count();
$count_page = ceil($count_list / $list);
$first = ($page - 1) * $list;
$code_datas = $accountd->orderBy('money_time', 'desc')->whereRaw($where)->offset($first)->limit($list)->get();//注单信息
if (!empty($code_datas)) {
$code_data = $code_datas->toArray();
} else {
return "";
}
//return $code_data;
foreach ($code_data as $k => $v) {
$data_codes = lm($v['game_name'], "Commons")->select('status','codes', 'extra')->where('info_no', $v['game_no'])->first();
$v['game_type'] = lang()->get($v['game_name']);
if (!empty($data_codes)) {
$v['wing_codes'] = $data_codes->codes;//
$v['gamed_status'] = $data_codes->status;//
}
$datu = $v;
}
if (empty($datu)) {
return "";
}
return $datu;
}
public function dataChange($data,$game='sixlottery') {
$args = array();
$buy_code = json_decode($data['codes'], 1); //该注购买号码
//$color_code = json_decode($data['prizes'], 1); //该注购买号码
$prize_code = json_decode($data['prize'], 1); //改注中奖号码
$prize_num = $data['wing_codes']; //改注中奖号码
$asb=array(
//正码1-6
'general_size',
'general_parity',
'general_sumsize',
'general_sumparity',
'general_endsize',
);
$asd =array(
// 特码A_大小、单双、半特(混合)
'special_size_a',
'special_parity_a',
'special_half_a',
'special_sumsize_a',
'special_sumparity_a',
'special_endsize_a',
// 特码b_大小、单双、半特(混合)
'special_size_b',
'special_parity_b',
'special_half_b',
'special_sumsize_b',
'special_sumparity_b',
'special_endsize_b',
//合肖
'join_born',
//半波
'special_halfwave',
//半半波
'special_mixwave',
//两面
'special_twofaceparity',
'specialsum_twofaceparity',
'special_twofacesize',
'specialsum_twofacesize'
);
$unmdata=array(
'special_halfwave',
'special_mixwave',
'poscode',
'fronttwostar',
'fivestar',
'fourstar',
'behindthreestar',
'fronttwostar',
'zhixuan',
'frontthreestar',
'bulls',
'size',
'mix',
'possize',
'dragon',
'join_born',
'general_parity',
'general_pass',
'general_twofacesize',
'general_size',
'generalsum_twofaceparity',
'twosided',
);
$paramt = $this->PccodeDetails($buy_code);
$odds=$this->getSettings($data['game_name']);
if (is_array($paramt) && count($paramt) > 0) {
$i = 0;
$a = "";
$s = 1;
$daa = 0;
foreach ($paramt as $k => $v) {
if (is_array($v) && count($v) > 0) {
foreach ($v as $k1 => $v1) {
$datas = explode(',', $k1);
$datrr = explode('_', $k1);
if (in_array($k, $unmdata)) {
$a = lang($data['game_name'])->get($k . '-' . $k1);
} elseif (!empty($datrr) && count($datas) == 1) {
foreach ($datrr as $value) {
if ($value > 0 || strlen($value) == 1) {
$a .= lang($data['game_name'])->get($k) . '-' . $value . "_";
} else {
$a .= lang($data['game_name'])->get($k . '-' . $value) . "_";
}
}
} elseif (!empty($datas)) {
foreach ($datas as $value) {
if ($value > 0 || strlen($value) == 1) {
$a .= lang($data['game_name'])->get($k) . '-' . $value . "_";
} else {
$a .= lang($data['game_name'])->get($k . '-' . $value) . "_";
}
}
} else {
$a = $k1;
}
$a = rtrim($a, '_');
$args[$i] = array(
'gameType' => lang($data['game_name'])->get($k),
'codes' => lang($data['game_name'])->get($k) . '-' . $a,
'money' => $v1[0],
'maybe' => $v1[0] * $v1['settings']['multiple'],
'play' => $k,
'p_codes' => $a,
'p_code' => $k1,
'back' => empty($v1['settings']['back']) ? 0 : $v1['settings']['back'],
);
if (isset($v1['settings']['multiple']['max'])) {
$args[$i]['odds'] = $v1['settings']['multiple']['max'];
} else {
$args[$i]['odds'] = $v1['settings']['multiple'];
} if ($data['gamed_status'] == 3) {
$args[$i]['prize_status'] = '开奖中';
$args[$i]['get_money'] = 0;
}else if ($data['status'] == 4) {
$args[$i]['prize_status'] = '撤单';
$args[$i]['get_money'] = 0;
} else if ($data['game_status'] == 0) {
$args[$i]['prize_status'] = '待开奖';
$args[$i]['get_money'] = 0;
} elseif (in_array($k, $asd)) {
$datas1 = explode(',', $prize_num);
if (in_array(49, $datas1)) {
$args[$i]['prize_status'] = '和';
$args[$i]['get_money'] = $v1[0];
$args[$i]['odds'] = 1;
} else {
$args[$i]['prize_status'] = '未中奖';
$args[$i]['get_money'] = -$v1[0];
}
} elseif (stripos($data['game_name'], '11x5') !== false) {
if ($k == 'total') {
$datas1 = explode(',', $prize_num);
foreach ($datas1 as $r) {
$daa += $r;
}
if ($k1 == 'big' || $k1 == 'small') {
if ($daa == 30) {
$args[$i]['prize_status'] = '和';
$args[$i]['get_money'] = $v1[0];
$args[$i]['odds'] = 1;
}else{
$args[$i]['prize_status'] = '未中奖';
$args[$i]['get_money'] = -$v1[0];
}
} else {
$args[$i]['prize_status'] = '未中奖';
$args[$i]['get_money'] = -$v1[0];
}
$daa = 0;
}elseif ($k == 'dragon') {
$datas1 = explode(',', $prize_num);
if ($k1 == 'big' || $k1 == 'small') {
if ($datas1[0] == $datas1[4]) {
$args[$i]['prize_status'] = '和';
$args[$i]['get_money'] = $v1[0];
$args[$i]['odds'] = 1;
}
} else {
$args[$i]['prize_status'] = '未中奖';
$args[$i]['get_money'] = -$v1[0];
}
}else{
$args[$i]['prize_status'] = '未中奖';
$args[$i]['get_money'] = -$v1[0];
}
} elseif (in_array($k, $asb)) {
$datas1 = explode(',', $prize_num);
foreach ($datas1 as $k1 => $v1) {
foreach ($datrr as $k2 => $v2) {
if ((string)$k1 + 1 == $v2 && $v1 == "49") {
$args[$i]['prize_status'] = '和';
$args[$i]['get_money'] = $v1[0];
$args[$i]['odds'] = 1;
}
}
}
} else {
$args[$i]['prize_status'] = '未中奖';
$args[$i]['get_money'] = -$v1[0];
}
$i++;
$a = "";
}
}
}
}
//中奖判断
$datauu=explode(',',$prize_num);
$dataw=explode(',',$prize_num);
if (is_array($prize_code) && count($prize_code) && $data['gamed_status'] == 2) {
foreach ($prize_code as $kk => $vv) {
$name = $k;
}
foreach ($dataw as $k=>$vv){
if ($vv > 9){
$aa[$k]=$vv % 10;
}else{
$aa[$k]=$vv;
}
}
$bb[$name]=array_unique($aa);
$cc=array_unique($aa);
$datass[$name] = $datauu;
array_pop($datauu);
$datd[$name] =$datauu;
//中奖号码
$paramt = $this->PcWincodeDetails($prize_code,$datass,$datd,$cc,$bb,$buy_code);
$arry = array(
'selfselect_eightlose',//八不中
'selfselect_elevenlose',
'selfselect_twelvelose',
'selfselect_tenlose',
'selfselect_sixlose',
'selfselect_ninelose',
'selfselect_sevenlose',
'selfselect_fivelose',//五不中
);
$arrys = array(
'series_twospecial',//二中特
'series_threetwo'
);
$asse = array(
'5'=>'series_fiveend',
'4'=>'series_fourend',
'3'=>'series_threeend',
'2'=>'series_twoend',
);
$xy28= array(
'specialthree'
);
foreach ($paramt as $p_k => $p_v) {
//购买号码
foreach ($args as $num => $v) {
if ($v['play'] == $p_k) {
if (is_array($p_v) && count($p_v) > 0) {
if ($data['game_name'] == 'sixlottery' || $data['game_name'] == 'sfsixlottery'){
$args=$this->Win($args,$p_k,$p_v,$v,$arry,$num,$arrys,$odds,$dataw,$asd,$prize_num,$asse,$bb,$asb);
}
elseif(stripos($data['game_name'], '11x5') !== false){
if( ($v['play'] == 'total' || $v['play'] == 'dragon') && ($v['p_code'] == 'big' || $v['p_code'] == 'small')) {
if ($v['prize_status'] != '和') {
foreach ($p_v as $p_k1 => $p_v2) {
if ($v['p_code'] == $p_v2) {
$args[$num]['prize_status'] = '中奖';
$args[$num]['get_money'] = $v['money'] * $v['odds'] - $v['money'];
break;
} else {
$args[$num]['prize_status'] = '未中奖';
$args[$num]['get_money'] = -$v['money'];
}
}
}
}else{
foreach ($p_v as $p_k1 => $p_v2) {
if ($v['p_code'] == $p_v2) {
$args[$num]['prize_status'] = '中奖';
$args[$num]['get_money'] = $v['money'] * $v['odds'] - $v['money'];
break;
} else {
$args[$num]['prize_status'] = '未中奖';
$args[$num]['get_money'] = -$v['money'];
}
}
}
}elseif(in_array($p_k, $xy28)) {
foreach ($p_v as $p_k1 => $p_v2) {
intval($p_v2);
settype($p_v2, "string");
if (stripos($v['p_code'],$p_v2) !== false) {
$args[$num]['prize_status'] = '中奖';
$args[$num]['get_money'] = $v['money'] * $v['odds'] - $v['money'];
break;
} else {
$args[$num]['prize_status'] = '未中奖';
$args[$num]['get_money'] = -$v['money'];
}
}
}else {
foreach ($p_v as $p_k1 => $p_v2) {
if ($v['p_code'] == $p_v2) {
$args[$num]['prize_status'] = '中奖';
$args[$num]['get_money'] = $v['money'] * $v['odds'] - $v['money'];
break;
} else {
$args[$num]['prize_status'] = '未中奖';
$args[$num]['get_money'] = -$v['money'];
}
}
}
}
}
}
}
}
if(is_array($args) && count($args) > 0){
foreach ($args as $k=>$v){
if (isset($v['prize_status'])){
$argss[$k]['codes'] = $v['p_codes']."-".$v['prize_status'];
}else{
$argss[$k]['codes'] = $v['p_codes']."-未中奖";
}
$argss[$k]['codeDate'] = $v['gameType'];
$argss[$k]['money'] = $v['money'];
}
if (count($args) >= 2){
$codeds =$argss[0]['codes'].$argss[1]['codes'];
}else{
$codeds =$argss[0]['codes'];
}
$game_type=$args[0]['gameType'];
}else{
$game_type="";
$codeds='';
$argss='';
}
if ($data['status'] == 4){
$game_status='撤单';
}elseif ($data['game_status'] == 0){
$game_status='待开奖';
}elseif ($data['game_status'] == 1){
$game_status='中奖';
}elseif ($data['game_status'] == 2){
$game_status='未中奖';
}
if ($data['wing_codes'] == '-1'){
$data['wing_codes']="";
}
$da_args['order_id']=$data['order_id'];
$da_args['wing_codes'] = $data['wing_codes'];
$da_args['get_money'] = $data['get_money']-$data['money'];
$da_args['game_no'] = $data['game_no'];
$da_args['get_money'] = $data['get_money'];
$da_args['game_type'] = $data['game_type'];
$da_args['money'] = $data['money'];
$da_args['codes'] = $data['codes'];
$da_args['game_name'] = $data['game_name'];
$da_args['codeDate'] = $game_type;
$da_args['codet'] = $argss;
$da_args['coded'] = $codeds;
$da_args['money_time'] = $data['money_time'];
$da_args['id'] = $data['id'];
$da_args['game_status'] = $game_status;
$da_args['gamed_status'] = $data['gamed_status'];
return $da_args;
}
/*
* pc账户明细
*/
function PcWinning($data)
{
$id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; //用户唯一id
$id = isset($data['id']) ? $data['id'] : '';
$page = isset($data['page']) ? $data['page'] : 1;
$num1 = isset($data['num1']) ? $data['num1'] : '';
$num2 = isset($data['num2']) ? $data['num2'] : '';
$new_time = isset($data['time']) ? $data['time'] : '';
$trade_type = isset($data['trade_type']) ? $data['trade_type'] : ''; //资金状态
if (empty($id_one)) {
return -4010;
}
if ($num2 > $num1) {
$bb = $num1;
$num1 = $num2;
$num2 = $bb;
}
if (!empty($new_time)) {
$new_time1 = $new_time;
$new_time2 = date("Y-m-d", strtotime("+1 day", strtotime($new_time)));
$arr = [ //向数据库追加数组 然后循环出来
'a.id' => $num1,
'b.id' => $num2,
'id' => $id,
'trade_type' => $trade_type,
'a.money_time' => $new_time1,
'b.money_time' => $new_time2,
"account_identity" => $id_one,
];
}else{
$arr = [ //向数据库追加数组 然后循环出来
'a.id' => $num1,
'b.id' => $num2,
'id' => $id,
'trade_type' => $trade_type,
"account_identity" => $id_one,
];
}
//var_dump($new_time1,$new_time2);
//return ;
$where = '1 = 1';
foreach ($arr as $key => $value) {
//循环数组
if ($value != '' && $key != 'a.id' && $key != 'b.id' && $key != 'a.money_time' && $key != 'b.money_time') { //判断条件
$where .= " AND {$key}='{$value}'"; //获取值
}
if ($value != '' && $key == 'a.id') {
//$time1 = date('Y-m-d 00:00:00', strtotime($time1));
$where .= " AND id<='{$num1}'";
}
if ($value != '' && $key == 'b.id') {
//$time2 = date('Y-m-d H:i:s', (strtotime($time2) + 24 * 60 * 60 - 1));
$where .= " AND id>='{$num2}'";
}
if ($value != '' && $key == 'a.money_time') {
//$time1 = date('Y-m-d 00:00:00', strtotime($time1));
$where .= " AND money_time>='{$new_time1}'";
}
if ($value != '' && $key == 'b.money_time') {
//$time2 = date('Y-m-d H:i:s', (strtotime($time2) + 24 * 60 * 60 - 1));
$where .= " AND money_time<'{$new_time2}'";
}
}
//return $where;
$rows = lm("money_details", "commons")->whereRaw($where)->get();
// return $rows;
if (count($rows) != 0) {
$list = 10;
//获取总页数
$count_list = lm("money_details", "commons")->whereRaw($where)->count();
$count_page = ceil($count_list / $list);
$first = ($page - 1) * $list;
$rows = lm("money_details", "commons")->orderBy('money_time', 'desc')->whereRaw($where)->offset($first)->limit($list)->get()->toArray();
// return $rows;
//$rows=lm("money_details","commons")->whereRaw($where)->get()->toArray();
} else {
return "";
}
foreach ($rows as $k => $v) {
if ($v['money_type'] == "1" && $v['status'] == '1') {
$rows[$k]['old_money'] = sprintf("%.1f", $v['money_cash'] - $v['money']);
} elseif ($v['money_type'] == "2" && $v['status'] == '1') {
$rows[$k]['old_money'] = sprintf("%.1f", $v['money_cash'] + $v['money']);
} else {
$rows[$k]['old_money'] = $v['money_cash'];
}
}
// $status=$this->GetStatus();
$money_type = $this->GetMonetType();
$Winning = $this->GetStatut();
foreach ($rows as $k => $val) {
foreach ($money_type as $key => $v) {
if ($val['trade_type'] == $key) {
$val['trade_type'] = lang()->get($v['name']);
$val['money'] = $val['money'];
$row[] = $val;
}
}
}
//return $row;
foreach ($Winning as $key => $v) {
foreach ($row as $k => $val) {
if ($val['status'] == $key) {
$val['status'] = lang()->get($v);
$rowt[] = $val;
}
}
}
$len = count($rowt);
for ($i = 0; $i < $len; $i++) {
for ($j = $len; $j < $len - $i; $j--) {
if ($rowt[$i]['money_time'] > $rowt[$j]['money_time']) {
$temp = $rowt[$i];
$rowt[$j] = $rowt[$i];
$rowt[$i] = $temp;
}
}
}
$dat = [
'data' => $rowt,
'count_page' => $count_page,
'page' => $page,
];
return $dat;
}
/*
* 账号盈亏
*/
public function Personals($data)
{
$id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; //用户唯一id
$now_times = isset($data['now_times']) ? $data['now_times'] : ''; //用户唯一id
// return $now_times;
if ($now_times == "当天") {
// return 1;
$now_time_old = date("Y-m-d", strtotime("+1 day"));
$now_time = date('Y-m-d', time());
for ($i = 1; $i <= 10; $i++) {
if ($i == '5' || $i == '6') {
} else {
$datas[] = lm("money_details", "commons")->where("account_identity", $id_one)
->where("trade_type", "$i")
->where("money_time", ">", $now_time)
->where("money_time", "<", $now_time_old)
->get()->toArray();
}
}
} elseif ($now_times == "一周") {
$now_time_old = date("Y-m-d", strtotime("-7 day"));
$week_time = date("Y-m-d", strtotime("+1 day"));
for ($i = 1; $i <= 10; $i++) {
if ($i == '5' || $i == '6') {
} else {
$datas[] = lm("money_details", "commons")->where("account_identity", $id_one)
->where("trade_type", "$i")
->where("money_time", "<", $week_time)
->where("money_time", ">", $now_time_old)
->get()->toArray();
}
}
} else {
for ($i = 1; $i <= 10; $i++) {
if ($i == '5' || $i == '6') {
} else {
$datas[] = lm("money_details", "commons")->where("account_identity", $id_one)
->where("trade_type", "$i")
->get()->toArray();
}
}
}
foreach ($datas as $key => $val) {
if (empty($val)) {
continue;
}
$arr[] = $val;
}
// return $arr;
if (empty($arr)) {
@$arrs['eart'] = 0;
@$arrs['koukuan'] = 0;
@$arrs['defection'] = 0;
@$arrs['balance'] = 0;
@$arrs['open_times'] = 0;
@$arrs['money_time'] = 0;
} else {
foreach ($arr as $v) {
foreach ($v as $val) {
$arrs[] = $val;
}
}
foreach ($arrs as $k => $v) {
$arrs[$k]['money_time'] = date("m", strtotime($v['money_time']));
}
}
// return $arrs;
$date = [
'01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12',
];
$datq = array();
$eart = 0;
$expenditure = "";
foreach ($date as $k => $val) {
foreach ($arrs as $v) {
if ($val == $v['money_time']) {
if ($v['trade_type'] == "1" || $v['trade_type'] == "2" || $v['trade_type'] == "9") {
@$expenditure += $v['money'];
}
if ($v['trade_type'] == "3" || $v['trade_type'] == "4" || $v['trade_type'] == "7" || $v['trade_type'] == "8" || $v['trade_type'] == "10") {
@$eart += $v['money'];
}
$balance = $eart - $expenditure;
//return $balance;
}
}
@$datq[$k]['eart'] = $eart;
@$datq[$k]['balance'] = $balance;
@$datq[$k]['expenditure'] = $expenditure;
@$datq[$k]['time'] = $val;
//return $datq;
$eart = 0;
$balance = 0;
$expenditure = 0;
}
return $datq;
//echo json_encode($datq);
}
//盈亏
public function Personal($data)
{
$id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; //用户唯一id
$now_times = isset($data['now_times']) ? $data['now_times'] : ''; //用户唯一id
// return $now_times;
if ($now_times == "当天") {
// return 1;
$now_time_old = date("Y-m-d", strtotime("+1 day"));
$now_time = date('Y-m-d', time());
$datas = lm("money_buy", "commons")
->where("account_identity", $id_one)
->where("status",'!=', "4")
->orWhere("status", "2")
->where("money_time", ">", $now_time)
->where("money_time", "<", $now_time_old)
->get();
if ($datas){
$datas=$datas->toArray();
}
} elseif ($now_times == "一周") {
$now_time_old = date("Y-m-d", strtotime("-7 day"));
$week_time = date("Y-m-d", strtotime("+1 day"));
$datas = lm("money_buy", "commons")->where("account_identity", $id_one)
->where("status",'!=', "4")
->where("money_time", "<", $week_time)
->where("money_time", ">", $now_time_old)
->get();
if ($datas){
$datas=$datas->toArray();
}
} else {
$datas = lm("money_buy", "commons")
->where("account_identity", $id_one)
->where("status",'!=', "4")
->get();
if ($datas){
$datas=$datas->toArray();
}
}
foreach ($datas as $key => $val) {
if (empty($val)) {
continue;
}
$arr[] = $val;
}
$date = [
'01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12',
];
$datq = array();
$eart = 0;
$balance = 0;
$expenditure = "";
foreach ($date as $k => $val) {
foreach ($arr as $v) {
if ($val == date("m", strtotime($v['money_time']))) {
@$eart += $v['prize_money'];
@$expenditure += $v['money'];
@$balance += $v['get_money'];
}
}
@$datq[$k]['eart'] = $eart;
@$datq[$k]['balance'] = $balance;
@$datq[$k]['expenditure'] = $expenditure;
@$datq[$k]['time'] = $val;
//return $datq;
$eart = 0;
$balance = 0;
$expenditure = 0;
}
$sixnum=$this->sixPersonal($id_one,$now_times);
foreach ($sixnum as $v){
foreach ($datq as $k=>$val){
if ($v['time'] == $val['time']){
$datq[$k]['eart']=$v['eart']+$val['eart'];
$datq[$k]['balance']=$v['balance']+$val['balance'];
$datq[$k]['expenditure']=$v['expenditure']+$val['expenditure'];
}
}
}
return $datq;
//echo json_encode($datq);
}
public function sixPersonal($id_one,$now_times)
{
if ($now_times == "当天") {
$now_time_old = date("Y-m-d", strtotime("+1 day"));
$now_time = date('Y-m-d', time());
$datas = lm("sixMoney_buy", "commons")->where("account_identity", $id_one)
->where("status",'!=', "4")
->where("money_time", ">", $now_time)
->where("money_time", "<", $now_time_old)
->get();
if ($datas){
$datas=$datas->toArray();
}
} elseif ($now_times == "一周") {
$now_time_old = date("Y-m-d", strtotime("-7 day"));
$week_time = date("Y-m-d", strtotime("+1 day"));
$datas = lm("sixMoney_buy", "commons")->where("account_identity", $id_one)
->where("status",'!=', "4")
->where("money_time", "<", $week_time)
->where("money_time", ">", $now_time_old)
->get();
if ($datas){
$datas=$datas->toArray();
}
} else {
$datas = lm("sixMoney_buy", "commons")->where("account_identity", $id_one)
->where("status",'!=', "4")
->get();
if ($datas){
$datas=$datas->toArray();
}
}
foreach ($datas as $key => $val) {
if (empty($val)) {
continue;
}
$arr[] = $val;
}
$date = [
'01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12',
];
$datq = array();
$eart = 0;
$balance = 0;
$expenditure = "";
foreach ($date as $k => $val) {
foreach ($arr as $v) {
if ($val == date("m", strtotime($v['money_time']))) {
@$eart += $v['prize_money'];
@$expenditure += $v['money'];
@$balance += $v['get_money'];
//return $balance;
}
}
@$datq[$k]['eart'] = $eart;
@$datq[$k]['balance'] = $balance;
@$datq[$k]['expenditure'] = $expenditure;
@$datq[$k]['time'] = $val;
//return $datq;
$eart = 0;
$balance = 0;
$expenditure = 0;
}
return $datq;
//echo json_encode($datq);
}
/*
* 充值记录
*/
function PCRecharge($data,$c=-1)
{
$id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; //用户唯一id
$id = isset($data['id']) ? $data['id'] : '';
$page = isset($data['page']) ? $data['page'] : 1;
$num1 = isset($data['num1']) ? $data['num1'] : '';
$num2 = isset($data['num2']) ? $data['num2'] : '';
$new_time = isset($data['time']) ? $data['time'] : '';
if (empty($id_one)) {
return -4010;
}
if ($num2 > $num1) {
$bb = $num1;
$num1 = $num2;
$num2 = $bb;
}
if (!empty($new_time)) {//qtx 2018-12-11
$newtime = explode('~',$new_time);
if(count($newtime) ==2){
$new_time1 = $newtime[0].' 00:00:00';
$new_time2 = $newtime[1].' 23:59:59';
}else{
$new_time1 = $new_time;
$new_time2 = date("Y-m-d", strtotime("+1 day", strtotime($new_time)));
}
$arr = [ //向数据库追加数组 然后循环出来
'a.id' => $num1,
'b.id' => $num2,
'id' => $id,
'a.apply_time' => $new_time1,
'b.apply_time' => $new_time2,
"account_identity" => $id_one,
];
}else{
$arr = [ //向数据库追加数组 然后循环出来
'a.id' => $num1,
'b.id' => $num2,
'id' => $id,
"account_identity" => $id_one,
];
}
$where = '1 = 1';
foreach ($arr as $key => $value) {
//循环数组
if ($value != '' && $key != 'a.id' && $key != 'b.id' && $key != 'a.apply_time' && $key != 'b.apply_time') { //判断条件
$where .= " AND {$key}='{$value}'"; //获取值
}
if ($value != '' && $key == 'a.id') {
//$time1 = date('Y-m-d 00:00:00', strtotime($time1));
$where .= " AND id<='{$num1}'";
}
if ($value != '' && $key == 'b.id') {
//$time2 = date('Y-m-d H:i:s', (strtotime($time2) + 24 * 60 * 60 - 1));
$where .= " AND id>='{$num2}'";
}
if ($value != '' && $key == 'a.apply_time') {
//$time1 = date('Y-m-d 00:00:00', strtotime($time1));
$where .= " AND apply_time>='{$new_time1}'";
}
if ($value != '' && $key == 'b.apply_time') {
//$time2 = date('Y-m-d H:i:s', (strtotime($time2) + 24 * 60 * 60 - 1));
$where .= " AND apply_time<'{$new_time2}'";
}
}
$rows = lm("money_recharge", "commons")->whereRaw($where)->get();
if($c==1){
$where .=" AND status=1";
$countMoney = $count_list = lm("money_recharge", "commons")->whereRaw($where)->sum('money');
$countMoney = empty($countMoney)?0:$countMoney;
return $countMoney;
}
if (count($rows) != 0) {
$list = 10;
//获取总页数
$count_list = lm("money_recharge", "commons")->whereRaw($where)->count();
$count_page = ceil($count_list / $list);
$first = ($page - 1) * $list;
$rows = lm("money_recharge", "commons")->orderBy('apply_time', 'desc')->whereRaw($where)->offset($first)->limit($list)->get()->toArray();
//$rows=lm("money_recharge","commons")->whereRaw($where)->get()->toArray();
//return $rows;
} else {
return "";
}
$Winning = $this->GetStatus();
foreach ($Winning as $key => $v) {
foreach ($rows as $k => $val) {
if ($val['status'] == $key) {
if ($val['status'] == '1') {
$val['old_money'] = ($val['money_cash'] - $val['money']);
} else {
$val['old_money'] = $val['money_cash'];
}
$val['statud'] = lang()->get($v);
$val['trade_type'] = lang()->get("Recharge");
$val['money'] = $val['money'];
$index = strtotime($val['apply_time']);
$rowr[$index] = $val;
//return $rowr;
}
}
}
rsort($rowr);
$dat = [
'data' => $rowr,
'count_page' => $count_page,
'page' => $page,
];
return $dat;
}
/*
* 提现记录
*/
function PCWithdrawals($data,$c=-1)
{
//$id_one = $_SESSION['uinfo']['account_identity'];
$id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; //用户唯一id
$id = isset($data['id']) ? $data['id'] : '';
$page = isset($data['page']) ? $data['page'] : 1;
$num1 = isset($data['num1']) ? $data['num1'] : '';
$num2 = isset($data['num2']) ? $data['num2'] : '';
$new_time = isset($data['time']) ? $data['time'] : '';
if (empty($id_one)) {
return -4010;
}
if ($num2 > $num1) {
$bb = $num1;
$num1 = $num2;
$num2 = $bb;
}
if (!empty($new_time)) {//qtx 2018-12-11
$newtime = explode('~',$new_time);
if(count($newtime) ==2){
$new_time1 = $newtime[0].' 00:00:00';
$new_time2 = $newtime[1].' 23:59:59';
}else{
$new_time1 = $new_time;
$new_time2 = date("Y-m-d", strtotime("+1 day", strtotime($new_time)));
}
$arr = [ //向数据库追加数组 然后循环出来
'a.id' => $num1,
'b.id' => $num2,
'id' => $id,
'a.apply_time' => $new_time1,
'b.apply_time' => $new_time2,
"account_identity" => $id_one,
];
}else{
$arr = [ //向数据库追加数组 然后循环出来
'a.id' => $num1,
'b.id' => $num2,
'id' => $id,
"account_identity" => $id_one,
];
}
$where = '1 = 1';
foreach ($arr as $key => $value) {
//循环数组
if ($value != '' && $key != 'a.id' && $key != 'b.id' && $key != 'a.apply_time' && $key != 'b.apply_time') { //判断条件
$where .= " AND {$key}='{$value}'"; //获取值
}
if ($value != '' && $key == 'a.id') {
//$time1 = date('Y-m-d 00:00:00', strtotime($time1));
$where .= " AND id<='{$num1}'";
}
if ($value != '' && $key == 'b.id') {
//$time2 = date('Y-m-d H:i:s', (strtotime($time2) + 24 * 60 * 60 - 1));
$where .= " AND id>='{$num2}'";
}
if ($value != '' && $key == 'a.apply_time') {
//$time1 = date('Y-m-d 00:00:00', strtotime($time1));
$where .= " AND apply_time>='{$new_time1}'";
}
if ($value != '' && $key == 'b.apply_time') {
//$time2 = date('Y-m-d H:i:s', (strtotime($time2) + 24 * 60 * 60 - 1));
$where .= " AND apply_time<'{$new_time2}'";
}
}
$rows = lm("money_take", "commons")->whereRaw($where)->get();
if($c==1){
$where .=" AND status=1";
$countMoney = lm("money_take", "commons")->whereRaw($where)->sum('money');
$countMoney = empty($countMoney)?0:$countMoney;
return $countMoney;
}
if (count($rows) != 0) {
$list = 10;
//获取总页数
$count_list = lm("money_take", "commons")->whereRaw($where)->count();
//return $count_list;
$count_page = ceil($count_list / $list);
$first = ($page - 1) * $list;
$rows = lm("money_take", "commons")->orderBy('apply_time', 'desc')->whereRaw($where)->offset($first)->limit($list)->get()->toArray();
} else {
return "";
}
$Winning = $this->GetStatus();
foreach ($Winning as $key => $v) {
foreach ($rows as $k => $val) {
if ($val['status'] == $key) {
if ($val['status'] == '1') {
$val['old_money'] = ($val['money_cash'] + $val['money']);
} else {
$val['old_money'] = $val['money_cash'];
}
$val['status'] = lang()->get($v);
$val['trade_type'] = lang()->get("Withdrawals");
$val['money'] = $val['money'];
$index = strtotime($val['apply_time']);
$rowr[$index] = $val;
}
}
}
rsort($rowr);
$dat = [
'data' => $rowr,
'count_page' => $count_page,
'page' => $page,
];
return $dat;
}
/*
* 投注详情
*/
function Betting($data)
{
$id = isset($data['id']) ? $data['id'] : '11315';
$game_name = isset($data['game_name']) ? $data['game_name'] : 'cqssc';
if ($game_name == 'jnd28' || $game_name == 'xy28') {
$tab_name = "SpecialCodeDataAccess";
} else {
$tab_name = "PoscodeDataAccess";
}
$cls = "\\Biz\\Game\\DataAccess\\" . ucfirst($game_name) . "\\" . $tab_name;
$settings = new $cls();
$number = $settings->getAttr();
$code_datas = lm('money_buy', "commons")->where('id', $id)->get();
if (!empty($code_datas)) {
$code_data = $code_datas->toArray();
} else {
return "";
}
foreach ($code_data as $o => $v) {
$tab_name = "bjpk10Parse";
$nums = C()->get($tab_name);
$data_paramt = json_decode($v['codes'], 1);
if (array_key_exists("head_three", $data_paramt)) {
$paramt = $this->CodeData($data_paramt);
} elseif (array_key_exists("head_two", $data_paramt)) {
$paramt = $this->CodeData($data_paramt);
} elseif (array_key_exists("fivestar", $data_paramt)) {
$paramt = $this->CQCodeData($data_paramt);
} elseif (array_key_exists("fourstar", $data_paramt)) {
$paramt = $this->CQCodeData($data_paramt);
} elseif (array_key_exists("behindthreestar", $data_paramt)) {
$paramt = $this->CQCodeData($data_paramt);
} elseif (array_key_exists("frontthreestar", $data_paramt)) {
$paramt = $this->CQCodeData($data_paramt);
} elseif (array_key_exists("fronttwostar", $data_paramt)) {
$paramt = $this->CQCodeData($data_paramt);
} else {
$datat = [
'codes' => $v['codes'],
];
$paramt = $nums->change($datat);
}
foreach ($paramt as $va) {
$CodeDate[] = $va['codes'];
}
if ($v['game_status'] == 1) {
$args = array();
$paramd = json_decode($v['prize'], 1);
$paramds = '';
if (empty($paramd)) {
$prize_code[] = "";
}
if (array_key_exists("head_three", $data_paramt)) {
foreach ($paramd as $v) {
foreach ($v as $ku => $val) {
$str = explode("_", $val);
$paramds .= $str[1] . ',';
$ast = substr($paramds, 0, strlen($paramds) - 1);
}
$args[]['codes'] = $ast;
}
foreach ($paramt as $kp => $vp) {
}
} elseif (array_key_exists("head_two", $data_paramt)) {
foreach ($paramd as $v) {
foreach ($v as $ku => $val) {
$str = explode("_", $val);
$paramds .= $str[1] . ',';
$ast = substr($paramds, 0, strlen($paramds) - 1);
}
$args[]['codes'] = $ast;
}
} elseif (array_key_exists("fivestar", $data_paramt)) {
foreach ($paramd as $v) {
foreach ($v as $ku => $val) {
$str = explode("_", $val);
$paramds .= $str[1] . ',';
$ast = substr($paramds, 0, strlen($paramds) - 1);
}
$args[]['codes'] = $ast;
}
} elseif (array_key_exists("fourstar", $data_paramt)) {
foreach ($paramd as $v) {
foreach ($v as $ku => $val) {
$str = explode("_", $val);
$paramds .= $str[1] . ',';
$ast = substr($paramds, 0, strlen($paramds) - 1);
}
$args[]['codes'] = $ast;
return $args;
}
} elseif (array_key_exists("behindthreestar", $data_paramt)) {
foreach ($paramd as $v) {
foreach ($v as $ku => $val) {
$str = explode("_", $val);
$paramds .= $str[1] . ',';
$ast = substr($paramds, 0, strlen($paramds) - 1);
}
$args[]['codes'] = $ast;
}
} elseif (array_key_exists("frontthreestar", $data_paramt)) {
foreach ($paramd as $v) {
foreach ($v as $ku => $val) {
$str = explode("_", $val);
$paramds .= $str[1] . ',';
$ast = substr($paramds, 0, strlen($paramds) - 1);
}
$args[]['codes'] = $ast;
}
} elseif (array_key_exists("fronttwostar", $data_paramt)) {
foreach ($paramd as $v) {
foreach ($v as $ku => $val) {
$str = explode("_", $val);
$paramds .= $str[1] . ',';
$ast = substr($paramds, 0, strlen($paramds) - 1);
}
$args[]['codes'] = $ast;
}
}
}
}
foreach ($paramt as $kp => $vp) {
foreach ($args as $ka => $va) {
if ($va['codes'] == $vp['codes']) {
$prize_code[] = $vp['codes'];
break;
}
}
}
$arr = [
'title' => $game_name,
'number' => $number,
'buy_code' => $CodeDate,
'prize_code' => $prize_code,
];
dump($data_paramt);
exit;
}
//快乐赛宝投注记录
function DiceBettingDetails($data){
$account_identity = isset($data['account_identity']) ? $data['account_identity'] : '';
$data=lm('Dice','commons')->orderBy('create_time', 'desc')->where('master_identity',$account_identity)->orWhere('guster_identity',$account_identity)->limit(10)->get();
foreach ($data as $k=>$v){
if ($v['master_identity'] == $account_identity){
$data[$k]['name_id']=1;
}else{
$data[$k]['name_id']=2;
}
if ($v['winner_identity'] == $account_identity){
$data[$k]['name_win']=1;
}else{
$data[$k]['name_win']=2;
}
}
return $data;
}
//赔率
function getSettings($game='sixlottery') {
$game = empty($game)?'sixlottery':$game;
//权限检测
$arrys = array(
'series_twospecial',//二中特
'series_threetwo-0',
'series_fiveend-0',
'series_fourend-0',
'series_threeend-0',
'series_twoend-0',
'series_twoborn-rate',
'series_twoborn-cattle',
'series_twoborn-tiger',
'series_twoborn-rabbit',
'series_twoborn-dragon',
'series_twoborn-snake',
'series_twoborn-horse',
'series_twoborn-sheep',
'series_twoborn-monkey',
'series_twoborn-chick',
'series_twoborn-dog',
'series_twoborn-pig',
'general_born'
);
$data = lm('Game_odds','Commons')->getOdds($game);
if($data<0){
return responseToJson($data);
}
$data = json_decode($data['odds'], 1);
return $data;
$array = array();
$i = 0;
foreach ($arrys as $v){
$bs[$v]=$data[$v];
}
return $bs;
}
/*
* PC塞子游戏投注记录
*/
public function PcDiceBettingRecord($data)
{
$id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; //用户唯一id
$time1 = isset($data['time1']) ? $data['time1'] : ''; //时间
$time2 = isset($data['time2']) ? $data['time2'] : ''; //时间
$game_type = isset($data['game'])&& !empty($data['game']) ? trim($data['game']) : 'diceone'; //游戏类型
$id = isset($data['id']) ? $data['id'] : '';
$page = isset($data['page']) ? $data['page'] : 2;
if ($game_type == 'diceone'){
$arrd = [ //向数据库追加数组 然后循环出来
'a.create_time' => $time1,
'b.create_time' => $time2,
'id' => $id,
'account_identity' => $id_one,
];
}else{
$arrd = [ //向数据库追加数组 然后循环出来
'a.create_time' => $time1,
'b.create_time' => $time2,
'id' => $id,
'master_identity'=>$id_one,
'guster_identity'=>$id_one,
];
}
if (empty($id_one)) {
return -4010;
}
$where = '1 = 1';
$accountd = lm($game_type, "commons");
foreach ($arrd as $key => $value) {
//循环数组
if ($value != '' && $key != 'a.create_time' && $key != 'b.create_time' && $key != 'master_identity' && $key != 'guster_identity') { //判断条件
$where .= " AND {$key}='{$value}'"; //获取值
}
if ($value != '' && $key == 'a.create_time') {
$where .= " AND create_time>='{$time1}'";
}
if ($value != '' && $key == 'b.create_time') {
$where .= " AND create_time<='{$time2}'";
}
if ($value != '' && $key == 'master_identity') {
$where .= " AND master_identity='{$id_one}'";
}
if ($value != '' && $key == 'guster_identity') {
$where .= " or guster_identity='{$id_one}'";
}
}
//return $where;
$list = 10;
//获取总页数
$count_list = $accountd->whereRaw($where)->count();
$count_page = ceil($count_list / $list);
$first = ($page - 1) * $list;
$code_datas = $accountd->orderBy('create_time', 'desc')->whereRaw($where)->offset($first)->limit($list)->get();//注单信息
if (!empty($code_datas)) {
$code_data = $code_datas->toArray();
} else {
return "";
}
foreach ($code_data as $k => $val) {
if ($game_type == 'diceone'){
if ($val['winstatus'] == '1') {
$code_data[$k]['winstatus'] = '中奖';
}else{
$code_data[$k]['winstatus'] = '未中奖';
}
$code_data[$k]['game_name'] = '单人快乐骰宝';
}else{
if ($val['winner_identity'] == $id_one){
$code_data[$k]['winstatus'] = '中奖';
}else{
$code_data[$k]['winstatus'] = '未中奖';
}
if ($val['winner_identity'] == $val['master_identity']){
$code_data[$k]['codes'] = $val['master_num'];
$code_data[$k]['money'] = $val['master_money'];
}else{
$code_data[$k]['codes'] = $val['guster_num'];
$code_data[$k]['money'] = $val['guster_money'];
}
$code_data[$k]['game_name'] = '双人快乐骰宝';
}
$code_data[$k]['coded'] = '查看详情';
$code_data[$k]['game'] = $game_type;
}
$dat = [
'data' => $code_data,
'count_page' => $count_page,
'page' => $page,
];
return $dat;
}
//塞子投注详情
public function DicedataChange($data) {
$id = isset($data['id']) ? $data['id'] : '';
$game=isset($data['game']) ? $data['game'] : '';
$game_name=isset($data['game_name']) ? $data['game_name'] : '';
$accountd = lm($game, "commons")->where('id',$id)->first();
if (!empty($accountd)) {
$accountd = $accountd->toArray();
} else {
return "";
}
$args = array();
$buy_code = json_decode($accountd['buycodes'], 1); //该注购买号码
$prize_code = json_decode($accountd['prizes'], 1); //改注中奖号码
$paramt = $buy_code;
if (is_array($paramt) && count($paramt) > 0) {
$i = 0;
$a="";
$s=1;
foreach ($paramt as $k => $v) {
if (is_array($v) && count($v) > 0) {
foreach ($v as $k1 => $v1) {
$args[$i] = array(
'gameType' => lang($game)->get($k),
'codes' => lang($game)->get($k). '-' . lang($game)->get($k1),
'money' => $v1[0],
'maybe' => $v1[0] * $v1['settings']['multiple'],
'play' => $k,
'p_codes' => $a,
'p_code' => $k1,
'back' => empty($v1['settings']['back']) ? 0 : $v1['settings']['back'],
);
if (isset($v1['settings']['multiple']['max'])) {
$args[$i]['odds'] = $v1['settings']['multiple']['max'];
} else {
$args[$i]['odds'] = $v1['settings']['multiple'];
}
if ($data['betstatus'] == 2) {
$args[$i]['prize_status'] = '撤单';
$args[$i]['get_money']=0;
}else {
$args[$i]['prize_status'] = '未中奖';
$args[$i]['get_money'] = -$v1[0];
}
$i++;
$a="";
}
}
}
}
//中奖判断
if (is_array($prize_code) && count($prize_code)) {
//中奖号码
$paramt = $prize_code['data'];
foreach ($paramt as $p_k => $p_v) {
//购买号码
foreach ($args as $num => $v) {
if ($v['play'] == $p_k) {
if (is_array($p_v) && count($p_v) > 0) {
foreach ($p_v as $p_k1 => $p_v2) {
if ($v['p_code'] == $p_k1) {
$args[$num]['prize_status'] = '中奖';
$args[$num]['get_money'] = $v['money'] * $v['odds'] - $v['money'];
break;
} else {
$args[$num]['prize_status'] = '未中奖';
$args[$num]['get_money'] = -$v['money'];
}
}
}
}
}
}
}
foreach ($args as $k=>$v){
$argss[$k]['codes'] = $v['codes']."-".$v['prize_status'];
$argss[$k]['codeDate'] = $v['gameType'];
$argss[$k]['money'] = $v['money'];
}
if (count($args) >= 2){
$codeds =$argss[0]['codes'].$argss[1]['codes'];
}else{
$codeds =$argss[0]['codes'];
}
$da_args['wing_codes'] = $accountd['codes'];
$da_args['game_no'] = $accountd['id'];
$da_args['get_money'] = $accountd['winmoney']-$accountd['money'];;
$da_args['game_type'] = $game_name;;
$da_args['money'] = $accountd['money'];
$da_args['codes'] = $accountd['codes'];
$da_args['codeDate'] = $args[0]['gameType'];
$da_args['codet'] = $argss;
$da_args['coded'] = $codeds;
$da_args['id'] = $accountd['id'];
return $da_args;
}
//双人塞子投注详情
public function DiceSdataChange($data) {
$id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; //用户唯一id
$id = isset($data['id']) ? $data['id'] : '';
$game=isset($data['game']) ? $data['game'] : '';
$game_name=isset($data['game_name']) ? $data['game_name'] : '';
$accountd = lm($game, "commons")->where('id',$id)->first();
if (!empty($accountd)) {
$accountd = $accountd->toArray();
} else {
return "";
}
foreach ($accountd as $k=>$v){
if ($v['winner_identity'] == $id_one){
$accountd[$k]['winner_type'] ='中奖';
}else{
$accountd[$k]['winner_type'] ='未中奖';
}
if ($v['winner_identity'] == $v['master_identity']){
$accountd[$k]['codes'] = $v['master_num'];
$accountd[$k]['money'] = $v['master_money'];
}else{
$accountd[$k]['codes'] = $v['guster_num'];
$accountd[$k]['money'] = $v['guster_money'];
}
}
foreach ($accountd as $k=>$v){
$argss[$k]['codeDate'] = '双人';
$argss[$k]['codes'] = $v['codes']."-".$v['winner_type'];
$argss[$k]['money'] = $v['money'];
}
$da_args['wing_codes'] = $accountd['codes'];
$da_args['game_no'] = $accountd['id'];
$da_args['get_money'] = $accountd['win_money']-$accountd['money'];;
$da_args['game_type'] = $game_name;;
$da_args['money'] = $accountd['money'];
$da_args['codet'] = $argss;
$da_args['id'] = $accountd['id'];
return $da_args;
}
/**
* 对象数组转为普通数组
*
* AJAX提交到后台的JSON字串经decode解码后为一个对象数组,
* 为此必须转为普通数组后才能进行后续处理,
* 此函数支持多维数组处理。
*
* @param array
* @return array
*/
function ObjarrayToArray($obj)
{
$ret = array();
foreach ($obj as $key => $value) {
if (gettype($value) == "array" || gettype($value) == "object") {
$ret[$key] = $this->ObjarrayToArray($value);
} else {
$ret[$key] = $value;
}
}
return $ret;
}
public function getColorCodes()
{
return array(
'coler' => array(
"code_type" => "coler",
"code_types" => "coler",
),
'code' => array(
"code_type" => "code",
"code_types" => "code",
),
'size_parity' => array(
"code_type" => "blend",
"code_types" => "size_parity",
),
'parity' => array(
"code_type" => "blend",
"code_types" => "parity",
),
'size' => array(
"code_type" => "blend",
"code_types" => "size",
),
'e_size' => array(
"code_type" => "blend",
"code_types" => "e_size",
),
'iden' => array(
"code_type" => "blend",
"code_types" => "iden",
),
);
}
public function getMixCodes()
{
return array(
'coler' => array(
'0' => 'green',
'1' => 'red',
'2' => 'blue',
),
'size_parity' => array(
'0' => 'Smalldouble',
'1' => 'Bigdouble',
'2' => 'Smallsingle',
'3' => 'Bigsingle',
),
'parity' => array(
'1' => 'double',
'2' => 'single',
),
'size' => array(
'0' => 'Small',
'1' => 'Big',
),
'e_size' => array(
'0' => 'Notnum',
'1' => 'VeryBig',
'2' => 'VerySmall',
),
'iden' => array(
'0' => 'NotWin',
'1' => 'Win',
),
);
}
function GetWinStatus()
{
return array("1" => "win", "2" => "notwin", "0" => "audit", "3" => "killorder");
}
function GetStatus()
{
return array("1" => "success", "2" => "fail", "0" => "audits");
}
function GetStatut()
{
return array("1" => "success", "0" => "fail");
}
function GetBuyStatus()
{
return array("1" => "Betting", "2" => "Chase", "3" => "ChageOrder");
}
function GetMonetType()
{
return array(
"1" => array("name" => "Betting", "opt" => "-", "old" => "+"),
"2" => array("name" => "ChaseNumber", "opt" => "-", "old" => "+"),
"3" => array("name" => "killorder", "opt" => "+", "old" => "-"),
"4" => array("name" => "Winning", "opt" => "+", "old" => "-"),
"5" => array("name" => "Withdrawals", "opt" => "-", "old" => "+"),
"6" => array("name" => "Recharge", "opt" => "+", "old" => "-"),
"7" => array("name" => "Defection", "opt" => "+", "old" => "-"),
"8" => array("name" => "backwater", "opt" => "+", "old" => "-"),
"9" => array("name" => "DeductMoney", "opt" => "-", "old" => "-"),
"10" => array("name" => "Commission", "opt" => "+", "old" => "-"),
"11" => array("name" => "HandRecharge", "opt" => "+", "old" => "-"),
"12" => array("name" => "Active", "opt" => "+", "old" => "-"),
"13" => array("name" => "Give", "opt" => "+", "old" => "-"),
"14" => array("name" => "Remit", "opt" => "+", "old" => "-"),
"15" => array("name" => "NoWithdrawals", "opt" => "+", "old" => "-"),
"16" => array("name" => "redget", "opt" => "+", "old" => "-"),
"19" => array("name" => "changemoney", "opt" => "+", "old" => "-"),
"22" => array("name" => "agentrecharge", "opt" => "+", "old" => "-"),
);
}
function GetMoneyStatus()
{
return array("1" => "Betting", "2" => "ChaseNumber", '4' => 'ChageOrder', '5' => 'notWithdrawals');
}
/**
* 计算组数
* @param [type] $data [description]
* @return [type] [description]
*/
function countNum($data, $money, $type,$multiple='',$game_name)
{
$hasNums = array_pop($data); //从数组中弹出最后一个数组
while (is_array($data) && count($data) > 0) {
$item = array_pop($data); //从数组中弹出最后一个
$nums = $hasNums;
$hasNums = [];
if (is_array($item) && count($item) > 0) {
foreach ($item as $k => $v) {
if (array_key_exists($k, $item)) {
$el = $item[$k]; //转存
foreach ($nums as $k2 => $v2) {
if (array_key_exists($k2, $nums)) {
$el2 = $nums[$k2];
if (gettype($el2) == 'string') {
$tmp = explode(',', $el2);
if ($this->checkExists($tmp, $el)) {
continue;
}
} else {
if ($el2 == $el) {
continue;
}
}
$str = $el . ',' . $el2;
array_push($hasNums, $str);
}
}
}
}
}
}
if (count($hasNums) > 1) {
foreach ($hasNums as $k => $v) {
if (array_key_exists($k, $hasNums)) {
$element = $hasNums[$k];
}
}
}
$hasNum = array();
foreach ($hasNums as $a => $b) {
$hasNum[$a]['codes'] = $b;
$hasNum[$a]['money'] = $money;
$hasNum[$a]['show_type'] = lang($game_name)->get($type);
$hasNum[$a]['show_nos'] = $b;
$hasNum[$a]['multiple'] = $multiple;
$hasNum[$a]['codeDate'] = $type;
}
return $hasNum;
}
function CQcountNum($data, $money, $type)
{
$hasNums = array_pop($data); //从数组中弹出最后一个数组
// dump($data);
while (is_array($data) && count($data) > 0) {
$item = array_pop($data); //从数组中弹出最后一个
$nums = $hasNums;
$hasNums = [];
if (is_array($item) && count($item) > 0) {
foreach ($item as $k => $v) {
if (array_key_exists($k, $item)) {
$el = $item[$k]; //转存
//dump($item);
foreach ($nums as $k2 => $v2) {
if (array_key_exists($k2, $nums)) {
$el2 = $nums[$k2];
//dump(gettype($el2));
if (gettype($el2) == 'string') {
$tmp = explode(',', $el2);
if ($this->checkExists($tmp, $el)) {
continue;
}
} else {
if ($el2 == $el) {
continue;
}
}
$str = $el . ',' . $el2;
array_push($hasNums, $str);
}
}
}
}
}
}
if (count($hasNums) > 1) {
foreach ($hasNums as $k => $v) {
if (array_key_exists($k, $hasNums)) {
$element = $hasNums[$k];
}
}
}
//dump($hasNums);
foreach ($hasNums as $a => $b) {
$as = explode(",", $b);
sort($as);
$arrs[] = $as;
}
foreach ($arrs as $v) {
$cc[] = implode(',', $v);
}
$asb = array_unique($cc);
foreach ($asb as $v) {
$adc[] = $v;
}
$hasNum = array();
foreach ($adc as $a => $b) {
$hasNum[$a]['codes'] = $b;
$hasNum[$a]['money'] = $money;
$hasNum[$a]['codeDate'] = $type;
}
return $hasNum;
}
function checkExists($data, $value)
{
foreach ($data as $k => $v) {
//判断键位是否存在
if (array_key_exists($k, $data)) {
$element = $data[$k];
if ($element == $value) {
return true;
}
}
}
return false;
}
function CodeData($data,$game_name)
{
$codes = array();
foreach ($data as $k => $v) {
$type = $k;
if (is_array($v) && count($v) > 0) {
foreach ($v as $k1 => $v1) {
$temp = explode('_', $k1);
$money = $v[$k1][0];
$multiple = $v[$k1]['settings']['multiple'];
if (!array_key_exists($temp[0] - 1, $codes)) {
$codes[$temp[0] - 1] = array();
array_push($codes[$temp[0] - 1], intval($temp[1]));
} else {
array_push($codes[$temp[0] - 1], intval($temp[1]));
}
}
}
}
$tempArr = $this->countNum($codes, $money, $type,$multiple,$game_name);
return $tempArr;
}
function CQCodeData($data, $num)
{
$codes = array();
foreach ($data as $k => $v) {
$type = $k;
if (is_array($v) && count($v) > 0) {
foreach ($v as $k1 => $v1) {
$temp = explode('_', $k1);
//var_dump($temp);
$money = $v[$k1][0];
if (!array_key_exists($temp[0] - 1, $codes)) {
$codes[] = $temp[1];
//array_push($codes[$temp[0] - 1], intval($temp[1]));
}
}
}
}
for ($i = 0; $i < $num; $i++) {
$bbb[] = array_slice($codes, $i * 1, $num);
}
$tempArr = $this->CQcountNum($bbb, $money, $type);
return $tempArr;
}
//号码组合解析排列 is_prtize匹配多少个算中奖,colse表示不中
/**
* @param $data
* @param $num
* @param string $is_prize 匹配多少个算中奖
* @param string $is_str 表示是字符串的号码
* @return mixed
*/
function CodesData($data, $num, $is_prize = '', $is_str = '', $game = '')
{
$codes = array();
foreach ($data as $k => $v) {
$type = $k;
if (is_array($v) && count($v) > 0) {
foreach ($v as $k1 => $v1) {
$money = $v[$k1][0];
$multiple = $v[$k1]['settings']['multiple'];
if ($k == 'series_twospecial'){
$codes[]= str_replace('g_','',$k1);
}else{
$codes[] = $k1;
}
}
}
}
if(count($codes) >= $num){
$a = $this->Isniu($codes, $num);
}else{
$nums = count($codes);
$a = $this->Isniu($codes, $nums);
}
//语言包内容组合
$sixarr = array('sfsixlottery','sixlottery');
if (is_array($a)){
foreach ($a as $k => $v) {
$codelists[$k]['codes'] = $v;
$codelists[$k]['money'] = $money;
$codelists[$k]['multiple'] = $multiple;
$codelists[$k]['show_nos'] = in_array($game, $sixarr)?$this->ChangeLan($game,$v):$v;
$codelists[$k]['show_type'] =lang($game)->get($type);
$codelists[$k]['codeDate'] = $type;
if (!empty($is_prize)) {
$codelists[$k]['is_prize'] = $is_prize;
}
if (!empty($is_str)) {
$codelists[$k]['is_str'] = $is_str;
}
if (!empty($game)) {
$codelists[$k]['game'] = $game;
}
}
}else{
$codelists='';
}
return $codelists;
}
function CodesDataA($data, $num, $is_prize = '', $is_str = '', $game = '')
{
$codes = array();
foreach ($data as $k => $v) {
$type = $k;
if (is_array($v) && count($v) > 0) {
foreach ($v as $k1 => $v1) {
$money = $v[$k1][0];
if ($k == 'series_twospecial'){
$codes[]= str_replace('g_','',$k1);
}
// elseif($k == 'join_born'){
// $codes[]= str_replace('_N','',$k1);
// }
else{
$codes[] = $k1;
}
}
}
}
$datas=array();
$datad=array();
sort($codes);
if(count($codes) >= $num){
$a = $this->Isniu($codes, $num);
}else{
$nums = count($codes);
$a = $this->Isniu($codes, $nums);
}
foreach ($data as $val){
foreach ($val as $value){
if (is_array($a)){
foreach ($a as $k=>$v){
$datas[$v]=$value;
}
}
}
}
$datad[$type]=$datas;
return $datad;
}
function CodesDatasA($data, $num, $is_prize = '', $is_str = '', $game = '')
{
$codes = array();
foreach ($data as $k => $v) {
$type = $k;
if (is_array($v) && count($v) > 0) {
foreach ($v as $k1 => $v1) {
$money = $v[$k1][0];
$codes[] = $v1;
}
}
}
$datas=array();
$datad=array();
sort($codes);
if(count($codes) >= $num){
$a = $this->Isniu($codes, $num);
}else{
$nums = count($codes);
$a = $this->Isniu($codes, $nums);
}
foreach ($a as $k=>$v){
$datas[$k]=$v;
}
$datad[$type]=$datas;
return $datad;
}
function getCombinationToString($arr, $m)
{
$result = array();
if ($m == 1) {
return $arr;
}
if ($m == count($arr)) {
$result[] = implode(',', $arr);
return $result;
}
$temp_firstelement = $arr[0];
unset($arr[0]);
$arr = array_values($arr);
$temp_list1 = $this->getCombinationToString($arr, ($m - 1));
foreach ($temp_list1 as $s) {
$s = $temp_firstelement . ',' . $s;
$result[] = $s;
}
unset($temp_list1);
$temp_list2 = $this->getCombinationToString($arr, $m);
foreach ($temp_list2 as $s) {
$result[] = $s;
}
unset($temp_list2);
return $result;
}
function Isniu($codes, $num)
{
$r= $this->getCombinationToString($codes, $num);
$code_names=array();
return $r;
}
function CodesDatas($data, $num, $game_name)
{
$codes = array();
foreach ($data as $k => $v) {
$type = $k;
if (is_array($v) && count($v) > 0) {
foreach ($v as $k1 => $v1) {
$money = $v[$k1][0];
$multiple = $v[$k1]['settings']['multiple'];
$codes[] = $k1;
}
}
}
foreach ($codes as $v) {
$coded[] = lang($game_name)->get($v);
}
if(count(explode('_', $codes[0]))>1){
$a = $this->PositionGroup($codes,$num);
}else{
$a = $this->Isniu($codes, $num);
}
$sixarr = array('sfsixlottery','sixlottery');
foreach ($a as $k => $v) {
$codelists[$k]['codes'] = $v;
$codelists[$k]['money'] = $money;
$codelists[$k]['multiple'] = $multiple;
$codelists[$k]['show_nos'] = in_array($game_name, $sixarr)?$this->ChangeLan($game_name,$v):$v;
$codelists[$k]['show_type'] = in_array($game_name, $sixarr)? lang($game_name)->get($type):lang($game_name)->get($type);
$codelists[$k]['codeDate'] = $type;
}
return $codelists;
}
//按位置分组,不同位置号码可相同
private function PositionGroup($codes,$num){
$arr = array();
$tarr = array();
$tc = '';
$i = 0;
$j = 0;
foreach ($codes as $k => $v) {
$i = 0;
$cs = explode('_', $v);
if(!empty($tc) && $tc!=$cs[0]){
$j = 0;
$tarr = $arr;
$arr = array();
}
if(empty($tarr)){
$arr[][$cs[0]] = $v;
}else{
$arr = array_merge($arr,$tarr);
$n = count($arr);
$i = $j;
for($i=$j;$i<$n;$i++){
if(isset($arr[$i][$cs[0]]))break;
$arr[$i][$cs[0]] = $v;
$j++;
}
}
$tc = $cs[0];
}
foreach ($arr as $key => $value) {
$arr[$key] = implode(',', $value);
}
return $arr;
}
function currentTotalMoney($data, $money, $joins)
{
$codes = array();
$tempMoney = 0;
foreach ($data as $k => $v) {
$class = explode('-', $v['name']);
$class[0] = str_replace('_', '', $class[0]);
$obj = $joins[$class[0]];
if (!$obj) {
// toLog('-3223-' . "{$class[0]}");
return -3223;
}
if ($obj->getCalcRule() == 'spesc') {
$tempMoney = $tempMoney + $v['price'];
$one_price = $v['price'];
$temp = explode('_', $class[1]);
// $codes[$temp[0]] = array();
// array_push($codes[$temp[0]], $temp[1]);
if (!array_key_exists($temp[0] - 1, $codes)) {
$codes[$temp[0] - 1] = array();
}
array_push($codes[$temp[0] - 1], intval($temp[1]));
}
}
$countarr = $this->countNum($data, $obj->num);
$money_codes = $one_price * $countarr;
$truemoeny = ($money - $tempMoney) > 0 ? $money - $tempMoney : 0;
$num = $truemoeny + $money_codes;
// dump($num);
return $num;
}
function countNums($codes, $num)
{
$a = count($codes);//总号码数
if ($a < $num) {
return -2127;
}
$total = 1;
for ($i = $a; $i >= 1; $i--) {
if ($i > $a - $num) {
$total *= $i;
}
}
for ($i = $num; $i >= 1; $i--) {
$total /= $i;
}
//dump($a);
return $total;
}
function prizeChange($params,$gamename){
if (is_array($params) && count($params) > 0) {
foreach ($params as $k => $v) {
if (is_array($v) && count($v) > 0) {
foreach ($v as $k1 => $v1) {
$args[] = array('codes' => lang($gamename)->get($k . '-' . $v1), 'codeDate' => $k);
}
}else{
$args[] = array('codes' => lang($gamename)->get($k . '-' . $v), 'codeDate' => $k);
}
}
}
return $args;
}
function PrizeData($data)
{
$codes = array();
foreach ($data as $k => $v) {
$type = $k;
if (is_array($v) && count($v) > 0) {
foreach ($v as $k1 => $v1) {
$temp = explode('_', $v1);
if (!array_key_exists($temp[0] - 1, $codes)) {
$codes[$temp[0] - 1] = array();
array_push($codes[$temp[0] - 1], intval($temp[1]));
} else {
array_push($codes[$temp[0] - 1], intval($temp[1]));
}
}
}
}
$tempArr = $this->countNum($codes, 0, $type);
return $tempArr;
}
function PrizesDatas($data, $num, $game_name)
{
$codes = array();
foreach ($data as $k => $v) {
$type = $k;
if (is_array($v) && count($v) > 0) {
foreach ($v as $k1 => $v1) {
$codes[] = $v1;
}
}
}
foreach ($codes as $v) {
$coded[] = lang($game_name)->get($v);
}
$a = $this->Isniu($codes, $num);
foreach ($a as $k => $v) {
$codelists[$k]['codes'] = $v;
$codelists[$k]['codeDate'] = $type;
}
return $codelists;
}
/**
* @param $data
* @param $num
* @param string $is_prize 匹配多少个算中奖
* @param string $is_str 表示是字符串的号码
* @return mixed
*/
function PrizesData($data, $num, $is_prize = '', $is_str = '', $game = '')
{
$codes = array();
foreach ($data as $k => $v) {
$type = $k;
if (is_array($v) && count($v) > 0) {
foreach ($v as $k1 => $v1) {
if ($k == 'series_twospecial'){
$codes[]= str_replace('g_','',$v1);
}else{
$codes[] = $v1;
}
}
}
}
if(count($codes) >= $num){
$a = $this->Isniu($codes, $num);
}else{
$nums = count($codes);
$a = $this->Isniu($codes, $nums);
}
//语言包内容组合
if (is_array($a)){
foreach ($a as $k => $v) {
$codelists[$k]['codes'] = $v;
$codelists[$k]['codeDate'] = $type;
if (!empty($is_prize)) {
$codelists[$k]['is_prize'] = $is_prize;
}
if (!empty($is_str)) {
$codelists[$k]['is_str'] = $is_str;
}
if (!empty($game)) {
$codelists[$k]['game'] = $game;
}
}
}else{
$codelists='';
}
return $codelists;
}
function PrizeDetails($data_paramt,$game_name){
if (array_key_exists("sum_born", $data_paramt)) {
$paramt = $this->prizeChange($data_paramt, $game_name);
foreach ($data_paramt as $k =>$v){
foreach ($v as $kk => $vv){
if ($vv == 2){
foreach ($paramt as $k=>$v){
$paramt[$k]['codes']='总肖-234';
}
}else{
$paramt=$this->prizeChange($datat, $game_name);
}
}
}
}elseif (array_key_exists("head_three", $data_paramt)) {
$paramt = $this->PrizeData($data_paramt);
} elseif (array_key_exists("head_two", $data_paramt)) {
$paramt = $this->PrizeData($data_paramt);
} elseif (array_key_exists("specialthree", $data_paramt)) {
//特码包3
$stdp['specialthree'] = $data_paramt['specialthree'];
$paramt = $this->PrizesData($stdp, 3, 1);
$paramt1 = $this->prizeChange($data_paramt, $game_name);
foreach ($paramt1 as $stk => $stv) {
if($stv['codeDate']!='specialthree'){
$paramt[] = $stv;
}
}
}elseif (array_key_exists("series_twospecial", $data_paramt)) {
//二中特
$paramt = $this->PrizesData($data_paramt, 2, 2, 1);
} elseif (array_key_exists("series_four", $data_paramt)) {
//4全中
$paramt = $this->PrizesData($data_paramt, 4, 4);
} elseif (array_key_exists("series_three", $data_paramt)) {
//三全中
$paramt = $this->PrizesData($data_paramt, 3, 3);
}elseif (array_key_exists("twodiffnum", $data_paramt)) {
//二不同号
$paramt = $this->PrizesData($data_paramt, 2, 2);
}elseif (array_key_exists("thdiffnum", $data_paramt)) {
//三不同号
$paramt = $this->PrizesData($data_paramt, 3, 3);
} elseif (array_key_exists("series_specialmix", $data_paramt)) {
$paramt = $this->PrizesData($data_paramt, 2);
} elseif (array_key_exists("series_two", $data_paramt)) {
//二全中
$paramt = $this->PrizesData($data_paramt, 2, 2);
} elseif (array_key_exists("series_threetwo", $data_paramt)) {
//三种二
$paramt = $this->PrizesData($data_paramt, 3, 2);
} elseif (array_key_exists("series_fiveborn", $data_paramt)) {
$paramt = $this->PrizesDatas($data_paramt, 5, $game_name);
} elseif (array_key_exists("series_fourborn", $data_paramt)) {
$paramt = $this->PrizesDatas($data_paramt, 4, $game_name);
} elseif (array_key_exists("series_threeborn", $data_paramt)) {
$paramt = $this->PrizesDatas($data_paramt, 3, $game_name);
} elseif (array_key_exists("series_twoborn", $data_paramt)) {
$paramt = $this->PrizesDatas($data_paramt, 2, $game_name);
} elseif (array_key_exists("series_fiveend", $data_paramt)) {
//
$paramt = $this->PrizesData($data_paramt, 5);
} elseif (array_key_exists("series_fourend", $data_paramt)) {
//4尾碰
$paramt = $this->PrizesData($data_paramt, 4);
} elseif (array_key_exists("series_threeend", $data_paramt)) {
//三尾碰
$paramt = $this->PrizesData($data_paramt, 3);
} elseif (array_key_exists("series_twoend", $data_paramt)) {
$paramt = $this->PrizesData($data_paramt, 2);
} elseif (array_key_exists("selfselect_fivelose", $data_paramt)) {
//五不中
$paramt = $this->PrizesData($data_paramt, 5, 5);
} elseif (array_key_exists("selfselect_sevenlose", $data_paramt)) {
//七不中
$paramt = $this->PrizesData($data_paramt, 7, 7);
} elseif (array_key_exists("selfselect_ninelose", $data_paramt)) {
//九不中
$paramt = $this->PrizesData($data_paramt, 9, 9);
} elseif (array_key_exists("selfselect_sixlose", $data_paramt)) {
//六不中
$paramt = $this->PrizesData($data_paramt, 6, 6);
} elseif (array_key_exists("selfselect_tenlose", $data_paramt)) {
//十不中
$paramt = $this->PrizesData($data_paramt, 10, 10);
} elseif (array_key_exists("selfselect_twelvelose", $data_paramt)) {
//十二不中
$paramt = $this->PrizesData($data_paramt, 12, 12);
} elseif (array_key_exists("selfselect_elevenlose", $data_paramt)) {
//十一不中
$paramt = $this->PrizesData($data_paramt, 11, 11);
} elseif (array_key_exists("selfselect_eightlose", $data_paramt)) {
$paramt = $this->PrizesData($data_paramt, 8, 8);
}else {
$paramt = $this->prizeChange($data_paramt, $game_name);
}
return $paramt;
}
function CodesDetails($data_paramt,$game_name,$identity_no){
$tab_name = "bjpk10Parse";
$nums = C()->get($tab_name);
if (array_key_exists("sum_born", $data_paramt)) {
$datat = [
'codes' => $identity_no['codes'],
];
$paramt = $nums->change($datat, $game_name);
foreach ($data_paramt as $k =>$v){
foreach ($v as $kk => $vv){
if ($kk == 2){
foreach ($paramt as $k=>$v){
$paramt[$k]['codes']='总肖-234';
}
}else{
$paramt=$nums->change($datat, $game_name);
}
}
}
}elseif (array_key_exists("head_three", $data_paramt)) {
$paramt = $this->CodeData($data_paramt,$game_name);
} elseif (array_key_exists("head_two", $data_paramt)) {
$paramt = $this->CodeData($data_paramt,$game_name);
} elseif (array_key_exists("specialthree", $data_paramt)) {
//特码包3
$stdp['specialthree'] = $data_paramt['specialthree'];
$paramt = $this->CodesData($stdp, 3, 1,'',$game_name);
$datat = [
'codes' => $identity_no['codes'],
];
$paramt1 = $nums->change($datat, $game_name);
foreach ($paramt1 as $stk => $stv) {
if($stv['codeDate']!='specialthree'){
$paramt[] = $stv;
}
}
}elseif (array_key_exists("series_twospecial", $data_paramt)) {
//二中特
$paramt = $this->CodesData($data_paramt, 2, 2, 1,$game_name);
} elseif (array_key_exists("series_four", $data_paramt)) {
//4全中
$paramt = $this->CodesData($data_paramt, 4, 4,'',$game_name);
} elseif (array_key_exists("series_three", $data_paramt)) {
//三全中
$paramt = $this->CodesData($data_paramt, 3, 3,'',$game_name);
}elseif (array_key_exists("twodiffnum", $data_paramt)) {
//二不同号
$paramt = $this->CodesData($data_paramt, 2, 2,'',$game_name);
}elseif (array_key_exists("thdiffnum", $data_paramt)) {
//三不同号
$paramt = $this->CodesData($data_paramt, 3, 3,'',$game_name);
} elseif (array_key_exists("series_specialmix", $data_paramt)) {
$paramt = $this->CodesData($data_paramt, 2,'','',$game_name);
} elseif (array_key_exists("series_two", $data_paramt)) {
//二全中
$paramt = $this->CodesData($data_paramt, 2, 2,'',$game_name);
} elseif (array_key_exists("series_threetwo", $data_paramt)) {
//三种二
$paramt = $this->CodesData($data_paramt, 3, 2,'',$game_name);
} elseif (array_key_exists("series_fiveborn", $data_paramt)) {
$paramt = $this->CodesDatas($data_paramt, 5, $game_name);
} elseif (array_key_exists("series_fourborn", $data_paramt)) {
$paramt = $this->CodesDatas($data_paramt, 4, $game_name);
} elseif (array_key_exists("series_threeborn", $data_paramt)) {
$paramt = $this->CodesDatas($data_paramt, 3, $game_name);
} elseif (array_key_exists("series_twoborn", $data_paramt)) {
$paramt = $this->CodesDatas($data_paramt, 2, $game_name);
} elseif (array_key_exists("series_fiveend", $data_paramt)) {
//
$paramt = $this->CodesData($data_paramt, 5,'','',$game_name);
} elseif (array_key_exists("series_fourend", $data_paramt)) {
//4尾碰
$paramt = $this->CodesData($data_paramt, 4,'','',$game_name);
} elseif (array_key_exists("series_threeend", $data_paramt)) {
//三尾碰
$paramt = $this->CodesData($data_paramt, 3,'','',$game_name);
} elseif (array_key_exists("series_twoend", $data_paramt)) {
$paramt = $this->CodesData($data_paramt, 2,'','',$game_name);
} elseif (array_key_exists("selfselect_fivelose", $data_paramt)) {
//五不中
$paramt = $this->CodesData($data_paramt, 5, 5,'',$game_name);
} elseif (array_key_exists("selfselect_sevenlose", $data_paramt)) {
//七不中
$paramt = $this->CodesData($data_paramt, 7, 7,'',$game_name);
} elseif (array_key_exists("selfselect_ninelose", $data_paramt)) {
//九不中
$paramt = $this->CodesData($data_paramt, 9, 9,'',$game_name);
} elseif (array_key_exists("selfselect_sixlose", $data_paramt)) {
//六不中
$paramt = $this->CodesData($data_paramt, 6, 6,'',$game_name);
} elseif (array_key_exists("selfselect_tenlose", $data_paramt)) {
//十不中
$paramt = $this->CodesData($data_paramt, 10, 10,'',$game_name);
} elseif (array_key_exists("selfselect_twelvelose", $data_paramt)) {
//十二不中
$paramt = $this->CodesData($data_paramt, 12, 12,'',$game_name);
} elseif (array_key_exists("selfselect_elevenlose", $data_paramt)) {
//十一不中
$paramt = $this->CodesData($data_paramt, 11, 11,'',$game_name);
} elseif (array_key_exists("selfselect_eightlose", $data_paramt)) {
$paramt = $this->CodesData($data_paramt, 8, 8,'',$game_name);
}else {
$datat = [
'codes' => $identity_no['codes'],
];
$paramt = $nums->change($datat, $game_name);
}
return $paramt;
}
function PccodeDetails($buy_code){
if (array_key_exists("sum_born", $buy_code)) {
foreach ($buy_code as $k =>$v){
$type = $k;
foreach ($v as $kk => $vv){
if ($kk == 2){
$param['234']=$vv;
}else{
$param[$kk]=$vv;
}
}
}
$paramt[$type] = $param;
} elseif (array_key_exists("specialthree", $buy_code)) {
$st_bcode['specialthree'] = $buy_code['specialthree'];
$paramt = $this->CodesDataA($st_bcode, 3, 1);
$buy_code['specialthree'] = $paramt['specialthree'];
$paramt = $buy_code;
}elseif (array_key_exists("series_twospecial", $buy_code)) {
//二中特
$paramt = $this->CodesDataA($buy_code, 2, 2, 1);
} elseif (array_key_exists("series_four", $buy_code)) {
//四全中
$paramt = $this->CodesDataA($buy_code, 4, 4);
} elseif (array_key_exists("series_three", $buy_code)) {
//三全中
$paramt = $this->CodesDataA($buy_code, 3, 3);
} elseif (array_key_exists("thdiffnum", $buy_code)) {
//三不同号
$paramt = $this->CodesDataA($buy_code, 3, 3);
} elseif (array_key_exists("twodiffnum", $buy_code)) {
//二不同号
$paramt = $this->CodesDataA($buy_code, 2, 2);
} elseif (array_key_exists("series_specialmix", $buy_code)) {
//特串
$paramt = $this->CodesDataA($buy_code, 2, 2);
} elseif (array_key_exists("series_two", $buy_code)) {
//二全中
$paramt = $this->CodesDataA($buy_code, 2, 2);
} elseif (array_key_exists("series_threetwo", $buy_code)) {
//三种二
$paramt = $this->CodesDataA($buy_code, 3, 2);
} elseif (array_key_exists("series_fiveborn", $buy_code)) {
$paramt = $this->CodesDataA($buy_code, 5, 5, '');
} elseif (array_key_exists("series_fourborn", $buy_code)) {
$paramt = $this->CodesDataA($buy_code, 4, 4, '');
} elseif (array_key_exists("series_threeborn", $buy_code)) {
$paramt = $this->CodesDataA($buy_code, 3, 3, '');
} elseif (array_key_exists("series_twoborn", $buy_code)) {
$paramt = $this->CodesDataA($buy_code, 2, 2, '');
} elseif (array_key_exists("series_fiveend", $buy_code)) {
//五尾碰
$paramt = $this->CodesDataA($buy_code, 5, 5);
} elseif (array_key_exists("series_fourend", $buy_code)) {
$paramt = $this->CodesDataA($buy_code, 4, 4);
} elseif (array_key_exists("series_threeend", $buy_code)) {
$paramt = $this->CodesDataA($buy_code, 3, 3);
} elseif (array_key_exists("series_twoend", $buy_code)) {
//二尾碰
$paramt = $this->CodesDataA($buy_code, 2, 2);
} elseif (array_key_exists("selfselect_fivelose", $buy_code)) {
//五不中
$paramt = $this->CodesDataA($buy_code, 5, 5);
} elseif (array_key_exists("selfselect_sevenlose", $buy_code)) {
//七不中
$paramt = $this->CodesDataA($buy_code, 7, 7);
} elseif (array_key_exists("selfselect_ninelose", $buy_code)) {
//九不中
$paramt = $this->CodesDataA($buy_code, 9, 9);
} elseif (array_key_exists("selfselect_sixlose", $buy_code)) {
//六不中
$paramt = $this->CodesDataA($buy_code, 6, 6);
} elseif (array_key_exists("selfselect_tenlose", $buy_code)) {
//十不中
$paramt = $this->CodesDataA($buy_code, 10, 10);
} elseif (array_key_exists("selfselect_twelvelose", $buy_code)) {
//十二不中
$paramt = $this->CodesDataA($buy_code, 12, 12);
} elseif (array_key_exists("selfselect_elevenlose", $buy_code)) {
//十一不中
$paramt = $this->CodesDataA($buy_code, 11, 11);
} elseif (array_key_exists("selfselect_eightlose", $buy_code)) {
//八不中
$paramt = $this->CodesDataA($buy_code, 8, 8);
}elseif (array_key_exists("join_born", $buy_code)) {
//八不中
$paramt = $this->CodesDataA($buy_code, 1, 1);
}else{
$paramt= $buy_code;
}
return $paramt;
}
function PcWincodeDetails($prize_code,$datass,$datd,$cc,$bb,$buy_code){
if (array_key_exists("head_three", $prize_code)) {
$paramt = $this->CodeData($prize_code);
} elseif (array_key_exists("head_two", $prize_code)) {
$paramt = $this->CodeData($prize_code);
}elseif (array_key_exists("series_twospecial", $prize_code)) {
//二中特
$paramt = $this->CodesDatasA($datass, 2, 2, 1);
} elseif (array_key_exists("series_four", $prize_code)) {
//四全中
$paramt = $this->CodesDatasA($datd, 4, 4);
} elseif (array_key_exists("series_three", $prize_code)) {
//三全中
$paramt = $this->CodesDatasA($datd, 3, 3);
}elseif (array_key_exists("thdiffnum", $prize_code)) {
//三不同号
$paramt = $this->CodesDatasA($prize_code, 3, 3);
}elseif (array_key_exists("twodiffnum", $prize_code)) {
//二不同号
$paramt = $this->CodesDatasA($prize_code, 2, 2);
} elseif (array_key_exists("series_specialmix", $prize_code)) {
//特串
$paramt = $this->CodesDatasA($datass, 2, 2);
} elseif (array_key_exists("series_two", $prize_code)) {
//二全中
$paramt = $this->CodesDatasA($datd, 2, 2);
} elseif (array_key_exists("series_threetwo", $prize_code)) {
//三种二
$paramt = $this->CodesDatasA($datass, 3, 2);
} elseif (array_key_exists("series_fiveborn", $prize_code)) {
$paramt = $this->CodesDatasA($prize_code, 5, 5, '');
} elseif (array_key_exists("series_fourborn", $prize_code)) {
$paramt = $this->CodesDatasA($prize_code, 4, 4, '');
} elseif (array_key_exists("series_threeborn", $prize_code)) {
$paramt = $this->CodesDatasA($prize_code, 3, 3, '');
} elseif (array_key_exists("series_twoborn", $prize_code)) {
$paramt = $this->CodesDatasA($prize_code, 2, 2, '');
} elseif (array_key_exists("series_fiveend", $prize_code)) {
//五尾碰
if (count($cc) >= 5){
$paramt = $this->CodesDatasA($bb, 5, 5);
}else{
$paramt = $this->CodesDatasA($datass, 5, 5);
}
} elseif (array_key_exists("series_fourend", $prize_code)) {
if (count($cc) >= 4){
$paramt = $this->CodesDatasA($bb, 4, 4);
}else{
$paramt = $this->CodesDatasA($datass, 4, 4);
}
} elseif (array_key_exists("series_threeend", $prize_code)) {
if (count($cc) >= 3){
$paramt = $this->CodesDatasA($bb, 3, 3);
}else{
$paramt = $this->CodesDatasA($datass, 3, 3);
}
} elseif (array_key_exists("series_twoend", $prize_code)) {
//二尾碰
if (count($cc) >= 2){
$paramt = $this->CodesDatasA($bb, 2, 2);
}else{
$paramt = $this->CodesDatasA($datass, 2, 2);
}
} elseif (array_key_exists("selfselect_fivelose", $buy_code)) {
//五不中
$paramt = $datass;
} elseif (array_key_exists("selfselect_sevenlose", $buy_code)) {
//七不中
$paramt = $datass;
} elseif (array_key_exists("selfselect_ninelose", $buy_code)) {
//九不中
$paramt = $datass;
} elseif (array_key_exists("selfselect_sixlose", $buy_code)) {
//六不中
$paramt = $datass;
} elseif (array_key_exists("selfselect_tenlose", $buy_code)) {
//十不中
$paramt = $datass;
} elseif (array_key_exists("selfselect_twelvelose", $buy_code)) {
//十二不中
$paramt = $datass;
} elseif (array_key_exists("selfselect_elevenlose", $buy_code)) {
//十一不中
$paramt = $datass;
} elseif (array_key_exists("selfselect_eightlose", $buy_code)) {
//八不中
$paramt = $datass;
}else{
$paramt= $prize_code;
}
return $paramt;
}
function Win($args,$p_k,$p_v,$v,$arry,$num,$arrys,$odds,$dataw,$asd,$prize_num,$asse,$bb,$asb){
if (in_array($p_k, $arry)) {
$not_num = 2;
foreach ($p_v as $p_k1 => $p_v2) {
$datas = explode(',', $v['p_code']);
foreach ($datas as $vss){
if ($vss == $p_v2){
$not_num =1;
break;
}
}
}
if ($not_num == 2){
$args[$num]['prize_status'] = '中奖';
$args[$num]['get_money'] = $v['money'] * $v['odds']- $v['money'];;
} else {
$args[$num]['prize_status'] = '未中奖';
$args[$num]['get_money'] = -$v['money'];
}
} elseif (in_array($p_k, $arrys)) {
foreach ($p_v as $p_k1 => $p_v2) {
$datass = explode(',', $p_v2);
$datas2 = explode(',', $v['p_code']);
// var_dump($datas1,$datas2);
foreach ($datass as $va) {
$datas1[] = intval($va);
}
if (count($datas1) == 2 ) {
if ($v['p_code'] == $p_v2){
// echo 1;
$args[$num]['prize_status'] = '中奖';
$args[$num]['get_money'] = $v['money'] * $odds[$p_k]['settings']['multiple']['max'] - $v['money'];
$args[$num]['odds'] = $odds[$p_k]['settings']['multiple']['max'];
}
if($v['p_code'] == $p_v2 && stripos($v['p_code'], $dataw[6]) !== false) {
$args[$num]['prize_status'] = '中奖';
$args[$num]['odds'] = $odds[$p_k]['settings']['multiple']['min'];
$args[$num]['get_money'] = $v['money'] * $odds[$p_k]['settings']['multiple']['min'] - $v['money'];
// break;
}
}
if (count($datas1) == 3 ) {
if ($v['p_code'] == $p_v2){
// echo 1;
$args[$num]['prize_status'] = '中奖';
$args[$num]['get_money'] = $v['money'] * $odds[$p_k]['settings']['multiple']['min'] - $v['money'];
$args[$num]['odds'] = $odds[$p_k]['settings']['multiple']['min'];
break;
}
$intersection = array_intersect($datas1, $datas2);
if(count($intersection) == 2 && $v['p_code'] != $p_v2) {
// var_dump($intersection);
$args[$num]['prize_status'] = '中奖';
$args[$num]['odds'] = $odds[$p_k]['settings']['multiple']['max'];
$args[$num]['get_money'] = $v['money'] * $odds[$p_k]['settings']['multiple']['max'] - $v['money'];
// break;
}
}
unset($datas1);
}
}elseif (in_array($p_k, $asd)) {
$datas1 = explode(',', $prize_num);
if (in_array(49, $datas1)) {
$args[$num]['prize_status'] = '和';
$args[$num]['odds'] = 1;
$args[$num]['get_money'] = $v['money'];
} else {
foreach ($p_v as $p_k1 => $p_v2) {
if ($v['p_code'] == $p_v2) {
$args[$num]['prize_status'] = '中奖';
$args[$num]['get_money'] = $v['money'] * $v['odds'] - $v['money'];
break;
} else {
$args[$num]['prize_status'] = '未中奖';
$args[$num]['get_money'] = -$v['money'];
}
}
}
}
elseif(in_array($p_k,$asse)){
foreach ($asse as $kk=> $vv){
if (count($bb) < $kk){
$args[$num]['prize_status'] = '未中奖';
$args[$num]['get_money'] = -$v['money'];
}
}
foreach ($p_v as $p_k1 => $p_v2) {
if ($v['p_code'] == $p_v2) {
$args[$num]['prize_status'] = '中奖';
$args[$num]['get_money'] = $v['money'] * $v['odds'] - $v['money'];
break;
} else {
$args[$num]['prize_status'] = '未中奖';
$args[$num]['get_money'] = -$v['money'];
}
}
}elseif ($p_k == 'series_specialmix') {
foreach ($p_v as $p_k1 => $p_v2) {
if ($v['p_code'] == $p_v2 && stripos($v['p_code'], $dataw[6]) !== false) {
$args[$num]['prize_status'] = '中奖';
$args[$num]['get_money'] = $v['money'] * $v['odds'] - $v['money'];
break;
} else {
$args[$num]['prize_status'] = '未中奖';
$args[$num]['get_money'] = -$v['money'];
}
}
}elseif ($p_k == 'specialthree') {
foreach ($p_v as $p_k1 => $p_v2) {
$stcodes = explode(',', $v['p_code']);
if(in_array($p_v2, $stcodes)){
$args[$num]['prize_status'] = ($p_v2==13 || $p_v2==14)?'和':'中奖';
$v['odds'] = ($p_v2==13 || $p_v2==14)?1:$v['odds'];
$args[$num]['get_money'] = $v['money'] * $v['odds'] - $v['money'];
break;
} else {
$args[$num]['prize_status'] = '未中奖';
$args[$num]['get_money'] = -$v['money'];
}
}
}elseif ($p_k == 'seven_colorwave') {
foreach ($p_v as $p_k1 => $p_v2) {
if ($v['p_code'] == $p_v2 && $v['p_code'] == 'draw') {
$args[$num]['prize_status'] = '中奖';
$args[$num]['get_money'] = ($v['money'] * $v['odds'] + $v['back']) - $v['money'];
break;
} else {
$args[$num]['prize_status'] = '和';
$args[$num]['get_money'] = 0;
}
if ($v['p_code'] == $p_v2 ) {
$args[$num]['prize_status'] = '中奖';
$args[$num]['get_money'] = ($v['money'] * $v['odds'] + $v['back']) - $v['money'];
break;
} else {
$args[$num]['prize_status'] = '未中奖';
}
}
}
elseif(in_array($p_k,$asb)){
if (isset($v['prize_status'])){
if ($v['prize_status'] == "和"){
$args[$num]['prize_status'] = '和';
$args[$num]['odds'] = 1;
$args[$num]['get_money'] = $v['money'];
}else{
foreach ($p_v as $p_k1 => $p_v2) {
if ($v['p_code'] == $p_v2) {
$args[$num]['prize_status'] = '中奖';
$args[$num]['get_money'] = $v['money'] * $v['odds'] - $v['money'];
break;
} else {
$args[$num]['prize_status'] = '未中奖';
$args[$num]['get_money'] = -$v['money'];
}
}
}
}else{
foreach ($p_v as $p_k1 => $p_v2) {
if ($v['p_code'] == $p_v2) {
$args[$num]['prize_status'] = '中奖';
$args[$num]['get_money'] = $v['money'] * $v['odds'] - $v['money'];
break;
} else {
$args[$num]['prize_status'] = '未中奖';
$args[$num]['get_money'] = -$v['money'];
}
}
}
}else {
foreach ($p_v as $p_k1 => $p_v2) {
if ($v['p_code'] == $p_v2) {
$args[$num]['prize_status'] = '中奖';
$args[$num]['get_money'] = $v['money'] * $v['odds'] - $v['money'];
break;
} else {
$args[$num]['prize_status'] = '未中奖';
$args[$num]['get_money'] = -$v['money'];
}
}
}
return $args;
}
/*
*提现限额
*/
function recordWithdraw($type=1,$account_identity,$money=0,$donate_money,$percent=1,$remark=''){
//用户id
if(empty($account_identity)){
return -50020;
}
//本金
if($money < 0){
return -50021;
}
//彩金
if($donate_money < 0){
return -50022;
}
//倍数
if(empty($percent)){
return -50023;
}
$widthdraw = lm('WithDrawRule',"commons")->where('account_identity',$account_identity)->first();
$account = lm('Account_detailed',"commons")->where('account_identity',$account_identity)->first();
if(!empty($account)){
$account = $account->toArray();
}else{
return -50024;
}
$data['updated_at'] = date('Y-m-d H:i:s');
$total = $money+$donate_money;
if(!empty($widthdraw)){
$widthdraw = $widthdraw->toArray();
$data['needBettingMoney'] = $total*$percent+$widthdraw['needBettingMoney'];
if(empty($widthdraw['donate_start'])){
$data['donate_start'] = date('Y-m-d H:i:s');
}
$res=lm('WithDrawRule', 'commons')->where('account_identity', $account_identity)->update($data);
}else{
$data['bettingMoney'] = 0;
$data['needBettingMoney'] = $total*$percent;
$data['account_identity'] = $account_identity;
$data['created_at'] = date('Y-m-d H:i:s');
$data['start_time'] = time();
$data['donate_start'] = date('Y-m-d H:i:s');
$res=lm ('WithDrawRule', 'commons')->insert($data);
}
return $res;
}
//有效投注统计
function EffectiveBetting($data,$c=-1)
{
$id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; //用户唯一id
$page = isset($data['page']) ? $data['page'] : 1;
//$start = isset($data['start']) ? $data['start'] : '';
//$end = isset($data['end']) ? $data['end'] : '';
$time = isset($data['time']) ? $data['time'] : '';
$start = '';
$end = '';
if(!empty($time)){//qtx 2018-12-11
$newtime = explode('~',$time);
if(count($newtime) ==2){
$start = $newtime[0].' 00:00:00';
$end = $newtime[1].' 23:59:59';
}else{
$start = $time;
$end = date("Y-m-d", strtotime("+1 day", strtotime($time)));
}
}
if (empty($id_one)) {
return -4010;
}
$where = "account_identity = '". $id_one ."' AND status < 4 AND game_status > 0";
$wheretwo = "account_identity = '". $id_one."'";
//时间段
if(!empty($start) && !empty($end))
{
$where .= " AND money_time >= '".$start."' AND money_time <= '".$end."'";
$wheretwo .= " AND money_time >= '".$start."' AND money_time <= '".$end."'";
}
//时间段,只有开始
if(!empty($start) && empty($end))
{
$where .= " AND money_time >= '".$start."'";
$wheretwo .= " AND money_time >= '".$start."'";
}
//时间段,只有结束
if(empty($start) && !empty($end))
{
$where .= " AND money_time <= '".$end."'";
$wheretwo .= " AND money_time <= '".$end."'";
}
//print_r($where); exit;
$filed = ['order_id','game_name','game_no','money','prize_money','game_status','money_time'];
//dump($where);
$rows = lm("money_buy", "commons")->whereRaw($where)->get($filed);
if($c==1){//qtx 2018-12-19
$countMoney = lm("money_buy", "commons")->whereRaw($where)->sum('money');
$winMoney = lm("money_buy", "commons")->whereRaw($where)->sum('prize_money');
$profitMoney = lm("money_buy", "commons")->whereRaw($where)->sum('get_money');
$sumbet = lm("money_buy", "commons")->whereRaw($wheretwo)->sum('money');//总投注
$wherethree[] = array('status','<',4);
$wherethree[] = array('game_status','=',0);
$noawardbet = lm("money_buy", "commons")->whereRaw($wheretwo)->where($wherethree)->sum('money');//未开奖投注
$cancelbet = lm("money_buy", "commons")->whereRaw($wheretwo)->where('status','=',4)->sum('money');//撤单投注
$sumbet = empty($sumbet)?0:$sumbet;
$noawardbet = empty($noawardbet)?0:$noawardbet;
$cancelbet = empty($cancelbet)?0:$cancelbet;
$countMoney = empty($countMoney)?0:$countMoney;
$winMoney = empty($winMoney)?0:$winMoney;
$profitMoney = empty($profitMoney)?0:$profitMoney;
$arrto['countMoney'] = $countMoney;
$arrto['winMoney'] = $winMoney;
$arrto['profitMoney'] = $profitMoney;
$arrto['sumbet'] = $sumbet;
$arrto['noawardbet'] = $noawardbet;
$arrto['cancelbet'] = $cancelbet;
return $arrto;
}
if (count($rows) != 0) {
$list = 20;
//获取总页数
$count_list = lm("money_buy", "commons")->whereRaw($where)->count();
$count_page = ceil($count_list / $list);
$first = ($page - 1) * $list;
$rows = lm("money_buy", "commons")
->orderBy('money_time', 'desc')
->whereRaw($where)
->offset($first)
->limit($list)
->get($filed)
->toArray();
//计算当前页总和
$sum = lm("money_buy", "commons")
->orderBy('money_time', 'desc')
->whereRaw($where)
->offset($first)
->limit($list)
->get(['money']);
$current_total = $sum->sum('money');
//总投注额
$total_sum = lm("money_buy", "commons")
->orderBy('money_time', 'desc')
->whereRaw($where)->sum('money');
}else{
return ['type'=>1,'code' => -10009];
}
$game = lm('game_type','commons')->get(['name','table_name']);
$lang = [];
foreach ($game as $k=>$v)
{
$lang[$v['table_name']] = $v['name'];
}
$dat = [
'type'=>1,
'data' => $rows,
'current_total' => $current_total,
'total_sum' =>$total_sum,
'count_page' => $count_page,
'page' => $page,
'lang' =>$lang,
];
return $dat;
}
//六合投注统计
function EffectivesixBetting($data,$c=-1)//qtx 2018-12-19
{
$id_one = isset($data['account_identity']) ? $data['account_identity'] : ''; //用户唯一id
$page = isset($data['page']) ? $data['page'] : 1;
//$start = isset($data['start']) ? $data['start'] : '';
//$end = isset($data['end']) ? $data['end'] : '';
$time = isset($data['time']) ? $data['time'] : '';
$start = '';
$end = '';
if(!empty($time)){//qtx 2018-12-11
$newtime = explode('~',$time);
if(count($newtime) ==2){
$start = $newtime[0].' 00:00:00';
$end = $newtime[1].' 23:59:59';
}else{
$start = $time;
$end = date("Y-m-d", strtotime("+1 day", strtotime($time)));
}
}
if (empty($id_one)) {
return -4010;
}
$where = "account_identity = '". $id_one ."' AND status < 4 AND game_status > 0";
$wheretwo = "account_identity = '". $id_one."'";
//时间段
if(!empty($start) && !empty($end))
{
$where .= " AND money_time >= '".$start."' AND money_time <= '".$end."'";
$wheretwo .= " AND money_time >= '".$start."' AND money_time <= '".$end."'";
}
//时间段,只有开始
if(!empty($start) && empty($end))
{
$where .= " AND money_time >= '".$start."'";
$wheretwo .= " AND money_time >= '".$start."'";
}
//时间段,只有结束
if(empty($start) && !empty($end))
{
$where .= " AND money_time <= '".$end."'";
$wheretwo .= " AND money_time <= '".$end."'";
}
//print_r($where);
$filed = ['order_id','game_name','game_no','money','prize_money','game_status','money_time'];
$rows = lm("SixMoney_buy", "commons")->whereRaw($where)->get($filed);
if($c==1){//qtx 2018-12-19
$countMoney = lm("SixMoney_buy", "commons")->whereRaw($where)->sum('money');
$winMoney = lm("SixMoney_buy", "commons")->whereRaw($where)->sum('prize_money');
$profitMoney = lm("SixMoney_buy", "commons")->whereRaw($where)->sum('get_money');
$sumbet = lm("SixMoney_buy", "commons")->whereRaw($wheretwo)->sum('money');//总投注
$wherethree[] = array('status','<',4);
$wherethree[] = array('game_status','=',0);
$noawardbet = lm("SixMoney_buy", "commons")->whereRaw($wheretwo)->where($wherethree)->sum('money');//未开奖投注
$cancelbet = lm("SixMoney_buy", "commons")->whereRaw($wheretwo)->where('status','=',4)->sum('money');//撤单投注
$sumbet = empty($sumbet)?0:$sumbet;
$noawardbet = empty($noawardbet)?0:$noawardbet;
$cancelbet = empty($cancelbet)?0:$cancelbet;
$countMoney = empty($countMoney)?0:$countMoney;
$winMoney = empty($winMoney)?0:$winMoney;
$profitMoney = empty($profitMoney)?0:$profitMoney;
$arrto['sixcountMoney'] = $countMoney;
$arrto['sixwinMoney'] = $winMoney;
$arrto['sixprofitMoney'] = $profitMoney;
$arrto['sixsumbet'] = $sumbet;
$arrto['sixnoawardbet'] = $noawardbet;
$arrto['sixcancelbet'] = $cancelbet;
//dump($arrto);
return $arrto;
}
if (count($rows) != 0) {
$list = 20;
//获取总页数
$count_list = lm("SixMoney_buy", "commons")->whereRaw($where)->count();
$count_page = ceil($count_list / $list);
$first = ($page - 1) * $list;
$rows = lm("SixMoney_buy", "commons")
->orderBy('money_time', 'desc')
->whereRaw($where)
->offset($first)
->limit($list)
->get($filed)
->toArray();
//计算当前页总和
$sum = lm("SixMoney_buy", "commons")
->orderBy('money_time', 'desc')
->whereRaw($where)
->offset($first)
->limit($list)
->get(['money']);
$current_total = $sum->sum('money');
//总投注额
$total_sum = lm("SixMoney_buy", "commons")
->orderBy('money_time', 'desc')
->whereRaw($where)->sum('money');
}else{
return ['type'=>1,'code' => -10009];
}
$game = lm('game_type','commons')->get(['name','table_name']);
$lang = [];
foreach ($game as $k=>$v)
{
$lang[$v['table_name']] = $v['name'];
}
$dat = [
'type'=>1,
'data' => $rows,
'current_total' => $current_total,
'total_sum' =>$total_sum,
'count_page' => $count_page,
'page' => $page,
'lang' =>$lang,
];
return $dat;
}
/*
*手机端记录
*/
/*
*手机端记录
*/
public function NewBettinglist($data)
{
$id_one = $data['account_identity'] ? $data['account_identity'] : ''; //用户唯一id
$status = $data['status'] ? $data['status'] : ''; //资金状态
$order_id = $data['order_id'] ? $data['order_id'] : ''; //资金类型
if($data['game_status'] != ''){
$game_status = $data['game_status'];
}
$game_name = $data['game_name'] ? $data['game_name'] : ''; //资金类型
$page = $data['page'] ? $data['page'] : '1'; //资金类型
$money_time = $data['time'] ? $data['time'] : date('Y-m-d'); //时间
$reorder = $data['reorder'] ? $data['reorder'] : 'money_time';
$updown = $data['updown'] ? $data['updown'] : 'desc';
if (!empty($money_time)) {//qtx 2018-12-11
$newtime = explode('~',$money_time);
if(count($newtime) ==2){
$start_time = $newtime[0];
$end_time = $newtime[1];
$beforetime = date("Y-m-d",strtotime("$start_time -1 day"));
$nexttime = date("Y-m-d",strtotime("$end_time +1 day"));
}else{
$beforetime = date("Y-m-d",strtotime("$money_time -1 day"));
$nexttime = date("Y-m-d",strtotime("$money_time +1 day"));
}
}
//$beforetime = date("Y-m-d",strtotime("$money_time -1 day"));
//$nexttime = date("Y-m-d",strtotime("$money_time +1 day"));
//return $page;
$play_num = "";
if (empty($id_one)) {
return -4010;
}
$arr = [ //向数据库追加数组 然后循环出来
'status' => $status,
'account_identity' => $id_one,
'order_id' => $order_id,
'game_status' => $game_status,
'game_name' => $game_name,
'money_time' => $money_time
];
$account = lm("game_type", "commons");
$game = $account->where("status", "=", "1")->get()->toArray();
//return $game;
$where = '1 = 1';
$wheretwo = '2=2';
$wherethree = '3=3';
foreach ($arr as $key => $value) {
//循环数组
if($value != '' && $key =='money_time'){
if(count($newtime) ==2){
$where .= " AND money_time>='".$start_time." 00:00:00' AND money_time<='".$end_time." 23:59:59'";
}else{
$where .= " AND {$key}>='{$value} 00:00:00' AND {$key}<='{$value} 23:59:59'";
}
}else{
if ($value != '' && $key != 'a.id' && $key != 'b.id') { //判断条件
$where .= " AND {$key}='{$value}'"; //获取值
}
}
}
$arr['money_time'] = $beforetime;
/* foreach ($arr as $key => $value) {
if($value != '' && $key =='money_time'){
$wheretwo .= " AND {$key}>='{$value} 00:00:00' AND {$key}<='{$value} 23:59:59'";
}else{
if ($value != '' && $key != 'a.id' && $key != 'b.id') { //判断条件
$wheretwo .= " AND {$key}='{$value}'"; //获取值
}
}
}
$arr['money_time'] = $nexttime;
foreach ($arr as $key => $value) {
if($value != '' && $key =='money_time'){
$wherethree .= " AND {$key}>='{$value} 00:00:00' AND {$key}<='{$value} 23:59:59'";
}else{
if ($value != '' && $key != 'a.id' && $key != 'b.id') { //判断条件
$wherethree .= " AND {$key}='{$value}'"; //获取值
}
}
}*/
//$code_data = lm("money_buy", "commons")->whereRaw($where)->get();
$resultdata =array();
$list = 15;
//获取总页数
$count_list = lm("money_buy", "commons")->whereRaw($where)->count();
$count_page = ceil($count_list / $list);
$first = ($page - 1) * $list;
//$code_datas = $accountd->orderBy('money_time', 'desc')->whereRaw($where)->offset($first)->limit($list)->get();
/* $before_data = lm("money_buy", "commons")
->whereRaw($wheretwo)->orderBy($reorder,$updown)
->offset($first)->limit($list)->get();
$next_data = lm("money_buy", "commons")
->whereRaw($wherethree)->orderBy($reorder,$updown)
->offset($first)->limit($list)->get();
*/
//2018-12-31 anton liu 添加六合彩追号记录 start
$game_data = lm("money_buy", "commons")
->whereRaw($where)->orderBy($reorder,$updown)
->offset($first)->limit($list)->orderby('id','desc')->get();
if (!$game_data) {
return -5004;
}
$game_data = $game_data->toArray();
//$before_data = '';
//$next_data = '';
$sixgame_data =[];
//新增获取六合彩追号记录 //2019-01-09 16:42 blues
if($status==2){
$sixgame_data = lm("SixMoney_buy", "commons")
->whereRaw($where)->orderBy($reorder,$updown)
->offset($first)->limit($list)->orderby('id','desc')->get();
if (!$sixgame_data) {
return -5004;
}
$sixgame_data = $sixgame_data->toArray();
}
$code_data = array_merge($game_data,$sixgame_data);
//end
$beforenum = 0;
$nextnum = 0;
$tonum = 0;
$rowy = array();
if(empty($before_data)){
$resultdata['beforeday'] = $beforenum;
}else{
$before_data = $before_data->toArray();
foreach ($before_data as $key => $value) {
$beforenum = $beforenum + floatval($value['get_money']);
}
$resultdata['beforeday'] = $beforenum;
}
if(empty($next_data)){
$resultdata['nextday'] = $nextnum;
}else{
$next_data = $next_data->toArray();
foreach ($next_data as $key => $value) {
$nextnum = $nextnum + floatval($value['get_money']);
}
$resultdata['nextday'] = $nextnum;
}
$Winning = $this->GetMoneyStatus();
$Status = $this->GetWinStatus();
foreach ($code_data as $k => $val) {
$val['game_type'] = lang()->get($val['game_name']);
$data_paramt =json_decode($val['codes'],true);
$regrouptype = $this->reGrouptype();
$grouparr = array();
foreach ($data_paramt as $key => $value) {
if(in_array($key, $regrouptype)){
foreach ($value as $sk => $sv) {
$seatarr = explode('_',$sk);
$val2=$sv;
if(isset($val2['settings'])){
unset($val2['settings']);
}
if(isset($grouparr[$seatarr[0]])){
$grouparr[$seatarr[0]] += count($val2);
}else{
$grouparr[$seatarr[0]] = count($val2);
}
}
}
}
$accounttwo = lm($val['game_name'] . "_buy", "commons");
$identity_no = $accounttwo->where("order_id", $val['order_id'])->first();
if (count($identity_no) != 0) {
$identity_no = $identity_no->toArray();
} else {
return "";
}
$paramt = $this->CodesDetails($data_paramt,$val['game_name'],$identity_no);
if (array_key_exists("general_pass", $data_paramt) || array_key_exists("join_born", $data_paramt)) {
$val['num'] = 1;
}else{
if(empty($grouparr)){
$val['num'] = count($paramt);
}else{
$val['num'] = 1;
foreach($grouparr as $k=>$v){
$val['num'] *= $v;
}
}
}
/* if($val['game_status'] > 0){
$tonum = $tonum+ floatval($val['get_money']);
}*/
$tonum = 0;
$val['timename'] = $this->time_tranx(strtotime($val['money_time']));
if($status == 4){
$wherecan['account_identity'] = $val['account_identity'];
$wherecan['out_order_id'] = $val['order_id'];
$cancel = lm("money_details", "commons")->where($wherecan)->first();
if(!empty($cancel)){
$cancel = $cancel->toArray();
$val['canceltime'] = $cancel['money_time'];
$val['canceltimename'] = $this->time_tranx(strtotime($cancel['money_time']));
}
}
foreach ($Winning as $key => $v) {
//return $val['status'];
if ($val['status'] == $key) {
$val['status'] = lang()->get($v);
$row[] = $val;
}
}
//$val['game_number'] = count($codes['specialCode']);
}
$resultdata['today'] = $tonum;
foreach ($Status as $key => $v) {
foreach ($row as $k => $val) {
if ($val['game_status'] == $key) {
$val['game_status'] = lang()->get($v);
$index = $val['id'];
$rowy[$index] = $val;
//$aa[]=$val;
}
}
}
rsort($rowy);
if($resultdata['today'] >= 0){
$resultdata['todayact'] = 1;
}else{
$resultdata['todayact'] = 0;
}
if($resultdata['beforeday'] >= 0){
$resultdata['beforedayact'] = 1;
}else{
$resultdata['beforedayact'] = 0;
}
if($resultdata['nextday'] >= 0){
$resultdata['nextdayact'] = 1;
}else{
$resultdata['nextdayact'] = 0;
}
$resultdata['tolist'] = $rowy;
$resultdata['count_page'] = $count_page;
$resultdata['act_page'] = intval($page);
return $resultdata;
}
/***
* 六合投注列表
* @param $data
* @return mixed
*/
public function newSixBettingRecord($data)
{
$id_one = $data['account_identity'] ? $data['account_identity'] : ''; //用户唯一id
$status = $data['status'] ? $data['status'] : ''; //资金状态
$order_id = $data['order_id'] ? $data['order_id'] : ''; //资金类型
$game_status = isset($data['game_status']) ? $data['game_status'] : ''; //资金类型
$game_name = $data['game_name'] ? $data['game_name'] : ''; //资金类型
$page = $data['page'] ? $data['page'] : '1'; //资金类型
$money_time = $data['time'] ? $data['time'] : date('Y-m-d'); //时间
$reorder = $data['reorder'] ? $data['reorder'] : 'money_time';
$updown = $data['updown'] ? $data['updown'] : 'desc';
if (!empty($money_time)) {//qtx 2018-12-11
$newtime = explode('~',$money_time);
if(count($newtime) ==2){
$start_time = $newtime[0];
$end_time = $newtime[1];
$beforetime = date("Y-m-d",strtotime("$start_time -1 day"));
$nexttime = date("Y-m-d",strtotime("$end_time +1 day"));
}else{
$beforetime = date("Y-m-d",strtotime("$money_time -1 day"));
$nexttime = date("Y-m-d",strtotime("$money_time +1 day"));
}
}
//return $page;
$play_num = "";
if (empty($id_one)) {
return -4010;
}
$arr = [ //向数据库追加数组 然后循环出来
'status' => $status,
'account_identity' => $id_one,
'order_id' => $order_id,
'game_status' => $game_status,
'money_time' => $money_time
];
$where = '1 = 1';
$wheretwo = '2=2';
$wherethree = '3=3';
foreach ($arr as $key => $value) {
//循环数组
if($value != '' && $key =='money_time'){
if(count($newtime) ==2){
$where .= " AND money_time>='".$start_time." 00:00:00' AND money_time<='".$end_time." 23:59:59'";
}else{
$where .= " AND {$key}>='{$value} 00:00:00' AND {$key}<='{$value} 23:59:59'";
}
}else{
if (($value != '' || $value===0) && $key != 'a.id' && $key != 'b.id') { //判断条件
$where .= " AND {$key}='{$value}'"; //获取值
}
}
}
$arr['money_time'] = $beforetime;
foreach ($arr as $key => $value) {
if($value != '' && $key =='money_time'){
$wheretwo .= " AND {$key}>='{$value} 00:00:00' AND {$key}<='{$value} 23:59:59'";
}else{
if (($value != '' || $value===0) && $key != 'a.id' && $key != 'b.id') { //判断条件
$wheretwo .= " AND {$key}='{$value}'"; //获取值
}
}
}
$arr['money_time'] = $nexttime;
foreach ($arr as $key => $value) {
if($value != '' && $key =='money_time'){
$wherethree .= " AND {$key}>='{$value} 00:00:00' AND {$key}<='{$value} 23:59:59'";
}else{
if (($value != '' || $value===0) && $key != 'a.id' && $key != 'b.id') { //判断条件
$wherethree .= " AND {$key}='{$value}'"; //获取值
}
}
}
$list = 15;
//获取总页数
$count_list = lm("sixMoney_buy", "commons")->whereRaw($where)->count();
$count_page = ceil($count_list / $list);
$first = ($page - 1) * $list;
$before_data = lm("sixMoney_buy", "commons")
->whereRaw($wheretwo)->orderBy($reorder,$updown)
->offset($first)->limit($list)->get();
$next_data = lm("sixMoney_buy", "commons")
->whereRaw($wherethree)->orderBy($reorder,$updown)
->offset($first)->limit($list)->get();
$code_data = lm("sixMoney_buy", "commons")
->whereRaw($where)->orderBy($reorder,$updown)
->offset($first)->limit($list)->get();
if (!$code_data) {
return -5004;
}
$beforenum = 0.00;
$nextnum = 0.00;
$tonum = 0.00;
$rowy = array();
if(empty($before_data)){
$resultdata['beforeday'] = $beforenum;
}else{
$before_data = $before_data->toArray();
foreach ($before_data as $key => $value) {
$beforenum = $beforenum + sprintf("%.2f",$value['get_money']);
}
$resultdata['beforeday'] = $beforenum;
}
if(empty($next_data)){
$resultdata['nextday'] = $nextnum;
}else{
$next_data = $next_data->toArray();
foreach ($next_data as $key => $value) {
$nextnum = $nextnum + sprintf("%.2f",$value['get_money']);
}
$resultdata['nextday'] = $nextnum;
}
$code_data = $code_data->toArray();
foreach ($code_data as $k=>$v){
$data_codes = lm($v['game_name'], "Commons")->select('status')->where('info_no', $v['game_no'])->first();
if ($data_codes){
$data_codes=$data_codes->toArray();
$code_data[$k]['gamed_status']=$data_codes['status'];
}
//$tonum = $tonum+ intval($v['get_money']);
}
//$resultdata['today'] = $tonum;
$Winning = $this->GetMoneyStatus();
$Status = $this->GetWinStatus();
foreach ($code_data as $k => $val) {
$val['game_type'] = lang()->get($val['game_name']);
$data_paramt =json_decode($val['codes'],true);
$regrouptype = $this->reGrouptype();
$grouparr = array();
foreach ($data_paramt as $key => $value) {
if(in_array($key, $regrouptype)){
foreach ($value as $sk => $sv) {
$seatarr = explode('_',$sk);
$val2=$sv;
if(isset($val2['settings'])){
unset($val2['settings']);
}
if(isset($grouparr[$seatarr[0]])){
$grouparr[$seatarr[0]] += count($val2);
}else{
$grouparr[$seatarr[0]] = count($val2);
}
}
}
}
$accounttwo = lm($val['game_name'] . "_buy", "commons");
$identity_no = $accounttwo->where("order_id", $val['order_id'])->first();
if (count($identity_no) != 0) {
$identity_no = $identity_no->toArray();
} else {
return "";
}
$paramt = $this->CodesDetails($data_paramt,$val['game_name'],$identity_no);
if (array_key_exists("general_pass", $data_paramt) || array_key_exists("join_born", $data_paramt)) {
$val['num'] = 1;
}else{
if(empty($grouparr)){
$val['num'] = count($paramt);
}else{
$val['num'] = 1;
foreach($grouparr as $k=>$v){
$val['num'] *= $v;
}
}
}
$tonum = $tonum + intval($val['get_money']);
$val['timename'] = $this->time_tranx(strtotime($val['money_time']));
if($status == 4){
$wherecan['account_identity'] = $val['account_identity'];
$wherecan['out_order_id'] = $val['order_id'];
$cancel = lm("money_details", "commons")->where($wherecan)->first();
if(!empty($cancel)){
$cancel = $cancel->toArray();
$val['canceltime'] = $cancel['money_time'];
$val['canceltimename'] = $this->time_tranx(strtotime($cancel['money_time']));
}
}
foreach ($Winning as $key => $v) {
//return $val['status'];
if ($val['status'] == $key) {
$val['status'] = lang()->get($v);
$row[] = $val;
}
}
}
$resultdata['today'] = $tonum;
foreach ($Status as $key => $v) {
foreach ($row as $k => $val) {
if ($val['game_status'] == $key) {
$val['game_status'] = lang()->get($v);
$index = $val['id'];
$rowy[$index] = $val;
//$aa[]=$val;
}
}
}
rsort($rowy);
if($resultdata['today'] >= 0){
$resultdata['todayact'] = 1;
}else{
$resultdata['todayact'] = 0;
}
if($resultdata['beforeday'] >= 0){
$resultdata['beforedayact'] = 1;
}else{
$resultdata['beforedayact'] = 0;
}
if($resultdata['nextday'] >= 0){
$resultdata['nextdayact'] = 1;
}else{
$resultdata['nextdayact'] = 0;
}
$resultdata['tolist'] = $rowy;
$resultdata['count_page'] = $count_page;
$resultdata['act_page'] = intval($page);
return $resultdata;
}
//时间函数
function time_tranx($the_time){
$dur = time() - $the_time;
if($dur < 0){
return $the_time;
}elseif($dur < 60){
return $dur.'秒前';
}elseif($dur < 3600){
return floor($dur/60).'分钟前';
}elseif($dur < 86400){
return floor($dur/3600).'小时前';
}elseif($dur < 259200){
return floor($dur/86400).'天前';
}else{
return '超过3天前';
}
}
/*
* 回水金额
*/
public function backWaterMoney($data){
$id_one = $data['account_identity'] ? $data['account_identity'] : ''; //用户唯一id
$status = isset($data['status']) ? $data['status'] : '1'; //资金状态
$new_time = isset($data['time']) ? $data['time'] : '';
if (empty($id_one)) {
return -4010;
}
if(!empty($new_time)){//qtx 2018-12-11
$newtime = explode('~',$new_time);
if(count($newtime) ==2){
$new_time1 = $newtime[0];
$new_time2 = $newtime[1];
}else{
$new_time1 = $new_time;
$new_time2 = $new_time;
}
$where[] = array('processing_time','>=',$new_time1.' 00:00:00');
$where[] = array('processing_time','<=',$new_time2.' 23:59:59');
}
$where[] = array('account_identity','=',$id_one);
$where[] = array('status','=',$status);
$code_data = lm("money_return", "commons")->where($where)->sum('money');
if (!$code_data) {
return -5004;
}
return $code_data;
}
/*
* 返水金额
*/
public function returnMoney($data){
$id_one = $data['account_identity'] ? $data['account_identity'] : ''; //用户唯一id
$status = isset($data['status']) ? $data['status'] : '3'; //资金状态
$new_time = isset($data['time']) ? $data['time'] : '';
if (empty($id_one)) {
return -4010;
}
if(!empty($new_time)){//qtx 2018-12-11
$newtime = explode('~',$new_time);
if(count($newtime) ==2){
$new_time1 = $newtime[0] ;
$new_time2 = $newtime[1];
}else{
$new_time1 = $new_time;
$new_time2 = $new_time;
}
$where[] = array('processing_time','>=',$new_time1.' 00:00:00');
$where[] = array('processing_time','<=',$new_time2.' 23:59:59');
}
$where[] = array('account_identity','=',$id_one);
$where[] = array('status','=',$status);
$code_data = lm("money_back", "commons")->where($where)->sum('money');
if (!$code_data) {
return -5004;
}
return $code_data;
}
/*
* 投注汇总结果
*/
public function bettingsum($data){
$id_one = $data['account_identity'] ? $data['account_identity'] : ''; //用户唯一id
if (empty($id_one)) {
return -4010;
}
$time = $data['time'] ? $data['time'] : date('Y-m-d'); //时间
$where[] = array('account_identity','=',$id_one);
$where[] = array('status','<',4);
$where[] = array('game_status','>',0);
if (!empty($time)) {//qtx 2018-12-11
$newtime = explode('~',$time);
if(count($newtime) ==2){
$start_time = $newtime[0];
$end_time = $newtime[1];
$beforetime = date("Y-m-d",strtotime("$start_time -1 day"));
$nexttime = date("Y-m-d",strtotime("$end_time +1 day"));
$where[] = array('money_time','>=',$start_time.' 00:00:00');
$where[] = array('money_time','<=',$end_time.' 23:59:59');
}else{
$beforetime = date("Y-m-d",strtotime("$time -1 day"));
$nexttime = date("Y-m-d",strtotime("$time +1 day"));
$where[] = array('money_time','>=',$time.' 00:00:00');
$where[] = array('money_time','<=',$time.' 23:59:59');
}
}
$arr = array();
$arrdata = array();
$tablename = lm("game_type", "commons")->select('name','table_name','close_status')->where("status", "=", "1")->where("table_name","<>",'-1')->get()->toArray();
foreach ($tablename as $key => $value) {
$arr[$value['table_name']]=$value;
$arr[$value['table_name']]['money'] = 0;
$arr[$value['table_name']]['prize_money'] = 0;
$arr[$value['table_name']]['get_money'] = 0;
}
$codedata = lm("money_buy", "commons")->where($where)->get();
$six_codedata = lm("SixMoney_buy", "commons")->where($where)->get();
// $where[3] = array('money_time','>=',$beforetime.' 00:00:00');
// $where[4] = array('money_time','<=',$beforetime.' 23:59:59');
// $before_data = lm("money_buy", "commons")->where($where)->get();
//
// $where[3] = array('money_time','>=',$nexttime.' 00:00:00');
// $where[4] = array('money_time','<=',$nexttime.' 23:59:59');
// $next_data = lm("money_buy", "commons")->where($where)->get();
$codedata = $codedata->toArray();
$six_codedata =count($six_codedata)>0? $six_codedata->toArray():[];
// $before_data = $before_data->toArray();
// $next_data = $next_data->toArray();
$before_data ='';
$next_data ='';
if(empty($codedata)){
$arrdata['today'] = 0;
$arrdata['todayact'] = 0;
$arrdata['tolist'] ='';
}
if(empty($before_data)){
$arrdata['beforeday'] = 0;
$arrdata['beforedayact'] = 0;
}
if(empty($next_data)){
$arrdata['nextday'] = 0;
$arrdata['nextdayact'] = 0;
}
foreach ($before_data as $key => $value) {
$arrdata['beforeday'] += $value['get_money'];
}
foreach ($next_data as $key => $value) {
$arrdata['nextday'] += $value['get_money'];
}
$codedata = array_merge($six_codedata,$codedata);
foreach ($codedata as $key => $value) {
$arr[$value['game_name']]['money'] += $value['money'];
$arr[$value['game_name']]['prize_money'] += $value['prize_money'];
$arr[$value['game_name']]['get_money'] += $value['get_money'];
$arrdata['today'] += $value['get_money'];
}
if($arrdata['today'] >= 0){
$arrdata['todayact'] = 1;
}else{
$arrdata['todayact'] = 0;
}
if($arrdata['beforeday'] >= 0){
$arrdata['beforedayact'] = 1;
}else{
$arrdata['beforedayact'] = 0;
}
if($arrdata['nextday'] >= 0){
$arrdata['nextdayact'] = 1;
}else{
$arrdata['nextdayact'] = 0;
}
$arrdata['tolist'] = array_values($arr);
return $arrdata;
}
}