From f660d091784fdd0567b1d16698e3dc3fc78f2ae0 Mon Sep 17 00:00:00 2001
From: Rogan Hamby <rhamby@equinoxinitiative.org>
Date: Fri, 24 Jan 2020 11:13:29 -0500
Subject: [PATCH] adding billing report for horizon from database extracts

---
 mig-xml/mapping_reports.xml |    9 +++++++++
 1 files changed, 9 insertions(+), 0 deletions(-)

diff --git a/mig-xml/mapping_reports.xml b/mig-xml/mapping_reports.xml
index 47f07e6..53665d5 100644
--- a/mig-xml/mapping_reports.xml
+++ b/mig-xml/mapping_reports.xml
@@ -706,6 +706,15 @@
         <query>SELECT cki_notes FROM item_csv_clean WHERE LENGTH(cki_notes) > 1 LIMIT 20;</query>
     </report>
 
+    <report>
+        <name>hz_burbbills</name>
+        <report_title>Count of Bills by Type</report_title>
+        <tag>horizon2</tag>
+        <iteration>0</iteration>
+        <heading>Count.Bill Type</heading>
+        <query>SELECT COUNT(*), block FROM burb_csv_clean WHERE amount::INTEGER > 0 GROUP BY 2;</query>
+    </report>
+
 <!-- resource mate -->
 
     <report>
-- 
1.7.2.5