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."instructeur
    ON dossier.instructeur = instructeur.instructeur
LEFT JOIN ".DB_PREFIXE."om_utilisateur
    ON instructeur.om_utilisateur = om_utilisateur.om_utilisateur
LEFT JOIN ".DB_PREFIXE."avis_decision
    ON avis_decision.avis_decision=dossier.avis_decision
LEFT JOIN ".DB_PREFIXE."division
    ON dossier.division=division.division";

$champAffiche=array(
    'dossier.dossier as "'._("dossier").'"',
    'dossier.demandeur_nom as "'._("demandeur_nom").'"',
    'instructeur.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_decision.libelle as "'._("avis_decision").'"',
    'CASE WHEN dossier.enjeu_erp is TRUE THEN \'<span class="om-icon om-icon-16 om-icon-fix enjeu_erp-16" title="'._('Enjeu ERP').'">ERP</span>\' ELSE \'\' END ||
     CASE WHEN dossier.enjeu_urba is TRUE THEN \'<span class="om-icon om-icon-16 om-icon-fix enjeu_urba-16" title="'._('Enjeu Urba').'">URBA</span>\' ELSE \'\' END
     as "'._("enjeu").'"',
);

$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_instruction") {
    // 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",
                      "dossier_message");
?>
1	fraynaud	3	<?php
2			//$Id$
3			//gen openMairie le 10/02/2011 20:39
4			include('../gen/sql/pgsql/dossier.inc.php');
5	fmichon	686	$table = DB_PREFIXE."dossier
6			LEFT JOIN ".DB_PREFIXE."instructeur
7			ON dossier.instructeur = instructeur.instructeur
8			LEFT JOIN ".DB_PREFIXE."om_utilisateur
9			ON instructeur.om_utilisateur = om_utilisateur.om_utilisateur
10			LEFT JOIN ".DB_PREFIXE."avis_decision
11			ON avis_decision.avis_decision=dossier.avis_decision
12	fmichon	681	LEFT JOIN ".DB_PREFIXE."division
13	fmichon	686	ON dossier.division=division.division";
14	fmichon	681
15	nhaye	471	$champAffiche=array(
16			'dossier.dossier as "'._("dossier").'"',
17			'dossier.demandeur_nom as "'._("demandeur_nom").'"',
18	nhaye	602	'instructeur.nom as "'._("instructeur").'"',
19	nhaye	471	'to_char(dossier.date_demande ,\'DD/MM/YYYY\') as "'._("date_demande").'"',
20			'to_char(dossier.date_depot ,\'DD/MM/YYYY\') as "'._("date_depot").'"',
21			'to_char(dossier.date_complet ,\'DD/MM/YYYY\') as "'._("date_complet").'"',
22			'to_char(dossier.date_notification_delai ,\'DD/MM/YYYY\') as "'._("date_notification_delai").'"',
23			'to_char(dossier.date_limite ,\'DD/MM/YYYY\') as "'._("date_limite").'"',
24			'etat as "'._("etat").'"',
25	vpihour	489	'avis_decision.libelle as "'._("avis_decision").'"',
26	nhaye	650	'CASE WHEN dossier.enjeu_erp is TRUE THEN \'<span class="om-icon om-icon-16 om-icon-fix enjeu_erp-16" title="'._('Enjeu ERP').'">ERP</span>\' ELSE \'\' END \|\|
27			CASE WHEN dossier.enjeu_urba is TRUE THEN \'<span class="om-icon om-icon-16 om-icon-fix enjeu_urba-16" title="'._('Enjeu Urba').'">URBA</span>\' ELSE \'\' END
28	nhaye	625	as "'._("enjeu").'"',
29	nhaye	471	);
30	nhaye	467
31			$tri= "order by dossier.dossier";
32
33			$champRecherche=array("dossier","demandeur_nom");
34
35			$ico = "../img/ico_dossier.png";
36
37			$edition="";
38
39	fraynaud	38	if ($retourformulaire== 'architecte'){
40	nhaye	467	$tab_actions['corner']['ajouter'] = NULL;
41			$tab_actions['left']['consulter'] = NULL;
42			$tab_actions['content'] =NULL;
43	fraynaud	38	$selection=" where dossier.architecte ='".$idx."'";
44			}
45			if ($retourformulaire== 'travaux'){
46	nhaye	467	$tab_actions['corner']['ajouter'] = NULL;
47			$tab_actions['left']['consulter'] = NULL;
48			$tab_actions['content'] =NULL;
49	fraynaud	38	$selection=" where dossier.travaux ='".$idx."'";
50			}
51	fmichon	476
52	fmichon	647	if (isset($_GET["obj"]) && $_GET["obj"] == "dossier_instruction") {
53	fmichon	476	// Configuration de la recherche avancee
54			if (!isset($options)) {
55			$options = array();
56			}
57			// Options pour les select de faux booléens
58			$args = array(
59			0 => array("", "Oui", "Non", ),
60			1 => array(_("choisir")." "._("accord_tacite"), _("Oui"), _("Non"), ),
61			);
62			//
63			$champs['dossier'] = array(
64			'table' => 'dossier',
65			'colonne' => 'dossier',
66			'type' => 'text',
67			'taille' => 30,
68			'libelle' => _('dossier'));
69			//
70			$champs['nature'] = array(
71			'table' => 'dossier',
72			'colonne' => 'nature',
73			'type' => 'select',
74			'taille' => 30,
75			'libelle' => _('nature'));
76
77
78
79			//
80			$champs['delegataire_nom'] = array(
81			'table' => 'dossier',
82			'colonne' => 'delegataire_nom',
83			'type' => 'text',
84			'taille' => 30,
85			'libelle' => _('nom delegataire'));
86			//
87			$champs['demandeur_nom'] = array(
88			'table' => 'dossier',
89			'colonne' => 'demandeur_nom',
90			'type' => 'text',
91			'taille' => 30,
92			'libelle' => _('nom demandeur'));
93
94
95			//
96			$champs['demandeur_societe'] = array(
97			'table' => 'dossier',
98			'colonne' => 'demandeur_societe',
99			'type' => 'text',
100			'taille' => 30,
101			'libelle' => _('demandeur_societe'));
102			//
103			$champs['parcelle'] = array(
104			'table' => 'dossier',
105			'colonne' => 'parcelle',
106			'type' => 'text',
107			'taille' => 30,
108			'libelle' => _('parcelle'));
109
110			//
111			$champs['rivoli'] = array(
112			'table' => 'dossier',
113			'colonne' => 'rivoli',
114			'type' => 'text',
115			'taille' => 30,
116			'libelle' => _('rivoli'));
117			//
118			$champs['terrain_adresse'] = array(
119			'table' => 'dossier',
120			'colonne' => 'terrain_adresse',
121			'type' => 'text',
122			'taille' => 30,
123			'libelle' => _('terrain_adresse'));
124
125
126
127
128			//
129			$champs['terrain_adresse_complement'] = array(
130			'table' => 'dossier',
131			'colonne' => 'terrain_adresse_complement',
132			'type' => 'text',
133			'taille' => 30,
134			'libelle' => _('terrain_adresse_complement'));
135			//// COL2
136
137			//
138			$champs['etat'] = array(
139			'table' => 'dossier',
140			'colonne' => 'etat',
141			'type' => 'select',
142			'libelle' => _('etat'));
143			//
144			$champs['accord_tacite'] = array(
145			'table' => 'dossier',
146			'colonne' => 'accord_tacite',
147			'type' => 'select',
148			"subtype" => "manualselect",
149			'libelle' => _('accord_tacite'),
150			"args" => $args,
151			);
152
153			//
154			$champs['travaux'] = array(
155			'table' => 'dossier',
156			'colonne' => 'travaux',
157			'type' => 'select',
158			'libelle' => _('travaux'));
159
160
161			//// COL3
162
163
164
165
166			//
167			$champs['instructeur'] = array(
168			'table' => 'dossier',
169			'colonne' => 'instructeur',
170			'type' => 'select',
171			'libelle' => _('instructeur'));
172			//
173			//$champs['architecte'] = array(
174			// 'table' => 'dossier',
175			// 'colonne' => 'architecte',
176			// 'type' => 'select',
177			// 'libelle' => _('architecte'));
178
179			//
180			$champs['date_depot'] = array(
181			'colonne' => 'date_depot',
182			'table' => 'dossier',
183			'libelle' => _('date_depot'),
184			'lib1'=> _("debut"),
185			'lib2' => _("fin"),
186			'type' => 'date',
187			'taille' => 8,
188			'where' => 'intervaldate');
189			//
190			$champs['date_rejet'] = array(
191			'colonne' => 'date_rejet',
192			'table' => 'dossier',
193			'libelle' => _('date_rejet'),
194			'lib1'=> _("debut"),
195			'lib2' => _("fin"),
196			'type' => 'date',
197			'taille' => 8,
198			'where' => 'intervaldate');
199
200			//
201			$champs['date_validite'] = array(
202			'colonne' => 'date_validite',
203			'table' => 'dossier',
204			'libelle' => _('date_validite'),
205			'lib1'=> _("debut"),
206			'lib2' => _("fin"),
207			'type' => 'date',
208			'taille' => 8,
209			'where' => 'intervaldate');
210
211
212
213			//
214			$champs['date_complet'] = array(
215			'colonne' => 'date_complet',
216			'table' => 'dossier',
217			'libelle' => _('date_complet'),
218			'lib1'=> _("debut"),
219			'lib2' => _("fin"),
220			'type' => 'date',
221			'taille' => 8,
222			'where' => 'intervaldate');
223			//
224			$champs['date_decision'] = array(
225			'colonne' => 'date_decision',
226			'table' => 'dossier',
227			'libelle' => _('date_decision'),
228			'lib1'=> _("debut"),
229			'lib2' => _("fin"),
230			'type' => 'date',
231			'taille' => 8,
232			'where' => 'intervaldate');
233			//
234			$champs['date_limite'] = array(
235			'colonne' => 'date_limite',
236			'table' => 'dossier',
237			'libelle' => _('date_limite'),
238			'lib1'=> _("debut"),
239			'lib2' => _("fin"),
240			'type' => 'date',
241			'taille' => 8,
242			'where' => 'intervaldate');
243
244
245
246
247			//
248			$champs['date_chantier'] = array(
249			'colonne' => 'date_chantier',
250			'table' => 'dossier',
251			'libelle' => _('date_chantier'),
252			'lib1'=> _("debut"),
253			'lib2' => _("fin"),
254			'type' => 'date',
255			'taille' => 8,
256			'where' => 'intervaldate');
257			//
258			$champs['date_achevement'] = array(
259			'colonne' => 'date_achevement',
260			'table' => 'dossier',
261			'libelle' => _('date_achevement'),
262			'lib1'=> _("debut"),
263			'lib2' => _("fin"),
264			'type' => 'date',
265			'taille' => 8,
266			'where' => 'intervaldate');
267			//
268			$champs['date_conformite'] = array(
269			'colonne' => 'date_conformite',
270			'table' => 'dossier',
271			'libelle' => _('date_conformite'),
272			'lib1'=> _("debut"),
273			'lib2' => _("fin"),
274			'type' => 'date',
275			'taille' => 8,
276			'where' => 'intervaldate');
277			//
278			$options[] = array(
279			'type' => 'search',
280			'display' => true,
281			'advanced' => $champs,
282			'default_form' => 'advanced',
283			'absolute_object' => 'dossier');
284			}
285
286
287	nhaye	467	$sousformulaire=array("instruction",
288			"consultation",
289			"terrain",
290			"blocnote",
291			"destination_shon",
292	mlimic	586	"statistique",
293	mlimic	712	"dossier_message");
294	fmichon	476	?>