~~NOCACHE~~ 
====== Les animations du mois prochain ======
<WRAP center centeralign>

/* Mois prochain */
<sql>
SELECT 
CONCAT("<div style=background-color:#5A0273;color:white;>",
CASE
  WHEN MONTH (DATE_ADD(NOW(), INTERVAL 1 MONTH)) = 1 Then "JANVIER"
  WHEN MONTH (DATE_ADD(NOW(), INTERVAL 1 MONTH)) = 2 Then "FEVRIER"
  WHEN MONTH (DATE_ADD(NOW(), INTERVAL 1 MONTH)) = 3 Then "MARS"
  WHEN MONTH (DATE_ADD(NOW(), INTERVAL 1 MONTH)) = 4 Then "AVRIL"
  WHEN MONTH (DATE_ADD(NOW(), INTERVAL 1 MONTH)) = 5 Then "MAI"
  WHEN MONTH (DATE_ADD(NOW(), INTERVAL 1 MONTH)) = 6 Then "JUIN"
  WHEN MONTH (DATE_ADD(NOW(), INTERVAL 1 MONTH)) = 7 Then "JUILLET"
  WHEN MONTH (DATE_ADD(NOW(), INTERVAL 1 MONTH)) = 8 Then "AOUT"
  WHEN MONTH (DATE_ADD(NOW(), INTERVAL 1 MONTH)) = 9 Then "SEPTEMBRE"
  WHEN MONTH (DATE_ADD(NOW(), INTERVAL 1 MONTH)) = 10 Then "OCTOBRE"
  WHEN MONTH (DATE_ADD(NOW(), INTERVAL 1 MONTH)) = 11 Then "NOVEMBRE"
  ELSE "DECEMBRE"
END," ",
YEAR((DATE_ADD(NOW(), INTERVAL 1 MONTH))),
"</div> "
) as '';
</sql>

<sql>
SELECT
CONCAT("<br/>",
"<h2>",label,"</h2>",
"<h3>",
CASE
  WHEN WEEKDAY (datep) = 0 Then "<div style=background-color:#03A696;>Lundi"
  WHEN WEEKDAY (datep) = 1 Then "<div style=background-color:#97BF04;>Mardi"
  WHEN WEEKDAY (datep) = 2 Then "<div style=background-color:#FFC900;>Mercredi"
  WHEN WEEKDAY (datep) = 3 Then "<div style=background-color:#03A696;>Jeudi"
  WHEN WEEKDAY (datep) = 4 Then "<div style=background-color:#97BF04;>Vendredi"
  WHEN WEEKDAY (datep) = 5 Then "<div style=background-color:#FFC900;>Samedi"
  ELSE "<div style=background-color:#F20544;>Dimanche"
END,
" ",DAY(datep),"<br/>",
CASE
  WHEN datep = datep2 Then ''
  ELSE CONCAT("De ",TIME_FORMAT(datep,"%H h %i")," à ",TIME_FORMAT (datep2,"%H h %i"),"<br/>")
END,"</div>",
"</h3>",
"<div>",REPLACE(note,'src="/viewimage.php','src="https://gestioncafe.reseauanais.fr/viewimage.php'),"</div>",
"<br/>"
) as "Les activités"
FROM `llx89_actioncomm` 
WHERE code = 'ANIMATION'
AND MONTH((DATE_ADD(NOW(), INTERVAL 1 MONTH))) = MONTH(datep)
AND YEAR((DATE_ADD(NOW(), INTERVAL 1 MONTH))) = YEAR(datep)
Group by label      
Order by datep

</sql>


</WRAP>



~~SNIPPET_O1576851240~~wiki:snippets:retourner_aux_sommaires~~
/* Bloc à utiliser au niveau R+3 */
====== Retourner aux sommaires ======
<WRAP center centeralign>
/* lien vers les sommaires des catégories supérieure */
[[:]] - [[..:]] - [[.:]]
</WRAP>
~~SNIPPET_C~~wiki:snippets:retourner_aux_sommaires~~