From 7f43845a6289a2ba7c6c1c313501674b59892cb7 Mon Sep 17 00:00:00 2001
From: cuilei <ray_tsu1@163.com>
Date: 星期二, 26 八月 2025 15:00:42 +0800
Subject: [PATCH] 齐套性检查、上下料查询相关接口
---
src/main/java/org/jeecg/modules/mes/service/impl/MesMaterialLoadingServiceImpl.java | 36 ++++++++++++++++++++++++++++++++++++
1 files changed, 36 insertions(+), 0 deletions(-)
diff --git a/src/main/java/org/jeecg/modules/mes/service/impl/MesMaterialLoadingServiceImpl.java b/src/main/java/org/jeecg/modules/mes/service/impl/MesMaterialLoadingServiceImpl.java
index 55d26ce..188ec6c 100644
--- a/src/main/java/org/jeecg/modules/mes/service/impl/MesMaterialLoadingServiceImpl.java
+++ b/src/main/java/org/jeecg/modules/mes/service/impl/MesMaterialLoadingServiceImpl.java
@@ -1,5 +1,9 @@
package org.jeecg.modules.mes.service.impl;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.jeecg.modules.mes.entity.MesMaterialLoading;
import org.jeecg.modules.mes.entity.MesMaterialUnloading;
@@ -8,6 +12,7 @@
import org.springframework.stereotype.Service;
import java.util.List;
+import java.util.Map;
/**
* @Description: 涓婃枡
@@ -27,4 +32,35 @@
public List<MesMaterialLoading> queryLoadingByWorkOrderId(String workOrderId) {
return baseMapper.queryLoadingByWorkOrderId(workOrderId);
}
+
+ @Override
+ public IPage<MesMaterialLoading> queryPageList(Page<MesMaterialLoading> page, Map<String, String[]> parameterMap) {
+ QueryWrapper<MesMaterialLoading> queryWrapper = Wrappers.query();
+ String[] factoryIds = parameterMap.get("factoryId");
+ if (factoryIds != null && factoryIds.length > 0) {
+ queryWrapper.eq("t2.factory_id", factoryIds[0]);
+ }
+ String[] workOrderIds = parameterMap.get("workOrderId");
+ if (workOrderIds != null && workOrderIds.length > 0) {
+ queryWrapper.eq("t1.work_order_id", workOrderIds[0]);
+ }
+ String[] materialNumbers = parameterMap.get("materialNumber");
+ if (materialNumbers != null && materialNumbers.length > 0) {
+ queryWrapper.like("t1.material_number", materialNumbers[0]);
+ }
+ String[] materialNames = parameterMap.get("materialName");
+ if (materialNames != null && materialNames.length > 0) {
+ queryWrapper.like("t1.material_name", materialNames[0]);
+ }
+ String[] batchNumbers = parameterMap.get("batchNumber");
+ if (batchNumbers != null && batchNumbers.length > 0) {
+ queryWrapper.like("t1.batch_number", batchNumbers[0]);
+ }
+ String[] equipmentIds = parameterMap.get("equipmentId");
+ if (equipmentIds != null && equipmentIds.length > 0) {
+ queryWrapper.eq("t1.equipment_id", equipmentIds[0]);
+ }
+ queryWrapper.orderByDesc("t1.create_time");
+ return this.baseMapper.queryPageList(page, queryWrapper);
+ }
}
--
Gitblit v1.9.3