From 542a89497f9efc97c718cc1107f98efc2e07ae7e Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Thu, 13 Sep 2018 10:13:43 -0400
Subject: [PATCH] Add filter for show only unpaid invoices.

Adding this to the admin billing invoices page.
---
 models/admin/billing/invoices.php | 6 ++++++
 views/admin/billing/invoices.html | 5 +++++
 2 files changed, 11 insertions(+)

diff --git a/models/admin/billing/invoices.php b/models/admin/billing/invoices.php
index 60a7d0e..b45718e 100644
--- a/models/admin/billing/invoices.php
+++ b/models/admin/billing/invoices.php
@@ -435,6 +435,12 @@ class GlmMembersAdmin_billing_invoices extends GlmDataInvoices
                      WHERE ref_name like '%" . esc_sql( $searchName ) . "%')";
             }
 
+            if ( isset( $_REQUEST['filterUnpaid'] ) ) {
+                $filterUnpaid = filter_var( $_REQUEST['filterUnpaid'], FILTER_VALIDATE_BOOLEAN );
+                if ( $filterUnpaid ) {
+                    $where_params[] = "T.paid <> true";
+                }
+            }
             if ( isset( $_REQUEST['filterPending'] ) ) {
                 $filterPending = filter_var( $_REQUEST['filterPending'], FILTER_VALIDATE_BOOLEAN );
                 $where_params[] = "T.paid <> true";
diff --git a/views/admin/billing/invoices.html b/views/admin/billing/invoices.html
index efd76ad..8b607b1 100644
--- a/views/admin/billing/invoices.html
+++ b/views/admin/billing/invoices.html
@@ -25,6 +25,11 @@
                     <input id="member-account" type="hidden" name="filterAccounts" value="{$filterAccounts}">
                     <input id="account_name" name="searchName" value="" />
                 </span>
+            <br>
+                <span class="glm-nowrap">
+                    <input type="checkbox" name="filterUnpaid"{if $smarty.request.filterUnpaid} checked{/if}>
+                    <b>Show only Unpaid Invoices</b>
+                </span>
             <br>
                 <span class="glm-nowrap">
                     <input type="submit" value="Submit">
-- 
2.17.1