"TYPO3 4.0.1: typo3_src-4.0.1/typo3/sysext/dbal/handlers/class.tx_dbal_handler_openoffice.php Source File", "datetime" => "Sat Dec 2 19:22:30 2006", "date" => "2 Dec 2006", "doxygenversion" => "1.4.6", "projectname" => "TYPO3 4.0.1", "projectnumber" => "4.0.1" ); get_header($doxygen_vars); ?>

class.tx_dbal_handler_openoffice.php

<?php
/***************************************************************
*  Copyright notice
*  
*  (c) 2004 Kasper Skaarhoj (kasper@typo3.com)
*  All rights reserved
*
*  This script is part of the TYPO3 project. The TYPO3 project is
*  free software; you can redistribute it and/or modify
*  it under the terms of the GNU General Public License as published by
*  the Free Software Foundation; either version 2 of the License, or
*  (at your option) any later version.
*
*  The GNU General Public License can be found at
*  http://www.gnu.org/copyleft/gpl.html.
*  A copy is found in the textfile GPL.txt and important notices to the license
*  from the author is found in LICENSE.txt distributed with these scripts.
*
*
*  This script is distributed in the hope that it will be useful,
*  but WITHOUT ANY WARRANTY; without even the implied warranty of
*  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
*  GNU General Public License for more details.
*
*  This copyright notice MUST APPEAR in all copies of the script!
***************************************************************/
class tx_dbal_handler_openoffice extends t3lib_sqlengine {

        var $config = array();
        var $pObj;      // Set from DBAL class.

        var $spreadSheetFiles = '';
        var $unzip;             // Object

        function init($config, &$pObj)  {
                $this->config = $config['config'];

                if (t3lib_extMgm::isLoaded('libunzipped'))      {

                                // Include Unzip library:
                        require_once(t3lib_extMgm::extPath('libunzipped').'class.tx_libunzipped.php');

                                // Find database file:
                        $sxc_file = t3lib_div::getFileAbsFileName($this->config['sxc_file']);
                        if (@is_file($sxc_file))        {

                                // Initialize Unzip object:
                                $this->unzip = t3lib_div::makeInstance('tx_libunzipped');
                                $this->spreadSheetFiles = $this->unzip->init($sxc_file);

                                if (is_array($this->spreadSheetFiles))  {
                                        return TRUE;
                                } else $this->errorStatus = 'Spreadsheet could not be unzipped...?';
                        } else $this->errorStatus = 'The Spreadsheet file "'.$sxc_file.'" was not found!';
                } else $this->errorStatus = 'This data handler needs the extension "tx_libunzipped" to be installed!';

                return FALSE;
        }

        function readDataSource($table) {
                if (!is_array($this->spreadSheetFiles)) {
                        die('Spreadsheet Data Source FATAL ERROR: No spreadsheet file loaded. Init() must have failed!');
                }

                $this->data[$table] = array();

                                // Read content.xml:
                $content_xml = $this->unzip->getFileFromArchive('content.xml');

                        // Testing for writing back:
                $content_xml = str_replace('Felt A1','FELT A1',$content_xml);

                        // Writing file back (to database)
                $this->unzip->putFileToArchive('content.xml', $content_xml['content']);

                        // Writing ZIP content back to zip-archive file:
                $result = $this->unzip->compileZipFile('fileadmin/dbtest_output.sxc');

                debug($result);

                exit;
        }

        function saveDataSource($table) {
        }









        /**************************************
         *
         * SQL admin functions
         * (For use in the Install Tool and Extension Manager)
         *
         **************************************/

        function admin_get_tables()     {

                $whichTables = array();
                return $whichTables;
        }

        function admin_get_fields($tableName)   {
                return array();
        }

        function admin_get_keys($tableName)     {
                return array();
        }

        function admin_query($query)    {

                $parsedQuery = $this->parseSQL($query);
                $table = $parsedQuery['TABLE'];

                if (is_array($parsedQuery))     {
                                // Process query based on type:
                        switch($parsedQuery['type'])    {
                                case 'CREATETABLE':
                                break;
                                case 'ALTERTABLE':
                                break;
                                case 'DROPTABLE':
                                break;
                                default:
                                        $this->errorStatus = 'Query type "'.$parsedQuery['type'].'" was not supported!';
                                break;
                        }

                } else $this->errorStatus = 'SQL parse error: '.$parsedQuery;

                return FALSE;
        }
}


if (defined('TYPO3_MODE') && $TYPO3_CONF_VARS[TYPO3_MODE]['XCLASS']['ext/dbal/handlers/class.tx_dbal_handler_openoffice.php'])  {
        include_once($TYPO3_CONF_VARS[TYPO3_MODE]['XCLASS']['ext/dbal/handlers/class.tx_dbal_handler_openoffice.php']);
}
?>