package org.jeecg.modules.eam.controller; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; 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.apache.shiro.SecurityUtils; import org.jeecg.common.api.vo.Result; import org.jeecg.common.aspect.annotation.AutoLog; import org.jeecg.common.system.base.controller.JeecgController; import org.jeecg.common.system.query.QueryGenerator; import org.jeecg.common.system.vo.LoginUser; import org.jeecg.common.util.oConvertUtils; import org.jeecg.modules.eam.entity.EquipmentSealDetail; import org.jeecg.modules.eam.entity.EquipmentTransfer; import org.jeecg.modules.eam.entity.ProjectMaintenanceOrder; import org.jeecg.modules.eam.entity.ProjectMaintenanceOrderDetail; import org.jeecg.modules.eam.model.SupplierVo; import org.jeecg.modules.eam.model.UserVo; import org.jeecg.modules.eam.service.IProjectMaintenanceOrderDetailService; import org.jeecg.modules.eam.service.IProjectMaintenanceOrderService; import org.jeecg.modules.eam.vo.EquipmentDisposalPage; import org.jeecg.modules.eam.vo.EquipmentSealPage; import org.jeecg.modules.eam.vo.ProjectMaintenanceOrderPage; import org.jeecgframework.poi.excel.ExcelImportUtil; import org.jeecgframework.poi.excel.def.NormalExcelConstants; import org.jeecgframework.poi.excel.entity.ExportParams; import org.jeecgframework.poi.excel.entity.ImportParams; import org.jeecgframework.poi.excel.view.JeecgEntityExcelView; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import org.springframework.web.multipart.MultipartFile; import org.springframework.web.multipart.MultipartHttpServletRequest; import org.springframework.web.servlet.ModelAndView; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.IOException; import java.util.ArrayList; import java.util.Arrays; import java.util.List; import java.util.Map; import java.util.stream.Collectors; /** * @Description: 项目性维修 * @Author: jeecg-boot * @Date: 2023-05-06 * @Version: V1.0 */ @Api(tags = "项目性维修") @RestController @RequestMapping("/eam/projectMaintenanceOrder") @Slf4j public class ProjectMaintenanceOrderController extends JeecgController { @Autowired private IProjectMaintenanceOrderService projectMaintenanceOrderService; @Autowired private IProjectMaintenanceOrderDetailService projectMaintenanceOrderDetailService; // @Autowired // private IFlowMyBusinessService flowMyBusinessService; /*---------------------------------主表处理-begin-------------------------------------*/ /** * 分页列表查询 * * @param projectMaintenanceOrder * @param pageNo * @param pageSize * @param req * @return */ //@AutoLog(value = "项目性维修-分页列表查询") @ApiOperation(value = "项目性维修-分页列表查询", notes = "项目性维修-分页列表查询") @GetMapping(value = "/list") public Result> queryPageList(ProjectMaintenanceOrder projectMaintenanceOrder, @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo, @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize, HttpServletRequest req) { QueryWrapper queryWrapper = QueryGenerator.initQueryWrapper(projectMaintenanceOrder, req.getParameterMap()); Page page = new Page(pageNo, pageSize); IPage pageList = projectMaintenanceOrderService.page(page, queryWrapper); List equipmentSealList = pageList.getRecords(); for (ProjectMaintenanceOrder entity : equipmentSealList) { String id = entity.getId(); // FlowMyBusiness flowMyBusiness = flowMyBusinessService.getByDataId(id); } return Result.OK(pageList); } /** * 添加 * * @param projectMaintenanceOrderPage * @return */ @AutoLog(value = "项目性维修-添加") @ApiOperation(value = "项目性维修-添加", notes = "项目性维修-添加") @PostMapping(value = "/add") public Result add(@RequestBody ProjectMaintenanceOrderPage projectMaintenanceOrderPage) { ProjectMaintenanceOrder projectMaintenanceOrder = new ProjectMaintenanceOrder(); BeanUtils.copyProperties(projectMaintenanceOrderPage, projectMaintenanceOrder); projectMaintenanceOrderService.saveMain(projectMaintenanceOrder, projectMaintenanceOrderPage.getProjectMaintenanceOrderDetailList()); return Result.OK("添加成功！"); } /** * 委外供应商列表 * qsw 2023-4-26 */ @GetMapping("getSupplier") public Result getSupplier() { List supplierVoList = projectMaintenanceOrderService.getSupplier(); return Result.ok(supplierVoList); } /** * 责任班组列表 * qsw 2023-4-26 */ @GetMapping("getTeam") public Result getTeam() { List teamVoList = projectMaintenanceOrderService.getTeam(); return Result.ok(teamVoList); } /** * 责任班组列表 * qsw 2023-4-26 */ @GetMapping("getUser") public Result getUser() { List userVoList = projectMaintenanceOrderService.getUser(); return Result.ok(userVoList); } /** * 编辑 * * @param projectMaintenanceOrderPage * @return */ @AutoLog(value = "项目性维修-编辑") @ApiOperation(value = "项目性维修-编辑", notes = "项目性维修-编辑") //@RequiresPermissions("org.jeecg.modules:mom_eam_equipment_change:edit") @RequestMapping(value = "/edit", method = {RequestMethod.PUT, RequestMethod.POST}) public Result edit(@RequestBody ProjectMaintenanceOrderPage projectMaintenanceOrderPage) { ProjectMaintenanceOrder projectMaintenanceOrder = new ProjectMaintenanceOrder(); BeanUtils.copyProperties(projectMaintenanceOrderPage, projectMaintenanceOrder); ProjectMaintenanceOrder projectMaintenanceOrderEntity = projectMaintenanceOrderService.getById(projectMaintenanceOrder.getId()); if (projectMaintenanceOrderEntity == null) { return Result.error("未找到对应数据"); } projectMaintenanceOrderService.updateMain(projectMaintenanceOrder, projectMaintenanceOrderPage.getProjectMaintenanceOrderDetailList()); return Result.OK("编辑成功!"); } /** * 通过id删除 * * @param id * @return */ @AutoLog(value = "项目性维修-通过id删除") @ApiOperation(value = "项目性维修-通过id删除", notes = "项目性维修-通过id删除") //@RequiresPermissions("org.jeecg.modules:mom_eam_equipment_change:delete") @DeleteMapping(value = "/delete") public Result delete(@RequestParam(name = "id", required = true) String id) { projectMaintenanceOrderService.delMain(id); return Result.OK("删除成功!"); } /** * 批量删除 * * @param ids * @return */ @AutoLog(value = "项目性维修-批量删除") @ApiOperation(value = "项目性维修-批量删除", notes = "项目性维修-批量删除") //@RequiresPermissions("org.jeecg.modules:mom_eam_equipment_change:deleteBatch") @DeleteMapping(value = "/deleteBatch") public Result deleteBatch(@RequestParam(name = "ids", required = true) String ids) { this.projectMaintenanceOrderService.delBatchMain(Arrays.asList(ids.split(","))); return Result.OK("批量删除成功！"); } /** * 提交/撤回 * * @param projectMaintenanceOrder * @return */ @RequestMapping(value = "/commit", method = {RequestMethod.PUT, RequestMethod.POST}) public Result commit(@RequestBody ProjectMaintenanceOrder projectMaintenanceOrder) { projectMaintenanceOrderService.updateById(projectMaintenanceOrder); return Result.OK("提交成功!"); } /** * 通过id查询 * * @param id * @return */ //@AutoLog(value = "项目性维修-通过id查询") @ApiOperation(value = "项目性维修-通过id查询", notes = "项目性维修-通过id查询") @GetMapping(value = "/queryById") public Result queryById(@RequestParam(name = "id", required = true) String id) { ProjectMaintenanceOrder projectMaintenanceOrder = projectMaintenanceOrderService.getById(id); if (projectMaintenanceOrder == null) { return Result.error("未找到对应数据"); } return Result.OK(projectMaintenanceOrder); } /** * 通过id查询 * * @param id * @return */ @ApiOperation(value = "项目性维修明细主表ID查询", notes = "项目性维修明细-通主表ID查询") @GetMapping(value = "/queryProjectMaintenanceOrderDetailByMainId") public Result queryProjectMaintenanceOrderDetailByMainId(@RequestParam(name = "id", required = true) String id) { // List projectMaintenanceOrderDetailList = projectMaintenanceOrderDetailService.selectByMainId(id); //字典转换 LambdaQueryWrapper queryWrapper = new LambdaQueryWrapper<>(); queryWrapper.eq(ProjectMaintenanceOrderDetail::getProjectMaintenanceOrderId, id); queryWrapper.orderByDesc(ProjectMaintenanceOrderDetail::getId); //分页 默认一次大修或项修不会超过100台设备 Page page = new Page(1, 100); Page page1 = projectMaintenanceOrderDetailService.page(page, queryWrapper); return Result.OK(page1); } /** * 导出excel * * @param request * @param projectMaintenanceOrder */ @RequestMapping(value = "/exportXls") public ModelAndView exportXls(HttpServletRequest request, ProjectMaintenanceOrder projectMaintenanceOrder) { // Step.1 组装查询条件查询数据 QueryWrapper queryWrapper = QueryGenerator.initQueryWrapper(projectMaintenanceOrder, request.getParameterMap()); LoginUser sysUser = (LoginUser) SecurityUtils.getSubject().getPrincipal(); //配置选中数据查询条件 String selections = request.getParameter("selections"); if (oConvertUtils.isNotEmpty(selections)) { List selectionList = Arrays.asList(selections.split(",")); queryWrapper.in("id", selectionList); } //Step.2 获取导出数据 List projectMaintenanceOrderList = projectMaintenanceOrderService.list(queryWrapper); // Step.3 组装pageList List pageList = new ArrayList(); for (ProjectMaintenanceOrder main : projectMaintenanceOrderList) { ProjectMaintenanceOrderPage vo = new ProjectMaintenanceOrderPage(); BeanUtils.copyProperties(main, vo); List projectMaintenanceOrderDetailList = projectMaintenanceOrderDetailService.selectByMainId(main.getId()); vo.setProjectMaintenanceOrderDetailList(projectMaintenanceOrderDetailList); pageList.add(vo); } // Step.4 AutoPoi 导出Excel ModelAndView mv = new ModelAndView(new JeecgEntityExcelView()); mv.addObject(NormalExcelConstants.FILE_NAME, "项目性维修列表"); mv.addObject(NormalExcelConstants.CLASS, EquipmentSealPage.class); mv.addObject(NormalExcelConstants.PARAMS, new ExportParams("项目性维修数据", "导出人:" + sysUser.getRealname(), "项目性维修")); mv.addObject(NormalExcelConstants.DATA_LIST, pageList); return mv; } /** * 通过excel导入数据 * * @param request * @param response * @return */ @RequestMapping(value = "/importExcel", method = RequestMethod.POST) public Result importExcel(HttpServletRequest request, HttpServletResponse response) { MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request; Map fileMap = multipartRequest.getFileMap(); for (Map.Entry entity : fileMap.entrySet()) { // 获取上传文件对象 MultipartFile file = entity.getValue(); ImportParams params = new ImportParams(); params.setTitleRows(2); params.setHeadRows(1); params.setNeedSave(true); try { List list = ExcelImportUtil.importExcel(file.getInputStream(), ProjectMaintenanceOrderPage.class, params); for (ProjectMaintenanceOrderPage page : list) { ProjectMaintenanceOrder po = new ProjectMaintenanceOrder(); BeanUtils.copyProperties(page, po); projectMaintenanceOrderService.saveMain(po, page.getProjectMaintenanceOrderDetailList()); } return Result.OK("文件导入成功！数据行数:" + list.size()); } catch (Exception e) { log.error(e.getMessage(), e); return Result.error("文件导入失败:" + e.getMessage()); } finally { try { file.getInputStream().close(); } catch (IOException e) { e.printStackTrace(); } } } return Result.OK("文件导入失败！"); } /*---------------------------------主表处理-end-------------------------------------*/ /*--------------------------------子表处理-项目性维修明细-begin----------------------------------------------*/ /** * 通过主表ID查询 * * @return */ //@AutoLog(value = "项目性维修明细-通过主表ID查询") @ApiOperation(value = "项目性维修明细-通过主表ID查询", notes = "项目性维修明细-通过主表ID查询") @GetMapping(value = "/listProjectMaintenanceOrderDetailByMainId") public Result> listProjectMaintenanceOrderDetailByMainId(ProjectMaintenanceOrderDetail projectMaintenanceOrderDetail, @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo, @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize, HttpServletRequest req) { QueryWrapper queryWrapper = QueryGenerator.initQueryWrapper(projectMaintenanceOrderDetail, req.getParameterMap()); Page page = new Page(pageNo, pageSize); IPage pageList = projectMaintenanceOrderDetailService.page(page, queryWrapper); return Result.OK(pageList); } /** * 添加 * * @param projectMaintenanceOrderDetail * @return */ @AutoLog(value = "项目性维修明细-添加") @ApiOperation(value = "项目性维修明细-添加", notes = "项目性维修明细-添加") @PostMapping(value = "/addProjectMaintenanceOrderDetail") public Result addProjectMaintenanceOrderDetail(@RequestBody ProjectMaintenanceOrderDetail projectMaintenanceOrderDetail) { projectMaintenanceOrderDetailService.save(projectMaintenanceOrderDetail); return Result.OK("添加成功！"); } /** * 编辑 * * @param projectMaintenanceOrderDetail * @return */ @AutoLog(value = "项目性维修明细-编辑") @ApiOperation(value = "项目性维修明细-编辑", notes = "项目性维修明细-编辑") @RequestMapping(value = "/editProjectMaintenanceOrderDetail", method = {RequestMethod.PUT, RequestMethod.POST}) public Result editProjectMaintenanceOrderDetail(@RequestBody ProjectMaintenanceOrderDetail projectMaintenanceOrderDetail) { projectMaintenanceOrderDetailService.updateById(projectMaintenanceOrderDetail); return Result.OK("编辑成功!"); } /** * 通过id删除 * * @param id * @return */ @AutoLog(value = "项目性维修明细-通过id删除") @ApiOperation(value = "项目性维修明细-通过id删除", notes = "项目性维修明细-通过id删除") @DeleteMapping(value = "/deleteProjectMaintenanceOrderDetail") public Result deleteProjectMaintenanceOrderDetail(@RequestParam(name = "id", required = true) String id) { projectMaintenanceOrderDetailService.removeById(id); return Result.OK("删除成功!"); } /** * 批量删除 * * @param ids * @return */ @AutoLog(value = "项目性维修明细-批量删除") @ApiOperation(value = "项目性维修明细-批量删除", notes = "项目性维修明细-批量删除") @DeleteMapping(value = "/deleteBatchProjectMaintenanceOrderDetail") public Result deleteBatchProjectMaintenanceOrderDetail(@RequestParam(name = "ids", required = true) String ids) { this.projectMaintenanceOrderDetailService.removeByIds(Arrays.asList(ids.split(","))); return Result.OK("批量删除成功!"); } /** * 导出 * * @return */ @RequestMapping(value = "/exportProjectMaintenanceOrderDetail") public ModelAndView exportProjectMaintenanceOrderDetail(HttpServletRequest request, ProjectMaintenanceOrderDetail projectMaintenanceOrderDetail) { // Step.1 组装查询条件 QueryWrapper queryWrapper = QueryGenerator.initQueryWrapper(projectMaintenanceOrderDetail, request.getParameterMap()); LoginUser sysUser = (LoginUser) SecurityUtils.getSubject().getPrincipal(); // Step.2 获取导出数据 List pageList = projectMaintenanceOrderDetailService.list(queryWrapper); List exportList = null; // 过滤选中数据 String selections = request.getParameter("selections"); if (oConvertUtils.isNotEmpty(selections)) { List selectionList = Arrays.asList(selections.split(",")); exportList = pageList.stream().filter(item -> selectionList.contains(item.getId())).collect(Collectors.toList()); } else { exportList = pageList; } // Step.3 AutoPoi 导出Excel ModelAndView mv = new ModelAndView(new JeecgEntityExcelView()); //此处设置的filename无效,前端会重更新设置一下 mv.addObject(NormalExcelConstants.FILE_NAME, "项目性维修明细"); mv.addObject(NormalExcelConstants.CLASS, EquipmentSealDetail.class); mv.addObject(NormalExcelConstants.PARAMS, new ExportParams("项目性维修明细报表", "导出人:" + sysUser.getRealname(), "项目性维修明细")); mv.addObject(NormalExcelConstants.DATA_LIST, exportList); return mv; } /** * 导入 * * @return */ @RequestMapping(value = "/importProjectMaintenanceOrderDetail/{mainId}") public Result importProjectMaintenanceOrderDetail(HttpServletRequest request, HttpServletResponse response, @PathVariable("mainId") String mainId) { MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request; Map fileMap = multipartRequest.getFileMap(); for (Map.Entry entity : fileMap.entrySet()) { // 获取上传文件对象 MultipartFile file = entity.getValue(); ImportParams params = new ImportParams(); params.setTitleRows(2); params.setHeadRows(1); params.setNeedSave(true); try { List list = ExcelImportUtil.importExcel(file.getInputStream(), ProjectMaintenanceOrderDetail.class, params); for (ProjectMaintenanceOrderDetail temp : list) { temp.setProjectMaintenanceOrderId(mainId); } long start = System.currentTimeMillis(); projectMaintenanceOrderDetailService.saveBatch(list); log.info("消耗时间" + (System.currentTimeMillis() - start) + "毫秒"); return Result.OK("文件导入成功！数据行数：" + list.size()); } catch (Exception e) { log.error(e.getMessage(), e); return Result.error("文件导入失败:" + e.getMessage()); } finally { try { file.getInputStream().close(); } catch (IOException e) { e.printStackTrace(); } } } return Result.error("文件导入失败！"); } /*--------------------------------子表处理-项目性维修明细-end----------------------------------------------*/ /** * 提交 * * @param projectMaintenanceOrderPage * @return */ @AutoLog(value = "项目性维修-提交") @ApiOperation(value = "项目性维修-提交", notes = "项目性维修-提交") @PostMapping(value = "/submit") public Result submit(@RequestBody ProjectMaintenanceOrderPage projectMaintenanceOrderPage) { String id = projectMaintenanceOrderPage.getId(); this.projectMaintenanceOrderService.submit(id); return Result.OK("提交成功！"); } /** * 批量提交 * * @param projectMaintenanceOrderPage * @return */ @AutoLog(value = "项目性维修-批量提交") @ApiOperation(value = "项目性维修-批量提交", notes = "项目性维修-批量提交") @PostMapping(value = "/submitBatch") public Result submitBatch(@RequestBody ProjectMaintenanceOrderPage projectMaintenanceOrderPage) { String ids = projectMaintenanceOrderPage.getIds(); this.projectMaintenanceOrderService.submitBatch(Arrays.asList(ids.split(","))); return Result.OK("批量提交成功！"); } /** * 撤回 * * @param projectMaintenanceOrderPage * @return */ @AutoLog(value = "项目性维修-撤回") @ApiOperation(value = "项目性维修-撤回", notes = "项目性维修-撤回") @PostMapping(value = "/revocation") public Result revocation(@RequestBody ProjectMaintenanceOrderPage projectMaintenanceOrderPage) { String id = projectMaintenanceOrderPage.getId(); projectMaintenanceOrderService.revocation(id); return Result.OK("撤回成功！"); } /** * 批量撤回 * * @param projectMaintenanceOrderPage * @return */ @AutoLog(value = "项目性维修-批量撤回") @ApiOperation(value = "项目性维修-批量撤回", notes = "项目性维修-批量撤回") @PostMapping(value = "/revocationBatch") public Result revocationBatch(@RequestBody ProjectMaintenanceOrderPage projectMaintenanceOrderPage) { String ids = projectMaintenanceOrderPage.getIds(); this.projectMaintenanceOrderService.revocationBatch(Arrays.asList(ids.split(","))); return Result.OK("批量撤回成功！"); } //查询审批通过的项目性维修，未生成工单的明细数据，用于维修工单选择 @GetMapping(value = "/queryProjectMaintenanceOrderDetail") public Result> queryProjectMaintenanceOrderDetail() { List projectMaintenanceOrderDetailList = projectMaintenanceOrderDetailService.queryProjectMaintenanceOrderDetail(); return Result.OK(projectMaintenanceOrderDetailList); } }