| 1 |
<?php |
| 2 |
/* |
| 3 |
* $Id: dossier_plusieursparcelles.reqmo.inc,v 1.1 2009-10-28 15:34:52 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 avec parcelle > 6 caracteres"; |
| 11 |
$reqmo['sql']="select dossier, |
| 12 |
dossier, |
| 13 |
parcelle, |
| 14 |
dossier_autorisation_type_detaille.code as nature, |
| 15 |
pos, |
| 16 |
sig |
| 17 |
from ".DB_PREFIXE."dossier |
| 18 |
INNER JOIN ".DB_PREFIXE."dossier_autorisation |
| 19 |
ON dossier.dossier_autorisation=dossier_autorisation.dossier_autorisation |
| 20 |
INNER JOIN ".DB_PREFIXE."dossier_autorisation_type_detaille |
| 21 |
ON dossier_autorisation.dossier_autorisation_type_detaille = |
| 22 |
dossier_autorisation_type_detaille.dossier_autorisation_type_detaille |
| 23 |
INNER JOIN ".DB_PREFIXE."dossier_autorisation_type |
| 24 |
ON dossier_autorisation_type_detaille.dossier_autorisation_type = |
| 25 |
dossier_autorisation_type.dossier_autorisation_type |
| 26 |
where length( parcelle ) > 6 |
| 27 |
and dossier_autorisation_type.code = 'PC' |
| 28 |
and sig =''"; |
| 29 |
|
| 30 |
?> |
Parent Directory
| 
Revision Log