package com.fgkj.mapper.impl;
|
|
import com.fgkj.dto.BattInf;
|
import com.fgkj.dto.BattMap_information;
|
import com.fgkj.dto.Batt_Maint_Dealarm;
|
import com.fgkj.dto.User_inf;
|
import com.fgkj.mapper.FBS9100_ComBase;
|
import org.apache.ibatis.annotations.Delete;
|
import org.apache.ibatis.annotations.Select;
|
import org.apache.ibatis.annotations.Update;
|
|
import java.util.List;
|
import java.util.Map;
|
|
public interface BattInfMapper{
|
|
//添加新的电池组(多个)
|
public boolean add(BattInf obj);
|
|
//TODO 待测试
|
//修改电池组信息(多个)
|
@Update("update db_battinf.tb_battinf set StationId=#{stationId},StationName=#{stationName},StationName1=#{stationName1}," +
|
"StationName2=#{stationName2},StationName3=#{stationName3},StationName4=#{stationName4},StationName5=#{stationName5}," +
|
"StationIp=#{stationIp},FBSDeviceId=#{fbsDeviceId},FbsDeviceIp=#{fbsDeviceIp},FBSDeviceName=#{fbsDeviceName}," +
|
"GroupIndexInFBSDevice=#{groupIndexInFBSDevice}" +
|
",BattGroupNum=#{battGroupNum},BattGroupName=#{battGroupName},FloatVolLevel=#{floatVolLevel}," +
|
"OfflineVolLevel=#{offlineVolLevel},BattFloatCurrent=#{battFloatCurrent}," +
|
"MonCount=#{monCount},MonCapStd=#{monCapStd},monVolStd=#{monVolStd},monResStd=#{monResStd}, " +
|
"MonSerStd=#{monSerStd},MonVolLowToAvg=#{monVolLowToAvg},BattProducer=#{battProducer},BattModel=#{battModel}," +
|
"BattProductDate=#{battProductDate},BattInUseDate=#{battInUseDate}," +
|
"Load_curr=#{load_curr},DisCurrMax=#{disCurrMax},station_phone=#{station_phone},FbsDeviceIp=#{fbsDeviceIp},FbsDeviceIp_YM=#{fbsDeviceIp}," +
|
"FbsDeviceIp_WG=#{fbsDeviceIp_WG},Vol_grade=#{vol_grade},Manufacturers=#{manufacturers}," +
|
"Assetequipment=#{assetequipment},Deviceclasspath=#{deviceclasspath}," +
|
"Deviceoperationdepartment=#{deviceoperationdepartment},PropertyRightUnit=#{propertyRightUnit}," +
|
"PropertyAttribute=#{propertyAttribute},FactoryNumber=#{factoryNumber}," +
|
"OperationTeam=#{operationTeam},DeviceIdentityCode=#{deviceIdentityCode},ProjectType=#{projectType}," +
|
"BatteryApplicationType=#{batteryApplicationType},SingleRatedVoltage=#{singleRatedVoltage}," +
|
"RemoteMonitor=#{remoteMonitor},BatttIndependentPlaced=#{batttIndependentPlaced}," +
|
"JunChargeVoltageValue=#{junChargeVoltageValue} where battgroupId=#{battGroupId}")
|
public int update(BattInf obj);
|
|
//修改电池信息配置(ip地址,掩码和网关)
|
@Update("update db_battinf.tb_battinf set FbsDeviceIp=#{fbsDeviceIp},FbsDeviceIp_YM=#{fbsDeviceIp_YM},FbsDeviceIp_WG=#{fbsDeviceIp_WG} where FbsDeviceId=#{fbsDeviceId}")
|
public int updateIp(BattInf obj);
|
|
//删除电池组(多个)
|
@Delete("delete from db_battinf.tb_battinf where battgroupid=#{battGroupId}")
|
public int del(BattInf obj);
|
|
//电池组信息配置中查询所有的电池组信息
|
@Select("select distinct(StationId),StationName1,StationName2,StationName3,StationName4,StationName5,StationIp,FBSDeviceId,FbsDeviceIp_YM,FbsDeviceIp_WG,FbsDeviceIp,"
|
+ "FBSDeviceName,GroupIndexInFBSDevice,battgroupId,BattGroupNum,BattGroupName,FloatVolLevel,OfflineVolLevel,BattFloatCurrent " +
|
",MonCount,MonCapStd,monVolStd,monResStd,MonSerStd,MonVolLowToAvg,BattProducer,BattModel,BattProductDate,BattInUseDate,Load_curr,DisCurrMax,station_phone "
|
+ ",Vol_grade,Manufacturers,Assetequipment,Deviceclasspath,Deviceoperationdepartment,PropertyRightUnit,PropertyAttribute,FactoryNumber,OperationTeam "
|
+ ",DeviceIdentityCode,ProjectType,BatteryApplicationType,SingleRatedVoltage,RemoteMonitor,BatttIndependentPlaced,JunChargeVoltageValue " +
|
" From db_battinf.tb_battinf " +
|
" Where StationName1 like '%${binf.stationName1}%' and StationName2 like '%${binf.stationName2}%' and StationName5 like '%${binf.stationName5}%' and StationName3 like '%${binf.stationName3}%' " +
|
" order by StationName3 ASC,StationId asc ")
|
public List<BattInf> searchInform(Batt_Maint_Dealarm obj);
|
|
//添加电池组时查询出最大的机房id和电池组id
|
public List searchMaxId();
|
|
//判断新增的电池组是否存在
|
@Select("select distinct stationid,fBSDeviceId from db_battinf.tb_battinf where stationname=#{stationName} limit 1")
|
public List<BattInf> judgeBattStationName(BattInf obj);
|
|
//判断新增机房名是否存在
|
public List judgeBattStationName3(Object obj);
|
|
//0.4根据城市名称查电池组
|
@Select("select distinct(battgroupid) from db_battinf.tb_battinf where stationname like '%${stationName}%' ")
|
public List<BattInf> search(BattInf obj);
|
|
//查询出当前存在内存中最大的设备的id(很重要**********)
|
@Select("select max(FbsDeviceId) as id from db_battinf.tb_battinf limit 1")
|
public int searchMaxdevId_binf();
|
|
//2.2查所有的电池组
|
@Select("select battgroupid from db_battinf.tb_battinf ")
|
public List<Integer> searchAll();
|
|
//5.3添加选取电池组或者机房或者维护区
|
public List<BattInf> serchBatt(BattInf obj);
|
|
//查询电池组左侧导航菜单（实时监测，历史数据查询）
|
public List findMenu();
|
|
//根据StationName1（维护区） 查不重复BattGroupName（蓄电池组）
|
@Select("select DISTINCT(StationName),battgroupname,moncount,BattGroupId from db_battinf.tb_battinf ORDER BY StationName1,battgroupId")
|
public List<BattInf> serchByStationName1(BattInf obj);
|
@Select("select DISTINCT(StationName),battgroupname,moncount,battgroupid from db_battinf.tb_battinf where StationName1 like '%${stationName1}%' ORDER BY StationName1,battgroupid")
|
List<BattInf> serchByStationName1plus(BattInf bif);
|
|
// 根据StationName（站点） 查不重复的BattGroupName（蓄电池组）
|
// @Select("select DISTINCT(StationName),FBSDeviceId,StationId,battgroupname,moncount,BattGroupId,StationName,battproducer,moncapstd,monvolstd,battproductdate,battinusedate,GroupIndexInFBSDevice " +
|
// "from db_battinf.tb_battinf where stationname1=#{stationName1} ORDER BY StationName1,battgroupId")
|
public List<BattInf> serchByBattGroupName(BattInf obj);
|
|
|
// 根据StationName1（维护区） 查不重复的StationName（站点）
|
public List<BattInf> serchByStationName(BattInf obj);
|
|
// 根据StationName1（维护区） 查不重复的StationName（站点）不包含91000000一期设备
|
public List<BattInf> serchByStationNameNot91(Object obj);
|
|
// 查不重复的StationName1（维护区）
|
@Select("select DISTINCT(StationName1) from db_battinf.tb_battinf ORDER BY StationName1,battgroupId")
|
public List<String> serchByStation() ;
|
|
// 查不重复的StationName1（维护区）不包含91000000一期设备
|
@Select("select DISTINCT(StationName1) from db_battinf.tb_battinf where fbsdeviceId >= '${@com.fgkj.mapper.FBS9100_ComBase@EQUIPMENTCLASSIFICATION_TWO}' ORDER BY StationName1,battgroupId")
|
public List<String> serchByStationNot91();
|
|
//-查询所有的省份
|
@Select(" select DISTINCT(StationName1) from db_battinf.tb_battinf " +
|
"where StationId in( select distinct db_user.tb_user_battgroup_baojigroup_battgroup.StationId " +
|
"from db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr " +
|
"where db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id=db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id and db_user.tb_user_battgroup_baojigroup_usr.uId=#{uId} ) "
|
+ " ORDER BY CONVERT( StationName1 USING gbk ) COLLATE gbk_chinese_ci ASC ")
|
public List<String> serchAllStationName1(User_inf obj);
|
|
//-查询所有的市
|
@Select(" select DISTINCT(StationName2) from db_battinf.tb_battinf "
|
+ " where StationName1 like '%${stationName1}%' and StationId in(" +
|
" select distinct db_user.tb_user_battgroup_baojigroup_battgroup.StationId from db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr where db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id=db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id and db_user.tb_user_battgroup_baojigroup_usr.uId=#{num}" +
|
" ) ORDER BY CONVERT( StationName2 USING gbk ) COLLATE gbk_chinese_ci ASC ")
|
public List<String> serchAllStationName2(BattInf obj);
|
|
//-查询所有的区县
|
@Select(" select DISTINCT(StationName5) from db_battinf.tb_battinf "
|
+ " where StationName1 like '%${stationName1}%' and StationName2 like '%${stationName2}%' "
|
+ "and StationId in(" +
|
" select distinct db_user.tb_user_battgroup_baojigroup_battgroup.StationId from db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr where db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id=db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id and db_user.tb_user_battgroup_baojigroup_usr.uId=#{num}" +
|
" ) "
|
+ " ORDER BY CONVERT( StationName5 USING gbk ) COLLATE gbk_chinese_ci ASC ")
|
public List<String> serchAllStationName5(BattInf obj);
|
|
//-查询所有的站点
|
@Select("select DISTINCT stationId,fBSDeviceId,StationName1,StationName2,StationName3,StationName5,stationName " +
|
" FROM db_battinf.tb_battinf " +
|
" where StationName1 like '%${stationName1}%' and StationName2 like '%${stationName2}%' and StationName5 like '%${stationName5}%' " +
|
" and StationId in(" +
|
" select distinct db_user.tb_user_battgroup_baojigroup_battgroup.StationId from db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr where db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id=db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id and db_user.tb_user_battgroup_baojigroup_usr.uId=#{num}" +
|
" ) "+
|
" ORDER BY CONVERT( StationName USING gbk ) COLLATE gbk_chinese_ci ASC ")
|
public List<BattInf> serchAllStationName(BattInf obj);
|
|
//-查询电池组信息
|
@Select(" select DISTINCT StationName,StationName1,StationName2,StationName3,StationName4,StationName5,StationId,stationid_ex,StationIP,FBSDeviceId,BattGroupName,BattGroupName1,BattGroupName2,MonCount,battgroupId,MonCapStd,MonVolStd,MonResStd,MonSerStd,BattModel,BattProducer,BattProductDate,BattInUseDate,GroupIndexInFBSDevice,Load_curr,DisCurrMax " +
|
" from db_battinf.tb_battinf where StationName1 like '%${stationName1}%' and StationName2 like '%${stationName2}%' and StationName5 like '%${stationName5}%' "
|
+ " and StationName3=#{stationName3} "
|
+ " ORDER BY StationName4 asc,battgroupId asc ")
|
public List<BattInf> serchAllBattinf(BattInf obj);
|
|
/**查询所有省/市/区/站点机房*/
|
@Deprecated
|
public Map searchAllStation(int uid);
|
|
// 查电池品牌
|
@Select("select DISTINCT(BattProducer) from db_battinf.tb_battinf ORDER BY BattProducer")
|
public List<String> serchByBattProducer();
|
|
// 查单体电压
|
@Select("select DISTINCT(MonVolStd) from db_battinf.tb_battinf ")
|
public List<String> serchByMonVolStd();
|
|
// 查电池容量
|
@Select("select DISTINCT(MonCapStd) from db_battinf.tb_battinf ORDER BY MonCapStd")
|
public List<String> serchByMonCapStd();
|
|
// 查系统类型
|
public List serchByBattGroupName1();
|
|
//查设备总数
|
/*public int serchByDeviceId(){
|
String sql=" SELECT COUNT(DISTINCT fbsdeviceid) number FROM db_battinf.tb_battinf limit 1";
|
List<BattInf> list=DateUtil.executeQuery(sql, DBUtil.getConn(), new Object[]{}, new CallBack() {
|
|
public List getResults(ResultSet rs) {
|
List list=new ArrayList();
|
try {
|
while(rs.next()){
|
BattInf binf=new BattInf();
|
binf.setNum(rs.getInt("number"));
|
list.add(binf);
|
}
|
} catch (SQLException e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
return list;
|
}
|
|
});
|
int number=0;//存放总数
|
if(list!=null&&list.size()>0){
|
number=list.get(list.size()-1).getNum();
|
}
|
return number;
|
}*/
|
public int serchByDeviceId(Object obj);
|
|
//-根据蓄电池组查不重复的MonCount(monNum)（单体编号）
|
@Select("select battGroupName,moncount,signalname from db_battinf.tb_battinf where battgroupid=#{battGroupId} order by signalname")
|
public List<BattInf> serchByMonNum(BattInf obj);
|
@Select("select * from db_battinf.tb_battinf where battgroupid=#{battGroupId}")
|
public List<BattInf> serchByBattgroupId(BattInf obj);
|
|
//3.1/3.2/0.1/6.2/6.4.3/6.4.4根据battgroupid查机房名称和电池组名称/查capstdolstd/moncount/serstd
|
@Select("select distinct(stationname),battgroupname,moncapstd,monserstd,monvolstd,moncount from db_battinf.tb_battinf where battgroupid=#{battGroupId} ")
|
public List<BattInf> serchByCondition(BattInf obj);
|
|
//1.1根据选择的信息查满足条件的battgroupid
|
/*public List serchByConditionNew(Object obj) {
|
Batt_Maint_Dealarm bmd = (Batt_Maint_Dealarm) obj;
|
List list = null;
|
BattInf binf = bmd.getBinf();
|
Batt_maint_inf mainf = bmd.getMainf();
|
Batttestdata_inf tdata = bmd.getTdata();
|
User_inf uinf=bmd.getUinf();
|
String sql="";
|
String baseSql="select distinct(db_battinf.tb_battinf.BattgroupId),db_battinf.tb_battinf.stationid,StationName1,StationName,stationip,BattGroupName,BattGroupName1,battgroupnum,moncount,moncapstd,monvolstd,battproducer,battproductdate,battinusedate "
|
+ ",maint_done_time"
|
+ ",test_record_count,test_starttime,test_type,test_curr,test_timelong,max_monvol,min_monvol,test_cap,data_new "
|
+",db_user.tb_user_battgroup_baojigroup_battgroup.battgroupid,db_user.tb_user_inf.uId,db_user.tb_user_inf.uName "
|
+ "from db_battinf.tb_battinf "
|
+ "left outer join db_battinf.tb_batt_maint_inf on db_battinf.tb_battinf.BattgroupId=db_battinf.tb_batt_maint_inf.BattGroupId "
|
+ "left outer join db_batt_testdata.tb_batttestdata_inf on db_battinf.tb_battinf.BattgroupId=db_batt_testdata.tb_batttestdata_inf.BattGroupId " +
|
"left outer join db_user.tb_user_battgroup_baojigroup_battgroup on db_user.tb_user_battgroup_baojigroup_battgroup.battgroupid=db_battinf.tb_battinf.BattgroupId " +
|
"left outer join db_user.tb_user_battgroup_baojigroup_usr on db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id= db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id " +
|
"left outer join db_user.tb_user_inf on db_user.tb_user_inf.uId=db_user.tb_user_battgroup_baojigroup_usr.uid " +
|
"where to_days(battproductdate)>=to_days(?) and to_days(battproductdate)<=to_days(?) and to_days(battinusedate)>=to_days(?) and to_days(battinusedate)<=to_days(?)";
|
//用于维护区
|
String station1SqlT=" and stationname1!=? ";//全部
|
String station1SqlF=" and stationname1=? ";
|
if(binf.getStationName1().equals("")){
|
baseSql+=station1SqlT;
|
}else{
|
baseSql+=station1SqlF;
|
}
|
//用于机房站点
|
String stationSqlT=" and stationname!=? ";//全部
|
String stationSqlF=" and stationname=? ";
|
if(binf.getStationName().equals("")){
|
baseSql+=stationSqlT;
|
}else{
|
baseSql+=stationSqlF;
|
}
|
//用于电池类型
|
String producerSqlT=" and battproducer!=? ";//全部
|
String producerSqlF=" and battproducer=? ";
|
if(binf.getBattProducer().equals("")){
|
baseSql+=producerSqlT;
|
}else{
|
baseSql+=producerSqlF;
|
}
|
//用于电池测试记录条件:
|
//放电/充电单个/有在线监测记录
|
String testSqlH=" and db_battinf.tb_battinf.BattGroupId in(select distinct(db_batt_testdata.tb_batttestdata_inf.BattGroupId ) from db_batt_testdata.tb_batttestdata_inf where db_batt_testdata.tb_batttestdata_inf.test_type=? and to_days(record_time)>=to_days(?) and to_days(record_time)<=to_days(?) and to_days(test_starttime)<=to_days(record_time)) ";
|
//内阻/电导
|
String testSqlF=" and db_battinf.tb_battinf.BattGroupId in(select distinct(db_batt_testdata.tb_battresdata_inf.BattGroupId ) from db_batt_testdata.tb_battresdata_inf where db_batt_testdata.tb_battresdata_inf.test_type!=? and to_days(record_time)>=to_days(?) and to_days(record_time)<=to_days(?) and to_days(test_starttime)<=to_days(record_time)) ";
|
//充电或者放电都行
|
String testSqlT=" and db_battinf.tb_battinf.BattGroupId in(select distinct(db_batt_testdata.tb_batttestdata_inf.BattGroupId ) from db_batt_testdata.tb_batttestdata_inf where db_batt_testdata.tb_batttestdata_inf.test_type in(?,2,3) and to_days(record_time)>=to_days(?) and to_days(record_time)<=to_days(?) and to_days(test_starttime)<=to_days(record_time)) ";
|
//无记录
|
String testSqlN=" and db_battinf.tb_battinf.BattGroupId not in(select distinct(db_batt_testdata.tb_batttestdata_inf.BattGroupId ) from db_batt_testdata.tb_batttestdata_inf where db_batt_testdata.tb_batttestdata_inf.test_type in(?,2,3) and to_days(record_time)>=to_days(?) and to_days(record_time)<=to_days(?) and to_days(test_starttime)<=to_days(record_time)) " +
|
" and db_battinf.tb_battinf.BattGroupId not in(select distinct(db_batt_testdata.tb_battresdata_inf.BattGroupId ) from db_batt_testdata.tb_battresdata_inf where db_batt_testdata.tb_battresdata_inf.test_type in (?,5) and to_days(record_time)>=to_days(?) and to_days(record_time)<=to_days(?) and to_days(test_starttime)<=to_days(record_time)) " ;
|
//全部
|
String testSqlA=" and db_battinf.tb_battinf.BattGroupId!=(select count(distinct(db_batt_testdata.tb_batttestdata_inf.BattGroupId )) from db_batt_testdata.tb_batttestdata_inf where db_batt_testdata.tb_batttestdata_inf.test_type in(?,2,3) and to_days(record_time)>=to_days(?) and to_days(record_time)<=to_days(?) and to_days(test_starttime)<=to_days(record_time)) " ;
|
if(tdata.getTest_type()==2){
|
baseSql+=testSqlH;
|
}else if(tdata.getTest_type()==3){
|
baseSql+=testSqlH;
|
}else if(tdata.getTest_type()==9){//有在线监测记录
|
baseSql+=testSqlH;
|
}else if(tdata.getTest_type()==5000){
|
baseSql+=testSqlF;
|
}else if(tdata.getTest_type()==3000){//充电或放电
|
baseSql+=testSqlT;
|
}else if(tdata.getTest_type()==4000){//无记录
|
baseSql+=testSqlN;
|
}else if(tdata.getTest_type()==0){
|
baseSql+=testSqlA;
|
}
|
//选取蓄电池组条件
|
String idSqlT=" and db_battinf.tb_battinf.battgroupid!=? ";
|
String idSqlF=" and db_battinf.tb_battinf.battgroupid=? ";
|
if(binf.getBattGroupId()==0){
|
baseSql+=idSqlT;
|
}else{
|
baseSql+=idSqlF;
|
}
|
//选取系统类型
|
String nameSqlT=" and BattGroupName1 like ? ";
|
String nameSqlF=" and BattGroupName1 not like '%开关电源系统%' and BattGroupName1 not like '%UPS系统%' and BattGroupName1 not like ? ";
|
if(binf.getBattGroupName1().equals("其他")){
|
baseSql+=nameSqlF;
|
}else{
|
baseSql+=nameSqlT;
|
}
|
//用于单体电压
|
String volSqlT=" and monVolStd!=? ";//全部
|
String volSqlF=" and monVolStd=?" ;
|
if(binf.getMonVolStd()==0){
|
baseSql+=volSqlT;
|
}else{
|
baseSql+=volSqlF;
|
}
|
//用于电池容量
|
String capSqlT=" and monCapStd!=? ";//全部
|
String capSqlF=" and monCapStd=?" ;
|
if(binf.getMonCapStd()==0){
|
baseSql+=capSqlT;
|
}else{
|
baseSql+=capSqlF;
|
}
|
//包机人
|
String userSqlF=" and db_user.tb_user_inf.uname=? and db_user.tb_user_inf.ubaojiusr=1 ";
|
if(uinf.getuName().equals("0")){
|
baseSql=baseSql;
|
}else{
|
baseSql+=userSqlF;
|
}
|
//用于测试类型
|
//全部
|
String start_typeA=" ";
|
//拉闸放电
|
String start_typeF=" and test_starttype<5 and test_type not in(2,9) and test_starttype!=2 ";
|
//核对性放电
|
String start_typeT=" and test_starttype>=5 or (test_type not in(2,9) and test_starttype=2) ";
|
if(tdata.getTest_starttype()==0){
|
baseSql+=start_typeA;
|
}else if(tdata.getTest_starttype()==1){
|
baseSql+=start_typeF;
|
}else if(tdata.getTest_starttype()==2){
|
baseSql+=start_typeT;
|
}
|
//用于电池维护记录条件
|
//有维护记录
|
String maintSqlT=" and db_battinf.tb_battinf.BattGroupId in(select db_battinf.tb_batt_maint_inf.battgroupid from db_battinf.tb_batt_maint_inf where to_days(maint_done_time)>=to_days(?) and to_days(maint_done_time)<=to_days(?)) " ;
|
//无维护记录
|
String maintSqlF=" and db_battinf.tb_battinf.BattGroupId not in(select db_battinf.tb_batt_maint_inf.battgroupid from db_battinf.tb_batt_maint_inf where to_days(maint_done_time)>=to_days(?) and to_days(maint_done_time)<=to_days(?)) " ;
|
//全部
|
String maintSqlA=" and db_battinf.tb_battinf.BattGroupId!=(select count(distinct(db_battinf.tb_batt_maint_inf.battgroupid )) from db_battinf.tb_batt_maint_inf where to_days(maint_done_time)>=to_days(?) and to_days(maint_done_time)<=to_days(?)) " ;
|
|
if(mainf.getRemark().equals("0")){
|
baseSql+=maintSqlF;
|
}else if(mainf.getRemark().equals("1")){
|
baseSql+=maintSqlT;
|
}else if(mainf.getRemark().equals("100")){
|
baseSql+=maintSqlA;
|
}
|
String endSql=" order by StationName1 asc,db_battinf.tb_battinf.BattgroupId asc,test_starttime asc ";
|
|
sql=baseSql+endSql;
|
//System.out.println(sql);
|
if(tdata.getTest_type()==4000){
|
if(uinf.getuName().equals("0")){
|
list = DateUtil.executeQuery(
|
sql,
|
DBUtil.getConn(),
|
new Object[] {
|
binf.getBattProductDate(),
|
binf.getBattProductDate1(),
|
binf.getBattInUseDate(),
|
binf.getBattInUseDate1(),
|
binf.getStationName1(),
|
binf.getStationName(),
|
binf.getBattProducer(),
|
|
tdata.getTest_type(),
|
tdata.getRecord_time(),
|
tdata.getRecord_time1(),
|
tdata.getTest_type(),
|
tdata.getRecord_time(),
|
tdata.getRecord_time1(),
|
binf.getBattGroupId(),
|
"%"+binf.getBattGroupName1()+"%",
|
binf.getMonVolStd(),
|
binf.getMonCapStd(),
|
mainf.getMaint_done_time(),
|
mainf.getMaint_done_time1()
|
},
|
new BattInfImpl());
|
}else{
|
list = DateUtil.executeQuery(
|
sql,
|
DBUtil.getConn(),
|
new Object[] {
|
binf.getBattProductDate(),
|
binf.getBattProductDate1(),
|
binf.getBattInUseDate(),
|
binf.getBattInUseDate1(),
|
binf.getStationName1(),
|
binf.getStationName(),
|
binf.getBattProducer(),
|
|
tdata.getTest_type(),
|
tdata.getRecord_time(),
|
tdata.getRecord_time1(),
|
tdata.getTest_type(),
|
tdata.getRecord_time(),
|
tdata.getRecord_time1(),
|
binf.getBattGroupId(),
|
"%"+binf.getBattGroupName1()+"%",
|
binf.getMonVolStd(),
|
binf.getMonCapStd(),
|
uinf.getuName(),
|
mainf.getMaint_done_time(),
|
mainf.getMaint_done_time1()
|
},
|
new BattInfImpl());
|
}
|
}else{
|
if(uinf.getuName().equals("0")){
|
list = DateUtil.executeQuery(
|
sql,
|
DBUtil.getConn(),
|
new Object[] {
|
binf.getBattProductDate(),
|
binf.getBattProductDate1(),
|
binf.getBattInUseDate(),
|
binf.getBattInUseDate1(),
|
binf.getStationName1(),
|
binf.getStationName(),
|
binf.getBattProducer(),
|
|
tdata.getTest_type(),
|
tdata.getRecord_time(),
|
tdata.getRecord_time1(),
|
binf.getBattGroupId(),
|
"%"+binf.getBattGroupName1()+"%",
|
binf.getMonVolStd(),
|
binf.getMonCapStd(),
|
mainf.getMaint_done_time(),
|
mainf.getMaint_done_time1()
|
},
|
new BattInfImpl());
|
}else{
|
list = DateUtil.executeQuery(
|
sql,
|
DBUtil.getConn(),
|
new Object[] {
|
binf.getBattProductDate(),
|
binf.getBattProductDate1(),
|
binf.getBattInUseDate(),
|
binf.getBattInUseDate1(),
|
binf.getStationName1(),
|
binf.getStationName(),
|
binf.getBattProducer(),
|
|
tdata.getTest_type(),
|
tdata.getRecord_time(),
|
tdata.getRecord_time1(),
|
binf.getBattGroupId(),
|
"%"+binf.getBattGroupName1()+"%",
|
binf.getMonVolStd(),
|
binf.getMonCapStd(),
|
uinf.getuName(),
|
mainf.getMaint_done_time(),
|
mainf.getMaint_done_time1()
|
},
|
new BattInfImpl());
|
}
|
}
|
|
// System.out.println(list.size());
|
List<Batt_Maint_Dealarm> listd=new ArrayList();
|
for(int i=0;i<list.size();i++){
|
System.out.println(((Batt_Maint_Dealarm)list.get(i)).getBinf().getBattGroupId());
|
}
|
int index=0;
|
//System.out.println(list.size());
|
for(int i=(bmd.getPage().getPageCurr()-1)*bmd.getPage().getPageSize();i<bmd.getPage().getPageSize()*bmd.getPage().getPageCurr()&&i<list.size();i++){
|
listd.add((Batt_Maint_Dealarm) list.get(i));
|
//system.out.println(list.get(i));
|
((Batt_Maint_Dealarm)listd.get(index++)).getPage().setPageAll(list.size());
|
}
|
return listd;
|
}*/
|
//1.1根据选择的信息查满足条件的battgroupid
|
public List serchByConditionNew(Object obj);
|
|
//1.4电池组后评估(分页查询电池组信息)
|
/*public List serchGroupAssess(Object obj) {
|
Batt_Maint_Dealarm bmd = (Batt_Maint_Dealarm) obj;
|
BattInf binf = bmd.getBinf();
|
Page page =bmd.getPage();
|
User_inf uinf=bmd.getUinf();
|
Connection conn=DBUtil.getConn();
|
String numberSql=" SELECT FOUND_ROWS() number";
|
String sql="";
|
String baseSql=" select SQL_CALC_FOUND_ROWS distinct(db_battinf.tb_battinf.BattgroupId),db_battinf.tb_battinf.stationid,StationName1,StationName,stationip,BattGroupName,BattGroupName1,moncount,moncapstd,monvolstd,battproducer,battproductdate,battinusedate " +
|
" from db_battinf.tb_battinf " +
|
" left outer join db_user.tb_user_battgroup_baojigroup_battgroup on db_user.tb_user_battgroup_baojigroup_battgroup.battgroupid=db_battinf.tb_battinf.BattgroupId " +
|
" left outer join db_user.tb_user_battgroup_baojigroup_usr on db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id= db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id " +
|
" left outer join db_user.tb_user_inf on db_user.tb_user_inf.uId=db_user.tb_user_battgroup_baojigroup_usr.uid " +
|
" where battproductdate>=? and battproductdate<=? and battinusedate>=? and battinusedate<=?";
|
//用于维护区
|
String station1SqlT=" and stationname1!=? ";//全部
|
String station1SqlF=" and stationname1=? ";
|
if(binf.getStationName1().equals("")){
|
baseSql+=station1SqlT;
|
}else{
|
baseSql+=station1SqlF;
|
}
|
//用于机房站点
|
String stationSqlT=" and stationname!=? ";//全部
|
String stationSqlF=" and stationname=? ";
|
if(binf.getStationName().equals("")){
|
baseSql+=stationSqlT;
|
}else{
|
baseSql+=stationSqlF;
|
}
|
//用于电池类型
|
String producerSqlT=" and battproducer!=? ";//全部
|
String producerSqlF=" and battproducer=? ";
|
if(binf.getBattProducer().equals("")){
|
baseSql+=producerSqlT;
|
}else{
|
baseSql+=producerSqlF;
|
}
|
//选取蓄电池组条件
|
String idSqlT=" and db_battinf.tb_battinf.battgroupid!=? ";
|
String idSqlF=" and db_battinf.tb_battinf.battgroupid=? ";
|
if(binf.getBattGroupId()==0){
|
baseSql+=idSqlT;
|
}else{
|
baseSql+=idSqlF;
|
}
|
//选取系统类型
|
String nameSqlT=" and BattGroupName1 like ? ";
|
String nameSqlF=" and BattGroupName1 not like '%开关电源系统%' and BattGroupName1 not like '%UPS系统%' and BattGroupName1 not like ? ";
|
if(binf.getBattGroupName1().equals("其他")){
|
baseSql+=nameSqlF;
|
}else{
|
baseSql+=nameSqlT;
|
}
|
//用于单体电压
|
String volSqlT=" and monVolStd!=? ";//全部
|
String volSqlF=" and monVolStd=?" ;
|
if(binf.getMonVolStd()==0){
|
baseSql+=volSqlT;
|
}else{
|
baseSql+=volSqlF;
|
}
|
//用于电池容量
|
String capSqlT=" and monCapStd!=? ";//全部
|
String capSqlF=" and monCapStd=?" ;
|
if(binf.getMonCapStd()==0){
|
baseSql+=capSqlT;
|
}else{
|
baseSql+=capSqlF;
|
}
|
//用于包机人条件
|
String userSqlT="and db_battinf.tb_battinf.battgroupid!=? ";//全部
|
String userSqlF="and db_user.tb_user_inf.uId=? and db_user.tb_user_inf.ubaojiusr=1 ";
|
if(uinf.getuId()==0){
|
baseSql+=userSqlT;
|
}else{
|
baseSql+=userSqlF;
|
}
|
//排序
|
String endSql=" order by db_battinf.tb_battinf.battgroupid asc ";
|
//分页
|
String limitSql=" limit ?,? ";
|
//最终结果
|
sql=baseSql+endSql+limitSql;
|
//System.out.println(sql);
|
List<BattInf> list=DateUtil.executeQueryLimit(sql,conn, new Object[]{
|
binf.getBattProductDate(),binf.getBattProductDate1(),binf.getBattInUseDate(),binf.getBattInUseDate1()
|
,binf.getStationName1(),binf.getStationName(),binf.getBattProducer(),binf.getBattGroupId()
|
,"%"+binf.getBattGroupName1()+"%",binf.getMonVolStd(),binf.getMonCapStd(),uinf.getuId()
|
,(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize()}, new CallBack() {
|
|
public List getResults(ResultSet rs) {
|
List list=new ArrayList();
|
try {
|
|
while(rs.next()){
|
BattInf binf=new BattInf();
|
binf.setBattGroupId(rs.getInt("battGroupId"));
|
binf.setStationId(rs.getString("stationId"));
|
binf.setStationName1(rs.getString("stationName1"));
|
binf.setStationName(rs.getString("stationName"));
|
binf.setStationIp(rs.getString("stationIp"));
|
binf.setBattGroupName(rs.getString("battGroupName"));
|
binf.setBattGroupName1(rs.getString("battGroupName1"));
|
binf.setMonCount(rs.getInt("monCount"));
|
binf.setMonCapStd(rs.getFloat("monCapStd"));
|
binf.setMonVolStd(rs.getFloat("monVolStd"));
|
binf.setBattProducer(rs.getString("battProducer"));
|
binf.setBattProductDate(rs.getDate("battProductDate"));
|
binf.setBattInUseDate(rs.getDate("battInUseDate"));
|
|
list.add(binf);
|
}
|
} catch (SQLException e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
return list;
|
}
|
});
|
//去掉limit条件后的总数
|
int number=LimitNumberFactory.GetLimtitNumber(conn, numberSql);
|
//System.out.println("number: "+number);
|
if(list!=null&&list.size()>0){
|
list.get(list.size()-1).setSize(number);
|
}
|
|
return list;
|
}*/
|
//1.4电池组后评估(分页查询电池组信息)
|
public List serchGroupAssess(Object obj);
|
|
//1.2电池组统计分析查询
|
/*public List serchByTestType(Object obj) {
|
Batt_Maint_Dealarm bmd = (Batt_Maint_Dealarm) obj;
|
BattInf binf = bmd.getBinf();
|
Page page =bmd.getPage();
|
Batttestdata_inf tinf=bmd.getTdata();
|
Connection conn=DBUtil.getConn();
|
String sql="";
|
String baseSql=" select distinct(db_battinf.tb_battinf.BattgroupId),StationName1,StationName,stationip,BattGroupName,BattGroupName1,moncount,moncapstd,monvolstd,battproducer,battproductdate,battinusedate " +
|
" ,db_batt_testdata.tb_batttestdata_inf.test_record_count,test_starttime " +
|
"from db_battinf.tb_battinf,db_batt_testdata.tb_batttestdata_inf " +
|
" where db_battinf.tb_battinf.battgroupid=db_batt_testdata.tb_batttestdata_inf.battgroupid " +
|
" and battproductdate>=? and battproductdate<=? and battinusedate>=? and battinusedate<=? " +
|
" and record_time>=? and record_time<=? ";
|
//用于维护区
|
String station1SqlT=" and stationname1!=? ";//全部
|
String station1SqlF=" and stationname1=? ";
|
if(binf.getStationName1().equals("")){
|
baseSql+=station1SqlT;
|
}else{
|
baseSql+=station1SqlF;
|
}
|
//用于机房站点
|
String stationSqlT=" and stationname!=? ";//全部
|
String stationSqlF=" and stationname=? ";
|
if(binf.getStationName().equals("")){
|
baseSql+=stationSqlT;
|
}else{
|
baseSql+=stationSqlF;
|
}
|
//用于电池类型
|
String producerSqlT=" and battproducer!=? ";//全部
|
String producerSqlF=" and battproducer=? ";
|
if(binf.getBattProducer().equals("")){
|
baseSql+=producerSqlT;
|
}else{
|
baseSql+=producerSqlF;
|
}
|
//选取蓄电池组条件
|
String idSqlT=" and db_battinf.tb_battinf.battgroupid!=? ";
|
String idSqlF=" and db_battinf.tb_battinf.battgroupid=? ";
|
if(binf.getBattGroupId()==0){
|
baseSql+=idSqlT;
|
}else{
|
baseSql+=idSqlF;
|
}
|
//选取系统类型
|
String nameSqlT=" and BattGroupName1 like ? ";
|
String nameSqlF=" and BattGroupName1 not like '%开关电源系统%' and BattGroupName1 not like '%UPS系统%' and BattGroupName1 not like ? ";
|
if(binf.getBattGroupName1().equals("其他")){
|
baseSql+=nameSqlF;
|
}else{
|
baseSql+=nameSqlT;
|
}
|
//用于单体电压
|
String volSqlT=" and monVolStd!=? ";//全部
|
String volSqlF=" and monVolStd=?" ;
|
if(binf.getMonVolStd()==0){
|
baseSql+=volSqlT;
|
}else{
|
baseSql+=volSqlF;
|
}
|
//用于电池容量
|
String capSqlT=" and monCapStd!=? ";//全部
|
String capSqlF=" and monCapStd=?" ;
|
if(binf.getMonCapStd()==0){
|
baseSql+=capSqlT;
|
}else{
|
baseSql+=capSqlF;
|
}
|
//充电放电选择
|
String test_typeA="";//全部
|
String test_typeR=" and test_type=2 ";//充电
|
//用于放电类型
|
//全部
|
String start_typeA=" and test_type=3 ";
|
//停电放电
|
String start_typeF=" and (test_starttype<5 and test_type not in(2,9) and test_starttype!=2 AND test_starttype!=3) ";
|
//假负载放电2
|
String start_typeT=" and (test_starttype=2 and test_type not in(2) ) ";
|
//节能放电3
|
String start_typeH=" and (test_starttype=3 and test_type not in(2) ) ";
|
if(tinf.getTest_type()==0){
|
baseSql+=test_typeA;
|
}else if(tinf.getTest_type()==2){
|
baseSql+=test_typeR;
|
}else if(tinf.getTest_type()==3){
|
if(tinf.getTest_starttype()==0){
|
baseSql+=start_typeA;
|
}else if(tinf.getTest_starttype()==1){
|
baseSql+=start_typeF;
|
}else if(tinf.getTest_starttype()==2){
|
baseSql+=start_typeT;
|
}else if(tinf.getTest_starttype()==3){
|
baseSql+=start_typeH;
|
}
|
}
|
|
//排序
|
String endSql=" order by db_battinf.tb_battinf.battgroupid asc,test_starttime asc ";
|
//最终结果
|
sql=baseSql+endSql;
|
//System.out.println(sql);
|
List<BattInf> list=DateUtil.executeQuery(sql,DBUtil.getConn(), new Object[]{
|
binf.getBattProductDate(),binf.getBattProductDate1(),binf.getBattInUseDate(),binf.getBattInUseDate1()
|
,tinf.getRecord_time(),tinf.getRecord_time1()
|
,binf.getStationName1(),binf.getStationName(),binf.getBattProducer(),binf.getBattGroupId()
|
,"%"+binf.getBattGroupName1()+"%",binf.getMonVolStd(),binf.getMonCapStd()
|
}, new CallBack() {
|
|
public List getResults(ResultSet rs) {
|
List list=new ArrayList();
|
try {
|
|
while(rs.next()){
|
BattInf binf=new BattInf();
|
binf.setBattGroupId(rs.getInt("battGroupId"));
|
binf.setStationName1(rs.getString("stationName1"));
|
binf.setStationName(rs.getString("stationName"));
|
binf.setStationIp(rs.getString("stationIp"));
|
binf.setBattGroupName(rs.getString("battGroupName"));
|
binf.setBattGroupName1(rs.getString("battGroupName1"));
|
binf.setMonCount(rs.getInt("monCount"));
|
binf.setMonCapStd(rs.getFloat("monCapStd"));
|
binf.setMonVolStd(rs.getFloat("monVolStd"));
|
binf.setBattProducer(rs.getString("battProducer"));
|
binf.setBattProductDate(rs.getDate("battProductDate"));
|
binf.setBattInUseDate(rs.getDate("battInUseDate"));
|
binf.setNum(rs.getInt("test_record_count"));
|
list.add(binf);
|
}
|
} catch (SQLException e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
return list;
|
}
|
});
|
|
return list;
|
}*/
|
//1.2电池组统计分析查询
|
public List serchByTestType(Object obj);
|
|
//4.1作业管理——创建模板查询
|
public List serchBattgroup(Batt_Maint_Dealarm obj);
|
|
//8.1放电计划管理中查询(旧版本)
|
public List serchBattgroupinfo1(Object obj);
|
|
//8.1放电计划管理中默认进图查询
|
/*public List serchBattgroupinfo(Object obj){
|
User_inf uinf=(User_inf) obj;
|
String sql="select DISTINCT stationid,BattgroupId,StationName,StationName1,stationip,BattGroupName,BattGroupName1,battgroupnum,moncount,moncapstd,monvolstd,battproducer,battproductdate,battinusedate,groupIndexInFBSDevice " +
|
" FROM db_battinf.tb_battinf " +
|
" where StationId in(" +
|
" select distinct db_user.tb_user_battgroup_baojigroup_battgroup.StationId from db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr where db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id=db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id and db_user.tb_user_battgroup_baojigroup_usr.uId=?" +
|
" )";
|
List<BattInf> list = DateUtil.executeQuery(
|
sql,
|
DBUtil.getConn(),
|
new Object[] {uinf.getuId()},new CallBack() {
|
public List getResults(ResultSet rs) {
|
List list=new ArrayList();
|
int id=0;
|
try {
|
while(rs.next()){
|
BattInf binf=new BattInf();
|
binf.setBattGroupId(rs.getInt("battGroupId"));
|
if(id==rs.getInt("battGroupId")){
|
continue;//去除重复项
|
}else{
|
id=rs.getInt("battGroupId");
|
}
|
binf.setStationName(rs.getString("stationName"));
|
binf.setStationName1(rs.getString("stationName1"));
|
binf.setStationIp(rs.getString("stationIp"));
|
binf.setBattGroupName(rs.getString("battGroupName"));
|
binf.setBattGroupName1(rs.getString("battGroupName1"));
|
binf.setBattGroupNum(rs.getInt("battGroupNum"));
|
binf.setMonCount(rs.getInt("monCount"));
|
binf.setMonCapStd(rs.getFloat("monCapStd"));
|
binf.setMonVolStd(rs.getFloat("monVolStd"));
|
binf.setBattProducer(rs.getString("battProducer"));
|
binf.setBattProductDate(rs.getDate("battProductDate"));
|
binf.setBattInUseDate(rs.getDate("battInUseDate"));
|
binf.setGroupIndexInFBSDevice(rs.getInt("groupIndexInFBSDevice"));
|
list.add(binf);
|
}
|
} catch (SQLException e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
return list;
|
}
|
});
|
|
return list;
|
}*/
|
|
@Select("select distinct db_battinf.tb_battinf.battgroupid,db_battinf.tb_battinf.stationid,StationName,StationName1,stationip,BattGroupName,BattGroupName1,battgroupnum,moncount,moncapstd,monvolstd,battproducer,battproductdate,battinusedate,groupIndexInFBSDevice " +
|
"from db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf " +
|
"where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid and db_user.tb_user_inf.uid=#{uId}")
|
public List<BattInf> serchBattgroupinfo(User_inf obj);
|
|
//新版添加放电计划查询<排除设置过放电计划的电池组>
|
public List serchBattPlan(BattInf obj);
|
|
//4.1根据维护区查询所有的电池组和对应的包机人(从模板创建)
|
public List serchByTemplate(Object obj);
|
|
//4.1根据维护区查询该维护区中还未加入到各类作业的电池组数(从模板创建)
|
public List serchBattNotInTask(Object obj);
|
|
//模糊查询
|
public List serchByInfo(Object obj);
|
|
//根据电池组id查询电池的基本信息
|
@Select("select DISTINCT(StationName),BattGroupId,BattGroupName,BattProducer,MonVolStd,MonCapStd,MonCount,BattProductDate,BattInUseDate from db_battinf.tb_battinf where BattGroupId=#{battGroupId}")
|
public List<BattInf> searchBattBybattgroupid(BattInf obj);
|
|
//6.3会根据电池组名称查询电池id
|
public int serchByName(Object obj);
|
|
//6.4数据统计报表查询(分地域查地域所在总电池数)
|
public List<BattInf> serchBylevel(int level);
|
|
//6.4.7按地域和标称电压分组统计蓄电池组服役超期的数量
|
/*
|
* 区域层次放在stationid中*/
|
public List<BattInf> serchBeyondTime(BattInf obj);
|
|
//6.4.8按地域和标称电压分组统计蓄电池组的数量(蓄电池组数量统计)
|
/*
|
* 区域层次放在stationid中*/
|
public List<BattInf> serchByMonVolStdGroup(BattInf obj);
|
|
//6.4.9按地域和标称电压分组统计蓄电池组品牌的数量(蓄电池供应商信息统计)
|
/*
|
* 区域层次放在stationid中*/
|
public List<BattInf> serchByBattProducerGroup(BattInf obj);
|
|
//1 根据机房id查询电池组id排序最小值
|
@Select("select distinct stationName,stationName1,stationName2,stationName3,stationName4,stationName5 from db_battinf.tb_battinf where stationid=#{stationId} order by battgroupid asc limit 1 ")
|
public List<BattInf> serchByIdLow(BattInf obj);
|
|
//6.4.10按地域和标称电压分组统计蓄电池组使用时间(蓄电池投产年限统计)
|
/*
|
* 区域层次放在stationid中*/
|
public List<BattInf> serchByBattInUseDateGroup(BattInf obj);
|
|
//9.1根据stationid查询机房电池组数和每组电池组中单体的个数(机房信息内容画图)
|
@Select(" select distinct db_battinf.tb_battinf.battgroupid,db_battinf.tb_battinf.battgroupname ,db_battinf.tb_battinf.moncount,db_battinf.tb_battinf.stationid,db_battinf.tb_battinf.moncapstd," +
|
" db_battinf.tb_battinf.battproductdate,db_battinf.tb_battinf.battinusedate " +
|
" from db_battinf.tb_battinf " +
|
" where db_battinf.tb_battinf.stationid=#{stationId}")
|
public List<BattInf> serchMonNum(BattMap_information obj);
|
|
//9.1根据电池组stationid查询电池组的信息(电池寿命管理)
|
@Select(" select distinct db_battinf.tb_battinf.battgroupid,db_battinf.tb_battinf.battgroupname ,db_battinf.tb_battinf.moncount,db_battinf.tb_battinf.stationid,db_battinf.tb_battinf.moncapstd," +
|
" db_battinf.tb_battinf.battproductdate,db_battinf.tb_battinf.battinusedate,db_battinf.tb_battinf.BattProducer,db_battinf.tb_battinf.BattModel,db_battinf.tb_battinf.MonVolStd " +
|
" from db_battinf.tb_battinf " +
|
" where db_battinf.tb_battinf.stationid=#{stationId}")
|
public List<BattInf> serchByStationid(BattMap_information obj);
|
/**
|
* 根据机房id查询电池组
|
* @param obj
|
* @return
|
*/
|
public List searchBattByStationId(Object obj);
|
|
//根据battgroupid查询机房id
|
@Select("SELECT DISTINCT db_battinf.tb_battinf.FBSDeviceId as dev_id from db_battinf.tb_battinf where battgroupid=#{battGroupId}")
|
public Integer serchDev_id(BattInf binf);
|
|
//查询总的单体数（电池健康率）
|
/*public int serchMonAll(){
|
String sql="select sum(moncount) as moncounts from db_battinf.tb_battinf limit 1";
|
List list=DateUtil.executeQuery(sql, DBUtil.getConn(), null, new CallBack() {
|
|
public List getResults(ResultSet rs) {
|
List list=new ArrayList();
|
try {
|
while(rs.next()){
|
int moncounts=rs.getInt("moncounts");
|
list.add(moncounts);
|
}
|
} catch (SQLException e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
return list;
|
}
|
});
|
int moncounts=0;//单体总个数
|
if(list!=null&&list.size()>0){
|
moncounts=(Integer) list.get(list.size()-1);
|
}
|
return moncounts;
|
|
}*/
|
|
@Select("select sum(moncount) as moncounts " +
|
" from db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf " +
|
" where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId " +
|
" and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id " +
|
" and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid " +
|
" and db_user.tb_user_inf.uid=#{uId}" +
|
" limit 1")
|
public Integer serchMonAll(User_inf obj);
|
|
//测试
|
public List searchStationId(Object obj);
|
|
//查询所有的机房
|
@Select("select DISTINCT stationid,StationName,StationName1,StationName2,StationName3,StationName4,StationName5," +
|
"StationName6,StationName7,StationName8,StationName9,fBSDeviceId " +
|
"FROM db_battinf.tb_battinf where StationId " +
|
"in( select distinct db_user.tb_user_battgroup_baojigroup_battgroup.StationId " +
|
"from db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr " +
|
"where db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id=db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id and db_user.tb_user_battgroup_baojigroup_usr.uId=#{uId} )")
|
public List<BattInf> serchAllStation(User_inf obj);
|
|
//根据机房id查询机房下的电池组信息
|
@Select("select DISTINCT StationName,StationName1,StationName2,StationName3,StationName4,StationName5,StationId,StationIP,FBSDeviceId,BattGroupName,BattGroupName1,BattGroupName2,MonCount,battgroupId,MonCapStd,MonVolStd,MonResStd,MonSerStd,BattProducer,BattInUseDate,GroupIndexInFBSDevice,Load_curr,DisCurrMax " +
|
"from db_battinf.tb_battinf where stationid=#{stationId} " +
|
"ORDER BY StationName1,battgroupId ")
|
public List<BattInf> serchBattByStation(BattInf obj);
|
|
//搜索机房或电池组
|
public List<BattInf> serchStationOrBattgroup(BattInf obj);
|
|
//查询所有的电池组数
|
@Select("select count(distinct battgroupid) as nums from db_battinf.tb_battinf " +
|
" where battgroupid in(" +
|
" select distinct db_user.tb_user_battgroup_baojigroup_battgroup.battgroupid from db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr where db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id=db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id and db_user.tb_user_battgroup_baojigroup_usr.uId=#{uId}" +
|
" ) " +
|
" and stationid in(" +
|
" select distinct db_user.tb_user_battgroup_baojigroup_battgroup.stationid from db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr where db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id=db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id and db_user.tb_user_battgroup_baojigroup_usr.uId=#{uId}" +
|
" ) " +
|
" limit 1")
|
public int serchAllBatt(User_inf obj);
|
|
//添加电池组时查询出最大的机房id和电池组id
|
@Select("select max(StationId) as id from db_battinf.tb_battinf limit 1")
|
public int searchMaxId_zj();
|
|
//查询出当前存在内存中最大的设备的id(很重要**********)
|
public int searchMaxdevId_binf_zj();
|
|
//查询出当前存在内存中最大的电池组id(很重要**********)
|
@Select(" select max(battgroupId) as id from db_battinf.tb_battinf limit 1")
|
public int searchMaxBattgroupId_zj();
|
|
//查站点下的所有设备名称
|
@Select(" select distinct(stationName4) from db_battinf.tb_battinf " +
|
"where stationname1 like '%${stationName1}%' and stationname2 like '%${stationName2}%' " +
|
"and stationname5 like '%${stationName5}%' and stationname3 like '%${stationName3}%' ")
|
public List<String> searchDevByStationName3(BattInf obj);
|
|
//根据维护区和机房名称查询电池组信息(电池组信息配置)<-------跨域->
|
@Select("select distinct(StationId),StationId_ex,StationName,StationName1,StationName2,StationName3,StationName4,StationName5,StationIp,FBSDeviceId,FbsDeviceIp_YM,FbsDeviceIp_WG,FbsDeviceIp,"
|
+ "FBSDeviceName,GroupIndexInFBSDevice,battgroupId,BattGroupNum,BattGroupName,FloatVolLevel,OfflineVolLevel,BattFloatCurrent" +
|
",MonCount,MonCapStd,monVolStd,monResStd,MonSerStd,MonVolLowToAvg,BattProducer,BattModel,BattProductDate,BattInUseDate,battGuarantDayCount,SignalId,CInterFaceId,Load_curr,install_user,DisCurrMax,SignalName,Station_install,station_phone " +
|
" From db_battinf.tb_battinf " +
|
" order by StationId ")
|
public List<BattInf> searchInform_ky();
|
|
//首页上根据stationid查询电池组的机历卡
|
@Select("select * from db_battinf.tb_battinf where db_battinf.tb_battinf.stationId=#{stationId} order by db_battinf.tb_battinf.battgroupid")
|
public List<BattInf> serchBattAllInfoByStationId(BattInf obj);
|
|
//-查询电池组信息<大屏显示>
|
@Select(" select DISTINCT StationName,StationName1,StationName2,StationName3,StationName4,StationName5,StationId,FBSDeviceId,BattGroupName,battgroupId,monVolStd,monCapStd " +
|
" from db_battinf.tb_battinf "
|
+ " ORDER BY StationId asc,battgroupId asc ")
|
public List<BattInf> serchBatt_DP(Object obj);
|
|
//紫晶山西-机房列表
|
@Select("select distinct(StationId),StationId_ex,StationName,StationName1,StationName2,StationName3,StationName4,StationName5,StationIp,FBSDeviceId,FbsDeviceIp_YM,FbsDeviceIp_WG,FbsDeviceIp,"
|
+ "FBSDeviceName,GroupIndexInFBSDevice,battgroupId,BattGroupNum,BattGroupName,FloatVolLevel,OfflineVolLevel,BattFloatCurrent" +
|
",MonCount,MonCapStd,monVolStd,monResStd,MonSerStd,MonVolLowToAvg,BattProducer,BattModel,BattProductDate,BattInUseDate,battGuarantDayCount,SignalId,CInterFaceId,Load_curr,install_user,DisCurrMax,SignalName,Station_install,station_phone " +
|
" From db_battinf.tb_battinf " +
|
" order by StationId asc,battgroupId asc")
|
public List<BattInf> searchStationList();
|
|
|
/*public static void main(String[] args) throws ParseException {
|
//new BattInfImpl().searchAll();
|
|
BattInfImpl biml = new BattInfImpl();
|
BattInf binf = new BattInf();
|
binf.setNum(1002);
|
binf.setBattGroupId(0);
|
binf.setStationName("内蒙古");
|
binf.setStationName1("");
|
binf.setStationName2("");
|
binf.setStationName5("");
|
binf.setStationName3("");
|
binf.setStationId("42070450");
|
|
User_inf uinf=new User_inf();
|
uinf.setuId(1002);
|
|
Page p=new Page();
|
p.setPageCurr(1);
|
p.setPageSize(50);
|
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
|
Date date1 = sdf.parse("2000-01-01");
|
Date date2 = sdf.parse("2020-01-01");
|
Batttestdata_inf tdata = new Batttestdata_inf();
|
tdata.setTest_type(3);
|
tdata.setTest_starttype(3);
|
tdata.setRecord_time(ActionUtil.getSimpDate(date1));
|
tdata.setRecord_time1(ActionUtil.getSimpDate(date2));
|
|
Batt_Maint_Dealarm bmd = new Batt_Maint_Dealarm();
|
bmd.setBinf(binf);
|
bmd.setPage(p);
|
bmd.setTdata(tdata);
|
bmd.setUinf(uinf);
|
//List<BattInf> list = biml.serchByConditionNew(bmd);
|
//List<BattInf> list=biml.serchByTestType(bmd);
|
*//*List<BattInf> list=biml.serchGroupAssess(bmd);
|
for (BattInf b : list) {
|
System.out.println(b);
|
}*//*
|
*//*List<BattInf> list=biml.serchBattPlan(binf);
|
for (BattInf b : list) {
|
System.out.println(b.getBattGroupId()+" "+b.getFBSDeviceId()+" "+b.getFparam());
|
}*//*
|
//List list=biml.searchDevByStationName3(binf);
|
List list=biml.serchBattAllInfoByStationId(binf);
|
System.out.println(list.size());
|
}
|
*/
|
}
|
