From ea2569eb05495fb4a89c681db9bf87d2d95a5790 Mon Sep 17 00:00:00 2001
From: Florent Bruneau <florent.bruneau@polytechnique.org>
Date: Thu, 6 Sep 2007 21:55:28 +0200
Subject: [PATCH] Disable the broken marketing for dead people.

Signed-off-by: Florent Bruneau <florent.bruneau@polytechnique.org>
---
 modules/marketing.php          | 3 ++-
 templates/marketing/broken.tpl | 9 ++++++++-
 2 files changed, 10 insertions(+), 2 deletions(-)

diff --git a/modules/marketing.php b/modules/marketing.php
index b967df7..8c648d0 100644
--- a/modules/marketing.php
+++ b/modules/marketing.php
@@ -178,7 +178,8 @@ class MarketingModule extends PLModule
         }
 
         $res = Xdb::query("SELECT  u.nom, u.prenom, u.promo, FIND_IN_SET('femme', u.flags) AS sexe,
-                                   a.alias AS forlife, b.alias AS bestalias, e.email, e.last
+                                   u.deces = '0000-00-00' AS alive, a.alias AS forlife, b.alias AS bestalias,
+                                   e.email, e.last
                              FROM  auth_user_md5 AS u
                        INNER JOIN  aliases       AS a ON (a.id = u.user_id AND a.type = 'a_vie')
                        INNER JOIN  aliases       AS b ON (b.id = u.user_id AND FIND_IN_SET('bestalias', b.flags))
diff --git a/templates/marketing/broken.tpl b/templates/marketing/broken.tpl
index 9a314f4..80266d5 100644
--- a/templates/marketing/broken.tpl
+++ b/templates/marketing/broken.tpl
@@ -27,8 +27,15 @@
   Merci de nous avoir communiqué cette information !
 </p>
 
-{elseif $user}
+{elseif $user && !$user.alive}
+<p class="erreur">
+  {$user.prenom} {$user.nom} (X{$user.promo}) est malheureusement décédé{if $user.sexe}e{/if}.
+  Nous ne réaliserons maintenance sur son adresse Polytechnique.org qu'à la demande explicite
+  de sa famille. Pour tout renseignement, merci de <a href="mailto:contact@polytechnique.org">
+  contacter le support</a>.
+</p>
 
+{elseif $user}
 <h1>
   Recherche d'adresses pour {$user.nom} {$user.prenom} (X{$user.promo})
 </h1>
-- 
2.1.4