package cn.iocoder.yudao.module.mes.controller.admin.md.item;
|
|
import cn.hutool.core.collection.CollUtil;
|
import cn.iocoder.yudao.framework.apilog.core.annotation.ApiAccessLog;
|
import cn.iocoder.yudao.framework.common.pojo.CommonResult;
|
import cn.iocoder.yudao.framework.common.pojo.PageParam;
|
import cn.iocoder.yudao.framework.common.pojo.PageResult;
|
import cn.iocoder.yudao.framework.common.util.collection.MapUtils;
|
import cn.iocoder.yudao.framework.common.util.object.BeanUtils;
|
import cn.iocoder.yudao.framework.excel.core.util.ExcelUtils;
|
import cn.iocoder.yudao.module.mes.controller.admin.md.item.vo.MesMdItemImportExcelVO;
|
import cn.iocoder.yudao.module.mes.controller.admin.md.item.vo.MesMdItemImportRespVO;
|
import cn.iocoder.yudao.module.mes.controller.admin.md.item.vo.MesMdItemPageReqVO;
|
import cn.iocoder.yudao.module.mes.controller.admin.md.item.vo.MesMdItemRespVO;
|
import cn.iocoder.yudao.module.mes.controller.admin.md.item.vo.MesMdItemSaveReqVO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.md.item.MesMdItemDO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.md.item.MesMdItemTypeDO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.md.unitmeasure.MesMdUnitMeasureDO;
|
import cn.iocoder.yudao.module.mes.service.md.item.MesMdItemService;
|
import cn.iocoder.yudao.module.mes.service.md.item.MesMdItemTypeService;
|
import cn.iocoder.yudao.module.mes.service.md.unitmeasure.MesMdUnitMeasureService;
|
import io.swagger.v3.oas.annotations.Operation;
|
import io.swagger.v3.oas.annotations.Parameter;
|
import io.swagger.v3.oas.annotations.Parameters;
|
import io.swagger.v3.oas.annotations.tags.Tag;
|
import jakarta.annotation.Resource;
|
import jakarta.servlet.http.HttpServletResponse;
|
import jakarta.validation.Valid;
|
import org.springframework.security.access.prepost.PreAuthorize;
|
import org.springframework.validation.annotation.Validated;
|
import org.springframework.web.bind.annotation.*;
|
import org.springframework.web.multipart.MultipartFile;
|
|
import java.io.IOException;
|
import java.math.BigDecimal;
|
import java.util.Arrays;
|
import java.util.Collections;
|
import java.util.List;
|
import java.util.Map;
|
|
import static cn.iocoder.yudao.framework.apilog.core.enums.OperateTypeEnum.EXPORT;
|
import static cn.iocoder.yudao.framework.common.pojo.CommonResult.success;
|
import static cn.iocoder.yudao.framework.common.util.collection.CollectionUtils.convertSet;
|
|
@Tag(name = "管理后台 - MES 物料产品")
|
@RestController
|
@RequestMapping("/mes/md/item")
|
@Validated
|
public class MesMdItemController {
|
|
@Resource
|
private MesMdItemService itemService;
|
@Resource
|
private MesMdItemTypeService itemTypeService;
|
@Resource
|
private MesMdUnitMeasureService unitMeasureService;
|
|
@PostMapping("/create")
|
@Operation(summary = "创建物料产品")
|
@PreAuthorize("@ss.hasPermission('mes:md-item:create')")
|
public CommonResult<Long> createItem(@Valid @RequestBody MesMdItemSaveReqVO createReqVO) {
|
return success(itemService.createItem(createReqVO));
|
}
|
|
@PutMapping("/update")
|
@Operation(summary = "更新物料产品")
|
@PreAuthorize("@ss.hasPermission('mes:md-item:update')")
|
public CommonResult<Boolean> updateItem(@Valid @RequestBody MesMdItemSaveReqVO updateReqVO) {
|
itemService.updateItem(updateReqVO);
|
return success(true);
|
}
|
|
@DeleteMapping("/delete")
|
@Operation(summary = "删除物料产品")
|
@Parameter(name = "id", description = "编号", required = true)
|
@PreAuthorize("@ss.hasPermission('mes:md-item:delete')")
|
public CommonResult<Boolean> deleteItem(@RequestParam("id") Long id) {
|
itemService.deleteItem(id);
|
return success(true);
|
}
|
|
@GetMapping("/get")
|
@Operation(summary = "获得物料产品")
|
@Parameter(name = "id", description = "编号", required = true, example = "1024")
|
@PreAuthorize("@ss.hasPermission('mes:md-item:query')")
|
public CommonResult<MesMdItemRespVO> getItem(@RequestParam("id") Long id) {
|
MesMdItemDO item = itemService.getItem(id);
|
return success(buildItemVO(item));
|
}
|
|
@GetMapping("/page")
|
@Operation(summary = "获得物料产品分页")
|
@PreAuthorize("@ss.hasPermission('mes:md-item:query')")
|
public CommonResult<PageResult<MesMdItemRespVO>> getItemPage(@Valid MesMdItemPageReqVO pageReqVO) {
|
PageResult<MesMdItemDO> pageResult = itemService.getItemPage(pageReqVO);
|
return success(new PageResult<>(buildItemVOList(pageResult.getList()), pageResult.getTotal()));
|
}
|
|
@GetMapping("/export-excel")
|
@Operation(summary = "导出物料产品 Excel")
|
@PreAuthorize("@ss.hasPermission('mes:md-item:export')")
|
@ApiAccessLog(operateType = EXPORT)
|
public void exportItemExcel(@Valid MesMdItemPageReqVO pageReqVO,
|
HttpServletResponse response) throws IOException {
|
pageReqVO.setPageSize(PageParam.PAGE_SIZE_NONE);
|
PageResult<MesMdItemDO> pageResult = itemService.getItemPage(pageReqVO);
|
// 导出 Excel
|
ExcelUtils.write(response, "物料产品.xls", "数据", MesMdItemRespVO.class,
|
buildItemVOList(pageResult.getList()));
|
}
|
|
@GetMapping("/get-import-template")
|
@Operation(summary = "获得物料导入模板")
|
@PreAuthorize("@ss.hasPermission('mes:md-item:import')")
|
public void importTemplate(HttpServletResponse response) throws IOException {
|
List<MesMdItemImportExcelVO> list = Arrays.asList(
|
MesMdItemImportExcelVO.builder()
|
.code("ITEM_RAW_001").name("铜杆").specification("Φ8mm").color("红色")
|
.unitMeasureName("千克").itemTypeName("原材料")
|
.safeStockFlag(true).minStock(new BigDecimal("100")).maxStock(new BigDecimal("10000"))
|
.highValue(false).batchFlag(true).remark("示例：计量单位、物料分类请填写系统中已存在的名称").build(),
|
MesMdItemImportExcelVO.builder()
|
.code("ITEM_RAW_002").name("铝杆").specification("Φ9.5mm").color("蓝色")
|
.unitMeasureName("千克").itemTypeName("原材料")
|
.safeStockFlag(false).highValue(false).batchFlag(false).remark("示例：颜色用于区分同型号不同颜色的物料").build()
|
);
|
ExcelUtils.writeTemplate(response, "物料导入模板.xls", "物料", MesMdItemImportExcelVO.class, list);
|
}
|
|
@PostMapping("/import")
|
@Operation(summary = "导入物料产品")
|
@Parameters({
|
@Parameter(name = "file", description = "Excel 文件", required = true),
|
@Parameter(name = "updateSupport", description = "是否支持更新，默认为 false", example = "true")
|
})
|
@PreAuthorize("@ss.hasPermission('mes:md-item:import')")
|
public CommonResult<MesMdItemImportRespVO> importExcel(@RequestParam("file") MultipartFile file,
|
@RequestParam(value = "updateSupport", required = false, defaultValue = "false") Boolean updateSupport) throws Exception {
|
List<MesMdItemImportExcelVO> list = ExcelUtils.read(file, MesMdItemImportExcelVO.class);
|
return success(itemService.importItemList(list, updateSupport));
|
}
|
|
// ==================== 拼接 VO ====================
|
|
private List<MesMdItemRespVO> buildItemVOList(List<MesMdItemDO> list) {
|
if (CollUtil.isEmpty(list)) {
|
return Collections.emptyList();
|
}
|
Map<Long, MesMdItemTypeDO> itemTypeMap = itemTypeService.getItemTypeMap(
|
convertSet(list, MesMdItemDO::getItemTypeId));
|
Map<Long, MesMdUnitMeasureDO> unitMeasureMap = unitMeasureService.getUnitMeasureMap(
|
convertSet(list, MesMdItemDO::getUnitMeasureId));
|
return BeanUtils.toBean(list, MesMdItemRespVO.class, item -> {
|
MapUtils.findAndThen(itemTypeMap, item.getItemTypeId(),
|
itemType -> {
|
item.setItemTypeName(itemType.getName());
|
item.setItemOrProduct(itemType.getItemOrProduct());
|
});
|
MapUtils.findAndThen(unitMeasureMap, item.getUnitMeasureId(),
|
unitMeasure -> item.setUnitMeasureName(unitMeasure.getName()));
|
});
|
}
|
|
private MesMdItemRespVO buildItemVO(MesMdItemDO item) {
|
if (item == null) {
|
return null;
|
}
|
return CollUtil.getFirst(buildItemVOList(Collections.singletonList(item)));
|
}
|
|
}
|
