match_id; $type = $req->type; $token = session('adminInfo.token'); $notice = \App\Models\Comendnotice::where('match_id', $match_id)->first(); if(!$notice){ return json_encode(['status'=>5,'msg'=>'请先核对结果,并提交结果']); } $noticeid = $notice['id']; //查询赛事单式是否有订单(足球) $newapp = new \App\Models\MoneyBuyMatch(); $simplex_ids = array_column($newapp->allsimplexorder($match_id,'zq'),'order_id'); $str_ids = array_column($newapp->allstrorder($match_id),'order_id'); if(count($simplex_ids)>0 || count($str_ids)>0){ $requet = file_get_contents($jsurl."/WinFail?noticeid=".$noticeid."&token=".$token); if(json_decode($requet,true)['status']==1){ $napp = new \App\Models\Stzqresult(); //单式结算 if(count($simplex_ids)>0 && count($str_ids)==0){ $huawei_res = $napp->simplexs($token,$match_id,$jsurl,'zq'); if($huawei_res['status']==1){ return json_encode(['status'=>1,'msg'=>'单式结算成功,没有串式订单']); }else{ return json_encode(['status'=>3,'msg'=>'单式结算有误,请联系管理员!!!('.$huawei_res['msg'].')']);//结算错误 } }elseif(count($str_ids)>0 && count($simplex_ids)==0){ //串式结算 $tandem_res = $napp->tandems($token,$match_id,$jsurl,'zq'); if($tandem_res['status']==1){ return json_encode(['status'=>1,'msg'=>'串式结算成功,没有单式订单']); }else{ return json_encode(['status'=>3,'msg'=>'串式结算有误,请联系管理员!!!('.$tandem_res['msg'].')']);//结算错误 } }elseif(count($str_ids)>0 && count($simplex_ids)>0){ //既有单式又有串式 $huawei_res = $napp->simplexs($token,$match_id,$jsurl,'zq'); //串式结算 $tandem_res = $napp->tandems($token,$match_id,$jsurl,'zq'); if($tandem_res['status']==1 && $huawei_res['status']==1){ return json_encode(['status'=>1,'msg'=>'结算成功']); }elseif($tandem_res['status']!=1 || $huawei_res['status']!=1){ return json_encode(['status'=>3,'msg'=>'结算有误,请联系管理员!!!('.$tandem_res['msg'].$huawei_res['msg'].')']); }else{ return json_encode(['status'=>3,'msg'=>'返回参数不对']); } } }else{ return json_encode(['status'=>2,'msg'=>'判断输赢错误,请联系管理员!!!']);;//输赢错误 } }else{ $log = array( session('adminInfo.admin_name'), ); OperationLog(session('adminInfo.admin_id'), '足球结算', $log); $res = \App\Models\Stzqresult::where ('match_id', $match_id)->update(['status' =>3]); $res = \App\Models\SportsSoccer::where ('match_id', $match_id)->update(['status' =>3]); return json_encode(['status'=>4,'msg'=>'该赛事没有任何订单,将会结束该赛事!!!']); } } //添加危险球列表 function addwarn(Req $req){ $match_id = $req->match_id; $warn = \App\Models\Stzqresult::where('match_id', $match_id)->select("warn_more")->first(); $warnmore = json_decode($warn['warn_more'],true); $sousuo = $req->sousuo?$req->sousuo:''; if($sousuo){ $shuzu = array(); for ($i=0; $i < count($warnmore); $i++) { if($warnmore[$i]['rtype']==$sousuo){ $shuzu[$i]['timei'] = $warnmore[$i]['timei']; $shuzu[$i]['rtype'] = $warnmore[$i]['rtype']; $shuzu[$i]['timep'] = $warnmore[$i]['timep']; } } $shuzu = array_values($shuzu); $warnmore = $shuzu; $warnmore[0]['timei'] = 10000; } if($warnmore[0]['timei']!="1970-1-1 0:0:1"){ $request['warnmore'] = $warnmore; //$request['warnmore'][0]['rtype'] = $sousuo; }else{ $request['warnmore'] = ''; } $request['match_id'] = $match_id; $request['sousuo'] = $sousuo; return view('admin.sportsfoot/addwarn', $request); } //危险球查询 function warnresult(Req $req){ $match_id = $req->match_id; $wid = $req->wid; $warnonlys = \App\Models\Stzqresult::where('match_id', $match_id)->select("warn_more","start_time")->first(); $warno = array( 'warn_more' => json_decode($warnonlys['warn_more'],true), 'starttime' => $warnonlys['start_time'], ); return $warno; } //添加编辑危险球 function addwarnonly(Req $req){ $matchid = $req->matchid; $wid = $req->wid;//编辑对象值 $timei = $req->timei?$req->timei:"1970-11-1 0:0:1"; $timep = $req->timep?$req->timep:"90"; $rtype = $req->warntype?$req->warntype:0; $typenum = $req->typenum; $model = \App\Models\Stzqresult::where('match_id', $matchid)->select("warn_more","start_time")->first()->toArray(); //该赛事的单式注单 $orders = array(); $otherorders = array(); $account_identitys = array(); $order_ids = array(); $order = \App\Models\SportsNoteList::where('match_id',$matchid)->get(); if(!empty($order)){ for ($c=0; $c < count($order); $c++){ if(strtotime($timei) >= strtotime($order[$c]['money_time']) && strtotime($timei)-$timep <= strtotime($order[$c]['money_time'])){ $orders[] = $order[$c]; $account_identitys[] = $order[$c]['account_identity']; $order_ids[] = $order[$c]['order_id']; }else{ $otherorders[] = $order[$c]['id']; } } } //危险球范围外的注单自动审核通过 if(!empty($otherorders)){ \App\Models\SportsNoteList::wherein('id', $account_identitys)->update(['roll_ratify' => '1']); } //return $account_identitys; $sel = json_decode($model['warn_more'],true); $addru = array( array( 'timei'=>$timei, 'timep'=>$timep, 'rtype'=>$rtype, ), ); $only =$model['start_time']; $t = strtotime($only); $tt = date('Y-m-d H:i:s', $t+1*3*60*60); //timei']!="1970-1-1 0:0:1" if($only<$timei && $timei<$tt){ if($typenum==10000){ if($sel[0]['timei']=="1970-1-1 0:0:1"){ //首次添加 $res = \App\Models\Stzqresult::where ('match_id', $matchid)->update(['warn_more' => json_encode($addru,JSON_UNESCAPED_UNICODE)]); }else{ //再次添加 $upnum = array_merge_recursive($sel,$addru); $res = \App\Models\Stzqresult::where ('match_id', $matchid)->update(['warn_more' => json_encode($upnum,JSON_UNESCAPED_UNICODE)]); } }else{ //编辑 for ($i=0; $i < count($sel); $i++) { $sel[$wid]['timei'] = $timei; $sel[$wid]['timep'] = $timep; $sel[$wid]['rtype'] = $rtype; } $res = \App\Models\Stzqresult::where ('match_id', $matchid)->update(['warn_more' => json_encode($sel,JSON_UNESCAPED_UNICODE)]); } //用戶账户金额 $account_money = \App\Models\Account_detailed::wherein('account_identity',$account_identitys)->get(); //反水 $water_return_money = \App\Models\Money_details::wherein('trade_id',$order_ids)->where('trade_type', '7')->get(); //return $water_return_money; if(!empty($orders)){ for($i=0;$imoney - $orders[$i]->gain_money - $water_return; $models = new \App\Models\Money_details(); $models->info_identity = UUID(); $models->trade_id = $orders[$i]->order_id; $models->account_name = $orders[$i]->account_name; $models->account_identity = $orders[$i]->account_identity; $models->money = abs($orders[$i]->money - $orders[$i]->gain_money - $water_return); $models->money_time = date("Y-m-d H:i:s", time()); if ($new_available_cash > $available_cash) { $models->money_type = '1'; } else { $models->money_type = '2'; } $models->money_cash = $new_available_cash; $models->trade_type = '25'; $models->trade_desc = '单式注单审核不通过回款'; $models->status = '1'; try { DB::beginTransaction();//开启事务 \App\Models\SportsNoteList::where('id', $orders[$i]['id'])->update(['roll_ratify' => '-1','status' => '2']); \App\Models\Account_detailed::where('account_identity', $orders[$i]->account_identity)->update(['available_cash' => $new_available_cash, 'cash' => $new_available_cash]); $models->save(); DB::commit();//提交 } catch (Exception $e) { DB::rollback();//回滚 } } } }else{ return json_encode(['status'=>2,'msg'=>'请设置正确时间']); } return responseToJson(1); } //足球结果列表 function outcome(Req $req) { $request=array(); $request['home_team'] = isset($req->home_team) ? trim($req->home_team) : null; $request['status'] = isset($req->status) ? trim($req->status) : '-1'; $request['sureblurs'] = isset($req->sureblurs) ? $req->sureblurs : 'on'; $request['star_time'] = isset($req->star_time) ? trim($req->star_time) :trans('status.default_time.seven_day') ; $request['end_time'] = isset($req->end_time) ? trim($req->end_time) : trans('status.default_time.etime'); $newapp = new \App\Models\SoccerLeague(); $data = $newapp->allleague(); $request['league'] = $data;//联赛id $request['token'] = session('adminInfo.token');//token 变量 $dt = \App\Lib\DataTable\DataTable::init(); $dt->setDataSource('/admin/sportsfoot/outcomeinfo'); $dt->setLang('sportsfoot'); $dt->addColsFields('newtime', array('templet' => '#newtime', 'sort' => false, 'width' => 200)); $dt->addColsFields('totime', array('templet' => '#totime', 'sort' => false, 'width' => 80)); $dt->addColsFields('home_team', array('templet' => '#userdetail', 'sort' => false, 'width' => 80)); $dt->addColsFields('guest_team', array('templet' => '#userdetail', 'sort' => false, 'width' => 70)); $dt->addColsFields('dsnum', array('templet' => '#dsnum', 'sort' => false, 'width' => 70)); $dt->addColsFields('csnum', array('templet' => '#csnum', 'sort' => false, 'width' => 110)); $dt->addColsFields('sxalfcourt', array('templet' => '#sxalfcourt', 'sort' => false, 'width' => 300)); $dt->addColsFields('statusmatch', array('templet' => '#statusmatch', 'sort' => false, 'width' => 150,'align' => 'left')); $dt->addColsFields('operation', array('templet' => '#status', 'sort' => false, 'width' => 300)); // $arr[] = 'view'; // if (checkRriv('/admin/sportsfoot/edit')) { // $arr[] = 'edit'; // } // $dt->setToolBar($arr, array('width' => 200)); $dt->enableCheckBox(); return view('admin.sportsfoot/outcome', $dt->render($request)); } //结果添加 function addend(Req $req){ $match_id = $req->matchid; $model = \App\Models\Stzqresult::where('match_id', $match_id)->first(); $penaltycard = array( 'home'=>intval($req->homeallcard)?intval($req->homeallcard):0, 'guest'=>intval($req->guestallcard)?intval($req->guestallcard):0, 'home_half'=>intval($req->homehalfcard)?intval($req->homehalfcard):0, 'guest_half'=>intval($req->guesthalfcard)?intval($req->guesthalfcard):0, ); $cornerball = array( 'home'=>intval($req->homeallcorner)?intval($req->homeallcorner):0, 'guest'=>intval($req->guestallcorner)?intval($req->guestallcorner):0, 'home_half'=>intval($req->homehalfcorner)?intval($req->homehalfcorner):0, 'guest_half'=>intval($req->guesthalfcorner)?intval($req->guesthalfcorner):0, ); $firstone = array( 'teamscore'=>$req->firstscore ? $req->firstscore:0, 'scoretime'=>intval($req->onescoretime)?intval($req->onescoretime):0, 'scoretype'=>$req->firststye ? $req->firststye:0, ); $model->last_score = $req->lastscore?$req->lastscore:''; $model->match_winer = $req->matchwiner?$req->matchwiner:''; $model->penalty_card = json_encode($penaltycard,JSON_UNESCAPED_UNICODE); $model->corner_ball = json_encode($cornerball,JSON_UNESCAPED_UNICODE); $model->first_score = json_encode($firstone,JSON_UNESCAPED_UNICODE); $model->save(); return responseToJson(1); } //查询赛事结果 function Matchresult(Req $req){ $match_id = $req->match_id; $newapp = \App\Models\Stzqresult::where('match_id', $match_id)->first(); $array =array( 'corner_ball' => json_decode($newapp['corner_ball'],true), 'penalty_card' => json_decode($newapp['penalty_card'],true), 'first_score' => json_decode($newapp['first_score'],true), 'newapp' => $newapp, ); return $array; } function onlyresult(Req $req){ $match_id = $req->matchid; $newapp = \App\Models\Stzqresult::where('match_id', $match_id)->first(); return $newapp; } //作废 function revokeft(Req $req){ $iszf = $req->iszf?$req->iszf:'';//赛事id if(intval($iszf)){ $id = $req->input('id'); if (empty($id)) { return responseToJson(-2001); // } $ids = explode(',', $id); if (!is_array($ids) && intval($ids) < 0) { return responseToJson(-2002); // } if (is_array($ids) && count($ids) > 0) { foreach ($ids as $k => $v) { if (intval($v) < 1) { unset($ids[$k]); } } } for ($ii=0; $ii < count($ids); $ii++) { $model = \App\Models\Stzqresult::where('match_id', $ids[$ii])->first(); $model->status = 4; $model->save(); $ssid = $model['match_id'];//赛事id $smodel = \App\Models\SportsSoccer::where('id', $ssid)->first(); if($smodel){ $smodel->status = 4; $smodel->save(); } //赛事下单式注单作废,串关注单下此赛事按平局处理 $upapp = new \App\Models\SportsNoteList(); $upapp->delorder($ssid,'zq'); // $upapp = new \App\Models\SportsNoteList(); // $data = $upapp->updatesimplex($ssid,'zq');//修改单式状态 //单式撤单返现 // $newapp = new \App\Models\MoneyBuyMatch(); // $all = $newapp->allsimplexorder($ssid,'zq'); // for ($i=0; $i < count($all); $i++) { // $appgx = new \App\Lib\Settlement\SettlementOrder(); // $appgx->insertData($all[$i]['order_id'], $all[$i]['money'], $all[$i]['account_identity'], '1', 'zq', $all[$i]['info_identity'], $all[$i]['money'],$all[$i]['match_id']); // } // // //串式撤单只改状态 // $str_ids = array_column($newapp->allstrorder($ssid),'order_id'); // $csapp = new \App\Models\MoneyBuyStr(); // $csapp->updatestatus($str_ids);//var_dump($ss);die; // //修改money_buy_match 投注结果result=2为平 // $newapp->updatast($ssid); } return responseToJson(1); }else{ $match_id = $req->match_id;//赛事id $model = \App\Models\Stzqresult::where('match_id', $match_id)->first(); $model->status = 4; $model->save(); $smodel = \App\Models\SportsSoccer::where('id', $match_id)->first(); if($smodel){ $smodel->status = 4; $smodel->save(); } //赛事下单式注单作废,串关注单下此赛事按平局处理 $upapp = new \App\Models\SportsNoteList(); $upapp->delorder($match_id,'zq'); // $upapp = new \App\Models\SportsNoteList(); // $data = $upapp->updatesimplex($match_id,'zq');//修改单式状态 // //单式撤单返现 // $newapp = new \App\Models\MoneyBuyMatch(); // $all = $newapp->allsimplexorder($match_id,'zq'); // for ($i=0; $i < count($all); $i++) { // $appgx = new \App\Lib\Settlement\SettlementOrder(); // $appgx->insertData($all[$i]['order_id'], $all[$i]['money'], $all[$i]['account_identity'], '1', 'zq', $all[$i]['info_identity'], $all[$i]['money'],$all[$i]['match_id']); // } // //串式撤单只改状态 // $str_ids = array_column($newapp->allstrorder($match_id),'order_id'); // $csapp = new \App\Models\MoneyBuyStr(); // $csapp->updatestatus($str_ids);//var_dump($ss);die; // //修改money_buy_match 投注结果result=2为平 // $newapp->updatast($match_id); return responseToJson(1); } } //赛事结果修改 function edit(Req $req) { $id = $req->id; if (intval($id) < 1) { return -1; } if (!$req->isMethod('post')) { $data = \App\Models\Stzqresult::where('id', $id)->first(); if (!$data) { return -2; } $data = $data->toArray(); return view('admin.sportsfoot/edit', $data); } else { $model = \App\Models\Stzqresult::where('id', $id)->first(); $model->home_team = $req->input('home_team'); $model->guest_team = $req->input('guest_team'); $model->home_rate = $req->input('home_rate'); $model->guest_rate = $req->input('guest_rate'); $model->status = $req->input('status'); //$model->update_time = time(); $model->save(); return responseToJson(1); } } function outcomeinfo() { $page = Request::has('page') ? Request::get('page') : ''; $list = Request::has('limit') ? Request::get('limit') : 10; $home_team = Request::has('home_team') ? Request::get('home_team') : ''; $sureblur = Request::has('sureblurs') ? Request::get('sureblurs') : 'off'; $status = Request::has('status') ? Request::get('status') : ''; $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' : ''; $where = array(); $orwhere = array(); if (!empty($home_team)) { if (empty($sureblur) || $sureblur == 'off') { $where[] = array('st_zq_result.home_team', 'like', '%' . $home_team . '%'); $orwhere[] = array('st_zq_result.guest_team', 'like', '%' . $home_team . '%'); } else { if(is_numeric($home_team)){ $where[] = array('st_zq_result.match_id', '=', $home_team); }else{ $where[] = array('st_zq_result.home_team', '=', $home_team); $orwhere[] = array('st_zq_result.guest_team', '=', $home_team); } } } if ($status != -1) { $where[] = array('st_zq_result.status', '=', $status); $orwhere[] = array('st_zq_result.status', '=', $status); } if(!is_numeric($home_team)){ if (!empty($star_time)) { $star_time = date('Y-m-d H:i:s', strtotime($star_time)); $where[] = array('st_zq_result.start_time', '>', $star_time); $orwhere[] = array('st_zq_result.start_time', '>', $star_time); } if (!empty($end_time)) { $end_time = date('Y-m-d H:i:s', strtotime($end_time)); $where[] = array('st_zq_result.start_time', '<', $end_time); $orwhere[] = array('st_zq_result.start_time', '<', $end_time); } } $newapp = new \App\Models\Stzqresult(); $data = $newapp->resultlist($list, $page, $where, $orwhere); return \App\Lib\DataTable\DataTable::init()->toJson($data['data'], $data['total']); } function saislist(Req $req){ $lgid = $req->lgid;//赛事id $newstzqcompetition = new \App\Models\Stzqcompetition(); $league_data = $newstzqcompetition->allcompetition($lgid);//赛事id return $league_data; } //赛事结果添加 guest_score 客队进球 all_goal总进球数 function addoutcome(Req $req) { if (!$req->isMethod('post')) { $lange = trans('menu'); $newapp = new \App\Models\SoccerLeague(); $league_data = $newapp->allleague();//联赛id return view('admin.sportsfoot/addoutcome',['data'=>$league_data]); } else { $match_id = trim($req->input('match_id'));//赛事id //添加足球比赛结果表 $alldata = $req->input(); unset($alldata['_token']); $all_goal = intval($alldata['home_score'])+intval($alldata['guest_score']);//总进球数 $penaltycard = array( 'home'=>intval($alldata['homeallcard'])?intval($alldata['homeallcard']):0, 'guest'=>intval($alldata['guestallcard'])?intval($alldata['guestallcard']):0, 'home_half'=>intval($alldata['homehalfcard'])?intval($alldata['homehalfcard']):0, 'guest_half'=>intval($alldata['guesthalfcard'])?intval($alldata['guesthalfcard']):0, ); $cornerball = array( 'home'=>intval($alldata['homeallcorner'])?intval($alldata['homeallcorner']):0, 'guest'=>intval($alldata['guestallcorner'])?intval($alldata['guestallcorner']):0, 'home_half'=>intval($alldata['homehalfcorner'])?intval($alldata['homehalfcorner']):0, 'guest_half'=>intval($alldata['guesthalfcorner'])?intval($alldata['guesthalfcorner']):0, ); $ret = \App\Models\Stzqresult::updateOrCreate(['match_id'=>$match_id],array_merge($alldata,['match_time'=>'00:01','update_time'=>date('Y-m-d H:i:s'),'all_goal'=>$all_goal,'penalty_card'=>json_encode($penaltycard),'corner_ball'=>json_encode($cornerball)])); //添加足球比赛结果记录表 \App\Models\Stzqresultrecord::updateOrCreate(['match_id'=>$match_id,'update_time'=>date('Y-m-d H:i:s')],array_merge($alldata,['match_time'=>'00:01','update_time'=>date('Y-m-d H:i:s')])); } return responseToJson(1); } //删除赛事结果 function deleteoutcome(Req $req) { $id = $req->input('id'); if (empty($id)) { return responseToJson(-2001); // } $ids = explode(',', $id); if (!is_array($ids) && intval($ids) < 0) { return responseToJson(-2002); // } if (is_array($ids) && count($ids) > 0) { foreach ($ids as $k => $v) { if (intval($v) < 1) { unset($ids[$k]); } } } $rows = \App\Models\Stzqresult::whereIn('id', $ids)->delete(); if (!$rows) { return responseToJson(-2003); } return responseToJson(1); } //更新赛事比分 function updatenum(Req $req){ $match_id = $req->match_id; $newapp = new \App\Models\Stzqresult(); $data['u_home_score'] = intval($req->u_home_score)?intval($req->u_home_score):0; $data['u_guest_score'] = intval($req->u_guest_score)?intval($req->u_guest_score):0; $data['home_score'] = intval($req->home_score)?intval($req->home_score):0; $data['guest_score'] = intval($req->guest_score)?intval($req->guest_score):0; $data['is_correct'] = 1;//追加手动更改标识 $newapp->updateInfo($data,$match_id);//联赛id $newapp->totalgoal($match_id); $update = $this->addcomendnotice($match_id); $twoapp = new \App\Models\SportsSoccer(); $twoapp->updatestatus('match_id',$match_id,['status'=>2]);//修改赛事状态 $newapp->updatestatus('match_id',$match_id,['status'=>2]);//修改结果状态 return responseToJson(1); } //添加赛事结束纪录 function addcomendnotice($match_id){ $data = \App\Models\Comendnotice::where(['match_id'=>$match_id,'game_code'=>'zq'])->first(); if(!$data){ $model = new \App\Models\Comendnotice(); $model->status = 0;//联赛id $model->game_code = 'zq'; $model->match_id = $match_id;//赛事id $model->ctime = date('Y-m-d H:i:s'); $model->save(); } return responseToJson(1); } }