<?php

/**
 * 
 * MOVE To Core ---
 * 
 * Usage:
 * 
 * POST Values: 
 *  xml = data
 *  format = [empty=xls] , 'gnumeric'  (download format)
 *  debug = true => download xml.
 * 
 * 
 * 
 */

require_once 'Pman.php';
class Pman_Core_GnumericToExcel extends Pman
{
    function getAuth()
    {
        $au = $this->getAuthUser();
        if (!$au) {
            die("NOT authenticated");
        }
        $this->authUser = $au;
        return true;
    }

    function get($v, $opts=array())
    {
        
    }
    function post($fname) {
        
        $ml = (int) ini_get('suhosin.post.max_value_length');
        if (empty($_POST['xml'])) {
            header("HTTP/1.0 400 Internal Server Error");
            die(  $ml ? "Suhosin Patch enabled - try and disable it!!!" : 'no XML sent');
        }
        
        if (empty($_POST['xml'])) {
            header("HTTP/1.0 400 Internal Server Error");
            die("Missing XML attribute");
        }
        $xml = $_POST['xml'];
        
        $xml = iconv("UTF-8", "UTF-8//IGNORE",  $xml);
        
        //$xml = str_replace('�', 'e', $xml);
        //$xml = str_replace("\xA0", ' ', $xml);
        //$xml = str_replace("�", 'dia.',$xml);
        
        //$this->addEvent("DOWNLOAD", false, isset($_REQUEST['title']) ? $_REQUEST['title'] : '???');
        
        
        if (!empty($_POST['format']) && $_POST['format']=='gnumeric') {
            if (empty($_POST['debug'])) {
                header('Content-type: application/x-gnumeric');
                header('Content-Disposition: attachment; filename="' .addslashes($fname). '.gnumeric"');
            } else {
                header('Content-type: text/xml');
            }
            echo $xml; 
            exit;
        }
        
        $ext = '.xls';
        $outfmt = 'Gnumeric_Excel:excel_biff8';
        $mime = 'application/vnd.ms-excel';
        
        /*
         // ssconvert results in bad images 
         if (!empty($_POST['format']) && $_POST['format']=='xlsx') {
            $outfmt = 'Gnumeric_Excel:xlsx';
            $ext = 'xlsx';
            $mime = 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet';
        }
        */
        
        
        
        $srcTmp = $this->tempName('gnumeric');
        $targetTmp = $this->tempName($ext);
        // write the gnumeric file...
        $fh = fopen($srcTmp,'w');
        fwrite($fh, $xml);
        fclose($fh);
        
        
        require_once 'System.php';
        $xvfb = System::which('xvfb-run');
        
        $ss = System::which('ssconvert');
        $cmd = $xvfb . " -a " . $ss. 
                " --import-encoding=Gnumeric_XmlIO:sax" .
                " --export-type={$outfmt} " . 
                $srcTmp . ' ' . $targetTmp . ' 2>&1';
        // echo $cmd;
        //passthru($cmd);exit;
        //exit;
        $out = `$cmd`;
        clearstatcache(); 
        
        if (!file_exists($targetTmp) || !filesize($targetTmp)) {
            header("HTTP/1.0 400 Internal Server Error - Convert error");
            die("ERROR CONVERTING?:" . $cmd ."\n<BR><BR> OUTPUT:". htmlspecialchars($out));
        }
        
        if (!empty($_POST['format']) && $_POST['format']=='xlsx') {
            require_once 'File/Convert.php';
            $cc = new File_Convert($targetTmp,'application/vnd.ms-excel');
           
            $targetTmp = $cc->convert('application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
            $mime = 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet';
            $ext = "xlsx";
         }
        
        
        
        
        
        
       // unlink($srcTmp);
        if (empty($fname)) {
           $fname = basename($targetTmp);
        }
        $fname .= preg_match('/\.' . $ext . '/i', $fname) ? '' :  ('.' . $ext); // make sure it ends in xls..
       
        header('Content-type: ' . $mime);
        header('Content-Disposition: attachment; filename="' .addslashes($fname). '"');
        header('Content-length: '. filesize($targetTmp));   
        header("Content-Transfer-Encoding: binary");
        if ($file = fopen($targetTmp, 'rb')) {
            while(!feof($file) and (connection_status()==0)) {
                print(fread($file, 1024*8));
                flush();
            }
            fclose($file);
        }
       
        unlink($targetTmp);
        exit;
        
    }
    
     
}