From 4b2a8d5602dff3177003a66c5cf5524cfdef1e5b Mon Sep 17 00:00:00 2001 From: Laury GvR Date: Fri, 26 Jul 2019 20:02:57 -0400 Subject: [PATCH] Coupons and packages only get entries active today --- setup/routes/dashboard.php | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) diff --git a/setup/routes/dashboard.php b/setup/routes/dashboard.php index f9877fa..e2b782a 100644 --- a/setup/routes/dashboard.php +++ b/setup/routes/dashboard.php @@ -250,7 +250,9 @@ class GLMA_Dashboard_Rest_Controller public function get_coupons_summary() { $fields = "id, name, name_slug, descr, image, start_date, end_date, expire"; $table = GLM_MEMBERS_COUPONS_PLUGIN_DB_PREFIX."coupons"; - $where = "status IN (".$this->config['status_numb']['Active'].")"; + $where = "status IN (".$this->config['status_numb']['Active'].") + AND start_date <= CURDATE() + AND end_date >= CURDATE()"; $sql = " SELECT $fields FROM $table @@ -265,7 +267,9 @@ class GLMA_Dashboard_Rest_Controller public function get_packages_summary() { $fields = "id, title, package_slug, short_descr, image, start_date, end_date, expire_date"; $table = GLM_MEMBERS_PACKAGING_PLUGIN_DB_PREFIX."packages"; - $where = "status IN (".$this->config['status_numb']['Active'].")"; + $where = "status IN (".$this->config['status_numb']['Active'].") + AND start_date <= CURDATE() + AND end_date >= CURDATE()"; $sql = " SELECT $fields FROM $table -- 2.17.1