| | |
|---|
| | | @GetMapping("/get") |
|---|
| | | @Operation(summary = "获得物料") |
|---|
| | | @Parameter(name = "id", description = "编号", required = true, example = "1") |
|---|
| | | @PreAuthorize("@ss.hasPermission('mdm:item:query')") |
|---|
| | | public CommonResult<MdmItemRespVO> getItem(@RequestParam("id") Long id) { |
|---|
| | | MdmItemDO item = itemService.getItem(id); |
|---|
| | | MdmItemRespVO resp = BeanUtils.toBean(item, MdmItemRespVO.class); |
|---|
| | |
|---|
| | | |
|---|
| | | @GetMapping("/page") |
|---|
| | | @Operation(summary = "获得物料分页") |
|---|
| | | @PreAuthorize("@ss.hasPermission('mdm:item:query')") |
|---|
| | | public CommonResult<PageResult<MdmItemRespVO>> getItemPage(@Valid MdmItemPageReqVO pageReqVO) { |
|---|
| | | PageResult<MdmItemDO> pageResult = itemService.getItemPage(pageReqVO); |
|---|
| | | // 转换并补齐关联名称 |
|---|
| | |
|---|
| | | @GetMapping("/list-by-ids") |
|---|
| | | @Operation(summary = "获得物料列表") |
|---|
| | | @Parameter(name = "ids", description = "编号列表", required = true, example = "1,2,3") |
|---|
| | | @PreAuthorize("@ss.hasPermission('mdm:item:query')") |
|---|
| | | public CommonResult<List<MdmItemRespVO>> getItemList(@RequestParam("ids") List<Long> ids) { |
|---|
| | | List<MdmItemDO> list = itemService.getItemList(ids); |
|---|
| | | return success(BeanUtils.toBean(list, MdmItemRespVO.class)); |
|---|
| | |
|---|
| | | @PreAuthorize("@ss.hasPermission('mdm:item:import')") |
|---|
| | | public CommonResult<MdmItemImportRespVO> importExcel(@RequestParam("file") MultipartFile file, |
|---|
| | | @RequestParam(value = "updateSupport", required = false, defaultValue = "false") Boolean updateSupport) throws Exception { |
|---|
| | | List<MdmItemImportExcelVO> list = ExcelUtils.read(file, MdmItemImportExcelVO.class); |
|---|
| | | List<MdmItemImportExcelVO> list; |
|---|
| | | try { |
|---|
| | | list = ExcelUtils.read(file, MdmItemImportExcelVO.class); |
|---|
| | | } catch (cn.idev.excel.exception.ExcelDataConvertException e) { |
|---|
| | | int row = e.getRowIndex() == null ? 0 : e.getRowIndex() + 1; |
|---|
| | | int col = e.getColumnIndex() == null ? 0 : e.getColumnIndex() + 1; |
|---|
| | | String cellVal = e.getCellData() == null ? "" : String.valueOf(e.getCellData().getStringValue()); |
|---|
| | | throw new cn.iocoder.yudao.framework.common.exception.ServiceException(400, |
|---|
| | | "Excel 第 " + row + " 行第 " + col + " 列数据『" + cellVal + "』格式不正确，请检查该列内容（例如“状态”请填 0/1 或 启用/停用）"); |
|---|
| | | } catch (Exception e) { |
|---|
| | | throw new cn.iocoder.yudao.framework.common.exception.ServiceException(400, |
|---|
| | | "Excel 解析失败：" + e.getMessage() + "，请使用系统“下载导入模板”并按模板填写。"); |
|---|
| | | } |
|---|
| | | return success(itemService.importItemList(list, updateSupport)); |
|---|
| | | } |
|---|
| | | |
|---|
