format('d.m.Y'); $_SESSION['today_sql'] = $_SESSION['today']->format('Y-m-d'); $today_sql = $_SESSION['today_sql']; $today_local = $_SESSION['today_local']; //var_dump($today_sql,$today_local); $user_log = ''; $session_no = session_id(); //print_r($_SERVER['SERVER_NAME']); //exit; // Affichage des erreurs if($_SERVER['SERVER_NAME']=='localhost' || $_SERVER['SERVER_NAME']=='127.0.0.1') $type_gestion = 3; else $type_gestion = 2; /* 1=>mode debug, 2=>mode production (erreur dans log/error.log), 3=>mode mixte (erreur dans log/error.log + a l'ecran), 0=>Aucun traitement */ //var_dump($type_gestion); ini_set('docref_root', 'http://manual/fr/'); ini_set('error_log', 'tech/error_gsbhosp.log'); ini_set('ignore_repeated_errors', true); ini_set('html_errors', true); ini_set('allow_url_fopen', 1); ini_set('error_prepend_string',''); ini_set('error_append_string',''); error_reporting (E_ALL | E_DEPRECATED); switch ($type_gestion) { case '1': // ecran tout pas de log ini_set('display_startup_errors',true); ini_set('display_errors', true); // ecran ini_set('log_errors', false); // fichier log //error_reporting (E_ALL | E_DEPRECATED); //error_reporting (E_ERROR | E_WARNING | E_PARSE | E_NOTICE); break; case '2': //mode production ini_set('display_startup_errors',false); ini_set('display_errors', false); // ecran ini_set('log_errors', true); // fichier log //error_reporting (E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED); //error_reporting (E_ERROR | E_WARNING | E_PARSE | E_NOTICE); break; case '3': ini_set('display_startup_errors',true); ini_set('display_errors', true); // ecran ini_set('log_errors', true); // fichier log //error_reporting (E_ALL | E_DEPRECATED); //error_reporting (E_ERROR | E_WARNING | E_PARSE | E_NOTICE); break; default: ini_set('display_startup_errors',false); ini_set('display_errors', false); // ecran ini_set('log_errors', true); // fichier log //error_reporting (E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED); //error_reporting (E_ERROR | E_WARNING | E_PARSE | E_NOTICE); } // ------------------------------------ gestion eplacement de la base et variable debug -------------------- // --------------------------------------------------------------------------------------------------------- $_SESSION['emplacement_database'] ='autre'; $hote = $_SERVER['SERVER_NAME']; if($hote == '127.0.0.1') $hote='localhost'; //if($hote=='localhost' || $hote=='sdt-design.ch') echo 'hôte : '.$_SERVER['SERVER_NAME']; switch ($hote) { case '127.0.0.1': $debug_general='oui'; $debug = 'non'; $debug_details = 'non'; $debug_calendrier = 'non'; $debug_libelles = 'oui'; $_SESSION['emplacement_database'] ='localhost'; break; case 'localhost': $debug_general='oui'; $debug = 'non'; $debug_details = 'non'; $debug_calendrier = 'non'; $debug_libelles = 'oui'; $_SESSION['emplacement_database'] ='localhost'; break; case 'sdt-design.ch': $debug_general='non'; $debug = 'non'; $debug_details = 'non'; $debug_calendrier = 'non'; $debug_libelles = 'non'; $_SESSION['emplacement_database'] ='sdt-design.ch'; break; case 'www.sdt-design.ch': $debug_general='non'; $debug = 'non'; $debug_details = 'non'; $debug_calendrier = 'non'; $debug_libelles = 'non'; $_SESSION['emplacement_database'] ='sdt-design.ch'; break; case 'www.hahahactualite.ch': $debug_general='non'; $debug = 'non'; $debug_details = 'non'; $debug_calendrier = 'non'; $debug_libelles = 'non'; $_SESSION['emplacement_database'] ='hahahactualite'; break; case 'hahahactualite.ch': $debug_general='non'; $debug = 'non'; $debug_details = 'non'; $debug_calendrier = 'non'; $debug_libelles = 'non'; $_SESSION['emplacement_database'] ='hahahactualite'; break; case 'gsbernard.com': $debug_general='non'; $debug = 'non'; $debug_details = 'non'; $debug_calendrier = 'non'; $debug_libelles = 'non'; $_SESSION['emplacement_database'] ='gsbernard.com'; break; case 'www.gsbernard.com': $debug_general='non'; $debug = 'non'; $debug_details = 'non'; $debug_calendrier = 'non'; $debug_libelles = 'non'; $_SESSION['emplacement_database'] ='gsbernard.com'; break; default: $debug_general='non'; $debug = 'non'; $debug_details = 'non'; $debug_calendrier = 'non'; $debug_libelles = 'non'; $_SESSION['emplacement_database'] ='localhost'; } $jour_semaine_tableau [0]['cpl'] = 'Dimanche'; $jour_semaine_tableau [0]['abr'] = 'Dim.'; $jour_semaine_tableau [1]['cpl'] = 'Lundi'; $jour_semaine_tableau [1]['abr'] = 'Lun.'; $jour_semaine_tableau [2]['cpl'] = 'Mardi'; $jour_semaine_tableau [2]['abr'] = 'Mar..'; $jour_semaine_tableau [3]['cpl'] = 'Mercredi'; $jour_semaine_tableau [3]['abr'] = 'Mer.'; $jour_semaine_tableau [4]['cpl'] = 'Jeudi'; $jour_semaine_tableau [4]['abr'] = 'Jeu.'; $jour_semaine_tableau [5]['cpl'] = 'Vendredi'; $jour_semaine_tableau [5]['abr'] = 'Ven.'; $jour_semaine_tableau [6]['cpl'] = 'Samedi'; $jour_semaine_tableau [6]['abr'] = 'Sam.'; $jour_semaine_tableau_iso [1]['cpl'] = 'Lundi'; $jour_semaine_tableau_iso [1]['abr'] = 'Lun.'; $jour_semaine_tableau_iso [2]['cpl'] = 'Mardi'; $jour_semaine_tableau_iso [2]['abr'] = 'Mar..'; $jour_semaine_tableau_iso [3]['cpl'] = 'Mercredi'; $jour_semaine_tableau_iso [3]['abr'] = 'Mer.'; $jour_semaine_tableau_iso [4]['cpl'] = 'Jeudi'; $jour_semaine_tableau_iso [4]['abr'] = 'Jeu.'; $jour_semaine_tableau_iso [5]['cpl'] = 'Vendredi'; $jour_semaine_tableau_iso [5]['abr'] = 'Ven.'; $jour_semaine_tableau_iso [6]['cpl'] = 'Samedi'; $jour_semaine_tableau_iso [6]['abr'] = 'Sam.'; $jour_semaine_tableau_iso [7]['cpl'] = 'Dimanche'; $jour_semaine_tableau_iso [7]['abr'] = 'Dim.'; $tableau_langues = array('FR'=>'fr','IT'=>'it','EN'=>'en','DE'=>'de'); // initie la connexion avec les bases MySQL include_once('tech/sql_lienI.php'); //session_regenerate_id(true); ini_set ('session.bug_compat_42', 0); ini_set ('session.bug_compat_warn', 0); ini_set ('allow_url_fopen',1); //intègre la page de fonctions php include_once('tech/fonctions_php.php'); include_once('tech/debug.php'); /// log ________________________________ if(isset($_GET['newses'])) { if($user_log != '') $log_details = $user_log.' déconnexion - '.$_SERVER['REMOTE_ADDR']; else $log_details = 'Déconnexion manuelle sans user - '.$_SERVER['REMOTE_ADDR']; // insert_log (user_log,log_cli_id, log_sej_id, log_logement_id, log_nca_nuit, log_action,log_details); insert_log ($user_log,0,0,0,'','Déconnexion',$log_details); /// log _________________________ // Détruit toutes les variables de session } $prefs= charge_preferences(); /*< debug ___*/debug('non',0,__FILE__,__LINE__,'','','session id',$session_no,0,'vert');/* ___ debug >*/ /*< debug ___*/debug('non',0,__FILE__,__LINE__,'','','session',$_SESSION,0,'vert');/* ___ debug >*/ /*$_SESSION['user'] $_SESSION['date_consultee'] $_SESSION['lieu'] $_SESSION['mode_util'] $_SESSION['groupe'] $_SESSION['page_prec'] $_SESSION['emplacement_database'] $_SESSION['lien_planing'] $_SESSION['euro'] */ if(! isset($_GET["section"])) {///1 $section='client'; $_SESSION['groupe']='client'; } else {///1 $section=$_GET["section"]; if(!isset($_SESSION['groupe'])) $_SESSION['groupe']=$section; }///1 if(! isset($_GET["page"])) $page=0; else $page=$_GET["page"]; $libelles = $_SESSION['libelles']; if(isset($_GET['o'])) $lieu = $_GET['o']; else $lieu='gsb'; $lieu='gsb'; if(isset($_GET['chaub']) && $_GET['chaub']!= 0) $chaub=$_GET['chaub'];else $chaub=0; if(isset($_GET['sej']) && $_GET['sej']!= 0) $sej=$_GET['sej'];else $sej=0; if(isset($_GET['ddaub']) && $_GET['ddaub']!= 0) $ddaub=$_GET['ddaub'];else $ddaub=0; if(isset($_GET['cl']) && $_GET['cl']!= 0) $cl=$_GET['cl'];else $cl=0; $intervalle_1_jour = new DateInterval('P1D'); //definit le nombre de places de hospice saint-bernard ou simplon $query = "SELECT SUM(loge_nbre_places) FROM logements WHERE loge_lieux = '$lieu' AND loge_no != 'C0' AND loge_no != 'D0' "; $result = $lienI->query($query); $ligne = $result->fetch_array(); $nbre_pl_bloquees = $prefs['places_bloquees']; $nombre_places_lieu = $ligne[0]; if($_SESSION['groupe'] == 'client' && $lieu=='gsb') $nombre_places_lieu = $nombre_places_lieu - $nbre_pl_bloquees; //definit le nombre de places en chambre de hospice saint-bernard ou simplon $query = "SELECT SUM(loge_nbre_places) FROM logements WHERE loge_lieux = '$lieu' AND loge_type = 'chambre' AND loge_no!= 'C0' "; $result = $lienI->query($query); $ligne = $result->fetch_array(); $places_bloquees_chambres = $prefs['places_bloquees_chambres']; $nombre_places_chambres_lieu = $ligne[0]; if($_SESSION['groupe'] == 'client' && $lieu=='gsb') $nombre_places_chambres_lieu = $nombre_places_chambres_lieu - $places_bloquees_chambres; //definit le nombre de places en dortoir de hospice saint-bernard ou simplon $query = "SELECT SUM(loge_nbre_places) FROM logements WHERE loge_lieux = '$lieu' AND loge_type = 'dortoir' AND loge_no != 'D0' "; $result = $lienI->query($query); $ligne = $result->fetch_array(); $places_bloquees_dortoirs = $prefs['places_bloquees_dortoirs']; $nombre_places_dortoirs_lieu = $ligne[0]; if($_SESSION['groupe'] == 'client' && $lieu=='gsb') $nombre_places_dortoirs_lieu = $nombre_places_dortoirs_lieu - $places_bloquees_dortoirs; /*< debug ___*/debug('non',0,__FILE__,__LINE__,'nombre_places_dortoirs_lieu',$nombre_places_dortoirs_lieu,'nombre_places_chambres_lieu',$nombre_places_chambres_lieu,0,'jaune');/* ___ debug >*/ /*< debug ___*/debug($debug_details,1,__FILE__,__LINE__,"libellé",$libelles,'','',1,'jaune');/* ___ debug >*/ if (! isset($_GET['date'])) $_SESSION['date_consultee'] = date('d.m.Y'); else $_SESSION['date_consultee'] = $_GET['date']; //if (! isset($_GET['o'])) $_SESSION['lieu'] = 'gsb'; else $_SESSION['lieu'] = $_GET['o']; $_SESSION['lieu'] = 'gsb'; /*< debug ___*/debug('non',1,__FILE__,__LINE__,"session",$_SESSION,'','',1,'jaune');/* ___ debug >*/ /*< debug ___*/debug('non',0,__FILE__,__LINE__,'session groupe, login interne',$_SESSION['groupe'],'','',0,'jaune');/* ___ debug >*/ if ($section == 1 && $page == 0) $_SESSION['user'] = "Login"; /*< debug ___*/debug('non',0,__FILE__,__LINE__,'','','parametres depart','user : './*$_SESSION['user'].*/' / groupe : '.$_SESSION['groupe'].' / section : '.$section,0,'jaune');/* ___ debug >*/ ?> */ echo '' ?> Hospice du Grand Saint-Bernard -<? echo $libelles['reservation_sejour'] [$langue]?> Auberge de l'hospice -<? echo $libelles['reservation_sejour'] [$langue]?> query($query_change); $ligne_change =$result_change->fetch_array(); $date_change = $ligne_change[0]; //echo '
'.$date_change.'
'; // tous les matins _______________________________________________ if($date_change != date('Y-m-d') /*|| 1==1*/) {///1 //This is aPHP(5)script example on how eurofxref-daily.xml can be parsed //Read eurofxref-daily.xml file in memory //For the next command you will need the config option allow_url_fopen=On (default) // original if($XML=simplexml_load_file('https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml')){///2 //par ip //$XML=simplexml_load_file('https://185.5.82.138/stats/eurofxref/eurofxref-daily.xml'); //the file is updated daily between 2.15 p.m. and 3.00 p.m. CET /*< debug ___*/debug('non',0,__FILE__,__LINE__,'','','XML',$XML,0,'jaune');/* ___ debug >*/ $l=1; $tableau_cours = array(); foreach($XML->Cube->Cube->Cube as $rate) {///2 //Output the value of 1EUR for a currency code //echo '1€='.$rate["rate"].' '.$rate["currency"].'
'; $tableau_cours[strtolower($rate["currency"])] = $rate["rate"]; //-------------------------------------------------- //Here you can add your code for inserting //$rate["rate"] and $rate["currency"] into your database //-------------------------------------------------- }///2 //print_r($tableau_cours); $valeur_1_euro_chf = floatval($tableau_cours['chf']); $valeur_1_euro_chf_vente = $valeur_1_euro_chf/100*104; /*< debug ___*/debug('non',0,__FILE__,__LINE__,'','','valeur_1_euro_chf_vente',$valeur_1_euro_chf_vente,0,'jaune');/* ___ debug >*/ $update = "UPDATE preferences SET pref_valeur ='$today_local' WHERE pref_parametre ='date_change'"; $result=$lienI->query($update); $update = "UPDATE preferences SET pref_valeur ='$valeur_1_euro_chf_vente' WHERE pref_parametre ='euro_taux'"; $result=$lienI->query($update); }///2 }///1 if(!isset($_SESSION['euro'])) {///1 $query_change_man = "SELECT pref_valeur FROM preferences WHERE pref_lieu = 'gsb' AND pref_parametre = 'euro_taux_manuel'"; $result_change_man = $lienI->query($query_change_man); $ligne_change_man = $result_change_man->fetch_array(); /*< debug ___*/debug('non',1,__FILE__,__LINE__,"ligne_change_man",$ligne_change_man,'','',1,'jaune');/* ___ debug >*/ if($ligne_change_man[0]==0) {///2 $query_change_auto = "SELECT pref_valeur FROM preferences WHERE pref_lieu = 'gsba' AND pref_parametre = 'euro_taux'"; $result_change_auto = $lienI->query($query_change_auto); $ligne_change_auto = $result_change_auto->fetch_array(); /*< debug ___*/debug('non',1,__FILE__,__LINE__,"ligne_change_auto",$ligne_change_auto,'','',1,'jaune');/* ___ debug >*/ $valeur_1_euro_chf = floatval($ligne_change_auto[0]); $valeur_1_euro_chf_vente = $valeur_1_euro_chf/100*104;// marge de vente par les banques env. 2.5% + 1.5% securite de change } else {///2 $valeur_1_euro_chf_vente = $ligne_change_man[0]; }///2 $_SESSION['euro'] = $valeur_1_euro_chf_vente; }///1 /*< debug ___*/debug('non',1,__FILE__,__LINE__,"SESSION[euro]",$_SESSION['euro'],'','',1,'jaune');/* ___ debug >*/ if($hote=='sdt-design.ch' || $hote=='www.sdt-design.ch') { $body_class='body_sdt'; } elseif($hote=='localhost' || $hote=='127.0.0.1') { $body_class='body_local'; } elseif($hote=='gsbernard.com' || $hote=='www.gsbernard.com') { $body_class='body_hospice'; }?>
*/ ?>
'.$libelles['reservation_sejour'][$langue].''?>
0 && $page != 8 && $page != 9){ ?> 0 && $page != 8 && $page != 9){ ?>
*/ include 'tech/navbarre_pages.php' ?>
0) include_once('gestion/col_droite.php'); ?>