Galette

Galette

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

Result in a limited list of 10 records Result in a full list Result in an embeded document

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

Galette

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

Galette

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
	;