From e706cc37a9643f2aac1791e45e30817ebcb564ae Mon Sep 17 00:00:00 2001
From: value <z1292839451@163.com>
Date: 星期三, 01 五月 2024 10:13:28 +0800
Subject: [PATCH] 费用统计增加时间段搜索
---
inspect-server/src/main/java/com/yuanchu/mom/service/impl/StandardProductListServiceImpl.java | 123 ++++++++++++++++++++++++++++++++++++++---
1 files changed, 114 insertions(+), 9 deletions(-)
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/StandardProductListServiceImpl.java b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/StandardProductListServiceImpl.java
index 96c6738..f3a44c8 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/StandardProductListServiceImpl.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/StandardProductListServiceImpl.java
@@ -3,15 +3,21 @@
import com.alibaba.fastjson.JSONArray;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.yuanchu.mom.common.GetLook;
+import com.yuanchu.mom.mapper.StandardProductListMapper;
+import com.yuanchu.mom.mapper.StandardTreeMapper;
import com.yuanchu.mom.pojo.InsSample;
import com.yuanchu.mom.pojo.StandardProductList;
+import com.yuanchu.mom.pojo.StandardTree;
import com.yuanchu.mom.service.StandardProductListService;
-import com.yuanchu.mom.mapper.StandardProductListMapper;
import lombok.AllArgsConstructor;
import org.springframework.stereotype.Service;
import java.math.BigDecimal;
+import java.util.ArrayList;
import java.util.List;
+import java.util.Objects;
+import java.util.concurrent.CompletableFuture;
import java.util.stream.Collectors;
/**
@@ -26,6 +32,10 @@
private StandardProductListMapper standardProductListMapper;
+ private StandardTreeMapper standardTreeMapper;
+
+ private GetLook getLook;
+
@Override
public int upStandardProductList(StandardProductList list) {
return standardProductListMapper.updateById(list);
@@ -38,15 +48,110 @@
@Override
public List<StandardProductList> selectStandardProductList(InsSample insSample) {
- List<StandardProductList> list = standardProductListMapper.selectList(Wrappers.<StandardProductList>lambdaQuery().eq(StandardProductList::getFactory, insSample.getFactory()).eq(StandardProductList::getLaboratory, insSample.getLaboratory()).eq(StandardProductList::getSampleType, insSample.getSampleType()).eq(StandardProductList::getSample, insSample.getSample()).eq(StandardProductList::getModel, insSample.getModel()));
- if (list.size() == 0) {
- list = standardProductListMapper.selectList(Wrappers.<StandardProductList>lambdaQuery().eq(StandardProductList::getFactory, insSample.getFactory()).eq(StandardProductList::getLaboratory, insSample.getLaboratory()).eq(StandardProductList::getSampleType, insSample.getSampleType()).eq(StandardProductList::getSample, insSample.getSample()));
+ List<StandardProductList> list = standardProductListMapper.selectList(Wrappers.<StandardProductList>lambdaQuery().eq(StandardProductList::getStandardMethodListId, insSample.getStandardMethodListId()).eq(StandardProductList::getState, 1).eq(StandardProductList::getModel, insSample.getModel()));
+ list = list.stream().filter(a -> {
try {
- list = list.stream().filter(a -> {
- String[] split = a.getSection().split("~");
- return new BigDecimal(insSample.getModel()).compareTo(new BigDecimal(split[0])) > -1 && new BigDecimal(insSample.getModel()).compareTo(new BigDecimal(split[1])) < 1;
- }).collect(Collectors.toList());
- } catch (Exception e) {}
+ if (a.getSection() != null && !Objects.equals(a.getSection(), "")) {
+ if (a.getSection().contains("~")) {
+ String[] split = a.getSection().split("~");
+ return new BigDecimal(insSample.getModel()).compareTo(new BigDecimal(split[0])) > -1 && new BigDecimal(insSample.getModel()).compareTo(new BigDecimal(split[1])) < 1;
+ } else if (a.getSection().contains("鈮�") || a.getSection().contains(">=")) {
+ String param = a.getSection().replace("鈮�", "").replace(">=", "");
+ return new BigDecimal(insSample.getModel()).compareTo(new BigDecimal(param)) > -1;
+ } else if (a.getSection().contains("鈮�") || a.getSection().contains("<=")) {
+ String param = a.getSection().replace("鈮�", "").replace("<=", "");
+ return new BigDecimal(insSample.getModel()).compareTo(new BigDecimal(param)) < 1;
+ } else if (a.getSection().contains(">")) {
+ String param = a.getSection().replace(">", "");
+ return new BigDecimal(insSample.getModel()).compareTo(new BigDecimal(param)) > 0;
+ } else if (a.getSection().contains("<")) {
+ String param = a.getSection().replace("<", "");
+ return new BigDecimal(insSample.getModel()).compareTo(new BigDecimal(param)) < 0;
+ } else if (a.getSection().contains("=")) {
+ String param = a.getSection().replace("=", "");
+ return new BigDecimal(insSample.getModel()).compareTo(new BigDecimal(param)) == 0;
+ }
+ }
+ } catch (Exception ignored) {
+ return false;
+ }
+ return true;
+ }).collect(Collectors.toList());
+ return list;
+ }
+
+ @Override
+ public List<StandardProductList> selectStandardProductListByMethodId(Integer id, String tree) {
+ String[] trees = tree.split(" - ");
+ StringBuffer str = new StringBuffer();
+ List<StandardProductList> list = new ArrayList<>();
+ if (trees.length == 3) {
+ str.append("\"").append(trees[2]).append("\"");
+ } else {
+ str.append("\"").append(trees[2]).append("\",\"").append(trees[3]).append("\"");
+ list.addAll(standardTreeMapper.selectStandardProductListByTree("\"" + trees[2] + "\""));
+ }
+ list.addAll(standardTreeMapper.selectStandardProductListByTree(str + ""));
+ List<StandardProductList> standardProductLists = standardProductListMapper.selectList(Wrappers.<StandardProductList>lambdaQuery().eq(StandardProductList::getStandardMethodListId, id).eq(StandardProductList::getTree, tree));
+ for (StandardProductList sp : standardProductLists) {
+ for (StandardProductList pl : list) {
+ if (Objects.equals(sp.getInspectionItem(), pl.getInspectionItem())
+ && Objects.equals(sp.getInspectionItemSubclass(), pl.getInspectionItemSubclass())) {
+ pl.setId(sp.getId());
+ pl.setState(sp.getState());
+ pl.setFactory(sp.getFactory());
+ pl.setLaboratory(sp.getLaboratory());
+ pl.setSampleType(sp.getSampleType());
+ pl.setSample(sp.getSample());
+ pl.setModel(sp.getModel());
+ pl.setMethodS(sp.getMethodS());
+ if(sp.getAsk()!=null&&!sp.getAsk().equals("")){
+ pl.setAsk(sp.getAsk());
+ }
+ if(sp.getTell()!=null&&!sp.getTell().equals("")){
+ pl.setTell(sp.getTell());
+ }
+ if(sp.getPrice()!=null&&!sp.getPrice().equals("")){
+ pl.setPrice(sp.getPrice());
+ }
+ if(sp.getManHour()!=null&&!sp.getManHour().equals("")){
+ pl.setManHour(sp.getManHour());
+ }
+ break;
+ }
+ }
+ }
+ Integer userId = getLook.selectPowerByMethodAndUserId(null).get("userId");
+ CompletableFuture.supplyAsync(() -> {
+ standardProductListMapper.delete(Wrappers.<StandardProductList>lambdaUpdate().eq(StandardProductList::getStandardMethodListId, id).eq(StandardProductList::getTree, tree));
+ saveBatch(list.stream().map(a->{
+ a.setFactory(trees[0]);
+ a.setLaboratory(trees[1]);
+ a.setSampleType(trees[2]);
+ try {
+ a.setSample(trees[3]);
+ }catch (Exception e){}
+ try {
+ a.setModel(trees[4]);
+ }catch (Exception e){}
+ a.setTree(tree);
+ a.setCreateUser(userId);
+ a.setUpdateUser(userId);
+ a.setStandardMethodListId(id);
+ return a;
+ }).collect(Collectors.toList()));
+ return null;
+ }).thenAccept(res -> {
+ }).exceptionally(e -> {
+ e.printStackTrace();
+ return null;
+ });
+ switch (trees.length){
+ case 3:
+ standardTreeMapper.selectList(Wrappers.<StandardTree>lambdaQuery().eq(StandardTree::getFactory, trees[0]).eq(StandardTree::getLaboratory, trees[1]).eq(StandardTree::getSampleType, trees[2]));
+ break;
+ case 4:
+ break;
}
return list;
}
--
Gitblit v1.9.3