From 441eb455e1e8a9283cd569c132b14ba8da4c54a6 Mon Sep 17 00:00:00 2001
From: xuhy <3313886187@qq.com>
Date: 星期六, 11 十月 2025 17:49:47 +0800
Subject: [PATCH] 导出，短信，模板消息
---
ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TErpProcurementServiceImpl.java | 105 +++++++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 98 insertions(+), 7 deletions(-)
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TErpProcurementServiceImpl.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TErpProcurementServiceImpl.java
index 99a65ec..addd8d1 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TErpProcurementServiceImpl.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TErpProcurementServiceImpl.java
@@ -1,6 +1,7 @@
package com.ruoyi.system.service.impl;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.common.core.domain.BaseModel;
@@ -12,6 +13,7 @@
import com.ruoyi.system.query.TErpGoodsQuery;
import com.ruoyi.system.query.TErpProcurementQuery;
import com.ruoyi.system.service.TErpGoodsService;
+import com.ruoyi.system.service.TErpProcurementGoodsService;
import com.ruoyi.system.service.TErpProcurementService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.system.vo.*;
@@ -26,7 +28,10 @@
import org.apache.http.conn.ssl.SSLSocketFactory;
import org.apache.http.entity.StringEntity;
import org.apache.http.impl.client.DefaultHttpClient;
+import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Propagation;
+import org.springframework.transaction.annotation.Transactional;
import javax.annotation.Resource;
import javax.net.ssl.SSLContext;
@@ -36,6 +41,7 @@
import java.io.FileInputStream;
import java.io.IOException;
import java.math.BigDecimal;
+import java.math.RoundingMode;
import java.security.PrivateKey;
import java.security.cert.X509Certificate;
import java.util.ArrayList;
@@ -78,6 +84,9 @@
@Resource
private TErpGoodsUnitMapper erpGoodsUnitMapper;
+ @Autowired
+ private TErpProcurementGoodsService erpProcurementGoodsService;
+
@Override
@@ -115,7 +124,7 @@
}
List<String> ids = list.stream().map(TErpProcurementVo::getId).collect(Collectors.toList());
List<TErpProcurementGoods> tErpProcurementGoods = erpProcurementGoodsMapper.selectList
- (new LambdaQueryWrapper<TErpProcurementGoods>().in(TErpProcurementGoods::getProcurementId, ids).eq(TErpProcurementGoods::getSupplierId, supplierClinicId));
+ (new LambdaQueryWrapper<TErpProcurementGoods>().in(TErpProcurementGoods::getProcurementId, ids));
List<TSysCommission> tSysCommissions =new ArrayList<>();
if(!tErpProcurementGoods.isEmpty()){
List<String> collect = tErpProcurementGoods.stream().map(TErpProcurementGoods::getId).collect(Collectors.toList());
@@ -185,6 +194,9 @@
tErpProcurementVo.setStatus(tErpProcurement.getStatus());
tErpProcurementVo.setSendTime(tErpProcurement.getSendTime());
+ tErpProcurementVo.setMoney(tErpProcurement.getMoney());
+ tErpProcurementVo.setTotalPrice(tErpProcurement.getPayMoney());
+
List<TErpProcurementGoods> tErpProcurementGoods = erpProcurementGoodsMapper.selectList
(new LambdaQueryWrapper<TErpProcurementGoods>().eq(TErpProcurementGoods::getProcurementId, id)
.like(goodsName != null && !goodsName.isEmpty(), TErpProcurementGoods::getGoodsName, goodsName)
@@ -201,6 +213,7 @@
tErpProcurementDetailNextVo.setNum(tErpProcurementGood.getPurchaseCount());
tErpProcurementDetailNextVo.setTotalPrice(tErpProcurementGood.getTotalPrice());
tErpProcurementDetailNextVo.setQuasiNumber(tErpProcurementGood.getQuasiNumber());
+ tErpProcurementDetailNextVo.setPurchasePrice(tErpProcurementGood.getPurchasePrice());
List<TSysCommission> tSysCommissions = sysCommissionMapper.selectList(new LambdaQueryWrapper<TSysCommission>().eq(TSysCommission::getTErpProcurementGoodsId, tErpProcurementGood.getId()));
@@ -231,6 +244,13 @@
tErpGoodsVO.setTypeName(tErpGoodsVO.getTypeName());
}
}
+ List<String> supplierClinicId = list.stream().filter(e->e.getGoodsSource()==1).map(TErpGoods::getSupplierClinicId).collect(Collectors.toList());
+ if(!supplierClinicId.isEmpty()){
+ List<TCrmSupplier> crmClinics = crmSupplierMapper.selectBatchIds(supplierClinicId);
+ for (TErpGoods tErpGoodsVO : list) {
+ crmClinics.stream().filter(t -> t.getId().equals(tErpGoodsVO.getSupplierClinicId())).findFirst().ifPresent(t -> tErpGoodsVO.setSupplierName(t.getSupplierName()));
+ }
+ }
pageInfo.setRecords( list);
return pageInfo;
}
@@ -238,18 +258,37 @@
@Override
public List<TErpGoodsVO> inventoryNotEnoughList(SysUser user) {
List<TErpGoodsVO> list = this.baseMapper.inventoryNotEnoughList(user);
+ List<String> typeIds = list.stream().map(TErpGoodsVO::getTypeId).collect(Collectors.toList());
+ if(!typeIds.isEmpty()){
+ List<TErpGoodsType> typeList = erpGoodsTypeMapper.selectBatchIds(typeIds);
+ for (TErpGoodsVO tErpGoodsVO : list) {
+ typeList.stream().filter(t -> t.getId().equals(tErpGoodsVO.getTypeId())).findFirst().ifPresent(t -> tErpGoodsVO.setTypeName(t.getTypeName()));
+ }
+ }
+ List<String> supplierClinicId = list.stream().filter(e->e.getGoodsSource()==1).map(TErpGoodsVO::getSupplierClinicId).collect(Collectors.toList());
+ if(!supplierClinicId.isEmpty()){
+ List<TCrmSupplier> crmSuppliers = crmSupplierMapper.selectBatchIds(supplierClinicId);
+ for (TErpGoodsVO tErpGoodsVO : list) {
+ crmSuppliers.stream().filter(t -> t.getId().equals(tErpGoodsVO.getSupplierClinicId())).findFirst().ifPresent(t -> tErpGoodsVO.setSupplierName(t.getSupplierName()));
+ }
+ }
- return null;
+ return list;
}
@Override
- public String addProcurement(String clinicSupplierId, SysUser user, List<AddProcurementDto> dtos) {
+ @Transactional(rollbackFor = Exception.class, propagation = Propagation.REQUIRED)
+ public void addProcurement(String clinicSupplierId, SysUser user, List<AddProcurementDto> dtos) {
List<String> goodsIds = dtos.stream().map(AddProcurementDto::getGoodsId).collect(Collectors.toList());
List<TErpGoods> tErpGoods = erpGoodsMapper.selectBatchIds(goodsIds);
for (AddProcurementDto dto : dtos) {
TErpGoods tErpGoodsVO = tErpGoods.stream().filter(t -> t.getId().equals(dto.getGoodsId())).findFirst().get();
+ dto.setPlatformCommissionPrice(tErpGoodsVO.getPlatformCommissionPrice());
dto.setSupplierId(tErpGoodsVO.getSupplierClinicId());
- dto.setGoodsSalesAmount(tErpGoodsVO.getSalesAmount());
+ dto.setGoodsSalesAmount(tErpGoodsVO.getClinicPurchasePrice());
+ if(dto.getSalesAmount()==null){
+ dto.setSalesAmount(tErpGoodsVO.getClinicPurchasePrice());
+ }
}
// 供应商分组
Map<String, List<AddProcurementDto>> supplierClinicIdListMap = dtos.stream().collect(Collectors.groupingBy(AddProcurementDto::getSupplierId));
@@ -264,14 +303,25 @@
tErpProcurement.setTermNo(supplier.getTermNo());
tErpProcurement.setMerchantNo(supplier.getRecvMerchantNo());
- tErpProcurement.setPayMoney(value.stream().map(AddProcurementDto::getSalesAmount).reduce(BigDecimal.ZERO, BigDecimal::add));
+ tErpProcurement.setCreateId(user.getUserId().toString());
+
+ BigDecimal all = BigDecimal.ZERO;
+
+ for (AddProcurementDto addProcurementDto : value) {
+ BigDecimal multiply = addProcurementDto.getSalesAmount().multiply(BigDecimal.valueOf(addProcurementDto.getPurchaseCount()));
+ all = all.add(multiply);
+ }
+ tErpProcurement.setPayMoney(all);
AddProcurementDto addProcurementDto = value.get(0);
if(addProcurementDto.getState()!=null && addProcurementDto.getState()==1){
tErpProcurement.setStatus(1);
}else {
tErpProcurement.setStatus(2);
}
- this.save(tErpProcurement);
+ ArrayList<TErpProcurementGoods> tErpProcurementGoods1 = new ArrayList<>();
+
+ BigDecimal add =BigDecimal.ZERO;
+
for (AddProcurementDto dto : value) {
TErpProcurementGoods tErpProcurementGoods = new TErpProcurementGoods();
tErpProcurementGoods.setProcurementId(tErpProcurement.getId());
@@ -285,15 +335,56 @@
tErpProcurementGoods.setUnitName(tErpGoodsUnit.getUnitName());
tErpProcurementGoods.setPurchasePrice(dto.getGoodsSalesAmount());
tErpProcurementGoods.setSalesAmount(dto.getSalesAmount());
+ tErpProcurementGoods.setTotalPrice(dto.getSalesAmount().multiply(new BigDecimal(dto.getPurchaseCount())));
tErpProcurementGoods.setPurchaseCount(dto.getPurchaseCount());
tErpProcurementGoods.setSupplierId(supplierClinicId);
tErpProcurementGoods.setRecvMerchantNo(supplier.getRecvMerchantNo());
+ tErpProcurementGoods.setSupplierMoney(dto.getSalesAmount().subtract(dto.getPlatformCommissionPrice()));
+ if(tErpProcurementGoods.getSupplierMoney().doubleValue()<0){
+ throw new RuntimeException("平台抽成不能大于售卖价格");
+ }
+ add = add.add(dto.getPlatformCommissionPrice().multiply(BigDecimal.valueOf(dto.getPurchaseCount())));
+ tErpProcurementGoods1.add(tErpProcurementGoods);
}
+ BigDecimal bigDecimal = tErpProcurement.getPayMoney().multiply(BigDecimal.valueOf(0.0038)).setScale(2, RoundingMode.HALF_UP);
+ tErpProcurement.setMoney(add.subtract(bigDecimal));
+ if(tErpProcurement.getMoney().doubleValue()<0){
+ throw new RuntimeException("金额设置错误，请联系平台管理员");
+ }
+ this.save(tErpProcurement);
+ tErpProcurementGoods1.forEach(e->e.setProcurementId(tErpProcurement.getId()));
+ erpProcurementGoodsService.saveBatch(tErpProcurementGoods1);
}
- return "";
+ }
+
+ @Override
+ public DetailProcurementVO detailProcurement(String clinicSupplierId, SysUser user, String id) {
+ DetailProcurementVO detailProcurementVO = new DetailProcurementVO();
+ TErpProcurement tErpProcurement = this.getById(id);
+ detailProcurementVO.setStatus(tErpProcurement.getStatus());
+ detailProcurementVO.setCreateTime(tErpProcurement.getCreateTime());
+ detailProcurementVO.setSendTime(tErpProcurement.getSendTime());
+ TCrmSupplier supplier = crmSupplierMapper.selectById(tErpProcurement.getSupplierId());
+ detailProcurementVO.setSupplierName(supplier.getSupplierName());
+ detailProcurementVO.setUserName(sysUserMapper.selectUserById(Long.valueOf(tErpProcurement.getCreateId())).getUserName());
+ List<TErpProcurementGoods> list = erpProcurementGoodsService.list(new QueryWrapper<TErpProcurementGoods>().eq("procurement_id", id));
+ ArrayList<DetailProcurementNextVO> detailProcurementNextVOS = new ArrayList<>();
+ for (TErpProcurementGoods tErpProcurementGoods : list) {
+ DetailProcurementNextVO detailProcurementNextVO = new DetailProcurementNextVO();
+ detailProcurementNextVO.setGoodsName(tErpProcurementGoods.getGoodsName());
+ detailProcurementNextVO.setQuasiNumber(tErpProcurementGoods.getQuasiNumber());
+ detailProcurementNextVO.setPackingUnitName(tErpProcurementGoods.getUnitName());
+ detailProcurementNextVO.setSalesAmount(tErpProcurementGoods.getSalesAmount());
+ detailProcurementNextVO.setNum(tErpProcurementGoods.getPurchaseCount());
+ detailProcurementNextVO.setTotalPrice(tErpProcurement.getPayMoney());
+ detailProcurementNextVO.setId(tErpProcurementGoods.getId());
+ detailProcurementNextVOS.add(detailProcurementNextVO);
+ }
+ detailProcurementVO.setList(detailProcurementNextVOS);
+ return detailProcurementVO;
}
}
--
Gitblit v1.7.1