oxutilsdate.php

Go to the documentation of this file.

<?php

class oxUtilsDate extends oxSuperCfg
{
    private static $_instance = null;

    public static function getInstance()
    {
        return oxRegistry::get("oxUtilsDate");
    }

    public function formatDBDate( $sDBDateIn, $blForceEnglishRet = false )
    {
        // convert english format to output format
        if ( !$sDBDateIn ) {
            return null;
        }

        $oStr = getStr();
        if ( $blForceEnglishRet && $oStr->strstr( $sDBDateIn, '-' ) ) {
            return $sDBDateIn;
        }

        if ( $this->isEmptyDate( $sDBDateIn ) && $sDBDateIn != '-' ) {
            return '-';
        } elseif ( $sDBDateIn == '-' ) {
            return '0000-00-00 00:00:00';
        }

        // is it a timestamp ?
        if ( is_numeric( $sDBDateIn ) ) {
            // db timestamp : 20030322100409
            $sNew  = substr( $sDBDateIn, 0, 4 ).'-'.substr( $sDBDateIn, 4, 2 ).'-'.substr( $sDBDateIn, 6, 2 ).' ';
            // check if it is a timestamp or wrong data: 20030322
            if ( strlen($sDBDateIn) > 8 ) {
                $sNew .= substr( $sDBDateIn, 8, 2 ).':'.substr( $sDBDateIn, 10, 2 ).':'.substr( $sDBDateIn, 12, 2 );
            }
            // convert it to english format
            $sDBDateIn = $sNew;
        }

        // remove time as it is same in english as in german
        $aData = explode( ' ', trim( $sDBDateIn ) );

        // preparing time array
        $sTime = ( isset( $aData[1] ) && $oStr->strstr( $aData[1], ':' ) )?$aData[1]:'';
        $aTime = $sTime?explode( ':', $sTime ):array( 0, 0, 0 );

        // preparind date array
        $sDate = isset( $aData[0] )?$aData[0]:'';
        $aDate = preg_split( '/[\/.-]/', $sDate );

        // choosing format..
        if ( $sTime ) {
            $sFormat = $blForceEnglishRet ? 'Y-m-d H:i:s' : oxRegistry::getLang()->translateString( 'fullDateFormat' );
        } else {
            $sFormat = $blForceEnglishRet ? 'Y-m-d' : oxRegistry::getLang()->translateString( 'simpleDateFormat' );
        }

        if ( count( $aDate ) != 3 ) {
            return date( $sFormat );
        } else {
            return $this->_processDate( $aTime, $aDate, $oStr->strstr( $sDate, '.' ), $sFormat );
        }
    }

    public function getTime()
    {
        $iServerTimeShift = $this->getConfig()->getConfigParam( 'iServerTimeShift' );
        if ( !$iServerTimeShift ) {
            return time();
        }

        return ( time() + ( (int) $iServerTimeShift * 3600 ) );
    }

    public function getWeekNumber( $iFirstWeekDay,  $sTimestamp = null, $sFormat = null )
    {
        if ( $sTimestamp == null ) {
            $sTimestamp = time();
        }
        if ( $sFormat == null ) {
            $sFormat = '%W';
            if ( $iFirstWeekDay ) {
                $sFormat = '%U';
            }
        }
        return (int) strftime( $sFormat, $sTimestamp );
    }

    public function german2English( $sDate )
    {
        $aDate = explode( ".", $sDate);

        if ( isset( $aDate ) && count( $aDate) > 1) {
            if ( count( $aDate) == 2) {
                $sDate = $aDate[1]."-".$aDate[0];
            } else {
                $sDate = $aDate[2]."-".$aDate[1]."-".$aDate[0];
            }
        }

        return $sDate;
    }

    protected function _processDate( $aTime, $aDate, $blGerman, $sFormat )
    {
        if ( $blGerman ) {
            return date( $sFormat, mktime( $aTime[0], $aTime[1], $aTime[2], $aDate[1], $aDate[0], $aDate[2] ) );
        } else {
            return date( $sFormat, mktime( $aTime[0], $aTime[1], $aTime[2], $aDate[1], $aDate[2], $aDate[0] ) );
        }
    }

    public function isEmptyDate( $sDate )
    {
        $blIsEmpty = true;

        if ( !empty( $sDate ) ) {
            $sDate = preg_replace("/[^0-9a-z]/i", "", $sDate);
            if ( is_numeric( $sDate ) && $sDate == 0 ) {
                $blIsEmpty = true;
            } else {
                $blIsEmpty = false;
            }
        }

        return $blIsEmpty;
    }

}