sql/pgsql/dossiers_tous_limites.inc.php

<?php
/**
 * 
 */

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

//
$selection = " WHERE
        (
            (date_limite <= CURRENT_TIMESTAMP + ".
                ((isset($_GET['nbj'])) ? $_GET['nbj'] : "1" ).
                " * interval '1 day' AND dossier.incompletude IS FALSE) OR
            (dossier.incompletude IS TRUE AND dossier.incomplet_notifie IS TRUE
                AND date_limite_incompletude <= CURRENT_TIMESTAMP + ".
                ((isset($_GET['nbj'])) ? $_GET['nbj'] : "1" )." * interval '1 day')
        )
        AND
        LOWER(dossier.accord_tacite) = 'oui' AND
        LOWER(dossier_autorisation_type.code) != 'dp' AND
        LOWER(dossier_autorisation_type_detaille.code) != 'cua' AND
        dossier.avis_decision IS NULL ";

$tri=" ORDER BY dossier.date_limite";
?>
1	softime	2120	<?php
2			/**
3			*
4			*/
5
6			//
7			include('../sql/pgsql/dossiers_limites.inc.php');
8
9			//
10			$selection = " WHERE
11	nhaye	3059	(
12			(date_limite <= CURRENT_TIMESTAMP + ".
13			((isset($_GET['nbj'])) ? $_GET['nbj'] : "1" ).
14			" * interval '1 day' AND dossier.incompletude IS FALSE) OR
15			(dossier.incompletude IS TRUE AND dossier.incomplet_notifie IS TRUE
16			AND date_limite_incompletude <= CURRENT_TIMESTAMP + ".
17			((isset($_GET['nbj'])) ? $_GET['nbj'] : "1" )." * interval '1 day')
18			)
19			AND
20	softime	2120	LOWER(dossier.accord_tacite) = 'oui' AND
21	nhaye	3059	LOWER(dossier_autorisation_type.code) != 'dp' AND
22			LOWER(dossier_autorisation_type_detaille.code) != 'cua' AND
23			dossier.avis_decision IS NULL ";
24
25			$tri=" ORDER BY dossier.date_limite";
26	softime	2120	?>