<?php

/**
 * $Id$
 *
 * @package    Mediboard
 * @subpackage SSR
 * @author     SARL OpenXtrem <*****@*****.**>
 * @license    GNU General Public License, see http://www.gnu.org/licenses/gpl.html
 * @version    $Revision$
 */
$keywords = CValue::post("keywords_nom", "%%");
$exclude_without_code = CValue::post("exclude_without_code");
$mediuser = new CMediusers();
$ds = $mediuser->_spec->ds;
$ljoin = array();
$ljoin["users"] = "users.user_id = users_mediboard.user_id";
$ljoin["functions_mediboard"] = "functions_mediboard.function_id = users_mediboard.function_id";
$where = array();
$where[] = "user_last_name " . $ds->prepareLike("{$keywords}%") . "OR user_first_name " . $ds->prepareLike("{$keywords}%");
$where["users_mediboard.actif"] = "= '1'";
if ($exclude_without_code == "true") {
    $where["code_intervenant_cdarr"] = "IS NOT NULL";
}
$order = "users.user_last_name ASC, users.user_first_name ASC";
$mediusers = $mediuser->loadlist($where, $order, null, null, $ljoin);
$smarty = new CSmartyDP();
$smarty->assign("mediusers", $mediusers);
$smarty->assign("nodebug", true);
$smarty->assign("keywords", $keywords);
$smarty->display("inc_interv_autocomplete.tpl");