From: Rogan Hamby <rhamby@equinoxinitiative.org>
Date: Tue, 5 May 2020 19:17:01 +0000 (-0400)
Subject: add some new koha reports
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=30444849807ba6c2afedf4c3f51d6c844cc9c0af

add some new koha reports
---

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>