
require("include/conex_db.inc");
$aujourdhui = getdate();
$mois = $aujourdhui['mon'];
$mois_encours = $aujourdhui['mon'];
$jour = $aujourdhui['mday'];
$an = $aujourdhui['year'];
$aujourdhui = "$an-$mois-$jour";
//PAVE Railway Mobility MEETINGS
//------------------------------------------------
print("
You will find here all the events and meetings related to the Railway mobility Project.
Click on the events' titles to get more details. ");
print ("");
print("");
$sql = new extranet_DB;
$sql->query("SELECT * from meetings where domainid='111' order by date_debut DESC");
while($sql->next_record())
{
$libelle_en = $sql->f("libelle_en");
$lieu = $sql->f("lieu");
$date_debut = $sql->f("date_debut");
$date_fin = $sql->f("date_fin");
//ATTENTION TOUJOURS AJOUTER LA VARIABLE SUIVANTE
$folderid = $sql->f("folderid");
// SPLITTE LA DATE et classe par mois
$test = split("\-", $date_debut);
$an = $test['0'];
$mois = $test['1'];
$jour = $test['2'];
if($mois == 1){$moislibellettre = "January";}
elseif($mois == 2){$moislibellettre = "February";}
elseif($mois == 3){$moislibellettre = "March";}
elseif($mois == 4){$moislibellettre = "April";}
elseif($mois == 5){$moislibellettre = "May";}
elseif($mois == 6){$moislibellettre = "June";}
elseif($mois == 7){$moislibellettre = "July";}
elseif($mois == 8){$moislibellettre = "August";}
elseif($mois == 9){$moislibellettre = "September";}
elseif($mois == 10){$moislibellettre = "October";}
elseif($mois == 11){$moislibellettre = "November";}
elseif($mois == 12){$moislibellettre = "December";}
if($mois == 1){$moislibel = "01";}
elseif($mois == 2){$moislibel = "02";}
elseif($mois == 3){$moislibel = "03";}
elseif($mois == 4){$moislibel = "04";}
elseif($mois == 5){$moislibel = "05";}
elseif($mois == 6){$moislibel = "06";}
elseif($mois == 7){$moislibel = "07";}
elseif($mois == 8){$moislibel = "08";}
elseif($mois == 9){$moislibel = "09";}
elseif($mois == 10){$moislibel = "10";}
elseif($mois == 11){$moislibel = "11";}
elseif($mois == 12){$moislibel = "12";}
if($mois != $mois_old)
{
// DATE - MOIS EN COURS //
print(" |
");
if($mois != $mois_encours)
{print("");}
else {print(" ");}
print("$moislibellettre $an | | ");// print("$moislibel $an//
}
// CONTENU - JOUR DE LA CONFERENCE //
print ("
f("id")."&action=event_detail')>
");
print ("$jour/$moislibel | ");
// CONTENU - LIBELLE DE LA CONFERENCE //
print (" ");
print("f("id")."&action=event_detail')>");
if($date_debut >= $aujourdhui)
{print(" $libelle_en | ");}
else{print(" $libelle_en");}
// CONTENU - LIEU DE LA CONFERENCE //
print (" $lieu | ");
// CONTENU - DOCUMENTS A TELECHARGER //
print("");
if($folderid)
{print(" ");}
print(" | ");
print (" | ");
$mois_old = $mois;
}
print("
");
//------------------------------------------------------
// FIN PAVE ERTMS MEETINGS
?>

|