====== Agenda des animations ======

<WRAP center round info 60%>
Le calendrier des animations est inscrit dans l'agenda Dolibarr. \\
Les animations de la semaine en cours et des 3 semaines suivantes sont présentées en colonne sur cette page.
</WRAP>


/* 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 column centeralign 200px>
<sql>
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),"<br/>",
"De ",TIME_FORMAT(datep,"%H h %i"), 
" à ",TIME_FORMAT (datep2,"%H h %i"),
"<br/>",label,
"<br/>",note
) as 'Semaine en cours'
/* ,`location` */ 
FROM `llx89_actioncomm` 
WHERE code = 'ANIMATION'
AND WEEK(NOW()) = WEEK(datep)
AND YEAR(NOW()) = YEAR(datep)
Order by datep
</sql>
</WRAP>
/* Semaine +1 */
<WRAP column centeralign 200px>
<sql>
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),"<br/>",
"De ",TIME_FORMAT(datep,"%H h %i"), 
" à ",TIME_FORMAT (datep2,"%H h %i"),
"<br/>",label,
"<br/>",note
) as 'Semaine +1'
/* ,`location` */ 
FROM `llx89_actioncomm` 
WHERE code = 'ANIMATION'
AND WEEK(NOW())+1 = WEEK(datep)
AND YEAR(NOW()) = YEAR(datep)
Order by datep
</sql>
</WRAP>
/* Semaine +2 */
<WRAP column centeralign 200px>
<sql>
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),"<br/>",
"De ",TIME_FORMAT(datep,"%H h %i"), 
" à ",TIME_FORMAT (datep2,"%H h %i"),
"<br/>",label,
"<br/>",note
) as 'Semaine +2'
/* ,`location` */ 
FROM `llx89_actioncomm` 
WHERE code = 'ANIMATION'
AND WEEK(NOW())+2 = WEEK(datep)
AND YEAR(NOW()) = YEAR(datep)
Order by datep
</sql>
</WRAP>
/* Semaine +3 */
<WRAP column centeralign 200px>
<sql>
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),"<br/>",
"De ",TIME_FORMAT(datep,"%H h %i"), 
" à ",TIME_FORMAT (datep2,"%H h %i"),
"<br/>",label,
"<br/>",note
) as 'Semaine +3'
/* ,`location` */ 
FROM `llx89_actioncomm` 
WHERE code = 'ANIMATION'
AND WEEK(NOW())+3 = WEEK(datep)
AND YEAR(NOW()) = YEAR(datep)
Order by datep
</sql>
</WRAP>



~~SNIPPET_O1570010920~~wiki:snippets:parcourir_le_site~~
<WRAP round box center centeralign 100% noprint>
===== Parcourir le site =====
/* Pages principales du site */
<nspages : -h1 -textPages="" -simpleLine -exclude>
/* Espaces collaboratifs */
[[wiki:]], [[playground:]]
/* Pôles associatif */
<nspages wiki: -subns -nopages -h1 -hideNoSubns  -simpleLine -textNS="" -exclude:snippets: -exclude:impressions: >
/* Contribuer et utiliser */
<WRAP center 60% noprint>
<nspages wiki: -h1 -simpleLine -textPages="Contribuer et utiliser" -actualTitle=4 -exclude:sommaire -exclude>
</WRAP>

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