list_order.php

Go to the documentation of this file.

<?php

class List_Order extends Order_List
{

    protected $_blDesc = false;

    public function getListSorting()
    {
        $aSort = oxRegistry::getConfig()->getRequestParameter('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
        oxRegistry::getSession()->setVariable('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);
    }
}