<?php
/***************************************************************************
- * Copyright (C) 2003-2008 Polytechnique.org *
+ * Copyright (C) 2003-2011 Polytechnique.org *
* http://opensource.polytechnique.org/ *
* *
* This program is free software; you can redistribute it and/or modify *
* 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *
***************************************************************************/
-function fill_email_combobox(PlPage& $page)
+function fill_email_combobox(PlPage $page, array $retrieve, $user = null)
{
- global $globals;
-
- $uid = S::v('uid');
- $forlife = S::v('forlife');
- $email_type = "directory";
-
- $res = XDB::query(
- "SELECT email_directory
- FROM profile_directory
- WHERE uid={?}", $uid);
- $email_directory = $res->fetchOneCell();
- if ($email_directory) {
- $page->assign('email_directory', $email_directory);
- list($alias, $domain) = explode('@', $email_directory);
- } else {
- $page->assign('email_directory', '');
- $email_type = NULL;
- $alias = $domain = '';
+ require_once 'emails.inc.php';
+ if (is_null($user)) {
+ $user = S::user();
}
+ /* Always refetch the profile. */
+ $profile = $user->profile(true);
- $res = XDB::query(
- "SELECT alias
- FROM virtual
- INNER JOIN virtual_redirect USING(vid)
- WHERE (redirect={?} OR redirect={?})
- AND alias LIKE '%@{$globals->mail->alias_dom}'",
- $forlife . '@' . $globals->mail->domain, $forlife . '@' . $globals->mail->domain2);
- $melix = $res->fetchOneCell();
- if ($melix) {
- list($melix) = explode('@', $melix);
- $page->assign('melix', $melix);
- if (($domain == $globals->mail->alias_dom) || ($domain == $globals->mail->alias_dom2)) {
- $email_type = "melix";
- }
+ $emails = array();
+ if (in_array('source', $retrieve)) {
+ $emails['Emails polytechniciens'] = XDB::fetchColumn('SELECT CONCAT(s.email, \'@\', d.name)
+ FROM email_source_account AS s
+ INNER JOIN email_virtual_domains AS m ON (s.domain = m.id)
+ INNER JOIN email_virtual_domains AS d ON (d.aliasing = m.id)
+ WHERE s.uid = {?}
+ ORDER BY s.email, d.name',
+ $user->id());
}
- $res = XDB::query(
- "SELECT alias
- FROM aliases
- WHERE id={?} AND (type='a_vie' OR type='alias')", $uid);
- $res = $res->fetchAllAssoc();
- $page->assign('list_email_X', $res);
- if (($domain == $globals->mail->domain) || ($domain == $globals->mail->domain2)) {
- foreach ($res as $res_it) {
- if ($alias == $res_it['alias']) {
- $email_type = "X";
+ if (in_array('redirect', $retrieve)) {
+ $redirect = new Redirect($user);
+ $emails['Redirections'] = array();
+ foreach ($redirect->emails as $redirect_it) {
+ if ($redirect_it->is_redirection()) {
+ $emails['Redirections'][] = $redirect_it->email;
}
}
}
- require_once 'emails.inc.php';
- $redirect = new Redirect($uid);
- $redir = array();
- foreach ($redirect->emails as $redirect_it) {
- if ($redirect_it instanceof EmailRedirection) {
- $redir[] = $redirect_it->email;
- if ($email_directory == $redirect_it->email) {
- $email_type = "redir";
+ if ($profile) {
+ if (in_array('job', $retrieve)) {
+ $emails['Emails professionels'] = XDB::fetchColumn('SELECT email
+ FROM profile_job
+ WHERE pid = {?} AND email IS NOT NULL AND email != \'\'',
+ $profile->id());
+ }
+
+ if ($profile->email_directory) {
+ if (in_array('directory', $retrieve)) {
+ foreach ($emails as &$email_list) {
+ foreach ($email_list as $key => $email) {
+ if ($profile->email_directory == $email) {
+ unset($email_list[$key]);
+ }
+ }
+ }
+ $emails['Email annuaire AX'] = array($profile->email_directory);
+ } elseif (in_array('stripped_directory', $retrieve)) {
+ if (User::isForeignEmailAddress($profile->email_directory)) {
+ $is_redirect = XDB::fecthOneCell('SELECT COUNT(*)
+ FROM email_redirect_account
+ WHERE uid = {?} AND redirect = {?}',
+ $user->id(), $profile->email_directory);
+ if ($is_redirect == 0) {
+ $emails['Email annuaire AX'] = array($profile->email_directory);
+ }
+ }
}
}
- }
- $page->assign('list_email_redir', $redir);
- $res = XDB::query(
- "SELECT email
- FROM entreprises
- WHERE uid={?}", $uid);
- $res = $res->fetchAllAssoc();
- $pro = array();
- foreach ($res as $res_it) {
- if ($res_it['email'] != '') {
- $pro[] = $res_it['email'];
- if ($email_directory == $res_it['email']) {
- $email_type = "pro";
+ if (isset($emails['Emails professionels']) && isset($emails['Redirections'])) {
+ $intersect = array_intersect($emails['Emails professionels'], $emails['Redirections']);
+ foreach ($intersect as $key => $email) {
+ unset($emails['Emails professionels'][$key]);
}
}
}
- $page->assign('list_email_pro', $pro);
- $page->assign('email_type', $email_type);
+ $emails_count = 0;
+ foreach ($emails as $email_list) {
+ $emails_count += count($email_list);
+ }
+ $page->assign('emails_count', $emails_count);
+ $page->assign('email_lists', $emails);
}
// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: