<%@ Page Language="C#" Buffer="true" CodeFile="gestion_entreprises.aspx.cs" Inherits="_gestion_entreprises" CodePage="65001" UICulture="fr" Culture="fr-FR" ValidateRequest="false" %> <%@ 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"; %><% 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)); %> " /> Entreprises

Annuaires

<% if (EC.currentUser != null) { EC.Page.Response.Write(EC.itl.login()); EC.Page.Response.Write(" "); } { DateTime date = DateTime.Now; EC.Page.Response.Write(EC.itl.formatTimestamp(date, "date")); EC.Page.Response.Write(" "); EC.Page.Response.Write(EC.itl.formatTimestamp(date, "hours")); } %>


  • Accueil
    • <% if(ItlRuntime.XRM.AuthorizeUtils.isAllowed("00000000")) { %>
  • Associations
    • <% } else { %><% } %><% if(ItlRuntime.XRM.AuthorizeUtils.isAllowed("00000000")) { %>
  • Commerces
    • <% } else { %><% } %><% if(ItlRuntime.XRM.AuthorizeUtils.isAllowed("00000000")) { %>
  • Entreprises
    • <% } else { %><% } %><% if(ItlRuntime.XRM.AuthorizeUtils.isAllowed("00000000")) { %>
  • Hébergement
    • <% } else { %><% } %><% if(ItlRuntime.XRM.AuthorizeUtils.isAllowed("00000000")) { %>
  • Restauration
    • <% } else { %><% } %>
 
