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 | 9 +++++++++
1 files changed, 9 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 ef87ded..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
@@ -32,4 +32,13 @@
"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