order_list.php

Go to the documentation of this file.

<?php

class Order_List extends oxAdminList
{
    protected $_sListClass = 'oxorder';

    protected $_blDesc = true;

    protected $_sDefSort = "oxorder.oxorderdate";

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

        $aFolders = $this->getConfig()->getConfigParam( 'aOrderfolder' );
        $sFolder  = oxConfig::getParameter( "folder" );
        // first display new orders
        if ( !$sFolder && is_array( $aFolders )) {
            $aNames = array_keys( $aFolders );
            $sFolder = $aNames[0];
        }

        $aSearch    = array( 'oxorderarticles' => 'ARTID', 'oxpayments' => 'PAYMENT');
        $sSearch    = oxConfig::getParameter( "addsearch" );
        $sSearchfld = oxConfig::getParameter( "addsearchfld" );

        $this->_aViewData["folder"]       = $sFolder ? $sFolder : -1;
        $this->_aViewData["addsearchfld"] = $sSearchfld ? $sSearchfld : -1;
        $this->_aViewData["asearch"]      = $aSearch;
        $this->_aViewData["addsearch"]    = $sSearch;
        $this->_aViewData["afolder"]      = $aFolders;

        return "order_list.tpl";
    }

    protected function _prepareWhereQuery( $aWhere, $sqlFull )
    {
        $oDb = oxDb::getDb();
        $sQ = parent::_prepareWhereQuery( $aWhere, $sqlFull );
        $myConfig = $this->getConfig();
        $aFolders = $myConfig->getConfigParam( 'aOrderfolder' );
        $sFolder = oxConfig::getParameter( 'folder' );
        //searchong for empty oxfolder fields
        if ( $sFolder && $sFolder != '-1' ) {
            $sQ .= " and ( oxorder.oxfolder = ".$oDb->quote( $sFolder )." ";
            //deprecated check for old orders
            $sQ .= "or oxorder.oxfolder = ".$oDb->quote( oxLang::getInstance()->translateString( $sFolder ) )." )";
        } elseif ( !$sFolder && is_array( $aFolders ) ) {
            $aFolderNames = array_keys( $aFolders );
            $sQ .= " and ( oxorder.oxfolder = ".$oDb->quote( $aFolderNames[0] )." ";
            //deprecated check for old orders
            $sQ .= "or oxorder.oxfolder = ".$oDb->quote( oxLang::getInstance()->translateString($aFolderNames[0] ) )." )";
        }

        return $sQ;
    }

    protected function _buildSelectString( $oListObject = null )
    {
        $sSql = parent::_buildSelectString( $oListObject );
        $oDb = oxDb::getDb();

        $sSearch      = oxConfig::getParameter( 'addsearch' );
        $sSearch      = trim( $sSearch );
        $sSearchField = oxConfig::getParameter( 'addsearchfld' );

        if ( $sSearch ) {
            switch ( $sSearchField ) {
            case 'oxorderarticles':
                $sQ = "oxorder left join oxorderarticles on oxorderarticles.oxorderid=oxorder.oxid where ( oxorderarticles.oxartnum like ".$oDb->quote( "%{$sSearch}%" ) ." or oxorderarticles.oxtitle like ".$oDb->quote( "%{$sSearch}%" )." ) and ";
                break;
            case 'oxpayments':
                $sQ = "oxorder left join oxpayments on oxpayments.oxid=oxorder.oxpaymenttype where oxpayments.oxdesc like ".$oDb->quote( "%{$sSearch}%" ) ." and ";
                break;
            default:
                $sQ = "oxorder where oxorder.oxpaid like ".$oDb->quote( "%{$sSearch}%" )." and ";
                break;
            }
            $sSql = str_replace( 'oxorder where', $sQ, $sSql);
        }

        return $sSql;
    }

    public function storno()
    {
        $myConfig = $this->getConfig();
        $soxId    = oxConfig::getParameter( "oxid");

        $oOrder = oxNew( "oxorder" );
        if ( $oOrder->load( $soxId ) ) {
            $oOrder->cancelOrder();
        }


        //we call init() here to load list items after sorno()
        $this->init();
    }

    protected function _prepareOrderByQuery( $sSql = null )
    {
        $sSortParam = oxConfig::getParameter( 'sort' );
        //setting sort order as ASC for oxbilllname column
        if ( $sSortParam && $sSortParam == 'oxorder.oxbilllname' ) {
           $this->_blDesc = false;
        }

        return parent::_prepareOrderByQuery( $sSql );
    }
}