<?php
/***************************************************************************
- * Copyright (C) 2003-2009 Polytechnique.org *
+ * Copyright (C) 2003-2010 Polytechnique.org *
* http://opensource.polytechnique.org/ *
* *
* This program is free software; you can redistribute it and/or modify *
public function Prepare(&$page)
{
parent::Prepare($page);
+ $profile = $this->user->profile();
- $res = XDB::query('SELECT date < DATE_SUB(NOW(), INTERVAL 365 DAY) AS is_profile_old,
- date AS profile_date, LENGTH(p.attach) > 0 AS photo
- FROM auth_user_md5 AS u
- LEFT JOIN photo AS p ON (u.user_id = p.uid)
- WHERE user_id = {?}',
- $this->user->id());
- list($is_profile_old, $profile_date, $has_photo) = $res->fetchOneRow();
+ $page->assign('profile_incitation', $profile->is_old);
+ $page->assign('profile_last_update', $profile->last_change);
+ $page->assign('photo_incitation', !$profile->has_photo);
- $page->assign('profile_incitation', $is_profile_old);
- $page->assign('profile_last_update', $profile_date);
- $page->assign('photo_incitation', $has_photo);
-
- require_once 'geoloc.inc.php';
- $res = localize_addresses($this->user->id());
- $page->assign('geocoding_incitation', count($res));
-
- $page->assign('incitations_count',
- ($is_profile_old ? 1 : 0) +
- ($has_photo ? 0 : 1) +
- (count($res) > 0 ? 1 : 0));
+ $res = XDB::query('SELECT COUNT(*)
+ FROM profile_addresses
+ WHERE pid = {?} AND accuracy = 0',
+ $profile->id());
+ $page->assign('geocoding_incitation', $res->fetchOneCell());
}
public function template()
public static function IsCandidate(User &$user, $candidate)
{
- $res = XDB::query('SELECT date < DATE_SUB(NOW(), INTERVAL 365 DAY) AS is_profile_old,
- p.attach AS photo
- FROM auth_user_md5 AS u
- LEFT JOIN photo AS p ON (u.user_id = p.uid)
- WHERE user_id = {?}',
- $user->id());
- list($is_profile_old, $has_photo) = $res->fetchOneRow();
- require_once 'geoloc.inc.php';
- $res = localize_addresses($user->id());
-
- return (count($res) || !$has_photo || $is_profile_old);
+ $profile = $user->profile();
+ if (!$profile) {
+ return false;
+ }
+ return !$profile->has_photo || $profile->is_old;
}
}