ID_, COMPANY_ID_, SN_, NUMBER_, ROAD_SEGMENT_ID_, OFFICE_ID_, START_PEG_, DIRECTION_, PROTECT_TYPE_, PROTECT_MATERIAL_, HEIGHT_, LENGTH_, PROTECTIVE_DIMENSION_, CONSTRUCTION_SITUATION_, GEOLOGY_, IS_HIGH_RISK_, IS_RAMP_, X_, Y_, START_PEG_K_, END_PEG_K_, DIRECTION_VALUE_, CREATE_BY_, CREATE_ORG_ID_, CREATE_TIME_, UPDATE_BY_, UPDATE_TIME_, TENANT_ID_ a.ID_ AS "sideSlopeInformation.id", a.COMPANY_ID_ AS "sideSlopeInformation.companyId", a.SN_ AS "sideSlopeInformation.sn", a.NUMBER_ AS "sideSlopeInformation.number", a.ROAD_SEGMENT_ID_ AS "sideSlopeInformation.roadSegmentId", a.OFFICE_ID_ AS "sideSlopeInformation.officeId", a.START_PEG_ AS "sideSlopeInformation.startPeg", a.DIRECTION_ AS "sideSlopeInformation.direction", a.PROTECT_TYPE_ AS "sideSlopeInformation.protectType", a.PROTECT_MATERIAL_ AS "sideSlopeInformation.protectMaterial", a.HEIGHT_ AS "sideSlopeInformation.height", a.LENGTH_ AS "sideSlopeInformation.length", a.PROTECTIVE_DIMENSION_ AS "sideSlopeInformation.protectiveDimension", a.CONSTRUCTION_SITUATION_ AS "sideSlopeInformation.constructionSituation", a.GEOLOGY_ AS "sideSlopeInformation.geology", a.IS_HIGH_RISK_ AS "sideSlopeInformation.isHighRisk", a.IS_RAMP_ AS "sideSlopeInformation.isRamp", a.X_ AS "sideSlopeInformation.x", a.Y_ AS "sideSlopeInformation.y", a.START_PEG_K_ AS "sideSlopeInformation.startPegK", a.END_PEG_K_ AS "sideSlopeInformation.endPegK", a.DIRECTION_VALUE_ AS "sideSlopeInformation.directionValue", b.ID_ AS "road.id", b.NUMBER_ AS "road.number", b.NAME_ AS "road.name", b.ADDRESS_ AS "road.address", b.ROUTE_ID_ AS "road.routeId", b.SIMPLICITY_ AS "road.simplicity", b.DESIGN_DEEP_ AS "road.designDeep", b.TYPE_ AS "road.type", b.LENGTH_ AS "road.length", b.WIDTH_ AS "road.width", b.ROADSURFACE_TYPE_ AS "road.roadsurfaceType", b.TECHNOLOGY_CLASS_ AS "road.technologyClass", b.DRIVEWAY_TYPE_ AS "road.drivewayType", b.DRIVEWAY_WIDTH_ AS "road.drivewayWidth", b.STARTING_POINT_ AS "road.startingPoint", b.TERMINAL_POINT_ AS "road.terminalPoint", b.START_PEG_ AS "road.startPeg", b.END_PEG_ AS "road.endPeg", b.PASS_DAY_ AS "road.passDay", b.TYPE_VALUE_ AS "road.typeValue", b.START_PEG_K_ AS "road.startPegK", b.END_PEG_K_ AS "road.endPegK", b.ROADSURFACE_TYPE_VALUE_ AS "road.roadsurfaceTypeValue", b.TECHNOLOGY_CLASS_VALUE_ AS "road.technologyClassValue", b.DRIVEWAY_TYPE_VALUE_ AS "road.drivewayTypeValue" SELECT FROM biz_side_slope_information a INNER JOIN biz_road_section b ON a.ROAD_SEGMENT_ID_ = b.ID_ ${ew.customSqlSegment} SELECT e.*, ( SELECT date_add( e.CHECK_DATE_, INTERVAL ( SELECT `value` FROM portal_sys_properties e WHERE e.alias = "side_slope_often_check" ) MONTH ) )as CHECK_NEW_DAY_ FROM ( SELECT ( CASE WHEN ( SELECT date_sub(( SELECT date_add( b.CHECK_DATE_, INTERVAL ( SELECT `value` FROM portal_sys_properties e WHERE e.alias = "side_slope_often_check" ) MONTH )), INTERVAL ( SELECT `value` FROM portal_sys_properties e WHERE e.alias = "side_slope_daily_check_wran_date" ) DAY )) > now() THEN 0 WHEN b.CHECK_DATE_ IS NULL THEN 0 ELSE 1 END ) AS 'temporary',a.*,b.* FROM biz_side_slope_information a LEFT JOIN ( SELECT Max( c.CHECK_DATE_ ) 'CHECK_DATE_', c.SIDE_SLOPE_ID_ FROM biz_side_slope_often_check c WHERE c.IS_DELE_ = '0' GROUP BY c.SIDE_SLOPE_ID_ ) b ON a.ID_ = b.SIDE_SLOPE_ID_ WHERE a.IS_DELE_ = '0' ) e ${ew.customSqlSegment} AND checkDate>=#{map.startTime,jdbcType=TIMESTAMP} AND checkDate <=#{map.endTime,jdbcType=TIMESTAMP} SELECT * FROM biz_side_slope_information ${ew.customSqlSegment} AND ROAD_SEGMENT_ID_ IN ( SELECT ID_ FROM biz_road_section WHERE IS_DELE_ = '0' AND ROUTE_ID_ =#{map.routeId} ) SELECT e.*, ( SELECT date_add( e.CHECK_DATE_, INTERVAL ( SELECT `value` FROM portal_sys_properties e WHERE e.alias = "side_slope_regular_check" ) YEAR ) )as CHECK_NEW_DAY_ FROM ( SELECT ( CASE WHEN ( SELECT date_sub(( SELECT date_add( b.CHECK_DATE_, INTERVAL ( SELECT `value` FROM portal_sys_properties e WHERE e.alias = "side_slope_regular_check" ) YEAR )), INTERVAL ( SELECT `value` FROM portal_sys_properties e WHERE e.alias = "side_slope_regular_check_warn_date" ) DAY )) > now() THEN 0 WHEN b.CHECK_DATE_ IS NULL THEN 0 ELSE 1 END ) AS 'temporary' ,a.*,b.* FROM biz_side_slope_information a LEFT JOIN ( SELECT Max( c.CHECK_DATE_ ) 'CHECK_DATE_', c.SIDE_SLOPE_ID_ FROM biz_side_slope_regular_check c WHERE c.IS_DELE_ = '0' GROUP BY c.SIDE_SLOPE_ID_ ) b ON a.ID_ = b.SIDE_SLOPE_ID_ WHERE a.IS_DELE_ = '0' )e ${ew.customSqlSegment} AND checkDate>=#{map.startTime,jdbcType=TIMESTAMP} AND checkDate <=#{map.endTime,jdbcType=TIMESTAMP}