<%@ Page Language="C#" Buffer="true" CodeFile="xls00010cd4.aspx.cs" Inherits="_xls00010cd4" 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é Prénom Nom E-mail Téléphone Adresse Date de départ Date de retour Autorisation d'entrée à l'intérieur de la propriété Nom Prénom Adresse Téléphone Nom Prénom Adresse Téléphone Nom Prénom Adresse Téléphone Observations Le jardin de la propriété est-il accessible ? Autorisation validation Date de création Date de modification Login du modificateur <% %> <% ItlEnumerator e65 = new ItlEnumerator("G00010cd4_64", null, false); e65.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("dm:form_OTV", @"SELECT this.`_oid` AS this FROM dm_form_OTV 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 = 'otv') 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_civility.`_oid` AS this_s_civility, this.prenon_demandeur AS this_p_prenon_demandeur, this.nom_demandeur AS this_p_nom_demandeur, this.email_demandeur AS this_p_email_demandeur, this.telephone_demandeur AS this_p_telephone_demandeur, this.adresse_demandeur AS this_p_adresse_demandeur, this.date_depart AS this_p_date_depart, this.date_retour AS this_p_date_retour, this.entree_propriete AS this_p_entree_propriete, this.nom_autorise AS this_p_nom_autorise, this.prenom_autorise AS this_p_prenom_autorise, this.adresse_autorise AS this_p_adresse_autorise, this.telephone_autorise AS this_p_telephone_autorise, this.nom_prevenu AS this_p_nom_prevenu, this.prenom_prevenu AS this_p_prenom_prevenu, this.adresse_prevenu AS this_p_adresse_prevenu, this.telephone_prevenu AS this_p_telephone_prevenu, this.nom_contact AS this_p_nom_contact, this.prenom_contact AS this_p_prenom_contact, this.adresse_contact AS this_p_adresse_contact, this.telephone_contact AS this_p_telephone_contact, this.observations AS this_p_observations, this.accessibilite_jardin AS this_p_accessibilite_jardin, this.autorisation AS this_p_autorisation, this.validation AS this_p_validation, this_s_civility.label_fr AS this_s_civility_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_OTV 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_civility On ((this.civility = this_s_civility.`_oid`) AND (this_s_civility.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map(), false, (List) EC.newList(new List()), 5000, null)); ItlEnumerator card = (ItlEnumerator) (e65); 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_civility_p_label_fr"))) { %> <% ITL.show((string)card.get("this_s_civility_p_label_fr"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_prenon_demandeur"))) { %> <% ITL.show((string)card.get("this_p_prenon_demandeur"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_nom_demandeur"))) { %> <% ITL.show((string)card.get("this_p_nom_demandeur"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_email_demandeur"))) { %> <% ITL.show((string)card.get("this_p_email_demandeur"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_telephone_demandeur"))) { %> <% ITL.show((string)card.get("this_p_telephone_demandeur"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_adresse_demandeur"))) { %> <% ITL.show((string)card.get("this_p_adresse_demandeur"), "string", "memo", "string"); %> <% } %> > <% if(ITL.isNotNull((DateTime?)card.get("this_p_date_depart"))) { %> ><% ITL.show(EC.itl.format(ITL.D((DateTime?)card.get("this_p_date_depart")), "xlsDate", null, "date"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((DateTime?)card.get("this_p_date_retour"))) { %> ><% ITL.show(EC.itl.format(ITL.D((DateTime?)card.get("this_p_date_retour")), "xlsDate", null, "date"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_entree_propriete"))) { %> <% ITL.show((string)card.get("this_p_entree_propriete"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_nom_autorise"))) { %> <% ITL.show((string)card.get("this_p_nom_autorise"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_prenom_autorise"))) { %> <% ITL.show((string)card.get("this_p_prenom_autorise"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_adresse_autorise"))) { %> <% ITL.show((string)card.get("this_p_adresse_autorise"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_telephone_autorise"))) { %> <% ITL.show((string)card.get("this_p_telephone_autorise"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_nom_prevenu"))) { %> <% ITL.show((string)card.get("this_p_nom_prevenu"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_prenom_prevenu"))) { %> <% ITL.show((string)card.get("this_p_prenom_prevenu"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_adresse_prevenu"))) { %> <% ITL.show((string)card.get("this_p_adresse_prevenu"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_telephone_prevenu"))) { %> <% ITL.show((string)card.get("this_p_telephone_prevenu"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_nom_contact"))) { %> <% ITL.show((string)card.get("this_p_nom_contact"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_prenom_contact"))) { %> <% ITL.show((string)card.get("this_p_prenom_contact"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_adresse_contact"))) { %> <% ITL.show((string)card.get("this_p_adresse_contact"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_telephone_contact"))) { %> <% ITL.show((string)card.get("this_p_telephone_contact"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_observations"))) { %> <% ITL.show((string)card.get("this_p_observations"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_accessibilite_jardin"))) { %> <% ITL.show((string)card.get("this_p_accessibilite_jardin"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card.get("this_p_autorisation"))) { %> <% ITL.show((string)card.get("this_p_autorisation"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((bool?)card.get("this_p_validation"))) { %> ><% ITL.show(ITL.b((bool?)card.get("this_p_validation"))?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 <% %> Civilité Prénom Nom E-mail Téléphone Adresse Date de départ Date de retour Autorisation d'entrée à l'intérieur de la propriété Nom Prénom Adresse Téléphone Nom Prénom Adresse Téléphone Nom Prénom Adresse Téléphone Observations Le jardin de la propriété est-il accessible ? Autorisation validation Date de création Date de modification Login du modificateur <% %> <% ItlEnumerator e193 = new ItlEnumerator("G00010cd4_192", null, false); e193.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("dm:form_OTV", @"SELECT this.`_oid` AS this FROM dm_form_OTV 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 = 'otv') 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_civility.`_oid` AS this_s_civility, this.prenon_demandeur AS this_p_prenon_demandeur, this.nom_demandeur AS this_p_nom_demandeur, this.email_demandeur AS this_p_email_demandeur, this.telephone_demandeur AS this_p_telephone_demandeur, this.adresse_demandeur AS this_p_adresse_demandeur, this.date_depart AS this_p_date_depart, this.date_retour AS this_p_date_retour, this.entree_propriete AS this_p_entree_propriete, this.nom_autorise AS this_p_nom_autorise, this.prenom_autorise AS this_p_prenom_autorise, this.adresse_autorise AS this_p_adresse_autorise, this.telephone_autorise AS this_p_telephone_autorise, this.nom_prevenu AS this_p_nom_prevenu, this.prenom_prevenu AS this_p_prenom_prevenu, this.adresse_prevenu AS this_p_adresse_prevenu, this.telephone_prevenu AS this_p_telephone_prevenu, this.nom_contact AS this_p_nom_contact, this.prenom_contact AS this_p_prenom_contact, this.adresse_contact AS this_p_adresse_contact, this.telephone_contact AS this_p_telephone_contact, this.observations AS this_p_observations, this.accessibilite_jardin AS this_p_accessibilite_jardin, this.autorisation AS this_p_autorisation, this.validation AS this_p_validation, this_s_civility.label_fr AS this_s_civility_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_OTV 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_civility On ((this.civility = this_s_civility.`_oid`) AND (this_s_civility.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map(), false, (List) EC.newList(new List()), 5000, null)); ItlEnumerator card__1 = (ItlEnumerator) (e193); 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_civility_p_label_fr"))) { %> <% ITL.show((string)card__1.get("this_s_civility_p_label_fr"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_prenon_demandeur"))) { %> <% ITL.show((string)card__1.get("this_p_prenon_demandeur"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_nom_demandeur"))) { %> <% ITL.show((string)card__1.get("this_p_nom_demandeur"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_email_demandeur"))) { %> <% ITL.show((string)card__1.get("this_p_email_demandeur"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_telephone_demandeur"))) { %> <% ITL.show((string)card__1.get("this_p_telephone_demandeur"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_adresse_demandeur"))) { %> <% ITL.show((string)card__1.get("this_p_adresse_demandeur"), "string", "memo", "string"); %> <% } %> > <% if(ITL.isNotNull((DateTime?)card__1.get("this_p_date_depart"))) { %> ><% ITL.show(EC.itl.format(ITL.D((DateTime?)card__1.get("this_p_date_depart")), "xlsDate", null, "date"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((DateTime?)card__1.get("this_p_date_retour"))) { %> ><% ITL.show(EC.itl.format(ITL.D((DateTime?)card__1.get("this_p_date_retour")), "xlsDate", null, "date"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_entree_propriete"))) { %> <% ITL.show((string)card__1.get("this_p_entree_propriete"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_nom_autorise"))) { %> <% ITL.show((string)card__1.get("this_p_nom_autorise"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_prenom_autorise"))) { %> <% ITL.show((string)card__1.get("this_p_prenom_autorise"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_adresse_autorise"))) { %> <% ITL.show((string)card__1.get("this_p_adresse_autorise"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_telephone_autorise"))) { %> <% ITL.show((string)card__1.get("this_p_telephone_autorise"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_nom_prevenu"))) { %> <% ITL.show((string)card__1.get("this_p_nom_prevenu"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_prenom_prevenu"))) { %> <% ITL.show((string)card__1.get("this_p_prenom_prevenu"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_adresse_prevenu"))) { %> <% ITL.show((string)card__1.get("this_p_adresse_prevenu"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_telephone_prevenu"))) { %> <% ITL.show((string)card__1.get("this_p_telephone_prevenu"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_nom_contact"))) { %> <% ITL.show((string)card__1.get("this_p_nom_contact"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_prenom_contact"))) { %> <% ITL.show((string)card__1.get("this_p_prenom_contact"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_adresse_contact"))) { %> <% ITL.show((string)card__1.get("this_p_adresse_contact"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_telephone_contact"))) { %> <% ITL.show((string)card__1.get("this_p_telephone_contact"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_observations"))) { %> <% ITL.show((string)card__1.get("this_p_observations"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_accessibilite_jardin"))) { %> <% ITL.show((string)card__1.get("this_p_accessibilite_jardin"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_autorisation"))) { %> <% ITL.show((string)card__1.get("this_p_autorisation"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((bool?)card__1.get("this_p_validation"))) { %> ><% ITL.show(ITL.b((bool?)card__1.get("this_p_validation"))?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(); %>
<% %>
<% } %>