?> <?php $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'] : 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 {
function displayCalendarNames() { global $master_array; $calendars = $master_array['calendars']; echo '<div class="calendars" id="calendars">'; for ($ct1 = 1; $ct1 <= count($calendars); $ct1++) { $calendar = $calendars[$ct1]; $inputId = 'view-' . idEncode($calendar['id']); $isWebCal = ''; if ($calendar['isWebCal']) { $isWebCal = ' webcal'; } if (!defined(DEFAULT_CALENDAR)) { define(DEFAULT_CALENDAR, $calendar['name']); } $isDefault = ''; if ($calendar['name'] == DEFAULT_CALENDAR) { $isDefault = ' default'; } echo '<div class="calendar-info color-' . $ct1 . $isWebCal . $isDefault . '">'; echo '<span class="cal-details">'; echo '<input type="checkbox" name="' . $inputId . '" id="' . $inputId . '" checked="checked" />'; echo '<label class="name" for="' . $inputId . '">'; echo $calendar['name']; echo '</label>'; echo '</span> '; echo '<span class="links">'; if ($calendar['isWebCal']) { echo '<a href="' . $calendar['filename'] . '">ics</a>'; echo ' <span class="faded">rss</span>'; } else { echo '<a href="phpicalendar-karl/calendars/' . $calendar['id'] . '.ics' . '">ics</a>'; echo ' <a href="phpicalendar-karl/rss/rss.php?cal=' . $calendar['id'] . '&rssview=month">rss</a>'; } echo '</span>'; echo '</div>'; } echo '</div>'; }
function getFilterFields($sql, $columns_params, $POST_vars, $filter_form, $msg_all, $small = false, $resource = false, $default_values = array()) { $time_start = startMetro(); $default_size_text = 20; $default_size_number = 10; $field_set_array = array(); // Check if it takes into account the default values or the POST values $buttons = array("submit_filter", "reset_filter", "reset", "overview_filter", "current", "order", "by", "records_by_page", "PHPSESSID"); $get_post_values = false; foreach ($buttons as $key => $value) { if (isset($POST_vars[$value])) { $get_post_values = true; break; } } // other if (isset($POST_vars['reset_filter'])) { foreach ($POST_vars as $key => $value) { if (!is_array($value)) { unset($POST_vars[$key]); } } } //end of other if ($get_post_values) { $values_array = $POST_vars; } else { $values_array = $default_values; } // End of check if it takes into account the default values or the POST values $connect_db = connect(); if (!$resource) { if (strpos($sql, " LIMIT ") !== false) { $head_sql = substr($sql, 0, strpos($sql, " LIMIT ")); } else { $head_sql = $sql; } $head_sql .= " LIMIT 0 "; $resource = mysql_query($head_sql) or die(reportError(mysql_error(), __FILE__, "function", __FUNCTION__, 'Erreur SQL : ' . $sql)); } $time_start_b = startMetro(); $fields = mysql_num_fields($resource); //CHRONOPHAGE? endMetro($time_start_b, __FUNCTION__ . " head query"); $column_side = 1; for ($i = 0; $i < $fields; $i++) { $new_field = ""; $names = $columns_params[$i]; //mysql_field_name($resource, $i); $name_array = explode("|", $names); $name = $name_array[0]; $label = $name_array[1]; $sub_querry = $name_array[2]; $multiple_size = $name_array[3]; if (strpos($name, "[hidden]") === false) { $len = mysql_field_len($resource, $i); $type = mysql_field_type($resource, $i); $flags = mysql_field_flags($resource, $i); if (strpos($flags, "not_null") !== false) { $mandatory = "*"; } else { $mandatory = ""; } if ($sub_querry != "" || strpos($flags, "enum") !== false) { $multiple = ""; $mult_suffix = ""; if ($multiple_size > 0) { $multiple = "size=\"" . $multiple_size . "\" multiple=\"multiple\""; $mult_suffix = "[]"; //The POST var must know that it's an array of values !! ... this is the trick ! On name attribute only !!! $msg_all = ""; } $new_field .= "<select class=\"select2\" id=\"" . idEncode($name) . "\" name=\"" . idEncode($name) . $mult_suffix . "\" " . $multiple . ">\n"; $selected = $values_array[idEncode($name)]; if ($sub_querry != "") { if (strpos($sub_querry, ";") !== false) { $enum_array = explode(";", $sub_querry); $new_field .= getOptionsFromArray($enum_array, $msg_all, $selected); } else { $comparedCol = "value"; $textCol = "text"; $new_field .= getOptions($sub_querry, $msg_all, $selected, $comparedCol, $textCol); } } else { $enum_array = getEnumArray($name); $new_field .= getOptionsFromArray($enum_array, $msg_all, $selected); } $new_field .= "</select>"; } else { switch ($type) { case "string": $new_field .= "<input class=\"input1\" id=\"" . idEncode($name) . "\" name=\"" . idEncode($name) . "\" value=\"" . $values_array[idEncode($name)] . "\" "; $new_field .= "type=\"text\" "; $len = $len / 3; $new_field .= "size=\"" . min($default_size, 0 + $len) . "\" maxlength=\"" . $len . "\" />"; break; case "int": case "real": $name_from = idEncode(">=|" . $name); $name_to = idEncode("<=|" . $name); $new_field .= "<input class=\"input1\" id=\"" . $name_from . "\" name=\"" . $name_from . "\" value=\"" . $values_array[$name_from] . "\" type=\"text\" size=\"" . $default_size_number . "\" />"; $new_field .= " ≤ x ≤ <input class=\"input1\" id=\"" . $name_to . "\" name=\"" . $name_to . "\" value=\"" . $values_array[$name_to] . "\" type=\"text\" size=\"" . $default_size_number . "\" />"; $name = "<=|" . $name; break; case "datetime": case "date": $name_from = idEncode(">=|" . $name); $name_to = idEncode("<=|" . $name); $new_field .= "<input class=\"input1\" id=\"" . $name_from . "\" name=\"" . $name_from . "\" value=\"" . $values_array[$name_from] . "\" type=\"text\" size=\"10\" maxlength=\"10\" readonly=\"readonly\" /> <a href=\"JavaScript:showCalendar(document." . $filter_form . ".elements['" . $name_from . "'],'yyyy-MM-DD','Pick a date')\"><img src=\"../images/icons/cal.gif\" alt=\"Click Here to use a calendar\" title=\"Click Here to use a calendar\" style=\"cursor:pointer;vertical-align:text-top;border:0px none;\" /></a>"; $new_field .= " ≤ x ≤ <input class=\"input1\" id=\"" . $name_to . "\" name=\"" . $name_to . "\" value=\"" . $values_array[$name_to] . "\" type=\"text\" size=\"10\" maxlength=\"10\" readonly=\"readonly\" /> <a href=\"JavaScript:showCalendar(document." . $filter_form . ".elements['" . $name_to . "'],'yyyy-MM-DD','Pick a date')\"><img src=\"../images/icons/cal.gif\" alt=\"Click Here to use a calendar\" title=\"Click Here to use a calendar\" style=\"cursor:pointer;vertical-align:text-top;border:0px none;\" /></a>"; $name = "<=|" . $name; break; default: break; } } $field_set = "<tr><td class=\"label\">\n"; $field_set .= "<label class=\"label_portlet\" for=\"" . idEncode($name) . "\">\n"; $field_set .= str_replace("[hidden]", "", $label) . "\n"; $field_set .= "</label>\n"; $field_set .= "</td>\n"; $field_set .= "<td class=\"field\">\n"; $field_set .= $new_field . "\n"; $field_set .= "</td></tr>\n"; $field_set_array[] .= $field_set; } } $field_set = "<tr><td>\n<table border=\"0\" cellspacing=\"1\" cellpadding=\"0\">\n"; for ($i = 0; $i < count($field_set_array); $i++) { $field_set .= $field_set_array[$i]; if ($i == ceil(count($field_set_array) / 2) - 1 && !$small) { $field_set .= "</table>\n</td>\n<td>\n<table border=\"0\" cellspacing=\"1\" cellpadding=\"0\">\n"; } } $field_set .= "</table>\n</td></tr>\n"; mysql_free_result($resource); close($connect_db); endMetro($time_start, __FUNCTION__); return $field_set; }