|
package org.springblade.mdm.statreport.controller;
|
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import io.swagger.v3.oas.annotations.Operation;
|
import io.swagger.v3.oas.annotations.tags.Tag;
|
import jakarta.servlet.http.HttpServletResponse;
|
import lombok.extern.slf4j.Slf4j;
|
import org.springblade.core.excel.util.ExcelUtil;
|
import org.springblade.core.tenant.annotation.NonDS;
|
import org.springblade.core.tool.api.R;
|
import org.springblade.core.tool.utils.BeanUtil;
|
import org.springblade.core.tool.utils.DateUtil;
|
import org.springblade.mdm.basesetting.machine.entity.Machine;
|
import org.springblade.mdm.basesetting.machine.service.MachineService;
|
import org.springblade.mdm.basesetting.producedivision.entity.MdmDept;
|
import org.springblade.mdm.basesetting.producedivision.service.MdmDeptService;
|
import org.springblade.mdm.machinefile.entity.MachineFile;
|
import org.springblade.mdm.machinefile.service.MachineFileChangeHisService;
|
import org.springblade.mdm.machinefile.service.MachineFileService;
|
import org.springblade.mdm.machinefile.vo.*;
|
import org.springblade.mdm.program.vo.CompareDataVO;
|
import org.springblade.mdm.statreport.vo.MachineFileExceptionExcelVO;
|
import org.springblade.mdm.statreport.vo.MachineFileExceptionQueryVO;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.web.bind.annotation.GetMapping;
|
import org.springframework.web.bind.annotation.PostMapping;
|
import org.springframework.web.bind.annotation.RequestMapping;
|
import org.springframework.web.bind.annotation.RestController;
|
|
import java.io.IOException;
|
import java.util.ArrayList;
|
import java.util.List;
|
|
/**
|
* 工控网异常文件记录
|
*
|
* @author yangys
|
*/
|
@NonDS
|
@RestController
|
@RequestMapping("/statreport/exceptionfile")
|
@Tag(name = "工控网程序节点", description = "工控网程序节点")
|
@Slf4j
|
public class MachineFileExceptionController {
|
@Autowired
|
private MachineFileService machineFileService;
|
@Autowired
|
private MdmDeptService mdmDeptService;
|
@Autowired
|
private MachineService machineService;
|
|
@GetMapping("/page")
|
@Operation(summary = "文件异常记录列表", description = "文件异常记录列表")
|
public R<IPage<MachineFile>> page(MachineFileExceptionQueryVO query) {
|
/*
|
if("workshop".equals(query.getNodeType()) || "seg".equals(query.getNodeType())) {
|
//节点为车间、工段
|
MdmDept dept = mdmDeptService.getById(query.getNodeId());
|
|
String idStr = dept.getAncestors()+","+dept.getId();
|
List<MdmDept> depts = mdmDeptService.lambdaQuery().likeRight(MdmDept::getParentId, query.getNodeId()).list();
|
List<Long> deptIds = new ArrayList<>(depts.stream().map(MdmDept::getId).toList());
|
deptIds.add(dept.getId());
|
//+本车间
|
//Func.toStrList(",",idStr)
|
query.setDeptIds(deptIds);
|
}else if("machine".equals(query.getNodeType())){
|
Machine machine = machineService.getById(query.getNodeId());
|
query.setMachineCode(machine.getCode());
|
}else if("dir".equals(query.getNodeType())){
|
query.setMachineCode(query.getMachineCode());
|
}*/
|
return R.data(machineFileService.exceptionFilePageQuery(query));
|
}
|
|
@Operation(summary = "回传程序处理导出Excel", description = "回传程序处理导出Excel")
|
@GetMapping("/export-excel")
|
public void exportExcel(MachineFileExceptionQueryVO query, HttpServletResponse response) {
|
query.setCurrent(1);
|
query.setSize(Integer.MAX_VALUE);
|
|
IPage<MachineFile> page = machineFileService.exceptionFilePageQuery(query);
|
//List<MachineFileExceptionExcelVO> list = BeanUtil.copy(page.getRecords(), MachineFileExceptionExcelVO.class);
|
List<MachineFileExceptionExcelVO> list = new ArrayList<>();
|
page.getRecords().forEach(machineFile ->{
|
MachineFileExceptionExcelVO excelVO = new MachineFileExceptionExcelVO();
|
BeanUtil.copyProperties(machineFile, excelVO);
|
//excelVO.setExceptionMsg(machineFile.getExceptionMsg());
|
|
list.add(excelVO);
|
});
|
|
ExcelUtil.export(response, "文件异常记录" + DateUtil.time(), "文件异常记录", list, MachineFileExceptionExcelVO.class);
|
}
|
|
|
}
|
