package com.ruoyi.consumables.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.bean.BeanUtils; import com.ruoyi.common.utils.poi.ExcelUtil; import com.ruoyi.consumables.dto.ConsumablesInRecordDto; import com.ruoyi.consumables.dto.ConsumablesInventoryDto; import com.ruoyi.consumables.dto.ConsumablesUnInventoryDto; import com.ruoyi.consumables.execl.ConsumablesInRecordExportData; import com.ruoyi.consumables.mapper.ConsumablesInRecordMapper; import com.ruoyi.consumables.mapper.ConsumablesInventoryMapper; import com.ruoyi.consumables.mapper.ConsumablesUnInventoryMapper; import com.ruoyi.consumables.pojo.ConsumablesInRecord; import com.ruoyi.consumables.pojo.ConsumablesInventory; import com.ruoyi.consumables.pojo.ConsumablesUnInventory; import com.ruoyi.consumables.service.ConsumablesInRecordService; import lombok.AllArgsConstructor; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import javax.servlet.http.HttpServletResponse; import java.util.List; @Service @AllArgsConstructor public class ConsumablesInRecordServiceImpl extends ServiceImpl implements ConsumablesInRecordService { private ConsumablesInRecordMapper consumablesInRecordMapper; private ConsumablesInventoryMapper consumablesInventoryMapper; private ConsumablesUnInventoryMapper consumablesUnInventoryMapper; @Override public IPage listPage(Page page, ConsumablesInRecordDto consumablesInRecordDto) { return consumablesInRecordMapper.listPage(page, consumablesInRecordDto); } // 新增入库 @Override @Transactional(rollbackFor = Exception.class) public int add(ConsumablesInRecordDto consumablesInRecordDto) { String no = OrderUtils.countTodayByCreateTime(consumablesInRecordMapper, "RK"); consumablesInRecordDto.setInboundBatches(no); ConsumablesInRecord consumablesInRecord = new ConsumablesInRecord(); BeanUtils.copyProperties(consumablesInRecordDto, consumablesInRecord); return consumablesInRecordMapper.insert(consumablesInRecord); } @Override @Transactional(rollbackFor = Exception.class) public int update(Long id, ConsumablesInRecordDto consumablesInRecordDto) { // 判断对象是否存在 ConsumablesInRecord consumablesInRecord = consumablesInRecordMapper.selectById(id); if (consumablesInRecord == null){ throw new BaseException("该入库记录不存在,无法更新!!!"); } String[] ignoreProperties = {"id", "inbound_batches"};//排除id属性 BeanUtils.copyProperties(consumablesInRecordDto, consumablesInRecord, ignoreProperties); return consumablesInRecordMapper.updateById(consumablesInRecord); } @Override @Transactional(rollbackFor = Exception.class) public int batchDelete(List ids) { for (Long id : ids) { ConsumablesInRecord consumablesInRecord = consumablesInRecordMapper.selectById(id); if (consumablesInRecord.getType().equals("0")) { ConsumablesInventory consumablesInventory = consumablesInventoryMapper.selectOne(new LambdaQueryWrapper().eq(ConsumablesInventory::getProductModelId, consumablesInRecord.getProductModelId())); if (consumablesInventory == null) { throw new BaseException("库存记录中没有对应的产品,无法删除!!!"); }else { ConsumablesInventoryDto consumablesInRecordDto = new ConsumablesInventoryDto(); consumablesInRecordDto.setProductModelId(consumablesInventory.getProductModelId()); consumablesInRecordDto.setQualitity(consumablesInRecord.getConsumablesInNum()); consumablesInventoryMapper.updateSubtractConsumablesInventory(consumablesInRecordDto); } }else if (consumablesInRecord.getType().equals("1")) { ConsumablesUnInventory consumablesUnInventory = consumablesUnInventoryMapper.selectOne(new LambdaQueryWrapper().eq(ConsumablesUnInventory::getProductModelId, consumablesInRecord.getProductModelId())); if (consumablesUnInventory == null) { throw new BaseException("库存记录中没有对应的产品,无法删除!!!"); }else { ConsumablesUnInventoryDto consumablesUnInventoryDto = new ConsumablesUnInventoryDto(); consumablesUnInventoryDto.setProductModelId(consumablesUnInventory.getProductModelId()); consumablesUnInventoryDto.setQualitity(consumablesInRecord.getConsumablesInNum()); consumablesUnInventoryMapper.updateSubtractConsumablesUnInventory(consumablesUnInventoryDto); } } } return consumablesInRecordMapper.deleteBatchIds(ids); } @Override public void exportConsumablesInRecord(HttpServletResponse response, ConsumablesInRecordDto consumablesInRecordDto) { List list = consumablesInRecordMapper.listConsumablesInRecordExportData(consumablesInRecordDto); for (ConsumablesInRecordExportData consumablesInRecordExportData : list) { if (consumablesInRecordExportData.getType().equals("0")) { consumablesInRecordExportData.setRecordType(EnumUtil.fromCode(StockOutQualifiedRecordTypeEnum.class, Integer.parseInt(consumablesInRecordExportData.getRecordType())).getValue()); }else { consumablesInRecordExportData.setRecordType(EnumUtil.fromCode(StockInUnQualifiedRecordTypeEnum.class, Integer.parseInt(consumablesInRecordExportData.getRecordType())).getValue()); } } ExcelUtil util = new ExcelUtil<>(ConsumablesInRecordExportData.class); util.exportExcel(response,list, "入库记录信息"); } }