sql/pgsql/dossier_instruction_tous_encours.inc.php

<?php

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

//
$champAffiche = array_merge($champAffiche_debut_commun, array(
    '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 ) = 'encours' 
";

?>
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			'instructeur.nom as "'._("instructeur").'"',
9			), $champAffiche_fin_commun);
10
11			//
12			$selection = " WHERE
13	fmichon	887	dossier.division = ".$_SESSION['division']."
14			AND (select e.statut from etat e where e.etat = dossier.etat ) = 'encours'
15	fmichon	686	";
16
17	fmichon	647	?>