<?php
/**
 *
 *
 * @package openfoncier
 * @version SVN : $Id: blocnote.inc.php 4418 2015-02-24 17:30:28Z tbenita $
 */

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

//
$ent = " -> "._("blocnote");
if (isset($idx) && $idx != ']' && trim($idx) != '') {
    $ent .= "->&nbsp;".$idx."&nbsp;";
}
if (isset($idz) && trim($idz) != '') {
    $ent .= "&nbsp;".mb_strtoupper($idz, "UTF-8")."&nbsp;";
}

// SELECT 
$champAffiche = array(
    'blocnote.blocnote as "'._("id").'"',
    'blocnote.categorie as "'._("categorie").'"',
    'blocnote.note as "'._("note").'"',
    );
//
$champRecherche = array(
    'blocnote.blocnote as "'._("id").'"',
    'blocnote.categorie as "'._("categorie").'"',
    'dossier.annee as "'._("dossier").'"',
    );

if(isset($idx))
  $selection=" where blocnote.dossier ='".$idx."'";
else
  $selection="";
$tri= " order by blocnote";

/**
 * Gestion particulière de l'affichage du listing dans le contexte d'un dossier
 * d'instruction
 */
include "../sql/pgsql/dossier_instruction_droit_specifique_par_division.inc.php";

?>