| 1 |
<?php |
| 2 |
//$Id$ |
| 3 |
//gen openMairie le 15/10/2012 10:58 |
| 4 |
|
| 5 |
$DEBUG=0; |
| 6 |
$ico="../img/ico_application.png"; |
| 7 |
$ent = _("application")." -> "._("consultation"); |
| 8 |
$tableSelect=DB_PREFIXE."consultation"; |
| 9 |
$champs=array( |
| 10 |
"consultation", |
| 11 |
"dossier", |
| 12 |
"date_envoi", |
| 13 |
"date_retour", |
| 14 |
"date_limite", |
| 15 |
"service", |
| 16 |
"avis_consultation", |
| 17 |
"date_reception", |
| 18 |
"motivation", |
| 19 |
"fichier", |
| 20 |
"lu"); |
| 21 |
//champs select |
| 22 |
$sql_avis_consultation="SELECT avis_consultation.avis_consultation, avis_consultation.libelle FROM ".DB_PREFIXE."avis_consultation WHERE ((avis_consultation.om_validite_debut IS NULL AND (avis_consultation.om_validite_fin IS NULL OR avis_consultation.om_validite_fin > CURRENT_DATE)) OR (avis_consultation.om_validite_debut <= CURRENT_DATE AND (avis_consultation.om_validite_fin IS NULL OR avis_consultation.om_validite_fin > CURRENT_DATE)))"; |
| 23 |
$sql_avis_consultation_by_id = "SELECT avis_consultation.avis_consultation, avis_consultation.libelle FROM ".DB_PREFIXE."avis_consultation WHERE avis_consultation = '<idx>'"; |
| 24 |
$sql_dossier="SELECT dossier.dossier, dossier.nature FROM ".DB_PREFIXE."dossier"; |
| 25 |
$sql_dossier_by_id = "SELECT dossier.dossier, dossier.nature FROM ".DB_PREFIXE."dossier WHERE dossier = '<idx>'"; |
| 26 |
$sql_service="SELECT service.service, service.libelle FROM ".DB_PREFIXE."service WHERE ((service.om_validite_debut IS NULL AND (service.om_validite_fin IS NULL OR service.om_validite_fin > CURRENT_DATE)) OR (service.om_validite_debut <= CURRENT_DATE AND (service.om_validite_fin IS NULL OR service.om_validite_fin > CURRENT_DATE)))"; |
| 27 |
$sql_service_by_id = "SELECT service.service, service.libelle FROM ".DB_PREFIXE."service WHERE service = '<idx>'"; |
| 28 |
?> |
Parent Directory
| 
Revision Log