From e1c5100cdff570acfe3f65d80f11b05549f7bda5 Mon Sep 17 00:00:00 2001
From: x2000habouzit <x2000habouzit>
Date: Sat, 17 Jul 2004 13:08:38 +0000
Subject: [PATCH] one more page

+--------+--------+--------+--------+
|  todo  |  post  |  done  |  tot.  |
+--------+--------+--------+--------+
|    33  |    31  |   110  |   174  |
|   19%  |   18%  |   63%  |  100%  |
+--------+--------+--------+--------+
---
 etat_migration                     |  2 +-
 htdocs/marketing/volontaire.php    | 56 +++++++++++++++++++++++++++++
 templates/marketing/volontaire.tpl | 73 ++++++++++++++++++++++++++++++++++++++
 3 files changed, 130 insertions(+), 1 deletion(-)
 create mode 100644 htdocs/marketing/volontaire.php
 create mode 100644 templates/marketing/volontaire.tpl

diff --git a/etat_migration b/etat_migration
index 8089b00..b61e946 100644
--- a/etat_migration
+++ b/etat_migration
@@ -20,7 +20,6 @@ Etat  | Ancien nom								  | Nouveau nom
 ;	  | admin/correction_adr.php				  | 
 ;	  | admin/evenements.php					  | 
 ------+-[ marketing ]-----------------------------+----------------
-;	  | admin/marketing_volontaire.php			  | marketing/
 ;	  | admin/relance.php						  | marketing/ 
 ;	  | admin/utilisateurs_identification.php	  | marketing/
 ;	  | admin/utilisateurs_marketing.php		  | marketing/
@@ -121,6 +120,7 @@ xx	  | admin/logger_actions.php				  | -
 xx	  | admin/logger.php						  | -
 xx	  | admin/marketing.php						  | marketing/index.php
 xx	  | admin/marketing_promo.php				  | marketing/promo.php
+xx	  | admin/marketing_volontaire.php			  | marketing/volontaire.php
 xx	  | admin/newsletter_archi.php				  | -
 xx	  | admin/newsletter_pattecassee.php		  | -
 xx	  | admin/newsletter_prep.php				  | -
