Subversion Repositories eFlore/Applications.cel

<?php

// 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'URL de la page de Photoflora affichant toutes les images d'un taxon donn.es.*/

define('EF_URL_PHOTOFLORA_TAXON', EF_URL_PHOTOFLORA.'FiTax.php?NumTaxon=%s');

/** Constante stockant l'URL du dossier de photoflora contenant les images miniatures.*/

define('EF_URL_PHOTOFLORA_IMG_MIN', 'http://www.tela-botanica.org/~photoflo/photos/%s/min/%s');

/** Constante stockant l'URL du dossier de photoflora contenant les images normale.*/

define('EF_URL_PHOTOFLORA_IMG_MAX', 'http://www.tela-botanica.org/~photoflo/photos/%s/max/%s');

/** 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');

Class InventoryPDF extends DBAccessor  {

	var $config;

	var $extendPDFProductor;

	function InventoryPDF($config) {

		$this->config=$config;

		// Pas d'heritage multiple en php :(

		$this->extendPDFProductor = new PDFProductor();

		$this->extendPDFProductor->initPDF();

	}

	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)

			// uid[3] : si absent : valeur 'all' (recherche libre)

			// uid[4] : si absent : valeur 'all' (station)

			$DB=$this->connectDB($this->config,'database_cel');

			if (!isset($uid[1]) || $uid[1]=="" || $uid[1]=="all" ) {

				$uid[1]="all";

				$query_location="";

			}

			else {

				$query_location=" AND location='".$DB->escapeSimple($uid[1])."' ";

			}

			if (!isset($uid[2]) || $uid[2]=="" || $uid[2]=="all") {

				$uid[2]="all";

				$query_date="";

			}

			else {

				$query_date=" AND date_observation='".$DB->escapeSimple($uid[2])."' ";

			}

			if (!isset($uid[3]) || $uid[3]=="" || $uid[3]=="all") {

				$uid[3]="all";

				$query_libre="";

			}

			else {

				$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])."%') ";

			}

			if (!isset($uid[4]) || $uid[4]=="" || $uid[4]=="all") {

				$uid[4]="all";

				$query_station="";

			}

			else {

				$query_station=" AND station='".$DB->escapeSimple($uid[4])."' ";

			}

			$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])."' " .

					$query_location.

	        		$query_date.

	        		$query_libre.

	         		$query_station.

	          		" ORDER BY ordre ";

       	    $res =& $DB->query($query);

			if (DB::isError($res)) {

			     die($res->getMessage());

			}

			// Set up the pdf object.

			$pdf = &File_PDF::factory(array('orientation' => 'P', 'format' => 'A4'));

			// DesActivate compression.

			$pdf->setCompression(false);

			$pdf->setMargins(0, 0);

			// Enable automatic page breaks.

			$pdf->setAutoPageBreak(true);

			// Start the document.

			$pdf->open();

			// Start a page.

			$pdf->addPage();

			$pdf->setFont('Times', '' , 12);

			$i=1;

		    $tempfn = tempnam("","");

			 while ($row =& $res->fetchrow(DB_FETCHMODE_ASSOC)) {

			 	// Denullifiage

				foreach($row as $k=>$v) {

					if (($v=="null") || ($v=="000null")) {

						$row[$k]="";

					}

					else {

						$row[$k]=utf8_decode($v);

					}

				}

			  	if ($row['date_observation']!="0000-00-00 00:00:00") {

	                list($year,$month,$day)= split ('-',$row['date_observation']);

    	            list($day)= split (' ',$day);

	                $row['date_observation']=$day."/".$month."/".$year;

	        	}

	        	else {

	                $row['date_observation']="00/00/0000";

	        	}

                $text= $row['nom_sel']." ".$row['num_nom_sel']." ".$row['nom_ret']." ".$row['num_nom_ret']." ".$row['num_taxon']." ".

                $row['famille']." ".$row['location']." ".$row['id_location']." ".$row['date_observation']." ".$row['station'];

                $row['commentaire'];

				$pdf->write(10, $text."\n");

				$projet_photo = 'photoflora';

				$tab_retour[$projet_photo]=chercherIllustrationsServiceXml(sprintf(EF_URL_PHOTOFLORA_SERVICE, $row['num_taxon']));

		      	$url_miniature ='';

				foreach ($tab_retour[$projet_photo] as $cle => $illustration) {

					if (preg_match(EF_URL_PHOTOFLORA_REGEXP, $illustration['about'], $match)) {

					$abreviation = $match[1];

					$fichier = $match[2];

			      	$url_miniature = sprintf(EF_URL_PHOTOFLORA_IMG_MIN, $abreviation, $fichier);;

					// Priorite aux images en png

						if (strstr($fichier, '.png')) {

							break;

						}

					}

				}

				if ($url_miniature!='') {

					list($debut,$ext)=split("\.",basename($url_miniature));

	       		    $temp = fopen($tempfn, "w");

					$buf=file_get_contents($url_miniature);

					fwrite($temp,$buf);

        			fclose($temp);

					$pdf->image($tempfn,10,($i*10),0,0,$ext);

				}

                $i++;

    	    }

			// Print the generated file.

		echo $pdf->output("Rapport");

	}

}

function chercherIllustrationsServiceXml($url)

{

		return  analyserFichierRdf($url);

}

function analyserFichierRdf($chemin)

{

		$aso_info = array();

		$dom = new DOMDocument();

		$dom->validateOnParse = true;

		if (preg_match('/^http:\/\//', $chemin)) {

			$dom->loadXML(file_get_contents($chemin));

		} else {

			$dom->load($chemin);

		}

		$tab_infos = array();

		foreach ($dom->getElementsByTagNameNS('http://www.w3.org/1999/02/22-rdf-syntax-ns#', 'Description') as $rdf_description) {

			$aso_info['about'] = $rdf_description->getAttribute('about');

			$aso_info['dc:identifier'] = $rdf_description->getAttribute('identifier');

			$aso_info['dc:title'] = utf8_decode($rdf_description->getAttribute('title'));

			$aso_info['dc:creator'] = utf8_decode($rdf_description->getAttribute('creator'));

			$aso_info['dc:contributor'] = utf8_decode($rdf_description->getAttribute('contributor'));

			$aso_info['dc:publisher'] = utf8_decode($rdf_description->getAttribute('publisher'));

			$aso_info['dc:type'] = utf8_decode($rdf_description->getAttribute('type'));

			$aso_info['dc:format'] = utf8_decode($rdf_description->getAttribute('format'));

			if (function_exists('date_default_timezone_set')) {

				date_default_timezone_set('Europe/Paris');

			}

			if (preg_match('/^\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2}$/', $rdf_description->getAttribute('created'))) {

				$aso_info['dcterms:created'] = date('j-m-Y � H:i:s', strtotime($rdf_description->getAttribute('created')));

			} else {

				$aso_info['dcterms:created'] = $rdf_description->getAttribute('created');

			}

			$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

*

* Revision 1.1  2007-06-06 13:31:16  ddelon

* v0.09

*

* Revision 1.4  2007-05-22 12:54:09  ddelon

* Securisation acces utilisateur

*

*

*

*/

?>