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

/* Mois en cours */
<sql>
SELECT 
CONCAT("<div style=background-color:#5A0273;color:white;>",
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()),
"</div> "
) as '';
</sql>
</WRAP>

===== Liste  =====
<WRAP center centeralign>
<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 par ordre d'apparition dans le mois"
FROM `llx89_actioncomm` 
WHERE code = 'ANIMATION'
AND MONTH(NOW()) = MONTH(datep)
AND YEAR(NOW()) = YEAR(datep)
Group by label      
Order by datep

</sql>


</WRAP>
===== Calendrier =====


~~SNIPPET_O1777465550~~wiki:snippets:agenda_animations~~
<WRAP center round box 100%>

/* Entête du programme */
<sql>
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';
</sql>

/* Semaine en cours */

<WRAP quarter column centeralign >
<sql>
SELECT 
CONCAT(
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>",
label,
"<br/>",LEFT(note,INSTR(note,"<hr />")-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
</sql>
</WRAP>

/* Semaine +1 */
<WRAP quarter column centeralign >
<sql>
SELECT 
CONCAT(
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>",
label,
"<br/>",LEFT(note,INSTR(note,"<hr />")-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
</sql>
</WRAP>

/* Semaine +2 */
<WRAP quarter column centeralign >
<sql>
SELECT 
CONCAT(
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>",
label,
"<br/>",LEFT(note,INSTR(note,"<hr />")-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
</sql>
</WRAP>
/* Semaine +3 */
<WRAP quarter column centeralign >
<sql>
SELECT 
CONCAT(
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>",
label,
"<br/>",LEFT(note,INSTR(note,"<hr />")-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
</sql>
</WRAP>

[[wiki:manifestations:animations_du_mois|Voir le programme complet]] - [[wiki:manifestations:animations_mois_prochain|]]

</WRAP>
~~SNIPPET_C~~wiki:snippets:agenda_animations~~



~~SNIPPET_O1777465550~~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~~