package com.yuanchu.mom.service.impl;
|
|
import com.alibaba.excel.annotation.ExcelProperty;
|
import com.alibaba.fastjson.JSON;
|
import com.alibaba.fastjson.JSONArray;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.core.toolkit.IdWorker;
|
import com.baomidou.mybatisplus.core.toolkit.ObjectUtils;
|
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.dto.ProductDto;
|
import com.yuanchu.mom.exception.ErrorException;
|
import com.yuanchu.mom.mapper.StandardMethodListMapper;
|
import com.yuanchu.mom.mapper.StandardProductListMapper;
|
import com.yuanchu.mom.mapper.StandardTreeMapper;
|
import com.yuanchu.mom.pojo.InsSample;
|
import com.yuanchu.mom.pojo.StandardMethodList;
|
import com.yuanchu.mom.pojo.StandardProductList;
|
import com.yuanchu.mom.pojo.StandardTree;
|
import com.yuanchu.mom.service.StandardProductListService;
|
import com.yuanchu.mom.service.StandardProductListService2;
|
import lombok.AllArgsConstructor;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
|
import java.math.BigDecimal;
|
import java.util.*;
|
import java.util.concurrent.CompletableFuture;
|
import java.util.regex.Matcher;
|
import java.util.regex.Pattern;
|
import java.util.stream.Collectors;
|
|
/**
|
* @author Administrator
|
* @description 针对表【standard_product_list(标准树下的检验项目)】的数据库操作Service实现
|
* @createDate 2024-03-05 10:33:29
|
*/
|
@Service
|
@AllArgsConstructor
|
public class StandardProductListServiceImpl extends ServiceImpl<StandardProductListMapper, StandardProductList>
|
implements StandardProductListService {
|
|
private StandardProductListMapper standardProductListMapper;
|
|
private StandardTreeMapper standardTreeMapper;
|
|
private GetLook getLook;
|
|
private StandardProductListService2 standardProductListService2;
|
|
@Override
|
public int upStandardProductList(StandardProductList list) {
|
return standardProductListMapper.updateById(list);
|
}
|
|
@Override
|
public int delStandardProduct(JSONArray list) {
|
return standardProductListMapper.deleteBatchIds(list);
|
}
|
|
@Override
|
public List<StandardProductList> selectStandardProductList(InsSample insSample) {
|
String[] models = insSample.getModel().split("-(?=[^-]*$)");//拆分最后一个【-】
|
String[] models1 = insSample.getModel().split(";(?=[^;]*$)");//拆分最后一个【-】
|
List<Integer> ids = Arrays.stream(insSample.getStandardMethodListId().split(","))
|
.map(String::trim).map(Integer::parseInt).collect(Collectors.toList());
|
List<StandardProductList> list = standardProductListMapper.selectDetail(ids, 1, models[0]);
|
if (list.size() == 0) {
|
if (Objects.equals(insSample.getFactory(), "") || insSample.getFactory() == null) {
|
return null;
|
}
|
String[] split = insSample.getFactory().split(" - ");
|
String tree = split[0] + " - " + split[1] + " - " + split[2] + " - " + split[3] + " - null";
|
list = standardProductListMapper.selectDetail2(ids, 1, tree);
|
if (list.size() == 0) {
|
String tree1 = split[0] + " - " + split[1] + " - " + split[2] + " - null - " + split[3];
|
list = standardProductListMapper.selectDetail2(ids, 1, tree1);
|
}
|
}
|
String[] split1 = insSample.getFactory().split(" - ");
|
//判断长度
|
if (split1.length > 4) {
|
if (ObjectUtils.isNotEmpty(split1[3])) {
|
list = list.stream().filter(list1 -> Objects.nonNull(list1.getSample())&&Objects.equals(list1.getSample(),split1[3])).collect(Collectors.toList());
|
}else if (split1[3].equals("")) {
|
list = list.stream().filter(list1 -> Objects.nonNull(list1.getSampleType())&&Objects.equals(list1.getSampleType(),split1[2])).collect(Collectors.toList());
|
}
|
}
|
list = list.stream().filter(a -> {
|
try {
|
if (a.getSection() != null && !Objects.equals(a.getSection(), "")) {
|
List<String> sections = JSON.parseArray(a.getSection(), String.class);
|
List<String> asks = JSON.parseArray(a.getAsk(), String.class);
|
List<String> tells = JSON.parseArray(a.getTell(), String.class);
|
List<String> manHours = JSON.parseArray(a.getManHour(), String.class);
|
List<String> prices = JSON.parseArray(a.getPrice(), String.class);
|
boolean isIf;
|
for (int i = 0; i < sections.size(); i++) {
|
if (Objects.equals(a.getBsm(), "1")) {
|
return true;
|
} else {
|
if (sections.get(i).contains("&")) {
|
String[] split = sections.get(i).split("&");
|
isIf = getIsIf(split[0], models1[1]) && getIsIf(split[1], models[1].split(";")[0]);
|
} else {
|
if (ObjectUtils.isNotEmpty(models[1].split(";")[0])){
|
isIf = getIsIf(sections.get(i), models[1].split(";")[0]);
|
if (!isIf) {
|
isIf = getIsIf(sections.get(i), models1[1]);
|
}
|
}else {
|
isIf = getIsIf(sections.get(i), models1[1]);
|
}
|
}
|
if (isIf) {
|
a.setSection(sections.get(i));
|
a.setAsk(asks.get(i));
|
a.setTell(tells.get(i));
|
a.setPrice(prices.get(i));
|
a.setManHour(manHours.get(i));
|
return true;
|
}
|
}
|
}
|
return false;
|
}
|
} catch (Exception ignored) {
|
return false;
|
}
|
return true;
|
}).map(standardProductList -> {
|
String code = baseMapper.selectStandardMethodById(standardProductList.getStandardMethodListId());
|
standardProductList.setMethodS(code);
|
return standardProductList;
|
}).collect(Collectors.toList());
|
//按照电路试验--辐射试验--温湿度试验--环境试验进行排序
|
// 定义自定义排序器
|
Comparator<StandardProductList> testTypeComparator = (o1, o2) -> {
|
String[] order = {"电路试验", "辐射试验", "温湿度试验", "环境试验","功率试验"};
|
int index1 = -1;
|
int index2 = -1;
|
// 找出两个对象 在自定义顺序数组中的位置
|
for (int i = 0; i < order.length; i++) {
|
if (o1.getInspectionItem().equals(order[i])) {
|
index1 = i;
|
}
|
if (o2.getInspectionItem().equals(order[i])) {
|
index2 = i;
|
}
|
if (index1 != -1 && index2 != -1) {
|
break; // 两个位置都找到了，可以退出循环
|
}
|
}
|
// 比较位置
|
int compareResult = Integer.compare(index1, index2);
|
// 如果是环境试验，且两个对象在主检验项目上排序相同，则用次级检验项目排序
|
if (compareResult == 0 && order[index1].equals("环境试验")) {
|
String[] subOrder = {"冲水试验", "振动试验"};
|
int subIndex1 = -1;
|
int subIndex2 = -1;
|
for (int i = 0; i < subOrder.length; i++) {
|
if (o1.getInspectionItemSubclass().equals(subOrder[i])) {
|
subIndex1 = i;
|
}
|
if (o2.getInspectionItemSubclass().equals(subOrder[i])) {
|
subIndex2 = i;
|
}
|
if (subIndex1 != -1 && subIndex2 != -1) {
|
break; // 两个次级位置都找到了，可以退出循环
|
}
|
}
|
compareResult = Integer.compare(subIndex1, subIndex2);
|
}
|
// 比较位置
|
return compareResult;
|
};
|
// 对列表进行排序
|
Collections.sort(list, testTypeComparator);
|
return list;
|
}
|
|
private boolean getIsIf(String str, String model) {
|
Matcher matcher = Pattern.compile("\\d+(\\.\\d+)?").matcher(model);
|
String model2 = "";
|
if (matcher.find()) {
|
model2 += matcher.group();
|
}else {
|
model2=model;
|
}
|
if (str.contains("≥") || str.contains(">=")) {
|
String param = str.replace("≥", "").replace(">=", "");
|
return new BigDecimal(model2).compareTo(new BigDecimal(param)) > -1;
|
} else if (str.contains("≤") || str.contains("<=")) {
|
String param = str.replace("≤", "").replace("<=", "");
|
return new BigDecimal(model2).compareTo(new BigDecimal(param)) < 1;
|
} else if (str.contains(">") || str.contains("＞")) {
|
String param = str.replace(">", "").replace("＞", "");
|
return new BigDecimal(model2).compareTo(new BigDecimal(param)) > 0;
|
} else if (str.contains("<") || str.contains("＜")) {
|
String param = str.replace("<", "").replace("＜", "");
|
return new BigDecimal(model2).compareTo(new BigDecimal(param)) < 0;
|
} else if (str.contains("=")) {
|
String param = str.replace("=", "");
|
if (matcher.find()) {
|
return new BigDecimal(model2).compareTo(new BigDecimal(param)) == 0;
|
}else {
|
return model2.equals(param);
|
}
|
}
|
return false;
|
}
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public Map<String, Object> selectStandardProductListByMethodId(Integer id, String tree, Integer page) {
|
String[] trees = tree.split(" - ");
|
try {
|
String tree1 = trees[2];
|
} catch (Exception e) {
|
throw new ErrorException("操作太快,系统传参错误!!!!");
|
}
|
List<StandardProductList> list = new ArrayList<>();
|
if (trees.length == 3) {
|
List<StandardTree> treeList = new ArrayList<>();
|
StandardTree standardTree = new StandardTree();
|
standardTree.setFactory(trees[0]);
|
standardTree.setLaboratory(trees[1]);
|
standardTree.setSampleType(trees[2]);
|
List<ProductDto> pList = standardTreeMapper.selectPList(trees[2]);
|
if (pList.size() == 0 || pList.get(0) == null) {
|
List<StandardTree> treeList1 = standardTreeMapper.selectList(Wrappers.<StandardTree>lambdaQuery().eq(StandardTree::getLaboratory, trees[1]).eq(StandardTree::getSampleType, trees[2]));
|
if (treeList1.size() == 0) {
|
treeList.add(standardTree);
|
} else {
|
treeList.addAll(treeList1);
|
}
|
} else {
|
for (ProductDto p : pList) {
|
standardTree.setSample(p.getName());
|
List<StandardTree> treeList1 = standardTreeMapper.selectList(Wrappers.<StandardTree>lambdaQuery().eq(StandardTree::getLaboratory, trees[1]).eq(StandardTree::getSampleType, trees[2]).eq(StandardTree::getSample, p.getName()));
|
if (treeList1.size() == 0) {
|
treeList.add(JSON.parseObject(JSON.toJSONString(standardTree), StandardTree.class));
|
} else {
|
treeList.addAll(treeList1);
|
}
|
}
|
}
|
for (StandardTree standardTree2 : treeList) {
|
String tree2 = trees[0] + " - " + trees[1] + " - " + trees[2] + " - " + standardTree2.getSample() + " - " + standardTree2.getModel();
|
list.addAll(standardTreeMapper.selectStandardProductListByTree("\"" + trees[2] + "\"", standardTree2.getSample(), standardTree2.getModel(), tree2, trees[1]));
|
list.addAll(standardTreeMapper.selectStandardProductListByTree2("\"" + trees[2] + "\",\"" + standardTree2.getSample() + "\"", standardTree2.getSample(), standardTree2.getModel(), tree2, trees[1]));
|
}
|
}
|
else if (trees.length == 4) {
|
List<StandardTree> treeList = standardTreeMapper.selectList(Wrappers.<StandardTree>lambdaQuery().eq(StandardTree::getLaboratory, trees[1]).eq(StandardTree::getSampleType, trees[2]).eq(StandardTree::getSample, trees[3]));
|
if (treeList.size() == 0) {
|
StandardTree standardTree = new StandardTree();
|
standardTree.setFactory(trees[0]);
|
standardTree.setLaboratory(trees[1]);
|
standardTree.setSampleType(trees[2]);
|
standardTree.setSample(trees[3]);
|
treeList.add(standardTree);
|
}
|
for (StandardTree standardTree : treeList) {
|
String str = tree + " - " + standardTree.getModel();
|
list.addAll(standardTreeMapper.selectStandardProductListByTree("\"" + trees[2] + "\"", standardTree.getSample(), standardTree.getModel(), str, trees[1]));
|
list.addAll(standardTreeMapper.selectStandardProductListByTree2("\"" + trees[2] + "\",\"" + trees[3] + "\"", standardTree.getSample(), standardTree.getModel(), str, trees[1]));
|
}
|
}
|
else {
|
list.addAll(standardTreeMapper.selectStandardProductListByTree("\"" + trees[2] + "\"", trees[3].equals("null") ? null : trees[3], trees[4], tree, trees[1]));
|
list.addAll(standardTreeMapper.selectStandardProductListByTree2("\"" + trees[2] + "\",\"" + trees[3] + "\"", trees[3].equals("null") ? null : trees[3], trees[4], tree, trees[1]));
|
}
|
for (StandardProductList productList : list) {
|
productList.setId(IdWorker.getId());
|
}
|
List<StandardProductList> standardProductLists = standardProductListMapper.selectList(Wrappers.<StandardProductList>lambdaQuery().eq(StandardProductList::getStandardMethodListId, id).like(StandardProductList::getTree, tree));
|
for (StandardProductList sp : standardProductLists) {
|
for (StandardProductList pl : list) {
|
if (Objects.equals(sp.getInspectionItem(), pl.getInspectionItem())
|
&& Objects.equals((sp.getInspectionItemSubclass() == null) ? "" : sp.getInspectionItemSubclass(), pl.getInspectionItemSubclass() == null ? "" : pl.getInspectionItemSubclass())
|
// && Objects.equals(sp.getSample(), pl.getSample())
|
&& Objects.equals(sp.getModel(), pl.getModel())
|
&& sp.getTree().indexOf(pl.getSample() == null ? "null" : pl.getSample()) > -1
|
&& Objects.equals(sp.getStructureItemParameterId(), pl.getStructureItemParameterId())) {
|
pl.setId(sp.getId());
|
if (sp.getState() != null && !sp.getState().equals("")) {
|
pl.setState(sp.getState());
|
} else {
|
pl.setState(id == 0 ? 1 : 0);
|
}
|
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());
|
}
|
if (sp.getSection() != null && !sp.getSection().equals("")) {
|
pl.setSection(sp.getSection());
|
}
|
if (sp.getTemplateId() != null && !sp.getTemplateId().equals("")) {
|
pl.setTemplateId(sp.getTemplateId());
|
}
|
if (sp.getTree() != null && !sp.getTree().equals("")) {
|
pl.setTree(sp.getTree());
|
}
|
break;
|
}
|
}
|
}
|
if (page == 1) {
|
Integer userId = getLook.selectPowerByMethodAndUserId(null).get("userId");
|
// CompletableFuture.supplyAsync(() -> {
|
System.out.println("开始开始开始开始!!!!!!!!!!");
|
if (trees.length == 5) {
|
standardProductListMapper.delete(Wrappers.<StandardProductList>lambdaUpdate()
|
.eq(StandardProductList::getStandardMethodListId, id)
|
.eq(StandardProductList::getTree, tree));
|
} else {
|
standardProductListMapper.delete(Wrappers.<StandardProductList>lambdaUpdate()
|
.eq(StandardProductList::getStandardMethodListId, id)
|
.like(StandardProductList::getTree, tree));
|
}
|
|
boolean success = false;
|
int retryCount = 0;
|
while (!success && retryCount < 100) {
|
try {
|
standardProductListService2.saveOrUpdateBatch(list.stream().map(a -> {
|
a.setFactory(trees[0]);
|
a.setLaboratory(trees[1]);
|
a.setSampleType(trees[2]);
|
a.setCreateUser(userId);
|
a.setUpdateUser(userId);
|
a.setStandardMethodListId(id);
|
return a;
|
}).collect(Collectors.toList()));
|
success = true;
|
} catch (Exception e) {
|
retryCount++;
|
System.out.println("重复" + retryCount + "次");
|
// 处理重复 ID 的记录，重新生成 ID 并继续尝试插入
|
for (StandardProductList productList : list) {
|
productList.setId(IdWorker.getId());
|
}
|
}
|
}
|
if (!success) {
|
throw new RuntimeException("插入失败");
|
} else {
|
System.out.println("结束结束结束结束@@@@@@@@@@@@");
|
}
|
|
/* standardProductListService2.saveBatch(list.stream().map(a -> {
|
a.setFactory(trees[0]);
|
a.setLaboratory(trees[1]);
|
a.setSampleType(trees[2]);
|
a.setCreateUser(userId);
|
a.setUpdateUser(userId);
|
a.setStandardMethodListId(id);
|
return a;
|
}).collect(Collectors.toList()));*/
|
// return null;
|
// }).thenAccept(res -> {
|
// }).exceptionally(e -> {
|
// e.printStackTrace();
|
// return null;
|
// });
|
}
|
Map<String, Object> map = new HashMap<>();
|
Collections.sort(list, (o1, o2) -> {
|
String field1 = o1.getManHourGroup();
|
String field2 = o2.getManHourGroup();
|
|
boolean isEmpty1 = field1 == null || field1.isEmpty();
|
boolean isEmpty2 = field2 == null || field2.isEmpty();
|
|
if (isEmpty1 && isEmpty2) {
|
return 0;
|
} else if (isEmpty1) {
|
return 1;
|
} else if (isEmpty2) {
|
return -1;
|
} else {
|
int num1 = extractNumber(field1);
|
int num2 = extractNumber(field2);
|
return Integer.compare(num1, num2);
|
}
|
});
|
try {
|
map.put("productList", list.subList((page - 1) * 50, page * 50));
|
} catch (IndexOutOfBoundsException e) {
|
map.put("productList", list.subList((page - 1) * 50, list.size()));
|
}
|
map.put("total", list.size());
|
return map;
|
}
|
|
private int extractNumber(String s) {
|
// 从字符串中提取数字的逻辑，这里假设字段的格式是 "text<number>"
|
String number = s;
|
if (!s.matches("\\d+")) {
|
number = s.replaceAll("\\D", "");
|
}
|
return Integer.parseInt(number);
|
}
|
|
@Override
|
public IPage<StandardProductList> selectStandardProductByMethodId(Integer id, String tree, Integer page, String laboratory, String item, String items) {
|
IPage<StandardProductList> iPage = new Page<>();
|
iPage.setSize(100);
|
iPage.setCurrent(page);
|
return standardProductListMapper.standardProductListIPage(id, tree, iPage, laboratory, item, items);
|
}
|
|
@Override
|
public Map<String, List<?>> selectStandardProductEnumByMethodId(Integer id, String tree, String item) {
|
HashMap<String, List<?>> map = new HashMap<>();
|
map.put("item", standardProductListMapper.selectList(Wrappers.<StandardProductList>lambdaQuery()
|
.eq(StandardProductList::getStandardMethodListId, id)
|
.like(StandardProductList::getTree, tree)
|
.select(StandardProductList::getInspectionItem)
|
.groupBy(StandardProductList::getInspectionItem)));
|
if (ObjectUtils.isNotEmpty(item)) {
|
map.put("items", standardProductListMapper.selectList(Wrappers.<StandardProductList>lambdaQuery()
|
.eq(StandardProductList::getStandardMethodListId, id)
|
.eq(StandardProductList::getInspectionItem, item)
|
.like(StandardProductList::getTree, tree)
|
.select(StandardProductList::getInspectionItemSubclass)
|
.groupBy(StandardProductList::getInspectionItemSubclass)));
|
} else {
|
map.put("items", standardProductListMapper.selectList(Wrappers.<StandardProductList>lambdaQuery()
|
.eq(StandardProductList::getStandardMethodListId, id)
|
.like(StandardProductList::getTree, tree)
|
.select(StandardProductList::getInspectionItemSubclass)
|
.groupBy(StandardProductList::getInspectionItemSubclass)));
|
}
|
return map;
|
}
|
}
|