diff --git a/htdocs/marketing/volontaire.php b/htdocs/marketing/volontaire.php
new file mode 100644
index 0000000..6c970c0
--- /dev/null
+++ b/htdocs/marketing/volontaire.php
@@ -0,0 +1,56 @@
+<?php
+require("auto.prepend.inc.php");
+new_admin_page('marketing/volontaire.tpl');
+
+$errors = Array();
+
+// traitement des paramètres éventuels
+if (!empty($_GET["del"])) {
+    mysql_query("DELETE FROM marketing WHERE id ='{$_GET['del']}'");
+    $errors[] = "Entrée effacée";
+}
+if (!empty($_GET["done"])) {
+    mysql_query("UPDATE marketing SET flags = CONCAT(flags,',envoye') WHERE id ='{$_GET['done']}'");
+    $errors[] = "Entrée mise à jour";
+}
+
+$page->assign_by_ref('errors', $errors);
+
+$sql = "SELECT  m.id, m.expe, m.dest, m.email, 
+		i.promo, i.nom, i.prenom, i.last_known_email, 
+		sa.promo AS spromo, sa.nom AS snom, sa.prenom AS sprenom, sa.username AS susername,
+                FIND_IN_SET('mail_perso', m.flags) AS mailperso
+          FROM  marketing      AS m
+    INNER JOIN  identification AS i  ON i.matricule = m.dest
+    INNER JOIN  auth_user_md5  AS sa ON sa.user_id = m.expe
+         WHERE  NOT FIND_IN_SET('envoye', m.flags)";
+
+$page->mysql_assign($sql, 'neuves');
+
+
+$sql = "SELECT  i.promo, i.nom, i.prenom,
+                m.email, a.nom AS inscrit,
+                sa.promo AS sprormo, sa.nom AS snom, sa.prenom AS sprenom
+          FROM  marketing      AS m
+    INNER JOIN  identification AS i  ON i.matricule = m.dest
+    INNER JOIN  auth_user_md5  AS sa ON sa.user_id = m.expe
+    LEFT  JOIN  auth_user_md5  AS a  ON a.matricule = m.dest
+         WHERE  FIND_IN_SET('envoye', m.flags)";
+
+$page->mysql_assign($sql, 'used', 'nbused');
+
+$sql = "SELECT  COUNT(a.nom) AS j,
+                COUNT(i.matricule) AS i,
+                100 * COUNT(a.nom) / COUNT(i.matricule) as rate
+          FROM  marketing      AS m
+    INNER JOIN  identification AS i  ON i.matricule = m.dest
+    INNER JOIN  auth_user_md5  AS sa ON sa.user_id = m.expe
+    LEFT  JOIN  auth_user_md5  AS a  ON a.matricule = m.dest
+         WHERE  FIND_IN_SET('envoye', m.flags)";
+$res = $globals->db->query($sql);
+
+$page->assign('rate', mysql_fetch_assoc($res));
+mysql_free_result($res);
+
+$page->run();
+?>
diff --git a/templates/marketing/volontaire.tpl b/templates/marketing/volontaire.tpl
new file mode 100644
index 0000000..acb0670
--- /dev/null
+++ b/templates/marketing/volontaire.tpl
@@ -0,0 +1,73 @@
+{* $Id: volontaire.tpl,v 1.1 2004-07-17 13:08:38 x2000habouzit Exp $ *}
+
+{dynamic}
+
+{foreach from=$errros item=err}
+<p class="erreur">{$err}</p>
+{/foreach}
+
+<div class="rubrique">
+  Marketing volontaire
+</div>
+
+<div class="ssrubrique">
+  Adresses neuves
+</div>
+
+<table class="bicol" cellpadding="3" summary="Adresses neuves">
+  <tr>
+    <th>Camarade concerné</th>
+    <th>Adresse email</th>
+    <th>Camarade "informateur"</th>
+    <th>Dernière adresse connue</th>
+    <th>Lui écrire ?</th>
+  </tr>
+  {foreach from=$neuves item=it}
+  <tr class="{cycle values="pair,impair"}">
+    <td>{$it.nom} {$it.prenom} (X{$it.promo})</td>
+    <td>{$it.email}</td>
+    <td>{$it.snom} {$it.sprenom} (X{$it.spromo})</td>
+    <td>{$it.last_known_email}</td>
+    <td>
+      {if $it.mailperso}
+      <a href="utilisateurs.php?xmat={$it.dest}&amp;sender={$it.expe}&amp;from={$it.sprenom}%20{$it.snom}%20<{$it.susername}&#64;polytechnique.org>&amp;mail={$it.email}&amp;submit=Mailer">Perso</a>
+      {else}
+      <a href="utilisateurs.php?xmat={$it.dest}&amp;sender={$it.expe}&amp;from=Equipe%20Polytechnique.org%20<register&#64;polytechnique.org>&amp;mail={$it.email}&amp;submit=Mailer">Equipe</a>
+      {/if}
+      <a href="{$smarty.server.PHP_SELF}?done={$it.id}">Fait !</a>
+      <a href="{$smarty.server.PHP_SELF}?del={$it.id}">Del</a>
+    </td>
+  </tr>
+  {/foreach}
+</table>
+
+<br />
+<br />
+
+<div class="ssrubrique">
+  Adresses déjà utilisées
+</div>
+
+<table class="bicol" cellpadding="3" summary="Adresses déjà utilisées">
+  <tr>
+    <th>Camarade concerné</th>
+    <th>Adresse email</th>
+    <th>Camarade "informateur"</th>
+    <th>inscrit?</th>
+  </tr>
+  {foreach from=$neuves item=it}
+  <tr class="{cycle values="pair,impair"}">
+    <td>{$it.nom} {$it.prenom} (X{$it.promo})</td>
+    <td>{$it.email}</td>
+    <td>{$it.snom} {$it.sprenom} (X{$it.spromo})</td>
+    <td>{if $it.inscrit}OUI{else}NON{/if}</td>
+  </tr>
+  {/foreach}
+</table>
+
+<p>
+{$rate.j} inscrits sur {$rate.i} sollicités, soit {$rate.rate}% de succès.
+</p>
+{/dynamic}
+
+{* vim:set et sw=2 sts=2 sws=2: *}
-- 
2.1.4