sports_admin/app/Models/MoneyBuyStr.php

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

    function getinfo($list = 10, $page, $where = '')
    {
        if (is_array ($where) && count ($where) > 0) {
            $data = $this
                ->join('money_details','money_details.info_identity','=','money_buy_str.info_identity')
                ->select('money_buy_str.id','money_buy_str.account_name','money_buy_str.order_id','money_buy_str.str_type','money_buy_str.money','money_buy_str.prize_money','money_buy_str.status','money_buy_str.money_time','money_buy_str.settle_status','money_buy_str.game_status','money_buy_str.gain_money','money_details.money_cash')
                ->where($where)
                ->orderby('money_buy_str.money_time','desc')
                ->paginate ($list);
        } else {
            $data = $this
                ->join('money_details','money_details.info_identity','=','money_buy_str.info_identity')
                ->select('money_buy_str.id','money_buy_str.account_name','money_buy_str.order_id','money_buy_str.str_type','money_buy_str.money','money_buy_str.prize_money','money_buy_str.status','money_buy_str.money_time','money_buy_str.settle_status','money_buy_str.game_status','money_buy_str.gain_money','money_details.money_cash')
                ->orderby('money_buy_str.money_time','desc')
                ->paginate ($list);
        }
        if (!$data < 0) {
            return -2021052003; //
        }
        //反水比例
        $res = DB::table('setinfo')->where('infoname','放水赔率')->first();

        for($i=0;$i<count($data);$i++){
            if($data[$i]->status==1){
                $data[$i]->status = '投注';
            }else if($data[$i]->status==2){
                $data[$i]->status = '追号';
            }else if($data[$i]->status==4){
                $data[$i]->status = '撤单';
            }
            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 = '未中奖';
            }

            //$str_type = str_replace('*', '串', $data[$i]->str_type);
            $mun = explode('串',$data[$i]->str_type);
            $data[$i]->detail_content = $data[$i]->settle_status.'：'.$mun[0].' [<a class="detail" lay-event="detail" pid="id" uri="/admin/SoccerStringNoteList/detail/?id=" href="/admin/SoccerStringNoteList/detail/?id='.$data[$i]->id.'"> 详情 </a>]';

            //反水
            $data[$i]->water_return = $data[$i]->money*$res->infocontent;
            $data[$i]->result = $data[$i]->water_return+$data[$i]->gain_money;

            $data[$i]->money_match_time = '投注：'.$data[$i]->money_time;

            $data[$i]->frozen_cash = $data[$i]->money_cash;
            $data[$i]->available_cash = $data[$i]->money_cash+$data[$i]->money.'.00';
            $data[$i]->account = $data[$i]->available_cash.' <span>'.$data[$i]->account_name.' </span> '.$data[$i]->frozen_cash;

            $data[$i]->settle_status = $data[$i]->settle_status.'<br><a class="layui-btn layui-btn-sm resettlement" lay-event="detail" pid="id" lay-filter = "resettlement" uri="/admin/SoccerStringNoteList/resettlement/?id=" href="/admin/SoccerStringNoteList/resettlement/?id='.$data[$i]->id.'"> 重新结算 </a>';

        }
        return $data->toArray();

    }

    //投注金额汇总统计
    function MoneyCount($where = '') {
        $data = array();
        $data['all_money'] = $this->sum('money');
        $data['all_prize_money'] = $this->sum('prize_money');
        if (!empty($where) && is_array($where)) {
            $data['all_money'] = $this->where($where)->sum('money');
            $data['all_prize_money'] = $this->where($where)->sum('prize_money');
        }

        return $data;
    }

    //获取串关注单详情信息
    function getdetailinfo($id) {
        $res = $this->where('id',$id)->first();
        $data = DB::table('money_buy_match')->where('batch_id',$res->batch_id)->get();
        $game_type = DB::table('st_game_type')->get();
        for($i=0;$i<count($data);$i++){
            $league = DB::table('st_'.$data[$i]->game_code.'_league')->where('lg_id',$data[$i]->lg_id)->first();
            if(!empty($league)){
                $data[$i]->league = $league->name_chinese;
            }else{
                $data[$i]->league = $data[$i]->lg_id;
            }

            $odds_code = DB::table('st_odds_code')->where('odds_code',$data[$i]->odds_code)->first();
            if(!empty($odds_code)){
                $data[$i]->odds_code = $odds_code->odds_name;
            }

            $data[$i]->home_guest = $data[$i]->home_team.' VS '.$data[$i]->guest_team;

            for($j=0;$j<count($game_type);$j++){
                if($data[$i]->game_code == $game_type[$j]->game_code){
                    $data[$i]->game_type = $game_type[$j]->game_name;
                }
            }

            if($data[$i]->status == 0){
                $data[$i]->status = '未结算';
            }else if($data[$i]->status == 1){
                $data[$i]->status = '已结算';
            }

            if($data[$i]->result == -1){
                $data[$i]->result = '输';
            }else if($data[$i]->result == 0){
                $data[$i]->result = '未处理';
            }else if($data[$i]->result == 1){
                $data[$i]->result = '赢';
            }else if($data[$i]->result == 2){
                $data[$i]->result = '平';
            }else if($data[$i]->result == 3){
                $data[$i]->result = '赢半平半';
            }else if($data[$i]->result == 4){
                $data[$i]->result = '输半平半';
            }
        }

        return $data->toArray();
    }




}