From a876b1ef311356fec8a15ea4dc07422611bef145 Mon Sep 17 00:00:00 2001
From: =?utf8?q?St=C3=A9phane=20Jacob?= <sj@m4x.org>
Date: Tue, 15 Nov 2011 10:10:26 +0100
Subject: [PATCH] Merge updates: conflicting names csv.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

Signed-off-by: Stéphane Jacob <sj@m4x.org>
---
 modules/fusionax.php         | 31 ++++++++++++++++++++++++++++---
 templates/fusionax/names.tpl |  2 ++
 2 files changed, 30 insertions(+), 3 deletions(-)

diff --git a/modules/fusionax.php b/modules/fusionax.php
index 6fdb360..325ec57 100644
--- a/modules/fusionax.php
+++ b/modules/fusionax.php
@@ -629,7 +629,7 @@ class FusionAxModule extends PLModule
         $page->assign('nbMissmatchingPromosTotal', $nbMissmatchingPromos);
     }
 
-    function handler_names($page, $action = '')
+    function handler_names($page, $action = '', $csv = false)
     {
         $page->changeTpl('fusionax/names.tpl');
 
@@ -640,7 +640,20 @@ class FusionAxModule extends PLModule
                                       INNER JOIN  profiles             AS p   ON (f.ax_id = p.ax_id)
                                       INNER JOIN  profile_public_names AS ppn ON (p.pid = ppn.pid)
                                            WHERE  f.prenom NOT IN (ppn.firstname_initial, ppn.firstname_main, ppn.firstname_ordinary)');
-            $page->assign('firstnameIssues', $res);
+
+            if ($csv) {
+                pl_cached_content_headers('text/x-csv', 'utf-8', 1, 'firstnames.csv');
+
+                $csv = fopen('php://output', 'w');
+                fputcsv($csv,  array('pid', 'ax_id', 'hrpid', 'AX', 'initial', 'principal', 'ordinaire'), ';');
+                foreach ($res as $item) {
+                    fputcsv($csv, $item, ';');
+                }
+                fclose($csv);
+                exit();
+            } else {
+                $page->assign('firstnameIssues', $res);
+            }
         } elseif ($action == 'last') {
             $res = XDB::rawFetchAllAssoc("SELECT  p.pid, p.ax_id, p.hrpid,
                                                   f.Nom_patronymique, f.Nom_usuel, f.Nom_complet,
@@ -651,8 +664,20 @@ class FusionAxModule extends PLModule
                                            WHERE  IF(f.partic_patro, CONCAT(f.partic_patro, CONCAT(' ', f.Nom_patronymique)), f.Nom_patronymique) NOT IN (ppn.lastname_initial, ppn.lastname_main, ppn.lastname_marital, ppn.lastname_ordinary)
                                                   AND IF(f.partic_nom, CONCAT(f.partic_nom, CONCAT(' ', f.Nom_usuel)), f.Nom_usuel) NOT IN (ppn.lastname_initial, ppn.lastname_main, ppn.lastname_marital, ppn.lastname_ordinary)
                                                   AND f.Nom_complet NOT IN (ppn.lastname_initial, ppn.lastname_main, ppn.lastname_marital, ppn.lastname_ordinary)");
-            $page->assign('lastnameIssues', $res);
 
+            if ($csv) {
+                pl_cached_content_headers('text/x-csv', 'utf-8', 1, 'lastnames.csv');
+
+                $csv = fopen('php://output', 'w');
+                fputcsv($csv,  array('pid', 'ax_id', 'hrpid', 'AX patro', 'AX usuel', 'AX complet', 'initial', 'principal', 'marital', 'ordinaire'), ';');
+                foreach ($res as $item) {
+                    fputcsv($csv, $item, ';');
+                }
+                fclose($csv);
+                exit();
+            } else {
+                $page->assign('lastnameIssues', $res);
+            }
         } else {
             $res = XDB::query('SELECT  COUNT(*)
                                  FROM  fusionax_anciens AS f
diff --git a/templates/fusionax/names.tpl b/templates/fusionax/names.tpl
index 2b1e15d..519d034 100644
--- a/templates/fusionax/names.tpl
+++ b/templates/fusionax/names.tpl
@@ -28,6 +28,7 @@
 {if $firstnameIssues|@count eq 0}
 <p>Aucun problème avec les prénoms.</p>
 {else}
+<p><a href="fusionax/names/first/true">Obtenir le csv des conflits.</a></p>
 <table class="bicol">
   <tr>
     <th>pid</th>
@@ -61,6 +62,7 @@
 {if $lastnameIssues|@count eq 0}
 <p>Aucun problème avec les noms.</p>
 {else}
+<p><a href="fusionax/names/last/true">Obtenir le csv des conflits.</a></p>
 <table class="bicol">
   <tr>
     <th>pid</th>
-- 
2.1.4