WebSVN – eFlore/Applications.cel – Diff – /branches/v2.8-houe/jrest/services/InventoryPDF.php

 <?php
+/**
+* PHP Version 5
+*
+* @category  PHP
+* @package   jrest
+* @author    David Delon <david.delon@clapas.net>
+* @copyright 2010 Tela-Botanica
+* @license   http://www.cecill.info/licences/Licence_CeCILL_V2-fr.txt Licence CECILL
+* @version   SVN: <svn_id>
+* @link      /doc/jrest/
+*/
-// In : utf8
-// Out : iso8859
 // Formatage pdf d'un releve (a revoir)
 /** Constante stockant l'URL de la page d'accueil de Photoflora.*/
 define('EF_URL_PHOTOFLORA', 'http://photoflora.free.fr/');
 /** Constante stockant l'expression r.guli.re r.cup.rant l'abr.viation du photographe et le nom du fichier.*/
 define('EF_URL_PHOTOFLORA_REGEXP', '/\/photos\/([^\/]+)\/max\/(.+)$/');
 /** Constante stockant l'URL du service XML de Photoflora.*/
 define('EF_URL_PHOTOFLORA_SERVICE', EF_URL_PHOTOFLORA.'ef_photoflora.php?nt=%s');
+/**
+* InventoryPDF.php
+*
+* in : utf8
+* out : iso8859
+*
+* Formatage pdf d'un releve (a revoir)
+*/
-Class InventoryPDF extends DBAccessor  {
 class InventoryPDF extends Cel  {
 	var $config;
+	var $extendPDFProductor;
-	var $extendPDFProductor;
+	function InventoryPDF($config) {
-	function InventoryPDF($config) {
+		parent::__construct($config);
 		$this->config=$config;
+		// Pas d'heritage multiple en php :(
+		$this->extendPDFProductor = new PDFProductor();
+		$this->extendPDFProductor->initPDF();
+	}
+	/**
-		// Pas d'heritage multiple en php :(
+	* uid[0] : utilisateur obligatoire
-		$this->extendPDFProductor = new PDFProductor();
+	* uid[1] : si absent : valeur 'all' (commune)
-		$this->extendPDFProductor->initPDF();
+	* uid[2] : si absent : valeur 'all' (date)
 	* uid[3] : si absent : valeur 'all' (recherche libre)
 	* uid[4] : si absent : valeur 'all' (station)
-	function getElement($uid){
-		   // Controle detournement utilisateur
-		    session_start();
-		 	$this->controleUtilisateur($uid[0]);
-			// uid[0] : utilisateur obligatoire
-			// uid[1] : si absent : valeur 'all' (commune)
+	*/
-			// uid[2] : si absent : valeur 'all' (date)
+	function getElement($uid){
-			// uid[3] : si absent : valeur 'all' (recherche libre)
-			// uid[4] : si absent : valeur 'all' (station)
+	   // Controle detournement utilisateur
 	    session_start();
-			$DB=$this->connectDB($this->config,'database_cel');
+	 	$this->controleUtilisateur($uid[0]);
-			if (!isset($uid[1]) || $uid[1]=="" || $uid[1]=="all" ) {
+		if (!isset($uid[1]) || $uid[1]=="" || $uid[1]=="all" ) {
-				$uid[1]="all";
+			$uid[1]="all";
-				$query_location="";
+			$requete_location="";
+		}
-			else {
+		else {
-				$query_location=" AND location='".$DB->escapeSimple($uid[1])."' ";
+			$requete_location=" AND location= ".$this->proteger($uid[1])." ";
+		}
-			if (!isset($uid[2]) || $uid[2]=="" || $uid[2]=="all") {
+		if (!isset($uid[2]) || $uid[2]=="" || $uid[2]=="all") {
-				$uid[2]="all";
+			$uid[2]="all";
-				$query_date="";
+			$requete_date="";
+		}
-			else {
+		else {
+			$requete_date=" AND date_observation= ".$this->proteger($uid[2])." ";
+		}
-				$query_date=" AND date_observation='".$DB->escapeSimple($uid[2])."' ";
+		if (!isset($uid[3]) || $uid[3]=="" || $uid[3]=="all") {
 			$uid[3]="all";
 			$requete_libre="";
-			if (!isset($uid[3]) || $uid[3]=="" || $uid[3]=="all") {
+		}
-				$uid[3]="all";
+		else {
-				$query_libre="";
+			$requete_libre=" AND (nom_sel LIKE ".$this->proteger('%'.$uid[3].'%').
-			}
+						" OR nom_ret LIKE ".$this->proteger('%'.$uid[3].'%').
-			else {
+						" OR station LIKE ".$this->proteger('%'.$uid[3].'%').
-				$query_libre=" AND (nom_sel like '%".$DB->escapeSimple($uid[3])."%' OR nom_ret like '%".$DB->escapeSimple($uid[3])."%' OR station like '%".$DB->escapeSimple($uid[3])."%' OR commentaire like '%".$DB->escapeSimple($uid[3])."%') ";
 						" OR commentaire LIKE ".$this->proteger('%'.$uid[3].'%');
-			if (!isset($uid[4]) || $uid[4]=="" || $uid[4]=="all") {
+		}
-				$uid[4]="all";
-				$query_station="";
+		if (!isset($uid[4]) || $uid[4]=="" || $uid[4]=="all") {
-			}
+			$uid[4]="all";
-			else {
+			$requete_station="";
-				$query_station=" AND station='".$DB->escapeSimple($uid[4])."' ";
+		}
 		else {
+			$requete_station=" AND station= ".$this->proteger($uid[4])." ";
-			$value=array();
+		}
+		$value=array();
-		   	$query="SELECT identifiant, ordre, nom_sel, num_nom_sel, nom_ret, num_nom_ret, num_taxon, famille, location, date_observation," .
-		           " station, commentaire, transmission  FROM cel_inventory WHERE identifiant='".$DB->escapeSimple($uid[0])."' " .
+	   	$requete="SELECT ce_utilisateur, ordre, nom_sel, nom_sel_nn, nom_ret, nom_ret_nn, nt, famille, zone_geo, date_observation," .
-					$query_location.
+	           " station, commentaire, transmission  FROM cel_obs WHERE ce_utilisateur = ".$this->proteger($uid[0])." " .
-	        		$query_date.
+				$requete_location.
-	        		$query_libre.
+        		$requete_date.
-	         		$query_station.
+        		$requete_libre.
-			$pdf->setFont('Times', '' , 12);
+		$pdf->setFont('Times', '' , 12);
-			$i=1;
+		$i=1;
-		    $tempfn = tempnam("","");
+	    $tempfn = tempnam("","");
 		foreach ($observations as $obs) {
-			 while ($row =& $res->fetchrow(DB_FETCHMODE_ASSOC)) {
-			 	// Denullifiage
+		 	// Denullifiage
-				foreach($row as $k=>$v) {
+			foreach($obs as $k=>$v) {
-					if (($v=="null") || ($v=="000null")) {
+				if (($v=="null") || ($v=="000null")) {
-						$row[$k]="";
+					$obs[$k]="";
-					}
+				}
-					else {
+				else {
-						$row[$k]=utf8_decode($v);
+					$obs[$k]=utf8_decode($v);
-					}
+				}
-				}
+			}
-			  	if ($row['date_observation']!="0000-00-00 00:00:00") {
+		  	if ($obs['date_observation']!="0000-00-00 00:00:00") {
-	                list($year,$month,$day)= split ('-',$row['date_observation']);
+                list($year,$month,$day)= split ('-',$obs['date_observation']);
-    	            list($day)= split (' ',$day);
+	            list($day)= split (' ',$day);
-	                $row['date_observation']=$day."/".$month."/".$year;
+                $obs['date_observation']=$day."/".$month."/".$year;
+        	}
-	        	else {
+        	else {
-	                $row['date_observation']="00/00/0000";
+                $obs['date_observation']="00/00/0000";
-	        	}
+        	}
-                $text= $row['nom_sel']." ".$row['num_nom_sel']." ".$row['nom_ret']." ".$row['num_nom_ret']." ".$row['num_taxon']." ".
+            $text= $obs['nom_sel']." ".$obs['nom_sel_nn']." ".$obs['nom_ret']." ".$obs['nom_ret_nn']." ".$obs['nt']." ".
-                $row['famille']." ".$row['location']." ".$row['id_location']." ".$row['date_observation']." ".$row['station'];
+            $obs['famille']." ".$obs['zone_geo']." ".$obs['ce_zone_geo']." ".$obs['date_observation']." ".$obs['station'];
-                $row['commentaire'];
+            $obs['commentaire'];
-							break;
+						break;
+					}
+				}
+			}
-				if ($url_miniature!='') {
+			if ($url_miniature!='') {
-					list($debut,$ext)=split("\.",basename($url_miniature));
+				list($debut,$ext)=split("\.",basename($url_miniature));
-	       		    $temp = fopen($tempfn, "w");
+       		    $temp = fopen($tempfn, "w");
-					$buf=file_get_contents($url_miniature);
+				$buf=file_get_contents($url_miniature);
+			}
-                $i++;
+            $i++;
-    	    }
 			// Print the generated file.
-		echo $pdf->output("Rapport");
-	}
 		echo $pdf->output("Rapport");
+	}
+}
 			$aso_info['dcterms:dateSubmitted'] = utf8_decode($rdf_description->getAttribute('dateSubmitted'));
 			$aso_info['dcterms:spatial'] = utf8_decode($rdf_description->getAttribute('spatial'));
 			$aso_info['dcterms:licence'] = utf8_decode($rdf_description->getAttribute('licence'));
 			$tab_infos[$rdf_description->getAttribute('identifier')] = $aso_info;
+		}
-		//echo '<pre>'.$chemin.print_r($tab_infos, true).'</pre>';
 		return $tab_infos;
+}
 /* +--Fin du code ---------------------------------------------------------------------------------------+
 * $Log$
 * Revision 1.2  2008-01-30 08:57:28  ddelon
 * fin mise en place mygwt
 * v0.09
+*
 * Revision 1.4  2007-05-22 12:54:09  ddelon
 * Securisation acces utilisateur
+*
-*
-*
 */
 ?>

Subversion Repositories eFlore/Applications.cel

(root)/branches/v2.8-houe/jrest/services/InventoryPDF.php @ 2857 – Rev 416 → 885