From 93cb16e3d1e2404c9b8e12afbb79d644dfc3c797 Mon Sep 17 00:00:00 2001 From: x2000habouzit Date: Sat, 17 Jul 2004 10:14:55 +0000 Subject: [PATCH] one more page +--------+--------+--------+--------+ | todo | post | done | tot. | +--------+--------+--------+--------+ | 34 | 31 | 109 | 174 | | 19% | 18% | 63% | 100% | +--------+--------+--------+--------+ --- etat_migration | 2 +- htdocs/marketing/promo.php | 26 +++++++++++++++ templates/marketing/index.tpl | 4 +-- templates/marketing/promo.tpl | 78 +++++++++++++++++++++++++++++++++++++++++++ 4 files changed, 107 insertions(+), 3 deletions(-) create mode 100644 htdocs/marketing/promo.php create mode 100644 templates/marketing/promo.tpl diff --git a/etat_migration b/etat_migration index 8370747..45531f0 100644 --- a/etat_migration +++ b/etat_migration @@ -22,7 +22,6 @@ Etat | Ancien nom | Nouveau nom ; | admin/evenements.php | ;! | admin/pg.php | ------+-[ marketing ]-----------------------------+---------------- -; | admin/marketing_promo.php | marketing/ ; | admin/marketing_volontaire.php | marketing/ ; | admin/relance.php | marketing/ ; | admin/utilisateurs_identification.php | marketing/ @@ -120,6 +119,7 @@ xx | admin/ins_confirmees.php | - 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/newsletter_archi.php | - xx | admin/newsletter_pattecassee.php | - xx | admin/newsletter_prep.php | - diff --git a/htdocs/marketing/promo.php b/htdocs/marketing/promo.php new file mode 100644 index 0000000..b2e8148 --- /dev/null +++ b/htdocs/marketing/promo.php @@ -0,0 +1,26 @@ +assign('promo', $promo); +$page->assign('promob10', $promo-10); +$page->assign('promob1', $promo-1); +$page->assign('promoa1', $promo+1); +$page->assign('promoa10', $promo+10); + +$sql = "SELECT i.nom, i.prenom, i.last_known_email, i.matricule, i.matricule_ax, MAX(e.date_envoi) AS dern_rel, c.email + FROM identification AS i + LEFT JOIN auth_user_md5 AS a ON (i.matricule = a.matricule) + LEFT JOIN envoidirect AS e ON (i.matricule = e.matricule) + LEFT JOIN en_cours AS c ON (i.matricule = c.matricule) + WHERE a.nom is NULL AND i.promo = $promo AND i.deces = 0 + GROUP BY i.matricule + ORDER BY nom,prenom"; + +$page->mysql_assign($sql, 'nonins', 'nbnonins'); + +$page->run(); + +?> diff --git a/templates/marketing/index.tpl b/templates/marketing/index.tpl index cf2eeec..7423044 100644 --- a/templates/marketing/index.tpl +++ b/templates/marketing/index.tpl @@ -1,4 +1,4 @@ -{* $Id: index.tpl,v 1.1 2004-07-16 20:22:03 x2000habouzit Exp $ *} +{* $Id: index.tpl,v 1.2 2004-07-17 10:14:56 x2000habouzit Exp $ *}
Marketing Polytechnique.org
@@ -11,7 +11,7 @@ Premier contact : Chercher un non inscrit   |   - Marketing promo   |   + Marketing promo   |   Sollicitations faites diff --git a/templates/marketing/promo.tpl b/templates/marketing/promo.tpl new file mode 100644 index 0000000..acb2bb1 --- /dev/null +++ b/templates/marketing/promo.tpl @@ -0,0 +1,78 @@ +{* $Id: promo.tpl,v 1.1 2004-07-17 10:14:56 x2000habouzit Exp $ *} + +{dynamic} + + + + + + + + + +
+
+ +
+ 		+
+ +
+ 		+
+ Promotion : +
+ 		+
+
+ + +
+
+ +
+ +
+ + Voir l'évolution des inscriptions de la promotion + +
+ +
+ + + + + + + + {foreach from=$nonins item=it} + + + + + + + {/foreach} +
NomDernière adresse connueDate dernière relance
(si moins d'un an)		 
{$it.nom} {$it.prenom}{if $it.last_known_email}{mailto address=$it.last_known_email}{/if} + {if $it.dern_rel} + {$it.dern_rel} + {elseif $it.email} + Ins en cours depuis {$it.email} + {else} + Jamais ou + d'1 an + {/if} + + Fiche AX/ + Marketing +
+
+ +

+{$nbnonins} Polytechniciens de la promo {$promo} ne sont pas inscrits ! +

+ +{/dynamic} + +{* vim:set et sw=2 sts=2 sws=2: *} -- 2.1.4