".__($obj);
if (!isset($premier))
$premier="";
if (!isset($advs_id))
$advs_id="";
if (!isset($tricol))
$tricol="";
if (!isset($valide))
$valide="";
$edition = "";
//
$table = DB_PREFIXE."emplacement
LEFT JOIN ".DB_PREFIXE."voie
ON emplacement.voie=voie.voie
LEFT JOIN ".DB_PREFIXE."voie_type
ON voie.voietype=voie_type.voie_type
LEFT JOIN ".DB_PREFIXE."zone
ON voie.zone=zone.zone
LEFT JOIN ".DB_PREFIXE."zone_type
ON zone.zonetype=zone_type.zone_type
LEFT JOIN ".DB_PREFIXE."cimetiere
ON zone.cimetiere=cimetiere.cimetiere
";
//
$champAffiche=array(
'emplacement as "'.__("id").'"',
'famille as "'.__("famille").'"',
"numero::text||' '||COALESCE(complement, '') as \"".__("numero")."\"",
"(voie_type.libelle||' '||voielib) as \"".__("voie")."\"",
"(zone_type.libelle||' '||zonelib) as \"".__("zone")."\"",
'cimetierelib as "'.__("cimetierelib").'"',
'libre as "'.__("libre").'"'
);
//
$champRecherche=array(
'emplacement as "'.__("id").'"',
//"(cast(numero as text)||' '||COALESCE(complement, '') ) as \"".__("numero")."\"",
"(voie_type.libelle||' '||voielib) as \"".__("voie")."\"",
"(zone_type.libelle||' '||zonelib) as \"".__("zone")."\"",
'cimetierelib as "'.__("cimetierelib").'"',
'nature as "'.__("nature").'"',
'numerocadastre as "'.__("numerocadastre").'"',
'famille as "'.__("famille").'"',
'numeroacte as "'.__("numeroacte").'"',
'terme as "'.__("terme").'"',
'sepulturetype as "'.__("sepulturetype").'"',
'typeconcession as "'.__("typeconcession").'"',
'videsanitaire as "'.__("videsanitaire").'"',
'semelle as "'.__("semelle").'"',
'etatsemelle as "'.__("etatsemelle").'"',
'monument as "'.__("monument").'"',
'etatmonument as "'.__("etatmonument").'"',
'abandon as "'.__("abandon").'"'
);
//
$selection = " where emplacement.nature='".$obj."' ";
//
$tri = " order by famille ";
//
$sousformulaire = array();
// EDITION
$tab_actions['left']['etat-emplacement'] = array(
'lien' => OM_ROUTE_FORM."&obj=".$obj."&action=101&idx=",
'id' => '',
'target' => "_blank",
'lib' => ''.__('récapitulatif').'',
'ordre' => 110,
);
// LOCALISATION
$tab_actions['left']['localiser-sig-interne'] = array(
'lien' => OM_ROUTE_MAP."&mode=tab_sig&idx=",
'id' => '&obj='.$obj.'&premier='.$premier.'&advs_id='.$advs_id.'&tricol='.$tricol.'&valide='.$valide.'&retour=tab',
'lib' => ''.__('SIG').'',
'ordre' => 150,
'parameters' => array("option_localisation" => "sig_interne", ),
);
$tab_actions['left']['localiser-sig-externe'] = array(
'lien' => "../app/localisation_sig_externe.php?idx=",
'lib' => ''.__('SIG').'',
'ordre' => 150,
'parameters' => array("option_localisation" => "sig_externe", ),
);
$tab_actions['left']['localiser-plan'] = array(
'lien' => "../app/localisation_plan_view.php?idx=",
'id' => '&obj='.$obj.'&premier='.$premier.'&advs_id='.$advs_id.'&tricol='.$tricol.'&valide='.$valide.'&retour=tab#camap0',
'lib' => ''.__('Plan').'',
'ordre' => 150,
'parameters' => array("option_localisation" => "plan", ),
);