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