order_list.php

Go to the documentation of this file.

<?php

class Order_List extends oxAdminList
{

    protected $_sListClass = 'oxorder';

    protected $_blDesc = true;

    protected $_sDefSortField = "oxorderdate";

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

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

        $aSearch = array('oxorderarticles' => 'ARTID', 'oxpayments' => 'PAYMENT');
        $sSearch = oxRegistry::getConfig()->getRequestParameter("addsearch");
        $sSearchfld = oxRegistry::getConfig()->getRequestParameter("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 = oxRegistry::getConfig()->getRequestParameter('folder');
        //searchong for empty oxfolder fields
        if ($sFolder && $sFolder != '-1') {
            $sQ .= " and ( oxorder.oxfolder = " . $oDb->quote($sFolder) . " )";
        } elseif (!$sFolder && is_array($aFolders)) {
            $aFolderNames = array_keys($aFolders);
            $sQ .= " and ( oxorder.oxfolder = " . $oDb->quote($aFolderNames[0]) . " )";
        }


        return $sQ;
    }

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

        $sSearch = oxRegistry::getConfig()->getRequestParameter('addsearch');
        $sSearch = trim($sSearch);
        $sSearchField = oxRegistry::getConfig()->getRequestParameter('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()
    {
        $oOrder = oxNew("oxorder");
        if ($oOrder->load($this->getEditObjectId())) {
            $oOrder->cancelOrder();
        }


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

    public function getListSorting()
    {
        $aSorting = parent::getListSorting();
        if (isset($aSorting["oxorder"]["oxbilllname"])) {
            $this->_blDesc = false;
        }

        return $aSorting;
    }
}