SportsNoteList.php 28 KB

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