Modèle:Synthese/Extraction : Différence entre versions

De Forum des Usages Coopératifs
 
(24 révisions intermédiaires par un utilisateur sont masquées)
Ligne 2 : Ligne 2 :
 
{{Admin/Edition|{{{1|}}}}}
 
{{Admin/Edition|{{{1|}}}}}
 
<center>
 
<center>
−
{{#ask:[[Category:Forum_{{#var:i}}/Inscriptions]] [[Is online::true]]
+
{{#ask:[[Category:Forum_{{#var:i}}/Inscriptions]]
 
  | mainlabel=-
 
  | mainlabel=-
−
  | ?Is registered_{{#var:i}}=ident
+
  | ?Has status=status
−
  | ?Holds the position of=fonction
+
  | ?Unik_id=id
 +
| ?Prenom=prenom
 +
| ?Nom=nom
 +
| ?Budget 2016=intervention
 +
| ?Supported by=p_charge
 +
| ?Has email=email
 
  | ?arrives on=arrive le | ?arrives at=à  
 
  | ?arrives on=arrive le | ?arrives at=à  
 
  | ?leaves on=part le | ?leaves at=à
 
  | ?leaves on=part le | ?leaves at=à
 +
| ?Holds the position of=fonction
 
  | ?Belongs to=structure
 
  | ?Belongs to=structure
 
  | ?Has address=address | ?Has zipcode=cp | ?From city=ville
 
  | ?Has address=address | ?Has zipcode=cp | ?From city=ville
 +
| ?Total cost=c_total | ?Will pay=c_inscription
 +
| ?Mezel1=nuit_1 | ?Mezel2=nuit_2 | ?Mezel3=nuit_3 | ?Mezel4=nuit_4 | ?Mezel5=nuit_5
 +
| ?Rak1=repas_2 | ?Rak2=repas_3 | ?Rak3=repas_4
 +
| ?fest1=soiree_1 | ?fest2=soiree_2 | ?Boisson
 +
| ?Buffet=buffet | ?Bus=bus | ?Need basket=panier
 +
| ?Paid by=paiement | ?To recipient=recip
 +
| ?Comments=commentaires
 +
| sort=Has status,Unik_id
 +
| format=csv
 +
| searchlabel=export final validation public et non validés (csv)
 +
| limit=500
 +
}}  <->  {{#ask:[[Category:Forum_{{#var:i}}/Inscriptions]] [[Is online::true]]
 +
| mainlabel=-
 +
| ?Unik_id=id
 +
| ?Prenom=prenom
 +
| ?Nom=nom
 +
| ?Has status=status
 +
| ?Budget 2016=intervention
 
  | ?Supported by=p_charge
 
  | ?Supported by=p_charge
−
| ?Will pay=c_inscription
 
−
| ?Total cost=c_total
 
 
  | ?Has email=email
 
  | ?Has email=email
 +
| ?arrives on=arrive le | ?arrives at=à
 +
| ?leaves on=part le | ?leaves at=à
 +
| ?Holds the position of=fonction
 +
| ?Belongs to=structure
 +
| ?Has address=address | ?Has zipcode=cp | ?From city=ville
 +
| ?Total cost=c_total | ?Will pay=c_inscription
 
  | ?Mezel1=nuit_1 | ?Mezel2=nuit_2 | ?Mezel3=nuit_3 | ?Mezel4=nuit_4 | ?Mezel5=nuit_5
 
  | ?Mezel1=nuit_1 | ?Mezel2=nuit_2 | ?Mezel3=nuit_3 | ?Mezel4=nuit_4 | ?Mezel5=nuit_5
 
  | ?Rak1=repas_2 | ?Rak2=repas_3 | ?Rak3=repas_4
 
  | ?Rak1=repas_2 | ?Rak2=repas_3 | ?Rak3=repas_4
−
  | ?fest1=soiree_1 | ?fest2=soiree_2
+
  | ?fest1=soiree_1 | ?fest2=soiree_2 | ?Boisson
 
  | ?Buffet=buffet | ?Bus=bus | ?Need basket=panier
 
  | ?Buffet=buffet | ?Bus=bus | ?Need basket=panier
 
  | ?Paid by=paiement | ?To recipient=recip
 
  | ?Paid by=paiement | ?To recipient=recip
−
  | ?Has status=status
+
  | ?Comments=commentaires
 +
| sort=Unik_id
 
  | format=csv
 
  | format=csv
−
  | searchlabel=export final complet (csv)
+
  | searchlabel=export final validation public (csv)
 
  | limit=500
 
  | limit=500
 
}}
 
}}
 
</center>
 
</center>
−
{{ #vardefine:day | {{Get|day0#ISO|{{#var:i}}}} }} {{#var:day}}
+
{{ #vardefine:day | {{Get|day0#ISO|{{#var:i}}}} }}
 
<table class="wikitable" style="margin:0 auto 0 auto;" width=900px>
 
<table class="wikitable" style="margin:0 auto 0 auto;" width=900px>
 
<tr>
 
<tr>
 
<th></th>
 
<th></th>
−
<th width=18%>]{{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 5 months}} ; {{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 28 days}}]</th>
+
<th width=16%>]{{#time:m/d/Y | {{#var:day}} - 5 months}} ; {{#time:m/d/Y | {{#var:day}} - 28 days}}]</th>
−
<th width=18%>]{{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 28 days}} ; {{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 14 days}}]</th>
+
<th width=16%>]{{#time:m/d/Y | {{#var:day}} - 28 days}} ; {{#time:m/d/Y | {{#var:day}} - 14 days}}]</th>
−
<th width=18%>]{{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 14 days}} ; {{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 7 days}}]</th>
+
<th width=16%>]{{#time:m/d/Y | {{#var:day}} - 14 days}} ; {{#time:m/d/Y | {{#var:day}} - 7 days}}]</th>
−
<th width=18%>]{{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 7 days}} ; {{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}}}}]</th>
+
<th width=16%>]{{#time:m/d/Y | {{#var:day}} - 7 days}} ; {{#time:m/d/Y | {{#var:day}} }}]</th>
−
<th width=18%>]{{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}}}} ; {{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} + 2 months}}]</th>
+
<th width=16%>]{{#time:m/d/Y | {{#var:day}} }} ; {{#time:m/d/Y | {{#var:day}} + 2 months}}]</th>
 +
<th width=16%>Full Database</th>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
Ligne 39 : Ligne 69 :
 
<td></td>
 
<td></td>
 
<td></td>
 
<td></td>
−
<td>{{Extract/Fiches | after={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 5 months}} | before={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 7 days}}}}</td>
+
<td>{{Extract/Fiches | after={{#time:m/d/Y | {{#var:day}} - 5 months}} | before={{#time:m/d/Y | {{#var:day}} - 7 days}}}}</td>
−
<td>{{Extract/Fiches | after={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 7 days}} | before={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}}}}}}</td>
+
<td>{{Extract/Fiches | after={{#time:m/d/Y | {{#var:day}} - 7 days}} | before={{#time:m/d/Y | {{#var:day}} }} }}</td>
−
<td>{{Extract/Fiches | after={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}}}} | before={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} + 2 months}}}}</td>
+
<td>{{Extract/Fiches | after={{#time:m/d/Y | {{#var:day}} }} | before={{#time:m/d/Y | {{#var:day}} + 2 months}}}}</td>
 +
<td>{{Extract/Fiches | after={{#time:m/d/Y | {{#var:day}} - 5 months}} | before={{#time:m/d/Y | {{#var:day}} + 2 months}}}}</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<th>Participants</th>
 
<th>Participants</th>
−
<td>{{Extract/Confirm | after={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 5 months}} | before={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 28 days}} | status=participant}}</td>
+
<td>{{Extract/Confirm | after={{#time:m/d/Y | {{#var:day}} - 5 months}} | before={{#time:m/d/Y | {{#var:day}} - 28 days}} | status=participant}}</td>
−
<td>{{Extract/Confirm | after={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 28 days}} | before={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 14 days}} | status=participant}}</td>
+
<td>{{Extract/Confirm | after={{#time:m/d/Y | {{#var:day}} - 28 days}} | before={{#time:m/d/Y | {{#var:day}} - 14 days}} | status=participant}}</td>
−
<td>{{Extract/Confirm | after={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 14 days}} | before={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 7 days}} | status=participant}}</td>
+
<td>{{Extract/Confirm | after={{#time:m/d/Y | {{#var:day}} - 14 days}} | before={{#time:m/d/Y | {{#var:day}} - 7 days}} | status=participant}}</td>
−
<td>{{Extract/Confirm | after={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 7 days}} | before={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}}}} | status=participant}}</td>
+
<td>{{Extract/Confirm | after={{#time:m/d/Y | {{#var:day}} - 7 days}} | before={{#time:m/d/Y | {{#var:day}} }} | status=participant}}</td>
−
<td>{{Extract/Confirm | after={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}}}} | before={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} + 2 months}} | status=participant}}</td>
+
<td>{{Extract/Confirm | after={{#time:m/d/Y | {{#var:day}} }} | before={{#time:m/d/Y | {{#var:day}} + 2 months}} | status=participant}}</td>
 +
<td>{{Extract/Confirm | after={{#time:m/d/Y | {{#var:day}} - 5 months}} | before={{#time:m/d/Y | {{#var:day}} + 2 months}} | status=participant}}</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<th>Intervenants</th>
 
<th>Intervenants</th>
−
<td>{{Extract/Confirm | after={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 5 months}} | before={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 28 days}} | status=intervenant}}</td>
+
<td>{{Extract/Confirm | after={{#time:m/d/Y | {{#var:day}} - 5 months}} | before={{#time:m/d/Y | {{#var:day}} - 28 days}} | status=intervenant}}</td>
−
<td>{{Extract/Confirm | after={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 28 days}} | before={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 14 days}} | status=intervenant}}</td>
+
<td>{{Extract/Confirm | after={{#time:m/d/Y | {{#var:day}} - 28 days}} | before={{#time:m/d/Y | {{#var:day}} - 14 days}} | status=intervenant}}</td>
−
<td>{{Extract/Confirm | after={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 14 days}} | before={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 7 days}} | status=intervenant}}</td>
+
<td>{{Extract/Confirm | after={{#time:m/d/Y | {{#var:day}} - 14 days}} | before={{#time:m/d/Y | {{#var:day}} - 7 days}} | status=intervenant}}</td>
−
<td>{{Extract/Confirm | after={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 7 days}} | before={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}}}} | status=intervenant}}</td>
+
<td>{{Extract/Confirm | after={{#time:m/d/Y | {{#var:day}} - 7 days}} | before={{#time:m/d/Y | {{#var:day}} }} | status=intervenant}}</td>
−
<td>{{Extract/Confirm | after={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}}}} | before={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} + 2 months}} | status=intervenant}}</td>
+
<td>{{Extract/Confirm | after={{#time:m/d/Y | {{#var:day}} }} | before={{#time:m/d/Y | {{#var:day}} + 2 months}} | status=intervenant}}</td>
 +
<td>{{Extract/Confirm | after={{#time:m/d/Y | {{#var:day}} - 5 months}} | before={{#time:m/d/Y | {{#var:day}} + 2 months}} | status=intervenant}}</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<th>Newsletter</th>
 
<th>Newsletter</th>
−
<td>{{Extract/Letter | after={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 5 months}} | before={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 28 days}} }}</td>
+
<td>{{Extract/Letter | after={{#time:m/d/Y | {{#var:day}} - 5 months}} | before={{#time:m/d/Y | {{#var:day}} - 28 days}} }}</td>
−
<td>{{Extract/Letter | after={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 28 days}} | before={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 14 days}} }}</td>
+
<td>{{Extract/Letter | after={{#time:m/d/Y | {{#var:day}} - 28 days}} | before={{#time:m/d/Y | {{#var:day}} - 14 days}} }}</td>
−
<td>{{Extract/Letter | after={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 14 days}} | before={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 7 days}} }}</td>
+
<td>{{Extract/Letter | after={{#time:m/d/Y | {{#var:day}} - 14 days}} | before={{#time:m/d/Y | {{#var:day}} - 7 days}} }}</td>
−
<td>{{Extract/Letter | after={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 7 days}} | before={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}}}} }}</td>
+
<td>{{Extract/Letter | after={{#time:m/d/Y | {{#var:day}} - 7 days}} | before={{#time:m/d/Y | {{#var:day}} }} }}</td>
−
<td>{{Extract/Letter | after={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}}}} | before={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} + 2 months}} }}</td>
+
<td>{{Extract/Letter | after={{#time:m/d/Y | {{#var:day}} }} | before={{#time:m/d/Y | {{#var:day}} + 2 months}} }}</td>
 +
<td>{{Extract/Letter | after={{#time:m/d/Y | {{#var:day}} - 5 months}} | before={{#time:m/d/Y | {{#var:day}} + 2 months}} }}</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<th>Contribution</th>
 
<th>Contribution</th>
−
<td>{{Extract/Contrib | after={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 5 months}} | before={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 28 days}} }}</td>
+
<td>{{Extract/Contrib | after={{#time:m/d/Y | {{#var:day}} - 5 months}} | before={{#time:m/d/Y | {{#var:day}} - 28 days}} }}</td>
−
<td>{{Extract/Contrib | after={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 28 days}} | before={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 14 days}} }}</td>
+
<td>{{Extract/Contrib | after={{#time:m/d/Y | {{#var:day}} - 28 days}} | before={{#time:m/d/Y | {{#var:day}} - 14 days}} }}</td>
−
<td>{{Extract/Contrib | after={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 14 days}} | before={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 7 days}} }}</td>
+
<td>{{Extract/Contrib | after={{#time:m/d/Y | {{#var:day}} - 14 days}} | before={{#time:m/d/Y | {{#var:day}} - 7 days}} }}</td>
−
<td>{{Extract/Contrib | after={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} - 7 days}} | before={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}}}} }}</td>
+
<td>{{Extract/Contrib | after={{#time:m/d/Y | {{#var:day}} - 7 days}} | before={{#time:m/d/Y | {{#var:day}} }} }}</td>
−
<td>{{Extract/Contrib | after={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}}}} | before={{#time:m/d/Y | {{Get|day0#ISO|{{#var:i}}}} + 2 months}} }}</td>
+
<td>{{Extract/Contrib | after={{#time:m/d/Y | {{#var:day}} }} | before={{#time:m/d/Y | {{#var:day}} + 2 months}} }}</td>
 +
<td>{{Extract/Contrib | after={{#time:m/d/Y | {{#var:day}} - 5 months}} | before={{#time:m/d/Y | {{#var:day}} + 2 months}} }}</td>
 +
</tr>
 +
<tr>
 +
<th>Hébergement</th>
 +
<td></td>
 +
<td></td>
 +
<td></td>
 +
<td></td>
 +
<td></td>
 +
<td>{{Extract/Heberge | after={{#time:m/d/Y | {{#var:day}} - 5 months}} | before={{#time:m/d/Y | {{#var:day}} + 2 months }} }}</td>
 
</tr>
 
</tr>
 
</table>
 
</table>
 
</includeonly><noinclude>[[Category:Bazar/Template]]{{Modèle:BazarDoc|modèle}}</noinclude>
 
</includeonly><noinclude>[[Category:Bazar/Template]]{{Modèle:BazarDoc|modèle}}</noinclude>

Version actuelle en date du 1 juillet 2016 à 10:39


Bittorrent.png

Portail :
Sémantique bazar

Il y a actuellement 19 articles liés à ce sujet.

PortailProjetCatégorie


Documentation


[edit]

Template-info.svg Documentation du BazaR

Utilisation

Ce modèle affiche un tableau de synthèse du nombre d'inscrit pour chaque journée du forum

Syntaxe

Un argument optionnel est utilisable, il permet de spécifier l'année spécifique sur laquelle l'on souhaite appliquer le modèle 

{{Synthese/Extraction|2018}}

Si cet argument est omis, le modèle tente de calculer à partir de l'url l'année pour laquelle le modèle sera appliqué. 

{{Synthese/Extraction }}


export final validation public et non validés (csv) <-> export final validation public (csv)

]02/02/2018 ; 06/04/2018] ]06/04/2018 ; 06/18/2018] ]06/18/2018 ; 06/25/2018] ]06/25/2018 ; 07/02/2018] ]07/02/2018 ; 09/02/2018] Full Database
Fiches
Participants
Intervenants
Newsletter
Contribution
Hébergement


Dépendance




Récupérée de « http://archives.forum-usages-cooperatifs.net/index.php?title=Modèle:Synthese/Extraction&oldid=58617 »