<%@ Page Language="C#" Buffer="true" CodeFile="page000131d8.aspx.cs" Inherits="_page000131d8" CodePage="65001" 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é")); %><% EC.imageProviderUrl = "./imageProvider.aspx"; %><% EC.albumDialogUrl = "./albumDialog.aspx"; %><% EC.albumPrivateDialogUrl = "./albumPrivateDialog.aspx"; %><% SqlObject card = (SqlObject) (new SqlObject("ocsNewsEvent:event", @"SELECT this.`_oid` AS this, this.location_fr AS this_p_location_fr, this.period_fr AS this_p_period_fr, this.startDate AS this_p_startDate, this.endDate AS this_p_endDate, this_z.title_fr AS this_z_p_title_fr, this_z.summary_fr AS this_z_p_summary_fr, this_z.body_fr AS this_z_p_body_fr, this_z.copyright_fr AS this_z_p_copyright_fr, this_z.author AS this_z_p_author, this_z.writingDate AS this_z_p_writingDate, this_z_s_image.width AS this_z_s_image_p_width, this_z_s_image.height AS this_z_s_image_p_height, this_z_s_image.frames AS this_z_s_image_p_frames, this_z_s_image.`_oid` AS this_z_s_image, this_z_s_image_z.label_fr AS this_z_s_image_z_p_label_fr, this_z_s_image_z.description_fr AS this_z_s_image_z_p_description_fr FROM ocsNewsEvent_event AS this INNER JOIN (ocsNewsEvent_card AS this_z INNER JOIN ocs_card AS this_z_z On ((this_z.`_oid` = this_z_z.`_oid`) AND (this_z_z.iso_sid <> '')) LEFT JOIN (alb_image AS this_z_s_image INNER JOIN alb_resource AS this_z_s_image_z On ((this_z_s_image.`_oid` = this_z_s_image_z.`_oid`) AND (this_z_s_image_z.iso_sid <> ''))) On ((this_z.image = this_z_s_image.`_oid`) AND (this_z_s_image.iso_sid <> ''))) 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:ocsNewsEvent:event", "card"))),true)); string cmd = (string) ((string)EC.itl.getParameterValue("string", "cmd")); bool? searchByTheme = (bool?) ((bool?)EC.itl.getParameterValue("boolean", "searchByTheme")); string searchThemes = (string) ((string)EC.itl.getParameterValue("string", "searchThemes")); bool? searchByPeriod = (bool?) ((bool?)EC.itl.getParameterValue("boolean", "searchByPeriod")); string searchPeriod = (string) ((string)EC.itl.getParameterValue("string", "searchPeriod")); int? searchXDaysPeriod = (int?) ((int?)EC.itl.getParameterValue("integer", "searchXDaysPeriod")); DateTime? searchStartPeriod = (DateTime?) ((DateTime?)EC.itl.getParameterValue("date", "searchStartPeriod")); DateTime? searchEndPeriod = (DateTime?) ((DateTime?)EC.itl.getParameterValue("date", "searchEndPeriod")); bool? searchByLocation = (bool?) ((bool?)EC.itl.getParameterValue("boolean", "searchByLocation")); string searchLocation = (string) ((string)EC.itl.getParameterValue("string", "searchLocation")); %> " /> Agenda
Trémentines

Actualités/Agenda/Agenda

Agenda

