[openads-Commits] r18042 - branches/6.6.0-develop-10428-xval/sql/pgsql

[ejpri...@users.adullact.net]

Author: ejpritchard
Date: 2024-06-21 15:50:19 +0200 (Fri, 21 Jun 2024)
New Revision: 18042

Added:
branches/6.6.0-develop-10428-xval/sql/pgsql/parametrage_annexe.inc.php
Log:
fix(ListingParametrageAnnexe) : Corriger l'intituler de la colonne dossier et ajouter la colonne instruction

Added: branches/6.6.0-develop-10428-xval/sql/pgsql/parametrage_annexe.inc.php
===================================================================
--- branches/6.6.0-develop-10428-xval/sql/pgsql/parametrage_annexe.inc.php (rev 0)
+++ branches/6.6.0-develop-10428-xval/sql/pgsql/parametrage_annexe.inc.php 2024-06-21 13:50:19 UTC (rev 18042)
@@ -0,0 +1,61 @@
+<?php
+//$Id$
+//gen openMairie le 12/06/2024 16:14
+
+$DEBUG=0;
+$serie=15;
+$ent = __("application")." -> ".__("parametrage_annexe");
+if(!isset($premier)) $premier='';
+if(!isset($tricolsf)) $tricolsf='';
+if(!isset($premiersf)) $premiersf='';
+if(!isset($selection)) $selection='';
+if(!isset($retourformulaire)) $retourformulaire='';
+if (!isset($idxformulaire)) {
+ $idxformulaire = '';
+}
+if (!isset($tricol)) {
+ $tricol = '';
+}
+if (!isset($valide)) {
+ $valide = '';
+}
+// FROM
+$table = DB_PREFIXE."parametrage_annexe
+ LEFT JOIN ".DB_PREFIXE."instruction
+ ON parametrage_annexe.instruction=instruction.instruction ";
+// SELECT
+$champAffiche = array(
+ 'parametrage_annexe.parametrage_annexe as "'.__("parametrage_annexe").'"',
+ 'instruction.dossier as "'.__("dossier").'"',
+ 'parametrage_annexe.instruction as "'.__("instruction").'"',
+ 'parametrage_annexe.document_object_type as "'.__("document_object_type").'"',
+ 'parametrage_annexe.document_object_type_id as "'.__("document_object_type_id").'"',
+ 'parametrage_annexe.condition as "'.__("condition").'"',
+ );
+//
+$champNonAffiche = array(
+ );
+//
+$champRecherche = array(
+ 'parametrage_annexe.parametrage_annexe as "'.__("parametrage_annexe").'"',
+ 'instruction.destinataire as "'.__("dossier").'"',
+ 'parametrage_annexe.document_object_type as "'.__("document_object_type").'"',
+ 'parametrage_annexe.document_object_type_id as "'.__("document_object_type_id").'"',
+ 'parametrage_annexe.condition as "'.__("condition").'"',
+ );
+$tri="ORDER BY instruction.destinataire ASC NULLS LAST";
+$edition="parametrage_annexe";
+/**
+ * Gestion de la clause WHERE => $selection
+ */
+// Filtre listing standard
+$selection = "";
+// Liste des clés étrangères avec leurs éventuelles surcharges
+$foreign_keys_extended = array(
+ "instruction" => array("instruction", "instruction_modale", ),
+);
+// Filtre listing sous formulaire - instruction
+if (in_array($retourformulaire, $foreign_keys_extended["instruction"])) {
+ $selection = " WHERE (parametrage_annexe.instruction = ".intval($idxformulaire).") ";
+}
+


Property changes on: branches/6.6.0-develop-10428-xval/sql/pgsql/parametrage_annexe.inc.php
___________________________________________________________________
Added: svn:executable
## -0,0 +1 ##
+*
\ No newline at end of property