From fec6fe0838d668ebc1e07039881ed37796f0ec59 Mon Sep 17 00:00:00 2001
From: Laury GvR <laury@gaslightmedia.com>
Date: Thu, 20 Sep 2018 11:32:33 -0400
Subject: [PATCH] Start building sql for pending query, list comp started

---
 models/admin/newDashboard/index.php           | 24 +++++++++++++++++++
 views/admin/newDashboard/components/list.html | 11 +++++++++
 2 files changed, 35 insertions(+)

diff --git a/models/admin/newDashboard/index.php b/models/admin/newDashboard/index.php
index b351c7da..f2502fe8 100644
--- a/models/admin/newDashboard/index.php
+++ b/models/admin/newDashboard/index.php
@@ -197,6 +197,8 @@ class GlmMembersAdmin_newDashboard_index extends GlmDataMembers
                 $addons[$a['slug']]['slug'] = $a['slug'];
                 $addons[$a['slug']]['index'] = $a['index'];
                 $addons[$a['slug']]['widgetData'] = apply_filters($a['slug'] . "-dashboard-widget", "");
+
+                $addons[$a['slug']]['widgetData'] = $this->queryWidgetLists($addons[$a['slug']]['widgetData']);
                 
             } else {
                 echo "<br>" . $a['slug'] .  " has no filter called " . $a['slug'] . "-dashboard-widget";
@@ -205,6 +207,8 @@ class GlmMembersAdmin_newDashboard_index extends GlmDataMembers
             
         }
 
+        
+
 
         // Compile template data.
         $templateData = array(
@@ -233,4 +237,24 @@ class GlmMembersAdmin_newDashboard_index extends GlmDataMembers
 
     }
 
+    public function queryWidgetLists( &$widgetData = false ) {
+        foreach ( $widgetData as &$widgetComponent ) {
+            echo "<br>";
+            var_dump($widgetComponent);
+            if ( $widgetComponent['component'] == 'list' && isset($widgetComponent['fields']) && isset($widgetComponent['table']) ) {
+                
+                if ( isset($widgetComponent) ) {
+                    $where = $widgetComponent['where'];
+                } else {
+                    $where = ' TRUE ';
+                }
+                $sql = "'SELECT " . $widgetComponent['fields'] . " FROM " . $widgetComponent['table'] . " WHERE " . $where . "'";
+                $widgetComponent['extra'] = 'test';
+                $widgetComponent['sql'] = $sql;
+
+            }
+        }
+        return $widgetData;
+    }
+
 }
diff --git a/views/admin/newDashboard/components/list.html b/views/admin/newDashboard/components/list.html
index e69de29b..86895235 100644
--- a/views/admin/newDashboard/components/list.html
+++ b/views/admin/newDashboard/components/list.html
@@ -0,0 +1,11 @@
+<br>List component was called
+<div class="{$widgetField}-list list-header"> {$widgetField.title} <a href="#">5</a> </div>
+<ul class="collection">
+{foreach $widgetField as $listFieldName => $listFieldData}
+    <li class="collection-item" style="line-height: 1;padding : 5px 15px;">
+        <a href="#">
+            {$listFieldName} - {$listFieldData}
+        </a>
+    </li>
+{/foreach}
+</ul>
\ No newline at end of file
-- 
2.17.1