$sql .= "LEFT OUTER JOIN `" . $_SESSION['Application_host'] . "`.`T_country` ON T_country.Iso = T_entry.Country ";
$sql .= "GROUP BY T_massif.Id ";
$columns_params = array(0 => "[hidden]|[hidden]Id", 1 => "[hidden]|[hidden]Locked", 2 => "[hidden]|<convert>#label=551<convert><br /><convert>#label=98<convert>", 3 => "T_massif*Name|[hidden]<convert>#label=551<convert>", 4 => "T_entry*Country|[hidden]<convert>#label=98<convert>|SELECT Iso AS value," . $_SESSION['language'] . "_name AS text FROM T_country ORDER BY text", 5 => "[hidden]|[hidden]5");
$param_link = "JavaScript:massifOnClick(event,'<Id>');";
$links = array(2 => array('conditions' => array(1 => '0'), 'parameters' => array('<Id>' => 0), 'link' => $param_link, 'target' => 'onclick'));
$input_type = array('type' => 'radio', 'conditions' => array(1 => '0'));
$style = array(2 => array('tag' => 'div', 'class' => 'plt_warning', 'conditions' => array(5 => '1')));
$default_order = 3;
$length_page = 10;
$records_by_page_array = array(5, 10, 15, 20, 25, 30, 40, 50);
$records_by_page = isset($_POST['records_by_page']) ? $_POST['records_by_page'] : 15;
$filter_form = "automatic_form";
$list_form = "result_form";
$result = getRowsFromSQL($sql, $columns_params, $links, $records_by_page, $filter_form, $list_form, $_POST, $input_type, $style, $default_order, true, true, "");
$resource_id = $result['resource_id'];
$filter_fields = getFilterFields($sql, $columns_params, $_POST, $filter_form, "<convert>#label=542<convert>", true, $resource_id);
//Tous
$rows = $result['rows'];
$total_count = $result['total_count'];
$local_count = $result['local_count'];
$count_page = ceil($total_count / $records_by_page);
$current_page = isset($_POST['current']) ? $_POST['current'] : 1;
$order = isset($_POST['order']) ? $_POST['order'] : '';
$by = isset($_POST['by']) ? $_POST['by'] : $default_order;
if ($total_count > 0) {
$navigator = getPageNavigator($length_page, $current_page, $count_page, $filter_form);
} else {
$navigator = "";
}
?>
<div>
$records_by_page_array = array(5, 10, 15, 20, 25, 30, 40, 50);
$records_by_page = isset($_POST['records_by_page']) ? $_POST['records_by_page'] : 10;
$filter_form = "automatic_form";
$list_form = "result_form";
$default_array = array('submit_filter' => '1');
if (allowAccess(request_approve_all)) {
//$default_array[idEncode("IF(((T_request*Id_author='".$_sess_user_id."'@AND@T_status*Name@IN@(".implode(",",$rw_array_for_walk)."))@OR@(T_status*Name@IN@(".implode(",",$manage_array_for_walk).")@AND@T_caver*Login='******'user_login'])."')),'<convert>#label=626<convert>','<convert>#label=627<convert>')")] = '<convert>#label=626<convert>'; //Oui
$default_array[idEncode("IF(((T_request*Id_author='" . $_sess_user_id . "'@AND@T_status*Name@IN@(" . implode(",", $rw_array_for_walk) . "))@OR@(T_status*Name@IN@(" . implode(",", $manage_array_for_walk) . ")@AND@T_request*Id_recipient='" . $_sess_user_id . "')),'<convert>#label=626<convert>','<convert>#label=627<convert>')")] = '<convert>#label=626<convert>';
//Oui
$default_array[idEncode("(SELECT@Language@FROM@" . $_SESSION['Application_host'] . "*T_caver@WHERE@Id=T_request*Id_author)")] = $_SESSION['language'];
} elseif (allowAccess(request_edit_mine)) {
$default_array[idEncode('T_status*Name')] = $def_status_array;
}
$result = getRowsFromSQL($sql, $columns_params, $links, $records_by_page, $filter_form, $list_form, $_POST, $input_type, $style, $default_order, true, true, "", $default_array, $images);
$resource_id = $result['resource_id'];
$filter_fields = getFilterFields($sql, $columns_params, $_POST, $filter_form, "<convert>#label=542<convert>", false, $resource_id, $default_array);
//Tous
$rows = $result['rows'];
$total_count = $result['total_count'];
$local_count = $result['local_count'];
$count_page = ceil($total_count / $records_by_page);
$current_page = isset($_POST['current']) ? $_POST['current'] : 1;
$order = isset($_POST['order']) ? $_POST['order'] : '';
$by = isset($_POST['by']) ? $_POST['by'] : $default_order;
if ($total_count > 0) {
$navigator = getPageNavigator($length_page, $current_page, $count_page, $filter_form);
} else {
$navigator = "";
}
?>
<div>