From bbe25007af388943027ee6b630c28a2815edca73 Mon Sep 17 00:00:00 2001
From: 81041 <81041@192.168.10.30>
Date: 星期三, 05 十二月 2018 09:51:05 +0800
Subject: [PATCH] 首页上添加续航不足图标功能
---
gx_tieta/src/com/fgkj/services/ram/Bts_station_stateService.java | 3 +
gx_tieta/src/com/fgkj/dao/impl/Batt_enduranceImpl.java | 34 ++++++++++++++++
gx_tieta/src/com/fgkj/services/BattMap_informationService.java | 34 ++++++++++++----
3 files changed, 61 insertions(+), 10 deletions(-)
diff --git a/gx_tieta/src/com/fgkj/dao/impl/Batt_enduranceImpl.java b/gx_tieta/src/com/fgkj/dao/impl/Batt_enduranceImpl.java
index a4ceb31..79b8943 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/Batt_enduranceImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/Batt_enduranceImpl.java
@@ -11,6 +11,7 @@
import com.fgkj.dao.DAOHelper;
import com.fgkj.dao.LimitNumberFactory;
import com.fgkj.db.DBUtil;
+import com.fgkj.dto.BattMap_information;
import com.fgkj.dto.Batt_endurance;
import com.fgkj.dto.Page;
import com.fgkj.dto.User_inf;
@@ -210,6 +211,33 @@
}
return nums;
}
+ //鏍规嵁鏈烘埧id鏌ヨ璇ユ満鎴跨画鑸笉瓒崇殑鏁�
+ public int serchxuhangNotInThree_stationid(Object obj) {
+ BattMap_information binformation=(BattMap_information) obj;
+ String sql="select count(distinct tb_batt_endurance.deviceid) as nums from web_site.tb_batt_endurance " +
+ " where endurance_actual_timelong<180 and tb_batt_endurance.stationid=? " ;
+ List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binformation.getStationId()}, new CallBack() {
+
+ public List getResults(ResultSet rs) {
+ List list=new ArrayList();
+ try {
+ while(rs.next()){
+ int nums=rs.getInt("nums");
+ list.add(nums);
+ }
+ } catch (SQLException e) {
+ // TODO Auto-generated catch block
+ e.printStackTrace();
+ }
+ return list;
+ }
+ });
+ int nums=0;//缁埅涓嶈冻3灏忔椂鏁�
+ if(list!=null&&list.size()>0){
+ nums=(Integer) list.get(list.size()-1);
+ }
+ return nums;
+ }
public List serchByInfo(Object obj) {
// TODO Auto-generated method stub
return null;
@@ -240,7 +268,11 @@
System.out.println(num);
}*/
//System.out.println(list.size());
- int nums=bimpl.serchxuhangNotInThree(uinf);
+ /*int nums=bimpl.serchxuhangNotInThree(uinf);
+ System.out.println(nums);*/
+ BattMap_information binformation=new BattMap_information();
+ binformation.setStationId("42000530");
+ int nums=bimpl.serchxuhangNotInThree_stationid(binformation);
System.out.println(nums);
}
diff --git a/gx_tieta/src/com/fgkj/services/BattMap_informationService.java b/gx_tieta/src/com/fgkj/services/BattMap_informationService.java
index 256b4d7..b091ab9 100644
--- a/gx_tieta/src/com/fgkj/services/BattMap_informationService.java
+++ b/gx_tieta/src/com/fgkj/services/BattMap_informationService.java
@@ -12,6 +12,7 @@
import com.fgkj.dao.impl.BattDischarge_planImpl;
import com.fgkj.dao.impl.BattInfImpl;
import com.fgkj.dao.impl.BattMap_informationImpl;
+import com.fgkj.dao.impl.Batt_enduranceImpl;
import com.fgkj.dao.impl.Batt_rtstateDAOImpl;
import com.fgkj.dao.impl.Battalarm_dataDAOImpl;
import com.fgkj.dao.impl.ram.Bts_station_stateImpl;
@@ -110,6 +111,7 @@
int numPlan=0;
int numPoff=0;
int dianzhanNum=0;
+ int xuhangNum=0;
if(list!=null&&list.size()>0){
for(int i=0;i<list.size();i++){
state="item-normal";
@@ -120,6 +122,7 @@
binf.setFBSDeviceId(binformation.getFBSDeviceId());
state=(new Fbs9100_stateImpl().seachDevNow(binf));
}else{
+ xuhangNum=(new Batt_enduranceImpl()).serchxuhangNotInThree_stationid(binformation);//缁埅涓嶈冻3灏忔椂鏁�
numPoff=(new Bts_station_stateImpl()).serchByStationId(binformation); //鍋滅數鏁�
dianzhanNum=(new Bts_station_stateImpl()).serchByStationId_diaozhan(binformation); //鎺夌珯鏁�
numBadBatt=(new BadBatt_monImpl()).serchByStationId(binformation); //钀藉悗鎬绘暟
@@ -132,16 +135,19 @@
state="item-poff"; //鍋滅數
}else{
- if(numBadBatt>0){
- state="item-behind"; //钀藉悗鏈烘埧
+ if(xuhangNum>0){
+ state="item-xuhang"; //缁埅涓嶈冻
}else{
- if(numAlarm > 0){
- state="item-warn"; //鍛婅鏈烘埧
+ if(numBadBatt>0){
+ state="item-behind"; //钀藉悗鏈烘埧
+ }else{
+ if(numAlarm > 0){
+ state="item-warn"; //鍛婅鏈烘埧
+ }
}
}
}
}
-
}
if("0".equals(list.get(i).getInformation())){
state="item-install"; //鑻ユ満鎴挎湭瀹夎灏嗘寚瀹氱殑鏈烘埧璁剧疆鎴愮伆鑹茬殑
@@ -152,6 +158,7 @@
model.setSum(numBadBatt); //钀藉悗鎬绘暟
//model.setNewsum(numPlan); //寤舵椂鎬绘暟
model.setMsgT(String.valueOf(dianzhanNum)); //鎺夌珯
+ model.setMsgV(String.valueOf(xuhangNum));//缁埅涓嶈冻
model.setMsg(state); //61850鐘舵��
model.setMsgN(binformation.getFBSDeviceId().toString());
listAll.add(model);
@@ -169,6 +176,7 @@
int numPlan=0;
int numPoff=0;
int dianzhanNum=0;
+ int xuhangNum=0;
if(list!=null&&list.size()>0){
for(int i=0;i<list.size();i++){
state="item-normal";
@@ -179,6 +187,7 @@
binf.setFBSDeviceId(binformation.getFBSDeviceId());
state=(new Fbs9100_stateImpl().seachDevNow(binf));
}else{
+ xuhangNum=(new Batt_enduranceImpl()).serchxuhangNotInThree_stationid(binformation);//缁埅涓嶈冻3灏忔椂鏁�
numPoff=(new Bts_station_stateImpl()).serchByStationId(binformation); //鍋滅數鏁�
dianzhanNum=(new Bts_station_stateImpl()).serchByStationId_diaozhan(binformation); //鎺夌珯鏁�
numBadBatt=(new BadBatt_monImpl()).serchByStationId(binformation); //钀藉悗鎬绘暟
@@ -191,11 +200,15 @@
state="item-poff"; //鍋滅數
}else{
- if(numBadBatt>0){
- state="item-behind"; //钀藉悗鏈烘埧
+ if(xuhangNum>0){
+ state="item-xuhang"; //缁埅涓嶈冻
}else{
- if(numAlarm > 0){
- state="item-warn"; //鍛婅鏈烘埧
+ if(numBadBatt>0){
+ state="item-behind"; //钀藉悗鏈烘埧
+ }else{
+ if(numAlarm > 0){
+ state="item-warn"; //鍛婅鏈烘埧
+ }
}
}
}
@@ -207,6 +220,7 @@
model.setSum(numBadBatt); //钀藉悗鎬绘暟
//model.setNewsum(numPlan); //寤舵椂鎬绘暟
model.setMsgT(String.valueOf(dianzhanNum)); //鎺夌珯
+ model.setMsgV(String.valueOf(xuhangNum));//缁埅涓嶈冻
model.setMsg(state); //61850鐘舵��
model.setMsgN(binformation.getFBSDeviceId().toString());
listAll.add(model);
@@ -227,12 +241,14 @@
int numPlan=(new BattDischarge_planImpl()).serchByStationId(binformation);
int numPoff=(new Bts_station_stateImpl()).serchByStationId(binformation); //鍋滅數鏁�
int dianzhanNum=(new Bts_station_stateImpl()).serchByStationId_diaozhan(binformation); //鎺夌珯鏁�
+ int xuhangNum=(new Batt_enduranceImpl()).serchxuhangNotInThree_stationid(binformation);//缁埅涓嶈冻3灏忔椂鏁�
model.setData(list.get(i));
model.setCode(numAlarm); //鍛婅鎬绘暟
model.setSum(numBadBatt); //钀藉悗鎬绘暟
model.setNewsum(numPlan); //寤舵椂鎬绘暟
model.setMsgO(String.valueOf(numPoff)); //鍋滅數鏁�
model.setMsgT(String.valueOf(dianzhanNum)); //鎺夌珯
+ model.setMsgV(String.valueOf(xuhangNum));//缁埅涓嶈冻
listAll.add(model);
}
}
diff --git a/gx_tieta/src/com/fgkj/services/ram/Bts_station_stateService.java b/gx_tieta/src/com/fgkj/services/ram/Bts_station_stateService.java
index 3f27a1d..16ead5d 100644
--- a/gx_tieta/src/com/fgkj/services/ram/Bts_station_stateService.java
+++ b/gx_tieta/src/com/fgkj/services/ram/Bts_station_stateService.java
@@ -7,6 +7,7 @@
import com.fgkj.dao.impl.BadBatt_monImpl;
import com.fgkj.dao.impl.BattInfImpl;
import com.fgkj.dao.impl.BattPower_offImpl;
+import com.fgkj.dao.impl.Batt_enduranceImpl;
import com.fgkj.dao.impl.Battalarm_dataDAOImpl;
import com.fgkj.dao.impl.ram.Bts_station_stateImpl;
import com.fgkj.dto.Battalarm_data;
@@ -56,12 +57,14 @@
int dianzhanNum=((Bts_station_stateImpl)dao).serchByState_diaozhan(obj); //鎺夌珯瀹炴椂鏁�
int badbattNum=(new BadBatt_monImpl()).searchBadBattInStation(obj);//瀛樺湪钀藉悗鍗曚綋鐨勬満鎴夸釜鏁�
int alarmNum=(new Battalarm_dataDAOImpl()).searchAlarmInStation(obj);//瀛樺湪鐢垫睜鍛婅鐨勬満鎴夸釜鏁�
+ int xuhangnums=(new Batt_enduranceImpl()).serchxuhangNotInThree(obj); //瀛樺湪缁埅涓嶈冻3灏忔椂鐨勬満鎴夸釜鏁�
int devNum=(new BattInfImpl()).serchByDeviceId(obj); //鎬昏澶囨暟
model.setSum(powerNum);//鍋滅數瀹炴椂鏁�
model.setCode(dianzhanNum);//鎺夌珯瀹炴椂鏁�
model.setNewsum(devNum); //鎬昏澶囨暟
model.setMsgN(String.valueOf(badbattNum));//瀛樺湪钀藉悗鍗曚綋鐨勬満鎴夸釜鏁�
model.setMsg(String.valueOf(alarmNum));//瀛樺湪鐢垫睜鍛婅鐨勬満鎴夸釜鏁�
+ model.setMsgT(String.valueOf(xuhangnums));//瀛樺湪缁埅涓嶈冻3灏忔椂鐨勬満鎴夸釜鏁�
return model;
}
--
Gitblit v1.9.1