<?php
//$Id$ 
//gen openMairie le 26/09/2012 17:10

$DEBUG=0;
$ico="../img/ico_application.png";
$ent = _("application")." -> "._("dossier");
$tableSelect=DB_PREFIXE."dossier";
$champs=array(
    "dossier",
    "nature",
    "annee",
    "etat",
    "types",
    "objet_dossier",
    "instructeur",
    "date_demande",
    "date_depot",
    "date_complet",
    "date_rejet",
    "date_notification_delai",
    "delai",
    "date_limite",
    "accord_tacite",
    "date_decision",
    "avis",
    "date_validite",
    "date_chantier",
    "date_achevement",
    "date_conformite",
    "demandeur_civilite",
    "demandeur_nom",
    "demandeur_societe",
    "demandeur_adresse",
    "demandeur_adresse_complement",
    "demandeur_cp",
    "demandeur_ville",
    "demandeur_pays",
    "demandeur_telephone",
    "demandeur_email",
    "demandeur_categorie",
    "delegataire",
    "delegataire_civilite",
    "delegataire_nom",
    "delegataire_societe",
    "delegataire_adresse",
    "delegataire_adresse_complement",
    "delegataire_cp",
    "delegataire_ville",
    "delegataire_pays",
    "delegataire_telephone",
    "delegataire_email",
    "terrain_numero",
    "terrain_numero_complement",
    "terrain_adresse",
    "terrain_adresse_complement",
    "terrain_cp",
    "terrain_ville",
    "architecte",
    "terrain_surface",
    "terrain_surface_calcul",
    "rivoli",
    "travaux",
    "travaux_complement",
    "parcelle",
    "pos",
    "sig",
    "batiment_nombre",
    "logement_nombre",
    "shon",
    "shon_calcul",
    "shob",
    "lot",
    "hauteur",
    "piece_nombre",
    "amenagement",
    "parcelle_lot",
    "parcelle_lot_lotissement",
    "description",
    "temp1",
    "temp2",
    "temp3",
    "temp4",
    "temp5",
    "servitude",
    "geom",
    "geom1");
//champs select
$sql_architecte="SELECT architecte.architecte, architecte.nom FROM ".DB_PREFIXE."architecte";
$sql_architecte_by_id = "SELECT architecte.architecte, architecte.nom FROM ".DB_PREFIXE."architecte WHERE architecte = <idx>";
$sql_avis="SELECT avis.avis, avis.libelle FROM ".DB_PREFIXE."avis";
$sql_avis_by_id = "SELECT avis.avis, avis.libelle FROM ".DB_PREFIXE."avis WHERE avis = '<idx>'";
$sql_delegataire_civilite="SELECT civilite.civilite, civilite.civilite FROM ".DB_PREFIXE."civilite";
$sql_delegataire_civilite_by_id = "SELECT civilite.civilite, civilite.civilite FROM ".DB_PREFIXE."civilite WHERE civilite = '<idx>'";
$sql_demandeur_categorie="SELECT categorie_demandeur.categorie_demandeur, categorie_demandeur.libelle FROM ".DB_PREFIXE."categorie_demandeur";
$sql_demandeur_categorie_by_id = "SELECT categorie_demandeur.categorie_demandeur, categorie_demandeur.libelle FROM ".DB_PREFIXE."categorie_demandeur WHERE categorie_demandeur = <idx>";
$sql_demandeur_civilite="SELECT civilite.civilite, civilite.civilite FROM ".DB_PREFIXE."civilite";
$sql_demandeur_civilite_by_id = "SELECT civilite.civilite, civilite.civilite FROM ".DB_PREFIXE."civilite WHERE civilite = '<idx>'";
$sql_etat="SELECT etat.etat, etat.libelle FROM ".DB_PREFIXE."etat";
$sql_etat_by_id = "SELECT etat.etat, etat.libelle FROM ".DB_PREFIXE."etat WHERE etat = '<idx>'";
$sql_instructeur="SELECT om_utilisateur.om_utilisateur, om_utilisateur.nom FROM ".DB_PREFIXE."om_utilisateur";
$sql_instructeur_by_id = "SELECT om_utilisateur.om_utilisateur, om_utilisateur.nom FROM ".DB_PREFIXE."om_utilisateur WHERE om_utilisateur = <idx>";
$sql_nature="SELECT nature.nature, nature.libelle FROM ".DB_PREFIXE."nature";
$sql_nature_by_id = "SELECT nature.nature, nature.libelle FROM ".DB_PREFIXE."nature WHERE nature = '<idx>'";
$sql_parcelle="SELECT parcelle.parcelle, parcelle.debut FROM ".DB_PREFIXE."parcelle";
$sql_parcelle_by_id = "SELECT parcelle.parcelle, parcelle.debut FROM ".DB_PREFIXE."parcelle WHERE parcelle = '<idx>'";
$sql_parcelle_lot="SELECT parcelle_lot.parcelle_lot, parcelle_lot.lotissement FROM ".DB_PREFIXE."parcelle_lot";
$sql_parcelle_lot_by_id = "SELECT parcelle_lot.parcelle_lot, parcelle_lot.lotissement FROM ".DB_PREFIXE."parcelle_lot WHERE parcelle_lot = <idx>";
$sql_pos="SELECT pos.pos, pos.libelle FROM ".DB_PREFIXE."pos";
$sql_pos_by_id = "SELECT pos.pos, pos.libelle FROM ".DB_PREFIXE."pos WHERE pos = '<idx>'";
$sql_rivoli="SELECT rivoli.rivoli, rivoli.libelle FROM ".DB_PREFIXE."rivoli";
$sql_rivoli_by_id = "SELECT rivoli.rivoli, rivoli.libelle FROM ".DB_PREFIXE."rivoli WHERE rivoli = '<idx>'";
$sql_travaux="SELECT travaux.travaux, travaux.libelle FROM ".DB_PREFIXE."travaux";
$sql_travaux_by_id = "SELECT travaux.travaux, travaux.libelle FROM ".DB_PREFIXE."travaux WHERE travaux = <idx>";
?>