| 1 |
<?php |
| 2 |
/** |
| 3 |
* Ce script permet de mettre un texte de la bible dans un formulaire instruction |
| 4 |
* champs file d'un formulaire - automatique |
| 5 |
* |
| 6 |
* @package openmairie_foncier |
| 7 |
* @version SVN : $Id$ |
| 8 |
*/ |
| 9 |
require_once "../obj/utils.class.php"; |
| 10 |
$f = new utils("nohtml"); |
| 11 |
/** |
| 12 |
* Affichage de la structure HTML |
| 13 |
*/ |
| 14 |
$f->setFlag("htmlonly"); |
| 15 |
$f->display(); |
| 16 |
$f->displayStartContent(); |
| 17 |
// *** get |
| 18 |
$formatDate="AAAA-MM-JJ"; |
| 19 |
$idx=$_GET['idx']; |
| 20 |
$evenement=$_GET['ev']; |
| 21 |
$DEBUG=0; |
| 22 |
// *** extraction consultation |
| 23 |
$consultation=$f->db->getOne("select consultation from ".DB_PREFIXE."evenement where evenement=".$evenement); |
| 24 |
$f->isDatabaseError($consultation); |
| 25 |
if($consultation=='Oui'){ |
| 26 |
$sql="select date_retour,avis_consultation.libelle as avis_consultation, |
| 27 |
service.libelle as service |
| 28 |
from ".DB_PREFIXE."consultation inner join ".DB_PREFIXE."service |
| 29 |
on consultation.service =service.service |
| 30 |
left join ".DB_PREFIXE."avis_consultation on consultation.avis_consultation = avis_consultation.avis_consultation |
| 31 |
where dossier ='".$idx."'"; |
| 32 |
if ($DEBUG==1) |
| 33 |
echo $sql; |
| 34 |
$res = $f->db->query($sql); |
| 35 |
$f->isDatabaseError($res); |
| 36 |
if ($DEBUG == 1) |
| 37 |
echo "La requete ".$sql." est executee"; |
| 38 |
$temp=""; |
| 39 |
while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)){ |
| 40 |
// date retour |
| 41 |
if ($row['date_retour']<>""){ |
| 42 |
if ($formatDate=="AAAA-MM-JJ"){ |
| 43 |
$date = explode("-", $row['date_retour']); |
| 44 |
// controle de date |
| 45 |
if (sizeof($date) == 3 and (checkdate($date[1],$date[2],$date[0]))) { |
| 46 |
$date_retour_f= $date[2]."/".$date[1]."/".$date[0]; |
| 47 |
$correct=true; |
| 48 |
}else{ |
| 49 |
$msg= $msg."<br>La date ".$row['date_retour']." n'est pas une date."; |
| 50 |
$correct=false; |
| 51 |
} |
| 52 |
} |
| 53 |
} |
| 54 |
$temp="Vu l'avis ".$row['avis_consultation']." du service ".$row['service']; |
| 55 |
if($correct==true) |
| 56 |
$temp=$temp." du ".$date_retour_f; |
| 57 |
?> |
| 58 |
<script language="javascript"> |
| 59 |
opener.document.f2.complement.value = opener.document.f2.complement.value+"<?php echo $temp;?>"+"\r\n"; |
| 60 |
</script> |
| 61 |
<?php |
| 62 |
} // while |
| 63 |
} // consultation |
| 64 |
|
| 65 |
// *** bible automatique complement 1 |
| 66 |
$sql="SELECT * FROM ".DB_PREFIXE."bible |
| 67 |
LEFT OUTER JOIN ".DB_PREFIXE."dossier_autorisation_type |
| 68 |
ON bible.dossier_autorisation_type=dossier_autorisation_type.dossier_autorisation_type |
| 69 |
WHERE evenement =".$evenement. |
| 70 |
" and complement=1 and automatique='Oui' and (dossier_autorisation_type.code ='". |
| 71 |
substr($idx,0,2)."' or bible.dossier_autorisation_type IS NULL)"; |
| 72 |
if ($DEBUG==1) |
| 73 |
echo $sql; |
| 74 |
$res = $f->db->query($sql); |
| 75 |
$f->isDatabaseError($res); |
| 76 |
if ($DEBUG == 1) |
| 77 |
echo "La requete ".$sql." est executee"; |
| 78 |
$temp=""; |
| 79 |
while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)){ |
| 80 |
$temp=$row['contenu']; |
| 81 |
$temp0=str_replace("\r\n","|",$temp); |
| 82 |
$temp0=str_replace("\r","|",$temp0); |
| 83 |
$temp0=str_replace("\n","|",$temp0); |
| 84 |
$temp1=explode("|",$temp0); |
| 85 |
for($i=0;$i<sizeof($temp1);$i++){ |
| 86 |
$temp2=$temp1[$i]; |
| 87 |
?> |
| 88 |
<script language="javascript"> |
| 89 |
opener.document.f2.complement.value = opener.document.f2.complement.value+"<?php echo $temp2;?>"+"\r\n"; |
| 90 |
</script> |
| 91 |
<?php |
| 92 |
} |
| 93 |
} // fin while |
| 94 |
|
| 95 |
// *** bible automatique complement 2 |
| 96 |
$sql="SELECT * FROM ".DB_PREFIXE."bible ". |
| 97 |
"LEFT OUTER JOIN ".DB_PREFIXE."dossier_autorisation_type ". |
| 98 |
"ON bible.dossier_autorisation_type=dossier_autorisation_type.dossier_autorisation_type ". |
| 99 |
"WHERE evenement =".$evenement. |
| 100 |
" and complement=2 and automatique ='Oui' and (dossier_autorisation_type.code ='". |
| 101 |
substr($idx,0,2)."' or bible.dossier_autorisation_type IS NULL)"; |
| 102 |
if ($DEBUG==1) |
| 103 |
echo $sql; |
| 104 |
$res = $f->db->query($sql); |
| 105 |
$f->isDatabaseError($res); |
| 106 |
if ($DEBUG == 1) |
| 107 |
echo "La requete ".$sql." est executee"; |
| 108 |
$temp=""; |
| 109 |
while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)){ |
| 110 |
$temp=$row['contenu'] ; |
| 111 |
$temp0=str_replace("\r\n","|",$temp); |
| 112 |
$temp0=str_replace("\r","|",$temp0); |
| 113 |
$temp0=str_replace("\n","|",$temp0); |
| 114 |
//echo "***".$temp0."***<br>"; |
| 115 |
$temp1=explode("|",$temp0); |
| 116 |
for($i=0;$i<sizeof($temp1);$i++){ |
| 117 |
$temp2=$temp1[$i]; |
| 118 |
?> |
| 119 |
<script language="javascript"> |
| 120 |
opener.document.f2.complement2.value = opener.document.f2.complement2.value+"<?php echo $temp2;?>"+"\r\n"; |
| 121 |
</script> |
| 122 |
<?php |
| 123 |
}// for |
| 124 |
} // fin while |
| 125 |
|
| 126 |
?> |
| 127 |
<script language="javascript"> |
| 128 |
this.close(); |
| 129 |
</script> |
Parent Directory
| 
Revision Log