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

Diff of /trunk/sql/pgsql/PA_accueil.inc.php

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 312 by atreal, Wed Mar 28 17:19:49 2012 UTC revision 427 by nhaye, Mon Sep 24 13:32:10 2012 UTC
# Line 15  else Line 15  else
15      $ent= "dossier -> PA accueil";      $ent= "dossier -> PA accueil";
16  $ico = "../img/ico_dossier.png";  $ico = "../img/ico_dossier.png";
17  $edition="";  $edition="";
18    $table=DB_PREFIXE."dossier left join ".
19           DB_PREFIXE."om_utilisateur on dossier.instructeur = om_utilisateur.om_utilisateur left join ".
20           DB_PREFIXE."avis on avis.avis=dossier.avis";
21  $champAffiche=array("dossier",  $champAffiche=array("dossier",
22                      "demandeur_nom",                      "demandeur_nom",
23                      "to_char(date_demande,'DD/MM/YYYY')  as date_demande",                      "to_char(date_demande,'DD/MM/YYYY')  as date_demande",
# Line 23  $champAffiche=array("dossier", Line 26  $champAffiche=array("dossier",
26                      );                      );
27  $champRecherche=array("dossier","demandeur_nom");  $champRecherche=array("dossier","demandeur_nom");
28  $selection=" where nature = 'PA' and (etat ='initialiser' or etat='notifier')";  $selection=" where nature = 'PA' and (etat ='initialiser' or etat='notifier')";
29    $tri="ORDER BY dossier ASC";
30    
31  $sousformulaire=array("instruction");  $sousformulaire=array("instruction");
32  ?>  ?>
Legend:
Removed from v.312  
changed lines
  Added in v.427
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26