From 66b57b7f650d7f61ac2859a2cbe652cd4becb523 Mon Sep 17 00:00:00 2001
From: admin <418351270@qq.com>
Date: 星期二, 09 一月 2024 17:24:37 +0800
Subject: [PATCH] 添加查询
---
guns-vip-main/src/main/java/cn/stylefeng/guns/modular/om/productionOrderRecords/service/impl/ProductionOrderRecordsServiceImpl.java | 2 +-
guns-vip-main/src/main/java/cn/stylefeng/guns/modular/om/productionOrderRecords/mapper/mapping/ProductionOrderRecordsMapper.xml | 12 ++++++++++++
guns-vip-main/src/main/java/cn/stylefeng/guns/modular/cm/passingStationCollection/service/impl/PassingStationCollectionServiceImpl.java | 2 +-
3 files changed, 14 insertions(+), 2 deletions(-)
diff --git a/guns-vip-main/src/main/java/cn/stylefeng/guns/modular/cm/passingStationCollection/service/impl/PassingStationCollectionServiceImpl.java b/guns-vip-main/src/main/java/cn/stylefeng/guns/modular/cm/passingStationCollection/service/impl/PassingStationCollectionServiceImpl.java
index 6efcdbc..020f30a 100644
--- a/guns-vip-main/src/main/java/cn/stylefeng/guns/modular/cm/passingStationCollection/service/impl/PassingStationCollectionServiceImpl.java
+++ b/guns-vip-main/src/main/java/cn/stylefeng/guns/modular/cm/passingStationCollection/service/impl/PassingStationCollectionServiceImpl.java
@@ -70,7 +70,7 @@
@Override
public List<PassingStationCollectionResult> findListBySpec(PassingStationCollectionParam param){
- return null;
+ return this.baseMapper.customList(param);
}
@Override
diff --git a/guns-vip-main/src/main/java/cn/stylefeng/guns/modular/om/productionOrderRecords/mapper/mapping/ProductionOrderRecordsMapper.xml b/guns-vip-main/src/main/java/cn/stylefeng/guns/modular/om/productionOrderRecords/mapper/mapping/ProductionOrderRecordsMapper.xml
index aaf4a35..0d2ac03 100644
--- a/guns-vip-main/src/main/java/cn/stylefeng/guns/modular/om/productionOrderRecords/mapper/mapping/ProductionOrderRecordsMapper.xml
+++ b/guns-vip-main/src/main/java/cn/stylefeng/guns/modular/om/productionOrderRecords/mapper/mapping/ProductionOrderRecordsMapper.xml
@@ -37,6 +37,18 @@
select
<include refid="Base_Column_List"/>
from om_production_order_records where 1 = 1
+ <if test="paramCondition.productNo != null and paramCondition.productNo != ''">
+ and product_no like CONCAT('%',#{paramCondition.productNo},'%')
+ </if>
+ <if test="paramCondition.workOrderNo != null and paramCondition.workOrderNo != ''">
+ and work_order_no like CONCAT('%',#{paramCondition.workOrderNo},'%')
+ </if>
+ <if test="paramCondition.materialCode != null and paramCondition.materialCode != ''">
+ and material_code like CONCAT('%',#{paramCondition.materialCode},'%')
+ </if>
+ <if test="paramCondition.locationCode != null and paramCondition.locationCode != ''">
+ and location_code like CONCAT('%',#{paramCondition.locationCode},'%')
+ </if>
</select>
<select id="customMapList" resultType="map" parameterType="cn.stylefeng.guns.modular.om.productionOrderRecords.model.params.ProductionOrderRecordsParam">
diff --git a/guns-vip-main/src/main/java/cn/stylefeng/guns/modular/om/productionOrderRecords/service/impl/ProductionOrderRecordsServiceImpl.java b/guns-vip-main/src/main/java/cn/stylefeng/guns/modular/om/productionOrderRecords/service/impl/ProductionOrderRecordsServiceImpl.java
index 39832b1..7fc9df3 100644
--- a/guns-vip-main/src/main/java/cn/stylefeng/guns/modular/om/productionOrderRecords/service/impl/ProductionOrderRecordsServiceImpl.java
+++ b/guns-vip-main/src/main/java/cn/stylefeng/guns/modular/om/productionOrderRecords/service/impl/ProductionOrderRecordsServiceImpl.java
@@ -53,7 +53,7 @@
@Override
public List<ProductionOrderRecordsResult> findListBySpec(ProductionOrderRecordsParam param){
- return null;
+ return this.baseMapper.customList(param);
}
@Override
--
Gitblit v1.9.3