From 30444849807ba6c2afedf4c3f51d6c844cc9c0af Mon Sep 17 00:00:00 2001
From: Rogan Hamby <rhamby@equinoxinitiative.org>
Date: Tue, 5 May 2020 15:17:01 -0400
Subject: [PATCH] add some new koha reports

---
 kmig.d/xml/stock_reports.xml |   26 +++++++++++++++++++++++++-
 1 files changed, 25 insertions(+), 1 deletions(-)

diff --git a/kmig.d/xml/stock_reports.xml b/kmig.d/xml/stock_reports.xml
index d7edb71..e390d2e 100644
--- a/kmig.d/xml/stock_reports.xml
+++ b/kmig.d/xml/stock_reports.xml
@@ -1,5 +1,13 @@
 <reports_file>
-    <!-- CORE REPORTS -->
+
+    <report>
+        <name>total_borrowers</name>
+        <tag>borrowers</tag>
+        <iteration>0</iteration>
+        <report_title>Total Borrowers</report_title>
+        <heading>Count</heading>
+        <query>SELECT COUNT(*) FROM borrowers</query>
+    </report>
 
     <report>
         <name>borrower_counts</name>
@@ -45,6 +53,14 @@
     </report>
 
      <report>
+        <name>total_items_count</name>
+        <tag>items</tag>
+        <report_title>Total Items Count</report_title>
+        <heading>Count</heading>
+        <query>SELECT COUNT(*) FROM items;</query>
+    </report>
+
+     <report>
         <name>items_by_type_ccode_branch</name>
         <tag>items</tag>
         <report_title>Items by Item Type and Collection Code By Branch</report_title>
@@ -69,6 +85,14 @@
     </report>
 
      <report>
+        <name>total_circs</name>
+        <tag>circs</tag>
+        <report_title>Migrated Circulations</report_title>
+        <heading>Count</heading>
+        <query>SELECT COUNT(*) FROM issues</query>
+    </report>
+
+     <report>
         <name>circs_by_due_date</name>
         <tag>circs</tag>
         <report_title>Migrated Circulations with Due Dates</report_title>
-- 
1.7.2.5