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

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

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

revision 11585 by softime, Thu Mar 3 17:52:44 2022 UTC revision 18876 by softime, Tue Oct 8 08:41:06 2024 UTC
# Line 4  Line 4 
4   * @version SVN : $Id: dossier_instruction_tous_clotures.inc.php 5220 2015-09-24 17:50:06Z fmichon $   * @version SVN : $Id: dossier_instruction_tous_clotures.inc.php 5220 2015-09-24 17:50:06Z fmichon $
5   */   */
6    
7    //Parametre de déclenchement de l'optimisation SQL du lien lien_dossier_demandeur
8    $optimisation_demandeurs = true;
9    
10  //  //
11  include "../sql/pgsql/dossier_instruction.inc.php";  include "../sql/pgsql/dossier_instruction.inc.php";
12    
13  //  //
14  $champAffiche = array_merge($champAffiche_debut_commun, array(  $champAffiche = array_merge($champAffiche_debut_commun, array(
15      'avis_decision.libelle as "'._("avis_decision").'"',      'avis_decision.libelle as "'.__("avis_decision").'"',
16      'instructeur.nom as "'._("instructeur").'"',      $instructeur_nom,
17  ), $champAffiche_fin_commun);  ), $champAffiche_fin_commun);
18    
19  //  //
20  $selection .= "  $selection .= "
21  AND dossier.division = ".$_SESSION['division']."  AND dossier.division = ".$_SESSION['division']."
22  AND dossier.etat IN (select etat from ".DB_PREFIXE."etat where etat.statut='cloture' )  AND etat.statut='cloture'
23  ";  ";
24    
25  /**  /**
Legend:
Removed from v.11585  
changed lines
  Added in v.18876
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26