package com.zy.asrs.wms.asrs.controller; import com.alibaba.fastjson.JSON; import com.alibaba.fastjson.JSONObject; import com.alibaba.fastjson.parser.Feature; import com.alibaba.fastjson.serializer.SerializerFeature; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.zy.asrs.framework.common.Cools; import com.zy.asrs.framework.common.R; import com.zy.asrs.wms.asrs.entity.MatField; import com.zy.asrs.wms.asrs.entity.MatFieldValue; import com.zy.asrs.wms.asrs.service.MatFieldService; import com.zy.asrs.wms.asrs.service.MatFieldValueService; import com.zy.asrs.wms.common.annotation.OperationLog; import com.zy.asrs.wms.common.domain.BaseParam; import com.zy.asrs.wms.common.domain.KeyValVo; import com.zy.asrs.wms.common.domain.PageParam; import com.zy.asrs.wms.asrs.entity.Mat; import com.zy.asrs.wms.asrs.service.MatService; import com.zy.asrs.wms.system.controller.BaseController; import com.zy.asrs.wms.utils.ExcelUtil; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.web.bind.annotation.*; import javax.servlet.http.HttpServletResponse; import java.util.*; @RestController @RequestMapping("/api") public class MatController extends BaseController { @Autowired private MatService matService; @Autowired private MatFieldService matFieldService; @Autowired private MatFieldValueService matFieldValueService; @PreAuthorize("hasAuthority('asrs:mat:list')") @PostMapping("/mat/page") public R page(@RequestBody Map map) { BaseParam baseParam = buildParam(map, BaseParam.class); PageParam pageParam = new PageParam<>(baseParam, Mat.class); PageParam page = matService.page(pageParam, pageParam.buildWrapper(true)); JSONObject data = JSON.parseObject(JSON.toJSONString(page)); List records = page.getRecords(); data.put("records", records); for (Mat mat : records) { List list = matFieldValueService.list(new LambdaQueryWrapper() .eq(MatFieldValue::getMatId, mat.getId())); mat.syncField(list); } return R.ok().add(data); } @PreAuthorize("hasAuthority('asrs:mat:list')") @PostMapping("/mat/list") public R list(@RequestBody Map map) { return R.ok().add(matService.list()); } @PreAuthorize("hasAuthority('asrs:mat:list')") @GetMapping("/mat/{id}") public R get(@PathVariable("id") Long id) { return R.ok().add(matService.getById(id)); } @PreAuthorize("hasAuthority('asrs:mat:save')") @OperationLog("添加商品档案") @PostMapping("/mat/save") public R save(@RequestBody HashMap param) { Mat mat = JSON.parseObject(JSON.toJSONString(param), Mat.class, Feature.DisableCircularReferenceDetect); if (!matService.save(mat)) { return R.error("添加失败"); } //设置扩展字段 setMatField(param, mat); return R.ok("添加成功"); } @PreAuthorize("hasAuthority('asrs:mat:update')") @OperationLog("修改商品档案") @PostMapping("/mat/update") public R update(@RequestBody HashMap param) { Mat mat = JSON.parseObject(JSON.toJSONString(param), Mat.class, Feature.DisableCircularReferenceDetect); //设置扩展字段 setMatField(param, mat); if (!matService.updateById(mat)) { return R.error("修改失败"); } return R.ok("修改成功"); } @PreAuthorize("hasAuthority('asrs:mat:remove')") @OperationLog("删除商品档案") @PostMapping("/mat/remove/{ids}") public R remove(@PathVariable Long[] ids) { if (!matService.removeByIds(Arrays.asList(ids))) { return R.error("删除失败"); } return R.ok("删除成功"); } @PreAuthorize("hasAuthority('asrs:mat:list')") @PostMapping("/mat/query") public R query(@RequestParam(required = false) String condition) { List vos = new ArrayList<>(); LambdaQueryWrapper wrapper = new LambdaQueryWrapper<>(); if (!Cools.isEmpty(condition)) { wrapper.like(Mat::getId, condition); } matService.page(new Page<>(1, 30), wrapper).getRecords().forEach( item -> vos.add(new KeyValVo(item.getId(), item.getId())) ); return R.ok().add(vos); } @PreAuthorize("hasAuthority('asrs:mat:list')") @PostMapping("/mat/export") public void export(@RequestBody Map map, HttpServletResponse response) throws Exception { List list = matService.parseMat(matService.list()); List matFields = matFieldService.getMatFields(); ExcelUtil.build(ExcelUtil.create(list, Mat.class, matFields), response); } private void setMatField(HashMap param, Mat mat) { //获取扩展字段 List matFields = matFieldService.list(); for (MatField matField : matFields) { if (param.containsKey(matField.getName())) { MatFieldValue fieldValue = matFieldValueService.getOne(new LambdaQueryWrapper() .eq(MatFieldValue::getMatId, mat.getId()) .eq(MatFieldValue::getFieldId, matField.getId())); if (fieldValue == null) { fieldValue = new MatFieldValue(); fieldValue.setMatId(mat.getId()); fieldValue.setFieldId(matField.getId()); fieldValue.setName(matField.getName()); fieldValue.setValue(param.get(matField.getName()).toString()); matFieldValueService.save(fieldValue); }else { fieldValue.setValue(param.get(matField.getName()).toString()); matFieldValueService.updateById(fieldValue); } } } } }