Screen.php
2.6 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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
<?php
namespace app\api\controller;
use think\Db;
use app\common\controller\Api;
use app\common\model\User;
/**
* 邮箱验证码接口
*/
class Screen extends Api
{
protected $noNeedLogin = '*';
protected $noNeedRight = '*';
public function _initialize()
{
parent::_initialize();
}
public function healthy($id = null){
$status = null;
$nexttime = '';
$daytime = date('Y-m-d');
$daytime1 = date('Y-m-d',strtotime("$daytime + 1 day"));
$skid = $this->reservoir_ids;
$time = [];
$seriesall = [];
$series = [];
for ($i = 0; $i < 6; $i++) {
$nexttime= date('Y-m-d',strtotime("$daytime1 - 1 day"));
$daytime1 = date('Y-m-d',strtotime("$daytime1 - 1 day"));
$time[] = $daytime1;
}
for($s = 0;$s<count($skid);$s++){
$name = null;
$series = [];
if($skid[$s] == 23){
$name = "花果山水库";
}elseif ($skid[$s] == 24) {
$name = "白云水库";
}else {
$name = "三岔河水库";
}
for ($i = 0; $i < 6; $i++) {
$nexttime= date('Y-m-d',strtotime("$daytime1 - 1 day"));
//数据组
$rqkf = Db::name('reservoir_hkws_warning')->where('reservoir_id',$skid[$s])->where('createtime','between time',[$nexttime,$daytime1])->count();
$sykf = Db::name('reservoir_warning_isotonic')->where('reservoir_id',$skid[$s])->where('createtime','between time',[$nexttime,$daytime1])->count();
$wykf = Db::name('reservoir_warning_displacement')->where('reservoir_id',$skid[$s])->where('createtime','between time',[$nexttime,$daytime1])->count();
$swkf = Db::name('reservoir_warning_waterlevel')->where('reservoir_id',$skid[$s])->where('createtime','between time',[$nexttime,$daytime1])->count();
$ylkf = Db::name('reservoir_warning_rainfall')->where('reservoir_id',$skid[$s])->where('createtime','between time',[$nexttime,$daytime1])->count();
$daytime1 = date('Y-m-d',strtotime("$daytime1 - 1 day"));
$calculation = $rqkf + $sykf+$wykf+$swkf+$ylkf;
$series[] = $calculation;
}
$seriesname = [
'name' => $name,
'data' => $series
];
$seriesall[] = $seriesname;
}
$data = [
'seriesall' => $seriesall,
'time' => $time
];
$this->success('',$data);
}
}