list_order.php

Go to the documentation of this file.

<?php

class List_Order extends Order_List
{
    protected function _getViewListSize()
    {
        return $this->_getUserDefListSize();
    }

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

        $this->_aViewData["viewListSize"]  = $this->_getViewListSize();
        $this->_aViewData["whereparam"]    = $this->_aViewData["whereparam"] . '&amp;viewListSize='.$this->_getViewListSize();
        $this->_aViewData["menustructure"] = $this->getNavigation()->getDomXml()->documentElement->childNodes;

        return "list_order.tpl";
    }


    public function _prepareWhereQuery( $aWhere, $sqlFull )
    {
        return oxAdminList::_prepareWhereQuery( $aWhere, $sqlFull );
    }

    protected function _calcListItemsCount( $sSql )
    {
        // count SQL
        $sSql = preg_replace( '/select .* from/', 'select count(*) from ', $sSql );

        // removing order by
        $sSql = 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" );

        // 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 = preg_replace("/select .*? from/", "select round( sum(oxorderarticles.oxbrutprice*oxorder.oxcurrate),2) from", $sSql );
        $this->_aViewData["sumresult"] = oxDb::getDb()->getOne( $sSumQ );

        $sSql = " $sSql group by oxorderarticles.oxartnum";
        if ( $sSort = oxConfig::getParameter( "sort" ) ) {
            if ($sSort == 'oxorder.oxorderdate') {
                $sSql .= " order by max(oxorder.oxorderdate) DESC";
            } else {
                $sSql .= " order by " . oxDb::getInstance()->escapeString( $sSort );
            }
        }
        return $sSql;
    }
}