无关风月
4 天以前 1442f149019ee0590389abd7a88a79c4d9b59034
ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/mapper/OrderMapper.java
@@ -27,7 +27,7 @@
     * @param orderState 订单状态
     * @return 本年订单数量
     */
    List<OrderQueryVO> orderCountByYear(@Param("cityList") List<String> cityList, @Param("orderState") Integer orderState);
    List<OrderQueryVO> orderCountByYear(@Param("cityList") List<String> cityList, @Param("orderState") Integer orderState,@Param("siteIds") List<String> siteIds);
    /**
     * 查询本月订单数量
@@ -36,7 +36,7 @@
     * @param orderState 订单状态
     * @return 本年订单数量
     */
    List<OrderQueryVO> orderCountByMonth(@Param("cityList") List<String> cityList, @Param("orderState") Integer orderState);
    List<OrderQueryVO> orderCountByMonth(@Param("cityList") List<String> cityList, @Param("orderState") Integer orderState,@Param("siteIds") List<String> siteIds);
    /**
     * 查询本周订单数量
@@ -45,7 +45,7 @@
     * @param orderState 订单状态
     * @return 本年订单数量
     */
    List<OrderQueryVO> orderCountByWeek(@Param("cityList") List<String> cityList, @Param("orderState") Integer orderState);
    List<OrderQueryVO> orderCountByWeek(@Param("cityList") List<String> cityList, @Param("orderState") Integer orderState,@Param("siteIds") List<String> siteIds);
    /**
     * 查询当天订单数量
@@ -54,7 +54,7 @@
     * @param orderState 订单状态
     * @return 本年订单数量
     */
    List<OrderQueryVO> orderCountByToday(@Param("cityList") List<String> cityList, @Param("orderState") Integer orderState);
    List<OrderQueryVO> orderCountByToday(@Param("cityList") List<String> cityList, @Param("orderState") Integer orderState,@Param("siteIds") List<String> siteIds);
    /**
     * 查询整个季度的交易额(订单状态为:已完工)
@@ -93,7 +93,8 @@
     * @return 分页统计
     */
    Page<OrderCountVO> orderCount(@Param("name") String name, @Param("phone") String phone,
                                  @Param("cityList") List<String> cityList, Page<OrderCountVO> page);
                                  @Param("cityList") List<String> cityList, Page<OrderCountVO> page,
                                  @Param("siteIds") List<String> siteIds);
    /**
     * 订单列表
@@ -103,14 +104,15 @@
     * @return 分页
     */
    Page<Order> queryPage(@Param("data") OrderQueryRequest orderQueryRequest, Page<Order> page);
    Page<Order> queryPage1(@Param("data") OrderQueryRequest orderQueryRequest, Page<Order> page);
    List<Order> excelExportList(@Param("data") OrderQueryRequest orderQueryRequest);
    /**
     * 订单管理分页模块,订单数量统计
     *
     * @param orderQueryRequest 筛选参数
     * @return 统计数量
     */
    List<Order> orderPageCount(@Param("data") OrderQueryRequest orderQueryRequest);
    Order orderPageCount(@Param("data") OrderQueryRequest orderQueryRequest);
    /**
     * 根据所选id查询
@@ -136,7 +138,7 @@
     * @param page   分页
     * @return 交易额
     */
    Page<Order> orderListWorker(@Param("userId") Integer userId, @Param("state") Integer state, Page<Order> page);
    Page<Order> orderListWorker(@Param("userId") Integer userId, @Param("state") Integer state,@Param("searchValues")String searchValues, Page<Order> page);
    /**
     * 师傅端-根据师傅id获取订单数量
@@ -164,7 +166,7 @@
     * @return 列表
     */
    List<OrderQueryVO> orderCountByTimeRange(@Param("cityList") List<String> cityList, @Param("startTime") String startTime,
                                             @Param("endTime") String endTime, @Param("orderState") Integer orderState);
                                             @Param("endTime") String endTime, @Param("orderState") Integer orderState,@Param("siteIds") List<String> siteIds);
    /**
     * 根据时间范围筛选订单
@@ -177,7 +179,7 @@
     * @return 列表
     */
    List<OrderQueryVO> orderCountByTimeRangeYear(@Param("cityList") List<String> cityList, @Param("startTime") String startTime,
                                                 @Param("endTime") String endTime, @Param("orderState") Integer orderState);
                                                 @Param("endTime") String endTime, @Param("orderState") Integer orderState,@Param("siteIds") List<String> siteIds);
    /**
     * 根据时间范围筛选订单
@@ -190,7 +192,7 @@
     * @return 列表
     */
    List<OrderQueryVO> orderCountByTimeRangeMonth(@Param("cityList") List<String> cityList, @Param("startTime") String startTime,
                                                  @Param("endTime") String endTime, @Param("orderState") Integer orderState);
                                                  @Param("endTime") String endTime, @Param("orderState") Integer orderState,@Param("siteIds") List<String> siteIds);
    List<PaperInVo> papercout(@Param("workId")String workId,@Param("date")String date);
}