package org.jeecg.modules.eam.controller;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
|
import com.baomidou.mybatisplus.core.toolkit.ObjectUtils;
|
import com.baomidou.mybatisplus.core.toolkit.StringUtils;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import io.swagger.annotations.Api;
|
import io.swagger.annotations.ApiOperation;
|
import lombok.extern.slf4j.Slf4j;
|
import org.jeecg.common.api.vo.Result;
|
import org.jeecg.common.aspect.annotation.AutoLog;
|
import org.jeecg.common.constant.CommonConstant;
|
import org.jeecg.common.system.api.ISysBaseAPI;
|
import org.jeecg.common.system.base.controller.JeecgController;
|
import org.jeecg.common.system.query.QueryGenerator;
|
import org.jeecg.modules.eam.entity.*;
|
import org.jeecg.modules.eam.service.*;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.context.annotation.Lazy;
|
import org.springframework.transaction.annotation.Transactional;
|
import org.springframework.web.bind.annotation.*;
|
import org.springframework.web.servlet.ModelAndView;
|
|
import javax.servlet.http.HttpServletRequest;
|
import javax.servlet.http.HttpServletResponse;
|
import java.math.BigDecimal;
|
import java.util.Arrays;
|
import java.util.Date;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* @Description: mom_eam_maintenance_standard
|
* @Author: jeecg-boot
|
* @Date: 2023-03-10
|
* @Version: V1.0
|
*/
|
@Api(tags = "预防性-保养标准")
|
@RestController
|
@RequestMapping("/eam/maintenanceStandard")
|
@Slf4j
|
public class MaintenanceStandardController extends JeecgController<MaintenanceStandard, IMaintenanceStandardService> {
|
@Autowired
|
private IMaintenanceStandardService maintenanceStandardService;
|
|
@Autowired
|
private IEamEquipmentService equipmentService;
|
|
@Autowired
|
private IMaintenanceStandardDetailService maintenanceStandardDetailService;
|
|
@Autowired
|
@Lazy
|
private IMaintenanceStandardPlanningMaterialService maintenanceStandardPlanningMaterialService;
|
|
@Autowired
|
@Lazy
|
private IMaintenanceStandardSafetyRequirementService maintenanceStandardSafetyRequirementService;
|
|
@Autowired
|
@Lazy
|
private IMaintenanceStandardWorkInstructionService maintenanceStandardWorkInstructionService;
|
|
|
|
// @Autowired
|
// private IUploadRelaService uploadRelaService;
|
//
|
// @Autowired
|
// private IUploadService uploadService;
|
@Autowired
|
private ISysBaseAPI sysBaseApi;
|
|
/**
|
* 分页列表查询
|
*
|
* @param maintenanceStandard
|
* @param pageNo
|
* @param pageSize
|
* @param req
|
* @return
|
*/
|
@ApiOperation(value = "预防性-保养标准-分页列表查询", notes = "预防性-保养标准-分页列表查询")
|
@GetMapping(value = "/list")
|
public Result<IPage<MaintenanceStandard>> queryPageList(MaintenanceStandard maintenanceStandard, @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo, @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize, HttpServletRequest req) {
|
QueryWrapper<MaintenanceStandard> queryWrapper = QueryGenerator.initQueryWrapper(maintenanceStandard, req.getParameterMap());
|
Page<MaintenanceStandard> page = new Page<MaintenanceStandard>(pageNo, pageSize);
|
IPage<MaintenanceStandard> pageList = maintenanceStandardService.page(page, queryWrapper);
|
return Result.OK(pageList);
|
}
|
|
/**
|
* 日常保养
|
* qsw 2023-4-26
|
*/
|
@GetMapping("getMaintenanceStandardList")
|
public Result<?> getMaintenanceStandardList(@RequestParam("pageNo") Integer pageNo, @RequestParam("pageSize") Integer pageSize, @RequestParam Map<String, Object> params) {
|
if(ObjectUtils.isNull(params.get("versionStatus"))|| StringUtils.isBlank((String)params.get("versionStatus"))){
|
params.put("versionStatus","2");
|
}
|
IPage<Map<String, Object>> maintenanceStandardList = maintenanceStandardService.getMaintenanceStandardList(pageNo, pageSize, params);
|
List<Map<String, Object>> records = maintenanceStandardList.getRecords();
|
for (Map<String, Object> record : records) {
|
String maintenanceStandardId = (String) record.get("id");
|
List<Map<String, Object>> maintenanceStandardDetaillist = maintenanceStandardDetailService.getMaintenanceStandardDetailList(maintenanceStandardId);
|
// for (Map<String, Object> detail : maintenanceStandardDetaillist) {
|
// //获取是否有无异常照片数据
|
//// List<SysUploadRela> sysUploadRelas = uploadRelaService.lambdaQuery().eq(SysUploadRela::getBusId, (String)detail.get("id")).eq(SysUploadRela::getDelFlag, 0).list();
|
// List<SysUploadRela> sysUploadRelas = sysBaseApi.listByBusIdAndBusType((String) detail.get("id"), null);
|
// if (sysUploadRelas.size() > 0) {
|
// detail.put("isNoPhotoFlag", true);
|
//// List<SysUploadRela> uploadRelas = uploadRelaService.listByBusIdAndBusType((String)detail.get("id"), "daily_maintenance_standard_photo");
|
// List<SysUploadRela> uploadRelas = sysBaseApi.listByBusIdAndBusType((String) detail.get("id"), "daily_maintenance_standard_photo");
|
// SysUpload upload = new SysUpload();
|
// if (CollectionUtils.isNotEmpty(uploadRelas)) {
|
//// upload = uploadService.getById(uploadRelas.get(0).getUploadId());
|
// upload = sysBaseApi.getUploadById(uploadRelas.get(0).getUploadId());
|
// }
|
// detail.put("upload", upload);
|
// } else {
|
// detail.put("isNoPhotoFlag", false);
|
// SysUpload upload = new SysUpload();
|
// detail.put("upload", upload);
|
// }
|
// }
|
record.put("maintenanceStandardDetaillist", maintenanceStandardDetaillist);
|
}
|
return Result.ok(maintenanceStandardList);
|
}
|
|
|
/**
|
* 日常保养工单创建 组件通过使用部门过滤获取保养标准
|
* qsw 2023-4-26
|
*/
|
@GetMapping("getMaintenanceStandard2List")
|
public Result<?> getMaintenanceStandard2List(@RequestParam("pageNo") Integer pageNo, @RequestParam("pageSize") Integer pageSize, @RequestParam Map<String, Object> params) {
|
IPage<Map<String, Object>> maintenanceStandardList = maintenanceStandardService.getMaintenanceStandard2List(pageNo, pageSize, params);
|
return Result.ok(maintenanceStandardList);
|
}
|
|
|
/**
|
* 添加
|
*
|
* @param maintenanceStandard
|
* @return
|
*/
|
@AutoLog(value = "日常保养标准-添加")
|
@ApiOperation(value = "日常保养标准-添加", notes = "日常保养标准-添加")
|
@PostMapping(value = "/add")
|
@Transactional(rollbackFor = {Exception.class})
|
public Result<String> add(@RequestBody MaintenanceStandard maintenanceStandard) {
|
// maintenanceStandard.setType("daily");
|
maintenanceStandardService.save(maintenanceStandard);
|
List<MaintenanceStandardDetail> maintenanceStandardDetaillist = maintenanceStandard.getMaintenanceStandardDetaillist();
|
for (MaintenanceStandardDetail maintenanceStandardDetail : maintenanceStandardDetaillist) {
|
maintenanceStandardDetail.setMaintenanceStandardId(maintenanceStandard.getId());
|
maintenanceStandardDetail.setPhoto(maintenanceStandardDetail.getPhoto());
|
maintenanceStandardDetailService.saveOrUpdate(maintenanceStandardDetail);
|
}
|
return Result.OK("添加成功！");
|
}
|
|
/**
|
* 编辑
|
*
|
* @param maintenanceStandard
|
* @return
|
*/
|
@AutoLog(value = "保养标准-编辑")
|
@ApiOperation(value = "保养标准-编辑", notes = "保养标准-编辑")
|
@RequestMapping(value = "/edit", method = {RequestMethod.PUT, RequestMethod.POST})
|
@Transactional(rollbackFor = {Exception.class})
|
public Result<String> edit(@RequestBody MaintenanceStandard maintenanceStandard) {
|
maintenanceStandardService.updateById(maintenanceStandard);
|
//1.删除原保养项目
|
List<MaintenanceStandardDetail> maintenanceStandardDetailList = maintenanceStandardDetailService.lambdaQuery().eq(MaintenanceStandardDetail::getMaintenanceStandardId, maintenanceStandard.getId()).eq(MaintenanceStandardDetail::getDelFlag, 0).eq(MaintenanceStandardDetail::getStatus, "1").list();
|
for (MaintenanceStandardDetail dailyInspectionStandardDetail : maintenanceStandardDetailList) {
|
dailyInspectionStandardDetail.setDelFlag(1);
|
maintenanceStandardDetailService.updateById(dailyInspectionStandardDetail);
|
}
|
//2.重新持久保养项目
|
List<MaintenanceStandardDetail> maintenanceStandardDetails = maintenanceStandard.getMaintenanceStandardDetaillist();
|
for (MaintenanceStandardDetail maintenanceStandardDetail : maintenanceStandardDetails) {
|
maintenanceStandardDetail.setMaintenanceStandardId(maintenanceStandard.getId());
|
maintenanceStandardDetailService.saveOrUpdate(maintenanceStandardDetail);
|
}
|
return Result.OK("编辑成功!");
|
}
|
|
/**
|
* 通过id删除
|
*
|
* @param id
|
* @return
|
*/
|
@AutoLog(value = "保养标准-通过id删除")
|
@ApiOperation(value = "保养标准-通过id删除", notes = "保养标准-通过id删除")
|
@DeleteMapping(value = "/delete")
|
public Result<String> delete(@RequestParam(name = "id", required = true) String id) {
|
MaintenanceStandard maintenanceStandard = maintenanceStandardService.getById(id);
|
maintenanceStandard.setDelFlag(1);
|
maintenanceStandardService.updateById(maintenanceStandard);
|
List<MaintenanceStandardDetail> maintenanceStandardDetails = maintenanceStandardDetailService.lambdaQuery().eq(MaintenanceStandardDetail::getMaintenanceStandardId, id).eq(MaintenanceStandardDetail::getDelFlag, 0).eq(MaintenanceStandardDetail::getStatus, "1").list();
|
for (MaintenanceStandardDetail maintenanceStandardDetail : maintenanceStandardDetails) {
|
maintenanceStandardDetail.setDelFlag(1);
|
maintenanceStandardDetailService.updateById(maintenanceStandardDetail);
|
}
|
return Result.OK("删除成功!");
|
}
|
|
/**
|
* 批量删除
|
*
|
* @param ids
|
* @return
|
*/
|
@AutoLog(value = "保养标准-批量删除")
|
@ApiOperation(value = "保养标准-批量删除", notes = "保养标准-批量删除")
|
@DeleteMapping(value = "/deleteBatch")
|
public Result<String> deleteBatch(@RequestParam(name = "ids", required = true) String ids) {
|
List<String> idList = Arrays.asList(ids.split(","));
|
for (String id : idList) {
|
MaintenanceStandard maintenanceStandard = maintenanceStandardService.getById(id);
|
maintenanceStandard.setDelFlag(1);
|
maintenanceStandardService.updateById(maintenanceStandard);
|
}
|
return Result.OK("批量删除成功!");
|
}
|
|
/**
|
* 通过id查询
|
*
|
* @param id
|
* @return
|
*/
|
@ApiOperation(value = "保养标准-通过id查询", notes = "保养标准-通过id查询")
|
@GetMapping(value = "/queryById")
|
public Result<MaintenanceStandard> queryById(@RequestParam(name = "id", required = true) String id) {
|
MaintenanceStandard maintenanceStandard = maintenanceStandardService.getById(id);
|
if (maintenanceStandard == null) {
|
return Result.error("未找到对应数据");
|
}
|
return Result.OK(maintenanceStandard);
|
}
|
|
/**
|
* 导出excel
|
*
|
* @param request
|
* @param maintenanceStandard
|
*/
|
@RequestMapping(value = "/exportXls")
|
public ModelAndView exportXls(HttpServletRequest request, MaintenanceStandard maintenanceStandard) {
|
return super.exportXls(request, maintenanceStandard, MaintenanceStandard.class, "mom_eam_maintenance_standard");
|
}
|
|
/**
|
* 通过excel导入数据
|
*
|
* @param request
|
* @param response
|
* @return
|
*/
|
@RequestMapping(value = "/importExcel", method = RequestMethod.POST)
|
public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) {
|
return super.importExcel(request, response, MaintenanceStandard.class);
|
}
|
|
/**
|
* 版本升级
|
*/
|
@PostMapping(value = "/revise")
|
@Transactional(rollbackFor = { Exception.class })
|
public Result<String> revise(@RequestBody MaintenanceStandard maintenanceStandard) {
|
//计划用料
|
List<MaintenanceStandardPlanningMaterial> maintenanceStandardPlanningMaterialList = maintenanceStandardPlanningMaterialService.lambdaQuery().eq(MaintenanceStandardPlanningMaterial::getMaintenanceStandardId,maintenanceStandard.getId())
|
.eq(MaintenanceStandardPlanningMaterial::getDelFlag, CommonConstant.DEL_FLAG_0).list();
|
//危险防控
|
List<MaintenanceStandardSafetyRequirement> maintenanceStandardSafetyRequirementList = maintenanceStandardSafetyRequirementService.lambdaQuery().eq(MaintenanceStandardSafetyRequirement::getMaintenanceStandardId,maintenanceStandard.getId())
|
.eq(MaintenanceStandardSafetyRequirement::getDelFlag, CommonConstant.DEL_FLAG_0).list();
|
//作业指导书
|
List<MaintenanceStandardWorkInstruction> maintenanceStandardWorkInstructionList = maintenanceStandardWorkInstructionService.lambdaQuery().eq(MaintenanceStandardWorkInstruction::getMaintenanceStandardId,maintenanceStandard.getId())
|
.eq(MaintenanceStandardWorkInstruction::getDelFlag, CommonConstant.DEL_FLAG_0).list();
|
maintenanceStandard.setId("");
|
maintenanceStandard.setCreateTime(new Date());
|
maintenanceStandardService.save(maintenanceStandard);
|
//明细信息
|
List<MaintenanceStandardDetail> maintenanceStandardDetailList = maintenanceStandard.getMaintenanceStandardDetaillist();
|
MaintenanceStandardDetail isd = null;
|
for (MaintenanceStandardDetail maintenanceStandardDetail : maintenanceStandardDetailList) {
|
isd = new MaintenanceStandardDetail();
|
isd.setMaintenanceStandardId(maintenanceStandard.getId());
|
isd.setLocation(maintenanceStandardDetail.getLocation());
|
isd.setPhoto(maintenanceStandardDetail.getPhoto());
|
isd.setMaintenanceProjectId(maintenanceStandardDetail.getMaintenanceProjectId());
|
isd.setMaintenanceCycleId(maintenanceStandardDetail.getMaintenanceCycleId());
|
isd.setMaintenanceMode(maintenanceStandardDetail.getMaintenanceMode());
|
isd.setMaintenanceRequire(maintenanceStandardDetail.getMaintenanceRequire());
|
maintenanceStandardDetailService.save(isd);
|
}
|
if(CollectionUtils.isNotEmpty(maintenanceStandardPlanningMaterialList)){
|
for(MaintenanceStandardPlanningMaterial maintenanceStandardPlanningMaterial : maintenanceStandardPlanningMaterialList){
|
MaintenanceStandardPlanningMaterial mspm = new MaintenanceStandardPlanningMaterial();
|
mspm.setMaintenanceStandardId(maintenanceStandard.getId());
|
mspm.setSparePartId(maintenanceStandardPlanningMaterial.getSparePartId());
|
mspm.setQuantity(maintenanceStandardPlanningMaterial.getQuantity());
|
mspm.setRemark(maintenanceStandardPlanningMaterial.getRemark());
|
maintenanceStandardPlanningMaterialService.save(mspm);
|
}
|
}
|
if(CollectionUtils.isNotEmpty(maintenanceStandardSafetyRequirementList)){
|
for(MaintenanceStandardSafetyRequirement maintenanceStandardSafetyRequirement : maintenanceStandardSafetyRequirementList){
|
MaintenanceStandardSafetyRequirement mssr = new MaintenanceStandardSafetyRequirement();
|
mssr.setMaintenanceStandardId(maintenanceStandard.getId());
|
mssr.setRiskPreventionId(maintenanceStandardSafetyRequirement.getRiskPreventionId());
|
maintenanceStandardSafetyRequirementService.save(mssr);
|
}
|
}
|
if(CollectionUtils.isNotEmpty(maintenanceStandardWorkInstructionList)){
|
for(MaintenanceStandardWorkInstruction maintenanceStandardWorkInstruction : maintenanceStandardWorkInstructionList){
|
MaintenanceStandardWorkInstruction mswi = new MaintenanceStandardWorkInstruction();
|
mswi.setMaintenanceStandardId(maintenanceStandard.getId());
|
mswi.setWorkInstructionId(maintenanceStandardWorkInstruction.getWorkInstructionId());
|
mswi.setNum(maintenanceStandardWorkInstruction.getNum());
|
maintenanceStandardWorkInstructionService.save(mswi);
|
}
|
}
|
return Result.OK("添加成功！");
|
}
|
|
/**
|
* 日常保养标准升版
|
*
|
*/
|
@RequestMapping("/getReviseVersion")
|
public Result<?> getReviseVersion(@RequestBody MaintenanceStandard maintenanceStandard) {
|
List<MaintenanceStandard> maintenanceStandardList = maintenanceStandardService.lambdaQuery().eq(MaintenanceStandard::getNum, maintenanceStandard.getNum())
|
.orderByDesc(MaintenanceStandard::getVersion).list();
|
String version = maintenanceStandardList.get(0).getVersion();
|
BigDecimal versionB = null;
|
if(StringUtils.isBlank(version)){
|
versionB = new BigDecimal(0);
|
}else{
|
versionB = new BigDecimal(version);
|
}
|
BigDecimal versionCode = versionB.add(new BigDecimal(1));
|
return Result.ok(versionCode.toString());
|
}
|
|
/**
|
* 版本生效
|
*/
|
@RequestMapping(value = "/versionTakeEffect", method = {RequestMethod.PUT,RequestMethod.POST})
|
@Transactional(rollbackFor = { Exception.class })
|
public Result<String> versionTakeEffect(@RequestBody MaintenanceStandard maintenanceStandard) {
|
|
List<MaintenanceStandard> maintenanceStandardList = maintenanceStandardService.lambdaQuery()
|
.eq(MaintenanceStandard::getNum, maintenanceStandard.getNum())
|
.eq(MaintenanceStandard::getVersionStatus, "2").list();
|
for (MaintenanceStandard standard : maintenanceStandardList) {
|
standard.setVersionStatus("3");
|
standard.setLoseEfficacyTime(new Date());
|
maintenanceStandardService.updateById(standard);
|
}
|
maintenanceStandard.setTakeEffectTime(new Date());
|
boolean b = maintenanceStandardService.updateById(maintenanceStandard);
|
if (b){
|
return Result.OK("生效成功!");
|
}else{
|
return Result.error("生效失败!");
|
}
|
}
|
|
}
|
