From d05d46076c62c744cdbd84c84d6e19b42cda9259 Mon Sep 17 00:00:00 2001
From: lishenao <3065849776@qq.com>
Date: 星期三, 02 七月 2025 09:30:15 +0800
Subject: [PATCH] 入库管理，出库管理，库存管理后端接口修改
---
src/main/java/com/ruoyi/inventory/service/impl/StockManagementServiceImpl.java | 109 +++++++++++++++++++++++++++++++++++++++++++-----------
1 files changed, 87 insertions(+), 22 deletions(-)
diff --git a/src/main/java/com/ruoyi/inventory/service/impl/StockManagementServiceImpl.java b/src/main/java/com/ruoyi/inventory/service/impl/StockManagementServiceImpl.java
index 1c5d1e2..a19d90b 100644
--- a/src/main/java/com/ruoyi/inventory/service/impl/StockManagementServiceImpl.java
+++ b/src/main/java/com/ruoyi/inventory/service/impl/StockManagementServiceImpl.java
@@ -1,45 +1,110 @@
package com.ruoyi.inventory.service.impl;
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ruoyi.basic.mapper.SupplierManageMapper;
+import com.ruoyi.basic.pojo.SupplierManage;
+import com.ruoyi.common.utils.poi.ExcelUtil;
+import com.ruoyi.inventory.dto.StockManagementDto;
+import com.ruoyi.inventory.excel.StockManagementExcelDto;
import com.ruoyi.inventory.mapper.StockManagementMapper;
+import com.ruoyi.inventory.mapper.StockOutMapper;
import com.ruoyi.inventory.pojo.StockManagement;
+import com.ruoyi.inventory.pojo.StockOut;
import com.ruoyi.inventory.service.StockManagementService;
+import com.ruoyi.purchase.mapper.ProductRecordMapper;
+import com.ruoyi.purchase.pojo.ProductRecord;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
+import javax.servlet.http.HttpServletResponse;
import java.util.List;
@Service
-public class StockManagementServiceImpl implements StockManagementService {
+public class StockManagementServiceImpl extends ServiceImpl<StockManagementMapper,StockManagement> implements StockManagementService {
@Autowired
private StockManagementMapper stockManagementMapper;
+ @Autowired
+ private StockOutMapper stockOutMapper;
+ @Autowired
+ private ProductRecordMapper productRecordMapper;
+ @Autowired
+ private SupplierManageMapper supplierManageMapper;
- @Override
- public List<StockManagement> getStockManagements() {
- List<StockManagement> stockManagements = stockManagementMapper.selectAll();
- return stockManagements;
- }
- @Override
- public StockManagement getStockManagementById(Long id) {
- StockManagement stockManagement = stockManagementMapper.selectByPrimaryKey(id);
- return stockManagement;
- }
-
- @Override
- public int addStockManagement(StockManagement stockManagement) {
- int i = stockManagementMapper.insertSelective(stockManagement);
- return i;
- }
@Override
public int updateStockManagement(StockManagement stockManagement) {
- int i = stockManagementMapper.updateByPrimaryKeySelective(stockManagement);
- return i;
+ return stockManagementMapper.updateById(stockManagement);
}
@Override
- public int deleteStockManagement(Long id) {
- int i = stockManagementMapper.deleteByPrimaryKey(id);
- return i;
+ public int delStockManage(List<Integer> ids) {
+ return stockManagementMapper.deleteBatchIds(ids);
+ }
+
+
+ @Override
+ public IPage<StockManagement> selectStockManagePage(Page page, StockManagementDto stockManagementdto) {
+ return stockManagementMapper.selectStockManagementBypage(page, stockManagementdto);
+ }
+
+ @Override
+ public void stockManageExport(HttpServletResponse response, StockManagementDto stockManagementdto) {
+ List<StockManagementExcelDto> stockManageList = stockManagementMapper.stockManageExportList(stockManagementdto);
+ ExcelUtil<StockManagementExcelDto> util = new ExcelUtil<StockManagementExcelDto>(StockManagementExcelDto.class);
+ util.exportExcel(response, stockManageList, "搴撳瓨瀵煎嚭");
+ }
+
+ @Override
+ public int stockout(StockManagement stockManagement) {
+// 闇�瑕佽繘琛屽垽鏂紝搴撳瓨鏁伴噺鏄惁瓒冲
+ StockManagement stockManagement1 = stockManagementMapper.selectById(stockManagement.getId());
+ if (stockManagement1.getStockQuantity() < stockManagement.getStockQuantity()) {
+ throw new RuntimeException("搴撳瓨鏁伴噺涓嶈冻");
+ }else if (stockManagement1.getStockQuantity().equals(stockManagement.getStockQuantity())){
+// 鍑忓幓鐨勬暟閲忚鍦ㄥ嚭搴撹褰曡〃涓姞涓�鏉℃暟鎹�
+ StockOut stockOut = new StockOut();
+ stockOut.setInboundQuantity(stockManagement.getStockQuantity());
+ stockOut.setProductRecordid(stockManagement1.getProductRecordid());
+ stockOut.setSupplierId(stockManagement1.getSupplierId());
+ stockOut.setUserId(stockManagement.getUserId());
+ stockOut.setInboundTime(stockManagement1.getBoundTime());
+ stockOutMapper.insert(stockOut);
+ return stockManagementMapper.deleteById(stockManagement.getId());
+ }
+ else {
+ stockManagement1.setStockQuantity(stockManagement1.getStockQuantity() - stockManagement.getStockQuantity());
+ StockOut stockOut = new StockOut();
+ stockOut.setInboundQuantity(stockManagement.getStockQuantity());
+ stockOut.setProductRecordid(stockManagement1.getProductRecordid());
+ stockOut.setSupplierId(stockManagement1.getSupplierId());
+ stockOut.setUserId(stockManagement.getUserId());
+ stockOut.setInboundTime(stockManagement1.getBoundTime());
+ stockOutMapper.insert(stockOut);
+ return stockManagementMapper.updateById(stockManagement1);
+ }
+ }
+
+// 娣诲姞搴撳瓨鏂规硶
+ @Override
+ public int addStockManage(StockManagement stockManagement) {
+// 闇�瑕佽繘琛屽垽鏂�
+ LambdaQueryWrapper<ProductRecord> queryWrapper1 = new LambdaQueryWrapper<>();
+ queryWrapper1.eq(ProductRecord::getProductId, stockManagement.getProductRecordid());
+ ProductRecord productRecord = productRecordMapper.selectOne(queryWrapper1);
+ if (productRecord == null) {
+ throw new RuntimeException("浜у搧涓嶅瓨鍦�");
+ }
+ LambdaQueryWrapper<SupplierManage> queryWrapper2 = new LambdaQueryWrapper<>();
+ queryWrapper2.eq(SupplierManage::getId, stockManagement.getSupplierId());
+ SupplierManage supplierManage = supplierManageMapper.selectOne(queryWrapper2);
+ System.out.println(supplierManage+"11");
+ if (supplierManage == null) {
+ throw new RuntimeException("渚涘簲鍟嗕笉瀛樺湪");
+ }
+ return stockManagementMapper.insert(stockManagement);
}
}
--
Gitblit v1.9.3