order_overview.php

Go to the documentation of this file.

<?php

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

        $oOrder = oxNew( "oxorder" );
        $oCur  = $myConfig->getActShopCurrencyObject();
        $oLang = oxLang::getInstance();

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

            $this->_aViewData["edit"]          = $oOrder;
            $this->_aViewData["aProductVats"]  = $oOrder->getProductVats();
            $this->_aViewData["orderArticles"] = $oOrder->getOrderArticles();
            $this->_aViewData["giftCard"]      = $oOrder->getGiftCard();
            $this->_aViewData["paymentType"]   = $this->_getPaymentType( $oOrder );
            $this->_aViewData["deliveryType"]  = $oOrder->getDelSet();
            if ( $oOrder->oxorder__oxtsprotectcosts->value ) {
                $this->_aViewData["tsprotectcosts"]  = $oLang->formatCurrency( $oOrder->oxorder__oxtsprotectcosts->value, $oCur);
            }
        }

        // orders today
        $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 = new oxField( $oPayment->oxpayments__oxdesc->value );
            }
        }

        return $oUserPayment;
    }

    public function exportlex()
    {
        $sOrderNr   = oxConfig::getParameter( "ordernr");
        $sToOrderNr = oxConfig::getParameter( "toordernr");
        $oImex = oxNew( "oximex" );
        if ( ( $sLexware = $oImex->exportLexwareOrders( $sOrderNr, $sToOrderNr ) ) ) {
            $oUtils = oxUtils::getInstance();
            $oUtils->setHeader( "Pragma: public" );
            $oUtils->setHeader( "Cache-Control: must-revalidate, post-check=0, pre-check=0" );
            $oUtils->setHeader( "Expires: 0" );
            $oUtils->setHeader( "Content-type: application/x-download" );
            $oUtils->setHeader( "Content-Length: ".strlen( $sLexware ) );
            $oUtils->setHeader( "Content-Disposition: attachment; filename=intern.xml" );
            $oUtils->showMessageAndExit( $sLexware );
        }
    }
    public function createPDF()
    {
        $soxId = oxConfig::getParameter( "oxid" );
        if ( $soxId != "-1" && isset( $soxId ) ) {
            // load object
            $oOrder = oxNew( "oxorder" );
            if ( $oOrder->load( $soxId ) ) {
                $oUtils = oxUtils::getInstance();
                $sFilename = $oOrder->oxorder__oxordernr->value . "_" . $oOrder->oxorder__oxbilllname->getRawValue() . ".pdf";

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

                $oUtils->setHeader( "Pragma: public" );
                $oUtils->setHeader( "Cache-Control: must-revalidate, post-check=0, pre-check=0" );
                $oUtils->setHeader( "Expires: 0" );
                $oUtils->setHeader( "Content-type: application/pdf" );
                $oUtils->setHeader( "Content-Disposition: attachment; filename=".$sFilename );
                oxUtils::getInstance()->showMessageAndExit( $sPDF );
            }
        }
    }

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

        if ( ( $iFromOrderNr = oxConfig::getParameter( "ordernr") ) ) {
            $sSelect .= " and oxordernr >= $iFromOrderNr";
        }

        $oOrderList->selectString( $sSelect );
        if ( count( $oOrderList ) ) {
            $oUserPayment = oxNew( "oxuserpayment" );
            $oUtils = oxUtils::getInstance();
            $oShop  = $this->getConfig()->getActiveShop();

            $sCompany   = $oShop->oxshops__oxcompany->value;
            $sRoutingNr = $this->_cleanup( $oShop->oxshops__oxbankcode->value ) + 1 - 1;
            $sAccountNr = $this->_cleanup( $oShop->oxshops__oxbanknumber->value );
            $sSubject   = oxLang::getInstance()->translateString( "order" );

            // can't be called with oxnew, as it only supports single constructor parameter
            $oDtaus = oxNew( "oxDtausBuilder", $sCompany, $sRoutingNr, $sAccountNr );
            foreach ( $oOrderList as $oOrder ) {
                $oUserPayment->load( $oOrder->oxorder__oxpaymentid->value );
                $aDynValues = $oUtils->assignValuesFromText( $oUserPayment->oxuserpayments__oxvalue->value );

                $sCustName  = $aDynValues[3]->value;
                $sRoutingNr = $this->_cleanup( $aDynValues[1]->value );
                $sAccountNr = $this->_cleanup( $aDynValues[2]->value );

                $oDtaus->add( $sCustName, $sRoutingNr, $sAccountNr, $oOrder->getTotalOrderSum(), array( $oShop->oxshops__oxname->getRawValue(), $sSubject . " " . $oOrder->oxorder__oxordernr->value ) );
            }

            $oUtils->setHeader( "Content-Disposition: attachment; filename=\"dtaus0.txt\"" );
            $oUtils->setHeader( "Content-type: text/plain" );
            $oUtils->setHeader( "Cache-control: public" );
            $oUtils->showMessageAndExit( $oDtaus->create() );
        }
    }

    protected function _cleanup( $sValue )
    {
        return str_replace( " ", "", $sValue );
    }

    public function sendorder()
    {
        $oOrder = oxNew( "oxorder" );
        if ( $oOrder->load( oxConfig::getParameter( "oxid" ) ) ) {
            $oOrder->oxorder__oxsenddate->setValue( date( "Y-m-d H:i:s", oxUtilsDate::getInstance()->getTime() ) );
            $oOrder->save();

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

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

    public function resetorder()
    {
        $oOrder = oxNew( "oxorder" );
        if ( $oOrder->load( oxConfig::getParameter( "oxid" ) ) ) {
            $oOrder->oxorder__oxsenddate->setValue( "0000-00-00 00:00:00" );
            $oOrder->save();
        }
    }

    public function canExport()
    {
        $blCan = false;
        //V #529: check if PDF invoice module 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";
            $blCan = (bool) $oDb->getOne( $sQ );
        }
        return $blCan;
    }
}