From 59380c11771d47459b8db5425bc21293823ada74 Mon Sep 17 00:00:00 2001
From: xuefei <564615061@qq.com>
Date: 星期日, 13 十二月 2020 10:26:00 +0800
Subject: [PATCH] areaId参数的转换
---
platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/mapper/OrderMapper.java | 23 ++++++++++++++++++++++-
1 files changed, 22 insertions(+), 1 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..ef87ded 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,34 @@
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);
}
\ No newline at end of file
--
Gitblit v1.9.1