<%@ Page Language="C#" Buffer="true" CodeFile="xls00010e78.aspx.cs" Inherits="_xls00010e78" 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 Adresse Code postal Ville Téléphone Email Nombre de personnes vivant au foyer Motif de la demande Date de création Date de modification Login du modificateur <% %> <% ItlEnumerator e31 = new ItlEnumerator("G00010e78_30", null, false); e31.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("dm:form_bac", @"SELECT this.`_oid` AS this FROM dm_form_bac 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_de_bac') 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_motif_de_la_demande.`_oid` AS this_s_motif_de_la_demande, this.nom AS this_p_nom, this.adresse AS this_p_adresse, this.code_postal AS this_p_code_postal, this.ville AS this_p_ville, this.telephone AS this_p_telephone, this.email AS this_p_email, this.personnes AS this_p_personnes, this_s_motif_de_la_demande.label_fr AS this_s_motif_de_la_demande_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_bac 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_motif_de_la_demande On ((this.motif_de_la_demande = this_s_motif_de_la_demande.`_oid`) AND (this_s_motif_de_la_demande.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map(), false, (List) EC.newList(new List()), 5000, null)); ItlEnumerator card = (ItlEnumerator) (e31); 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"))) { %> <% ITL.show((string)card.get("this_p_nom"), "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_telephone"))) { %> <% ITL.show((string)card.get("this_p_telephone"), "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_p_personnes"))) { %> <% ITL.show((string)card.get("this_p_personnes"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_s_motif_de_la_demande_p_label_fr"))) { %> <% ITL.show((string)card.get("this_s_motif_de_la_demande_p_label_fr"), "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 <% %> Nom Adresse Code postal Ville Téléphone Email Nombre de personnes vivant au foyer Motif de la demande Date de création Date de modification Login du modificateur <% %> <% ItlEnumerator e91 = new ItlEnumerator("G00010e78_90", null, false); e91.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("dm:form_bac", @"SELECT this.`_oid` AS this FROM dm_form_bac 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_de_bac') 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_motif_de_la_demande.`_oid` AS this_s_motif_de_la_demande, this.nom AS this_p_nom, this.adresse AS this_p_adresse, this.code_postal AS this_p_code_postal, this.ville AS this_p_ville, this.telephone AS this_p_telephone, this.email AS this_p_email, this.personnes AS this_p_personnes, this_s_motif_de_la_demande.label_fr AS this_s_motif_de_la_demande_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_bac 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_motif_de_la_demande On ((this.motif_de_la_demande = this_s_motif_de_la_demande.`_oid`) AND (this_s_motif_de_la_demande.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map(), false, (List) EC.newList(new List()), 5000, null)); ItlEnumerator card__1 = (ItlEnumerator) (e91); 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"))) { %> <% ITL.show((string)card__1.get("this_p_nom"), "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_telephone"))) { %> <% ITL.show((string)card__1.get("this_p_telephone"), "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_p_personnes"))) { %> <% ITL.show((string)card__1.get("this_p_personnes"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_s_motif_de_la_demande_p_label_fr"))) { %> <% ITL.show((string)card__1.get("this_s_motif_de_la_demande_p_label_fr"), "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(); %>
<% %>
<% } %>