33 lines
904 B
PHP
33 lines
904 B
PHP
<?php
|
|
/**
|
|
* Created by PhpStorm.
|
|
* User: Administrator
|
|
* Date: 2020/4/13
|
|
* Time: 23:29
|
|
*/
|
|
|
|
namespace app\api\model;
|
|
|
|
|
|
use think\Model;
|
|
|
|
class Batchs extends Model
|
|
{
|
|
protected $table = 'yzy_batchs';
|
|
|
|
/*
|
|
* 根据省份和年份,文理、分数查询最新批次
|
|
* @param provinceID int 省份ID
|
|
* */
|
|
public static function getBatchsByProvince($provinceID,$score,$subType = 0){
|
|
//获取配置表的年份
|
|
$year = config('setsub.year');
|
|
$result = self::field('batch,batchName')->where([['yzy_province','=',$provinceID],['year','=',$year],['batch','<>',0],
|
|
['score','<=',$score],['wenli','=',$subType]])->group('batchName')->order('batch asc')->select()->toArray();
|
|
//判断数组是否大于3,批次大于3的话去掉最低批次
|
|
if(count($result)>2){
|
|
array_pop($result);
|
|
}
|
|
return $result;
|
|
}
|
|
} |