sports_dapi/app/Models/MoneyBuyMatch.php

<?php
/**
 * Created by PhpStorm.
 * User: scstf
 * Date: 2018/9/28
 * Time: 20:05
 */

namespace App\Models;

use Illuminate\Database\Capsule\Manager as DB;
use Illuminate\Database\Eloquent\Model;

class MoneyBuyMatch extends Model
{
    protected $table = 'money_buy_match';
    public $timestamps = false;

    public function getByAttrs($where, $orderArray = [])
    {
        if (empty($order)) {
            $datas = $this->where($where)->get();
        } else {
            $datas = $this->where($where)->orderby($orderArray['orderby'], $orderArray['order'])->get();
        }
        return $datas;
    }

    //赛事下所有下注单式下单
    function allsimplexorder($ssid, $code)
    {
        //单式下单
        $where = array();
        $where[] = array('money_buy_match.match_id', '=', $ssid);
        $where[] = array('money_buy_match.bet_type', '=', 1);
        $where[] = array('money_buy_match.game_code', '=', $code);
        $data = $this->join('money_buy_simplex', 'money_buy_match.batch_id', '=', 'money_buy_simplex.batch_id')->select('money_buy_simplex.order_id', 'money_buy_simplex.money', 'money_buy_simplex.account_identity', 'money_buy_simplex.info_identity', 'money_buy_simplex.match_id')->where($where)->get()->toArray();
        return $data;
    }

    //赛事下所有下注串式下单
    function allstrorder($ssid)
    {
        //串式下单
        $where = array();
        $where[] = array('money_buy_match.match_id', '=', $ssid);
        $where[] = array('money_buy_match.bet_type', '=', 2);
        $data = $this->join('money_buy_str', 'money_buy_match.batch_id', '=', 'money_buy_str.batch_id')->select('money_buy_str.order_id')->where($where)->distinct('money_buy_match.batch_id')->get()->toArray();
        return $data;
    }

    //修改串式下注状态
    function updatast($match_id)
    {
        $the = array(
            'updated_at' => date('Y-m-d H:i:s'),
            'result' => 2,
        );
        $where = array(
            'match_id' => $match_id,
            'bet_type' => 2,
        );

        $res = $this->where($where)->update($the);

        if (!$res) {
            return -4010000102; //更新失败
        }
        return $res;
    }

    //某个赛事的单式和串式条数统计
    public function countByMatch($matchID)
    {
        $matchID = intval($matchID);

        $sqla = "select count(id) as mcount from  money_buy_match where match_id=$matchID and  bet_type=1 and   order_id in( select order_id from  money_buy_simplex where match_id=$matchID and is_manual=0 )";
        $sqlb = "select count(id) as mcount from  money_buy_match where match_id=$matchID and  bet_type=2 ";

        $reta = DB::select($sqla);
        $retb = DB::select($sqlb);

        $ret1 = $ret2 = 0;
        if ($reta && isset($reta['0']->mcount)) {
            $ret1 = intval($reta['0']->mcount);
        }

        if ($retb && isset($retb['0']->mcount)) {
            $ret2 = intval($retb['0']->mcount);
        }

        return ['bet1' => $ret1, 'bet2' => $ret2, 'count' => $ret1 + $ret2];
    }


}