package com.gkhy.safePlatform.equipment.controller;
|
import com.alibaba.fastjson.JSONObject;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.gkhy.safePlatform.commons.utils.BeanCopyUtils;
|
import com.gkhy.safePlatform.equipment.entity.*;
|
import com.gkhy.safePlatform.equipment.model.dto.req.EquipmentInfoImportExcel;
|
import com.gkhy.safePlatform.equipment.model.dto.req.EquipmentInfoSaveOrUpdate;
|
import com.gkhy.safePlatform.equipment.model.dto.resp.EquipmentInfoExcel;
|
import com.gkhy.safePlatform.equipment.utils.DateUtils;
|
import com.gkhy.safePlatform.equipment.utils.QueryHelpPlus;
|
import com.gkhy.safePlatform.equipment.utils.poihelper.ExcelLogs;
|
import com.gkhy.safePlatform.equipment.utils.poihelper.ExcelUtil;
|
import com.google.common.collect.Lists;
|
|
import java.io.IOException;
|
import java.net.URLEncoder;
|
import java.sql.Timestamp;
|
|
|
import com.gkhy.safePlatform.equipment.model.dto.resp.EquipmentInfoDto;
|
import com.gkhy.safePlatform.equipment.service.EquipmentInfoService;
|
import org.apache.commons.collections.CollectionUtils;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.web.bind.annotation.*;
|
import com.gkhy.safePlatform.commons.query.PageQuery;
|
import com.gkhy.safePlatform.commons.utils.PageUtils;
|
import com.gkhy.safePlatform.commons.vo.ResultVO;
|
import com.gkhy.safePlatform.commons.enums.ResultCodes;
|
import com.gkhy.safePlatform.equipment.model.dto.req.EquipmentInfoQueryCriteria;
|
import org.springframework.web.multipart.MultipartFile;
|
|
import java.util.*;
|
import java.util.stream.Collectors;
|
import javax.annotation.Resource;
|
import javax.servlet.http.HttpServletRequest;
|
import javax.servlet.http.HttpServletResponse;
|
import java.io.Serializable;
|
|
/**
|
* 设备设施详细信息(EquipmentInfo)表控制层
|
*
|
* @author xurui
|
* @since 2022-07-19 14:02:50
|
*/
|
@RestController
|
@RequestMapping("equipmentInfo")
|
public class EquipmentInfoController {
|
/**
|
* 服务对象
|
*/
|
@Resource
|
private EquipmentInfoService equipmentInfoService;
|
|
@Autowired
|
public HttpServletRequest request;
|
|
|
/**
|
* 分页查询所有数据
|
*
|
* @param pageQuery 查询实体
|
* @return 所有数据
|
*/
|
@PostMapping(value = "/page/list")
|
public ResultVO selectAll(@RequestBody PageQuery<EquipmentInfoQueryCriteria> pageQuery){
|
return this.equipmentInfoService.queryAll(pageQuery);
|
}
|
|
|
/**
|
* 通过主键查询单条数据
|
*
|
* @param id 主键
|
* @return 单条数据
|
*/
|
@GetMapping(value = "/selectOne/{id}")
|
public ResultVO selectOne(@PathVariable Serializable id) {
|
return new ResultVO<>(ResultCodes.OK,this.equipmentInfoService.selectOne(id));
|
}
|
|
/**
|
* 新增或者修改数据
|
*
|
* @param infoDto 实体对象
|
* @return 修改结果
|
*/
|
@PostMapping(value = "/addOrUpdate")
|
public ResultVO update(@RequestBody EquipmentInfoSaveOrUpdate infoDto) {
|
equipmentInfoService.addOrUpdate(infoDto);
|
return new ResultVO<>(ResultCodes.OK);
|
}
|
|
/**
|
* 删除数据
|
*
|
* @param ids 主键结合
|
* @return 删除结果
|
*/
|
@RequestMapping(value = "/delete",method = RequestMethod.POST)
|
public ResultVO delete(@RequestBody Long[] ids) {
|
|
this.equipmentInfoService.delete(ids);
|
return new ResultVO<>(ResultCodes.OK);
|
}
|
|
/**
|
* 统计
|
*
|
* @return 删除结果
|
*/
|
@GetMapping(value = "/statistics")
|
public ResultVO statistics() {
|
|
return new ResultVO<>(ResultCodes.OK,this.equipmentInfoService.statistics());
|
}
|
|
|
|
|
/**
|
* 下载模板
|
*
|
*/
|
@GetMapping(value = "/exportTemplate")
|
public void exportTemplate() throws IOException {
|
equipmentInfoService.exportTemplate();
|
}
|
|
|
/**
|
* 导入数据
|
*
|
*/
|
@RequestMapping(value = "/importData")
|
public ResultVO importData(MultipartFile file) throws IOException {
|
equipmentInfoService.importData(file);
|
return new ResultVO<>(ResultCodes.OK);
|
}
|
|
|
|
|
/**
|
* 导出一览数据
|
*
|
*/
|
@GetMapping(value = "/exportData")
|
public void exportData(EquipmentInfoQueryCriteria queryCriteria) throws IOException {
|
equipmentInfoService.exportData(queryCriteria);
|
}
|
|
|
|
|
public static void main(String[] args) {
|
EquipmentInfoDto infoDto = new EquipmentInfoDto();
|
List<EquipmentRepairDetail> repairDetails = Lists.newArrayList();
|
EquipmentRepairDetail repairDetail = new EquipmentRepairDetail();
|
repairDetail.setInfoTpe(0);
|
repairDetail.setRepairPersonId(0L);
|
repairDetail.setRepairStartDate(new Timestamp(new java.util.Date().getTime()));
|
repairDetail.setRepairEndDate(new Timestamp(new java.util.Date().getTime()));
|
repairDetail.setRepairPersonDepartmentId(0L);
|
repairDetail.setRepairMemo("");
|
repairDetail.setRepairStatus((byte)0);
|
repairDetail.setExceptionInfo("");
|
repairDetails.add(repairDetail);
|
infoDto.setRepaireDetailList(repairDetails);
|
|
//
|
infoDto.setCheckDetailList(new ArrayList());
|
|
//
|
List<EquipmentTestDetail> testDetails = Lists.newArrayList();
|
EquipmentTestDetail equipmentTestDetail = new EquipmentTestDetail();
|
equipmentTestDetail.setTestPersonId(0L);
|
equipmentTestDetail.setTestDate(new Timestamp(new java.util.Date().getTime()));
|
equipmentTestDetail.setTestPersonDepartmentId(0L);
|
equipmentTestDetail.setTestMemo("");
|
equipmentTestDetail.setTestResult(0);
|
equipmentTestDetail.setTestStatus("");
|
testDetails.add(equipmentTestDetail);
|
infoDto.setTestDetailList(testDetails);
|
|
List<EquipmentTakecareDetail> takecareDetails = Lists.newArrayList();
|
EquipmentTakecareDetail takecareDetail = new EquipmentTakecareDetail();
|
takecareDetail.setEquipmentId(0L);
|
takecareDetail.setTakecareMemo("");
|
takecareDetail.setLeadingPersonId(0L);
|
takecareDetail.setTakecareDate(new Timestamp(new java.util.Date().getTime()));
|
takecareDetail.setLeadingPersonDepartmentId(0L);
|
takecareDetails.add(takecareDetail);
|
infoDto.setTakecareDetailList(takecareDetails);
|
|
List<EquipmentTakecareStardardDetail> takecareStardardDetails = Lists.newArrayList();
|
EquipmentTakecareStardardDetail takecareStardardDetail = new EquipmentTakecareStardardDetail();
|
takecareStardardDetail.setFilePath("123");
|
takecareStardardDetails.add(takecareStardardDetail);
|
infoDto.setTakecareStardardeDetailList(takecareStardardDetails);
|
|
|
List<EquipmentCheckStandardDetail> theckStandardeDetails = Lists.newArrayList();
|
EquipmentCheckStandardDetail theckStandardeDetail = new EquipmentCheckStandardDetail();
|
theckStandardeDetail.setIndexNum("1");
|
theckStandardeDetail.setCheckContent("2");
|
theckStandardeDetail.setCheckTarget("3");
|
theckStandardeDetail.setUnit("4");
|
theckStandardeDetail.setCheckPart("5");
|
theckStandardeDetail.setRate("6");
|
theckStandardeDetails.add(theckStandardeDetail);
|
infoDto.setCheckStandardeDetailList(theckStandardeDetails);
|
|
|
|
|
infoDto.setEquipmentTypeId(0L);
|
infoDto.setInfoType(0);
|
infoDto.setqName("");
|
infoDto.setPositionNum("");
|
infoDto.setqUsage("");
|
infoDto.setModel("");
|
infoDto.setDepartmentId(0L);
|
infoDto.setSetPart("");
|
infoDto.setProduceTime(new Timestamp(new java.util.Date().getTime()));
|
infoDto.setUseEndDay("");
|
infoDto.setLifeCycle((byte)0);
|
infoDto.setUseDate(new Timestamp(new java.util.Date().getTime()));
|
infoDto.setRepairStatus((byte)0);
|
infoDto.setStopStatus((byte)0);
|
infoDto.setPreviousCheckDate(new Timestamp(new java.util.Date().getTime()));
|
infoDto.setPreviousTestDate(new Timestamp(new java.util.Date().getTime()));
|
infoDto.setPreviousTakecareDate(new Timestamp(new java.util.Date().getTime()));
|
infoDto.setNextCheckDate(new Timestamp(new java.util.Date().getTime()));
|
infoDto.setNextTestDate(new Timestamp(new java.util.Date().getTime()));
|
infoDto.setNextTakecareDate(new Timestamp(new java.util.Date().getTime()));
|
infoDto.setLeadingPersonId(0L);
|
infoDto.setLeadingPersonDepartmentId(0L);
|
infoDto.setSupplyName("");
|
infoDto.setUseMemo("");
|
infoDto.setIsNeedCheck(0);
|
infoDto.setCheckCycle("");
|
infoDto.setCheckWarn("");
|
infoDto.setIsNeedTest(0);
|
infoDto.setTestCycle("");
|
infoDto.setTestWarn("");
|
infoDto.setIsNeedTakecare(0);
|
infoDto.setCheckContent("");
|
infoDto.setLeadingDepartmentId(0L);
|
infoDto.setCheckPoint("");
|
infoDto.setAlertNum("");
|
infoDto.setLockNum("");
|
infoDto.setStopReason("");
|
infoDto.setAfterStopStep("");
|
infoDto.setActualStopDate(new Timestamp(new java.util.Date().getTime()));
|
infoDto.setStopSubmitPersonId(0L);
|
infoDto.setStopSubmitDate(new Timestamp(new java.util.Date().getTime()));
|
infoDto.setRecoveryReason("");
|
infoDto.setRecoverySubmitDate(new Timestamp(new java.util.Date().getTime()));
|
infoDto.setActualRecoveryDate(new Timestamp(new java.util.Date().getTime()));
|
infoDto.setDestoryReason("");
|
infoDto.setDestorySubmitDate(new Timestamp(new java.util.Date().getTime()));
|
infoDto.setActualDestoryDate(new Timestamp(new java.util.Date().getTime()));
|
|
System.out.println(JSONObject.toJSONString(infoDto));
|
|
}
|
}
|
