| | |
|---|
| | | jfpth.blade_region.`name` as addvnm |
|---|
| | | FROM |
|---|
| | | sys_alarm a LEFT JOIN sys_equipment e on e.deviceNumber=a.deviceNumber LEFT JOIN jfpth.blade_region on jfpth.blade_region.`code`=a.district where |
|---|
| | | DATE_FORMAT(alarmTime,'%Y-%m-%d') >=#{beginTime} and DATE_FORMAT(alarmTime,'%Y-%m-%d') <=#{endTime} and a.waringType NOT IN("系统测试","主机重新上电") ORDER BY alarmTime desc |
|---|
| | | DATE_FORMAT(alarmTime,'%Y-%m-%d') >=#{beginTime} and DATE_FORMAT(alarmTime,'%Y-%m-%d') <=#{endTime} and a.waringType IN("紧急求救") ORDER BY alarmTime desc |
|---|
| | | </select> |
|---|
| | | |
|---|
| | | |
|---|
