ID_, PLAN_ID_, TASK_ID_, RESULT_ID_, PATROL_ID_, PEG_VAL_, LNG_, LAT_, INSPECT_TIME_, INSPECT_INFO_, INSPECT_USER_ID_, INSPECT_USER_NAME_, HANDLE_TYPE_, INSPECT_STATUS_, IS_REPORT_, REPORT_TEL_, FILE_URL_, TEAM_ID_, TEAM_FULL_ID_, CREATE_BY_, CREATE_ORG_ID_, CREATE_ORG_NAME_, CREATE_COMPANY_ID_, CREATE_COMPANY_NAME_, CREATE_NAME_, 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 d.*, r.ROAD_CODE_ AS roadCode, r.ROAD_NAME_ AS roadName, p.DIRECTION_ AS patrolDirection, p.CATEGORY_ AS patrolCategory, p.CONTENT_ AS content FROM biz_inspection_result_detail d LEFT JOIN biz_inspection_result r ON r.ID_ = d.RESULT_ID_ LEFT JOIN biz_base_patrol p ON p.ID_ = d.patrol_id_ WHERE d.RESULT_ID_ = #{resultId} AND d.IS_DELE_ = '0' SELECT d.*, r.ROAD_CODE_ AS roadCode, r.ROAD_NAME_ AS roadName, p.DIRECTION_ AS patrolDirection, p.CATEGORY_ AS patrolCategory, p.CONTENT_ AS content FROM biz_inspection_result_detail d LEFT JOIN biz_inspection_result r ON r.ID_ = d.RESULT_ID_ LEFT JOIN biz_base_patrol p ON p.ID_ = d.patrol_id_ WHERE d.TASK_ID_ = #{taskId} AND d.IS_DELE_ = '0' SELECT * FROM ( SELECT d.*, r.ROAD_CODE_ AS roadCode, r.ROAD_NAME_ AS roadName FROM biz_inspection_result_detail d LEFT JOIN biz_inspection_result r ON r.ID_ = d.RESULT_ID_ LEFT JOIN biz_base_patrol p ON p.ID_ = d.patrol_id_ )s ${ew.customSqlSegment} SELECT d.*, r.ROAD_CODE_ AS roadCode, r.ROAD_NAME_ AS roadName, p.DIRECTION_ AS patrolDirection, p.CATEGORY_ AS patrolCategory, p.CONTENT_ AS content FROM biz_inspection_result_detail d LEFT JOIN biz_inspection_result r ON r.ID_ = d.RESULT_ID_ LEFT JOIN biz_base_patrol p ON p.ID_ = d.patrol_id_ WHERE d.id_ = #{id} AND d.IS_DELE_ = '0' SELECT d.*, r.ROAD_CODE_ AS roadCode, r.ROAD_NAME_ AS roadName, p.CONTENT_ AS content FROM biz_inspection_result_detail d LEFT JOIN biz_inspection_result r ON r.ID_ = d.RESULT_ID_ LEFT JOIN biz_base_patrol p ON p.ID_ = d.patrol_id_ AND p.IS_DELE_='0' WHERE d.IS_DELE_ = '0' AND r.IS_DELE_='0' AND d.TASK_ID_=#{taskId} ORDER BY d.CREATE_TIME_ DESC SELECT count(1) AS zsNum, count(case when rd.handle_type_=1 then 1 end) AS wclNum, count(case when rd.handle_type_=2 then 1 end) AS yclNum FROM biz_inspection_result_detail rd JOIN biz_inspection_task t ON rd.task_id_=t.id_ WHERE rd.is_dele_ = '0' AND t.is_dele_ = '0' AND INSPECT_STATUS_ =0 AND TASK_DATE_ between #{startTime} and #{endTime} AND t.road_id_ IN #{id} SELECT rd.*, t.road_name_ FROM biz_inspection_result_detail rd JOIN biz_inspection_task t ON rd.task_id_=t.id_ AND rd.is_dele_ = '0' AND t.is_dele_ = '0' AND INSPECT_STATUS_ =0 ${ew.customSqlSegment} AND TASK_DATE_ >= #{ew.paramNameValuePairs.startTime} AND TASK_DATE_ #{ew.paramNameValuePairs.endTime} AND HANDLE_TYPE_=#{handType} AND t.road_id_ IN #{id} SELECT rd.TASK_ID_ AS taskId, rd.INSPECT_TIME_, CASE WHEN rd.TYPE_ =1 OR rd.CATEGORY_=2 THEN rd.PEG_VAL_ ELSE IFNULL(bp.NAME_,rd.PEG_VAL_) END AS name, rd.INSPECT_INFO_ AS inspectInfo, CASE rd.INSPECT_STATUS_ WHEN 1 THEN '无异常' ELSE CONCAT('异常点位:',rd.HANDLE_CONTENT_) END AS handInfo FROM biz_inspection_result_detail rd LEFT JOIN biz_base_patrol bp ON rd.PATROL_ID_=bp.id_ WHERE rd.is_dele_='0' AND rd.TASK_ID_ IN #{id}