diff options
| author | Camil Staps | 2016-07-27 15:08:24 +0200 |
|---|---|---|
| committer | Camil Staps | 2016-07-27 15:08:24 +0200 |
| commit | 1b703d0c4b09fb3d3b5946ac4b03de7eac5417b2 (patch) | |
| tree | 9f2da90355e141bb6bb63aa26dca07ab39b5d54e /include/home.php | |
| parent | v0.4.2 moved payment_received to separate table/class payment(s) (diff) | |
Remove payment when new value is unparsable
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 { |