From a032ee1f6c375cbf90543e934c92dbe7b70d2100 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期三, 18 十一月 2020 14:27:51 +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