<% string mode__1 = (string) ((string)EC.itl.getParameterValue("string", "mode", "list")); string cmd = (string) ((string)EC.itl.getParameterValue("string", "cmd")); string oids = (string) ((string)EC.itl.getParameterValue("string", "oids")); int? newStatus = (int?) ((int?)EC.itl.getParameterValue("integer", "newStatus")); string action__1 = (string) ((string)EC.itl.getParameterValue("string", "action", "")); string cardType = (string) ((string)EC.itl.getParameterValue("string", "cardType", "current")); int? statusFilter__1 = (int?) ((int?)EC.itl.getParameterValue("integer", "statusFilter", -1)); string searchFilter__1 = (string) ((string)EC.itl.getParameterValue("string", "searchFilter", "")); string logComment__1 = (string) ((string)EC.itl.getParameterValue("string", "logComment")); string creatorFilter__1 = (string) ((string)EC.itl.getParameterValue("string", "creatorFilter", "")); string ocsNotificationForActionMessage__1 = (string) ((string)EC.itl.getParameterValue("string", "ocsNotificationForActionMessage")); string ocsNotificationForInfoMessage__1 = (string) ((string)EC.itl.getParameterValue("string", "ocsNotificationForInfoMessage")); string ocsNotificationForActionMailSubject = (string) ((string)EC.itl.getParameterValue("string", "ocsNotificationForActionMailSubject")); string ocsNotificationForInfoMailSubject = (string) ((string)EC.itl.getParameterValue("string", "ocsNotificationForInfoMailSubject")); SqlObject card__1 = (SqlObject) (new SqlObject("ocsCol:association", @"SELECT this.`_oid` AS this, this_z_s_ocsCatalog.`_oid` AS this_z_s_ocsCatalog, #V_1&; AS this_z_x_ocsVisibility_masks, 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.width AS this_s_image_p_width, this_s_image.height AS this_s_image_p_height, this_s_image.frames AS this_s_image_p_frames, this_s_image_z.urlDir AS this_s_image_z_p_urlDir, this_s_image_z.filename AS this_s_image_z_p_filename, this_s_image_z.extension AS this_s_image_z_p_extension, this_s_image_z.filesize AS this_s_image_z_p_filesize, this_s_image_z.filedate AS this_s_image_z_p_filedate, this_s_image_z.label_fr AS this_s_image_z_p_label_fr, this_s_image_z.description_fr AS this_s_image_z_p_description_fr, this_z.ocsStatus AS this_z_p_ocsStatus, this_z.ocsCreationDate AS this_z_p_ocsCreationDate, this_z.ocsCreationLogin AS this_z_p_ocsCreationLogin, this_z.ocsModificationDate AS this_z_p_ocsModificationDate, this_z.ocsModificationLogin AS this_z_p_ocsModificationLogin, this_z_s_ocsCatalog.useValidation AS this_z_s_ocsCatalog_p_useValidation, this_z_s_ocsCatalog.editRightsMode AS this_z_s_ocsCatalog_p_editRightsMode 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 <> '')) LEFT JOIN xrm_object_mask_view AS this_z_x_ocsVisibility On ((this_z_x_ocsVisibility.verb = 'ocsVisibility') AND (this_z_x_ocsVisibility.objectOID = this_z.`_oid`))) 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 <> '') AND (this.`_oid` = #V_0&;)", new Map("#V_0&;|integer", EC.itl.toInteger(EC.itl.getParameterValue("object:ocsCol:association", "card")), "#V_1&;|xrmMasks", EC.sqlEngine.generateXrmFilterGids("this_z_x_ocsVisibility")),true)); SqlObject catalogObject = (SqlObject) (new SqlObject("ocs:catalog", @"SELECT this.`_oid` AS this, this.useValidation AS this_p_useValidation, this.useXRM AS this_p_useXRM, this.editRightsMode AS this_p_editRightsMode FROM ocs_catalog AS this WHERE (this.iso_sid <> '') AND (this.name = 'entreprises')", 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); bool useXRM = (bool) (ITL.b((bool?)catalogObject.get("this_p_useXRM"))); compiledMode = (string)(ITL.gv["compiledMode"] = mode__1 == "new" && !ITL.b(hasNewCardRight)?"list":(mode__1 == "modify" && !(EC.itl.toBoolean(card__1) && ((ITL.b((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation"))?EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0:EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0 && ((string)card__1.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)card__1.get("this_z_p_ocsCreationLogin") == EC.itl.login():true)) && ((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)) != 0 || EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0 && ((string)card__1.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)card__1.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) && ((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)) != 2))?"card":mode__1)); if(!EC.itl.isReplay()) { if(action__1 == "new") { int catOID = (int) (EC.itl.toInteger(catalogObject)); ItlCreate c9 = new ItlCreate("ocsCol:association", "card", card__1); ; c9.setField("ocsCreationDate", EC.itl.now(), "date", "ocs:card"); c9.setField("ocsCreationLogin", EC.itl.login(), "string", "ocs:card", 255); c9.setField("ocsModificationDate", EC.itl.now(), "date", "ocs:card"); c9.setField("ocsModificationLogin", EC.itl.login(), "string", "ocs:card", 255); c9.setAssociation("ocsCatalog", catOID, "object:ocs:catalog", "ocs:card", true, false); if(c9.exec()) { int? newCompiledStatus = (int?) ((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)); ItlCreate c11 = new ItlCreate("ocs:log", null, null); ; c11.setAssociation("card", card__1, "object:ocs:card", "ocs:log", true, false); c11.setField("userLogin", EC.itl.login(), "string", "ocs:log", 255); c11.setField("date", EC.itl.now(), "date", "ocs:log"); c11.setField("comment", logComment__1, "string", "ocs:log", 255); c11.setField("cardStatus", newCompiledStatus, "integer", "ocs:log"); if(c11.exec()) { } else { } string cardUrl = (string) (((EC.destination["httpURL"] + "linkTable.aspx?GID=00011380") + "&mode=card&card=") + ITL.S((int?)card__1.get("this"))); string modifyUrl = (string) (((EC.destination["httpURL"] + "linkTable.aspx?GID=00011380") + "&mode=modify&card=") + ITL.S((int?)card__1.get("this"))); string recipient = (string) (EC.itl.login()); { OcsMailLoop _mailLoop = new OcsMailLoop("action"); while(_mailLoop.next()) { recipient = _mailLoop.getValue(); ItlMail mail12 = new ItlMail(); mail12.setProperty("to", recipient); mail12.setProperty("from", EC.itl.userProperty("email")); mail12.setProperty("subject", ocsNotificationForActionMailSubject); mail12.addToBody( @"

Demande émise par : "); ITL.show(EC.itl.login(), "string", "html", "string"); mail12.addToBody( @" ("); ITL.show(EC.itl.userProperty("email"), "string", "html", "string"); mail12.addToBody( @")

Message :

"); ITL.show(ocsNotificationForActionMessage__1, "string", "memo", "string"); mail12.addToBody( @"

>> Voir la fiche
>> Modifier la fiche

"); if(ITL.b(logComment__1)) { mail12.addToBody( @"

Note d'historique :
"); ITL.show(logComment__1, "string", "html", "string"); mail12.addToBody( @"

"); } mail12.addToBody( @"
"); mail12.exec();; } } { OcsMailLoop _mailLoop = new OcsMailLoop("info"); while(_mailLoop.next()) { recipient = _mailLoop.getValue(); ItlMail mail15 = new ItlMail(); mail15.setProperty("to", recipient); mail15.setProperty("from", EC.itl.userProperty("email")); mail15.setProperty("subject", ocsNotificationForInfoMailSubject); mail15.addToBody( @"

Information émise par : "); ITL.show(EC.itl.login(), "string", "html", "string"); mail15.addToBody( @" ("); ITL.show(EC.itl.userProperty("email"), "string", "html", "string"); mail15.addToBody( @")

Message :

"); ITL.show(ocsNotificationForInfoMessage__1, "string", "memo", "string"); mail15.addToBody( @"

>> Voir la fiche

"); if(ITL.b(logComment__1)) { mail15.addToBody( @"

Note d'historique :
"); ITL.show(logComment__1, "string", "html", "string"); mail15.addToBody( @"

"); } mail15.addToBody( @"
"); mail15.exec();; } } } else { } } else if(action__1 == "modify") { int? previousStatus = (int?) ((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)); ItlUpdateObject c18 = new ItlUpdateObject("ocsCol:association", "card", card__1); ; c18.setField("ocsModificationDate", EC.itl.now(), "date", "ocs:card"); c18.setField("ocsModificationLogin", EC.itl.login(), "string", "ocs:card", 255); if(c18.exec()) { int? newCompiledStatus__1 = (int?) ((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)); ItlCreate c20 = new ItlCreate("ocs:log", null, null); ; c20.setAssociation("card", card__1, "object:ocs:card", "ocs:log", true, false); c20.setField("userLogin", EC.itl.login(), "string", "ocs:log", 255); c20.setField("date", EC.itl.now(), "date", "ocs:log"); c20.setField("comment", logComment__1, "string", "ocs:log", 255); c20.setField("cardStatus", newCompiledStatus__1, "integer", "ocs:log"); if(c20.exec()) { } else { } string cardUrl__1 = (string) (((EC.destination["httpURL"] + "linkTable.aspx?GID=00011380") + "&mode=card&card=") + ITL.S((int?)card__1.get("this"))); string modifyUrl__1 = (string) (((EC.destination["httpURL"] + "linkTable.aspx?GID=00011380") + "&mode=modify&card=") + ITL.S((int?)card__1.get("this"))); string recipient__1 = (string) (EC.itl.login()); { OcsMailLoop _mailLoop = new OcsMailLoop("action"); while(_mailLoop.next()) { recipient__1 = _mailLoop.getValue(); ItlMail mail21 = new ItlMail(); mail21.setProperty("to", recipient__1); mail21.setProperty("from", EC.itl.userProperty("email")); mail21.setProperty("subject", ocsNotificationForActionMailSubject); mail21.addToBody( @"

Demande émise par : "); ITL.show(EC.itl.login(), "string", "html", "string"); mail21.addToBody( @" ("); ITL.show(EC.itl.userProperty("email"), "string", "html", "string"); mail21.addToBody( @")

Message :

"); ITL.show(ocsNotificationForActionMessage__1, "string", "memo", "string"); mail21.addToBody( @"

>> Voir la fiche
>> Modifier la fiche

"); if(ITL.b(logComment__1)) { mail21.addToBody( @"

Note d'historique :
"); ITL.show(logComment__1, "string", "html", "string"); mail21.addToBody( @"

"); } mail21.addToBody( @"
"); mail21.exec();; } } { OcsMailLoop _mailLoop = new OcsMailLoop("info"); while(_mailLoop.next()) { recipient__1 = _mailLoop.getValue(); ItlMail mail24 = new ItlMail(); mail24.setProperty("to", recipient__1); mail24.setProperty("from", EC.itl.userProperty("email")); mail24.setProperty("subject", ocsNotificationForInfoMailSubject); mail24.addToBody( @"

Information émise par : "); ITL.show(EC.itl.login(), "string", "html", "string"); mail24.addToBody( @" ("); ITL.show(EC.itl.userProperty("email"), "string", "html", "string"); mail24.addToBody( @")

Message :

"); ITL.show(ocsNotificationForInfoMessage__1, "string", "memo", "string"); mail24.addToBody( @"

>> Voir la fiche

"); if(ITL.b(logComment__1)) { mail24.addToBody( @"

Note d'historique :
"); ITL.show(logComment__1, "string", "html", "string"); mail24.addToBody( @"

"); } mail24.addToBody( @"
"); mail24.exec();; } } } else { } } else if(action__1 == "delete") { ItlDelete c30 = new ItlDelete("ocs:log", new SqlCollection("ocs:log", @"SELECT this.`_oid` AS this FROM ocs_log AS this LEFT JOIN ocs_card AS this_s_card On ((this.card = this_s_card.`_oid`) AND (this_s_card.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this_s_card.`_oid` = #V_0&;)", new Map("#V_0&;|integer", (int?)card__1.get("this")), (List) EC.newList(new List()))); ; if(c30.exec()) { } else { } ItlDelete c31 = new ItlDelete("ocsCol:association", card__1); ; if(c31.exec()) { } else { } } else if(action__1 == "changeStatus") { int? previousStatus__1 = (int?) ((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)); ItlUpdateObject c32 = new ItlUpdateObject("ocsCol:association", "card", card__1); ; if(c32.exec()) { int? newCompiledStatus__2 = (int?) ((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)); ItlCreate c34 = new ItlCreate("ocs:log", null, null); ; c34.setAssociation("card", card__1, "object:ocs:card", "ocs:log", true, false); c34.setField("userLogin", EC.itl.login(), "string", "ocs:log", 255); c34.setField("date", EC.itl.now(), "date", "ocs:log"); c34.setField("comment", logComment__1, "string", "ocs:log", 255); c34.setField("cardStatus", newCompiledStatus__2, "integer", "ocs:log"); if(c34.exec()) { } else { } string cardUrl__2 = (string) (((EC.destination["httpURL"] + "linkTable.aspx?GID=00011380") + "&mode=card&card=") + ITL.S((int?)card__1.get("this"))); string modifyUrl__2 = (string) (((EC.destination["httpURL"] + "linkTable.aspx?GID=00011380") + "&mode=modify&card=") + ITL.S((int?)card__1.get("this"))); string recipient__2 = (string) (EC.itl.login()); { OcsMailLoop _mailLoop = new OcsMailLoop("action"); while(_mailLoop.next()) { recipient__2 = _mailLoop.getValue(); ItlMail mail35 = new ItlMail(); mail35.setProperty("to", recipient__2); mail35.setProperty("from", EC.itl.userProperty("email")); mail35.setProperty("subject", ocsNotificationForActionMailSubject); mail35.addToBody( @"

Demande émise par : "); ITL.show(EC.itl.login(), "string", "html", "string"); mail35.addToBody( @" ("); ITL.show(EC.itl.userProperty("email"), "string", "html", "string"); mail35.addToBody( @")

Message :

"); ITL.show(ocsNotificationForActionMessage__1, "string", "memo", "string"); mail35.addToBody( @"

>> Voir la fiche
>> Modifier la fiche

"); if(ITL.b(logComment__1)) { mail35.addToBody( @"

Note d'historique :
"); ITL.show(logComment__1, "string", "html", "string"); mail35.addToBody( @"

"); } mail35.addToBody( @"
"); mail35.exec();; } } { OcsMailLoop _mailLoop = new OcsMailLoop("info"); while(_mailLoop.next()) { recipient__2 = _mailLoop.getValue(); ItlMail mail38 = new ItlMail(); mail38.setProperty("to", recipient__2); mail38.setProperty("from", EC.itl.userProperty("email")); mail38.setProperty("subject", ocsNotificationForInfoMailSubject); mail38.addToBody( @"

Information émise par : "); ITL.show(EC.itl.login(), "string", "html", "string"); mail38.addToBody( @" ("); ITL.show(EC.itl.userProperty("email"), "string", "html", "string"); mail38.addToBody( @")

Message :

"); ITL.show(ocsNotificationForInfoMessage__1, "string", "memo", "string"); mail38.addToBody( @"

>> Voir la fiche

"); if(ITL.b(logComment__1)) { mail38.addToBody( @"

Note d'historique :
"); ITL.show(logComment__1, "string", "html", "string"); mail38.addToBody( @"

"); } mail38.addToBody( @"
"); mail38.exec();; } } } else { } } else if(EC.itl.startsWith(ITL.S(action__1), "multiple-")) { string oids__1 = (string) ((string)EC.itl.getParameterValue("string", "oids")); ocsMultipleActionCount = (int?)(ITL.gv["ocsMultipleActionCount"] = 0); ocsMultipleActionOkCount = (int?)(ITL.gv["ocsMultipleActionOkCount"] = 0); ocsMultipleActionNotOkCount = (int?)(ITL.gv["ocsMultipleActionNotOkCount"] = 0); if(oids__1 == "all") { int? statusFilter__2 = (int?) ((int?)EC.itl.getParameterValue("integer", "statusFilter")); string cardType__1 = (string) ((string)EC.itl.getParameterValue("string", "cardType")); string searchFilter__2 = (string) ((string)EC.itl.getParameterValue("string", "searchFilter")); string creatorFilter__2 = (string) ((string)EC.itl.getParameterValue("string", "creatorFilter")); if(statusFilter__2 == -1) { if(cardType__1 != "archive") { ocsMultipleActionCount = (int?)(ITL.gv["ocsMultipleActionCount"] = 0); ocsMultipleActionOkCount = (int?)(ITL.gv["ocsMultipleActionOkCount"] = 0); ocsMultipleActionNotOkCount = (int?)(ITL.gv["ocsMultipleActionNotOkCount"] = 0); if(action__1 == "multiple-delete") { ItlEnumerator e42 = new ItlEnumerator("G00011380_41", null, false); string _t0 = ITL.S(searchFilter__2); e42.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 = 'entreprises') 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__2 == ""), "boolean"), new ItlRuntime.SQL.Parameter("#V_1&;", creatorFilter__2, "string"), new ItlRuntime.SQL.Parameter("#V_2&;", (searchFilter__2 == ""), "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_z_s_ocsCatalog.`_oid` AS this_z_s_ocsCatalog, this_k_1.result1 AS this_k_1_1, this_k_2.result1 AS this_k_2_1, this_z.ocsStatus AS this_z_p_ocsStatus, this_z.ocsCreationLogin AS this_z_p_ocsCreationLogin, this_z_s_ocsCatalog.useValidation AS this_z_s_ocsCatalog_p_useValidation, this_z_s_ocsCatalog.editRightsMode AS this_z_s_ocsCatalog_p_editRightsMode 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 <> '')) LEFT JOIN (SELECT c1.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> ''))) On ((this.`_oid` = c0_l.`_to`) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.`_oid` IN (#V_0&;)) GROUP BY c1.`_oid`) AS this_k_1 On (this.`_oid` = this_k_1.origin) LEFT JOIN (SELECT c1.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.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 c1.`_oid`) AS this_k_2 On (this.`_oid` = this_k_2.origin) WHERE (this.iso_sid <> '')", new Map("#V_0&;|oids", EC.itl.categoryOids(true), "#V_1&;|oids", EC.itl.categoryOids(true)), false, (List) EC.newList(new List()), null, null)); ItlEnumerator e = (ItlEnumerator) (e42); e.reset(); if(e.isNotEmpty()) { e.resetGroup(); for(e.start();e.test();e.fetch()) { ocsMultipleActionCount = (int?)(ITL.gv["ocsMultipleActionCount"] = ITL.i((int?)ITL.gv["ocsMultipleActionCount"]) + 1); if((ITL.b((bool?)e.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)e.get("this_k_1_1")) > 0:ITL.countDefault((int?)e.get("this_k_2_1")) > 0 && ((string)e.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e.get("this_z_p_ocsCreationLogin") == EC.itl.login():true)) && ((bool?)e.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)e.get("this_z_p_ocsStatus"):((int?)e.get("this_z_p_ocsStatus") == 2 || (int?)e.get("this_z_p_ocsStatus") == 3?(int?)e.get("this_z_p_ocsStatus"):0)) != 0 || ITL.countDefault((int?)e.get("this_k_2_1")) > 0 && ((string)e.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) && ((bool?)e.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)e.get("this_z_p_ocsStatus"):((int?)e.get("this_z_p_ocsStatus") == 2 || (int?)e.get("this_z_p_ocsStatus") == 3?(int?)e.get("this_z_p_ocsStatus"):0)) != 2) { ocsMultipleActionOkCount = (int?)(ITL.gv["ocsMultipleActionOkCount"] = ITL.i((int?)ITL.gv["ocsMultipleActionOkCount"]) + 1); ItlDelete c48 = new ItlDelete("ocs:log", new SqlCollection("ocs:log", @"SELECT this.`_oid` AS this FROM ocs_log AS this LEFT JOIN ocs_card AS this_s_card On ((this.card = this_s_card.`_oid`) AND (this_s_card.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this_s_card.`_oid` = #V_0&;)", new Map("#V_0&;|integer", (int?)e.get("this")), (List) EC.newList(new List()))); ; if(c48.exec()) { } else { } ItlDelete c49 = new ItlDelete("ocsCol:association", e); ; if(c49.exec()) { } else { } } else { ocsMultipleActionNotOkCount = (int?)(ITL.gv["ocsMultipleActionNotOkCount"] = ITL.i((int?)ITL.gv["ocsMultipleActionNotOkCount"]) + 1); } } } e.finish(); } else if(action__1 == "multiple-changeStatus") { int? newStatus__1 = (int?) ((int?)EC.itl.getParameterValue("integer", "newStatus")); ItlEnumerator e52 = new ItlEnumerator("G00011380_51", null, false); string _t1 = ITL.S(searchFilter__2); e52.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 = 'entreprises') 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__2 == ""), "boolean"), new ItlRuntime.SQL.Parameter("#V_1&;", creatorFilter__2, "string"), new ItlRuntime.SQL.Parameter("#V_2&;", (searchFilter__2 == ""), "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_z_s_ocsCatalog.`_oid` AS this_z_s_ocsCatalog, this_k_1.result1 AS this_k_1_1, this_k_2.result1 AS this_k_2_1, this_z.ocsStatus AS this_z_p_ocsStatus, this_z.ocsCreationLogin AS this_z_p_ocsCreationLogin, this_z_s_ocsCatalog.useValidation AS this_z_s_ocsCatalog_p_useValidation, this_z_s_ocsCatalog.editRightsMode AS this_z_s_ocsCatalog_p_editRightsMode 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 <> '')) LEFT JOIN (SELECT c1.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> ''))) On ((this.`_oid` = c0_l.`_to`) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.`_oid` IN (#V_0&;)) GROUP BY c1.`_oid`) AS this_k_1 On (this.`_oid` = this_k_1.origin) LEFT JOIN (SELECT c1.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.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 c1.`_oid`) AS this_k_2 On (this.`_oid` = this_k_2.origin) WHERE (this.iso_sid <> '')", new Map("#V_0&;|oids", EC.itl.categoryOids(true), "#V_1&;|oids", EC.itl.categoryOids(true)), false, (List) EC.newList(new List()), null, null)); ItlEnumerator e__1 = (ItlEnumerator) (e52); e__1.reset(); if(e__1.isNotEmpty()) { e__1.resetGroup(); for(e__1.start();e__1.test();e__1.fetch()) { ocsMultipleActionCount = (int?)(ITL.gv["ocsMultipleActionCount"] = ITL.i((int?)ITL.gv["ocsMultipleActionCount"]) + 1); if(((ITL.b((bool?)e__1.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)e__1.get("this_k_1_1")) > 0:ITL.countDefault((int?)e__1.get("this_k_2_1")) > 0 && ((string)e__1.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__1.get("this_z_p_ocsCreationLogin") == EC.itl.login():true)) && ((bool?)e__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)e__1.get("this_z_p_ocsStatus"):((int?)e__1.get("this_z_p_ocsStatus") == 2 || (int?)e__1.get("this_z_p_ocsStatus") == 3?(int?)e__1.get("this_z_p_ocsStatus"):0)) != 0 || ITL.countDefault((int?)e__1.get("this_k_2_1")) > 0 && ((string)e__1.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__1.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) && ((bool?)e__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)e__1.get("this_z_p_ocsStatus"):((int?)e__1.get("this_z_p_ocsStatus") == 2 || (int?)e__1.get("this_z_p_ocsStatus") == 3?(int?)e__1.get("this_z_p_ocsStatus"):0)) != 2) && ((ITL.countDefault((int?)e__1.get("this_k_2_1")) > 0 && ((string)e__1.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__1.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) || (ITL.b((bool?)e__1.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)e__1.get("this_k_1_1")) > 0:ITL.countDefault((int?)e__1.get("this_k_2_1")) > 0 && ((string)e__1.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__1.get("this_z_p_ocsCreationLogin") == EC.itl.login():true))) && newStatus__1 == 0 || (ITL.countDefault((int?)e__1.get("this_k_2_1")) > 0 && ((string)e__1.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__1.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) || (ITL.b((bool?)e__1.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)e__1.get("this_k_1_1")) > 0:ITL.countDefault((int?)e__1.get("this_k_2_1")) > 0 && ((string)e__1.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__1.get("this_z_p_ocsCreationLogin") == EC.itl.login():true))) && newStatus__1 == 1 || (ITL.b((bool?)e__1.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)e__1.get("this_k_1_1")) > 0:ITL.countDefault((int?)e__1.get("this_k_2_1")) > 0 && ((string)e__1.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__1.get("this_z_p_ocsCreationLogin") == EC.itl.login():true)) && newStatus__1 == 2 || (ITL.countDefault((int?)e__1.get("this_k_2_1")) > 0 && ((string)e__1.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__1.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) || (ITL.b((bool?)e__1.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)e__1.get("this_k_1_1")) > 0:ITL.countDefault((int?)e__1.get("this_k_2_1")) > 0 && ((string)e__1.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__1.get("this_z_p_ocsCreationLogin") == EC.itl.login():true))) && newStatus__1 == 3)) { ocsMultipleActionOkCount = (int?)(ITL.gv["ocsMultipleActionOkCount"] = ITL.i((int?)ITL.gv["ocsMultipleActionOkCount"]) + 1); if(((bool?)e__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)e__1.get("this_z_p_ocsStatus"):((int?)e__1.get("this_z_p_ocsStatus") == 2 || (int?)e__1.get("this_z_p_ocsStatus") == 3?(int?)e__1.get("this_z_p_ocsStatus"):0)) != newStatus__1) { int? previousStatus__2 = (int?) ((bool?)e__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)e__1.get("this_z_p_ocsStatus"):((int?)e__1.get("this_z_p_ocsStatus") == 2 || (int?)e__1.get("this_z_p_ocsStatus") == 3?(int?)e__1.get("this_z_p_ocsStatus"):0)); ItlUpdateObject c68 = new ItlUpdateObject("ocsCol:association", null, e__1); ; c68.setField("ocsStatus", newStatus__1, "integer", "ocs:card"); if(c68.exec()) { ItlCreate c70 = new ItlCreate("ocs:log", null, null); ; c70.setAssociation("card", e__1, "object:ocs:card", "ocs:log", true, false); c70.setField("userLogin", EC.itl.login(), "string", "ocs:log", 255); c70.setField("date", EC.itl.now(), "date", "ocs:log"); c70.setField("comment", "", "string", "ocs:log", 255); c70.setField("cardStatus", newStatus__1, "integer", "ocs:log"); if(c70.exec()) { } else { } } else { } } } else { ocsMultipleActionNotOkCount = (int?)(ITL.gv["ocsMultipleActionNotOkCount"] = ITL.i((int?)ITL.gv["ocsMultipleActionNotOkCount"]) + 1); } } } e__1.finish(); } } else { ocsMultipleActionCount = (int?)(ITL.gv["ocsMultipleActionCount"] = 0); ocsMultipleActionOkCount = (int?)(ITL.gv["ocsMultipleActionOkCount"] = 0); ocsMultipleActionNotOkCount = (int?)(ITL.gv["ocsMultipleActionNotOkCount"] = 0); if(action__1 == "multiple-delete") { ItlEnumerator e73 = new ItlEnumerator("G00011380_72", null, false); string _t2 = ITL.S(searchFilter__2); e73.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 = 'entreprises') 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__2 == ""), "boolean"), new ItlRuntime.SQL.Parameter("#V_1&;", creatorFilter__2, "string"), new ItlRuntime.SQL.Parameter("#V_2&;", (searchFilter__2 == ""), "boolean"), new ItlRuntime.SQL.Parameter("#V_3&;", _t2, "string")), new ItlRuntime.SQL.OrderAliases(), new ItlRuntime.SQL.OptionalOrderAliases(), null, null), @"SELECT this.`_oid` AS this, this_z_s_ocsCatalog.`_oid` AS this_z_s_ocsCatalog, this_k_1.result1 AS this_k_1_1, this_k_2.result1 AS this_k_2_1, this_z.ocsStatus AS this_z_p_ocsStatus, this_z.ocsCreationLogin AS this_z_p_ocsCreationLogin, this_z_s_ocsCatalog.useValidation AS this_z_s_ocsCatalog_p_useValidation, this_z_s_ocsCatalog.editRightsMode AS this_z_s_ocsCatalog_p_editRightsMode 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 <> '')) LEFT JOIN (SELECT c1.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> ''))) On ((this.`_oid` = c0_l.`_to`) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.`_oid` IN (#V_0&;)) GROUP BY c1.`_oid`) AS this_k_1 On (this.`_oid` = this_k_1.origin) LEFT JOIN (SELECT c1.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.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 c1.`_oid`) AS this_k_2 On (this.`_oid` = this_k_2.origin) WHERE (this.iso_sid <> '')", new Map("#V_0&;|oids", EC.itl.categoryOids(true), "#V_1&;|oids", EC.itl.categoryOids(true)), false, (List) EC.newList(new List()), null, null)); ItlEnumerator e__2 = (ItlEnumerator) (e73); e__2.reset(); if(e__2.isNotEmpty()) { e__2.resetGroup(); for(e__2.start();e__2.test();e__2.fetch()) { ocsMultipleActionCount = (int?)(ITL.gv["ocsMultipleActionCount"] = ITL.i((int?)ITL.gv["ocsMultipleActionCount"]) + 1); if((ITL.b((bool?)e__2.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)e__2.get("this_k_1_1")) > 0:ITL.countDefault((int?)e__2.get("this_k_2_1")) > 0 && ((string)e__2.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__2.get("this_z_p_ocsCreationLogin") == EC.itl.login():true)) && ((bool?)e__2.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)e__2.get("this_z_p_ocsStatus"):((int?)e__2.get("this_z_p_ocsStatus") == 2 || (int?)e__2.get("this_z_p_ocsStatus") == 3?(int?)e__2.get("this_z_p_ocsStatus"):0)) != 0 || ITL.countDefault((int?)e__2.get("this_k_2_1")) > 0 && ((string)e__2.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__2.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) && ((bool?)e__2.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)e__2.get("this_z_p_ocsStatus"):((int?)e__2.get("this_z_p_ocsStatus") == 2 || (int?)e__2.get("this_z_p_ocsStatus") == 3?(int?)e__2.get("this_z_p_ocsStatus"):0)) != 2) { ocsMultipleActionOkCount = (int?)(ITL.gv["ocsMultipleActionOkCount"] = ITL.i((int?)ITL.gv["ocsMultipleActionOkCount"]) + 1); ItlDelete c79 = new ItlDelete("ocs:log", new SqlCollection("ocs:log", @"SELECT this.`_oid` AS this FROM ocs_log AS this LEFT JOIN ocs_card AS this_s_card On ((this.card = this_s_card.`_oid`) AND (this_s_card.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this_s_card.`_oid` = #V_0&;)", new Map("#V_0&;|integer", (int?)e__2.get("this")), (List) EC.newList(new List()))); ; if(c79.exec()) { } else { } ItlDelete c80 = new ItlDelete("ocsCol:association", e__2); ; if(c80.exec()) { } else { } } else { ocsMultipleActionNotOkCount = (int?)(ITL.gv["ocsMultipleActionNotOkCount"] = ITL.i((int?)ITL.gv["ocsMultipleActionNotOkCount"]) + 1); } } } e__2.finish(); } else if(action__1 == "multiple-changeStatus") { int? newStatus__2 = (int?) ((int?)EC.itl.getParameterValue("integer", "newStatus")); ItlEnumerator e83 = new ItlEnumerator("G00011380_82", null, false); string _t3 = ITL.S(searchFilter__2); e83.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 = 'entreprises') 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__2 == ""), "boolean"), new ItlRuntime.SQL.Parameter("#V_1&;", creatorFilter__2, "string"), new ItlRuntime.SQL.Parameter("#V_2&;", (searchFilter__2 == ""), "boolean"), new ItlRuntime.SQL.Parameter("#V_3&;", _t3, "string")), new ItlRuntime.SQL.OrderAliases(), new ItlRuntime.SQL.OptionalOrderAliases(), null, null), @"SELECT this.`_oid` AS this, this_z_s_ocsCatalog.`_oid` AS this_z_s_ocsCatalog, this_k_1.result1 AS this_k_1_1, this_k_2.result1 AS this_k_2_1, this_z.ocsStatus AS this_z_p_ocsStatus, this_z.ocsCreationLogin AS this_z_p_ocsCreationLogin, this_z_s_ocsCatalog.useValidation AS this_z_s_ocsCatalog_p_useValidation, this_z_s_ocsCatalog.editRightsMode AS this_z_s_ocsCatalog_p_editRightsMode 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 <> '')) LEFT JOIN (SELECT c1.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> ''))) On ((this.`_oid` = c0_l.`_to`) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.`_oid` IN (#V_0&;)) GROUP BY c1.`_oid`) AS this_k_1 On (this.`_oid` = this_k_1.origin) LEFT JOIN (SELECT c1.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.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 c1.`_oid`) AS this_k_2 On (this.`_oid` = this_k_2.origin) WHERE (this.iso_sid <> '')", new Map("#V_0&;|oids", EC.itl.categoryOids(true), "#V_1&;|oids", EC.itl.categoryOids(true)), false, (List) EC.newList(new List()), null, null)); ItlEnumerator e__3 = (ItlEnumerator) (e83); e__3.reset(); if(e__3.isNotEmpty()) { e__3.resetGroup(); for(e__3.start();e__3.test();e__3.fetch()) { ocsMultipleActionCount = (int?)(ITL.gv["ocsMultipleActionCount"] = ITL.i((int?)ITL.gv["ocsMultipleActionCount"]) + 1); if(((ITL.b((bool?)e__3.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)e__3.get("this_k_1_1")) > 0:ITL.countDefault((int?)e__3.get("this_k_2_1")) > 0 && ((string)e__3.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__3.get("this_z_p_ocsCreationLogin") == EC.itl.login():true)) && ((bool?)e__3.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)e__3.get("this_z_p_ocsStatus"):((int?)e__3.get("this_z_p_ocsStatus") == 2 || (int?)e__3.get("this_z_p_ocsStatus") == 3?(int?)e__3.get("this_z_p_ocsStatus"):0)) != 0 || ITL.countDefault((int?)e__3.get("this_k_2_1")) > 0 && ((string)e__3.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__3.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) && ((bool?)e__3.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)e__3.get("this_z_p_ocsStatus"):((int?)e__3.get("this_z_p_ocsStatus") == 2 || (int?)e__3.get("this_z_p_ocsStatus") == 3?(int?)e__3.get("this_z_p_ocsStatus"):0)) != 2) && ((ITL.countDefault((int?)e__3.get("this_k_2_1")) > 0 && ((string)e__3.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__3.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) || (ITL.b((bool?)e__3.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)e__3.get("this_k_1_1")) > 0:ITL.countDefault((int?)e__3.get("this_k_2_1")) > 0 && ((string)e__3.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__3.get("this_z_p_ocsCreationLogin") == EC.itl.login():true))) && newStatus__2 == 0 || (ITL.countDefault((int?)e__3.get("this_k_2_1")) > 0 && ((string)e__3.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__3.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) || (ITL.b((bool?)e__3.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)e__3.get("this_k_1_1")) > 0:ITL.countDefault((int?)e__3.get("this_k_2_1")) > 0 && ((string)e__3.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__3.get("this_z_p_ocsCreationLogin") == EC.itl.login():true))) && newStatus__2 == 1 || (ITL.b((bool?)e__3.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)e__3.get("this_k_1_1")) > 0:ITL.countDefault((int?)e__3.get("this_k_2_1")) > 0 && ((string)e__3.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__3.get("this_z_p_ocsCreationLogin") == EC.itl.login():true)) && newStatus__2 == 2 || (ITL.countDefault((int?)e__3.get("this_k_2_1")) > 0 && ((string)e__3.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__3.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) || (ITL.b((bool?)e__3.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)e__3.get("this_k_1_1")) > 0:ITL.countDefault((int?)e__3.get("this_k_2_1")) > 0 && ((string)e__3.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__3.get("this_z_p_ocsCreationLogin") == EC.itl.login():true))) && newStatus__2 == 3)) { ocsMultipleActionOkCount = (int?)(ITL.gv["ocsMultipleActionOkCount"] = ITL.i((int?)ITL.gv["ocsMultipleActionOkCount"]) + 1); if(((bool?)e__3.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)e__3.get("this_z_p_ocsStatus"):((int?)e__3.get("this_z_p_ocsStatus") == 2 || (int?)e__3.get("this_z_p_ocsStatus") == 3?(int?)e__3.get("this_z_p_ocsStatus"):0)) != newStatus__2) { int? previousStatus__3 = (int?) ((bool?)e__3.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)e__3.get("this_z_p_ocsStatus"):((int?)e__3.get("this_z_p_ocsStatus") == 2 || (int?)e__3.get("this_z_p_ocsStatus") == 3?(int?)e__3.get("this_z_p_ocsStatus"):0)); ItlUpdateObject c99 = new ItlUpdateObject("ocsCol:association", null, e__3); ; c99.setField("ocsStatus", newStatus__2, "integer", "ocs:card"); if(c99.exec()) { ItlCreate c101 = new ItlCreate("ocs:log", null, null); ; c101.setAssociation("card", e__3, "object:ocs:card", "ocs:log", true, false); c101.setField("userLogin", EC.itl.login(), "string", "ocs:log", 255); c101.setField("date", EC.itl.now(), "date", "ocs:log"); c101.setField("comment", "", "string", "ocs:log", 255); c101.setField("cardStatus", newStatus__2, "integer", "ocs:log"); if(c101.exec()) { } else { } } else { } } } else { ocsMultipleActionNotOkCount = (int?)(ITL.gv["ocsMultipleActionNotOkCount"] = ITL.i((int?)ITL.gv["ocsMultipleActionNotOkCount"]) + 1); } } } e__3.finish(); } } } else { ocsMultipleActionCount = (int?)(ITL.gv["ocsMultipleActionCount"] = 0); ocsMultipleActionOkCount = (int?)(ITL.gv["ocsMultipleActionOkCount"] = 0); ocsMultipleActionNotOkCount = (int?)(ITL.gv["ocsMultipleActionNotOkCount"] = 0); if(action__1 == "multiple-delete") { ItlEnumerator e104 = new ItlEnumerator("G00011380_103", null, false); string _t4 = ITL.S(searchFilter__2); e104.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 = 'entreprises') 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__2 == ""), "boolean"), new ItlRuntime.SQL.Parameter("#V_1&;", creatorFilter__2, "string"), new ItlRuntime.SQL.Parameter("#V_2&;", (searchFilter__2 == ""), "boolean"), new ItlRuntime.SQL.Parameter("#V_3&;", _t4, "string"), new ItlRuntime.SQL.Parameter("#V_4&;", statusFilter__2, "integer")), new ItlRuntime.SQL.OrderAliases(), new ItlRuntime.SQL.OptionalOrderAliases(), null, null), @"SELECT this.`_oid` AS this, this_z_s_ocsCatalog.`_oid` AS this_z_s_ocsCatalog, this_k_1.result1 AS this_k_1_1, this_k_2.result1 AS this_k_2_1, this_z.ocsStatus AS this_z_p_ocsStatus, this_z.ocsCreationLogin AS this_z_p_ocsCreationLogin, this_z_s_ocsCatalog.useValidation AS this_z_s_ocsCatalog_p_useValidation, this_z_s_ocsCatalog.editRightsMode AS this_z_s_ocsCatalog_p_editRightsMode 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 <> '')) LEFT JOIN (SELECT c1.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> ''))) On ((this.`_oid` = c0_l.`_to`) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.`_oid` IN (#V_0&;)) GROUP BY c1.`_oid`) AS this_k_1 On (this.`_oid` = this_k_1.origin) LEFT JOIN (SELECT c1.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.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 c1.`_oid`) AS this_k_2 On (this.`_oid` = this_k_2.origin) WHERE (this.iso_sid <> '')", new Map("#V_0&;|oids", EC.itl.categoryOids(true), "#V_1&;|oids", EC.itl.categoryOids(true)), false, (List) EC.newList(new List()), null, null)); ItlEnumerator e__4 = (ItlEnumerator) (e104); e__4.reset(); if(e__4.isNotEmpty()) { e__4.resetGroup(); for(e__4.start();e__4.test();e__4.fetch()) { ocsMultipleActionCount = (int?)(ITL.gv["ocsMultipleActionCount"] = ITL.i((int?)ITL.gv["ocsMultipleActionCount"]) + 1); if((ITL.b((bool?)e__4.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)e__4.get("this_k_1_1")) > 0:ITL.countDefault((int?)e__4.get("this_k_2_1")) > 0 && ((string)e__4.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__4.get("this_z_p_ocsCreationLogin") == EC.itl.login():true)) && ((bool?)e__4.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)e__4.get("this_z_p_ocsStatus"):((int?)e__4.get("this_z_p_ocsStatus") == 2 || (int?)e__4.get("this_z_p_ocsStatus") == 3?(int?)e__4.get("this_z_p_ocsStatus"):0)) != 0 || ITL.countDefault((int?)e__4.get("this_k_2_1")) > 0 && ((string)e__4.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__4.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) && ((bool?)e__4.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)e__4.get("this_z_p_ocsStatus"):((int?)e__4.get("this_z_p_ocsStatus") == 2 || (int?)e__4.get("this_z_p_ocsStatus") == 3?(int?)e__4.get("this_z_p_ocsStatus"):0)) != 2) { ocsMultipleActionOkCount = (int?)(ITL.gv["ocsMultipleActionOkCount"] = ITL.i((int?)ITL.gv["ocsMultipleActionOkCount"]) + 1); ItlDelete c110 = new ItlDelete("ocs:log", new SqlCollection("ocs:log", @"SELECT this.`_oid` AS this FROM ocs_log AS this LEFT JOIN ocs_card AS this_s_card On ((this.card = this_s_card.`_oid`) AND (this_s_card.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this_s_card.`_oid` = #V_0&;)", new Map("#V_0&;|integer", (int?)e__4.get("this")), (List) EC.newList(new List()))); ; if(c110.exec()) { } else { } ItlDelete c111 = new ItlDelete("ocsCol:association", e__4); ; if(c111.exec()) { } else { } } else { ocsMultipleActionNotOkCount = (int?)(ITL.gv["ocsMultipleActionNotOkCount"] = ITL.i((int?)ITL.gv["ocsMultipleActionNotOkCount"]) + 1); } } } e__4.finish(); } else if(action__1 == "multiple-changeStatus") { int? newStatus__3 = (int?) ((int?)EC.itl.getParameterValue("integer", "newStatus")); ItlEnumerator e114 = new ItlEnumerator("G00011380_113", null, false); string _t5 = ITL.S(searchFilter__2); e114.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 = 'entreprises') 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__2 == ""), "boolean"), new ItlRuntime.SQL.Parameter("#V_1&;", creatorFilter__2, "string"), new ItlRuntime.SQL.Parameter("#V_2&;", (searchFilter__2 == ""), "boolean"), new ItlRuntime.SQL.Parameter("#V_3&;", _t5, "string"), new ItlRuntime.SQL.Parameter("#V_4&;", statusFilter__2, "integer")), new ItlRuntime.SQL.OrderAliases(), new ItlRuntime.SQL.OptionalOrderAliases(), null, null), @"SELECT this.`_oid` AS this, this_z_s_ocsCatalog.`_oid` AS this_z_s_ocsCatalog, this_k_1.result1 AS this_k_1_1, this_k_2.result1 AS this_k_2_1, this_z.ocsStatus AS this_z_p_ocsStatus, this_z.ocsCreationLogin AS this_z_p_ocsCreationLogin, this_z_s_ocsCatalog.useValidation AS this_z_s_ocsCatalog_p_useValidation, this_z_s_ocsCatalog.editRightsMode AS this_z_s_ocsCatalog_p_editRightsMode 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 <> '')) LEFT JOIN (SELECT c1.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> ''))) On ((this.`_oid` = c0_l.`_to`) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.`_oid` IN (#V_0&;)) GROUP BY c1.`_oid`) AS this_k_1 On (this.`_oid` = this_k_1.origin) LEFT JOIN (SELECT c1.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.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 c1.`_oid`) AS this_k_2 On (this.`_oid` = this_k_2.origin) WHERE (this.iso_sid <> '')", new Map("#V_0&;|oids", EC.itl.categoryOids(true), "#V_1&;|oids", EC.itl.categoryOids(true)), false, (List) EC.newList(new List()), null, null)); ItlEnumerator e__5 = (ItlEnumerator) (e114); e__5.reset(); if(e__5.isNotEmpty()) { e__5.resetGroup(); for(e__5.start();e__5.test();e__5.fetch()) { ocsMultipleActionCount = (int?)(ITL.gv["ocsMultipleActionCount"] = ITL.i((int?)ITL.gv["ocsMultipleActionCount"]) + 1); if(((ITL.b((bool?)e__5.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)e__5.get("this_k_1_1")) > 0:ITL.countDefault((int?)e__5.get("this_k_2_1")) > 0 && ((string)e__5.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__5.get("this_z_p_ocsCreationLogin") == EC.itl.login():true)) && ((bool?)e__5.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)e__5.get("this_z_p_ocsStatus"):((int?)e__5.get("this_z_p_ocsStatus") == 2 || (int?)e__5.get("this_z_p_ocsStatus") == 3?(int?)e__5.get("this_z_p_ocsStatus"):0)) != 0 || ITL.countDefault((int?)e__5.get("this_k_2_1")) > 0 && ((string)e__5.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__5.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) && ((bool?)e__5.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)e__5.get("this_z_p_ocsStatus"):((int?)e__5.get("this_z_p_ocsStatus") == 2 || (int?)e__5.get("this_z_p_ocsStatus") == 3?(int?)e__5.get("this_z_p_ocsStatus"):0)) != 2) && ((ITL.countDefault((int?)e__5.get("this_k_2_1")) > 0 && ((string)e__5.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__5.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) || (ITL.b((bool?)e__5.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)e__5.get("this_k_1_1")) > 0:ITL.countDefault((int?)e__5.get("this_k_2_1")) > 0 && ((string)e__5.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__5.get("this_z_p_ocsCreationLogin") == EC.itl.login():true))) && newStatus__3 == 0 || (ITL.countDefault((int?)e__5.get("this_k_2_1")) > 0 && ((string)e__5.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__5.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) || (ITL.b((bool?)e__5.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)e__5.get("this_k_1_1")) > 0:ITL.countDefault((int?)e__5.get("this_k_2_1")) > 0 && ((string)e__5.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__5.get("this_z_p_ocsCreationLogin") == EC.itl.login():true))) && newStatus__3 == 1 || (ITL.b((bool?)e__5.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)e__5.get("this_k_1_1")) > 0:ITL.countDefault((int?)e__5.get("this_k_2_1")) > 0 && ((string)e__5.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__5.get("this_z_p_ocsCreationLogin") == EC.itl.login():true)) && newStatus__3 == 2 || (ITL.countDefault((int?)e__5.get("this_k_2_1")) > 0 && ((string)e__5.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__5.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) || (ITL.b((bool?)e__5.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)e__5.get("this_k_1_1")) > 0:ITL.countDefault((int?)e__5.get("this_k_2_1")) > 0 && ((string)e__5.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__5.get("this_z_p_ocsCreationLogin") == EC.itl.login():true))) && newStatus__3 == 3)) { ocsMultipleActionOkCount = (int?)(ITL.gv["ocsMultipleActionOkCount"] = ITL.i((int?)ITL.gv["ocsMultipleActionOkCount"]) + 1); if(((bool?)e__5.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)e__5.get("this_z_p_ocsStatus"):((int?)e__5.get("this_z_p_ocsStatus") == 2 || (int?)e__5.get("this_z_p_ocsStatus") == 3?(int?)e__5.get("this_z_p_ocsStatus"):0)) != newStatus__3) { int? previousStatus__4 = (int?) ((bool?)e__5.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)e__5.get("this_z_p_ocsStatus"):((int?)e__5.get("this_z_p_ocsStatus") == 2 || (int?)e__5.get("this_z_p_ocsStatus") == 3?(int?)e__5.get("this_z_p_ocsStatus"):0)); ItlUpdateObject c130 = new ItlUpdateObject("ocsCol:association", null, e__5); ; c130.setField("ocsStatus", newStatus__3, "integer", "ocs:card"); if(c130.exec()) { ItlCreate c132 = new ItlCreate("ocs:log", null, null); ; c132.setAssociation("card", e__5, "object:ocs:card", "ocs:log", true, false); c132.setField("userLogin", EC.itl.login(), "string", "ocs:log", 255); c132.setField("date", EC.itl.now(), "date", "ocs:log"); c132.setField("comment", "", "string", "ocs:log", 255); c132.setField("cardStatus", newStatus__3, "integer", "ocs:log"); if(c132.exec()) { } else { } } else { } } } else { ocsMultipleActionNotOkCount = (int?)(ITL.gv["ocsMultipleActionNotOkCount"] = ITL.i((int?)ITL.gv["ocsMultipleActionNotOkCount"]) + 1); } } } e__5.finish(); } } } else { ocsMultipleActionCount = (int?)(ITL.gv["ocsMultipleActionCount"] = 0); ocsMultipleActionOkCount = (int?)(ITL.gv["ocsMultipleActionOkCount"] = 0); ocsMultipleActionNotOkCount = (int?)(ITL.gv["ocsMultipleActionNotOkCount"] = 0); if(action__1 == "multiple-delete") { ItlEnumerator e135 = new ItlEnumerator("G00011380_134", null, false); e135.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__1), "oids")), new ItlRuntime.SQL.OrderAliases(), new ItlRuntime.SQL.OptionalOrderAliases(), null, null), @"SELECT this.`_oid` AS this, this_z_s_ocsCatalog.`_oid` AS this_z_s_ocsCatalog, this_k_1.result1 AS this_k_1_1, this_k_2.result1 AS this_k_2_1, this_z.ocsStatus AS this_z_p_ocsStatus, this_z.ocsCreationLogin AS this_z_p_ocsCreationLogin, this_z_s_ocsCatalog.useValidation AS this_z_s_ocsCatalog_p_useValidation, this_z_s_ocsCatalog.editRightsMode AS this_z_s_ocsCatalog_p_editRightsMode 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 <> '')) LEFT JOIN (SELECT c1.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> ''))) On ((this.`_oid` = c0_l.`_to`) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.`_oid` IN (#V_0&;)) GROUP BY c1.`_oid`) AS this_k_1 On (this.`_oid` = this_k_1.origin) LEFT JOIN (SELECT c1.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.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 c1.`_oid`) AS this_k_2 On (this.`_oid` = this_k_2.origin) WHERE (this.iso_sid <> '')", new Map("#V_0&;|oids", EC.itl.categoryOids(true), "#V_1&;|oids", EC.itl.categoryOids(true)), false, (List) EC.newList(new List()), null, null)); ItlEnumerator e__6 = (ItlEnumerator) (e135); e__6.reset(); if(e__6.isNotEmpty()) { e__6.resetGroup(); for(e__6.start();e__6.test();e__6.fetch()) { ocsMultipleActionCount = (int?)(ITL.gv["ocsMultipleActionCount"] = ITL.i((int?)ITL.gv["ocsMultipleActionCount"]) + 1); if((ITL.b((bool?)e__6.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)e__6.get("this_k_1_1")) > 0:ITL.countDefault((int?)e__6.get("this_k_2_1")) > 0 && ((string)e__6.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__6.get("this_z_p_ocsCreationLogin") == EC.itl.login():true)) && ((bool?)e__6.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)e__6.get("this_z_p_ocsStatus"):((int?)e__6.get("this_z_p_ocsStatus") == 2 || (int?)e__6.get("this_z_p_ocsStatus") == 3?(int?)e__6.get("this_z_p_ocsStatus"):0)) != 0 || ITL.countDefault((int?)e__6.get("this_k_2_1")) > 0 && ((string)e__6.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__6.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) && ((bool?)e__6.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)e__6.get("this_z_p_ocsStatus"):((int?)e__6.get("this_z_p_ocsStatus") == 2 || (int?)e__6.get("this_z_p_ocsStatus") == 3?(int?)e__6.get("this_z_p_ocsStatus"):0)) != 2) { ocsMultipleActionOkCount = (int?)(ITL.gv["ocsMultipleActionOkCount"] = ITL.i((int?)ITL.gv["ocsMultipleActionOkCount"]) + 1); ItlDelete c141 = new ItlDelete("ocs:log", new SqlCollection("ocs:log", @"SELECT this.`_oid` AS this FROM ocs_log AS this LEFT JOIN ocs_card AS this_s_card On ((this.card = this_s_card.`_oid`) AND (this_s_card.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this_s_card.`_oid` = #V_0&;)", new Map("#V_0&;|integer", (int?)e__6.get("this")), (List) EC.newList(new List()))); ; if(c141.exec()) { } else { } ItlDelete c142 = new ItlDelete("ocsCol:association", e__6); ; if(c142.exec()) { } else { } } else { ocsMultipleActionNotOkCount = (int?)(ITL.gv["ocsMultipleActionNotOkCount"] = ITL.i((int?)ITL.gv["ocsMultipleActionNotOkCount"]) + 1); } } } e__6.finish(); } else if(action__1 == "multiple-changeStatus") { int? newStatus__4 = (int?) ((int?)EC.itl.getParameterValue("integer", "newStatus")); ItlEnumerator e145 = new ItlEnumerator("G00011380_144", null, false); e145.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__1), "oids")), new ItlRuntime.SQL.OrderAliases(), new ItlRuntime.SQL.OptionalOrderAliases(), null, null), @"SELECT this.`_oid` AS this, this_z_s_ocsCatalog.`_oid` AS this_z_s_ocsCatalog, this_k_1.result1 AS this_k_1_1, this_k_2.result1 AS this_k_2_1, this_z.ocsStatus AS this_z_p_ocsStatus, this_z.ocsCreationLogin AS this_z_p_ocsCreationLogin, this_z_s_ocsCatalog.useValidation AS this_z_s_ocsCatalog_p_useValidation, this_z_s_ocsCatalog.editRightsMode AS this_z_s_ocsCatalog_p_editRightsMode 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 <> '')) LEFT JOIN (SELECT c1.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> ''))) On ((this.`_oid` = c0_l.`_to`) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.`_oid` IN (#V_0&;)) GROUP BY c1.`_oid`) AS this_k_1 On (this.`_oid` = this_k_1.origin) LEFT JOIN (SELECT c1.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.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 c1.`_oid`) AS this_k_2 On (this.`_oid` = this_k_2.origin) WHERE (this.iso_sid <> '')", new Map("#V_0&;|oids", EC.itl.categoryOids(true), "#V_1&;|oids", EC.itl.categoryOids(true)), false, (List) EC.newList(new List()), null, null)); ItlEnumerator e__7 = (ItlEnumerator) (e145); e__7.reset(); if(e__7.isNotEmpty()) { e__7.resetGroup(); for(e__7.start();e__7.test();e__7.fetch()) { ocsMultipleActionCount = (int?)(ITL.gv["ocsMultipleActionCount"] = ITL.i((int?)ITL.gv["ocsMultipleActionCount"]) + 1); if(((ITL.b((bool?)e__7.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)e__7.get("this_k_1_1")) > 0:ITL.countDefault((int?)e__7.get("this_k_2_1")) > 0 && ((string)e__7.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__7.get("this_z_p_ocsCreationLogin") == EC.itl.login():true)) && ((bool?)e__7.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)e__7.get("this_z_p_ocsStatus"):((int?)e__7.get("this_z_p_ocsStatus") == 2 || (int?)e__7.get("this_z_p_ocsStatus") == 3?(int?)e__7.get("this_z_p_ocsStatus"):0)) != 0 || ITL.countDefault((int?)e__7.get("this_k_2_1")) > 0 && ((string)e__7.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__7.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) && ((bool?)e__7.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)e__7.get("this_z_p_ocsStatus"):((int?)e__7.get("this_z_p_ocsStatus") == 2 || (int?)e__7.get("this_z_p_ocsStatus") == 3?(int?)e__7.get("this_z_p_ocsStatus"):0)) != 2) && ((ITL.countDefault((int?)e__7.get("this_k_2_1")) > 0 && ((string)e__7.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__7.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) || (ITL.b((bool?)e__7.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)e__7.get("this_k_1_1")) > 0:ITL.countDefault((int?)e__7.get("this_k_2_1")) > 0 && ((string)e__7.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__7.get("this_z_p_ocsCreationLogin") == EC.itl.login():true))) && newStatus__4 == 0 || (ITL.countDefault((int?)e__7.get("this_k_2_1")) > 0 && ((string)e__7.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__7.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) || (ITL.b((bool?)e__7.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)e__7.get("this_k_1_1")) > 0:ITL.countDefault((int?)e__7.get("this_k_2_1")) > 0 && ((string)e__7.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__7.get("this_z_p_ocsCreationLogin") == EC.itl.login():true))) && newStatus__4 == 1 || (ITL.b((bool?)e__7.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)e__7.get("this_k_1_1")) > 0:ITL.countDefault((int?)e__7.get("this_k_2_1")) > 0 && ((string)e__7.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__7.get("this_z_p_ocsCreationLogin") == EC.itl.login():true)) && newStatus__4 == 2 || (ITL.countDefault((int?)e__7.get("this_k_2_1")) > 0 && ((string)e__7.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__7.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) || (ITL.b((bool?)e__7.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)e__7.get("this_k_1_1")) > 0:ITL.countDefault((int?)e__7.get("this_k_2_1")) > 0 && ((string)e__7.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)e__7.get("this_z_p_ocsCreationLogin") == EC.itl.login():true))) && newStatus__4 == 3)) { ocsMultipleActionOkCount = (int?)(ITL.gv["ocsMultipleActionOkCount"] = ITL.i((int?)ITL.gv["ocsMultipleActionOkCount"]) + 1); if(((bool?)e__7.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)e__7.get("this_z_p_ocsStatus"):((int?)e__7.get("this_z_p_ocsStatus") == 2 || (int?)e__7.get("this_z_p_ocsStatus") == 3?(int?)e__7.get("this_z_p_ocsStatus"):0)) != newStatus__4) { int? previousStatus__5 = (int?) ((bool?)e__7.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)e__7.get("this_z_p_ocsStatus"):((int?)e__7.get("this_z_p_ocsStatus") == 2 || (int?)e__7.get("this_z_p_ocsStatus") == 3?(int?)e__7.get("this_z_p_ocsStatus"):0)); ItlUpdateObject c161 = new ItlUpdateObject("ocsCol:association", null, e__7); ; c161.setField("ocsStatus", newStatus__4, "integer", "ocs:card"); if(c161.exec()) { ItlCreate c163 = new ItlCreate("ocs:log", null, null); ; c163.setAssociation("card", e__7, "object:ocs:card", "ocs:log", true, false); c163.setField("userLogin", EC.itl.login(), "string", "ocs:log", 255); c163.setField("date", EC.itl.now(), "date", "ocs:log"); c163.setField("comment", "", "string", "ocs:log", 255); c163.setField("cardStatus", newStatus__4, "integer", "ocs:log"); if(c163.exec()) { } else { } } else { } } } else { ocsMultipleActionNotOkCount = (int?)(ITL.gv["ocsMultipleActionNotOkCount"] = ITL.i((int?)ITL.gv["ocsMultipleActionNotOkCount"]) + 1); } } } e__7.finish(); } } } } %>

Entreprises (<% ITL.show(EC.itl.toInteger(new SqlCollection("ocsCol:association", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT this.title AS this_p_title, this.`_oid` AS this, this.`_oid` AS data 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 = 'entreprises')) AS this", new Map(), (List) EC.newList(new List(), "this_p_title")).get("result")), "string", "html", "integer"); %>)
    > <% ItlLink link166 = new ItlLink("./gestion_entreprises.aspx"); link166.setParameter("creatorFilter", EC.itl.login()); link166.show(); %> Mes fiches (<% ITL.show(EC.itl.toInteger(new SqlCollection("ocsCol:association", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT this.title AS this_p_title, this.`_oid` AS this, this.`_oid` AS data 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 = 'entreprises') AND (this_z.ocsCreationLogin = #V_0&;)) AS this", new Map("#V_0&;|string", EC.itl.login()), (List) EC.newList(new List(), "this_p_title")).get("result")), "string", "html", "integer"); %>) <% link166.close(); %> > <% ItlLink link168 = new ItlLink("./gestion_entreprises.aspx"); link168.setParameter("statusFilter", 0); link168.show(); %> En rédaction (<% ITL.show(EC.itl.toInteger(new SqlCollection("ocsCol:association", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT this.title AS this_p_title, this.`_oid` AS this, this.`_oid` AS data 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 = 'entreprises') 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)) = 0)) AS this", new Map(), (List) EC.newList(new List(), "this_p_title")).get("result")), "string", "html", "integer"); %>) <% link168.close(); %> <% if(ITL.b(useValidation)) { %> > <% ItlLink link171 = new ItlLink("./gestion_entreprises.aspx"); link171.setParameter("statusFilter", 1); link171.show(); if(ITL.b(hasValidateRight)) { %> A valider <% } else {%> En validation <% } %> (<% ITL.show(EC.itl.toInteger(new SqlCollection("ocsCol:association", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT this.title AS this_p_title, this.`_oid` AS this, this.`_oid` AS data 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 = 'entreprises') 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)) = 1)) AS this", new Map(), (List) EC.newList(new List(), "this_p_title")).get("result")), "string", "html", "integer"); %>) <% link171.close(); %> <% } %> > <% ItlLink link173 = new ItlLink("./gestion_entreprises.aspx"); link173.setParameter("statusFilter", 2); link173.show(); %> Publiées (<% ITL.show(EC.itl.toInteger(new SqlCollection("ocsCol:association", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT this.title AS this_p_title, this.`_oid` AS this, this.`_oid` AS data 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 = 'entreprises') 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)) = 2)) AS this", new Map(), (List) EC.newList(new List(), "this_p_title")).get("result")), "string", "html", "integer"); %>) <% link173.close(); %> > <% ItlLink link175 = new ItlLink("./gestion_entreprises.aspx"); link175.setParameter("statusFilter", 3); link175.show(); %> Archivées (<% ITL.show(EC.itl.toInteger(new SqlCollection("ocsCol:association", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT this.title AS this_p_title, this.`_oid` AS this, this.`_oid` AS data 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 = 'entreprises') 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)) AS this", new Map(), (List) EC.newList(new List(), "this_p_title")).get("result")), "string", "html", "integer"); %>) <% link175.close(); %> <% if(ITL.b(hasNewCardRight)) { %> > <% ItlLink link178 = new ItlLink("./gestion_entreprises.aspx"); link178.setParameter("mode", "new"); link178.show(); %> Créer une nouvelle fiche <% link178.close(); %> <% } %> <% if((string)ITL.gv["compiledMode"] == "list" || (string)ITL.gv["compiledMode"] == "card") { %>

    Rechercher

    <%ItlForm form180 = new ItlForm("form180", EC.itl.getId(), "./gestion_entreprises.aspx", "G00011380_181"); form180.setProperty("hasProcessing", false); form180.addParameter("mode", "list"); form180.addParameter("statusFilter", EC.itl.makeParameter(statusFilter__1, "integer")); form180.addParameter("creatorFilter", EC.itl.makeParameter(creatorFilter__1, "string")); form180.show(); %>

    />

    <%form180.close(); } if((string)ITL.gv["compiledMode"] == "card" || (string)ITL.gv["compiledMode"] == "modify" || (string)ITL.gv["compiledMode"] == "new") { %>

    Infos de la fiche

    Créée le : <% if((string)ITL.gv["compiledMode"] == "new") { ITL.show(EC.itl.now(), "date", "html", "date"); } else { ITL.show((DateTime?)card__1.get("this_z_p_ocsCreationDate"), "string", "html", "date"); } %>

    Par : <% if((string)ITL.gv["compiledMode"] == "new") { ITL.show(EC.itl.login(), "string", "html", "string"); } else { ITL.show((string)card__1.get("this_z_p_ocsCreationLogin"), "string", "html", "string"); } %>

    <% if((string)ITL.gv["compiledMode"] != "new") { %>

    Dernière modification le : <% ITL.show((DateTime?)card__1.get("this_z_p_ocsModificationDate"), "string", "html", "date"); %>

    Par : <% ITL.show((string)card__1.get("this_z_p_ocsModificationLogin"), "string", "html", "string"); %>

    Etat : <% if(((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)) == 0) { %> En rédaction <% } else if(((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)) == 1) { if(ITL.b(hasValidateRight)) { %> A valider <% } else {%> En validation <% } } else if(((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)) == 2) { %> Publiée <% } else if(((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)) == 3) { %> Archivée <% } %>

    <% if(ITL.b(useXRM)) { %>

    Catégories de filtrage : <% string _t6 = EC.sqlEngine.getCategoryLabelsFromMask(card__1.get("this_z_x_ocsVisibility_masks")); ITL.show(((ITL.b(_t6)) ? _t6 : "Aucune"), "string", "html", "string"); %>

    <% } } %>
    <% } %>
    Retour au site
    <% if(!EC.itl.isReplay() && EC.itl.startsWith(ITL.S(action__1), "multiple-") && (int?)ITL.gv["ocsMultipleActionNotOkCount"] != 0) { %>
         
     

    Attention : seul <% ITL.show((int?)ITL.gv["ocsMultipleActionOkCount"], "string", "html", "integer"); %> fiches sur <% ITL.show((int?)ITL.gv["ocsMultipleActionCount"], "string", "html", "integer"); %> ont été traitées.

    Vous ne disposez pas des droits suffisant pour effectuer cette opération sur les <% ITL.show((int?)ITL.gv["ocsMultipleActionNotOkCount"], "string", "html", "integer"); %> autres fiches sélectionnées.

    		  
         
    <% } if((string)ITL.gv["compiledMode"] == "card") { %>

    Actions sur la fiche

      <% if((ITL.b((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation"))?EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0:EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0 && ((string)card__1.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)card__1.get("this_z_p_ocsCreationLogin") == EC.itl.login():true)) && ((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)) != 0 || EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0 && ((string)card__1.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)card__1.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) && ((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)) != 2) { %>
    • <% ItlLink link191 = new ItlLink("./gestion_entreprises.aspx"); link191.setProperty("class", "modify"); link191.setParameter("mode", "modify"); link191.setParameter("card", (int?)card__1.get("this")); link191.show(); %> Modifier la fiche <% link191.close(); %>
      • <% } %>
    • <% ItlLink link192 = new ItlLink("./log00011380.aspx"); link192.setProperty("target", "ocsLog"); link192.setProperty("class", "seeLog"); link192.setProperty("onclick", "window.open('about:blank','ocsLog','location=0,menubar=0,toolbar=0,resizable=1,status=1');return true;"); link192.setParameter("card", (int?)card__1.get("this")); link192.show(); %> Voir l'historique <% link192.close(); %>
      • <% if((ITL.b((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation"))?EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0:EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0 && ((string)card__1.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)card__1.get("this_z_p_ocsCreationLogin") == EC.itl.login():true)) && ((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)) != 0 || EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0 && ((string)card__1.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)card__1.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) && ((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)) != 2) { %>
    • <% ItlLink link197 = new ItlLink("./gestion_entreprises.aspx"); link197.setProperty("onclick", "return ocsConfirmDelete();"); link197.setProperty("class", "delete"); link197.setParameter("action", "delete"); link197.setParameter("card", (int?)card__1.get("this")); link197.show(); %> Supprimer la fiche <% link197.close(); %>
      • <% } if(ITL.b(hasNewCardRight)) { %>
    • <% ItlLink link199 = new ItlLink("./gestion_entreprises.aspx"); link199.setProperty("class", "clone"); link199.setParameter("mode", "new"); link199.setParameter("card", (int?)card__1.get("this")); link199.show(); %> Cloner la fiche <% link199.close(); %>
      • <% } %> <% } %>
           
        <% if((string)ITL.gv["compiledMode"] == "new" || (string)ITL.gv["compiledMode"] == "modify") { %>
      <% ItlLink link200 = new ItlLink("./gestion_entreprises.aspx"); link200.setProperty("renderstyle.aClass", "admButton"); link200.setProperty("renderstyle.spanClass", "admButtonSpan"); link200.setProperty("renderstyle", "button"); link200.setParameter("card", (int?)card__1.get("this")); link200.setParameter("mode", (string)ITL.gv["compiledMode"] == "modify"?"card":"list"); link200.show(); %>Annuler<% link200.close(); ItlLink link201 = new ItlLink("./gestion_entreprises.aspx"); link201.setProperty("renderstyle.aClass", "admButton"); link201.setProperty("renderstyle.spanClass", "admButtonSpan"); link201.setProperty("renderstyle", "button"); link201.setProperty("onclick", "document.forms.editCard.elements.submitButton.click();return false;"); link201.show(); %>Enregistrer<% link201.close(); %>
      <%ItlForm form202 = new ItlForm("form202", EC.itl.getId(), "./gestion_entreprises.aspx", "G00011380_203"); form202.setProperty("name", "editCard"); form202.setProperty("method", "POST"); form202.setProperty("enctype", "multipart/form-data"); form202.setProperty("hasProcessing", false); form202.addParameter("card", EC.itl.makeParameter(card__1, "object")); form202.addParameter("mode", "list"); form202.addParameter("action", EC.itl.makeParameter((string)ITL.gv["compiledMode"], "string")); form202.show(); %>

      <% if((string)ITL.gv["compiledMode"] == "modify") { %> Modification : <% ITL.show((string)card__1.get("this_p_title"), "string", "html", "string"); } else {%> Nouvelle fiche /> <% } %>

      <%EC.itl.pushTab();%><%EC.itl.resetCurrentTab();%>
      <%EC.itl.generateCurrentTabAnchor();%>

      Association / Organisme

      <%OdfControl input204 = OdfControlFactory.create("generic", "controlcard_title", "card.title", null); input204.setForm(form202); input204.setProperty("width", "600"); input204.setProperty("comment", "Libellé"); input204.setProperty("kind", "required"); input204.setProperty("missingreason", "Le champ Libellé est obligatoire"); input204.setProperty("value", EC.itl.makeParameter((string)card__1.get("this_p_title"), "string")); input204.setProperty("maxlength", 255); input204.show(); %>
      <%OdfControl input205 = OdfControlFactory.create("generic", "controlcard_person_in_charge", "card.person_in_charge", null); input205.setForm(form202); input205.setProperty("width", "600"); input205.setProperty("comment", "Nom du responsable"); input205.setProperty("value", EC.itl.makeParameter((string)card__1.get("this_p_person_in_charge"), "string")); input205.setProperty("maxlength", 255); input205.show(); %>
      <%OdfControl input206 = OdfControlFactory.create("generic", "controlcard_person_title", "card.person_title", null); input206.setForm(form202); input206.setProperty("width", "600"); input206.setProperty("comment", "Titre du responsable"); input206.setProperty("value", EC.itl.makeParameter((string)card__1.get("this_p_person_title"), "string")); input206.setProperty("maxlength", 32); input206.show(); %>
      <%OdfControl input207 = OdfControlFactory.create("date", "controlcard_creationDate", "card.creationDate", null); input207.setForm(form202); input207.setProperty("width", ""); input207.setProperty("comment", "Date de création"); input207.setProperty("value", EC.itl.makeParameter((DateTime?)card__1.get("this_p_creationDate"), "date")); input207.show(); %>
      <%OdfControl input208 = OdfControlFactory.create("textArea", "controlcard_object", "card.object", null); input208.setForm(form202); input208.setProperty("width", "600"); input208.setProperty("height", "80"); input208.setProperty("comment", "Objet"); input208.setProperty("value", EC.itl.makeParameter((string)card__1.get("this_p_object"), "string")); input208.setProperty("maxlength", 255); input208.show(); %>
      <%OdfControl input209 = OdfControlFactory.create("textArea", "controlcard_headOffice", "card.headOffice", null); input209.setForm(form202); input209.setProperty("width", "600"); input209.setProperty("height", "80"); input209.setProperty("comment", "Siège social"); input209.setProperty("value", EC.itl.makeParameter((string)card__1.get("this_p_headOffice"), "string")); input209.setProperty("maxlength", 255); input209.show(); %>
      <%OdfControl input210 = OdfControlFactory.create("image", "controlcard_image", "card.image", null); input210.setForm(form202); input210.setProperty("width", "600"); input210.setProperty("height", "200"); input210.setProperty("comment", "Illustration"); input210.setProperty("value", EC.itl.makeParameter(card__1.getObject("this_s_image", "alb:image"), "object")); input210.setProperty("sourcewidth", (int?)card__1.get("this_s_image_p_width")); input210.setProperty("sourceheight", (int?)card__1.get("this_s_image_p_height")); input210.setProperty("sourceURL", (((EC.globalRootPath + ITL.S((string)card__1.get("this_s_image_z_p_urlDir"))) + ITL.S((string)card__1.get("this_s_image_z_p_filename"))) + ITL.S((string)card__1.get("this_s_image_z_p_extension")))); input210.setProperty("sourcefilename", (string)card__1.get("this_s_image_z_p_filename")); input210.setProperty("sourceextension", (string)card__1.get("this_s_image_z_p_extension")); input210.setProperty("sourcefiledate", (DateTime?)card__1.get("this_s_image_z_p_filedate")); input210.setProperty("sourcefilesize", (int?)card__1.get("this_s_image_z_p_filesize")); input210.setProperty("sourcelabel", (string)card__1.get("this_s_image_z_p_label_fr")); input210.setProperty("sourcedescription", (string)card__1.get("this_s_image_z_p_description_fr")); input210.show(); %>
      <%EC.itl.nextTab();%>
      <%EC.itl.generateCurrentTabAnchor();%>

      Contact

      <%OdfControl input211 = OdfControlFactory.create("textArea", "controlcard_address", "card.address", null); input211.setForm(form202); input211.setProperty("width", "600"); input211.setProperty("height", "80"); input211.setProperty("comment", "Adresse"); input211.setProperty("value", EC.itl.makeParameter((string)card__1.get("this_p_address"), "string")); input211.setProperty("maxlength", 1000); input211.show(); %>
      <%OdfControl input212 = OdfControlFactory.create("textArea", "controlcard_contact", "card.contact", null); input212.setForm(form202); input212.setProperty("width", "600"); input212.setProperty("height", "80"); input212.setProperty("comment", "Contact"); input212.setProperty("value", EC.itl.makeParameter((string)card__1.get("this_p_contact"), "string")); input212.setProperty("maxlength", 1000); input212.show(); %>
      <%OdfControl input213 = OdfControlFactory.create("generic", "controlcard_email", "card.email", null); input213.setForm(form202); input213.setProperty("width", "600"); input213.setProperty("comment", "Adresse mail"); input213.setProperty("value", EC.itl.makeParameter((string)card__1.get("this_p_email"), "string")); input213.setProperty("maxlength", 255); input213.show(); %>
      <%OdfControl input214 = OdfControlFactory.create("generic", "controlcard_phoneNumber", "card.phoneNumber", null); input214.setForm(form202); input214.setProperty("width", "120"); input214.setProperty("comment", "Numéro de téléphone"); input214.setProperty("value", EC.itl.makeParameter((string)card__1.get("this_p_phoneNumber"), "string")); input214.setProperty("maxlength", 25); input214.show(); %>
      <%OdfControl input215 = OdfControlFactory.create("generic", "controlcard_mobilePhone", "card.mobilePhone", null); input215.setForm(form202); input215.setProperty("width", "120"); input215.setProperty("comment", "Téléphone mobile"); input215.setProperty("value", EC.itl.makeParameter((string)card__1.get("this_p_mobilePhone"), "string")); input215.setProperty("maxlength", 25); input215.show(); %>
      <%OdfControl input216 = OdfControlFactory.create("generic", "controlcard_fax", "card.fax", null); input216.setForm(form202); input216.setProperty("width", "120"); input216.setProperty("comment", "Télécopie"); input216.setProperty("value", EC.itl.makeParameter((string)card__1.get("this_p_fax"), "string")); input216.setProperty("maxlength", 25); input216.show(); %>
      <%EC.itl.nextTab();%>
      <%EC.itl.generateCurrentTabAnchor();%>

      Informations complémentaires

      <%OdfControl input217 = OdfControlFactory.create("generic", "controlcard_website", "card.website", null); input217.setForm(form202); input217.setProperty("width", "600"); input217.setProperty("comment", "Site internet"); input217.setProperty("value", EC.itl.makeParameter((string)card__1.get("this_p_website"), "string")); input217.setProperty("maxlength", 255); input217.show(); %>
      <%OdfControl input218 = OdfControlFactory.create("dhtml", "controlcard_comment", "card.comment", null); input218.setForm(form202); input218.setProperty("width", "600"); input218.setProperty("height", "100"); input218.setProperty("comment", "Commentaire"); input218.setProperty("value", EC.itl.makeParameter((string)card__1.get("this_p_comment"), "string")); input218.show(); %>
      <%EC.itl.nextTab();%>
      <%EC.itl.generateCurrentTabAnchor();%>

      Visibilité / Mots-clés

      <% if(useXRM == true && EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT this.label_fr AS this_p_label_fr, this.`_oid` AS this, this.`_oid` AS data FROM xrm_category AS this WHERE (this.iso_sid <> '')) AS this", new Map(), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0) { %><% } %>
      <%OdfControl input221 = OdfControlFactory.create("xrmFilter", "controlcard_ocsVisibility", "card.ocsVisibility", null); input221.setForm(form202); input221.setProperty("width", "600"); input221.setProperty("height", "100"); input221.setProperty("columns", 2); input221.setProperty("comment", "Visibilité dans le site"); input221.setProperty("value", EC.itl.makeParameter(card__1.getCollection("ocsVisibility", "xrm:category", true, true), "collection")); ItlEnumerator e223 = new ItlEnumerator("G00011380_222", null, false); e223.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("xrm:category", @"SELECT this.`_oid` AS this, this.rank AS o_1 FROM xrm_category AS this WHERE (this.iso_sid <> '')", new ItlRuntime.SQL.Parameters(), new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_1", true)), new ItlRuntime.SQL.OptionalOrderAliases(), null, null), @"SELECT DISTINCT this.`_oid` AS this, this.gid AS this_p_gid, this.label_fr AS this_p_label_fr FROM xrm_category AS this WHERE (this.iso_sid <> '')", new Map(), false, (List) EC.newList(new List()), null, null)); ItlEnumerator c__5 = (ItlEnumerator) (e223); c__5.reset(); if(c__5.isNotEmpty()) { c__5.resetGroup(); for(c__5.start();c__5.test();c__5.fetch()) { input221.addOption(EC.itl.makeParameter(((ITL.S((string)c__5.get("this_p_gid")) + ":") + ITL.S((int?)c__5.get("this"))), "string"), (string)c__5.get("this_p_label_fr"), new Map()); } } c__5.finish(); input221.show(); %>
      <%OdfControl input225 = OdfControlFactory.create("keyword", "controlcard_filter", "card.filter", null); input225.setForm(form202); input225.setProperty("width", "600"); input225.setProperty("rootidentifier", ""); input225.setProperty("comment", "Filtre"); input225.setProperty("value", EC.itl.makeParameter(card__1.getCollection("filter", "kwd:keyword", true, true), "collection")); input225.setProperty("popupLink", "./kwdPopup.aspx"); input225.show(); %>
      <%EC.itl.nextTab();EC.itl.popTab();%>
      <% %>
      Cycle de validation
      <% if((string)ITL.gv["compiledMode"] == "new" || ((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)) == 0) { %> /> <% } else {%> /> <% } %> En rédaction
      En rédaction
      <% if(ITL.b(useValidation)) { %>
      <% if((string)ITL.gv["compiledMode"] != "new" && ((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)) == 1) { %> <% } else {%> <% } %> A valider
      A valider
      <% } if((string)ITL.gv["compiledMode"] == "new" && ITL.b(hasValidateRight) || (ITL.b((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation"))?EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0:EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0 && ((string)card__1.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)card__1.get("this_z_p_ocsCreationLogin") == EC.itl.login():true))) { %>
      <% if((string)ITL.gv["compiledMode"] != "new" && ((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)) == 2) { %> /> <% } else {%> /> <% } %> Publiée
      Publiée
      <% } if((string)ITL.gv["compiledMode"] == "new" || EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0 && ((string)card__1.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)card__1.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) || (ITL.b((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation"))?EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0:EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0 && ((string)card__1.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)card__1.get("this_z_p_ocsCreationLogin") == EC.itl.login():true))) { %>
      <% if((string)ITL.gv["compiledMode"] != "new" && ((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)) == 3) { %> /> <% } else {%> /> <% } %> Archivée
      Archivée
      <% } %>

      <% if(ITL.b(useValidation)) { SqlObject _t7 = new SqlObject("ocs:catalog", @"SELECT this.`_oid` AS this FROM ocs_catalog AS this WHERE (this.iso_sid <> '') AND (this.name = 'entreprises')", new Map(),false); SqlObject _t8 = new SqlObject("ocs:catalog", @"SELECT this.`_oid` AS this FROM ocs_catalog AS this WHERE (this.iso_sid <> '') AND (this.name = 'entreprises')", new Map(),false); { OcsNotificationScriptBuilder _scriptBuilder = new OcsNotificationScriptBuilder(); _scriptBuilder.generate((string)card__1.get("this_z_p_ocsCreationLogin"), new SqlCollection("xrm:category", @"SELECT DISTINCT c0.`_oid` AS origin, this.label_fr AS this_p_label_fr, this.`_oid` AS this 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 <> '')", new Map("#V_0&;|integer", (int?)_t7.get("this")), (List) EC.newList(new List(), "this_p_label_fr")).keys(), new SqlCollection("xrm:category", @"SELECT DISTINCT c0.`_oid` AS origin, this.label_fr AS this_p_label_fr, this.`_oid` AS this 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 <> '')", new Map("#V_0&;|integer", (int?)_t8.get("this")), (List) EC.newList(new List(), "this_p_label_fr")).keys(), (int?)card__1.get("this"), ((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)), (string)catalogObject.get("this_p_editRightsMode")); } string message = (string) ((string)ITL.gv["compiledMode"] == "new"?"Nouvelle fiche":((string)ITL.gv["compiledMode"] == "card"?"Nouvel état":"Modification")); string mailSubject = (string) (((("Demande de " + (((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)) == 0?"modification":"validation")) + " de la fiche '") + ITL.S((string)card__1.get("this_p_title"))) + "'"); string mailInfoSubject = (string) (("Information concernant la fiche '" + ITL.S((string)card__1.get("this_p_title"))) + "'"); int messageCtrlWidth = (int) ((string)ITL.gv["compiledMode"] == "card"?725:715); %>
      <%EC.itl.pushTab();%><%EC.itl.resetCurrentTab();%>
      <%EC.itl.generateCurrentTabAnchor();%>

      Demande d'action

      Vous pouvez envoyer une demande d'action aux personnes ayant les droits pour agir sur la fiche.

      Personnes à notifier :


      Sujet de l'e-mail

      <%OdfControl input239 = OdfControlFactory.create("generic", EC.itl.getId(), "ocsNotificationForActionMailSubject", null); input239.setForm(form202); input239.setProperty("width", ITL.S(messageCtrlWidth)); input239.setProperty("value", EC.itl.makeParameter(mailSubject, "string")); input239.show(); %>

      <%OdfControl input240 = OdfControlFactory.create("textArea", EC.itl.getId(), "ocsNotificationForActionMessage", null); input240.setForm(form202); input240.setProperty("width", ITL.S(messageCtrlWidth)); input240.setProperty("height", "54"); input240.setProperty("value", EC.itl.makeParameter(message, "string")); input240.show(); %>

      <%EC.itl.nextTab();%>
      <%EC.itl.generateCurrentTabAnchor();%>

      Information

      Vous pouvez envoyer une information concernant la fiche aux personnes ayant collaboré à sa publication.

      Personnes à notifier :


      Sujet de l'e-mail

      <%OdfControl input241 = OdfControlFactory.create("generic", EC.itl.getId(), "ocsNotificationForInfoMailSubject", null); input241.setForm(form202); input241.setProperty("width", ITL.S(messageCtrlWidth)); input241.setProperty("value", EC.itl.makeParameter(mailInfoSubject, "string")); input241.show(); %>

      <%OdfControl input242 = OdfControlFactory.create("textArea", EC.itl.getId(), "ocsNotificationForInfoMessage", null); input242.setForm(form202); input242.setProperty("width", ITL.S(messageCtrlWidth)); input242.setProperty("height", "54"); input242.setProperty("value", EC.itl.makeParameter(message, "string")); input242.show(); %>

      <%EC.itl.nextTab();EC.itl.popTab();%>
      <% } %>

      <%OdfControl input243 = OdfControlFactory.create("textArea", EC.itl.getId(), "logComment", null); input243.setForm(form202); input243.setProperty("width", "725"); input243.setProperty("height", "54"); input243.setProperty("value", EC.itl.makeParameter(((string)ITL.gv["compiledMode"] != "modify"?"Création de la fiche":""), "string")); input243.show(); %>


      <% ItlLink link244 = new ItlLink("./gestion_entreprises.aspx"); link244.setProperty("renderstyle.aClass", "admButton"); link244.setProperty("renderstyle.spanClass", "admButtonSpan"); link244.setProperty("renderstyle", "button"); link244.setParameter("card", (int?)card__1.get("this")); link244.setParameter("mode", (string)ITL.gv["compiledMode"] == "modify"?"card":"list"); link244.show(); %>Annuler<% link244.close(); ItlLink link245 = new ItlLink("./gestion_entreprises.aspx"); link245.setProperty("renderstyle.aClass", "admButton"); link245.setProperty("renderstyle.spanClass", "admButtonSpan"); link245.setProperty("renderstyle", "button"); link245.setProperty("onclick", "document.forms.editCard.elements.submitButton.click();return false;"); link245.show(); %>Enregistrer<% link245.close(); %>
      <%form202.close(); } else if((string)ITL.gv["compiledMode"] == "card") { %>

      Fiche : <% ITL.show((string)card__1.get("this_p_title"), "string", "html", "string"); %>

      <% columnWidth = (string)(ITL.gv["columnWidth"] = "width: 48%;");%>
      <% if(EC.itl.toBoolean(card__1.getObject("this_s_image", "alb:image"))) { %>
      <% ItlImage image248 = new ItlImage("alb:image", card__1.getObject("this_s_image", "alb:image"), (int?)card__1.get("this_s_image_p_width"), (int?)card__1.get("this_s_image_p_height"), (int?)card__1.get("this_s_image_p_frames")); image248.setProperty("maxWidth", 200); image248.setProperty("maxHeight", 200); image248.setProperty("title", (string)card__1.get("this_s_image_z_p_label_fr")); image248.setProperty("alt", (string)card__1.get("this_s_image_z_p_label_fr")); image248.setProperty("longdesc", (string)card__1.get("this_s_image_z_p_description_fr")); image248.show(); %>
      <% } else { columnWidth = (string)(ITL.gv["columnWidth"] = "width: 97%;"); } %>
      <% if(ITL.b((DateTime?)card__1.get("this_p_creationDate"))) { %><% } if(ITL.b((string)card__1.get("this_p_headOffice"))) { %><% } if(ITL.b((string)card__1.get("this_p_person_in_charge"))) { %><% } if(ITL.b((string)card__1.get("this_p_contact"))) { %><% } if(ITL.b((string)card__1.get("this_p_address"))) { %><% } if(ITL.b((string)card__1.get("this_p_phoneNumber"))) { %><% } if(ITL.b((string)card__1.get("this_p_mobilePhone"))) { %><% } if(ITL.b((string)card__1.get("this_p_fax"))) { %><% } %>
      Date de la création :<% ITL.show((DateTime?)card__1.get("this_p_creationDate"), "string", "html", "date"); %>
      Siège social :<% ITL.show((string)card__1.get("this_p_headOffice"), "string", "memo", "string"); %>
      Nom du responsable :<% ITL.show((string)card__1.get("this_p_person_in_charge"), "string", "html", "string"); %>(<% ITL.show((string)card__1.get("this_p_person_title"), "string", "html", "string"); %>)
      Qui contacter :<% ITL.show((string)card__1.get("this_p_contact"), "string", "memo", "string"); %>
      Adresse :<% ITL.show((string)card__1.get("this_p_address"), "string", "memo", "string"); %>
      Numéro de téléphone :<% ITL.show((string)card__1.get("this_p_phoneNumber"), "string", "html", "string"); %>
      Téléphone mobile :<% ITL.show((string)card__1.get("this_p_mobilePhone"), "string", "html", "string"); %>
      Télécopie :<% ITL.show((string)card__1.get("this_p_fax"), "string", "html", "string"); %>
        <% if(ITL.b((string)card__1.get("this_p_website"))) { %>
      • target="_blank">Site Internet
        • <% } if(ITL.b((string)card__1.get("this_p_email"))) { %>
      • >Envoyer un mail
        • <% } %>


      <% if(ITL.b((string)card__1.get("this_p_comment"))) { %>

      <% ITL.show((string)card__1.get("this_p_comment"), "string", "direct", "string"); %>

      <% } %>
      <% } else if((string)ITL.gv["compiledMode"] == "list") { int cardcount = (int) (ITL.i(EC.itl.toInteger(new SqlCollection("ocsCol:association", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT this.title AS this_p_title, this.`_oid` AS this, this.`_oid` AS data 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 = 'entreprises') AND (#V_0&; OR (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_1&;)) AND (#V_2&; OR (this_z.ocsCreationLogin = #V_3&;)) AND (#V_4&; OR ((this.title LIKE CONCAT('%', #V_5&;, '%')) OR ((this.object LIKE CONCAT('%', #V_5&;, '%')) OR ((this.headOffice LIKE CONCAT('%', #V_5&;, '%')) OR ((this.person_in_charge LIKE CONCAT('%', #V_5&;, '%')) OR ((this.person_title LIKE CONCAT('%', #V_5&;, '%')) OR ((this.address LIKE CONCAT('%', #V_5&;, '%')) OR ((this.contact LIKE CONCAT('%', #V_5&;, '%')) OR ((this.phoneNumber LIKE CONCAT('%', #V_5&;, '%')) OR ((this.mobilePhone LIKE CONCAT('%', #V_5&;, '%')) OR ((this.fax LIKE CONCAT('%', #V_5&;, '%')) OR ((this.email LIKE CONCAT('%', #V_5&;, '%')) OR (this.website LIKE CONCAT('%', #V_5&;, '%')))))))))))))) 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)) AS this", new Map("#V_0&;|boolean", (statusFilter__1 == -1), "#V_1&;|integer", statusFilter__1, "#V_2&;|boolean", (creatorFilter__1 == ""), "#V_3&;|string", creatorFilter__1, "#V_4&;|boolean", (searchFilter__1 == ""), "#V_5&;|string", ITL.S(searchFilter__1)), (List) EC.newList(new List(), "this_p_title")).get("result"))) + ITL.i(EC.itl.toInteger(new SqlCollection("ocsCol:association", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT this.title AS this_p_title, this.`_oid` AS this, this.`_oid` AS data 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 = 'entreprises') AND (#V_0&; OR (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_1&;)) AND (#V_2&; OR (this_z.ocsCreationLogin = #V_3&;)) AND (#V_4&; OR ((this.title LIKE CONCAT('%', #V_5&;, '%')) OR ((this.object LIKE CONCAT('%', #V_5&;, '%')) OR ((this.headOffice LIKE CONCAT('%', #V_5&;, '%')) OR ((this.person_in_charge LIKE CONCAT('%', #V_5&;, '%')) OR ((this.person_title LIKE CONCAT('%', #V_5&;, '%')) OR ((this.address LIKE CONCAT('%', #V_5&;, '%')) OR ((this.contact LIKE CONCAT('%', #V_5&;, '%')) OR ((this.phoneNumber LIKE CONCAT('%', #V_5&;, '%')) OR ((this.mobilePhone LIKE CONCAT('%', #V_5&;, '%')) OR ((this.fax LIKE CONCAT('%', #V_5&;, '%')) OR ((this.email LIKE CONCAT('%', #V_5&;, '%')) OR (this.website LIKE CONCAT('%', #V_5&;, '%')))))))))))))) 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)) AS this", new Map("#V_0&;|boolean", (statusFilter__1 == -1), "#V_1&;|integer", statusFilter__1, "#V_2&;|boolean", (creatorFilter__1 == ""), "#V_3&;|string", creatorFilter__1, "#V_4&;|boolean", (searchFilter__1 == ""), "#V_5&;|string", ITL.S(searchFilter__1)), (List) EC.newList(new List(), "this_p_title")).get("result")))); %>

      <% if(cardcount > 1) { ITL.show(cardcount, "string", "html", "integer"); %> fiches <% if(searchFilter__1 != "") { %> contiennent le texte "<% ITL.show(searchFilter__1, "string", "html", "string"); %>"<% } %>. <% } else if(cardcount == 1) { %> 1 fiche <% if(searchFilter__1 != "") { %> contient le texte "<% ITL.show(searchFilter__1, "string", "html", "string"); %>"<% } %>. <% } %>

      Choisissez la fiche à administrer

      <% string helpLink = (string) (""); if(statusFilter__1 == 0 || statusFilter__1 == 1 || statusFilter__1 == 2) { bool hasActionRight = (bool) ((statusFilter__1 == -1 || statusFilter__1 == 3) && (ITL.b(hasNewCardRight) || ITL.b(hasValidateRight)) || statusFilter__1 == 0 && ITL.b(hasNewCardRight) || (statusFilter__1 == 1 || statusFilter__1 == 2) && ITL.b(hasValidateRight)); ItlForm form269 = new ItlForm("form269", EC.itl.getId(), "#", "G00011380_270"); form269.setProperty("method", "post"); form269.setProperty("name", "fake"); form269.setProperty("hasProcessing", false); form269.show(); int? sdsLimit = (int?) ((int?)EC.itl.getParameterValue("integer", "sdsLimit", 15)); %>
      <% ItlEnumerator e275 = new ItlEnumerator("G00011380_274", null, false); e275.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("ocsCol:association", @"SELECT this.`_oid` AS this, this.title AS o_1, this.title AS o_2, this.object AS o_3, this_z.ocsStatus AS o_4, this_z.ocsCreationDate AS o_5 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 = 'entreprises') AND (#V_0&; OR (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_1&;)) AND (#V_2&; OR (this_z.ocsCreationLogin = #V_3&;)) AND (#V_4&; OR ((this.title LIKE CONCAT('%', #V_5&;, '%')) OR ((this.object LIKE CONCAT('%', #V_5&;, '%')) OR ((this.headOffice LIKE CONCAT('%', #V_5&;, '%')) OR ((this.person_in_charge LIKE CONCAT('%', #V_5&;, '%')) OR ((this.person_title LIKE CONCAT('%', #V_5&;, '%')) OR ((this.address LIKE CONCAT('%', #V_5&;, '%')) OR ((this.contact LIKE CONCAT('%', #V_5&;, '%')) OR ((this.phoneNumber LIKE CONCAT('%', #V_5&;, '%')) OR ((this.mobilePhone LIKE CONCAT('%', #V_5&;, '%')) OR ((this.fax LIKE CONCAT('%', #V_5&;, '%')) OR ((this.email LIKE CONCAT('%', #V_5&;, '%')) OR (this.website LIKE CONCAT('%', #V_5&;, '%')))))))))))))) 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&;", (statusFilter__1 == -1), "boolean"), new ItlRuntime.SQL.Parameter("#V_1&;", statusFilter__1, "integer"), new ItlRuntime.SQL.Parameter("#V_2&;", (creatorFilter__1 == ""), "boolean"), new ItlRuntime.SQL.Parameter("#V_3&;", creatorFilter__1, "string"), new ItlRuntime.SQL.Parameter("#V_4&;", (searchFilter__1 == ""), "boolean"), new ItlRuntime.SQL.Parameter("#V_5&;", ITL.S(searchFilter__1), "string")), new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_1", true)), new ItlRuntime.SQL.OptionalOrderAliases(new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_2", true)), new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_3", true)), new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_4", true)), new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_5", true))), null, null), @"SELECT this.`_oid` AS this, this_z_s_ocsCatalog.`_oid` AS this_z_s_ocsCatalog, this_k_1.result1 AS this_k_1_1, this_k_2.result1 AS this_k_2_1, this.title AS this_p_title, this.object AS this_p_object, this_z.ocsStatus AS this_z_p_ocsStatus, this_z.ocsCreationDate AS this_z_p_ocsCreationDate, this_z.ocsCreationLogin AS this_z_p_ocsCreationLogin, this_z_s_ocsCatalog.useValidation AS this_z_s_ocsCatalog_p_useValidation, this_z_s_ocsCatalog.editRightsMode AS this_z_s_ocsCatalog_p_editRightsMode 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 <> '')) LEFT JOIN (SELECT c1.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> ''))) On ((this.`_oid` = c0_l.`_to`) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.`_oid` IN (#V_0&;)) GROUP BY c1.`_oid`) AS this_k_1 On (this.`_oid` = this_k_1.origin) LEFT JOIN (SELECT c1.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.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 c1.`_oid`) AS this_k_2 On (this.`_oid` = this_k_2.origin) WHERE (this.iso_sid <> '')", new Map("#V_0&;|oids", EC.itl.categoryOids(true), "#V_1&;|oids", EC.itl.categoryOids(true)), true, (List) EC.newList(new List(), 1, 1, 1, 1), (int?)null, (int?)null)); e275.setLimit(sdsLimit); e275.setLimits("15 50 100 all"); e275.setNavigationFeatures("firstPage previousPage lastPage nextPage allPages"); ItlEnumerator card__2 = (ItlEnumerator) (e275); card__2.reset(); if(card__2.isNotEmpty()) { ItlEnumerator tableEnumerator = (ItlEnumerator) (card__2); if(mode__1 == "edit") { %>

      Correction de la fiche "<% ITL.show((string)card__2.get("this_p_title"), "string", "html", "string"); %>"

      <% } %> <% columnCount = (int?)(ITL.gv["columnCount"] = 1);%><% columnCount = (int?)(ITL.gv["columnCount"] = 2); %><% columnCount = (int?)(ITL.gv["columnCount"] = 3);%><% columnCount = (int?)(ITL.gv["columnCount"] = 4); %><% columnCount = (int?)(ITL.gv["columnCount"] = 5); %><% columnCount = (int?)(ITL.gv["columnCount"] = 6); %><% if(tableEnumerator.needNavigationBar()) { %><% } %><% %><% %><% %><% %><% %><% if(tableEnumerator.needNavigationBar()) { %><% } if(tableEnumerator.count() > 1 && false) { %><% } %><% %><% card__2.resetGroup(); for(card__2.start();card__2.test();card__2.fetch()) { string oddEven = (string) (tableEnumerator.positionInPage() % 2 == 1?"odd":"even"); %>><% %><% %><% %><% %><% }%>
      <% ItlLink link287 = new ItlLink("./xls00011380.aspx"); link287.setParameter("statusFilter", statusFilter__1); link287.setParameter("creatorFilter", creatorFilter__1); link287.setParameter("cardType", cardType); link287.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link287, "link287");%> Exporter <% if(ITL.b(hasActionRight)) { ItlLink link289 = new ItlLink("./gestion_entreprises.aspx"); link289.setParameter("action", "multiple-delete"); link289.setParameter("statusFilter", statusFilter__1); link289.setParameter("creatorFilter", creatorFilter__1); link289.setParameter("cardType", cardType); link289.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link289, "link289");%> Supprimer <% } if(statusFilter__1 != 0 && ITL.b(hasActionRight)) { ItlLink link291 = new ItlLink("./gestion_entreprises.aspx"); link291.setParameter("action", "multiple-changeStatus"); link291.setParameter("newStatus", 0); link291.setParameter("statusFilter", statusFilter__1); link291.setParameter("creatorFilter", creatorFilter__1); link291.setParameter("cardType", cardType); link291.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link291, "link291");%> En rédaction <% } if(ITL.b(useValidation) && statusFilter__1 != 1 && ITL.b(hasActionRight)) { ItlLink link293 = new ItlLink("./gestion_entreprises.aspx"); link293.setParameter("action", "multiple-changeStatus"); link293.setParameter("newStatus", 1); link293.setParameter("statusFilter", statusFilter__1); link293.setParameter("creatorFilter", creatorFilter__1); link293.setParameter("cardType", cardType); link293.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link293, "link293");%> A valider <% } if(statusFilter__1 != 2 && ITL.b(hasValidateRight)) { ItlLink link295 = new ItlLink("./gestion_entreprises.aspx"); link295.setParameter("action", "multiple-changeStatus"); link295.setParameter("newStatus", 2); link295.setParameter("statusFilter", statusFilter__1); link295.setParameter("creatorFilter", creatorFilter__1); link295.setParameter("cardType", cardType); link295.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link295, "link295");%> Publier <% } if(statusFilter__1 != 3 && (statusFilter__1 != -1 || cardType != "archive") && ITL.b(hasActionRight)) { ItlLink link297 = new ItlLink("./gestion_entreprises.aspx"); link297.setParameter("action", "multiple-changeStatus"); link297.setParameter("newStatus", 3); link297.setParameter("statusFilter", statusFilter__1); link297.setParameter("creatorFilter", creatorFilter__1); link297.setParameter("cardType", cardType); link297.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link297, "link297");%> Archiver <% } %>
        pas de fiches sélectionnées
      <% if(tableEnumerator.count() == 1) { %>1 fiche<% } else if(tableEnumerator.isOverflow()) { %> > <% ITL.show(EC.itl.translate("%1 fiches", ITL.S(tableEnumerator.count())), "string", "raw", "string"); } else { ITL.show(EC.itl.translate("%1 fiches", ITL.S(tableEnumerator.count())), "string", "raw", "string"); } %>
      Nombre de fiches à afficher  <% ITL.show(tableEnumerator.limitSelect(), "string", "raw", "string"); %>
      <% ITL.show(tableEnumerator.navigationBar(), "string", "raw", "string"); %>
       Libellé<% if(tableEnumerator.count() > 1) { %>v^<% } %>Objet<% if(tableEnumerator.count() > 1) { %>v^<% } %>Etat :<% if(tableEnumerator.count() > 1) { %>v^<% } %>Postée le<% if(tableEnumerator.count() > 1) { %>v^<% } %>
      <% ITL.show(tableEnumerator.navigationBar(), "string", "raw", "string"); %>
      <% if(tableEnumerator.count() == 1) { %>1 fiche<% } else if(tableEnumerator.isOverflow()) { %> > <% ITL.show(EC.itl.translate("%1 fiches", ITL.S(tableEnumerator.count())), "string", "raw", "string"); } else { ITL.show(EC.itl.translate("%1 fiches", ITL.S(tableEnumerator.count())), "string", "raw", "string"); } %>
      Nombre de fiches à afficher  <% ITL.show(tableEnumerator.limitSelect(), "string", "raw", "string"); %>
        pas de fiches sélectionnées
      <% ItlLink link326 = new ItlLink("./xls00011380.aspx"); link326.setParameter("statusFilter", statusFilter__1); link326.setParameter("creatorFilter", creatorFilter__1); link326.setParameter("cardType", cardType); link326.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link326, "link326");%> Exporter <% if(ITL.b(hasActionRight)) { ItlLink link328 = new ItlLink("./gestion_entreprises.aspx"); link328.setParameter("action", "multiple-delete"); link328.setParameter("statusFilter", statusFilter__1); link328.setParameter("creatorFilter", creatorFilter__1); link328.setParameter("cardType", cardType); link328.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link328, "link328");%> Supprimer <% } if(statusFilter__1 != 0 && ITL.b(hasActionRight)) { ItlLink link330 = new ItlLink("./gestion_entreprises.aspx"); link330.setParameter("action", "multiple-changeStatus"); link330.setParameter("newStatus", 0); link330.setParameter("statusFilter", statusFilter__1); link330.setParameter("creatorFilter", creatorFilter__1); link330.setParameter("cardType", cardType); link330.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link330, "link330");%> En rédaction <% } if(ITL.b(useValidation) && statusFilter__1 != 1 && ITL.b(hasActionRight)) { ItlLink link332 = new ItlLink("./gestion_entreprises.aspx"); link332.setParameter("action", "multiple-changeStatus"); link332.setParameter("newStatus", 1); link332.setParameter("statusFilter", statusFilter__1); link332.setParameter("creatorFilter", creatorFilter__1); link332.setParameter("cardType", cardType); link332.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link332, "link332");%> A valider <% } if(statusFilter__1 != 2 && ITL.b(hasValidateRight)) { ItlLink link334 = new ItlLink("./gestion_entreprises.aspx"); link334.setParameter("action", "multiple-changeStatus"); link334.setParameter("newStatus", 2); link334.setParameter("statusFilter", statusFilter__1); link334.setParameter("creatorFilter", creatorFilter__1); link334.setParameter("cardType", cardType); link334.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link334, "link334");%> Publier <% } if(statusFilter__1 != 3 && (statusFilter__1 != -1 || cardType != "archive") && ITL.b(hasActionRight)) { ItlLink link336 = new ItlLink("./gestion_entreprises.aspx"); link336.setParameter("action", "multiple-changeStatus"); link336.setParameter("newStatus", 3); link336.setParameter("statusFilter", statusFilter__1); link336.setParameter("creatorFilter", creatorFilter__1); link336.setParameter("cardType", cardType); link336.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link336, "link336");%> Archiver <% } %>
      <% if(tableEnumerator.isObjectSelected()) { %> checked="checked"/><% } else {%>/><% } %> <% if((ITL.b((bool?)card__2.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)card__2.get("this_k_1_1")) > 0:ITL.countDefault((int?)card__2.get("this_k_2_1")) > 0 && ((string)card__2.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)card__2.get("this_z_p_ocsCreationLogin") == EC.itl.login():true)) && ((bool?)card__2.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__2.get("this_z_p_ocsStatus"):((int?)card__2.get("this_z_p_ocsStatus") == 2 || (int?)card__2.get("this_z_p_ocsStatus") == 3?(int?)card__2.get("this_z_p_ocsStatus"):0)) != 0 || ITL.countDefault((int?)card__2.get("this_k_2_1")) > 0 && ((string)card__2.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)card__2.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) && ((bool?)card__2.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__2.get("this_z_p_ocsStatus"):((int?)card__2.get("this_z_p_ocsStatus") == 2 || (int?)card__2.get("this_z_p_ocsStatus") == 3?(int?)card__2.get("this_z_p_ocsStatus"):0)) != 2) { ItlLink link344 = new ItlLink("./gestion_entreprises.aspx"); link344.setProperty("title", "Modifier la fiche"); link344.setProperty("class", "ocsActions"); link344.setParameter("mode", "modify"); link344.setParameter("card", card__2); link344.show(); %> Modifier la fiche <% link344.close(); } if(ITL.b(hasNewCardRight)) { ItlLink link346 = new ItlLink("./gestion_entreprises.aspx"); link346.setProperty("title", "Cloner la fiche"); link346.setProperty("class", "ocsActions"); link346.setParameter("mode", "new"); link346.setParameter("card", card__2); link346.show(); %> Cloner la fiche <% link346.close(); } %> <% ItlLink link350 = new ItlLink("./gestion_entreprises.aspx"); link350.setProperty("title", "Voir la fiche"); link350.setParameter("mode", "card"); link350.setParameter("card", card__2); link350.show(); ITL.show((string)card__2.get("this_p_title"), "string", "html", "string"); link350.close(); %> <% ItlLink link352 = new ItlLink("./gestion_entreprises.aspx"); link352.setProperty("title", "Voir la fiche"); link352.setParameter("mode", "card"); link352.setParameter("card", card__2); link352.show(); ITL.show((string)card__2.get("this_p_object"), "string", "memo", "string"); link352.close(); %> <% if(((bool?)card__2.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__2.get("this_z_p_ocsStatus"):((int?)card__2.get("this_z_p_ocsStatus") == 2 || (int?)card__2.get("this_z_p_ocsStatus") == 3?(int?)card__2.get("this_z_p_ocsStatus"):0)) == 0) { %> En rédaction <% } else if(((bool?)card__2.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__2.get("this_z_p_ocsStatus"):((int?)card__2.get("this_z_p_ocsStatus") == 2 || (int?)card__2.get("this_z_p_ocsStatus") == 3?(int?)card__2.get("this_z_p_ocsStatus"):0)) == 1) { %> /> <% } else if(((bool?)card__2.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__2.get("this_z_p_ocsStatus"):((int?)card__2.get("this_z_p_ocsStatus") == 2 || (int?)card__2.get("this_z_p_ocsStatus") == 3?(int?)card__2.get("this_z_p_ocsStatus"):0)) == 2) { %> Publiée <% } else if(((bool?)card__2.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__2.get("this_z_p_ocsStatus"):((int?)card__2.get("this_z_p_ocsStatus") == 2 || (int?)card__2.get("this_z_p_ocsStatus") == 3?(int?)card__2.get("this_z_p_ocsStatus"):0)) == 3) { %> Archivée <% } %> <% ITL.show((DateTime?)card__2.get("this_z_p_ocsCreationDate"), "string", "html", "date"); %>
      <% } else {%> Aucune fiche. <% } card__2.finish(); %> <%form269.close(); } else if(statusFilter__1 == 3) { bool hasActionRight__1 = (bool) ((statusFilter__1 == -1 || statusFilter__1 == 3) && (ITL.b(hasNewCardRight) || ITL.b(hasValidateRight)) || statusFilter__1 == 0 && ITL.b(hasNewCardRight) || (statusFilter__1 == 1 || statusFilter__1 == 2) && ITL.b(hasValidateRight)); ItlForm form357 = new ItlForm("form357", EC.itl.getId(), "#", "G00011380_358"); form357.setProperty("method", "post"); form357.setProperty("name", "fake"); form357.setProperty("hasProcessing", false); form357.show(); int? sdsLimit__1 = (int?) ((int?)EC.itl.getParameterValue("integer", "sdsLimit", 15)); %>
      <% ItlEnumerator e363 = new ItlEnumerator("G00011380_362", null, false); e363.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("ocsCol:association", @"SELECT this.`_oid` AS this, this.title AS o_1, this.title AS o_2, this.object AS o_3, this_z.ocsStatus AS o_4, this_z.ocsCreationDate AS o_5 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 = 'entreprises') AND (#V_0&; OR (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_1&;)) AND (#V_2&; OR (this_z.ocsCreationLogin = #V_3&;)) AND (#V_4&; OR ((this.title LIKE CONCAT('%', #V_5&;, '%')) OR ((this.object LIKE CONCAT('%', #V_5&;, '%')) OR ((this.headOffice LIKE CONCAT('%', #V_5&;, '%')) OR ((this.person_in_charge LIKE CONCAT('%', #V_5&;, '%')) OR ((this.person_title LIKE CONCAT('%', #V_5&;, '%')) OR ((this.address LIKE CONCAT('%', #V_5&;, '%')) OR ((this.contact LIKE CONCAT('%', #V_5&;, '%')) OR ((this.phoneNumber LIKE CONCAT('%', #V_5&;, '%')) OR ((this.mobilePhone LIKE CONCAT('%', #V_5&;, '%')) OR ((this.fax LIKE CONCAT('%', #V_5&;, '%')) OR ((this.email LIKE CONCAT('%', #V_5&;, '%')) OR (this.website LIKE CONCAT('%', #V_5&;, '%')))))))))))))) 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&;", (statusFilter__1 == -1), "boolean"), new ItlRuntime.SQL.Parameter("#V_1&;", statusFilter__1, "integer"), new ItlRuntime.SQL.Parameter("#V_2&;", (creatorFilter__1 == ""), "boolean"), new ItlRuntime.SQL.Parameter("#V_3&;", creatorFilter__1, "string"), new ItlRuntime.SQL.Parameter("#V_4&;", (searchFilter__1 == ""), "boolean"), new ItlRuntime.SQL.Parameter("#V_5&;", ITL.S(searchFilter__1), "string")), new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_1", true)), new ItlRuntime.SQL.OptionalOrderAliases(new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_2", true)), new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_3", true)), new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_4", true)), new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_5", true))), null, null), @"SELECT this.`_oid` AS this, this_z_s_ocsCatalog.`_oid` AS this_z_s_ocsCatalog, this_k_1.result1 AS this_k_1_1, this_k_2.result1 AS this_k_2_1, this.title AS this_p_title, this.object AS this_p_object, this_z.ocsStatus AS this_z_p_ocsStatus, this_z.ocsCreationDate AS this_z_p_ocsCreationDate, this_z.ocsCreationLogin AS this_z_p_ocsCreationLogin, this_z_s_ocsCatalog.useValidation AS this_z_s_ocsCatalog_p_useValidation, this_z_s_ocsCatalog.editRightsMode AS this_z_s_ocsCatalog_p_editRightsMode 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 <> '')) LEFT JOIN (SELECT c1.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> ''))) On ((this.`_oid` = c0_l.`_to`) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.`_oid` IN (#V_0&;)) GROUP BY c1.`_oid`) AS this_k_1 On (this.`_oid` = this_k_1.origin) LEFT JOIN (SELECT c1.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.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 c1.`_oid`) AS this_k_2 On (this.`_oid` = this_k_2.origin) WHERE (this.iso_sid <> '')", new Map("#V_0&;|oids", EC.itl.categoryOids(true), "#V_1&;|oids", EC.itl.categoryOids(true)), true, (List) EC.newList(new List(), 1, 1, 1, 1), (int?)null, (int?)null)); e363.setLimit(sdsLimit__1); e363.setLimits("15 50 100 all"); e363.setNavigationFeatures("firstPage previousPage lastPage nextPage allPages"); ItlEnumerator card__4 = (ItlEnumerator) (e363); card__4.reset(); if(card__4.isNotEmpty()) { ItlEnumerator tableEnumerator__1 = (ItlEnumerator) (card__4); if(mode__1 == "edit") { %>

      Correction de la fiche "<% ITL.show((string)card__4.get("this_p_title"), "string", "html", "string"); %>"

      <% } %> <% columnCount = (int?)(ITL.gv["columnCount"] = 1);%><% columnCount = (int?)(ITL.gv["columnCount"] = 2); %><% columnCount = (int?)(ITL.gv["columnCount"] = 3);%><% columnCount = (int?)(ITL.gv["columnCount"] = 4); %><% columnCount = (int?)(ITL.gv["columnCount"] = 5); %><% columnCount = (int?)(ITL.gv["columnCount"] = 6); %><% if(tableEnumerator__1.needNavigationBar()) { %><% } %><% %><% %><% %><% %><% %><% if(tableEnumerator__1.needNavigationBar()) { %><% } if(tableEnumerator__1.count() > 1 && false) { %><% } %><% %><% card__4.resetGroup(); for(card__4.start();card__4.test();card__4.fetch()) { string oddEven__1 = (string) (tableEnumerator__1.positionInPage() % 2 == 1?"odd":"even"); %>><% %><% %><% %><% %><% }%>
      <% ItlLink link375 = new ItlLink("./xls00011380.aspx"); link375.setParameter("statusFilter", statusFilter__1); link375.setParameter("creatorFilter", creatorFilter__1); link375.setParameter("cardType", cardType); link375.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link375, "link375");%> Exporter <% if(ITL.b(hasActionRight__1)) { ItlLink link377 = new ItlLink("./gestion_entreprises.aspx"); link377.setParameter("action", "multiple-delete"); link377.setParameter("statusFilter", statusFilter__1); link377.setParameter("creatorFilter", creatorFilter__1); link377.setParameter("cardType", cardType); link377.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link377, "link377");%> Supprimer <% } if(statusFilter__1 != 0 && ITL.b(hasActionRight__1)) { ItlLink link379 = new ItlLink("./gestion_entreprises.aspx"); link379.setParameter("action", "multiple-changeStatus"); link379.setParameter("newStatus", 0); link379.setParameter("statusFilter", statusFilter__1); link379.setParameter("creatorFilter", creatorFilter__1); link379.setParameter("cardType", cardType); link379.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link379, "link379");%> En rédaction <% } if(ITL.b(useValidation) && statusFilter__1 != 1 && ITL.b(hasActionRight__1)) { ItlLink link381 = new ItlLink("./gestion_entreprises.aspx"); link381.setParameter("action", "multiple-changeStatus"); link381.setParameter("newStatus", 1); link381.setParameter("statusFilter", statusFilter__1); link381.setParameter("creatorFilter", creatorFilter__1); link381.setParameter("cardType", cardType); link381.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link381, "link381");%> A valider <% } if(statusFilter__1 != 2 && ITL.b(hasValidateRight)) { ItlLink link383 = new ItlLink("./gestion_entreprises.aspx"); link383.setParameter("action", "multiple-changeStatus"); link383.setParameter("newStatus", 2); link383.setParameter("statusFilter", statusFilter__1); link383.setParameter("creatorFilter", creatorFilter__1); link383.setParameter("cardType", cardType); link383.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link383, "link383");%> Publier <% } if(statusFilter__1 != 3 && (statusFilter__1 != -1 || cardType != "archive") && ITL.b(hasActionRight__1)) { ItlLink link385 = new ItlLink("./gestion_entreprises.aspx"); link385.setParameter("action", "multiple-changeStatus"); link385.setParameter("newStatus", 3); link385.setParameter("statusFilter", statusFilter__1); link385.setParameter("creatorFilter", creatorFilter__1); link385.setParameter("cardType", cardType); link385.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link385, "link385");%> Archiver <% } %>
        pas de fiches sélectionnées
      <% if(tableEnumerator__1.count() == 1) { %>1 fiche<% } else if(tableEnumerator__1.isOverflow()) { %> > <% ITL.show(EC.itl.translate("%1 fiches", ITL.S(tableEnumerator__1.count())), "string", "raw", "string"); } else { ITL.show(EC.itl.translate("%1 fiches", ITL.S(tableEnumerator__1.count())), "string", "raw", "string"); } %>
      Nombre de fiches à afficher  <% ITL.show(tableEnumerator__1.limitSelect(), "string", "raw", "string"); %>
      <% ITL.show(tableEnumerator__1.navigationBar(), "string", "raw", "string"); %>
       Libellé<% if(tableEnumerator__1.count() > 1) { %>v^<% } %>Objet<% if(tableEnumerator__1.count() > 1) { %>v^<% } %>Etat :<% if(tableEnumerator__1.count() > 1) { %>v^<% } %>Postée le<% if(tableEnumerator__1.count() > 1) { %>v^<% } %>
      <% ITL.show(tableEnumerator__1.navigationBar(), "string", "raw", "string"); %>
      <% if(tableEnumerator__1.count() == 1) { %>1 fiche<% } else if(tableEnumerator__1.isOverflow()) { %> > <% ITL.show(EC.itl.translate("%1 fiches", ITL.S(tableEnumerator__1.count())), "string", "raw", "string"); } else { ITL.show(EC.itl.translate("%1 fiches", ITL.S(tableEnumerator__1.count())), "string", "raw", "string"); } %>
      Nombre de fiches à afficher  <% ITL.show(tableEnumerator__1.limitSelect(), "string", "raw", "string"); %>
        pas de fiches sélectionnées
      <% ItlLink link414 = new ItlLink("./xls00011380.aspx"); link414.setParameter("statusFilter", statusFilter__1); link414.setParameter("creatorFilter", creatorFilter__1); link414.setParameter("cardType", cardType); link414.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link414, "link414");%> Exporter <% if(ITL.b(hasActionRight__1)) { ItlLink link416 = new ItlLink("./gestion_entreprises.aspx"); link416.setParameter("action", "multiple-delete"); link416.setParameter("statusFilter", statusFilter__1); link416.setParameter("creatorFilter", creatorFilter__1); link416.setParameter("cardType", cardType); link416.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link416, "link416");%> Supprimer <% } if(statusFilter__1 != 0 && ITL.b(hasActionRight__1)) { ItlLink link418 = new ItlLink("./gestion_entreprises.aspx"); link418.setParameter("action", "multiple-changeStatus"); link418.setParameter("newStatus", 0); link418.setParameter("statusFilter", statusFilter__1); link418.setParameter("creatorFilter", creatorFilter__1); link418.setParameter("cardType", cardType); link418.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link418, "link418");%> En rédaction <% } if(ITL.b(useValidation) && statusFilter__1 != 1 && ITL.b(hasActionRight__1)) { ItlLink link420 = new ItlLink("./gestion_entreprises.aspx"); link420.setParameter("action", "multiple-changeStatus"); link420.setParameter("newStatus", 1); link420.setParameter("statusFilter", statusFilter__1); link420.setParameter("creatorFilter", creatorFilter__1); link420.setParameter("cardType", cardType); link420.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link420, "link420");%> A valider <% } if(statusFilter__1 != 2 && ITL.b(hasValidateRight)) { ItlLink link422 = new ItlLink("./gestion_entreprises.aspx"); link422.setParameter("action", "multiple-changeStatus"); link422.setParameter("newStatus", 2); link422.setParameter("statusFilter", statusFilter__1); link422.setParameter("creatorFilter", creatorFilter__1); link422.setParameter("cardType", cardType); link422.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link422, "link422");%> Publier <% } if(statusFilter__1 != 3 && (statusFilter__1 != -1 || cardType != "archive") && ITL.b(hasActionRight__1)) { ItlLink link424 = new ItlLink("./gestion_entreprises.aspx"); link424.setParameter("action", "multiple-changeStatus"); link424.setParameter("newStatus", 3); link424.setParameter("statusFilter", statusFilter__1); link424.setParameter("creatorFilter", creatorFilter__1); link424.setParameter("cardType", cardType); link424.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link424, "link424");%> Archiver <% } %>
      <% if(tableEnumerator__1.isObjectSelected()) { %> checked="checked"/><% } else {%>/><% } %> <% if((ITL.b((bool?)card__4.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)card__4.get("this_k_1_1")) > 0:ITL.countDefault((int?)card__4.get("this_k_2_1")) > 0 && ((string)card__4.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)card__4.get("this_z_p_ocsCreationLogin") == EC.itl.login():true)) && ((bool?)card__4.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__4.get("this_z_p_ocsStatus"):((int?)card__4.get("this_z_p_ocsStatus") == 2 || (int?)card__4.get("this_z_p_ocsStatus") == 3?(int?)card__4.get("this_z_p_ocsStatus"):0)) != 0 || ITL.countDefault((int?)card__4.get("this_k_2_1")) > 0 && ((string)card__4.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)card__4.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) && ((bool?)card__4.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__4.get("this_z_p_ocsStatus"):((int?)card__4.get("this_z_p_ocsStatus") == 2 || (int?)card__4.get("this_z_p_ocsStatus") == 3?(int?)card__4.get("this_z_p_ocsStatus"):0)) != 2) { ItlLink link432 = new ItlLink("./gestion_entreprises.aspx"); link432.setProperty("title", "Modifier la fiche"); link432.setProperty("class", "ocsActions"); link432.setParameter("mode", "modify"); link432.setParameter("card", card__4); link432.show(); %> Modifier la fiche <% link432.close(); } if(ITL.b(hasNewCardRight)) { ItlLink link434 = new ItlLink("./gestion_entreprises.aspx"); link434.setProperty("title", "Cloner la fiche"); link434.setProperty("class", "ocsActions"); link434.setParameter("mode", "new"); link434.setParameter("card", card__4); link434.show(); %> Cloner la fiche <% link434.close(); } %> <% ItlLink link438 = new ItlLink("./gestion_entreprises.aspx"); link438.setProperty("title", "Voir la fiche"); link438.setParameter("mode", "card"); link438.setParameter("card", card__4); link438.show(); ITL.show((string)card__4.get("this_p_title"), "string", "html", "string"); link438.close(); %> <% ItlLink link440 = new ItlLink("./gestion_entreprises.aspx"); link440.setProperty("title", "Voir la fiche"); link440.setParameter("mode", "card"); link440.setParameter("card", card__4); link440.show(); ITL.show((string)card__4.get("this_p_object"), "string", "memo", "string"); link440.close(); %> <% if(((bool?)card__4.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__4.get("this_z_p_ocsStatus"):((int?)card__4.get("this_z_p_ocsStatus") == 2 || (int?)card__4.get("this_z_p_ocsStatus") == 3?(int?)card__4.get("this_z_p_ocsStatus"):0)) == 0) { %> En rédaction <% } else if(((bool?)card__4.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__4.get("this_z_p_ocsStatus"):((int?)card__4.get("this_z_p_ocsStatus") == 2 || (int?)card__4.get("this_z_p_ocsStatus") == 3?(int?)card__4.get("this_z_p_ocsStatus"):0)) == 1) { %> /> <% } else if(((bool?)card__4.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__4.get("this_z_p_ocsStatus"):((int?)card__4.get("this_z_p_ocsStatus") == 2 || (int?)card__4.get("this_z_p_ocsStatus") == 3?(int?)card__4.get("this_z_p_ocsStatus"):0)) == 2) { %> Publiée <% } else if(((bool?)card__4.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__4.get("this_z_p_ocsStatus"):((int?)card__4.get("this_z_p_ocsStatus") == 2 || (int?)card__4.get("this_z_p_ocsStatus") == 3?(int?)card__4.get("this_z_p_ocsStatus"):0)) == 3) { %> Archivée <% } %> <% ITL.show((DateTime?)card__4.get("this_z_p_ocsCreationDate"), "string", "html", "date"); %>
      <% } else {%> Aucune fiche. <% } card__4.finish(); %> <%form357.close(); } else {%>
      <%EC.itl.pushTab();%><%EC.itl.resetCurrentTab();%>
      <%EC.itl.generateCurrentTabAnchor();%>

      En cours

      <% bool hasActionRight__2 = (bool) ((statusFilter__1 == -1 || statusFilter__1 == 3) && (ITL.b(hasNewCardRight) || ITL.b(hasValidateRight)) || statusFilter__1 == 0 && ITL.b(hasNewCardRight) || (statusFilter__1 == 1 || statusFilter__1 == 2) && ITL.b(hasValidateRight)); ItlForm form445 = new ItlForm("form445", EC.itl.getId(), "#", "G00011380_446"); form445.setProperty("method", "post"); form445.setProperty("name", "fake"); form445.setProperty("hasProcessing", false); form445.show(); int? sdsLimit__2 = (int?) ((int?)EC.itl.getParameterValue("integer", "sdsLimit", 15)); %>
      <% ItlEnumerator e451 = new ItlEnumerator("G00011380_450", null, false); e451.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("ocsCol:association", @"SELECT this.`_oid` AS this, this.title AS o_1, this.title AS o_2, this.object AS o_3, this_z.ocsStatus AS o_4, this_z.ocsCreationDate AS o_5 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 = 'entreprises') AND (#V_0&; OR (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_1&;)) AND (#V_2&; OR (this_z.ocsCreationLogin = #V_3&;)) AND (#V_4&; OR ((this.title LIKE CONCAT('%', #V_5&;, '%')) OR ((this.object LIKE CONCAT('%', #V_5&;, '%')) OR ((this.headOffice LIKE CONCAT('%', #V_5&;, '%')) OR ((this.person_in_charge LIKE CONCAT('%', #V_5&;, '%')) OR ((this.person_title LIKE CONCAT('%', #V_5&;, '%')) OR ((this.address LIKE CONCAT('%', #V_5&;, '%')) OR ((this.contact LIKE CONCAT('%', #V_5&;, '%')) OR ((this.phoneNumber LIKE CONCAT('%', #V_5&;, '%')) OR ((this.mobilePhone LIKE CONCAT('%', #V_5&;, '%')) OR ((this.fax LIKE CONCAT('%', #V_5&;, '%')) OR ((this.email LIKE CONCAT('%', #V_5&;, '%')) OR (this.website LIKE CONCAT('%', #V_5&;, '%')))))))))))))) 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&;", (statusFilter__1 == -1), "boolean"), new ItlRuntime.SQL.Parameter("#V_1&;", statusFilter__1, "integer"), new ItlRuntime.SQL.Parameter("#V_2&;", (creatorFilter__1 == ""), "boolean"), new ItlRuntime.SQL.Parameter("#V_3&;", creatorFilter__1, "string"), new ItlRuntime.SQL.Parameter("#V_4&;", (searchFilter__1 == ""), "boolean"), new ItlRuntime.SQL.Parameter("#V_5&;", ITL.S(searchFilter__1), "string")), new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_1", true)), new ItlRuntime.SQL.OptionalOrderAliases(new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_2", true)), new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_3", true)), new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_4", true)), new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_5", true))), null, null), @"SELECT this.`_oid` AS this, this_z_s_ocsCatalog.`_oid` AS this_z_s_ocsCatalog, this_k_1.result1 AS this_k_1_1, this_k_2.result1 AS this_k_2_1, this.title AS this_p_title, this.object AS this_p_object, this_z.ocsStatus AS this_z_p_ocsStatus, this_z.ocsCreationDate AS this_z_p_ocsCreationDate, this_z.ocsCreationLogin AS this_z_p_ocsCreationLogin, this_z_s_ocsCatalog.useValidation AS this_z_s_ocsCatalog_p_useValidation, this_z_s_ocsCatalog.editRightsMode AS this_z_s_ocsCatalog_p_editRightsMode 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 <> '')) LEFT JOIN (SELECT c1.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> ''))) On ((this.`_oid` = c0_l.`_to`) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.`_oid` IN (#V_0&;)) GROUP BY c1.`_oid`) AS this_k_1 On (this.`_oid` = this_k_1.origin) LEFT JOIN (SELECT c1.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.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 c1.`_oid`) AS this_k_2 On (this.`_oid` = this_k_2.origin) WHERE (this.iso_sid <> '')", new Map("#V_0&;|oids", EC.itl.categoryOids(true), "#V_1&;|oids", EC.itl.categoryOids(true)), true, (List) EC.newList(new List(), 1, 1, 1, 1), (int?)null, (int?)null)); e451.setLimit(sdsLimit__2); e451.setLimits("15 50 100 all"); e451.setNavigationFeatures("firstPage previousPage lastPage nextPage allPages"); ItlEnumerator card__6 = (ItlEnumerator) (e451); card__6.reset(); if(card__6.isNotEmpty()) { ItlEnumerator tableEnumerator__2 = (ItlEnumerator) (card__6); if(mode__1 == "edit") { %>

      Correction de la fiche "<% ITL.show((string)card__6.get("this_p_title"), "string", "html", "string"); %>"

      <% } %> <% columnCount = (int?)(ITL.gv["columnCount"] = 1);%><% columnCount = (int?)(ITL.gv["columnCount"] = 2); %><% columnCount = (int?)(ITL.gv["columnCount"] = 3);%><% columnCount = (int?)(ITL.gv["columnCount"] = 4); %><% columnCount = (int?)(ITL.gv["columnCount"] = 5); %><% columnCount = (int?)(ITL.gv["columnCount"] = 6); %><% if(tableEnumerator__2.needNavigationBar()) { %><% } %><% %><% %><% %><% %><% %><% if(tableEnumerator__2.needNavigationBar()) { %><% } if(tableEnumerator__2.count() > 1 && false) { %><% } %><% %><% card__6.resetGroup(); for(card__6.start();card__6.test();card__6.fetch()) { string oddEven__2 = (string) (tableEnumerator__2.positionInPage() % 2 == 1?"odd":"even"); %>><% %><% %><% %><% %><% }%>
      <% ItlLink link463 = new ItlLink("./xls00011380.aspx"); link463.setParameter("statusFilter", statusFilter__1); link463.setParameter("creatorFilter", creatorFilter__1); link463.setParameter("cardType", "current"); link463.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link463, "link463");%> Exporter <% if(ITL.b(hasActionRight__2)) { ItlLink link465 = new ItlLink("./gestion_entreprises.aspx"); link465.setParameter("action", "multiple-delete"); link465.setParameter("statusFilter", statusFilter__1); link465.setParameter("creatorFilter", creatorFilter__1); link465.setParameter("cardType", "current"); link465.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link465, "link465");%> Supprimer <% } if(statusFilter__1 != 0 && ITL.b(hasActionRight__2)) { ItlLink link467 = new ItlLink("./gestion_entreprises.aspx"); link467.setParameter("action", "multiple-changeStatus"); link467.setParameter("newStatus", 0); link467.setParameter("statusFilter", statusFilter__1); link467.setParameter("creatorFilter", creatorFilter__1); link467.setParameter("cardType", "current"); link467.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link467, "link467");%> En rédaction <% } if(ITL.b(useValidation) && statusFilter__1 != 1 && ITL.b(hasActionRight__2)) { ItlLink link469 = new ItlLink("./gestion_entreprises.aspx"); link469.setParameter("action", "multiple-changeStatus"); link469.setParameter("newStatus", 1); link469.setParameter("statusFilter", statusFilter__1); link469.setParameter("creatorFilter", creatorFilter__1); link469.setParameter("cardType", "current"); link469.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link469, "link469");%> A valider <% } if(statusFilter__1 != 2 && ITL.b(hasValidateRight)) { ItlLink link471 = new ItlLink("./gestion_entreprises.aspx"); link471.setParameter("action", "multiple-changeStatus"); link471.setParameter("newStatus", 2); link471.setParameter("statusFilter", statusFilter__1); link471.setParameter("creatorFilter", creatorFilter__1); link471.setParameter("cardType", "current"); link471.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link471, "link471");%> Publier <% } if(statusFilter__1 != 3 && ITL.b(hasActionRight__2)) { ItlLink link473 = new ItlLink("./gestion_entreprises.aspx"); link473.setParameter("action", "multiple-changeStatus"); link473.setParameter("newStatus", 3); link473.setParameter("statusFilter", statusFilter__1); link473.setParameter("creatorFilter", creatorFilter__1); link473.setParameter("cardType", "current"); link473.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link473, "link473");%> Archiver <% } %>
        pas de fiches sélectionnées
      <% if(tableEnumerator__2.count() == 1) { %>1 fiche<% } else if(tableEnumerator__2.isOverflow()) { %> > <% ITL.show(EC.itl.translate("%1 fiches", ITL.S(tableEnumerator__2.count())), "string", "raw", "string"); } else { ITL.show(EC.itl.translate("%1 fiches", ITL.S(tableEnumerator__2.count())), "string", "raw", "string"); } %>
      Nombre de fiches à afficher  <% ITL.show(tableEnumerator__2.limitSelect(), "string", "raw", "string"); %>
      <% ITL.show(tableEnumerator__2.navigationBar(), "string", "raw", "string"); %>
       Libellé<% if(tableEnumerator__2.count() > 1) { %>v^<% } %>Objet<% if(tableEnumerator__2.count() > 1) { %>v^<% } %>Etat :<% if(tableEnumerator__2.count() > 1) { %>v^<% } %>Postée le<% if(tableEnumerator__2.count() > 1) { %>v^<% } %>
      <% ITL.show(tableEnumerator__2.navigationBar(), "string", "raw", "string"); %>
      <% if(tableEnumerator__2.count() == 1) { %>1 fiche<% } else if(tableEnumerator__2.isOverflow()) { %> > <% ITL.show(EC.itl.translate("%1 fiches", ITL.S(tableEnumerator__2.count())), "string", "raw", "string"); } else { ITL.show(EC.itl.translate("%1 fiches", ITL.S(tableEnumerator__2.count())), "string", "raw", "string"); } %>
      Nombre de fiches à afficher  <% ITL.show(tableEnumerator__2.limitSelect(), "string", "raw", "string"); %>
        pas de fiches sélectionnées
      <% ItlLink link502 = new ItlLink("./xls00011380.aspx"); link502.setParameter("statusFilter", statusFilter__1); link502.setParameter("creatorFilter", creatorFilter__1); link502.setParameter("cardType", "current"); link502.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link502, "link502");%> Exporter <% if(ITL.b(hasActionRight__2)) { ItlLink link504 = new ItlLink("./gestion_entreprises.aspx"); link504.setParameter("action", "multiple-delete"); link504.setParameter("statusFilter", statusFilter__1); link504.setParameter("creatorFilter", creatorFilter__1); link504.setParameter("cardType", "current"); link504.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link504, "link504");%> Supprimer <% } if(statusFilter__1 != 0 && ITL.b(hasActionRight__2)) { ItlLink link506 = new ItlLink("./gestion_entreprises.aspx"); link506.setParameter("action", "multiple-changeStatus"); link506.setParameter("newStatus", 0); link506.setParameter("statusFilter", statusFilter__1); link506.setParameter("creatorFilter", creatorFilter__1); link506.setParameter("cardType", "current"); link506.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link506, "link506");%> En rédaction <% } if(ITL.b(useValidation) && statusFilter__1 != 1 && ITL.b(hasActionRight__2)) { ItlLink link508 = new ItlLink("./gestion_entreprises.aspx"); link508.setParameter("action", "multiple-changeStatus"); link508.setParameter("newStatus", 1); link508.setParameter("statusFilter", statusFilter__1); link508.setParameter("creatorFilter", creatorFilter__1); link508.setParameter("cardType", "current"); link508.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link508, "link508");%> A valider <% } if(statusFilter__1 != 2 && ITL.b(hasValidateRight)) { ItlLink link510 = new ItlLink("./gestion_entreprises.aspx"); link510.setParameter("action", "multiple-changeStatus"); link510.setParameter("newStatus", 2); link510.setParameter("statusFilter", statusFilter__1); link510.setParameter("creatorFilter", creatorFilter__1); link510.setParameter("cardType", "current"); link510.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link510, "link510");%> Publier <% } if(statusFilter__1 != 3 && ITL.b(hasActionRight__2)) { ItlLink link512 = new ItlLink("./gestion_entreprises.aspx"); link512.setParameter("action", "multiple-changeStatus"); link512.setParameter("newStatus", 3); link512.setParameter("statusFilter", statusFilter__1); link512.setParameter("creatorFilter", creatorFilter__1); link512.setParameter("cardType", "current"); link512.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link512, "link512");%> Archiver <% } %>
      <% if(tableEnumerator__2.isObjectSelected()) { %> checked="checked"/><% } else {%>/><% } %> <% if((ITL.b((bool?)card__6.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)card__6.get("this_k_1_1")) > 0:ITL.countDefault((int?)card__6.get("this_k_2_1")) > 0 && ((string)card__6.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)card__6.get("this_z_p_ocsCreationLogin") == EC.itl.login():true)) && ((bool?)card__6.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__6.get("this_z_p_ocsStatus"):((int?)card__6.get("this_z_p_ocsStatus") == 2 || (int?)card__6.get("this_z_p_ocsStatus") == 3?(int?)card__6.get("this_z_p_ocsStatus"):0)) != 0 || ITL.countDefault((int?)card__6.get("this_k_2_1")) > 0 && ((string)card__6.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)card__6.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) && ((bool?)card__6.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__6.get("this_z_p_ocsStatus"):((int?)card__6.get("this_z_p_ocsStatus") == 2 || (int?)card__6.get("this_z_p_ocsStatus") == 3?(int?)card__6.get("this_z_p_ocsStatus"):0)) != 2) { ItlLink link520 = new ItlLink("./gestion_entreprises.aspx"); link520.setProperty("title", "Modifier la fiche"); link520.setProperty("class", "ocsActions"); link520.setParameter("mode", "modify"); link520.setParameter("card", card__6); link520.show(); %> Modifier la fiche <% link520.close(); } if(ITL.b(hasNewCardRight)) { ItlLink link522 = new ItlLink("./gestion_entreprises.aspx"); link522.setProperty("title", "Cloner la fiche"); link522.setProperty("class", "ocsActions"); link522.setParameter("mode", "new"); link522.setParameter("card", card__6); link522.show(); %> Cloner la fiche <% link522.close(); } %> <% ItlLink link526 = new ItlLink("./gestion_entreprises.aspx"); link526.setProperty("title", "Voir la fiche"); link526.setParameter("mode", "card"); link526.setParameter("card", card__6); link526.show(); ITL.show((string)card__6.get("this_p_title"), "string", "html", "string"); link526.close(); %> <% ItlLink link528 = new ItlLink("./gestion_entreprises.aspx"); link528.setProperty("title", "Voir la fiche"); link528.setParameter("mode", "card"); link528.setParameter("card", card__6); link528.show(); ITL.show((string)card__6.get("this_p_object"), "string", "memo", "string"); link528.close(); %> <% if(((bool?)card__6.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__6.get("this_z_p_ocsStatus"):((int?)card__6.get("this_z_p_ocsStatus") == 2 || (int?)card__6.get("this_z_p_ocsStatus") == 3?(int?)card__6.get("this_z_p_ocsStatus"):0)) == 0) { %> En rédaction <% } else if(((bool?)card__6.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__6.get("this_z_p_ocsStatus"):((int?)card__6.get("this_z_p_ocsStatus") == 2 || (int?)card__6.get("this_z_p_ocsStatus") == 3?(int?)card__6.get("this_z_p_ocsStatus"):0)) == 1) { %> /> <% } else if(((bool?)card__6.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__6.get("this_z_p_ocsStatus"):((int?)card__6.get("this_z_p_ocsStatus") == 2 || (int?)card__6.get("this_z_p_ocsStatus") == 3?(int?)card__6.get("this_z_p_ocsStatus"):0)) == 2) { %> Publiée <% } else if(((bool?)card__6.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__6.get("this_z_p_ocsStatus"):((int?)card__6.get("this_z_p_ocsStatus") == 2 || (int?)card__6.get("this_z_p_ocsStatus") == 3?(int?)card__6.get("this_z_p_ocsStatus"):0)) == 3) { %> Archivée <% } %> <% ITL.show((DateTime?)card__6.get("this_z_p_ocsCreationDate"), "string", "html", "date"); %>
      <% } else {%> Aucune fiche. <% } card__6.finish(); %> <%form445.close();%> <%EC.itl.nextTab();%>
      <%EC.itl.generateCurrentTabAnchor();%>

      Archives

      <% bool hasActionRight__3 = (bool) ((statusFilter__1 == -1 || statusFilter__1 == 3) && (ITL.b(hasNewCardRight) || ITL.b(hasValidateRight)) || statusFilter__1 == 0 && ITL.b(hasNewCardRight) || (statusFilter__1 == 1 || statusFilter__1 == 2) && ITL.b(hasValidateRight)); ItlForm form533 = new ItlForm("form533", EC.itl.getId(), "#", "G00011380_534"); form533.setProperty("method", "post"); form533.setProperty("name", "fake"); form533.setProperty("hasProcessing", false); form533.show(); int? sdsLimit__3 = (int?) ((int?)EC.itl.getParameterValue("integer", "sdsLimit", 15)); %>
      <% ItlEnumerator e539 = new ItlEnumerator("G00011380_538", null, false); e539.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("ocsCol:association", @"SELECT this.`_oid` AS this, this.title AS o_1, this.title AS o_2, this.object AS o_3, this_z.ocsStatus AS o_4, this_z.ocsCreationDate AS o_5 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 = 'entreprises') AND (#V_0&; OR (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_1&;)) AND (#V_2&; OR (this_z.ocsCreationLogin = #V_3&;)) AND (#V_4&; OR ((this.title LIKE CONCAT('%', #V_5&;, '%')) OR ((this.object LIKE CONCAT('%', #V_5&;, '%')) OR ((this.headOffice LIKE CONCAT('%', #V_5&;, '%')) OR ((this.person_in_charge LIKE CONCAT('%', #V_5&;, '%')) OR ((this.person_title LIKE CONCAT('%', #V_5&;, '%')) OR ((this.address LIKE CONCAT('%', #V_5&;, '%')) OR ((this.contact LIKE CONCAT('%', #V_5&;, '%')) OR ((this.phoneNumber LIKE CONCAT('%', #V_5&;, '%')) OR ((this.mobilePhone LIKE CONCAT('%', #V_5&;, '%')) OR ((this.fax LIKE CONCAT('%', #V_5&;, '%')) OR ((this.email LIKE CONCAT('%', #V_5&;, '%')) OR (this.website LIKE CONCAT('%', #V_5&;, '%')))))))))))))) 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&;", (statusFilter__1 == -1), "boolean"), new ItlRuntime.SQL.Parameter("#V_1&;", statusFilter__1, "integer"), new ItlRuntime.SQL.Parameter("#V_2&;", (creatorFilter__1 == ""), "boolean"), new ItlRuntime.SQL.Parameter("#V_3&;", creatorFilter__1, "string"), new ItlRuntime.SQL.Parameter("#V_4&;", (searchFilter__1 == ""), "boolean"), new ItlRuntime.SQL.Parameter("#V_5&;", ITL.S(searchFilter__1), "string")), new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_1", true)), new ItlRuntime.SQL.OptionalOrderAliases(new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_2", true)), new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_3", true)), new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_4", true)), new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_5", true))), null, null), @"SELECT this.`_oid` AS this, this_z_s_ocsCatalog.`_oid` AS this_z_s_ocsCatalog, this_k_1.result1 AS this_k_1_1, this_k_2.result1 AS this_k_2_1, this.title AS this_p_title, this.object AS this_p_object, this_z.ocsStatus AS this_z_p_ocsStatus, this_z.ocsCreationDate AS this_z_p_ocsCreationDate, this_z.ocsCreationLogin AS this_z_p_ocsCreationLogin, this_z_s_ocsCatalog.useValidation AS this_z_s_ocsCatalog_p_useValidation, this_z_s_ocsCatalog.editRightsMode AS this_z_s_ocsCatalog_p_editRightsMode 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 <> '')) LEFT JOIN (SELECT c1.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> ''))) On ((this.`_oid` = c0_l.`_to`) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.`_oid` IN (#V_0&;)) GROUP BY c1.`_oid`) AS this_k_1 On (this.`_oid` = this_k_1.origin) LEFT JOIN (SELECT c1.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.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 c1.`_oid`) AS this_k_2 On (this.`_oid` = this_k_2.origin) WHERE (this.iso_sid <> '')", new Map("#V_0&;|oids", EC.itl.categoryOids(true), "#V_1&;|oids", EC.itl.categoryOids(true)), true, (List) EC.newList(new List(), 1, 1, 1, 1), (int?)null, (int?)null)); e539.setLimit(sdsLimit__3); e539.setLimits("15 50 100 all"); e539.setNavigationFeatures("firstPage previousPage lastPage nextPage allPages"); ItlEnumerator card__8 = (ItlEnumerator) (e539); card__8.reset(); if(card__8.isNotEmpty()) { ItlEnumerator tableEnumerator__3 = (ItlEnumerator) (card__8); if(mode__1 == "edit") { %>

      Correction de la fiche "<% ITL.show((string)card__8.get("this_p_title"), "string", "html", "string"); %>"

      <% } %> <% columnCount = (int?)(ITL.gv["columnCount"] = 1);%><% columnCount = (int?)(ITL.gv["columnCount"] = 2); %><% columnCount = (int?)(ITL.gv["columnCount"] = 3);%><% columnCount = (int?)(ITL.gv["columnCount"] = 4); %><% columnCount = (int?)(ITL.gv["columnCount"] = 5); %><% columnCount = (int?)(ITL.gv["columnCount"] = 6); %><% if(tableEnumerator__3.needNavigationBar()) { %><% } %><% %><% %><% %><% %><% %><% if(tableEnumerator__3.needNavigationBar()) { %><% } if(tableEnumerator__3.count() > 1 && false) { %><% } %><% %><% card__8.resetGroup(); for(card__8.start();card__8.test();card__8.fetch()) { string oddEven__3 = (string) (tableEnumerator__3.positionInPage() % 2 == 1?"odd":"even"); %>><% %><% %><% %><% %><% }%>
      <% ItlLink link551 = new ItlLink("./xls00011380.aspx"); link551.setParameter("statusFilter", statusFilter__1); link551.setParameter("creatorFilter", creatorFilter__1); link551.setParameter("cardType", "archive"); link551.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link551, "link551");%> Exporter <% if(ITL.b(hasActionRight__3)) { ItlLink link553 = new ItlLink("./gestion_entreprises.aspx"); link553.setParameter("action", "multiple-delete"); link553.setParameter("statusFilter", statusFilter__1); link553.setParameter("creatorFilter", creatorFilter__1); link553.setParameter("cardType", "archive"); link553.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link553, "link553");%> Supprimer <% } if(statusFilter__1 != 0 && ITL.b(hasActionRight__3)) { ItlLink link555 = new ItlLink("./gestion_entreprises.aspx"); link555.setParameter("action", "multiple-changeStatus"); link555.setParameter("newStatus", 0); link555.setParameter("statusFilter", statusFilter__1); link555.setParameter("creatorFilter", creatorFilter__1); link555.setParameter("cardType", "archive"); link555.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link555, "link555");%> En rédaction <% } if(ITL.b(useValidation) && statusFilter__1 != 1 && ITL.b(hasActionRight__3)) { ItlLink link557 = new ItlLink("./gestion_entreprises.aspx"); link557.setParameter("action", "multiple-changeStatus"); link557.setParameter("newStatus", 1); link557.setParameter("statusFilter", statusFilter__1); link557.setParameter("creatorFilter", creatorFilter__1); link557.setParameter("cardType", "archive"); link557.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link557, "link557");%> A valider <% } if(statusFilter__1 != 2 && ITL.b(hasValidateRight)) { ItlLink link559 = new ItlLink("./gestion_entreprises.aspx"); link559.setParameter("action", "multiple-changeStatus"); link559.setParameter("newStatus", 2); link559.setParameter("statusFilter", statusFilter__1); link559.setParameter("creatorFilter", creatorFilter__1); link559.setParameter("cardType", "archive"); link559.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link559, "link559");%> Publier <% } if(statusFilter__1 != 3 && (statusFilter__1 != -1 || "archive" != "archive") && ITL.b(hasActionRight__3)) { ItlLink link561 = new ItlLink("./gestion_entreprises.aspx"); link561.setParameter("action", "multiple-changeStatus"); link561.setParameter("newStatus", 3); link561.setParameter("statusFilter", statusFilter__1); link561.setParameter("creatorFilter", creatorFilter__1); link561.setParameter("cardType", "archive"); link561.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link561, "link561");%> Archiver <% } %>
        pas de fiches sélectionnées
      <% if(tableEnumerator__3.count() == 1) { %>1 fiche<% } else if(tableEnumerator__3.isOverflow()) { %> > <% ITL.show(EC.itl.translate("%1 fiches", ITL.S(tableEnumerator__3.count())), "string", "raw", "string"); } else { ITL.show(EC.itl.translate("%1 fiches", ITL.S(tableEnumerator__3.count())), "string", "raw", "string"); } %>
      Nombre de fiches à afficher  <% ITL.show(tableEnumerator__3.limitSelect(), "string", "raw", "string"); %>
      <% ITL.show(tableEnumerator__3.navigationBar(), "string", "raw", "string"); %>
       Libellé<% if(tableEnumerator__3.count() > 1) { %>v^<% } %>Objet<% if(tableEnumerator__3.count() > 1) { %>v^<% } %>Etat :<% if(tableEnumerator__3.count() > 1) { %>v^<% } %>Postée le<% if(tableEnumerator__3.count() > 1) { %>v^<% } %>
      <% ITL.show(tableEnumerator__3.navigationBar(), "string", "raw", "string"); %>
      <% if(tableEnumerator__3.count() == 1) { %>1 fiche<% } else if(tableEnumerator__3.isOverflow()) { %> > <% ITL.show(EC.itl.translate("%1 fiches", ITL.S(tableEnumerator__3.count())), "string", "raw", "string"); } else { ITL.show(EC.itl.translate("%1 fiches", ITL.S(tableEnumerator__3.count())), "string", "raw", "string"); } %>
      Nombre de fiches à afficher  <% ITL.show(tableEnumerator__3.limitSelect(), "string", "raw", "string"); %>
        pas de fiches sélectionnées
      <% ItlLink link590 = new ItlLink("./xls00011380.aspx"); link590.setParameter("statusFilter", statusFilter__1); link590.setParameter("creatorFilter", creatorFilter__1); link590.setParameter("cardType", "archive"); link590.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link590, "link590");%> Exporter <% if(ITL.b(hasActionRight__3)) { ItlLink link592 = new ItlLink("./gestion_entreprises.aspx"); link592.setParameter("action", "multiple-delete"); link592.setParameter("statusFilter", statusFilter__1); link592.setParameter("creatorFilter", creatorFilter__1); link592.setParameter("cardType", "archive"); link592.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link592, "link592");%> Supprimer <% } if(statusFilter__1 != 0 && ITL.b(hasActionRight__3)) { ItlLink link594 = new ItlLink("./gestion_entreprises.aspx"); link594.setParameter("action", "multiple-changeStatus"); link594.setParameter("newStatus", 0); link594.setParameter("statusFilter", statusFilter__1); link594.setParameter("creatorFilter", creatorFilter__1); link594.setParameter("cardType", "archive"); link594.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link594, "link594");%> En rédaction <% } if(ITL.b(useValidation) && statusFilter__1 != 1 && ITL.b(hasActionRight__3)) { ItlLink link596 = new ItlLink("./gestion_entreprises.aspx"); link596.setParameter("action", "multiple-changeStatus"); link596.setParameter("newStatus", 1); link596.setParameter("statusFilter", statusFilter__1); link596.setParameter("creatorFilter", creatorFilter__1); link596.setParameter("cardType", "archive"); link596.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link596, "link596");%> A valider <% } if(statusFilter__1 != 2 && ITL.b(hasValidateRight)) { ItlLink link598 = new ItlLink("./gestion_entreprises.aspx"); link598.setParameter("action", "multiple-changeStatus"); link598.setParameter("newStatus", 2); link598.setParameter("statusFilter", statusFilter__1); link598.setParameter("creatorFilter", creatorFilter__1); link598.setParameter("cardType", "archive"); link598.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link598, "link598");%> Publier <% } if(statusFilter__1 != 3 && (statusFilter__1 != -1 || "archive" != "archive") && ITL.b(hasActionRight__3)) { ItlLink link600 = new ItlLink("./gestion_entreprises.aspx"); link600.setParameter("action", "multiple-changeStatus"); link600.setParameter("newStatus", 3); link600.setParameter("statusFilter", statusFilter__1); link600.setParameter("creatorFilter", creatorFilter__1); link600.setParameter("cardType", "archive"); link600.setParameter("searchFilter", searchFilter__1); EC.itl.sdsRegisterTableActionLink(link600, "link600");%> Archiver <% } %>
      <% if(tableEnumerator__3.isObjectSelected()) { %> checked="checked"/><% } else {%>/><% } %> <% if((ITL.b((bool?)card__8.get("this_z_s_ocsCatalog_p_useValidation"))?ITL.countDefault((int?)card__8.get("this_k_1_1")) > 0:ITL.countDefault((int?)card__8.get("this_k_2_1")) > 0 && ((string)card__8.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)card__8.get("this_z_p_ocsCreationLogin") == EC.itl.login():true)) && ((bool?)card__8.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__8.get("this_z_p_ocsStatus"):((int?)card__8.get("this_z_p_ocsStatus") == 2 || (int?)card__8.get("this_z_p_ocsStatus") == 3?(int?)card__8.get("this_z_p_ocsStatus"):0)) != 0 || ITL.countDefault((int?)card__8.get("this_k_2_1")) > 0 && ((string)card__8.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)card__8.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) && ((bool?)card__8.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__8.get("this_z_p_ocsStatus"):((int?)card__8.get("this_z_p_ocsStatus") == 2 || (int?)card__8.get("this_z_p_ocsStatus") == 3?(int?)card__8.get("this_z_p_ocsStatus"):0)) != 2) { ItlLink link608 = new ItlLink("./gestion_entreprises.aspx"); link608.setProperty("title", "Modifier la fiche"); link608.setProperty("class", "ocsActions"); link608.setParameter("mode", "modify"); link608.setParameter("card", card__8); link608.show(); %> Modifier la fiche <% link608.close(); } if(ITL.b(hasNewCardRight)) { ItlLink link610 = new ItlLink("./gestion_entreprises.aspx"); link610.setProperty("title", "Cloner la fiche"); link610.setProperty("class", "ocsActions"); link610.setParameter("mode", "new"); link610.setParameter("card", card__8); link610.show(); %> Cloner la fiche <% link610.close(); } %> <% ItlLink link614 = new ItlLink("./gestion_entreprises.aspx"); link614.setProperty("title", "Voir la fiche"); link614.setParameter("mode", "card"); link614.setParameter("card", card__8); link614.show(); ITL.show((string)card__8.get("this_p_title"), "string", "html", "string"); link614.close(); %> <% ItlLink link616 = new ItlLink("./gestion_entreprises.aspx"); link616.setProperty("title", "Voir la fiche"); link616.setParameter("mode", "card"); link616.setParameter("card", card__8); link616.show(); ITL.show((string)card__8.get("this_p_object"), "string", "memo", "string"); link616.close(); %> <% if(((bool?)card__8.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__8.get("this_z_p_ocsStatus"):((int?)card__8.get("this_z_p_ocsStatus") == 2 || (int?)card__8.get("this_z_p_ocsStatus") == 3?(int?)card__8.get("this_z_p_ocsStatus"):0)) == 0) { %> En rédaction <% } else if(((bool?)card__8.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__8.get("this_z_p_ocsStatus"):((int?)card__8.get("this_z_p_ocsStatus") == 2 || (int?)card__8.get("this_z_p_ocsStatus") == 3?(int?)card__8.get("this_z_p_ocsStatus"):0)) == 1) { %> /> <% } else if(((bool?)card__8.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__8.get("this_z_p_ocsStatus"):((int?)card__8.get("this_z_p_ocsStatus") == 2 || (int?)card__8.get("this_z_p_ocsStatus") == 3?(int?)card__8.get("this_z_p_ocsStatus"):0)) == 2) { %> Publiée <% } else if(((bool?)card__8.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__8.get("this_z_p_ocsStatus"):((int?)card__8.get("this_z_p_ocsStatus") == 2 || (int?)card__8.get("this_z_p_ocsStatus") == 3?(int?)card__8.get("this_z_p_ocsStatus"):0)) == 3) { %> Archivée <% } %> <% ITL.show((DateTime?)card__8.get("this_z_p_ocsCreationDate"), "string", "html", "date"); %>
      <% } else {%> Aucune fiche. <% } card__8.finish(); %> <%form533.close();%> <%EC.itl.nextTab();EC.itl.popTab();%> <% } } else {%>

      Mode inconnu !

      <% } %>
      		 
           
      <% if((string)ITL.gv["compiledMode"] == "card") { %>

      Actions sur la fiche

        <% if((ITL.b((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation"))?EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0:EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0 && ((string)card__1.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)card__1.get("this_z_p_ocsCreationLogin") == EC.itl.login():true)) && ((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)) != 0 || EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0 && ((string)card__1.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)card__1.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) && ((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)) != 2) { %>
      • <% ItlLink link625 = new ItlLink("./gestion_entreprises.aspx"); link625.setProperty("class", "modify"); link625.setParameter("mode", "modify"); link625.setParameter("card", (int?)card__1.get("this")); link625.show(); %> Modifier la fiche <% link625.close(); %>
        • <% } %>
      • <% ItlLink link626 = new ItlLink("./log00011380.aspx"); link626.setProperty("target", "ocsLog"); link626.setProperty("class", "seeLog"); link626.setProperty("onclick", "window.open('about:blank','ocsLog','location=0,menubar=0,toolbar=0,resizable=1,status=1');return true;"); link626.setParameter("card", (int?)card__1.get("this")); link626.show(); %> Voir l'historique <% link626.close(); %>
        • <% if((ITL.b((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation"))?EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0:EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0 && ((string)card__1.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)card__1.get("this_z_p_ocsCreationLogin") == EC.itl.login():true)) && ((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)) != 0 || EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0 && ((string)card__1.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)card__1.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) && ((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)) != 2) { %>
      • <% ItlLink link631 = new ItlLink("./gestion_entreprises.aspx"); link631.setProperty("onclick", "return ocsConfirmDelete();"); link631.setProperty("class", "delete"); link631.setParameter("action", "delete"); link631.setParameter("card", (int?)card__1.get("this")); link631.show(); %> Supprimer la fiche <% link631.close(); %>
        • <% } if(ITL.b(hasNewCardRight)) { %>
      • <% ItlLink link633 = new ItlLink("./gestion_entreprises.aspx"); link633.setProperty("class", "clone"); link633.setParameter("mode", "new"); link633.setParameter("card", (int?)card__1.get("this")); link633.show(); %> Cloner la fiche <% link633.close(); %>
        • <% } %> <% } if((string)ITL.gv["compiledMode"] == "card") { if((ITL.b((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation"))?EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0:EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0 && ((string)card__1.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)card__1.get("this_z_p_ocsCreationLogin") == EC.itl.login():true)) && ((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)) != 0 || EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0 && ((string)card__1.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)card__1.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) && ((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)) != 2) { %>
             
          <%ItlForm form639 = new ItlForm("form639", EC.itl.getId(), "./gestion_entreprises.aspx", "G00011380_640"); form639.setProperty("name", "changeStatus"); form639.setProperty("hasProcessing", false); form639.addParameter("card", EC.itl.makeParameter(card__1, "object")); form639.addParameter("action", "changeStatus"); form639.show(); %>

        Cycle de validation

        <% if(((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)) == 0) { %> /> <% } else {%> /> <% } %> En rédaction
        En rédaction
        <% if(ITL.b(useValidation)) { %>
        <% if(((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)) == 1) { %> /> <% } else {%> /> <% } %> A valider
        A valider
        <% } if(ITL.b((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation"))?EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0:EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0 && ((string)card__1.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)card__1.get("this_z_p_ocsCreationLogin") == EC.itl.login():true)) { %>
        <% if(((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)) == 2) { %> /> <% } else {%> /> <% } %> Publiée
        Publiée
        <% } if(EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0 && ((string)card__1.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)card__1.get("this_z_p_ocsCreationLogin") == EC.itl.login():true) || (ITL.b((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation"))?EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0:EC.itl.toInteger(new SqlCollection("xrm:category", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT c1.`_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 <> '')) INNER JOIN (ocs_card AS c1 INNER JOIN ocs_card AS c1_z On ((c1.`_oid` = c1_z.`_oid`) AND (c1_z.iso_sid <> ''))) On ((c0.`_oid` = c1.ocsCatalog) AND (c1.iso_sid <> '') AND (c1.`_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?)card__1.get("this"), "#V_1&;|oids", EC.itl.categoryOids(true)), (List) EC.newList(new List(), "this_p_label_fr")).get("result")) > 0 && ((string)card__1.get("this_z_s_ocsCatalog_p_editRightsMode") == "author"?(string)card__1.get("this_z_p_ocsCreationLogin") == EC.itl.login():true))) { %>
        <% if(((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)) == 3) { %> /> <% } else {%> /> <% } %> Archivée
        Archivée
        <% } %>

        <% if(ITL.b(useValidation)) { SqlObject _t9 = new SqlObject("ocs:catalog", @"SELECT this.`_oid` AS this FROM ocs_catalog AS this WHERE (this.iso_sid <> '') AND (this.name = 'entreprises')", new Map(),false); SqlObject _t10 = new SqlObject("ocs:catalog", @"SELECT this.`_oid` AS this FROM ocs_catalog AS this WHERE (this.iso_sid <> '') AND (this.name = 'entreprises')", new Map(),false); { OcsNotificationScriptBuilder _scriptBuilder = new OcsNotificationScriptBuilder(); _scriptBuilder.generate((string)card__1.get("this_z_p_ocsCreationLogin"), new SqlCollection("xrm:category", @"SELECT DISTINCT c0.`_oid` AS origin, this.label_fr AS this_p_label_fr, this.`_oid` AS this 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 <> '')", new Map("#V_0&;|integer", (int?)_t9.get("this")), (List) EC.newList(new List(), "this_p_label_fr")).keys(), new SqlCollection("xrm:category", @"SELECT DISTINCT c0.`_oid` AS origin, this.label_fr AS this_p_label_fr, this.`_oid` AS this 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 <> '')", new Map("#V_0&;|integer", (int?)_t10.get("this")), (List) EC.newList(new List(), "this_p_label_fr")).keys(), (int?)card__1.get("this"), ((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)), (string)catalogObject.get("this_p_editRightsMode")); } string message__1 = (string) ((string)ITL.gv["compiledMode"] == "new"?"Nouvelle fiche":((string)ITL.gv["compiledMode"] == "card"?"Nouvel état":"Modification")); string mailSubject__1 = (string) (((("Demande de " + (((bool?)card__1.get("this_z_s_ocsCatalog_p_useValidation") == true?(int?)card__1.get("this_z_p_ocsStatus"):((int?)card__1.get("this_z_p_ocsStatus") == 2 || (int?)card__1.get("this_z_p_ocsStatus") == 3?(int?)card__1.get("this_z_p_ocsStatus"):0)) == 0?"modification":"validation")) + " de la fiche '") + ITL.S((string)card__1.get("this_p_title"))) + "'"); string mailInfoSubject__1 = (string) (("Information concernant la fiche '" + ITL.S((string)card__1.get("this_p_title"))) + "'"); int messageCtrlWidth__1 = (int) ((string)ITL.gv["compiledMode"] == "card"?725:715); %>
        <%EC.itl.pushTab();%><%EC.itl.resetCurrentTab();%>
        <%EC.itl.generateCurrentTabAnchor();%>

        Demande d'action

        Vous pouvez envoyer une demande d'action aux personnes ayant les droits pour agir sur la fiche.

        Personnes à notifier :


        Sujet de l'e-mail

        <%OdfControl input654 = OdfControlFactory.create("generic", EC.itl.getId(), "ocsNotificationForActionMailSubject", null); input654.setForm(form639); input654.setProperty("width", ITL.S(messageCtrlWidth__1)); input654.setProperty("value", EC.itl.makeParameter(mailSubject__1, "string")); input654.show(); %>

        <%OdfControl input655 = OdfControlFactory.create("textArea", EC.itl.getId(), "ocsNotificationForActionMessage", null); input655.setForm(form639); input655.setProperty("width", ITL.S(messageCtrlWidth__1)); input655.setProperty("height", "54"); input655.setProperty("value", EC.itl.makeParameter(message__1, "string")); input655.show(); %>

        <%EC.itl.nextTab();%>
        <%EC.itl.generateCurrentTabAnchor();%>

        Information

        Vous pouvez envoyer une information concernant la fiche aux personnes ayant collaboré à sa publication.

        Personnes à notifier :


        Sujet de l'e-mail

        <%OdfControl input656 = OdfControlFactory.create("generic", EC.itl.getId(), "ocsNotificationForInfoMailSubject", null); input656.setForm(form639); input656.setProperty("width", ITL.S(messageCtrlWidth__1)); input656.setProperty("value", EC.itl.makeParameter(mailInfoSubject__1, "string")); input656.show(); %>

        <%OdfControl input657 = OdfControlFactory.create("textArea", EC.itl.getId(), "ocsNotificationForInfoMessage", null); input657.setForm(form639); input657.setProperty("width", ITL.S(messageCtrlWidth__1)); input657.setProperty("height", "54"); input657.setProperty("value", EC.itl.makeParameter(message__1, "string")); input657.show(); %>

        <%EC.itl.nextTab();EC.itl.popTab();%>
        <% } %>

        <%OdfControl input658 = OdfControlFactory.create("textArea", EC.itl.getId(), "logComment", null); input658.setForm(form639); input658.setProperty("width", "734"); input658.setProperty("height", "54"); input658.show(); %>

        <% ItlLink link659 = new ItlLink("#"); link659.setProperty("renderstyle.aClass", "admButton"); link659.setProperty("renderstyle.spanClass", "admButtonSpan"); link659.setProperty("renderstyle", "button"); link659.setProperty("onclick", "document.forms.changeStatus.submitButton.click(); return false;"); link659.show(); %> Valider <% link659.close(); %>
        <%form639.close();%>
        		 
             

        <% } } %> <% card__1.close(); catalogObject.close();%>