| | |
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
| | | 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.manager.enums.OrderSourceType; |
| | | import com.vincent.rsf.server.manager.enums.OrderType; |
| | | import com.vincent.rsf.server.manager.enums.OrderWorkType; |
| | | import com.vincent.rsf.server.common.utils.ExcelUtil; |
| | | import com.vincent.rsf.server.manager.entity.Companys; |
| | | import com.vincent.rsf.server.manager.entity.Matnr; |
| | | import com.vincent.rsf.server.manager.entity.Purchase; |
| | | import com.vincent.rsf.server.manager.entity.excel.AsnOrderTemplate; |
| | | import com.vincent.rsf.server.manager.entity.excel.PurchaseTemplate; |
| | | import com.vincent.rsf.server.manager.enums.CompanysType; |
| | | import com.vincent.rsf.server.manager.mapper.PurchaseItemMapper; |
| | |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | import org.springframework.web.multipart.MultipartFile; |
| | | |
| | | import java.io.IOException; |
| | | import java.text.SimpleDateFormat; |
| | | import java.util.*; |
| | | import java.util.stream.Collectors; |
| | | |
| | |
| | | } |
| | | PurchaseTemplate template = list.stream().findFirst().get(); |
| | | Purchase purchase = new Purchase(); |
| | | SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd"); |
| | | Date date = dateFormat.parse(template.getArrTime()); |
| | | BeanUtils.copyProperties(template, purchase); |
| | | purchase.setCode(template.getPoCode()); |
| | | if (StringUtils.isBlank(template.getPoCode())) { |
| | |
| | | } |
| | | purchase.setType(OrderType.getTypeVal(template.getType())) |
| | | .setWkType(OrderWorkType.getWorkType(template.getWkType())) |
| | | .setSource(template.getSource()) |
| | | .setSource(OrderSourceType.ORDER_SOURCE_TYPE_EXCEL.desc) |
| | | .setPreArr(date) |
| | | .setCreateBy(loginUserId) |
| | | .setUpdateBy(loginUserId); |
| | | if (!purchaseService.save(purchase)) { |
| | |
| | | if (StringUtils.isBlank(purchaseTemplate.getMatnrCode())) { |
| | | throw new CoolException(purchaseTemplate.getPoCode() + ":物料编码不能为空!!"); |
| | | } |
| | | Matnr matnr = matnrService.getOne(new LambdaQueryWrapper<Matnr>().eq(Matnr::getCode, template.getMatnrCode())); |
| | | Matnr matnr = matnrService.getOne(new LambdaQueryWrapper<Matnr>().eq(Matnr::getCode, purchaseTemplate.getMatnrCode())); |
| | | if (Objects.isNull(matnr)) { |
| | | throw new CoolException(template.getMatnrCode() + "物料不存在!!"); |
| | | throw new CoolException(purchaseTemplate.getMatnrCode() + "物料不存在!!"); |
| | | } |
| | | item.setMatnrName(matnr.getName()) |
| | | .setMatnrCode(matnr.getCode()) |
| | | .setPlatItemId(template.getPlatItemId()) |
| | | .setAnfme(template.getAnfme()) |
| | | .setQty(template.getQty()) |
| | | .setPlatItemId(purchaseTemplate.getPlatItemId()) |
| | | .setAnfme(purchaseTemplate.getAnfme()) |
| | | .setPurchaseId(purchase.getId()) |
| | | .setUnit(matnr.getUnit()) |
| | | .setNromQty(matnr.getNromNum()) |
| | | .setSplrBatch(template.getSplrBatch()) |
| | | .setSplrBatch(purchaseTemplate.getSplrBatch()) |
| | | .setCreateBy(loginUserId) |
| | | .setUpdateBy(loginUserId) |
| | | .setUnit(template.getUnit()); |
| | | .setUpdateBy(loginUserId); |
| | | |
| | | if (StringUtils.isNotBlank(purchaseTemplate.getSplrCode())) { |
| | | Companys companys = companysService.getOne(new LambdaQueryWrapper<Companys>() |
| | | .eq(Companys::getType, CompanysType.COMPANYS_TYPE_SUPPLIER.val) |
| | | .eq(Companys::getCode, template.getSplrCode())); |
| | | .eq(Companys::getCode, purchaseTemplate.getSplrCode())); |
| | | if (!Objects.isNull(companys)) { |
| | | item.setSplrCode(companys.getCode()).setSplrName(companys.getName()); |
| | | } else { |
| | |
| | | } |
| | | |
| | | double anfmes = items.stream().mapToDouble(PurchaseItem::getAnfme).sum(); |
| | | double qty = items.stream().mapToDouble(PurchaseItem::getQty).sum(); |
| | | purchase.setAnfme(anfmes).setQty(qty); |
| | | purchase.setAnfme(anfmes); |
| | | |
| | | if (!purchaseService.updateById(purchase)) { |
| | | throw new CoolException("主单数量修改失败!!"); |