<?php
/**
 * Fichier de configuration pour le module recherche (obj/search.class.php)
 *
 * @package opencimetiere
 * @version CVS : $Id: concession.search.inc.php,v 1.8 2010-09-17 14:12:42 salamandre Exp $
 */

///// definitions des types de recherche
// $conf = array(
//    "libelle" => _("Recherche globale"),
//    "champAffiche" => array(), /// liste des champs a afficher
//    "champRecherche" => array(), /// champs de recherche 
//    "table" => "", // tables
//    "serie" => 0, // limit (facultatif - par defaut 100 )
//    "selection" => "", // where
//    "tri" => "", // order by (facultatif)
//    "href" => "" // lien (facultatif)
// );
// array_push( $configTypeRecherche, $conf);

$configTypeRecherche = array();


$conf = array(
    "libelle" => _("Recherche globale"),
    "champAffiche" => "#",
    "champRecherche" => "",
    "table" => "",
    "serie" => 0,
    "selection" => "",
    "tri" => "",
    "href" => ""
);
array_push( $configTypeRecherche, $conf);


$conf = array(
    "libelle" => _("Numero de concession"),
    "champAffiche" => array(    "e.emplacement AS emplacement",
                                "e.famille AS famille",
                                "e.numero AS numero",
                                "v.voielib as voielib",
                                "z.zonelib AS zonelib",
                                "c.cimetierelib AS cimetierelib"),
    "champRecherche" => array("e.numero","e.emplacement"),
    "table" => DB_PREFIXE."emplacement e, ".DB_PREFIXE."voie v, ".DB_PREFIXE."zone z, ".DB_PREFIXE."cimetiere c",
    "serie" => 100,
    "selection" => "WHERE e.voie = v.voie AND v.zone = z.zone AND z.cimetiere = c.cimetiere",
    "tri" => "ORDER BY numero",
    "href" => "../scr/form.php?obj=concession&amp;action=3&amp;idx=£emplacement&amp;idz=£famille"
);
array_push( $configTypeRecherche, $conf);


$conf = array(
    "libelle" => _("Famille de la concession"),
    "champAffiche" => array(    "e.emplacement AS emplacement",
                                "e.famille AS famille",
                                "e.numero AS numero",
                                "v.voielib as voielib",
                                "z.zonelib AS zonelib",
                                "c.cimetierelib AS cimetierelib"),
    "champRecherche" => array("e.famille"),
    "table" => DB_PREFIXE."emplacement e, ".DB_PREFIXE."voie v, ".DB_PREFIXE."zone z, ".DB_PREFIXE."cimetiere c",
    "serie" => 100,
    "selection" => "WHERE e.voie = v.voie AND v.zone = z.zone AND z.cimetiere = c.cimetiere",
    "tri" => "ORDER BY famille",
    "href" => "../scr/form.php?obj=concession&amp;action=3&amp;idx=£emplacement&amp;idz=£famille"
);
array_push( $configTypeRecherche, $conf);


$conf = array(
    "libelle" => _("Nom du defunt"),
    "champAffiche" => array(    "d.titre AS titre",
                                "d.nom AS nom",
                                "d.prenom AS prenom",
                                "e.emplacement AS emplacement",
                                "e.famille AS famille",
                                "e.numero AS numero",
                                "v.voielib AS voielib",
                                "z.zonelib AS zonelib",
                                "c.cimetierelib AS cimetierelib"),
    "champRecherche" => array("d.nom"),
    "table" => DB_PREFIXE."defunt d,".DB_PREFIXE."emplacement e, ".DB_PREFIXE."voie v, ".DB_PREFIXE."zone z, ".DB_PREFIXE."cimetiere c",
    "serie" => 100,
    "selection" => "WHERE e.voie = v.voie AND v.zone = z.zone AND z.cimetiere = c.cimetiere AND d.emplacement = e.emplacement",
    "tri" => "ORDER BY nom",
    "href" => "../scr/form.php?obj=concession&amp;action=3&amp;idx=£emplacement&amp;idz=£famille"
);
array_push( $configTypeRecherche, $conf);


