/[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 1031 - (show annotations)
Mon Dec 10 09:22:13 2012 UTC (12 years, 1 month ago) by nhaye
File size: 2513 byte(s)
Correction d'un bug,
amélioration de l'affichage du nom des demandeurs

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 'id' => '',
16 'lib' => '<span class="om-icon om-icon-16 om-icon-fix add-16" title="'._('Ajouter une demande').'">'._('Ajouter une demande').'</span>',
17 'ordre' => 20,);
18
19 // Action du contenu : transferer
20 $tab_actions['content'] = $tab_actions['left']['consulter'];
21
22 // Recherche avancee
23 $champs = array();
24
25 $champs['dossier'] = array(
26 'table' => 'dossier',
27 'colonne' => 'dossier',
28 'type' => 'text',
29 'libelle' => _('dossier_instruction'));
30
31 $champs['particulier_nom'] =
32 array('colonne' => 'particulier_nom',
33 'table' => 'demandeur',
34 'libelle' => _('petitionnaire'),
35 'type' => 'text'
36 );
37 $champs['adresse'] = array(
38 'table' => 'dossier',
39 'colonne' => 'TRIM(CONCAT(dossier_autorisation.terrain_adresse_voie_numero,\' \',
40 dossier_autorisation.complement,\' \',
41 dossier_autorisation.terrain_adresse_lieu_dit,\' \',
42 dossier_autorisation.terrain_adresse_code_postal,\' \',
43 dossier_autorisation.terrain_adresse_localite,\' \',
44 dossier_autorisation.terrain_adresse_bp,\' \',
45 dossier_autorisation.terrain_adresse_cedex
46 ))',
47 'type' => 'text',
48 'libelle' => _('terrain'));
49
50 $champs['arrondissement'] =
51 array('colonne' => 'arrondissement',
52 'table' => 'dossier_autorisation',
53 'libelle' => _('arrondissement'),
54 'type' => 'select'
55 );
56
57 $champs['dossier_autorisation_type_detaille'] = array(
58 'table' => 'dossier_autorisation',
59 'colonne' => 'dossier_autorisation_type_detaille',
60 'type' => 'select',
61 'libelle' => _('nature du dossier'));
62
63 $champs['depot_initial'] =
64 array('colonne' => 'depot_initial',
65 'table' => 'dossier',
66 'libelle' => _('depot_initial'),
67 'type' => 'date',
68 'where' => 'intervaldate');
69
70 $champs['etat'] = array(
71 'table' => 'dossier',
72 'colonne' => 'etat',
73 'type' => 'select',
74 'libelle' => _('etat du dossier'));
75
76 $options[] = array('type' => 'search',
77 'display' => true,
78 'advanced' => $champs,
79 'absolute_object' => 'dossier',
80 'export' => array("csv"));
81
82 ?>

[email protected]
ViewVC Help
Powered by ViewVC 1.1.26