diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml index 935c07b..7259c17 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml @@ -128,6 +128,9 @@ and sub_time >= #{request.subTimeStart} + + and creator = #{request.createUserId} + and sub_time #{request.subTimeEnd} @@ -140,8 +143,11 @@ and creator_name like concat('%',#{request.creatorName},'%') - - and approval_status = #{request.approvalStatus} + + and creator = #{request.createUserId} + + + and creator_name like concat('%',#{request.creatorName},'%') and id in diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml index 935c07b..7259c17 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml @@ -128,6 +128,9 @@ and sub_time >= #{request.subTimeStart} + + and creator = #{request.createUserId} + and sub_time #{request.subTimeEnd} @@ -140,8 +143,11 @@ and creator_name like concat('%',#{request.creatorName},'%') - - and approval_status = #{request.approvalStatus} + + and creator = #{request.createUserId} + + + and creator_name like concat('%',#{request.creatorName},'%') and id in diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml index d09bb21..45fe9bd 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml @@ -97,6 +97,9 @@ and commander_id = #{request.commanderId} + + and commander_id = #{request.createUserId} + diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml index 935c07b..7259c17 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml @@ -128,6 +128,9 @@ and sub_time >= #{request.subTimeStart} + + and creator = #{request.createUserId} + and sub_time #{request.subTimeEnd} @@ -140,8 +143,11 @@ and creator_name like concat('%',#{request.creatorName},'%') - - and approval_status = #{request.approvalStatus} + + and creator = #{request.createUserId} + + + and creator_name like concat('%',#{request.creatorName},'%') and id in diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml index d09bb21..45fe9bd 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml @@ -97,6 +97,9 @@ and commander_id = #{request.commanderId} + + and commander_id = #{request.createUserId} + diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml index 332191e..9008ace 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml @@ -129,6 +129,9 @@ and approval_status = #{request.approvalStatus} + + and creator = #{request.createUserId} + and id in diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml index 935c07b..7259c17 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml @@ -128,6 +128,9 @@ and sub_time >= #{request.subTimeStart} + + and creator = #{request.createUserId} + and sub_time #{request.subTimeEnd} @@ -140,8 +143,11 @@ and creator_name like concat('%',#{request.creatorName},'%') - - and approval_status = #{request.approvalStatus} + + and creator = #{request.createUserId} + + + and creator_name like concat('%',#{request.creatorName},'%') and id in diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml index d09bb21..45fe9bd 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml @@ -97,6 +97,9 @@ and commander_id = #{request.commanderId} + + and commander_id = #{request.createUserId} + diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml index 332191e..9008ace 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml @@ -129,6 +129,9 @@ and approval_status = #{request.approvalStatus} + + and creator = #{request.createUserId} + and id in diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml index f777caf..5b8aac8 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml @@ -99,6 +99,9 @@ and commander_id = #{request.commanderId} + + and commander_id = #{request.createUserId} + and commander_name like concat('%',#{request.commanderName},'%') @@ -120,8 +123,7 @@ - select from biz_quality_management_review_plan a diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml index 935c07b..7259c17 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml @@ -128,6 +128,9 @@ and sub_time >= #{request.subTimeStart} + + and creator = #{request.createUserId} + and sub_time #{request.subTimeEnd} @@ -140,8 +143,11 @@ and creator_name like concat('%',#{request.creatorName},'%') - - and approval_status = #{request.approvalStatus} + + and creator = #{request.createUserId} + + + and creator_name like concat('%',#{request.creatorName},'%') and id in diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml index d09bb21..45fe9bd 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml @@ -97,6 +97,9 @@ and commander_id = #{request.commanderId} + + and commander_id = #{request.createUserId} + diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml index 332191e..9008ace 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml @@ -129,6 +129,9 @@ and approval_status = #{request.approvalStatus} + + and creator = #{request.createUserId} + and id in diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml index f777caf..5b8aac8 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml @@ -99,6 +99,9 @@ and commander_id = #{request.commanderId} + + and commander_id = #{request.createUserId} + and commander_name like concat('%',#{request.commanderName},'%') @@ -120,8 +123,7 @@ - select from biz_quality_management_review_plan a diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml index 095910d..164df9d 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml @@ -95,6 +95,9 @@ and biz_lab_code = #{request.bizLabCode} + + and commander_id = #{request.createUserId} + and commander_id = #{request.commanderId} diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml index 935c07b..7259c17 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml @@ -128,6 +128,9 @@ and sub_time >= #{request.subTimeStart} + + and creator = #{request.createUserId} + and sub_time #{request.subTimeEnd} @@ -140,8 +143,11 @@ and creator_name like concat('%',#{request.creatorName},'%') - - and approval_status = #{request.approvalStatus} + + and creator = #{request.createUserId} + + + and creator_name like concat('%',#{request.creatorName},'%') and id in diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml index d09bb21..45fe9bd 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml @@ -97,6 +97,9 @@ and commander_id = #{request.commanderId} + + and commander_id = #{request.createUserId} + diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml index 332191e..9008ace 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml @@ -129,6 +129,9 @@ and approval_status = #{request.approvalStatus} + + and creator = #{request.createUserId} + and id in diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml index f777caf..5b8aac8 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml @@ -99,6 +99,9 @@ and commander_id = #{request.commanderId} + + and commander_id = #{request.createUserId} + and commander_name like concat('%',#{request.commanderName},'%') @@ -120,8 +123,7 @@ - select from biz_quality_management_review_plan a diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml index 095910d..164df9d 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml @@ -95,6 +95,9 @@ and biz_lab_code = #{request.bizLabCode} + + and commander_id = #{request.createUserId} + and commander_id = #{request.commanderId} diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml index a59999d..2d189c1 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml @@ -112,6 +112,9 @@ and creator = #{request.creator} + + and creator = #{request.createUserId} + and approval_status = #{request.approvalStatus} diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml index 935c07b..7259c17 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml @@ -128,6 +128,9 @@ and sub_time >= #{request.subTimeStart} + + and creator = #{request.createUserId} + and sub_time #{request.subTimeEnd} @@ -140,8 +143,11 @@ and creator_name like concat('%',#{request.creatorName},'%') - - and approval_status = #{request.approvalStatus} + + and creator = #{request.createUserId} + + + and creator_name like concat('%',#{request.creatorName},'%') and id in diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml index d09bb21..45fe9bd 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml @@ -97,6 +97,9 @@ and commander_id = #{request.commanderId} + + and commander_id = #{request.createUserId} + diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml index 332191e..9008ace 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml @@ -129,6 +129,9 @@ and approval_status = #{request.approvalStatus} + + and creator = #{request.createUserId} + and id in diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml index f777caf..5b8aac8 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml @@ -99,6 +99,9 @@ and commander_id = #{request.commanderId} + + and commander_id = #{request.createUserId} + and commander_name like concat('%',#{request.commanderName},'%') @@ -120,8 +123,7 @@ - select from biz_quality_management_review_plan a diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml index 095910d..164df9d 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml @@ -95,6 +95,9 @@ and biz_lab_code = #{request.bizLabCode} + + and commander_id = #{request.createUserId} + and commander_id = #{request.commanderId} diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml index a59999d..2d189c1 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml @@ -112,6 +112,9 @@ and creator = #{request.creator} + + and creator = #{request.createUserId} + and approval_status = #{request.approvalStatus} diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonReviewFormMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonReviewFormMapper.xml index 4b76963..dde5b49 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonReviewFormMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonReviewFormMapper.xml @@ -134,6 +134,10 @@ and a.creator = #{request.creator} + + + and creator = #{request.createUserId} + and a.creator_name like concat('%',#{request.creatorName},'%') diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml index 935c07b..7259c17 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml @@ -128,6 +128,9 @@ and sub_time >= #{request.subTimeStart} + + and creator = #{request.createUserId} + and sub_time #{request.subTimeEnd} @@ -140,8 +143,11 @@ and creator_name like concat('%',#{request.creatorName},'%') - - and approval_status = #{request.approvalStatus} + + and creator = #{request.createUserId} + + + and creator_name like concat('%',#{request.creatorName},'%') and id in diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml index d09bb21..45fe9bd 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml @@ -97,6 +97,9 @@ and commander_id = #{request.commanderId} + + and commander_id = #{request.createUserId} + diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml index 332191e..9008ace 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml @@ -129,6 +129,9 @@ and approval_status = #{request.approvalStatus} + + and creator = #{request.createUserId} + and id in diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml index f777caf..5b8aac8 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml @@ -99,6 +99,9 @@ and commander_id = #{request.commanderId} + + and commander_id = #{request.createUserId} + and commander_name like concat('%',#{request.commanderName},'%') @@ -120,8 +123,7 @@ - select from biz_quality_management_review_plan a diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml index 095910d..164df9d 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml @@ -95,6 +95,9 @@ and biz_lab_code = #{request.bizLabCode} + + and commander_id = #{request.createUserId} + and commander_id = #{request.commanderId} diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml index a59999d..2d189c1 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml @@ -112,6 +112,9 @@ and creator = #{request.creator} + + and creator = #{request.createUserId} + and approval_status = #{request.approvalStatus} diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonReviewFormMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonReviewFormMapper.xml index 4b76963..dde5b49 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonReviewFormMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonReviewFormMapper.xml @@ -134,6 +134,10 @@ and a.creator = #{request.creator} + + + and creator = #{request.createUserId} + and a.creator_name like concat('%',#{request.creatorName},'%') diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityPreventRecordMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityPreventRecordMapper.xml index 65667d6..c73813c 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityPreventRecordMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityPreventRecordMapper.xml @@ -135,6 +135,9 @@ and creator = #{request.creator} + + and creator = #{request.createUserId} + and group_no = #{request.groupNo} diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml index 935c07b..7259c17 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml @@ -128,6 +128,9 @@ and sub_time >= #{request.subTimeStart} + + and creator = #{request.createUserId} + and sub_time #{request.subTimeEnd} @@ -140,8 +143,11 @@ and creator_name like concat('%',#{request.creatorName},'%') - - and approval_status = #{request.approvalStatus} + + and creator = #{request.createUserId} + + + and creator_name like concat('%',#{request.creatorName},'%') and id in diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml index d09bb21..45fe9bd 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml @@ -97,6 +97,9 @@ and commander_id = #{request.commanderId} + + and commander_id = #{request.createUserId} + diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml index 332191e..9008ace 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml @@ -129,6 +129,9 @@ and approval_status = #{request.approvalStatus} + + and creator = #{request.createUserId} + and id in diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml index f777caf..5b8aac8 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml @@ -99,6 +99,9 @@ and commander_id = #{request.commanderId} + + and commander_id = #{request.createUserId} + and commander_name like concat('%',#{request.commanderName},'%') @@ -120,8 +123,7 @@ - select from biz_quality_management_review_plan a diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml index 095910d..164df9d 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml @@ -95,6 +95,9 @@ and biz_lab_code = #{request.bizLabCode} + + and commander_id = #{request.createUserId} + and commander_id = #{request.commanderId} diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml index a59999d..2d189c1 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml @@ -112,6 +112,9 @@ and creator = #{request.creator} + + and creator = #{request.createUserId} + and approval_status = #{request.approvalStatus} diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonReviewFormMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonReviewFormMapper.xml index 4b76963..dde5b49 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonReviewFormMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonReviewFormMapper.xml @@ -134,6 +134,10 @@ and a.creator = #{request.creator} + + + and creator = #{request.createUserId} + and a.creator_name like concat('%',#{request.creatorName},'%') diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityPreventRecordMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityPreventRecordMapper.xml index 65667d6..c73813c 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityPreventRecordMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityPreventRecordMapper.xml @@ -135,6 +135,9 @@ and creator = #{request.creator} + + and creator = #{request.createUserId} + and group_no = #{request.groupNo} diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityReviewFormMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityReviewFormMapper.xml index 6c8a80c..a0dd4f0 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityReviewFormMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityReviewFormMapper.xml @@ -92,6 +92,10 @@ and creator = #{request.creator} + + + and creator = #{request.createUserId} + and creator_name like concat('%',#{request.creatorName},'%') diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml index 935c07b..7259c17 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml @@ -128,6 +128,9 @@ and sub_time >= #{request.subTimeStart} + + and creator = #{request.createUserId} + and sub_time #{request.subTimeEnd} @@ -140,8 +143,11 @@ and creator_name like concat('%',#{request.creatorName},'%') - - and approval_status = #{request.approvalStatus} + + and creator = #{request.createUserId} + + + and creator_name like concat('%',#{request.creatorName},'%') and id in diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml index d09bb21..45fe9bd 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml @@ -97,6 +97,9 @@ and commander_id = #{request.commanderId} + + and commander_id = #{request.createUserId} + diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml index 332191e..9008ace 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml @@ -129,6 +129,9 @@ and approval_status = #{request.approvalStatus} + + and creator = #{request.createUserId} + and id in diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml index f777caf..5b8aac8 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml @@ -99,6 +99,9 @@ and commander_id = #{request.commanderId} + + and commander_id = #{request.createUserId} + and commander_name like concat('%',#{request.commanderName},'%') @@ -120,8 +123,7 @@ - select from biz_quality_management_review_plan a diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml index 095910d..164df9d 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml @@ -95,6 +95,9 @@ and biz_lab_code = #{request.bizLabCode} + + and commander_id = #{request.createUserId} + and commander_id = #{request.commanderId} diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml index a59999d..2d189c1 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml @@ -112,6 +112,9 @@ and creator = #{request.creator} + + and creator = #{request.createUserId} + and approval_status = #{request.approvalStatus} diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonReviewFormMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonReviewFormMapper.xml index 4b76963..dde5b49 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonReviewFormMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonReviewFormMapper.xml @@ -134,6 +134,10 @@ and a.creator = #{request.creator} + + + and creator = #{request.createUserId} + and a.creator_name like concat('%',#{request.creatorName},'%') diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityPreventRecordMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityPreventRecordMapper.xml index 65667d6..c73813c 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityPreventRecordMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityPreventRecordMapper.xml @@ -135,6 +135,9 @@ and creator = #{request.creator} + + and creator = #{request.createUserId} + and group_no = #{request.groupNo} diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityReviewFormMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityReviewFormMapper.xml index 6c8a80c..a0dd4f0 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityReviewFormMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityReviewFormMapper.xml @@ -92,6 +92,10 @@ and creator = #{request.creator} + + + and creator = #{request.createUserId} + and creator_name like concat('%',#{request.creatorName},'%') diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityScenePlanMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityScenePlanMapper.xml index 384d6b1..2e40fac 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityScenePlanMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityScenePlanMapper.xml @@ -111,6 +111,10 @@ and a.commander_name like concat('%',#{request.commanderName},'%') + + + and commander_id = #{request.createUserId} + and b.work_name like concat('%',#{request.workName},'%') diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml index 935c07b..7259c17 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml @@ -128,6 +128,9 @@ and sub_time >= #{request.subTimeStart} + + and creator = #{request.createUserId} + and sub_time #{request.subTimeEnd} @@ -140,8 +143,11 @@ and creator_name like concat('%',#{request.creatorName},'%') - - and approval_status = #{request.approvalStatus} + + and creator = #{request.createUserId} + + + and creator_name like concat('%',#{request.creatorName},'%') and id in diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml index d09bb21..45fe9bd 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml @@ -97,6 +97,9 @@ and commander_id = #{request.commanderId} + + and commander_id = #{request.createUserId} + diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml index 332191e..9008ace 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml @@ -129,6 +129,9 @@ and approval_status = #{request.approvalStatus} + + and creator = #{request.createUserId} + and id in diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml index f777caf..5b8aac8 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml @@ -99,6 +99,9 @@ and commander_id = #{request.commanderId} + + and commander_id = #{request.createUserId} + and commander_name like concat('%',#{request.commanderName},'%') @@ -120,8 +123,7 @@ - select from biz_quality_management_review_plan a diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml index 095910d..164df9d 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml @@ -95,6 +95,9 @@ and biz_lab_code = #{request.bizLabCode} + + and commander_id = #{request.createUserId} + and commander_id = #{request.commanderId} diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml index a59999d..2d189c1 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml @@ -112,6 +112,9 @@ and creator = #{request.creator} + + and creator = #{request.createUserId} + and approval_status = #{request.approvalStatus} diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonReviewFormMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonReviewFormMapper.xml index 4b76963..dde5b49 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonReviewFormMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonReviewFormMapper.xml @@ -134,6 +134,10 @@ and a.creator = #{request.creator} + + + and creator = #{request.createUserId} + and a.creator_name like concat('%',#{request.creatorName},'%') diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityPreventRecordMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityPreventRecordMapper.xml index 65667d6..c73813c 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityPreventRecordMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityPreventRecordMapper.xml @@ -135,6 +135,9 @@ and creator = #{request.creator} + + and creator = #{request.createUserId} + and group_no = #{request.groupNo} diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityReviewFormMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityReviewFormMapper.xml index 6c8a80c..a0dd4f0 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityReviewFormMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityReviewFormMapper.xml @@ -92,6 +92,10 @@ and creator = #{request.creator} + + + and creator = #{request.createUserId} + and creator_name like concat('%',#{request.creatorName},'%') diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityScenePlanMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityScenePlanMapper.xml index 384d6b1..2e40fac 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityScenePlanMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityScenePlanMapper.xml @@ -111,6 +111,10 @@ and a.commander_name like concat('%',#{request.commanderName},'%') + + + and commander_id = #{request.createUserId} + and b.work_name like concat('%',#{request.workName},'%') diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualitySupervisionRepMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualitySupervisionRepMapper.xml index 1fb6d91..27f141a 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualitySupervisionRepMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualitySupervisionRepMapper.xml @@ -127,6 +127,9 @@ and sub_time <= #{request.subTimeEnd} + + and creator = #{request.createUserId} + ORDER BY a.create_time DESC diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml index 935c07b..7259c17 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityCorrectiveRecordMapper.xml @@ -128,6 +128,9 @@ and sub_time >= #{request.subTimeStart} + + and creator = #{request.createUserId} + and sub_time #{request.subTimeEnd} @@ -140,8 +143,11 @@ and creator_name like concat('%',#{request.creatorName},'%') - - and approval_status = #{request.approvalStatus} + + and creator = #{request.createUserId} + + + and creator_name like concat('%',#{request.creatorName},'%') and id in diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml index d09bb21..45fe9bd 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditPlanMapper.xml @@ -97,6 +97,9 @@ and commander_id = #{request.commanderId} + + and commander_id = #{request.createUserId} + diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml index 332191e..9008ace 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityInternalAuditRepMapper.xml @@ -129,6 +129,9 @@ and approval_status = #{request.approvalStatus} + + and creator = #{request.createUserId} + and id in diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml index f777caf..5b8aac8 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewPlanMapper.xml @@ -99,6 +99,9 @@ and commander_id = #{request.commanderId} + + and commander_id = #{request.createUserId} + and commander_name like concat('%',#{request.commanderName},'%') @@ -120,8 +123,7 @@ - select from biz_quality_management_review_plan a diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml index 095910d..164df9d 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityManagementReviewRepMapper.xml @@ -95,6 +95,9 @@ and biz_lab_code = #{request.bizLabCode} + + and commander_id = #{request.createUserId} + and commander_id = #{request.commanderId} diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml index a59999d..2d189c1 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonConformanceRepMapper.xml @@ -112,6 +112,9 @@ and creator = #{request.creator} + + and creator = #{request.createUserId} + and approval_status = #{request.approvalStatus} diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonReviewFormMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonReviewFormMapper.xml index 4b76963..dde5b49 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonReviewFormMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityNonReviewFormMapper.xml @@ -134,6 +134,10 @@ and a.creator = #{request.creator} + + + and creator = #{request.createUserId} + and a.creator_name like concat('%',#{request.creatorName},'%') diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityPreventRecordMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityPreventRecordMapper.xml index 65667d6..c73813c 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityPreventRecordMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityPreventRecordMapper.xml @@ -135,6 +135,9 @@ and creator = #{request.creator} + + and creator = #{request.createUserId} + and group_no = #{request.groupNo} diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityReviewFormMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityReviewFormMapper.xml index 6c8a80c..a0dd4f0 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityReviewFormMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityReviewFormMapper.xml @@ -92,6 +92,10 @@ and creator = #{request.creator} + + + and creator = #{request.createUserId} + and creator_name like concat('%',#{request.creatorName},'%') diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityScenePlanMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityScenePlanMapper.xml index 384d6b1..2e40fac 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityScenePlanMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityScenePlanMapper.xml @@ -111,6 +111,10 @@ and a.commander_name like concat('%',#{request.commanderName},'%') + + + and commander_id = #{request.createUserId} + and b.work_name like concat('%',#{request.workName},'%') diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualitySupervisionRepMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualitySupervisionRepMapper.xml index 1fb6d91..27f141a 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualitySupervisionRepMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualitySupervisionRepMapper.xml @@ -127,6 +127,9 @@ and sub_time <= #{request.subTimeEnd} + + and creator = #{request.createUserId} + ORDER BY a.create_time DESC diff --git a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityWorkRegistrationMapper.xml b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityWorkRegistrationMapper.xml index 3e1e27e..885f574 100644 --- a/casic-metering-dao/src/main/resources/mapper/quality/BizQualityWorkRegistrationMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/quality/BizQualityWorkRegistrationMapper.xml @@ -88,6 +88,9 @@ and file_name like concat('%',#{request.fileName},'%') + + and creator = #{request.createUserId} + and creator_name like concat('%',#{request.creatorName},'%')