SportsfootController.php 45 KB

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