2 /***************************************************************************
3 * Copyright (C) 2003-2011 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 Platal
::load('newsletter');
24 class XnetNlModule
extends NewsletterModule
29 '%grp/nl' => $this->make_hook('nl', AUTH_PASSWD
, 'groups'),
30 '%grp/nl/show' => $this->make_hook('nl_show', AUTH_PASSWD
, 'groups'),
31 '%grp/nl/search' => $this->make_hook('nl_search', AUTH_PASSWD
, 'groups'),
32 '%grp/admin/nl' => $this->make_hook('admin_nl', AUTH_PASSWD
, 'groupadmin'),
33 '%grp/admin/nl/sync' => $this->make_hook('admin_nl_sync', AUTH_PASSWD
, 'groupadmin'),
34 '%grp/admin/nl/enable' => $this->make_hook('admin_nl_enable', AUTH_PASSWD
, 'groupadmin'),
35 '%grp/admin/nl/edit' => $this->make_hook('admin_nl_edit', AUTH_PASSWD
, 'groupadmin'),
36 '%grp/admin/nl/edit/cancel' => $this->make_hook('admin_nl_cancel', AUTH_PASSWD
, 'groupadmin'),
37 '%grp/admin/nl/edit/valid' => $this->make_hook('admin_nl_valid', AUTH_PASSWD
, 'groupadmin'),
38 '%grp/admin/nl/categories' => $this->make_hook('admin_nl_cat', AUTH_PASSWD
, 'groupadmin'),
39 '%grp/stat' => $this->make_hook('stat_nl', AUTH_PASSWD
, 'groupadmin')
43 protected function getNl()
46 $group = $globals->asso('shortname');
47 return NewsLetter
::forGroup($group);
50 public function handler_admin_nl_sync($page)
58 if (Env
::has('add_users')) {
59 S
::assert_xsrf_token();
61 $nl->bulkSubscribe(array_keys(Env
::v('add_users')));
63 $page->trigSuccess('Ajouts réalisés avec succès.');
66 // TODO(x2006barrois): remove raw SQL query.
67 $uids = XDB
::fetchColumn('SELECT DISTINCT(g.uid)
68 FROM group_members AS g
69 WHERE g.asso_id = {?} AND NOT EXISTS (SELECT ni.*
70 FROM newsletter_ins AS ni
71 INNER JOIN newsletters AS n ON (ni.nlid = n.id)
72 WHERE g.uid = ni.uid AND n.group_id = g.asso_id)',
73 $globals->asso('id'));
75 $users = User
::getBulkUsersWithUIDs($uids);
76 usort($users, 'User::compareDirectoryName');
78 $page->setTitle('Synchronisation de la newsletter');
79 $page->changeTpl('newsletter/sync.tpl');
80 $page->assign('users', $users);
83 public function handler_admin_nl_enable($page)
91 if (Post
::has('title')) {
92 if (!S
::has_xsrf_token()) {
96 XDB
::execute('INSERT INTO newsletters
97 SET group_id = {?}, name = {?}',
98 $globals->asso('id'), Post
::s('title'));
100 $mailer = new PlMailer();
101 $mailer->assign('group', $globals->asso('nom'));
102 $mailer->assign('user', S
::user());
105 $page->trigSuccessRedirect("La lettre d'informations du groupe " .
106 $globals->asso('nom') . " a bien été créée",
107 $globals->asso('shortname') . '/admin/nl');
109 $page->setTitle('Activation de la newsletter');
110 $page->changeTpl('newsletter/enable.tpl');
114 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: