src/main/java/com/ruoyi/home/service/impl/HomeServiceImpl.java
@@ -185,15 +185,8 @@ // 获取当天入库数量 LambdaQueryWrapper<ProcurementRecordStorage> procurementRecordStorageLambdaQueryWrapper = new LambdaQueryWrapper<>(); procurementRecordStorageLambdaQueryWrapper.ge(ProcurementRecordStorage::getCreateTime, now) // 大于等于当天 .lt(ProcurementRecordStorage::getCreateTime, now.plusDays(1)); // 小于明天 List<ProcurementRecordStorage> procurementRecordStorages1 = procurementRecordStorageMapper.selectList(procurementRecordStorageLambdaQueryWrapper); BigDecimal stockAmount1 = procurementRecordStorages1.stream() .map(ProcurementRecordStorage::getInboundNum) .filter(Objects::nonNull) .reduce(BigDecimal.ZERO, BigDecimal::add); homeBusinessDto.setTodayInventoryNum(stockAmount1.setScale(2, RoundingMode.HALF_UP).toString()); BigDecimal bigDecimal = stockInventoryMapper.selectTotalByDate(LocalDate.now()); homeBusinessDto.setTodayInventoryNum(bigDecimal.setScale(2, RoundingMode.HALF_UP).toString()); return homeBusinessDto; }
@@ -433,6 +433,7 @@ //批量删除检验标准 LambdaQueryWrapper<QualityInspect> materialInspectLambdaQueryWrapper = new LambdaQueryWrapper<>(); materialInspectLambdaQueryWrapper.in(QualityInspect::getPurchaseLedgerId, ids); List<QualityInspect> qualityInspects = qualityInspectMapper.selectList(materialInspectLambdaQueryWrapper); qualityInspects.stream().forEach(qualityInspect -> { if (ObjectUtils.isNotEmpty(qualityInspect.getInspectState())&&qualityInspect.getInspectState().equals(1)) { src/main/java/com/ruoyi/quality/controller/QualityInspectController.java
@@ -2,10 +2,12 @@ import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.ruoyi.common.enums.StockQualifiedRecordTypeEnum; import com.ruoyi.framework.web.domain.AjaxResult; import com.ruoyi.procurementrecord.pojo.ProcurementRecordStorage; import com.ruoyi.procurementrecord.service.ProcurementRecordService; import com.ruoyi.procurementrecord.service.impl.ProcurementRecordServiceImpl; import com.ruoyi.procurementrecord.utils.StockUtils; import com.ruoyi.quality.dto.QualityInspectDto; import com.ruoyi.quality.pojo.QualityInspect; import com.ruoyi.quality.pojo.QualityInspectFile; @@ -40,6 +42,8 @@ private IQualityInspectFileService qualityInspectFileService; @Autowired private ProcurementRecordService procurementRecordService; @Autowired private StockUtils stockUtils; /** @@ -69,7 +73,9 @@ qualityInspectFileService.remove(Wrappers.<QualityInspectFile>lambdaQuery() .in(QualityInspectFile::getInspectId,ids)); //删除入库记录 procurementRecordService.remove(Wrappers.<ProcurementRecordStorage>lambdaQuery().in(ProcurementRecordStorage::getQualityInspectId,ids)); for (Integer id : ids) { stockUtils.deleteStockRecord(Long.valueOf(id), StockQualifiedRecordTypeEnum.QUALITYINSPECT_STOCK_IN.getCode()); } //删除检验单 return AjaxResult.success(qualityInspectService.removeBatchByIds(ids)); } src/main/java/com/ruoyi/stock/mapper/StockInventoryMapper.java
@@ -11,6 +11,7 @@ import org.apache.ibatis.annotations.Param; import java.math.BigDecimal; import java.time.LocalDate; import java.util.List; /** @@ -39,4 +40,5 @@ BigDecimal selectTotal(); BigDecimal selectTotalByDate( @Param("now") LocalDate now); } src/main/resources/mapper/stock/StockInventoryMapper.xml
@@ -188,5 +188,11 @@ select ifnull(sum(qualitity),0) from stock_inventory </select> <select id="selectTotalByDate" resultType="java.math.BigDecimal"> select sum(qualitity) from stock_inventory where create_time >= #{now} and create_time < DATE_ADD(#{now}, INTERVAL 1 DAY) </select> </mapper>
