}
for (var i; i <= 50; i++)
{
document.getElementById('c' + i).style.display = 'none';
}
return false;
}
</script>
<?php
echo "<div class=\"page_sans_col_gauche\">";
if (isset($id_area)) {
$res = grr_sql_query("SELECT * FROM " . TABLE_PREFIX . "_area WHERE id={$id_area}");
if (!$res) {
fatal_error(0, get_vocab('error_area') . $id_area . get_vocab('not_found'));
}
$row = grr_sql_row_keyed($res, 0);
grr_sql_free($res);
if ($action == "duplique_area") {
echo "<h2>" . get_vocab("duplique_domaine") . "</h2>";
} else {
echo "<h2>" . get_vocab("editarea") . "</h2>";
}
if ($row["calendar_default_values"] == 'y') {
$row["morningstarts_area"] = $morningstarts;
$row["eveningends_area"] = $eveningends;
$row["resolution_area"] = $resolution;
$row["duree_par_defaut_reservation_area"] = $duree_par_defaut_reservation_area;
$row["duree_max_resa_area"] = $duree_max_resa;
$row["eveningends_minutes_area"] = $eveningends_minutes;
$row["weekstarts_area"] = $weekstarts;
$row["twentyfourhour_format_area"] = $twentyfourhour_format;
function grr_backup($id_entry,$login_moderateur,$motivation_moderation) {
$sql = "SELECT * FROM ".TABLE_PREFIX."_entry WHERE id='".$id_entry."'";
$res = grr_sql_query($sql);
if (! $res) return FALSE;
$row = grr_sql_row_keyed($res, 0);
grr_sql_free($res);
$req = "insert into ".TABLE_PREFIX."_entry_moderate set
id = '".$row['id']."',
start_time = '".$row['start_time']."',
end_time = '".$row['end_time']."',
entry_type = '".$row['entry_type']."',
repeat_id = '".$row['repeat_id']."',
room_id = '".$row['room_id']."',
timestamp = '".$row['timestamp']."',
create_by = '".$row['create_by']."',
beneficiaire = '".$row['beneficiaire']."',
name = '".protect_data_sql($row['name'])."',
type = '".$row['type']."',
description = '".protect_data_sql($row['description'])."',
statut_entry = '".$row['statut_entry']."',
option_reservation = '".$row['option_reservation']."',
overload_desc = '".protect_data_sql($row['overload_desc'])."',
moderate = '".$row['moderate']."',
motivation_moderation = '".protect_data_sql(strip_tags($motivation_moderation))."',
login_moderateur = '".protect_data_sql($login_moderateur)."'";
$res = grr_sql_query($req);
if (! $res)
return FALSE;
else {
grr_sql_free($res);
return TRUE;
}
}
/**
* @param string $motivation_moderation
*/
function grr_backup($id_entry, $login_moderateur, $motivation_moderation)
{
$sql = "SELECT * FROM " . TABLE_PREFIX . "_entry WHERE id='" . $id_entry . "'";
$res = grr_sql_query($sql);
if (!$res) {
return false;
}
$row = grr_sql_row_keyed($res, 0);
grr_sql_free($res);
$req = "INSERT INTO " . TABLE_PREFIX . "_entry_moderate SET\n\tid = '" . $row['id'] . "',\n\tstart_time = '" . $row['start_time'] . "',\n\tend_time = '" . $row['end_time'] . "',\n\tentry_type = '" . $row['entry_type'] . "',\n\trepeat_id = '" . $row['repeat_id'] . "',\n\troom_id = '" . $row['room_id'] . "',\n\ttimestamp = '" . $row['timestamp'] . "',\n\tcreate_by = '" . $row['create_by'] . "',\n\tbeneficiaire = '" . $row['beneficiaire'] . "',\n\tname = '" . protect_data_sql($row['name']) . "',\n\ttype = '" . $row['type'] . "',\n\tdescription = '" . protect_data_sql($row['description']) . "',\n\tstatut_entry = '" . $row['statut_entry'] . "',\n\toption_reservation = '" . $row['option_reservation'] . "',\n\toverload_desc = '" . protect_data_sql($row['overload_desc']) . "',\n\tmoderate = '" . $row['moderate'] . "',\n\tmotivation_moderation = '" . protect_data_sql(strip_tags($motivation_moderation)) . "',\n\tlogin_moderateur = '" . protect_data_sql($login_moderateur) . "'";
$res = grr_sql_query($req);
if (!$res) {
return false;
} else {
grr_sql_free($res);
return true;
}
}
function update_site($id)
{
if ((isset($_POST['back']) or isset($_GET['back']))) {
// On affiche le tableau des sites
read_sites();
exit();
}
// On affiche le formulaire de saisie quand l'appel de la fonction ne provient pas de la validation de ce même formulaire
if (! (isset($_POST['save']) or isset($_GET['save'])))
{
// Initialisation
$res = grr_sql_query("SELECT * FROM ".TABLE_PREFIX."_site WHERE id='".$id."'");
if (! $res) fatal_error(0,'<p>'.grr_sql_error().'</p>');
$row = grr_sql_row_keyed($res, 0);
grr_sql_free($res);
$sitecode = $row['sitecode'];
$sitename = $row['sitename'];
$adresse_ligne1 = $row['adresse_ligne1'];
$adresse_ligne2 = $row['adresse_ligne2'];
$adresse_ligne3 = $row['adresse_ligne3'];
$cp = $row['cp'];
$ville = $row['ville'];
$pays = $row['pays'];
$tel = $row['tel'];
$fax = $row['fax'];
// Affichage des titres de la page
echo ' <h2>'.get_vocab('modifier site').'</h2>';
echo '
<form action="admin_site.php?action=update" method="post">
<table>
<tr><td>'.get_vocab('site_code').' *</td><td><input type="text" name="sitecode" value="'.$sitecode.'" size="10" title="'.get_vocab('site_code').'" /></td></tr>
<tr><td>'.get_vocab('site_name').' *</td><td><input type="text" name="sitename" value="'.$sitename.'" size="50" title="'.get_vocab('site_name').'" /></td></tr>
<tr><td>'.get_vocab('site_adresse_ligne1').'</td><td><input type="text" name="adresse_ligne1" value="'.$adresse_ligne1.'" size="38" title="'.get_vocab('site_adresse_ligne1').'" /></td></tr>
<tr><td>'.get_vocab('site_adresse_ligne2').'</td><td><input type="text" name="adresse_ligne2" value="'.$adresse_ligne2.'" size="38" title="'.get_vocab('site_adresse_ligne2').'" /></td></tr>
<tr><td>'.get_vocab('site_adresse_ligne3').'</td><td><input type="text" name="adresse_ligne3" value="'.$adresse_ligne3.'" size="38" title="'.get_vocab('site_adresse_ligne3').'" /></td></tr>
<tr><td>'.get_vocab('site_cp').'</td><td><input type="text" name="cp" value="'.$cp.'" size="5" title="'.get_vocab('site_cp').'" /></td></tr>
<tr><td>'.get_vocab('site_ville').'</td><td><input type="text" name="ville" value="'.$ville.'" size="50" title="'.get_vocab('site_ville').'" /></td></tr>
<tr><td>'.get_vocab('site_pays').'</td><td><input type="text" name="pays" value="'.$pays.'" size="50" title="'.get_vocab('site_pays').'" /></td></tr>
<tr><td>'.get_vocab('site_tel').'</td><td><input type="text" name="tel" value="'.$tel.'" size="25" title="'.get_vocab('site_tel').'" /></td></tr>
<tr><td>'.get_vocab('site_fax').'</td><td><input type="text" name="fax" value="'.$fax.'" size="25" title="'.get_vocab('site_fax').'" /></td></tr>
</table>
<div>
<input type="hidden" name="valid" value="yes" />
<input type="hidden" name="id" value="'.$id.'" />
<input type="submit" name="save" value="'.get_vocab('save').'" />
<input type="submit" name="back" value="'.get_vocab('back').'" /></div>
</form>';
echo get_vocab("required");
// Sinon, il faut valider le formulaire
} else {
$msg ='';
if (!isset($id)) $id = isset($_POST['id']) ? $_POST['id'] : NULL;
if (!isset($sitecode)) $sitecode = isset($_POST['sitecode']) ? $_POST['sitecode'] : NULL;
if (!isset($sitename)) $sitename = isset($_POST['sitename']) ? $_POST['sitename'] : NULL;
if (!isset($adresse_ligne1)) $adresse_ligne1 = isset($_POST['adresse_ligne1']) ? $_POST['adresse_ligne1'] : NULL;
if (!isset($adresse_ligne2)) $adresse_ligne2 = isset($_POST['adresse_ligne2']) ? $_POST['adresse_ligne2'] : NULL;
if (!isset($adresse_ligne3)) $adresse_ligne3 = isset($_POST['adresse_ligne3']) ? $_POST['adresse_ligne3'] : NULL;
if (!isset($cp)) $cp = isset($_POST['cp']) ? $_POST['cp'] : NULL;
if (!isset($ville)) $ville = isset($_POST['ville']) ? $_POST['ville'] : NULL;
if (!isset($pays)) $pays = isset($_POST['pays']) ? $_POST['pays'] : NULL;
if (!isset($tel)) $tel = isset($_POST['tel']) ? $_POST['tel'] : NULL;
if (!isset($fax)) $fax = isset($_POST['fax']) ? $_POST['fax'] : NULL;
// On vérifie que le code et le nom du site ont été renseignés
if ($sitecode=='' or $sitecode==NULL or $sitename=='' or $sitename==NULL)
{
$_POST['save'] = 'no';
$_GET['save'] = 'no';
echo '<span class="avertissement">'.get_vocab('required').'</span>';
}
// Sauvegarde du record
if ((isset($_POST['save']) and ($_POST['save']!='no')) or ((isset($_GET['save'])) and ($_GET['save']!='no')))
{
$sql="update ".TABLE_PREFIX."_site
SET sitecode='".strtoupper(protect_data_sql($sitecode))."',
sitename='".protect_data_sql($sitename)."',
adresse_ligne1='".protect_data_sql($adresse_ligne1)."',
adresse_ligne2='".protect_data_sql($adresse_ligne2)."',
adresse_ligne3='".protect_data_sql($adresse_ligne3)."',
cp='".protect_data_sql($cp)."',
ville='".strtoupper(protect_data_sql($ville))."',
pays='".strtoupper(protect_data_sql($pays))."',
tel='".protect_data_sql($tel)."',
fax='".protect_data_sql($fax)."'
where id='".$id."'";
if (grr_sql_command($sql) < 0)
fatal_error(0,'<p>'.grr_sql_error().'</p>');
$site = mysql_insert_id();
}
// On affiche le tableau des sites
read_sites();
}
}
