<%@ Page Language="C#" Buffer="true" CodeFile="xls0001137e.aspx.cs" Inherits="_xls0001137e" 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("ocsCol:association", @"SELECT this.`_oid` AS this FROM ocsCol_association 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:ocsCol:association", "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 = 'commerces')", new Map(),false)); bool useValidation = (bool) (ITL.b((bool?)catalogObject.get("this_p_useValidation"))); bool hasNewCardRight = (bool) (EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c0.`_oid` AS origin, this.label_fr AS this_p_label_fr, this.`_oid` AS this, this.`_oid` AS data FROM xrm_category AS this INNER JOIN (ocs_catalog AS c0 INNER JOIN ocs_catalog_redactionRights AS c0_l On ((c0.`_oid` = c0_l.`_from`) AND (c0.iso_sid <> '') AND (c0.`_oid` = #V_0&;))) On ((this.`_oid` = c0_l.`_to`) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.`_oid` IN (#V_1&;))) AS this", new Map("#V_0&;|integer", (int?)catalogObject.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0); bool? hasValidateRight = (bool?) (ITL.b(useValidation)?EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c0.`_oid` AS origin, this.label_fr AS this_p_label_fr, this.`_oid` AS this, this.`_oid` AS data FROM xrm_category AS this INNER JOIN (ocs_catalog AS c0 INNER JOIN ocs_catalog_validationRights AS c0_l On ((c0.`_oid` = c0_l.`_from`) AND (c0.iso_sid <> '') AND (c0.`_oid` = #V_0&;))) On ((this.`_oid` = c0_l.`_to`) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.`_oid` IN (#V_1&;))) AS this", new Map("#V_0&;|integer", (int?)catalogObject.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0:hasNewCardRight); int? statusFilter__1 = (int?) ((int?)EC.itl.getParameterValue("integer", "statusFilter")); string cardType = (string) ((string)EC.itl.getParameterValue("string", "cardType")); string searchFilter__1 = (string) ((string)EC.itl.getParameterValue("string", "searchFilter")); string creatorFilter__1 = (string) ((string)EC.itl.getParameterValue("string", "creatorFilter")); if(statusFilter__1 == -1) { if(cardType != "archive") { string init = (string) (EC.itl.sdsInitXlsWorksheetNames()); ITL.show(EC.itl.addHeader("Content-Disposition", ("attachment; filename=classeur" + ".xls")) + EC.itl.addHeader("Content-Type", "application/vnd.ms-excel"), "string", "raw", "string"); EC.Page.Response.ContentEncoding = System.Text.Encoding.UTF8; ITL.show((((((ITL.b(EC.itl.now())?"":"") + "\n\n", "string", "raw", "string"); %> > <% %> <% %> État <% %> Libellé Date de création Objet Siège social Nom du responsable Titre du responsable Adresse Contact Numéro de téléphone Téléphone mobile Télécopie E-mail Site internet Commentaire Illustration Mots-clés Lettre <% %> <% ItlEnumerator e47 = new ItlEnumerator("G0001137e_46", null, false); string _t0 = ITL.S(searchFilter__1); e47.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("ocsCol:association", @"SELECT this.`_oid` AS this FROM ocsCol_association 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 = 'commerces') AND (#V_0&; OR (this_z.ocsCreationLogin = #V_1&;)) AND (#V_2&; OR ((this.title LIKE CONCAT('%', #V_3&;, '%')) OR ((this.object LIKE CONCAT('%', #V_3&;, '%')) OR ((this.headOffice LIKE CONCAT('%', #V_3&;, '%')) OR ((this.person_in_charge LIKE CONCAT('%', #V_3&;, '%')) OR ((this.person_title LIKE CONCAT('%', #V_3&;, '%')) OR ((this.address LIKE CONCAT('%', #V_3&;, '%')) OR ((this.contact LIKE CONCAT('%', #V_3&;, '%')) OR ((this.phoneNumber LIKE CONCAT('%', #V_3&;, '%')) OR ((this.mobilePhone LIKE CONCAT('%', #V_3&;, '%')) OR ((this.fax LIKE CONCAT('%', #V_3&;, '%')) OR ((this.email LIKE CONCAT('%', #V_3&;, '%')) OR (this.website 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_image.`_oid` AS this_s_image, this.title AS this_p_title, this.creationDate AS this_p_creationDate, this.object AS this_p_object, this.headOffice AS this_p_headOffice, this.person_in_charge AS this_p_person_in_charge, this.person_title AS this_p_person_title, this.address AS this_p_address, this.contact AS this_p_contact, this.phoneNumber AS this_p_phoneNumber, this.mobilePhone AS this_p_mobilePhone, this.fax AS this_p_fax, this.email AS this_p_email, this.website AS this_p_website, this.comment AS this_p_comment, this_s_image_z.filename AS this_s_image_z_p_filename, this_s_image_z.extension AS this_s_image_z_p_extension, this_z.ocsStatus AS this_z_p_ocsStatus FROM ocsCol_association AS this INNER JOIN ocs_card AS this_z On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) LEFT JOIN (alb_image AS this_s_image INNER JOIN alb_resource AS this_s_image_z On ((this_s_image.`_oid` = this_s_image_z.`_oid`) AND (this_s_image_z.iso_sid <> ''))) On ((this.image = this_s_image.`_oid`) AND (this_s_image.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map(), false, (List) EC.newList(new List()), 5000, null)); ItlEnumerator card__1 = (ItlEnumerator) (e47); card__1.reset(); if(card__1.isNotEmpty()) { card__1.resetGroup(); for(card__1.start();card__1.test();card__1.fetch()) { ItlEnumerator row = (ItlEnumerator) (card__1); if(row.position() % 10 == 9) { EC.Page.Response.Flush(); Response.BufferOutput = false; } %> <% if(ITL.isNotNull(((int?)card__1.get("this_z_p_ocsStatus") == 0?"En rédaction":((int?)card__1.get("this_z_p_ocsStatus") == 1?"A valider":((int?)card__1.get("this_z_p_ocsStatus") == 2?"Publiée":"Archivée")))) && ((int?)card__1.get("this_z_p_ocsStatus") == 0?"En rédaction":((int?)card__1.get("this_z_p_ocsStatus") == 1?"A valider":((int?)card__1.get("this_z_p_ocsStatus") == 2?"Publiée":"Archivée"))) != "") { %> <% ITL.show((int?)card__1.get("this_z_p_ocsStatus") == 0?"En rédaction":((int?)card__1.get("this_z_p_ocsStatus") == 1?"A valider":((int?)card__1.get("this_z_p_ocsStatus") == 2?"Publiée":"Archivée")), "string", "html", "string"); %> <% } %> <% %> <% if(ITL.isNotNull((string)card__1.get("this_p_title"))) { %> <% ITL.show((string)card__1.get("this_p_title"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((DateTime?)card__1.get("this_p_creationDate"))) { %> ><% ITL.show(EC.itl.format(ITL.D((DateTime?)card__1.get("this_p_creationDate")), "xlsDate", null, "date"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_object"))) { %> <% ITL.show((string)card__1.get("this_p_object"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_headOffice"))) { %> <% ITL.show((string)card__1.get("this_p_headOffice"), "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_person_title"))) { %> <% ITL.show((string)card__1.get("this_p_person_title"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_address"))) { %> <% ITL.show((string)card__1.get("this_p_address"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_contact"))) { %> <% ITL.show((string)card__1.get("this_p_contact"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_phoneNumber"))) { %> <% ITL.show((string)card__1.get("this_p_phoneNumber"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_mobilePhone"))) { %> <% ITL.show((string)card__1.get("this_p_mobilePhone"), "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_email"))) { %> <% ITL.show((string)card__1.get("this_p_email"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_website"))) { %> <% ITL.show((string)card__1.get("this_p_website"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__1.get("this_p_comment"))) { %> <% ITL.show((string)card__1.get("this_p_comment"), "string", "direct", "string"); %> <% } %> <% if(ITL.isNotNull((ITL.S((string)card__1.get("this_s_image_z_p_filename")) + " " + ITL.S((string)card__1.get("this_s_image_z_p_extension"))))) { %> <% ITL.show(ITL.S((string)card__1.get("this_s_image_z_p_filename")) + " " + ITL.S((string)card__1.get("this_s_image_z_p_extension")), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull(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 (ocsCol_association AS c0 INNER JOIN ocsCol_association_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 (ocsCol_association AS c0 INNER JOIN ocsCol_association_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"); %> <% } %> <% if(ITL.isNotNull(EC.itl.stringSubstr(ITL.S((string)card__1.get("this_p_title")),0, 1).ToUpper())) { %> <% ITL.show(EC.itl.stringSubstr(ITL.S((string)card__1.get("this_p_title")),0, 1).ToUpper(), "string", "html", "string"); %> <% } %> <% %> <% } } card__1.finish(); %>
<% %> <% } else { string init__1 = (string) (EC.itl.sdsInitXlsWorksheetNames()); ITL.show(EC.itl.addHeader("Content-Disposition", ("attachment; filename=classeur" + ".xls")) + EC.itl.addHeader("Content-Type", "application/vnd.ms-excel"), "string", "raw", "string"); EC.Page.Response.ContentEncoding = System.Text.Encoding.UTF8; ITL.show((((((ITL.b(EC.itl.now())?"":"") + "\n\n", "string", "raw", "string"); %> > <% %> <% %> État <% %> Libellé Date de création Objet Siège social Nom du responsable Titre du responsable Adresse Contact Numéro de téléphone Téléphone mobile Télécopie E-mail Site internet Commentaire Illustration Mots-clés Lettre <% %> <% ItlEnumerator e133 = new ItlEnumerator("G0001137e_132", null, false); string _t1 = ITL.S(searchFilter__1); e133.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("ocsCol:association", @"SELECT this.`_oid` AS this FROM ocsCol_association 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 = 'commerces') AND (#V_0&; OR (this_z.ocsCreationLogin = #V_1&;)) AND (#V_2&; OR ((this.title LIKE CONCAT('%', #V_3&;, '%')) OR ((this.object LIKE CONCAT('%', #V_3&;, '%')) OR ((this.headOffice LIKE CONCAT('%', #V_3&;, '%')) OR ((this.person_in_charge LIKE CONCAT('%', #V_3&;, '%')) OR ((this.person_title LIKE CONCAT('%', #V_3&;, '%')) OR ((this.address LIKE CONCAT('%', #V_3&;, '%')) OR ((this.contact LIKE CONCAT('%', #V_3&;, '%')) OR ((this.phoneNumber LIKE CONCAT('%', #V_3&;, '%')) OR ((this.mobilePhone LIKE CONCAT('%', #V_3&;, '%')) OR ((this.fax LIKE CONCAT('%', #V_3&;, '%')) OR ((this.email LIKE CONCAT('%', #V_3&;, '%')) OR (this.website 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_image.`_oid` AS this_s_image, this.title AS this_p_title, this.creationDate AS this_p_creationDate, this.object AS this_p_object, this.headOffice AS this_p_headOffice, this.person_in_charge AS this_p_person_in_charge, this.person_title AS this_p_person_title, this.address AS this_p_address, this.contact AS this_p_contact, this.phoneNumber AS this_p_phoneNumber, this.mobilePhone AS this_p_mobilePhone, this.fax AS this_p_fax, this.email AS this_p_email, this.website AS this_p_website, this.comment AS this_p_comment, this_s_image_z.filename AS this_s_image_z_p_filename, this_s_image_z.extension AS this_s_image_z_p_extension, this_z.ocsStatus AS this_z_p_ocsStatus FROM ocsCol_association AS this INNER JOIN ocs_card AS this_z On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) LEFT JOIN (alb_image AS this_s_image INNER JOIN alb_resource AS this_s_image_z On ((this_s_image.`_oid` = this_s_image_z.`_oid`) AND (this_s_image_z.iso_sid <> ''))) On ((this.image = this_s_image.`_oid`) AND (this_s_image.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map(), false, (List) EC.newList(new List()), 5000, null)); ItlEnumerator card__2 = (ItlEnumerator) (e133); card__2.reset(); if(card__2.isNotEmpty()) { card__2.resetGroup(); for(card__2.start();card__2.test();card__2.fetch()) { ItlEnumerator row__1 = (ItlEnumerator) (card__2); if(row__1.position() % 10 == 9) { EC.Page.Response.Flush(); Response.BufferOutput = false; } %> <% if(ITL.isNotNull(((int?)card__2.get("this_z_p_ocsStatus") == 0?"En rédaction":((int?)card__2.get("this_z_p_ocsStatus") == 1?"A valider":((int?)card__2.get("this_z_p_ocsStatus") == 2?"Publiée":"Archivée")))) && ((int?)card__2.get("this_z_p_ocsStatus") == 0?"En rédaction":((int?)card__2.get("this_z_p_ocsStatus") == 1?"A valider":((int?)card__2.get("this_z_p_ocsStatus") == 2?"Publiée":"Archivée"))) != "") { %> <% ITL.show((int?)card__2.get("this_z_p_ocsStatus") == 0?"En rédaction":((int?)card__2.get("this_z_p_ocsStatus") == 1?"A valider":((int?)card__2.get("this_z_p_ocsStatus") == 2?"Publiée":"Archivée")), "string", "html", "string"); %> <% } %> <% %> <% if(ITL.isNotNull((string)card__2.get("this_p_title"))) { %> <% ITL.show((string)card__2.get("this_p_title"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((DateTime?)card__2.get("this_p_creationDate"))) { %> ><% ITL.show(EC.itl.format(ITL.D((DateTime?)card__2.get("this_p_creationDate")), "xlsDate", null, "date"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_object"))) { %> <% ITL.show((string)card__2.get("this_p_object"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_headOffice"))) { %> <% ITL.show((string)card__2.get("this_p_headOffice"), "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_person_title"))) { %> <% ITL.show((string)card__2.get("this_p_person_title"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_address"))) { %> <% ITL.show((string)card__2.get("this_p_address"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_contact"))) { %> <% ITL.show((string)card__2.get("this_p_contact"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_phoneNumber"))) { %> <% ITL.show((string)card__2.get("this_p_phoneNumber"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_mobilePhone"))) { %> <% ITL.show((string)card__2.get("this_p_mobilePhone"), "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_email"))) { %> <% ITL.show((string)card__2.get("this_p_email"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_website"))) { %> <% ITL.show((string)card__2.get("this_p_website"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__2.get("this_p_comment"))) { %> <% ITL.show((string)card__2.get("this_p_comment"), "string", "direct", "string"); %> <% } %> <% if(ITL.isNotNull((ITL.S((string)card__2.get("this_s_image_z_p_filename")) + " " + ITL.S((string)card__2.get("this_s_image_z_p_extension"))))) { %> <% ITL.show(ITL.S((string)card__2.get("this_s_image_z_p_filename")) + " " + ITL.S((string)card__2.get("this_s_image_z_p_extension")), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull(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 (ocsCol_association AS c0 INNER JOIN ocsCol_association_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 (ocsCol_association AS c0 INNER JOIN ocsCol_association_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"); %> <% } %> <% if(ITL.isNotNull(EC.itl.stringSubstr(ITL.S((string)card__2.get("this_p_title")),0, 1).ToUpper())) { %> <% ITL.show(EC.itl.stringSubstr(ITL.S((string)card__2.get("this_p_title")),0, 1).ToUpper(), "string", "html", "string"); %> <% } %> <% %> <% } } card__2.finish(); %>
<% %> <% } } else { string init__2 = (string) (EC.itl.sdsInitXlsWorksheetNames()); ITL.show(EC.itl.addHeader("Content-Disposition", ("attachment; filename=classeur" + ".xls")) + EC.itl.addHeader("Content-Type", "application/vnd.ms-excel"), "string", "raw", "string"); EC.Page.Response.ContentEncoding = System.Text.Encoding.UTF8; ITL.show((((((ITL.b(EC.itl.now())?"":"") + "\n\n", "string", "raw", "string"); %> > <% %> <% %> État <% %> Libellé Date de création Objet Siège social Nom du responsable Titre du responsable Adresse Contact Numéro de téléphone Téléphone mobile Télécopie E-mail Site internet Commentaire Illustration Mots-clés Lettre <% %> <% ItlEnumerator e219 = new ItlEnumerator("G0001137e_218", null, false); string _t2 = ITL.S(searchFilter__1); e219.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("ocsCol:association", @"SELECT this.`_oid` AS this FROM ocsCol_association 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 = 'commerces') AND (#V_0&; OR (this_z.ocsCreationLogin = #V_1&;)) AND (#V_2&; OR ((this.title LIKE CONCAT('%', #V_3&;, '%')) OR ((this.object LIKE CONCAT('%', #V_3&;, '%')) OR ((this.headOffice LIKE CONCAT('%', #V_3&;, '%')) OR ((this.person_in_charge LIKE CONCAT('%', #V_3&;, '%')) OR ((this.person_title LIKE CONCAT('%', #V_3&;, '%')) OR ((this.address LIKE CONCAT('%', #V_3&;, '%')) OR ((this.contact LIKE CONCAT('%', #V_3&;, '%')) OR ((this.phoneNumber LIKE CONCAT('%', #V_3&;, '%')) OR ((this.mobilePhone LIKE CONCAT('%', #V_3&;, '%')) OR ((this.fax LIKE CONCAT('%', #V_3&;, '%')) OR ((this.email LIKE CONCAT('%', #V_3&;, '%')) OR (this.website 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_image.`_oid` AS this_s_image, this.title AS this_p_title, this.creationDate AS this_p_creationDate, this.object AS this_p_object, this.headOffice AS this_p_headOffice, this.person_in_charge AS this_p_person_in_charge, this.person_title AS this_p_person_title, this.address AS this_p_address, this.contact AS this_p_contact, this.phoneNumber AS this_p_phoneNumber, this.mobilePhone AS this_p_mobilePhone, this.fax AS this_p_fax, this.email AS this_p_email, this.website AS this_p_website, this.comment AS this_p_comment, this_s_image_z.filename AS this_s_image_z_p_filename, this_s_image_z.extension AS this_s_image_z_p_extension, this_z.ocsStatus AS this_z_p_ocsStatus FROM ocsCol_association AS this INNER JOIN ocs_card AS this_z On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) LEFT JOIN (alb_image AS this_s_image INNER JOIN alb_resource AS this_s_image_z On ((this_s_image.`_oid` = this_s_image_z.`_oid`) AND (this_s_image_z.iso_sid <> ''))) On ((this.image = this_s_image.`_oid`) AND (this_s_image.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map(), false, (List) EC.newList(new List()), 5000, null)); ItlEnumerator card__3 = (ItlEnumerator) (e219); card__3.reset(); if(card__3.isNotEmpty()) { card__3.resetGroup(); for(card__3.start();card__3.test();card__3.fetch()) { ItlEnumerator row__2 = (ItlEnumerator) (card__3); if(row__2.position() % 10 == 9) { EC.Page.Response.Flush(); Response.BufferOutput = false; } %> <% if(ITL.isNotNull(((int?)card__3.get("this_z_p_ocsStatus") == 0?"En rédaction":((int?)card__3.get("this_z_p_ocsStatus") == 1?"A valider":((int?)card__3.get("this_z_p_ocsStatus") == 2?"Publiée":"Archivée")))) && ((int?)card__3.get("this_z_p_ocsStatus") == 0?"En rédaction":((int?)card__3.get("this_z_p_ocsStatus") == 1?"A valider":((int?)card__3.get("this_z_p_ocsStatus") == 2?"Publiée":"Archivée"))) != "") { %> <% ITL.show((int?)card__3.get("this_z_p_ocsStatus") == 0?"En rédaction":((int?)card__3.get("this_z_p_ocsStatus") == 1?"A valider":((int?)card__3.get("this_z_p_ocsStatus") == 2?"Publiée":"Archivée")), "string", "html", "string"); %> <% } %> <% %> <% if(ITL.isNotNull((string)card__3.get("this_p_title"))) { %> <% ITL.show((string)card__3.get("this_p_title"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((DateTime?)card__3.get("this_p_creationDate"))) { %> ><% ITL.show(EC.itl.format(ITL.D((DateTime?)card__3.get("this_p_creationDate")), "xlsDate", null, "date"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_object"))) { %> <% ITL.show((string)card__3.get("this_p_object"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_headOffice"))) { %> <% ITL.show((string)card__3.get("this_p_headOffice"), "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_person_title"))) { %> <% ITL.show((string)card__3.get("this_p_person_title"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_address"))) { %> <% ITL.show((string)card__3.get("this_p_address"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_contact"))) { %> <% ITL.show((string)card__3.get("this_p_contact"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_phoneNumber"))) { %> <% ITL.show((string)card__3.get("this_p_phoneNumber"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_mobilePhone"))) { %> <% ITL.show((string)card__3.get("this_p_mobilePhone"), "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_email"))) { %> <% ITL.show((string)card__3.get("this_p_email"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_website"))) { %> <% ITL.show((string)card__3.get("this_p_website"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__3.get("this_p_comment"))) { %> <% ITL.show((string)card__3.get("this_p_comment"), "string", "direct", "string"); %> <% } %> <% if(ITL.isNotNull((ITL.S((string)card__3.get("this_s_image_z_p_filename")) + " " + ITL.S((string)card__3.get("this_s_image_z_p_extension"))))) { %> <% ITL.show(ITL.S((string)card__3.get("this_s_image_z_p_filename")) + " " + ITL.S((string)card__3.get("this_s_image_z_p_extension")), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull(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 (ocsCol_association AS c0 INNER JOIN ocsCol_association_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 (ocsCol_association AS c0 INNER JOIN ocsCol_association_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"); %> <% } %> <% if(ITL.isNotNull(EC.itl.stringSubstr(ITL.S((string)card__3.get("this_p_title")),0, 1).ToUpper())) { %> <% ITL.show(EC.itl.stringSubstr(ITL.S((string)card__3.get("this_p_title")),0, 1).ToUpper(), "string", "html", "string"); %> <% } %> <% %> <% } } card__3.finish(); %>
<% %> <% } catalogObject.close(); } else { string init__3 = (string) (EC.itl.sdsInitXlsWorksheetNames()); ITL.show(EC.itl.addHeader("Content-Disposition", ("attachment; filename=classeur" + ".xls")) + EC.itl.addHeader("Content-Type", "application/vnd.ms-excel"), "string", "raw", "string"); EC.Page.Response.ContentEncoding = System.Text.Encoding.UTF8; ITL.show((((((ITL.b(EC.itl.now())?"":"") + "\n\n", "string", "raw", "string"); %> > <% %> <% %> État <% %> Libellé Date de création Objet Siège social Nom du responsable Titre du responsable Adresse Contact Numéro de téléphone Téléphone mobile Télécopie E-mail Site internet Commentaire Illustration Mots-clés Lettre <% %> <% ItlEnumerator e305 = new ItlEnumerator("G0001137e_304", null, false); e305.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("ocsCol:association", @"SELECT this.`_oid` AS this FROM ocsCol_association 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_image.`_oid` AS this_s_image, this.title AS this_p_title, this.creationDate AS this_p_creationDate, this.object AS this_p_object, this.headOffice AS this_p_headOffice, this.person_in_charge AS this_p_person_in_charge, this.person_title AS this_p_person_title, this.address AS this_p_address, this.contact AS this_p_contact, this.phoneNumber AS this_p_phoneNumber, this.mobilePhone AS this_p_mobilePhone, this.fax AS this_p_fax, this.email AS this_p_email, this.website AS this_p_website, this.comment AS this_p_comment, this_s_image_z.filename AS this_s_image_z_p_filename, this_s_image_z.extension AS this_s_image_z_p_extension, this_z.ocsStatus AS this_z_p_ocsStatus FROM ocsCol_association AS this INNER JOIN ocs_card AS this_z On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) LEFT JOIN (alb_image AS this_s_image INNER JOIN alb_resource AS this_s_image_z On ((this_s_image.`_oid` = this_s_image_z.`_oid`) AND (this_s_image_z.iso_sid <> ''))) On ((this.image = this_s_image.`_oid`) AND (this_s_image.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map(), false, (List) EC.newList(new List()), 5000, null)); ItlEnumerator card__4 = (ItlEnumerator) (e305); card__4.reset(); if(card__4.isNotEmpty()) { card__4.resetGroup(); for(card__4.start();card__4.test();card__4.fetch()) { ItlEnumerator row__3 = (ItlEnumerator) (card__4); if(row__3.position() % 10 == 9) { EC.Page.Response.Flush(); Response.BufferOutput = false; } %> <% if(ITL.isNotNull(((int?)card__4.get("this_z_p_ocsStatus") == 0?"En rédaction":((int?)card__4.get("this_z_p_ocsStatus") == 1?"A valider":((int?)card__4.get("this_z_p_ocsStatus") == 2?"Publiée":"Archivée")))) && ((int?)card__4.get("this_z_p_ocsStatus") == 0?"En rédaction":((int?)card__4.get("this_z_p_ocsStatus") == 1?"A valider":((int?)card__4.get("this_z_p_ocsStatus") == 2?"Publiée":"Archivée"))) != "") { %> <% ITL.show((int?)card__4.get("this_z_p_ocsStatus") == 0?"En rédaction":((int?)card__4.get("this_z_p_ocsStatus") == 1?"A valider":((int?)card__4.get("this_z_p_ocsStatus") == 2?"Publiée":"Archivée")), "string", "html", "string"); %> <% } %> <% %> <% if(ITL.isNotNull((string)card__4.get("this_p_title"))) { %> <% ITL.show((string)card__4.get("this_p_title"), "string", "html", "string"); %> <% } %> > <% if(ITL.isNotNull((DateTime?)card__4.get("this_p_creationDate"))) { %> ><% ITL.show(EC.itl.format(ITL.D((DateTime?)card__4.get("this_p_creationDate")), "xlsDate", null, "date"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_object"))) { %> <% ITL.show((string)card__4.get("this_p_object"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_headOffice"))) { %> <% ITL.show((string)card__4.get("this_p_headOffice"), "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_person_title"))) { %> <% ITL.show((string)card__4.get("this_p_person_title"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_address"))) { %> <% ITL.show((string)card__4.get("this_p_address"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_contact"))) { %> <% ITL.show((string)card__4.get("this_p_contact"), "string", "memo", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_phoneNumber"))) { %> <% ITL.show((string)card__4.get("this_p_phoneNumber"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_mobilePhone"))) { %> <% ITL.show((string)card__4.get("this_p_mobilePhone"), "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_email"))) { %> <% ITL.show((string)card__4.get("this_p_email"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_website"))) { %> <% ITL.show((string)card__4.get("this_p_website"), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull((string)card__4.get("this_p_comment"))) { %> <% ITL.show((string)card__4.get("this_p_comment"), "string", "direct", "string"); %> <% } %> <% if(ITL.isNotNull((ITL.S((string)card__4.get("this_s_image_z_p_filename")) + " " + ITL.S((string)card__4.get("this_s_image_z_p_extension"))))) { %> <% ITL.show(ITL.S((string)card__4.get("this_s_image_z_p_filename")) + " " + ITL.S((string)card__4.get("this_s_image_z_p_extension")), "string", "html", "string"); %> <% } %> <% if(ITL.isNotNull(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 (ocsCol_association AS c0 INNER JOIN ocsCol_association_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 (ocsCol_association AS c0 INNER JOIN ocsCol_association_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"); %> <% } %> <% if(ITL.isNotNull(EC.itl.stringSubstr(ITL.S((string)card__4.get("this_p_title")),0, 1).ToUpper())) { %> <% ITL.show(EC.itl.stringSubstr(ITL.S((string)card__4.get("this_p_title")),0, 1).ToUpper(), "string", "html", "string"); %> <% } %> <% %> <% } } card__4.finish(); %>
<% %> <% } %>