function selectAll(idCheck,numRows,action) { for(i=0;i'; $tbl_session_category = Database::get_main_table(TABLE_MAIN_SESSION_CATEGORY); $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION); $page=intval($_GET['page']); $action= Security::remove_XSS($_REQUEST['action']); $sort=in_array($_GET['sort'],array('name','nbr_session','date_start','date_end'))? Security::remove_XSS($_GET['sort']) : 'name'; $idChecked = Security::remove_XSS($_REQUEST['idChecked']); $order = (isset($_REQUEST['order']))? Security::remove_XSS($_REQUEST['order']): 'ASC'; if ($action == 'delete_on_session' || $action == 'delete_off_session') { $delete_session = ($action == 'delete_on_session')? true: false; SessionManager::delete_session_category($idChecked, $delete_session); header('Location: '.api_get_self().'?sort='.$sort.'&action=show_message&message='.urlencode(get_lang('SessionCategoryDelete'))); exit(); } $interbreadcrumb[]=array("url" => "index.php","name" => get_lang('PlatformAdmin')); if (isset ($_GET['search']) && $_GET['search'] == 'advanced') { $interbreadcrumb[] = array ("url" => 'session_category_list.php', "name" => get_lang('ListSessionCategory')); $tool_name = get_lang('SearchASession'); Display :: display_header($tool_name); $form = new FormValidator('advanced_search','get'); $form->addElement('header', '', $tool_name); $active_group = array(); $active_group[] = $form->createElement('checkbox','active','',get_lang('Active')); $active_group[] = $form->createElement('checkbox','inactive','',get_lang('Inactive')); $form->addGroup($active_group,'',get_lang('ActiveSession'),'
',false); $form->addElement('style_submit_button', 'submit',get_lang('SearchUsers'),'class="search"'); $defaults['active'] = 1; $defaults['inactive'] = 1; $form->setDefaults($defaults); $form->display(); } else { $limit = 20; $from = $page * $limit; //if user is crfp admin only list its sessions if(!api_is_platform_admin()) { $where .= (empty($_REQUEST['keyword']) ? " " : " WHERE name LIKE '%".addslashes($_REQUEST['keyword'])."%'"); } else { $where .= (empty($_REQUEST['keyword']) ? " " : " WHERE name LIKE '%".addslashes($_REQUEST['keyword'])."%'"); } $query = "SELECT sc.*, (select count(id) FROM $tbl_session WHERE session_category_id = sc.id) as nbr_session FROM $tbl_session_category sc $where ORDER BY $sort $order LIMIT $from,".($limit+1); $query_rows = "SELECT count(*) as total_rows FROM $tbl_session_category sc $where "; $order = ($order == 'ASC')? 'DESC': 'ASC'; $result_rows = Database::query($query_rows,__FILE__,__LINE__); $recorset = Database::fetch_array($result_rows); $num = $recorset['total_rows']; $result = Database::query($query,__FILE__,__LINE__); $Sessions = Database::store_result($result); $nbr_results = sizeof($Sessions); $tool_name = get_lang('ListSessionCategory'); Display::display_header($tool_name); api_display_tool_title($tool_name); if (!empty($_GET['warn'])) { Display::display_warning_message(urldecode($_GET['warn']),false); } if(isset($_GET['action'])) { Display::display_normal_message(stripslashes($_GET['message']),false); } ?>
'.Display::return_icon('view_more_stats.gif',get_lang('AddSession')).get_lang('AddSessionCategory').'
'; ?>

'; } else { if ($num > $limit) { if ($page) { ?> | $limit) { ?>

$enreg) { if($key == $limit) { break; } $sql = 'SELECT COUNT(session_category_id) FROM '.$tbl_session.' WHERE session_category_id = '.intval($enreg['id']); $rs = Database::query($sql, __FILE__, __LINE__); list($nb_courses) = Database::fetch_array($rs); ?>
 
".$nb_courses." Sesion(es) "; ?>

$limit) { if ($page) { ?> | $limit) { ?>

 -