modules/googleapps.php

   1 <?php
   2 /***************************************************************************
   3  *  Copyright (C) 2003-2008 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 class GoogleAppsModule extends PLModule
  23 {
  24     function handlers()
  25     {
  26         global $globals;
  27         if (!$globals->mailstorage->googleapps_domain) {
  28             return array();
  29         }
  30
  31         return array(
  32             'googleapps'            => $this->make_hook('index', AUTH_MDP),
  33             'admin/googleapps'      => $this->make_hook('admin', AUTH_MDP. 'admin'),
  34             'admin/googleapps/job'  => $this->make_hook('admin_job', AUTH_MDP, 'admin'),
  35             'admin/googleapps/user' => $this->make_hook('admin_user', AUTH_MDP, 'admin'),
  36         );
  37     }
  38
  39     function handler_index(&$page, $action = null, $subaction = null)
  40     {
  41         require_once("emails.inc.php");
  42         require_once("googleapps.inc.php");
  43         $page->changeTpl('googleapps/index.tpl');
  44         $page->addJsLink('motdepasse.js');
  45         $page->assign('xorg_title', 'Polytechnique.org - Compte Google Apps');
  46
  47         $account = new GoogleAppsAccount(S::v('uid'), S::v('forlife'));
  48
  49         // Fills up the 'is Google Apps redirection active' variable.
  50         $page->assign('redirect_active', false);
  51         $page->assign('redirect_unique', true);
  52
  53         if ($account->active()) {
  54             $redirect = new Redirect(S::v('uid'));
  55             $page->assign('redirect_unique', !$redirect->other_active('googleapps'));
  56
  57             $storage = new EmailStorage(S::v('uid'), 'googleapps');
  58             $page->assign('redirect_active', $storage->active);
  59         }
  60
  61         // Updates the Google Apps account as required.
  62         if ($action) {
  63             if ($action == 'password') {
  64                 if ($subaction == 'sync') {
  65                     $account->set_password_sync(true);
  66                     $account->set_password(S::v('password'));
  67                     pl_redirect('googleapps#password');
  68                 } else if ($subaction == 'nosync') {
  69                     $account->set_password_sync(false);
  70                 } else if (Post::has('response2') && !$account->sync_password) {
  71                     $account->set_password(Post::v('response2'));
  72                 }
  73             }
  74
  75             if ($action == 'suspend' && Post::has('suspend') && $account->active()) {
  76                 if ($account->pending_update_suspension) {
  77                     $page->trig("Ton compte est déjà en cours de désactivation.");
  78                 } else {
  79                     if ($redirect->modify_one_email('googleapps', false) == SUCCESS) {
  80                         $account->suspend();
  81                         $page->trig("Ton compte Google Apps est dorénavant désactivé.");
  82                     } else {
  83                         $page->trig("Ton compte Google Apps est ta seule adresse de redirection. Ton compte ne peux pas être désactivé.");
  84                     }
  85                 }
  86             } elseif ($action == 'unsuspend' && Post::has('unsuspend') && $account->suspended()) {
  87                 $account->unsuspend(Post::b('redirect_mails', true));
  88                 $page->trig("Ta demande de réactivation a bien été prise en compte.");
  89             }
  90
  91             if ($action == 'create') {
  92                 $page->assign('has_password_sync', Get::has('password_sync'));
  93                 $page->assign('password_sync', Get::b('password_sync', true));
  94             }
  95             if ($action == 'create' && Post::has('password_sync') && Post::has('redirect_mails')) {
  96                 $password_sync = Post::b('password_sync');
  97                 $redirect_mails = Post::b('redirect_mails');
  98                 if ($password_sync) {
  99                     $password = S::v('password');
 100                 } else {
 101                     $password = Post::v('response2');
 102                 }
 103
 104                 $account->create($password_sync, $password, $redirect_mails);
 105                 $page->trig("La demande de création de ton compte Google Apps a bien été enregistrée.");
 106             }
 107         }
 108
 109         $page->assign('account', $account);
 110     }
 111
 112     function handler_admin(&$page, $action = null) {
 113         require_once("googleapps.inc.php");
 114         $page->changeTpl('googleapps/admin.tpl');
 115         $page->assign('xorg_title', 'Polytechnique.org - Administration Google Apps');
 116         $page->assign('googleapps_admin', GoogleAppsAccount::is_administrator(S::v('uid')));
 117
 118         if ($action == 'ack') {
 119             $qid = @func_get_arg(2);
 120             if ($qid) {
 121                 XDB::execute(
 122                     "DELETE FROM  gapps_queue
 123                            WHERE  q_id = {?} AND p_status = 'hardfail'", $qid);
 124                 $page->trig("La requête échouée a bien été retirée.");
 125             }
 126         }
 127
 128         // Retrieves latest pending administrative requests from the gappsd queue.
 129         $res = XDB::iterator(
 130             "SELECT  q_id, q_recipient_id, a.alias, j_type, j_parameters,
 131                      UNIX_TIMESTAMP(q.p_entry_date) AS p_entry_date
 132                FROM  gapps_queue AS q
 133           LEFT JOIN  aliases AS a ON (a.id = q_recipient_id AND a.type = 'a_vie')
 134               WHERE  p_status IN ('idle', 'active', 'softfail') AND
 135                      p_admin_request IS TRUE
 136            ORDER BY  p_entry_date");
 137         while ($request = $res->next()) {
 138             $j_parameters = json_decode($request['j_parameters'], true);
 139             unset($j_parameters['username']);
 140             $parameters = array_keys($j_parameters);
 141             $request['parameters'] = implode(', ', $parameters);
 142
 143             $page->append('admin_requests', $request);
 144         }
 145
 146         // Retrieves latest failed requests from the gappsd queue.
 147         $res = XDB::iterator(
 148             "SELECT  q.q_id, q.q_recipient_id, a.alias, q.j_type, q.r_result,
 149                      UNIX_TIMESTAMP(q.p_entry_date) AS p_entry_date
 150                FROM  gapps_queue AS q
 151           LEFT JOIN  aliases AS a ON (a.id = q.q_recipient_id AND a.type = 'a_vie')
 152               WHERE  q.p_status = 'hardfail'
 153            ORDER BY  p_entry_date DESC
 154               LIMIT  20");
 155         $page->assign('failed_requests', $res);
 156     }
 157
 158     function handler_admin_job(&$page, $job = null) {
 159         require_once("googleapps.inc.php");
 160         $page->changeTpl('googleapps/admin.job.tpl');
 161         $page->assign('xorg_title', 'Polytechnique.org - Administration Google Apps');
 162         $page->assign('googleapps_admin', GoogleAppsAccount::is_administrator(S::v('uid')));
 163
 164         if ($job) {
 165             $res = XDB::query(
 166                 "SELECT  q.*, ao.alias AS q_owner, ar.alias AS q_recipient
 167                    FROM  gapps_queue AS q
 168               LEFT JOIN  aliases AS ao ON (ao.id = q.q_owner_id AND ao.type = 'a_vie')
 169               LEFT JOIN  aliases AS ar ON (ar.id = q.q_recipient_id AND ar.type = 'a_vie')
 170                   WHERE  q_id = {?}", $job);
 171             $sql_job = $res->fetchOneAssoc();
 172             $sql_job['decoded_parameters'] = var_export(json_decode($sql_job['j_parameters'], true), true);
 173             $page->assign('job', $sql_job);
 174         }
 175     }
 176
 177     function handler_admin_user(&$page, $user = null, $action = null) {
 178         require_once("emails.inc.php");
 179         require_once("googleapps.inc.php");
 180         $page->changeTpl('googleapps/admin.user.tpl');
 181         $page->assign('xorg_title', 'Polytechnique.org - Administration Google Apps');
 182         $page->assign('googleapps_admin', GoogleAppsAccount::is_administrator(S::v('uid')));
 183
 184         if (!$user && Post::has('login')) {
 185             $user = Post::v('login');
 186         }
 187         if ($user && !is_numeric($user)) {
 188             $res = XDB::query("SELECT id FROM aliases WHERE alias = {?} AND type != 'homonyme'", $user);
 189             $user = $res->fetchOneCell();
 190         }
 191
 192         if ($user) {
 193             $account = new GoogleAppsAccount($user);
 194             $storage = new EmailStorage($user, 'googleapps');
 195
 196             // Force synchronization of plat/al and Google Apps passwords.
 197             if ($action == 'forcesync' && $account->sync_password) {
 198                 $res = XDB::query("SELECT password FROM auth_user_md5 WHERE user_id = {?}", $user);
 199                 $account->set_password($res->fetchOneCell());
 200                 $page->trig('Le mot de passe a été synchronisé.');
 201             }
 202
 203             // Displays basic account information.
 204             $page->assign('account', $account);
 205             $page->assign('admin_account', GoogleAppsAccount::is_administrator($user));
 206             $page->assign('googleapps_storage', $storage->active);
 207             $page->assign('user', $user);
 208
 209             // Retrieves user's pending requests.
 210             $res = XDB::iterator(
 211                 "SELECT  q_id, q_recipient_id, p_status, j_type, UNIX_TIMESTAMP(p_entry_date) AS p_entry_date
 212                    FROM  gapps_queue
 213                   WHERE  q_recipient_id = {?}
 214                ORDER BY  p_entry_date DESC", $user);
 215             $page->assign('requests', $res);
 216         }
 217     }
 218 }
 219
 220 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
 221 ?>