SportsSoccerController.php 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710
  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\SettlementWinFail;
  7. use App\Models;
  8. use Request;
  9. /**
  10. *1
  11. */
  12. class SportsSoccerController extends Controller
  13. {
  14. public function score(Req $req)
  15. {
  16. $request['name_chinese'] = isset($req->name_chinese) ? trim($req->name_chinese) : '';
  17. $request['home_team'] = isset($req->home_team) ? trim($req->home_team) : null;
  18. $request['match_date'] = isset($req->match_date) ? trim($req->match_date) : null;
  19. $request['recommend'] = isset($req->recommend) ? trim($req->recommend) : '';
  20. $request['status'] = isset($req->status) ? trim($req->status) : '-1';
  21. $request['sureblurs'] = isset($req->sureblurs) ? $req->sureblurs : 'on';
  22. $request['star_time'] = isset($req->star_time) ? trim($req->star_time) : null;
  23. $request['end_time'] = isset($req->end_time) ? trim($req->end_time) : null;
  24. $request['is_rollball'] = isset($req->is_rollball) ? trim($req->is_rollball) : '0';
  25. $request['is_today'] = isset($req->is_today) ? trim($req->is_today) : '0';
  26. $request['is_morningplate'] = isset($req->is_morningplate) ? trim($req->is_morningplate) : '0';
  27. $request['is_stringscene'] = isset($req->is_stringscene) ? trim($req->is_stringscene) : '0';
  28. $source = \App\Models\Setinfo::where('id', '1000')->first();
  29. if ($source->infocontent != '混合数据') {
  30. $data = \App\Models\SoccerLeague::join('st_zq_local_league', 'st_zq_league.id', '=', 'st_zq_local_league.lg_id')->select('st_zq_league.id', 'st_zq_league.name_chinese')->where('st_zq_local_league.source', $source->infocontent)->get();
  31. } else {
  32. $data = \App\Models\SoccerLeague::select('id', 'name_chinese')->get();
  33. }
  34. $request['league'] = $data;
  35. $dt = \App\Lib\DataTable\DataTable::init();
  36. $dt->setDataSource('/admin/SportsSoccer/info');
  37. $dt->setLang('sportsbase');
  38. $dt->addColsFields('id', array('templet' => '#userdetail', 'sort' => true, 'width' => 100));
  39. $dt->addColsFields('lg_id', array('templet' => '#userdetail', 'sort' => true, 'width' => 100));
  40. $dt->addColsFields('name_chinese', array('templet' => '#userdetail', 'sort' => false, 'width' => 200));
  41. $dt->addColsFields('home_guest', array('templet' => '#userdetail', 'sort' => false, 'width' => 260));
  42. $dt->addColsFields('match_date', array('templet' => '#userdetail', 'sort' => true, 'width' => 120));
  43. $dt->addColsFields('match_time', array('templet' => '#userdetail', 'sort' => true, 'width' => 100));
  44. $dt->addColsFields('recommend', array('templet' => '#recommend', 'sort' => false, 'width' => 120, 'align' => 'center'));
  45. $dt->addColsFields('status', array('templet' => '#userdetail', 'sort' => false, 'width' => 100));
  46. if (checkRriv('/admin/SportsSoccer/edit')) {
  47. $arr[] = 'edit';
  48. }
  49. if (checkRriv('/admin/SportsSoccer/odds')) {
  50. $arr[] = 'odds';
  51. }
  52. $dt->setToolBar($arr, array('width' => 200));
  53. $dt->enableCheckBox();
  54. return view('sports/soccer_match', $dt->render($request));
  55. }
  56. function info(Req $req)
  57. {
  58. $page = Request::has('page') ? Request::get('page') : '';
  59. $list = Request::has('limit') ? Request::get('limit') : 10;
  60. $name_chinese = Request::has('name_chinese') ? Request::get('name_chinese') : '';
  61. $home_team = Request::has('home_team') ? Request::get('home_team') : '';
  62. $match_date = Request::has('match_date') ? Request::get('match_date') : '';
  63. $star_time = Request::get('star_time') ? Request::get('star_time') : '';
  64. $end_time = Request::get('end_time') ? Request::get('end_time') : '';
  65. $status = Request::has('status') ? Request::get('status') : '';
  66. $sureblur = Request::has('sureblurs') ? Request::get('sureblurs') : 'off';
  67. $where = array();
  68. $orwhere = array();
  69. if (!empty($name_chinese)) {
  70. if (empty($sureblur) || $sureblur == 'off') {
  71. $where[] = array('st_zq_league.name_chinese', 'like', '%' . $name_chinese . '%');
  72. } else {
  73. $where[] = array('st_zq_league.name_chinese', '=', $name_chinese);
  74. }
  75. }
  76. if (!empty($home_team)) {
  77. if (empty($sureblur) || $sureblur == 'off') {
  78. $where[] = array('st_zq_competition.home_team', 'like', '%' . $home_team . '%');
  79. $orwhere[] = array('st_zq_competition.guest_team', 'like', '%' . $home_team . '%');
  80. } else {
  81. $where[] = array('st_zq_competition.home_team', '=', $home_team);
  82. $orwhere[] = array('st_zq_competition.guest_team', '=', $home_team);
  83. }
  84. }
  85. if (!empty($star_time)) {
  86. if (!empty($end_time)) {
  87. $where[] = array('st_zq_competition.match_date', '>=', $star_time);
  88. $where[] = array('st_zq_competition.match_date', '<=', $end_time);
  89. } else {
  90. $where[] = array('st_zq_competition.match_date', '>=', $star_time);
  91. }
  92. } else if (empty($star_time)) {
  93. if (!empty($end_time)) {
  94. $where[] = array('st_zq_competition.match_date', '<=', $end_time);
  95. }
  96. }
  97. if ($status != -1) {
  98. $where[] = array('st_zq_competition.status', '=', $status);
  99. }
  100. $newapp = new \App\Models\SportsSoccer();
  101. $data = $newapp->getinfo($list, $page, $where, $orwhere);
  102. return \App\Lib\DataTable\DataTable::init()->toJson($data['data'], $data['total']);
  103. }
  104. /**
  105. *设置是否为推荐赛事
  106. */
  107. function recommendmatch(Req $req)
  108. {
  109. $id = $req->id;
  110. $recommend = is_numeric($req->recommend) ? intval($req->recommend) : '';
  111. if (empty($id) || !is_numeric($recommend)) {
  112. return responseToJson(-2020100102);
  113. }
  114. $u_db = new \App\Models\SportsSoccer;
  115. $data = array(
  116. 'recommend' => $recommend,
  117. );
  118. $res = $u_db->updateInfos($data, $id);
  119. return responseToJson($res);
  120. }
  121. /**
  122. *获取所有足球联赛信息
  123. */
  124. function getParent()
  125. {
  126. $source = \App\Models\Setinfo::where('id', '1000')->first();
  127. if ($source->infocontent != '混合数据') {
  128. $data = \App\Models\SoccerLeague::join('st_zq_local_league', 'st_zq_league.id', '=', 'st_zq_local_league.lg_id')->select('st_zq_league.id', 'st_zq_league.name_chinese')->where('st_zq_local_league.source', $source->infocontent)->get();
  129. } else {
  130. $data = \App\Models\SoccerLeague::select('id', 'name_chinese')->get();
  131. }
  132. if (!$data) {
  133. return;
  134. }
  135. return $data->toArray();
  136. }
  137. /**
  138. *获取所有国家信息
  139. */
  140. function getCountry()
  141. {
  142. $data = \App\Models\Country::select('country_id', 'name_chinese')->get();
  143. if (!$data) {
  144. return;
  145. }
  146. for ($i = 0; $i < count($data); $i++) {
  147. $data[$i]->home_country_name = $data[$i]->name_chinese;
  148. $data[$i]->home_country_id = $data[$i]->country_id;
  149. $data[$i]->guest_country_name = $data[$i]->name_chinese;
  150. $data[$i]->guest_country_id = $data[$i]->country_id;
  151. }
  152. return $data->toArray();
  153. }
  154. /**
  155. *获取国家的球队信息
  156. */
  157. function getteam()
  158. {
  159. $countryid = $_GET["countryid"];
  160. $gametype = \App\Models\StGameType::where('game_code', 'zq')->first();
  161. $res = \App\Models\Team::where('country_id', $countryid)->where('game_type_id', $gametype->id)->get();
  162. return json_encode($res);
  163. }
  164. /**
  165. *添加赛事
  166. */
  167. function add(Req $req)
  168. {
  169. if (!$req->isMethod('post')) {
  170. $parents = $this->getParent();
  171. $lange = trans('menu');
  172. foreach ($parents as $k => $v) {
  173. $arr = trim($parents[$k]['name_chinese']);
  174. if (isset($lange[$arr])) {
  175. $parents[$k]['name'] = $lange[$arr];
  176. }
  177. }
  178. $data['parents'] = $parents;
  179. return view('sports.soccer_form', $data);
  180. } else {
  181. $model = new \App\Models\SportsSoccer();
  182. $model->home_team = $req->input('home_team');
  183. $model->guest_team = $req->input('guest_team');
  184. $model->lg_id = $req->input('parent_id');
  185. $model->match_date = $req->input('match_date');
  186. $model->match_time = $req->input('match_time');
  187. $model->status = $req->input('status');
  188. if ($req->input('is_rollball') == true) {
  189. $model->is_rollball = 1;
  190. } else {
  191. $model->is_rollball = 0;
  192. }
  193. if ($req->input('is_today') == true) {
  194. $model->is_today = 1;
  195. } else {
  196. $model->is_today = 0;
  197. }
  198. if ($req->input('is_morningplate') == true) {
  199. $model->is_morningplate = 1;
  200. } else {
  201. $model->is_morningplate = 0;
  202. }
  203. if ($req->input('is_stringscene') == true) {
  204. $model->is_stringscene = 1;
  205. } else {
  206. $model->is_stringscene = 0;
  207. }
  208. $model->match_id = time();
  209. $model->ctime = date('Y-m-d H:i:s', time());
  210. $model->utime = date('Y-m-d H:i:s', time());
  211. $model->tag = mt_rand(0, 100);
  212. $model->source = 'user-defined';
  213. $db = new \App\Models\Stzqlocalmatch();
  214. $db->source = 'user-defined';
  215. $db->match_id = $model->match_id;
  216. $model->save();
  217. $db->save();
  218. return responseToJson(1);
  219. }
  220. }
  221. function view(Req $req)
  222. {
  223. return $this->edit($req);
  224. }
  225. /**
  226. *修改赛事
  227. */
  228. function edit(Req $req)
  229. {
  230. $id = $req->id;
  231. if (intval($id) < 1) {
  232. return -1;
  233. }
  234. if (!$req->isMethod('post')) {
  235. // $country = $this->getCountry();
  236. // $countrys = $this->getCountry();
  237. $data = \App\Models\SportsSoccer::where('id', $id)->first();
  238. if (!$data) {
  239. return -2;
  240. }
  241. //查看赛事是否有下注细信息
  242. $res = \App\Models\MoneyBuyMatch::where('match_id', $id)->get()->toArray();
  243. if (!empty($res)) {
  244. if ($data->status == 0) {//有注单的未开始赛事
  245. $match_status = array(['status' => 0, 'name' => '未开始'], ['status' => 1, 'name' => '正在进行'], ['status' => 4, 'name' => '作废']);
  246. }
  247. if ($data->status == 1) {//有注单的已开始赛事
  248. $match_status = array(['status' => 1, 'name' => '正在进行'], ['status' => 2, 'name' => '已结束'], ['status' => 4, 'name' => '作废']);
  249. }
  250. } else {
  251. if ($data->status == 0) {//无注单的未开始赛事
  252. $match_status = array(['status' => 0, 'name' => '未开始'], ['status' => 1, 'name' => '正在进行'], ['status' => 6, 'name' => '取消']);
  253. }
  254. if ($data->status == 1) {//无注单的已开始赛事
  255. $match_status = array(['status' => 1, 'name' => '正在进行'], ['status' => 2, 'name' => '已结束'], ['status' => 4, 'name' => '作废'], ['status' => 6, 'name' => '取消']);
  256. }
  257. }
  258. if ($data->status == 2) {//已结束
  259. $match_status = array(['status' => 2, 'name' => '已结束'], ['status' => 4, 'name' => '作废']);
  260. }
  261. if ($data->status == 3) {//已结算
  262. $match_status = array(['status' => 3, 'name' => '已结算'], ['status' => 5, 'name' => '待结算']);
  263. }
  264. if ($data->status == 4) {//已作废
  265. $match_status = array(['status' => 4, 'name' => '作废'], ['status' => 6, 'name' => '取消']);
  266. }
  267. if ($data->status == 5) {//待结算
  268. $match_status = array(['status' => 0, 'name' => '未开始'], ['status' => 1, 'name' => '正在进行'],['status' => 5, 'name' => '待结算'], ['status' => 4, 'name' => '作废']);
  269. }
  270. if ($data->status == 6) {//已取消
  271. $match_status = array(['status' => 0, 'name' => '未开始'], ['status' => 1, 'name' => '正在进行'], ['status' => 2, 'name' => '已结束'],['status' => 6, 'name' => '取消']);
  272. }
  273. $name_chinese = \App\Models\SoccerLeague::where('id', $data->lg_id)->first();
  274. $data->name_chinese = $name_chinese->name_chinese;
  275. $data = $data->toArray();
  276. $data['parents'] = $this->getParent();
  277. // $data['country'] = $country;
  278. // $data['countrys'] = $countrys;
  279. $data['match_status'] = $match_status;
  280. foreach ($data['parents'] as $k => $v) {
  281. $arr = trim($data['parents'][$k]['name_chinese']);
  282. if (isset($lange[$arr])) {
  283. $data['parents'][$k]['name_chinese'] = $lange[$arr];
  284. }
  285. }
  286. return view('sports.soccer_form', $data);
  287. } else {
  288. $model = new \App\Models\SportsSoccer();
  289. $model->id = $req->input('id');
  290. $model = $model::find($model->id);
  291. $model->home_team = $req->input('home_team');
  292. $model->guest_team = $req->input('guest_team');
  293. // if(gettype($req->input('parent_id'))=='integer'){
  294. // $model->lg_id = $req->input('parent_id');
  295. // }else{
  296. // $model->name_chinese = $req->input('parent_id');
  297. // $res = \App\Model\SportsLeague::where('name_chinese',$model->name_chinese)->first();
  298. // $model->lg_id = $res->lg_id;
  299. // }
  300. $model->lg_id = $req->input('parent_id');
  301. $model->match_date = $req->input('match_date');
  302. $model->match_time = $req->input('match_time');
  303. $model->status = $req->input('status');
  304. if ($req->input('is_rollball') == true) {
  305. $model->is_rollball = 1;
  306. } else {
  307. $model->is_rollball = 0;
  308. }
  309. if ($req->input('is_today') == true) {
  310. $model->is_today = 1;
  311. } else {
  312. $model->is_today = 0;
  313. }
  314. if ($req->input('is_morningplate') == true) {
  315. $model->is_morningplate = 1;
  316. } else {
  317. $model->is_morningplate = 0;
  318. }
  319. if ($req->input('is_stringscene') == true) {
  320. $model->is_stringscene = 1;
  321. } else {
  322. $model->is_stringscene = 0;
  323. }
  324. $model->ctime = date('Y-m-d H:i:s', time());
  325. $model->utime = date('Y-m-d H:i:s', time());
  326. $model->save();
  327. return responseToJson(1);
  328. }
  329. }
  330. /**
  331. *删除赛事
  332. */
  333. public function delete(Req $req)
  334. {
  335. $id = $req->input('id');
  336. if (empty($id)) {
  337. return responseToJson(-2001);
  338. }
  339. $ids = explode(',', $id);
  340. if (!is_array($ids) && intval($ids) < 0) {
  341. return responseToJson(-2002);
  342. }
  343. $id = array();
  344. $localmatch = \App\Models\Stzqlocalmatch::get();
  345. if (is_array($ids) && count($ids) > 0) {
  346. foreach ($ids as $k => $v) {
  347. if (intval($v) < 1) {
  348. unset($ids[$k]);
  349. }
  350. $match = \App\Models\SportsSoccer::where('id', $v)->first();
  351. for ($i = 0; $i < count($localmatch); $i++) {
  352. if ($localmatch[$i]->match_id == $match->match_id) {
  353. $id[] = $localmatch[$i]->id;
  354. }
  355. }
  356. }
  357. }
  358. $rows = \App\Models\SportsSoccer::whereIn('id', $ids)->delete();
  359. if (!$rows) {
  360. return responseToJson(-2003);
  361. }
  362. if (count($id) > 0) {
  363. $row = \App\Models\Stzqlocalmatch::whereIn('id', $id)->delete();
  364. if (!$row) {
  365. return responseToJson(-2003);
  366. }
  367. }
  368. return responseToJson(1, trans('menu.delete_success'));
  369. }
  370. /**
  371. *赛事结果处理
  372. */
  373. public function dealwith(Req $req)
  374. {
  375. $id = $req->id;
  376. if (intval($id) < 1) {
  377. return -1;
  378. }
  379. $SettlementWinFail = new SettlementWinFail();
  380. $data = $SettlementWinFail->doRun($id);
  381. return $data;
  382. }
  383. function odds(Req $req)
  384. {
  385. $cp_id = $req->id;
  386. $request['status'] = isset($req->status) ? trim($req->status) : '-1';
  387. $request['p_code'] = isset($req->p_code) ? trim($req->p_code) : '-1';
  388. $request['id'] = isset($req->id) ? trim($req->id) : null;
  389. $newapp = \App\Models\SportsSoccer::where('id', $request['id'])->first();
  390. if (empty($newapp)) {
  391. $match_id = $req->input('id');
  392. } else {
  393. $match_id = $newapp->id;
  394. }
  395. $request['match_id'] = isset($match_id) ? trim($match_id) : null;
  396. $data = \App\Models\Matchcode::where('p_id', '0')->where('game_code', 'zq')->get();
  397. $request['pcode'] = $data;
  398. $dt = \App\Lib\DataTable\DataTable::init();
  399. $dt->setDataSource('/admin/SportsSoccer/oddsinfo?match_id=' . $match_id . '');
  400. $dt->setLang('sportssoccer');
  401. $dt->addColsFields('id', array('templet' => '#userdetail', 'sort' => true, 'width' => 80));
  402. $dt->addColsFields('match_id', array('templet' => '#userdetail', 'sort' => true, 'width' => 100));
  403. $dt->addColsFields('odds_code_cn', array('templet' => '#userdetail', 'sort' => false, 'width' => 200));
  404. $dt->addColsFields('condition', array('templet' => '#userdetail', 'sort' => false, 'width' => 80));
  405. $dt->addColsFields('odds', array('templet' => '#userdetail', 'sort' => false, 'width' => 80));
  406. $dt->addColsFields('p_code_cn', array('templet' => '#userdetail', 'sort' => false, 'width' => 120));
  407. $dt->addColsFields('max', array('templet' => '#userdetail', 'sort' => false, 'width' => 100));
  408. $dt->addColsFields('min', array('templet' => '#userdetail', 'sort' => false, 'width' => 100));
  409. $dt->addColsFields('status', array('templet' => '#userdetail', 'sort' => false, 'width' => 80));
  410. $dt->addColsFields('expire_time', array('templet' => '#userdetail', 'sort' => false, 'width' => 100));
  411. $dt->addColsFields('source', array('templet' => '#userdetail', 'sort' => false, 'width' => 100));
  412. if (checkRriv('/admin/SportsSoccer/oddsedit?id=' . $cp_id . '')) {
  413. $arr[] = 'oddsedit';
  414. }
  415. $dt->setToolBar($arr, array('width' => 150));
  416. $dt->enableCheckBox();
  417. return view('sports/soccer_odds', $dt->render($request));
  418. }
  419. function oddsinfo(Req $req)
  420. {
  421. $lange = trans('sportsoddscode');
  422. $match_id = $req->match_id;
  423. $p_code = Request::has('p_code') ? Request::get('p_code') : '';
  424. $status = Request::has('status') ? Request::get('status') : '';
  425. $where = array();
  426. if (!empty($p_code) && $p_code != -1) {
  427. $where[] = array('st_zq_odds.p_code', '=', $p_code);
  428. }
  429. if (!empty($status) && $status != -1) {
  430. $where[] = array('st_zq_odds.status', '=', $status);
  431. }
  432. if (intval($match_id) < 1) {
  433. return -1;
  434. }
  435. $new = new \App\Models\SoccerOdds();
  436. $data = $new->getodds($match_id, $where);
  437. foreach ($data as $k => $v) {
  438. $odds_code = trim($data[$k]['odds_code']);
  439. $p_code = trim($data[$k]['p_code']);
  440. if (isset($lange[$odds_code])) {
  441. $data[$k]['odds_code'] = $lange[$odds_code];
  442. }
  443. if (isset($lange[$p_code])) {
  444. $data[$k]['p_code'] = $lange[$p_code];
  445. }
  446. };
  447. return \App\Lib\DataTable\DataTable::init()->toJson($data);
  448. }
  449. /**
  450. *根据选择的父级赔率代码获取对应的子级赔率代码
  451. */
  452. function getoddscode()
  453. {
  454. $p_code = $_GET["pcode"];
  455. $res = \App\Models\Matchcode::where('odds_code', $p_code)->first();
  456. $codedata = \App\Models\Matchcode::where('p_id', $res->id)->get();
  457. return json_encode($codedata);
  458. }
  459. /**
  460. *添加赔率
  461. */
  462. function addodds(Req $req)
  463. {
  464. $pcodedata = \App\Models\Matchcode::where('p_id', '0')->where('game_code', 'zq')->get();
  465. for ($i = 0; $i < count($pcodedata); $i++) {
  466. $pcodedata[$i]->p_code = $pcodedata[$i]->odds_code;
  467. }
  468. if (!$req->isMethod('post')) {
  469. $cp_id = $_SERVER['QUERY_STRING']; //获取url中的参数--赛事id
  470. $data = ["match_id" => $cp_id];
  471. $data['pcode'] = $pcodedata;
  472. return view('sports.soccer_odds_form', $data);
  473. } else {
  474. $model = new \App\Models\SoccerOdds();
  475. $date = new \App\Models\SoccerOddsRecord();
  476. $model->match_id = $req->input('match_id');
  477. $model->odds_code = $req->input('code');
  478. $model->status = $req->input('status');
  479. $model->p_code = $req->input('pcode');
  480. $res = \App\Models\Matchcode::where('odds_code', $model->p_code)->first();
  481. $model->p_id = $res->id;
  482. $result = \App\Models\SoccerOdds::where('odds_code', $model->odds_code)->where('p_id', $model->p_id)->orderby('utime', 'desc')->first();
  483. if (!empty($result)) {
  484. $sort = $result->sort;
  485. $model->sort = $sort + 1;
  486. } else {
  487. $model->sort = 0;
  488. }
  489. $model->odds = $req->input('odds');
  490. $model->condition = $req->input('condition');
  491. $model->max = $req->input('max');
  492. $model->min = $req->input('min');
  493. $model->ctime = date('Y-m-d H:i:s', time());
  494. $model->utime = date('Y-m-d H:i:s', time());
  495. $model->sole = md5($model->match_id . $model->odds_code . $model->sort . $model->p_id . $model->ctime);
  496. $model->source = 'user-defined';
  497. $lg_id = \App\Models\SportsSoccer::where('match_id', $model->match_id)->first();
  498. if (!empty($lg_id)) {
  499. $model->lg_id = $lg_id->lg_id;
  500. }
  501. $model->expire_time = $req->input('expire_time');
  502. $model->odds_only = md5($model->match_id . $model->odds_code . $model->ctime);
  503. $date->match_id = $model->match_id;
  504. $date->odds_code = $model->odds_code;
  505. $date->status = $model->status;
  506. $date->p_code = $model->p_code;
  507. $date->p_id = $model->p_id;
  508. $record = \App\Models\SoccerOddsRecord::where('odds_code', $date->odds_code)->where('p_id', $date->p_id)->orderby('utime', 'desc')->first();
  509. if (!empty($record)) {
  510. $sort = $record->sort;
  511. $date->sort = $sort + 1;
  512. } else {
  513. $date->sort = 0;
  514. }
  515. $date->odds = $model->odds;
  516. $date->condition = $model->condition;
  517. $date->max = $model->max;
  518. $date->min = $model->min;
  519. $date->ctime = $model->ctime;
  520. $date->utime = $model->utime;
  521. $date->source = $model->source;
  522. $date->lg_id = $model->lg_id;
  523. $date->odds_only = $model->odds_only;
  524. $model->save();
  525. $date->save();
  526. return responseToJson(1);
  527. }
  528. }
  529. /**
  530. *修改赔率
  531. */
  532. function oddsedit(Req $req)
  533. {
  534. $lange = trans('sportsoddscode');
  535. $pcodedata = \App\Models\Matchcode::where('p_id', '0')->where('game_code', 'zq')->get();
  536. for ($i = 0; $i < count($pcodedata); $i++) {
  537. $pcodedata[$i]->p_code = $pcodedata[$i]->odds_code;
  538. }
  539. $id = $req->id;
  540. if (intval($id) < 1) {
  541. return -1;
  542. }
  543. if (!$req->isMethod('post')) {
  544. $data = \App\Models\SoccerOdds::where('id', $id)->first();
  545. if (!$data) {
  546. return -2;
  547. }
  548. //$res = \App\Model\Matchcode::where('odds_code', $data->odds_code)->where('game_type','zq')->first();
  549. $res = \App\Models\Matchcode::where('odds_code', $data->odds_code)->first();
  550. if (!empty($res)) {
  551. $data->odds_name = $res->odds_name;
  552. }
  553. // $res = \App\Model\Matchcode::where('odds_code', $data->odds_code)->first();
  554. // if(!empty($res)){
  555. // $data->odds_code = $res->odds_name;
  556. // }
  557. // $res1 = \App\Model\Matchcode::where('odds_code', $data->p_code)->first();
  558. // if(!empty($res)){
  559. // $data->p_code = $res1->odds_name;
  560. // }
  561. $expire_time = $data->expire_time; //2019-04-15 21:10:00
  562. $str1 = str_replace(" ", "T", $expire_time);
  563. $data->expire_time = $str1;
  564. // $odds_code = trim($data->odds_code);
  565. // $p_code = trim($data->p_code);
  566. // if (isset($lange[$odds_code])) {
  567. // $data->odds_code_cn=$lange[$odds_code];
  568. // }
  569. // if (isset($lange[$p_code])) {
  570. // $data->p_code_cn=$lange[$p_code];
  571. // }
  572. // if (isset($lange[$odds_code])) {
  573. // $data->odds_code=$lange[$odds_code];
  574. // }
  575. // if (isset($lange[$p_code])) {
  576. // $data->p_code=$lange[$p_code];
  577. // }
  578. $data = $data->toArray();
  579. $data['pcode'] = $pcodedata;
  580. return view('sports.soccer_odds_form', $data);
  581. } else {
  582. $model = new \App\Models\SoccerOdds();
  583. $data = new \App\Models\SoccerOddsRecord();
  584. $model->id = $req->input('id');
  585. $model = $model::find($model->id);
  586. $model->status = $req->input('status');
  587. $model->odds = $req->input('odds');
  588. $model->condition = $req->input('condition');
  589. $model->max = $req->input('max');
  590. $model->min = $req->input('min');
  591. $model->ctime = date('Y-m-d H:i:s', time());
  592. $model->utime = date('Y-m-d H:i:s', time());
  593. $model->expire_time = $req->input('expire_time');
  594. $model->odds_only = md5($model->match_id . $model->odds_code . $model->ctime);
  595. $result = \App\Models\SoccerOdds::where('id', $model->id)->first();
  596. $data->match_id = $result->match_id;
  597. $data->status = $model->status;
  598. $data->p_id = $result->p_id;
  599. $record = \App\Models\SoccerOddsRecord::where('match_id', $data->match_id)->where('odds_code', $result->odds_code)->where('p_id', $result->p_id)->orderby('utime', 'desc')->first();
  600. if (!empty($record)) {
  601. $sort = $record->sort;
  602. $data->sort = $sort + 1;
  603. } else {
  604. $data->sort = 0;
  605. }
  606. $data->odds = $model->odds;
  607. $data->condition = $model->condition;
  608. $data->max = $model->max;
  609. $data->min = $model->min;
  610. $data->ctime = $model->ctime;
  611. $data->utime = $model->utime;
  612. $data->source = $result->source;
  613. $data->lg_id = $result->lg_id;
  614. $data->odds_only = $result->odds_only;
  615. $model->save();
  616. $data->save();
  617. return responseToJson(1);
  618. }
  619. }
  620. /**
  621. *删除赔率
  622. */
  623. public function oddsdelete(Req $req)
  624. {
  625. $id = $req->input('id');
  626. if (empty($id)) {
  627. return responseToJson(-2001);
  628. }
  629. $ids = explode(',', $id);
  630. if (!is_array($ids) && intval($ids) < 0) {
  631. return responseToJson(-2002);
  632. }
  633. if (is_array($ids) && count($ids) > 0) {
  634. foreach ($ids as $k => $v) {
  635. if (intval($v) < 1) {
  636. unset($ids[$k]);
  637. }
  638. }
  639. }
  640. $rows = \App\Models\SoccerOdds::whereIn('id', $ids)->delete();
  641. if (!$rows) {
  642. return responseToJson(-2003);
  643. }
  644. return responseToJson(1, trans('menu.delete_success'));
  645. }
  646. }