diff options
Diffstat (limited to 'admin/survey/excel/PHPExcel/Shared/Date.php')
| -rw-r--r-- | admin/survey/excel/PHPExcel/Shared/Date.php | 356 |
1 files changed, 0 insertions, 356 deletions
diff --git a/admin/survey/excel/PHPExcel/Shared/Date.php b/admin/survey/excel/PHPExcel/Shared/Date.php deleted file mode 100644 index 600d54c..0000000 --- a/admin/survey/excel/PHPExcel/Shared/Date.php +++ /dev/null @@ -1,356 +0,0 @@ -<?php
-
-/**
- * PHPExcel
- *
- * Copyright (c) 2006 - 2012 PHPExcel
- *
- * This library is free software; you can redistribute it and/or
- * modify it under the terms of the GNU Lesser General Public
- * License as published by the Free Software Foundation; either
- * version 2.1 of the License, or (at your option) any later version.
- *
- * This library 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
- * Lesser General Public License for more details.
- *
- * You should have received a copy of the GNU Lesser General Public
- * License along with this library; if not, write to the Free Software
- * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
- *
- * @category PHPExcel
- * @package PHPExcel_Shared
- * @copyright Copyright (c) 2006 - 2012 PHPExcel (http://www.codeplex.com/PHPExcel)
- * @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL
- * @version 1.7.8, 2012-10-12
- */
-
-
-/**
- * PHPExcel_Shared_Date
- *
- * @category PHPExcel
- * @package PHPExcel_Shared
- * @copyright Copyright (c) 2006 - 2012 PHPExcel (http://www.codeplex.com/PHPExcel)
- */
-class PHPExcel_Shared_Date
-{
- /** constants */
- const CALENDAR_WINDOWS_1900 = 1900; // Base date of 1st Jan 1900 = 1.0
- const CALENDAR_MAC_1904 = 1904; // Base date of 2nd Jan 1904 = 1.0
-
- /*
- * Names of the months of the year, indexed by shortname
- * Planned usage for locale settings
- *
- * @public
- * @var string[]
- */
- public static $_monthNames = array( 'Jan' => 'January',
- 'Feb' => 'February',
- 'Mar' => 'March',
- 'Apr' => 'April',
- 'May' => 'May',
- 'Jun' => 'June',
- 'Jul' => 'July',
- 'Aug' => 'August',
- 'Sep' => 'September',
- 'Oct' => 'October',
- 'Nov' => 'November',
- 'Dec' => 'December'
- );
-
- /*
- * Base calendar year to use for calculations
- *
- * @private
- * @var int
- */
- private static $ExcelBaseDate = self::CALENDAR_WINDOWS_1900;
-
- /*
- * Object type for PHP Date/Time values
- *
- * @private
- * @var string
- */
- public static $dateTimeObjectType = 'DateTime';
-
-
- /**
- * Set the Excel calendar (Windows 1900 or Mac 1904)
- *
- * @param integer $baseDate Excel base date
- * @return boolean Success or failure
- */
- public static function setExcelCalendar($baseDate) {
- if (($baseDate == self::CALENDAR_WINDOWS_1900) ||
- ($baseDate == self::CALENDAR_MAC_1904)) {
- self::$ExcelBaseDate = $baseDate;
- return TRUE;
- }
- return FALSE;
- } // function setExcelCalendar()
-
-
- /**
- * Return the Excel calendar (Windows 1900 or Mac 1904)
- *
- * @return integer $baseDate Excel base date
- */
- public static function getExcelCalendar() {
- return self::$ExcelBaseDate;
- } // function getExcelCalendar()
-
-
- /**
- * Convert a date from Excel to PHP
- *
- * @param long $dateValue Excel date/time value
- * @return long PHP serialized date/time
- */
- public static function ExcelToPHP($dateValue = 0) {
- if (self::$ExcelBaseDate == self::CALENDAR_WINDOWS_1900) {
- $myExcelBaseDate = 25569;
- // Adjust for the spurious 29-Feb-1900 (Day 60)
- if ($dateValue < 60) {
- --$myExcelBaseDate;
- }
- } else {
- $myExcelBaseDate = 24107;
- }
-
- // Perform conversion
- if ($dateValue >= 1) {
- $utcDays = $dateValue - $myExcelBaseDate;
- $returnValue = round($utcDays * 86400);
- if (($returnValue <= PHP_INT_MAX) && ($returnValue >= -PHP_INT_MAX)) {
- $returnValue = (integer) $returnValue;
- }
- } else {
- $hours = round($dateValue * 24);
- $mins = round($dateValue * 1440) - round($hours * 60);
- $secs = round($dateValue * 86400) - round($hours * 3600) - round($mins * 60);
- $returnValue = (integer) gmmktime($hours, $mins, $secs);
- }
-
- // Return
- return $returnValue;
- } // function ExcelToPHP()
-
-
- /**
- * Convert a date from Excel to a PHP Date/Time object
- *
- * @param long $dateValue Excel date/time value
- * @return long PHP date/time object
- */
- public static function ExcelToPHPObject($dateValue = 0) {
- $dateTime = self::ExcelToPHP($dateValue);
- $days = floor($dateTime / 86400);
- $time = round((($dateTime / 86400) - $days) * 86400);
- $hours = round($time / 3600);
- $minutes = round($time / 60) - ($hours * 60);
- $seconds = round($time) - ($hours * 3600) - ($minutes * 60);
-
- $dateObj = date_create('1-Jan-1970+'.$days.' days');
- $dateObj->setTime($hours,$minutes,$seconds);
-
- return $dateObj;
- } // function ExcelToPHPObject()
-
-
- /**
- * Convert a date from PHP to Excel
- *
- * @param mixed $dateValue PHP serialized date/time or date object
- * @return mixed Excel date/time value
- * or boolean FALSE on failure
- */
- public static function PHPToExcel($dateValue = 0) {
- $saveTimeZone = date_default_timezone_get();
- date_default_timezone_set('UTC');
- $retValue = FALSE;
- if ((is_object($dateValue)) && ($dateValue instanceof self::$dateTimeObjectType)) {
- $retValue = self::FormattedPHPToExcel( $dateValue->format('Y'), $dateValue->format('m'), $dateValue->format('d'),
- $dateValue->format('H'), $dateValue->format('i'), $dateValue->format('s')
- );
- } elseif (is_numeric($dateValue)) {
- $retValue = self::FormattedPHPToExcel( date('Y',$dateValue), date('m',$dateValue), date('d',$dateValue),
- date('H',$dateValue), date('i',$dateValue), date('s',$dateValue)
- );
- }
- date_default_timezone_set($saveTimeZone);
-
- return $retValue;
- } // function PHPToExcel()
-
-
- /**
- * FormattedPHPToExcel
- *
- * @param long $year
- * @param long $month
- * @param long $day
- * @param long $hours
- * @param long $minutes
- * @param long $seconds
- * @return long Excel date/time value
- */
- public static function FormattedPHPToExcel($year, $month, $day, $hours=0, $minutes=0, $seconds=0) {
- if (self::$ExcelBaseDate == self::CALENDAR_WINDOWS_1900) {
- //
- // Fudge factor for the erroneous fact that the year 1900 is treated as a Leap Year in MS Excel
- // This affects every date following 28th February 1900
- //
- $excel1900isLeapYear = TRUE;
- if (($year == 1900) && ($month <= 2)) { $excel1900isLeapYear = FALSE; }
- $myExcelBaseDate = 2415020;
- } else {
- $myExcelBaseDate = 2416481;
- $excel1900isLeapYear = FALSE;
- }
-
- // Julian base date Adjustment
- if ($month > 2) {
- $month -= 3;
- } else {
- $month += 9;
- --$year;
- }
-
- // Calculate the Julian Date, then subtract the Excel base date (JD 2415020 = 31-Dec-1899 Giving Excel Date of 0)
- $century = substr($year,0,2);
- $decade = substr($year,2,2);
- $excelDate = floor((146097 * $century) / 4) + floor((1461 * $decade) / 4) + floor((153 * $month + 2) / 5) + $day + 1721119 - $myExcelBaseDate + $excel1900isLeapYear;
-
- $excelTime = (($hours * 3600) + ($minutes * 60) + $seconds) / 86400;
-
- return (float) $excelDate + $excelTime;
- } // function FormattedPHPToExcel()
-
-
- /**
- * Is a given cell a date/time?
- *
- * @param PHPExcel_Cell $pCell
- * @return boolean
- */
- public static function isDateTime(PHPExcel_Cell $pCell) {
- return self::isDateTimeFormat(
- $pCell->getParent()->getStyle(
- $pCell->getCoordinate()
- )->getNumberFormat()
- );
- } // function isDateTime()
-
-
- /**
- * Is a given number format a date/time?
- *
- * @param PHPExcel_Style_NumberFormat $pFormat
- * @return boolean
- */
- public static function isDateTimeFormat(PHPExcel_Style_NumberFormat $pFormat) {
- return self::isDateTimeFormatCode($pFormat->getFormatCode());
- } // function isDateTimeFormat()
-
-
- private static $possibleDateFormatCharacters = 'eymdHs';
-
- /**
- * Is a given number format code a date/time?
- *
- * @param string $pFormatCode
- * @return boolean
- */
- public static function isDateTimeFormatCode($pFormatCode = '') {
- // Switch on formatcode
- switch ($pFormatCode) {
- // General contains an epoch letter 'e', so we trap for it explicitly here
- case PHPExcel_Style_NumberFormat::FORMAT_GENERAL:
- return FALSE;
- // Explicitly defined date formats
- case PHPExcel_Style_NumberFormat::FORMAT_DATE_YYYYMMDD:
- case PHPExcel_Style_NumberFormat::FORMAT_DATE_YYYYMMDD2:
- case PHPExcel_Style_NumberFormat::FORMAT_DATE_DDMMYYYY:
- case PHPExcel_Style_NumberFormat::FORMAT_DATE_DMYSLASH:
- case PHPExcel_Style_NumberFormat::FORMAT_DATE_DMYMINUS:
- case PHPExcel_Style_NumberFormat::FORMAT_DATE_DMMINUS:
- case PHPExcel_Style_NumberFormat::FORMAT_DATE_MYMINUS:
- case PHPExcel_Style_NumberFormat::FORMAT_DATE_DATETIME:
- case PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME1:
- case PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME2:
- case PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME3:
- case PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME4:
- case PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME5:
- case PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME6:
- case PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME7:
- case PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME8:
- case PHPExcel_Style_NumberFormat::FORMAT_DATE_YYYYMMDDSLASH:
- case PHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX14:
- case PHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX15:
- case PHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX16:
- case PHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX17:
- case PHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX22:
- return TRUE;
- }
-
- // Typically number, currency or accounting (or occasionally fraction) formats
- if ((substr($pFormatCode,0,1) == '_') || (substr($pFormatCode,0,2) == '0 ')) {
- return FALSE;
- }
- // Try checking for any of the date formatting characters that don't appear within square braces
- if (preg_match('/(^|\])[^\[]*['.self::$possibleDateFormatCharacters.']/i',$pFormatCode)) {
- // We might also have a format mask containing quoted strings...
- // we don't want to test for any of our characters within the quoted blocks
- if (strpos($pFormatCode,'"') !== FALSE) {
- $i = FALSE;
- foreach(explode('"',$pFormatCode) as $subVal) {
- // Only test in alternate array entries (the non-quoted blocks)
- if (($i = !$i) && (preg_match('/(^|\])[^\[]*['.self::$possibleDateFormatCharacters.']/i',$subVal))) {
- return TRUE;
- }
- }
- return FALSE;
- }
- return TRUE;
- }
-
- // No date...
- return FALSE;
- } // function isDateTimeFormatCode()
-
-
- /**
- * Convert a date/time string to Excel time
- *
- * @param string $dateValue Examples: '2009-12-31', '2009-12-31 15:59', '2009-12-31 15:59:10'
- * @return float|FALSE Excel date/time serial value
- */
- public static function stringToExcel($dateValue = '') {
- if (strlen($dateValue) < 2)
- return FALSE;
- if (!preg_match('/^(\d{1,4}[ \.\/\-][A-Z]{3,9}([ \.\/\-]\d{1,4})?|[A-Z]{3,9}[ \.\/\-]\d{1,4}([ \.\/\-]\d{1,4})?|\d{1,4}[ \.\/\-]\d{1,4}([ \.\/\-]\d{1,4})?)( \d{1,2}:\d{1,2}(:\d{1,2})?)?$/iu', $dateValue))
- return FALSE;
-
- $dateValueNew = PHPExcel_Calculation_DateTime::DATEVALUE($dateValue);
-
- if ($dateValueNew === PHPExcel_Calculation_Functions::VALUE()) {
- return FALSE;
- } else {
- if (strpos($dateValue, ':') !== FALSE) {
- $timeValue = PHPExcel_Calculation_DateTime::TIMEVALUE($dateValue);
- if ($timeValue === PHPExcel_Calculation_Functions::VALUE()) {
- return FALSE;
- }
- $dateValueNew += $timeValue;
- }
- return $dateValueNew;
- }
-
-
- }
-
-}
|