1 |
fraynaud |
3 |
<?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 |
|
|
[nature], |
13 |
|
|
[etat], |
14 |
|
|
concat(substring(date_depot,9,2),'/',substring(date_depot,6,2),'/',substring(date_depot,1,4)) as date_depot_francais |
15 |
|
|
from dossier |
16 |
|
|
where parcelle ='' order by date_depot desc"; |
17 |
|
|
$reqmo['nature']="checked"; |
18 |
|
|
$reqmo['etat']="checked"; |
19 |
|
|
//$reqmo['date_depot']="checked" |
20 |
|
|
?> |