diff options
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 c9d0cf3..51d899b 100644 --- a/include/home.php +++ b/include/home.php @@ -115,7 +115,7 @@ require('./header.php'); $count = count(BusinessAdmin::getOfferIds($_pdo, array( "`invoice_date` > '1970-01-01'", "`invoice_date`<=CURDATE()", - "NOT EXISTS (SELECT * FROM `".constants::db_prefix."payment` WHERE `offerId`=`".constants::db_prefix."offer`.`id` AND `date` != TIMESTAMP(0))"))); + "NOT EXISTS (SELECT * FROM `".constants::db_prefix."payment` WHERE `offerId`=`".constants::db_prefix."offer`.`id`)"))); ?> <div class="panel panel-<?=($count==0 ? 'primary' : 'yellow')?>"> <div class="panel-heading"> @@ -242,7 +242,7 @@ require('./header.php'); $offers = BusinessAdmin::getOffers($_pdo, array( "`invoice_date` > '1970-01-01'", "`invoice_date`<=CURDATE()", - "NOT EXISTS (SELECT * FROM `".constants::db_prefix."payment` WHERE `offerId`=`".constants::db_prefix."offer`.`id` AND `date` != TIMESTAMP(0))")); + "NOT EXISTS (SELECT * FROM `".constants::db_prefix."payment` WHERE `offerId`=`".constants::db_prefix."offer`.`id`)")); if (count($offers) == 0) { echo "<tr><td colspan='3'>There are no currently open invoices.</td></tr>"; } else { |