list_order.php

Go to the documentation of this file.

<?php

class List_Order extends oxAdminList
{
    public function render()
    {
        $this->_oList = oxNew( "oxlist", "core" );
        $this->_oList->setSqlLimit( 0, 5000 );
        $this->_oList->init( "oxbase", "oxorder" );

        $aWhere = $this->buildWhere();

        $sSql = $this->_buildSelectString( $this->_oList->getBaseObject() );
        $sSql = $this->_prepareWhereQuery( $aWhere, $sSql );

        // 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 = $this->_prepareOrderByQuery( $sSql );
        $sSql = $this->_changeselect( $sSql );
        $this->_oList->selectString( $sSql );

        parent::render();

        $aWhere = oxConfig::getParameter( "where");
        if ( is_array( $aWhere ) ) {
            foreach ( $aWhere as $sField => $sValue ) {
                $this->_aViewData["where"]->{str_replace( '.', '__', $sField )} = $sValue;
            }
        }

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

        return "list_order.tpl";
    }

    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 )
    {
        $sSql = " $sSql group by oxorderarticles.oxartnum";
        if ( $sSort = oxConfig::getParameter( "sort" ) ) {
            $sSortDesc = ($sSort == 'oxorder.oxorderdate') ? 'DESC' : '';
            $sSql .= " order by $sSort " . $sSortDesc;
        }

        return $sSql;
    }
}

---