Subversion Repositories eFlore/Applications.cel

<?php

/* vim: set expandtab tabstop=4 shiftwidth=4: */

// +----------------------------------------------------------------------+

// | PHP Version 4                                                        |

// +----------------------------------------------------------------------+

// | Copyright (c) 1997-2002 The PHP Group                                |

// +----------------------------------------------------------------------+

// | This source file is subject to version 2.02 of the PHP license,      |

// | that is bundled with this package in the file LICENSE, and is        |

// | available at through the world-wide-web at                           |

// | http://www.php.net/license/2_02.txt.                                 |

// | If you did not receive a copy of the PHP license and are unable to   |

// | obtain it through the world-wide-web, please send a note to          |

// | license@php.net so we can mail you a copy immediately.               |

// +----------------------------------------------------------------------+

// | Author: Xavier Noguer <xnoguer@php.net>                              |

// | Based on OLE::Storage_Lite by Kawai, Takanori                        |

// +----------------------------------------------------------------------+

//

// $Id: Root.php,v 1.9 2005/04/23 21:53:49 dufuz Exp $

/**

* Class for creating Root PPS's for OLE containers

*

* @author   Xavier Noguer <xnoguer@php.net>

* @category PHPExcel

* @package  PHPExcel_Shared_OLE

*/

