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

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

$ent = __("operations")." -> ".__("toutes les opérations");

$sousformulaire = array();

$champ_demandeur = 'CONCAT_WS(\' \',
        \'(\' || 
            CASE WHEN autorisation.nature IS NOT NULL AND autorisation.nature = \'ayantdroit\'
            THEN
                \'ayant-droit\'
            ELSE
                autorisation.nature
            END
        || \')\',
        titre_de_civilite.libelle,                    
        CASE WHEN autorisation.marital IS NOT NULL AND autorisation.marital != \'\'
            THEN 
                autorisation.marital 
            ELSE
                autorisation.nom 
        END, 
        prenom
    ) as "'.__("demandeur").'"';

$champAffiche = array(
    'operation.operation as "'.__("id").'"',
    'numdossier as "'.__("numdossier").'"',
    'famille as "'.__("famille").'"',
    $champ_demandeur,
    'to_char(operation.date,\'DD/MM/YYYY\') as "'.__("date").'"',
    'operation.consigne_acces as "'.__("consigne d'accès (origine)").'"',
    'operation.consigne_acces_transfert as "'.__("consigne d'accès (destination)").'"',
    "CASE operation.prive WHEN 't' THEN 'Oui' ELSE 'Non' END as \"".__("Privé").'"',
);
$champRecherche = array(
    'operation.operation as "'.__("id").'"',
    'numdossier as "'.__("numdossier").'"',
    "famille",
    $champ_demandeur,
);

$table=sprintf(
    '%1$soperation 
    INNER JOIN 
        %1$semplacement 
            ON operation.emplacement = emplacement.emplacement
    LEFT JOIN
        %1$sautorisation
            ON operation.demandeur = autorisation.autorisation
    LEFT JOIN
        %1$stitre_de_civilite
            ON autorisation.titre = titre_de_civilite.titre_de_civilite',
    DB_PREFIXE
);

$selection="WHERE etat='actif' ";