<%@ Page Language="C#" Buffer="true" CodeFile="xls00011382.aspx.cs" Inherits="_xls00011382" 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 mode = (string) ((string)EC.itl.getParameterValue("string", "mode", "list")); string action = (string) ((string)EC.itl.getParameterValue("string", "action", "")); int? statusFilter = (int?) ((int?)EC.itl.getParameterValue("integer", "statusFilter", -1)); string searchFilter = (string) ((string)EC.itl.getParameterValue("string", "searchFilter")); string logComment = (string) ((string)EC.itl.getParameterValue("string", "logComment")); string creatorFilter = (string) ((string)EC.itl.getParameterValue("string", "creatorFilter")); string ocsNotificationForActionMessage = (string) ((string)EC.itl.getParameterValue("string", "ocsNotificationForActionMessage")); string ocsNotificationForInfoMessage = (string) ((string)EC.itl.getParameterValue("string", "ocsNotificationForInfoMessage")); SqlObject card = (SqlObject) (new SqlObject("ocsTrm:accomodation", @"SELECT this.`_oid` AS this FROM ocsTrm_accomodation AS this INNER JOIN ocs_card AS this_z On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.`_oid` = #V_0&;)", new Map("#V_0&;|integer", EC.itl.toInteger(EC.itl.getParameterValue("object:ocsTrm:accomodation", "card"))),true)); %><% string oids = (string) ((string)EC.itl.getParameterValue("string", "oids")); if(oids == "all") { SqlObject catalogObject = (SqlObject) (new SqlObject("ocs:catalog", @"SELECT this.`_oid` AS this, this.useValidation AS this_p_useValidation FROM ocs_catalog AS this WHERE (this.iso_sid <> '') AND (this.name = 'hebergement')", new Map(),false)); bool useValidation = (bool) (ITL.b((bool?)catalogObject.get("this_p_useValidation"))); bool hasNewCardRight = (bool) (EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c0.`_oid` AS origin, this.label_fr AS this_p_label_fr, this.`_oid` AS this, this.`_oid` AS data FROM xrm_category AS this INNER JOIN (ocs_catalog AS c0 INNER JOIN ocs_catalog_redactionRights AS c0_l On ((c0.`_oid` = c0_l.`_from`) AND (c0.iso_sid <> '') AND (c0.`_oid` = #V_0&;))) On ((this.`_oid` = c0_l.`_to`) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.`_oid` IN (#V_1&;))) AS this", new Map("#V_0&;|integer", (int?)catalogObject.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0); bool? hasValidateRight = (bool?) (ITL.b(useValidation)?EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c0.`_oid` AS origin, this.label_fr AS this_p_label_fr, this.`_oid` AS this, this.`_oid` AS data FROM xrm_category AS this INNER JOIN (ocs_catalog AS c0 INNER JOIN ocs_catalog_validationRights AS c0_l On ((c0.`_oid` = c0_l.`_from`) AND (c0.iso_sid <> '') AND (c0.`_oid` = #V_0&;))) On ((this.`_oid` = c0_l.`_to`) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.`_oid` IN (#V_1&;))) AS this", new Map("#V_0&;|integer", (int?)catalogObject.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0:hasNewCardRight); int? statusFilter__1 = (int?) ((int?)EC.itl.getParameterValue("integer", "statusFilter")); string cardType = (string) ((string)EC.itl.getParameterValue("string", "cardType")); string searchFilter__1 = (string) ((string)EC.itl.getParameterValue("string", "searchFilter")); string creatorFilter__1 = (string) ((string)EC.itl.getParameterValue("string", "creatorFilter")); if(statusFilter__1 == -1) { if(cardType != "archive") { string init = (string) (EC.itl.sdsInitXlsWorksheetNames()); ITL.show(EC.itl.addHeader("Content-Disposition", ("attachment; filename=classeur" + ".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 <% %> Libellé Adresse Qui contacter Téléphone Mobile Télécopie Adresse E-Mail Site Internet Commentaire Distinction Niveau de distinction Illustration En savoir plus Catégorie Mots-clés <% %> <% ItlEnumerator e43 = new ItlEnumerator("G00011382_42", null, false); string _t0 = ITL.S(searchFilter__1); e43.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("ocsTrm:accomodation", @"SELECT this.`_oid` AS this FROM ocsTrm_accomodation AS this INNER JOIN (ocs_card AS this_z LEFT JOIN ocs_catalog AS this_z_s_ocsCatalog On ((this_z.ocsCatalog = this_z_s_ocsCatalog.`_oid`) AND (this_z_s_ocsCatalog.iso_sid <> ''))) On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this_z_s_ocsCatalog.name = 'hebergement') AND (#V_0&; OR (this_z.ocsCreationLogin = #V_1&;)) AND (#V_2&; OR ((this.title LIKE CONCAT('%', #V_3&;, '%')) OR ((this.address LIKE CONCAT('%', #V_3&;, '%')) OR ((this.contact LIKE CONCAT('%', #V_3&;, '%')) OR ((this.phonenumber LIKE CONCAT('%', #V_3&;, '%')) OR ((this.mobilenumber LIKE CONCAT('%', #V_3&;, '%')) OR ((this.fax LIKE CONCAT('%', #V_3&;, '%')) OR ((this.mailaddress LIKE CONCAT('%', #V_3&;, '%')) OR ((this.website LIKE CONCAT('%', #V_3&;, '%')) OR ((this.comment LIKE CONCAT('%', #V_3&;, '%')) OR (this.description LIKE CONCAT('%', #V_3&;, '%')))))))))))) AND (IF((this_z_s_ocsCatalog.useValidation = 1),this_z.ocsStatus,IF(((this_z.ocsStatus = 2) OR (this_z.ocsStatus = 3)),this_z.ocsStatus,0)) <> 3)", new ItlRuntime.SQL.Parameters( new ItlRuntime.SQL.Parameter("#V_0&;", (creatorFilter__1 == ""), "boolean"), new ItlRuntime.SQL.Parameter("#V_1&;", creatorFilter__1, "string"), new ItlRuntime.SQL.Parameter("#V_2&;", (searchFilter__1 == ""), "boolean"), new ItlRuntime.SQL.Parameter("#V_3&;", _t0, "string")), new ItlRuntime.SQL.OrderAliases(), new ItlRuntime.SQL.OptionalOrderAliases(), null, null), @"SELECT this.`_oid` AS this, this_s_awards.`_oid` AS this_s_awards, this_s_image.`_oid` AS this_s_image, this_s_category.`_oid` AS this_s_category, this.title AS this_p_title, this.address AS this_p_address, this.contact AS this_p_contact, this.phonenumber AS this_p_phonenumber, this.mobilenumber AS this_p_mobilenumber, this.fax AS this_p_fax, this.mailaddress AS this_p_mailaddress, this.website AS this_p_website, this.comment AS this_p_comment, this.distinctionLevel AS this_p_distinctionLevel, this.description AS this_p_description, this_s_awards.label_fr AS this_s_awards_p_label_fr, this_s_image_z.filename AS this_s_image_z_p_filename, this_s_image_z.extension AS this_s_image_z_p_extension, this_s_category.label_fr AS this_s_category_p_label_fr, this_z.ocsStatus AS this_z_p_ocsStatus FROM ocsTrm_accomodation AS this INNER JOIN ocs_card AS this_z On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_awards On ((this.awards = this_s_awards.`_oid`) AND (this_s_awards.iso_sid <> '')) LEFT JOIN (alb_image AS this_s_image INNER JOIN alb_resource AS this_s_image_z On ((this_s_image.`_oid` = this_s_image_z.`_oid`) AND (this_s_image_z.iso_sid <> ''))) On ((this.image = this_s_image.`_oid`) AND (this_s_image.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_category On ((this.category = this_s_category.`_oid`) AND (this_s_category.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map(), false, (List) EC.newList(new List()), 5000, null)); ItlEnumerator card__1 = (ItlEnumerator) (e43); card__1.reset(); if(card__1.isNotEmpty()) { card__1.resetGroup(); for(card__1.start();card__1.test();card__1.fetch()) { ItlEnumerator row = (ItlEnumerator) (card__1); if(row.position() % 10 == 9) { EC.Page.Response.Flush(); Response.BufferOutput = false; } %> <% if(ITL.isNotNull(((int?)card__1.get("this_z_p_ocsStatus") == 0?"En rédaction":((int?)card__1.get("this_z_p_ocsStatus") == 1?"A valider":((int?)card__1.get("this_z_p_ocsStatus") == 2?"Publiée":"Archivée")))) && ((int?)card__1.get("this_z_p_ocsStatus") == 0?"En rédaction":((int?)card__1.get("this_z_p_ocsStatus") == 1?"A valider":((int?)card__1.get("this_z_p_ocsStatus") == 2?"Publiée":"Archivée"))) != "") { %> <% ITL.show((int?)card__1.get("this_z_p_ocsStatus") == 0?"En rédaction":((int?)card__1.get("this_z_p_ocsStatus") == 1?"A valider":((int?)card__1.get("this_z_p_ocsStatus") == 2?"Publiée":"Archivée")), "string", "html", "string"); %> <% } %> <% %> <% if(ITL.isNotNull((string)card__1.get("this_p_title"))) { %> <% ITL.show((string)card__1.get("this_p_title"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_address"))) { %> <% ITL.show((string)card__1.get("this_p_address"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_contact"))) { %> <% ITL.show((string)card__1.get("this_p_contact"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_phonenumber"))) { %> <% ITL.show((string)card__1.get("this_p_phonenumber"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_mobilenumber"))) { %> <% ITL.show((string)card__1.get("this_p_mobilenumber"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_fax"))) { %> <% ITL.show((string)card__1.get("this_p_fax"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_mailaddress"))) { %> <% ITL.show((string)card__1.get("this_p_mailaddress"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_website"))) { %> <% ITL.show((string)card__1.get("this_p_website"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_comment"))) { %> <% ITL.show((string)card__1.get("this_p_comment"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_s_awards_p_label_fr"))) { %> <% ITL.show((string)card__1.get("this_s_awards_p_label_fr"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((int?)card__1.get("this_p_distinctionLevel"))) { %> ><% ITL.show((int?)card__1.get("this_p_distinctionLevel"), "string", "html", "integer"); %> <% } %> <% if(ITL.isNotNull((ITL.S((string)card__1.get("this_s_image_z_p_filename")) + " " + ITL.S((string)card__1.get("this_s_image_z_p_extension"))))) { %> <% ITL.show(ITL.S((string)card__1.get("this_s_image_z_p_filename")) + " " + ITL.S((string)card__1.get("this_s_image_z_p_extension")), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_description"))) { %> <% ITL.show((string)card__1.get("this_p_description"), "string", "direct", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_s_category_p_label_fr"))) { %> <% ITL.show((string)card__1.get("this_s_category_p_label_fr"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull(new SqlCollection("kwd:keyword", @"SELECT DISTINCT c0.`_oid` AS origin, this.label AS this_p_label, this.`_oid` AS this FROM kwd_keyword AS this INNER JOIN (ocsTrm_accomodation AS c0 INNER JOIN ocsTrm_accomodation_filter AS c0_l On ((c0.`_oid` = c0_l.`_from`) AND (c0.iso_sid <> '') AND (c0.`_oid` = #V_0&;)) INNER JOIN ocs_card AS c0_z On ((c0.`_oid` = c0_z.`_oid`) AND (c0_z.iso_sid <> ''))) On ((this.`_oid` = c0_l.`_to`) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map("#V_0&;|integer", (int?)card__1.get("this")), (List) EC.newList(new List(), "this_p_label")).labels())) { %> <% ITL.show(new SqlCollection("kwd:keyword", @"SELECT DISTINCT c0.`_oid` AS origin, this.label AS this_p_label, this.`_oid` AS this FROM kwd_keyword AS this INNER JOIN (ocsTrm_accomodation AS c0 INNER JOIN ocsTrm_accomodation_filter AS c0_l On ((c0.`_oid` = c0_l.`_from`) AND (c0.iso_sid <> '') AND (c0.`_oid` = #V_0&;)) INNER JOIN ocs_card AS c0_z On ((c0.`_oid` = c0_z.`_oid`) AND (c0_z.iso_sid <> ''))) On ((this.`_oid` = c0_l.`_to`) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map("#V_0&;|integer", (int?)card__1.get("this")), (List) EC.newList(new List(), "this_p_label")).labels(), "string", "html", "string"); %> <% } %> <% %> <% } } card__1.finish(); %>
<% %> <% } else { string init__1 = (string) (EC.itl.sdsInitXlsWorksheetNames()); ITL.show(EC.itl.addHeader("Content-Disposition", ("attachment; filename=classeur" + ".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 <% %> Libellé Adresse Qui contacter Téléphone Mobile Télécopie Adresse E-Mail Site Internet Commentaire Distinction Niveau de distinction Illustration En savoir plus Catégorie Mots-clés <% %> <% ItlEnumerator e121 = new ItlEnumerator("G00011382_120", null, false); string _t1 = ITL.S(searchFilter__1); e121.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("ocsTrm:accomodation", @"SELECT this.`_oid` AS this FROM ocsTrm_accomodation AS this INNER JOIN (ocs_card AS this_z LEFT JOIN ocs_catalog AS this_z_s_ocsCatalog On ((this_z.ocsCatalog = this_z_s_ocsCatalog.`_oid`) AND (this_z_s_ocsCatalog.iso_sid <> ''))) On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this_z_s_ocsCatalog.name = 'hebergement') AND (#V_0&; OR (this_z.ocsCreationLogin = #V_1&;)) AND (#V_2&; OR ((this.title LIKE CONCAT('%', #V_3&;, '%')) OR ((this.address LIKE CONCAT('%', #V_3&;, '%')) OR ((this.contact LIKE CONCAT('%', #V_3&;, '%')) OR ((this.phonenumber LIKE CONCAT('%', #V_3&;, '%')) OR ((this.mobilenumber LIKE CONCAT('%', #V_3&;, '%')) OR ((this.fax LIKE CONCAT('%', #V_3&;, '%')) OR ((this.mailaddress LIKE CONCAT('%', #V_3&;, '%')) OR ((this.website LIKE CONCAT('%', #V_3&;, '%')) OR ((this.comment LIKE CONCAT('%', #V_3&;, '%')) OR (this.description LIKE CONCAT('%', #V_3&;, '%')))))))))))) AND (IF((this_z_s_ocsCatalog.useValidation = 1),this_z.ocsStatus,IF(((this_z.ocsStatus = 2) OR (this_z.ocsStatus = 3)),this_z.ocsStatus,0)) = 3)", new ItlRuntime.SQL.Parameters( new ItlRuntime.SQL.Parameter("#V_0&;", (creatorFilter__1 == ""), "boolean"), new ItlRuntime.SQL.Parameter("#V_1&;", creatorFilter__1, "string"), new ItlRuntime.SQL.Parameter("#V_2&;", (searchFilter__1 == ""), "boolean"), new ItlRuntime.SQL.Parameter("#V_3&;", _t1, "string")), new ItlRuntime.SQL.OrderAliases(), new ItlRuntime.SQL.OptionalOrderAliases(), null, null), @"SELECT this.`_oid` AS this, this_s_awards.`_oid` AS this_s_awards, this_s_image.`_oid` AS this_s_image, this_s_category.`_oid` AS this_s_category, this.title AS this_p_title, this.address AS this_p_address, this.contact AS this_p_contact, this.phonenumber AS this_p_phonenumber, this.mobilenumber AS this_p_mobilenumber, this.fax AS this_p_fax, this.mailaddress AS this_p_mailaddress, this.website AS this_p_website, this.comment AS this_p_comment, this.distinctionLevel AS this_p_distinctionLevel, this.description AS this_p_description, this_s_awards.label_fr AS this_s_awards_p_label_fr, this_s_image_z.filename AS this_s_image_z_p_filename, this_s_image_z.extension AS this_s_image_z_p_extension, this_s_category.label_fr AS this_s_category_p_label_fr, this_z.ocsStatus AS this_z_p_ocsStatus FROM ocsTrm_accomodation AS this INNER JOIN ocs_card AS this_z On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_awards On ((this.awards = this_s_awards.`_oid`) AND (this_s_awards.iso_sid <> '')) LEFT JOIN (alb_image AS this_s_image INNER JOIN alb_resource AS this_s_image_z On ((this_s_image.`_oid` = this_s_image_z.`_oid`) AND (this_s_image_z.iso_sid <> ''))) On ((this.image = this_s_image.`_oid`) AND (this_s_image.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_category On ((this.category = this_s_category.`_oid`) AND (this_s_category.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map(), false, (List) EC.newList(new List()), 5000, null)); ItlEnumerator card__2 = (ItlEnumerator) (e121); card__2.reset(); if(card__2.isNotEmpty()) { card__2.resetGroup(); for(card__2.start();card__2.test();card__2.fetch()) { ItlEnumerator row__1 = (ItlEnumerator) (card__2); if(row__1.position() % 10 == 9) { EC.Page.Response.Flush(); Response.BufferOutput = false; } %> <% if(ITL.isNotNull(((int?)card__2.get("this_z_p_ocsStatus") == 0?"En rédaction":((int?)card__2.get("this_z_p_ocsStatus") == 1?"A valider":((int?)card__2.get("this_z_p_ocsStatus") == 2?"Publiée":"Archivée")))) && ((int?)card__2.get("this_z_p_ocsStatus") == 0?"En rédaction":((int?)card__2.get("this_z_p_ocsStatus") == 1?"A valider":((int?)card__2.get("this_z_p_ocsStatus") == 2?"Publiée":"Archivée"))) != "") { %> <% ITL.show((int?)card__2.get("this_z_p_ocsStatus") == 0?"En rédaction":((int?)card__2.get("this_z_p_ocsStatus") == 1?"A valider":((int?)card__2.get("this_z_p_ocsStatus") == 2?"Publiée":"Archivée")), "string", "html", "string"); %> <% } %> <% %> <% if(ITL.isNotNull((string)card__2.get("this_p_title"))) { %> <% ITL.show((string)card__2.get("this_p_title"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_address"))) { %> <% ITL.show((string)card__2.get("this_p_address"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_contact"))) { %> <% ITL.show((string)card__2.get("this_p_contact"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_phonenumber"))) { %> <% ITL.show((string)card__2.get("this_p_phonenumber"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_mobilenumber"))) { %> <% ITL.show((string)card__2.get("this_p_mobilenumber"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_fax"))) { %> <% ITL.show((string)card__2.get("this_p_fax"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_mailaddress"))) { %> <% ITL.show((string)card__2.get("this_p_mailaddress"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_website"))) { %> <% ITL.show((string)card__2.get("this_p_website"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_comment"))) { %> <% ITL.show((string)card__2.get("this_p_comment"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_s_awards_p_label_fr"))) { %> <% ITL.show((string)card__2.get("this_s_awards_p_label_fr"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((int?)card__2.get("this_p_distinctionLevel"))) { %> ><% ITL.show((int?)card__2.get("this_p_distinctionLevel"), "string", "html", "integer"); %> <% } %> <% if(ITL.isNotNull((ITL.S((string)card__2.get("this_s_image_z_p_filename")) + " " + ITL.S((string)card__2.get("this_s_image_z_p_extension"))))) { %> <% ITL.show(ITL.S((string)card__2.get("this_s_image_z_p_filename")) + " " + ITL.S((string)card__2.get("this_s_image_z_p_extension")), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_description"))) { %> <% ITL.show((string)card__2.get("this_p_description"), "string", "direct", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_s_category_p_label_fr"))) { %> <% ITL.show((string)card__2.get("this_s_category_p_label_fr"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull(new SqlCollection("kwd:keyword", @"SELECT DISTINCT c0.`_oid` AS origin, this.label AS this_p_label, this.`_oid` AS this FROM kwd_keyword AS this INNER JOIN (ocsTrm_accomodation AS c0 INNER JOIN ocsTrm_accomodation_filter AS c0_l On ((c0.`_oid` = c0_l.`_from`) AND (c0.iso_sid <> '') AND (c0.`_oid` = #V_0&;)) INNER JOIN ocs_card AS c0_z On ((c0.`_oid` = c0_z.`_oid`) AND (c0_z.iso_sid <> ''))) On ((this.`_oid` = c0_l.`_to`) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map("#V_0&;|integer", (int?)card__2.get("this")), (List) EC.newList(new List(), "this_p_label")).labels())) { %> <% ITL.show(new SqlCollection("kwd:keyword", @"SELECT DISTINCT c0.`_oid` AS origin, this.label AS this_p_label, this.`_oid` AS this FROM kwd_keyword AS this INNER JOIN (ocsTrm_accomodation AS c0 INNER JOIN ocsTrm_accomodation_filter AS c0_l On ((c0.`_oid` = c0_l.`_from`) AND (c0.iso_sid <> '') AND (c0.`_oid` = #V_0&;)) INNER JOIN ocs_card AS c0_z On ((c0.`_oid` = c0_z.`_oid`) AND (c0_z.iso_sid <> ''))) On ((this.`_oid` = c0_l.`_to`) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map("#V_0&;|integer", (int?)card__2.get("this")), (List) EC.newList(new List(), "this_p_label")).labels(), "string", "html", "string"); %> <% } %> <% %> <% } } card__2.finish(); %>
<% %> <% } } else { string init__2 = (string) (EC.itl.sdsInitXlsWorksheetNames()); ITL.show(EC.itl.addHeader("Content-Disposition", ("attachment; filename=classeur" + ".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 <% %> Libellé Adresse Qui contacter Téléphone Mobile Télécopie Adresse E-Mail Site Internet Commentaire Distinction Niveau de distinction Illustration En savoir plus Catégorie Mots-clés <% %> <% ItlEnumerator e199 = new ItlEnumerator("G00011382_198", null, false); string _t2 = ITL.S(searchFilter__1); e199.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("ocsTrm:accomodation", @"SELECT this.`_oid` AS this FROM ocsTrm_accomodation AS this INNER JOIN (ocs_card AS this_z LEFT JOIN ocs_catalog AS this_z_s_ocsCatalog On ((this_z.ocsCatalog = this_z_s_ocsCatalog.`_oid`) AND (this_z_s_ocsCatalog.iso_sid <> ''))) On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this_z_s_ocsCatalog.name = 'hebergement') AND (#V_0&; OR (this_z.ocsCreationLogin = #V_1&;)) AND (#V_2&; OR ((this.title LIKE CONCAT('%', #V_3&;, '%')) OR ((this.address LIKE CONCAT('%', #V_3&;, '%')) OR ((this.contact LIKE CONCAT('%', #V_3&;, '%')) OR ((this.phonenumber LIKE CONCAT('%', #V_3&;, '%')) OR ((this.mobilenumber LIKE CONCAT('%', #V_3&;, '%')) OR ((this.fax LIKE CONCAT('%', #V_3&;, '%')) OR ((this.mailaddress LIKE CONCAT('%', #V_3&;, '%')) OR ((this.website LIKE CONCAT('%', #V_3&;, '%')) OR ((this.comment LIKE CONCAT('%', #V_3&;, '%')) OR (this.description LIKE CONCAT('%', #V_3&;, '%')))))))))))) AND (IF((this_z_s_ocsCatalog.useValidation = 1),this_z.ocsStatus,IF(((this_z.ocsStatus = 2) OR (this_z.ocsStatus = 3)),this_z.ocsStatus,0)) = #V_4&;)", new ItlRuntime.SQL.Parameters( new ItlRuntime.SQL.Parameter("#V_0&;", (creatorFilter__1 == ""), "boolean"), new ItlRuntime.SQL.Parameter("#V_1&;", creatorFilter__1, "string"), new ItlRuntime.SQL.Parameter("#V_2&;", (searchFilter__1 == ""), "boolean"), new ItlRuntime.SQL.Parameter("#V_3&;", _t2, "string"), new ItlRuntime.SQL.Parameter("#V_4&;", statusFilter__1, "integer")), new ItlRuntime.SQL.OrderAliases(), new ItlRuntime.SQL.OptionalOrderAliases(), null, null), @"SELECT this.`_oid` AS this, this_s_awards.`_oid` AS this_s_awards, this_s_image.`_oid` AS this_s_image, this_s_category.`_oid` AS this_s_category, this.title AS this_p_title, this.address AS this_p_address, this.contact AS this_p_contact, this.phonenumber AS this_p_phonenumber, this.mobilenumber AS this_p_mobilenumber, this.fax AS this_p_fax, this.mailaddress AS this_p_mailaddress, this.website AS this_p_website, this.comment AS this_p_comment, this.distinctionLevel AS this_p_distinctionLevel, this.description AS this_p_description, this_s_awards.label_fr AS this_s_awards_p_label_fr, this_s_image_z.filename AS this_s_image_z_p_filename, this_s_image_z.extension AS this_s_image_z_p_extension, this_s_category.label_fr AS this_s_category_p_label_fr, this_z.ocsStatus AS this_z_p_ocsStatus FROM ocsTrm_accomodation AS this INNER JOIN ocs_card AS this_z On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_awards On ((this.awards = this_s_awards.`_oid`) AND (this_s_awards.iso_sid <> '')) LEFT JOIN (alb_image AS this_s_image INNER JOIN alb_resource AS this_s_image_z On ((this_s_image.`_oid` = this_s_image_z.`_oid`) AND (this_s_image_z.iso_sid <> ''))) On ((this.image = this_s_image.`_oid`) AND (this_s_image.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_category On ((this.category = this_s_category.`_oid`) AND (this_s_category.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map(), false, (List) EC.newList(new List()), 5000, null)); ItlEnumerator card__3 = (ItlEnumerator) (e199); card__3.reset(); if(card__3.isNotEmpty()) { card__3.resetGroup(); for(card__3.start();card__3.test();card__3.fetch()) { ItlEnumerator row__2 = (ItlEnumerator) (card__3); if(row__2.position() % 10 == 9) { EC.Page.Response.Flush(); Response.BufferOutput = false; } %> <% if(ITL.isNotNull(((int?)card__3.get("this_z_p_ocsStatus") == 0?"En rédaction":((int?)card__3.get("this_z_p_ocsStatus") == 1?"A valider":((int?)card__3.get("this_z_p_ocsStatus") == 2?"Publiée":"Archivée")))) && ((int?)card__3.get("this_z_p_ocsStatus") == 0?"En rédaction":((int?)card__3.get("this_z_p_ocsStatus") == 1?"A valider":((int?)card__3.get("this_z_p_ocsStatus") == 2?"Publiée":"Archivée"))) != "") { %> <% ITL.show((int?)card__3.get("this_z_p_ocsStatus") == 0?"En rédaction":((int?)card__3.get("this_z_p_ocsStatus") == 1?"A valider":((int?)card__3.get("this_z_p_ocsStatus") == 2?"Publiée":"Archivée")), "string", "html", "string"); %> <% } %> <% %> <% if(ITL.isNotNull((string)card__3.get("this_p_title"))) { %> <% ITL.show((string)card__3.get("this_p_title"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_address"))) { %> <% ITL.show((string)card__3.get("this_p_address"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_contact"))) { %> <% ITL.show((string)card__3.get("this_p_contact"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_phonenumber"))) { %> <% ITL.show((string)card__3.get("this_p_phonenumber"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_mobilenumber"))) { %> <% ITL.show((string)card__3.get("this_p_mobilenumber"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_fax"))) { %> <% ITL.show((string)card__3.get("this_p_fax"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_mailaddress"))) { %> <% ITL.show((string)card__3.get("this_p_mailaddress"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_website"))) { %> <% ITL.show((string)card__3.get("this_p_website"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_comment"))) { %> <% ITL.show((string)card__3.get("this_p_comment"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_s_awards_p_label_fr"))) { %> <% ITL.show((string)card__3.get("this_s_awards_p_label_fr"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((int?)card__3.get("this_p_distinctionLevel"))) { %> ><% ITL.show((int?)card__3.get("this_p_distinctionLevel"), "string", "html", "integer"); %> <% } %> <% if(ITL.isNotNull((ITL.S((string)card__3.get("this_s_image_z_p_filename")) + " " + ITL.S((string)card__3.get("this_s_image_z_p_extension"))))) { %> <% ITL.show(ITL.S((string)card__3.get("this_s_image_z_p_filename")) + " " + ITL.S((string)card__3.get("this_s_image_z_p_extension")), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_description"))) { %> <% ITL.show((string)card__3.get("this_p_description"), "string", "direct", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_s_category_p_label_fr"))) { %> <% ITL.show((string)card__3.get("this_s_category_p_label_fr"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull(new SqlCollection("kwd:keyword", @"SELECT DISTINCT c0.`_oid` AS origin, this.label AS this_p_label, this.`_oid` AS this FROM kwd_keyword AS this INNER JOIN (ocsTrm_accomodation AS c0 INNER JOIN ocsTrm_accomodation_filter AS c0_l On ((c0.`_oid` = c0_l.`_from`) AND (c0.iso_sid <> '') AND (c0.`_oid` = #V_0&;)) INNER JOIN ocs_card AS c0_z On ((c0.`_oid` = c0_z.`_oid`) AND (c0_z.iso_sid <> ''))) On ((this.`_oid` = c0_l.`_to`) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map("#V_0&;|integer", (int?)card__3.get("this")), (List) EC.newList(new List(), "this_p_label")).labels())) { %> <% ITL.show(new SqlCollection("kwd:keyword", @"SELECT DISTINCT c0.`_oid` AS origin, this.label AS this_p_label, this.`_oid` AS this FROM kwd_keyword AS this INNER JOIN (ocsTrm_accomodation AS c0 INNER JOIN ocsTrm_accomodation_filter AS c0_l On ((c0.`_oid` = c0_l.`_from`) AND (c0.iso_sid <> '') AND (c0.`_oid` = #V_0&;)) INNER JOIN ocs_card AS c0_z On ((c0.`_oid` = c0_z.`_oid`) AND (c0_z.iso_sid <> ''))) On ((this.`_oid` = c0_l.`_to`) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map("#V_0&;|integer", (int?)card__3.get("this")), (List) EC.newList(new List(), "this_p_label")).labels(), "string", "html", "string"); %> <% } %> <% %> <% } } card__3.finish(); %>
<% %> <% } catalogObject.close(); } else { string init__3 = (string) (EC.itl.sdsInitXlsWorksheetNames()); ITL.show(EC.itl.addHeader("Content-Disposition", ("attachment; filename=classeur" + ".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 <% %> Libellé Adresse Qui contacter Téléphone Mobile Télécopie Adresse E-Mail Site Internet Commentaire Distinction Niveau de distinction Illustration En savoir plus Catégorie Mots-clés <% %> <% ItlEnumerator e277 = new ItlEnumerator("G00011382_276", null, false); e277.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("ocsTrm:accomodation", @"SELECT this.`_oid` AS this FROM ocsTrm_accomodation AS this INNER JOIN ocs_card AS this_z On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) WHERE (this.iso_sid <> '') 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_awards.`_oid` AS this_s_awards, this_s_image.`_oid` AS this_s_image, this_s_category.`_oid` AS this_s_category, this.title AS this_p_title, this.address AS this_p_address, this.contact AS this_p_contact, this.phonenumber AS this_p_phonenumber, this.mobilenumber AS this_p_mobilenumber, this.fax AS this_p_fax, this.mailaddress AS this_p_mailaddress, this.website AS this_p_website, this.comment AS this_p_comment, this.distinctionLevel AS this_p_distinctionLevel, this.description AS this_p_description, this_s_awards.label_fr AS this_s_awards_p_label_fr, this_s_image_z.filename AS this_s_image_z_p_filename, this_s_image_z.extension AS this_s_image_z_p_extension, this_s_category.label_fr AS this_s_category_p_label_fr, this_z.ocsStatus AS this_z_p_ocsStatus FROM ocsTrm_accomodation AS this INNER JOIN ocs_card AS this_z On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_awards On ((this.awards = this_s_awards.`_oid`) AND (this_s_awards.iso_sid <> '')) LEFT JOIN (alb_image AS this_s_image INNER JOIN alb_resource AS this_s_image_z On ((this_s_image.`_oid` = this_s_image_z.`_oid`) AND (this_s_image_z.iso_sid <> ''))) On ((this.image = this_s_image.`_oid`) AND (this_s_image.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_category On ((this.category = this_s_category.`_oid`) AND (this_s_category.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map(), false, (List) EC.newList(new List()), 5000, null)); ItlEnumerator card__4 = (ItlEnumerator) (e277); card__4.reset(); if(card__4.isNotEmpty()) { card__4.resetGroup(); for(card__4.start();card__4.test();card__4.fetch()) { ItlEnumerator row__3 = (ItlEnumerator) (card__4); if(row__3.position() % 10 == 9) { EC.Page.Response.Flush(); Response.BufferOutput = false; } %> <% if(ITL.isNotNull(((int?)card__4.get("this_z_p_ocsStatus") == 0?"En rédaction":((int?)card__4.get("this_z_p_ocsStatus") == 1?"A valider":((int?)card__4.get("this_z_p_ocsStatus") == 2?"Publiée":"Archivée")))) && ((int?)card__4.get("this_z_p_ocsStatus") == 0?"En rédaction":((int?)card__4.get("this_z_p_ocsStatus") == 1?"A valider":((int?)card__4.get("this_z_p_ocsStatus") == 2?"Publiée":"Archivée"))) != "") { %> <% ITL.show((int?)card__4.get("this_z_p_ocsStatus") == 0?"En rédaction":((int?)card__4.get("this_z_p_ocsStatus") == 1?"A valider":((int?)card__4.get("this_z_p_ocsStatus") == 2?"Publiée":"Archivée")), "string", "html", "string"); %> <% } %> <% %> <% if(ITL.isNotNull((string)card__4.get("this_p_title"))) { %> <% ITL.show((string)card__4.get("this_p_title"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_address"))) { %> <% ITL.show((string)card__4.get("this_p_address"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_contact"))) { %> <% ITL.show((string)card__4.get("this_p_contact"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_phonenumber"))) { %> <% ITL.show((string)card__4.get("this_p_phonenumber"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_mobilenumber"))) { %> <% ITL.show((string)card__4.get("this_p_mobilenumber"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_fax"))) { %> <% ITL.show((string)card__4.get("this_p_fax"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_mailaddress"))) { %> <% ITL.show((string)card__4.get("this_p_mailaddress"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_website"))) { %> <% ITL.show((string)card__4.get("this_p_website"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_comment"))) { %> <% ITL.show((string)card__4.get("this_p_comment"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_s_awards_p_label_fr"))) { %> <% ITL.show((string)card__4.get("this_s_awards_p_label_fr"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((int?)card__4.get("this_p_distinctionLevel"))) { %> ><% ITL.show((int?)card__4.get("this_p_distinctionLevel"), "string", "html", "integer"); %> <% } %> <% if(ITL.isNotNull((ITL.S((string)card__4.get("this_s_image_z_p_filename")) + " " + ITL.S((string)card__4.get("this_s_image_z_p_extension"))))) { %> <% ITL.show(ITL.S((string)card__4.get("this_s_image_z_p_filename")) + " " + ITL.S((string)card__4.get("this_s_image_z_p_extension")), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_description"))) { %> <% ITL.show((string)card__4.get("this_p_description"), "string", "direct", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_s_category_p_label_fr"))) { %> <% ITL.show((string)card__4.get("this_s_category_p_label_fr"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull(new SqlCollection("kwd:keyword", @"SELECT DISTINCT c0.`_oid` AS origin, this.label AS this_p_label, this.`_oid` AS this FROM kwd_keyword AS this INNER JOIN (ocsTrm_accomodation AS c0 INNER JOIN ocsTrm_accomodation_filter AS c0_l On ((c0.`_oid` = c0_l.`_from`) AND (c0.iso_sid <> '') AND (c0.`_oid` = #V_0&;)) INNER JOIN ocs_card AS c0_z On ((c0.`_oid` = c0_z.`_oid`) AND (c0_z.iso_sid <> ''))) On ((this.`_oid` = c0_l.`_to`) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map("#V_0&;|integer", (int?)card__4.get("this")), (List) EC.newList(new List(), "this_p_label")).labels())) { %> <% ITL.show(new SqlCollection("kwd:keyword", @"SELECT DISTINCT c0.`_oid` AS origin, this.label AS this_p_label, this.`_oid` AS this FROM kwd_keyword AS this INNER JOIN (ocsTrm_accomodation AS c0 INNER JOIN ocsTrm_accomodation_filter AS c0_l On ((c0.`_oid` = c0_l.`_from`) AND (c0.iso_sid <> '') AND (c0.`_oid` = #V_0&;)) INNER JOIN ocs_card AS c0_z On ((c0.`_oid` = c0_z.`_oid`) AND (c0_z.iso_sid <> ''))) On ((this.`_oid` = c0_l.`_to`) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map("#V_0&;|integer", (int?)card__4.get("this")), (List) EC.newList(new List(), "this_p_label")).labels(), "string", "html", "string"); %> <% } %> <% %> <% } } card__4.finish(); %>
<% %> <% } %>