<?php
/**
 *
 *
 * @package opencimetiere
 * @version SVN : $Id$
 */

//
include "../gen/sql/pgsql/contrat.inc.php";

//
$ent = " -> ".__($obj);

//
$field_contrat_emplacement = 'emplacement.emplacement as "'.__("emplacement").'"';
$champAffiche = array(
    'contrat.contrat as "'.__("id").'"',
    $field_contrat_emplacement,
    'to_char(contrat.datedemande ,\'DD/MM/YYYY\') as "'.__("datedemande").'"',
    'contrat.origine as "'.__("origine").'"',
    'contrat.terme as "'.__("terme").'"',
    'contrat.duree as "'.__("duree").'"',
    'to_char(contrat.datevente ,\'DD/MM/YYYY\') as "'.__("datevente").'"',
    'to_char(contrat.dateterme ,\'DD/MM/YYYY\') as "'.__("dateterme").'"',
    'contrat.montant as "'.__("montant").'"',
    'contrat.monnaie as "'.__("monnaie").'"',
    "case contrat.valide when 't' then 'Oui' else 'Non' end as \"".__("valide")."\"",
);
//
$fields_to_hide = array();
if (in_array($retourformulaire, $foreign_keys_extended["emplacement"])) {
    $fields_to_hide[] = $field_contrat_emplacement;
}
$champAffiche = array_diff($champAffiche, $fields_to_hide);
$tri = " ORDER BY contrat.datevente ASC, contrat.dateterme ASC ";