<?php
//$Id$ 
//gen openMairie le 10/02/2011 20:39 
include('../gen/sql/pgsql/dossier.inc.php');
$table=DB_PREFIXE."dossier left join ".
       DB_PREFIXE."om_utilisateur on dossier.instructeur = om_utilisateur.om_utilisateur left join ".
       DB_PREFIXE."avis on avis.avis=dossier.avis";
$champAffiche=array(
    'dossier.dossier as "'._("dossier").'"',
    'dossier.demandeur_nom as "'._("demandeur_nom").'"',
    'om_utilisateur.nom as "'._("instructeur").'"',
    'to_char(dossier.date_demande ,\'DD/MM/YYYY\') as "'._("date_demande").'"',
    'to_char(dossier.date_depot ,\'DD/MM/YYYY\') as "'._("date_depot").'"',
    'to_char(dossier.date_complet ,\'DD/MM/YYYY\') as "'._("date_complet").'"',
    'to_char(dossier.date_notification_delai ,\'DD/MM/YYYY\') as "'._("date_notification_delai").'"',
    'to_char(dossier.date_limite ,\'DD/MM/YYYY\') as "'._("date_limite").'"',
    'etat as "'._("etat").'"',
    'avis.libelle as "'._("avis").'"',
);

$tri= "order by dossier.dossier";

$champRecherche=array("dossier","demandeur_nom");

$ico = "../img/ico_dossier.png";

$edition="";

if ($retourformulaire== 'architecte'){
    $tab_actions['corner']['ajouter'] = NULL;
    $tab_actions['left']['consulter'] = NULL;
    $tab_actions['content'] =NULL;
    $selection=" where dossier.architecte ='".$idx."'";
}
if ($retourformulaire== 'travaux'){
    $tab_actions['corner']['ajouter'] = NULL;
    $tab_actions['left']['consulter'] = NULL;
    $tab_actions['content'] =NULL;
    $selection=" where dossier.travaux ='".$idx."'";
}

