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

$DEBUG=0;
$ico="../img/ico_application.png";
$ent = _("application")." -> "._("instruction");
$tableSelect=DB_PREFIXE."instruction";
$champs=array(
    "instruction",
    "destinataire",
    "datecourrier",
    "evenement",
    "lettretype",
    "complement",
    "complement2",
    "dossier",
    "action",
    "delai",
    "etat",
    "accord_tacite",
    "delai_notification",
    "avis",
    "archive_delai",
    "archive_date_complet",
    "archive_date_rejet",
    "archive_date_limite",
    "archive_date_notification_delai",
    "archive_accord_tacite",
    "archive_etat",
    "archive_date_decision",
    "archive_avis",
    "archive_date_validite",
    "archive_date_achevement",
    "archive_date_chantier",
    "archive_date_conformite",
    "complement3",
    "complement4",
    "complement5",
    "complement6",
    "complement7",
    "complement8",
    "complement9",
    "complement10",
    "complement11",
    "complement12",
    "complement13",
    "complement14",
    "complement15");
//champs select
$sql_action="SELECT action.action, action.libelle FROM ".DB_PREFIXE."action";
$sql_action_by_id = "SELECT action.action, action.libelle FROM ".DB_PREFIXE."action WHERE action = '<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_dossier="SELECT dossier.dossier, dossier.nature FROM ".DB_PREFIXE."dossier";
$sql_dossier_by_id = "SELECT dossier.dossier, dossier.nature FROM ".DB_PREFIXE."dossier WHERE dossier = '<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_evenement="SELECT evenement.evenement, evenement.libelle FROM ".DB_PREFIXE."evenement";
$sql_evenement_by_id = "SELECT evenement.evenement, evenement.libelle FROM ".DB_PREFIXE."evenement WHERE evenement = <idx>";
?>