order_overview.php

Go to the documentation of this file.

<?php

    // DTAUS
    require_once "dtaus/class.DTAUS.php";

class Order_Overview extends oxAdminDetails
{
    public function render()
    {
        $myConfig = $this->getConfig();
        parent::render();

        $oOrder = oxNew( "oxorder" );

        $soxId = oxConfig::getParameter( "oxid");
        if ( $soxId != "-1" && isset( $soxId)) {
            // load object
            $oOrder->load( $soxId);

            $this->_aViewData["edit"]          = $oOrder;
            $this->_aViewData["orderArticles"] = $oOrder->getOrderArticles();
            $this->_aViewData["giftCard"]      = $oOrder->getGiftCard();
            $this->_aViewData["paymentType"]   = $this->getPaymentType( $oOrder );
            $this->_aViewData["deliveryType"]  = $oOrder->getDelSet();
        }

        // orders today
        $oLang = oxLang::getInstance();
        $oCur  = $myConfig->getActShopCurrencyObject();
        $dSum  = $oOrder->getOrderSum(true);
        $this->_aViewData["ordersum"] = $oLang->formatCurrency($dSum, $oCur);
        $this->_aViewData["ordercnt"] = $oOrder->getOrderCnt(true);

        // ALL orders
        $dSum = $oOrder->getOrderSum();
        $this->_aViewData["ordertotalsum"] = $oLang->formatCurrency( $dSum, $oCur);
        $this->_aViewData["ordertotalcnt"] = $oOrder->getOrderCnt();
        $this->_aViewData["afolder"] = $myConfig->getConfigParam( 'aOrderfolder' );
        $this->_aViewData["sfolder"] = $myConfig->getConfigParam( 'aOrderfolder' );
            $this->_aViewData["alangs"] = $oLang->getLanguageNames();


        $this->_aViewData["currency"] = $oCur;

        return "order_overview.tpl";
    }

    protected function getPaymentType( $oOrder )
    {
        if ( !( $oUserPayment = $oOrder->getPaymentType() ) && $oOrder->oxorder__oxpaymenttype->value ) {
                $oPayment = oxNew( "oxpayment" );
            if ( $oPayment->load( $oOrder->oxorder__oxpaymenttype->value ) ) {
                // in case due to security reasons payment info was not kept in db
                $oUserPayment = oxNew( "oxuserpayment" );
                $oUserPayment->oxpayments__oxdesc->value = $oPayment->oxpayments__oxdesc->value;
            }
        }

        return $oUserPayment;
    }

    public function exportlex()
    {
        $sOrderNr   = oxConfig::getParameter( "ordernr");
        $sToOrderNr = oxConfig::getParameter( "toordernr");

        $oImex = oxNew( "oximex" );
        $sLexware = $oImex->exportLexwareOrders( $sOrderNr, $sToOrderNr);

        if ( isset( $sLexware) && $sLexware) {
            header("Pragma: public");
            header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
            header("Expires: 0");
            header("Content-type: application/x-download");
            header('Content-Length: '.strlen($sLexware));
            header("Content-Disposition: attachment; filename=intern.xml");
            echo( $sLexware);
            exit();
        }
    }
    public function createPDF()
    {
        $soxId = oxConfig::getParameter( "oxid");
        if ( $soxId != "-1" && isset( $soxId)) {
            // load object
            $oOrder = oxNew( "oxorder" );
            $oOrder->load( $soxId);
            $sFilename = $oOrder->oxorder__oxordernr->value."_".$oOrder->oxorder__oxbilllname->value.".pdf";

            ob_start();
            $oOrder->genPDF( $sFilename, oxConfig::getParameter( "pdflanguage"));
            $sPDF = ob_get_contents();
            ob_end_clean();

            header("Pragma: public");
            header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
            header("Expires: 0");
            header("Content-type: application/pdf");
            header("Content-Disposition: attachment; filename=".$sFilename);
            echo( $sPDF);
            exit();
        }

    }