$conf = array(
    "libelle" => _("Date deces du defunt"),
    "champAffiche" => array(    "d.titre AS titre",
                                "d.nom AS nom",
                                "d.prenom AS prenom",
                                "d.datedeces AS dcd",
                                "e.emplacement AS emplacement",
                                "e.famille AS famille",
                                "e.numero AS numero",
                                "v.voielib AS voielib",
                                "z.zonelib AS zonelib",
                                "c.cimetierelib AS cimetierelib"),
    "champRecherche" => array("d.datedeces"),
    "table" => DB_PREFIXE."defunt d,".DB_PREFIXE."emplacement e, ".DB_PREFIXE."voie v, ".DB_PREFIXE."zone z, ".DB_PREFIXE."cimetiere c",
    "serie" => 100,
    "selection" => "WHERE e.voie = v.voie AND v.zone = z.zone AND z.cimetiere = c.cimetiere AND d.emplacement = e.emplacement",
    "tri" => "ORDER BY dcd",
    "modeDate" => "true",
    "href" => "../scr/form.php?obj=concession&amp;action=3&amp;idx=£emplacement&amp;idz=£famille"
);
array_push( $configTypeRecherche, $conf);


$conf = array(
    "libelle" => _("Nom de jeune fille du defunt"),
    "champAffiche" => array(    "d.titre AS titre",
                                "d.nom AS nom",
                                "d.prenom AS prenom",
                                "d.marital AS marital",
                                "e.emplacement AS emplacement",
                                "e.famille AS famille",
                                "e.numero AS numero",
                                "v.voielib AS voielib",
                                "z.zonelib AS zonelib",
                                "c.cimetierelib AS cimetierelib"),
    "champRecherche" => array("marital"),
    "table" => DB_PREFIXE."defunt d,".DB_PREFIXE."emplacement e, ".DB_PREFIXE."voie v, ".DB_PREFIXE."zone z, ".DB_PREFIXE."cimetiere c",
    "serie" => 100,
    "selection" => "WHERE e.voie = v.voie AND v.zone = z.zone AND z.cimetiere = c.cimetiere AND d.emplacement = e.emplacement AND d.marital<>''",
    "tri" => "ORDER BY marital",
    "href" => "../scr/form.php?obj=concession&amp;action=3&amp;idx=£emplacement&amp;idz=£famille"
);
array_push( $configTypeRecherche, $conf);


$conf = array(
    "libelle" => _("Nom du concessionnaire"),
    "champAffiche" => array(    "a.titre AS titre",
                                "a.nom AS nom",
                                "a.prenom AS prenom",
                                "e.emplacement AS emplacement",
                                "e.famille AS famille",
                                "e.numero AS numero",
                                "v.voielib as voielib",
                                "z.zonelib AS zonelib",
                                "c.cimetierelib AS cimetierelib"),
    "champRecherche" => array("nom"),
    "table" => DB_PREFIXE."autorisation a,".DB_PREFIXE."emplacement e, ".DB_PREFIXE."voie v, ".DB_PREFIXE."zone z, ".DB_PREFIXE."cimetiere c",
    "serie" => 100,
    "selection" => "WHERE e.voie = v.voie AND v.zone = z.zone AND z.cimetiere = c.cimetiere AND a.nature='concessionnaire' AND a.emplacement = e.emplacement",
    "tri" => "ORDER BY nom",
    "href" => "../scr/form.php?obj=concession&amp;action=3&amp;idx=£emplacement&amp;idz=£famille"
);
array_push( $configTypeRecherche, $conf);


