Renames user_id to uid accordingly to our naming convention.
[platal.git] / modules / axletter.php
CommitLineData
8da0d3c1 1<?php
2/***************************************************************************
9f5bd98e 3 * Copyright (C) 2003-2010 Polytechnique.org *
8da0d3c1 4 * http://opensource.polytechnique.org/ *
5 * *
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. *
10 * *
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. *
15 * *
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 *
18 * Foundation, Inc., *
19 * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *
20 ***************************************************************************/
21
22class AXLetterModule extends PLModule
23{
24 function handlers()
25 {
26 return array(
eb5a266d 27 'ax' => $this->make_hook('index', AUTH_COOKIE),
a0f05027 28 'ax/out' => $this->make_hook('out', AUTH_PUBLIC),
8da0d3c1 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),
eb5a266d 33 'admin/axletter' => $this->make_hook('admin', AUTH_MDP, 'admin'),
8da0d3c1 34 );
35 }
36
030038cd 37 function handler_out(&$page, $hash = null)
a0f05027 38 {
39 if (!$hash) {
40 if (!S::logged()) {
41 return PL_DO_AUTH;
42 } else {
43 return $this->handler_index($page, 'out');
44 }
45 }
460d8f55 46 $this->load('axletter.inc.php');
a0f05027 47 $page->changeTpl('axletter/unsubscribe.tpl');
48 $page->assign('success', AXLetter::unsubscribe($hash, true));
49 }
50
51 function handler_index(&$page, $action = null)
8da0d3c1 52 {
460d8f55 53 $this->load('axletter.inc.php');
8da0d3c1 54
55 $page->changeTpl('axletter/index.tpl');
46f272fe 56 $page->setTitle('Envois de l\'AX');
8da0d3c1 57
58 switch ($action) {
8da0d3c1 59 case 'in': AXLetter::subscribe(); break;
a0f05027 60 case 'out': AXLetter::unsubscribe(); break;
8da0d3c1 61 }
62
63 $perm = AXLetter::hasPerms();
64 if ($perm) {
9b242f17 65 $res = XDB::query("SELECT * FROM axletter_ins");
66 $page->assign('count', $res->numRows());
a0f05027 67 $page->assign('new', AXLetter::awaiting());
8da0d3c1 68 }
69 $page->assign('axs', AXLetter::subscriptionState());
70 $page->assign('ax_list', AXLetter::listSent());
71 $page->assign('ax_rights', $perm);
72 }
73
74 function handler_submit(&$page, $action = null)
75 {
460d8f55 76 $this->load('axletter.inc.php');
8da0d3c1 77 if (!AXLetter::hasPerms()) {
78 return PL_FORBIDDEN;
79 }
80
81 $page->changeTpl('axletter/edit.tpl');
82
4ea58d4b
VZ
83 $saved = Post::i('saved');
84 $new = false;
85 $id = Post::i('id');
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');
4a08dc73 93 $subset_to = preg_split("/[ ,;\:\n\r]+/", Post::v('subset_to'), -1, PREG_SPLIT_NO_EMPTY);
180627f3 94 $subset = (count($subset_to) > 0);
1f58ab8e 95 $subset_rm = Post::b('subset_rm');
4ea58d4b
VZ
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');
8da0d3c1 99 $echeance_date = Post::v('echeance_date');
100 $echeance_time = Post::v('echeance_time');
101
102 if (!$id) {
103 $res = XDB::query("SELECT * FROM axletter WHERE FIND_IN_SET('new', bits)");
104 if ($res->numRows()) {
105 extract($res->fetchOneAssoc(), EXTR_OVERWRITE);
c1134ef2 106 $subset_to = ($subset ? explode("\n", $subset) : null);
180627f3 107 $subset = (count($subset_to) > 0);
8da0d3c1 108 $saved = true;
109 } else {
110 XDB::execute("INSERT INTO axletter SET id = NULL");
111 $id = XDB::insertId();
112 }
113 if (!$echeance || $echeance == '0000-00-00 00:00:00') {
114 $saved = false;
115 $new = true;
116 }
40d428d8
VZ
117 } elseif (Post::has('valid')) {
118 S::assert_xsrf_token();
119
8da0d3c1 120 if (!$subject && $title) {
121 $subject = $title;
122 }
123 if (!$title && $subject) {
124 $title = $subject;
125 }
126 if (!$subject || !$title || !$body) {
a7d35093 127 $page->trigError("L'article doit avoir un sujet et un contenu");
8da0d3c1 128 Post::kill('valid');
129 }
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)))
133 {
a7d35093 134 $page->trigError("L'intervalle de promotions n'est pas valide");
8da0d3c1 135 Post::kill('valid');
136 }
4ea58d4b 137 if (empty($short_name)) {
a7d35093 138 $page->trigError("L'annonce doit avoir un nom raccourci pour simplifier la navigation dans les archives");
8da0d3c1 139 Post::kill('valid');
4ea58d4b 140 } elseif (!preg_match('/^[a-z][-a-z0-9]*[a-z0-9]$/', $short_name)) {
a7d35093 141 $page->trigError("Le nom raccourci n'est pas valide, il doit comporter au moins 2 caractères et n'être composé "
8da0d3c1 142 . "que de chiffres, lettres et tirets");
143 Post::kill('valid');
4ea58d4b
VZ
144 } elseif ($short_name != Post::v('old_short_name')) {
145 $res = XDB::query("SELECT id FROM axletter WHERE short_name = {?}", $short_name);
8da0d3c1 146 if ($res->numRows() && $res->fetchOneCell() != $id) {
a7d35093 147 $page->trigError("Le nom $short_name est déjà utilisé, merci d'en choisir un autre");
4ea58d4b
VZ
148 $short_name = Post::v('old_short_name');
149 if (empty($short_name)) {
8da0d3c1 150 Post::kill('valid');
151 }
152 }
153 }
154
155 switch (@Post::v('valid')) {
a7de4ef7 156 case 'Aperçu':
460d8f55 157 $this->load('axletter.inc.php');
4ea58d4b 158 $al = new AXLetter(array($id, $short_name, $subject, $title, $body, $signature,
1f58ab8e 159 $promo_min, $promo_max, $subset, $subset_rm, $echeance, 0, 'new'));
8da0d3c1 160 $al->toHtml($page, S::v('prenom'), S::v('nom'), S::v('femme'));
161 break;
162
163 case 'Confirmer':
164 XDB::execute("REPLACE INTO axletter
c6f2cafe 165 SET id = {?}, short_name = {?}, subject = {?}, title = {?}, body = {?},
1f58ab8e
RB
166 signature = {?}, promo_min = {?}, promo_max = {?}, echeance = {?}, subset = {?}, subset_rm = {?}",
167 $id, $short_name, $subject, $title, $body, $signature, $promo_min, $promo_max, $echeance, $subset ? implode("\n", $subset_to) : null, $subset_rm);
9b242f17 168 if (!$saved) {
115c90db 169 global $globals;
9b242f17 170 $mailer = new PlMailer();
1d55fe45 171 $mailer->setFrom("support@" . $globals->mail->domain);
faefdbb7
SJ
172 $mailer->setSubject("Un nouveau projet d'email de l'AX vient d'être proposé");
173 $mailer->setTxtBody("Un nouvel email vient d'être rédigé en prévision d'un envoi prochain. Vous pouvez "
9b242f17 174 . "le modifier jusqu'à ce qu'il soit verrouillé pour l'envoi\n\n"
faefdbb7 175 . "Le sujet de l'email : $subject\n"
9b242f17 176 . "L'échéance d'envoi est fixée à $echeance.\n"
faefdbb7 177 . "L'email pourra néanmoins partir avant cette échéance si un administrateur de "
9b242f17 178 . "Polytechnique.org le valide.\n\n"
faefdbb7 179 . "Pour modifier, valider ou annuler l'email :\n"
9b242f17 180 . "https://www.polytechnique.org/ax/edit\n"
181 . "-- \n"
182 . "Association Polytechnique.org\n");
1bf36cd1 183 $users = User::getBulkUsersWithUIDs(XDB::fetchColumn('SELECT uid
bd84f1ae
FB
184 FROM axletter_rights'));
185 foreach ($users as $user) {
186 $mailer->addTo($user);
9b242f17 187 }
188 $mailer->send();
189 }
8da0d3c1 190 $saved = true;
191 $echeance_date = null;
192 $echeance_time = null;
193 pl_redirect('ax');
194 break;
195 }
196 }
197 $page->assign('id', $id);
4ea58d4b 198 $page->assign('short_name', $short_name);
8da0d3c1 199 $page->assign('subject', $subject);
200 $page->assign('title', $title);
201 $page->assign('body', $body);
202 $page->assign('signature', $signature);
203 $page->assign('promo_min', $promo_min);
204 $page->assign('promo_max', $promo_max);
2a3f4f57
RB
205 $page->assign('subset_to', implode("\n", $subset_to));
206 $page->assign('subset', $subset);
1f58ab8e 207 $page->assign('subset_rm', $subset_rm);
8da0d3c1 208 $page->assign('echeance', $echeance);
209 $page->assign('echeance_date', $echeance_date);
210 $page->assign('echeance_time', $echeance_time);
211 $page->assign('saved', $saved);
212 $page->assign('new', $new);
dd70cd28 213 $page->assign('is_xorg', S::admin());
8da0d3c1 214
215 if (!$saved) {
216 $select = '';
8da0d3c1 217 for ($i = 0 ; $i < 24 ; $i++) {
218 $stamp = sprintf('%02d:00:00', $i);
219 if ($stamp == $echeance_time) {
220 $sel = ' selected="selected"';
221 } else {
222 $sel = '';
223 }
224 $select .= "<option value=\"$stamp\"$sel>{$i}h</option>\n";
225 }
226 $page->assign('echeance_time', $select);
eaf30d86 227 }
8da0d3c1 228 }
229
230 function handler_cancel(&$page, $force = null)
231 {
460d8f55 232 $this->load('axletter.inc.php');
fde3e90e 233 if (!AXLetter::hasPerms() || !S::has_xsrf_token()) {
8da0d3c1 234 return PL_FORBIDDEN;
235 }
236
a0f05027 237 $al = AXLetter::awaiting();
fde3e90e 238 if (!$al) {
8da0d3c1 239 $page->kill("Aucune lettre en attente");
240 return;
241 }
8da0d3c1 242 if (!$al->invalid()) {
243 $page->kill("Une erreur est survenue lors de l'annulation de l'envoi");
244 return;
245 }
246
8f794f88 247 $page->killSuccess("L'envoi de l'annonce {$al->title()} est annulé.");
8da0d3c1 248 }
249
250 function handler_valid(&$page, $force = null)
251 {
460d8f55 252 $this->load('axletter.inc.php');
fde3e90e 253 if (!AXLetter::hasPerms() || !S::has_xsrf_token()) {
8da0d3c1 254 return PL_FORBIDDEN;
255 }
256
a0f05027 257 $al = AXLetter::awaiting();
258 if (!$al) {
8da0d3c1 259 $page->kill("Aucune lettre en attente");
260 return;
261 }
8da0d3c1 262 if (!$al->valid()) {
263 $page->kill("Une erreur est survenue lors de la validation de l'envoi");
264 return;
265 }
266
8f794f88 267 $page->killSuccess("L'envoi de l'annonce aura lieu dans l'heure qui vient.");
8da0d3c1 268 }
269
270 function handler_show(&$page, $nid = 'last')
271 {
460d8f55 272 $this->load('axletter.inc.php');
8da0d3c1 273 $page->changeTpl('axletter/show.tpl');
274
4a71cf67
SJ
275 try {
276 $nl = new AXLetter($nid);
6d1747b3 277 $user =& S::user();
4a71cf67 278 if (Get::has('text')) {
6d1747b3 279 $nl->toText($page, $user);
4a71cf67 280 } else {
6d1747b3 281 $nl->toHtml($page, $user);
4a71cf67
SJ
282 }
283 if (Post::has('send')) {
6d1747b3 284 $nl->sendTo($user);
4a71cf67
SJ
285 }
286 } catch (MailNotFound $e) {
287 return PL_NOT_FOUND;
8da0d3c1 288 }
289 }
0d75939a 290
291 function handler_admin(&$page, $action = null, $uid = null)
292 {
460d8f55 293 $this->load('axletter.inc.php');
0d75939a 294 if (Post::has('action')) {
295 $action = Post::v('action');
296 $uid = Post::v('uid');
297 }
40d428d8
VZ
298 if ($uid) {
299 S::assert_xsrf_token();
300
0d75939a 301 $uids = preg_split('/ *[,;\: ] */', $uid);
302 foreach ($uids as $uid) {
303 switch ($action) {
304 case 'add':
305 $res = AXLetter::grantPerms($uid);
306 break;
307 case 'del';
308 $res = AXLetter::revokePerms($uid);
309 break;
310 }
311 if (!$res) {
a7d35093 312 $page->trigError("Personne ne correspond à l'identifiant '$uid'");
0d75939a 313 }
314 }
315 }
316
317 $page->changeTpl('axletter/admin.tpl');
1bf36cd1 318 $page->assign('admins', User::getBulkUsersWithUIDs(XDB::fetchColumn('SELECT uid
bd84f1ae 319 FROM axletter_rights')));
eaf30d86 320
0d75939a 321 $importer = new CSVImporter('axletter_ins');
1bf36cd1 322 $importer->registerFunction('uid', 'email vers Id X.org', array($this, 'idFromMail'));
0d75939a 323 $importer->forceValue('hash', array($this, 'createHash'));
1bf36cd1 324 $importer->apply($page, "admin/axletter", array('uid', 'email', 'prenom', 'nom', 'promo', 'flag', 'hash'));
0d75939a 325 }
326
f6eacab0 327 function idFromMail($line, $key, $relation = null)
0d75939a 328 {
329 static $field;
cbce77b7 330 global $globals;
0d75939a 331 if (!isset($field)) {
332 $field = array('email', 'mail', 'login', 'bestalias', 'forlife', 'flag');
333 foreach ($field as $fld) {
334 if (isset($line[$fld])) {
335 $field = $fld;
336 break;
337 }
338 }
339 }
bd84f1ae
FB
340 $uf = new UserFilter(new UFC_Email($line[$field]));
341 $id = $uf->getUIDs();
342 return count($id) == 1 ? $id[0] : 0;
0d75939a 343 }
344
f6eacab0 345 function createHash($line, $key, $relation)
0d75939a 346 {
5480a216 347 $hash = implode(time(), $line) . rand();
0d75939a 348 $hash = md5($hash);
349 return $hash;
350 }
8da0d3c1 351}
352
a7de4ef7 353// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
8da0d3c1 354?>