sports_admin/app/Models/SportsNoteList.php

<?php
/**
 * Created by PhpStorm.
 * User: Jonlin
 * Date: 2019/4/9
 * Time: 9:18
 */
namespace App\Models;
use Illuminate\Support\Facades\DB;
class SportsNoteList extends BaseModel {
    protected $table = "money_buy_simplex";
    public $timestamps = false;

    function getinfo($list = 10, $page, $where = '',$type)
    {
        $data = $this
            ->join('money_details','money_details.info_identity','=','money_buy_simplex.info_identity')
            ->join('st_'.$type.'_competition','st_'.$type.'_competition.match_id','=','money_buy_simplex.match_id')
            ->join('st_'.$type.'_league','st_'.$type.'_competition.lg_id','=','st_'.$type.'_league.lg_id')
            ->select('money_buy_simplex.id','money_buy_simplex.account_name','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','money_details.money_cash','money_buy_simplex.batch_id','st_'.$type.'_league.name_chinese')
            ->where($where)
            ->orderby('money_buy_simplex.money_time','desc')
            ->paginate ($list);
        if (!$data < 0) {
            return -2021052003; //
        }

        //反水
        $water_return_money = \App\Models\Money_details::where('trade_type','7')->get();

        //订单投注的玩法
        $content = \App\Models\MoneyBuyMatch::where('bet_type','1')->get();


        for($i=0;$i<count($data);$i++){
            if($data[$i]->settle_status==1){
                $data[$i]->settle_status = '未结算';
            }else if($data[$i]->settle_status==2){
                $data[$i]->settle_status = '已结算';
            }
            if($data[$i]->game_status==0){
                $data[$i]->game_status = '未处理';
            }else if($data[$i]->game_status==1){
                $data[$i]->game_status = '赢';
            }else if($data[$i]->game_status==2){
                $data[$i]->game_status = '输';
            }else if($data[$i]->game_status==3){
                $data[$i]->game_status = '平';
            }
            $data[$i]->match_id_order = '<span>'.$data[$i]->match_id.'</span><br>'.$data[$i]->order_id;
            $data[$i]->league = $data[$i]->name_chinese;

            $data[$i]->home_guest = $data[$i]->home_team.' VS '.$data[$i]->guest_team;
            $data[$i]->match_time = '开赛：'.$data[$i]->match_date.' '.$data[$i]->match_time;
            $data[$i]->money_match_time = '投注：'.$data[$i]->money_time.'<br>'.$data[$i]->match_time;

            //反水
            $data[$i]->water_return = -1;
            for($a=0;$a<count($water_return_money);$a++){
                if($data[$i]->order_id == $water_return_money[$a]->trade_id){
                    $data[$i]->water_return = $water_return_money[$a]->money;
                    //用户投注后账户金额
                    $data[$i]->frozen_cash = $water_return_money[$a]->money_cash;
                }
            }
            if($data[$i]->water_return == -1){
                $data[$i]->water_return == 0;
                //用户投注后账户金额
                $data[$i]->frozen_cash = $data[$i]->money_cash;
            }

//            $water_return_money = \App\Models\Money_details::where('trade_id',$data[$i]->order_id)->where('trade_type','7')->first();
//            if(!empty($water_return_money)){
//                $data[$i]->water_return = $water_return_money->money;
//                //用户投注后账户金额
//                $data[$i]->frozen_cash = $water_return_money->money_cash;
//            }else{
//                //用户投注后账户金额
//                $data[$i]->frozen_cash = $data[$i]->money_cash;
//            }

            $data[$i]->result = $data[$i]->water_return+$data[$i]->gain_money;

            //用户投注前账户金额
            $data[$i]->available_cash = $data[$i]->money_cash;

            $data[$i]->account = $data[$i]->available_cash.'<br><span>'.$data[$i]->account_name.'</span><br>'.$data[$i]->frozen_cash;

//            $data[$i]->str = 0;
//            for($b=0;$b<count($content);$b++){
//                if($data[$i]->match_id == $content[$b]->match_id && $data[$i]->batch_id == $content[$b]->batch_id){
//                    if($content[$b]->result == '0'){
//                        $data[$i]->str = 1;
//                    }else{
//                        if($data[$i]->game_status == '未处理'){
//                            $data[$i]->str = 2;
//                        }else{
//                            $data[$i]->str = 3;
//                        }
//                    }
//                }
//            }
//            if($data[$i]->str == 1){
//                $data[$i]->game_status = $data[$i]->game_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>';
//            }
//            if($data[$i]->str == 2){
//                $data[$i]->game_status = $data[$i]->game_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>';
//            }
//            if($data[$i]->str == 3){
//                $data[$i]->game_status = $data[$i]->game_status.'<br><a class="layui-btn layui-btn-sm resettlement" lay-event="detail" pid="id" uri="" href="javascript:void(0)" style="background-color: #FFAF60;"> 已结算 </a>';
//            }


            $content = \App\Models\MoneyBuyMatch::where('batch_id',$data[$i]->batch_id)->where('match_id',$data[$i]->match_id)->where('bet_type','1')->get();
            if($content[0]->result == '0'){
                $data[$i]->game_status = $data[$i]->game_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>';
            }else{
                if($data[$i]->game_status == '未处理'){
                    $data[$i]->game_status = $data[$i]->game_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>';
                }else{
                    //$data[$i]->game_status = $data[$i]->game_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>';
                    $data[$i]->game_status = $data[$i]->game_status.'<br><a class="layui-btn layui-btn-sm resettlement" lay-event="detail" pid="id" uri="" href="javascript:void(0)" style="background-color: #FFAF60;"> 已结算 </a>';
                }
            }

            for($j=0;$j<count($content);$j++){
                $odds_code = $content[$j]->odds_code;
                $result = \App\Models\Matchcode::where('odds_code',$odds_code)->first();
                if(!empty($result)){
                    $odds_name = $result->odds_name;
                }else{
                    $odds_name = $odds_code;
                }
                $data[$i]->content = $data[$i]->content.$odds_name.$content[$j]->condition.' ￥'.$content[$j]->bet_money.'@'.$content[$j]->odds.'<br>';

            }

        }
        return $data->toArray();

    }

    //投注金额汇总统计
    function MoneyCount($where = '',$type) {
        $data = array();
//        $data['all_money'] = $this->sum('money');
//        $data['all_prize_money'] = $this->sum('prize_money');
//        $data['alraedy_prize_money'] = $this->where('settle_status','2')->sum('gain_money');
        $data['all_money'] = 0;
        $data['all_prize_money'] = 0;
        $data['alraedy_prize_money'] = 0;
        $all_money = $this->join('money_details','money_details.info_identity','=','money_buy_simplex.info_identity')->join('st_'.$type.'_competition','st_'.$type.'_competition.match_id','=','money_buy_simplex.match_id')->join('st_'.$type.'_league','st_'.$type.'_competition.lg_id','=','st_'.$type.'_league.lg_id')->select('money_buy_simplex.money','money_buy_simplex.prize_money','money_buy_simplex.gain_money')->get();
        for($a=0;$a<count($all_money);$a++){
            $data['all_money'] = $data['all_money']+$all_money[$a]->money;
        }
        $all_prize_money = $this->join('money_details','money_details.info_identity','=','money_buy_simplex.info_identity')->join('st_'.$type.'_competition','st_'.$type.'_competition.match_id','=','money_buy_simplex.match_id')->join('st_'.$type.'_league','st_'.$type.'_competition.lg_id','=','st_'.$type.'_league.lg_id')->select('money_buy_simplex.money','money_buy_simplex.prize_money','money_buy_simplex.gain_money')->get();
        for($a=0;$a<count($all_prize_money);$a++){
            $data['all_prize_money'] = $data['all_money']+$all_prize_money[$a]->prize_money;
        }
        $alraedy_prize_money = $this->join('money_details','money_details.info_identity','=','money_buy_simplex.info_identity')->join('st_'.$type.'_competition','st_'.$type.'_competition.match_id','=','money_buy_simplex.match_id')->join('st_'.$type.'_league','st_'.$type.'_competition.lg_id','=','st_'.$type.'_league.lg_id')->select('money_buy_simplex.money','money_buy_simplex.prize_money','money_buy_simplex.gain_money')->where('money_buy_simplex.settle_status','2')->get();
        for($a=0;$a<count($alraedy_prize_money);$a++){
            $data['alraedy_prize_money'] = $data['all_money']+$alraedy_prize_money[$a]->gain_money;
        }

        if (!empty($where) && is_array($where)) {
            $data['all_money'] = 0;
            $data['all_prize_money'] = 0;
            $data['alraedy_prize_money'] = 0;
            //$data['all_money'] = $this->where($where)->sum('money');
//            $data['all_prize_money'] = $this->where($where)->sum('prize_money');
//            $data['alraedy_prize_money'] = $this->where($where)->where('settle_status','2')->sum('gain_money');
            $all_money = $this->join('money_details','money_details.info_identity','=','money_buy_simplex.info_identity')->join('st_zq_competition','st_zq_competition.match_id','=','money_buy_simplex.match_id')->join('st_zq_league','st_zq_competition.lg_id','=','st_zq_league.lg_id')->select('money_buy_simplex.money','money_buy_simplex.prize_money','money_buy_simplex.gain_money')->where($where)->get();
            for($a=0;$a<count($all_money);$a++){
                $data['all_money'] = $data['all_money']+$all_money[$a]->money;
            }
            $all_prize_money = $this->join('money_details','money_details.info_identity','=','money_buy_simplex.info_identity')->join('st_'.$type.'_competition','st_'.$type.'_competition.match_id','=','money_buy_simplex.match_id')->join('st_'.$type.'_league','st_'.$type.'_competition.lg_id','=','st_'.$type.'_league.lg_id')->select('money_buy_simplex.money','money_buy_simplex.prize_money','money_buy_simplex.gain_money')->where($where)->get();
            for($a=0;$a<count($all_prize_money);$a++){
                $data['all_prize_money'] = $data['all_prize_money']+$all_prize_money[$a]->prize_money;
            }
            $alraedy_prize_money = $this->join('money_details','money_details.info_identity','=','money_buy_simplex.info_identity')->join('st_'.$type.'_competition','st_'.$type.'_competition.match_id','=','money_buy_simplex.match_id')->join('st_'.$type.'_league','st_'.$type.'_competition.lg_id','=','st_'.$type.'_league.lg_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)->get();
            for($a=0;$a<count($alraedy_prize_money);$a++){
                $data['alraedy_prize_money'] = $data['alraedy_prize_money']+$alraedy_prize_money[$a]->gain_money;
            }
        }

        return $data;
    }


}