$conf = array(
    "libelle" => _("Nom de jeune fille du concessionnaire"),
    "champAffiche" => array(    "a.titre AS titre",
                                "a.nom AS nom",
                                "a.prenom AS prenom",
                                "a.marital AS marital",
                                "e.emplacement AS emplacement",
                                "e.famille AS famille",
                                "e.numero AS numero",
                                "v.voielib as voielib",
                                "z.zonelib AS zonelib",
                                "c.cimetierelib AS cimetierelib"),
    "champRecherche" => array("marital"),
    "table" => DB_PREFIXE."autorisation a,".DB_PREFIXE."emplacement e, ".DB_PREFIXE."voie v, ".DB_PREFIXE."zone z, ".DB_PREFIXE."cimetiere c",
    "serie" => 100,
    "selection" => "WHERE e.voie = v.voie AND v.zone = z.zone AND z.cimetiere = c.cimetiere AND a.nature='concessionnaire' AND a.emplacement = e.emplacement AND a.marital<>''",
    "tri" => "ORDER BY marital",
    "href" => "../scr/form.php?obj=concession&amp;action=3&amp;idx=£emplacement&amp;idz=£famille"
);
array_push( $configTypeRecherche, $conf);


$conf = array(
    "libelle" => _("Nom de l'ayant droit"),
    "champAffiche" => array(    "a.titre AS titre",
                                "a.nom AS nom",
                                "a.prenom AS prenom",
                                "e.emplacement AS emplacement",
                                "e.famille AS famille",
                                "e.numero AS numero",
                                "v.voielib as voielib",
                                "z.zonelib AS zonelib",
                                "c.cimetierelib AS cimetierelib"),
    "champRecherche" => array("nom"),
    "table" => DB_PREFIXE."autorisation a,".DB_PREFIXE."emplacement e, ".DB_PREFIXE."voie v, ".DB_PREFIXE."zone z, ".DB_PREFIXE."cimetiere c",
    "serie" => 100,
    "selection" => "WHERE e.voie = v.voie AND v.zone = z.zone AND z.cimetiere = c.cimetiere AND a.nature='ayantdroit' AND a.emplacement = e.emplacement",
    "tri" => "ORDER BY nom",
    "href" => "../scr/form.php?obj=concession&amp;action=3&amp;idx=£emplacement&amp;idz=£famille"
);
array_push( $configTypeRecherche, $conf);


$conf = array(
    "libelle" => _("Nom de jeune fille de l'ayant droit"),
    "champAffiche" => array(    "a.titre AS titre",
                                "a.nom AS nom",
                                "a.prenom AS prenom",
                                "a.marital AS marital",
                                "e.emplacement AS emplacement",
                                "e.famille AS famille",
                                "e.numero AS numero",
                                "v.voielib as voielib",
                                "z.zonelib AS zonelib",
                                "c.cimetierelib AS cimetierelib"),
    "champRecherche" => array("marital"),
    "table" => DB_PREFIXE."autorisation a,".DB_PREFIXE."emplacement e, ".DB_PREFIXE."voie v, ".DB_PREFIXE."zone z, ".DB_PREFIXE."cimetiere c",
    "serie" => 100,
    "selection" => "WHERE e.voie = v.voie AND v.zone = z.zone AND z.cimetiere = c.cimetiere AND a.nature='ayantdroit' AND a.emplacement = e.emplacement AND a.marital<>''",
    "tri" => "ORDER BY marital",
    "href" => "../scr/form.php?obj=concession&amp;action=3&amp;idx=£emplacement&amp;idz=£famille"
);
array_push( $configTypeRecherche, $conf);


////// SELECTION DU CIMETIERE
$conf = array(
    "type" => "select",
    "libelle" => _("cimetiere"),
    "requete" => "select cimetiere, cimetierelib from ".DB_PREFIXE."cimetiere",
    "list" => 1,
    "value" => 0,
    "selection" => "c.cimetiere"
);
array_push( $configTypeRecherche, $conf);


?>