package com.ruoyi.requier.service.impl;
|
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
|
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
|
import com.ruoyi.basic.mapper.StructureItemParameterMapper;
|
import com.ruoyi.basic.pojo.Product;
|
import com.ruoyi.basic.pojo.StructureItemParameter;
|
import com.ruoyi.basic.service.ProductService;
|
import com.ruoyi.common.core.domain.entity.Custom;
|
import com.ruoyi.inspect.mapper.InsOrderMapper;
|
import com.ruoyi.inspect.mapper.InsProductMapper;
|
import com.ruoyi.inspect.mapper.InsSampleMapper;
|
import com.ruoyi.inspect.pojo.InsOrder;
|
import com.ruoyi.inspect.pojo.InsProduct;
|
import com.ruoyi.inspect.pojo.InsSample;
|
import com.ruoyi.inspect.service.InsOrderService;
|
import com.ruoyi.requier.mapper.DeviceMaintenanceMapper;
|
import com.ruoyi.requier.mapper.DeviceMapper;
|
import com.ruoyi.requier.mapper.DeviceMetricRecordMapper;
|
import com.ruoyi.requier.pojo.Device;
|
import com.ruoyi.requier.pojo.DeviceMaintenance;
|
import com.ruoyi.requier.pojo.DeviceMetricRecord;
|
import com.ruoyi.requier.service.QrShowService;
|
import com.ruoyi.system.service.CustomService;
|
import org.apache.commons.lang3.StringUtils;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.beans.factory.annotation.Value;
|
import org.springframework.stereotype.Service;
|
import org.springframework.ui.Model;
|
|
import java.math.BigDecimal;
|
import java.math.RoundingMode;
|
import java.time.Duration;
|
import java.time.LocalDate;
|
import java.time.LocalDateTime;
|
import java.time.ZoneId;
|
import java.time.format.DateTimeFormatter;
|
import java.util.*;
|
import java.util.stream.Collectors;
|
|
@Service
|
public class QrShowServiceImpl implements QrShowService {
|
|
@Autowired
|
private InsOrderService insOrderService;
|
|
@Autowired
|
private ProductService productService;
|
|
@Autowired
|
private CustomService customService;
|
|
@Autowired
|
private InsOrderMapper insOrderMapper;
|
|
@Autowired
|
private DeviceMapper deviceMapper;
|
|
@Autowired
|
private DeviceMetricRecordMapper deviceMetricRecordMapper;
|
|
@Autowired
|
private DeviceMaintenanceMapper deviceMaintenanceMapper;
|
|
@Autowired
|
private StructureItemParameterMapper structureItemParameterMapper;
|
|
@Autowired
|
private InsSampleMapper insSampleMapper;
|
|
@Autowired
|
private InsProductMapper insProductMapper;
|
|
@Value("${spring.profiles.active}")
|
private String active;
|
|
private String getIp(){
|
if(StringUtils.isNotBlank(active)){
|
return "prod".equals(active)?"https://zttx-lims.ztt.cn:8021/lims/":"http://114.132.189.42:8001/";
|
}
|
return "http://192.168.1.124:8001/lims/";
|
}
|
|
@Override
|
public void transformModelByType(Model model, String code, String type) {
|
if(StringUtils.isNotBlank(type)){
|
switch (type){
|
case "word":
|
InsOrder insOrder = insOrderService.getOne(Wrappers.<InsOrder>lambdaQuery()
|
.eq(InsOrder::getEntrustCode, code));
|
Product product = productService.getOne(Wrappers.<Product>lambdaQuery()
|
.eq(Product::getName, insOrder.getSample()));
|
String insOrderModel = productService.getWordQrModel(insOrder.getId());
|
Custom company = customService.getOne(Wrappers.<Custom>lambdaQuery()
|
.eq(Custom::getCompany, insOrder.getCompany()));
|
String orderType = insOrderMapper.getEnumLabelByValue(insOrder.getOrderType());
|
String[] monthNames = {"January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"};
|
model.addAttribute("entrustCode", code);
|
model.addAttribute("productName",product.getName());
|
model.addAttribute("productNameEn",product.getNameEn());
|
model.addAttribute("insOrderModel", insOrderModel);
|
model.addAttribute("company", company.getCompany());
|
model.addAttribute("companyEn", company.getCompanyEn());
|
model.addAttribute("getTime", insOrder.getExamineTime().format(DateTimeFormatter.ofPattern("yyyy年MM月dd日")));
|
String getTimeEn = monthNames[insOrder.getExamineTime().getMonthValue() - 1] + " " + insOrder.getExamineTime().getDayOfMonth() + ", " + insOrder.getExamineTime().getYear();
|
model.addAttribute("getTimeEn", getTimeEn);
|
model.addAttribute("issuingDate", insOrder.getIssuingDate().format(DateTimeFormatter.ofPattern("yyyy年MM月dd日")));
|
String issuingDateEn = monthNames[insOrder.getIssuingDate().getMonthValue() - 1] + " " + insOrder.getIssuingDate().getDayOfMonth() + ", " + insOrder.getIssuingDate().getYear();
|
model.addAttribute("issuingDateEn", issuingDateEn);
|
model.addAttribute("orderType", orderType);
|
model.addAttribute("orderTypeEn", insOrder.getOrderType());
|
break;
|
case "device":
|
//查询设备主表信息
|
List<Device> deviceList = deviceMapper.selectList(Wrappers.<Device>lambdaQuery().eq(Device::getManagementNumber, code));
|
if(deviceList.size()>1){
|
throw new RuntimeException("设备编号"+code+"重复");
|
}
|
Device device = deviceList.isEmpty()?null:deviceList.get(0);
|
if(!Objects.isNull(device)){
|
//查询设备校准信息
|
DeviceMetricRecord calibrate = getDeviceMetricRecord(device.getId(), "calibrate");
|
//查询设备核查信息
|
DeviceMetricRecord examine = getDeviceMetricRecord(device.getId(), "examine");
|
//查询设备维护记录
|
DeviceMaintenance deviceMaintenance = Optional.ofNullable(deviceMaintenanceMapper.selectOne(Wrappers.<DeviceMaintenance>lambdaQuery()
|
.eq(DeviceMaintenance::getDeviceId, device.getId())
|
.orderByDesc(DeviceMaintenance::getId)
|
.last("limit 1"))).orElse(new DeviceMaintenance());
|
model.addAttribute("progress",calcDeviceNextCheckRatio(calibrate.getCalibrationDate(),calibrate.getNextCalibrationDate()));//距离下次校准日期的天数百分比
|
model.addAttribute("deviceName",device.getDeviceName());//设备名称
|
model.addAttribute("deviceCode",device.getManagementNumber());//设备编号
|
model.addAttribute("usedYears",calcUsedYears(device.getActivationDate()));//启用时长(年)
|
model.addAttribute("runStatus",device.getDeviceStatus());//设备运行状态
|
model.addAttribute("lastCalibrationDate",formatDate(calibrate.getCalibrationDate(),"yyyy-MM-dd"));//最近校准日期
|
model.addAttribute("nextCalibrationDate",formatDate(calibrate.getNextCalibrationDate(),"yyyy-MM-dd"));//下次校准日期
|
String calibrateStatus = "0yes".equals(calibrate.getStatus())?"合格":"1no".equals(calibrate.getStatus())?"不合格":"其他";
|
model.addAttribute("calibrateStatus",Objects.isNull(calibrate.getCalibrationDate())?"":calibrateStatus);//校准总结论
|
model.addAttribute("lastExamineDate",formatDate(examine.getCalibrationDate(),"yyyy-MM-dd"));//最近核查日期
|
model.addAttribute("nextExamineDate",formatDate(examine.getNextCalibrationDate(),"yyyy-MM-dd"));//下次核查日期
|
String examineStatus = "0yes".equals(examine.getStatus())?"合格":"1no".equals(examine.getStatus())?"不合格":"其他";
|
model.addAttribute("examineStatus",Objects.isNull(examine.getCalibrationDate())?"":examineStatus);//核查总结论
|
model.addAttribute("maintenanceDate",formatDate(deviceMaintenance.getDate(),"yyyy-MM-dd"));//最近维护日期
|
model.addAttribute("nextMaintenanceDate",formatDate(deviceMaintenance.getNextDate(),"yyyy-MM-dd"));//下次维护日期
|
String maintenanceType = "";
|
if(!Objects.isNull(deviceMaintenance.getMaintenanceType())){
|
maintenanceType = 0==deviceMaintenance.getMaintenanceType()?"使用前维护":"使用后维护";
|
}
|
model.addAttribute("maintenanceType",maintenanceType);//维护总结论
|
//测量项目
|
String insProduct = "";
|
if(StringUtils.isNotBlank(device.getInsProductIds())){
|
String[] ids = device.getInsProductIds().split(",");
|
List<StructureItemParameter> parameters = structureItemParameterMapper.selectBatchIds(Arrays.asList(ids));
|
List<String> itemList = parameters.stream().map(StructureItemParameter::getInspectionItem).distinct().collect(Collectors.toList());
|
insProduct = String.join(",",itemList);
|
}
|
model.addAttribute("insProduct",insProduct);//测量项目
|
model.addAttribute("fileName",calibrate.getFileName());
|
model.addAttribute("downloadUrl",getIp()+"img/"+calibrate.getSystemFileName());
|
}
|
break;
|
case "sample":
|
// 查询样品信息
|
InsSample insSample = insSampleMapper.selectById(code);
|
InsOrder insOrder1 = insOrderMapper.selectById(insSample.getInsOrderId());
|
List<InsProduct> insProducts = insProductMapper.selectList(new LambdaQueryWrapper<InsProduct>()
|
.eq(InsProduct::getInsSampleId, insSample.getId()));
|
String collect = "";
|
if(CollectionUtils.isNotEmpty(insProducts)){
|
// collect = insProducts.stream().map(item -> {
|
// String inspectionItem = "";
|
// if (Strings.isNotEmpty(item.getInspectionItemSubclass())) {
|
// inspectionItem = item.getInspectionItemSubclass();
|
// } else {
|
// inspectionItem = item.getInspectionItem();
|
// }
|
// return inspectionItem;
|
// }).distinct().collect(Collectors.joining(","));
|
collect = insProducts.stream().map(InsProduct::getInspectionItem).distinct().collect(Collectors.joining(","));
|
}
|
model.addAttribute("sampleCode",insSample.getSampleCode()); // 样品编号
|
model.addAttribute("entrustCode",insOrder1.getEntrustCode()); // 委托单号
|
model.addAttribute("model",insSample.getModel()); // 规格型号
|
model.addAttribute("sample",insSample.getSample()); // 样品名称
|
model.addAttribute("inspectionItem",collect); // 检测项目
|
model.addAttribute("insState",insSample.getInsState()); // 检测状态
|
model.addAttribute("isLeave",insOrder1.getIsLeave()); // 是否留样
|
}
|
}
|
}
|
|
/**
|
* 计算启用时长
|
* @param activationDate
|
* @return
|
*/
|
public double calcUsedYears(LocalDateTime activationDate) {
|
if(Objects.isNull(activationDate)){
|
return 0;
|
}
|
BigDecimal defDays = BigDecimal.valueOf(365);
|
BigDecimal usedDays = BigDecimal.valueOf(Duration.between(activationDate,LocalDateTime.now()).toDays());
|
return usedDays.divide(defDays,2,RoundingMode.HALF_UP).setScale(2,RoundingMode.HALF_UP).doubleValue();
|
}
|
|
/**
|
* 计算距离下次校准日期的天数百分比
|
* @param startDate
|
* @param endDate
|
* @return
|
*/
|
public double calcDeviceNextCheckRatio(Date startDate, Date endDate){
|
if(Objects.isNull(startDate) || Objects.isNull(endDate)){
|
return 0;
|
}
|
LocalDateTime startLocalDate = startDate.toInstant().atZone(ZoneId.systemDefault()).toLocalDateTime();
|
LocalDateTime endLocalDate = endDate.toInstant().atZone(ZoneId.systemDefault()).toLocalDateTime();
|
long totalDays = Duration.between(startLocalDate, endLocalDate).toDays();
|
long usedDays = Duration.between(startLocalDate, LocalDateTime.now()).toDays();
|
BigDecimal calcVal = BigDecimal.valueOf(usedDays).divide(BigDecimal.valueOf(totalDays),2,RoundingMode.HALF_UP).multiply(BigDecimal.valueOf(100)).setScale(2, RoundingMode.HALF_UP);
|
if(calcVal.compareTo(BigDecimal.ZERO)<0){
|
calcVal = BigDecimal.ZERO;
|
}else if(calcVal.compareTo(BigDecimal.valueOf(100))>0){
|
calcVal = BigDecimal.valueOf(100);
|
}
|
return calcVal.doubleValue();
|
}
|
|
/**
|
* 查询设备校准/核查记录
|
* @param deviceId
|
* @param type
|
* @return
|
*/
|
public DeviceMetricRecord getDeviceMetricRecord(int deviceId,String type){
|
return Optional.ofNullable(
|
deviceMetricRecordMapper.selectOne(Wrappers.<DeviceMetricRecord>lambdaQuery()
|
.eq(DeviceMetricRecord::getDeviceId, deviceId)
|
.eq(DeviceMetricRecord::getType, type)
|
.orderByDesc(DeviceMetricRecord::getCreateTime)
|
.last("limit 1"))).orElse(new DeviceMetricRecord());
|
}
|
|
/**
|
* 格式化日期
|
* @return
|
*/
|
public String formatDate(Date date,String formatter){
|
if(Objects.isNull(date)){
|
return "";
|
}
|
LocalDateTime localDateTime = date.toInstant().atZone(ZoneId.systemDefault()).toLocalDateTime();
|
return localDateTime.format(DateTimeFormatter.ofPattern(formatter));
|
}
|
/**
|
* 格式化日期
|
* @return
|
*/
|
public String formatDate(LocalDate date,String formatter){
|
if(Objects.isNull(date)){
|
return "";
|
}
|
return date.format(DateTimeFormatter.ofPattern(formatter));
|
}
|
|
|
}
|
