SELECT * FROM evenement WHERE Repertoire_No=#attributes.Repertoire_No# and eventid='#form.eventid#' Order by eventid desc; PERIODE DE TEST - SYSTEME D'ENVOI EXCEL

<cfif form.actif is "2">Incomplet<cfelseif form.actif is "3">Confirmé<cfelseif form.actif is "6">Refusé<cfelse>En cours</cfif> #form.inscrid#<cfif listfindnocase("#event.niveau2#","membre_no")> #form.membre_no#</cfif> #REReplace("#form.itemligne1#", "<[^>]*>", "", "ALL")#<cfif len(form.itemligne2)><cfif len(form.itemligne1) and len(form.itemligne2)>/,</cfif> #REReplace("#form.itemligne2#", "<[^>]*>", "", "ALL")#</cfif><cfif len(form.itemligne3)>, #REReplace("#form.itemligne3#", "<[^>]*>", "", "ALL")#</cfif><cfif len(form.itemligne4)>, #REReplace("#form.itemligne4#", "<[^>]*>", "", "ALL")#</cfif><cfif len(form.itemligne5)>, #REReplace("#form.itemligne5#", "<[^>]*>", "", "ALL")#</cfif><cfif len(form.itemligne6)>, #REReplace("#form.itemligne6#", "<[^>]*>", "", "ALL")#</cfif><cfif listfindnocase("#form.politesse#","2")> Madame<cfelseif listfindnocase("#form.politesse#","1")> Monsieur<cfelseif listfindnocase("#form.politesse#","15")> Honorable<cfelseif listfindnocase("#form.politesse#","16")> Docteur<cfelse> #form.politesse#</cfif> #form.prenom# #form.nom#<cfif listfindnocase("#event.niveau2#","fonction")> #form.fonction#</cfif><cfif listfindnocase("#event.niveau2#","societe")> #form.societe#</cfif><cfif listfindnocase("#event.niveau2#","division")> #form.division#</cfif><cfif listfindnocase("#event.niveau2#","groupe1")> #form.groupe1#</cfif><cfif listfindnocase("#event.niveau2#","groupe2")> #form.groupe2#</cfif> #form.adresse# #form.adresse_line2# #form.adresse_line3# #form.ville# #form.province# #form.code_postal# <cfif listfindnocase("#event.niveau2#","pays")>#form.pays#</cfif> #form.telephone#<cfif listfindnocase("#event.niveau2#","telephonea")> #form.telephonea#</cfif> #form.telecopieur# #form.courriel#<cfif listfindnocase("#event.niveau2#","vousrejoindre")> #form.vousrejoindre#</cfif><cfif listfindnocase("#event.niveau2#","client")> #form.client#</cfif><cfif listfindnocase("#event.niveau2#","publier")> #form.publier#</cfif><cfif listfindnocase("#event.niveau2#","parti_premi")> #form.parti_premi#</cfif><cfif listfindnocase("#event.niveau2#","inscription_restriction")><cfif listfindnocase("#event.repas_restrict1#","1")> #form.repas_restrict1# #form.repas_details1#</cfif><cfif listfindnocase("#event.allergie1#","1")> #form.allergie1# #form.allergie1_details#</cfif><cfif listfindnocase("#event.mobilite1#","1")> #form.mobilite1#</cfif><cfif listfindnocase("#event.besoins1#","1")> #form.besoins1#</cfif></cfif> #DateFormat(form.entree,"yyyy-mm-dd")# #DateFormat(form.modification,"yyyy-mm-dd")#<cfif len(event.itemligne1)><cfif len(event.periode1)> #Replace(NumberFormat(form.p1_1,"9.99"),".","#SetNumber#","All")#</cfif><cfif len(event.periode2)> #Replace(form.p1_2,".","#SetNumber#","All")#</cfif><cfif len(event.periode3)> #Replace(form.p1_3,".","#SetNumber#","All")#</cfif><cfif len(event.periode4)> #Replace(form.p1_4,".","#SetNumber#","All")#</cfif></cfif><cfif len(event.itemligne2)><cfif len(event.periode1)> #Replace(form.p2_1,".","#SetNumber#","All")#</cfif><cfif len(event.periode2)> #Replace(form.p2_2,".","#SetNumber#","All")#</cfif><cfif len(event.periode3)> #Replace(form.p2_3,".","#SetNumber#","All")#</cfif><cfif len(event.periode4)> #Replace(form.p2_4,".","#SetNumber#","All")#</cfif></cfif><cfif len(event.itemligne3)><cfif len(event.periode1)> #Replace(form.p3_1,".","#SetNumber#","All")#</cfif><cfif len(event.periode2)> #Replace(form.p3_2,".","#SetNumber#","All")#</cfif><cfif len(event.periode3)> #Replace(form.p3_3,".","#SetNumber#","All")#</cfif><cfif len(event.periode4)> #Replace(form.p3_4,".","#SetNumber#","All")#</cfif></cfif><cfif len(event.itemligne4)><cfif len(event.periode1)> #Replace(form.p4_1,".","#SetNumber#","All")#</cfif><cfif len(event.periode2)> #Replace(form.p4_2,".","#SetNumber#","All")#</cfif><cfif len(event.periode3)> #Replace(form.p4_3,".","#SetNumber#","All")#</cfif><cfif len(event.periode4)> #Replace(form.p4_4,".","#SetNumber#","All")#</cfif></cfif><cfif len(event.itemligne5)><cfif len(event.periode1)> #Replace(form.p5_1,".","#SetNumber#","All")#</cfif><cfif len(event.periode2)> #Replace(form.p5_2,".","#SetNumber#","All")#</cfif><cfif len(event.periode3)> #Replace(form.p5_3,".","#SetNumber#","All")#</cfif><cfif len(event.periode4)> #Replace(form.p5_4,".","#SetNumber#","All")#</cfif></cfif><cfif len(event.itemligne6)><cfif len(event.periode1)> #Replace(form.p6_1,".","#SetNumber#","All")#</cfif><cfif len(event.periode2)> #Replace(form.p6_2,".","#SetNumber#","All")#</cfif><cfif len(event.periode3)> #Replace(form.p6_3,".","#SetNumber#","All")#</cfif><cfif len(event.periode4)> #Replace(form.p6_4,".","#SetNumber#","All")#</cfif></cfif><cfif listfindnocase("#event.niveau2#","accreditation")><cfif listfindnocase("#event.niveau2#","accreditation_organisme")> #form.accreditation_organisme#</cfif><cfif len(event.resolution)> #form.resolution#</cfif></cfif><cfif len(event.item1)> #Replace(form.p1,".","#SetNumber#","All")#</cfif><cfif len(event.item2)> #Replace(form.p2,".","#SetNumber#","All")#</cfif><cfif len(event.item3)> #Replace(form.p3,".","#SetNumber#","All")#</cfif><cfif len(event.item4)> #Replace(form.p4,".","#SetNumber#","All")#</cfif><cfif len(event.item5)> #Replace(form.p5,".","#SetNumber#","All")#</cfif><cfif len(event.item6)> #Replace(form.p6,".","#SetNumber#","All")#</cfif><cfif len(event.item7)> #Replace(form.p7,".","#SetNumber#","All")#</cfif><cfif len(event.item8)> #Replace(form.p8,".","#SetNumber#","All")#</cfif><cfif len(event.item9)> #Replace(form.p9,".","#SetNumber#","All")#</cfif><cfif len(event.item10)> #Replace(form.p10,".","#SetNumber#","All")#</cfif> #form.item1name1#<cfif len(form.item1name2)>, #form.item1name2#</cfif><cfif len(form.item1name3)>, #form.item1name3#</cfif><cfif len(form.item1name4)>, #form.item1name4#</cfif> #Replace(form.grandtotal,".","#SetNumber#","All")# #Replace(form.paiement,".","#SetNumber#","All")# <cfif len(form.grandtotal)><cfset vari.grandtotal="#form.grandtotal#"><cfelse><cfset vari.grandtotal="0"></cfif><cfif len(form.paiement)><cfset vari.paiement="#form.paiement#"><cfelse><cfset vari.grandtotal="0"></cfif><cfset attributes.balance=evaluate(#vari.grandtotal# - #vari.paiement#)>#Replace(NumberFormat(attributes.balance,"9.99"),".","#SetNumber#","All")# #DateFormat(form.conf_date,"yyyy-mm-dd")# #form.conf_paiement# #form.confirmation_no# #form.paiement_mode#<cfif listfindnocase("#event.niveau2#","hebergement")> #form.chambre_choix# #form.partage_nom#<cfif listfindnocase("#event.chambre_choix#","M'assigner un participant")> #form.chambre_genre#</cfif><cfif event.chambre_date is "1"><cfif len(event.chambrejour1)> #form.chambrejour1#</cfif><cfif len(event.chambrejour2)> #form.chambrejour2#</cfif><cfif len(event.chambrejour3)> #form.chambrejour3#</cfif><cfif len(event.chambrejour4)> #form.chambrejour4#</cfif><cfif len(event.chambrejour5)> #chambrejour5#</cfif><cfif len(event.chambrejour6)> #form.chambrejour6#</cfif><cfif len(event.chambrejour7)> #form.chambrejour7#</cfif></cfif><cfif listfindnocase("#event.fumeur#","1")> #form.fumeur#</cfif></cfif><cfif listfindnocase("#event.niveau2#","deplacement")> #form.transport# #form.covoiturage# #form.personne1#<cfif len(form.personne2)>, #form.personne2#</cfif><cfif len(form.personne3)>, #form.personne3#</cfif><cfif len(form.personne4)>, #form.personne4#</cfif><cfif listfindnocase("#event.stationnement#","1")> #form.stationnement#</cfif> #form.distance#</cfif><cfif listfindnocase("#event.rembours_demande#","1")> #form.rembours_demande#</cfif><cfif listfindnocase("#event.octroi_subvention#","1")> #form.octroi_subvention#</cfif><cfif listfindnocase("#event.rembours_politique#","1")> #form.rembours_politique#</cfif> #Replace(NumberFormat(form.rembours,"9.99"),".","#SetNumber#","All")# #DateFormat(form.conf_date_rembours,"yyyy-mm-dd")# #form.conf_rembours#<cfif len(event.nourriture1)> #form.nourriture1#</cfif><cfif listfindnocase("#event.niveau2#","restriction")><cfif listfindnocase("#event.repas_restrict1#","1")> #form.repas_restrict1# #form.repas_details1#</cfif><cfif listfindnocase("#event.allergie1#","1")> #form.allergie1# #form.allergie1_details#</cfif><cfif listfindnocase("#event.mobilite1#","1")> #form.mobilite1#</cfif><cfif listfindnocase("#event.besoins1#","1")> #replace (form.besoins1,"#chr(13)##chr(10)#"," ","all")#</cfif></cfif> #replace (form.commentaires,"#chr(13)##chr(10)#"," ","all")# #form.langue_pref# #form.personne_admin#<cfif listfindnocase("#event.niveau2#","autres")> #replace (form.autre_commentaire,"#chr(13)##chr(10)#"," ","all")#</cfif> #replace (form.notes,"#chr(13)##chr(10)#"," ","all")#</cfloop>