Displacement.php
2.0 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
<?php
namespace app\api\controller\reservoir\dam;
use app\common\controller\Api;
use think\Request;
use think\Db;
/**
* Class Displacement
* @package app\api\controller
*/
class Displacement extends Api{
protected $noNeedLogin = '*';
protected $noNeedRight = '*';
public function _initialize()
{
parent::_initialize();
$this->model = new \app\admin\model\reservoir\dam\Displacement;
}
public function getList(){
$id = input('get.id');
$page = input('get.page')?:1;
$limit = input('get.limit')?:8;
$starttime = strtotime(input('get.starttime'));
$endtime = strtotime(input('get.endtime'));
if($starttime && $endtime){
$res = $this->model->where('reservoir_id','=',$id)->where('createtime','>=',$starttime)->where('createtime','<=',$endtime)->order('createtime desc')->page($page,$limit)->select();
}
else {
$res = $this->model->where('reservoir_id', '=', $id)->order('createtime desc')->page($page, $limit)->select();
}
$this->success('成功',$res);
}
//水库id
public function getLast($id){
$info = $this->model->where('reservoir_id',$id)->field('horizontal,vertical,FROM_UNIXTIME(createtime) as createtime')->order('createtime desc')->find();
$this->success('',$info);
}
//水库id
public function getLastNew($id){
$count = Db::name('reservoir_equipment')->where('type','=',6)->where('reservoir_id',$id)->count();
$info = Db::name('reservoir_dam_displacement')->where('reservoir_id',$id)
->field('vertical,horizontal,horizontalY,FROM_UNIXTIME(createtime) as createtime,number')->order('createtime desc')->limit($count)->select();
$res = [];
foreach($info as $k => $v){
if(!($k != 0 && (strtotime($info[$k-1]['createtime'])-strtotime($v['createtime']))>3000)){
$res[] = $v;
}
}
$this->success('',$res);
}
}