<%@ Page Language="C#" Buffer="true" CodeFile="gestion_inscription_cantine.aspx.cs" Inherits="_gestion_inscription_cantine" 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"; %> " /> Inscriptions à la cantine

Téléservices

<% 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")); } %>


 
<% EC.Request.dumpRepostForm(); int? currentStatus = (int?) ((int?)EC.itl.getParameterValue("integer", "currentStatus", 0)); SqlObject modifiedCard = (SqlObject) (new SqlObject("dm:form_cantine", @"SELECT this.`_oid` AS this FROM dm_form_cantine AS this INNER JOIN sf_form 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:dm:form_cantine", "modifiedCard"))),true)); string mode = (string) ((string)EC.itl.getParameterValue("string", "mode")); 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")); if(cmd == "newCardStatus") { ItlUpdateObject c1 = new ItlUpdateObject("dm:form_cantine", null, modifiedCard); ; c1.setField("sfStatus", newStatus, "integer", "sf:form"); c1.exec();; } else if(cmd == "deleteCard") { ItlDelete c2 = new ItlDelete("dm:form_cantine", modifiedCard); ; c2.exec();; } else if(cmd == "newStatus") { if(oids == "all") { %>- <% ItlUpdateCollection c4 = new ItlUpdateCollection("dm:form_cantine", new SqlCollection("dm:form_cantine", "SELECT \nthis.`_oid` AS this \nFROM dm_form_cantine AS this\nINNER JOIN sf_form AS this_z\nOn ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) \nWHERE \n(this.iso_sid <> '') \nAND (#V_0&; OR (this_z.sfStatus = #V_1&;))", new Map("#V_0&;|boolean", (currentStatus == -1), "#V_1&;|integer", currentStatus), null), (List>) EC.newList(new List>(), (List) EC.newList(new List(), "UPDATE sf_form \nSET \nsfStatus = #V_2&;", new Map("#V_0&;|boolean", (currentStatus == -1), "#V_1&;|integer", currentStatus, "#V_2&;|integer", newStatus)))); ; c4.exec();; } else { ItlEnumerator e6 = new ItlEnumerator("G00010cd1_5", null, false); e6.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("dm:form_cantine", @"SELECT this.`_oid` AS this FROM dm_form_cantine AS this INNER JOIN sf_form AS this_z On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.`_oid` IN (#V_0&;))", new ItlRuntime.SQL.Parameters( new ItlRuntime.SQL.Parameter("#V_0&;", ITL.S(oids), "oids")), new ItlRuntime.SQL.OrderAliases(), new ItlRuntime.SQL.OptionalOrderAliases(), null, null), @"SELECT this.`_oid` AS this FROM dm_form_cantine AS this INNER JOIN sf_form AS this_z On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map(), false, (List) EC.newList(new List()), null, null)); ItlEnumerator c = (ItlEnumerator) (e6); c.reset(); if(c.isNotEmpty()) { c.resetGroup(); for(c.start();c.test();c.fetch()) { ItlUpdateObject c7 = new ItlUpdateObject("dm:form_cantine", null, c); ; c7.setField("sfStatus", newStatus, "integer", "sf:form"); c7.exec();; } } c.finish(); } } SqlObject _t0 = new SqlObject("dm:form_cantine", @"SELECT this.`_oid` AS this FROM dm_form_cantine AS this INNER JOIN sf_form AS this_z On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (#V_0&; OR (#V_1&; = this_z.sfStatus)) ORDER BY this_z.sfModificationDate ASC, this_z.sfCreationDate DESC", new Map("#V_0&;|boolean", (currentStatus == -1), "#V_1&;|integer", currentStatus),false); SqlObject card = (SqlObject) (new SqlObject("dm:form_cantine", @"SELECT this.`_oid` AS this, this.nom_de_l_enfant AS this_p_nom_de_l_enfant, this.prenom_de_l_enfant AS this_p_prenom_de_l_enfant, this.adresse_des_parents AS this_p_adresse_des_parents, this.date_de_naissance_de_l_enfant AS this_p_date_de_naissance_de_l_enfant, this.regime_allergies AS this_p_regime_allergies, this.lundi AS this_p_lundi, this.mardi AS this_p_mardi, this.mercredi AS this_p_mercredi, this.jeudi AS this_p_jeudi, this.vendredi AS this_p_vendredi, this_s_classe_de_l_enfant.label_fr AS this_s_classe_de_l_enfant_p_label_fr, this_s_classe_de_l_enfant.`_oid` AS this_s_classe_de_l_enfant, this_s_photo_d_identite.width AS this_s_photo_d_identite_p_width, this_s_photo_d_identite.height AS this_s_photo_d_identite_p_height, this_s_photo_d_identite.frames AS this_s_photo_d_identite_p_frames, this_s_photo_d_identite.`_oid` AS this_s_photo_d_identite, this_s_photo_d_identite_z.urlDir AS this_s_photo_d_identite_z_p_urlDir, this_s_photo_d_identite_z.filename AS this_s_photo_d_identite_z_p_filename, this_s_photo_d_identite_z.extension AS this_s_photo_d_identite_z_p_extension, this_s_photo_d_identite_z.filesize AS this_s_photo_d_identite_z_p_filesize, this_s_photo_d_identite_z.filedate AS this_s_photo_d_identite_z_p_filedate, this_s_photo_d_identite_z.label_fr AS this_s_photo_d_identite_z_p_label_fr, this_s_photo_d_identite_z.description_fr AS this_s_photo_d_identite_z_p_description_fr, this_z.sfCreationDate AS this_z_p_sfCreationDate, this_z.sfModificationDate AS this_z_p_sfModificationDate, this_z.sfModifierLogin AS this_z_p_sfModifierLogin, this_z.sfStatus AS this_z_p_sfStatus FROM dm_form_cantine AS this INNER JOIN sf_form AS this_z On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_classe_de_l_enfant On ((this.classe_de_l_enfant = this_s_classe_de_l_enfant.`_oid`) AND (this_s_classe_de_l_enfant.iso_sid <> '')) LEFT JOIN (alb_private_image AS this_s_photo_d_identite INNER JOIN alb_private_resource AS this_s_photo_d_identite_z On ((this_s_photo_d_identite.`_oid` = this_s_photo_d_identite_z.`_oid`) AND (this_s_photo_d_identite_z.iso_sid <> ''))) On ((this.photo_d_identite = this_s_photo_d_identite.`_oid`) AND (this_s_photo_d_identite.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.`_oid` = #V_0&;)", new Map("#V_0&;|integer", EC.itl.toInteger(EC.itl.getParameterValue("object:dm:form_cantine", "card", EC.itl.toInteger(_t0)))),true)); if(cmd == "editCard") { ItlUpdateObject c13 = new ItlUpdateObject("dm:form_cantine", "card", card); ; c13.setField("sfModifierLogin", EC.itl.login(), "string", "sf:form", 64); c13.setField("sfModificationDate", EC.itl.now(), "date", "sf:form"); c13.exec();; } %>

Inscriptions à la cantine (<% ITL.show(EC.itl.toInteger(new SqlCollection("dm:form_cantine", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT this.`_oid` AS this, this.`_oid` AS data FROM dm_form_cantine AS this INNER JOIN (sf_form AS this_z LEFT JOIN sf_catalog AS this_z_s_sfCatalog On ((this_z.sfCatalog = this_z_s_sfCatalog.`_oid`) AND (this_z_s_sfCatalog.iso_sid <> ''))) On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this_z_s_sfCatalog.name = 'demande_d_inscription_a_la_cantine') AND (this_z.sfStatus = 0)) AS this", new Map(), (List) EC.newList(new List())).get("result")), "string", "html", "integer"); %>)

    > <% ItlLink link15 = new ItlLink("./gestion_inscription_cantine.aspx"); link15.setProperty("title", "Voir la liste des fiches entrantes"); link15.setParameter("currentStatus", 0); link15.show(); %> Fiches entrantes (<% ITL.show(EC.itl.toInteger(new SqlCollection("dm:form_cantine", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT this.`_oid` AS this, this.`_oid` AS data FROM dm_form_cantine AS this INNER JOIN (sf_form AS this_z LEFT JOIN sf_catalog AS this_z_s_sfCatalog On ((this_z.sfCatalog = this_z_s_sfCatalog.`_oid`) AND (this_z_s_sfCatalog.iso_sid <> ''))) On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this_z_s_sfCatalog.name = 'demande_d_inscription_a_la_cantine') AND (this_z.sfStatus = 0)) AS this", new Map(), (List) EC.newList(new List())).get("result")), "string", "html", "integer"); %>) <% link15.close(); %> > <% ItlLink link17 = new ItlLink("./gestion_inscription_cantine.aspx"); link17.setProperty("title", "Voir la liste des fiches en attente"); link17.setParameter("currentStatus", 1); link17.show(); %> Fiches en attente (<% ITL.show(EC.itl.toInteger(new SqlCollection("dm:form_cantine", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT this.`_oid` AS this, this.`_oid` AS data FROM dm_form_cantine AS this INNER JOIN (sf_form AS this_z LEFT JOIN sf_catalog AS this_z_s_sfCatalog On ((this_z.sfCatalog = this_z_s_sfCatalog.`_oid`) AND (this_z_s_sfCatalog.iso_sid <> ''))) On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this_z_s_sfCatalog.name = 'demande_d_inscription_a_la_cantine') AND (this_z.sfStatus = 1)) AS this", new Map(), (List) EC.newList(new List())).get("result")), "string", "html", "integer"); %>) <% link17.close(); %> > <% ItlLink link19 = new ItlLink("./gestion_inscription_cantine.aspx"); link19.setProperty("title", "Voir la liste des fiches acceptées"); link19.setParameter("currentStatus", 2); link19.show(); %> Fiches acceptées (<% ITL.show(EC.itl.toInteger(new SqlCollection("dm:form_cantine", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT this.`_oid` AS this, this.`_oid` AS data FROM dm_form_cantine AS this INNER JOIN (sf_form AS this_z LEFT JOIN sf_catalog AS this_z_s_sfCatalog On ((this_z.sfCatalog = this_z_s_sfCatalog.`_oid`) AND (this_z_s_sfCatalog.iso_sid <> ''))) On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this_z_s_sfCatalog.name = 'demande_d_inscription_a_la_cantine') AND (this_z.sfStatus = 2)) AS this", new Map(), (List) EC.newList(new List())).get("result")), "string", "html", "integer"); %>) <% link19.close(); %> > <% ItlLink link21 = new ItlLink("./gestion_inscription_cantine.aspx"); link21.setProperty("title", "Voir la liste des fiches rejetées"); link21.setParameter("currentStatus", 3); link21.show(); %> Fiches rejetées (<% ITL.show(EC.itl.toInteger(new SqlCollection("dm:form_cantine", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT this.`_oid` AS this, this.`_oid` AS data FROM dm_form_cantine AS this INNER JOIN (sf_form AS this_z LEFT JOIN sf_catalog AS this_z_s_sfCatalog On ((this_z.sfCatalog = this_z_s_sfCatalog.`_oid`) AND (this_z_s_sfCatalog.iso_sid <> ''))) On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this_z_s_sfCatalog.name = 'demande_d_inscription_a_la_cantine') AND (this_z.sfStatus = 3)) AS this", new Map(), (List) EC.newList(new List())).get("result")), "string", "html", "integer"); %>) <% link21.close(); %> > <% ItlLink link23 = new ItlLink("./gestion_inscription_cantine.aspx"); link23.setProperty("title", "Voir toutes les fiches"); link23.setParameter("currentStatus", -1); link23.show(); %> Toutes les fiches (<% ITL.show(EC.itl.toInteger(new SqlCollection("dm:form_cantine", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT this.`_oid` AS this, this.`_oid` AS data FROM dm_form_cantine AS this INNER JOIN (sf_form AS this_z LEFT JOIN sf_catalog AS this_z_s_sfCatalog On ((this_z.sfCatalog = this_z_s_sfCatalog.`_oid`) AND (this_z_s_sfCatalog.iso_sid <> ''))) On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this_z_s_sfCatalog.name = 'demande_d_inscription_a_la_cantine')) AS this", new Map(), (List) EC.newList(new List())).get("result")), "string", "html", "integer"); %>) <% link23.close(); %>

    Retour au site

         
      <% if(mode == "view" && EC.itl.toBoolean(card)) { %>

    Actions sur la fiche

    • <% ItlLink link25 = new ItlLink("./gestion_inscription_cantine.aspx"); link25.setProperty("title", "Modifier la fiche"); link25.setProperty("class", "modify"); link25.setParameter("mode", "edit"); link25.setParameter("currentStatus", 2); link25.setParameter("card", (int?)card.get("this")); link25.show(); %> Modifier <% link25.close(); if((int?)card.get("this_z_p_sfStatus") < 2) { ItlLink link27 = new ItlLink("./gestion_inscription_cantine.aspx"); link27.setProperty("title", "Accepter la fiche"); link27.setProperty("class", "accept"); link27.setParameter("mode", "view"); link27.setParameter("cmd", "newCardStatus"); link27.setParameter("modifiedCard", (int?)card.get("this")); link27.setParameter("newStatus", 2); link27.setParameter("currentStatus", currentStatus); link27.show(); %> Accepter <% link27.close(); } if((int?)card.get("this_z_p_sfStatus") != 1) { ItlLink link29 = new ItlLink("./gestion_inscription_cantine.aspx"); link29.setProperty("title", "Mettre la fiche en attente"); link29.setProperty("class", "wait"); link29.setParameter("mode", "view"); link29.setParameter("cmd", "newCardStatus"); link29.setParameter("modifiedCard", (int?)card.get("this")); link29.setParameter("newStatus", 1); link29.setParameter("currentStatus", currentStatus); link29.show(); %> En attente <% link29.close(); } if((int?)card.get("this_z_p_sfStatus") < 2) { ItlLink link31 = new ItlLink("./gestion_inscription_cantine.aspx"); link31.setProperty("title", "Rejeter la fiche"); link31.setProperty("class", "reject"); link31.setParameter("mode", "view"); link31.setParameter("cmd", "newCardStatus"); link31.setParameter("modifiedCard", (int?)card.get("this")); link31.setParameter("newStatus", 3); link31.setParameter("currentStatus", currentStatus); link31.show(); %> Rejeter <% link31.close(); } if((int?)card.get("this_z_p_sfStatus") < 2) { ItlLink link33 = new ItlLink("./gestion_inscription_cantine.aspx"); link33.setProperty("title", "Supprimer la fiche"); link33.setProperty("class", "remove"); link33.setProperty("onclick", "return confirm('Êtes-vous sûr de vouloir supprimer la fiche')"); link33.setParameter("mode", "view"); link33.setParameter("cmd", "deleteCard"); link33.setParameter("modifiedCard", (int?)card.get("this")); link33.setParameter("currentStatus", currentStatus); link33.show(); %> Supprimer <% link33.close(); } %>

    Fiche :

    Nom de l'enfant :

    <% ITL.show((string)card.get("this_p_nom_de_l_enfant"), "string", "html", "string"); %>

    Prénom de l'enfant :

    <% ITL.show((string)card.get("this_p_prenom_de_l_enfant"), "string", "html", "string"); %>

    Adresse des parents :

    <% ITL.show((string)card.get("this_p_adresse_des_parents"), "string", "memo", "string"); %>

    Date de naissance de l'enfant :

    <% ITL.show((DateTime?)card.get("this_p_date_de_naissance_de_l_enfant"), "string", "html", "date"); %>

    Classe de l'enfant :

    <% ITL.show((string)card.get("this_s_classe_de_l_enfant_p_label_fr"), "string", "html", "string"); %>

    Photo d'identité :

    <% if(ITL.isNotNull((int?)card.get("this_s_photo_d_identite"))) { int effectiveWidth = (int) (EC.itl.getEffectiveWidth((int?)card.get("this_s_photo_d_identite_p_width"), (int?)card.get("this_s_photo_d_identite_p_height"), 200, 100)); int effectiveHeight = (int) (EC.itl.getEffectiveHeight((int?)card.get("this_s_photo_d_identite_p_width"), (int?)card.get("this_s_photo_d_identite_p_height"), 200, 100)); %>

    > > <% ItlLink link51 = new ItlLink(""); link51.setProperty("class", "link"); link51.show(); %> class="image"<%ITL.showAttributeWithName("title", (string)card.get("this_s_photo_d_identite_z_p_label_fr"));ITL.showAttributeWithName("alt", (string)card.get("this_s_photo_d_identite_z_p_label_fr"));ITL.showAttributeWithName("longdesc", (string)card.get("this_s_photo_d_identite_z_p_description_fr"));ITL.showAttributeWithName("height", effectiveHeight);ITL.showAttributeWithName("width", effectiveWidth);%>/><% link51.close(); if((int?)card.get("this_s_photo_d_identite_p_width") > 200 || (int?)card.get("this_s_photo_d_identite_p_height") > 100) { fullSizeRatio = (double?)(ITL.gv["fullSizeRatio"] = 1D); if((int?)card.get("this_s_photo_d_identite_p_width") <= 800 - 37 && (int?)card.get("this_s_photo_d_identite_p_height") <= 600 - 30) { fullSizeRatio = (double?)(ITL.gv["fullSizeRatio"] = 1D); } else if(ITL.i((int?)card.get("this_s_photo_d_identite_p_height")) * (800 - 37) > ITL.i((int?)card.get("this_s_photo_d_identite_p_width")) * (600 - 30)) { fullSizeRatio = (double?)(ITL.gv["fullSizeRatio"] = 570D / ITL.d((int?)card.get("this_s_photo_d_identite_p_height"))); } else { fullSizeRatio = (double?)(ITL.gv["fullSizeRatio"] = 570D / ITL.d((int?)card.get("this_s_photo_d_identite_p_height"))); } string fullSizeUrl = (string) (EC.itl.getEffectiveUrl("alb:private_image", (int?)card.get("this_s_photo_d_identite"), (int?)card.get("this_s_photo_d_identite_p_width"), (int?)card.get("this_s_photo_d_identite_p_height"), (int?)card.get("this_s_photo_d_identite_p_frames"), (int)Math.Floor((ITL.d((double?)ITL.gv["fullSizeRatio"]) * ITL.d((int?)card.get("this_s_photo_d_identite_p_width")))), (int)Math.Floor((ITL.d((double?)ITL.gv["fullSizeRatio"]) * ITL.d((int?)card.get("this_s_photo_d_identite_p_height")))))); string wp = (string) (((("width=" + ITL.S((int)Math.Floor((ITL.d((double?)ITL.gv["fullSizeRatio"]) * ITL.d((int?)card.get("this_s_photo_d_identite_p_width")))))) + ",height=") + ITL.S((int)Math.Floor((ITL.d((double?)ITL.gv["fullSizeRatio"]) * ITL.d((int?)card.get("this_s_photo_d_identite_p_height")))))) + ",scrollbars=1,menubar=0,resizable=1"); ItlLink link53 = new ItlLink(fullSizeUrl); link53.setProperty("class", "zoom "); link53.setProperty("windowParams", wp); link53.show(); %>Zoom<% link53.close(); } %>

    <% } else { } %>

    Régime-Allergies :

    <% ITL.show((string)card.get("this_p_regime_allergies"), "string", "memo", "string"); %>

    Lundi :

    <% ITL.show((bool?)card.get("this_p_lundi"), "string", "html", "boolean"); %>

    Mardi :

    <% ITL.show((bool?)card.get("this_p_mardi"), "string", "html", "boolean"); %>

    Mercredi :

    <% ITL.show((bool?)card.get("this_p_mercredi"), "string", "html", "boolean"); %>

    Jeudi :

    <% ITL.show((bool?)card.get("this_p_jeudi"), "string", "html", "boolean"); %>

    Vendredi :

    <% ITL.show((bool?)card.get("this_p_vendredi"), "string", "html", "boolean"); %>

    Informations supplémentaires
    Date de création : <% ITL.show((DateTime?)card.get("this_z_p_sfCreationDate"), "string", "html", "date"); %> <% if(ITL.b((DateTime?)card.get("this_z_p_sfModificationDate"))) { %> Date de dernière modification : <% ITL.show((DateTime?)card.get("this_z_p_sfModificationDate"), "string", "html", "date"); %> par <% ITL.show((string)card.get("this_z_p_sfModifierLogin"), "string", "html", "string"); %> <% } %>
    <% } else if(mode == "edit") { ItlForm form63 = new ItlForm("form63", EC.itl.getId(), "./gestion_inscription_cantine.aspx", "G00010cd1_64"); form63.setProperty("name", "edit"); form63.setProperty("enctype", "multipart/form-data"); form63.setProperty("method", "post"); form63.setProperty("hasProcessing", false); form63.addParameter("card", EC.itl.makeParameter(card, "object")); form63.addParameter("mode", "view"); form63.addParameter("modifiedCard", EC.itl.makeParameter(card, "object")); form63.addParameter("currentStatus", EC.itl.makeParameter(currentStatus, "integer")); form63.addParameter("cmd", "editCard"); form63.show(); %>

    Modification :

    <%OdfControl input65 = OdfControlFactory.create("generic", "controlcard_nom_de_l_enfant", "card.nom_de_l_enfant", null); input65.setForm(form63); input65.setProperty("columns", 2); input65.setProperty("requiredmeta", false); input65.setProperty("width", "647"); input65.setProperty("height", "80"); input65.setProperty("value", EC.itl.makeParameter((string)card.get("this_p_nom_de_l_enfant"), "string")); input65.setProperty("maxlength", 255); input65.show(); %>
    <%OdfControl input66 = OdfControlFactory.create("generic", "controlcard_prenom_de_l_enfant", "card.prenom_de_l_enfant", null); input66.setForm(form63); input66.setProperty("columns", 2); input66.setProperty("requiredmeta", false); input66.setProperty("width", "647"); input66.setProperty("height", "80"); input66.setProperty("value", EC.itl.makeParameter((string)card.get("this_p_prenom_de_l_enfant"), "string")); input66.setProperty("maxlength", 255); input66.show(); %>
    <%OdfControl input67 = OdfControlFactory.create("textArea", "controlcard_adresse_des_parents", "card.adresse_des_parents", null); input67.setForm(form63); input67.setProperty("columns", 2); input67.setProperty("requiredmeta", false); input67.setProperty("width", "647"); input67.setProperty("height", "80"); input67.setProperty("value", EC.itl.makeParameter((string)card.get("this_p_adresse_des_parents"), "string")); input67.setProperty("maxlength", 1024); input67.show(); %>
    <%OdfControl input68 = OdfControlFactory.create("date", "controlcard_date_de_naissance_de_l_enfant", "card.date_de_naissance_de_l_enfant", null); input68.setForm(form63); input68.setProperty("columns", 2); input68.setProperty("requiredmeta", false); input68.setProperty("value", EC.itl.makeParameter((DateTime?)card.get("this_p_date_de_naissance_de_l_enfant"), "date")); input68.show(); %>
    <%OdfControl input69 = OdfControlFactory.create("select", "controlcard_classe_de_l_enfant", "card.classe_de_l_enfant", null); input69.setForm(form63); input69.setProperty("comment", "Classe de l'enfant"); input69.setProperty("value", EC.itl.makeParameter(card.getObject("this_s_classe_de_l_enfant", "omc:stringItem"), "object")); input69.addOption("", "--- non défini ---", new Map()); ItlEnumerator e71 = new ItlEnumerator("G00010cd1_70", null, false); e71.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("omc:stringItem", @"SELECT this.`_oid` AS this, this.rank AS o_1 FROM omc_stringItem AS this LEFT JOIN omc_stringList AS this_s_list On ((this.list = this_s_list.`_oid`) AND (this_s_list.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this_s_list.name = 'dm:classe')", 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.label_fr AS this_p_label_fr FROM omc_stringItem AS this WHERE (this.iso_sid <> '')", new Map(), false, (List) EC.newList(new List()), null, null)); ItlEnumerator item = (ItlEnumerator) (e71); item.reset(); if(item.isNotEmpty()) { item.resetGroup(); for(item.start();item.test();item.fetch()) { input69.addOption(EC.itl.makeParameter((int?)item.get("this"), "integer"), (string)item.get("this_p_label_fr"), new Map()); } } item.finish(); input69.show(); %>
    <%OdfControl input73 = OdfControlFactory.create("privateImage", "controlcard_photo_d_identite", "card.photo_d_identite", null); input73.setForm(form63); input73.setProperty("columns", 2); input73.setProperty("requiredmeta", false); input73.setProperty("width", "647"); input73.setProperty("height", "80"); input73.setProperty("value", EC.itl.makeParameter(card.getObject("this_s_photo_d_identite", "alb:private_image"), "object")); input73.setProperty("sourcewidth", (int?)card.get("this_s_photo_d_identite_p_width")); input73.setProperty("sourceheight", (int?)card.get("this_s_photo_d_identite_p_height")); input73.setProperty("sourceURL", (((EC.globalRootPath + ITL.S(EC.itl.stringSubstr(ITL.S((string)card.get("this_s_photo_d_identite_z_p_urlDir")),0, 1) == "/"?EC.itl.stringSubstr(ITL.S((string)card.get("this_s_photo_d_identite_z_p_urlDir")),1, null):(string)card.get("this_s_photo_d_identite_z_p_urlDir"))) + ITL.S((string)card.get("this_s_photo_d_identite_z_p_filename"))) + ITL.S((string)card.get("this_s_photo_d_identite_z_p_extension")))); input73.setProperty("sourcefilename", (string)card.get("this_s_photo_d_identite_z_p_filename")); input73.setProperty("sourceextension", (string)card.get("this_s_photo_d_identite_z_p_extension")); input73.setProperty("sourcefiledate", (DateTime?)card.get("this_s_photo_d_identite_z_p_filedate")); input73.setProperty("sourcefilesize", (int?)card.get("this_s_photo_d_identite_z_p_filesize")); input73.setProperty("sourcelabel", (string)card.get("this_s_photo_d_identite_z_p_label_fr")); input73.setProperty("sourcedescription", (string)card.get("this_s_photo_d_identite_z_p_description_fr")); input73.show(); %>
    <%OdfControl input74 = OdfControlFactory.create("textArea", "controlcard_regime_allergies", "card.regime_allergies", null); input74.setForm(form63); input74.setProperty("columns", 2); input74.setProperty("requiredmeta", false); input74.setProperty("width", "647"); input74.setProperty("height", "80"); input74.setProperty("value", EC.itl.makeParameter((string)card.get("this_p_regime_allergies"), "string")); input74.setProperty("maxlength", 1024); input74.show(); %>
    <%OdfControl input75 = OdfControlFactory.create("checkbox", "controlcard_lundi", "card.lundi", null); input75.setForm(form63); input75.setProperty("columns", 2); input75.setProperty("requiredmeta", false); input75.setProperty("width", "647"); input75.setProperty("height", "80"); input75.setProperty("value", EC.itl.makeParameter((bool?)card.get("this_p_lundi"), "boolean")); input75.show(); %>
    <%OdfControl input76 = OdfControlFactory.create("checkbox", "controlcard_mardi", "card.mardi", null); input76.setForm(form63); input76.setProperty("columns", 2); input76.setProperty("requiredmeta", false); input76.setProperty("width", "647"); input76.setProperty("height", "80"); input76.setProperty("value", EC.itl.makeParameter((bool?)card.get("this_p_mardi"), "boolean")); input76.show(); %>
    <%OdfControl input77 = OdfControlFactory.create("checkbox", "controlcard_mercredi", "card.mercredi", null); input77.setForm(form63); input77.setProperty("columns", 2); input77.setProperty("requiredmeta", false); input77.setProperty("width", "647"); input77.setProperty("height", "80"); input77.setProperty("value", EC.itl.makeParameter((bool?)card.get("this_p_mercredi"), "boolean")); input77.show(); %>
    <%OdfControl input78 = OdfControlFactory.create("checkbox", "controlcard_jeudi", "card.jeudi", null); input78.setForm(form63); input78.setProperty("columns", 2); input78.setProperty("requiredmeta", false); input78.setProperty("width", "647"); input78.setProperty("height", "80"); input78.setProperty("value", EC.itl.makeParameter((bool?)card.get("this_p_jeudi"), "boolean")); input78.show(); %>
    <%OdfControl input79 = OdfControlFactory.create("checkbox", "controlcard_vendredi", "card.vendredi", null); input79.setForm(form63); input79.setProperty("columns", 2); input79.setProperty("requiredmeta", false); input79.setProperty("width", "647"); input79.setProperty("height", "80"); input79.setProperty("value", EC.itl.makeParameter((bool?)card.get("this_p_vendredi"), "boolean")); input79.show(); %>
    <% %>
    <% ItlLink link81 = new ItlLink("./gestion_inscription_cantine.aspx"); link81.setProperty("renderstyle", "admButton"); link81.setProperty("title", "Retourner à la vue fiche"); link81.setParameter("card", (int?)card.get("this")); link81.setParameter("mode", "view"); link81.setParameter("currentStatus", currentStatus); link81.show(); %> Annuler <% link81.close(); ItlLink link82 = new ItlLink("#"); link82.setProperty("renderstyle", "admButton"); link82.setProperty("onclick", "document.forms.edit.submitButton.click();return false;"); link82.setProperty("title", "Enregistrer les modifications"); link82.show(); %> Valider <% link82.close(); %>

    <%form63.close(); } else {ItlForm form83 = new ItlForm("form83", EC.itl.getId(), "#", "G00010cd1_84"); form83.setProperty("method", "post"); form83.setProperty("name", "fake"); form83.setProperty("hasProcessing", false); form83.show(); int? sdsLimit = (int?) ((int?)EC.itl.getParameterValue("integer", "sdsLimit", 15)); %>
    <% ItlEnumerator e89 = new ItlEnumerator("G00010cd1_88", null, false); e89.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("dm:form_cantine", @"SELECT this.`_oid` AS this, this_z.sfModificationDate AS o_1, this_z.sfCreationDate AS o_2, this.nom_de_l_enfant AS o_3, 0 AS o_4, this.lundi AS o_5, this.mardi AS o_6, this.mercredi AS o_7, this.jeudi AS o_8, this.vendredi AS o_9, this_z.sfStatus AS o_10, this_z.sfCreationDate AS o_11 FROM dm_form_cantine AS this INNER JOIN (sf_form AS this_z LEFT JOIN sf_catalog AS this_z_s_sfCatalog On ((this_z.sfCatalog = this_z_s_sfCatalog.`_oid`) AND (this_z_s_sfCatalog.iso_sid <> ''))) On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this_z_s_sfCatalog.name = 'demande_d_inscription_a_la_cantine') AND (#V_0&; OR (this_z.sfStatus = #V_1&;))", new ItlRuntime.SQL.Parameters( new ItlRuntime.SQL.Parameter("#V_0&;", (currentStatus < 0), "boolean"), new ItlRuntime.SQL.Parameter("#V_1&;", currentStatus, "integer")), new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_1", true), new ItlRuntime.SQL.OrderAlias("o_2", false)), new ItlRuntime.SQL.OptionalOrderAliases(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)), new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_6", true)), new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_7", true)), new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_8", true)), new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_9", true)), new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_10", true)), new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_11", true))), null, null), @"SELECT this.`_oid` AS this, this.nom_de_l_enfant AS this_p_nom_de_l_enfant, this.lundi AS this_p_lundi, this.mardi AS this_p_mardi, this.mercredi AS this_p_mercredi, this.jeudi AS this_p_jeudi, this.vendredi AS this_p_vendredi, this_s_classe_de_l_enfant.label_fr AS this_s_classe_de_l_enfant_p_label_fr, this_s_classe_de_l_enfant.`_oid` AS this_s_classe_de_l_enfant, this_z.sfCreationDate AS this_z_p_sfCreationDate, this_z.sfStatus AS this_z_p_sfStatus FROM dm_form_cantine AS this INNER JOIN sf_form AS this_z On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_classe_de_l_enfant On ((this.classe_de_l_enfant = this_s_classe_de_l_enfant.`_oid`) AND (this_s_classe_de_l_enfant.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map(), true, (List) EC.newList(new List(), 1, 1, 1, 1, 1, 1, 1, 1, 1), (int?)null, (int?)null)); e89.setLimit(sdsLimit); e89.setLimits("15 50 100 all"); e89.setNavigationFeatures("firstPage previousPage lastPage nextPage allPages"); ItlEnumerator card__2 = (ItlEnumerator) (e89); card__2.reset(); if(card__2.isNotEmpty()) { ItlEnumerator tableEnumerator = (ItlEnumerator) (card__2); %>

    <% if(mode == "edit") { %> Correction de la fiche "" <% } else if(currentStatus == -1) { %> Toutes les fiches <% } else if(currentStatus == 0) { %> Fiches entrantes <% } else if(currentStatus == 1) { %> Fiches en attente <% } else if(currentStatus == 2) { %> Fiches acceptées <% } else if(currentStatus == 3) { %> Fiches rejetées <% } %>

    <% 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);%><% columnCount = (int?)(ITL.gv["columnCount"] = 7);%><% columnCount = (int?)(ITL.gv["columnCount"] = 8);%><% columnCount = (int?)(ITL.gv["columnCount"] = 9); %><% columnCount = (int?)(ITL.gv["columnCount"] = 10); %><% columnCount = (int?)(ITL.gv["columnCount"] = 11); %><% 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"); %>><% %><% %><% %><% %><% }%>
    <% if(currentStatus == 0 || currentStatus == 3) { %> target="_self" title="Supprimer les fiches de la sélection"> Supprimer <% } ItlLink link107 = new ItlLink("./xls00010cd1.aspx"); link107.setParameter("className", "dm:form_cantine"); link107.setParameter("formName", "demande_d_inscription_a_la_cantine"); link107.setParameter("currentStatus", currentStatus); EC.itl.sdsRegisterTableActionLink(link107, "link107");%> Exporter <% if(currentStatus < 2) { ItlLink link109 = new ItlLink("./gestion_inscription_cantine.aspx"); link109.setParameter("cmd", "newStatus"); link109.setParameter("newStatus", 3); link109.setParameter("currentStatus", currentStatus); EC.itl.sdsRegisterTableActionLink(link109, "link109");%> Rejeter <% } if(currentStatus != 1) { ItlLink link111 = new ItlLink("./gestion_inscription_cantine.aspx"); link111.setParameter("cmd", "newStatus"); link111.setParameter("newStatus", 1); link111.setParameter("currentStatus", currentStatus); EC.itl.sdsRegisterTableActionLink(link111, "link111");%> En attente <% } if(currentStatus < 2) { ItlLink link113 = new ItlLink("./gestion_inscription_cantine.aspx"); link113.setParameter("cmd", "newStatus"); link113.setParameter("newStatus", 2); link113.setParameter("currentStatus", currentStatus); EC.itl.sdsRegisterTableActionLink(link113, "link113");%> Accepter <% } %>
      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"); %>
     Nom de l'enfant<% if(tableEnumerator.count() > 1) { %>v^<% } %>Classe de l'enfant<% if(tableEnumerator.count() > 1) { %>v^<% } %>Lundi<% if(tableEnumerator.count() > 1) { %>v^<% } %>Mardi<% if(tableEnumerator.count() > 1) { %>v^<% } %>Mercredi<% if(tableEnumerator.count() > 1) { %>v^<% } %>Jeudi<% if(tableEnumerator.count() > 1) { %>v^<% } %>Vendredi<% if(tableEnumerator.count() > 1) { %>v^<% } %>État<% 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
    <% if(currentStatus == 0 || currentStatus == 3) { %> target="_self" title="Supprimer les fiches de la sélection"> Supprimer <% } ItlLink link153 = new ItlLink("./xls00010cd1.aspx"); link153.setParameter("className", "dm:form_cantine"); link153.setParameter("formName", "demande_d_inscription_a_la_cantine"); link153.setParameter("currentStatus", currentStatus); EC.itl.sdsRegisterTableActionLink(link153, "link153");%> Exporter <% if(currentStatus < 2) { ItlLink link155 = new ItlLink("./gestion_inscription_cantine.aspx"); link155.setParameter("cmd", "newStatus"); link155.setParameter("newStatus", 3); link155.setParameter("currentStatus", currentStatus); EC.itl.sdsRegisterTableActionLink(link155, "link155");%> Rejeter <% } if(currentStatus != 1) { ItlLink link157 = new ItlLink("./gestion_inscription_cantine.aspx"); link157.setParameter("cmd", "newStatus"); link157.setParameter("newStatus", 1); link157.setParameter("currentStatus", currentStatus); EC.itl.sdsRegisterTableActionLink(link157, "link157");%> En attente <% } if(currentStatus < 2) { ItlLink link159 = new ItlLink("./gestion_inscription_cantine.aspx"); link159.setParameter("cmd", "newStatus"); link159.setParameter("newStatus", 2); link159.setParameter("currentStatus", currentStatus); EC.itl.sdsRegisterTableActionLink(link159, "link159");%> Accepter <% } %>
    <% if(tableEnumerator.isObjectSelected()) { %> checked="checked"/><% } else {%>/><% } %> <% ItlLink link163 = new ItlLink("./gestion_inscription_cantine.aspx"); link163.setProperty("title", "Modifier la fiche"); link163.setParameter("mode", "edit"); link163.setParameter("card", card__2); link163.setParameter("currentStatus", currentStatus); link163.show(); %> Modifier la fiche <% link163.close(); %> <% ItlLink link167 = new ItlLink("./gestion_inscription_cantine.aspx"); link167.setProperty("title", "Voir la fiche"); link167.setParameter("mode", "view"); link167.setParameter("currentStatus", currentStatus); link167.setParameter("card", card__2); link167.show(); ITL.show((string)card__2.get("this_p_nom_de_l_enfant"), "string", "html", "string"); link167.close(); if(ITL.S((string)card__2.get("this_p_nom_de_l_enfant")) == "") { %>   <% } %> <% ItlLink link170 = new ItlLink("./gestion_inscription_cantine.aspx"); link170.setProperty("title", "Voir la fiche"); link170.setParameter("mode", "view"); link170.setParameter("currentStatus", currentStatus); link170.setParameter("card", card__2); link170.show(); ITL.show((string)card__2.get("this_s_classe_de_l_enfant_p_label_fr"), "string", "html", "string"); link170.close(); if(EC.itl.toString(card__2.getObject("this_s_classe_de_l_enfant", "omc:stringItem")) == "") { %>   <% } %> <% ItlLink link174 = new ItlLink("./gestion_inscription_cantine.aspx"); link174.setProperty("title", "Voir la fiche"); link174.setParameter("mode", "view"); link174.setParameter("currentStatus", currentStatus); link174.setParameter("card", card__2); link174.show(); ITL.show((bool?)card__2.get("this_p_lundi"), "string", "html", "boolean"); link174.close(); if(ITL.S((bool?)card__2.get("this_p_lundi")) == "") { %>   <% } %> <% ItlLink link177 = new ItlLink("./gestion_inscription_cantine.aspx"); link177.setProperty("title", "Voir la fiche"); link177.setParameter("mode", "view"); link177.setParameter("currentStatus", currentStatus); link177.setParameter("card", card__2); link177.show(); ITL.show((bool?)card__2.get("this_p_mardi"), "string", "html", "boolean"); link177.close(); if(ITL.S((bool?)card__2.get("this_p_mardi")) == "") { %>   <% } %> <% ItlLink link180 = new ItlLink("./gestion_inscription_cantine.aspx"); link180.setProperty("title", "Voir la fiche"); link180.setParameter("mode", "view"); link180.setParameter("currentStatus", currentStatus); link180.setParameter("card", card__2); link180.show(); ITL.show((bool?)card__2.get("this_p_mercredi"), "string", "html", "boolean"); link180.close(); if(ITL.S((bool?)card__2.get("this_p_mercredi")) == "") { %>   <% } %> <% ItlLink link183 = new ItlLink("./gestion_inscription_cantine.aspx"); link183.setProperty("title", "Voir la fiche"); link183.setParameter("mode", "view"); link183.setParameter("currentStatus", currentStatus); link183.setParameter("card", card__2); link183.show(); ITL.show((bool?)card__2.get("this_p_jeudi"), "string", "html", "boolean"); link183.close(); if(ITL.S((bool?)card__2.get("this_p_jeudi")) == "") { %>   <% } %> <% ItlLink link186 = new ItlLink("./gestion_inscription_cantine.aspx"); link186.setProperty("title", "Voir la fiche"); link186.setParameter("mode", "view"); link186.setParameter("currentStatus", currentStatus); link186.setParameter("card", card__2); link186.show(); ITL.show((bool?)card__2.get("this_p_vendredi"), "string", "html", "boolean"); link186.close(); if(ITL.S((bool?)card__2.get("this_p_vendredi")) == "") { %>   <% } %> <% ItlLink link188 = new ItlLink("./gestion_inscription_cantine.aspx"); link188.setProperty("title", "Voir la fiche"); link188.setParameter("mode", "view"); link188.setParameter("currentStatus", currentStatus); link188.setParameter("card", card__2); link188.show(); if((int?)card__2.get("this_z_p_sfStatus") == 0) { %>Entrant<% } else if((int?)card__2.get("this_z_p_sfStatus") == 1) { %>En attente<% } else if((int?)card__2.get("this_z_p_sfStatus") == 2) { %>Accepté<% } else if((int?)card__2.get("this_z_p_sfStatus") == 3) { %>Rejeté<% } else if((int?)card__2.get("this_z_p_sfStatus") == 4) { %>Traité<% } link188.close(); %> <% ITL.show((DateTime?)card__2.get("this_z_p_sfCreationDate"), "string", "html", "date"); %>
    <% } else {%> Aucune fiche.
    <% } card__2.finish(); %> <%form83.close(); } %>
    		 
         

    <% modifiedCard.close(); card.close();%>