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

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

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

revision 1280 by nhaye, Thu Feb 21 16:32:36 2013 UTC revision 1281 by nhaye, Thu Feb 21 16:40:40 2013 UTC
# Line 87  $champAffiche = array_merge($champAffich Line 87  $champAffiche = array_merge($champAffich
87  // Liste des autres dossiers d'instructions  // Liste des autres dossiers d'instructions
88  if ($retourformulaire== 'dossier_instruction'){  if ($retourformulaire== 'dossier_instruction'){
89      $champAffiche=array(      $champAffiche=array(
90          'dossier.dossier as "'._("dossier_instruction").'"',          'b.dossier as "'._("dossier_instruction").'"',
91          'dossier_instruction_type.libelle as "'._("dossier").'"',          'dossier_instruction_type.libelle as "'._("dossier").'"',
92          'to_char(dossier.date_depot ,\'DD/MM/YYYY\') as "'._("date_depot").'"',          'to_char(b.date_depot ,\'DD/MM/YYYY\') as "'._("date_depot").'"',
93          'etat as "'._("etat").'"',          'b.etat as "'._("etat").'"',
94      );      );
95    
96      $table =DB_PREFIXE.'dossier      $table =DB_PREFIXE.'dossier as a
97                JOIN '.DB_PREFIXE.'dossier_autorisation
98                ON a.dossier_autorisation=dossier_autorisation.dossier_autorisation
99                JOIN '.DB_PREFIXE.'dossier as b
100                ON b.dossier_autorisation=dossier_autorisation.dossier_autorisation
101              JOIN '.DB_PREFIXE.'dossier_instruction_type              JOIN '.DB_PREFIXE.'dossier_instruction_type
102              ON dossier_instruction_type.dossier_instruction_type = dossier.dossier_instruction_type';              ON dossier_instruction_type.dossier_instruction_type = b.dossier_instruction_type';
103      $selection = 'WHERE dossier.dossier=\''.$idx.'\'';        $selection = 'WHERE a.dossier=\''.$idx.'\' AND b.dossier!=\''.$idx.'\'';  
104      $tri= "order by dossier.date_depot ASC";      $tri= "order by b.date_depot ASC";
105    
106      //Suppression du bouton d'ajout      //Suppression du bouton d'ajout
107      $tab_actions['corner']['ajouter'] = NULL;      $tab_actions['corner']['ajouter'] = NULL;
Legend:
Removed from v.1280  
changed lines
  Added in v.1281
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26