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