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
*
*
* 
*/

 
?>