Rajout de l'export CSV

diff --git a/data/jeu_essai.db b/data/jeu_essai.db
index 6954bf8..cdb9c11 100644 (file)
Binary files a/data/jeu_essai.db and b/data/jeu_essai.db differ

diff --git a/data/scripts/schema.sql b/data/scripts/schema.sql
index 14a9f1f..ebf8a4b 100644 (file)
--- a/data/scripts/schema.sql
+++ b/data/scripts/schema.sql
@@ -215,3 +215,10 @@ BEGIN
     END;
 END;
 
+CREATE VIEW gallery_info AS
+    SELECT gallery.id, gallery.name, gallery.description, user.firstname || ' ' || user.lastname AS username, count(photo.id) as nb
+    INNER JOIN user ON gallery.id_user = user.id
+    LEFT JOIN photo ON gallery.id = photo.id_gallery
+    GROUP BY user.lastname, user.firstname, gallery.name
+    ORDER BY user.lastname, user.firstname, gallery.name
+;

diff --git a/module/Galerie/config/module.config.php b/module/Galerie/config/module.config.php
index 5c06d9c..5f96569 100644 (file)
--- a/module/Galerie/config/module.config.php
+++ b/module/Galerie/config/module.config.php
@@ -117,7 +117,18 @@ return array(
                             ),
                         ),
                         'verb' => 'get',
-                    ),/*
+                    ),
+                    'csv' => array(
+                        'type'    => 'Literal',
+                        'options' => array(
+                            'route'    => '/csv',
+                            'defaults' => array(
+                                'action' => 'csv',
+                            ),
+                        ),
+                        'verb' => 'get',
+                    ),
+/*
                     'default' => array(
                         'type'    => 'Segment',
                         'options' => array(

diff --git a/module/Galerie/src/Galerie/Controller/IndexController.php b/module/Galerie/src/Galerie/Controller/IndexController.php
index fefa823..1f358f3 100644 (file)
--- a/module/Galerie/src/Galerie/Controller/IndexController.php
+++ b/module/Galerie/src/Galerie/Controller/IndexController.php
@@ -61,6 +61,30 @@ class IndexController extends AbstractActionController
         return new ViewModel($this->MessageGetter());
     } 
 
+    public function csvAction() {
+        // Récupération des informations brutes
+        $modelManager = $this->_getGalerieInfoTable();
+        $datas = $modelManager->all();
+
+        // Mise en forme des résultats
+        $content = array($modelManager->csvHeader());
+        foreach($datas as $d) {
+            $content[] = $d->csvFormat();
+        }
+
+        // Création de la réponse
+        $response = $this->getResponse();
+        $response->setStatusCode(200);
+
+        $headers = $this->getResponse()->getHeaders();
+        $headers->addHeaderLine('Content-Type', 'text/csv; charset=utf-8');
+        $headers->addHeaderLine('Content-Disposition', 'attachment; filename="export_galerie.csv"');
+
+
+        $response->setContent(implode("\r\n", $content));
+        return $response;
+    }
+
     public function listAction() 
     { 
         // Récupération de l'objet requête

diff --git a/module/Galerie/src/Galerie/Model/GalerieInfo.php b/module/Galerie/src/Galerie/Model/GalerieInfo.php
index 2abe6ca..954ee71 100644 (file)
--- a/module/Galerie/src/Galerie/Model/GalerieInfo.php
+++ b/module/Galerie/src/Galerie/Model/GalerieInfo.php
@@ -27,4 +27,13 @@ class GalerieInfo extends Entity
     protected $primary_columns = array(
     );
 
+    public function csvFormat()
+    {
+        return $this->id
+            . ';' . $this->name
+            . ';' . $this->description
+            . ';' . $this->username
+            . ';' . $this->nb;
+    }
+
 }

diff --git a/module/Galerie/src/Galerie/Model/GalerieInfoTable.php b/module/Galerie/src/Galerie/Model/GalerieInfoTable.php
index 3d5890b..939f8b3 100644 (file)
--- a/module/Galerie/src/Galerie/Model/GalerieInfoTable.php
+++ b/module/Galerie/src/Galerie/Model/GalerieInfoTable.php
@@ -157,6 +157,10 @@ class GalerieInfoTable implements TableGatewayInterface
     }
 
 
+    public function csvHeader()
+    {
+        return "Id;Nom;Description;Propriétaire;Nombre";
+    }
 
 
 }