From 108823718291729cda833c67c849a7a70d612e38 Mon Sep 17 00:00:00 2001
From: Laury GvR <laury@gaslightmedia.com>
Date: Fri, 12 Jul 2019 18:59:16 -0400
Subject: [PATCH] Get selective data from each addon for the dashboard/summary

---
 setup/routes/dashboard.php | 68 +++++++++++++++++++++++++++++---------
 1 file changed, 52 insertions(+), 16 deletions(-)

diff --git a/setup/routes/dashboard.php b/setup/routes/dashboard.php
index cb40a4b..2a15efb 100644
--- a/setup/routes/dashboard.php
+++ b/setup/routes/dashboard.php
@@ -164,11 +164,32 @@ class GLMA_Dashboard_Rest_Controller
         }
         return $status;
     }
+
+
+
+// ;
+// ; Entry Status Types
+// ;
+// status[10] = 'Active'
+// status[20] = 'Pending Review'
+// status[30] = 'Inactive'
+// status[90] = 'Archived'
+
+// status_numb['Active'] = 10
+// status_numb['Pending'] = 20
+// status_numb['Inactive'] = 30
+// status_numb['Archived'] = 90
+
     
     // Get members
     //public function getList( $where = '', $order = '', $fieldVals = true, $idField = 'id', $start = false, $limit = false, $prohibitListOptions = false, $appendSelect = null )
     public function get_members_summary() {
 
+        // !!!
+        // WE'LL NEED TO GET MEMBER INFO AS WELL
+        // !!!
+        $fields = "id, name, member_slug";
+        $table = GLM_MEMBERS_PLUGIN_DB_PREFIX."members";
         $where = 
         " access 
           IN (
@@ -176,11 +197,11 @@ class GLMA_Dashboard_Rest_Controller
             ".$this->config['access_numb']['Moderated'].",
             ".$this->config['access_numb']['Full']."
             )";
-        $where = " true";
-        $sql = 
-            "SELECT *
-            FROM ".GLM_MEMBERS_PLUGIN_DB_PREFIX."members
-            WHERE ".$where.";";
+
+        $sql = " 
+            SELECT $fields
+            FROM $table
+            WHERE $where;";
 
         $members = $this->wpdb->get_results( $sql );
 
@@ -333,10 +354,17 @@ class GLMA_Dashboard_Rest_Controller
 
     // Get events
     public function get_events_summary() {
-        $sql = 
-            "SELECT *
-            FROM ".GLM_MEMBERS_EVENTS_PLUGIN_DB_PREFIX."events";
-
+        // !!!
+        // WE'LL NEED TO GET EVENT RECURRENCES AS WELL (for start/end date)
+        // !!!
+        $fields = "id, name, name_slug, descr, image";
+        $table = GLM_MEMBERS_EVENTS_PLUGIN_DB_PREFIX."events";
+        $where = "status IN (".$this->config['status_numb']['Active'].")";
+        $sql = "
+            SELECT $fields
+            FROM $table
+            WHERE $where;";
+            
         $events = $this->wpdb->get_results( $sql );
 
         return $events;
@@ -345,10 +373,14 @@ class GLMA_Dashboard_Rest_Controller
 
     // Get coupons
     public function get_coupons_summary() {
-        $sql = 
-            "SELECT *
-            FROM ".GLM_MEMBERS_COUPONS_PLUGIN_DB_PREFIX."coupons";
-
+        $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'].")";
+        $sql = "
+            SELECT $fields
+            FROM $table
+            WHERE $where;";
+            
         $coupons = $this->wpdb->get_results( $sql );
 
         return $coupons;
@@ -356,9 +388,13 @@ class GLMA_Dashboard_Rest_Controller
     
     // Get packages
     public function get_packages_summary() {
-        $sql = 
-            "SELECT *
-            FROM ".GLM_MEMBERS_PACKAGING_PLUGIN_DB_PREFIX."packages";
+        $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'].")";
+        $sql = "
+            SELECT $fields
+            FROM $table
+            WHERE $where;";
 
         $packages = $this->wpdb->get_results( $sql );
 
-- 
2.17.1