diff --git a/casic-data/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordMapper.xml b/casic-data/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordMapper.xml index 2828eb5..a730841 100644 --- a/casic-data/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordMapper.xml +++ b/casic-data/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordMapper.xml @@ -4,23 +4,23 @@ - - - - - - - - - - - - - - - - - + + + + + + + + + + + + + + + + + @@ -30,12 +30,16 @@ - bi.MONITOR_NAME AS monitorName, bi.DEVICE_IP AS deviceIp, bi.DEVICE_PORT AS devicePort, bi.DEVICE_USER AS deviceUser, bi.DEVICE_PASSWORD AS devicePassword, bi.NVR_IP AS nvrIp, bi.NVR_PORT AS nvrPort, bi.NVR_CHANNEL AS nvrChannel, bi.NVR_USER AS nvrUser, bi.NVR_PASSWORD AS nvrPassword + bi.MONITOR_NAME AS monitorName, bi.DEVICE_IP AS deviceIp, bi.DEVICE_PORT AS devicePort, bi.DEVICE_USER AS deviceUser, bi.DEVICE_PASSWORD AS devicePassword, bi.NVR_IP AS nvrIp, bi.NVR_PORT AS nvrPort, bi.NVR_CHANNEL AS nvrChannel, bi.NVR_USER AS nvrUser, bi.NVR_PASSWORD AS nvrPassword SELECT - distinct(ar.ID) AS id, ar.MONITOR_ID AS monitorId,ar.DETAIL AS detail, ar.DEVICE_CODE AS deviceCode, ar.ALARM_TYPE AS alarmType, ar.ALARM_CONTENT AS alarmContent, ar.ALARM_VALUE AS alarmValue, ar.ALARM_THRESH AS alarmThresh, ar.ALARM_DIRECTION AS alarmDirection, ar.ALARM_PITCH AS alarmPitch, ar.ALARM_TIME AS alarmTime, ar.ALARM_STATUS AS alarmStatus, ar.CANCEL_TIME AS cancelTime, ar.CANCEL_USER AS cancelUser, ar.RESUME_TIME AS resumeTime, ar.LINE_NUM AS lineNum, ar.SERIAL_NUM AS serialNum, ar.TS AS ts, + distinct(ar.ID) AS id, ar.MONITOR_ID AS monitorId,ar.DETAIL AS detail, ar.DEVICE_CODE AS deviceCode, + ar.ALARM_TYPE AS alarmType, ar.ALARM_CONTENT AS alarmContent, ar.ALARM_VALUE AS alarmValue, ar.ALARM_THRESH AS + alarmThresh, ar.ALARM_DIRECTION AS alarmDirection, ar.ALARM_PITCH AS alarmPitch, ar.ALARM_TIME AS alarmTime, + ar.ALARM_STATUS AS alarmStatus, ar.CANCEL_TIME AS cancelTime, ar.CANCEL_USER AS cancelUser, ar.RESUME_TIME AS + resumeTime, ar.LINE_NUM AS lineNum, ar.SERIAL_NUM AS serialNum, ar.TS AS ts, , bs.STATION_NAME as stationName, bo.LINE_NAME as lineName @@ -119,26 +127,26 @@ SELECT - , + distinct(ar.ID) AS id, ar.MONITOR_ID AS monitorId, ar.DEVICE_CODE AS deviceCode, ar.ALARM_TYPE AS alarmType, + ar.ALARM_CONTENT AS alarmContent, ar.ALARM_VALUE AS alarmValue, ar.ALARM_THRESH AS alarmThresh, + ar.ALARM_DIRECTION AS alarmDirection, ar.ALARM_PITCH AS alarmPitch, ar.ALARM_TIME AS alarmTime, ar.ALARM_STATUS + AS alarmStatus, ar.CANCEL_TIME AS cancelTime, ar.CANCEL_USER AS cancelUser, ar.RESUME_TIME AS resumeTime, + ar.LINE_NUM AS lineNum, ar.SERIAL_NUM AS serialNum, ar.TS AS ts, bi.MONITOR_NAME as monitorName, bs.STATION_NAME as stationName, bo.LINE_NAME as lineName @@ -48,16 +52,16 @@ bi.VALID = 0 AND bs.VALID = 0 - and bi.STATION_ID = #{request.stationId} + and bi.STATION_ID = #{request.stationId} AND ar.MONITOR_ID = #{request.monitorId} - AND ar.ALARM_TYPE = #{request.alarmType} + AND ar.ALARM_TYPE = #{request.alarmType} - AND ar.ALARM_STATUS= #{request.alarmStatus} + AND ar.ALARM_STATUS= #{request.alarmStatus} AND ar.ALARM_TIME = ]]> #{request.startTime} @@ -70,7 +74,11 @@ - SELECT DATE_FORMAT(ALARM_TIME, '%Y-%m-%d') AS alarmTime,count(ar.id) AS count + SELECT DATE_FORMAT(ALARM_TIME, '%Y-%m-%d') AS alarmTime,count(ar.id) AS count FROM alarm_record ar JOIN ( - SELECT id,STATION_ID - FROM bus_monipoi_info - WHERE VALID = 0 - - AND id = #{request.monitorId} - + SELECT id,STATION_ID + FROM bus_monipoi_info + WHERE VALID = 0 + + AND id = #{request.monitorId} + )bi ON ar.MONITOR_ID = bi.ID JOIN ( - SELECT ID,DEPT_ID - FROM bus_station_info - WHERE VALID=0 - - AND ID = #{request.stationId} - + SELECT ID,DEPT_ID + FROM bus_station_info + WHERE VALID=0 + + AND ID = #{request.stationId} + ) bs ON bs.ID = bi.STATION_ID left join bus_obserpoi_info bo on (bo.MONITOR_ID= ar.MONITOR_ID and bo.LINE_NUM=ar.LINE_NUM) - WHERE 1=1 + WHERE 1=1 AND ar.ALARM_TIME = ]]> #{request.startTime} @@ -149,26 +157,26 @@