sql/pgsql/dossier_sansparcelle.reqmo.inc.php

<?php
/*
 * $Id: dossier_sansparcelle.reqmo.inc,v 1.1 2009-10-09 15:16:27 fraynaud Exp $
 * Created on 9 oct. 2009
 *
 * To change the template for this generated file go to
 * Window - Preferences - PHPeclipse - PHP - Code Templates
 */

$reqmo['libelle']="dossier_sansparcelle";
$reqmo['sql']="select dossier,
                      [dossier_autorisation_type_detaille.code as nature],
                      [dossier.etat as etat],
                      to_char(dossier.date_depot,'DD/MM/YYYY') as date_depot_francais
                from ".DB_PREFIXE."dossier 
                INNER JOIN ".DB_PREFIXE."dossier_autorisation
                      ON dossier.dossier_autorisation=dossier_autorisation.dossier_autorisation
                INNER JOIN ".DB_PREFIXE."dossier_autorisation_type_detaille
                      ON dossier_autorisation.dossier_autorisation_type_detaille = 
                      dossier_autorisation_type_detaille.dossier_autorisation_type_detaille
                where parcelle ='' order by date_depot desc";
$reqmo['nature']="checked";
$reqmo['etat']="checked";
//$reqmo['date_depot']="checked"
?>
1	<?php
2	/*
3	* $Id: dossier_sansparcelle.reqmo.inc,v 1.1 2009-10-09 15:16:27 fraynaud Exp $
4	* Created on 9 oct. 2009
5	*
6	* To change the template for this generated file go to
7	* Window - Preferences - PHPeclipse - PHP - Code Templates
8	*/
9
10	$reqmo['libelle']="dossier_sansparcelle";
11	$reqmo['sql']="select dossier,
12	[dossier_autorisation_type_detaille.code as nature],
13	[dossier.etat as etat],
14	to_char(dossier.date_depot,'DD/MM/YYYY') as date_depot_francais
15	from ".DB_PREFIXE."dossier
16	INNER JOIN ".DB_PREFIXE."dossier_autorisation
17	ON dossier.dossier_autorisation=dossier_autorisation.dossier_autorisation
18	INNER JOIN ".DB_PREFIXE."dossier_autorisation_type_detaille
19	ON dossier_autorisation.dossier_autorisation_type_detaille =
20	dossier_autorisation_type_detaille.dossier_autorisation_type_detaille
21	where parcelle ='' order by date_depot desc";
22	$reqmo['nature']="checked";
23	$reqmo['etat']="checked";
24	//$reqmo['date_depot']="checked"
25	?>