Prochaines sorties
query("SELECT * FROM " .TABLE_PREFIX ."mod_sorties WHERE from_date > CURDATE() ORDER BY from_date ASC;" );
if($query->numRows() > 0) {
?>
fetchRow()) {
echo "
"; } }?>
".$sorties['titre']. "
"."\n"; echo ""."\n";
$sorties['from_date'] = strftime("%A, %d %B %Y",strtotime($sorties['from_date']));
$sorties['to_date'] = strftime("%A, %d %B %Y",strtotime($sorties['to_date']));
$query_paid_count = $database->query("SELECT COUNT(id) FROM ".TABLE_PREFIX ."mod_sorties_inscription WHERE sid=".$sorties['id']." AND paid=1");
$paid_count = $query_paid_count->fetchRow();
$query_acompte_paid_count = $database->query("SELECT COUNT(id) FROM ".TABLE_PREFIX ."mod_sorties_inscription WHERE sid=".$sorties['id']." AND acompte_paid=1");
$acompte_paid_count = $query_acompte_paid_count->fetchRow();
$query_count = $database->query("SELECT COUNT(id) FROM ".TABLE_PREFIX ."mod_sorties_inscription WHERE sid=".$sorties['id']);
$count = $query_count->fetchRow();
// voir si deja inscrit
/*if($_SESSION['USER_ID']!='') {
$query_inscrit = $database->query("SELECT * FROM " .TABLE_PREFIX ."mod_sorties_inscription WHERE sid={$sorties['id']}");
echo "Du ".$sorties['from_date']." au ".$sorties['to_date']." ";
// si encore places dispo
if($paid_count['COUNT(id)'] < $sorties['nb_part_max']) {
if($query_inscrit->numRows() == 0) { // pas inscrit
echo "".$sorties['titre']."
Du ".$sorties['from_date']." au ".$sorties['to_date']."
Prix: ".$sorties['prix']." Frs"))."\" title=\"Confirmation\" onclick=\"Modalbox.show(this.href, {title: this.title, width: 600}); return false;\">S'inscrire
"."\n"; }else{ echo "Inscrit
"."\n"; } }else { echo "Sortie complète "."\n"; if($query_inscrit->numRows() == 1) { echo "Déjà inscrit"."\n"; } echo("
"."\n"); } }else{*/ $date_now = new DateTime("now"); $date_limite = new DateTime($sorties['date_limite_inscription']); echo "Du ".$sorties['from_date']." au ".$sorties['to_date']." "; if($date_now < $date_limite) { //if($count['COUNT(id)'] < $sorties['nb_part_max']) { if($acompte_paid_count['COUNT(id)'] < $sorties['nb_part_max']) { echo "S'inscrire
"."\n"; }else { echo "Sortie complète
S'inscrire sur liste d'attente
"."\n"; } } else { echo "Inscriptions closes!\n"; } //} echo "
"."\n";
echo "Du ".$sorties['from_date']." au ".$sorties['to_date']."
Prix: ".$sorties['prix']." Frs"))."\" title=\"Confirmation\" onclick=\"Modalbox.show(this.href, {title: this.title, width: 600}); return false;\">S'inscrire
"."\n"; }else{ echo "Inscrit
"."\n"; } }else { echo "Sortie complète "."\n"; if($query_inscrit->numRows() == 1) { echo "Déjà inscrit"."\n"; } echo("
"."\n"); } }else{*/ $date_now = new DateTime("now"); $date_limite = new DateTime($sorties['date_limite_inscription']); echo "Du ".$sorties['from_date']." au ".$sorties['to_date']." "; if($date_now < $date_limite) { //if($count['COUNT(id)'] < $sorties['nb_part_max']) { if($acompte_paid_count['COUNT(id)'] < $sorties['nb_part_max']) { echo "S'inscrire
"."\n"; }else { echo "Sortie complète
S'inscrire sur liste d'attente
"."\n"; } } else { echo "Inscriptions closes!\n"; } //} echo "
"."\n";
echo $sorties['description'];
echo "
"."\n";
echo ""."\n";
if($sorties['prix']!=0){echo("Prix: ".$sorties['prix']." Frs"."
");}else{echo("");} if($sorties['acompte']!=0){echo("Acompte: ".$sorties['acompte']." Frs"."
");}else{echo("");} echo "Nb. max. de participants: ".$sorties['nb_part_max']."
"; echo "Inscrits: ".$acompte_paid_count['COUNT(id)']."
"; echo "Date limite d'inscription: ".strftime("%A, %d %B %Y",strtotime($sorties['date_limite_inscription']));; echo "
"."\n";
echo "");}else{echo("");} if($sorties['acompte']!=0){echo("Acompte: ".$sorties['acompte']." Frs"."
");}else{echo("");} echo "Nb. max. de participants: ".$sorties['nb_part_max']."
"; echo "Inscrits: ".$acompte_paid_count['COUNT(id)']."
"; echo "Date limite d'inscription: ".strftime("%A, %d %B %Y",strtotime($sorties['date_limite_inscription']));; echo "
"; } }?>
