sql/pgsql/dossier.inc.php

<?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",
                    "om_utilisateur.nom as instructeur",
                    "demandeur_nom",
                    "to_char(date_demande,'DD/MM/YYYY')  as demande",
                    "to_char(date_depot,'DD/MM/YYYY') as depot",
                    "to_char(date_complet,'DD/MM/YYYY') as  complet",
                    "to_char(date_notification_delai,'DD/MM/YYYY') as delai",
                    "to_char(date_limite,'DD/MM/YYYY') as limite",
                    "etat","avis.libelle as avis"
                    );
if ($retourformulaire== 'architecte'){
    $href[0] = array("lien" => "#", "id" => "", "lib" => "", );
    $href[1] = array("lien" => "", "id" => "", "lib" => "", );
    $href[2] = array("lien" => "#", "id" => "", "lib" => "", );
    $selection=" where dossier.architecte ='".$idx."'";
}
if ($retourformulaire== 'travaux'){
    $href[0] = array("lien" => "#", "id" => "", "lib" => "", );
    $href[1] = array("lien" => "", "id" => "", "lib" => "", );
    $href[2] = array("lien" => "#", "id" => "", "lib" => "", );
    $selection=" where dossier.travaux ='".$idx."'";
}
?>
1	<?php
2	//$Id$
3	//gen openMairie le 10/02/2011 20:39
4	include('../gen/sql/pgsql/dossier.inc.php');
5	$table=DB_PREFIXE."dossier left join ".
6	DB_PREFIXE."om_utilisateur on dossier.instructeur = om_utilisateur.om_utilisateur left join ".
7	DB_PREFIXE."avis on avis.avis=dossier.avis";
8	$champAffiche=array("dossier",
9	"om_utilisateur.nom as instructeur",
10	"demandeur_nom",
11	"to_char(date_demande,'DD/MM/YYYY') as demande",
12	"to_char(date_depot,'DD/MM/YYYY') as depot",
13	"to_char(date_complet,'DD/MM/YYYY') as complet",
14	"to_char(date_notification_delai,'DD/MM/YYYY') as delai",
15	"to_char(date_limite,'DD/MM/YYYY') as limite",
16	"etat","avis.libelle as avis"
17	);
18	if ($retourformulaire== 'architecte'){
19	$href[0] = array("lien" => "#", "id" => "", "lib" => "", );
20	$href[1] = array("lien" => "", "id" => "", "lib" => "", );
21	$href[2] = array("lien" => "#", "id" => "", "lib" => "", );
22	$selection=" where dossier.architecte ='".$idx."'";
23	}
24	if ($retourformulaire== 'travaux'){
25	$href[0] = array("lien" => "#", "id" => "", "lib" => "", );
26	$href[1] = array("lien" => "", "id" => "", "lib" => "", );
27	$href[2] = array("lien" => "#", "id" => "", "lib" => "", );
28	$selection=" where dossier.travaux ='".$idx."'";
29	}
30	?>