From bc906065cf3ab03d92b3cf815fb8c03bef9941ea Mon Sep 17 00:00:00 2001 From: cuijian <cuijian@xalxzn.com> Date: 星期四, 03 七月 2025 09:13:27 +0800 Subject: [PATCH] 质量管理-抽样规则、缺陷维护功能 --- src/main/java/org/jeecg/modules/qms/service/impl/InspectionItemServiceImpl.java | 35 +++++++++++++++++++++++++++++++++++ 1 files changed, 35 insertions(+), 0 deletions(-) diff --git a/src/main/java/org/jeecg/modules/qms/service/impl/InspectionItemServiceImpl.java b/src/main/java/org/jeecg/modules/qms/service/impl/InspectionItemServiceImpl.java index 101beb0..b851290 100644 --- a/src/main/java/org/jeecg/modules/qms/service/impl/InspectionItemServiceImpl.java +++ b/src/main/java/org/jeecg/modules/qms/service/impl/InspectionItemServiceImpl.java @@ -1,11 +1,22 @@ package org.jeecg.modules.qms.service.impl; +import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; +import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.core.metadata.OrderItem; +import com.baomidou.mybatisplus.core.toolkit.Wrappers; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import org.apache.commons.lang.StringUtils; +import org.jeecg.common.exception.ExceptionCast; import org.jeecg.modules.qms.entity.InspectionItem; import org.jeecg.modules.qms.mapper.InspectionItemMapper; import org.jeecg.modules.qms.service.IInspectionItemService; import org.springframework.stereotype.Service; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; + +import java.util.ArrayList; +import java.util.List; +import java.util.Map; /** * @Description: 妫�楠岄」鐩� @@ -16,4 +27,28 @@ @Service public class InspectionItemServiceImpl extends ServiceImpl<InspectionItemMapper, InspectionItem> implements IInspectionItemService { + @Override + public IPage<Map<String, Object>> queryList(Integer pageNo, Integer pageSize, Map<String, String> query) { + if (pageNo == null || pageNo < 1 || pageSize == null || pageSize < 1) { + ExceptionCast.cast("鍙傛暟閿欒"); + } + IPage<Map> pageData = new Page<Map>(pageNo, pageSize); + QueryWrapper<Map> queryWrapper = Wrappers.query(); + if (null != query) { + String itemCode = query.get("itemCode"); + if (StringUtils.isNotBlank(itemCode)) { + queryWrapper.like("t1.item_code", itemCode); + } + String itemName = query.get("itemName"); + if (StringUtils.isNotBlank(itemName)) { + queryWrapper.like("t2.item_name", itemName); + } + + // 鎺掑簭鍐欐硶 + List<OrderItem> orderItems = new ArrayList<>(); + orderItems.add(OrderItem.desc("t1.create_time")); + ((Page<Map>) pageData).setOrders(orderItems); + } + return super.getBaseMapper().queryList(pageData,queryWrapper); + } } -- Gitblit v1.9.3