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

5 files changed, 22 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) {
 
     }
diff --git a/tpl/config.html b/tpl/config.html
index a19a84fe..7d1c6afe 100644
--- a/tpl/config.html
+++ b/tpl/config.html
@@ -3,4 +3,6 @@
                 <p>Thanks to the bookmarklet, you will be able to easily add a link to your poche. If you don't know how use a bookmarklet, <a href="http://support.mozilla.org/en-US/kb/bookmarklets-perform-common-web-page-tasks">have a look here</a>.</p>
                 <p>Drag & drop this link to your bookmarks bar and have fun with poche.</p>
                 <p><a style="cursor: move; border: 1px dashed grey; background: white;" title="i am a bookmarklet, use me !" href="javascript:(function(){var%20url%20=%20location.href%20||%20url;window.open('{$poche_url}?action=add&url='%20+%20encodeURIComponent(url),'_self');})();">poche it !</a></p>
+                <h2>Export</h2>
+                <p><a href="?view=export" target="_blank">Click here</a> to export your poche datas.</p>
             </div>
\ No newline at end of file
diff --git a/tpl/export.html b/tpl/export.html
new file mode 100644
index 00000000..d22d05fc
--- /dev/null
+++ b/tpl/export.html
@@ -0,0 +1 @@
+export {$export}
\ No newline at end of file