aboutsummaryrefslogtreecommitdiff
path: root/include/home.php
diff options
context:
space:
mode:
Diffstat (limited to 'include/home.php')
-rw-r--r--include/home.php4
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 {