include/reminder/profile_update.inc.php

   1 <?php
   2 /***************************************************************************
   3  *  Copyright (C) 2003-2009 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 ReminderProfileUpdate extends Reminder
  23 {
  24     public function HandleAction($action)
  25     {
  26         switch ($action) {
  27           case 'dismiss':
  28             $this->UpdateOnDismiss();
  29             break;
  30
  31           case 'profile':
  32             $this->UpdateOnDismiss();
  33             pl_redirect('profile/edit');
  34             break;
  35
  36           case 'photo':
  37             $this->UpdateOnDismiss();
  38             pl_redirect('photo/change');
  39             break;
  40
  41           case 'geoloc':
  42             $this->UpdateOnDismiss();
  43             pl_redirect('profile/edit/adresses');
  44             break;
  45         }
  46     }
  47
  48     public function Prepare(&$page)
  49     {
  50         parent::Prepare($page);
  51
  52         $res = XDB::query('SELECT  date < DATE_SUB(NOW(), INTERVAL 365 DAY) AS is_profile_old,
  53                                    date AS profile_date, LENGTH(p.attach) > 0 AS has_photo
  54                              FROM  auth_user_md5     AS u
  55                         LEFT JOIN  photo             AS p ON (u.user_id = p.uid)
  56                             WHERE  user_id = {?}',
  57                           $this->user->id());
  58         list($is_profile_old, $profile_date, $has_photo) = $res->fetchOneRow();
  59
  60         $page->assign('profile_incitation', $is_profile_old);
  61         $page->assign('profile_last_update', $profile_date);
  62         $page->assign('photo_incitation', !$has_photo);
  63
  64         $res = XDB::query('SELECT  COUNT(*)
  65                              FROM  profile_addresses
  66                             WHERE  pid = {?} AND accuracy = 0',
  67                           $this->user->id());
  68         $page->assign('geocoding_incitation', $res->fetchOneCell());
  69     }
  70
  71     public function template()
  72     {
  73         return 'reminder/profile_update.tpl';
  74     }
  75     public function title()
  76     {
  77         return "Mise à jour de ton profil";
  78     }
  79     public function warning()
  80     {
  81         return true;
  82     }
  83
  84     public static function IsCandidate(User &$user, $candidate)
  85     {
  86         $res = XDB::query('SELECT  date < DATE_SUB(NOW(), INTERVAL 365 DAY) AS is_profile_old,
  87                                    p.attach AS photo
  88                              FROM  auth_user_md5 AS u
  89                         LEFT JOIN  photo         AS p ON (u.user_id = p.uid)
  90                             WHERE  user_id = {?}',
  91                           $user->id());
  92         list($is_profile_old, $has_photo) = $res->fetchOneRow();
  93
  94         $res = XDB::query('SELECT  COUNT(*)
  95                              FROM  profile_addresses
  96                             WHERE  pid = {?} AND accuracy = 0',
  97                           $user->id());
  98
  99         return ($res->fetchOneCell() || !$has_photo || $is_profile_old);
 100     }
 101 }
 102
 103 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
 104 ?>