package com.ruoyi.consumables.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.ruoyi.consumables.dto.ConsumablesInRecordDto;
|
import com.ruoyi.consumables.dto.ConsumablesInventoryDto;
|
import com.ruoyi.consumables.execl.ConsumablesInventoryExportData;
|
import com.ruoyi.consumables.pojo.ConsumablesInventory;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.math.BigDecimal;
|
import java.time.LocalDate;
|
import java.time.LocalDateTime;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* <p>
|
* 库存表 Mapper 接口
|
* </p>
|
*
|
* @author 芯导软件（江苏）有限公司
|
* @since 2026-01-21 04:16:36
|
*/
|
@Mapper
|
public interface ConsumablesInventoryMapper extends BaseMapper<ConsumablesInventory> {
|
|
IPage<ConsumablesInventoryDto> pageConsumablesInventory(Page page, @Param("ew") ConsumablesInventoryDto ConsumablesInventoryDto);
|
|
|
int updateAddConsumablesInventory(@Param("ew") ConsumablesInventoryDto ConsumablesInventoryDto);
|
|
int updateSubtractConsumablesInventory(@Param("ew") ConsumablesInventoryDto ConsumablesInventoryDto);
|
|
List<ConsumablesInventoryExportData> listConsumablesInventoryExportData(@Param("ew") ConsumablesInventoryDto ConsumablesInventoryDto);
|
|
IPage<ConsumablesInRecordDto> ConsumablesInventoryPage(@Param("ew") ConsumablesInventoryDto ConsumablesInventoryDto, Page page);
|
|
IPage<ConsumablesInventoryDto> ConsumablesInAndOutRecord(@Param("ew") ConsumablesInventoryDto ConsumablesInventoryDto, Page page);
|
|
BigDecimal selectTotal();
|
|
int selectStorageProductCountByDate(@Param("startDate") LocalDateTime startDate, @Param("endDate") LocalDateTime endDate);
|
|
List<Map<String, Object>> selectDailyConsumablesInCounts(@Param("rootCategoryId") Long rootCategoryId, @Param("startDate") String startDate, @Param("endDate") String endDate);
|
|
List<Map<String, Object>> selectDailyConsumablesOutCounts(@Param("rootCategoryId") Long rootCategoryId, @Param("startDate") String startDate, @Param("endDate") String endDate);
|
|
BigDecimal selectTotalByDate(@Param("now") LocalDate now);
|
}
|
