htdocs/marketing/private.php

   1 <?php
   2 /***************************************************************************
   3  *  Copyright (C) 2003-2004 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 require_once('xorg.inc.php');
  23 new_admin_page('marketing/private.tpl');
  24
  25 $uid = Env::get('uid');
  26 $res = $globals->xdb->query("SELECT nom, prenom, promo, matricule FROM auth_user_md5 WHERE user_id={?} AND perms='pending'", $uid);
  27
  28 if (list($nom, $prenom, $promo, $matricule) = $res->fetchOneRow()) {
  29     require_once('register.inc.php');
  30     $matricule_X = get_X_mat($matricule);
  31     $page->gassign('nom');
  32     $page->gassign('prenom');
  33     $page->gassign('promo');
  34     $page->gassign('matricule');
  35     $page->assign('matricule_X',$matricule_X);
  36 } else {
  37     $page->kill('uid invalide');
  38 }
  39
  40 if (Env::has('del')) {
  41     $globals->xdb->execute('DELETE FROM register_marketing WHERE uid={?} AND email={?}', $uid, Env::get('del'));
  42 }
  43
  44 if (Env::has('rel') && !Env::has('valider')) {
  45     require_once('marketing.inc.php');
  46     list($to, $title, $text) = mark_text_mail($uid, Env::get('rel'));
  47     $from = mark_from_mail($uid, Env::get('rel'));
  48     $page->assign('rel_from_user', $from);
  49     $page->assign('rel_from_staff', "\"Equipe Polytechnique.org\" <register@polytechnique.org>");
  50     $page->assign('rel_to', $to);
  51     $page->assign('rel_title', $title);
  52     $page->assign('rel_text', $text);
  53 }
  54
  55 if (Env::get('valider') == 'Envoyer') {
  56     require_once('marketing.inc.php');
  57     mark_send_mail($uid, Env::get('rel'), Env::get('from'), Env::get('to'), Env::get('title'), Env::get('message'));
  58     $page->trig("Mail envoyé");
  59 }
  60
  61 if (Env::has('relance')) {
  62     require_once('marketing.inc.php');
  63     if (relance($uid)) {
  64         $page->trig('relance faite');
  65     }
  66 }
  67
  68 if (Env::get('action') == 'ajouter') {
  69     $globals->xdb->execute(
  70         "INSERT INTO register_marketing
  71                  SET uid = {?}, sender = {?}, email = {?},
  72                      date = NOW(), type = {?}",
  73         $uid, Session::get('uid'), Env::get('email'), Env::get('type'));
  74 }
  75
  76 $res = $globals->xdb->iterator(
  77         "SELECT  r.*, a.alias
  78            FROM  register_marketing AS r
  79      INNER JOIN  aliases            AS a ON (r.sender=a.id AND a.type = 'a_vie')
  80           WHERE  uid={?}
  81        ORDER BY  date", $uid);
  82 $page->assign('addr', $res);
  83
  84 $res = $globals->xdb->query("SELECT date, relance FROM register_pending WHERE uid = {?}", $uid);
  85 if (list($pending, $relance) = $res->fetchOneCell()) {
  86     $page->gassign('pending');
  87     $page->gassign('relance');
  88 }
  89
  90
  91 $page->run();
  92
  93 // vim:set et sw=4 sws=4 sts=4:
  94 ?>