<?php
/**
* LICENSE
*
* This source file is subject to the new BSD license
* It is available through the world-wide-web at this URL:
* http://www.petala-azul.com/bsd.txt
* If you did not receive a copy of the license and are unable to
* obtain it through the world-wide-web, please send an email
* to [email protected] so we can send you a copy immediately.
*
* @package Bvb_Grid
* @author Bento Vilas Boas <[email protected]>
* @copyright 2010 ZFDatagrid
* @license http://www.petala-azul.com/bsd.txt New BSD License
* @version $Id$
* @link http://zfdatagrid.com
*/
class Bvb_Grid_Deploy_Ods extends Bvb_Grid implements Bvb_Grid_Deploy_DeployInterface
{
/**
* Info about template params
* @var array
*/
public $templateInfo;
/**
* First folder where the template is stored
* @var string
*/
private $inicialDir;
/**
* Dir where the template is stored
* @var atring
*/
protected $templateDir;
public function __construct (array $options = array())
{
if ( ! class_exists('ZipArchive') ) {
throw new Bvb_Grid_Exception('Class ZipArchive not available. Check www.php.net/ZipArchive for more information');
}
$this->_setRemoveHiddenFields(true);
parent::__construct($options);
$this->addTemplateDir('Bvb/Grid/Template', 'Bvb_Grid_Template', 'ods');
}
public function deploy ()
{
$this->checkExportRights();
$this->setRecordsPerPage(0);
parent::deploy();
if ( ! $this->_temp['ods'] instanceof Bvb_Grid_Template_Ods ) {
$this->setTemplate('ods', 'ods');
}
$this->templateInfo = $this->_temp['ods']->options;
if ( ! isset($this->_deploy['title']) ) {
$this->_deploy['title'] = '';
}
if ( ! isset($this->_deploy['subtitle']) ) {
$this->_deploy['subtitle'] = '';
}
if ( ! isset($this->_deploy['logo']) ) {
$this->_deploy['logo'] = '';
}
if ( ! isset($this->_deploy['footer']) ) {
$this->_deploy['footer'] = '';
}
if ( ! isset($this->_deploy['save']) ) {
$this->_deploy['save'] = false;
}
if ( ! isset($this->_deploy['download']) ) {
$this->_deploy['download'] = false;
}
if ( $this->_deploy['save'] != 1 && $this->_deploy['download'] != 1 ) {
throw new Exception('Nothing to do. Please specify download&&|save options');
}
$this->_deploy['dir'] = rtrim($this->_deploy['dir'], '/') . '/';
$this->inicialDir = $this->_deploy['dir'];
if ( empty($this->_deploy['name']) ) {
$this->_deploy['name'] = date('H_m_d_H_i_s');
}
if ( substr($this->_deploy['name'], - 5) == '.docx' ) {
$this->_deploy['name'] = substr($this->_deploy['name'], 0, - 5);
}
if ( ! is_dir($this->_deploy['dir']) ) {
throw new Bvb_Grid_Exception($this->_deploy['dir'] . ' is not a dir');
}
if ( ! is_writable($this->_deploy['dir']) ) {
throw new Bvb_Grid_Exception($this->_deploy['dir'] . ' is not writable');
}
$this->templateDir = explode('/', $this->templateInfo['dir']);
array_pop($this->templateDir);
$this->templateDir = ucfirst(end($this->templateDir));
$this->_deploy['dir'] = rtrim($this->_deploy['dir'], '/') . '/' . ucfirst($this->_deploy['name']) . '/';
if ( ! defined(APPLICATION_PATH) ) {
$pathTemplate = substr($this->templateInfo['dir'], 0, - 4) . '/';
} else {
$pathTemplate = APPLICATION_PATH . '/../' . rtrim($this->getLibraryDir(), '/') . '/' . substr($this->templateInfo['dir'], 0, - 4) . '/';
}
Bvb_Grid_Deploy_Helper_File::deldir($this->_deploy['dir']);
Bvb_Grid_Deploy_Helper_File::copyDir($pathTemplate, $this->_deploy['dir']);
$xml = $this->_temp['ods']
->globalStart();
$titles = parent::_buildTitles();
$wsData = parent::_buildGrid();
$sql = parent::_buildSqlExp();
// START CONTENT.XML
$xml = $this->_temp['ods']
->globalStart();
$xml .= $this->_temp['ods']
->titlesStart();
foreach ( $titles as $value ) {
$xml .= str_replace("{{value}}", utf8_encode($value['value']), $this->_temp['ods']
->titlesLoop());
}
$xml .= $this->_temp['ods']
->titlesEnd();
if ( is_array($wsData) ) {
foreach ( $wsData as $row ) {
$xml .= $this->_temp['ods']
->loopStart();
foreach ( $row as $value ) {
$xml .= str_replace("{{value}}", utf8_encode(strip_tags($value['value'])), $this->_temp['ods']
->loopLoop());
}
$xml .= $this->_temp['ods']
->loopEnd();
}
}
if ( is_array($sql) ) {
$xml .= $this->_temp['ods']
->sqlExpStart();
foreach ( $sql as $value ) {
$xml .= str_replace("{{value}}", utf8_encode($value['value']), $this->_temp['ods']
->sqlExpLoop());
}
$xml .= $this->_temp['ods']
->sqlExpEnd();
}
$xml .= $this->_temp['ods']
->globalEnd();
file_put_contents($this->_deploy['dir'] . "content.xml", $xml);
$final = Bvb_Grid_Deploy_Helper_File::scan_directory_recursively($this->_deploy['dir']);
$f = explode('|', Bvb_Grid_Deploy_Helper_File::zipPaths($final));
array_pop($f);
$zip = new ZipArchive();
$filename = $this->_deploy['dir'] . $this->_deploy['name'] . ".zip";
if ( $zip->open($filename, ZIPARCHIVE::CREATE) !== TRUE ) {
exit("cannot open <$filename>\n");
}
foreach ( $f as $value ) {
$zip->addFile($value, str_replace($this->_deploy['dir'], '', $value));
}
$zip->close();
rename($filename, $this->inicialDir . $this->_deploy['name'] . '.ods');
if ( $this->_deploy['download'] == 1 ) {
header('Content-type: application/vnd.oasis.opendocument.spreadsheet');
header('Content-Disposition: attachment; filename="' . $this->_deploy['name'] . '.ods"');
readfile($this->inicialDir . $this->_deploy['name'] . '.ods');
}
if ( $this->_deploy['save'] != 1 ) {
unlink($this->inicialDir . $this->_deploy['name'] . '.ods');
}
Bvb_Grid_Deploy_Helper_File::deldir($this->_deploy['dir']);
die();
}
}
|
Download
