if ($champ[$k] == "room") { $sql .= grr_sql_syntax_caseless_contains("r.room_name", $texte[$k], $type_recherche[$k]); } if ($champ[$k] == "type") { $sql .= grr_sql_syntax_caseless_contains("t.type_name", $texte[$k], $type_recherche[$k]); } if ($champ[$k] == "name") { $sql .= grr_sql_syntax_caseless_contains("e.name", $texte[$k], $type_recherche[$k]); } if ($champ[$k] == "descr") { $sql .= grr_sql_syntax_caseless_contains("e.description", $texte[$k], $type_recherche[$k]); } if ($champ[$k] == "login") { $sql .= grr_sql_syntax_caseless_contains("e.beneficiaire", $texte[$k], $type_recherche[$k]); } $overload_fields = mrbsOverloadGetFieldslist(""); foreach ($overload_fields as $fieldname => $fieldtype) { if ($overload_fields[$fieldname]["confidentiel"] != 'y') { if ($champ[$k] == "addon_" . $overload_fields[$fieldname]["id"]) { $sql .= grr_sql_syntax_caseless_contains_overload("e.overload_desc", $texte[$k], $overload_fields[$fieldname]["id"], $type_recherche[$k]); } } } if ($k < count($texte) - 1) { $sql .= " " . $_GET["condition_et_ou"] . " "; } $k++; } $sql .= ")"; } $sql .= " AND t.type_letter = e.type ";
} } else { $beneficiaire_ext = ''; } if (!isset($_GET['rooms'][0])) { print_header(); echo '<h2>' . get_vocab('choose_a_room') . '</h2>'; include 'include/trailer.inc.php'; die; } if (isset($_SERVER['HTTP_REFERER'])) { $back = htmlspecialchars($_SERVER['HTTP_REFERER']); } $area = mrbsGetRoomArea($_GET['rooms'][0]); $overload_data = array(); $overload_fields_list = mrbsOverloadGetFieldslist($area); foreach ($overload_fields_list as $overfield => $fieldtype) { $id_field = $overload_fields_list[$overfield]['id']; $fieldname = 'addon_' . $id_field; if ($overload_fields_list[$overfield]['obligatoire'] == 'y' && (!isset($_GET[$fieldname]) || trim($_GET[$fieldname]) == '')) { print_header(); echo '<h2>' . get_vocab('required') . '</h2>'; echo '<a href="' . $back . '&Err=yes">' . get_vocab('returnprev') . '</a>'; include 'include/trailer.inc.php'; die; } if ($overload_fields_list[$overfield]['type'] == 'numeric' && isset($_GET[$fieldname]) && $_GET[$fieldname] != '' && !preg_match("`^[0-9]*\\.{0,1}[0-9]*\$`", $_GET[$fieldname])) { print_header(); echo '<h2>' . $overload_fields_list[$overfield]['name'] . get_vocab('deux_points') . get_vocab('is_not_numeric') . '</h2>'; echo '<a href="' . $back . '&Err=yes">' . get_vocab('returnprev') . '</a>'; include 'include/trailer.inc.php';
$tplArrayEditEntry['vocab']['addentry'] = get_vocab('addentry'); $tplArrayEditEntry['vocab']['editseries'] = get_vocab('editseries'); $tplArrayEditEntry['vocab']['copyentry'] = get_vocab('copyentry'); $tplArrayEditEntry['vocab']['editentry'] = get_vocab('editentry'); $tplArrayEditEntry['vocab']['namebooker'] = get_vocab('namebooker'); $tplArrayEditEntry['vocab']['fulldescription'] = get_vocab('fulldescription'); $tplArrayEditEntry['vocab']['reservations_moderees'] = get_vocab('reservations_moderees'); $tplArrayEditEntry['vocab']['fulldescription'] = get_vocab('fulldescription'); $tplArrayEditEntry['vocab']['date'] = get_vocab('date'); $tplArrayEditEntry['vocab']['definir_par_defaut'] = get_vocab('definir par defaut'); $tplArrayEditEntry['vocab']['nom_beneficiaire'] = strip_tags(get_vocab('nom_beneficiaire')); $tplArrayEditEntry['vocab']['email_beneficiaire'] = get_vocab('email beneficiaire'); $tplArrayEditEntry['vocab']['no_compatibility_with_repeat_type'] = get_vocab('no_compatibility_with_repeat_type'); foreach ($allareas_id as $idtmp) { //$overload_fields = mrbsOverloadGetFieldslist($idtmp); $tplArrayEditEntry['overloadFields'][] = mrbsOverloadGetFieldslist($idtmp); } /* $A est le titre de la page */ if ($id == 0) { $A = get_vocab('addentry'); $tplArrayEditEntry['titrePage'] = get_vocab('addentry'); } else { if ($edit_type == 'series') { $A = get_vocab('editseries'); $tplArrayEditEntry['titrePage'] = get_vocab('editseries'); } else { if (isset($_GET['copier'])) { $A = get_vocab('copyentry'); $tplArrayEditEntry['titrePage'] = get_vocab('copyentry'); } else { $A = get_vocab('editentry');
alert ( "<?php echo get_vocab('you_have_not_entered').":" . '\n' . strtolower(get_vocab('nom beneficiaire')) ?>"); return false; } } <?php if (getSettingValue("remplissage_description_breve")=='1') { ?> if(document.forms["main"].name.value == "") { alert ( "<?php echo get_vocab('you_have_not_entered') . '\n' . get_vocab('brief_description') ?>"); return false; } <?php } // On teste si les champs additionnels obligatoires sont bien remplis // Boucle sur tous les areas foreach ($allareas_id as $idtmp) { // On récupère les infos sur le champ add $overload_fields = mrbsOverloadGetFieldslist($idtmp); // Boucle sur tous les champs additionnels de l'area foreach ($overload_fields as $fieldname=>$fieldtype) { if ($overload_fields[$fieldname]["obligatoire"] == 'y') { // Le champ est obligatoire : si le tableau est affiché (area sélectionné) et que le champ est vide alors on affiche un message d'avertissement if ($overload_fields[$fieldname]["type"] != "list") { echo "if((document.getElementById('id_".$idtmp."_".$overload_fields[$fieldname]["id"]."')) && (document.forms[\"main\"].addon_".$overload_fields[$fieldname]["id"].".value == \"\")) {\n"; } else { echo "if((document.getElementById('id_".$idtmp."_".$overload_fields[$fieldname]["id"]."')) && (document.forms[\"main\"].addon_".$overload_fields[$fieldname]["id"].".options[0].selected == true)) {\n"; } echo "alert (\"".$vocab["required"]."\");\n"; echo "return false\n}\n"; } // Si le champ est numérique.... if ($overload_fields[$fieldname]["type"] == "numeric") { echo "if (isNaN((document.getElementById('id_".$idtmp."_".$overload_fields[$fieldname]["id"]."')) && (document.forms[\"main\"].addon_".$overload_fields[$fieldname]["id"].".value))) {\n";
/** mrbsCreateRepeatEntry() * * Creates a repeat entry in the data base * * $starttime - Start time of entry * $endtime - End time of entry * $rep_type - The repeat type * $rep_enddate - When the repeating ends * $rep_opt - Any options associated with the entry * $room_id - Room ID * $beneficiaire - beneficiaire * $beneficiaire_ext - beneficiaire extérieur * $creator - celui aui a créé ou modifié la réservation. * $name - Name * $type - Type (Internal/External) * $description - Description *$rep_jour_c - Le jour cycle d'une réservation, si aucun 0 * * Returns: * 0 - An error occured while inserting the entry * non-zero - The entry's ID */ function mrbsCreateRepeatEntry($starttime, $endtime, $rep_type, $rep_enddate, $rep_opt, $room_id, $creator, $beneficiaire, $beneficiaire_ext, $name, $type, $description, $rep_num_weeks,$overload_data, $rep_jour_c) { $overload_data_string = ""; $area_id = mrbsGetAreaIdFromRoomId($room_id); $overload_fields_list = mrbsOverloadGetFieldslist($area_id); foreach ($overload_fields_list as $field=>$fieldtype) { $id_field = $overload_fields_list[$field]["id"]; if (array_key_exists($id_field,$overload_data)) { // $begin_string = "<".$id_field.">"; //tructruc // $end_string = "</".$id_field.">"; //tructruc $begin_string = "@".$id_field."@"; $end_string = "@/".$id_field."@"; // $overload_data_string .= $begin_string.base64_encode($overload_data[$id_field]).$end_string; // tructruc $overload_data_string .= $begin_string.urlencode($overload_data[$id_field]).$end_string; // tructruc } } $sql = "INSERT INTO ".TABLE_PREFIX."_repeat ( start_time, end_time, rep_type, end_date, rep_opt, room_id, create_by, beneficiaire, beneficiaire_ext, type, name, description, rep_num_weeks, overload_desc, jours) VALUES ($starttime, $endtime, $rep_type, $rep_enddate, '$rep_opt', $room_id, '".protect_data_sql($creator)."','".protect_data_sql($beneficiaire)."','".protect_data_sql($beneficiaire_ext)."', '".protect_data_sql($type)."', '".protect_data_sql($name)."', '".protect_data_sql($description)."', '$rep_num_weeks','".protect_data_sql($overload_data_string)."',".$rep_jour_c.")"; if (grr_sql_command($sql) < 0) { return 0; } return grr_sql_insert_id("".TABLE_PREFIX."_repeat", "id"); }
if (authUserAccesArea(getUserName(), $areas) == 0) { showAccessDenied(''); exit; } // Champs additionneles : on récupère les données de la réservation si il y en a if ($id != 0) { $overload_data = mrbsEntryGetOverloadDesc($id); } if ($unicode_encoding) { header('Content-Type: text/html;charset=utf-8'); } else { header('Content-Type: text/html;charset=' . $charset_html); } //header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Boucle sur les areas $overload_fields = mrbsOverloadGetFieldslist($areas); /*echo "<pre>"; var_dump($overload_fields); echo "</pre>";*/ foreach ($overload_fields as $fieldname => $fieldtype) { if ($overload_fields[$fieldname]['obligatoire'] == 'y') { $flag_obli = ' *'; } else { $flag_obli = ''; } echo '<table width="100%" id="id_' . $areas . '_' . $overload_fields[$fieldname]['id'] . '">'; if ($overload_fields[$fieldname]['type'] != 'checkbox') { echo '<tr><td class=E><b>' . removeMailUnicode($fieldname) . $flag_obli . "</b></td></tr>\n"; } if (isset($overload_data[$fieldname]['valeur'])) { $data = $overload_data[$fieldname]['valeur'];