From bf2fbd9f3e90dd2ef508c5944ae63491397b42ae Mon Sep 17 00:00:00 2001
From: LSH
Date: 星期六, 04 十一月 2023 10:35:26 +0800
Subject: [PATCH] #
---
src/main/java/com/zy/crm/manager/mapper/OrderMapper.java | 23 ++++++++++++++++++++++-
1 files changed, 22 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/zy/crm/manager/mapper/OrderMapper.java b/src/main/java/com/zy/crm/manager/mapper/OrderMapper.java
index bce5640..db4d412 100644
--- a/src/main/java/com/zy/crm/manager/mapper/OrderMapper.java
+++ b/src/main/java/com/zy/crm/manager/mapper/OrderMapper.java
@@ -1,12 +1,33 @@
package com.zy.crm.manager.mapper;
-import com.zy.crm.manager.entity.Order;
import com.baomidou.mybatisplus.mapper.BaseMapper;
+import com.baomidou.mybatisplus.plugins.Page;
+import com.zy.crm.manager.entity.Order;
import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;
+
+import java.util.HashMap;
+import java.util.List;
@Mapper
@Repository
public interface OrderMapper extends BaseMapper<Order> {
+ Order selectByUuid(@Param("hostId") Long hostId, @Param("uuid") String uuid);
+
+ Order selectOrderByNewestUuid(@Param("hostId") Long hostId);
+
+ List<Order> listByPage(Page<Order> page, @Param("hostId") Long hostId, @Param("deptId") String deptId, @Param("userId") Long userId,@Param("director") Long director, @Param("condition") String condition, @Param("status") Integer status);
+
+ Double selectMoneyByYearAndStatus(String year, Integer status);//鑾峰彇鎸囧畾骞翠唤鍜岃鍗曠姸鎬佹�讳氦鏄撻噾棰�
+
+ Double selectMoneyByUserAndYearAndStatus(Long userId, String year, Integer status);//鑾峰彇鎸囧畾鐢ㄦ埛銆佸勾浠藉拰璁㈠崟鐘舵�佹�讳氦鏄撻噾棰�
+
+ Integer selectCountByUserYearAndStatus(Long userId, String year, Integer status);//鑾峰彇鎸囧畾骞翠唤鍜岃鍗曠姸鎬佹�绘暟閲�
+
+ List<Order> selectTopMoney();//鏌ヨ浜ゆ槗棰濆墠7鍚嶅憳宸�
+
+ List<HashMap<String, Object>> selectCurrentYearMonthSuccess();//鑾峰彇褰撳墠骞村害12涓湀鐨勪氦鏄撴垚鍔熼噾棰濇暟鎹�
+
}
--
Gitblit v1.9.1