sql/pgsql/dossier_instruction_tous_clotures.inc.php

<?php

//
include('../sql/pgsql/dossier_instruction.inc.php');

//
$champAffiche = array_merge($champAffiche_debut_commun, array(
    'avis_decision.libelle as "'._("avis_decision").'"',
    'instructeur.nom as "'._("instructeur").'"',
), $champAffiche_fin_commun);

//
$selection = " WHERE
dossier.division = ".$_SESSION['division']."
AND (select e.statut from etat e where e.etat = dossier.etat ) = 'cloture' 
";

?>
1	fmichon	647	<?php
2
3			//
4			include('../sql/pgsql/dossier_instruction.inc.php');
5
6	fmichon	686	//
7			$champAffiche = array_merge($champAffiche_debut_commun, array(
8			'avis_decision.libelle as "'._("avis_decision").'"',
9			'instructeur.nom as "'._("instructeur").'"',
10			), $champAffiche_fin_commun);
11
12			//
13			$selection = " WHERE
14	fmichon	887	dossier.division = ".$_SESSION['division']."
15			AND (select e.statut from etat e where e.etat = dossier.etat ) = 'cloture'
16	fmichon	686	";
17
18	fmichon	647	?>