add some new koha reports
authorRogan Hamby <rhamby@equinoxinitiative.org>
Tue, 5 May 2020 19:17:01 +0000 (15:17 -0400)
committerRogan Hamby <rhamby@equinoxinitiative.org>
Tue, 5 May 2020 19:17:01 +0000 (15:17 -0400)
kmig.d/xml/stock_reports.xml

index d7edb71..e390d2e 100644 (file)
@@ -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>
     </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>
     </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>