package com.ruoyi.stock.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.common.enums.StockInUnQualifiedRecordTypeEnum; import com.ruoyi.common.enums.StockOutQualifiedRecordTypeEnum; import com.ruoyi.common.exception.base.BaseException; import com.ruoyi.common.utils.EnumUtil; import com.ruoyi.common.utils.OrderUtils; import com.ruoyi.common.utils.SecurityUtils; import com.ruoyi.common.utils.bean.BeanUtils; import com.ruoyi.common.utils.poi.ExcelUtil; import com.ruoyi.framework.security.LoginUser; import com.ruoyi.stock.dto.StockInRecordDto; import com.ruoyi.stock.dto.StockInventoryDto; import com.ruoyi.stock.dto.StockUninventoryDto; import com.ruoyi.stock.execl.StockInRecordExportData; import com.ruoyi.stock.mapper.StockInRecordMapper; import com.ruoyi.stock.mapper.StockInventoryMapper; import com.ruoyi.stock.mapper.StockUninventoryMapper; import com.ruoyi.stock.pojo.StockInRecord; import com.ruoyi.stock.pojo.StockInventory; import com.ruoyi.stock.pojo.StockUninventory; import com.ruoyi.stock.service.StockInRecordService; import com.ruoyi.stock.service.StockInventoryService; 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.List; @Service public class StockInRecordServiceImpl extends ServiceImpl implements StockInRecordService { @Autowired private StockInRecordMapper stockInRecordMapper; @Autowired private StockInventoryMapper stockInventoryMapper; @Autowired private StockUninventoryMapper stockUninventoryMapper; @Autowired private StockInventoryService stockInventoryService; @Override public IPage listPage(Page page, StockInRecordDto stockInRecordDto) { return stockInRecordMapper.listPage(page, stockInRecordDto); } // 新增入库 @Override @Transactional(rollbackFor = Exception.class) public Long add(StockInRecordDto stockInRecordDto) { String no = OrderUtils.countTodayByCreateTime(stockInRecordMapper, "RK"); stockInRecordDto.setInboundBatches(no); StockInRecord stockInRecord = new StockInRecord(); BeanUtils.copyProperties(stockInRecordDto, stockInRecord); int insertRows = stockInRecordMapper.insert(stockInRecord); Long insertId = stockInRecord.getId(); // 替换为你的实际主键字段:getRecordId()/getInboundId() 等 return insertRows > 0 ? insertId : null; } @Override @Transactional(rollbackFor = Exception.class) public int update(Long id, StockInRecordDto stockInRecordDto) { // 判断对象是否存在 StockInRecord stockInRecord = stockInRecordMapper.selectById(id); if (stockInRecord == null) { throw new BaseException("该入库记录不存在,无法更新!!!"); } String[] ignoreProperties = {"id", "inbound_batches"};//排除id属性 BeanUtils.copyProperties(stockInRecordDto, stockInRecord, ignoreProperties); return stockInRecordMapper.updateById(stockInRecord); } @Override @Transactional(rollbackFor = Exception.class) public int batchDelete(List ids) { for (Long id : ids) { StockInRecord stockInRecord = stockInRecordMapper.selectById(id); if (stockInRecord.getType().equals("0")) { StockInventory stockInventory = stockInventoryMapper.selectOne(new LambdaQueryWrapper().eq(StockInventory::getProductModelId, stockInRecord.getProductModelId())); if (stockInventory == null) { throw new BaseException("库存记录中没有对应的产品,无法删除!!!"); } else { StockInventoryDto stockInRecordDto = new StockInventoryDto(); stockInRecordDto.setProductModelId(stockInventory.getProductModelId()); stockInRecordDto.setQualitity(stockInRecord.getStockInNum()); stockInventoryMapper.updateSubtractStockInventory(stockInRecordDto); } } else if (stockInRecord.getType().equals("1")) { StockUninventory stockUninventory = stockUninventoryMapper.selectOne(new LambdaQueryWrapper().eq(StockUninventory::getProductModelId, stockInRecord.getProductModelId())); if (stockUninventory == null) { throw new BaseException("库存记录中没有对应的产品,无法删除!!!"); } else { StockUninventoryDto stockUninventoryDto = new StockUninventoryDto(); stockUninventoryDto.setProductModelId(stockUninventory.getProductModelId()); stockUninventoryDto.setQualitity(stockInRecord.getStockInNum()); stockUninventoryMapper.updateSubtractStockUnInventory(stockUninventoryDto); } } } return stockInRecordMapper.deleteBatchIds(ids); } @Override public void exportStockInRecord(HttpServletResponse response, StockInRecordDto stockInRecordDto) { List list = stockInRecordMapper.listStockInRecordExportData(stockInRecordDto); for (StockInRecordExportData stockInRecordExportData : list) { if (stockInRecordExportData.getType().equals("0")) { stockInRecordExportData.setRecordType(EnumUtil.fromCode(StockOutQualifiedRecordTypeEnum.class, Integer.parseInt(stockInRecordExportData.getRecordType())).getValue()); } else { stockInRecordExportData.setRecordType(EnumUtil.fromCode(StockInUnQualifiedRecordTypeEnum.class, Integer.parseInt(stockInRecordExportData.getRecordType())).getValue()); } } ExcelUtil util = new ExcelUtil<>(StockInRecordExportData.class); util.exportExcel(response, list, "入库记录信息"); } @Override public StockInRecordDto selectByRecord(Long id) { return stockInRecordMapper.selectByRecord(id); } @Override public int updateStockInRecord(StockInRecordDto stockInRecordDto) { LoginUser loginUser = SecurityUtils.getLoginUser(); try { stockInventoryService.addApproveByPurchase(loginUser, stockInRecordDto,stockInRecordDto.getId()); } catch (Exception e) { e.printStackTrace(); } stockInRecordDto.setApproveStatus(2); return stockInRecordMapper.updateById(stockInRecordDto); } }