<?php
/***************************************************************************
 *  Copyright (C) 2003-2011 Polytechnique.org                              *
 *  http://opensource.polytechnique.org/                                   *
 *                                                                         *
 *  This program is free software; you can redistribute it and/or modify   *
 *  it under the terms of the GNU General Public License as published by   *
 *  the Free Software Foundation; either version 2 of the License, or      *
 *  (at your option) any later version.                                    *
 *                                                                         *
 *  This program is distributed in the hope that it will be useful,        *
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of         *
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the          *
 *  GNU General Public License for more details.                           *
 *                                                                         *
 *  You should have received a copy of the GNU General Public License      *
 *  along with this program; if not, write to the Free Software            *
 *  Foundation, Inc.,                                                      *
 *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
 ***************************************************************************/

function fill_email_combobox(PlPage $page, $user = null, $profile = null)
{
    if (is_null($user)) {
        $user = S::user();
    }
    if (is_null($profile)) {
        /* Always refetch the profile. */
        $profile = $user->profile(true);
    }
    $email_type = 'directory';

    if ($profile) {
        $email_directory = $profile->email_directory;
        $page->assign('email_directory', $email_directory);

        $res = XDB::fetchAllAssoc('SELECT  email
                                     FROM  profile_job
                                    WHERE  pid = {?}', $profile->id());
        $pro = array();
        foreach ($res as $res_it) {
            if ($res_it['email'] != '') {
                $pro[] = $res_it['email'];
                if ($email_directory == $res_it['email']) {
                    $email_type = "pro";
                }
            }
        }
        $page->assign('list_email_pro', $pro);
    }

    if ($user) {
        $res = XDB::fetchAllAssoc('SELECT  CONCAT(s.email, \'@\', d.name) AS email
                                     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());
        $page->assign('list_email_X', $res);
        foreach ($res as $res_it) {
            if ($email_directory == $res_it) {
                $email_type = 'X';
            }
        }

        require_once 'emails.inc.php';
        $redirect = new Redirect($user);
        $redir    = array();
        foreach ($redirect->emails as $redirect_it) {
            if ($redirect_it->is_redirection()) {
                $redir[] = $redirect_it->email;
                if ($email_directory == $redirect_it->email) {
                    $email_type = 'redir';
                }
            }
        }
        $page->assign('list_email_redir', $redir);
        $page->assign('email_type', $email_type);
    } else {
        $page->assign('list_email_X', array());
        $page->assign('list_email_redir', array());
        $page->assign('list_email_pro', array());
    }
}

// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
?>