list_order.php

Go to the documentation of this file.

<?php

class List_Order extends Order_List
{
    protected $_blDesc = false;

    public function getListSorting()
    {
        $aSort = oxConfig::getParameter( 'sort' );
        if ( $this->_aCurrSorting === null && isset( $aSort[0]['oxorderdate'] ) ) {
            $this->_aCurrSorting[]["max(oxorder.oxorderdate)"] = "desc";
            return $this->_aCurrSorting;
        } else {
            return parent::getListSorting();
        }
    }

    protected function _getViewListSize()
    {
        return $this->_getUserDefListSize();
    }

    public function render()
    {
        oxAdminList::render();

        $this->_aViewData["menustructure"] = $this->getNavigation()->getDomXml()->documentElement->childNodes;

        return "list_order.tpl";
    }


    public function _prepareWhereQuery( $aWhere, $sqlFull )
    {
        $sQ  = oxAdminList::_prepareWhereQuery( $aWhere, $sqlFull );
        $sQ .= " group by oxorderarticles.oxartnum";
        return $sQ;
    }

    protected function _calcListItemsCount( $sSql )
    {
        $oStr = getStr();

        // count SQL
        $sSql = $oStr->preg_replace( '/select .* from/', 'select count(*) from ', $sSql );

        // removing order by
        $sSql = $oStr->preg_replace( '/order by .*$/', '', $sSql );

        // con of list items which fits current search conditions
        $this->_iListSize = oxDb::getDb()->getOne( "select count(*) from ( $sSql ) as test", false, false );

        // set it into session that other frames know about size of DB
        oxSession::setVar( 'iArtCnt', $this->_iListSize );
    }

    protected function _buildSelectString( $oObject = null )
    {
        return 'select oxorderarticles.oxid, oxorder.oxid as oxorderid, max(oxorder.oxorderdate) as oxorderdate, oxorderarticles.oxartnum, sum( oxorderarticles.oxamount ) as oxorderamount, oxorderarticles.oxtitle, round( sum(oxorderarticles.oxbrutprice*oxorder.oxcurrate),2) as oxprice from oxorderarticles left join oxorder on oxorder.oxid=oxorderarticles.oxorderid where 1 ';
    }

    protected function _prepareOrderByQuery( $sSql = null )
    {
        // calculating sum
        $sSumQ = getStr()->preg_replace( array( "/select .*? from/", "/group by oxorderarticles.oxartnum/" ), array( "select round( sum(oxorderarticles.oxbrutprice*oxorder.oxcurrate),2) from", "" ), $sSql );
        $this->_aViewData["sumresult"] = oxDb::getDb()->getOne( $sSumQ, false, false );
        return parent::_prepareOrderByQuery( $sSql );
    }
}