ID_, COMPANY_ID_, COMPANY_IDS_, COMPANY_NAME_,LAT_,LNG_, ROAD_SEGMENT_ID_, ROAD_SEGMENT_NAME_, DEVICE_NAME_, DEVICE_CODE_, TYPE_, DETAIL_TYPE_, DETAIL_TYPE_NAME_,STATE_, TP_BRIDGE_NAME_, TP_BRIDGE_CODE_,TP_BRIDGE_ID_,TP_BRIDGE_TYPE_, TR_BRIDGE_ID_, CREATE_BY_, CREATE_ORG_NAME_, CREATE_COMPANY_ID_, CREATE_COMPANY_NAME_, CREATE_NAME_, CREATE_ORG_ID_, CREATE_TIME_, UPDATE_BY_, UPDATE_NAME_, UPDATE_COMPANY_NAME_, UPDATE_COMPANY_ID_, UPDATE_ORG_ID_, UPDATE_ORG_NAME_, UPDATE_TIME_, LAST_TIME_, IS_DELE_, VERSION_, TENANT_ID_ SELECT * FROM BIZ_TP_DEVICE ${ew.customSqlSegment} AND ROAD_SEGMENT_ID_ IN ( SELECT ID_ FROM biz_road_section WHERE IS_DELE_ = '0' AND ROUTE_ID_ =#{map.routeId} ) SELECT COUNT (ID_) as total, IFNULL(SUM(CASE WHEN STATE_ = 1 THEN 1 ELSE 0 END),0) AS onlineCount, IFNULL(SUM(CASE WHEN STATE_ = 0 THEN 1 ELSE 0 END),0) AS offlineCount FROM BIZ_TP_DEVICE ${ew.customSqlSegment} AND ROAD_SEGMENT_ID_ IN ( SELECT ID_ FROM biz_road_section WHERE IS_DELE_ = '0' AND ROUTE_ID_ =#{map.routeId} )