From 02dab566014a28bbcd6b2a2004a857562101e459 Mon Sep 17 00:00:00 2001 From: value <z1292839451@163.com> Date: 星期五, 26 四月 2024 09:11:09 +0800 Subject: [PATCH] 检验项目绑定产品;检验对象绑定产品 --- cnas-server/src/main/java/com/yuanchu/mom/service/impl/DeviceServiceImpl.java | 35 ++++++++++++++++++++++++++++++++++- 1 files changed, 34 insertions(+), 1 deletions(-) diff --git a/cnas-server/src/main/java/com/yuanchu/mom/service/impl/DeviceServiceImpl.java b/cnas-server/src/main/java/com/yuanchu/mom/service/impl/DeviceServiceImpl.java index 17d7753..3286e6b 100644 --- a/cnas-server/src/main/java/com/yuanchu/mom/service/impl/DeviceServiceImpl.java +++ b/cnas-server/src/main/java/com/yuanchu/mom/service/impl/DeviceServiceImpl.java @@ -1,16 +1,21 @@ package com.yuanchu.mom.service.impl; +import com.alibaba.fastjson.JSON; +import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.yuanchu.mom.common.GetLook; import com.yuanchu.mom.common.PrintChina; import com.yuanchu.mom.mapper.DeviceMapper; +import com.yuanchu.mom.mapper.StructureItemParameterMapper; import com.yuanchu.mom.pojo.Device; +import com.yuanchu.mom.pojo.StructureItemParameter; import com.yuanchu.mom.service.DeviceService; import com.yuanchu.mom.utils.QueryWrappers; import lombok.AllArgsConstructor; import org.springframework.stereotype.Service; +import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; @@ -26,8 +31,10 @@ private DeviceMapper deviceMapper; + private StructureItemParameterMapper structureItemParameterMapper; + @Override - public Map<String, Object> selectDeviceParameter(com.baomidou.mybatisplus.extension.plugins.pagination.Page page, Device itemParameter) { + public Map<String, Object> selectDeviceParameter(Page page, Device itemParameter) { Map<String, Object> map = new HashMap<>(); map.put("head", PrintChina.printChina(Device.class)); Map<String, Integer> map1 = getLook.selectPowerByMethodAndUserId("selectDeviceParameter"); @@ -70,5 +77,31 @@ public List<Device> selectDevicePrincipal() { return deviceMapper.selectDevicePrincipal(); } + + @Override + public List<Device> selectDeviceByCategory(String inspectionItem, String inspectionItemSubclass) { + Integer id; + try { + id = structureItemParameterMapper.selectOne(Wrappers.<StructureItemParameter>lambdaQuery().eq(StructureItemParameter::getInspectionItem, inspectionItem).eq(StructureItemParameter::getInspectionItemSubclass, inspectionItemSubclass).last("limit 1").select(StructureItemParameter::getId)).getId(); + } catch (Exception e) { + return null; + } + List<Device> devices = deviceMapper.selectList(Wrappers.<Device>lambdaQuery().eq(Device::getDeviceStatus, 0).isNotNull(Device::getInsProductIds)); + List<Device> devices2 = new ArrayList<>(); + for (Device device : devices) { + List<Integer> ids = JSON.parseArray(device.getInsProductIds(), Integer.class); + for (Integer i : ids) { + if (i == id) { + devices2.add(device); + } + } + } + return devices2; + } + + @Override + public Device selectDeviceByCode(String code) { + return deviceMapper.selectOne(Wrappers.<Device>lambdaQuery().eq(Device::getFactoryNo, code).last("limit 1")); + } } -- Gitblit v1.9.3