SportsbkController.php 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593
  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 SportsbkController extends Controller {
  14. public $code = "lq";
  15. //篮球结果列表
  16. public function outcome(Req $req) {
  17. $request['home_team'] = isset($req->home_team) ? trim($req->home_team) : null;
  18. $request['status'] = isset($req->status) ? trim($req->status) : '-1';
  19. $request['if_order'] = isset($req->if_order) ? trim($req->if_order) : '1';
  20. $request['sureblurs'] = isset($req->sureblurs) ? $req->sureblurs : 'on';
  21. $request['star_time'] = isset($req->star_time) ? trim($req->star_time) :trans('status.default_time.seven_day') ;
  22. $request['end_time'] = isset($req->end_time) ? trim($req->end_time) : trans('status.default_time.etime');
  23. $dt = \App\Lib\DataTable\DataTable::init();
  24. $dt->setDataSource('/admin/Sportsbk/info');
  25. $dt->setLang('sportsbk');
  26. $dt->addColsFields('lg_id', array('templet' => '#liansai', 'sort' => true, 'width' => 160));
  27. $dt->addColsFields('start_time', array('templet' => '#userdetail', 'sort' => true, 'width' => 160));
  28. $dt->addColsFields('home_team', array('templet' => '#userdetail', 'sort' => false, 'width' => 100));
  29. $dt->addColsFields('guest_team', array('templet' => '#userdetail', 'sort' => false, 'width' => 100));
  30. $dt->addColsFields('dsnum', array('templet' => '#dsnum', 'sort' => false, 'width' => 100));
  31. $dt->addColsFields('csnum', array('templet' => '#csnum', 'sort' => false, 'width' => 100));
  32. $dt->addColsFields('match_score', array('templet' => '#match_score','sort' => false, 'width' => 170));
  33. // $dt->addColsFields('sectionone_two', array('templet' => '#sectionone_two', 'sort' => false, 'width' => 170));
  34. // $dt->addColsFields('sectionthere_four', array('templet' => '#sectionthere_four', 'sort' => false, 'width' => 220));
  35. $dt->addColsFields('status', array('templet' => '#matchstatus', 'sort' => false, 'width' => 80));
  36. $dt->addColsFields('operation', array('templet' => '#operation', 'sort' => false, 'width' => 300));
  37. $dt->enableCheckBox();
  38. // if (checkRriv('/admin/Sportsbk/edit')) {
  39. // $arr[] = 'edit';
  40. // }
  41. // $dt->setToolBar($arr, array('width' => 200));
  42. // $dt->enableCheckBox();
  43. return view('admin/sportsbk/outcome', $dt->render($request));
  44. }
  45. //篮球赛事作废
  46. function revoke(Req $req){
  47. $match_id = $req->match_id;//赛事id
  48. \App\Models\Stlqresult::where('match_id', $match_id)->update(['status'=>4]);
  49. \App\Models\SportsBasket::where('id', $match_id)->update(['status'=>4]);
  50. //赛事下单式注单作废,串关注单下此赛事按平局处理
  51. $upapp = new \App\Models\SportsNoteList();
  52. $upapp->delorder($match_id,'lq');
  53. // $upapp = new \App\Models\SportsNoteList();
  54. // $data = $upapp->updatesimplex($match_id,$this->code);//修改单式状态
  55. //
  56. // //单式撤单返现
  57. // $newapp = new \App\Models\MoneyBuyMatch();
  58. // $all = $newapp->allsimplexorder($match_id,$this->code);
  59. // for ($i=0; $i < count($all); $i++) {
  60. // $appgx = new SettlementOrder();
  61. // $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']);
  62. // }
  63. //
  64. // //串式撤单只改状态
  65. // $str_ids = array_column($newapp->allstrorder($match_id),'order_id');
  66. // $csapp = new \App\Models\MoneyBuyStr();
  67. // $csapp->updatestatus($str_ids);
  68. // //修改money_buy_match 投注结果result=2为平
  69. // $newapp->updatast($match_id);
  70. return responseToJson(1);
  71. }
  72. //结果添加
  73. function addend(Req $req){
  74. $match_id = $req->matchid;
  75. $model = \App\Models\Stlqresult::where('match_id', $match_id)->first();
  76. $match = \App\Models\SportsBasket::where('id', $match_id)->first();
  77. $match_status = $match['status'];
  78. $data = array(
  79. "1" => array(
  80. 'home' => intval($req->homeo)?intval($req->homeo):0,
  81. 'guest' => intval($req->guesto)?intval($req->guesto):0,
  82. ),
  83. "2" => array(
  84. 'home' => intval($req->homet)?intval($req->homet):0,
  85. 'guest' => intval($req->guestt)?intval($req->guestt):0,
  86. ),
  87. "3" => array(
  88. 'home' => intval($req->homes)?intval($req->homes):0,
  89. 'guest' => intval($req->guests)?intval($req->guests):0,
  90. ),
  91. "4" => array(
  92. 'home' => intval($req->homef)?intval($req->homef):0,
  93. 'guest' => intval($req->guestf)?intval($req->guestf):0,
  94. ),
  95. "5" => array(
  96. 'home' => intval($req->homeu)?intval($req->homeu):0,
  97. 'guest' => intval($req->guestu)?intval($req->guestu):0,
  98. ),
  99. "6" => array(
  100. 'home' => intval($req->homeb)?intval($req->homeb):0,
  101. 'guest' => intval($req->guestb)?intval($req->guestb):0,
  102. ),
  103. "all" => array(
  104. 'home' => intval($req->homen)?intval($req->homen):0,
  105. 'guest' => intval($req->guestn)?intval($req->guestn):0,
  106. ),
  107. );
  108. // $array = array();
  109. // foreach($data as $key){
  110. // $array[] = $key['home'];
  111. // $array[] = $key['guest'];
  112. // }
  113. //修改蓝球比分前的比分数据
  114. $res = \App\Models\Stlqresult::where('match_id', $match_id)->first();
  115. $scores = json_decode($res['inning'],true);
  116. $process = array();//进程
  117. if($scores[1]['home'] != $data[1]['home'] || $scores[1]['guest'] != $data[1]['guest']){
  118. $process[] = 'one';
  119. }
  120. if($scores[2]['home'] != $data[2]['home'] || $scores[2]['guest'] != $data[2]['guest']){
  121. $process[] = 'two';
  122. }
  123. if($scores[3]['home'] != $data[3]['home'] || $scores[3]['guest'] != $data[3]['guest']){
  124. $process[] = 'three';
  125. }
  126. if($scores[4]['home'] != $data[4]['home'] || $scores[4]['guest'] != $data[4]['guest']){
  127. $process[] = 'four';
  128. }
  129. if($scores[5]['home'] != $data[5]['home'] || $scores[5]['guest'] != $data[5]['guest']){
  130. $process[] = 'uhalf';
  131. }
  132. if($scores[6]['home'] != $data[6]['home'] || $scores[6]['guest'] != $data[6]['guest']){
  133. $process[] = 'dhalf';
  134. }
  135. if($scores['all']['home'] != $data['all']['home'] || $scores['all']['guest'] != $data['all']['guest']){
  136. $process[] = 'all';
  137. }
  138. if(!empty($process)){
  139. //赛事下注单作废 处理
  140. commonFunction::HandleInvalid($data,$match_id,$match_status,'lq',$process);
  141. $guestscore =array(
  142. '1' => $data[1]['guest'],//第一节客队比分
  143. '2' => $data[2]['guest'],//第二节客队比分
  144. '3' => $data[3]['guest'],//第三节客队比分
  145. '4' => $data[4]['guest'],//第四节客队比分
  146. );
  147. $homescore =array(
  148. '1' => $data[1]['home'],//第一节客队比分
  149. '2' => $data[2]['home'],//第二节客队比分
  150. '3' => $data[3]['home'],//第三节客队比分
  151. '4' => $data[4]['home'],//第四节客队比分
  152. );
  153. $updatainfo = [
  154. "home_score"=>json_encode($homescore),
  155. "guest_score"=>json_encode($guestscore),
  156. "inning"=>json_encode($data),
  157. "u_home_score"=>$data[5]['home'],
  158. "u_guest_score"=>$data[5]['guest'],
  159. "s_home_score"=>$data[6]['home'],
  160. "s_guest_score"=>$data[6]['guest'],
  161. "match_score"=>$data['all']['home'].':'.$data['all']['guest'],
  162. 'is_correct'=>1
  163. ];
  164. \App\Models\Stlqresult::where('match_id', $match_id)->update($updatainfo);
  165. $addnew = new \App\Models\Comendnotice();
  166. $addnew->addcomendnotice($match_id,'lq');
  167. //赛事下所有注单状态都改变时,修改赛事,赛事结果状态
  168. if(count($process) == count($data)){
  169. $twoapp = new \App\Models\SportsBasket();
  170. $twoapp->updatestatus('id',$match_id,['status'=>2,'utime'=>date('Y-m-d H:i:s')]);//修改赛事状态
  171. $newapp = new \App\Models\Stlqresult();
  172. $newapp->updatestatus('match_id',$match_id,['status'=>2,'update_time'=>date('Y-m-d H:i:s')]);//修改结果状态
  173. }
  174. //添加赛事结果记录
  175. $lastLog = \App\Models\Stlqresultlog::where([
  176. ['match_id', $match_id],
  177. ['type', 1]
  178. ])->orderBy('id', 'asc')->first();
  179. if(empty($lastLog) || $lastLog['inning'] != json_encode($data)){
  180. \App\Models\Stlqresultlog::insert([
  181. 'match_id' => $match_id,
  182. 'home_score' => json_encode($homescore),
  183. 'guest_score' => json_encode($guestscore),
  184. 'inning' => json_encode($data),
  185. 'user_id' => session('adminInfo.admin_id'),
  186. 'type' => 1,
  187. 'create_at' => now()
  188. ]);
  189. }
  190. }
  191. return responseToJson(1);
  192. }
  193. //查询赛事结果
  194. function Matchresult(Req $req){
  195. $match_id = $req->match_id;
  196. $newapp = \App\Models\Stlqresult::where('match_id', $match_id)->first();
  197. // $array =array(
  198. // 'corner_ball' => json_decode($newapp['corner_ball'],true),
  199. // 'penalty_card' => json_decode($newapp['penalty_card'],true),
  200. // 'newapp' => $newapp,
  201. // );
  202. $array =array(
  203. 'lqresult' => json_decode($newapp['inning'],true),
  204. );
  205. return $array;
  206. }
  207. //查询赛事结果记录
  208. function resultLog(Req $req){
  209. $match_id = $req->match_id;
  210. $list = \App\Models\Stlqresultlog::leftJoin('system_user', 'user_id', '=', 'system_user.id')
  211. ->select('st_lq_result_log.*', 'system_user.loginname')->where('match_id', $match_id)->orderBy('id', 'asc')->get();
  212. foreach ($list as $key=>$value){
  213. // $list[$key]['home_score'] = json_decode($value['home_score'], true);
  214. // $list[$key]['guest_score'] = json_decode($value['guest_score'], true);
  215. $list[$key]['inning'] = json_decode($value['inning'], true);
  216. }
  217. $result =array(
  218. 'status' => 200,
  219. 'list' => $list
  220. );
  221. echo json_encode($result);die;
  222. }
  223. //结算
  224. function Settlementlq(Req $req){
  225. $jsurl = config('sconstant.url');//结算请求域名地址
  226. $match_id = $req->match_id;
  227. $type = $req->type;
  228. $token = session('adminInfo.token');
  229. $notice = \App\Models\Comendnotice::where('match_id', $match_id)->first();
  230. $noticeid = $notice['id'];
  231. if(!$notice){
  232. return json_encode(['status'=>5,'msg'=>'请先核对结果,并提交结果']);
  233. }
  234. //查询赛事单式是否有订单(篮球)
  235. $newapp = new \App\Models\MoneyBuyMatch();
  236. $simplex_ids = array_column($newapp->simsettleorder($match_id,'lq'),'order_id');
  237. $str_ids = array_column($newapp->strsettleorder($match_id),'order_id');
  238. //去重
  239. $simplex_ids = array_unique($simplex_ids);
  240. $str_ids = array_unique($str_ids);
  241. //判断赛事下注单输赢
  242. $datas = array('noticeid' => $noticeid , 'token' => $token);
  243. $settlementAuto = new \App\Lib\Settlement\SettlementAuto();
  244. $winfail = $settlementAuto->SubmitSettelement('w',$datas);
  245. if($winfail == false){
  246. return json_encode(['status'=>2,'msg'=>'判断输赢错误,请联系管理员!!!']);//输赢错误
  247. }
  248. $sim = array(
  249. 'token'=>$token,
  250. 'order_ids'=>'', //订单id字符串,用半角都好分隔
  251. 'bettype'=>1, //结算类型 1单式 2串式
  252. 'settype'=>2, //结算次数 1首次 2非首冷饮
  253. 'game_code'=>$type, //赛事类型 zq lq wq bq
  254. 'match_id'=>$match_id, // 赛事ID
  255. 'change_status'=>1 //是否改状态
  256. );
  257. $str = array(
  258. 'token'=>$token,
  259. 'order_ids'=>'', //订单id字符串,用半角都好分隔
  260. 'bettype'=>2, //结算类型 1单式 2串式
  261. 'settype'=>2, //结算次数 1首次 2非首冷饮
  262. 'game_code'=>$type, //赛事类型 zq lq wq bq
  263. 'match_id'=>$match_id, // 赛事ID
  264. 'change_status'=>1 //是否改状态
  265. );
  266. if(count($simplex_ids)>0 || count($str_ids)>0){
  267. //单式结算
  268. if(count($simplex_ids)>0 && count($str_ids)==0){
  269. $sim['order_ids'] = implode(',',$simplex_ids);
  270. $settlesim = $settlementAuto->SubmitSettelement('s',$sim);
  271. if($settlesim == false){
  272. return json_encode(['status'=>3,'msg'=>'单式注单结算有误,请联系管理员!!!']);
  273. }else{
  274. return json_encode(['status'=>1,'msg'=>'单式结算成功,没有串式订单']);
  275. }
  276. }
  277. elseif(count($str_ids)>0 && count($simplex_ids)==0){
  278. $str['order_ids'] = implode(',',$str_ids);
  279. $settlestr = $settlementAuto->SubmitSettelement('s',$str);
  280. if($settlestr == false){
  281. return json_encode(['status'=>3,'msg'=>'串式注单结算有误,请联系管理员!!!']);
  282. }else{
  283. return json_encode(['status'=>1,'msg'=>'串式结算成功,没有单式订单']);
  284. }
  285. }
  286. elseif(count($str_ids)>0 && count($simplex_ids)>0){
  287. $sim['order_ids'] = implode(',',$simplex_ids);
  288. $str['order_ids'] = implode(',',$str_ids);
  289. $settlesim = $settlementAuto->SubmitSettelement('s',$sim);
  290. $settlestr = $settlementAuto->SubmitSettelement('s',$str);
  291. if($settlesim == true || $settlestr == true){
  292. return json_encode(['status'=>1,'msg'=>'结算成功']);
  293. }else{
  294. return json_encode(['status'=>3,'msg'=>'结算有误,请联系管理员!!!']);
  295. }
  296. }
  297. }else{
  298. $log = array(
  299. session('adminInfo.admin_name'),
  300. );
  301. OperationLog(session('adminInfo.admin_id'), '篮球结算', $log);
  302. $res = \App\Models\Stlqresult::where ('match_id', $match_id)->update(['status' =>3]);
  303. $res = \App\Models\SportsBasket::where ('id', $match_id)->update(['status' =>3]);
  304. return json_encode(['status'=>4,'msg'=>'该赛事没有任何订单,将会结束该赛事!!!']);
  305. }
  306. }
  307. function info() {
  308. $page = Request::has('page') ? Request::get('page') : '';
  309. $list = Request::has('limit') ? Request::get('limit') : 1;
  310. $home_team = Request::has('home_team') ? Request::get('home_team') : '';
  311. $sureblurs = Request::has('sureblurs') ? Request::get('sureblurs') : 'off';
  312. $star_time = Request::get('star_time') ? Request::get('star_time').' 00:00:00' : '';
  313. $end_time = Request::get('end_time') ? Request::get('end_time').' 23:59:59' : '';
  314. $status = Request::has('status') ? Request::get('status') : '';
  315. $if_order = Request::has('if_order') ? Request::get('if_order') : '';
  316. $where = array();
  317. $orwhere = array();
  318. if (!empty($home_team)) {
  319. if (empty($sureblurs) || $sureblurs == 'off') {
  320. $where[] = array('st_lq_result.home_team', 'like', '%' . $home_team . '%');
  321. $orwhere[] = array('st_lq_result.guest_team', 'like', '%' . $home_team . '%');
  322. } else {
  323. if(is_numeric($home_team)){
  324. $where[] = array('st_lq_result.match_id', '=', $home_team);
  325. $orwhere[] = array('st_lq_result.match_id', '=', $home_team);
  326. }else{
  327. $where[] = array('st_lq_result.home_team', '=', $home_team);
  328. $orwhere[] = array('st_lq_result.guest_team', '=', $home_team);
  329. }
  330. }
  331. }
  332. if (!empty($star_time) and empty($home_team)) {
  333. $star_time = date('Y-m-d H:i:s', strtotime($star_time));
  334. $where[] = array('st_lq_result.start_time', '>', $star_time);
  335. $orwhere[] = array('st_lq_result.start_time', '>', $star_time);
  336. }
  337. if (!empty($end_time) and empty($home_team)) {
  338. $end_time = date('Y-m-d H:i:s', strtotime($end_time));
  339. $where[] = array('st_lq_result.start_time', '<', $end_time);
  340. $orwhere[] = array('st_lq_result.start_time', '<', $end_time);
  341. }
  342. if ($status != -1) {
  343. $where[] = array('st_lq_competition.status', '=', $status);
  344. $orwhere[] = array('st_lq_competition.status', '=', $status);
  345. }
  346. $newapp = new \App\Models\Stlqresult();
  347. $data = $newapp->resultbklist($list, $page, $where, $orwhere,$if_order);
  348. for ($i=0; $i < count($data['data']); $i++) {
  349. $home_score = json_decode($data['data'][$i]['home_score'],true);
  350. $guest_score = json_decode($data['data'][$i]['guest_score'],true);
  351. $data['data'][$i]['okteamscore'] = $guest_score[1];//第一节客队比分
  352. $data['data'][$i]['ozteamscore'] = $home_score[1];//第一节主队比分
  353. $data['data'][$i]['tkteamscore'] = $guest_score[2];//第二节客队比分
  354. $data['data'][$i]['tzteamscore'] = $home_score[2];//第二节主队比分
  355. $data['data'][$i]['skteamscore'] = $guest_score[3];//第三节客队比分
  356. $data['data'][$i]['szteamscore'] = $home_score[3];//第三节主队比分
  357. $data['data'][$i]['akteamscore'] = $guest_score[4];//第四节客队比分
  358. $data['data'][$i]['azteamscore'] = $home_score[4];//第四节主队比分
  359. if(empty($data['data'][$i]['match_score'])){
  360. $data['data'][$i]['home_scores'] = 0;
  361. $data['data'][$i]['guest_scores'] = 0;
  362. }else{
  363. $scores = explode(':',$data['data'][$i]['match_score']);
  364. $data['data'][$i]['home_scores'] = $scores[0];
  365. $data['data'][$i]['guest_scores'] = $scores[1];
  366. }
  367. }
  368. return \App\Lib\DataTable\DataTable::init()->toJson($data['data'], $data['total']);
  369. }
  370. //修改添加赛事比分
  371. function updatascore(Req $req){
  372. $match_id = $req->match_id;//节数唯一标识
  373. $model = \App\Models\Stlqresult::where('match_id', $match_id)->first();
  374. $model->update_time = date('Y-m-d H:i:s');
  375. //赛事状态
  376. $match_status = intval($req->match_status)?intval($req->match_status):0;
  377. $guestscore =array(
  378. '1' => intval($req->okteamscore)?intval($req->okteamscore):0,//第一节客队比分
  379. '2' => intval($req->tkteamscore)?intval($req->tkteamscore):0,//第二节客队比分
  380. '3' => intval($req->skteamscore)?intval($req->skteamscore):0,//第三节客队比分
  381. '4' => intval($req->akteamscore)?intval($req->akteamscore):0,//第四节客队比分
  382. );
  383. $homescore =array(
  384. '1' => intval($req->ozteamscore)?intval($req->ozteamscore):0,//第一节主队比分
  385. '2' => intval($req->tzteamscore)?intval($req->tzteamscore):0,//第二节主队比分
  386. '3' => intval($req->szteamscore)?intval($req->szteamscore):0,//第三节主队比分
  387. '4' => intval($req->azteamscore)?intval($req->azteamscore):0,//第四节主队比分
  388. );
  389. $model->guest_score = json_encode($guestscore);
  390. $model->home_score = json_encode($homescore);
  391. $model->is_correct = 1;//追加手动更改标识
  392. $model->save();
  393. //更新比分 默认 status
  394. $status = 2;
  395. //赛事下注单作废 处理
  396. $data = array_merge($guestscore,$homescore);
  397. if(in_array(-1,$data)){
  398. commonFunction::HandleInvalid($data,$match_id,$match_status,'lq');
  399. }
  400. /*
  401. //追加判断比分 如果都== -1,则作废该赛事
  402. if($guestscore[1] < 0 and $guestscore[2] < 0 and $guestscore[3] < 0 and $guestscore[4] < 0 and $homescore[1] < 0 and $homescore[2] < 0 and $homescore[3] < 0 and $homescore[4] < 0 ){
  403. //已结算作废赛事处理
  404. if($match_status == 3){
  405. $url = 'http://stadmin.bocai108.com:9094/UnSettelement';
  406. $data_up = [
  407. 'token'=>session('adminInfo.token'),
  408. 'game_code'=>'lq',
  409. 'match_id'=>$match_id,
  410. ];
  411. $ret_json = commonFunction::https_request($url,$data_up);
  412. // $ret_json = '{"status":1,"msg":"撤销成功!2019-10-26 16:28:30 取消赛事处理--结束end:game_code= zq match_id= 40986 \n","data":[]}';
  413. $ret_arr = json_decode($ret_json,true);
  414. if($ret_arr['status'] != 1){
  415. return responseToJson(-20003);
  416. }
  417. }
  418. //赛事下单式注单作废,串关注单下此赛事按平局处理
  419. $upapp = new \App\Models\SportsNoteList();
  420. $upapp->delorder($match_id,'lq');
  421. $status = 4;
  422. }
  423. */
  424. $addnew = new \App\Models\Comendnotice();
  425. $addnew->addcomendnotice($match_id,'lq');
  426. $twoapp = new \App\Models\SportsBasket();
  427. $twoapp->updatestatus('match_id',$match_id,['status'=>$status,'utime'=>date('Y-m-d H:i:s')]);//修改赛事状态
  428. $newapp = new \App\Models\Stlqresult();
  429. $newapp->updatestatus('match_id',$match_id,['status'=>$status,'update_time'=>date('Y-m-d H:i:s')]);//修改结果状态
  430. //添加赛事结果比较记录
  431. $lastLog = \App\Models\Stlqresultlog::where([
  432. ['match_id', $match_id],
  433. ['type', 2]
  434. ])->orderBy('id', 'desc')->first();
  435. if(empty($lastLog) || !(
  436. $lastLog['guest_score'] == $model->guest_score
  437. && $lastLog['home_score'] == $model->home_score
  438. )){
  439. $logData = [
  440. 'guest_score' => $model->guest_score,
  441. 'home_score' => $model->home_score,
  442. 'type' => 2,
  443. 'match_id' => $match_id,
  444. 'user_id' => session('adminInfo.admin_id'),
  445. 'create_at' => now()
  446. ];
  447. \App\Models\Stlqresultlog::insert($logData);
  448. }
  449. return responseToJson(1);
  450. }
  451. function saislist(){
  452. $lgid = $_POST['lgid'];//赛事id
  453. $newstzqcompetition = new \App\Models\SportsBasket();
  454. $league_data = $newstzqcompetition->allcompetition($lgid);//赛事id
  455. return $league_data;
  456. }
  457. function addoutcome(Req $req) {
  458. if (!$req->isMethod('post')) {
  459. $lange = trans('menu');
  460. $newapp = new \App\Models\BasketLeague();
  461. $league_data = $newapp->allleague();//联赛id
  462. return view('admin.sportsbk/addoutcome',['data'=>$league_data]);
  463. }else{
  464. $model = new \App\Models\Stlqresult();
  465. $model->lg_id = trim($req->input('lg_id'));//联赛id
  466. $model->home_team = trim($req->input('home_team'));
  467. $model->guest_team = trim($req->input('guest_team'));
  468. $model->home_rate = trim($req->input('home_rate'));
  469. $model->guest_rate = trim($req->input('guest_rate'));
  470. $model->home_score = trim($req->input('home_score'));
  471. $model->guest_score = trim($req->input('guest_score'));
  472. $model->all_goal = trim($req->input('all_goal'));
  473. $model->match_score = trim($req->input('match_score'));
  474. $model->u_home_score = trim($req->input('u_home_score'));
  475. $model->u_guest_score = trim($req->input('u_guest_score'));
  476. $model->update_time = date('Y-m-d h:i:s', time());//更新时间
  477. $model->match_time = "11:22";//trim($req->input('match_time'));
  478. $model->tag = trim($req->input('tag'));
  479. $model->status = trim($req->input('status'));
  480. $model->match_process = trim($req->input('match_process'));
  481. $model->match_id = trim($req->input('match_id'));//赛事id
  482. $model->save();
  483. return responseToJson(1);
  484. }
  485. }
  486. //赛事结果修改
  487. function edit(Req $req) {
  488. $id = $req->id;
  489. if (intval($id) < 1) {
  490. return -1;
  491. }
  492. if (!$req->isMethod('post')) {
  493. $data = \App\Models\Stlqresult::where('id', $id)->first();
  494. if (!$data) {
  495. return -2;
  496. }
  497. $data = $data->toArray();
  498. return view('admin.sportsbk/edit', $data);
  499. } else {
  500. $model = \App\Models\Stlqresult::where('id', $id)->first();
  501. $model->home_team = $req->input('home_team');
  502. $model->guest_team = $req->input('guest_team');
  503. $model->home_rate = $req->input('home_rate');
  504. $model->guest_rate = $req->input('guest_rate');
  505. $model->status = $req->input('status');
  506. //$model->update_time = time();
  507. $model->save();
  508. return responseToJson(1);
  509. }
  510. }
  511. //删除赛事结果
  512. function deleteoutcome(Req $req) {
  513. $id = $req->input('id');
  514. if (empty($id)) {
  515. return responseToJson(-2001); //
  516. }
  517. $ids = explode(',', $id);
  518. if (!is_array($ids) && intval($ids) < 0) {
  519. return responseToJson(-2002); //
  520. }
  521. if (is_array($ids) && count($ids) > 0) {
  522. foreach ($ids as $k => $v) {
  523. if (intval($v) < 1) {
  524. unset($ids[$k]);
  525. }
  526. }
  527. }
  528. // echo '敬请期待';die;
  529. $rows = \App\Models\Stlqresult::whereIn('id', $ids)->delete();
  530. if (!$rows) {
  531. return responseToJson(-2003);
  532. }
  533. return responseToJson(1);
  534. }
  535. }