From c085e6fa1cb24f0173b500488ecd192dd2ae624f Mon Sep 17 00:00:00 2001
From: 1697371125@qq.com <wei1697371125>
Date: 星期五, 25 十二月 2020 15:13:50 +0800
Subject: [PATCH] 增加解释及库表说明
---
platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/mapper/OrderMapper.java | 30 ++++++++++++++++++++++++++++++
1 files changed, 30 insertions(+), 0 deletions(-)
diff --git a/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/mapper/OrderMapper.java b/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/mapper/OrderMapper.java
index 369cd8d..ea22085 100644
--- a/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/mapper/OrderMapper.java
+++ b/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/mapper/OrderMapper.java
@@ -2,13 +2,43 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import cn.cetc54.platform.zhyl.entity.Order;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
import java.util.List;
+import java.util.Map;
/**
* 璁㈠崟鏁版嵁澶勭悊灞�
* @author
*/
public interface OrderMapper extends BaseMapper<Order> {
+ /**
+ * 鑾峰彇鏌愪釜鍖哄煙鐨勬湇鍔￠」鐩殑涓暟
+ * @param areaId
+ * @return
+ */
+ @Select("<script>" +
+ "select detail,count(*) as num " +
+ "from" +
+ "(select detail,person_id " +
+ "from t_yl_order " +
+ "<where>" +
+ " <if test='areaId!= null'>" +
+ "and area_id=#{areaId} " +
+ " </if>" +
+ "</where>" +
+ "GROUP BY detail,person_id) t " +
+ "GROUP BY detail ORDER BY num desc" +
+ "</script>")
+ List<Map<String,Object>> getTypeStatics(@Param("areaId") String areaId);
+ @Select("<script>" +
+ "select count(*) as num " +
+ "from t_yl_order o " +
+ "left join t_yl_fuwu_person p " +
+ "on o.person_id=p.id " +
+ "where p.org_fw_Id=#{orgId}" +
+ "</script>")
+ int getOrderNum(@Param("orgId") String orgId);
}
\ No newline at end of file
--
Gitblit v1.9.1