From 014270352f8e19b51bbb4367ae2ff256050a30a2 Mon Sep 17 00:00:00 2001 From: skyouc Date: 星期二, 22 四月 2025 14:03:42 +0800 Subject: [PATCH] #修改优化 1. 字典优化修改 2. 编码规则优化 3. 出库单编码生成为空问题修复 --- rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/AsnOrderItemServiceImpl.java | 192 ++++++++++++++++++++++++++++++++++++----------- 1 files changed, 147 insertions(+), 45 deletions(-) diff --git a/rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/AsnOrderItemServiceImpl.java b/rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/AsnOrderItemServiceImpl.java index b7775b2..768ef85 100644 --- a/rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/AsnOrderItemServiceImpl.java +++ b/rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/AsnOrderItemServiceImpl.java @@ -4,95 +4,197 @@ import cn.afterturn.easypoi.excel.entity.result.ExcelImportResult; import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; +import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper; +import com.baomidou.mybatisplus.core.metadata.IPage; import com.vincent.rsf.framework.common.R; import com.vincent.rsf.framework.exception.CoolException; +import com.vincent.rsf.server.api.entity.enums.OrderType; +import com.vincent.rsf.server.api.entity.enums.OrderWorkType; +import com.vincent.rsf.server.common.domain.BaseParam; +import com.vincent.rsf.server.common.domain.PageParam; import com.vincent.rsf.server.common.utils.CommonUtil; import com.vincent.rsf.server.common.utils.ExcelUtil; +import com.vincent.rsf.server.common.utils.FieldsUtils; import com.vincent.rsf.server.manager.entity.AsnOrder; +import com.vincent.rsf.server.manager.entity.Matnr; import com.vincent.rsf.server.manager.entity.excel.AsnOrderTemplate; -import com.vincent.rsf.server.manager.entity.excel.MatnrsTemplate; import com.vincent.rsf.server.manager.mapper.AsnOrderItemMapper; import com.vincent.rsf.server.manager.entity.AsnOrderItem; -import com.vincent.rsf.server.manager.mapper.AsnOrderMapper; import com.vincent.rsf.server.manager.service.AsnOrderItemService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; -import com.vincent.rsf.server.system.entity.Fields; -import com.vincent.rsf.server.system.entity.FieldsItem; +import com.vincent.rsf.server.manager.service.AsnOrderService; +import com.vincent.rsf.server.manager.service.MatnrService; +import com.vincent.rsf.server.system.constant.SerialRuleCode; import com.vincent.rsf.server.system.service.FieldsItemService; import com.vincent.rsf.server.system.service.FieldsService; -import org.springframework.beans.BeanUtils; +import com.vincent.rsf.server.system.utils.SerialRuleUtils; +import org.apache.commons.lang3.StringUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.web.multipart.MultipartFile; import javax.annotation.Resource; -import java.io.IOException; import java.util.*; +import java.util.stream.Collectors; @Service("asnOrderItemService") public class AsnOrderItemServiceImpl extends ServiceImpl<AsnOrderItemMapper, AsnOrderItem> implements AsnOrderItemService { - @Resource - private AsnOrderMapper asnOrderMapper; + @Autowired + private AsnOrderService asnOrderMapper; @Autowired private FieldsService fieldsService; + @Autowired private FieldsItemService fieldsItemService; + @Autowired + private MatnrService matnrService; + + @Autowired + private AsnOrderItemService asnOrderItemService; @Override - @Transactional(rollbackFor = Exception.class) - public R excelImport(MultipartFile file, HashMap<String, Object> hashMap) throws Exception { - ExcelImportResult<AsnOrderTemplate> result = ExcelImportUtil.importExcelMore(file.getInputStream(), MatnrsTemplate.class, ExcelUtil.getDefaultImportParams()); - if (result.getList().isEmpty()) { - throw new CoolException("鐗╂枡瀵煎叆澶辫触锛侊紒"); + public R generateBarcode(List<Long> orders) { + if (Objects.isNull(orders) || orders.isEmpty()) { + throw new CoolException("鍙傛暟涓嶈兘涓虹┖锛侊紒"); } - if (!Objects.isNull(hashMap.get("asnId"))) { - throw new CoolException("涓诲崟ID涓虹┖锛屾棤娉曟搷浣滐紒锛�"); + List<AsnOrderItem> items = this.list(new LambdaQueryWrapper<AsnOrderItem>().eq(AsnOrderItem::getId, orders)); + if (items.isEmpty()) { + throw new CoolException("鍗曟嵁鏄庣粏涓嶅瓨鍦紒锛�"); } - AsnOrder order = asnOrderMapper.selectOne(new LambdaQueryWrapper<AsnOrder>().eq(AsnOrder::getId, hashMap.get("asnId"))); - if (Objects.isNull(order)) { - throw new CoolException("ASN鍗曟嵁涓嶅瓨鍦紒锛�"); - } - List<AsnOrderItem> itemList = new ArrayList<>(); - result.getList().forEach(template -> { - AsnOrderItem orderItem = new AsnOrderItem(); - BeanUtils.copyProperties(template, orderItem); - orderItem.setAsnId(order.getId()) - .setAsnCode(order.getCode()); - itemList.add(orderItem); + items.forEach(item -> { + String ruleCode = SerialRuleUtils.generateRuleCode(SerialRuleCode.SYS_LABEL_CODE, item); + if (Objects.isNull(ruleCode) || StringUtils.isBlank(ruleCode)) { + throw new CoolException("绯荤粺閿欒锛岃妫�鏌ャ�孲YS_LABEL_CODE銆嶆爣绛捐鍒欐槸鍚﹀瓨鍦�"); + } + item.setTrackCode(ruleCode); }); - if (!this.saveBatch(itemList)) { - throw new CoolException("淇濆瓨澶辫触锛侊紒"); + if (!this.saveOrUpdateBatch(items)) { + throw new CoolException("鐢熸垚鏉$爜澶辫触锛侊紒"); } - return R.ok("鎿嶄綔鎴愬姛锛侊紒"); + + return R.ok(); } @Override - public boolean fieldsSave(Map<String, Object> params) { - List<Fields> fields = fieldsService.list(new LambdaQueryWrapper<Fields>().eq(Fields::getStatus, 1).eq(Fields::getFlagEnable, 1)); - List<FieldsItem> fieldsItems = new ArrayList<>(); - if (!fields.isEmpty()) { - String uuid16 = CommonUtil.randomUUID16(); - for (Fields obj : fields) { - if (!Objects.isNull(params.get(obj.getFields()))) { - FieldsItem item = new FieldsItem(); - item.setUuid(uuid16) - .setValue(params.get(obj.getFields()).toString()) - .setMatnrId(Long.parseLong(params.get("matnrId").toString())) - .setFieldsId(obj.getId()); - fieldsItems.add(item); + @Transactional(rollbackFor = Exception.class) + public R excelImport(MultipartFile file, HashMap<String, Object> hashMap, Long loginUserId) throws Exception { + ExcelImportResult result = ExcelImportUtil.importExcelMore(file.getInputStream(), AsnOrderTemplate.class, ExcelUtil.getDefaultImportParams()); + if (result.getList().isEmpty()) { + throw new CoolException("鐗╂枡瀵煎叆澶辫触锛侊紒"); + } + if (result.getList().isEmpty()) { + throw new CoolException("琛ㄦ牸鍐呭涓嶈兘涓虹┖锛侊紒"); + } + List<AsnOrderTemplate> resultList = result.getList(); + Map<String, List<AsnOrderTemplate>> listMap = resultList.stream().collect(Collectors.groupingBy(AsnOrderTemplate::getCode)); + for (String key : listMap.keySet()) { + AsnOrderTemplate template = listMap.get(key).stream().findFirst().get(); + AsnOrder asnOrder = asnOrderMapper.getOne(new LambdaQueryWrapper<AsnOrder>().eq(AsnOrder::getCode, template.getCode())); + if (Objects.isNull(asnOrder)) { + continue; + } + AsnOrder order = new AsnOrder(); + order.setCode(template.getCode()) + .setPoCode(template.getPoCode()) + .setMemo(template.getMemo()) + .setUpdateBy(loginUserId) + .setCreateBy(loginUserId) + .setPoId(Long.parseLong(template.getPoId())) + .setType(OrderType.getTypeVal(template.getType())) + .setWkType(OrderWorkType.getWorkType(template.getWkType())); + if (!asnOrderMapper.save(order)) { + throw new CoolException("鍗曟嵁淇濆瓨澶辫触锛侊紒"); + } + List<AsnOrderItem> items = new ArrayList<>(); + for (AsnOrderTemplate orderTemplate : listMap.get(key)) { + AsnOrderItem orderItem = new AsnOrderItem(); + Matnr matnr = null; + if (!Objects.isNull(orderTemplate.getMatnrCode()) || StringUtils.isNotBlank(orderTemplate.getMatnrCode())) { + matnr = matnrService.getOne(new LambdaQueryWrapper<Matnr>() + .eq(Matnr::getCode, orderTemplate.getMatnrCode())); + } + orderItem.setAsnId(order.getId()) + .setAsnCode(order.getCode()) + .setSplrBatch(orderTemplate.getSplrBatch()) + .setAnfme(Double.parseDouble(orderTemplate.getAnfme())) + .setQty(Double.parseDouble(orderTemplate.getQty())) + .setSplrName(orderTemplate.getSplrName()) + .setBarcode(orderTemplate.getBarcode()) + .setTrackCode(orderTemplate.getTrackCode()) + .setSplrCode(orderTemplate.getSplrCode()) + .setPoCode(orderTemplate.getPoCode()) + .setMaktx(orderTemplate.getMaktx()) + .setMatnrCode(orderTemplate.getMatnrCode()) + .setPurUnit(orderTemplate.getPurUnit()) + .setPurQty(Double.parseDouble(orderTemplate.getPurQty())); + if (!Objects.isNull(matnr)) { + orderItem.setMaktx(matnr.getName()).setMatnrCode(matnr.getCode()).setMatnrId(matnr.getId()); + } + items.add(orderItem); + if (!asnOrderItemService.saveBatch(items)) { + throw new CoolException("鍗曟嵁鏄庣粏淇濆瓨澶辫触锛侊紒"); } } - if (!fieldsItemService.saveBatch(fieldsItems)) { - throw new CoolException("鍗曟嵁鏄庣粏鎵╁睍瀛楁淇濆瓨澶辫触锛侊紒"); + if (!items.isEmpty()) { + double qty = items.stream().mapToDouble(AsnOrderItem::getQty).sum(); + double purQty = items.stream().mapToDouble(AsnOrderItem::getPurQty).sum(); + if (!asnOrderMapper.update(new LambdaUpdateWrapper<AsnOrder>().set(AsnOrder::getQty, qty).set(AsnOrder::getAnfme, purQty).eq(AsnOrder::getId, order.getId()))) { + throw new CoolException("鍗曟嵁鏁伴噺淇敼澶辫触锛侊紒"); + } } } + + return R.ok("鎿嶄綔鎴愬姛锛侊紒"); + } + + /** + * @param + * @return + * @author Ryan + * @description ASN鏄庣粏鍗曟嵁淇濆瓨锛屽強鎵╁睍瀛楁淇濆瓨 + * @time 2025/4/7 09:59 + */ + @Override + @Transactional(rollbackFor = Exception.class) + public boolean fieldsSave(Map<String, Object> params) { AsnOrderItem asnOrderItem = JSONObject.parseObject(JSONObject.toJSONString(params), AsnOrderItem.class); - if (!this.save(asnOrderItem)) { + if (StringUtils.isBlank(asnOrderItem.getTrackCode())) { + String ruleCode = SerialRuleUtils.generateRuleCode(SerialRuleCode.SYS_LABEL_CODE, asnOrderItem); + asnOrderItem.setTrackCode(ruleCode).setBarcode(ruleCode); + ; + } + if (Objects.isNull(asnOrderItem.getAnfme()) || Double.compare(asnOrderItem.getAnfme(), 0.0) <= 0) { + throw new CoolException("璁″垝鏀惰揣鏁颁笉鑳戒负绌猴紒锛�"); + } + //淇濆瓨鎵╁睍瀛楁 + try { + String uuid16 = CommonUtil.randomUUID16(); + Boolean fields = FieldsUtils.saveFields(params, uuid16); + if (fields) { + asnOrderItem.setFieldsIndex(uuid16); + } + } catch (Exception e) { + throw new RuntimeException(e); + } + if (!this.saveOrUpdate(asnOrderItem)) { throw new CoolException("鏀惰揣閫氱煡鍗曟槑缁嗕繚瀛樺け璐ワ紒锛�"); } return true; } + + @Override + public IPage<Map<String, Object>> listByAsnId(PageParam<AsnOrderItem, BaseParam> pageParam, QueryWrapper<AsnOrderItem> buildWrapper) { + IPage<Map<String, Object>> hsahMap = this.baseMapper.resultForMap(pageParam, buildWrapper); + if (hsahMap.getRecords().isEmpty()) { + return hsahMap.setRecords(new ArrayList<>()); + } + hsahMap.setRecords(FieldsUtils.getExtendFields(hsahMap.getRecords())); + return hsahMap; + + } + } -- Gitblit v1.9.1