GitHub - blanky01/qingda at patch-6

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 73 Commits
api		api
css		css
data		data
images		images
js		js
libs		libs
staticPages		staticPages
templates		templates
.gitignore		.gitignore
README		README
del-icon.png		del-icon.png
index.html		index.html
qingda.sql		qingda.sql
scroll.html		scroll.html

Repository files navigation

配置文件

偏离趋势接口 
URI: /api/index.php/report/deviationTrend 
method: GET 
参数说明: 
id 站点 
begin 开始时间 
end 结束时间
返回值： 
record_time 记录时间 
sid 站点id 
name 站点名称 
U 电压均值 
T 温度均值 
R 电阻均值 
EU 异常电压 
ET 异常温度 
ER 异常电阻 
返回值范例 
{"response":{"code":0,"msg":""},"data":[{"id":"1","sid":"20","gid":"1","sn_key":"11601090010101","U":"12.539","T":"27.491","R":"0.88818181","EU":"12.530","ET":"27.400","ER":"1.070","record_time":"2016-01-26 23:10:32","site_name":"\u4e0a\u5730\u7ad9\u70b9"}]}

-- 
-- 偏离趋势 
DROP TABLE IF EXISTS my_deviation_trend; 
CREATE TABLE IF NOT EXISTS my_deviation_trend ( 
id int(11) NOT NULL AUTO_INCREMENT, 
sid int(11) NOT NULL COMMENT '站点id', 
gid int(11) NOT NULL COMMENT '组id', 
sn_key varchar(100) NOT NULL COMMENT '硬件序列号', 
U float(10,3) NOT NULL DEFAULT '0' COMMENT '温度均值', 
T float(10,3) NOT NULL DEFAULT '0' COMMENT '温度均值', 
R char(10) NOT NULL DEFAULT '0' COMMENT '电阻均值', 
EU float(10,3) NOT NULL DEFAULT '0' COMMENT '异常电池电压', 
ET float(10,3
58CD
) NOT NULL DEFAULT '0' COMMENT '异常电池温度', 
ER char(10) NOT NULL DEFAULT '0' COMMENT '异常电池内阻', 
record_time datetime NOT NULL, 
PRIMARY KEY (id) 
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

fastcgi_param DB_QINGDA_HOST 127.0.0.1; 
fastcgi_param DB_QINGDA_DATABASE qingdalinghang; 
fastcgi_param DB_QINGDA_USERNAME qingda_user; 
fastcgi_param DB_QINGDA_PASSWORD xxxxx; 
fastcgi_param DB_QINGDA_PORT 3306; 
fastcgi_param DB_BMS_HOST 127.0.0.1; 
fastcgi_param DB_BMS_DATABASE db_bms_english; 
fastcgi_param DB_BMS_USERNAME db_bms_user; 
fastcgi_param DB_BMS_PASSWORD xxxxxx; 
fastcgi_param DB_BMS_PORT 3306;

SetEnv DB_QINGDA_HOST 127.0.0.1 
SetEnv DB_QINGDA_DATABASE qingdalinghang 
SetEnv DB_QINGDA_USERNAME qingda_user 
SetEnv DB_QINGDA_PASSWORD xxxxx 
SetEnv DB_QINGDA_PORT 3306 
SetEnv DB_BMS_HOST 127.0.0.1 
SetEnv DB_BMS_DATABASE db_bms_english 
SetEnv DB_BMS_USERNAME db_bms_user 
SetEnv DB_BMS_PASSWORD xxxxxx 
SetEnv DB_BMS_PORT 3306