/* Entête du programme */ SELECT CONCAT( CASE WHEN MONTH (NOW()) = 1 Then "JANVIER" WHEN MONTH (NOW()) = 2 Then "FEVRIER" WHEN MONTH (NOW()) = 3 Then "MARS" WHEN MONTH (NOW()) = 4 Then "AVRIL" WHEN MONTH (NOW()) = 5 Then "MAI" WHEN MONTH (NOW()) = 6 Then "JUIN" WHEN MONTH (NOW()) = 7 Then "JUILLET" WHEN MONTH (NOW()) = 8 Then "AOUT" WHEN MONTH (NOW()) = 9 Then "SEPTEMBRE" WHEN MONTH (NOW()) = 10 Then "OCTOBRE" WHEN MONTH (NOW()) = 11 Then "NOVEMBRE" ELSE "DECEMBRE" END," ", YEAR(NOW()) ) as 'Programme'; /* Semaine en cours */ SELECT CONCAT( CASE WHEN WEEKDAY (datep) = 0 Then "
Lundi" WHEN WEEKDAY (datep) = 1 Then "
Mardi" WHEN WEEKDAY (datep) = 2 Then "
Mercredi" WHEN WEEKDAY (datep) = 3 Then "
Jeudi" WHEN WEEKDAY (datep) = 4 Then "
Vendredi" WHEN WEEKDAY (datep) = 5 Then "
Samedi" ELSE "
Dimanche" END, " ",DAY(datep),"
", CASE WHEN datep = datep2 Then '' ELSE CONCAT("De ",TIME_FORMAT(datep,"%H h %i")," à ",TIME_FORMAT (datep2,"%H h %i"),"
") END,"
", label, "
",LEFT(note,INSTR(note,"
")-1) ) as 'Semaine en cours' /* ,`location` */ FROM `llx89_actioncomm` WHERE code = 'ANIMATION' AND ( ( WEEK(NOW()) = WEEK(datep) AND YEAR(NOW()) = YEAR(datep)) OR ( WEEK(NOW())-51 = WEEK(datep) AND YEAR(NOW())+ 1 = YEAR(datep)) ) Order by datep /* Semaine +1 */ SELECT CONCAT( CASE WHEN WEEKDAY (datep) = 0 Then "
Lundi" WHEN WEEKDAY (datep) = 1 Then "
Mardi" WHEN WEEKDAY (datep) = 2 Then "
Mercredi" WHEN WEEKDAY (datep) = 3 Then "
Jeudi" WHEN WEEKDAY (datep) = 4 Then "
Vendredi" WHEN WEEKDAY (datep) = 5 Then "
Samedi" ELSE "
Dimanche" END, " ",DAY(datep),"
", CASE WHEN datep = datep2 Then '' ELSE CONCAT("De ",TIME_FORMAT(datep,"%H h %i")," à ",TIME_FORMAT (datep2,"%H h %i"),"
") END,"
", label, "
",LEFT(note,INSTR(note,"
")-1) ) as 'Semaine +1' /* ,`location` */ FROM `llx89_actioncomm` WHERE code = 'ANIMATION' AND ( ( WEEK(NOW())+1 = WEEK(datep) AND YEAR(NOW()) = YEAR(datep)) OR ( WEEK(NOW())-51 = WEEK(datep) AND YEAR(NOW())+ 1 = YEAR(datep)) ) Order by datep /* Semaine +2 */ SELECT CONCAT( CASE WHEN WEEKDAY (datep) = 0 Then "
Lundi" WHEN WEEKDAY (datep) = 1 Then "
Mardi" WHEN WEEKDAY (datep) = 2 Then "
Mercredi" WHEN WEEKDAY (datep) = 3 Then "
Jeudi" WHEN WEEKDAY (datep) = 4 Then "
Vendredi" WHEN WEEKDAY (datep) = 5 Then "
Samedi" ELSE "
Dimanche" END, " ",DAY(datep),"
", CASE WHEN datep = datep2 Then '' ELSE CONCAT("De ",TIME_FORMAT(datep,"%H h %i")," à ",TIME_FORMAT (datep2,"%H h %i"),"
") END,"
", label, "
",LEFT(note,INSTR(note,"
")-1) ) as 'Semaine +2' /* ,`location` */ FROM `llx89_actioncomm` WHERE code = 'ANIMATION' AND ( ( WEEK(NOW())+2 = WEEK(datep) AND YEAR(NOW()) = YEAR(datep)) OR ( WEEK(NOW())-50 = WEEK(datep) AND YEAR(NOW())+ 1 = YEAR(datep)) ) Order by datep /* Semaine +3 */ SELECT CONCAT( CASE WHEN WEEKDAY (datep) = 0 Then "
Lundi" WHEN WEEKDAY (datep) = 1 Then "
Mardi" WHEN WEEKDAY (datep) = 2 Then "
Mercredi" WHEN WEEKDAY (datep) = 3 Then "
Jeudi" WHEN WEEKDAY (datep) = 4 Then "
Vendredi" WHEN WEEKDAY (datep) = 5 Then "
Samedi" ELSE "
Dimanche" END, " ",DAY(datep),"
", CASE WHEN datep = datep2 Then '' ELSE CONCAT("De ",TIME_FORMAT(datep,"%H h %i")," à ",TIME_FORMAT (datep2,"%H h %i"),"
") END,"
", label, "
",LEFT(note,INSTR(note,"
")-1) ) as 'Semaine +3' /* ,`location` */ FROM `llx89_actioncomm` WHERE code = 'ANIMATION' AND ( ( WEEK(NOW())+3 = WEEK(datep) AND YEAR(NOW()) = YEAR(datep)) OR ( WEEK(NOW())-49 = WEEK(datep) AND YEAR(NOW())+ 1 = YEAR(datep)) ) Order by datep [[wiki:manifestations:animations_du_mois|Voir le programme complet]] - [[wiki:manifestations:animations_mois_prochain|]]