2 /***************************************************************************
3 * Copyright (C) 2003-2009 Polytechnique.org *
4 * http://opensource.polytechnique.org/ *
6 * This program is free software; you can redistribute it and/or modify *
7 * it under the terms of the GNU General Public License as published by *
8 * the Free Software Foundation; either version 2 of the License, or *
9 * (at your option) any later version. *
11 * This program is distributed in the hope that it will be useful, *
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
14 * GNU General Public License for more details. *
16 * You should have received a copy of the GNU General Public License *
17 * along with this program; if not, write to the Free Software *
19 * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *
20 ***************************************************************************/
22 class AXLetterModule
extends PLModule
27 'ax' => $this->make_hook('index', AUTH_COOKIE
),
28 'ax/out' => $this->make_hook('out', AUTH_PUBLIC
),
29 'ax/show' => $this->make_hook('show', AUTH_COOKIE
),
30 'ax/edit' => $this->make_hook('submit', AUTH_MDP
),
31 'ax/edit/cancel' => $this->make_hook('cancel', AUTH_MDP
),
32 'ax/edit/valid' => $this->make_hook('valid', AUTH_MDP
),
33 'admin/axletter' => $this->make_hook('admin', AUTH_MDP
, 'admin'),
37 function handler_out(&$page, $hash = null
)
43 return $this->handler_index($page, 'out');
46 $this->load('axletter.inc.php');
47 $page->changeTpl('axletter/unsubscribe.tpl');
48 $page->assign('success', AXLetter
::unsubscribe($hash, true
));
51 function handler_index(&$page, $action = null
)
53 $this->load('axletter.inc.php');
55 $page->changeTpl('axletter/index.tpl');
56 $page->setTitle('Envois de l\'AX');
59 case 'in': AXLetter
::subscribe(); break;
60 case 'out': AXLetter
::unsubscribe(); break;
63 $perm = AXLetter
::hasPerms();
65 $res = XDB
::query("SELECT * FROM axletter_ins");
66 $page->assign('count', $res->numRows());
67 $page->assign('new', AXLetter
::awaiting());
69 $page->assign('axs', AXLetter
::subscriptionState());
70 $page->assign('ax_list', AXLetter
::listSent());
71 $page->assign('ax_rights', $perm);
74 function handler_submit(&$page, $action = null
)
76 $this->load('axletter.inc.php');
77 if (!AXLetter
::hasPerms()) {
81 $page->changeTpl('axletter/edit.tpl');
83 $saved = Post
::i('saved');
86 $short_name = trim(Post
::v('short_name'));
87 $subject = trim(Post
::v('subject'));
88 $title = trim(Post
::v('title'));
89 $body = rtrim(Post
::v('body'));
90 $signature = trim(Post
::v('signature'));
91 $promo_min = Post
::i('promo_min');
92 $promo_max = Post
::i('promo_max');
93 $subset_to = preg_split("/[ ,;\:\n\r]+/", Post
::v('subset_to'), -1, PREG_SPLIT_NO_EMPTY
);
94 $subset = (count($subset_to) > 0);
95 $subset_rm = Post
::b('subset_rm');
96 $echeance = Post
::has('echeance_date') ?
97 preg_replace('/^(\d\d\d\d)(\d\d)(\d\d)$/', '\1-\2-\3', Post
::v('echeance_date')) . ' ' . Post
::v('echeance_time')
98 : Post
::v('echeance');
99 $echeance_date = Post
::v('echeance_date');
100 $echeance_time = Post
::v('echeance_time');
103 $res = XDB
::query("SELECT * FROM axletter WHERE FIND_IN_SET('new', bits)");
104 if ($res->numRows()) {
105 extract($res->fetchOneAssoc(), EXTR_OVERWRITE
);
106 $subset_to = ($subset ?
explode("\n", $subset) : null
);
107 $subset = (count($subset_to) > 0);
110 XDB
::execute("INSERT INTO axletter SET id = NULL");
111 $id = XDB
::insertId();
113 if (!$echeance ||
$echeance == '0000-00-00 00:00:00') {
117 } elseif (Post
::has('valid')) {
118 S
::assert_xsrf_token();
120 if (!$subject && $title) {
123 if (!$title && $subject) {
126 if (!$subject ||
!$title ||
!$body) {
127 $page->trigError("L'article doit avoir un sujet et un contenu");
130 if (($promo_min > $promo_max && $promo_max != 0)||
131 ($promo_min != 0 && ($promo_min <= 1900 ||
$promo_min >= 2020)) ||
132 ($promo_max != 0 && ($promo_max <= 1900 ||
$promo_max >= 2020)))
134 $page->trigError("L'intervalle de promotions n'est pas valide");
137 if (empty($short_name)) {
138 $page->trigError("L'annonce doit avoir un nom raccourci pour simplifier la navigation dans les archives");
140 } elseif (!preg_match('/^[a-z][-a-z0-9]*[a-z0-9]$/', $short_name)) {
141 $page->trigError("Le nom raccourci n'est pas valide, il doit comporter au moins 2 caractères et n'être composé "
142 . "que de chiffres, lettres et tirets");
144 } elseif ($short_name != Post
::v('old_short_name')) {
145 $res = XDB
::query("SELECT id FROM axletter WHERE short_name = {?}", $short_name);
146 if ($res->numRows() && $res->fetchOneCell() != $id) {
147 $page->trigError("Le nom $short_name est déjà utilisé, merci d'en choisir un autre");
148 $short_name = Post
::v('old_short_name');
149 if (empty($short_name)) {
155 switch (@Post
::v('valid')) {
157 // Same as 'preview', but performs a test of all provided emails
159 require_once 'emails.inc.php';
160 $ids = ids_from_mails($subset_to);
162 foreach ($subset_to as $e) {
163 if (!array_key_exists($e, $ids)) {
165 $page->trigError("Emails inconnus :");
168 $page->trigError($e);
172 // XXX : no break here, since Vérifier is a subcase of Aperçu.
174 $this->load('axletter.inc.php');
175 $al = new AXLetter(array($id, $short_name, $subject, $title, $body, $signature,
176 $promo_min, $promo_max, $subset, $subset_rm, $echeance, 0, 'new'));
177 $al->toHtml($page, S
::v('prenom'), S
::v('nom'), S
::v('femme'));
181 XDB
::execute("REPLACE INTO axletter
182 SET id = {?}, short_name = {?}, subject = {?}, title = {?}, body = {?},
183 signature = {?}, promo_min = {?}, promo_max = {?}, echeance = {?}, subset = {?}, subset_rm = {?}",
184 $id, $short_name, $subject, $title, $body, $signature, $promo_min, $promo_max, $echeance, $subset ?
implode("\n", $subset_to) : null
, $subset_rm);
187 $mailer = new PlMailer();
188 $mailer->setFrom("support@" . $globals->mail
->domain
);
189 $mailer->setSubject("Un nouveau projet d'email de l'AX vient d'être proposé");
190 $mailer->setTxtBody("Un nouvel email vient d'être rédigé en prévision d'un envoi prochain. Vous pouvez "
191 . "le modifier jusqu'à ce qu'il soit verrouillé pour l'envoi\n\n"
192 . "Le sujet de l'email : $subject\n"
193 . "L'échéance d'envoi est fixée à $echeance.\n"
194 . "L'email pourra néanmoins partir avant cette échéance si un administrateur de "
195 . "Polytechnique.org le valide.\n\n"
196 . "Pour modifier, valider ou annuler l'email :\n"
197 . "https://www.polytechnique.org/ax/edit\n"
199 . "Association Polytechnique.org\n");
200 $res = XDB
::iterRow("SELECT IF(u.nom_usage != '', u.nom_usage, u.nom) AS nom,
201 u.prenom, a.alias AS bestalias
202 FROM axletter_rights AS ar
203 INNER JOIN auth_user_md5 AS u USING(user_id)
204 INNER JOIN aliases AS a ON (u.user_id = a.id
205 AND FIND_IN_SET('bestalias', a.flags))");
206 while (list($nom, $prenom, $alias) = $res->next()) {
207 $mailer->addTo("$nom $prenom <$alias@{$globals->mail->domain}>");
212 $echeance_date = null
;
213 $echeance_time = null
;
218 $page->assign('id', $id);
219 $page->assign('short_name', $short_name);
220 $page->assign('subject', $subject);
221 $page->assign('title', $title);
222 $page->assign('body', $body);
223 $page->assign('signature', $signature);
224 $page->assign('promo_min', $promo_min);
225 $page->assign('promo_max', $promo_max);
226 $page->assign('subset_to', implode("\n", $subset_to));
227 $page->assign('subset', $subset);
228 $page->assign('subset_rm', $subset_rm);
229 $page->assign('echeance', $echeance);
230 $page->assign('echeance_date', $echeance_date);
231 $page->assign('echeance_time', $echeance_time);
232 $page->assign('saved', $saved);
233 $page->assign('new', $new);
234 $page->assign('is_xorg', S
::admin());
238 for ($i = 0 ; $i < 24 ; $i++
) {
239 $stamp = sprintf('%02d:00:00', $i);
240 if ($stamp == $echeance_time) {
241 $sel = ' selected="selected"';
245 $select .= "<option value=\"$stamp\"$sel>{$i}h</option>\n";
247 $page->assign('echeance_time', $select);
251 function handler_cancel(&$page, $force = null
)
253 $this->load('axletter.inc.php');
254 if (!AXLetter
::hasPerms() ||
!S
::has_xsrf_token()) {
258 $al = AXLetter
::awaiting();
260 $page->kill("Aucune lettre en attente");
263 if (!$al->invalid()) {
264 $page->kill("Une erreur est survenue lors de l'annulation de l'envoi");
268 $page->killSuccess("L'envoi de l'annonce {$al->title()} est annulé.");
271 function handler_valid(&$page, $force = null
)
273 $this->load('axletter.inc.php');
274 if (!AXLetter
::hasPerms() ||
!S
::has_xsrf_token()) {
278 $al = AXLetter
::awaiting();
280 $page->kill("Aucune lettre en attente");
284 $page->kill("Une erreur est survenue lors de la validation de l'envoi");
288 $page->killSuccess("L'envoi de l'annonce aura lieu dans l'heure qui vient.");
291 function handler_show(&$page, $nid = 'last')
293 $this->load('axletter.inc.php');
294 $page->changeTpl('axletter/show.tpl');
297 $nl = new AXLetter($nid);
298 if (Get
::has('text')) {
299 $nl->toText($page, S
::v('prenom'), S
::v('nom'), S
::v('femme'));
301 $nl->toHtml($page, S
::v('prenom'), S
::v('nom'), S
::v('femme'));
303 if (Post
::has('send')) {
304 $nl->sendTo(S
::user()->login(), S
::user()->bestEmail(),
305 S
::v('prenom'), S
::v('nom'),
306 S
::v('femme'), S
::v('mail_fmt') != 'texte');
308 } catch (MailNotFound
$e) {
313 function handler_admin(&$page, $action = null
, $uid = null
)
315 $this->load('axletter.inc.php');
316 if (Post
::has('action')) {
317 $action = Post
::v('action');
318 $uid = Post
::v('uid');
321 S
::assert_xsrf_token();
323 $uids = preg_split('/ *[,;\: ] */', $uid);
324 foreach ($uids as $uid) {
327 $res = AXLetter
::grantPerms($uid);
330 $res = AXLetter
::revokePerms($uid);
334 $page->trigError("Personne ne correspond à l'identifiant '$uid'");
339 $page->changeTpl('axletter/admin.tpl');
340 $res = XDB
::iterator("SELECT IF(u.nom_usage != '', u.nom_usage, u.nom) AS nom,
341 u.prenom, u.promo, u.hruid
342 FROM axletter_rights AS ar
343 INNER JOIN auth_user_md5 AS u USING(user_id)");
344 $page->assign('admins', $res);
346 $importer = new CSVImporter('axletter_ins');
347 $importer->registerFunction('user_id', 'email vers Id X.org', array($this, 'idFromMail'));
348 $importer->forceValue('hash', array($this, 'createHash'));
349 $importer->apply($page, "admin/axletter", array('user_id', 'email', 'prenom', 'nom', 'promo', 'flag', 'hash'));
352 function idFromMail($line, $key, $relation = null
)
356 if (!isset($field)) {
357 $field = array('email', 'mail', 'login', 'bestalias', 'forlife', 'flag');
358 foreach ($field as $fld) {
359 if (isset($line[$fld])) {
365 $email = $line[$field];
366 if (strpos($email, '@') === false
) {
368 $domain = $globals->mail
->domain2
;
370 list($user, $domain) = explode('@', $email);
372 if ($domain != $globals->mail
->domain
&& $domain != $globals->mail
->domain2
373 && $domain != $globals->mail
->alias_dom
&& $domain != $globals->mail
->alias_dom2
) {
374 $res = XDB
::query("SELECT uid FROM emails WHERE email = {?}", $email);
375 if ($res->numRows() == 1) {
376 return $res->fetchOneCell();
380 list($user) = explode('+', $user);
381 list($user) = explode('_', $user);
382 if ($domain == $globals->mail
->alias_dom ||
$domain == $globals->mail
->alias_dom2
) {
383 $res = XDB
::query("SELECT a.id
385 INNER JOIN virtual_redirect AS r USING(vid)
386 INNER JOIN aliases AS a ON (a.type = 'a_vie'
387 AND r.redirect = CONCAT(a.alias, '@{$globals->mail->domain2}'))
388 WHERE v.alias = CONCAT({?}, '@{$globals->mail->alias_dom}')", $user);
389 $id = $res->fetchOneCell();
390 return $id ?
$id : '0';
392 $res = XDB
::query("SELECT id FROM aliases WHERE alias = {?}", $user);
393 $id = $res->fetchOneCell();
394 return $id ?
$id : '0';
397 function createHash($line, $key, $relation)
399 $hash = implode(time(), $line) . rand();
405 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: