modules/xnetnl.php

   1 <?php
   2 /***************************************************************************
   3  *  Copyright (C) 2003-2011 Polytechnique.org                              *
   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
  22 Platal::load('newsletter');
  23
  24 class XnetNlModule extends NewsletterModule
  25 {
  26     function handlers()
  27     {
  28         return array(
  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')
  40         );
  41     }
  42
  43     protected function getNl()
  44     {
  45        global $globals;
  46        $group = $globals->asso('shortname');
  47        return NewsLetter::forGroup($group);
  48     }
  49
  50     public function handler_admin_nl_sync($page)
  51     {
  52         global $globals;
  53         $nl = $this->getNl();
  54         if (!$nl) {
  55             return PL_FORBIDDEN;
  56         }
  57
  58         if (Env::has('add_users')) {
  59             S::assert_xsrf_token();
  60
  61             $nl->bulkSubscribe(array_keys(Env::v('add_users')));
  62
  63             $page->trigSuccess('Ajouts réalisés avec succès.');
  64         }
  65
  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'));
  74
  75         $users = User::getBulkUsersWithUIDs($uids);
  76         usort($users, 'User::compareDirectoryName');
  77
  78         $page->setTitle('Synchronisation de la newsletter');
  79         $page->changeTpl('newsletter/sync.tpl');
  80         $page->assign('users', $users);
  81     }
  82
  83     public function handler_admin_nl_enable($page)
  84     {
  85         global $globals;
  86         $nl = $this->getNl();
  87         if ($nl) {
  88             return PL_FORBIDDEN;
  89         }
  90
  91         if (Post::has('title')) {
  92             if (!S::has_xsrf_token()) {
  93                 return PL_FORBIDDEN;
  94             }
  95
  96             XDB::execute('INSERT INTO  newsletters
  97                                   SET  group_id = {?}, name = {?}',
  98                                   $globals->asso('id'), Post::s('title'));
  99
 100             $mailer = new PlMailer();
 101             $mailer->assign('group', $globals->asso('nom'));
 102             $mailer->assign('user', S::user());
 103             $mailer->send();
 104
 105             $page->trigSuccessRedirect("La lettre d'informations du groupe " .
 106                                        $globals->asso('nom') . " a bien été créée",
 107                                        $globals->asso('shortname') . '/admin/nl');
 108         }
 109         $page->setTitle('Activation de la newsletter');
 110         $page->changeTpl('newsletter/enable.tpl');
 111     }
 112 }
 113
 114 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
 115 ?>