From 08cb7e0bdd27178c9c73159a0d000d78b3045aed Mon Sep 17 00:00:00 2001
From: xuhy <3313886187@qq.com>
Date: 星期四, 08 六月 2023 19:10:35 +0800
Subject: [PATCH] 司机选择区域不限制，车辆地图定时刷新
---
management/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/TOrderMapper.java | 150 ++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 150 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 0b99902..c8d56b5 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,7 +1,18 @@
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.math.BigDecimal;
+import java.time.LocalDate;
+import java.util.Date;
+import java.util.List;
/**
* <p>
@@ -11,6 +22,145 @@
* @author stylefeng
* @since 2023-02-15
*/
+@Mapper
public interface TOrderMapper extends BaseMapper<TOrder> {
+ /**
+ * 查询订单列表
+ * @param startTime
+ * @param endTime
+ * @param code
+ * @param source
+ * @param userName
+ * @param userPhone
+ * @param state
+ * @param driverName
+ * @return
+ */
+ List<TOrderResp> getOrderList(@Param("startTime") String startTime,@Param("endTime")String endTime, @Param("code") String code,
+ @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);
+
+ /**
+ * 今日非服务中统计
+ * @param agentId
+ * @param type
+ * @param localDate
+ * @return
+ */
+ Integer getDataStatisticsCount(@Param("agentId")Integer agentId, @Param("type")Integer type, @Param("localDate")LocalDate localDate);
+
+ /**
+ * 今日服务中统计
+ * @param agentId
+ * @param localDate
+ * @return
+ */
+ Integer getDataStatisticsServerCount(@Param("agentId")Integer agentId, @Param("localDate") LocalDate localDate);
+
+ /**
+ * 查询今日服务中的订单列表
+ * @param agentId
+ * @param localDate
+ * @return
+ */
+ List<TOrderServerResp> getDataStatisticsServerList(@Param("agentId")Integer agentId,@Param("localDate") LocalDate localDate);
+
+ /**
+ * 查询今日所有列表
+ * @param agentId
+ * @param localDate
+ * @return
+ */
+ List<TOrder> getDataStatisticsAllList(@Param("agentId")Integer agentId,@Param("type") Integer type,@Param("localDate") LocalDate localDate);
+
+ /**
+ * 广东省今日所有区域非服务中查询
+ * @param ids
+ * @param type
+ * @param localDate
+ * @return
+ */
+ Integer getDataStatisticsCountByIds(@Param("ids")List<Integer> ids, @Param("type")Integer type, @Param("localDate")LocalDate localDate);
+
+ /**
+ * 广东省今日服务中查询
+ * @param ids
+ * @param localDate
+ * @return
+ */
+ Integer getDataStatisticsServerCountByIds(@Param("ids")List<Integer> ids, @Param("localDate")LocalDate localDate);
+
+ /**
+ * 广东省今日服务中列表
+ * @param ids
+ * @param localDate
+ * @return
+ */
+ List<TOrderServerResp> getDataStatisticsServerListByIds(@Param("ids")List<Integer> ids, @Param("localDate")LocalDate localDate);
+
+ /**
+ * 广东省今日所有列表
+ * @param ids
+ * @param localDate
+ * @return
+ */
+ List<TOrder> getDataStatisticsAllListByIds(@Param("ids")List<Integer> ids,@Param("type")Integer type, @Param("localDate")LocalDate localDate);
+
+ /**
+ * 通过年份查询订单数量（广东）
+ * @param ids
+ * @param yearDate
+ * @return
+ */
+ List<DataStatisticsOrderYearResp> getDataStatisticsByYearByIds(@Param("ids")List<Integer> ids, @Param("yearDate")String yearDate);
+
+ /**
+ * 业绩排名单量（广东）
+ * @param ids
+ * @param monthDate
+ * @return
+ */
+ List<PerformanceTableResp> getDataStatisticsOrderCountByIds(@Param("ids")List<Integer> ids, @Param("monthDate")String monthDate);
+
+ /**
+ * 查询本月订单
+ * @param agentId
+ * @param dayDate
+ * @return
+ */
+ List<DataStatisticsOrderYearResp> getStatisticsOrderByMonth(@Param("agentId")Integer agentId, @Param("dayDate")String dayDate);
+
+ /**
+ * 查询本月订单广东
+ * @param ids
+ * @param dayDate
+ * @return
+ */
+ List<DataStatisticsOrderYearResp> getStatisticsOrderByMonthIds(@Param("ids")List<Integer> ids, @Param("dayDate")String dayDate);
+
+ /**
+ * 查询司机当月有效订单数量
+ * @param driverId
+ * @param orderMoney
+ * @param month
+ * @return
+ */
+ Integer getValidOrderCount(@Param("driverId") Integer driverId,@Param("orderMoney") BigDecimal orderMoney, @Param("month")String month);
}
--
Gitblit v1.7.1