package cn.iocoder.yudao.module.wms.dal.mysql.home;
|
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.math.BigDecimal;
|
import java.time.LocalDateTime;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* WMS 首页统计 Mapper
|
*
|
* @author 芋道源码
|
*/
|
@Mapper
|
public interface WmsHomeStatisticsMapper {
|
|
/**
|
* 按单据类型和状态统计单据数量
|
*
|
* @param warehouseId 仓库编号
|
* @return [{ "orderType": 1, "status": 0, "count": 5 }, ...]
|
*/
|
List<Map<String, Object>> selectOrderCountGroupByTypeAndStatus(@Param("warehouseId") Long warehouseId);
|
|
/**
|
* 按天聚合单据数量
|
*
|
* @param beginTime >= 开始时间
|
* @param endTime < 结束时间
|
* @param warehouseId 仓库编号
|
* @return [{ "date": "2026-05-14", "orderType": 1, "count": 5 }, ...]
|
*/
|
List<Map<String, Object>> selectDailyOrderTrend(@Param("beginTime") LocalDateTime beginTime,
|
@Param("endTime") LocalDateTime endTime,
|
@Param("warehouseId") Long warehouseId);
|
|
/**
|
* 统计库存总数量
|
*
|
* @param warehouseId 仓库编号
|
* @return 库存总数量
|
*/
|
BigDecimal selectInventoryTotalQuantity(@Param("warehouseId") Long warehouseId);
|
|
/**
|
* 按商品统计库存数量排行
|
*
|
* @param warehouseId 仓库编号
|
* @param limit 数量限制
|
* @return [{ "id": 1, "name": "A4 复印纸", "quantity": 100 }, ...]
|
*/
|
List<Map<String, Object>> selectInventoryItemRank(@Param("warehouseId") Long warehouseId,
|
@Param("limit") Integer limit);
|
|
/**
|
* 按仓库统计库存数量排行
|
*
|
* @param warehouseId 仓库编号
|
* @param limit 数量限制
|
* @return [{ "id": 1, "name": "上海仓", "quantity": 100 }, ...]
|
*/
|
List<Map<String, Object>> selectInventoryWarehouseRank(@Param("warehouseId") Long warehouseId,
|
@Param("limit") Integer limit);
|
|
}
|
