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

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

if (isset($idx)) {
    $selection = " where genealogie_archive.emplacement=".$idx;
}
// Actions a gauche : consulter
if (isset($tab_actions)) {
    unset($tab_actions['corner']['ajouter']);
}

$champAffiche = array(
    'genealogie_archive.genealogie as "'.__("Généalogie").'"',
    // Affichage de la première personne sélectionnée en fonction de defunt_p1 et autorisation_p1
    'CASE WHEN 
        genealogie_archive.defunt_p1 IS NOT NULL 
            THEN 
            (SELECT CONCAT_WS(\' \', defunt_archive.defunt, defunt_archive.nom, defunt_archive.marital, defunt_archive.prenom, \'defunt\') as libelle FROM '.DB_PREFIXE.'defunt_archive WHERE defunt_archive.defunt = genealogie_archive.defunt_p1)
            ELSE 
            (SELECT CONCAT_WS(\' \', autorisation_archive.autorisation, autorisation_archive.nom, autorisation_archive.marital, autorisation_archive.prenom, \'contact\') as libelle FROM '.DB_PREFIXE.'autorisation_archive WHERE autorisation_archive.autorisation = genealogie_archive.autorisation_p1)
    END as "'.__("personne_1").'"',

    '(SELECT CONCAT_WS(\' -> \', lien_parente.libelle, lien_parente.lien_inverse) AS "Lien de parenté" FROM '.DB_PREFIXE.'lien_parente WHERE lien_parente.lien_parente = genealogie_archive.lien_parente)',

    // Affichage de la deuxième personne sélectionnée en fonction de defunt_p2 et autorisation_p2
    'CASE WHEN 
        genealogie_archive.defunt_p2 IS NOT NULL 
            THEN 
            (SELECT CONCAT_WS(\' \', defunt_archive.defunt, defunt_archive.nom, defunt_archive.marital, defunt_archive.prenom, \'defunt\') as libelle FROM '.DB_PREFIXE.'defunt_archive WHERE defunt_archive.defunt = genealogie_archive.defunt_p2)
            ELSE 
            (SELECT CONCAT_WS(\' \', autorisation_archive.autorisation, autorisation_archive.nom, autorisation_archive.marital, autorisation_archive.prenom, \'contact\') as libelle FROM '.DB_PREFIXE.'autorisation_archive WHERE autorisation_archive.autorisation = genealogie_archive.autorisation_p2)
    END as "'.__("personne_2").'"',

);