/[openfoncier]/trunk/sql/pgsql/recherche_dossier.inc.php
ViewVC logotype

Contents of /trunk/sql/pgsql/recherche_dossier.inc.php

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1028 - (show annotations)
Fri Dec 7 17:55:23 2012 UTC (12 years, 1 month ago) by nhaye
File size: 2491 byte(s)
Modification des liens du tableau

1 <?php
2 /**
3 * @package openfoncier
4 * @version SVN : $id$
5 **/
6
7 //
8 include('../sql/pgsql/dossier_instruction.inc.php');
9
10
11 $tab_actions['corner']['ajouter'] = NULL;
12 // Actions a gauche : consulter
13 $tab_actions['left']['consulter'] =
14 array('lien' => '../scr/form.php?obj=demande&amp;idx_dossier=',
15 'lib' => '<span class="om-icon om-icon-16 om-icon-fix add-16" title="'._('Ajouter une demande').'">'._('Ajouter une demande').'</span>',
16 'ordre' => 20,);
17
18 // Action du contenu : transferer
19 $tab_actions['content'] = $tab_actions['left']['consulter'];
20
21 // Recherche avancee
22 $champs = array();
23
24 $champs['dossier'] = array(
25 'table' => 'dossier',
26 'colonne' => 'dossier',
27 'type' => 'text',
28 'libelle' => _('dossier_instruction'));
29
30 $champs['particulier_nom'] =
31 array('colonne' => 'particulier_nom',
32 'table' => 'demandeur',
33 'libelle' => _('petitionnaire'),
34 'type' => 'text'
35 );
36 $champs['adresse'] = array(
37 'table' => 'dossier',
38 'colonne' => 'TRIM(CONCAT(dossier_autorisation.terrain_adresse_voie_numero,\' \',
39 dossier_autorisation.complement,\' \',
40 dossier_autorisation.terrain_adresse_lieu_dit,\' \',
41 dossier_autorisation.terrain_adresse_code_postal,\' \',
42 dossier_autorisation.terrain_adresse_localite,\' \',
43 dossier_autorisation.terrain_adresse_bp,\' \',
44 dossier_autorisation.terrain_adresse_cedex
45 ))',
46 'type' => 'text',
47 'libelle' => _('terrain'));
48
49 $champs['arrondissement'] =
50 array('colonne' => 'arrondissement',
51 'table' => 'dossier_autorisation',
52 'libelle' => _('arrondissement'),
53 'type' => 'select'
54 );
55
56 $champs['dossier_autorisation_type_detaille'] = array(
57 'table' => 'dossier_autorisation',
58 'colonne' => 'dossier_autorisation_type_detaille',
59 'type' => 'select',
60 'libelle' => _('nature du dossier'));
61
62 $champs['depot_initial'] =
63 array('colonne' => 'depot_initial',
64 'table' => 'dossier',
65 'libelle' => _('depot_initial'),
66 'type' => 'date',
67 'where' => 'intervaldate');
68
69 $champs['etat'] = array(
70 'table' => 'dossier',
71 'colonne' => 'etat',
72 'type' => 'select',
73 'libelle' => _('etat du dossier'));
74
75 $options[] = array('type' => 'search',
76 'display' => true,
77 'advanced' => $champs,
78 'absolute_object' => 'dossier',
79 'export' => array("csv"));
80
81 ?>

[email protected]
ViewVC Help
Powered by ViewVC 1.1.26