Merge branch 'master' of http://118.89.139.230:10101/r/fg_v2.0
| | |
| | | |
| | | import java.util.Date; |
| | | |
| | | /**故障隐患上报 确认库*/ |
| | | /** |
| | | * 故障隐患上报 确认库 |
| | | * 说明:故障隐患上报 确认库 -> 管理层审核完了后,会进入 故障隐患 申报库 |
| | | * */ |
| | | @TableName(schema = "web_site",value = "tb_fault_upload") |
| | | @JsonIgnoreProperties(ignoreUnknown = true) |
| | | public class FaultUpload { |
| | |
| | | |
| | | import java.util.Date; |
| | | |
| | | /**故障隐患上报 申报库*/ |
| | | /** |
| | | * 故障隐患上报 申报库 |
| | | * 说明:故障隐患上报 确认库 -> 管理层审核完了后,会进入 故障隐患 申报库 |
| | | * */ |
| | | @TableName(schema = "web_site",value = "tb_fault_upload_application") |
| | | public class FaultUploadApplication { |
| | | |
| | |
| | | </select> |
| | | |
| | | <select id="getDevNum" resultType="java.lang.Integer"> |
| | | select count(distinct FBSDeviceIp) from db_battinf.tb_battinf where StationId in(select distinct db_battinf.tb_battinf.StationId |
| | | select count(distinct FBSDeviceIp,comm_port) from db_battinf.tb_battinf where StationId in(select distinct db_battinf.tb_battinf.StationId |
| | | 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 |
| | |
| | | |
| | | |
| | | <select id="getStationInfWithSpecificMainId" resultType="com.whyc.pojo.StationInf"> |
| | | select stt.stationName3,stt.stationName5,apl.main_id as togetherFlag from web_site.tb_fault_upload_application apl left join db_battinf.tb_station_inf stt on apl.station_id = stt.stationId |
| | | select stt.stationName3,stt.stationName5,apl.main_id as togetherFlag from web_site.tb_fault_upload apl left join db_battinf.tb_station_inf stt on apl.station_id = stt.stationId |
| | | <where> |
| | | <if test="list!=null and list.size() > 0"> |
| | | apl.main_id in |