package com.vincent.rsf.server.manager.controller; import cn.afterturn.easypoi.excel.ExcelImportUtil; import cn.afterturn.easypoi.excel.entity.ImportParams; import cn.afterturn.easypoi.excel.entity.result.ExcelImportResult; import cn.afterturn.easypoi.excel.imports.ExcelImportService; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.vincent.rsf.framework.common.Cools; import com.vincent.rsf.framework.common.R; import com.vincent.rsf.framework.exception.CoolException; import com.vincent.rsf.server.common.domain.PageResult; import com.vincent.rsf.server.common.utils.ExcelUtil; import com.vincent.rsf.server.common.annotation.OperationLog; import com.vincent.rsf.server.common.domain.BaseParam; import com.vincent.rsf.server.common.domain.KeyValVo; import com.vincent.rsf.server.common.domain.PageParam; import com.vincent.rsf.server.manager.entity.Matnr; import com.vincent.rsf.server.manager.service.MatnrService; import com.vincent.rsf.server.system.controller.BaseController; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import io.swagger.v3.oas.annotations.security.SecurityRequirement; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.http.HttpHeaders; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.web.bind.annotation.*; import org.springframework.web.multipart.MultipartFile; import javax.servlet.http.HttpServletResponse; import java.util.*; @RestController @Api(tags = "物料表接口") public class MatnrController extends BaseController { @Autowired private MatnrService matnrService; @PreAuthorize("hasAuthority('manager:matnr:list')") @PostMapping("/matnr/page") public R page(@RequestBody Map map) { BaseParam baseParam = buildParam(map, BaseParam.class); PageParam pageParam = new PageParam<>(baseParam, Matnr.class); return R.ok().add(matnrService.page(pageParam, pageParam.buildWrapper(true))); } @PreAuthorize("hasAuthority('manager:matnr:list')") @PostMapping("/matnr/list") public R list(@RequestBody Map map) { return R.ok().add(matnrService.list()); } @PreAuthorize("hasAuthority('manager:matnr:list')") @PostMapping({"/matnr/many/{ids}", "/matnrs/many/{ids}"}) public R many(@PathVariable Long[] ids) { return R.ok().add(matnrService.listByIds(Arrays.asList(ids))); } @PreAuthorize("hasAuthority('manager:matnr:list')") @GetMapping("/matnr/{id}") public R get(@PathVariable("id") Long id) { return R.ok().add(matnrService.getById(id)); } @PreAuthorize("hasAuthority('manager:matnr:save')") @OperationLog("Create 物料信息表") @PostMapping("/matnr/save") public R save(@RequestBody Matnr matnr) { matnr.setCreateBy(getLoginUserId()); matnr.setCreateTime(new Date()); matnr.setUpdateBy(getLoginUserId()); matnr.setUpdateTime(new Date()); if (!matnrService.save(matnr)) { return R.error("Save Fail"); } return R.ok("Save Success").add(matnr); } @PreAuthorize("hasAuthority('manager:matnr:update')") @OperationLog("Update 物料信息表") @PostMapping("/matnr/update") public R update(@RequestBody Matnr matnr) { matnr.setUpdateBy(getLoginUserId()); matnr.setUpdateTime(new Date()); if (!matnrService.updateById(matnr)) { return R.error("Update Fail"); } return R.ok("Update Success").add(matnr); } @PreAuthorize("hasAuthority('manager:matnr:remove')") @OperationLog("Delete 物料信息表") @PostMapping("/matnr/remove/{ids}") public R remove(@PathVariable Long[] ids) { if (!matnrService.removeByIds(Arrays.asList(ids))) { return R.error("Delete Fail"); } return R.ok("Delete Success").add(ids); } @PreAuthorize("hasAuthority('manager:matnr:list')") @PostMapping("/matnr/query") public R query(@RequestParam(required = false) String condition) { List vos = new ArrayList<>(); LambdaQueryWrapper wrapper = new LambdaQueryWrapper<>(); if (!Cools.isEmpty(condition)) { wrapper.like(Matnr::getName, condition); } matnrService.page(new Page<>(1, 30), wrapper).getRecords().forEach( item -> vos.add(new KeyValVo(item.getId(), item.getName())) ); return R.ok().add(vos); } @SecurityRequirement(name = HttpHeaders.AUTHORIZATION) @PreAuthorize("hasAuthority('manager:matnr:list')") @ApiOperation(value = "获取分类物料明细列表") @PostMapping("/matnr/group") public R getGroupMatnrs(@RequestBody Map map) { BaseParam baseParam = buildParam(map, BaseParam.class); PageParam pageParam = new PageParam<>(baseParam, Matnr.class); LambdaQueryWrapper wrapper = new LambdaQueryWrapper<>(); if (!Cools.isEmpty(map.get("condition"))) { wrapper.like(Matnr::getName, map.get("condition")); } if (Cools.isEmpty(map.get("groupId"))) { throw new CoolException("分类ID不能为空!!"); } wrapper.eq(Matnr::getGroupId, map.get("groupId")); Page matnrPage = matnrService.page(new Page<>(1, 30), wrapper); return R.ok(new PageResult().setRecords(matnrPage.getRecords()).setTotal(matnrPage.getTotal())); } @PreAuthorize("hasAuthority('manager:matnr:list')") @PostMapping("/matnr/export") public void export(@RequestBody Map map, HttpServletResponse response) throws Exception { ExcelUtil.build(ExcelUtil.create(matnrService.list(), Matnr.class), response); } @PreAuthorize("hasAuthority('manager:matnr:save')") @ApiOperation(value = "excel表格导入物料信息") @PostMapping("/matnr/import") public R listImport(@RequestParam MultipartFile file) throws Exception { if (Objects.isNull(file)) { throw new CoolException("文件不能为空!!"); } matnrService.importExcels(file); return R.ok(); } }