/** * $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(); $current = intval(CValue::get('current', 0)); $step = intval(CValue::get('step', 20)); $interv = CValue::get("interv", ""); $exclude_without_code = CValue::get("exclude_without_code", "false"); $intervenant = new CIntervenantCdARR(); $intervenants = $intervenant->loadList(null, "code"); $mediuser = 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["users_mediboard.actif"] = "= '1'"; $where["functions_mediboard.group_id"] = "= '" . CGroups::loadCurrent()->_id . "'"; if ($interv) { $last_space = strrpos($interv, " "); $last_name = substr($interv, 0, $last_space); $where[] = "users.user_last_name = '{$last_name}'\n OR users.user_last_name = '{$last_name}'"; } $limit = "{$current}, {$step}"; $order = "users.user_last_name ASC, users.user_first_name ASC"; $total = $mediuser->countList($where, null, $ljoin);