From bec9ef7332b0c0d1afc9b28918748efc63a60bcc Mon Sep 17 00:00:00 2001 From: xuhy <3313886187@qq.com> Date: 星期一, 03 四月 2023 08:42:00 +0800 Subject: [PATCH] 首页数据统计 --- management/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/TOrderMapper.java | 27 +++++++++++++++++++++++++++ 1 files changed, 27 insertions(+), 0 deletions(-) diff --git a/management/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/TOrderMapper.java b/management/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/TOrderMapper.java index 9a2e7bb..13c22e2 100644 --- a/management/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/TOrderMapper.java +++ b/management/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/TOrderMapper.java @@ -1,11 +1,15 @@ package com.stylefeng.guns.modular.system.dao; +import com.stylefeng.guns.modular.system.controller.resp.DataStatisticsOrderYearResp; +import com.stylefeng.guns.modular.system.controller.resp.PerformanceTableResp; import com.stylefeng.guns.modular.system.controller.resp.TOrderResp; +import com.stylefeng.guns.modular.system.controller.resp.TOrderServerResp; import com.stylefeng.guns.modular.system.model.TOrder; import com.baomidou.mybatisplus.mapper.BaseMapper; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; +import java.time.LocalDate; import java.util.List; /** @@ -35,4 +39,27 @@ @Param("source") Integer source,@Param("userName")String userName, @Param("userPhone")String userPhone, @Param("state")Integer state,@Param("driverName")String driverName,@Param("isException") Integer isException, @Param("roleType")Integer roleType,@Param("objectId")Integer objectId); + + /** + * 通过年份查询订单数量 + * @param agentId + * @return + */ + List<DataStatisticsOrderYearResp> getDataStatisticsByYear(@Param("agentId") Integer agentId,@Param("yearDate")String yearDate); + + /** + * 单量 + * @param agentId + * @param monthDate + * @return + */ + List<PerformanceTableResp> getDataStatisticsOrderCount(@Param("agentId")Integer agentId, @Param("monthDate")String monthDate); + + Integer getDataStatisticsCount(@Param("agentId")Integer agentId, @Param("type")Integer type, @Param("localDate")LocalDate localDate); + + Integer getDataStatisticsServerCount(@Param("agentId")Integer agentId, @Param("localDate") LocalDate localDate); + + List<TOrderServerResp> getDataStatisticsServerList(@Param("agentId")Integer agentId,@Param("localDate") LocalDate localDate); + + List<TOrder> getDataStatisticsAllList(@Param("agentId")Integer agentId,@Param("localDate") LocalDate localDate); } -- Gitblit v1.7.1