<% if(ITL.isNotNull((int?)card.get("this"))) { %>
<% ItlLink link5 = new ItlLink("./page000131d8.aspx"); link5.setProperty("class", " backLink"); link5.show(); %>Retour à la liste<% link5.close(); %>
<% string titleContent = (string) ((string)card.get("this_z_p_title_fr")); %>

<% ITL.show(titleContent, "string", "html", "string"); %>

<% if(ITL.b((DateTime?)card.get("this_p_startDate")) || ITL.b((DateTime?)card.get("this_p_endDate")) || ITL.b((string)card.get("this_p_location_fr")) || ITL.b((string)card.get("this_p_period_fr"))) { %>

<% if(ITL.b((DateTime?)card.get("this_p_startDate")) || ITL.b((DateTime?)card.get("this_p_endDate"))) { %> <% if(ITL.b((DateTime?)card.get("this_p_startDate")) && ITL.b((DateTime?)card.get("this_p_endDate"))) { if((DateTime?)card.get("this_p_startDate") == (DateTime?)card.get("this_p_endDate")) { %>Le <% ITL.show((DateTime?)card.get("this_p_startDate"), "date", "html", "date"); } else {%>Du <% ITL.show((DateTime?)card.get("this_p_startDate"), "date", "html", "date"); %> au <% ITL.show((DateTime?)card.get("this_p_endDate"), "date", "html", "date"); } } else if(ITL.b((DateTime?)card.get("this_p_startDate"))) { %>A partir du <% ITL.show((DateTime?)card.get("this_p_startDate"), "date", "html", "date"); } else {%>Jusqu'au <% ITL.show((DateTime?)card.get("this_p_endDate"), "date", "html", "date"); } %>
<% } if(ITL.b((string)card.get("this_p_location_fr")) || ITL.b((string)card.get("this_p_period_fr"))) { if(ITL.b((string)card.get("this_p_location_fr"))) { %><% ITL.show((string)card.get("this_p_location_fr"), "string", "html", "string"); %>
<% } if(ITL.b((string)card.get("this_p_period_fr"))) { %><% ITL.show((string)card.get("this_p_period_fr"), "string", "html", "string"); %>
<% } } %>

<% } if(ITL.isNotNull((int?)card.get("this_z_s_image"))) { if(ITL.isNotNull((int?)card.get("this_z_s_image"))) { int effectiveWidth = (int) (EC.itl.getEffectiveWidth((int?)card.get("this_z_s_image_p_width"), (int?)card.get("this_z_s_image_p_height"), 150, 112)); int effectiveHeight = (int) (EC.itl.getEffectiveHeight((int?)card.get("this_z_s_image_p_width"), (int?)card.get("this_z_s_image_p_height"), 150, 112)); %>

> > <% ItlLink link16 = new ItlLink(""); link16.setProperty("class", "link"); link16.show(); %> class="image"<%ITL.showAttributeWithName("title", (string)card.get("this_z_s_image_z_p_label_fr"));ITL.showAttributeWithName("alt", (string)card.get("this_z_s_image_z_p_label_fr"));ITL.showAttributeWithName("longdesc", (string)card.get("this_z_s_image_z_p_description_fr"));ITL.showAttributeWithName("height", effectiveHeight);ITL.showAttributeWithName("width", effectiveWidth);%>/><% link16.close(); %> ><% ITL.show((string)card.get("this_z_s_image_z_p_label_fr"), "string", "html", "string"); %>

<% } else { } %>
<% } if(ITL.b((DateTime?)card.get("this_z_p_writingDate")) || ITL.b((string)card.get("this_z_p_author")) || ITL.b((string)card.get("this_z_p_copyright_fr"))) { %>

<% if(ITL.b((string)card.get("this_z_p_author")) && ITL.b((DateTime?)card.get("this_z_p_writingDate"))) { %> Par <% ITL.show((string)card.get("this_z_p_author"), "string", "html", "string"); %>, le <% ITL.show((DateTime?)card.get("this_z_p_writingDate"), "string", "html", "date"); %>
<% } else if(ITL.b((string)card.get("this_z_p_author"))) { %> Par <% ITL.show((string)card.get("this_z_p_author"), "string", "html", "string"); %>
<% } else if(ITL.b((DateTime?)card.get("this_z_p_writingDate"))) { %> Rédigée le <% ITL.show((DateTime?)card.get("this_z_p_writingDate"), "string", "html", "date"); %>
<% } else { } if(ITL.b((string)card.get("this_z_p_copyright_fr"))) { %><% ITL.show((string)card.get("this_z_p_copyright_fr"), "string", "html", "string"); %>
<% } %>

<% } if((string)card.get("this_z_p_body_fr") != "" || (string)card.get("this_z_p_summary_fr") != "") { %>
<% if((string)card.get("this_z_p_body_fr") == "" && (string)card.get("this_z_p_summary_fr") != "") { ITL.show((string)card.get("this_z_p_summary_fr"), "string", "memo", "string"); } else if((string)card.get("this_z_p_body_fr") != "") { ITL.show((string)card.get("this_z_p_body_fr"), "string", "direct", "string"); } %>
<% } ItlEnumerator e26 = new ItlEnumerator("G000131d8_25", null, false); e26.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("ocsNewsEvent:event", @"SELECT this_k_1.result1 AS this_k_1_1, this_k_2.result1 AS this_k_2_1, this.`_oid` AS this FROM ocsNewsEvent_event AS this INNER JOIN (ocsNewsEvent_card AS this_z INNER JOIN (ocs_card AS this_z_z LEFT JOIN ocs_catalog AS this_z_z_s_ocsCatalog On ((this_z_z.ocsCatalog = this_z_z_s_ocsCatalog.`_oid`) AND (this_z_z_s_ocsCatalog.iso_sid <> ''))) On ((this_z.`_oid` = this_z_z.`_oid`) AND (this_z_z.iso_sid <> ''))) 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 (ocsNewsEvent_event AS c0 INNER JOIN ocs_card_ocsVisibility AS c0_l On ((c0.`_oid` = c0_l.`_from`) AND (c0.iso_sid <> '')) INNER JOIN (ocsNewsEvent_card AS c0_z INNER JOIN ocs_card AS c0_z_z On ((c0_z.`_oid` = c0_z_z.`_oid`) AND (c0_z_z.iso_sid <> ''))) 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_2&;)) GROUP BY c0.`_oid`) AS this_k_1 On (this.`_oid` = this_k_1.origin) LEFT JOIN (SELECT c0.`_oid` AS origin, MAX(this.`_oid`) AS result1 FROM kwd_keyword AS this INNER JOIN (ocsNewsEvent_event AS c0 INNER JOIN ocsNewsEvent_card_keywords AS c0_l On ((c0.`_oid` = c0_l.`_from`) AND (c0.iso_sid <> '')) INNER JOIN (ocsNewsEvent_card AS c0_z INNER JOIN ocs_card AS c0_z_z On ((c0_z.`_oid` = c0_z_z.`_oid`) AND (c0_z_z.iso_sid <> ''))) 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.gid IN (#V_3&;)) GROUP BY c0.`_oid`) AS this_k_2 On (this.`_oid` = this_k_2.origin) WHERE (this.iso_sid <> '') AND (IF((this_z_z_s_ocsCatalog.useValidation = 1),this_z_z.ocsStatus,IF(((this_z_z.ocsStatus = 2) OR (this_z_z.ocsStatus = 3)),this_z_z.ocsStatus,0)) = 2) AND ((this_z.startVisibilityDate IS NULL ) OR (this_z.startVisibilityDate <= #V_0&;)) AND ((this_z.endVisibilityDate IS NULL ) OR (this_z.endVisibilityDate >= #V_0&;)) AND ((this_z_z_s_ocsCatalog.useXRM = 0) OR ((this_z_z_s_ocsCatalog.useXRM = 1) AND (this_k_1.result1 > 0))) AND (this_z_z_s_ocsCatalog.name = 'agenda') AND (this_k_2.result1 IS NOT NULL ) AND (this.`_oid` <> #V_1&;)", new ItlRuntime.SQL.Parameters( new ItlRuntime.SQL.Parameter("#V_0&;", EC.itl.today(), "date"), new ItlRuntime.SQL.Parameter("#V_1&;", (int?)card.get("this"), "integer"), new ItlRuntime.SQL.Parameter("#V_2&;", EC.itl.categoryOids(true), "oids"), new ItlRuntime.SQL.Parameter("#V_3&;", IsoKeywords.getKeywordGidsFromOids(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 (ocsNewsEvent_event AS c0 INNER JOIN ocsNewsEvent_card_keywords AS c0_l On ((c0.`_oid` = c0_l.`_from`) AND (c0.iso_sid <> '') AND (c0.`_oid` = #V_0&;)) INNER JOIN (ocsNewsEvent_card AS c0_z INNER JOIN ocs_card AS c0_z_z On ((c0_z.`_oid` = c0_z_z.`_oid`) AND (c0_z_z.iso_sid <> ''))) 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.get("this")), (List) EC.newList(new List(), "this_p_label")).keys()), "strings")), new ItlRuntime.SQL.OrderAliases(), new ItlRuntime.SQL.OptionalOrderAliases(), null, null), @"SELECT this.`_oid` AS this, this_z.title_fr AS this_z_p_title_fr, this_z.catchLine_fr AS this_z_p_catchLine_fr FROM ocsNewsEvent_event AS this INNER JOIN (ocsNewsEvent_card AS this_z INNER JOIN ocs_card AS this_z_z On ((this_z.`_oid` = this_z_z.`_oid`) AND (this_z_z.iso_sid <> ''))) On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map(), false, (List) EC.newList(new List()), null, null)); ItlEnumerator cardSeeAlso = (ItlEnumerator) (e26); cardSeeAlso.reset(); if(cardSeeAlso.isNotEmpty()) {%>

A lire également

<% ItlElement elem27 = new ItlElement("ul"); elem27.setAttribute("class", "bsDiscList"); elem27.setAttribute("style", ""); elem27.open(); cardSeeAlso.resetGroup(); for(cardSeeAlso.start();cardSeeAlso.test();cardSeeAlso.fetch()) { %>
  • <% ItlLink link30 = new ItlLink("./page000131d8.aspx"); link30.setParameter("card", cardSeeAlso); link30.show(); string _t0; ITL.show(((ITL.b((_t0 = (string)cardSeeAlso.get("this_z_p_catchLine_fr")))) ? _t0 : (string)cardSeeAlso.get("this_z_p_title_fr")), "string", "html", "string"); link30.close(); %>
    • <% }elem27.close(); %>
    <% } cardSeeAlso.finish(); %>
    <% } else { int? nbCollectionItem = (int?) (EC.itl.toInteger(new SqlCollection("ocsNewsEvent:event", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT this_k_1.result1 AS this_k_1_1, this.`_oid` AS this, this_z.title_fr AS this_z_p_title_fr, this.`_oid` AS data FROM ocsNewsEvent_event AS this INNER JOIN (ocsNewsEvent_card AS this_z INNER JOIN (ocs_card AS this_z_z LEFT JOIN ocs_catalog AS this_z_z_s_ocsCatalog On ((this_z_z.ocsCatalog = this_z_z_s_ocsCatalog.`_oid`) AND (this_z_z_s_ocsCatalog.iso_sid <> ''))) On ((this_z.`_oid` = this_z_z.`_oid`) AND (this_z_z.iso_sid <> ''))) 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 (ocsNewsEvent_event AS c0 INNER JOIN ocs_card_ocsVisibility AS c0_l On ((c0.`_oid` = c0_l.`_from`) AND (c0.iso_sid <> '')) INNER JOIN (ocsNewsEvent_card AS c0_z INNER JOIN ocs_card AS c0_z_z On ((c0_z.`_oid` = c0_z_z.`_oid`) AND (c0_z_z.iso_sid <> ''))) 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_1&;)) GROUP BY c0.`_oid`) AS this_k_1 On (this.`_oid` = this_k_1.origin) WHERE (this.iso_sid <> '') AND (IF((this_z_z_s_ocsCatalog.useValidation = 1),this_z_z.ocsStatus,IF(((this_z_z.ocsStatus = 2) OR (this_z_z.ocsStatus = 3)),this_z_z.ocsStatus,0)) = 2) AND ((this_z.startVisibilityDate IS NULL ) OR (this_z.startVisibilityDate <= #V_0&;)) AND ((this_z.endVisibilityDate IS NULL ) OR (this_z.endVisibilityDate >= #V_0&;)) AND ((this_z_z_s_ocsCatalog.useXRM = 0) OR ((this_z_z_s_ocsCatalog.useXRM = 1) AND (this_k_1.result1 > 0))) AND (this_z_z_s_ocsCatalog.name = 'agenda')) AS this", new Map("#V_0&;|date", EC.itl.today(), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_z_p_title_fr")).get("result"))); cardSearchFilter = (string)(ITL.gv["cardSearchFilter"] = ""); eventSearchFilter = (string)(ITL.gv["eventSearchFilter"] = ""); dayX = (DateTime?)(ITL.gv["dayX"] = ITL.D(ITL.d(EC.itl.today()) + ITL.d(ITL.i(searchXDaysPeriod) * 86400000))); isDefStartPeriod = (bool?)(ITL.gv["isDefStartPeriod"] = ITL.b(searchStartPeriod)); isDefEndPeriod = (bool?)(ITL.gv["isDefEndPeriod"] = ITL.b(searchEndPeriod)); cardSearchFilter = (string)(ITL.gv["cardSearchFilter"] = "[(searchByTheme == false()) || (searchByTheme && keywords.matchAnyFromOid(searchThemes))][(searchByPeriod == false()) || ((searchByPeriod == true()) && (((searchPeriod == 'xDays') && (writingDate >= today()) && (writingDate <= dayX)) || ((searchPeriod == 'between') && ((isDefStartPeriod == false()) || (isDefStartPeriod && (writingDate >= searchStartPeriod))) && ((isDefEndPeriod == false()) || (isDefEndPeriod && (writingDate <= searchEndPeriod)))) ))]"); eventSearchFilter = (string)(ITL.gv["eventSearchFilter"] = "[(searchByTheme == false()) || (searchByTheme && keywords.matchAnyFromOid(searchThemes))][(searchByPeriod == false()) || ((searchByPeriod == true()) && (((searchPeriod == 'xDays') && (isNotNull(startDate) || isNotNull(endDate)) && ((isNotNull(startDate) && (startDate >= today())) || (isNotNull(endDate) && (endDate >= today()))) && ((isNotNull(startDate) && (startDate <= dayX)) || (isNotNull(endDate) && (endDate <= dayX)))) || ((searchPeriod == 'between') && (isNotNull(startDate) || isNotNull(endDate)) && ((isDefStartPeriod == false()) || (isDefStartPeriod && (isNull(endDate) || (isNotNull(endDate) && (endDate >= searchStartPeriod))))) && ((isDefEndPeriod == false()) || (isDefEndPeriod && (isNull(startDate) || (isNotNull(startDate) && (startDate <= searchEndPeriod))))))))][(searchByLocation == false()) || (searchByLocation && (location ~ searchLocation))]");%>
    <% ItlEnumerator e42 = new ItlEnumerator("G000131d8_41", null, false); e42.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("ocsNewsEvent:event", @"SELECT this_k_1.result1 AS this_k_1_1, this_k_2.result1 AS this_k_2_1, this.`_oid` AS this, this.startDate AS o_1 FROM ocsNewsEvent_event AS this INNER JOIN (ocsNewsEvent_card AS this_z INNER JOIN (ocs_card AS this_z_z LEFT JOIN ocs_catalog AS this_z_z_s_ocsCatalog On ((this_z_z.ocsCatalog = this_z_z_s_ocsCatalog.`_oid`) AND (this_z_z_s_ocsCatalog.iso_sid <> ''))) On ((this_z.`_oid` = this_z_z.`_oid`) AND (this_z_z.iso_sid <> ''))) 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 (ocsNewsEvent_event AS c0 INNER JOIN ocs_card_ocsVisibility AS c0_l On ((c0.`_oid` = c0_l.`_from`) AND (c0.iso_sid <> '')) INNER JOIN (ocsNewsEvent_card AS c0_z INNER JOIN ocs_card AS c0_z_z On ((c0_z.`_oid` = c0_z_z.`_oid`) AND (c0_z_z.iso_sid <> ''))) 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_17&;)) GROUP BY c0.`_oid`) AS this_k_1 On (this.`_oid` = this_k_1.origin) LEFT JOIN (SELECT c0.`_oid` AS origin, MAX(this.`_oid`) AS result1 FROM kwd_keyword AS this INNER JOIN (ocsNewsEvent_event AS c0 INNER JOIN ocsNewsEvent_card_keywords AS c0_l On ((c0.`_oid` = c0_l.`_from`) AND (c0.iso_sid <> '')) INNER JOIN (ocsNewsEvent_card AS c0_z INNER JOIN ocs_card AS c0_z_z On ((c0_z.`_oid` = c0_z_z.`_oid`) AND (c0_z_z.iso_sid <> ''))) 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.gid IN (#V_18&;)) GROUP BY c0.`_oid`) AS this_k_2 On (this.`_oid` = this_k_2.origin) WHERE (this.iso_sid <> '') AND (IF((this_z_z_s_ocsCatalog.useValidation = 1),this_z_z.ocsStatus,IF(((this_z_z.ocsStatus = 2) OR (this_z_z.ocsStatus = 3)),this_z_z.ocsStatus,0)) = 2) AND ((this_z.startVisibilityDate IS NULL ) OR (this_z.startVisibilityDate <= #V_0&;)) AND ((this_z.endVisibilityDate IS NULL ) OR (this_z.endVisibilityDate >= #V_0&;)) AND ((this_z_z_s_ocsCatalog.useXRM = 0) OR ((this_z_z_s_ocsCatalog.useXRM = 1) AND (this_k_1.result1 > 0))) AND (this_z_z_s_ocsCatalog.name = 'agenda') AND (#V_1&; OR (#V_2&; AND (this_k_2.result1 IS NOT NULL ))) AND (#V_3&; OR (#V_4&; AND ((#V_5&; AND (((this.startDate IS NOT NULL ) OR (this.endDate IS NOT NULL )) AND ((((this.startDate IS NOT NULL ) AND (this.startDate >= #V_0&;)) OR ((this.endDate IS NOT NULL ) AND (this.endDate >= #V_0&;))) AND (((this.startDate IS NOT NULL ) AND (this.startDate <= #V_6&;)) OR ((this.endDate IS NOT NULL ) AND (this.endDate <= #V_6&;)))))) OR (#V_7&; AND (((this.startDate IS NOT NULL ) OR (this.endDate IS NOT NULL )) AND ((#V_8&; OR (#V_9&; AND ((this.endDate IS NULL ) OR ((this.endDate IS NOT NULL ) AND (this.endDate >= #V_10&;))))) AND (#V_11&; OR (#V_12&; AND ((this.startDate IS NULL ) OR ((this.startDate IS NOT NULL ) AND (this.startDate <= #V_13&;))))))))))) AND (#V_14&; OR (#V_15&; AND (this.location_fr LIKE CONCAT('%', #V_16&;, '%'))))", new ItlRuntime.SQL.Parameters( new ItlRuntime.SQL.Parameter("#V_0&;", EC.itl.today(), "date"), new ItlRuntime.SQL.Parameter("#V_1&;", (searchByTheme == false), "boolean"), new ItlRuntime.SQL.Parameter("#V_2&;", ITL.b(searchByTheme), "boolean"), new ItlRuntime.SQL.Parameter("#V_3&;", (searchByPeriod == false), "boolean"), new ItlRuntime.SQL.Parameter("#V_4&;", (searchByPeriod == true), "boolean"), new ItlRuntime.SQL.Parameter("#V_5&;", (searchPeriod == "xDays"), "boolean"), new ItlRuntime.SQL.Parameter("#V_6&;", (DateTime?)ITL.gv["dayX"], "date"), new ItlRuntime.SQL.Parameter("#V_7&;", (searchPeriod == "between"), "boolean"), new ItlRuntime.SQL.Parameter("#V_8&;", ((bool?)ITL.gv["isDefStartPeriod"] == false), "boolean"), new ItlRuntime.SQL.Parameter("#V_9&;", ITL.b((bool?)ITL.gv["isDefStartPeriod"]), "boolean"), new ItlRuntime.SQL.Parameter("#V_10&;", searchStartPeriod, "date"), new ItlRuntime.SQL.Parameter("#V_11&;", ((bool?)ITL.gv["isDefEndPeriod"] == false), "boolean"), new ItlRuntime.SQL.Parameter("#V_12&;", ITL.b((bool?)ITL.gv["isDefEndPeriod"]), "boolean"), new ItlRuntime.SQL.Parameter("#V_13&;", searchEndPeriod, "date"), new ItlRuntime.SQL.Parameter("#V_14&;", (searchByLocation == false), "boolean"), new ItlRuntime.SQL.Parameter("#V_15&;", ITL.b(searchByLocation), "boolean"), new ItlRuntime.SQL.Parameter("#V_16&;", searchLocation, "string"), new ItlRuntime.SQL.Parameter("#V_17&;", EC.itl.categoryOids(true), "oids"), new ItlRuntime.SQL.Parameter("#V_18&;", IsoKeywords.getKeywordGidsFromOids(ITL.S(searchThemes)), "strings")), new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_1", true)), new ItlRuntime.SQL.OptionalOrderAliases(), null, null), @"SELECT this.`_oid` AS this, this.location_fr AS this_p_location_fr, this.period_fr AS this_p_period_fr, this.startDate AS this_p_startDate, this.endDate AS this_p_endDate, this_z.title_fr AS this_z_p_title_fr, this_z.summary_fr AS this_z_p_summary_fr, this_z_s_image.width AS this_z_s_image_p_width, this_z_s_image.height AS this_z_s_image_p_height, this_z_s_image.frames AS this_z_s_image_p_frames, this_z_s_image.`_oid` AS this_z_s_image, this_z_s_image_z.label_fr AS this_z_s_image_z_p_label_fr, this_z_s_image_z.description_fr AS this_z_s_image_z_p_description_fr FROM ocsNewsEvent_event AS this INNER JOIN (ocsNewsEvent_card AS this_z INNER JOIN ocs_card AS this_z_z On ((this_z.`_oid` = this_z_z.`_oid`) AND (this_z_z.iso_sid <> '')) LEFT JOIN (alb_image AS this_z_s_image INNER JOIN alb_resource AS this_z_s_image_z On ((this_z_s_image.`_oid` = this_z_s_image_z.`_oid`) AND (this_z_s_image_z.iso_sid <> ''))) On ((this_z.image = this_z_s_image.`_oid`) AND (this_z_s_image.iso_sid <> ''))) On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map(), false, (List) EC.newList(new List()), null, null)); ItlEnumerator card__1 = (ItlEnumerator) (e42); card__1.reset(); if(card__1.isNotEmpty()) {%> <% card__1.resetGroup(); ItlGroup grpColumn = (ItlGroup) (card__1.addGroup(new ItlGroup("grpColumn",1, true,null))); for(card__1.start();card__1.test();card__1.fetch()) { if(grpColumn.isFirst()) {%> > <% }%> <% if(grpColumn.isLast()) {%> <% } }%>
    > <% if(card__1.positionInPage() > 1) { %>
    <% } string titleContent__1 = (string) ((string)card__1.get("this_z_p_title_fr")); %>

    <% ITL.show(titleContent__1, "string", "html", "string"); %>

    <% if(ITL.b((DateTime?)card__1.get("this_p_startDate")) || ITL.b((DateTime?)card__1.get("this_p_endDate")) || ITL.b((string)card__1.get("this_p_location_fr"))) { %>

    <% if(ITL.b((DateTime?)card__1.get("this_p_startDate")) || ITL.b((DateTime?)card__1.get("this_p_endDate"))) { %> <% if(ITL.b((DateTime?)card__1.get("this_p_startDate")) && ITL.b((DateTime?)card__1.get("this_p_endDate"))) { if((DateTime?)card__1.get("this_p_startDate") == (DateTime?)card__1.get("this_p_endDate")) { %>Le <% ITL.show((DateTime?)card__1.get("this_p_startDate"), "date", "html", "date"); } else {%>Du <% ITL.show((DateTime?)card__1.get("this_p_startDate"), "date", "html", "date"); %> au <% ITL.show((DateTime?)card__1.get("this_p_endDate"), "date", "html", "date"); } } else if(ITL.b((DateTime?)card__1.get("this_p_startDate"))) { %>A partir du <% ITL.show((DateTime?)card__1.get("this_p_startDate"), "date", "html", "date"); } else {%>Jusqu'au <% ITL.show((DateTime?)card__1.get("this_p_endDate"), "date", "html", "date"); } %>
    <% } if(ITL.b((string)card__1.get("this_p_location_fr"))) { %><% ITL.show((string)card__1.get("this_p_location_fr"), "string", "html", "string"); %>
    <% } if(ITL.b((string)card__1.get("this_p_period_fr"))) { %><% ITL.show((string)card__1.get("this_p_period_fr"), "string", "html", "string"); %>
    <% } %>

    <% } string _t1 = EC.itl.toString(card__1.getObject("this_z_s_image", "alb:image")); if(ITL.b(((ITL.b(_t1)) ? _t1 : (string)card__1.get("this_z_p_summary_fr")))) { %>
    <% if(ITL.isNotNull((int?)card__1.get("this_z_s_image"))) { %>
    <% ItlImage image54 = new ItlImage("alb:image", card__1.getObject("this_z_s_image", "alb:image"), (int?)card__1.get("this_z_s_image_p_width"), (int?)card__1.get("this_z_s_image_p_height"), (int?)card__1.get("this_z_s_image_p_frames")); image54.setProperty("maxWidth", 100); image54.setProperty("maxHeight", 75); image54.setProperty("title", (string)card__1.get("this_z_s_image_z_p_label_fr")); image54.setProperty("alt", (string)card__1.get("this_z_s_image_z_p_label_fr")); image54.setProperty("longdesc", (string)card__1.get("this_z_s_image_z_p_description_fr")); image54.show(); %>
    <% } if(ITL.b((string)card__1.get("this_z_p_summary_fr"))) { %>

    <% ITL.show((string)card__1.get("this_z_p_summary_fr"), "string", "memo", "string"); %>

    <% } %>
    <% } %> <% ItlLink link57 = new ItlLink("./page000131d8.aspx"); link57.setProperty("class", " detailLink"); link57.setParameter("card", card__1); link57.show(); %>>> Lire la suite<% link57.close(); %>
    <% } else { if(cmd == "searchForm") { %>

    Aucun résultat ne correspond à votre recherche.

    <% } else {%>

    Aucun événement disponible pour le moment.

    <% } } card__1.finish(); %> <% } %>

    © Mairie de TREMENTINES 2021