SportsfootController.php 44 KB

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