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'];
