c.ID_ AS 'siteInspection.id', c.MANAGE_UNIT_ID_ AS 'siteInspection.manageUnitId', c.MANAGE_UNIT_NAME_ AS 'siteInspection.manageUnitName', c.ROAD_SEGMENT_ID_ AS 'siteInspection.roadSegmentId', c.ROAD_SEGMENT_NAME_ AS 'siteInspection.roadSegmentName', c.TYPE_ AS 'siteInspection.type', c.COMPANY_ID_ AS 'siteInspection.companyId', c.COMPANY_NAME_ AS 'siteInspection.companyName', c.PATROL_DATE_ AS 'siteInspection.patrolDate', c.START_TIME_ AS 'siteInspection.startTime', c.END_TIME_ AS 'siteInspection.endTime', c.WEATHER_ AS 'siteInspection.weather', c.WEATHER_VALUE_ AS 'siteInspection.weatherValue', c.RUMMAGER_ID_ AS 'siteInspection.rummagerId', c.RUMMAGER_ACCOUNT_ AS 'siteInspection.rummagerAccount', c.RECORDER_ID_ AS 'siteInspection.recorderId', c.RECORDER_ACCOUNT_ AS 'siteInspection.recorderAccount', c.PROBLEM_ AS 'siteInspection.problem', c.CONTENT_ AS 'siteInspection.content', c.CREATE_BY_ AS 'siteInspection.createBy', c.CREATE_ORG_NAME_ AS 'siteInspection.createOrgName', c.CREATE_COMPANY_ID_ AS 'siteInspection.createCompanyName', c.CREATE_COMPANY_NAME_ AS 'siteInspection.createCompanyName', c.CREATE_NAME_ AS 'siteInspection.createName', c.CREATE_ORG_ID_ AS 'siteInspection.createOrgId', c.CREATE_TIME_ AS 'siteInspection.createTime', c.UPDATE_BY_ AS 'siteInspection.updateBy', c.UPDATE_NAME_ AS 'siteInspection.updateName', c.UPDATE_COMPANY_NAME_ AS 'siteInspection.updateCompanyName', c.UPDATE_COMPANY_ID_ AS 'siteInspection.updateCompanyId', c.UPDATE_ORG_ID_ AS 'siteInspection.updateOrgId', c.UPDATE_ORG_NAME_ AS 'siteInspection.updateOrgName', c.UPDATE_TIME_ AS 'siteInspection.updateTime', c.LAST_TIME_ AS 'siteInspection.lastTime', c.IS_DELE_ AS 'siteInspection.isDele', c.VERSION_ AS 'siteInspection.version', d.id_ AS 'defaultBpmCheckOpinion.id', d.proc_def_id_ AS 'defaultBpmCheckOpinion.procDefId', d.sup_inst_id_ AS 'defaultBpmCheckOpinion.supInstId', d.proc_inst_id_ AS 'defaultBpmCheckOpinion.procInstId', d.task_id_ AS 'defaultBpmCheckOpinion.taskId', d.task_key_ AS 'defaultBpmCheckOpinion.taskKey', d.task_name_ AS 'defaultBpmCheckOpinion.taskName', d.token_ AS 'defaultBpmCheckOpinion.token', d.qualfieds_ AS 'defaultBpmCheckOpinion.qualfieds', d.qualfied_names_ AS 'defaultBpmCheckOpinion.qualfiedNames', d.auditor_ AS 'defaultBpmCheckOpinion.auditor', d.auditor_name_ AS 'defaultBpmCheckOpinion.auditorName', d.opinion_ AS 'defaultBpmCheckOpinion.opinion', d.status_ AS 'defaultBpmCheckOpinion.status', d.is_read_ AS 'defaultBpmCheckOpinion.isRead', d.form_def_id_ AS 'defaultBpmCheckOpinion.formDefId', d.agent_leader_id_ AS 'defaultBpmCheckOpinion.agentLeaderId', d.sign_type_ AS 'defaultBpmCheckOpinion.signType', d.skip_type_ AS 'defaultBpmCheckOpinion.skipType', d.form_name_ AS 'defaultBpmCheckOpinion.formName', d.create_time_ AS 'defaultBpmCheckOpinion.createTime', d.assign_time_ AS 'defaultBpmCheckOpinion.assignTime', d.complete_time_ AS 'defaultBpmCheckOpinion.completeTime', d.dur_ms_ AS 'defaultBpmCheckOpinion.durMs', d.z_files_ AS 'defaultBpmCheckOpinion.zfiles', d.interpose_ AS 'defaultBpmCheckOpinion.interpose', d.org_id_ AS 'defaultBpmCheckOpinion.orgId', d.org_path_ AS 'defaultBpmCheckOpinion.orgPath' c.ID_ AS 'siteInspection.id', c.MANAGE_UNIT_ID_ AS 'siteInspection.manageUnitId', c.MANAGE_UNIT_NAME_ AS 'siteInspection.manageUnitName', c.ROAD_SEGMENT_ID_ AS 'siteInspection.roadSegmentId', c.ROAD_SEGMENT_NAME_ AS 'siteInspection.roadSegmentName', c.TYPE_ AS 'siteInspection.type', c.COMPANY_ID_ AS 'siteInspection.companyId', c.COMPANY_NAME_ AS 'siteInspection.companyName', c.PATROL_DATE_ AS 'siteInspection.patrolDate', c.START_TIME_ AS 'siteInspection.startTime', c.END_TIME_ AS 'siteInspection.endTime', c.WEATHER_ AS 'siteInspection.weather', c.WEATHER_VALUE_ AS 'siteInspection.weatherValue', c.RUMMAGER_ID_ AS 'siteInspection.rummagerId', c.RUMMAGER_ACCOUNT_ AS 'siteInspection.rummagerAccount', c.RECORDER_ID_ AS 'siteInspection.recorderId', c.RECORDER_ACCOUNT_ AS 'siteInspection.recorderAccount', c.PROBLEM_ AS 'siteInspection.problem', c.CONTENT_ AS 'siteInspection.content', c.CREATE_BY_ AS 'siteInspection.createBy', c.CREATE_ORG_NAME_ AS 'siteInspection.createOrgName', c.CREATE_COMPANY_ID_ AS 'siteInspection.createCompanyName', c.CREATE_COMPANY_NAME_ AS 'siteInspection.createCompanyName', c.CREATE_NAME_ AS 'siteInspection.createName', c.CREATE_ORG_ID_ AS 'siteInspection.createOrgId', c.CREATE_TIME_ AS 'siteInspection.createTime', c.UPDATE_BY_ AS 'siteInspection.updateBy', c.UPDATE_NAME_ AS 'siteInspection.updateName', c.UPDATE_COMPANY_NAME_ AS 'siteInspection.updateCompanyName', c.UPDATE_COMPANY_ID_ AS 'siteInspection.updateCompanyId', c.UPDATE_ORG_ID_ AS 'siteInspection.updateOrgId', c.UPDATE_ORG_NAME_ AS 'siteInspection.updateOrgName', c.UPDATE_TIME_ AS 'siteInspection.updateTime', c.LAST_TIME_ AS 'siteInspection.lastTime', c.IS_DELE_ AS 'siteInspection.isDele', c.VERSION_ AS 'siteInspection.version', -- c.instId AS 'defaultBpmProcessInstance.id', -- c.subject AS 'defaultBpmProcessInstance.subject', -- c. procDefId AS 'defaultBpmProcessInstance.procDefId', -- c. bpmnDefId AS 'defaultBpmProcessInstance.bpmnDefId', -- c. procDefKey AS 'defaultBpmProcessInstance.procDefKey', -- c. procDefName AS 'defaultBpmProcessInstance.procDefName', -- c. bizKey AS 'defaultBpmProcessInstance.bizKey', -- c. sysCode AS 'defaultBpmProcessInstance.sysCode', -- c. formKey AS 'defaultBpmProcessInstance.formKey', -- c.status AS 'defaultBpmProcessInstance.status', -- c.endTime AS 'defaultBpmProcessInstance.endTime', -- c.duration AS 'defaultBpmProcessInstance.duration', -- c.typeId AS 'defaultBpmProcessInstance.typeId', -- c.resultType AS 'defaultBpmProcessInstance.resultType', -- c.isFormmal AS 'defaultBpmProcessInstance.isFormmal', -- c.parentInstId AS 'defaultBpmProcessInstance.parentInstId', -- c.superNodeId AS 'defaultBpmProcessInstance.superNodeId', -- c.urgentState AS 'defaultBpmProcessInstance.urgentState', -- c.creator AS 'defaultBpmProcessInstance.creator', -- c.isForbidden AS 'defaultBpmProcessInstance.isForbidden', -- c.createOrgPath AS 'defaultBpmProcessInstance.createOrgPath', -- c.supportMobile AS 'defaultBpmProcessInstance.supportMobile', -- c.dataMode AS 'defaultBpmProcessInstance.dataMode', d.id_ AS 'defaultBpmTask.id', d.name_ AS 'defaultBpmTask.name', d.subject_ AS 'defaultBpmTask.subject', d.task_id_ AS 'defaultBpmTask.taskId', d.exec_id_ AS 'defaultBpmTask.execId', d.node_id_ AS 'defaultBpmTask.nodeId', d.proc_inst_id_ AS 'defaultBpmTask.procInstId', d.proc_def_id_ AS 'defaultBpmTask.procDefId', d.proc_def_key_ AS 'defaultBpmTask.procDefKey', d.proc_def_name_ AS 'defaultBpmTask.procDefName', d.owner_id_ AS 'defaultBpmTask.ownerId', d.assignee_id_ AS 'defaultBpmTask.assigneeId', d.assignee_name_ AS 'defaultBpmTask.assigneeName', d.owner_name_ AS 'defaultBpmTask.ownerName', d.status_ AS 'defaultBpmTask.status', d.priority_ AS 'defaultBpmTask.priority', d.suspend_state_ AS 'defaultBpmTask.suspendState', d.parent_id_ AS 'defaultBpmTask.parentId', d.bpmn_inst_id_ AS 'defaultBpmTask.bpmnInstId', d.bpmn_def_id_ AS 'defaultBpmTask.bpmnDefId', d.type_id_ AS 'defaultBpmTask.typeId', d.is_read_ AS 'defaultBpmTask.isRead', d.is_revoke_ AS 'defaultBpmTask.isRevoke' select a.*, b.fullname_ AS "rummagerName", c.fullname_ AS "recorderName" FROM biz_site_inspection AS a LEFT JOIN uc_user AS b ON a.RUMMAGER_ID_ = b.ID_ LEFT JOIN uc_user AS c ON a.RECORDER_ID_ = c.ID_ ${ew.customSqlSegment} AND a.PATROL_DATE_>=#{map.beginCheckDate,jdbcType=TIMESTAMP} AND a.PATROL_DATE_ <=#{map.endTime,jdbcType=TIMESTAMP} SELECT FROM ( SELECT a.*, b.id_ AS instId FROM biz_site_inspection a INNER JOIN bpm_pro_inst b ON a.ID_ = b.biz_key_ ) c INNER JOIN ( SELECT b.* FROM ( SELECT proc_inst_id_, MAX( create_time_ ) AS create_time_ FROM bpm_check_opinion WHERE task_id_ != 'NULL' GROUP BY proc_inst_id_ ) a INNER JOIN bpm_check_opinion b ON a.proc_inst_id_ = b.proc_inst_id_ AND a.create_time_ = b.create_time_ ) d ON c.instId = d.proc_inst_id_ ${ew.customSqlSegment} SELECT FROM ( SELECT a.*, b.id_ AS instId FROM biz_site_inspection a INNER JOIN bpm_pro_inst b ON a.ID_ = b.biz_key_ ) c INNER JOIN bpm_task d ON c.instId = d.proc_inst_id_ ${ew.customSqlSegment} select a.* FROM biz_site_inspection a ${ew.customSqlSegment} AND a.PATROL_DATE_>=#{map.startTime,jdbcType=TIMESTAMP} AND a.PATROL_DATE_ <=#{map.endTime,jdbcType=TIMESTAMP} SELECT * FROM biz_site_inspection a ${ew.customSqlSegment} AND a.PATROL_DATE_>=#{map.startTime,jdbcType=TIMESTAMP} AND a.PATROL_DATE_ <=#{map.endTime,jdbcType=TIMESTAMP} SELECT ID_ AS "siteInspectionVo.id", MANAGE_UNIT_ID_ AS "siteInspectionVo.manageUnitId", MANAGE_UNIT_NAME_ AS "siteInspectionVo.manageUnitName", ROAD_SEGMENT_ID_ AS "siteInspectionVo.roadSegmentId", ROAD_SEGMENT_NAME_ AS "siteInspectionVo.roadSegmentName", ROUTE_ID_ AS "siteInspectionVo.routeId", ROUTE_NAME_ AS "siteInspectionVo.routeName", COMPANY_ID_ AS "siteInspectionVo.companyId", COMPANY_NAME_ AS "siteInspectionVo.companyName", PATROL_DATE_ AS "siteInspectionVo.patrolDate", START_TIME_ AS "siteInspectionVo.startTime", END_TIME_ AS "siteInspectionVo.endTime", CONTENT_ AS "siteInspectionVo.content", WEATHER_ AS "siteInspectionVo.weather", WEATHER_VALUE_ AS "siteInspectionVo.weatherValue", HAND_STATUS_ AS "siteInspectionVo.handStatus", RUMMAGER_ID_ AS "siteInspectionVo.rummagerId", RUMMAGER_ACCOUNT_ AS "siteInspectionVo.rummagerAccount", PROBLEM_ AS "siteInspectionVo.problem", JOB_NUMBER_ AS "siteInspectionVo.jobNumber" FROM biz_site_inspection WHERE IS_DELE_ = "0" AND ID_=#{id}