<%@ Page Language="C#" Buffer="true" CodeFile="xls00010c1c.aspx.cs" Inherits="_xls00010c1c" 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("ocsRb:room", @"SELECT this.`_oid` AS this FROM ocsRb_room 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:ocsRb:room", "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 = 'salles_communales')", 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 <% %> Nom Capacité Surface Description Photo Localisation Plan d'accès Fenêtres Accès handicapé Heure de début Heure de fin Durée minimum Détails des réservations visible par l'utilisateur courant <% %> <% ItlEnumerator e39 = new ItlEnumerator("G00010c1c_38", null, false); string _t0 = ITL.S(searchFilter__1); e39.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("ocsRb:room", @"SELECT this.`_oid` AS this FROM ocsRb_room 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 = 'salles_communales') AND (#V_0&; OR (this_z.ocsCreationLogin = #V_1&;)) AND (#V_2&; OR ((this.name LIKE CONCAT('%', #V_3&;, '%')) OR ((this.description LIKE CONCAT('%', #V_3&;, '%')) OR (this.location 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_k_1.result1 AS this_k_1_1, this_s_picture.`_oid` AS this_s_picture, this_s_document.`_oid` AS this_s_document, this.name AS this_p_name, this.capacity AS this_p_capacity, this.area AS this_p_area, this.description AS this_p_description, this.location AS this_p_location, this.windows AS this_p_windows, this.disabled_access AS this_p_disabled_access, this.startHour AS this_p_startHour, this.endHour AS this_p_endHour, this.minSpan AS this_p_minSpan, this.restrictBookingDetails AS this_p_restrictBookingDetails, this_s_picture_z.filename AS this_s_picture_z_p_filename, this_s_picture_z.extension AS this_s_picture_z_p_extension, this_s_document.filename AS this_s_document_p_filename, this_s_document.extension AS this_s_document_p_extension, this_z.ocsStatus AS this_z_p_ocsStatus FROM ocsRb_room AS this INNER JOIN ocs_card AS this_z On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) LEFT JOIN (SELECT c0.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 FROM xrm_category AS this INNER JOIN (ocsRb_room AS c0 INNER JOIN ocsRb_room_bookingValidationRights AS c0_l On ((c0.`_oid` = c0_l.`_from`) AND (c0.iso_sid <> '')) 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 <> '') AND (this.`_oid` IN (#V_0&;)) GROUP BY c0.`_oid`) AS this_k_1 On (this.`_oid` = this_k_1.origin) LEFT JOIN (alb_private_image AS this_s_picture INNER JOIN alb_private_resource AS this_s_picture_z On ((this_s_picture.`_oid` = this_s_picture_z.`_oid`) AND (this_s_picture_z.iso_sid <> ''))) On ((this.picture = this_s_picture.`_oid`) AND (this_s_picture.iso_sid <> '')) LEFT JOIN alb_private_resource AS this_s_document On ((this.document = this_s_document.`_oid`) AND (this_s_document.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map("#V_0&;|oids", EC.itl.categoryOids(true)), false, (List) EC.newList(new List()), 5000, null)); ItlEnumerator card__1 = (ItlEnumerator) (e39); 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_name"))) { %> <% ITL.show((string)card__1.get("this_p_name"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((int?)card__1.get("this_p_capacity"))) { %> ><% ITL.show((int?)card__1.get("this_p_capacity"), "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((double?)card__1.get("this_p_area"))) { %> ><% ITL.show(EC.itl.format(ITL.d((double?)card__1.get("this_p_area")), "double", null, "double"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_description"))) { %> <% ITL.show((string)card__1.get("this_p_description"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((ITL.S((string)card__1.get("this_s_picture_z_p_filename")) + " " + ITL.S((string)card__1.get("this_s_picture_z_p_extension"))))) { %> <% ITL.show(ITL.S((string)card__1.get("this_s_picture_z_p_filename")) + " " + ITL.S((string)card__1.get("this_s_picture_z_p_extension")), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_location"))) { %> <% ITL.show((string)card__1.get("this_p_location"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((ITL.S((string)card__1.get("this_s_document_p_filename")) + " " + ITL.S((string)card__1.get("this_s_document_p_extension"))))) { %> <% ITL.show(ITL.S((string)card__1.get("this_s_document_p_filename")) + " " + ITL.S((string)card__1.get("this_s_document_p_extension")), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((bool?)card__1.get("this_p_windows"))) { %> ><% ITL.show(ITL.b((bool?)card__1.get("this_p_windows"))?1:0, "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((bool?)card__1.get("this_p_disabled_access"))) { %> ><% ITL.show(ITL.b((bool?)card__1.get("this_p_disabled_access"))?1:0, "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((int?)card__1.get("this_p_startHour"))) { %> ><% ITL.show((int?)card__1.get("this_p_startHour"), "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((int?)card__1.get("this_p_endHour"))) { %> ><% ITL.show((int?)card__1.get("this_p_endHour"), "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((int?)card__1.get("this_p_minSpan"))) { %> ><% ITL.show((int?)card__1.get("this_p_minSpan"), "string", "html", "integer"); %> <% } %> 0))?"String":"Boolean") == "DateTime"?"s25":"s24");%>> <% if(ITL.isNotNull((!ITL.b((bool?)card__1.get("this_p_restrictBookingDetails")) || ITL.countDefault((int?)card__1.get("this_k_1_1")) > 0))) { %> 0))?"String":"Boolean");%>><% ITL.show(!ITL.b((bool?)card__1.get("this_p_restrictBookingDetails")) || ITL.countDefault((int?)card__1.get("this_k_1_1")) > 0?1:0, "string", "html", "integer"); %> <% } %> <% %> <% } } 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 <% %> Nom Capacité Surface Description Photo Localisation Plan d'accès Fenêtres Accès handicapé Heure de début Heure de fin Durée minimum Détails des réservations visible par l'utilisateur courant <% %> <% ItlEnumerator e111 = new ItlEnumerator("G00010c1c_110", null, false); string _t1 = ITL.S(searchFilter__1); e111.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("ocsRb:room", @"SELECT this.`_oid` AS this FROM ocsRb_room 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 = 'salles_communales') AND (#V_0&; OR (this_z.ocsCreationLogin = #V_1&;)) AND (#V_2&; OR ((this.name LIKE CONCAT('%', #V_3&;, '%')) OR ((this.description LIKE CONCAT('%', #V_3&;, '%')) OR (this.location 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_k_1.result1 AS this_k_1_1, this_s_picture.`_oid` AS this_s_picture, this_s_document.`_oid` AS this_s_document, this.name AS this_p_name, this.capacity AS this_p_capacity, this.area AS this_p_area, this.description AS this_p_description, this.location AS this_p_location, this.windows AS this_p_windows, this.disabled_access AS this_p_disabled_access, this.startHour AS this_p_startHour, this.endHour AS this_p_endHour, this.minSpan AS this_p_minSpan, this.restrictBookingDetails AS this_p_restrictBookingDetails, this_s_picture_z.filename AS this_s_picture_z_p_filename, this_s_picture_z.extension AS this_s_picture_z_p_extension, this_s_document.filename AS this_s_document_p_filename, this_s_document.extension AS this_s_document_p_extension, this_z.ocsStatus AS this_z_p_ocsStatus FROM ocsRb_room AS this INNER JOIN ocs_card AS this_z On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) LEFT JOIN (SELECT c0.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 FROM xrm_category AS this INNER JOIN (ocsRb_room AS c0 INNER JOIN ocsRb_room_bookingValidationRights AS c0_l On ((c0.`_oid` = c0_l.`_from`) AND (c0.iso_sid <> '')) 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 <> '') AND (this.`_oid` IN (#V_0&;)) GROUP BY c0.`_oid`) AS this_k_1 On (this.`_oid` = this_k_1.origin) LEFT JOIN (alb_private_image AS this_s_picture INNER JOIN alb_private_resource AS this_s_picture_z On ((this_s_picture.`_oid` = this_s_picture_z.`_oid`) AND (this_s_picture_z.iso_sid <> ''))) On ((this.picture = this_s_picture.`_oid`) AND (this_s_picture.iso_sid <> '')) LEFT JOIN alb_private_resource AS this_s_document On ((this.document = this_s_document.`_oid`) AND (this_s_document.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map("#V_0&;|oids", EC.itl.categoryOids(true)), false, (List) EC.newList(new List()), 5000, null)); ItlEnumerator card__2 = (ItlEnumerator) (e111); 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_name"))) { %> <% ITL.show((string)card__2.get("this_p_name"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((int?)card__2.get("this_p_capacity"))) { %> ><% ITL.show((int?)card__2.get("this_p_capacity"), "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((double?)card__2.get("this_p_area"))) { %> ><% ITL.show(EC.itl.format(ITL.d((double?)card__2.get("this_p_area")), "double", null, "double"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_description"))) { %> <% ITL.show((string)card__2.get("this_p_description"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((ITL.S((string)card__2.get("this_s_picture_z_p_filename")) + " " + ITL.S((string)card__2.get("this_s_picture_z_p_extension"))))) { %> <% ITL.show(ITL.S((string)card__2.get("this_s_picture_z_p_filename")) + " " + ITL.S((string)card__2.get("this_s_picture_z_p_extension")), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_location"))) { %> <% ITL.show((string)card__2.get("this_p_location"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((ITL.S((string)card__2.get("this_s_document_p_filename")) + " " + ITL.S((string)card__2.get("this_s_document_p_extension"))))) { %> <% ITL.show(ITL.S((string)card__2.get("this_s_document_p_filename")) + " " + ITL.S((string)card__2.get("this_s_document_p_extension")), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((bool?)card__2.get("this_p_windows"))) { %> ><% ITL.show(ITL.b((bool?)card__2.get("this_p_windows"))?1:0, "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((bool?)card__2.get("this_p_disabled_access"))) { %> ><% ITL.show(ITL.b((bool?)card__2.get("this_p_disabled_access"))?1:0, "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((int?)card__2.get("this_p_startHour"))) { %> ><% ITL.show((int?)card__2.get("this_p_startHour"), "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((int?)card__2.get("this_p_endHour"))) { %> ><% ITL.show((int?)card__2.get("this_p_endHour"), "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((int?)card__2.get("this_p_minSpan"))) { %> ><% ITL.show((int?)card__2.get("this_p_minSpan"), "string", "html", "integer"); %> <% } %> 0))?"String":"Boolean") == "DateTime"?"s25":"s24");%>> <% if(ITL.isNotNull((!ITL.b((bool?)card__2.get("this_p_restrictBookingDetails")) || ITL.countDefault((int?)card__2.get("this_k_1_1")) > 0))) { %> 0))?"String":"Boolean");%>><% ITL.show(!ITL.b((bool?)card__2.get("this_p_restrictBookingDetails")) || ITL.countDefault((int?)card__2.get("this_k_1_1")) > 0?1:0, "string", "html", "integer"); %> <% } %> <% %> <% } } 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 <% %> Nom Capacité Surface Description Photo Localisation Plan d'accès Fenêtres Accès handicapé Heure de début Heure de fin Durée minimum Détails des réservations visible par l'utilisateur courant <% %> <% ItlEnumerator e183 = new ItlEnumerator("G00010c1c_182", null, false); string _t2 = ITL.S(searchFilter__1); e183.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("ocsRb:room", @"SELECT this.`_oid` AS this FROM ocsRb_room 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 = 'salles_communales') AND (#V_0&; OR (this_z.ocsCreationLogin = #V_1&;)) AND (#V_2&; OR ((this.name LIKE CONCAT('%', #V_3&;, '%')) OR ((this.description LIKE CONCAT('%', #V_3&;, '%')) OR (this.location 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_k_1.result1 AS this_k_1_1, this_s_picture.`_oid` AS this_s_picture, this_s_document.`_oid` AS this_s_document, this.name AS this_p_name, this.capacity AS this_p_capacity, this.area AS this_p_area, this.description AS this_p_description, this.location AS this_p_location, this.windows AS this_p_windows, this.disabled_access AS this_p_disabled_access, this.startHour AS this_p_startHour, this.endHour AS this_p_endHour, this.minSpan AS this_p_minSpan, this.restrictBookingDetails AS this_p_restrictBookingDetails, this_s_picture_z.filename AS this_s_picture_z_p_filename, this_s_picture_z.extension AS this_s_picture_z_p_extension, this_s_document.filename AS this_s_document_p_filename, this_s_document.extension AS this_s_document_p_extension, this_z.ocsStatus AS this_z_p_ocsStatus FROM ocsRb_room AS this INNER JOIN ocs_card AS this_z On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) LEFT JOIN (SELECT c0.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 FROM xrm_category AS this INNER JOIN (ocsRb_room AS c0 INNER JOIN ocsRb_room_bookingValidationRights AS c0_l On ((c0.`_oid` = c0_l.`_from`) AND (c0.iso_sid <> '')) 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 <> '') AND (this.`_oid` IN (#V_0&;)) GROUP BY c0.`_oid`) AS this_k_1 On (this.`_oid` = this_k_1.origin) LEFT JOIN (alb_private_image AS this_s_picture INNER JOIN alb_private_resource AS this_s_picture_z On ((this_s_picture.`_oid` = this_s_picture_z.`_oid`) AND (this_s_picture_z.iso_sid <> ''))) On ((this.picture = this_s_picture.`_oid`) AND (this_s_picture.iso_sid <> '')) LEFT JOIN alb_private_resource AS this_s_document On ((this.document = this_s_document.`_oid`) AND (this_s_document.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map("#V_0&;|oids", EC.itl.categoryOids(true)), false, (List) EC.newList(new List()), 5000, null)); ItlEnumerator card__3 = (ItlEnumerator) (e183); 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_name"))) { %> <% ITL.show((string)card__3.get("this_p_name"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((int?)card__3.get("this_p_capacity"))) { %> ><% ITL.show((int?)card__3.get("this_p_capacity"), "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((double?)card__3.get("this_p_area"))) { %> ><% ITL.show(EC.itl.format(ITL.d((double?)card__3.get("this_p_area")), "double", null, "double"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_description"))) { %> <% ITL.show((string)card__3.get("this_p_description"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((ITL.S((string)card__3.get("this_s_picture_z_p_filename")) + " " + ITL.S((string)card__3.get("this_s_picture_z_p_extension"))))) { %> <% ITL.show(ITL.S((string)card__3.get("this_s_picture_z_p_filename")) + " " + ITL.S((string)card__3.get("this_s_picture_z_p_extension")), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_location"))) { %> <% ITL.show((string)card__3.get("this_p_location"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((ITL.S((string)card__3.get("this_s_document_p_filename")) + " " + ITL.S((string)card__3.get("this_s_document_p_extension"))))) { %> <% ITL.show(ITL.S((string)card__3.get("this_s_document_p_filename")) + " " + ITL.S((string)card__3.get("this_s_document_p_extension")), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((bool?)card__3.get("this_p_windows"))) { %> ><% ITL.show(ITL.b((bool?)card__3.get("this_p_windows"))?1:0, "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((bool?)card__3.get("this_p_disabled_access"))) { %> ><% ITL.show(ITL.b((bool?)card__3.get("this_p_disabled_access"))?1:0, "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((int?)card__3.get("this_p_startHour"))) { %> ><% ITL.show((int?)card__3.get("this_p_startHour"), "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((int?)card__3.get("this_p_endHour"))) { %> ><% ITL.show((int?)card__3.get("this_p_endHour"), "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((int?)card__3.get("this_p_minSpan"))) { %> ><% ITL.show((int?)card__3.get("this_p_minSpan"), "string", "html", "integer"); %> <% } %> 0))?"String":"Boolean") == "DateTime"?"s25":"s24");%>> <% if(ITL.isNotNull((!ITL.b((bool?)card__3.get("this_p_restrictBookingDetails")) || ITL.countDefault((int?)card__3.get("this_k_1_1")) > 0))) { %> 0))?"String":"Boolean");%>><% ITL.show(!ITL.b((bool?)card__3.get("this_p_restrictBookingDetails")) || ITL.countDefault((int?)card__3.get("this_k_1_1")) > 0?1:0, "string", "html", "integer"); %> <% } %> <% %> <% } } 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 <% %> Nom Capacité Surface Description Photo Localisation Plan d'accès Fenêtres Accès handicapé Heure de début Heure de fin Durée minimum Détails des réservations visible par l'utilisateur courant <% %> <% ItlEnumerator e255 = new ItlEnumerator("G00010c1c_254", null, false); e255.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("ocsRb:room", @"SELECT this.`_oid` AS this FROM ocsRb_room 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_k_1.result1 AS this_k_1_1, this_s_picture.`_oid` AS this_s_picture, this_s_document.`_oid` AS this_s_document, this.name AS this_p_name, this.capacity AS this_p_capacity, this.area AS this_p_area, this.description AS this_p_description, this.location AS this_p_location, this.windows AS this_p_windows, this.disabled_access AS this_p_disabled_access, this.startHour AS this_p_startHour, this.endHour AS this_p_endHour, this.minSpan AS this_p_minSpan, this.restrictBookingDetails AS this_p_restrictBookingDetails, this_s_picture_z.filename AS this_s_picture_z_p_filename, this_s_picture_z.extension AS this_s_picture_z_p_extension, this_s_document.filename AS this_s_document_p_filename, this_s_document.extension AS this_s_document_p_extension, this_z.ocsStatus AS this_z_p_ocsStatus FROM ocsRb_room AS this INNER JOIN ocs_card AS this_z On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) LEFT JOIN (SELECT c0.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 FROM xrm_category AS this INNER JOIN (ocsRb_room AS c0 INNER JOIN ocsRb_room_bookingValidationRights AS c0_l On ((c0.`_oid` = c0_l.`_from`) AND (c0.iso_sid <> '')) 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 <> '') AND (this.`_oid` IN (#V_0&;)) GROUP BY c0.`_oid`) AS this_k_1 On (this.`_oid` = this_k_1.origin) LEFT JOIN (alb_private_image AS this_s_picture INNER JOIN alb_private_resource AS this_s_picture_z On ((this_s_picture.`_oid` = this_s_picture_z.`_oid`) AND (this_s_picture_z.iso_sid <> ''))) On ((this.picture = this_s_picture.`_oid`) AND (this_s_picture.iso_sid <> '')) LEFT JOIN alb_private_resource AS this_s_document On ((this.document = this_s_document.`_oid`) AND (this_s_document.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map("#V_0&;|oids", EC.itl.categoryOids(true)), false, (List) EC.newList(new List()), 5000, null)); ItlEnumerator card__4 = (ItlEnumerator) (e255); 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_name"))) { %> <% ITL.show((string)card__4.get("this_p_name"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((int?)card__4.get("this_p_capacity"))) { %> ><% ITL.show((int?)card__4.get("this_p_capacity"), "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((double?)card__4.get("this_p_area"))) { %> ><% ITL.show(EC.itl.format(ITL.d((double?)card__4.get("this_p_area")), "double", null, "double"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_description"))) { %> <% ITL.show((string)card__4.get("this_p_description"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((ITL.S((string)card__4.get("this_s_picture_z_p_filename")) + " " + ITL.S((string)card__4.get("this_s_picture_z_p_extension"))))) { %> <% ITL.show(ITL.S((string)card__4.get("this_s_picture_z_p_filename")) + " " + ITL.S((string)card__4.get("this_s_picture_z_p_extension")), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_location"))) { %> <% ITL.show((string)card__4.get("this_p_location"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((ITL.S((string)card__4.get("this_s_document_p_filename")) + " " + ITL.S((string)card__4.get("this_s_document_p_extension"))))) { %> <% ITL.show(ITL.S((string)card__4.get("this_s_document_p_filename")) + " " + ITL.S((string)card__4.get("this_s_document_p_extension")), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((bool?)card__4.get("this_p_windows"))) { %> ><% ITL.show(ITL.b((bool?)card__4.get("this_p_windows"))?1:0, "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((bool?)card__4.get("this_p_disabled_access"))) { %> ><% ITL.show(ITL.b((bool?)card__4.get("this_p_disabled_access"))?1:0, "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((int?)card__4.get("this_p_startHour"))) { %> ><% ITL.show((int?)card__4.get("this_p_startHour"), "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((int?)card__4.get("this_p_endHour"))) { %> ><% ITL.show((int?)card__4.get("this_p_endHour"), "string", "html", "integer"); %> <% } %> > <% if(ITL.isNotNull((int?)card__4.get("this_p_minSpan"))) { %> ><% ITL.show((int?)card__4.get("this_p_minSpan"), "string", "html", "integer"); %> <% } %> 0))?"String":"Boolean") == "DateTime"?"s25":"s24");%>> <% if(ITL.isNotNull((!ITL.b((bool?)card__4.get("this_p_restrictBookingDetails")) || ITL.countDefault((int?)card__4.get("this_k_1_1")) > 0))) { %> 0))?"String":"Boolean");%>><% ITL.show(!ITL.b((bool?)card__4.get("this_p_restrictBookingDetails")) || ITL.countDefault((int?)card__4.get("this_k_1_1")) > 0?1:0, "string", "html", "integer"); %> <% } %> <% %> <% } } card__4.finish(); %>
<% %> <% } %>