<%@ Page Language="C#" Buffer="true" CodeFile="xls00010cd1.aspx.cs" Inherits="_xls00010cd1" 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 <% %> Nom de l'enfant Prénom de l'enfant Adresse des parents Date de naissance de l'enfant Classe de l'enfant Photo d'identité Régime-Allergies Lundi Mardi Mercredi Jeudi Vendredi Date de création Date de modification Login du modificateur <% %> <% ItlEnumerator e39 = new ItlEnumerator("G00010cd1_38", null, false); e39.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("dm:form_cantine", @"SELECT this.`_oid` AS this FROM dm_form_cantine 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 = 'demande_d_inscription_a_la_cantine') 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_classe_de_l_enfant.`_oid` AS this_s_classe_de_l_enfant, this_s_photo_d_identite.`_oid` AS this_s_photo_d_identite, this.nom_de_l_enfant AS this_p_nom_de_l_enfant, this.prenom_de_l_enfant AS this_p_prenom_de_l_enfant, this.adresse_des_parents AS this_p_adresse_des_parents, this.date_de_naissance_de_l_enfant AS this_p_date_de_naissance_de_l_enfant, this.regime_allergies AS this_p_regime_allergies, this.lundi AS this_p_lundi, this.mardi AS this_p_mardi, this.mercredi AS this_p_mercredi, this.jeudi AS this_p_jeudi, this.vendredi AS this_p_vendredi, this_s_classe_de_l_enfant.label_fr AS this_s_classe_de_l_enfant_p_label_fr, this_s_photo_d_identite_z.filename AS this_s_photo_d_identite_z_p_filename, this_s_photo_d_identite_z.extension AS this_s_photo_d_identite_z_p_extension, 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_cantine 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_classe_de_l_enfant On ((this.classe_de_l_enfant = this_s_classe_de_l_enfant.`_oid`) AND (this_s_classe_de_l_enfant.iso_sid <> '')) LEFT JOIN (alb_private_image AS this_s_photo_d_identite INNER JOIN alb_private_resource AS this_s_photo_d_identite_z On ((this_s_photo_d_identite.`_oid` = this_s_photo_d_identite_z.`_oid`) AND (this_s_photo_d_identite_z.iso_sid <> ''))) On ((this.photo_d_identite = this_s_photo_d_identite.`_oid`) AND (this_s_photo_d_identite.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map(), false, (List) EC.newList(new List()), 5000, null)); ItlEnumerator card = (ItlEnumerator) (e39); 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_p_nom_de_l_enfant"))) { %> <% ITL.show((string)card.get("this_p_nom_de_l_enfant"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_prenom_de_l_enfant"))) { %> <% ITL.show((string)card.get("this_p_prenom_de_l_enfant"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_adresse_des_parents"))) { %> <% ITL.show((string)card.get("this_p_adresse_des_parents"), "string", "memo", "string"); %> <% } %> > <% if(ITL.isNotNull((DateTime?)card.get("this_p_date_de_naissance_de_l_enfant"))) { %> ><% ITL.show(EC.itl.format(ITL.D((DateTime?)card.get("this_p_date_de_naissance_de_l_enfant")), "xlsDate", null, "date"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_s_classe_de_l_enfant_p_label_fr"))) { %> <% ITL.show((string)card.get("this_s_classe_de_l_enfant_p_label_fr"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((ITL.S((string)card.get("this_s_photo_d_identite_z_p_filename")) + " " + ITL.S((string)card.get("this_s_photo_d_identite_z_p_extension"))))) { %> <% ITL.show(ITL.S((string)card.get("this_s_photo_d_identite_z_p_filename")) + " " + ITL.S((string)card.get("this_s_photo_d_identite_z_p_extension")), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_regime_allergies"))) { %> <% ITL.show((string)card.get("this_p_regime_allergies"), "string", "memo", "string"); %> <% } %> > <% if(ITL.isNotNull((bool?)card.get("this_p_lundi"))) { %> ><% ITL.show(ITL.b((bool?)card.get("this_p_lundi"))?1:0, "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((bool?)card.get("this_p_mardi"))) { %> ><% ITL.show(ITL.b((bool?)card.get("this_p_mardi"))?1:0, "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((bool?)card.get("this_p_mercredi"))) { %> ><% ITL.show(ITL.b((bool?)card.get("this_p_mercredi"))?1:0, "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((bool?)card.get("this_p_jeudi"))) { %> ><% ITL.show(ITL.b((bool?)card.get("this_p_jeudi"))?1:0, "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((bool?)card.get("this_p_vendredi"))) { %> ><% ITL.show(ITL.b((bool?)card.get("this_p_vendredi"))?1:0, "string", "html", "integer"); %> <% } %> > <% 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 <% %> Nom de l'enfant Prénom de l'enfant Adresse des parents Date de naissance de l'enfant Classe de l'enfant Photo d'identité Régime-Allergies Lundi Mardi Mercredi Jeudi Vendredi Date de création Date de modification Login du modificateur <% %> <% ItlEnumerator e115 = new ItlEnumerator("G00010cd1_114", null, false); e115.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("dm:form_cantine", @"SELECT this.`_oid` AS this FROM dm_form_cantine 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 = 'demande_d_inscription_a_la_cantine') 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_classe_de_l_enfant.`_oid` AS this_s_classe_de_l_enfant, this_s_photo_d_identite.`_oid` AS this_s_photo_d_identite, this.nom_de_l_enfant AS this_p_nom_de_l_enfant, this.prenom_de_l_enfant AS this_p_prenom_de_l_enfant, this.adresse_des_parents AS this_p_adresse_des_parents, this.date_de_naissance_de_l_enfant AS this_p_date_de_naissance_de_l_enfant, this.regime_allergies AS this_p_regime_allergies, this.lundi AS this_p_lundi, this.mardi AS this_p_mardi, this.mercredi AS this_p_mercredi, this.jeudi AS this_p_jeudi, this.vendredi AS this_p_vendredi, this_s_classe_de_l_enfant.label_fr AS this_s_classe_de_l_enfant_p_label_fr, this_s_photo_d_identite_z.filename AS this_s_photo_d_identite_z_p_filename, this_s_photo_d_identite_z.extension AS this_s_photo_d_identite_z_p_extension, 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_cantine 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_classe_de_l_enfant On ((this.classe_de_l_enfant = this_s_classe_de_l_enfant.`_oid`) AND (this_s_classe_de_l_enfant.iso_sid <> '')) LEFT JOIN (alb_private_image AS this_s_photo_d_identite INNER JOIN alb_private_resource AS this_s_photo_d_identite_z On ((this_s_photo_d_identite.`_oid` = this_s_photo_d_identite_z.`_oid`) AND (this_s_photo_d_identite_z.iso_sid <> ''))) On ((this.photo_d_identite = this_s_photo_d_identite.`_oid`) AND (this_s_photo_d_identite.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map(), false, (List) EC.newList(new List()), 5000, null)); ItlEnumerator card__1 = (ItlEnumerator) (e115); 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_p_nom_de_l_enfant"))) { %> <% ITL.show((string)card__1.get("this_p_nom_de_l_enfant"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_prenom_de_l_enfant"))) { %> <% ITL.show((string)card__1.get("this_p_prenom_de_l_enfant"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_adresse_des_parents"))) { %> <% ITL.show((string)card__1.get("this_p_adresse_des_parents"), "string", "memo", "string"); %> <% } %> > <% if(ITL.isNotNull((DateTime?)card__1.get("this_p_date_de_naissance_de_l_enfant"))) { %> ><% ITL.show(EC.itl.format(ITL.D((DateTime?)card__1.get("this_p_date_de_naissance_de_l_enfant")), "xlsDate", null, "date"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_s_classe_de_l_enfant_p_label_fr"))) { %> <% ITL.show((string)card__1.get("this_s_classe_de_l_enfant_p_label_fr"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((ITL.S((string)card__1.get("this_s_photo_d_identite_z_p_filename")) + " " + ITL.S((string)card__1.get("this_s_photo_d_identite_z_p_extension"))))) { %> <% ITL.show(ITL.S((string)card__1.get("this_s_photo_d_identite_z_p_filename")) + " " + ITL.S((string)card__1.get("this_s_photo_d_identite_z_p_extension")), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_regime_allergies"))) { %> <% ITL.show((string)card__1.get("this_p_regime_allergies"), "string", "memo", "string"); %> <% } %> > <% if(ITL.isNotNull((bool?)card__1.get("this_p_lundi"))) { %> ><% ITL.show(ITL.b((bool?)card__1.get("this_p_lundi"))?1:0, "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((bool?)card__1.get("this_p_mardi"))) { %> ><% ITL.show(ITL.b((bool?)card__1.get("this_p_mardi"))?1:0, "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((bool?)card__1.get("this_p_mercredi"))) { %> ><% ITL.show(ITL.b((bool?)card__1.get("this_p_mercredi"))?1:0, "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((bool?)card__1.get("this_p_jeudi"))) { %> ><% ITL.show(ITL.b((bool?)card__1.get("this_p_jeudi"))?1:0, "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((bool?)card__1.get("this_p_vendredi"))) { %> ><% ITL.show(ITL.b((bool?)card__1.get("this_p_vendredi"))?1:0, "string", "html", "integer"); %> <% } %> > <% 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(); %>
<% %> <% } %>