actions_list.php

Go to the documentation of this file.

<?php

class Actions_List extends oxAdminList
{

    protected $_sThisTemplate = 'actions_list.tpl';

    protected $_sListClass = 'oxactions';

    protected $_sDefSortField = 'oxtitle';

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

        // passing display type back to view
        $this->_aViewData["displaytype"] = oxRegistry::getConfig()->getRequestParameter("displaytype");

        return $this->_sThisTemplate;
    }

    protected function _prepareWhereQuery($aWhere, $sqlFull)
    {
        $sQ = parent::_prepareWhereQuery($aWhere, $sqlFull);
        $sDisplayType = (int) oxRegistry::getConfig()->getRequestParameter('displaytype');
        $sTable = getViewName("oxactions");

        //searchong for empty oxfolder fields
        if ($sDisplayType) {

            $sNow = date('Y-m-d H:i:s', oxRegistry::get("oxUtilsDate")->getTime());

            switch ($sDisplayType) {
                case 1: // active
                    $sQ .= " and {$sTable}.oxactivefrom < '{$sNow}' and {$sTable}.oxactiveto > '{$sNow}' ";
                    break;
                case 2: // upcoming
                    $sQ .= " and {$sTable}.oxactivefrom > '{$sNow}' ";
                    break;
                case 3: // expired
                    $sQ .= " and {$sTable}.oxactiveto < '{$sNow}' and {$sTable}.oxactiveto != '0000-00-00 00:00:00' ";
                    break;
            }
        }


        return $sQ;
    }
}