* $Id$
*
* @package Mediboard
* @subpackage SSR
* @author SARL OpenXtrem <*****@*****.**>
* @license GNU General Public License, see http://www.gnu.org/licenses/gpl.html
* @version $Revision$
*/
CCanDo::checkRead();
$needle = CValue::post("_executant", "aaa");
$intervenant = new CMediusers();
$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["code_intervenant_cdarr"] = "IS NOT NULL";
$where["users_mediboard.actif"] = "= '1'";
$where["functions_mediboard.group_id"] = "= '" . CGroups::loadCurrent()->_id . "'";
$order = "users.user_last_name ASC, users.user_first_name ASC";
/** @var CMediusers[] $intervenants */
$intervenants = $intervenant->seek($needle, $where, 100, false, $ljoin, $order);
foreach ($intervenants as &$_intervenant) {
$_intervenant->loadRefFunction();
$_intervenant->loadRefIntervenantCdARR();
}
// Création du template
$smarty = new CSmartyDP();
$smarty->assign("intervenants", $intervenants);
$smarty->assign("needle", $needle);
$smarty->assign("nodebug", true);
$smarty->display("inc_do_intervenant_autocomplete.tpl");
$order = "functions_mediboard.text {$order_way}, users.user_last_name ASC, users.user_first_name ASC";
}
if ($order_col == "user_username") {
$order = "users.user_username {$order_way}, users.user_last_name ASC, users.user_first_name ASC";
}
if ($order_col == "user_last_name") {
$order = "users.user_last_name {$order_way}, users.user_first_name ASC";
}
if ($order_col == "user_first_name") {
$order = "users.user_first_name {$order_way}, users.user_last_name ASC";
}
if ($order_col == "user_type") {
$order = "users.user_type {$order_way}, users.user_last_name ASC, users.user_first_name ASC";
}
if ($filter) {
$mediusers = $mediuser->seek($filter, $where, "{$page}, {$step}", true, $ljoin, $order);
$total_mediuser = $mediuser->_totalSeek;
} else {
$total_mediuser = $mediuser->countList($where, null, $ljoin);
$mediusers = $mediuser->loadList($where, $order, "{$page}, {$step}", "users_mediboard.user_id", $ljoin);
}
/** @var CMediusers[] $mediusers */
foreach ($mediusers as $_mediuser) {
$_mediuser->loadRefFunction();
$_mediuser->loadRefProfile();
$_mediuser->loadRefUser();
$_mediuser->_ref_user->isLDAPLinked();
$_mediuser->getLastLogin();
}
$smarty = new CSmartyDP();
$smarty->assign("mediusers", $mediusers);