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";
    public $timestamps = false;

    function getinfo($list = 10, $page, $where = '',$type)
    {
        if (is_array ($where) && count ($where) > 0) {
            $data = $this->where($where)
                ->where('money_buy.game_name', $type)
                ->orderby('money_time','desc')
                ->paginate ($list);
        } else {
            $data = $this->where('money_buy.game_name', $type)
                ->orderby('money_time','desc')
                ->paginate ($list);
        }
        if (!$data < 0) {
            return -2021052003; //
        }
        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]->water_status==1){
                $data[$i]->water_status = '未回水';
            }else if($data[$i]->water_status==2){
                $data[$i]->water_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 = '未中奖';
            }
            if($data[$i]->member_type==1){
                $data[$i]->member_type = '普通会员';
            }else if($data[$i]->member_type==2){
                $data[$i]->member_type = '超级会员';
            }

            $data[$i]->order_time = $data[$i]->order_id.'<br>'.$data[$i]->money_time;

            $codes = json_decode($data[$i]->codes, true);
            $data[$i]->content = '';
            for($j=0;$j<count($codes);$j++){
                $odds_only = $codes[$j]['odds_only'];
                $res = DB::table('st_'.$type.'_odds_record')->where('odds_only',$odds_only)->first();
                if(!empty($res)){
                    $result = DB::table('st_odds_code')->where('odds_code',$res->odds_code)->first();
                    if(!empty($result)){
                        $odds_name = $result->odds_name;
                    }else{
                        $odds_name = $res->odds_code;
                    }
                    $game = DB::table('st_game_type')->where('game_code',$data[$i]->game_name)->first();
                    $data[$i]->content = $data[$i]->content.$odds_name.  '￥'.$codes[$j]['bet_amount'].'<br>';
                    $data[$i]->game = $game->game_name;
                }

            }

        }
        return $data->toArray();

    }


}