Fixed #55 - export des données au format json

3 files changed, 19 insertions, 1 deletions

diff --git a/inc/functions.php b/inc/functions.php
index 10005dfe..abf70a93 100644
--- a/inc/functions.php
+++ b/inc/functions.php
@@ -232,6 +232,12 @@ function display_view($view, $id = 0, $full_head = 'yes')
 
     switch ($view)
     {
+        case 'export':
+            $entries = $store->retrieveAll();
+            $tpl->assign('export', json_encode($entries));
+            $tpl->draw('export');
+            logm('export view');
+            break;
         case 'config':
             $tpl->assign('load_all_js', 0);
             $tpl->draw('head');
@@ -240,7 +246,7 @@ function display_view($view, $id = 0, $full_head = 'yes')
             $tpl->draw('js');
             $tpl->draw('footer');
             logm('config view');
-        break;
+            break;
         case 'view':
             $entry = $store->retrieveOneById($id);
 
diff --git a/inc/store/sqlite.class.php b/inc/store/sqlite.class.php
index b2ae94a7..d5208a29 100644
--- a/inc/store/sqlite.class.php
+++ b/inc/store/sqlite.class.php
@@ -38,6 +38,14 @@ class Sqlite extends Store {
         }
     }
 
+    public function retrieveAll() {
+        $sql        = "SELECT * FROM entries ORDER BY id";
+        $query      = $this->executeQuery($sql, array());
+        $entries    = $query->fetchAll();
+
+        return $entries;
+    }
+
     public function retrieveOneById($id) {
         parent::__construct();
 
diff --git a/inc/store/store.class.php b/inc/store/store.class.php
index ae3cb341..360ff7c2 100644
--- a/inc/store/store.class.php
+++ b/inc/store/store.class.php
@@ -17,6 +17,10 @@ class Store {
 
     }
 
+    public function retrieveAll() {
+        
+    }
+
     public function retrieveOneById($id) {
 
     }