sql/pgsql/consultation.inc.php

<?php
//$Id$ 
//gen openMairie le 10/02/2011 20:32 
include('../gen/sql/pgsql/consultation.inc.php');

if(isset($idx))
  $selection=" where consultation.dossier ='".$idx."'";
else
  $selection="";

if ($retourformulaire== 'service'){
    // Actions en coin : ajouter
    $tab_actions['corner']['ajouter'] = NULL;
    // Actions a gauche : consulter
    $tab_actions['left']['consulter'] = NULL;
    $selection=" where consultation.service ='".$idx."'";
}

$champs = array();

$champs['dossier'] = array(
    'table' => 'consultation',
    'colonne' => 'dossier',
    'type' => 'text',
    'libelle' => _('Dossier'));

$champs['service'] = array(
    'table' => 'consultation',
    'colonne' => 'service',
    'type' => 'select',
    'libelle' => _('Service'));

$champs['date_envoi'] =
    array('colonne' => 'date_envoi',
          'table' => 'consultation',
          'libelle' => _('Date d\'envoi'),
          'type' => 'date',
          'where' => 'intervaldate');
    
$champs['date_limite'] =
    array('colonne' => 'date_limite',
          'table' => 'consultation',
          'libelle' => _('Date limite'),
          'type' => 'date',
          'where' => 'intervaldate');


 $options[] =  array('type' => 'search',
                     'display' => true,
                     'advanced' => $champs,
                     'default_form' => 'advanced',
                     'absolute_object' => 'consultation');
?>
1	<?php
2	//$Id$
3	//gen openMairie le 10/02/2011 20:32
4	include('../gen/sql/pgsql/consultation.inc.php');
5
6	if(isset($idx))
7	$selection=" where consultation.dossier ='".$idx."'";
8	else
9	$selection="";
10
11	if ($retourformulaire== 'service'){
12	// Actions en coin : ajouter
13	$tab_actions['corner']['ajouter'] = NULL;
14	// Actions a gauche : consulter
15	$tab_actions['left']['consulter'] = NULL;
16	$selection=" where consultation.service ='".$idx."'";
17	}
18
19	$champs = array();
20
21	$champs['dossier'] = array(
22	'table' => 'consultation',
23	'colonne' => 'dossier',
24	'type' => 'text',
25	'libelle' => _('Dossier'));
26
27	$champs['service'] = array(
28	'table' => 'consultation',
29	'colonne' => 'service',
30	'type' => 'select',
31	'libelle' => _('Service'));
32
33	$champs['date_envoi'] =
34	array('colonne' => 'date_envoi',
35	'table' => 'consultation',
36	'libelle' => _('Date d\'envoi'),
37	'type' => 'date',
38	'where' => 'intervaldate');
39
40	$champs['date_limite'] =
41	array('colonne' => 'date_limite',
42	'table' => 'consultation',
43	'libelle' => _('Date limite'),
44	'type' => 'date',
45	'where' => 'intervaldate');
46
47
48	$options[] = array('type' => 'search',
49	'display' => true,
50	'advanced' => $champs,
51	'default_form' => 'advanced',
52	'absolute_object' => 'consultation');
53	?>