<?php
//$Id: lien_module.inc.php

include('../gen/sql/pgsql/lien_module.inc.php');

$retourformulaire = $retourformulaire ?? ($_GET['retourformulaire'] ?? '');
$idx = $idx ?? ($_GET['idx'] ?? '');

if (! empty($retourformulaire)) {

    $champAffiche = array(
        'lien_module.lien_module as "'.__("lien_module").'"',
        'lien_module.object_id as "'.__("object_id").'"',
        'lien_module.module as "'.__("module").'"',
        'lien_module.declencheur as "'.__("declencheur").'"',
        'lien_module.ordre as "'.__("ordre").'"',
        );
    $champNonAffiche = array(
        'lien_module.object_name as "'.__("object_name").'"',
        'lien_module.parametres as "'.__("parametres").'"',
        );

    $champRecherche = array(
        'lien_module.lien_module as "'.__("lien_module").'"',
        'lien_module.object_id as "'.__("object_id").'"',
        'lien_module.module as "'.__("module").'"',
        'lien_module.declencheur as "'.__("declencheur").'"',
        'lien_module.ordre as "'.__("ordre").'"',
        );

    $selection = "WHERE object_name = '".$this->db->escapeSimple($retourformulaire)."'";

    if (! empty($idx)) {
        $selection .= " AND object_id = '".$this->db->escapeSimple($idx)."'";
    }

    $tri = "ORDER BY lien_module.ordre DESC NULLS LAST";
}