package com.yuanchu.mom.service.impl;
import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.deepoove.poi.XWPFTemplate;
import com.deepoove.poi.config.Configure;
import com.yuanchu.mom.common.GetLook;
import com.yuanchu.mom.dto.DeviceTraceabilityManagementDetailsDto;
import com.yuanchu.mom.dto.DeviceTraceabilityManagementDto;
import com.yuanchu.mom.mapper.DeviceTraceabilityManagementDetailsMapper;
import com.yuanchu.mom.mapper.DeviceTraceabilityManagementMapper;
import com.yuanchu.mom.mapper.UserMapper;
import com.yuanchu.mom.pojo.DeviceTraceabilityManagement;
import com.yuanchu.mom.pojo.DeviceTraceabilityManagementDetails;
import com.yuanchu.mom.pojo.User;
import com.yuanchu.mom.service.DeviceTraceabilityManagementDetailsService;
import com.yuanchu.mom.service.DeviceTraceabilityManagementService;
import com.yuanchu.mom.utils.HackLoopTableRenderPolicy;
import com.yuanchu.mom.utils.UserUtils;
import com.yuanchu.mom.utils.QueryWrappers;
import com.yuanchu.mom.vo.Result;
import org.apache.commons.collections4.CollectionUtils;
import org.springframework.beans.BeanUtils;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletResponse;
import java.io.InputStream;
import java.io.OutputStream;
import java.net.URLEncoder;
import java.time.LocalDateTime;
import java.util.HashMap;
import java.util.List;
import java.util.stream.Collectors;
/**
*
* 设备量值溯源计划表 服务实现类
*
*
* @author 江苏鵷雏网络科技有限公司
* @since 2024-12-20 02:27:44
*/
@Service
public class DeviceTraceabilityManagementServiceImpl extends ServiceImpl implements DeviceTraceabilityManagementService {
@Resource
private DeviceTraceabilityManagementDetailsService deviceTraceabilityManagementDetailsService;
@Resource
private DeviceTraceabilityManagementDetailsMapper deviceTraceabilityManagementDetailsMapper;
@Resource
private GetLook getLook;
@Resource
private UserMapper userMapper;
/**
* 分页查询设备量值溯源计划
*
* @param page
* @return
*/
@Override
public Result> selectDeviceTraceabilityManagementByPage(IPage page, DeviceTraceabilityManagementDto deviceTraceabilityManagementDto) {
IPage iPage = baseMapper.selectDeviceParameterPage(page, QueryWrappers.queryWrappers(deviceTraceabilityManagementDto));
return Result.success(iPage);
}
/**
* 新增设备量值溯源计划
*
* @param deviceTraceabilityManagementDto 设备量值溯源计划
*/
@Override
public Result addTraceabilityManagement(DeviceTraceabilityManagementDto deviceTraceabilityManagementDto) {
Integer userId = getLook.selectPowerByMethodAndUserId(null).get("userId");
User user = userMapper.selectById(userId);
deviceTraceabilityManagementDto.setCompilerId(userId);
deviceTraceabilityManagementDto.setCompiler(user.getName());
deviceTraceabilityManagementDto.setDatePreparation(LocalDateTime.now());
// 查询审核人id
if (deviceTraceabilityManagementDto.getAuditId() != null) {
User auditUser = userMapper.selectById(deviceTraceabilityManagementDto.getAuditId());
deviceTraceabilityManagementDto.setAudit(auditUser.getName());
}
this.saveOrUpdate(deviceTraceabilityManagementDto);
// 详情赋值并保存
List deviceTraceabilityManagementDetails = deviceTraceabilityManagementDto.getDeviceTraceabilityManagementDetails();
if (CollectionUtils.isNotEmpty(deviceTraceabilityManagementDetails)) { // 详情不为空
List collect = deviceTraceabilityManagementDetails.stream().map(detailsDto -> {
detailsDto.setTraceabilityManagementId(deviceTraceabilityManagementDto.getTraceabilityManagementId()); // 量值溯源计划ID
DeviceTraceabilityManagementDetails details = new DeviceTraceabilityManagementDetails();
BeanUtils.copyProperties(detailsDto, details);
return details;
}).collect(Collectors.toList());
deviceTraceabilityManagementDetailsService.saveBatch(collect);
}
return Result.success();
}
/**
* 修改设备量值溯源计划
*
* @param deviceTraceabilityManagementDto 设备量值溯源计划
*/
@Override
public Result updateTraceabilityManagement(DeviceTraceabilityManagementDto deviceTraceabilityManagementDto) {
// 查询审核人id
if (deviceTraceabilityManagementDto.getAuditId() != null) {
User auditUser = userMapper.selectById(deviceTraceabilityManagementDto.getAuditId());
deviceTraceabilityManagementDto.setAudit(auditUser.getName());
}
this.saveOrUpdate(deviceTraceabilityManagementDto);
// 删除原本的详情
deviceTraceabilityManagementDetailsService.remove(Wrappers.lambdaQuery().eq(DeviceTraceabilityManagementDetails::getTraceabilityManagementId, deviceTraceabilityManagementDto.getTraceabilityManagementId()));
// 详情赋值并保存
List deviceTraceabilityManagementDetails = deviceTraceabilityManagementDto.getDeviceTraceabilityManagementDetails();
if (CollectionUtils.isNotEmpty(deviceTraceabilityManagementDetails)) { // 详情不为空
List collect = deviceTraceabilityManagementDetails.stream().map(detailsDto -> {
detailsDto.setTraceabilityManagementId(deviceTraceabilityManagementDto.getTraceabilityManagementId()); // 量值溯源计划ID
DeviceTraceabilityManagementDetails details = new DeviceTraceabilityManagementDetails();
BeanUtils.copyProperties(detailsDto, details);
return details;
}).collect(Collectors.toList());
deviceTraceabilityManagementDetailsService.saveBatch(collect);
}
return Result.success();
}
/**
* 删除设备量值溯源计划
*
* @param deviceTraceabilityManagementDto 设备量值溯源计划
*/
@Override
public Result deleteTraceabilityManagement(DeviceTraceabilityManagementDto deviceTraceabilityManagementDto) {
this.removeById(deviceTraceabilityManagementDto);
deviceTraceabilityManagementDetailsService.remove(Wrappers.lambdaQuery().eq(DeviceTraceabilityManagementDetails::getTraceabilityManagementId, deviceTraceabilityManagementDto.getTraceabilityManagementId()));
return Result.success();
}
/**
* 查询设备量值溯源计划详情
*
* @param traceabilityManagementId 设备量值溯源计划id
*/
@Override
public Result getTraceabilityManagementDetail(Integer traceabilityManagementId) {
// 查询设备量值溯源计划
DeviceTraceabilityManagement deviceTraceabilityManagement = baseMapper.selectById(traceabilityManagementId);
// 查询详情
DeviceTraceabilityManagementDto deviceTraceabilityManagementDto = new DeviceTraceabilityManagementDto();
BeanUtils.copyProperties(deviceTraceabilityManagement, deviceTraceabilityManagementDto);
deviceTraceabilityManagementDto.setDeviceTraceabilityManagementDetails(deviceTraceabilityManagementDetailsMapper.deviceTraceabilityManagementDetailsList(traceabilityManagementId));
return Result.success(deviceTraceabilityManagementDto);
}
/**
* 审核设备量值溯源计划
*
* @param deviceTraceabilityManagementDto 设备量值溯源计划
*/
@Override
public Result reviewTraceabilityManagementStatus(DeviceTraceabilityManagementDto deviceTraceabilityManagementDto) {
Integer userId = getLook.selectPowerByMethodAndUserId(null).get("userId");
User user = userMapper.selectById(userId);
LambdaUpdateWrapper wrapper = Wrappers.lambdaUpdate()
.eq(DeviceTraceabilityManagement::getTraceabilityManagementId, deviceTraceabilityManagementDto.getTraceabilityManagementId())
.set(DeviceTraceabilityManagement::getAuditDate, LocalDateTime.now())
.set(DeviceTraceabilityManagement::getAuditId, user.getId())
.set(DeviceTraceabilityManagement::getAudit, user.getName())
.set(DeviceTraceabilityManagement::getStatus, deviceTraceabilityManagementDto.getStatus()) // 审核状态
.set(DeviceTraceabilityManagement::getAuditRemark, deviceTraceabilityManagementDto.getAuditRemark());// 审核备注
// 为0清除审核人
if (deviceTraceabilityManagementDto.getStatus().equals(0)) {
wrapper.set(DeviceTraceabilityManagement::getAuditId, null)
.set(DeviceTraceabilityManagement::getAudit, null);
}
this.update(wrapper); // 更新
return Result.success();
}
/**
* 导出设备量值溯源计划
*
* @param traceabilityManagementId 设备量值溯源计划id
*/
@Override
public Result exportDeviceTraceabilityManagementDto(Integer traceabilityManagementId, HttpServletResponse response) {
// 查询设备保养计划
DeviceTraceabilityManagementDto deviceTraceabilityManagement = baseMapper.selectDeviceTraceabilityManagementById(traceabilityManagementId);
// 查询设备保养计划详情
List deviceTraceabilityManagementDetailsDtoList = deviceTraceabilityManagementDetailsMapper.deviceTraceabilityManagementDetailsList(traceabilityManagementId);
// 设置序号
deviceTraceabilityManagementDetailsDtoList.forEach(deviceTraceabilityManagementDetails -> {
deviceTraceabilityManagementDetails.setIndex(deviceTraceabilityManagementDetailsDtoList.indexOf(deviceTraceabilityManagementDetails) + 1);
});
// 获取路径
InputStream inputStream = this.getClass().getResourceAsStream("/static/word/traceability-management-details.docx");
Configure configure = Configure.builder()
.bind("deviceTraceabilityManagementDetailsDtoList", new HackLoopTableRenderPolicy())
.build();
XWPFTemplate template = XWPFTemplate.compile(inputStream, configure).render(
new HashMap() {{
put("deviceTraceabilityManagement", deviceTraceabilityManagement);
put("deviceTraceabilityManagementDetailsDtoList", deviceTraceabilityManagementDetailsDtoList);
// 编制人签名地址
put("compilerUrl", UserUtils.getFinalUserSignatureUrl(deviceTraceabilityManagement.getCompilerId()));
// 审核人签名地址
put("auditUrl", UserUtils.getFinalUserSignatureUrl(deviceTraceabilityManagement.getAuditId()));
}});
try {
response.setContentType("application/msword");
String finalFileName = deviceTraceabilityManagement.getFileName() == null ? "" : deviceTraceabilityManagement.getFileName() + "_";
String fileName = URLEncoder.encode(
finalFileName+ "设备量值溯源计划", "UTF-8");
response.setHeader("Content-disposition",
"attachment;filename=" + fileName + ".docx");
OutputStream os = response.getOutputStream();
template.write(os);
os.flush();
os.close();
} catch (Exception e) {
e.printStackTrace();
throw new RuntimeException("导出失败");
}
return Result.success();
}
}