    public function exportDTAUS()
    {
        $iFromOrderNr = oxConfig::getParameter( "ordernr");

        $oOrderList = oxNew( "oxlist" );
        $oOrderList->init( "oxorder");
        $sSelect =  "select * from oxorder where oxpaymenttype = 'oxiddebitnote'";

        if ( isset( $iFromOrderNr) && $iFromOrderNr)
            $sSelect .= " and oxordernr >= $iFromOrderNr";

        $oOrderList->selectString( $sSelect);

        if ( !count( $oOrderList))
            return;

        $oPayment = oxNew( "oxuserpayment" );
        $oShop = $this->getConfig()->getActiveShop();
        $dtaus = new DTAUS("L", $oShop->oxshops__oxcompany->value, str_replace( " ", "", $oShop->oxshops__oxbankcode->value), str_replace( " ", "", $oShop->oxshops__oxbanknumber->value));

        $myUtils = oxUtils::getInstance();
        $myLang  = oxLang::getInstance();
        foreach ( $oOrderList as $oOrder) {
            $oPayment->load( $oOrder->oxorder__oxpaymentid->value);
            $aDynValues = $myUtils->assignValuesFromText( $oPayment->oxuserpayments__oxvalue->value );
            // #630
            //$dtaus->addTransaktion( $aDynValues[3]->value, str_replace( array(" ", "-"), "", $aDynValues[1]->value), str_replace( array(" ", "-"), "", $aDynValues[2]->value), str_replace( ",", ".",$oOrder->ftotalorder), $oShop->oxshops__oxname->getRawValue(), oxLang::getInstance()->translateString("order")." ".$oOrder->oxorder__oxordernr->value,"");
            $dtaus->addTransaktion( $aDynValues[3]->value, str_replace( " ", "", $aDynValues[1]->value), str_replace( " ", "", $aDynValues[2]->value), str_replace( ",", ".", $oOrder->ftotalorder), $oShop->oxshops__oxname->getRawValue(), $myLang->translateString("order")." ".$oOrder->oxorder__oxordernr->value, "");

        }

        header("Content-Disposition: attachment; filename=\"dtaus0.txt\"");
        header("Content-type: text/plain");
        header("Cache-control: public");

        echo(  $dtaus->create());
        exit();
    }

    public function sendorder()
    {
        $soxId  = oxConfig::getParameter( "oxid");
        $oOrder = oxNew( "oxorder" );
        $oOrder->load( $soxId);

        // #632A
        $timeout = oxUtilsDate::getInstance()->getTime(); //time();
        $now = date("Y-m-d H:i:s", $timeout);
        $oOrder->oxorder__oxsenddate->setValue($now);
        $oOrder->save();

        // #1071C
        $oOrderArticles = $oOrder->getOrderArticles();
        foreach ( $oOrderArticles as $oxid=>$oArticle) {
            // remove canceled articles from list
            if ( $oArticle->oxorderarticles__oxstorno->value == 1 )
                $oOrderArticles->offsetUnset($oxid);
        }

        $blMail  = oxConfig::getParameter( "sendmail");
        if ( isset( $blMail) && $blMail) {
            // send eMail
            $oxEMail = oxNew( "oxemail" );
            $oxEMail->sendSendedNowMail( $oOrder );
        }
    }

    public function resetorder()
    {
        $soxId  = oxConfig::getParameter( "oxid");
        $oOrder = oxNew( "oxorder" );
        $oOrder->load( $soxId);

        $oOrder->oxorder__oxsenddate->setValue("0000-00-00 00:00:00");
        $oOrder->save();
    }

    public function canExport()
    {
        //V #529: check if PDF invoice modul is active
        if ( oxUtilsObject::getInstance()->isModuleActive( 'oxorder', 'myorder' ) ) {
            $oDb = oxDb::getDb();
            $sOrderId = oxConfig::getParameter( "oxid" );
            $sTable = getViewName( "oxorderarticles" );
            $sQ = "select count(oxid) from {$sTable} where oxorderid = ".$oDb->quote( $sOrderId )." and oxstorno = 0";
            return (bool) $oDb->getOne( $sQ );
        }
        return false;
    }
}

---