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 $_sDefSort = 'oxactions.oxtitle';

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

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

        return $this->_sThisTemplate;
    }

    protected function _prepareWhereQuery( $aWhere, $sqlFull )
    {
        $sQ = parent::_prepareWhereQuery( $aWhere, $sqlFull );
        $sDisplayType = (int) oxConfig::getParameter( 'displaytype' );
        $sTable = getViewName( "oxactions" );

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

            $sNow   = date( 'Y-m-d H:i:s', oxUtilsDate::getInstance()->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;
    }
}