<%@ Page Language="C#" Buffer="true" CodeFile="xls00010c18.aspx.cs" Inherits="_xls00010c18" 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("ocsPbm:callForTenders", @"SELECT this.`_oid` AS this FROM ocsPbm_callForTenders 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:ocsPbm:callForTenders", "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 = 'appels_d_offres')", 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 <% %> Dépositaire Contact Service E-mail Numéro de téléphone Télécopie Référence Type de marché Type de procédure Maître d'ouvrage Nom du responsable Adresse Code Postal Ville E-mail du responsable Zone de diffusion Objet du marché Date de parution Date limite Lieu d'exécution Complément Document Mots-clés <% %> <% ItlEnumerator e59 = new ItlEnumerator("G00010c18_58", null, false); string _t0 = ITL.S(searchFilter__1); e59.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("ocsPbm:callForTenders", @"SELECT this.`_oid` AS this FROM ocsPbm_callForTenders 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 = 'appels_d_offres') AND (#V_0&; OR (this_z.ocsCreationLogin = #V_1&;)) AND (#V_2&; OR ((this.contact LIKE CONCAT('%', #V_3&;, '%')) OR ((this.service LIKE CONCAT('%', #V_3&;, '%')) OR ((this.email LIKE CONCAT('%', #V_3&;, '%')) OR ((this.phoneNumber LIKE CONCAT('%', #V_3&;, '%')) OR ((this.fax LIKE CONCAT('%', #V_3&;, '%')) OR ((this.reference LIKE CONCAT('%', #V_3&;, '%')) OR ((this.client LIKE CONCAT('%', #V_3&;, '%')) OR ((this.person_in_charge LIKE CONCAT('%', #V_3&;, '%')) OR ((this.address LIKE CONCAT('%', #V_3&;, '%')) OR ((this.postalCode LIKE CONCAT('%', #V_3&;, '%')) OR ((this.city LIKE CONCAT('%', #V_3&;, '%')) OR ((this.personInChargeMail LIKE CONCAT('%', #V_3&;, '%')) OR ((this.tenderZone LIKE CONCAT('%', #V_3&;, '%')) OR ((this.marketObject LIKE CONCAT('%', #V_3&;, '%')) OR ((this.executionPlace LIKE CONCAT('%', #V_3&;, '%')) OR (this.complement 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_depositary.`_oid` AS this_s_depositary, this_s_marketType.`_oid` AS this_s_marketType, this_s_procedureType.`_oid` AS this_s_procedureType, this_s_document.`_oid` AS this_s_document, this.contact AS this_p_contact, this.service AS this_p_service, this.email AS this_p_email, this.phoneNumber AS this_p_phoneNumber, this.fax AS this_p_fax, this.reference AS this_p_reference, this.client AS this_p_client, this.person_in_charge AS this_p_person_in_charge, this.address AS this_p_address, this.postalCode AS this_p_postalCode, this.city AS this_p_city, this.personInChargeMail AS this_p_personInChargeMail, this.tenderZone AS this_p_tenderZone, this.marketObject AS this_p_marketObject, this.issueDate AS this_p_issueDate, this.deadline AS this_p_deadline, this.executionPlace AS this_p_executionPlace, this.complement AS this_p_complement, this_s_depositary.label_fr AS this_s_depositary_p_label_fr, this_s_marketType.label_fr AS this_s_marketType_p_label_fr, this_s_procedureType.label_fr AS this_s_procedureType_p_label_fr, 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 ocsPbm_callForTenders 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_depositary On ((this.depositary = this_s_depositary.`_oid`) AND (this_s_depositary.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_marketType On ((this.marketType = this_s_marketType.`_oid`) AND (this_s_marketType.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_procedureType On ((this.procedureType = this_s_procedureType.`_oid`) AND (this_s_procedureType.iso_sid <> '')) LEFT JOIN alb_resource AS this_s_document On ((this.document = this_s_document.`_oid`) AND (this_s_document.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map(), false, (List) EC.newList(new List()), 5000, null)); ItlEnumerator card__1 = (ItlEnumerator) (e59); 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_s_depositary_p_label_fr"))) { %> <% ITL.show((string)card__1.get("this_s_depositary_p_label_fr"), "string", "html", "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_service"))) { %> <% ITL.show((string)card__1.get("this_p_service"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_email"))) { %> <% ITL.show((string)card__1.get("this_p_email"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_phoneNumber"))) { %> <% ITL.show((string)card__1.get("this_p_phoneNumber"), "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_reference"))) { %> <% ITL.show((string)card__1.get("this_p_reference"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_s_marketType_p_label_fr"))) { %> <% ITL.show((string)card__1.get("this_s_marketType_p_label_fr"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_s_procedureType_p_label_fr"))) { %> <% ITL.show((string)card__1.get("this_s_procedureType_p_label_fr"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_client"))) { %> <% ITL.show((string)card__1.get("this_p_client"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_person_in_charge"))) { %> <% ITL.show((string)card__1.get("this_p_person_in_charge"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_address"))) { %> <% ITL.show((string)card__1.get("this_p_address"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_postalCode"))) { %> <% ITL.show((string)card__1.get("this_p_postalCode"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_city"))) { %> <% ITL.show((string)card__1.get("this_p_city"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_personInChargeMail"))) { %> <% ITL.show((string)card__1.get("this_p_personInChargeMail"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_tenderZone"))) { %> <% ITL.show((string)card__1.get("this_p_tenderZone"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_marketObject"))) { %> <% ITL.show((string)card__1.get("this_p_marketObject"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((DateTime?)card__1.get("this_p_issueDate"))) { %> ><% ITL.show(EC.itl.format(ITL.D((DateTime?)card__1.get("this_p_issueDate")), "xlsDate", null, "date"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((DateTime?)card__1.get("this_p_deadline"))) { %> ><% ITL.show(EC.itl.format(ITL.D((DateTime?)card__1.get("this_p_deadline")), "xlsDate", null, "date"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_executionPlace"))) { %> <% ITL.show((string)card__1.get("this_p_executionPlace"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_complement"))) { %> <% ITL.show((string)card__1.get("this_p_complement"), "string", "direct", "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(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 (ocsPbm_callForTenders AS c0 INNER JOIN ocsPbm_callForTenders_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 (ocsPbm_callForTenders AS c0 INNER JOIN ocsPbm_callForTenders_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 <% %> Dépositaire Contact Service E-mail Numéro de téléphone Télécopie Référence Type de marché Type de procédure Maître d'ouvrage Nom du responsable Adresse Code Postal Ville E-mail du responsable Zone de diffusion Objet du marché Date de parution Date limite Lieu d'exécution Complément Document Mots-clés <% %> <% ItlEnumerator e169 = new ItlEnumerator("G00010c18_168", null, false); string _t1 = ITL.S(searchFilter__1); e169.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("ocsPbm:callForTenders", @"SELECT this.`_oid` AS this FROM ocsPbm_callForTenders 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 = 'appels_d_offres') AND (#V_0&; OR (this_z.ocsCreationLogin = #V_1&;)) AND (#V_2&; OR ((this.contact LIKE CONCAT('%', #V_3&;, '%')) OR ((this.service LIKE CONCAT('%', #V_3&;, '%')) OR ((this.email LIKE CONCAT('%', #V_3&;, '%')) OR ((this.phoneNumber LIKE CONCAT('%', #V_3&;, '%')) OR ((this.fax LIKE CONCAT('%', #V_3&;, '%')) OR ((this.reference LIKE CONCAT('%', #V_3&;, '%')) OR ((this.client LIKE CONCAT('%', #V_3&;, '%')) OR ((this.person_in_charge LIKE CONCAT('%', #V_3&;, '%')) OR ((this.address LIKE CONCAT('%', #V_3&;, '%')) OR ((this.postalCode LIKE CONCAT('%', #V_3&;, '%')) OR ((this.city LIKE CONCAT('%', #V_3&;, '%')) OR ((this.personInChargeMail LIKE CONCAT('%', #V_3&;, '%')) OR ((this.tenderZone LIKE CONCAT('%', #V_3&;, '%')) OR ((this.marketObject LIKE CONCAT('%', #V_3&;, '%')) OR ((this.executionPlace LIKE CONCAT('%', #V_3&;, '%')) OR (this.complement 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_depositary.`_oid` AS this_s_depositary, this_s_marketType.`_oid` AS this_s_marketType, this_s_procedureType.`_oid` AS this_s_procedureType, this_s_document.`_oid` AS this_s_document, this.contact AS this_p_contact, this.service AS this_p_service, this.email AS this_p_email, this.phoneNumber AS this_p_phoneNumber, this.fax AS this_p_fax, this.reference AS this_p_reference, this.client AS this_p_client, this.person_in_charge AS this_p_person_in_charge, this.address AS this_p_address, this.postalCode AS this_p_postalCode, this.city AS this_p_city, this.personInChargeMail AS this_p_personInChargeMail, this.tenderZone AS this_p_tenderZone, this.marketObject AS this_p_marketObject, this.issueDate AS this_p_issueDate, this.deadline AS this_p_deadline, this.executionPlace AS this_p_executionPlace, this.complement AS this_p_complement, this_s_depositary.label_fr AS this_s_depositary_p_label_fr, this_s_marketType.label_fr AS this_s_marketType_p_label_fr, this_s_procedureType.label_fr AS this_s_procedureType_p_label_fr, 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 ocsPbm_callForTenders 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_depositary On ((this.depositary = this_s_depositary.`_oid`) AND (this_s_depositary.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_marketType On ((this.marketType = this_s_marketType.`_oid`) AND (this_s_marketType.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_procedureType On ((this.procedureType = this_s_procedureType.`_oid`) AND (this_s_procedureType.iso_sid <> '')) LEFT JOIN alb_resource AS this_s_document On ((this.document = this_s_document.`_oid`) AND (this_s_document.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map(), false, (List) EC.newList(new List()), 5000, null)); ItlEnumerator card__2 = (ItlEnumerator) (e169); 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_s_depositary_p_label_fr"))) { %> <% ITL.show((string)card__2.get("this_s_depositary_p_label_fr"), "string", "html", "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_service"))) { %> <% ITL.show((string)card__2.get("this_p_service"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_email"))) { %> <% ITL.show((string)card__2.get("this_p_email"), "string", "html", "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_fax"))) { %> <% ITL.show((string)card__2.get("this_p_fax"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_reference"))) { %> <% ITL.show((string)card__2.get("this_p_reference"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_s_marketType_p_label_fr"))) { %> <% ITL.show((string)card__2.get("this_s_marketType_p_label_fr"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_s_procedureType_p_label_fr"))) { %> <% ITL.show((string)card__2.get("this_s_procedureType_p_label_fr"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_client"))) { %> <% ITL.show((string)card__2.get("this_p_client"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_person_in_charge"))) { %> <% ITL.show((string)card__2.get("this_p_person_in_charge"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_address"))) { %> <% ITL.show((string)card__2.get("this_p_address"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_postalCode"))) { %> <% ITL.show((string)card__2.get("this_p_postalCode"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_city"))) { %> <% ITL.show((string)card__2.get("this_p_city"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_personInChargeMail"))) { %> <% ITL.show((string)card__2.get("this_p_personInChargeMail"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_tenderZone"))) { %> <% ITL.show((string)card__2.get("this_p_tenderZone"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_marketObject"))) { %> <% ITL.show((string)card__2.get("this_p_marketObject"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((DateTime?)card__2.get("this_p_issueDate"))) { %> ><% ITL.show(EC.itl.format(ITL.D((DateTime?)card__2.get("this_p_issueDate")), "xlsDate", null, "date"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((DateTime?)card__2.get("this_p_deadline"))) { %> ><% ITL.show(EC.itl.format(ITL.D((DateTime?)card__2.get("this_p_deadline")), "xlsDate", null, "date"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_executionPlace"))) { %> <% ITL.show((string)card__2.get("this_p_executionPlace"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_complement"))) { %> <% ITL.show((string)card__2.get("this_p_complement"), "string", "direct", "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(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 (ocsPbm_callForTenders AS c0 INNER JOIN ocsPbm_callForTenders_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 (ocsPbm_callForTenders AS c0 INNER JOIN ocsPbm_callForTenders_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 <% %> Dépositaire Contact Service E-mail Numéro de téléphone Télécopie Référence Type de marché Type de procédure Maître d'ouvrage Nom du responsable Adresse Code Postal Ville E-mail du responsable Zone de diffusion Objet du marché Date de parution Date limite Lieu d'exécution Complément Document Mots-clés <% %> <% ItlEnumerator e279 = new ItlEnumerator("G00010c18_278", null, false); string _t2 = ITL.S(searchFilter__1); e279.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("ocsPbm:callForTenders", @"SELECT this.`_oid` AS this FROM ocsPbm_callForTenders 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 = 'appels_d_offres') AND (#V_0&; OR (this_z.ocsCreationLogin = #V_1&;)) AND (#V_2&; OR ((this.contact LIKE CONCAT('%', #V_3&;, '%')) OR ((this.service LIKE CONCAT('%', #V_3&;, '%')) OR ((this.email LIKE CONCAT('%', #V_3&;, '%')) OR ((this.phoneNumber LIKE CONCAT('%', #V_3&;, '%')) OR ((this.fax LIKE CONCAT('%', #V_3&;, '%')) OR ((this.reference LIKE CONCAT('%', #V_3&;, '%')) OR ((this.client LIKE CONCAT('%', #V_3&;, '%')) OR ((this.person_in_charge LIKE CONCAT('%', #V_3&;, '%')) OR ((this.address LIKE CONCAT('%', #V_3&;, '%')) OR ((this.postalCode LIKE CONCAT('%', #V_3&;, '%')) OR ((this.city LIKE CONCAT('%', #V_3&;, '%')) OR ((this.personInChargeMail LIKE CONCAT('%', #V_3&;, '%')) OR ((this.tenderZone LIKE CONCAT('%', #V_3&;, '%')) OR ((this.marketObject LIKE CONCAT('%', #V_3&;, '%')) OR ((this.executionPlace LIKE CONCAT('%', #V_3&;, '%')) OR (this.complement 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_depositary.`_oid` AS this_s_depositary, this_s_marketType.`_oid` AS this_s_marketType, this_s_procedureType.`_oid` AS this_s_procedureType, this_s_document.`_oid` AS this_s_document, this.contact AS this_p_contact, this.service AS this_p_service, this.email AS this_p_email, this.phoneNumber AS this_p_phoneNumber, this.fax AS this_p_fax, this.reference AS this_p_reference, this.client AS this_p_client, this.person_in_charge AS this_p_person_in_charge, this.address AS this_p_address, this.postalCode AS this_p_postalCode, this.city AS this_p_city, this.personInChargeMail AS this_p_personInChargeMail, this.tenderZone AS this_p_tenderZone, this.marketObject AS this_p_marketObject, this.issueDate AS this_p_issueDate, this.deadline AS this_p_deadline, this.executionPlace AS this_p_executionPlace, this.complement AS this_p_complement, this_s_depositary.label_fr AS this_s_depositary_p_label_fr, this_s_marketType.label_fr AS this_s_marketType_p_label_fr, this_s_procedureType.label_fr AS this_s_procedureType_p_label_fr, 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 ocsPbm_callForTenders 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_depositary On ((this.depositary = this_s_depositary.`_oid`) AND (this_s_depositary.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_marketType On ((this.marketType = this_s_marketType.`_oid`) AND (this_s_marketType.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_procedureType On ((this.procedureType = this_s_procedureType.`_oid`) AND (this_s_procedureType.iso_sid <> '')) LEFT JOIN alb_resource AS this_s_document On ((this.document = this_s_document.`_oid`) AND (this_s_document.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map(), false, (List) EC.newList(new List()), 5000, null)); ItlEnumerator card__3 = (ItlEnumerator) (e279); 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_s_depositary_p_label_fr"))) { %> <% ITL.show((string)card__3.get("this_s_depositary_p_label_fr"), "string", "html", "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_service"))) { %> <% ITL.show((string)card__3.get("this_p_service"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_email"))) { %> <% ITL.show((string)card__3.get("this_p_email"), "string", "html", "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_fax"))) { %> <% ITL.show((string)card__3.get("this_p_fax"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_reference"))) { %> <% ITL.show((string)card__3.get("this_p_reference"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_s_marketType_p_label_fr"))) { %> <% ITL.show((string)card__3.get("this_s_marketType_p_label_fr"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_s_procedureType_p_label_fr"))) { %> <% ITL.show((string)card__3.get("this_s_procedureType_p_label_fr"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_client"))) { %> <% ITL.show((string)card__3.get("this_p_client"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_person_in_charge"))) { %> <% ITL.show((string)card__3.get("this_p_person_in_charge"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_address"))) { %> <% ITL.show((string)card__3.get("this_p_address"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_postalCode"))) { %> <% ITL.show((string)card__3.get("this_p_postalCode"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_city"))) { %> <% ITL.show((string)card__3.get("this_p_city"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_personInChargeMail"))) { %> <% ITL.show((string)card__3.get("this_p_personInChargeMail"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_tenderZone"))) { %> <% ITL.show((string)card__3.get("this_p_tenderZone"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_marketObject"))) { %> <% ITL.show((string)card__3.get("this_p_marketObject"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((DateTime?)card__3.get("this_p_issueDate"))) { %> ><% ITL.show(EC.itl.format(ITL.D((DateTime?)card__3.get("this_p_issueDate")), "xlsDate", null, "date"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((DateTime?)card__3.get("this_p_deadline"))) { %> ><% ITL.show(EC.itl.format(ITL.D((DateTime?)card__3.get("this_p_deadline")), "xlsDate", null, "date"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_executionPlace"))) { %> <% ITL.show((string)card__3.get("this_p_executionPlace"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_complement"))) { %> <% ITL.show((string)card__3.get("this_p_complement"), "string", "direct", "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(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 (ocsPbm_callForTenders AS c0 INNER JOIN ocsPbm_callForTenders_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 (ocsPbm_callForTenders AS c0 INNER JOIN ocsPbm_callForTenders_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 <% %> Dépositaire Contact Service E-mail Numéro de téléphone Télécopie Référence Type de marché Type de procédure Maître d'ouvrage Nom du responsable Adresse Code Postal Ville E-mail du responsable Zone de diffusion Objet du marché Date de parution Date limite Lieu d'exécution Complément Document Mots-clés <% %> <% ItlEnumerator e389 = new ItlEnumerator("G00010c18_388", null, false); e389.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("ocsPbm:callForTenders", @"SELECT this.`_oid` AS this FROM ocsPbm_callForTenders 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_depositary.`_oid` AS this_s_depositary, this_s_marketType.`_oid` AS this_s_marketType, this_s_procedureType.`_oid` AS this_s_procedureType, this_s_document.`_oid` AS this_s_document, this.contact AS this_p_contact, this.service AS this_p_service, this.email AS this_p_email, this.phoneNumber AS this_p_phoneNumber, this.fax AS this_p_fax, this.reference AS this_p_reference, this.client AS this_p_client, this.person_in_charge AS this_p_person_in_charge, this.address AS this_p_address, this.postalCode AS this_p_postalCode, this.city AS this_p_city, this.personInChargeMail AS this_p_personInChargeMail, this.tenderZone AS this_p_tenderZone, this.marketObject AS this_p_marketObject, this.issueDate AS this_p_issueDate, this.deadline AS this_p_deadline, this.executionPlace AS this_p_executionPlace, this.complement AS this_p_complement, this_s_depositary.label_fr AS this_s_depositary_p_label_fr, this_s_marketType.label_fr AS this_s_marketType_p_label_fr, this_s_procedureType.label_fr AS this_s_procedureType_p_label_fr, 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 ocsPbm_callForTenders 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_depositary On ((this.depositary = this_s_depositary.`_oid`) AND (this_s_depositary.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_marketType On ((this.marketType = this_s_marketType.`_oid`) AND (this_s_marketType.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_procedureType On ((this.procedureType = this_s_procedureType.`_oid`) AND (this_s_procedureType.iso_sid <> '')) LEFT JOIN alb_resource AS this_s_document On ((this.document = this_s_document.`_oid`) AND (this_s_document.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map(), false, (List) EC.newList(new List()), 5000, null)); ItlEnumerator card__4 = (ItlEnumerator) (e389); 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_s_depositary_p_label_fr"))) { %> <% ITL.show((string)card__4.get("this_s_depositary_p_label_fr"), "string", "html", "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_service"))) { %> <% ITL.show((string)card__4.get("this_p_service"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_email"))) { %> <% ITL.show((string)card__4.get("this_p_email"), "string", "html", "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_fax"))) { %> <% ITL.show((string)card__4.get("this_p_fax"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_reference"))) { %> <% ITL.show((string)card__4.get("this_p_reference"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_s_marketType_p_label_fr"))) { %> <% ITL.show((string)card__4.get("this_s_marketType_p_label_fr"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_s_procedureType_p_label_fr"))) { %> <% ITL.show((string)card__4.get("this_s_procedureType_p_label_fr"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_client"))) { %> <% ITL.show((string)card__4.get("this_p_client"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_person_in_charge"))) { %> <% ITL.show((string)card__4.get("this_p_person_in_charge"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_address"))) { %> <% ITL.show((string)card__4.get("this_p_address"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_postalCode"))) { %> <% ITL.show((string)card__4.get("this_p_postalCode"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_city"))) { %> <% ITL.show((string)card__4.get("this_p_city"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_personInChargeMail"))) { %> <% ITL.show((string)card__4.get("this_p_personInChargeMail"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_tenderZone"))) { %> <% ITL.show((string)card__4.get("this_p_tenderZone"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_marketObject"))) { %> <% ITL.show((string)card__4.get("this_p_marketObject"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((DateTime?)card__4.get("this_p_issueDate"))) { %> ><% ITL.show(EC.itl.format(ITL.D((DateTime?)card__4.get("this_p_issueDate")), "xlsDate", null, "date"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((DateTime?)card__4.get("this_p_deadline"))) { %> ><% ITL.show(EC.itl.format(ITL.D((DateTime?)card__4.get("this_p_deadline")), "xlsDate", null, "date"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_executionPlace"))) { %> <% ITL.show((string)card__4.get("this_p_executionPlace"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_complement"))) { %> <% ITL.show((string)card__4.get("this_p_complement"), "string", "direct", "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(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 (ocsPbm_callForTenders AS c0 INNER JOIN ocsPbm_callForTenders_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 (ocsPbm_callForTenders AS c0 INNER JOIN ocsPbm_callForTenders_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(); %>
<% %> <% } %>