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",
                    "demandeur_nom as nom",
                    "om_utilisateur.nom as instructeur",
                    "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"
                    );

$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."'";
}
$sousformulaire=array("instruction",
                      "consultation",
                      "terrain",
                      "blocnote",
                      "destination_shon",
                      "statistique");
?>
1	fraynaud	3	<?php
2			//$Id$
3			//gen openMairie le 10/02/2011 20:39
4			include('../gen/sql/pgsql/dossier.inc.php');
5	fraynaud	38	$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	nhaye	467	"demandeur_nom as nom",
10	fraynaud	38	"om_utilisateur.nom as instructeur",
11	fraynaud	78	"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	fraynaud	38	"etat","avis.libelle as avis"
17			);
18	nhaye	467
19			$tri= "order by dossier.dossier";
20
21			$champRecherche=array("dossier","demandeur_nom");
22
23			$ico = "../img/ico_dossier.png";
24
25			$edition="";
26
27	fraynaud	38	if ($retourformulaire== 'architecte'){
28	nhaye	467	$tab_actions['corner']['ajouter'] = NULL;
29			$tab_actions['left']['consulter'] = NULL;
30			$tab_actions['content'] =NULL;
31	fraynaud	38	$selection=" where dossier.architecte ='".$idx."'";
32			}
33			if ($retourformulaire== 'travaux'){
34	nhaye	467	$tab_actions['corner']['ajouter'] = NULL;
35			$tab_actions['left']['consulter'] = NULL;
36			$tab_actions['content'] =NULL;
37	fraynaud	38	$selection=" where dossier.travaux ='".$idx."'";
38			}
39	nhaye	467	$sousformulaire=array("instruction",
40			"consultation",
41			"terrain",
42			"blocnote",
43			"destination_shon",
44			"statistique");
45	fraynaud	3	?>