name_chinese) ? trim($req->name_chinese) : null; $request['sureblurs'] = isset($req->sureblurs) ? $req->sureblurs : 'on'; $request['account'] = isset($req->account) ? trim($req->account) :null ; $request['star_time'] = isset($req->star_time) ? trim($req->star_time) :null ; $request['end_time'] = isset($req->end_time) ? trim($req->end_time) :null ; $request['order_id'] = isset($req->order_id) ? trim($req->order_id) :null ; $request['status'] = isset($req->status) ? trim($req->status) : '-1'; $dt = \App\Lib\DataTable\DataTable::init(); $dt->setDataSource('/admin/SoccerStringNoteList/info'); $dt->setLang('sportsnotelist'); //$dt->addColsFields('id', array('templet' => '#userdetail', 'sort' => true, 'width' => 80)); $dt->addColsFields('order_id', array('templet' => '#userdetail', 'sort' => true, 'width' => 200)); $dt->addColsFields('str_type', array('templet' => '#userdetail', 'sort' => false, 'width' => 70)); $dt->addColsFields('detail_content', array('sort' => false, 'width' => 150)); $dt->addColsFields('money', array('templet' => '#userdetail', 'sort' => false, 'width' => 90)); $dt->addColsFields('water_return', array('templet' => '#userdetail', 'sort' => false, 'width' => 90)); $dt->addColsFields('prize_money', array('templet' => '#userdetail', 'sort' => false, 'width' => 90)); $dt->addColsFields('result', array('templet' => '#userdetail', 'sort' => false, 'width' => 90)); $dt->addColsFields('money_match_time', array('templet' => '#userdetail', 'sort' => false, 'width' => 200)); $dt->addColsFields('account', array('templet' => '#userdetail', 'sort' => false, 'width' => 240)); $dt->addColsFields('settle_status', array('sort' => false, 'width' => 100)); // if (checkRriv('/admin/SoccerStringNoteList/edit')) { // $arr[] ='edit'; // } // $dt->setToolBar($arr, array('width' => 100)); $dt->enableCheckBox(); return view('sports/sports_stringnotelist', $dt->render($request)); } function info() { $page = Request::has('page') ? Request::get('page') : ''; $list = Request::has('limit') ? Request::get('limit') : 10; $account = Request::get('account') ? Request::get('account') : ''; $star_time = Request::get('star_time') ? Request::get('star_time').' 00:00:00' : ''; $end_time = Request::get('end_time') ? Request::get('end_time').' 23:59:59' : ''; $order_id = Request::get('order_id') ? Request::get('order_id') : ''; $status = Request::has('status') ? Request::get('status') : ''; $sureblur = Request::has('sureblurs') ? Request::get('sureblurs') : 'off'; $where = array(); if (!empty($account)) { if (empty($sureblur) || $sureblur == 'off') { $where[] = array('money_buy_str.account_name', 'like', '%' . $account . '%'); } else { $where[] = array('money_buy_str.account_name', '=', $account); } } if (!empty($star_time)) { if (!empty($end_time)){ $where[] = array('money_buy_str.money_time', '>', $star_time); $where[] = array('money_buy_str.money_time', '<', $end_time); }else{ $where[] = array('money_buy_str.money_time', '>', $star_time); } }else if(empty($star_time)){ if (!empty($end_time)){ $where[] = array('money_buy_str.money_time', '<', $end_time); } } if (!empty($order_id)){ $where[] = array('money_buy_str.order_id', $order_id); } if ($status != -1) { $where[] = array('money_buy_str.settle_status', '=', $status); } $newapp = new \App\Models\MoneyBuyStr(); $data = $newapp->getinfo($list, $page, $where); return \App\Lib\DataTable\DataTable::init()->toJson($data['data'], $data['total'], 0, $where); } /** *串关注单详情 */ function detail(Req $req) { $id = $req->id; $request['name_chinese'] = isset($req->name_chinese) ? trim($req->name_chinese) : null; $request['sureblurs'] = isset($req->sureblurs) ? $req->sureblurs : 'on'; $request['account'] = isset($req->account) ? trim($req->account) :null ; $request['match_id'] = isset($req->match_id) ? trim($req->match_id) :null ; $dt = \App\Lib\DataTable\DataTable::init(); $dt->setDataSource('/admin/SoccerStringNoteList/detailinfo?id='.$id.''); $dt->setLang('sportsnotelist'); $dt->addColsFields('match_id', array('templet' => '#userdetail', 'sort' => true, 'width' => 80)); $dt->addColsFields('league', array('templet' => '#userdetail', 'sort' => false, 'width' => 150)); $dt->addColsFields('home_guest', array('templet' => '#userdetail', 'sort' => false, 'width' => 180)); $dt->addColsFields('game_type', array('templet' => '#userdetail', 'sort' => false, 'width' => 90)); $dt->addColsFields('odds_code', array('templet' => '#userdetail', 'sort' => false, 'width' => 180)); $dt->addColsFields('condition', array('templet' => '#userdetail', 'sort' => false, 'width' => 80)); $dt->addColsFields('odds', array('templet' => '#userdetail', 'sort' => false, 'width' => 80)); $dt->addColsFields('status', array('templet' => '#userdetail', 'sort' => false, 'width' => 80)); $dt->addColsFields('result', array('templet' => '#userdetail', 'sort' => false, 'width' => 80)); $dt->enableCheckBox(); return view('sports/sports_notelistdetail', $dt->render($request)); } function detailinfo(Req $req) { $id = $req->id; $newapp = new \App\Models\MoneyBuyStr(); $data = $newapp->getdetailinfo($id); return \App\Lib\DataTable\DataTable::init()->toJson($data); } /** *串关注单结算 */ public function settlement(Req $req) { $id = $req->id; if (intval($id) < 1) { return -1; } $order = \App\Models\MoneyBuyStr::where('id', $id)->first(); $order_ids = array($order->order_id); //return $order_ids; $SettlementOrder = new SettlementOrder(); $bet_type = 2; //串关注单 $data = $SettlementOrder->reSettlement($order_ids, $bet_type); //dd($SettlementOrder); return $data; } /** *串关注单重新结算 */ public function resettlement(Req $req) { $id = $req->id; if (intval($id) < 1) { return -1; } $order = \App\Models\MoneyBuyStr::where('id',$id)->first(); $order_ids = array($order->order_id); //return $order_ids; $SettlementOrder = new SettlementOrder(); $bet_type = 2; //串关注单 $data = $SettlementOrder->reSettlement($order_ids,$bet_type); return $data; $m = explode('串',$order->str_type); //获取此订单下包含的赛事 $matchs = \App\Models\MoneyBuyMatch::where('batch_id',$order->batch_id)->where('bet_type',2)->get()->toArray(); function combination($a, $m) { $r = array(); $n = count($a); if ($m <= 0 || $m > $n) { return $r; } for ($i=0; $i<$n; $i++) { $t = array($a[$i]); if ($m == 1) { $r[] = $t; } else { $b = array_slice($a, $i+1); $c = combination($b, $m-1); foreach ($c as $v) { $r[] = array_merge($t, $v); } } } return $r; } $arr = combination($matchs,$m[0]); $win_money = 0; for($i=0;$imoney/count($arr); for($j=0;$jresult == 0){ //未处理 return ""; }else if($arr[$i][$j]->result == -1){ //输 $win_money = 0; $model = new \App\Models\MoneyBuyStr(); $model = $model::find($id); $model->gain_money = $win_money; $model->save(); return ""; }else if($arr[$i][$j]->result == 1){ //赢 $odds = $arr[$i][$j]->odds; $money = $money*$odds; }else if($arr[$i][$j]->result == 2){ //平 $money = $money*1; }else if($arr[$i][$j]->result == 3){ //赢半平半 $odds = $arr[$i][$j]->odds; $money = $money/2*$odds+$money/2*1; }else if($arr[$i][$j]->result == 4){ //输半平半 $money = $money/2*1; } } //减本金 // $win_money = $win_money+$money-$order->money/count($arr); //不减本金 $win_money = $win_money+$money; } $model = new \App\Models\MoneyBuyStr(); $model = $model::find($id); $model->settle_status = 2; $model->gain_money = $win_money; $model->save(); return 1; } /** *串关注单批量结算 */ public function batchsettlement(){ $bet_type = 2; //串关注单 $orders = \App\Models\MoneyBuyStr::where('settle_status','1')->get(); $order_ids = array(); for($i=0;$ibatch_id)->get(); $res = array(); for($j=0;$jresult; } if(!in_array(0,$res)){ $order_ids[] = $orders[$i]->order_id; } } //return $order_id; $SettlementOrder = new SettlementOrder(); $data = $SettlementOrder->reSettlement($order_ids,$bet_type); return $data; } /** *删除串关注单 */ public function deletel(Req $req) { $id = $req->input('id'); if (empty($id)) { return responseToJson(-2001); //id����Ϊ�� } $ids = explode(',', $id); if (!is_array($ids) && intval($ids) < 0) { return responseToJson(-2002); //id���� } if (is_array($ids) && count($ids) > 0) { foreach ($ids as $k => $v) { if (intval($v) < 1) { unset($ids[$k]); } } } $rows = \App\Models\MoneyBuyStr::whereIn('id', $ids)->delete(); if (!$rows) { return responseToJson(-2003); //id���� } return responseToJson(1, trans('menu.delete_success')); //id���� } /** * 投注金额统计 */ function moneycount() { $where = Request::has('where') ? Request::get('where') : ''; $db = new \App\Models\MoneyBuyStr(); $data = $db->MoneyCount($where); return responseToJson($data); } }