| | |
| | | @GetMapping("/get") |
| | | @Operation(summary = "获得工艺路线") |
| | | @Parameter(name = "id", description = "编号", required = true, example = "1024") |
| | | @PreAuthorize("@ss.hasPermission('mes:pro-route:query')") |
| | | public CommonResult<MesProRouteRespVO> getRoute(@RequestParam("id") Long id) { |
| | | MesProRouteDO route = routeService.getRoute(id); |
| | | return success(BeanUtils.toBean(route, MesProRouteRespVO.class)); |
| | |
| | | |
| | | @GetMapping("/page") |
| | | @Operation(summary = "获得工艺路线分页") |
| | | @PreAuthorize("@ss.hasPermission('mes:pro-route:query')") |
| | | public CommonResult<PageResult<MesProRouteRespVO>> getRoutePage(@Valid MesProRoutePageReqVO pageReqVO) { |
| | | PageResult<MesProRouteDO> pageResult = routeService.getRoutePage(pageReqVO); |
| | | return success(BeanUtils.toBean(pageResult, MesProRouteRespVO.class)); |
| | |
| | | ExcelWriter writer = FastExcelFactory.write(response.getOutputStream()).autoCloseStream(false).build(); |
| | | try { |
| | | writer.write(Collections.emptyList(), FastExcelFactory.writerSheet(0, "路线") |
| | | .head(MesProRouteCompleteImportWorkbook.RouteRow.class).build()); |
| | | .head(MesProRouteCompleteImportWorkbook.RouteRow.class) |
| | | .registerWriteHandler(new cn.iocoder.yudao.framework.excel.core.handler.ColumnWidthMatchStyleStrategy()) |
| | | .registerWriteHandler(new cn.iocoder.yudao.framework.excel.core.handler.RequiredHeaderWriteHandler()).build()); |
| | | writer.write(Collections.emptyList(), FastExcelFactory.writerSheet(1, "产品") |
| | | .head(MesProRouteCompleteImportWorkbook.ProductRow.class).build()); |
| | | .head(MesProRouteCompleteImportWorkbook.ProductRow.class) |
| | | .registerWriteHandler(new cn.iocoder.yudao.framework.excel.core.handler.ColumnWidthMatchStyleStrategy()) |
| | | .registerWriteHandler(new cn.iocoder.yudao.framework.excel.core.handler.RequiredHeaderWriteHandler()).build()); |
| | | writer.write(Collections.emptyList(), FastExcelFactory.writerSheet(2, "工序") |
| | | .head(MesProRouteCompleteImportWorkbook.ProcessRow.class).build()); |
| | | .head(MesProRouteCompleteImportWorkbook.ProcessRow.class) |
| | | .registerWriteHandler(new cn.iocoder.yudao.framework.excel.core.handler.ColumnWidthMatchStyleStrategy()) |
| | | .registerWriteHandler(new cn.iocoder.yudao.framework.excel.core.handler.RequiredHeaderWriteHandler()).build()); |
| | | writer.write(Collections.emptyList(), FastExcelFactory.writerSheet(3, "工序产出") |
| | | .head(MesProRouteCompleteImportWorkbook.OutputRow.class).build()); |
| | | .head(MesProRouteCompleteImportWorkbook.OutputRow.class) |
| | | .registerWriteHandler(new cn.iocoder.yudao.framework.excel.core.handler.ColumnWidthMatchStyleStrategy()) |
| | | .registerWriteHandler(new cn.iocoder.yudao.framework.excel.core.handler.RequiredHeaderWriteHandler()).build()); |
| | | writer.write(Collections.emptyList(), FastExcelFactory.writerSheet(4, "工序投料") |
| | | .head(MesProRouteCompleteImportWorkbook.InputRow.class).build()); |
| | | .head(MesProRouteCompleteImportWorkbook.InputRow.class) |
| | | .registerWriteHandler(new cn.iocoder.yudao.framework.excel.core.handler.ColumnWidthMatchStyleStrategy()) |
| | | .registerWriteHandler(new cn.iocoder.yudao.framework.excel.core.handler.RequiredHeaderWriteHandler()).build()); |
| | | writer.write(List.of( |
| | | new MesProRouteCompleteImportWorkbook.GuideRow("路线", "每行一条路线;路线编码唯一。完整导入仅新增,已有编码会报错,导入后默认停用。"), |
| | | new MesProRouteCompleteImportWorkbook.GuideRow("产品", "路线编码与路线表一致;每条路线至少一个产品。物料、仓库、库区、库位填写已有业务编码;时间单位填 MINUTE/HOUR/DAY。"), |