<%@ Page Language="C#" Buffer="true" CodeFile="xls00010db5.aspx.cs" Inherits="_xls00010db5" CodePage="1252" UICulture="fr" Culture="fr-FR" ValidateRequest="true" %> <%@ Import Namespace="ItlRuntime" %> <%@ Import Namespace="System.Collections.Generic" %> <%@ Import Namespace="System.Linq" %> <% EC.linkableClassMap = (Map) EC.newMap(new Map() , "ocsNewsEvent:news", new ClassLink("./page00013329.aspx?card=object", "linkTable.aspx?GID=00013329&card=object", "Actualité")); %><% string oids = (string) ((string)EC.itl.getParameterValue("string", "oids")); int? currentStatus = (int?) ((int?)EC.itl.getParameterValue("integer", "currentStatus")); if(oids == "all") { string init = (string) (EC.itl.sdsInitXlsWorksheetNames()); ITL.show(EC.itl.addHeader("Content-Disposition", ("attachment; filename=formulaire" + ".xls")) + EC.itl.addHeader("Content-Type", "application/vnd.ms-excel"), "string", "raw", "string"); EC.Page.Response.ContentEncoding = System.Text.Encoding.UTF8; ITL.show((((((ITL.b(EC.itl.now())?"":"") + "\n\n", "string", "raw", "string"); %> > <% %> <% %> État <% %> Civilité Nom Prénom Email Vous êtes téléphone Adresse Code postal Ville Remarques Prénom de l'enfant Nom de l'enfant Date de naissance Sexe Détails Informations complémentaires presence dejeuner regime Date de création Date de modification Login du modificateur <% %> <% ItlEnumerator e53 = new ItlEnumerator("G00010db5_52", null, false); e53.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("dm:form_clsh", @"SELECT this.`_oid` AS this FROM dm_form_clsh AS this INNER JOIN (sf_form AS this_z LEFT JOIN sf_catalog AS this_z_s_sfCatalog On ((this_z.sfCatalog = this_z_s_sfCatalog.`_oid`) AND (this_z_s_sfCatalog.iso_sid <> ''))) On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this_z_s_sfCatalog.name = 'inscription_au_centre_de_loisrs') AND (#V_0&; OR (this_z.sfStatus = #V_1&;))", new ItlRuntime.SQL.Parameters( new ItlRuntime.SQL.Parameter("#V_0&;", (currentStatus == -1), "boolean"), new ItlRuntime.SQL.Parameter("#V_1&;", currentStatus, "integer")), new ItlRuntime.SQL.OrderAliases(), new ItlRuntime.SQL.OptionalOrderAliases(), null, null), @"SELECT this.`_oid` AS this, this_s_civilite.`_oid` AS this_s_civilite, this_s_demandeur.`_oid` AS this_s_demandeur, this.nom AS this_p_nom, this.prenom AS this_p_prenom, this.email AS this_p_email, this.telephone AS this_p_telephone, this.adresse AS this_p_adresse, this.code_postal AS this_p_code_postal, this.ville AS this_p_ville, this.remarques AS this_p_remarques, this.prenom_enfant AS this_p_prenom_enfant, this.nom_enfant AS this_p_nom_enfant, this.date_naissance AS this_p_date_naissance, this.sexe AS this_p_sexe, this.details AS this_p_details, this.informations_complementaires AS this_p_informations_complementaires, this.presence AS this_p_presence, this.dejeuner AS this_p_dejeuner, this.regime AS this_p_regime, this_s_civilite.label_fr AS this_s_civilite_p_label_fr, this_s_demandeur.label_fr AS this_s_demandeur_p_label_fr, this_z.sfCreationDate AS this_z_p_sfCreationDate, this_z.sfModificationDate AS this_z_p_sfModificationDate, this_z.sfModifierLogin AS this_z_p_sfModifierLogin, this_z.sfStatus AS this_z_p_sfStatus FROM dm_form_clsh AS this INNER JOIN sf_form AS this_z On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_civilite On ((this.civilite = this_s_civilite.`_oid`) AND (this_s_civilite.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_demandeur On ((this.demandeur = this_s_demandeur.`_oid`) AND (this_s_demandeur.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map(), false, (List) EC.newList(new List()), 5000, null)); ItlEnumerator card = (ItlEnumerator) (e53); card.reset(); if(card.isNotEmpty()) { card.resetGroup(); for(card.start();card.test();card.fetch()) { ItlEnumerator row = (ItlEnumerator) (card); if(row.position() % 10 == 9) { EC.Page.Response.Flush(); Response.BufferOutput = false; } %> <% if(ITL.isNotNull(((int?)card.get("this_z_p_sfStatus") == 0?"Entrant":((int?)card.get("this_z_p_sfStatus") == 1?"En attente":((int?)card.get("this_z_p_sfStatus") == 2?"Accepté":"Rejeté")))) && ((int?)card.get("this_z_p_sfStatus") == 0?"Entrant":((int?)card.get("this_z_p_sfStatus") == 1?"En attente":((int?)card.get("this_z_p_sfStatus") == 2?"Accepté":"Rejeté"))) != "") { %> <% ITL.show((int?)card.get("this_z_p_sfStatus") == 0?"Entrant":((int?)card.get("this_z_p_sfStatus") == 1?"En attente":((int?)card.get("this_z_p_sfStatus") == 2?"Accepté":"Rejeté")), "string", "html", "string"); %> <% } %> <% %> <% if(ITL.isNotNull((string)card.get("this_s_civilite_p_label_fr"))) { %> <% ITL.show((string)card.get("this_s_civilite_p_label_fr"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_nom"))) { %> <% ITL.show((string)card.get("this_p_nom"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_prenom"))) { %> <% ITL.show((string)card.get("this_p_prenom"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_email"))) { %> <% ITL.show((string)card.get("this_p_email"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_s_demandeur_p_label_fr"))) { %> <% ITL.show((string)card.get("this_s_demandeur_p_label_fr"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_telephone"))) { %> <% ITL.show((string)card.get("this_p_telephone"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_adresse"))) { %> <% ITL.show((string)card.get("this_p_adresse"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_code_postal"))) { %> <% ITL.show((string)card.get("this_p_code_postal"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_ville"))) { %> <% ITL.show((string)card.get("this_p_ville"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_remarques"))) { %> <% ITL.show((string)card.get("this_p_remarques"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_prenom_enfant"))) { %> <% ITL.show((string)card.get("this_p_prenom_enfant"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_nom_enfant"))) { %> <% ITL.show((string)card.get("this_p_nom_enfant"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((DateTime?)card.get("this_p_date_naissance"))) { %> ><% ITL.show(EC.itl.format(ITL.D((DateTime?)card.get("this_p_date_naissance")), "xlsDate", null, "date"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_sexe"))) { %> <% ITL.show((string)card.get("this_p_sexe"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_details"))) { %> <% ITL.show((string)card.get("this_p_details"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_informations_complementaires"))) { %> <% ITL.show((string)card.get("this_p_informations_complementaires"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_presence"))) { %> <% ITL.show((string)card.get("this_p_presence"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_dejeuner"))) { %> <% ITL.show((string)card.get("this_p_dejeuner"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_regime"))) { %> <% ITL.show((string)card.get("this_p_regime"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((DateTime?)card.get("this_z_p_sfCreationDate"))) { %> ><% ITL.show(EC.itl.format(ITL.D((DateTime?)card.get("this_z_p_sfCreationDate")), "xlsDate", null, "date"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((DateTime?)card.get("this_z_p_sfModificationDate"))) { %> ><% ITL.show(EC.itl.format(ITL.D((DateTime?)card.get("this_z_p_sfModificationDate")), "xlsDate", null, "date"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_z_p_sfModifierLogin"))) { %> <% ITL.show((string)card.get("this_z_p_sfModifierLogin"), "string", "html", "string"); %> <% } %> <% %> <% } } card.finish(); %>
<% %>
<% } else { string init__1 = (string) (EC.itl.sdsInitXlsWorksheetNames()); ITL.show(EC.itl.addHeader("Content-Disposition", ("attachment; filename=formulaire" + ".xls")) + EC.itl.addHeader("Content-Type", "application/vnd.ms-excel"), "string", "raw", "string"); EC.Page.Response.ContentEncoding = System.Text.Encoding.UTF8; ITL.show((((((ITL.b(EC.itl.now())?"":"") + "\n\n", "string", "raw", "string"); %> > <% %> <% %> État <% %> Civilité Nom Prénom Email Vous êtes téléphone Adresse Code postal Ville Remarques Prénom de l'enfant Nom de l'enfant Date de naissance Sexe Détails Informations complémentaires presence dejeuner regime Date de création Date de modification Login du modificateur <% %> <% ItlEnumerator e157 = new ItlEnumerator("G00010db5_156", null, false); e157.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("dm:form_clsh", @"SELECT this.`_oid` AS this FROM dm_form_clsh AS this INNER JOIN (sf_form AS this_z LEFT JOIN sf_catalog AS this_z_s_sfCatalog On ((this_z.sfCatalog = this_z_s_sfCatalog.`_oid`) AND (this_z_s_sfCatalog.iso_sid <> ''))) On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this_z_s_sfCatalog.name = 'inscription_au_centre_de_loisrs') AND (this.`_oid` IN (#V_0&;))", new ItlRuntime.SQL.Parameters( new ItlRuntime.SQL.Parameter("#V_0&;", ITL.S(oids), "oids")), new ItlRuntime.SQL.OrderAliases(), new ItlRuntime.SQL.OptionalOrderAliases(), null, null), @"SELECT this.`_oid` AS this, this_s_civilite.`_oid` AS this_s_civilite, this_s_demandeur.`_oid` AS this_s_demandeur, this.nom AS this_p_nom, this.prenom AS this_p_prenom, this.email AS this_p_email, this.telephone AS this_p_telephone, this.adresse AS this_p_adresse, this.code_postal AS this_p_code_postal, this.ville AS this_p_ville, this.remarques AS this_p_remarques, this.prenom_enfant AS this_p_prenom_enfant, this.nom_enfant AS this_p_nom_enfant, this.date_naissance AS this_p_date_naissance, this.sexe AS this_p_sexe, this.details AS this_p_details, this.informations_complementaires AS this_p_informations_complementaires, this.presence AS this_p_presence, this.dejeuner AS this_p_dejeuner, this.regime AS this_p_regime, this_s_civilite.label_fr AS this_s_civilite_p_label_fr, this_s_demandeur.label_fr AS this_s_demandeur_p_label_fr, this_z.sfCreationDate AS this_z_p_sfCreationDate, this_z.sfModificationDate AS this_z_p_sfModificationDate, this_z.sfModifierLogin AS this_z_p_sfModifierLogin, this_z.sfStatus AS this_z_p_sfStatus FROM dm_form_clsh AS this INNER JOIN sf_form AS this_z On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_civilite On ((this.civilite = this_s_civilite.`_oid`) AND (this_s_civilite.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_demandeur On ((this.demandeur = this_s_demandeur.`_oid`) AND (this_s_demandeur.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map(), false, (List) EC.newList(new List()), 5000, null)); ItlEnumerator card__1 = (ItlEnumerator) (e157); card__1.reset(); if(card__1.isNotEmpty()) { card__1.resetGroup(); for(card__1.start();card__1.test();card__1.fetch()) { ItlEnumerator row__1 = (ItlEnumerator) (card__1); if(row__1.position() % 10 == 9) { EC.Page.Response.Flush(); Response.BufferOutput = false; } %> <% if(ITL.isNotNull(((int?)card__1.get("this_z_p_sfStatus") == 0?"Entrant":((int?)card__1.get("this_z_p_sfStatus") == 1?"En attente":((int?)card__1.get("this_z_p_sfStatus") == 2?"Accepté":"Rejeté")))) && ((int?)card__1.get("this_z_p_sfStatus") == 0?"Entrant":((int?)card__1.get("this_z_p_sfStatus") == 1?"En attente":((int?)card__1.get("this_z_p_sfStatus") == 2?"Accepté":"Rejeté"))) != "") { %> <% ITL.show((int?)card__1.get("this_z_p_sfStatus") == 0?"Entrant":((int?)card__1.get("this_z_p_sfStatus") == 1?"En attente":((int?)card__1.get("this_z_p_sfStatus") == 2?"Accepté":"Rejeté")), "string", "html", "string"); %> <% } %> <% %> <% if(ITL.isNotNull((string)card__1.get("this_s_civilite_p_label_fr"))) { %> <% ITL.show((string)card__1.get("this_s_civilite_p_label_fr"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_nom"))) { %> <% ITL.show((string)card__1.get("this_p_nom"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_prenom"))) { %> <% ITL.show((string)card__1.get("this_p_prenom"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_email"))) { %> <% ITL.show((string)card__1.get("this_p_email"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_s_demandeur_p_label_fr"))) { %> <% ITL.show((string)card__1.get("this_s_demandeur_p_label_fr"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_telephone"))) { %> <% ITL.show((string)card__1.get("this_p_telephone"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_adresse"))) { %> <% ITL.show((string)card__1.get("this_p_adresse"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_code_postal"))) { %> <% ITL.show((string)card__1.get("this_p_code_postal"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_ville"))) { %> <% ITL.show((string)card__1.get("this_p_ville"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_remarques"))) { %> <% ITL.show((string)card__1.get("this_p_remarques"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_prenom_enfant"))) { %> <% ITL.show((string)card__1.get("this_p_prenom_enfant"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_nom_enfant"))) { %> <% ITL.show((string)card__1.get("this_p_nom_enfant"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((DateTime?)card__1.get("this_p_date_naissance"))) { %> ><% ITL.show(EC.itl.format(ITL.D((DateTime?)card__1.get("this_p_date_naissance")), "xlsDate", null, "date"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_sexe"))) { %> <% ITL.show((string)card__1.get("this_p_sexe"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_details"))) { %> <% ITL.show((string)card__1.get("this_p_details"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_informations_complementaires"))) { %> <% ITL.show((string)card__1.get("this_p_informations_complementaires"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_presence"))) { %> <% ITL.show((string)card__1.get("this_p_presence"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_dejeuner"))) { %> <% ITL.show((string)card__1.get("this_p_dejeuner"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_regime"))) { %> <% ITL.show((string)card__1.get("this_p_regime"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((DateTime?)card__1.get("this_z_p_sfCreationDate"))) { %> ><% ITL.show(EC.itl.format(ITL.D((DateTime?)card__1.get("this_z_p_sfCreationDate")), "xlsDate", null, "date"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((DateTime?)card__1.get("this_z_p_sfModificationDate"))) { %> ><% ITL.show(EC.itl.format(ITL.D((DateTime?)card__1.get("this_z_p_sfModificationDate")), "xlsDate", null, "date"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_z_p_sfModifierLogin"))) { %> <% ITL.show((string)card__1.get("this_z_p_sfModifierLogin"), "string", "html", "string"); %> <% } %> <% %> <% } } card__1.finish(); %>
<% %>
<% } %>