pricealarm_list.php

Go to the documentation of this file.

<?php

class PriceAlarm_List extends oxAdminList
{
    protected $_sThisTemplate = 'pricealarm_list.tpl';

    protected $_sListClass = 'oxpricealarm';

    protected $_sDefSortField = "oxuserid";

    protected function _buildSelectString( $oListObject = null )
    {
        $sViewName = getViewName( "oxarticles", (int) $this->getConfig()->getConfigParam( "sDefaultLang" ) );
        $sSql  = "select oxpricealarm.*, {$sViewName}.oxtitle AS articletitle, ";
        $sSql .= "oxuser.oxlname as userlname, oxuser.oxfname as userfname ";
        $sSql .= "from oxpricealarm left join {$sViewName} on {$sViewName}.oxid = oxpricealarm.oxartid ";
        $sSql .= "left join oxuser on oxuser.oxid = oxpricealarm.oxuserid WHERE 1 ";

        return $sSql;
    }

    public function buildWhere()
    {
        $this->_aWhere = parent::buildWhere();
        $sViewName = getViewName( "oxpricealarm" );
        $sArtViewName = getViewName( "oxarticles" );

        // updating price fields values for correct search in DB
        if ( isset( $this->_aWhere[$sViewName.'.oxprice'] ) ) {
            $sPriceParam = (double) str_replace( array( '%', ',' ), array( '', '.' ), $this->_aWhere[$sViewName.'.oxprice'] );
            $this->_aWhere[$sViewName.'.oxprice'] = '%'. $sPriceParam. '%';
        }

        if ( isset( $this->_aWhere[$sArtViewName.'.oxprice'] ) ) {
            $sPriceParam = (double) str_replace( array( '%', ',' ), array( '', '.' ), $this->_aWhere[$sArtViewName.'.oxprice'] );
            $this->_aWhere[$sArtViewName.'.oxprice'] = '%'. $sPriceParam. '%';
        }


        return $this->_aWhere;
    }

}