批量添加入库的方法

lishenao

16 小时以前 6bbac4845106ca8648900b1d9af758c84275ffee

 src/main/java/com/ruoyi/inventory/service/impl/StockManagementServiceImpl.java

@@ -1,25 +1,42 @@
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.excel.SupplierManageExcelDto;
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.dto.ProductRecordDto;
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 org.springframework.transaction.annotation.Transactional;

import javax.servlet.http.HttpServletResponse;
import java.util.Date;
import java.util.List;

@Service
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 int updateStockManagement(StockManagement stockManagement) {
@@ -43,4 +60,59 @@
        ExcelUtil<StockManagementExcelDto> util = new ExcelUtil<StockManagementExcelDto>(StockManagementExcelDto.class);
        util.exportExcel(response, stockManageList, "库存导出");
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public int stockout(StockManagement stockManagement) {
//        在前端其实就穿了3个数，数量，出库人，时间，只需要进行判断，库存数量是否足够即可,有三种情况
        StockOut stockOut = new StockOut();
        LambdaQueryWrapper<StockManagement> queryWrapper = new LambdaQueryWrapper<>();
        queryWrapper.eq(StockManagement::getId, stockManagement.getId());
        StockManagement stockManagement1 = stockManagementMapper.selectOne(queryWrapper);
        if (stockManagement1.getStockQuantity() < stockManagement.getStockQuantity()) {
            throw new RuntimeException("库存数量不足");
        } else if (stockManagement1.getStockQuantity() > stockManagement.getStockQuantity()) {
            stockManagement1.setStockQuantity(stockManagement1.getStockQuantity() - stockManagement.getStockQuantity());
            stockManagementMapper.updateById(stockManagement1);
        }
        else {
            stockManagementMapper.deleteById(stockManagement.getId());
        }
        stockOut.setProductrecordId(stockManagement1.getProductrecordId());
        stockOut.setInboundTime(stockManagement.getBoundTime());
//            出库批次自动生成
        String batchCode = "CK" + System.currentTimeMillis();
        stockOut.setInboundBatch(batchCode);
        stockOut.setSupplierId(stockManagement1.getSupplierId());
        stockOut.setInboundQuantity(stockManagement.getStockQuantity());
        stockOut.setUserId(stockManagement.getUserId());
        return stockOutMapper.insert(stockOut);
    }

//    添加库存方法
    @Override
    public int addStockManage(StockManagement stockManagement) {
//        需要先判断采购记录表中是否有该产品的采购记录
        LambdaQueryWrapper<ProductRecord> queryWrapper1 = new LambdaQueryWrapper<>();
        queryWrapper1.eq(ProductRecord::getId, stockManagement.getProductrecordId());
        ProductRecord productRecord = productRecordMapper.selectOne(queryWrapper1);
        ProductRecordDto productRecordDto = productRecordMapper.selectProductRecordById(productRecord.getId());
        if (productRecordDto!= null) {
            stockManagement.setProductrecordId(productRecordDto.getId());
            stockManagement.setBoundTime(stockManagement.getBoundTime());
            stockManagement.setSupplierId(productRecordDto.getSupplierId());
            stockManagement.setStockQuantity(stockManagement.getStockQuantity());
            stockManagement.setUserId(stockManagement.getUserId());
            return stockManagementMapper.insert(stockManagement);
        }else {
            throw new RuntimeException("采购记录表中没有该产品的采购记录");
        }
    }

    @Override
    public StockManagement getStockManageById(Long id) {
        return stockManagementMapper.selectById(id);
    }


}