sports_web/Application/Commons/Model/Money_buy_simplex.php

<?php
/**
*------Create thems Model------
*------SCWPHP  Version 1.0.0------
*------Dev Model Jions------
*------Create Time 2019-04-15 16:05:26------
*/
namespace App\Commons\Model;

use \System\Model;
use Illuminate\Support\Facades\DB;

class Money_buy_simplex extends Model {

    // 对象表
    protected $table = 'money_buy_simplex';
    public $timestamps = false;

    /**
     * 投注记录
     *
     * @access public
     * @param mixed $select 查询字段
     * @param mixed $where 查询条件
     * @param mixed $between 查询条件区间     ['money_time' => [$startTime, $endTime], ...]
     * @param mixed $begin 起始查询位置
     * @param mixed $pageSize 分页大小
     * @param mixed $toArray 是否专为数组
     * @param mixed $orderBy 排序字段
     * @param mixed $join 关联关系      ['article' => 'oney_buy.info_identity = article.identity', ...]
     * @return array JsonString
     */
    public function moneyBuySimplex($select, $where = '', $between = '', $begin = '', $pageSize = '', $toArray = 0, $orderBy = ['money_time' => 'desc'], $join = '') {
        // 查询字段
        $result = $this -> select($select);
        // 循环关联
        if (!empty($join)) {
            foreach ($join as $key => $value) {
                $result = $result -> join($key, $value);
            }
        }
        // 查询条件
        if (!empty($where)) {
            $result = $result -> where($where);
        }
        // 循环获取查询区间
        if (!empty($between)) {
            foreach ($between as $key => $value) {
                $result = $result -> whereBetween($key, $value);
            }
        }
        // 查询起始
        if (strlen($begin)) {
            $result = $result -> offset($begin);
        }
        // 分页大小
        if (strlen($pageSize)) {
            $result = $result -> limit($pageSize);
        }
        // 循环排序规则
        foreach ($orderBy as $key => $value) {
            $result = $result -> orderBy($key, $value);
        }
        // 获取数据
        $result = $result -> get();
        if ($toArray) {
            $result = $result -> toArray();
        }

        return $result;
    }
}