package com.ycl.platform.service.impl;
|
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper;
|
import com.baomidou.mybatisplus.extension.conditions.update.LambdaUpdateChainWrapper;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.ycl.platform.domain.dto.ReportImportDTO;
|
import com.ycl.platform.domain.entity.*;
|
import com.ycl.platform.domain.form.ReportAuditingForm;
|
import com.ycl.platform.domain.form.ReportForm;
|
import com.ycl.platform.domain.query.ReportQuery;
|
import com.ycl.platform.domain.vo.ReportVO;
|
import com.ycl.platform.domain.vo.YwPointVO;
|
import com.ycl.platform.mapper.ReportMapper;
|
import com.ycl.platform.mapper.YwPeopleMapper;
|
import com.ycl.platform.mapper.YwPointMapper;
|
import com.ycl.platform.mapper.YwUnitMapper;
|
import com.ycl.platform.service.ReportAuditingRecordService;
|
import com.ycl.platform.service.ReportErrorTypeService;
|
import com.ycl.platform.service.ReportService;
|
import com.ycl.system.Result;
|
import com.ycl.system.entity.SysDictData;
|
import com.ycl.system.page.PageUtil;
|
import com.ycl.system.service.ISysDictTypeService;
|
import com.ycl.utils.DateUtils;
|
import com.ycl.utils.SecurityUtils;
|
import com.ycl.utils.StringUtils;
|
import com.ycl.utils.html.EscapeUtil;
|
import com.ycl.utils.poi.ExcelUtil;
|
import com.ycl.utils.uuid.IdUtils;
|
import jakarta.servlet.http.HttpServletResponse;
|
import lombok.RequiredArgsConstructor;
|
import lombok.SneakyThrows;
|
import org.springframework.beans.BeanUtils;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
import org.springframework.util.Assert;
|
|
import java.util.Date;
|
import java.util.List;
|
import java.util.Map;
|
import java.util.Objects;
|
import java.util.stream.Collectors;
|
|
/**
|
* 报备 服务实现类
|
*
|
* @author xp
|
* @since 2024-03-19
|
*/
|
@Service
|
@RequiredArgsConstructor
|
public class ReportServiceImpl extends ServiceImpl<ReportMapper, Report> implements ReportService {
|
|
private final YwUnitMapper unitMapper;
|
private final YwPointMapper ywpointMapper;
|
private final YwPeopleMapper peopleMapper;
|
private final ReportErrorTypeService reportErrorTypeService;
|
private final ISysDictTypeService dictTypeService;
|
private final ReportAuditingRecordService reportAuditingRecordService;
|
|
/**
|
* 添加
|
* @param form
|
* @return
|
*/
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public Result add(ReportForm form) {
|
if (Objects.isNull(form.getPointId())) {
|
throw new RuntimeException("点位不能为空");
|
}
|
Long userId = SecurityUtils.getUserId();
|
YwPeople people = new LambdaQueryChainWrapper<>(peopleMapper).eq(YwPeople::getUserId, userId).one();
|
form.setPeopleId(people.getId());
|
form.setUnitId(people.getBelongUnit());
|
if ("事前报备".equals(form.getReportType())) {
|
// 如果是事前报备需要检验是否已经生成下发工单
|
YwPointVO point = ywpointMapper.countNotFinishedWorkOrderByGb(form.getPointId());
|
if (Objects.nonNull(point)) {
|
throw new RuntimeException(String.format("点位【%s】已经存在下发工单，无法事前报备", point.getPointName()));
|
}
|
}
|
YwPoint point = new LambdaQueryChainWrapper<>(ywpointMapper)
|
.eq(YwPoint::getSerialNumber, form.getPointId())
|
.one();
|
if (Objects.isNull(point)) {
|
throw new RuntimeException("点位不存在");
|
}
|
Report entity = ReportForm.getEntityByForm(form, null);
|
entity.setSerialNumber(point.getSerialNumber());
|
entity.setStatus(0);
|
entity.setIdentify(IdUtils.randomNO());
|
Date now = new Date();
|
entity.setCreateTime(now);
|
entity.setUpdateTime(now);
|
baseMapper.insert(entity);
|
List<ReportErrorType> errorTypeList = form.getErrorTypeList().stream().map(item -> {
|
ReportErrorType reportErrorType = new ReportErrorType();
|
reportErrorType.setErrorType(item);
|
reportErrorType.setDeleted(0);
|
reportErrorType.setCreateTime(now);
|
reportErrorType.setReportId(entity.getId());
|
return reportErrorType;
|
}).collect(Collectors.toList());
|
reportErrorTypeService.saveBatch(errorTypeList);
|
return Result.ok("报备成功");
|
}
|
|
@Override
|
@SneakyThrows
|
public void importTemplate(HttpServletResponse response) {
|
ExcelUtil<ReportImportDTO> excelUtil = new ExcelUtil<>(ReportImportDTO.class);
|
excelUtil.exportExcel(response, null, "报备导入模板");
|
}
|
|
@Override
|
@SneakyThrows
|
@Transactional
|
public Result importData(ReportForm form) {
|
Long userId = SecurityUtils.getUserId();
|
YwPeople people = new LambdaQueryChainWrapper<>(peopleMapper).eq(YwPeople::getUserId, userId).one();
|
form.setPeopleId(people.getId());
|
form.setUnitId(people.getBelongUnit());
|
// 读取excel数据
|
ExcelUtil<ReportImportDTO> excelUtil = new ExcelUtil<>(ReportImportDTO.class);
|
List<ReportImportDTO> list = excelUtil.importExcel(form.getImportPointId().getInputStream());
|
// 批量插入
|
String pid = IdUtils.randomNO();
|
Integer success = 0;
|
for (ReportImportDTO item : list) {
|
if ("事前报备".equals(form.getReportType())) {
|
// 如果是事前报备需要检验是否已经生成下发工单
|
YwPointVO point = ywpointMapper.countNotFinishedWorkOrderByGb(item.getSerialNumber());
|
if (Objects.nonNull(point)) {
|
throw new RuntimeException(String.format("点位【%s】已经存在下发工单，无法事前报备", point.getPointName()));
|
}
|
}
|
YwPoint point = new LambdaQueryChainWrapper<>(ywpointMapper)
|
.eq(YwPoint::getSerialNumber, form.getPointId())
|
.one();
|
if (Objects.isNull(point)) {
|
continue;
|
}
|
Report entity = ReportForm.getEntityByForm(form, null);
|
entity.setImportBatchNumber(pid);
|
entity.setSerialNumber(item.getSerialNumber());
|
entity.setStatus(0);
|
entity.setIdentify(IdUtils.randomNO());
|
Date now = DateUtils.getNowDate();
|
entity.setCreateTime(now);
|
entity.setUpdateTime(now);
|
baseMapper.insert(entity);
|
List<ReportErrorType> errorTypeList = form.getErrorTypeList().stream().map(err -> {
|
ReportErrorType reportErrorType = new ReportErrorType();
|
reportErrorType.setErrorType(err);
|
reportErrorType.setDeleted(0);
|
reportErrorType.setCreateTime(now);
|
reportErrorType.setReportId(entity.getId());
|
return reportErrorType;
|
}).collect(Collectors.toList());
|
reportErrorTypeService.saveBatch(errorTypeList);
|
success++;
|
}
|
return Result.ok("报备点位数：" + list.size() + "，导入成功数：" + success);
|
}
|
|
/**
|
* 修改
|
* @param form
|
* @return
|
*/
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public Result update(ReportForm form) {
|
|
Report entity = baseMapper.selectById(form.getId());
|
// 为空抛IllegalArgumentException，做全局异常处理
|
Assert.notNull(entity, "记录不存在");
|
Date now = new Date();
|
entity.setUpdateTime(now);
|
if ("事前报备".equals(form.getReportType())) {
|
// 如果是事前报备需要检验是否已经生成下发工单
|
YwPointVO point = ywpointMapper.countNotFinishedWorkOrderByGb(form.getPointId());
|
if (Objects.nonNull(point)) {
|
throw new RuntimeException(String.format("点位【%s】已经存在下发工单，无法事前报备", point.getPointName()));
|
}
|
}
|
YwPoint point = new LambdaQueryChainWrapper<>(ywpointMapper)
|
.eq(YwPoint::getSerialNumber, form.getPointId())
|
.one();
|
if (Objects.isNull(point)) {
|
throw new RuntimeException("点位不存在");
|
}
|
BeanUtils.copyProperties(form, entity);
|
entity.setSerialNumber(form.getPointId());
|
// 重置为待审核
|
entity.setStatus(0);
|
baseMapper.updateById(entity);
|
new LambdaUpdateChainWrapper<>(reportErrorTypeService.getBaseMapper())
|
.eq(ReportErrorType::getReportId, form.getId())
|
.remove();
|
List<ReportErrorType> errorTypeList = form.getErrorTypeList().stream().map(err -> {
|
ReportErrorType reportErrorType = new ReportErrorType();
|
reportErrorType.setErrorType(err);
|
reportErrorType.setDeleted(0);
|
reportErrorType.setCreateTime(now);
|
reportErrorType.setReportId(entity.getId());
|
return reportErrorType;
|
}).collect(Collectors.toList());
|
reportErrorTypeService.saveBatch(errorTypeList);
|
return Result.ok("修改成功");
|
}
|
|
/**
|
* 批量删除
|
* @param ids
|
* @return
|
*/
|
@Override
|
public Result remove(List<String> ids) {
|
if(baseMapper.deleteBatchIds(ids) > 0) {
|
return Result.ok("删除成功");
|
}
|
return Result.error("删除失败");
|
}
|
|
/**
|
* id删除
|
* @param id
|
* @return
|
*/
|
@Override
|
public Result removeById(String id) {
|
if(baseMapper.deleteById(id) > 0) {
|
return Result.ok("删除成功");
|
}
|
return Result.error("删除失败");
|
}
|
|
/**
|
* 分页查询
|
* @param query
|
* @return
|
*/
|
@Override
|
public Result page(ReportQuery query) {
|
IPage<ReportVO> page = PageUtil.getPage(query, ReportVO.class);
|
baseMapper.page(page, query);
|
List<SysDictData> errorTypeList = dictTypeService.selectDictDataByType("report_error_type");
|
Map<String, String> dictMap = errorTypeList.stream().collect(Collectors.toMap(SysDictData::getDictValue, SysDictData::getDictLabel));
|
page.getRecords().stream().forEach(item -> {
|
if (StringUtils.hasText(item.getErrorType())) {
|
item.setErrorTypeList(List.of(item.getErrorType().split(",")));
|
StringBuilder sb = new StringBuilder();
|
item.getErrorTypeList().stream().forEach(err -> {
|
String s = dictMap.get(err);
|
if (org.springframework.util.StringUtils.hasText(s)) {
|
sb.append(s).append("、");
|
}
|
});
|
item.setErrorType(sb.substring(0, sb.length() - 1));
|
}
|
});
|
return Result.ok().data(page).total(page.getTotal());
|
}
|
|
/**
|
* 根据id查找
|
* @param id
|
* @return
|
*/
|
@Override
|
public Result detail(String id) {
|
Report entity = baseMapper.selectById(id);
|
Assert.notNull(entity, "记录不存在");
|
ReportVO vo = ReportVO.getVoByEntity(entity, null);
|
vo.setPointId(vo.getSerialNumber());
|
List<ReportErrorType> errList = new LambdaQueryChainWrapper<>(reportErrorTypeService.getBaseMapper())
|
.select(ReportErrorType::getErrorType)
|
.eq(ReportErrorType::getReportId, id)
|
.list();
|
List<String> list = errList.stream().map(ReportErrorType::getErrorType).collect(Collectors.toList());
|
vo.setErrorTypeList(list);
|
return Result.ok().data(vo);
|
}
|
|
/**
|
* 列表
|
* @return
|
*/
|
@Override
|
public Result all() {
|
List<Report> entities = baseMapper.selectList(null);
|
List<ReportVO> vos = entities.stream()
|
.map(
|
entity -> ReportVO.getVoByEntity(entity, null)
|
)
|
.collect(Collectors.toList());
|
return Result.ok().data(vos);
|
}
|
|
@Override
|
public List<ReportVO> export(ReportQuery query) {
|
IPage<ReportVO> page = PageUtil.getPage(query, ReportVO.class);
|
page.setSize(-1);
|
baseMapper.page(page, query);
|
page.getRecords().forEach(item -> {
|
item.setReportContent(EscapeUtil.clean(item.getReportContent()));
|
});
|
return page.getRecords();
|
}
|
|
|
@Override
|
public Result auditingRecord(Integer id) {
|
List<ReportVO> reportList = baseMapper.examineRecord(id);
|
return Result.ok().data(reportList);
|
}
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public Result auditing(ReportAuditingForm form) {
|
Report report = baseMapper.selectById(form.getId());
|
if (Objects.isNull(report)) {
|
throw new RuntimeException("审核的报备不存在");
|
}
|
if (form.getAuditingResult()) {
|
report.setStatus(1);
|
} else {
|
report.setStatus(2);
|
}
|
Date now = new Date();
|
report.setUpdateTime(now);
|
baseMapper.updateById(report);
|
|
// 添加一条审核记录
|
ReportAuditingRecord reportAuditingRecord = new ReportAuditingRecord();
|
reportAuditingRecord.setReportId(form.getId());
|
reportAuditingRecord.setDeleted(0);
|
reportAuditingRecord.setCreateTime(now);
|
reportAuditingRecord.setResultRemark(form.getAuditOpinion());
|
reportAuditingRecord.setResult(form.getAuditingResult());
|
reportAuditingRecordService.save(reportAuditingRecord);
|
return Result.ok("操作成功");
|
}
|
}
|
