package com.yuanchu.mom.service.impl;
|
|
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.common.PrintChina;
|
import com.yuanchu.mom.excel.StructureTestObjectData;
|
import com.yuanchu.mom.exception.ErrorException;
|
import com.yuanchu.mom.mapper.ProductMapper;
|
import com.yuanchu.mom.mapper.StructureTestObjectMapper;
|
import com.yuanchu.mom.pojo.Laboratory;
|
import com.yuanchu.mom.pojo.Product;
|
import com.yuanchu.mom.pojo.StructureTestObject;
|
import com.yuanchu.mom.service.LaboratoryService;
|
import com.yuanchu.mom.service.ProductService;
|
import com.yuanchu.mom.utils.QueryWrappers;
|
import lombok.AllArgsConstructor;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* @author z1292
|
* @description 针对表【product(产品表)】的数据库操作Service实现
|
* @createDate 2024-04-26 01:11:02
|
*/
|
@Service
|
@AllArgsConstructor
|
public class ProductServiceImpl extends ServiceImpl<ProductMapper, Product>
|
implements ProductService{
|
|
private ProductMapper productMapper;
|
|
private GetLook getLook;
|
|
private LaboratoryService laboratoryService;
|
|
private StructureTestObjectMapper structureTestObjectMapper;
|
|
@Override
|
public Map<String, Object> selectProductListByObjectId(Page page, Product product) {
|
Map<String, Object> map = new HashMap<>();
|
map.put("head", PrintChina.printChina(Product.class));
|
Map<String, Integer> map1 = getLook.selectPowerByMethodAndUserId("selectProductListByObjectId");
|
if(map1.get("look")==1) product.setCreateUser(map1.get("userId"));
|
map.put("body", productMapper.selectPage(page, QueryWrappers.queryWrappers(product).eq("object_id", product.getObjectId())));
|
return map;
|
}
|
|
@Override
|
public int addProduct(Product product) {
|
return productMapper.insert(product);
|
}
|
|
@Override
|
public int upProduct(Product product) {
|
return productMapper.updateById(product);
|
}
|
|
@Override
|
public int delProduct(Integer id) {
|
return productMapper.deleteById(id);
|
}
|
|
@Transactional(rollbackFor = Exception.class)
|
@Override
|
public void importPartExcel(List<StructureTestObjectData> list) {
|
list.forEach(i -> {
|
// 检验对象
|
StructureTestObject structureTestObject1 = structureTestObjectMapper.selectOne(Wrappers.<StructureTestObject>lambdaQuery()
|
.eq(StructureTestObject::getSpecimenName, i.getSpecimenName())
|
.eq(StructureTestObject::getSpecimenNameEn, i.getSpecimenNameEn()));
|
Laboratory laboratory = laboratoryService.getOne(Wrappers.<Laboratory>lambdaQuery()
|
.eq(Laboratory::getLaboratoryName, i.getLaboratory()));
|
if (ObjectUtils.isEmpty(laboratory)) {
|
throw new ErrorException("未找到该场所：" + i.getLaboratory() + "，请检查是否存在该场所！");
|
}
|
// 如果为空进行新增
|
if(ObjectUtils.isEmpty(structureTestObject1)) {
|
StructureTestObject structureTestObject = new StructureTestObject();
|
structureTestObject.setLaboratoryId(laboratory.getId());
|
structureTestObject.setSpecimenName(i.getSpecimenName());
|
structureTestObject.setSpecimenNameEn(i.getSpecimenNameEn());
|
structureTestObject.setCode(i.getCode());
|
structureTestObjectMapper.insert(structureTestObject);
|
|
// 产品
|
Product product = productMapper.selectOne(Wrappers.<Product>lambdaQuery()
|
.eq(Product::getName, i.getName())
|
.eq(Product::getNameEn, i.getNameEn()));
|
if (ObjectUtils.isEmpty(product)){
|
Product product1 = new Product();
|
product1.setName(i.getName());
|
product1.setNameEn(i.getNameEn());
|
product1.setObjectId(structureTestObject.getId());
|
baseMapper.insert(product1);
|
}
|
} else {
|
structureTestObject1.setCode(i.getCode());
|
structureTestObject1.setLaboratoryId(laboratory.getId());
|
structureTestObjectMapper.updateById(structureTestObject1);
|
// 产品
|
Product product = productMapper.selectOne(Wrappers.<Product>lambdaQuery()
|
.eq(Product::getName, i.getName())
|
.eq(Product::getNameEn, i.getNameEn()));
|
if (ObjectUtils.isEmpty(product)){
|
Product product1 = new Product();
|
product1.setName(i.getName());
|
product1.setNameEn(i.getNameEn());
|
product1.setObjectId(structureTestObject1.getId());
|
baseMapper.insert(product1);
|
} else {
|
product.setName(i.getName());
|
product.setNameEn(i.getNameEn());
|
product.setObjectId(structureTestObject1.getId());
|
baseMapper.updateById(product);
|
}
|
}
|
});
|
}
|
}
|
