SportsNoteList.php 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463
  1. <?php
  2. /**
  3. * Created by PhpStorm.
  4. * User: Jonlin
  5. * Date: 2019/4/9
  6. * Time: 9:18
  7. */
  8. namespace App\Models;
  9. use Illuminate\Support\Facades\DB;
  10. class SportsNoteList extends BaseModel {
  11. protected $table = "money_buy_simplex";
  12. public $timestamps = false;
  13. function getinfo($list = 10, $page, $where = '',$type)
  14. {
  15. $data = $this
  16. ->join('money_details','money_details.info_identity','=','money_buy_simplex.info_identity')
  17. ->join('st_'.$type.'_competition','st_'.$type.'_competition.id','=','money_buy_simplex.match_id')
  18. ->join('st_'.$type.'_league','st_'.$type.'_competition.lg_id','=','st_'.$type.'_league.id')
  19. ->select('money_buy_simplex.id','money_buy_simplex.account_name','money_buy_simplex.account_identity','money_buy_simplex.order_id','money_buy_simplex.money','money_buy_simplex.prize_money','money_buy_simplex.status','money_buy_simplex.money_time','money_buy_simplex.settle_status','money_buy_simplex.gain_money','money_buy_simplex.game_code','money_buy_simplex.match_id','money_buy_simplex.game_status','st_'.$type.'_competition.home_team','st_'.$type.'_competition.guest_team','st_'.$type.'_competition.match_date','st_'.$type.'_competition.match_time','st_'.$type.'_competition.lg_id','st_'.$type.'_competition.status as match_status','money_details.money_cash','money_buy_simplex.batch_id','st_'.$type.'_league.name_chinese','st_'.$type.'_league.last_time')
  20. ->where($where)
  21. ->orderby('money_buy_simplex.money_time','desc')
  22. ->paginate ($list);
  23. if (!$data < 0) {
  24. return -2021052003; //
  25. }
  26. //反水
  27. $water_return_money = \App\Models\Money_details::where('trade_type','7')->get();
  28. //注单作废
  29. $invalid_money = \App\Models\Money_details::where('trade_type','3')->get();
  30. //订单投注的玩法
  31. $content = \App\Models\MoneyBuyMatch::where('bet_type','1')->get();
  32. for($d=0;$d<count($content);$d++){
  33. if($content[$d]->result==0){
  34. $content[$d]->result = '未处理';
  35. }
  36. if($content[$d]->result==1){
  37. $content[$d]->result = '赢';
  38. }
  39. if($content[$d]->result==-1){
  40. $content[$d]->result = '输';
  41. }
  42. if($content[$d]->result==2){
  43. $content[$d]->result = '平';
  44. }
  45. if($content[$d]->result==3){
  46. $content[$d]->result = '赢半平半';
  47. }
  48. if($content[$d]->result==4){
  49. $content[$d]->result = '输半平半';
  50. }
  51. }
  52. //玩法
  53. $result = \App\Models\Matchcode::where('game_code','zq')->get();
  54. //$result = \App\Model\Matchcode::get();
  55. for($i=0;$i<count($data);$i++){
  56. // if($data[$i]->status==1 && $data[$i]->game_status==0){
  57. // $data[$i]->order_status = '投注'.'<br>;<a class="layui-btn layui-btn-sm invalid" lay-event="detail" pid="id" uri="/admin/SoccerNoteList/invalid/?id=" href="javascript:invalid(\'/admin/SoccerNoteList/invalid/?id='.$data[$i]->id.'\');"> 作废 </a>';
  58. // }else
  59. if($data[$i]->status==1 && $data[$i]->game_status==0){
  60. $data[$i]->order_status = '投注';
  61. }else if($data[$i]->status==2){
  62. $data[$i]->order_status = '作废';//.'<br><a class="layui-btn layui-btn-sm audit" lay-event="detail" pid="id" uri="" href="javascript:void(0)" style="background-color: grey;"> 已作废 </a>';
  63. }else if($data[$i]->status==3){
  64. $data[$i]->order_status = '撤单';//.'<br><a class="layui-btn layui-btn-sm audit" lay-event="detail" pid="id" uri="" href="javascript:void(0)" style="background-color: grey;"> 已撤单 </a>';
  65. }
  66. if($data[$i]->settle_status==1){
  67. $data[$i]->settle_status = '未结算';
  68. }else if($data[$i]->settle_status==2){
  69. $data[$i]->settle_status = '已结算';
  70. }
  71. if($data[$i]->game_status==0){
  72. $data[$i]->game_status = '未处理';
  73. }else{
  74. $data[$i]->game_status = '已处理';
  75. }
  76. if($data[$i]->game_code == 'zq'){
  77. $data[$i]->match_id_order = '<a href="/admin/sportsfoot/outcome?home_team='.$data[$i]->match_id.'">'.$data[$i]->match_id.'</a> (<span>'.$data[$i]->account_name.'</span>)<br>'.$data[$i]->order_id;
  78. }
  79. if($data[$i]->game_code == 'lq'){
  80. $data[$i]->match_id_order = '<a href="/admin/Sportsbk/outcome?home_team='.$data[$i]->match_id.'">'.$data[$i]->match_id.'</a> (<span>'.$data[$i]->account_name.'</span>)<br>'.$data[$i]->order_id;
  81. }
  82. if($data[$i]->game_code == 'wq'){
  83. $data[$i]->match_id_order = '<a href="/admin/Sportswq/outcome?home_team='.$data[$i]->match_id.'">'.$data[$i]->match_id.'</a> (<span>'.$data[$i]->account_name.'</span>)<br>'.$data[$i]->order_id;
  84. }
  85. if($data[$i]->game_code == 'bq'){
  86. $data[$i]->match_id_order = '<a href="/admin/Sportsbq/outcome?home_team='.$data[$i]->match_id.'">'.$data[$i]->match_id.'</a> (<span>'.$data[$i]->account_name.'</span>)<br>'.$data[$i]->order_id;
  87. }
  88. $data[$i]->league = $data[$i]->name_chinese;
  89. $data[$i]->home_guest = $data[$i]->home_team.' VS '.$data[$i]->guest_team;
  90. $data[$i]->time = '开赛:'.$data[$i]->match_date.' '.$data[$i]->match_time;
  91. $data[$i]->money_match_time = '下注:'.$data[$i]->money_time.'<br>'.$data[$i]->time;
  92. //反水
  93. $data[$i]->water_return = -1;
  94. for($a=0;$a<count($water_return_money);$a++){
  95. if($data[$i]->order_id == $water_return_money[$a]->trade_id){
  96. if($data[$i]->status == 2 || $data[$i]->status == 3){
  97. $data[$i]->water_return = 0;
  98. }else{
  99. $data[$i]->water_return = $water_return_money[$a]->money;
  100. }
  101. //用户投注后账户金额
  102. $data[$i]->frozen_cash = $water_return_money[$a]->money_cash;
  103. }
  104. }
  105. if($data[$i]->water_return == -1){
  106. $data[$i]->water_return = 0;
  107. //用户投注后账户金额
  108. $data[$i]->frozen_cash = $data[$i]->money_cash;
  109. }
  110. //此时结果金额
  111. $data[$i]->result = $data[$i]->water_return+$data[$i]->gain_money;
  112. //用户投注前账户金额
  113. $data[$i]->available_cash = $data[$i]->money_cash+$data[$i]->money;
  114. //投注前后账户金额
  115. $data[$i]->account_money = $data[$i]->available_cash.'<br><span>'.$data[$i]->money.'</span><br>'.$data[$i]->frozen_cash;
  116. if($data[$i]->status == 2 || $data[$i]->status == 3){
  117. for($b=0;$b<count($invalid_money);$b++){
  118. if($data[$i]->order_id == $invalid_money[$b]->trade_id){
  119. $data[$i]->available_cash = $invalid_money[$b]->money_cash;
  120. $data[$i]->account_money = $data[$i]->available_cash;
  121. }
  122. }
  123. }
  124. $data[$i]->str = 0;
  125. for($b=0;$b<count($content);$b++){
  126. $data[$i]->str1 = 0;
  127. $data[$i]->team = '';
  128. if(!empty($content[$b]->odds_code)){
  129. if(!empty(stristr($content[$b]->odds_code,'home'))){
  130. $data[$i]->team = $data[$i]->home_team;
  131. }
  132. if(!empty(stristr($content[$b]->odds_code,'guest'))){
  133. $data[$i]->team = $data[$i]->guest_team;
  134. }
  135. if($content[$b]->p_code == 'half_full'){
  136. $string = str_replace('home',$data[$i]->home_team,$content[$b]->odds_code);
  137. $string = str_replace('guest',$data[$i]->guest_team,$string);
  138. $string = str_replace('dogfall','和局',$string);
  139. $string = explode('_',$string);
  140. $data[$i]->team = $string['2'].'/'.$string['3'];
  141. }
  142. }
  143. if($data[$i]->match_id == $content[$b]->match_id && $data[$i]->batch_id == $content[$b]->batch_id){
  144. if($content[$b]->p_code == 'first_last_ball' || $content[$b]->p_code == 'half_full' || $content[$b]->p_code == 'capot' || $content[$b]->p_code == 'two_sides' || $content[$b]->p_code == 'total_goal'){
  145. $content[$b]->condition = '';
  146. }
  147. $data[$i]->game_status = $data[$i]->game_status;
  148. //投注详情
  149. if(!empty($data[$i]->match_time)){
  150. $data[$i]->content1 = '['.$data[$i]->match_time.']';
  151. //$data[$i]->match_time = $data[$i]->match_time;
  152. }else{
  153. if(!empty($data[$i]->last_time)){
  154. $datetime = explode(' ',$data[$i]->last_time);
  155. //$data[$i]->match_time = $datetime[1];
  156. $data[$i]->content1 = '['.$datetime[1].']';
  157. }
  158. }
  159. for($c=0;$c<count($result);$c++){
  160. if($content[$b]->odds_code == $result[$c]->odds_code){
  161. $data[$i]->str1 = 1;
  162. if($content[$b]->result=='未处理'){
  163. $data[$i]->content = $data[$i]->content.$result[$c]->odds_name.'<br>'.$content[$b]->condition.' '.$data[$i]->team.'@'.$content[$b]->odds.' ¥'.$content[$b]->bet_money.'<br>';
  164. }else{
  165. $data[$i]->content = $data[$i]->content.$result[$c]->odds_name.'<br>'.$content[$b]->condition.' '.$data[$i]->team.'@'.$content[$b]->odds.' ¥'.$content[$b]->bet_money.'<br><span>'.$content[$b]->result.'</span>('.$content[$b]->matchresult.')<br>';
  166. }
  167. }
  168. }
  169. if($data[$i]->str1 == 0){
  170. if($content[$b]->result=='未处理'){
  171. $data[$i]->content = $data[$i]->content.$content[$b]->odds_code.'<br>'.$content[$b]->condition.' '.$data[$i]->team.'@'.$content[$b]->odds.' ¥'.$content[$b]->bet_money.'<br>';
  172. }else{
  173. $data[$i]->content = $data[$i]->content.$content[$b]->odds_code.'<br>'.$content[$b]->condition.' '.$data[$i]->team.'@'.$content[$b]->odds.' ¥'.$content[$b]->bet_money.'<br><span>'.$content[$b]->result.'</span>('.$content[$b]->matchresult.')<br>';
  174. }
  175. }
  176. }
  177. }
  178. // if($data[$i]->status == 1){
  179. // if($data[$i]->match_status == 0 || $data[$i]->match_status == 1){
  180. // $data[$i]->game_status = $data[$i]->settle_status.'<br><a class="layui-btn layui-btn-sm audit" lay-event="detail" pid="id" uri="" href="javascript:void(0)" style="background-color: grey;"> 结算 </a>';
  181. // }
  182. // if($data[$i]->match_status == 2 || $data[$i]->match_status == 3 || $data[$i]->match_status == 5){
  183. // if($data[$i]->settle_status == '已结算'){
  184. // $data[$i]->game_status = $data[$i]->settle_status.'<br><a class="layui-btn layui-btn-sm resettlement" lay-event="detail" pid="id" uri="/admin/SoccerNoteList/resettlement/?id=" href="javascript:resettlement(\'/admin/SoccerNoteList/resettlement/?id='.$data[$i]->id.'\');"> 重新结算 </a>';
  185. // }else{
  186. // $data[$i]->game_status = $data[$i]->settle_status.'<br><a class="layui-btn layui-btn-sm settlement" lay-event="detail" pid="id" uri="/admin/SoccerNoteList/settlement/?id=" href="javascript:settlement(\'/admin/SoccerNoteList/settlement/?id='.$data[$i]->id.'\');"> 结算 </a>';
  187. // }
  188. // }
  189. // }else{
  190. // $data[$i]->game_status = $data[$i]->settle_status.'<br><a class="layui-btn layui-btn-sm audit" lay-event="detail" pid="id" uri="" href="javascript:void(0)" style="background-color: grey;"> 结2算 </a>';
  191. // }
  192. $data[$i]->content = $data[$i]->content1.$data[$i]->content;
  193. }
  194. return $data->toArray();
  195. }
  196. //投注金额汇总统计
  197. function MoneyCount($where = '',$type) {
  198. $data = array();
  199. // $data['all_money'] = $this->sum('money');
  200. // $data['all_prize_money'] = $this->sum('prize_money');
  201. // $data['alraedy_prize_money'] = $this->where('settle_status','2')->sum('gain_money');
  202. $data['all_money'] = 0;
  203. $data['all_prize_money'] = 0;
  204. $data['alraedy_prize_money'] = 0;
  205. $all_money = $this->join('money_details','money_details.info_identity','=','money_buy_simplex.info_identity')->join('st_'.$type.'_competition','st_'.$type.'_competition.id','=','money_buy_simplex.match_id')->join('st_'.$type.'_league','st_'.$type.'_competition.lg_id','=','st_'.$type.'_league.id')->select('money_buy_simplex.money','money_buy_simplex.prize_money','money_buy_simplex.gain_money')->where('money_buy_simplex.status','1')->get();
  206. for($a=0;$a<count($all_money);$a++){
  207. $data['all_money'] = $data['all_money']+$all_money[$a]->money;
  208. }
  209. $all_prize_money = $this->join('money_details','money_details.info_identity','=','money_buy_simplex.info_identity')->join('st_'.$type.'_competition','st_'.$type.'_competition.id','=','money_buy_simplex.match_id')->join('st_'.$type.'_league','st_'.$type.'_competition.lg_id','=','st_'.$type.'_league.id')->select('money_buy_simplex.money','money_buy_simplex.prize_money','money_buy_simplex.gain_money')->where('money_buy_simplex.status','1')->get();
  210. for($a=0;$a<count($all_prize_money);$a++){
  211. $data['all_prize_money'] = $data['all_money']+$all_prize_money[$a]->prize_money;
  212. }
  213. $alraedy_prize_money = $this->join('money_details','money_details.info_identity','=','money_buy_simplex.info_identity')->join('st_'.$type.'_competition','st_'.$type.'_competition.id','=','money_buy_simplex.match_id')->join('st_'.$type.'_league','st_'.$type.'_competition.lg_id','=','st_'.$type.'_league.id')->select('money_buy_simplex.money','money_buy_simplex.prize_money','money_buy_simplex.gain_money')->where('money_buy_simplex.settle_status','2')->where('money_buy_simplex.status','1')->get();
  214. for($a=0;$a<count($alraedy_prize_money);$a++){
  215. $data['alraedy_prize_money'] = $data['all_money']+$alraedy_prize_money[$a]->gain_money;
  216. }
  217. if (!empty($where) && is_array($where)) {
  218. $data['all_money'] = 0;
  219. $data['all_prize_money'] = 0;
  220. $data['alraedy_prize_money'] = 0;
  221. //$data['all_money'] = $this->where($where)->sum('money');
  222. // $data['all_prize_money'] = $this->where($where)->sum('prize_money');
  223. // $data['alraedy_prize_money'] = $this->where($where)->where('settle_status','2')->sum('gain_money');
  224. $all_money = $this->join('money_details','money_details.info_identity','=','money_buy_simplex.info_identity')->join('st_zq_competition','st_zq_competition.id','=','money_buy_simplex.match_id')->join('st_zq_league','st_zq_competition.lg_id','=','st_zq_league.id')->select('money_buy_simplex.money','money_buy_simplex.prize_money','money_buy_simplex.gain_money')->where($where)->where('money_buy_simplex.status','1')->get();
  225. for($a=0;$a<count($all_money);$a++){
  226. $data['all_money'] = $data['all_money']+$all_money[$a]->money;
  227. }
  228. $all_prize_money = $this->join('money_details','money_details.info_identity','=','money_buy_simplex.info_identity')->join('st_'.$type.'_competition','st_'.$type.'_competition.id','=','money_buy_simplex.match_id')->join('st_'.$type.'_league','st_'.$type.'_competition.lg_id','=','st_'.$type.'_league.id')->select('money_buy_simplex.money','money_buy_simplex.prize_money','money_buy_simplex.gain_money')->where($where)->where('money_buy_simplex.status','1')->get();
  229. for($a=0;$a<count($all_prize_money);$a++){
  230. $data['all_prize_money'] = $data['all_prize_money']+$all_prize_money[$a]->prize_money;
  231. }
  232. $alraedy_prize_money = $this->join('money_details','money_details.info_identity','=','money_buy_simplex.info_identity')->join('st_'.$type.'_competition','st_'.$type.'_competition.id','=','money_buy_simplex.match_id')->join('st_'.$type.'_league','st_'.$type.'_competition.lg_id','=','st_'.$type.'_league.id')->select('money_buy_simplex.money','money_buy_simplex.prize_money','money_buy_simplex.gain_money')->where('money_buy_simplex.settle_status','2')->where($where)->where('money_buy_simplex.status','1')->get();
  233. for($a=0;$a<count($alraedy_prize_money);$a++){
  234. $data['alraedy_prize_money'] = $data['alraedy_prize_money']+$alraedy_prize_money[$a]->gain_money;
  235. }
  236. }
  237. return $data;
  238. }
  239. //修改赛事下的所有单式下注 3199308
  240. function updatesimplex($ssid,$code){
  241. $newapp = new \App\Models\MoneyBuyMatch();
  242. $data = $newapp->allsimplexorder($ssid,$code);
  243. if($data){
  244. for ($i=0; $i < count($data); $i++) {
  245. $the = array(
  246. 'status' => 2,
  247. 'game_status' => 3,
  248. 'game_code' =>$code,
  249. );
  250. $res = $this->where('order_id',$data[$i]['order_id'])->update($the);
  251. }
  252. if($res<0){
  253. return -7012000302; //操作失败
  254. }
  255. return $res;
  256. }else{
  257. return -111;
  258. }
  259. }
  260. function info($list = 10, $page, $where = '',$type)
  261. {
  262. $data = $this
  263. ->join('money_details','money_details.info_identity','=','money_buy_simplex.info_identity')
  264. ->join('st_'.$type.'_competition','st_'.$type.'_competition.id','=','money_buy_simplex.match_id')
  265. ->join('st_'.$type.'_league','st_'.$type.'_competition.lg_id','=','st_'.$type.'_league.id')
  266. ->select('money_buy_simplex.id','money_buy_simplex.account_name','money_buy_simplex.account_identity','money_buy_simplex.order_id','money_buy_simplex.money','money_buy_simplex.prize_money','money_buy_simplex.status','money_buy_simplex.money_time','money_buy_simplex.settle_status','money_buy_simplex.gain_money','money_buy_simplex.game_code','money_buy_simplex.match_id','money_buy_simplex.game_status','st_'.$type.'_competition.home_team','st_'.$type.'_competition.guest_team','st_'.$type.'_competition.match_date','st_'.$type.'_competition.match_time','st_'.$type.'_competition.lg_id','st_'.$type.'_competition.status as match_status','money_details.money_cash','money_buy_simplex.batch_id','st_'.$type.'_league.name_chinese','st_'.$type.'_league.last_time')
  267. ->where($where)
  268. ->orderby('money_buy_simplex.money_time','desc')
  269. ->paginate ($list);
  270. if (!$data < 0) {
  271. return -2021052003; //
  272. }
  273. //反水
  274. $water_return_money = \App\Models\Money_details::where('trade_type','7')->get();
  275. //注单作废
  276. $invalid_money = \App\Models\Money_details::where('trade_type','3')->get();
  277. //订单投注的玩法
  278. $content = \App\Models\MoneyBuyMatch::where('bet_type','1')->get();
  279. for($d=0;$d<count($content);$d++){
  280. if($content[$d]->result==0){
  281. $content[$d]->result = '未处理';
  282. }
  283. if($content[$d]->result==1){
  284. $content[$d]->result = '赢';
  285. }
  286. if($content[$d]->result==-1){
  287. $content[$d]->result = '输';
  288. }
  289. if($content[$d]->result==2){
  290. $content[$d]->result = '平';
  291. }
  292. if($content[$d]->result==3){
  293. $content[$d]->result = '赢半平半';
  294. }
  295. if($content[$d]->result==4){
  296. $content[$d]->result = '输半平半';
  297. }
  298. }
  299. //玩法
  300. $result = \App\Models\Matchcode::where('game_code','zq')->get();
  301. //$result = \App\Model\Matchcode::get();
  302. for($i=0;$i<count($data);$i++){
  303. if($data[$i]->status==1 && $data[$i]->game_status==0){
  304. $data[$i]->order_status = '投注'.'<br><a class="layui-btn layui-btn-sm invalid" lay-event="detail" pid="id" uri="/admin/SoccerNoteList/invalid/?id=" href="javascript:invalid(\'/admin/SoccerNoteList/invalid/?id='.$data[$i]->id.'\');"> 作废 </a>';
  305. }else if($data[$i]->status==1 && $data[$i]->game_status!=0){
  306. $data[$i]->order_status = '投注';
  307. }else if($data[$i]->status==2){
  308. $data[$i]->order_status = '作废';
  309. }else if($data[$i]->status==3){
  310. $data[$i]->order_status = '撤单';
  311. }
  312. // if($data[$i]->settle_status==1){
  313. // $data[$i]->settle_status = '未结算';
  314. // }else if($data[$i]->settle_status==2){
  315. // $data[$i]->settle_status = '已结算';
  316. // }
  317. if($data[$i]->game_status==0){
  318. $data[$i]->game_status = '未处理';
  319. }else{
  320. $data[$i]->game_status = '已处理';
  321. }
  322. if($data[$i]->game_code == 'zq'){
  323. $data[$i]->match_id_order = '<a href="/admin/sportsfoot/outcome?home_team='.$data[$i]->match_id.'">'.$data[$i]->match_id.'</a> (<span>'.$data[$i]->account_name.'</span>)<br>'.$data[$i]->order_id;
  324. }
  325. if($data[$i]->game_code == 'lq'){
  326. $data[$i]->match_id_order = '<a href="/admin/Sportsbk/outcome?home_team='.$data[$i]->match_id.'">'.$data[$i]->match_id.'</a> (<span>'.$data[$i]->account_name.'</span>)<br>'.$data[$i]->order_id;
  327. }
  328. if($data[$i]->game_code == 'wq'){
  329. $data[$i]->match_id_order = '<a href="/admin/Sportswq/outcome?home_team='.$data[$i]->match_id.'">'.$data[$i]->match_id.'</a> (<span>'.$data[$i]->account_name.'</span>)<br>'.$data[$i]->order_id;
  330. }
  331. if($data[$i]->game_code == 'bq'){
  332. $data[$i]->match_id_order = '<a href="/admin/Sportsbq/outcome?home_team='.$data[$i]->match_id.'">'.$data[$i]->match_id.'</a> (<span>'.$data[$i]->account_name.'</span>)<br>'.$data[$i]->order_id;
  333. }
  334. $data[$i]->league = $data[$i]->name_chinese;
  335. $data[$i]->home_guest = $data[$i]->home_team.' VS '.$data[$i]->guest_team;
  336. $data[$i]->time = '开赛:'.$data[$i]->match_date.' '.$data[$i]->match_time;
  337. $data[$i]->money_match_time = '下注:'.$data[$i]->money_time.'<br>'.$data[$i]->time;
  338. //反水
  339. $data[$i]->water_return = -1;
  340. for($a=0;$a<count($water_return_money);$a++){
  341. if($data[$i]->order_id == $water_return_money[$a]->trade_id){
  342. if($data[$i]->status == 2 || $data[$i]->status == 3){
  343. $data[$i]->water_return = 0;
  344. }else{
  345. $data[$i]->water_return = $water_return_money[$a]->money;
  346. }
  347. //用户投注后账户金额
  348. $data[$i]->frozen_cash = $water_return_money[$a]->money_cash;
  349. }
  350. }
  351. if($data[$i]->water_return == -1){
  352. $data[$i]->water_return = 0;
  353. //用户投注后账户金额
  354. $data[$i]->frozen_cash = $data[$i]->money_cash;
  355. }
  356. //此时结果金额
  357. $data[$i]->result = $data[$i]->water_return+$data[$i]->gain_money;
  358. //用户投注前账户金额
  359. $data[$i]->available_cash = $data[$i]->money_cash+$data[$i]->money;
  360. //投注前后账户金额
  361. $data[$i]->account_money = $data[$i]->available_cash.'<br><span>'.$data[$i]->money.'</span><br>'.$data[$i]->frozen_cash;
  362. if($data[$i]->status == 2 || $data[$i]->status == 3){
  363. for($b=0;$b<count($invalid_money);$b++){
  364. if($data[$i]->order_id == $invalid_money[$b]->trade_id){
  365. $data[$i]->available_cash = $invalid_money[$b]->money_cash;
  366. $data[$i]->account_money = $data[$i]->available_cash;
  367. }
  368. }
  369. }
  370. $data[$i]->str = 0;
  371. for($b=0;$b<count($content);$b++){
  372. $data[$i]->str1 = 0;
  373. $data[$i]->team = '';
  374. if(!empty($content[$b]->odds_code)){
  375. if(!empty(stristr($content[$b]->odds_code,'home'))){
  376. $data[$i]->team = $data[$i]->home_team;
  377. }
  378. if(!empty(stristr($content[$b]->odds_code,'guest'))){
  379. $data[$i]->team = $data[$i]->guest_team;
  380. }
  381. if($content[$b]->p_code == 'half_full'){
  382. $string = str_replace('home',$data[$i]->home_team,$content[$b]->odds_code);
  383. $string = str_replace('guest',$data[$i]->guest_team,$string);
  384. $string = str_replace('dogfall','和局',$string);
  385. $string = explode('_',$string);
  386. $data[$i]->team = $string['2'].'/'.$string['3'];
  387. }
  388. }
  389. if($data[$i]->match_id == $content[$b]->match_id && $data[$i]->batch_id == $content[$b]->batch_id){
  390. if($content[$b]->p_code == 'first_last_ball' || $content[$b]->p_code == 'half_full' || $content[$b]->p_code == 'capot' || $content[$b]->p_code == 'two_sides' || $content[$b]->p_code == 'total_goal'){
  391. $content[$b]->condition = '';
  392. }
  393. $data[$i]->game_status = $data[$i]->game_status;
  394. //投注详情
  395. if(!empty($data[$i]->match_time)){
  396. $data[$i]->content1 = '['.$data[$i]->match_time.']';
  397. //$data[$i]->match_time = $data[$i]->match_time;
  398. }else{
  399. if(!empty($data[$i]->last_time)){
  400. $datetime = explode(' ',$data[$i]->last_time);
  401. //$data[$i]->match_time = $datetime[1];
  402. $data[$i]->content1 = '['.$datetime[1].']';
  403. }
  404. }
  405. for($c=0;$c<count($result);$c++){
  406. if($content[$b]->odds_code == $result[$c]->odds_code){
  407. $data[$i]->str1 = 1;
  408. if($content[$b]->result=='未处理'){
  409. $data[$i]->content = $data[$i]->content.$result[$c]->odds_name.'<br>'.$content[$b]->condition.' '.$data[$i]->team.'@'.$content[$b]->odds.' ¥'.$content[$b]->bet_money.'<br>';
  410. }else{
  411. $data[$i]->content = $data[$i]->content.$result[$c]->odds_name.'<br>'.$content[$b]->condition.' '.$data[$i]->team.'@'.$content[$b]->odds.' ¥'.$content[$b]->bet_money.'<br><span>'.$content[$b]->result.'</span>('.$content[$b]->matchresult.')<br>';
  412. }
  413. }
  414. }
  415. if($data[$i]->str1 == 0){
  416. if($content[$b]->result=='未处理'){
  417. $data[$i]->content = $data[$i]->content.$content[$b]->odds_code.'<br>'.$content[$b]->condition.' '.$data[$i]->team.'@'.$content[$b]->odds.' ¥'.$content[$b]->bet_money.'<br>';
  418. }else{
  419. $data[$i]->content = $data[$i]->content.$content[$b]->odds_code.'<br>'.$content[$b]->condition.' '.$data[$i]->team.'@'.$content[$b]->odds.' ¥'.$content[$b]->bet_money.'<br><span>'.$content[$b]->result.'</span>('.$content[$b]->matchresult.')<br>';
  420. }
  421. }
  422. }
  423. }
  424. $data[$i]->game_status = $data[$i]->settle_status;
  425. $data[$i]->content = $data[$i]->content1.$data[$i]->content;
  426. }
  427. return $data->toArray();
  428. }
  429. }