ID, callid, phone, userid, username, leadtype, leadtypeValue, subordinate, subordinateValue, calltime, duration, entry_time, region_name, region_code, region_shortname, road_id, road_name, road_code, delete_status, update_timestamp, batch_number SELECT r.id_ AS roadId, r.name_ AS roadName, count(ca.id) AS totalNum, count(CASE WHEN leadtype='公共服务' THEN ca.id END) AS ggfwNum, count(CASE WHEN leadtype='突发事件' THEN ca.id END) AS tfsjNum, count(CASE WHEN leadtype='通知' THEN ca.id END) AS tzNum, count(CASE WHEN leadtype='施工' THEN ca.id END) AS sgNum, count(CASE WHEN leadtype='其他' THEN ca.id END) AS qtNum FROM biz_base_road r LEFT JOIN biz_call_agents ca ON r.id_ = ca.road_id AND ca.calltime BETWEEN DATE(#{dto.startTime}) AND DATE(#{dto.endTime}) AND r.ID_ IN #{orgId} GROUP BY r.id_,r.name_ SELECT '合计' AS roadName, count(ca.id) AS totalNum, count(CASE WHEN leadtype='公共服务' THEN ca.id END) AS ggfwNum, count(CASE WHEN leadtype='突发事件' THEN ca.id END) AS tfsjNum, count(CASE WHEN leadtype='通知' THEN ca.id END) AS tzNum, count(CASE WHEN leadtype='施工' THEN ca.id END) AS sgNum, count(CASE WHEN leadtype='其他' THEN ca.id END) AS qtNum FROM biz_base_road r JOIN biz_call_agents ca ON r.id_ = ca.road_id AND ca.calltime BETWEEN DATE(#{dto.startTime}) AND DATE(#{dto.endTime}) AND r.ID_ IN #{orgId}