class PHPExcel_Shared_OLE_PPS_Root extends PHPExcel_Shared_OLE_PPS

	{

	/**

	 * Directory for temporary files

	 * @var string

	 */

	protected $_tmp_dir		= NULL;

	/**

	 * @param integer $time_1st A timestamp

	 * @param integer $time_2nd A timestamp

	 */

	public function __construct($time_1st, $time_2nd, $raChild)

	{

		$this->_tempDir = PHPExcel_Shared_File::sys_get_temp_dir();

		parent::__construct(

		   null,

		   PHPExcel_Shared_OLE::Asc2Ucs('Root Entry'),

		   PHPExcel_Shared_OLE::OLE_PPS_TYPE_ROOT,

		   null,

		   null,

		   null,

		   $time_1st,

		   $time_2nd,

		   null,

		   $raChild);

	}

	/**

	* Method for saving the whole OLE container (including files).

	* In fact, if called with an empty argument (or '-'), it saves to a

	* temporary file and then outputs it's contents to stdout.

	* If a resource pointer to a stream created by fopen() is passed

	* it will be used, but you have to close such stream by yourself.

	*

	* @param string|resource $filename The name of the file or stream where to save the OLE container.

	* @access public

	* @return mixed true on success

	*/

	public function save($filename)

	{

		// Initial Setting for saving

		$this->_BIG_BLOCK_SIZE  = pow(2,

					  ((isset($this->_BIG_BLOCK_SIZE))? self::_adjust2($this->_BIG_BLOCK_SIZE)  : 9));

		$this->_SMALL_BLOCK_SIZE= pow(2,

					  ((isset($this->_SMALL_BLOCK_SIZE))?  self::_adjust2($this->_SMALL_BLOCK_SIZE): 6));

		if (is_resource($filename)) {

		    $this->_FILEH_ = $filename;

		} else if ($filename == '-' || $filename == '') {

			if ($this->_tmp_dir === NULL)

				$this->_tmp_dir = PHPExcel_Shared_File::sys_get_temp_dir();

			$this->_tmp_filename = tempnam($this->_tmp_dir, "OLE_PPS_Root");

			$this->_FILEH_ = fopen($this->_tmp_filename,"w+b");

			if ($this->_FILEH_ == false) {

				throw new PHPExcel_Writer_Exception("Can't create temporary file.");

			}

		} else {

			$this->_FILEH_ = fopen($filename, "wb");

		}

		if ($this->_FILEH_ == false) {

			throw new PHPExcel_Writer_Exception("Can't open $filename. It may be in use or protected.");

		}

		// Make an array of PPS's (for Save)

		$aList = array();

		PHPExcel_Shared_OLE_PPS::_savePpsSetPnt($aList, array($this));

		// calculate values for header

		list($iSBDcnt, $iBBcnt, $iPPScnt) = $this->_calcSize($aList); //, $rhInfo);

		// Save Header

		$this->_saveHeader($iSBDcnt, $iBBcnt, $iPPScnt);

		// Make Small Data string (write SBD)

		$this->_data = $this->_makeSmallData($aList);

		// Write BB

		$this->_saveBigData($iSBDcnt, $aList);

		// Write PPS

		$this->_savePps($aList);

		// Write Big Block Depot and BDList and Adding Header informations

		$this->_saveBbd($iSBDcnt, $iBBcnt, $iPPScnt);

		if (!is_resource($filename)) {

 			fclose($this->_FILEH_);

 		}

		return true;

	}

	/**

	* Calculate some numbers

	*

	* @access public

	* @param array $raList Reference to an array of PPS's

	* @return array The array of numbers

	*/

	public function _calcSize(&$raList)

	{

		// Calculate Basic Setting

		list($iSBDcnt, $iBBcnt, $iPPScnt) = array(0,0,0);

		$iSmallLen = 0;

		$iSBcnt = 0;

		$iCount = count($raList);

		for ($i = 0; $i < $iCount; ++$i) {

			if ($raList[$i]->Type == PHPExcel_Shared_OLE::OLE_PPS_TYPE_FILE) {

				$raList[$i]->Size = $raList[$i]->_DataLen();

				if ($raList[$i]->Size < PHPExcel_Shared_OLE::OLE_DATA_SIZE_SMALL) {

					$iSBcnt += floor($raList[$i]->Size / $this->_SMALL_BLOCK_SIZE)

								  + (($raList[$i]->Size % $this->_SMALL_BLOCK_SIZE)? 1: 0);

				} else {

					$iBBcnt += (floor($raList[$i]->Size / $this->_BIG_BLOCK_SIZE) +

						(($raList[$i]->Size % $this->_BIG_BLOCK_SIZE)? 1: 0));

				}

			}

		}

		$iSmallLen = $iSBcnt * $this->_SMALL_BLOCK_SIZE;

		$iSlCnt = floor($this->_BIG_BLOCK_SIZE / PHPExcel_Shared_OLE::OLE_LONG_INT_SIZE);

		$iSBDcnt = floor($iSBcnt / $iSlCnt) + (($iSBcnt % $iSlCnt)? 1:0);

		$iBBcnt +=  (floor($iSmallLen / $this->_BIG_BLOCK_SIZE) +

					  (( $iSmallLen % $this->_BIG_BLOCK_SIZE)? 1: 0));

		$iCnt = count($raList);

		$iBdCnt = $this->_BIG_BLOCK_SIZE / PHPExcel_Shared_OLE::OLE_PPS_SIZE;

		$iPPScnt = (floor($iCnt/$iBdCnt) + (($iCnt % $iBdCnt)? 1: 0));

		return array($iSBDcnt, $iBBcnt, $iPPScnt);

	}

	/**

	* Helper function for caculating a magic value for block sizes

	*

	* @access public

	* @param integer $i2 The argument

	* @see save()

	* @return integer

	*/

	private static function _adjust2($i2)

	{

		$iWk = log($i2)/log(2);

		return ($iWk > floor($iWk))? floor($iWk)+1:$iWk;

	}

	/**

	* Save OLE header

	*

	* @access public

	* @param integer $iSBDcnt

	* @param integer $iBBcnt

	* @param integer $iPPScnt

	*/

	public function _saveHeader($iSBDcnt, $iBBcnt, $iPPScnt)

	{

		$FILE = $this->_FILEH_;

		// Calculate Basic Setting

		$iBlCnt = $this->_BIG_BLOCK_SIZE / PHPExcel_Shared_OLE::OLE_LONG_INT_SIZE;

		$i1stBdL = ($this->_BIG_BLOCK_SIZE - 0x4C) / PHPExcel_Shared_OLE::OLE_LONG_INT_SIZE;

		$iBdExL = 0;

		$iAll = $iBBcnt + $iPPScnt + $iSBDcnt;

		$iAllW = $iAll;

		$iBdCntW = floor($iAllW / $iBlCnt) + (($iAllW % $iBlCnt)? 1: 0);

		$iBdCnt = floor(($iAll + $iBdCntW) / $iBlCnt) + ((($iAllW+$iBdCntW) % $iBlCnt)? 1: 0);

		// Calculate BD count

		if ($iBdCnt > $i1stBdL) {

			while (1) {

				++$iBdExL;

				++$iAllW;

				$iBdCntW = floor($iAllW / $iBlCnt) + (($iAllW % $iBlCnt)? 1: 0);

				$iBdCnt = floor(($iAllW + $iBdCntW) / $iBlCnt) + ((($iAllW+$iBdCntW) % $iBlCnt)? 1: 0);

				if ($iBdCnt <= ($iBdExL*$iBlCnt+ $i1stBdL)) {

					break;

				}

			}

		}

		// Save Header

		fwrite($FILE,

				"\xD0\xCF\x11\xE0\xA1\xB1\x1A\xE1"

				. "\x00\x00\x00\x00"

				. "\x00\x00\x00\x00"

				. "\x00\x00\x00\x00"

				. "\x00\x00\x00\x00"

				. pack("v", 0x3b)

				. pack("v", 0x03)

				. pack("v", -2)

				. pack("v", 9)

				. pack("v", 6)

				. pack("v", 0)

				. "\x00\x00\x00\x00"

				. "\x00\x00\x00\x00"

				. pack("V", $iBdCnt)

				. pack("V", $iBBcnt+$iSBDcnt) //ROOT START

				. pack("V", 0)

				. pack("V", 0x1000)

				. pack("V", $iSBDcnt ? 0 : -2)                  //Small Block Depot

				. pack("V", $iSBDcnt)

		  );

		// Extra BDList Start, Count

		if ($iBdCnt < $i1stBdL) {

			fwrite($FILE,

					pack("V", -2)      // Extra BDList Start

					. pack("V", 0)        // Extra BDList Count

				  );

		} else {

			fwrite($FILE, pack("V", $iAll+$iBdCnt) . pack("V", $iBdExL));

		}

		// BDList

		for ($i = 0; $i < $i1stBdL && $i < $iBdCnt; ++$i) {

			fwrite($FILE, pack("V", $iAll+$i));

		}

		if ($i < $i1stBdL) {

			$jB = $i1stBdL - $i;

			for ($j = 0; $j < $jB; ++$j) {

				fwrite($FILE, (pack("V", -1)));

			}

		}

	}

	/**

	* Saving big data (PPS's with data bigger than PHPExcel_Shared_OLE::OLE_DATA_SIZE_SMALL)

	*

	* @access public

	* @param integer $iStBlk

	* @param array &$raList Reference to array of PPS's

	*/

	public function _saveBigData($iStBlk, &$raList)

	{

		$FILE = $this->_FILEH_;

		// cycle through PPS's

		$iCount = count($raList);

		for ($i = 0; $i < $iCount; ++$i) {

			if ($raList[$i]->Type != PHPExcel_Shared_OLE::OLE_PPS_TYPE_DIR) {

				$raList[$i]->Size = $raList[$i]->_DataLen();

				if (($raList[$i]->Size >= PHPExcel_Shared_OLE::OLE_DATA_SIZE_SMALL) ||

					(($raList[$i]->Type == PHPExcel_Shared_OLE::OLE_PPS_TYPE_ROOT) && isset($raList[$i]->_data)))

				{

					// Write Data

					//if (isset($raList[$i]->_PPS_FILE)) {

					//	$iLen = 0;

					//	fseek($raList[$i]->_PPS_FILE, 0); // To The Top

					//	while($sBuff = fread($raList[$i]->_PPS_FILE, 4096)) {

					//		$iLen += strlen($sBuff);

					//		fwrite($FILE, $sBuff);

					//	}

					//} else {

						fwrite($FILE, $raList[$i]->_data);

					//}

					if ($raList[$i]->Size % $this->_BIG_BLOCK_SIZE) {

						fwrite($FILE, str_repeat("\x00", $this->_BIG_BLOCK_SIZE - ($raList[$i]->Size % $this->_BIG_BLOCK_SIZE)));

					}

					// Set For PPS

					$raList[$i]->_StartBlock = $iStBlk;

					$iStBlk +=

							(floor($raList[$i]->Size / $this->_BIG_BLOCK_SIZE) +

								(($raList[$i]->Size % $this->_BIG_BLOCK_SIZE)? 1: 0));

				}

				// Close file for each PPS, and unlink it

				//if (isset($raList[$i]->_PPS_FILE)) {

				//	fclose($raList[$i]->_PPS_FILE);

				//	$raList[$i]->_PPS_FILE = null;

				//	unlink($raList[$i]->_tmp_filename);

				//}

			}

		}

	}

	/**

	* get small data (PPS's with data smaller than PHPExcel_Shared_OLE::OLE_DATA_SIZE_SMALL)

	*

	* @access public

	* @param array &$raList Reference to array of PPS's

	*/

	public function _makeSmallData(&$raList)

	{

		$sRes = '';

		$FILE = $this->_FILEH_;

		$iSmBlk = 0;

		$iCount = count($raList);

		for ($i = 0; $i < $iCount; ++$i) {

			// Make SBD, small data string

			if ($raList[$i]->Type == PHPExcel_Shared_OLE::OLE_PPS_TYPE_FILE) {

				if ($raList[$i]->Size <= 0) {

					continue;

				}

				if ($raList[$i]->Size < PHPExcel_Shared_OLE::OLE_DATA_SIZE_SMALL) {

					$iSmbCnt = floor($raList[$i]->Size / $this->_SMALL_BLOCK_SIZE)

								  + (($raList[$i]->Size % $this->_SMALL_BLOCK_SIZE)? 1: 0);

					// Add to SBD

					$jB = $iSmbCnt - 1;

					for ($j = 0; $j < $jB; ++$j) {

						fwrite($FILE, pack("V", $j+$iSmBlk+1));

					}

					fwrite($FILE, pack("V", -2));

					//// Add to Data String(this will be written for RootEntry)

					//if ($raList[$i]->_PPS_FILE) {

					//	fseek($raList[$i]->_PPS_FILE, 0); // To The Top

					//	while ($sBuff = fread($raList[$i]->_PPS_FILE, 4096)) {

					//		$sRes .= $sBuff;

					//	}

					//} else {

						$sRes .= $raList[$i]->_data;

					//}

					if ($raList[$i]->Size % $this->_SMALL_BLOCK_SIZE) {

						$sRes .= str_repeat("\x00",$this->_SMALL_BLOCK_SIZE - ($raList[$i]->Size % $this->_SMALL_BLOCK_SIZE));

					}

					// Set for PPS

					$raList[$i]->_StartBlock = $iSmBlk;

					$iSmBlk += $iSmbCnt;

				}

			}

		}

		$iSbCnt = floor($this->_BIG_BLOCK_SIZE / PHPExcel_Shared_OLE::OLE_LONG_INT_SIZE);

		if ($iSmBlk % $iSbCnt) {

			$iB = $iSbCnt - ($iSmBlk % $iSbCnt);

			for ($i = 0; $i < $iB; ++$i) {

				fwrite($FILE, pack("V", -1));

			}

		}

		return $sRes;

	}

	/**

	* Saves all the PPS's WKs

	*

	* @access public

	* @param array $raList Reference to an array with all PPS's

	*/

	public function _savePps(&$raList)

	{

		// Save each PPS WK

		$iC = count($raList);

		for ($i = 0; $i < $iC; ++$i) {

			fwrite($this->_FILEH_, $raList[$i]->_getPpsWk());

		}

		// Adjust for Block

		$iCnt = count($raList);

		$iBCnt = $this->_BIG_BLOCK_SIZE / PHPExcel_Shared_OLE::OLE_PPS_SIZE;

		if ($iCnt % $iBCnt) {

			fwrite($this->_FILEH_, str_repeat("\x00",($iBCnt - ($iCnt % $iBCnt)) * PHPExcel_Shared_OLE::OLE_PPS_SIZE));

		}

	}

	/**

	* Saving Big Block Depot

	*

	* @access public

	* @param integer $iSbdSize

	* @param integer $iBsize

	* @param integer $iPpsCnt

	*/

	public function _saveBbd($iSbdSize, $iBsize, $iPpsCnt)

	{

		$FILE = $this->_FILEH_;

		// Calculate Basic Setting

		$iBbCnt = $this->_BIG_BLOCK_SIZE / PHPExcel_Shared_OLE::OLE_LONG_INT_SIZE;

		$i1stBdL = ($this->_BIG_BLOCK_SIZE - 0x4C) / PHPExcel_Shared_OLE::OLE_LONG_INT_SIZE;

		$iBdExL = 0;

		$iAll = $iBsize + $iPpsCnt + $iSbdSize;

		$iAllW = $iAll;

		$iBdCntW = floor($iAllW / $iBbCnt) + (($iAllW % $iBbCnt)? 1: 0);

		$iBdCnt = floor(($iAll + $iBdCntW) / $iBbCnt) + ((($iAllW+$iBdCntW) % $iBbCnt)? 1: 0);

		// Calculate BD count

		if ($iBdCnt >$i1stBdL) {

			while (1) {

				++$iBdExL;

				++$iAllW;

				$iBdCntW = floor($iAllW / $iBbCnt) + (($iAllW % $iBbCnt)? 1: 0);

				$iBdCnt = floor(($iAllW + $iBdCntW) / $iBbCnt) + ((($iAllW+$iBdCntW) % $iBbCnt)? 1: 0);

				if ($iBdCnt <= ($iBdExL*$iBbCnt+ $i1stBdL)) {

					break;

				}

			}

		}

		// Making BD

		// Set for SBD

		if ($iSbdSize > 0) {

			for ($i = 0; $i < ($iSbdSize - 1); ++$i) {

				fwrite($FILE, pack("V", $i+1));

			}

			fwrite($FILE, pack("V", -2));

		}

		// Set for B

		for ($i = 0; $i < ($iBsize - 1); ++$i) {

			fwrite($FILE, pack("V", $i+$iSbdSize+1));

		}

		fwrite($FILE, pack("V", -2));

		// Set for PPS

		for ($i = 0; $i < ($iPpsCnt - 1); ++$i) {

			fwrite($FILE, pack("V", $i+$iSbdSize+$iBsize+1));

		}

		fwrite($FILE, pack("V", -2));

		// Set for BBD itself ( 0xFFFFFFFD : BBD)

		for ($i = 0; $i < $iBdCnt; ++$i) {

			fwrite($FILE, pack("V", 0xFFFFFFFD));

		}

		// Set for ExtraBDList

		for ($i = 0; $i < $iBdExL; ++$i) {

			fwrite($FILE, pack("V", 0xFFFFFFFC));

		}

		// Adjust for Block

		if (($iAllW + $iBdCnt) % $iBbCnt) {

			$iBlock = ($iBbCnt - (($iAllW + $iBdCnt) % $iBbCnt));

			for ($i = 0; $i < $iBlock; ++$i) {

				fwrite($FILE, pack("V", -1));

			}

		}

		// Extra BDList

		if ($iBdCnt > $i1stBdL) {

			$iN=0;

			$iNb=0;

			for ($i = $i1stBdL;$i < $iBdCnt; $i++, ++$iN) {

				if ($iN >= ($iBbCnt - 1)) {

					$iN = 0;

					++$iNb;

					fwrite($FILE, pack("V", $iAll+$iBdCnt+$iNb));

				}

				fwrite($FILE, pack("V", $iBsize+$iSbdSize+$iPpsCnt+$i));

			}

			if (($iBdCnt-$i1stBdL) % ($iBbCnt-1)) {

				$iB = ($iBbCnt - 1) - (($iBdCnt - $i1stBdL) % ($iBbCnt - 1));

				for ($i = 0; $i < $iB; ++$i) {

					fwrite($FILE, pack("V", -1));

				}

			}

			fwrite($FILE, pack("V", -2));

		}

	}

}