diff options
| author | Camil Staps | 2015-02-24 10:12:16 +0100 |
|---|---|---|
| committer | Camil Staps | 2015-02-24 10:12:16 +0100 |
| commit | e9f105f4a7f59d3e7f3e2131657b6fe5abd1b2ab (patch) | |
| tree | ac3d9bfd14a436669edcee714edbf1f1fdb3d15d /include/home.php | |
| parent | Active offers can have an invoice (diff) | |
invoices in the future aren't open
Diffstat (limited to 'include/home.php')
| -rw-r--r-- | include/home.php | 4 |
1 files 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 { |