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

Diff of /trunk/sql/pgsql/demande.form.inc.php

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

revision 1084 by vpihour, Mon Dec 17 17:14:59 2012 UTC revision 1333 by nhaye, Thu Mar 7 11:20:12 2013 UTC
# Line 59  $portlet_actions['pdfetat'] = Line 59  $portlet_actions['pdfetat'] =
59            'ordre' => 30,            'ordre' => 30,
60            'target'=>'_blank',            'target'=>'_blank',
61            'ajax' => false);            'ajax' => false);
62    
63    $sql_demande_type="SELECT demande_type.demande_type, demande_type.libelle, demande_type.contraintes FROM ".DB_PREFIXE."demande_type";
64    $sql_autreDossierEnCour = "SELECT count(*) FROM ".DB_PREFIXE."dossier as a
65                                JOIN ".DB_PREFIXE."dossier_autorisation ON dossier_autorisation.dossier_autorisation = a.dossier_autorisation
66                                JOIN ".DB_PREFIXE."dossier as b ON b.dossier_autorisation = dossier_autorisation.dossier_autorisation
67                                JOIN ".DB_PREFIXE."etat ON etat.etat = b.etat
68                                WHERE etat.statut='encours' AND a.dossier='<idx>'";
69  ?>  ?>
Legend:
Removed from v.1084  
changed lines
  Added in v.1333
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26