Galette
This is the latest revision of this page; it has no approved revision.
Jump to navigation
Jump to search
| Source: | DataSource |
|---|---|
| Language: | English |
| Topic: | Galette |
| SubTopic: | Query |
| Last Edit By: | DochyJP |
| LastEdit: | 2021-08-05 |
| Document type: | Table-Embedded |
| Status: | Active |
| Access: | Galette-restricted |
| Section | Source | Topic | SubTopic | Language | DocumentType | Status | Access |
|---|---|---|---|---|---|---|---|
| Galette - adhesion form DOSAN | DataSource | Galette | Script | English | Script | Active | Galette-restricted |
| Galette - script - members | DataSource | Galette | Script | English | Script | Active | Galette-restricted |
| Section | Source | Topic | SubTopic | Language | DocumentType | Status | Access |
|---|---|---|---|---|---|---|---|
| Galette - adhesion form DOSAN | DataSource | Galette | Script | English | Script | Active | Galette-restricted |
| Galette - script - members | DataSource | Galette | Script | English | Script | Active | Galette-restricted |
Galette - adhesion form DOSAN
| Source: | DataSource |
|---|---|
| Language: | English |
| Topic: | Galette |
| SubTopic: | Script |
| Last Edit By: | DochyJP |
| LastEdit: | 2021-08-05 |
| Document type: | script |
| Status: | Active |
| Access: | Galette-restricted |
A mettre en body :
<hr/>
<div class="infos">_T("Vul het formulier in en stuur het terugnaar / Remplissez le formulaire et renvoyez-le à / Complete the form and send it to itfdosantervuren@gmail .com ")</div>
<div class="infos">_T("of breng het naar de les of stuur het per post naar / ou amenez-le au cours ou renvoyez-le par la poste à / Bring it to the training or send it back by post to :")</div>
<table>
<tr>
<td width="50%"></td>
<td width="50%">{ASSO_ADDRESS_MULTI}</td>
</tr>
</table>
<hr/>
<table>
<tr>
<td height="30"></td>
</tr>
<tr>
<td>_T("Registratie proeflessen / Inscription scéances d'essai / Registration for trial lessons 2021 / 2022")
</td>
</tr>
<tr>
<td>_T("Registratie voor het seizoen / Inscription pour la saison / Registration for seazon 2021 / 2022")
</td>
</tr>
<tr>
<td height="30"></td>
</tr>
</table>
<table class="member">
<tr>
<td class="label">_T("Naam/Nom/Name")</td>
<td class="input">{LAST_NAME_ADH}</td>
</tr>
<tr>
<td class="label">_T("Voornaam/Prénom/First name")</td>
<td class="input">{FIRST_NAME_ADH}</td>
</tr>
<tr>
<td class="label">_T("Date de naissance/Gebortedatum/birthdate")</td>
<td class="input"></td>
</tr>
<tr>
<td class="label"> </td>
</tr>
<tr>
<td class="label">_T("Address")</td>
<td class="input">{ADDRESS_ADH}</td>
</tr>
<tr>
<td class="label"></td>
<td class="input"></td>
</tr>
<tr>
<td class="label">_T("Zip Code")</td>
<td class="cpinput">{ZIP_ADH}</td>
</tr>
<tr>
<td class="label">_T("City")</td>
<td class="towninput">{TOWN_ADH}</td>
</tr>
<tr>
<td class="label">_T("Country")</td>
<td class="input">{COUNTRY_ADH}</td>
</tr>
<tr>
<td class="label">_T("Email address")</td>
<td class="input">{EMAIL_ADH}</td>
</tr>
<tr>
<td class="label"> </td>
</tr>
<tr>
<td class="label">_T("Photos") </td>
<td class="label">_T("Ja/Oui/Yes - Nee/Non/No") </td>
</tr>
<tr>
<td colspan="2" height="10"></td>
</tr>
</table>
<p></p><p></p><p>Te / Fait à / At .............................. </p><p>De / Le / On .......... / .......... / .......... </p><p>_T("Signature")</p>
Galette - script - members
| Source: | DataSource |
|---|---|
| Language: | English |
| Topic: | Galette |
| SubTopic: | Script |
| Last Edit By: | DochyJP |
| LastEdit: | 2021-08-05 |
| Document type: | Script |
| Status: | Active |
| Access: | Galette-restricted |
Download this page as PDF
Script to construct the member listing of the club :
Use lagalettededosan database.
select if(activite_adh=1,'Active','Inactive') statut, adh.id_adh, adh.nom_adh, adh.prenom_adh , if(sexe_adh=0,'-',if(sexe_adh=1,'M','F'))sexe , ddn_adh , round((datediff(CURRENT_DATE,ddn_adh)/365.25+0.5)-1) leeftijd, adresse_adh, cp_adh, ville_adh, tel_adh, gsm_adh, email_adh , -- adh.id_statut, sta.libelle_statut, (select fc.val from galette_dynamic_fields df , galette_field_contents_1 fc where adh.id_adh=item_id and field_id=1 and df.field_val = fc.id) level, (Select grp.group_name from galette_groups grp, galette_groups_members grpmb where grp.id_group = grpmb.id_group and adh.id_adh=grpmb.id_adh) AgeGroup -- into outfile '/var/www/vhosts/club.dosan.be/exports/galette-members-dosan' fields terminated by '|' lines terminated by '\r\n' from galette_adherents adh, galette_statuts sta where adh.id_statut = sta.id_statut and sta.libelle_statut <> "non-member" and ( adh.id_statut < 5 OR adh.id_statut = 12) -- comptes active students -- and round((datediff(CURRENT_DATE,ddn_adh)/365.25+0.5)-1) < 18 -- jeunes de moins de 18 ans -- and cp_adh = 3080 -- and cp_adh in (3040,3060,1560,3090) -- and adh.nom_adh='Dochy' order by adh.nom_adh, adh.prenom_adh ;