if (isset($_GET["obj"]) && $_GET["obj"] == "dossier") {
    // Configuration de la recherche avancee
    if (!isset($options)) {
        $options = array();
    }
    // Options pour les select de faux booléens
    $args = array(
        0 => array("", "Oui", "Non", ),
        1 => array(_("choisir")." "._("accord_tacite"), _("Oui"), _("Non"), ),
    );
    //
    $champs['dossier'] = array(
        'table' => 'dossier',
        'colonne' => 'dossier',
        'type' => 'text',
        'taille' => 30,
        'libelle' => _('dossier'));
    //
    $champs['nature'] = array(
        'table' => 'dossier',
        'colonne' => 'nature',
        'type' => 'select',
        'taille' => 30,
        'libelle' => _('nature'));


    //
    $champs['delegataire_nom'] = array(
        'table' => 'dossier',
        'colonne' => 'delegataire_nom',
        'type' => 'text',
        'taille' => 30,
        'libelle' => _('nom delegataire'));
    //
    $champs['demandeur_nom'] = array(
        'table' => 'dossier',
        'colonne' => 'demandeur_nom',
        'type' => 'text',
        'taille' => 30,
        'libelle' => _('nom demandeur'));


    //
    $champs['demandeur_societe'] = array(
        'table' => 'dossier',
        'colonne' => 'demandeur_societe',
        'type' => 'text',
        'taille' => 30,
        'libelle' => _('demandeur_societe'));
    //
    $champs['parcelle'] = array(
        'table' => 'dossier',
        'colonne' => 'parcelle',
        'type' => 'text',
        'taille' => 30,
        'libelle' => _('parcelle'));

    //
    $champs['rivoli'] = array(
        'table' => 'dossier',
        'colonne' => 'rivoli',
        'type' => 'text',
        'taille' => 30,
        'libelle' => _('rivoli'));
    //
    $champs['terrain_adresse'] = array(
        'table' => 'dossier',
        'colonne' => 'terrain_adresse',
        'type' => 'text',
        'taille' => 30,
        'libelle' => _('terrain_adresse'));


    //
    $champs['terrain_adresse_complement'] = array(
        'table' => 'dossier',
        'colonne' => 'terrain_adresse_complement',
        'type' => 'text',
        'taille' => 30,
        'libelle' => _('terrain_adresse_complement'));
    //// COL2

    //
    $champs['etat'] = array(
        'table' => 'dossier',
        'colonne' => 'etat',
        'type' => 'select',
        'libelle' => _('etat'));
    //
    $champs['accord_tacite'] = array(
        'table' => 'dossier',
        'colonne' => 'accord_tacite',
        'type' => 'select',
        "subtype" => "manualselect",
        'libelle' => _('accord_tacite'),
        "args" => $args,
    );

    //
    $champs['travaux'] = array(
        'table' => 'dossier',
        'colonne' => 'travaux',
        'type' => 'select',
        'libelle' => _('travaux'));


    //// COL3


    //
    $champs['instructeur'] = array(
        'table' => 'dossier',
        'colonne' => 'instructeur',
        'type' => 'select',
        'libelle' => _('instructeur'));
    //
    //$champs['architecte'] = array(
    //    'table' => 'dossier',
    //    'colonne' => 'architecte',
    //    'type' => 'select',
    //    'libelle' => _('architecte'));

    //
    $champs['date_depot'] = array(
        'colonne' => 'date_depot',
        'table' => 'dossier',
        'libelle' => _('date_depot'),
        'lib1'=> _("debut"),
        'lib2' => _("fin"),
        'type' => 'date',
        'taille' => 8,
        'where' => 'intervaldate');
    //
    $champs['date_rejet'] = array(
        'colonne' => 'date_rejet',
        'table' => 'dossier',
        'libelle' => _('date_rejet'),
        'lib1'=> _("debut"),
        'lib2' => _("fin"),
        'type' => 'date',
        'taille' => 8,
        'where' => 'intervaldate');

   //
    $champs['date_validite'] = array(
        'colonne' => 'date_validite',
        'table' => 'dossier',
        'libelle' => _('date_validite'),
        'lib1'=> _("debut"),
        'lib2' => _("fin"),
        'type' => 'date',
        'taille' => 8,
        'where' => 'intervaldate');


    //
    $champs['date_complet'] = array(
        'colonne' => 'date_complet',
        'table' => 'dossier',
        'libelle' => _('date_complet'),
        'lib1'=> _("debut"),
        'lib2' => _("fin"),
        'type' => 'date',
        'taille' => 8,
        'where' => 'intervaldate');
    //
    $champs['date_decision'] = array(
        'colonne' => 'date_decision',
        'table' => 'dossier',
        'libelle' => _('date_decision'),
        'lib1'=> _("debut"),
        'lib2' => _("fin"),
        'type' => 'date',
        'taille' => 8,
        'where' => 'intervaldate');
    //
    $champs['date_limite'] = array(
        'colonne' => 'date_limite',
        'table' => 'dossier',
        'libelle' => _('date_limite'),
        'lib1'=> _("debut"),
        'lib2' => _("fin"),
        'type' => 'date',
        'taille' => 8,
        'where' => 'intervaldate');


    //
    $champs['date_chantier'] = array(
        'colonne' => 'date_chantier',
        'table' => 'dossier',
        'libelle' => _('date_chantier'),
        'lib1'=> _("debut"),
        'lib2' => _("fin"),
        'type' => 'date',
        'taille' => 8,
        'where' => 'intervaldate');
    //
    $champs['date_achevement'] = array(
        'colonne' => 'date_achevement',
        'table' => 'dossier',
        'libelle' => _('date_achevement'),
        'lib1'=> _("debut"),
        'lib2' => _("fin"),
        'type' => 'date',
        'taille' => 8,
        'where' => 'intervaldate');
    //
    $champs['date_conformite'] = array(
        'colonne' => 'date_conformite',
        'table' => 'dossier',
        'libelle' => _('date_conformite'),
        'lib1'=> _("debut"),
        'lib2' => _("fin"),
        'type' => 'date',
        'taille' => 8,
        'where' => 'intervaldate');
    //
    $options[] = array(
        'type' => 'search',
        'display' => true,
        'advanced'  => $champs,
        'default_form'  => 'advanced',
        'absolute_object' => 'dossier');
}


$sousformulaire=array("instruction",
                      "consultation",
                      "terrain",
                      "blocnote",
                      "destination_shon",
                      "statistique");
?>