aps-modules/aps-core/src/main/resources/mapper/core/ApsGasPipingPlanMapper.xml
@@ -50,9 +50,9 @@ <include refid="selectApsGasPipingPlanVo"/> <where> <if test="masterPlanner != null and masterPlanner != ''"> and master_planner like concat('%', #{masterPlanner}, '%')</if> <if test="customer != null and customer != ''"> and customer like concat('%', #{customer}, '%')</if> <if test="customer != null and customer != ''"> and customer like '%' || #{customer} || '%' </if> <if test="businessType != null and businessType != ''"> and business_type = #{businessType}</if> <if test="documentNumber != null and documentNumber != ''"> and document_number = #{documentNumber}</if> <if test="documentNumber != null and documentNumber != ''"> and document_number like '%' || #{documentNumber} || '%'</if> <if test="requirementType != null and requirementType != ''"> and requirement_type = #{requirementType}</if> <if test="documentStatus != null and documentStatus != ''"> and document_status = #{documentStatus}</if> <if test="itemNumber != null and itemNumber != ''"> and item_number = #{itemNumber}</if> aps-modules/aps-core/src/main/resources/mapper/core/ApsPartPlanMapper.xml
@@ -56,8 +56,7 @@ <if test="mainPartDrawingNumber != null and mainPartDrawingNumber != ''"> and main_part_drawing_number = #{mainPartDrawingNumber}</if> <if test="customer != null and customer != ''"> and customer like '%' || #{customer} || '%' </if> <if test="businessType != null and businessType != ''"> and business_type = #{businessType}</if> <if test="documentNumber != null and documentNumber != ''"> and document_number like '%' || #{documentNumber} || '%'</if> <if test="requirementType != null and requirementType != ''"> and requirement_type = #{requirementType}</if> <if test="documentNumber != null and documentNumber != ''"> and document_number like '%' || #{documentNumber} || '%'</if> <if test="requirementType != null and requirementType != ''"> and requirement_type = #{requirementType}</if> <if test="documentStatus != null and documentStatus != ''"> and document_status = #{documentStatus}</if> <if test="itemNumber != null and itemNumber != ''"> and item_number = #{itemNumber}</if> <if test="drawingNo != null and drawingNo != ''"> and drawing_no = #{drawingNo}</if> aps-modules/aps-core/src/main/resources/mapper/core/ApsPlatePlanMapper.xml
@@ -177,9 +177,9 @@ <if test="weekCycle != null">week_cycle = #{weekCycle},</if> <if test="mainPartNumber != null">main_part_number = #{mainPartNumber},</if> <if test="mainPartDrawingNumber != null">main_part_drawing_number = #{mainPartDrawingNumber},</if> <if test="customer != null">customer = #{customer},</if> <if test="businessType != null">business_type = #{businessType},</if> <if test="documentNumber != null">document_number = #{documentNumber},</if> <if test="customer != null and customer != ''"> and customer like '%' || #{customer} || '%' </if> <if test="businessType != null and businessType != ''"> and business_type = #{businessType}</if> <if test="documentNumber != null and documentNumber != ''"> and document_number like '%' || #{documentNumber} || '%'</if> <if test="requirementType != null">requirement_type = #{requirementType},</if> <if test="documentStatus != null">document_status = #{documentStatus},</if> <if test="itemNumber != null">item_number = #{itemNumber},</if>
