SportsfootController.php 44 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244
  1. <?php
  2. namespace App\Http\Controllers\Admin;
  3. use App\Http\Controllers\Controller;
  4. use Illuminate\Http\Request as Req;
  5. use Illuminate\Support\Facades\DB;
  6. Use App\Lib\Settlement\SettlementOrder;
  7. use App\Models;
  8. use Request;
  9. use App\Lib\Biz\Sport\Common as commonFunction;
  10. use App\Lib\Settlement\SwInterface;
  11. /**
  12. *足球结算
  13. */
  14. class SportsfootController extends Controller {
  15. function Settlement1(Req $req){
  16. $match_id = $req->match_id;
  17. $match = \App\Models\SportsSoccer::where ('id', $match_id)->first();
  18. $type = $req->type;
  19. $process = $req->process;
  20. if(empty($process)){
  21. $process = array();
  22. }
  23. //赛事比分数据
  24. $res = \App\Models\Stzqresult::where('match_id', $match_id)->first();
  25. $scores = json_decode($res['manual_result'],true);
  26. //结算验证
  27. if(in_array('half_corner',$process)){
  28. if(strlen($scores['half_corner']['home'])==0 || strlen($scores['half_corner']['guest'])==0){
  29. return json_encode(['status'=>6,'msg'=>'没有上半场角球结果,无法结算上半场角球']);
  30. }
  31. }
  32. if(in_array('all_corner',$process)){
  33. if(strlen($scores['all_corner']['home'])==0 || strlen($scores['all_corner']['guest'])==0){
  34. return json_encode(['status'=>7,'msg'=>'没有全场角球结果,无法结算全场角球']);
  35. }
  36. }
  37. if(in_array('half',$process)){
  38. if(strlen($scores['half']['home'])==0 || strlen($scores['half']['guest'])==0){
  39. return json_encode(['status'=>8,'msg'=>'没有上半场结果,无法结算上半场']);
  40. }
  41. }
  42. if(in_array('all',$process)){
  43. if(strlen($scores['all']['home'])==0 || strlen($scores['all']['guest'])==0){
  44. return json_encode(['status'=>9,'msg'=>'没有全场结果,无法结算全场']);
  45. }
  46. }
  47. $token = session('adminInfo.token');
  48. $notice = \App\Models\Comendnotice::where('match_id', $match_id)->first();
  49. if(!$notice){
  50. return json_encode(['status'=>5,'msg'=>'请先核对结果,并提交结果']);
  51. }
  52. $noticeid = $notice['id'];
  53. //查询赛事单式是否有订单(足球)
  54. $newapp = new \App\Models\MoneyBuyMatch();
  55. $simplex = $newapp->simsettleorder($match_id,$type);
  56. $str = $newapp->strsettleorder($match_id);
  57. //获取赛事结算进程下的注单
  58. $simplex = commonFunction::getOrderData($data = [],$simplex,$type,$process);
  59. $str = commonFunction::getOrderData($data = [],$str,$type,$process);
  60. //获取注单id组成一维数组
  61. $simplex_ids = array_column($simplex['settle'],'order_id');
  62. $str_ids = array_column($str['settle'],'order_id');
  63. //去重
  64. $simplex_ids = array_unique($simplex_ids);
  65. $str_ids = array_unique($str_ids);
  66. //print_r($simplex_ids);exit;
  67. //判断赛事下注单输赢
  68. //单式
  69. if(count($simplex_ids)>0){
  70. $simids = implode(',',$simplex_ids);
  71. $winfail = SwInterface::getInstance()->WinfailMulNomal($simids,'1');
  72. if($winfail['status'] != 1){
  73. return json_encode(['status'=>2,'msg'=>'单式判断输赢错误,请联系管理员!!!']);//输赢错误
  74. }
  75. }
  76. //串式
  77. if(count($str_ids)>0){
  78. $strids = implode(',',$str_ids);
  79. $winfail = SwInterface::getInstance()->WinfailMulNomal($strids,2);
  80. if($winfail['status'] != 1){
  81. return json_encode(['status'=>2,'msg'=>'串式判断输赢错误,请联系管理员!!!']);//输赢错误
  82. }
  83. }
  84. //结算
  85. $change_status = 1;
  86. if($match['status'] == 0 || $match['status'] == 1){
  87. $change_status = 0;
  88. }
  89. $sim = array(
  90. 'token'=>$token,
  91. 'order_ids'=>'', //订单id字符串,用半角都好分隔
  92. 'bettype'=>1, //结算类型 1单式 2串式
  93. 'settype'=>2, //结算次数 1首次 2非首次
  94. 'game_code'=>$type, //赛事类型 zq lq wq bq
  95. 'match_id'=>$match_id, // 赛事ID
  96. 'change_status'=>$change_status //是否改状态
  97. );
  98. $str = array(
  99. 'token'=>$token,
  100. 'order_ids'=>'', //订单id字符串,用半角都好分隔
  101. 'bettype'=>2, //结算类型 1单式 2串式
  102. 'settype'=>2, //结算次数 1首次 2非首次
  103. 'game_code'=>$type, //赛事类型 zq lq wq bq
  104. 'match_id'=>$match_id, // 赛事ID
  105. 'change_status'=>$change_status //是否改状态
  106. );
  107. $settlementAuto = new \App\Lib\Settlement\SettlementAuto();
  108. if(count($simplex_ids)>0 || count($str_ids)>0){
  109. //单式结算
  110. if(count($simplex_ids)>0 && count($str_ids)==0){
  111. $sim['order_ids'] = implode(',',$simplex_ids);
  112. $settlesim = $settlementAuto->SubmitSettelement('s',$sim);
  113. if($settlesim == false){
  114. return json_encode(['status'=>3,'msg'=>'单式注单结算有误,请联系管理员!!!']);
  115. }else{
  116. return json_encode(['status'=>1,'msg'=>'单式结算成功,没有串式订单']);
  117. }
  118. }
  119. //串式结算
  120. elseif(count($str_ids)>0 && count($simplex_ids)==0){
  121. $str['order_ids'] = implode(',',$str_ids);
  122. $settlestr = $settlementAuto->SubmitSettelement('s',$str);
  123. if($settlestr == false){
  124. return json_encode(['status'=>3,'msg'=>'串式注单结算有误,请联系管理员!!!']);
  125. }else{
  126. return json_encode(['status'=>1,'msg'=>'串式结算成功,没有单式订单']);
  127. }
  128. }
  129. //既有单式也有串式
  130. elseif(count($str_ids)>0 && count($simplex_ids)>0){
  131. $sim['order_ids'] = implode(',',$simplex_ids);
  132. $str['order_ids'] = implode(',',$str_ids);
  133. $settlesim = $settlementAuto->SubmitSettelement('s',$sim);
  134. $settlestr = $settlementAuto->SubmitSettelement('s',$str);
  135. if($settlesim == true || $settlestr == true){
  136. return json_encode(['status'=>1,'msg'=>'结算成功']);
  137. }else{
  138. return json_encode(['status'=>3,'msg'=>'结算有误,请联系管理员!!!']);
  139. }
  140. }
  141. }else{
  142. $log = array(
  143. session('adminInfo.admin_name'),
  144. );
  145. OperationLog(session('adminInfo.admin_id'), '足球结算', $log);
  146. if($match['status'] == 0 || $match['status'] == 1){
  147. return json_encode(['status'=>4,'msg'=>'该赛事进程下没有任何订单']);
  148. }
  149. $res = \App\Models\Stzqresult::where ('match_id', $match_id)->update(['status' =>3]);
  150. $res = \App\Models\SportsSoccer::where ('id', $match_id)->update(['status' =>3]);
  151. return json_encode(['status'=>4,'msg'=>'该赛事没有任何订单,将会结束该赛事!!!']);
  152. }
  153. }
  154. function Settlement(Req $req){
  155. $jsurl = config('sconstant.url');//结算请求域名地址
  156. $match_id = $req->match_id;
  157. $type = $req->type;
  158. $token = session('adminInfo.token');
  159. $notice = \App\Models\Comendnotice::where('match_id', $match_id)->first();
  160. if(!$notice){
  161. return json_encode(['status'=>5,'msg'=>'请先核对结果,并提交结果']);
  162. }
  163. $noticeid = $notice['id'];
  164. //查询赛事单式是否有订单(足球)
  165. $newapp = new \App\Models\MoneyBuyMatch();
  166. $simplex_ids = array_column($newapp->simsettleorder($match_id,'zq'),'order_id');
  167. $str_ids = array_column($newapp->strsettleorder($match_id),'order_id');
  168. //去重
  169. $simplex_ids = array_unique($simplex_ids);
  170. $str_ids = array_unique($str_ids);
  171. //判断赛事下注单输赢
  172. $datas = array('noticeid' => $noticeid , 'token' => $token);
  173. $settlementAuto = new \App\Lib\Settlement\SettlementAuto();
  174. $winfail = $settlementAuto->SubmitSettelement('w',$datas);
  175. if($winfail == false){
  176. return json_encode(['status'=>2,'msg'=>'判断输赢错误,请联系管理员!!!']);//输赢错误
  177. }
  178. $sim = array(
  179. 'token'=>$token,
  180. 'order_ids'=>'', //订单id字符串,用半角都好分隔
  181. 'bettype'=>1, //结算类型 1单式 2串式
  182. 'settype'=>2, //结算次数 1首次 2非首次
  183. 'game_code'=>$type, //赛事类型 zq lq wq bq
  184. 'match_id'=>$match_id, // 赛事ID
  185. 'change_status'=>1 //是否改状态
  186. );
  187. $str = array(
  188. 'token'=>$token,
  189. 'order_ids'=>'', //订单id字符串,用半角都好分隔
  190. 'bettype'=>2, //结算类型 1单式 2串式
  191. 'settype'=>2, //结算次数 1首次 2非首次
  192. 'game_code'=>$type, //赛事类型 zq lq wq bq
  193. 'match_id'=>$match_id, // 赛事ID
  194. 'change_status'=>1 //是否改状态
  195. );
  196. if(count($simplex_ids)>0 || count($str_ids)>0){
  197. //单式结算
  198. if(count($simplex_ids)>0 && count($str_ids)==0){
  199. $sim['order_ids'] = implode(',',$simplex_ids);
  200. $settlesim = $settlementAuto->SubmitSettelement('s',$sim);
  201. if($settlesim == false){
  202. return json_encode(['status'=>3,'msg'=>'单式注单结算有误,请联系管理员!!!']);
  203. }else{
  204. return json_encode(['status'=>1,'msg'=>'单式结算成功,没有串式订单']);
  205. }
  206. }
  207. //串式结算
  208. elseif(count($str_ids)>0 && count($simplex_ids)==0){
  209. $str['order_ids'] = implode(',',$str_ids);
  210. $settlestr = $settlementAuto->SubmitSettelement('s',$str);
  211. if($settlestr == false){
  212. return json_encode(['status'=>3,'msg'=>'串式注单结算有误,请联系管理员!!!']);
  213. }else{
  214. return json_encode(['status'=>1,'msg'=>'串式结算成功,没有单式订单']);
  215. }
  216. }
  217. //既有单式也有串式
  218. elseif(count($str_ids)>0 && count($simplex_ids)>0){
  219. $sim['order_ids'] = implode(',',$simplex_ids);
  220. $str['order_ids'] = implode(',',$str_ids);
  221. $settlesim = $settlementAuto->SubmitSettelement('s',$sim);
  222. $settlestr = $settlementAuto->SubmitSettelement('s',$str);
  223. if($settlesim == true || $settlestr == true){
  224. return json_encode(['status'=>1,'msg'=>'结算成功']);
  225. }else{
  226. return json_encode(['status'=>3,'msg'=>'结算有误,请联系管理员!!!']);
  227. }
  228. }
  229. }else{
  230. $log = array(
  231. session('adminInfo.admin_name'),
  232. );
  233. OperationLog(session('adminInfo.admin_id'), '足球结算', $log);
  234. $res = \App\Models\Stzqresult::where ('match_id', $match_id)->update(['status' =>3]);
  235. $res = \App\Models\SportsSoccer::where ('id', $match_id)->update(['status' =>3]);
  236. return json_encode(['status'=>4,'msg'=>'该赛事没有任何订单,将会结束该赛事!!!']);
  237. }
  238. }
  239. //添加危险球列表
  240. function addwarn(Req $req){
  241. $match_id = $req->match_id;
  242. $warn = \App\Models\Stzqresult::where('match_id', $match_id)->select("warn_more")->first();
  243. $warnmore = json_decode($warn['warn_more'],true);
  244. $sousuo = $req->sousuo?$req->sousuo:'';
  245. if($sousuo){
  246. $shuzu = array();
  247. for ($i=0; $i < count($warnmore); $i++) {
  248. if($warnmore[$i]['rtype']==$sousuo){
  249. $shuzu[$i]['timei'] = $warnmore[$i]['timei'];
  250. $shuzu[$i]['rtype'] = $warnmore[$i]['rtype'];
  251. $shuzu[$i]['timep'] = $warnmore[$i]['timep'];
  252. }
  253. }
  254. $shuzu = array_values($shuzu);
  255. $warnmore = $shuzu;
  256. // $warnmore[0]['timei'] = 10000;
  257. }
  258. if($warnmore[0]['timei']!="1970-1-1 0:0:1"){
  259. $request['warnmore'] = $warnmore;
  260. // $request['warnmore'][0]['rtype'] = $sousuo;1
  261. }else{
  262. $request['warnmore'] = '';
  263. }
  264. $request['match_id'] = $match_id;
  265. $request['sousuo'] = $sousuo;
  266. return view('admin.sportsfoot/addwarn', $request);
  267. }
  268. //获取指定赛事危险球数据
  269. function getWarnData(Req $req){
  270. $match_id = $req->match_id;
  271. $warnonlys = \App\Models\Stzqresult::where('match_id', $match_id)->select("warn_more","start_time")->first();
  272. $warn_more = json_decode($warnonlys['warn_more'],true);
  273. if(!empty($warn_more)){
  274. $data = [];
  275. foreach($warn_more as $k=>$v){
  276. $v['id'] =$k+1;
  277. $data[$k] = $v;
  278. }
  279. }
  280. if($data[0]['timei']=="1970-1-1 0:0:1"){
  281. $data = [];
  282. }
  283. return \App\Lib\DataTable\DataTable::init()->toJson($data);
  284. }
  285. //危险球查询
  286. function warnresult(Req $req){
  287. $match_id = $req->match_id;
  288. $wid = $req->wid;
  289. $typenum = $req->typenum;
  290. $warnonlys = \App\Models\Stzqresult::where('match_id', $match_id)->select("warn_more","start_time")->first();
  291. $warn_data = json_decode($warnonlys['warn_more'],true);
  292. if($typenum == 10000){ //添加危险球时,默认出现时间为赛事开始时间
  293. $warn_data[0] =[
  294. 'timei' =>$warnonlys['start_time'],
  295. 'rtype' =>0,
  296. 'timep' =>90
  297. ];
  298. }
  299. $warno = array(
  300. 'warn_more' => $warn_data,
  301. 'starttime' => $warnonlys['start_time'],
  302. 'endtime'=> date("Y-m-d H:i:s", strtotime("+2 hour",strtotime($warnonlys['start_time']))),//$warnonlys['start_time']
  303. );
  304. return $warno;
  305. }
  306. //添加编辑危险球
  307. function addwarnonly(Req $req){
  308. //编辑对象值
  309. $wid = ($req->wid);
  310. //赛事id
  311. $matchid = $req->match_id;
  312. /*
  313. //出现危险球的分钟数
  314. $time_i = $req->time_i;
  315. //出现危险球的秒数
  316. $time_s = $req->time_s;
  317. //危险球审核有效时间 秒
  318. */
  319. $timei = $req->time_i;
  320. $timep = $req->time_p;
  321. //危险球类型
  322. $rtype = $req->warn_type;
  323. //验证是否是首次添加危险球
  324. $typenum = $req->type_num;
  325. if(empty($matchid) || empty($timep) || empty($rtype)) return json_encode(['status'=>2,'msg'=>'设置数据异常']);
  326. $model = \App\Models\Stzqresult::where('match_id', $matchid)->select("warn_more","start_time","status")->first()->toArray();
  327. // if($model['status'] != 2) return json_encode(['status'=>3,'msg'=>'赛事未结束,不能设置危险球']);
  328. /*
  329. //赛事开赛时间
  330. $match_time = $model['start_time'];
  331. //危险球出现进行时间 秒
  332. $warn_time_s = ($time_i*60)+$time_s;
  333. //危险球出现时间 == 开赛时间+进行时间 秒
  334. $timei = date('Y-m-d H:i:s',strtotime($match_time)+$warn_time_s);
  335. */
  336. //该赛事的单式注单
  337. $orders = array();
  338. $otherorders = array();
  339. $account_identitys = array();
  340. $order_ids = array();
  341. $order = \App\Models\SportsNoteList::where('match_id',$matchid)->get();
  342. if(!empty($order)){
  343. for ($c=0; $c < count($order); $c++){
  344. if(strtotime($timei) >= strtotime($order[$c]['money_time']) && strtotime($timei)-$timep <= strtotime($order[$c]['money_time'])){
  345. $orders[] = $order[$c];
  346. $account_identitys[] = $order[$c]['account_identity'];
  347. $order_ids[] = $order[$c]['order_id'];
  348. }else{
  349. $otherorders[] = $order[$c]['id'];
  350. }
  351. }
  352. }
  353. //危险球范围外的注单自动审核通过
  354. //return $otherorders;
  355. if(!empty($otherorders)){
  356. \App\Models\SportsNoteList::wherein('id', $otherorders)->update(['roll_ratify' => '1']);
  357. }
  358. //return $account_identitys;
  359. $sel = json_decode($model['warn_more'],true);
  360. $addru = array(
  361. array(
  362. 'timei'=>$timei,
  363. 'timep'=>$timep,
  364. 'rtype'=>$rtype,
  365. ),
  366. );
  367. if($typenum==10000){
  368. if($sel[0]['timei']=="1970-1-1 0:0:1"){
  369. //首次添加
  370. $res = \App\Models\Stzqresult::where ('match_id', $matchid)->update(['warn_more' => json_encode($addru,JSON_UNESCAPED_UNICODE)]);
  371. }else{
  372. //再次添加
  373. $upnum = array_merge_recursive($sel,$addru);
  374. $res = \App\Models\Stzqresult::where ('match_id', $matchid)->update(['warn_more' => json_encode($upnum,JSON_UNESCAPED_UNICODE)]);
  375. }
  376. }else{
  377. //编辑
  378. for ($i=0; $i < count($sel); $i++) {
  379. $sel[$wid]['timei'] = $timei;
  380. $sel[$wid]['timep'] = $timep;
  381. $sel[$wid]['rtype'] = $rtype;
  382. }
  383. $res = \App\Models\Stzqresult::where ('match_id', $matchid)->update(['warn_more' => json_encode($sel,JSON_UNESCAPED_UNICODE)]);
  384. }
  385. //用戶账户金额
  386. $account_money = \App\Models\Account_detailed::wherein('account_identity',$account_identitys)->get();
  387. //反水
  388. $water_return_money = \App\Models\Money_details::wherein('trade_id',$order_ids)->where('trade_type', '7')->get();
  389. if(!empty($orders)){
  390. for($i=0;$i<count($orders);$i++){
  391. for($a=0;$a<count($account_money);$a++){
  392. if($orders[$i]['account_identity'] == $account_money[$a]['account_identity']){
  393. $available_cash = $account_money[$a]['available_cash'];
  394. }
  395. }
  396. for($b=0;$b<count($water_return_money);$b++){
  397. if($orders[$i]['order_id'] == $water_return_money[$b]['trade_id']){
  398. $water_return = $water_return_money[$b]['money'];
  399. } else {
  400. $water_return = 0;
  401. }
  402. }
  403. $new_available_cash = $available_cash + $orders[$i]->money - $orders[$i]->gain_money - $water_return;
  404. $models = new \App\Models\Money_details();
  405. $models->info_identity = UUID();
  406. $models->trade_id = $orders[$i]->order_id;
  407. $models->account_name = $orders[$i]->account_name;
  408. $models->account_identity = $orders[$i]->account_identity;
  409. $models->money = abs($orders[$i]->money - $orders[$i]->gain_money - $water_return);
  410. $models->money_time = date("Y-m-d H:i:s", time());
  411. if ($new_available_cash > $available_cash) {
  412. $models->money_type = '1';
  413. } else {
  414. $models->money_type = '2';
  415. }
  416. $models->money_cash = $new_available_cash;
  417. $models->trade_type = '25';
  418. $models->trade_desc = '单式注单审核不通过回款';
  419. $models->status = '1';
  420. try {
  421. DB::beginTransaction();//开启事务
  422. \App\Models\SportsNoteList::where('id', $orders[$i]['id'])->update(['roll_ratify' => '-1','status' => '2']);
  423. \App\Models\Account_detailed::where('account_identity', $orders[$i]->account_identity)->update(['available_cash' => $new_available_cash, 'cash' => $new_available_cash]);
  424. $models->save();
  425. DB::commit();//提交
  426. } catch (Exception $e) {
  427. DB::rollback();//回滚
  428. }
  429. }
  430. }
  431. return responseToJson(1);
  432. }
  433. //弃用
  434. function addwarnonly__(Req $req){
  435. $matchid = $req->matchid;
  436. $wid = $req->wid;//编辑对象值
  437. $timei = $req->timei?$req->timei:"1970-11-1 0:0:1";
  438. $timep = $req->timep?$req->timep:"90";
  439. $rtype = $req->warntype?$req->warntype:0;
  440. $typenum = $req->typenum;
  441. $model = \App\Models\Stzqresult::where('match_id', $matchid)->select("warn_more","start_time")->first()->toArray();
  442. //该赛事的单式注单
  443. $orders = array();
  444. $otherorders = array();
  445. $account_identitys = array();
  446. $order_ids = array();
  447. $order = \App\Models\SportsNoteList::where('match_id',$matchid)->get();
  448. if(!empty($order)){
  449. for ($c=0; $c < count($order); $c++){
  450. if(strtotime($timei) >= strtotime($order[$c]['money_time']) && strtotime($timei)-$timep <= strtotime($order[$c]['money_time'])){
  451. $orders[] = $order[$c];
  452. $account_identitys[] = $order[$c]['account_identity'];
  453. $order_ids[] = $order[$c]['order_id'];
  454. }else{
  455. $otherorders[] = $order[$c]['id'];
  456. }
  457. }
  458. }
  459. //危险球范围外的注单自动审核通过
  460. //return $otherorders;
  461. if(!empty($otherorders)){
  462. \App\Models\SportsNoteList::wherein('id', $otherorders)->update(['roll_ratify' => '1']);
  463. }
  464. //return $account_identitys;
  465. $sel = json_decode($model['warn_more'],true);
  466. $addru = array(
  467. array(
  468. 'timei'=>$timei,
  469. 'timep'=>$timep,
  470. 'rtype'=>$rtype,
  471. ),
  472. );
  473. $only =$model['start_time'];
  474. $t = strtotime($only);
  475. $tt = date('Y-m-d H:i:s', $t+1*3*60*60);
  476. //timei']!="1970-1-1 0:0:1"
  477. if($only<$timei && $timei<$tt){
  478. if($typenum==10000){
  479. if($sel[0]['timei']=="1970-1-1 0:0:1"){
  480. //首次添加
  481. $res = \App\Models\Stzqresult::where ('match_id', $matchid)->update(['warn_more' => json_encode($addru,JSON_UNESCAPED_UNICODE)]);
  482. }else{
  483. //再次添加
  484. $upnum = array_merge_recursive($sel,$addru);
  485. $res = \App\Models\Stzqresult::where ('match_id', $matchid)->update(['warn_more' => json_encode($upnum,JSON_UNESCAPED_UNICODE)]);
  486. }
  487. }else{
  488. //编辑
  489. for ($i=0; $i < count($sel); $i++) {
  490. $sel[$wid]['timei'] = $timei;
  491. $sel[$wid]['timep'] = $timep;
  492. $sel[$wid]['rtype'] = $rtype;
  493. }
  494. $res = \App\Models\Stzqresult::where ('match_id', $matchid)->update(['warn_more' => json_encode($sel,JSON_UNESCAPED_UNICODE)]);
  495. }
  496. //用戶账户金额
  497. $account_money = \App\Models\Account_detailed::wherein('account_identity',$account_identitys)->get();
  498. //反水
  499. $water_return_money = \App\Models\Money_details::wherein('trade_id',$order_ids)->where('trade_type', '7')->get();
  500. //return $water_return_money;
  501. if(!empty($orders)){
  502. for($i=0;$i<count($orders);$i++){
  503. for($a=0;$a<count($account_money);$a++){
  504. if($orders[$i]['account_identity'] == $account_money[$a]['account_identity']){
  505. $available_cash = $account_money[$a]['available_cash'];
  506. }
  507. }
  508. for($b=0;$b<count($water_return_money);$b++){
  509. if($orders[$i]['order_id'] == $water_return_money[$b]['trade_id']){
  510. $water_return = $water_return_money[$b]['money'];
  511. } else {
  512. $water_return = 0;
  513. }
  514. }
  515. $new_available_cash = $available_cash + $orders[$i]->money - $orders[$i]->gain_money - $water_return;
  516. $models = new \App\Models\Money_details();
  517. $models->info_identity = UUID();
  518. $models->trade_id = $orders[$i]->order_id;
  519. $models->account_name = $orders[$i]->account_name;
  520. $models->account_identity = $orders[$i]->account_identity;
  521. $models->money = abs($orders[$i]->money - $orders[$i]->gain_money - $water_return);
  522. $models->money_time = date("Y-m-d H:i:s", time());
  523. if ($new_available_cash > $available_cash) {
  524. $models->money_type = '1';
  525. } else {
  526. $models->money_type = '2';
  527. }
  528. $models->money_cash = $new_available_cash;
  529. $models->trade_type = '25';
  530. $models->trade_desc = '单式注单审核不通过回款';
  531. $models->status = '1';
  532. try {
  533. DB::beginTransaction();//开启事务
  534. \App\Models\SportsNoteList::where('id', $orders[$i]['id'])->update(['roll_ratify' => '-1','status' => '2']);
  535. \App\Models\Account_detailed::where('account_identity', $orders[$i]->account_identity)->update(['available_cash' => $new_available_cash, 'cash' => $new_available_cash]);
  536. $models->save();
  537. DB::commit();//提交
  538. } catch (Exception $e) {
  539. DB::rollback();//回滚
  540. }
  541. }
  542. }
  543. }else{
  544. return json_encode(['status'=>2,'msg'=>'请设置正确时间']);
  545. }
  546. return responseToJson(1);
  547. }
  548. //足球结果列表 1
  549. function outcome(Req $req) {
  550. $request=array();
  551. $request['home_team'] = isset($req->home_team) ? trim($req->home_team) : null;
  552. $request['status'] = isset($req->status) ? trim($req->status) : '-1';
  553. $request['if_order'] = isset($req->if_order) ? trim($req->if_order) : '1';
  554. $request['sureblurs'] = isset($req->sureblurs) ? $req->sureblurs : 'on';
  555. $request['star_time'] = isset($req->star_time) ? trim($req->star_time) :trans('status.default_time.seven_day') ;
  556. $request['end_time'] = isset($req->end_time) ? trim($req->end_time) : trans('status.default_time.etime');
  557. $newapp = new \App\Models\SoccerLeague();
  558. $data = $newapp->allleague();
  559. $request['league'] = $data;//联赛id
  560. $request['token'] = session('adminInfo.token');//token 变量
  561. $dt = \App\Lib\DataTable\DataTable::init();
  562. $dt->setDataSource('/admin/sportsfoot/outcomeinfo');
  563. $dt->setLang('sportsfoot');
  564. $dt->addColsFields('newtime', array('templet' => '#newtime', 'sort' => false, 'width' => 200));
  565. $dt->addColsFields('totime', array('templet' => '#totime', 'sort' => false, 'width' => 155));
  566. $dt->addColsFields('home_team', array('templet' => '#userdetail', 'sort' => false, 'width' => 90));
  567. $dt->addColsFields('guest_team', array('templet' => '#userdetail', 'sort' => false, 'width' => 90));
  568. $dt->addColsFields('dsnum', array('templet' => '#dsnum', 'sort' => false, 'width' => 100));
  569. $dt->addColsFields('csnum', array('templet' => '#csnum', 'sort' => false, 'width' => 100));
  570. //$dt->addColsFields('match_score', array('sort' => false, 'width' => 210));
  571. $dt->addColsFields('match_score', array('templet' => '#match_score', 'sort' => false, 'width' => 180));
  572. $dt->addColsFields('statusmatch', array('templet' => '#statusmatch', 'sort' => false, 'width' => 100,'align' => 'left'));
  573. $dt->addColsFields('operation', array('templet' => '#status', 'sort' => false, 'width' => 300));
  574. // $arr[] = 'view';
  575. // if (checkRriv('/admin/sportsfoot/edit')) {
  576. // $arr[] = 'edit';
  577. // }
  578. // $dt->setToolBar($arr, array('width' => 200));1
  579. $dt->enableCheckBox();
  580. return view('admin.sportsfoot/outcome', $dt->render($request));
  581. }
  582. //结果添加
  583. function addend(Req $req){
  584. $match_id = $req->matchid;
  585. $model = \App\Models\Stzqresult::where('match_id', $match_id)->first();
  586. $match = \App\Models\SportsSoccer::where('id', $match_id)->first();
  587. $match_status = $match['status'];
  588. $data = array(
  589. //上半场角球
  590. "half_corner" => array(
  591. 'home' => strlen($req->homehalfcorner)?$req->homehalfcorner:'',
  592. 'guest' => strlen($req->guesthalfcorner)?$req->guesthalfcorner:'',
  593. ),
  594. //全场角球
  595. "all_corner" => array(
  596. 'home' => strlen($req->homeallcorner)?$req->homeallcorner:'',
  597. 'guest' => strlen($req->guestallcorner)?$req->guestallcorner:'',
  598. ),
  599. //上半场罚牌
  600. "half_penalty" => array(
  601. 'home' => strlen($req->homehalfcard)?$req->homehalfcard:'',
  602. 'guest' => strlen($req->guesthalfcard)?$req->guesthalfcard:'',
  603. ),
  604. //全场罚牌
  605. "all_penalty" => array(
  606. 'home' => strlen($req->homeallcard)?$req->homeallcard:'',
  607. 'guest' => strlen($req->guestallcard)?$req->guestallcard:'',
  608. ),
  609. //首进球时间
  610. "first_score" => array(
  611. 'time' => strlen($req->onescoretime)?$req->onescoretime:'',
  612. ),
  613. //上半场比分
  614. "half" => array(
  615. 'home' => strlen($req->homehalf)?$req->homehalf:'',
  616. 'guest' => strlen($req->guesthalf)?$req->guesthalf:'',
  617. ),
  618. //全场比分
  619. "all" => array(
  620. 'home' => strlen($req->homeall)>0?$req->homeall:'',
  621. 'guest' => strlen($req->guestall)>0?$req->guestall:'',
  622. ),
  623. );
  624. //修改足球比分前的比分数据
  625. $res = \App\Models\Stzqresult::where('match_id', $match_id)->first();
  626. $scores = json_decode($res['manual_result'],true);
  627. $process = array();//进程
  628. //主队上半场角球
  629. if($scores['half_corner']['home'] != $data['half_corner']['home']){
  630. $process[] = 'half_corner_home';
  631. }
  632. //客队上半场角球
  633. if($scores['half_corner']['guest'] != $data['half_corner']['guest']){
  634. $process[] = 'half_corner_guest';
  635. }
  636. //上半场角球
  637. if($scores['half_corner']['home'] != $data['half_corner']['home'] && $scores['half_corner']['guest'] != $data['half_corner']['guest']){
  638. $process[] = 'half_corner';
  639. }
  640. //主队全场角球
  641. if($scores['all_corner']['home'] != $data['all_corner']['home']){
  642. $process[] = 'all_corner_home';
  643. }
  644. //客队全场角球
  645. if($scores['all_corner']['guest'] != $data['all_corner']['guest']){
  646. $process[] = 'all_corner_guest';
  647. }
  648. //全场角球
  649. if($scores['all_corner']['home'] != $data['all_corner']['home'] && $scores['all_corner']['guest'] != $data['all_corner']['guest']){
  650. $process[] = 'all_corner';
  651. }
  652. //主队上半场罚牌
  653. if($scores['half_penalty']['home'] != $data['half_penalty']['home']){
  654. $process[] = 'half_penalty_home';
  655. }
  656. //客队上半场罚牌
  657. if($scores['half_penalty']['guest'] != $data['half_penalty']['guest']){
  658. $process[] = 'half_penalty_guest';
  659. }
  660. //上半场罚牌
  661. if($scores['half_penalty']['home'] != $data['half_penalty']['home'] && $scores['half_penalty']['guest'] != $data['half_penalty']['guest']){
  662. $process[] = 'half_penalty';
  663. }
  664. //主队全场罚牌
  665. if($scores['all_penalty']['home'] != $data['all_penalty']['home']){
  666. $process[] = 'all_penalty_home';
  667. }
  668. //客队全场罚牌
  669. if($scores['all_penalty']['guest'] != $data['all_penalty']['guest']){
  670. $process[] = 'all_penalty_guest';
  671. }
  672. //全场罚牌
  673. if($scores['all_penalty']['home'] != $data['all_penalty']['home'] && $scores['all_penalty']['guest'] != $data['all_penalty']['guest']){
  674. $process[] = 'all_penalty';
  675. }
  676. if($scores['all']['home'] != $data['all']['home'] || $scores['all']['guest'] != $data['all']['guest']){
  677. $process[] = 'all';
  678. }
  679. if($scores['half']['home'] != $data['half']['home'] || $scores['half']['guest'] != $data['half']['guest']){
  680. $process[] = 'half';
  681. }
  682. if(!empty($process)){
  683. //赛事下注单作废 处理
  684. commonFunction::HandleInvalid($data,$match_id,$match_status,'zq',$process);
  685. $updatainfo = [
  686. "manual_result"=>json_encode($data,JSON_UNESCAPED_UNICODE),
  687. 'is_correct'=>1
  688. ];
  689. \App\Models\Stzqresult::where('match_id', $match_id)->update($updatainfo);
  690. $update = $this->addcomendnotice($match_id);
  691. //赛事下所有注单状态都改变时,修改赛事,赛事结果状态
  692. if($match_status != 0 && $match_status != 1){
  693. $twoapp = new \App\Models\SportsSoccer();
  694. $twoapp->updatestatus('id',$match_id,['status'=>2,'utime'=>date('Y-m-d H:i:s')]);//修改赛事状态
  695. $newapp = new \App\Models\Stzqresult();
  696. $newapp->updatestatus('match_id',$match_id,['status'=>2,'update_time'=>date('Y-m-d H:i:s')]);//修改结果状态
  697. }
  698. //添加赛事结果记录
  699. $lastLog = \App\Models\Stzqresultlog::where([
  700. ['match_id', $match_id],
  701. ['type', 1]
  702. ])->orderBy('id', 'desc')->first();
  703. if(empty($lastLog) || $lastLog['manual_result'] != json_encode($data)){
  704. \App\Models\Stzqresultlog::insert([
  705. 'match_id' => $match_id,
  706. 'manual_result' => json_encode($data),
  707. 'user_id' => session('adminInfo.admin_id'),
  708. 'type' => 1,
  709. 'create_at' => now()
  710. ]);
  711. }
  712. }
  713. return responseToJson(1);
  714. }
  715. //查询赛事结果
  716. function Matchresult(Req $req){
  717. $match_id = $req->match_id;
  718. $newapp = \App\Models\Stzqresult::where('match_id', $match_id)->first();
  719. $array =array(
  720. 'corner_ball' => json_decode($newapp['corner_ball'],true),
  721. 'penalty_card' => json_decode($newapp['penalty_card'],true),
  722. 'first_score' => json_decode($newapp['first_score'],true),
  723. 'manual_result' => json_decode($newapp['manual_result'],true),
  724. 'newapp' => $newapp,
  725. );
  726. return $array;
  727. }
  728. //查询赛事结果记录
  729. function resultLog(Req $req){
  730. $match_id = $req->match_id;
  731. $list = \App\Models\Stzqresultlog::leftJoin('system_user', 'user_id', '=', 'system_user.id')
  732. ->select('st_zq_result_log.*', 'system_user.loginname')->where('match_id', $match_id)->orderBy('id', 'asc')->get();
  733. foreach ($list as $key=>$value){
  734. $list[$key]['penalty_card'] = json_decode($value['penalty_card'], true);
  735. $list[$key]['corner_ball'] = json_decode($value['corner_ball'], true);
  736. $list[$key]['first_score'] = empty($value['first_score']) ? '' : json_decode($value['first_score'], true);
  737. $list[$key]['manual_result'] = empty($value['manual_result']) ? '' : json_decode($value['manual_result'], true);
  738. }
  739. $result =array(
  740. 'status' => 200,
  741. 'list' => $list
  742. );
  743. echo json_encode($result);die;
  744. }
  745. function onlyresult(Req $req){
  746. $match_id = $req->matchid;
  747. $newapp = \App\Models\Stzqresult::where('match_id', $match_id)->first();
  748. return $newapp;
  749. }
  750. //作废
  751. function revokeft(Req $req){
  752. $iszf = $req->iszf?$req->iszf:'';//赛事id
  753. if(intval($iszf)){
  754. $id = $req->input('id');
  755. if (empty($id)) {
  756. return responseToJson(-2001); //
  757. }
  758. $ids = explode(',', $id);
  759. if (!is_array($ids) && intval($ids) < 0) {
  760. return responseToJson(-2002); //
  761. }
  762. if (is_array($ids) && count($ids) > 0) {
  763. foreach ($ids as $k => $v) {
  764. if (intval($v) < 1) {
  765. unset($ids[$k]);
  766. }
  767. }
  768. }
  769. for ($ii=0; $ii < count($ids); $ii++) {
  770. $model = \App\Models\Stzqresult::where('match_id', $ids[$ii])->first();
  771. $model->status = 4;
  772. $model->save();
  773. $ssid = $model['match_id'];//赛事id
  774. $smodel = \App\Models\SportsSoccer::where('id', $ssid)->first();
  775. if($smodel){
  776. $smodel->status = 4;
  777. $smodel->save();
  778. }
  779. //赛事下单式注单作废,串关注单下此赛事按平局处理
  780. $upapp = new \App\Models\SportsNoteList();
  781. $upapp->delorder($ssid,'zq');
  782. // $upapp = new \App\Models\SportsNoteList();
  783. // $data = $upapp->updatesimplex($ssid,'zq');//修改单式状态
  784. //单式撤单返现
  785. // $newapp = new \App\Models\MoneyBuyMatch();
  786. // $all = $newapp->allsimplexorder($ssid,'zq');
  787. // for ($i=0; $i < count($all); $i++) {
  788. // $appgx = new \App\Lib\Settlement\SettlementOrder();
  789. // $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']);
  790. // }
  791. //
  792. // //串式撤单只改状态
  793. // $str_ids = array_column($newapp->allstrorder($ssid),'order_id');
  794. // $csapp = new \App\Models\MoneyBuyStr();
  795. // $csapp->updatestatus($str_ids);//var_dump($ss);die;
  796. // //修改money_buy_match 投注结果result=2为平
  797. // $newapp->updatast($ssid);
  798. }
  799. return responseToJson(1);
  800. }else{
  801. $match_id = $req->match_id;//赛事id
  802. $model = \App\Models\Stzqresult::where('match_id', $match_id)->first();
  803. $model->status = 4;
  804. $model->save();
  805. $smodel = \App\Models\SportsSoccer::where('id', $match_id)->first();
  806. if($smodel){
  807. $smodel->status = 4;
  808. $smodel->save();
  809. }
  810. //赛事下单式注单作废,串关注单下此赛事按平局处理
  811. $upapp = new \App\Models\SportsNoteList();
  812. $upapp->delorder($match_id,'zq');
  813. // $upapp = new \App\Models\SportsNoteList();
  814. // $data = $upapp->updatesimplex($match_id,'zq');//修改单式状态
  815. // //单式撤单返现
  816. // $newapp = new \App\Models\MoneyBuyMatch();
  817. // $all = $newapp->allsimplexorder($match_id,'zq');
  818. // for ($i=0; $i < count($all); $i++) {
  819. // $appgx = new \App\Lib\Settlement\SettlementOrder();
  820. // $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']);
  821. // }
  822. // //串式撤单只改状态
  823. // $str_ids = array_column($newapp->allstrorder($match_id),'order_id');
  824. // $csapp = new \App\Models\MoneyBuyStr();
  825. // $csapp->updatestatus($str_ids);//var_dump($ss);die;
  826. // //修改money_buy_match 投注结果result=2为平
  827. // $newapp->updatast($match_id);
  828. return responseToJson(1);
  829. }
  830. }
  831. //赛事结果修改
  832. function edit(Req $req) {
  833. $id = $req->id;
  834. if (intval($id) < 1) {
  835. return -1;
  836. }
  837. if (!$req->isMethod('post')) {
  838. $data = \App\Models\Stzqresult::where('id', $id)->first();
  839. if (!$data) {
  840. return -2;
  841. }
  842. $data = $data->toArray();
  843. return view('admin.sportsfoot/edit', $data);
  844. } else {
  845. $model = \App\Models\Stzqresult::where('id', $id)->first();
  846. $model->home_team = $req->input('home_team');
  847. $model->guest_team = $req->input('guest_team');
  848. $model->home_rate = $req->input('home_rate');
  849. $model->guest_rate = $req->input('guest_rate');
  850. $model->status = $req->input('status');
  851. //$model->update_time = time();
  852. $model->save();
  853. return responseToJson(1);
  854. }
  855. }
  856. function outcomeinfo() {
  857. $page = Request::has('page') ? Request::get('page') : '';
  858. $list = Request::has('limit') ? Request::get('limit') : 10;
  859. $home_team = Request::has('home_team') ? Request::get('home_team') : '';
  860. $sureblur = Request::has('sureblurs') ? Request::get('sureblurs') : 'off';
  861. $status = Request::has('status') ? Request::get('status') : '';
  862. $if_order = Request::has('if_order') ? Request::get('if_order') : '';
  863. $star_time = Request::get('star_time') ? Request::get('star_time').' 00:00:00' : '';
  864. $end_time = Request::get('end_time') ? Request::get('end_time').' 23:59:59' : '';
  865. $where = array();
  866. $orwhere = array();
  867. if (!empty($home_team)) {
  868. if (empty($sureblur) || $sureblur == 'off') {
  869. $where[] = array('st_zq_result.home_team', 'like', '%' . $home_team . '%');
  870. $orwhere[] = array('st_zq_result.guest_team', 'like', '%' . $home_team . '%');
  871. } else {
  872. if(is_numeric($home_team)){
  873. $where[] = array('st_zq_result.match_id', '=', $home_team);
  874. $orwhere[] = array('st_zq_result.match_id', '=', $home_team);
  875. }else{
  876. $where[] = array('st_zq_result.home_team', '=', $home_team);
  877. $orwhere[] = array('st_zq_result.guest_team', '=', $home_team);
  878. }
  879. }
  880. }
  881. //
  882. if ($status != -1) {
  883. $where[] = array('st_zq_competition.status', '=', $status);
  884. $orwhere[] = array('st_zq_competition.status', '=', $status);
  885. }
  886. if (!empty($star_time) and empty($home_team)) {
  887. $star_time = date('Y-m-d H:i:s', strtotime($star_time));
  888. $where[] = array('st_zq_result.start_time', '>', $star_time);
  889. $orwhere[] = array('st_zq_result.start_time', '>', $star_time);
  890. }
  891. if (!empty($end_time) and empty($home_team)) {
  892. $end_time = date('Y-m-d H:i:s', strtotime($end_time));
  893. $where[] = array('st_zq_result.start_time', '<', $end_time);
  894. $orwhere[] = array('st_zq_result.start_time', '<', $end_time);
  895. }
  896. $newapp = new \App\Models\Stzqresult();
  897. $data = $newapp->resultlist($list, $page, $where, $orwhere,$if_order);
  898. return \App\Lib\DataTable\DataTable::init()->toJson($data['data'], $data['total']);
  899. }
  900. function saislist(Req $req){
  901. $lgid = $req->lgid;//赛事id
  902. $newstzqcompetition = new \App\Models\Stzqcompetition();
  903. $league_data = $newstzqcompetition->allcompetition($lgid);//赛事id
  904. return $league_data;
  905. }
  906. //赛事结果添加 guest_score 客队进球 all_goal总进球数
  907. function addoutcome(Req $req) {
  908. if (!$req->isMethod('post')) {
  909. $lange = trans('menu');
  910. $newapp = new \App\Models\SoccerLeague();
  911. $league_data = $newapp->allleague();//联赛id
  912. return view('admin.sportsfoot/addoutcome',['data'=>$league_data]);
  913. } else {
  914. $match_id = trim($req->input('match_id'));//赛事id
  915. //添加足球比赛结果表
  916. $alldata = $req->input();
  917. unset($alldata['_token']);
  918. $all_goal = intval($alldata['home_score'])+intval($alldata['guest_score']);//总进球数
  919. $penaltycard = array(
  920. 'home'=>intval($alldata['homeallcard'])?intval($alldata['homeallcard']):0,
  921. 'guest'=>intval($alldata['guestallcard'])?intval($alldata['guestallcard']):0,
  922. 'home_half'=>intval($alldata['homehalfcard'])?intval($alldata['homehalfcard']):0,
  923. 'guest_half'=>intval($alldata['guesthalfcard'])?intval($alldata['guesthalfcard']):0,
  924. );
  925. $cornerball = array(
  926. 'home'=>intval($alldata['homeallcorner'])?intval($alldata['homeallcorner']):0,
  927. 'guest'=>intval($alldata['guestallcorner'])?intval($alldata['guestallcorner']):0,
  928. 'home_half'=>intval($alldata['homehalfcorner'])?intval($alldata['homehalfcorner']):0,
  929. 'guest_half'=>intval($alldata['guesthalfcorner'])?intval($alldata['guesthalfcorner']):0,
  930. );
  931. $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)]));
  932. //添加足球比赛结果记录表
  933. \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')]));
  934. }
  935. return responseToJson(1);
  936. }
  937. //删除赛事结果
  938. function deleteoutcome(Req $req) {
  939. $id = $req->input('id');
  940. if (empty($id)) {
  941. return responseToJson(-2001); //
  942. }
  943. $ids = explode(',', $id);
  944. if (!is_array($ids) && intval($ids) < 0) {
  945. return responseToJson(-2002); //
  946. }
  947. if (is_array($ids) && count($ids) > 0) {
  948. foreach ($ids as $k => $v) {
  949. if (intval($v) < 1) {
  950. unset($ids[$k]);
  951. }
  952. }
  953. }
  954. $rows = \App\Models\Stzqresult::whereIn('id', $ids)->delete();
  955. if (!$rows) {
  956. return responseToJson(-2003);
  957. }
  958. return responseToJson(1);
  959. }
  960. /**
  961. * 更新赛事比分
  962. * 追加 赛事及所属注单作废处理
  963. */
  964. function updatenum(Req $req){
  965. $match_id = $req->match_id;
  966. $newapp = new \App\Models\Stzqresult();
  967. //赛事状态
  968. $match_status = intval($req->match_status)?intval($req->match_status):0;
  969. $data['u_home_score'] = intval($req->u_home_score)?intval($req->u_home_score):0;
  970. $data['u_guest_score'] = intval($req->u_guest_score)?intval($req->u_guest_score):0;
  971. $data['home_score'] = intval($req->home_score)?intval($req->home_score):0;
  972. $data['guest_score'] = intval($req->guest_score)?intval($req->guest_score):0;
  973. $data['is_correct'] = 1;//追加手动更改标识
  974. //更新比分 默认 status
  975. $status = 2;
  976. //赛事下注单作废 处理
  977. if(in_array(-1,$data)){
  978. commonFunction::HandleInvalid($data,$match_id,$match_status,'zq');
  979. // $this->HandleInvalid($data,$match_id,$match_status,'zq');
  980. }
  981. $newapp->updateInfo($data,$match_id);//联赛id
  982. $newapp->totalgoal($match_id);
  983. $update = $this->addcomendnotice($match_id);
  984. $twoapp = new \App\Models\SportsSoccer();
  985. $twoapp->updatestatus('match_id',$match_id,['status'=>$status,'utime'=>date('Y-m-d H:i:s')]);//修改赛事状态
  986. $newapp->updatestatus('match_id',$match_id,['status'=>$status,'update_time'=>date('Y-m-d H:i:s')]);//修改结果状态
  987. //添加赛事结果比较记录
  988. $lastLog = \App\Models\Stzqresultlog::where([
  989. ['match_id', $match_id],
  990. ['type', 2]
  991. ])->orderBy('id', 'desc')->first();
  992. if(empty($lastLog) || !(
  993. $lastLog['u_home_score'] == $data['u_home_score']
  994. && $lastLog['u_guest_score'] == $data['u_guest_score']
  995. && $lastLog['home_score'] == $data['home_score']
  996. && $lastLog['guest_score'] == $data['guest_score']
  997. )){
  998. $logData = $data;
  999. unset($logData['is_correct']);
  1000. $logData['type'] = 2;
  1001. $logData['match_id'] = $match_id;
  1002. $logData['user_id'] = session('adminInfo.admin_id');
  1003. $logData['create_at'] = now();
  1004. \App\Models\Stzqresultlog::insert($logData);
  1005. }
  1006. return responseToJson(1);
  1007. }
  1008. /**
  1009. * 赛事下注单作废处理
  1010. * 弃用 保留备份
  1011. */
  1012. function HandleInvalid($data=[],$match_id='',$match_status='',$game_code=''){
  1013. //===作废处理===
  1014. $moneyBuyMatch = new \App\Models\MoneyBuyMatch();
  1015. //获取赛事下所有单式注单
  1016. $select = ['money_buy_simplex.order_id', 'money_buy_simplex.match_id', 'money_buy_simplex.account_identity', 'money_buy_simplex.account_name','money_buy_simplex.money', 'money_buy_simplex.gain_money','money_buy_match.odds_code','st_odds_code.odds_name'];
  1017. //obj
  1018. $match_order_sim_obj = $moneyBuyMatch->allsimplexorder($match_id,$game_code,$select);
  1019. //获取赛事下所有串式注单
  1020. $select = ['money_buy_str.order_id', 'money_buy_match.match_id', 'money_buy_str.account_identity', 'money_buy_str.account_name','money_buy_str.money', 'money_buy_str.gain_money','st_odds_code.odds_name','money_buy_match.odds_code'];
  1021. //obj
  1022. $match_order_str_obj = $moneyBuyMatch->allstrorder($match_id,$game_code,$select);
  1023. //如果赛事下有 单式 注单
  1024. if(!empty($match_order_sim_obj)){
  1025. //获取单式注单中 待处理注单
  1026. $oddsData_sim = $this->getOrderData($data,$match_order_sim_obj,$game_code);
  1027. }
  1028. //如果赛事下有 串式 注单
  1029. if(!empty($match_order_str_obj)){
  1030. //获取串式注单中 待处理注单
  1031. $oddsData_str = $this->getOrderData($data,$match_order_str_obj,$game_code);
  1032. }
  1033. //如果是已结算赛事
  1034. if($match_status == 3){
  1035. //合并上半场/全场 待处理 单式+串式订单
  1036. $oddsData = array_merge($oddsData_sim,$oddsData_str);
  1037. //去重
  1038. $oddsData = commonFunction::uniquArrV2($oddsData,'order_id');
  1039. $url = 'http://stadmin.bocai108.com:9094/UnsetOneOrder';
  1040. $data_up = [
  1041. 'token'=>session('adminInfo.token'),
  1042. 'game_code'=>$game_code,
  1043. 'match_id'=>$match_id,
  1044. ];
  1045. //返回请求状态码
  1046. $set_status = [];
  1047. foreach($oddsData as $k=>$v){
  1048. $data_up['order_id'] = $v['order_id'];
  1049. $ret_json = commonFunction::https_request($url,$data_up);
  1050. $ret_arr = json_decode($ret_json,true);
  1051. $set_status[] = $ret_arr['status'];
  1052. }
  1053. if(in_array(0,$set_status)){
  1054. return responseToJson(-20003);
  1055. }
  1056. }else{
  1057. //未结算赛事 处理 下单式注单作废,串关注单下此赛事按平局处理
  1058. $oddsData_str = $oddsData_str->toArray();
  1059. $upapp = new \App\Models\SportsNoteList();
  1060. $upapp->delorder($match_id,$game_code,$match_order_sim_obj,$oddsData_str);
  1061. }
  1062. //=== end ===
  1063. }
  1064. /**
  1065. * 获取赛事下 符合条件 待处理注单
  1066. * 弃用 保留备份
  1067. */
  1068. function getOrderData($data,$match_order,$game_code){
  1069. //足球 获取 上半场/全场
  1070. if($game_code == 'zq'){
  1071. // 获取上半场作废 需处理 单式注单
  1072. $matchOdds_h = [];
  1073. if($data['u_home_score'] == -1 and $data['u_guest_score'] == -1){
  1074. foreach($match_order as $k=>$v){
  1075. $tmparray = explode('上半场',$v->odds_name);
  1076. if(count($tmparray) > 1){
  1077. $matchOdds_h[] = $v;
  1078. }
  1079. }
  1080. }
  1081. //获取全场作废 需处理 单式注单
  1082. $matchOdds_f = [];
  1083. if($data['home_score'] == -1 and $data['guest_score'] == -1){
  1084. foreach($match_order as $k=>$v){
  1085. $tmparray = explode('全场',$v->odds_name);
  1086. if(count($tmparray) > 1){
  1087. $matchOdds_f[] = $v;
  1088. }
  1089. }
  1090. }
  1091. $orderData = array_merge($matchOdds_h,$matchOdds_f);
  1092. }
  1093. return $orderData;
  1094. }
  1095. //添加赛事结束纪录
  1096. function addcomendnotice($match_id){
  1097. $data = \App\Models\Comendnotice::where(['match_id'=>$match_id,'game_code'=>'zq'])->first();
  1098. if(!$data){
  1099. $model = new \App\Models\Comendnotice();
  1100. $model->status = 0;//联赛id
  1101. $model->game_code = 'zq';
  1102. $model->match_id = $match_id;//赛事id
  1103. $model->ctime = date('Y-m-d H:i:s');
  1104. $model->save();
  1105. }
  1106. }
  1107. //获取赛事进程数据
  1108. function getprocess(Req $req){
  1109. $type = $req->type;
  1110. $process = commonFunction::getprocess($type);
  1111. return json_encode($process);
  1112. }
  1113. }