id_, conf_id_, device_code_, warn_name_, warn_time_, warn_threshold_, warn_reason_, warn_data_,warn_data_id_, handle_id_, handle_status_, handle_user_, handle_result_, handle_time_,handle_completion_, version_, last_time_ SELECT count(*) as count FROM (SELECT DEVICE_CODE_ FROM device_warn_info WHERE DEVICE_TYPE_ = #{deviceType} GROUP BY DEVICE_CODE_) a SELECT * FROM device_warn_info WHERE DEVICE_CODE_ = #{deviceCode} AND WARN_TYPE_ = #{warnType} AND HANDLE_STATUS_ = 0 AND WARN_TIME_ = ( SELECT max( WARN_TIME_ ) FROM device_warn_info WHERE DEVICE_CODE_ = #{deviceCode} ) select * from ( (select warn.*, area.NAME_ areaName, dpt.name_ productType, di.name_ deviceName from device_warn_info warn inner join device_info di on di.code_ = warn.DEVICE_CODE_ and di.IS_DELE_ = '0' LEFT JOIN device_product_info dpi ON di.PRODUCT_ID_ = dpi.id_ LEFT JOIN device_product_type dpt ON dpi.type_id_ = dpt.id_ left join device_base_area area on di.area_id_ = area.ID_ and area.IS_DELE_ = '0' ) union all (select warn.*, area.NAME_ areaName, '摄像头' productType, di.name_ deviceName from device_warn_info warn inner join device_video_point di on di.code_ = warn.DEVICE_CODE_ and di.IS_DELE_ = '0' left join device_video_point_extend vpe on di.code_ = vpe.code_ left join device_base_area area on vpe.area_id_ = area.ID_ and area.IS_DELE_ = '0' ) ) warn ${ew.customSqlSegment} SELECT bwi.HANDLE_STATUS_ status,dpt.name_ type , date_format(bwi.WARN_TIME_, '%Y-%m') time , date_format(bwi.WARN_TIME_, '%Y-%m-%d') time FROM device_warn_info bwi LEFT JOIN device_info di ON di.code_ = bwi.device_code_ LEFT JOIN device_product_info pi ON pi.id_ = di.product_id_ LEFT JOIN device_product_type dpt ON dpt.id_ = pi.type_id_ WHERE bwi.WARN_TYPE_ = 2 and DATE_FORMAT(bwi.WARN_TIME_, #{dto.dateType}) = #{dto.time} DATE_FORMAT(now(), #{dto.dateType}) select count(1) count, DATE_FORMAT(warn_time_, '%Y-%m') month from device_warn_info warn where warn_time_ >= DATE_SUB(warn_time_, INTERVAL 12 MONTH) group by month select count(1) count, ifnull(dba.name_, '') area from device_warn_info dwi left join device_info di on di.code_ = dwi.device_code_ left join device_base_area dba on dba.id_ = di.area_id_ where dwi.warn_time_ now() and dba.name_ is not null group by dba.name_ SELECT count(1) count, dpt.name_ type FROM device_warn_info bwi LEFT JOIN device_info di ON di.code_ = bwi.device_code_ LEFT JOIN device_product_info pi ON pi.id_ = di.product_id_ LEFT JOIN device_product_type dpt ON dpt.id_ = pi.type_id_ WHERE pi.device_type_ IS NOT NULL AND DATE_FORMAT( bwi.WARN_TIME_, #{dto.dateType} ) = #{dto.time} AND bwi.HANDLE_STATUS_ = #{dto.warnStatus} GROUP BY type