From 1b703d0c4b09fb3d3b5946ac4b03de7eac5417b2 Mon Sep 17 00:00:00 2001
From: Camil Staps
Date: Wed, 27 Jul 2016 15:08:24 +0200
Subject: Remove payment when new value is unparsable

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

(limited to 'include/home.php')

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 {
-- 
cgit v1.2.3