htdocs/marketing/promo.php

   1 <?php
   2 /***************************************************************************
   3  *  Copyright (C) 2003-2006 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
  23 require_once("xorg.inc.php");
  24 new_admin_page('marketing/promo.tpl');
  25
  26 $promo = (integer) (isset($_REQUEST["promo"]) ? $_REQUEST["promo"] : $_SESSION["promo"]);
  27 $page->assign('promo', $promo);
  28
  29 $sql = "SELECT  u.user_id, u.nom, u.prenom, u.last_known_email, u.matricule_ax,
  30                 IF(MAX(m.last)>p.relance, MAX(m.last), p.relance) AS dern_rel, p.email
  31           FROM  auth_user_md5      AS u
  32      LEFT JOIN  register_pending   AS p ON p.uid = u.user_id
  33      LEFT JOIN  register_marketing AS m ON m.uid = u.user_id
  34          WHERE  u.promo = {?} AND u.deces = 0 AND u.perms='pending'
  35       GROUP BY  u.user_id
  36       ORDER BY  nom, prenom";
  37 $page->assign('nonins', $globals->xdb->iterator($sql, $promo));
  38
  39 $page->run();
  40
  41 ?>