From 90ffa7515c367e9be9a2c41e954757898ad2df94 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期二, 17 十一月 2020 15:27:07 +0800
Subject: [PATCH] #
---
src/main/java/com/zy/asrs/mapper/ReportQueryMapper.java | 6 ++++++
1 files changed, 6 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/ReportQueryMapper.java b/src/main/java/com/zy/asrs/mapper/ReportQueryMapper.java
index f2b91f4..f8285ce 100644
--- a/src/main/java/com/zy/asrs/mapper/ReportQueryMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/ReportQueryMapper.java
@@ -27,4 +27,10 @@
@Select("select * from asr_loc_use_view")
LocChartPie getLocUseRate();
+ @Select("select count(1) as totalWrk from asr_wrk_mast_log where crn_no = #{crnNo}")
+ Integer getTotalWrkByCrnId(Integer crnNo);
+
+ @Select("select count(1) as totalLoc from asr_loc_mast")
+ Integer getTotalLocByCrnId();
+
}
--
Gitblit v1.9.1