From e9f105f4a7f59d3e7f3e2131657b6fe5abd1b2ab Mon Sep 17 00:00:00 2001
From: Camil Staps
Date: Tue, 24 Feb 2015 10:12:16 +0100
Subject: invoices in the future aren't open

---
 include/home.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/include/home.php b/include/home.php
index b1e21a3..f30c8bc 100644
--- a/include/home.php
+++ b/include/home.php
@@ -86,7 +86,7 @@ require('header.php');
             </div>
             <div class="col-lg-4 col-md-4 col-sm-6">
                 <?php
-                $count = count(BusinessAdmin::getOfferIds($_pdo, array("`invoice_date` > '1970-01-01'", "`payment_received` <= '1970-01-01' OR `payment_received` IS NULL")));
+                $count = count(BusinessAdmin::getOfferIds($_pdo, array("`invoice_date` > '1970-01-01'", "`invoice_date`<=CURDATE()", "`payment_received` <= '1970-01-01' OR `payment_received` IS NULL")));
                 ?>
                 <div class="panel panel-<?=($count==0 ? 'primary' : 'yellow')?>">
                     <div class="panel-heading">
@@ -170,7 +170,7 @@ require('header.php');
                             </thead>
                             <tbody>
                                 <?php
-                                $offers = BusinessAdmin::getOffers($_pdo, array("`invoice_date` > '1970-01-01'", "`payment_received` <= '1970-01-01' OR `payment_received` IS NULL"));
+                                $offers = BusinessAdmin::getOffers($_pdo, array("`invoice_date` > '1970-01-01'", "`invoice_date`<=CURDATE()", "`payment_received` <= '1970-01-01' OR `payment_received` IS NULL"));
                                 if (count($offers) == 0) {
                                     echo "<tr><td colspan='3'>There are no currently open invoices.</td></tr>";
                                 } else {
-- 
cgit v1.2.3