voucherserie_export.php

Go to the documentation of this file.

<?php

class VoucherSerie_Export extends VoucherSerie_Main
{
    public $sClassDo = "voucherserie_export";

    public $sExportFileType = "csv";

    protected $_sThisTemplate = "voucherserie_export.tpl";

    public $iExportPerTick = 1000;

    public function __construct()
    {
        parent::__construct();

        // export file name
        $this->sExportFileName = $this->_getExportFileName();

        // set generic frame template
        $this->_sFilePath = $this->_getExportFilePath();
    }

    public function getDownloadUrl()
    {
        $myConfig = $this->getConfig();

        // override cause of admin dir
        $sUrl = $myConfig->getConfigParam( 'sShopURL' ). $myConfig->getConfigParam( 'sAdminDir' );
        if ( $myConfig->getConfigParam( 'sAdminSSLURL' ) ) {
            $sUrl = $myConfig->getConfigParam( 'sAdminSSLURL' );
        }

        $sUrl = oxRegistry::get("oxUtilsUrl")->processUrl( $sUrl.'/index.php' );
        return $sUrl . '&amp;cl='.$this->sClassDo.'&amp;fnc=download';
    }

    protected function _getExportFileName()
    {
        $sSessionFileName = oxSession::getVar( "sExportFileName" );
        if ( !$sSessionFileName ) {
            $sSessionFileName = md5( $this->getSession()->getId() . oxUtilsObject::getInstance()->generateUId() );
            oxSession::setVar( "sExportFileName", $sSessionFileName );
        }
        return $sSessionFileName;
    }

    protected function _getExportFilePath()
    {
        return $this->getConfig()->getConfigParam( 'sShopDir' ) . "/export/". $this->_getExportFileName();
    }

    public function download()
    {
        $oUtils = oxRegistry::getUtils();
        $oUtils->setHeader( "Pragma: public" );
        $oUtils->setHeader( "Cache-Control: must-revalidate, post-check=0, pre-check=0" );
        $oUtils->setHeader( "Expires: 0" );
        $oUtils->setHeader( "Content-Disposition: attachment; filename=vouchers.csv");
        $oUtils->setHeader( "Content-Type: application/csv" );
        $sFile = $this->_getExportFilePath();
        if ( file_exists( $sFile ) && is_readable( $sFile ) ) {
            readfile( $sFile );
        }
        $oUtils->showMessageAndExit( "" );
    }

    public function run()
    {
        $blContinue = true;
        $iExportedItems = 0;

        $this->fpFile = @fopen( $this->_sFilePath, "a");
        if ( !isset( $this->fpFile) || !$this->fpFile) {
            // we do have an error !
            $this->stop( ERR_FILEIO);
        } else {
            // file is open
            $iStart = oxConfig::getParameter("iStart");
            if (!$iStart) {
                ftruncate($this->fpFile, 0);
            }

            if ( ( $iExportedItems = $this->exportVouchers( $iStart ) ) === false ) {
                // end reached
                $this->stop( ERR_SUCCESS );
                $blContinue = false;
            }

            if ( $blContinue ) {
                // make ticker continue
                $this->_aViewData['refresh']   = 0;
                $this->_aViewData['iStart']    = $iStart + $iExportedItems;
                $this->_aViewData['iExpItems'] = $iStart + $iExportedItems;
            }
            fclose( $this->fpFile);
        }
    }

    public function exportVouchers( $iStart )
    {
        $iExported = false;

        if ( $oSerie = $this->_getVoucherSerie() ) {

            $oDb = oxDb::getDb( oxDB::FETCH_MODE_ASSOC );

            $sSelect = "select oxvouchernr from oxvouchers where oxvoucherserieid = ".$oDb->quote( $oSerie->getId() );
            $rs = $oDb->selectLimit( $sSelect, $this->iExportPerTick, $iStart );

            if ( !$rs->EOF ) {
                $iExported = 0;

                // writing header text
                if ( $iStart == 0 ) {
                    $this->write( oxRegistry::getLang()->translateString("VOUCHERSERIE_MAIN_VOUCHERSTATISTICS", oxRegistry::getLang()->getTplLanguage(), true ));
                }
            }

            // writing vouchers..
            while ( !$rs->EOF ) {
                $this->write( current( $rs->fields ) );
                $iExported++;
                $rs->moveNext();
            }
        }

        return $iExported;
    }

    public function write( $sLine )
    {
        if ( $sLine ) {
           fwrite( $this->fpFile, $sLine."\n");
        }
    }
}