SportsfootController.php 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619
  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. /**
  10. *足球结算
  11. */
  12. class SportsfootController extends Controller {
  13. function Settlement(Req $req){
  14. $jsurl = config('sconstant.url');//结算请求域名地址
  15. $match_id = $req->match_id;
  16. $type = $req->type;
  17. $token = session('adminInfo.token');
  18. $notice = \App\Models\Comendnotice::where('match_id', $match_id)->first();
  19. if(!$notice){
  20. return json_encode(['status'=>5,'msg'=>'请先核对结果,并提交结果']);
  21. }
  22. $noticeid = $notice['id'];
  23. //查询赛事单式是否有订单(足球)
  24. $newapp = new \App\Models\MoneyBuyMatch();
  25. $simplex_ids = array_column($newapp->allsimplexorder($match_id,'zq'),'order_id');
  26. $str_ids = array_column($newapp->allstrorder($match_id),'order_id');
  27. if(count($simplex_ids)>0 || count($str_ids)>0){
  28. $requet = file_get_contents($jsurl."/WinFail?noticeid=".$noticeid."&token=".$token);
  29. if(json_decode($requet,true)['status']==1){
  30. $napp = new \App\Models\Stzqresult();
  31. //单式结算
  32. if(count($simplex_ids)>0 && count($str_ids)==0){
  33. $huawei_res = $napp->simplexs($token,$match_id,$jsurl,'zq');
  34. if($huawei_res['status']==1){
  35. return json_encode(['status'=>1,'msg'=>'单式结算成功,没有串式订单']);
  36. }else{
  37. return json_encode(['status'=>3,'msg'=>'单式结算有误,请联系管理员!!!('.$huawei_res['msg'].')']);//结算错误
  38. }
  39. }elseif(count($str_ids)>0 && count($simplex_ids)==0){
  40. //串式结算
  41. $tandem_res = $napp->tandems($token,$match_id,$jsurl,'zq');
  42. if($tandem_res['status']==1){
  43. return json_encode(['status'=>1,'msg'=>'串式结算成功,没有单式订单']);
  44. }else{
  45. return json_encode(['status'=>3,'msg'=>'串式结算有误,请联系管理员!!!('.$tandem_res['msg'].')']);//结算错误
  46. }
  47. }elseif(count($str_ids)>0 && count($simplex_ids)>0){
  48. //既有单式又有串式
  49. $huawei_res = $napp->simplexs($token,$match_id,$jsurl,'zq');
  50. //串式结算
  51. $tandem_res = $napp->tandems($token,$match_id,$jsurl,'zq');
  52. if($tandem_res['status']==1 && $huawei_res['status']==1){
  53. return json_encode(['status'=>1,'msg'=>'结算成功']);
  54. }elseif($tandem_res['status']!=1 || $huawei_res['status']!=1){
  55. return json_encode(['status'=>3,'msg'=>'结算有误,请联系管理员!!!('.$tandem_res['msg'].$huawei_res['msg'].')']);
  56. }else{
  57. return json_encode(['status'=>3,'msg'=>'返回参数不对']);
  58. }
  59. }
  60. }else{
  61. return json_encode(['status'=>2,'msg'=>'判断输赢错误,请联系管理员!!!']);;//输赢错误
  62. }
  63. }else{
  64. $log = array(
  65. session('adminInfo.admin_name'),
  66. );
  67. OperationLog(session('adminInfo.admin_id'), '足球结算', $log);
  68. $res = \App\Models\Stzqresult::where ('match_id', $match_id)->update(['status' =>3]);
  69. $res = \App\Models\SportsSoccer::where ('match_id', $match_id)->update(['status' =>3]);
  70. return json_encode(['status'=>4,'msg'=>'该赛事没有任何订单,将会结束该赛事!!!']);
  71. }
  72. }
  73. //添加危险球列表
  74. function addwarn(Req $req){
  75. $match_id = $req->match_id;
  76. $warn = \App\Models\Stzqresult::where('match_id', $match_id)->select("warn_more")->first();
  77. $warnmore = json_decode($warn['warn_more'],true);
  78. $sousuo = $req->sousuo?$req->sousuo:'';
  79. if($sousuo){
  80. $shuzu = array();
  81. for ($i=0; $i < count($warnmore); $i++) {
  82. if($warnmore[$i]['rtype']==$sousuo){
  83. $shuzu[$i]['timei'] = $warnmore[$i]['timei'];
  84. $shuzu[$i]['rtype'] = $warnmore[$i]['rtype'];
  85. $shuzu[$i]['timep'] = $warnmore[$i]['timep'];
  86. }
  87. }
  88. $shuzu = array_values($shuzu);
  89. $warnmore = $shuzu;
  90. $warnmore[0]['timei'] = 10000;
  91. }
  92. if($warnmore[0]['timei']!="1970-1-1 0:0:1"){
  93. $request['warnmore'] = $warnmore;
  94. //$request['warnmore'][0]['rtype'] = $sousuo;
  95. }else{
  96. $request['warnmore'] = '';
  97. }
  98. $request['match_id'] = $match_id;
  99. $request['sousuo'] = $sousuo;
  100. return view('admin.sportsfoot/addwarn', $request);
  101. }
  102. //危险球查询
  103. function warnresult(Req $req){
  104. $match_id = $req->match_id;
  105. $wid = $req->wid;
  106. $warnonlys = \App\Models\Stzqresult::where('match_id', $match_id)->select("warn_more","start_time")->first();
  107. $warno = array(
  108. 'warn_more' => json_decode($warnonlys['warn_more'],true),
  109. 'starttime' => $warnonlys['start_time'],
  110. );
  111. return $warno;
  112. }
  113. //添加编辑危险球
  114. function addwarnonly(Req $req){
  115. $matchid = $req->matchid;
  116. $wid = $req->wid;//编辑对象值
  117. $timei = $req->timei?$req->timei:"1970-11-1 0:0:1";
  118. $timep = $req->timep?$req->timep:"90";
  119. $rtype = $req->warntype?$req->warntype:0;
  120. $typenum = $req->typenum;
  121. $model = \App\Models\Stzqresult::where('match_id', $matchid)->select("warn_more","start_time")->first()->toArray();
  122. //该赛事的单式注单
  123. $orders = array();
  124. $otherorders = array();
  125. $account_identitys = array();
  126. $order_ids = array();
  127. $order = \App\Models\SportsNoteList::where('match_id',$matchid)->get();
  128. if(!empty($order)){
  129. for ($c=0; $c < count($order); $c++){
  130. if(strtotime($timei) >= strtotime($order[$c]['money_time']) && strtotime($timei)-$timep <= strtotime($order[$c]['money_time'])){
  131. $orders[] = $order[$c];
  132. $account_identitys[] = $order[$c]['account_identity'];
  133. $order_ids[] = $order[$c]['order_id'];
  134. }else{
  135. $otherorders[] = $order[$c]['id'];
  136. }
  137. }
  138. }
  139. //危险球范围外的注单自动审核通过
  140. //return $otherorders;
  141. if(!empty($otherorders)){
  142. \App\Models\SportsNoteList::wherein('id', $otherorders)->update(['roll_ratify' => '1']);
  143. }
  144. //return $account_identitys;
  145. $sel = json_decode($model['warn_more'],true);
  146. $addru = array(
  147. array(
  148. 'timei'=>$timei,
  149. 'timep'=>$timep,
  150. 'rtype'=>$rtype,
  151. ),
  152. );
  153. $only =$model['start_time'];
  154. $t = strtotime($only);
  155. $tt = date('Y-m-d H:i:s', $t+1*3*60*60);
  156. //timei']!="1970-1-1 0:0:1"
  157. if($only<$timei && $timei<$tt){
  158. if($typenum==10000){
  159. if($sel[0]['timei']=="1970-1-1 0:0:1"){
  160. //首次添加
  161. $res = \App\Models\Stzqresult::where ('match_id', $matchid)->update(['warn_more' => json_encode($addru,JSON_UNESCAPED_UNICODE)]);
  162. }else{
  163. //再次添加
  164. $upnum = array_merge_recursive($sel,$addru);
  165. $res = \App\Models\Stzqresult::where ('match_id', $matchid)->update(['warn_more' => json_encode($upnum,JSON_UNESCAPED_UNICODE)]);
  166. }
  167. }else{
  168. //编辑
  169. for ($i=0; $i < count($sel); $i++) {
  170. $sel[$wid]['timei'] = $timei;
  171. $sel[$wid]['timep'] = $timep;
  172. $sel[$wid]['rtype'] = $rtype;
  173. }
  174. $res = \App\Models\Stzqresult::where ('match_id', $matchid)->update(['warn_more' => json_encode($sel,JSON_UNESCAPED_UNICODE)]);
  175. }
  176. //用戶账户金额
  177. $account_money = \App\Models\Account_detailed::wherein('account_identity',$account_identitys)->get();
  178. //反水
  179. $water_return_money = \App\Models\Money_details::wherein('trade_id',$order_ids)->where('trade_type', '7')->get();
  180. //return $water_return_money;
  181. if(!empty($orders)){
  182. for($i=0;$i<count($orders);$i++){
  183. for($a=0;$a<count($account_money);$a++){
  184. if($orders[$i]['account_identity'] == $account_money[$a]['account_identity']){
  185. $available_cash = $account_money[$a]['available_cash'];
  186. }
  187. }
  188. for($b=0;$b<count($water_return_money);$b++){
  189. if($orders[$i]['order_id'] == $water_return_money[$b]['trade_id']){
  190. $water_return = $water_return_money[$b]['money'];
  191. } else {
  192. $water_return = 0;
  193. }
  194. }
  195. $new_available_cash = $available_cash + $orders[$i]->money - $orders[$i]->gain_money - $water_return;
  196. $models = new \App\Models\Money_details();
  197. $models->info_identity = UUID();
  198. $models->trade_id = $orders[$i]->order_id;
  199. $models->account_name = $orders[$i]->account_name;
  200. $models->account_identity = $orders[$i]->account_identity;
  201. $models->money = abs($orders[$i]->money - $orders[$i]->gain_money - $water_return);
  202. $models->money_time = date("Y-m-d H:i:s", time());
  203. if ($new_available_cash > $available_cash) {
  204. $models->money_type = '1';
  205. } else {
  206. $models->money_type = '2';
  207. }
  208. $models->money_cash = $new_available_cash;
  209. $models->trade_type = '25';
  210. $models->trade_desc = '单式注单审核不通过回款';
  211. $models->status = '1';
  212. try {
  213. DB::beginTransaction();//开启事务
  214. \App\Models\SportsNoteList::where('id', $orders[$i]['id'])->update(['roll_ratify' => '-1','status' => '2']);
  215. \App\Models\Account_detailed::where('account_identity', $orders[$i]->account_identity)->update(['available_cash' => $new_available_cash, 'cash' => $new_available_cash]);
  216. $models->save();
  217. DB::commit();//提交
  218. } catch (Exception $e) {
  219. DB::rollback();//回滚
  220. }
  221. }
  222. }
  223. }else{
  224. return json_encode(['status'=>2,'msg'=>'请设置正确时间']);
  225. }
  226. return responseToJson(1);
  227. }
  228. //足球结果列表
  229. function outcome(Req $req) {
  230. $request=array();
  231. $request['home_team'] = isset($req->home_team) ? trim($req->home_team) : null;
  232. $request['status'] = isset($req->status) ? trim($req->status) : '-1';
  233. $request['sureblurs'] = isset($req->sureblurs) ? $req->sureblurs : 'on';
  234. $request['star_time'] = isset($req->star_time) ? trim($req->star_time) :trans('status.default_time.seven_day') ;
  235. $request['end_time'] = isset($req->end_time) ? trim($req->end_time) : trans('status.default_time.etime');
  236. $newapp = new \App\Models\SoccerLeague();
  237. $data = $newapp->allleague();
  238. $request['league'] = $data;//联赛id
  239. $request['token'] = session('adminInfo.token');//token 变量
  240. $dt = \App\Lib\DataTable\DataTable::init();
  241. $dt->setDataSource('/admin/sportsfoot/outcomeinfo');
  242. $dt->setLang('sportsfoot');
  243. $dt->addColsFields('newtime', array('templet' => '#newtime', 'sort' => false, 'width' => 200));
  244. $dt->addColsFields('totime', array('templet' => '#totime', 'sort' => false, 'width' => 80));
  245. $dt->addColsFields('home_team', array('templet' => '#userdetail', 'sort' => false, 'width' => 80));
  246. $dt->addColsFields('guest_team', array('templet' => '#userdetail', 'sort' => false, 'width' => 70));
  247. $dt->addColsFields('dsnum', array('templet' => '#dsnum', 'sort' => false, 'width' => 70));
  248. $dt->addColsFields('csnum', array('templet' => '#csnum', 'sort' => false, 'width' => 110));
  249. $dt->addColsFields('sxalfcourt', array('templet' => '#sxalfcourt', 'sort' => false, 'width' => 300));
  250. $dt->addColsFields('statusmatch', array('templet' => '#statusmatch', 'sort' => false, 'width' => 150,'align' => 'left'));
  251. $dt->addColsFields('operation', array('templet' => '#status', 'sort' => false, 'width' => 300));
  252. // $arr[] = 'view';
  253. // if (checkRriv('/admin/sportsfoot/edit')) {
  254. // $arr[] = 'edit';
  255. // }
  256. // $dt->setToolBar($arr, array('width' => 200));
  257. $dt->enableCheckBox();
  258. return view('admin.sportsfoot/outcome', $dt->render($request));
  259. }
  260. //结果添加
  261. function addend(Req $req){
  262. $match_id = $req->matchid;
  263. $model = \App\Models\Stzqresult::where('match_id', $match_id)->first();
  264. $penaltycard = array(
  265. 'home'=>intval($req->homeallcard)?intval($req->homeallcard):0,
  266. 'guest'=>intval($req->guestallcard)?intval($req->guestallcard):0,
  267. 'home_half'=>intval($req->homehalfcard)?intval($req->homehalfcard):0,
  268. 'guest_half'=>intval($req->guesthalfcard)?intval($req->guesthalfcard):0,
  269. );
  270. $cornerball = array(
  271. 'home'=>intval($req->homeallcorner)?intval($req->homeallcorner):0,
  272. 'guest'=>intval($req->guestallcorner)?intval($req->guestallcorner):0,
  273. 'home_half'=>intval($req->homehalfcorner)?intval($req->homehalfcorner):0,
  274. 'guest_half'=>intval($req->guesthalfcorner)?intval($req->guesthalfcorner):0,
  275. );
  276. $firstone = array(
  277. 'teamscore'=>$req->firstscore ? $req->firstscore:0,
  278. 'scoretime'=>intval($req->onescoretime)?intval($req->onescoretime):0,
  279. 'scoretype'=>$req->firststye ? $req->firststye:0,
  280. );
  281. $model->last_score = $req->lastscore?$req->lastscore:'';
  282. $model->match_winer = $req->matchwiner?$req->matchwiner:'';
  283. $model->penalty_card = json_encode($penaltycard,JSON_UNESCAPED_UNICODE);
  284. $model->corner_ball = json_encode($cornerball,JSON_UNESCAPED_UNICODE);
  285. $model->first_score = json_encode($firstone,JSON_UNESCAPED_UNICODE);
  286. $model->save();
  287. return responseToJson(1);
  288. }
  289. //查询赛事结果
  290. function Matchresult(Req $req){
  291. $match_id = $req->match_id;
  292. $newapp = \App\Models\Stzqresult::where('match_id', $match_id)->first();
  293. $array =array(
  294. 'corner_ball' => json_decode($newapp['corner_ball'],true),
  295. 'penalty_card' => json_decode($newapp['penalty_card'],true),
  296. 'first_score' => json_decode($newapp['first_score'],true),
  297. 'newapp' => $newapp,
  298. );
  299. return $array;
  300. }
  301. function onlyresult(Req $req){
  302. $match_id = $req->matchid;
  303. $newapp = \App\Models\Stzqresult::where('match_id', $match_id)->first();
  304. return $newapp;
  305. }
  306. //作废
  307. function revokeft(Req $req){
  308. $iszf = $req->iszf?$req->iszf:'';//赛事id
  309. if(intval($iszf)){
  310. $id = $req->input('id');
  311. if (empty($id)) {
  312. return responseToJson(-2001); //
  313. }
  314. $ids = explode(',', $id);
  315. if (!is_array($ids) && intval($ids) < 0) {
  316. return responseToJson(-2002); //
  317. }
  318. if (is_array($ids) && count($ids) > 0) {
  319. foreach ($ids as $k => $v) {
  320. if (intval($v) < 1) {
  321. unset($ids[$k]);
  322. }
  323. }
  324. }
  325. for ($ii=0; $ii < count($ids); $ii++) {
  326. $model = \App\Models\Stzqresult::where('match_id', $ids[$ii])->first();
  327. $model->status = 4;
  328. $model->save();
  329. $ssid = $model['match_id'];//赛事id
  330. $smodel = \App\Models\SportsSoccer::where('id', $ssid)->first();
  331. if($smodel){
  332. $smodel->status = 4;
  333. $smodel->save();
  334. }
  335. //赛事下单式注单作废,串关注单下此赛事按平局处理
  336. $upapp = new \App\Models\SportsNoteList();
  337. $upapp->delorder($ssid,'zq');
  338. // $upapp = new \App\Models\SportsNoteList();
  339. // $data = $upapp->updatesimplex($ssid,'zq');//修改单式状态
  340. //单式撤单返现
  341. // $newapp = new \App\Models\MoneyBuyMatch();
  342. // $all = $newapp->allsimplexorder($ssid,'zq');
  343. // for ($i=0; $i < count($all); $i++) {
  344. // $appgx = new \App\Lib\Settlement\SettlementOrder();
  345. // $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']);
  346. // }
  347. //
  348. // //串式撤单只改状态
  349. // $str_ids = array_column($newapp->allstrorder($ssid),'order_id');
  350. // $csapp = new \App\Models\MoneyBuyStr();
  351. // $csapp->updatestatus($str_ids);//var_dump($ss);die;
  352. // //修改money_buy_match 投注结果result=2为平
  353. // $newapp->updatast($ssid);
  354. }
  355. return responseToJson(1);
  356. }else{
  357. $match_id = $req->match_id;//赛事id
  358. $model = \App\Models\Stzqresult::where('match_id', $match_id)->first();
  359. $model->status = 4;
  360. $model->save();
  361. $smodel = \App\Models\SportsSoccer::where('id', $match_id)->first();
  362. if($smodel){
  363. $smodel->status = 4;
  364. $smodel->save();
  365. }
  366. //赛事下单式注单作废,串关注单下此赛事按平局处理
  367. $upapp = new \App\Models\SportsNoteList();
  368. $upapp->delorder($match_id,'zq');
  369. // $upapp = new \App\Models\SportsNoteList();
  370. // $data = $upapp->updatesimplex($match_id,'zq');//修改单式状态
  371. // //单式撤单返现
  372. // $newapp = new \App\Models\MoneyBuyMatch();
  373. // $all = $newapp->allsimplexorder($match_id,'zq');
  374. // for ($i=0; $i < count($all); $i++) {
  375. // $appgx = new \App\Lib\Settlement\SettlementOrder();
  376. // $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']);
  377. // }
  378. // //串式撤单只改状态
  379. // $str_ids = array_column($newapp->allstrorder($match_id),'order_id');
  380. // $csapp = new \App\Models\MoneyBuyStr();
  381. // $csapp->updatestatus($str_ids);//var_dump($ss);die;
  382. // //修改money_buy_match 投注结果result=2为平
  383. // $newapp->updatast($match_id);
  384. return responseToJson(1);
  385. }
  386. }
  387. //赛事结果修改
  388. function edit(Req $req) {
  389. $id = $req->id;
  390. if (intval($id) < 1) {
  391. return -1;
  392. }
  393. if (!$req->isMethod('post')) {
  394. $data = \App\Models\Stzqresult::where('id', $id)->first();
  395. if (!$data) {
  396. return -2;
  397. }
  398. $data = $data->toArray();
  399. return view('admin.sportsfoot/edit', $data);
  400. } else {
  401. $model = \App\Models\Stzqresult::where('id', $id)->first();
  402. $model->home_team = $req->input('home_team');
  403. $model->guest_team = $req->input('guest_team');
  404. $model->home_rate = $req->input('home_rate');
  405. $model->guest_rate = $req->input('guest_rate');
  406. $model->status = $req->input('status');
  407. //$model->update_time = time();
  408. $model->save();
  409. return responseToJson(1);
  410. }
  411. }
  412. function outcomeinfo() {
  413. $page = Request::has('page') ? Request::get('page') : '';
  414. $list = Request::has('limit') ? Request::get('limit') : 10;
  415. $home_team = Request::has('home_team') ? Request::get('home_team') : '';
  416. $sureblur = Request::has('sureblurs') ? Request::get('sureblurs') : 'off';
  417. $status = Request::has('status') ? Request::get('status') : '';
  418. $star_time = Request::get('star_time') ? Request::get('star_time').' 00:00:00' : '';
  419. $end_time = Request::get('end_time') ? Request::get('end_time').' 23:59:59' : '';
  420. $where = array();
  421. $orwhere = array();
  422. if (!empty($home_team)) {
  423. if (empty($sureblur) || $sureblur == 'off') {
  424. $where[] = array('st_zq_result.home_team', 'like', '%' . $home_team . '%');
  425. $orwhere[] = array('st_zq_result.guest_team', 'like', '%' . $home_team . '%');
  426. } else {
  427. if(is_numeric($home_team)){
  428. $where[] = array('st_zq_result.match_id', '=', $home_team);
  429. }else{
  430. $where[] = array('st_zq_result.home_team', '=', $home_team);
  431. $orwhere[] = array('st_zq_result.guest_team', '=', $home_team);
  432. }
  433. }
  434. }
  435. if ($status != -1) {
  436. $where[] = array('st_zq_result.status', '=', $status);
  437. $orwhere[] = array('st_zq_result.status', '=', $status);
  438. }
  439. if(!is_numeric($home_team)){
  440. if (!empty($star_time)) {
  441. $star_time = date('Y-m-d H:i:s', strtotime($star_time));
  442. $where[] = array('st_zq_result.start_time', '>', $star_time);
  443. $orwhere[] = array('st_zq_result.start_time', '>', $star_time);
  444. }
  445. if (!empty($end_time)) {
  446. $end_time = date('Y-m-d H:i:s', strtotime($end_time));
  447. $where[] = array('st_zq_result.start_time', '<', $end_time);
  448. $orwhere[] = array('st_zq_result.start_time', '<', $end_time);
  449. }
  450. }
  451. $newapp = new \App\Models\Stzqresult();
  452. $data = $newapp->resultlist($list, $page, $where, $orwhere);
  453. return \App\Lib\DataTable\DataTable::init()->toJson($data['data'], $data['total']);
  454. }
  455. function saislist(Req $req){
  456. $lgid = $req->lgid;//赛事id
  457. $newstzqcompetition = new \App\Models\Stzqcompetition();
  458. $league_data = $newstzqcompetition->allcompetition($lgid);//赛事id
  459. return $league_data;
  460. }
  461. //赛事结果添加 guest_score 客队进球 all_goal总进球数
  462. function addoutcome(Req $req) {
  463. if (!$req->isMethod('post')) {
  464. $lange = trans('menu');
  465. $newapp = new \App\Models\SoccerLeague();
  466. $league_data = $newapp->allleague();//联赛id
  467. return view('admin.sportsfoot/addoutcome',['data'=>$league_data]);
  468. } else {
  469. $match_id = trim($req->input('match_id'));//赛事id
  470. //添加足球比赛结果表
  471. $alldata = $req->input();
  472. unset($alldata['_token']);
  473. $all_goal = intval($alldata['home_score'])+intval($alldata['guest_score']);//总进球数
  474. $penaltycard = array(
  475. 'home'=>intval($alldata['homeallcard'])?intval($alldata['homeallcard']):0,
  476. 'guest'=>intval($alldata['guestallcard'])?intval($alldata['guestallcard']):0,
  477. 'home_half'=>intval($alldata['homehalfcard'])?intval($alldata['homehalfcard']):0,
  478. 'guest_half'=>intval($alldata['guesthalfcard'])?intval($alldata['guesthalfcard']):0,
  479. );
  480. $cornerball = array(
  481. 'home'=>intval($alldata['homeallcorner'])?intval($alldata['homeallcorner']):0,
  482. 'guest'=>intval($alldata['guestallcorner'])?intval($alldata['guestallcorner']):0,
  483. 'home_half'=>intval($alldata['homehalfcorner'])?intval($alldata['homehalfcorner']):0,
  484. 'guest_half'=>intval($alldata['guesthalfcorner'])?intval($alldata['guesthalfcorner']):0,
  485. );
  486. $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)]));
  487. //添加足球比赛结果记录表
  488. \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')]));
  489. }
  490. return responseToJson(1);
  491. }
  492. //删除赛事结果
  493. function deleteoutcome(Req $req) {
  494. $id = $req->input('id');
  495. if (empty($id)) {
  496. return responseToJson(-2001); //
  497. }
  498. $ids = explode(',', $id);
  499. if (!is_array($ids) && intval($ids) < 0) {
  500. return responseToJson(-2002); //
  501. }
  502. if (is_array($ids) && count($ids) > 0) {
  503. foreach ($ids as $k => $v) {
  504. if (intval($v) < 1) {
  505. unset($ids[$k]);
  506. }
  507. }
  508. }
  509. $rows = \App\Models\Stzqresult::whereIn('id', $ids)->delete();
  510. if (!$rows) {
  511. return responseToJson(-2003);
  512. }
  513. return responseToJson(1);
  514. }
  515. //更新赛事比分
  516. function updatenum(Req $req){
  517. $match_id = $req->match_id;
  518. $newapp = new \App\Models\Stzqresult();
  519. $data['u_home_score'] = intval($req->u_home_score)?intval($req->u_home_score):0;
  520. $data['u_guest_score'] = intval($req->u_guest_score)?intval($req->u_guest_score):0;
  521. $data['home_score'] = intval($req->home_score)?intval($req->home_score):0;
  522. $data['guest_score'] = intval($req->guest_score)?intval($req->guest_score):0;
  523. $data['is_correct'] = 1;//追加手动更改标识
  524. $newapp->updateInfo($data,$match_id);//联赛id
  525. $newapp->totalgoal($match_id);
  526. $update = $this->addcomendnotice($match_id);
  527. $twoapp = new \App\Models\SportsSoccer();
  528. $twoapp->updatestatus('match_id',$match_id,['status'=>2]);//修改赛事状态
  529. $newapp->updatestatus('match_id',$match_id,['status'=>2]);//修改结果状态
  530. return responseToJson(1);
  531. }
  532. //添加赛事结束纪录
  533. function addcomendnotice($match_id){
  534. $data = \App\Models\Comendnotice::where(['match_id'=>$match_id,'game_code'=>'zq'])->first();
  535. if(!$data){
  536. $model = new \App\Models\Comendnotice();
  537. $model->status = 0;//联赛id
  538. $model->game_code = 'zq';
  539. $model->match_id = $match_id;//赛事id
  540. $model->ctime = date('Y-m-d H:i:s');
  541. $model->save();
  542. }
  543. return responseToJson(1);
  544. }
  545. }