sql/pgsql/demande_avis_encours.inc.php

<?php
//$Id: demande_avis_encours.inc.php 4418 2015-02-24 17:30:28Z tbenita $ 
//gen openMairie le 18/10/2012 16:21
include('demande_avis.inc.php');
$ent = _("Demandes d'avis")." -> "._("en cours");
$tab_title = _("Demandes d'avis en cours");

//
$case_marque = "
CASE
    consultation.marque
WHEN
    't'
THEN
    '<span class=\"om-prev-icon om-icon-16 om-icon-fix marque-16\" title=\""._('Oui')."\"> </span>'
END";
array_push($champAffiche, $case_marque." as \""._("marqué")."\"");

$selection=' WHERE consultation.date_limite >= current_date
AND consultation.avis_consultation IS NULL
AND om_utilisateur.login=\''.$_SESSION['login'].'\'';
$tri="ORDER BY consultation.marque DESC, consultation.date_limite::date ASC";

?>
1	<?php
2	//$Id: demande_avis_encours.inc.php 4418 2015-02-24 17:30:28Z tbenita $
3	//gen openMairie le 18/10/2012 16:21
4	include('demande_avis.inc.php');
5	$ent = _("Demandes d'avis")." -> "._("en cours");
6	$tab_title = _("Demandes d'avis en cours");
7
8	//
9	$case_marque = "
10	CASE
11	consultation.marque
12	WHEN
13	't'
14	THEN
15	'<span class=\"om-prev-icon om-icon-16 om-icon-fix marque-16\" title=\""._('Oui')."\"> </span>'
16	END";
17	array_push($champAffiche, $case_marque." as \""._("marqué")."\"");
18
19	$selection=' WHERE consultation.date_limite >= current_date
20	AND consultation.avis_consultation IS NULL
21	AND om_utilisateur.login=\''.$_SESSION['login'].'\'';
22	$tri="ORDER BY consultation.marque DESC, consultation.date_limite::date ASC";
23
24	?>