X-Git-Url: http://olivier.miskin.fr/git/?a=blobdiff_plain;f=action%2Fexporter_souscriptions.php;fp=action%2Fexporter_souscriptions.php;h=a1228f67a3d85f2b39396e439214c721c838cb4a;hb=acf01f6c1a3709bdc3d8724794f0823e2c9d75b8;hp=0000000000000000000000000000000000000000;hpb=5b775a847e6b8cd1d62938e9b23a165a04ba4f2d;p=spip_souscriptions.git

diff --git a/action/exporter_souscriptions.php b/action/exporter_souscriptions.php
new file mode 100644
index 0000000..a1228f6
--- /dev/null
+++ b/action/exporter_souscriptions.php
@@ -0,0 +1,65 @@
+<?php
+if (!defined("_ECRIRE_INC_VERSION")) return;
+
+function action_exporter_souscriptions_dist($arg=null) {
+
+  /* FIXME: permettre de selectionner les exports */
+  /* FIXME: améliorer la jointure... */
+
+  if (is_null($arg)) {
+    $securiser_action = charger_fonction('securiser_action', 'inc');
+    $arg = $securiser_action();
+  }
+
+  /* Vérification des droits de l'utilisateur. */
+  if(!autoriser("exporter", "souscriptiondon", '')) {
+    include_spip('inc/minipres');
+    echo minipres();
+    exit;
+  }
+
+  if($arg == "payes") {
+    $row = sql_select("id_souscription, courriel,"
+                      ."montant, reglee, spip_transactions.statut, date_paiement, mode, autorisation_id,"
+                      ."nom, prenom, code_postal, ville, recu_fiscal, envoyer_info, date_souscription,"
+                      ."id_souscription_campagne, titre",
+                      "spip_souscriptions LEFT JOIN spip_transactions USING(id_transaction) LEFT JOIN spip_souscription_campagnes USING(id_souscription_campagne) ",
+                      "reglee='oui'");
+  }
+  elseif($arg == "tous") {
+    $row = sql_select("id_souscription, courriel,"
+                      ."montant, reglee, spip_transactions.statut, date_paiement, mode, autorisation_id,"
+                      ."nom, prenom, code_postal, ville, recu_fiscal, envoyer_info, date_souscription,"
+                      ."id_souscription_campagne, titre",
+                      "spip_souscriptions LEFT JOIN spip_transactions USING(id_transaction) LEFT JOIN spip_souscription_campagnes USING(id_souscription_campagne)");
+  }
+  else {
+    include_spip('inc/minipres');
+    echo minipres("Argument invalide");
+    exit;    
+  }
+
+  $entete = array("ID du don",
+                  "Courriel",
+                  "Montant",
+                  "Reglée",
+                  "Statut",
+                  "Date de paiement",
+                  "Mode de paiement",
+                  "ID de l'autorisation",
+                  "Nom",
+                  "Prénom",
+                  "Code Postal",
+                  "Ville",
+                  "Souhaite reçu fiscal",
+                  "Souhaite être informé",
+                  "Date don",
+                  "ID Campagne",
+                  "Titre de la campagne");
+
+  /* Utilisation de la fonction exporter_csv de Bonux */
+  $exporter_csv = charger_fonction('exporter_csv', 'inc/', true);
+
+  $exporter_csv("souscriptions_${arg}", $row, ',', $entete);
+  exit();
+}