From bd75d3a75afe6dcd2208079e63aa0ee433f79cf8 Mon Sep 17 00:00:00 2001
From: Chris Sharp <csharp@georgialibraries.org>
Date: Mon, 4 Jan 2016 14:49:37 -0500
Subject: [PATCH] we need to only void overdue fines accrued on those dates

---
 batch_void_fines.sh | 6 ++++--
 1 file changed, 4 insertions(+), 2 deletions(-)

diff --git a/batch_void_fines.sh b/batch_void_fines.sh
index eb84c27..8c87f69 100755
--- a/batch_void_fines.sh
+++ b/batch_void_fines.sh
@@ -91,7 +91,8 @@ fi
 read -d '' SYSTEM_Q <<END_OF_Q
 SELECT * INTO $BACKUP_TABLE
 FROM money.billing mb
-WHERE date(billing_ts) IN (
+WHERE btype = 1
+AND date(billing_ts) IN (
     '$DATE'
 ) AND voided = FALSE
 	AND EXISTS ( 
@@ -109,7 +110,8 @@ END_OF_Q
 read -d '' BRANCH_Q <<END_OF_Q
 SELECT * INTO $BACKUP_TABLE
 FROM money.billing mb
-WHERE date(billing_ts) IN (
+WHERE btype = 1 
+AND date(billing_ts) IN (
     '$DATE'
 ) AND voided = FALSE
 	AND EXISTS ( 
-- 
2.11.0