voucherserie_export.php

Go to the documentation of this file.

<?php

class VoucherSerie_Export extends oxAdminDetails
{
    public function render()
    {
        parent::render();

        $sFilepath = oxConfig::getParameter( "filepath" );
        if ( !isset( $sFilepath)) {
            $sFilepath = getShopBasePath();
            $sFilepath.= "export/oxexport.csv";
        }

        $this->_aViewData["filepath"] =  $sFilepath;
        return "voucherserie_export.tpl";
    }

    public function export()
    {
        $sFilepath = oxConfig::getParameter( "filepath");
        oxSession::setVar( "filepath", $sFilepath);

        $oSerie = oxNew( "oxvoucherserie" );
        $oSerie->load(oxConfig::getParameter("oxid"));

        $oDB = oxDb::getDb();

        $sSelect = "select oxvouchernr from oxvouchers where oxvoucherserieid = '" . $oSerie->oxvoucherseries__oxid->value . "'";
        $rs = $oDB->execute($sSelect);
        // if first, delete the file
        $fp = @fopen( $sFilepath, "w");
        if ( $fp) {
             fputs( $fp, "Gutschein\n");
            while (!$rs->EOF) {

                $sLine = "";

                foreach ( $rs->fields as $field)
                    $sLine .= $field/*.$myConfig->sCSVSign*/;
                $sLine .= "\n";

                fputs( $fp, $sLine);

                $rs->moveNext();
            }
            fclose( $fp);
            $this->_aViewData["exportCompleted"] = true;
        } else
            $this->_aViewData["exportCompleted"] =false;
    }
}

---