pricealarm_list.php

Go to the documentation of this file.

<?php

class PriceAlarm_List extends oxAdminList
{
    protected $_sListClass = 'oxpricealarm';

    protected $_sDefSort = "oxpricealarm.oxuserid";

    protected function _buildSelectString( $oListObject = null )
    {
        $sSql  = "select oxpricealarm.*, oxarticles.oxtitle AS articletitle, ";
        $sSql .= "oxuser.oxlname as userlname, oxuser.oxfname as userfname ";
        $sSql .= "from oxpricealarm ";
        $sSql .= "left join oxarticles on oxarticles.oxid = oxpricealarm.oxartid ";
        $sSql .= "left join oxuser on oxuser.oxid = oxpricealarm.oxuserid WHERE 1 ";

        return $sSql;
    }

    public function render()
    {
        $myConfig = $this->getConfig();

        parent::render();


        $oDefCurr = $myConfig->getActShopCurrencyObject();
        $myUtils  = oxUtils::getInstance();
        $myLang   = oxLang::getInstance();

        foreach ( $this->_aViewData["mylist"] as $oListItem ) {

            $oArticle = oxNew( "oxarticle" );
            $oArticle->load($oListItem->oxpricealarm__oxartid->value);

            //$oListI = $this->_aViewData["mylist"][$sItemId];
            $oThisCurr = $myConfig->getCurrencyObject( $oListItem->oxpricealarm__oxcurrency->value );

            // #869A we should perform currency conversion
            // (older versions doesn't have currency info - assume as it is default - first in currency array)
            if ( !$oThisCurr ) {
                $oThisCurr = $myConfig->getCurrencyObject( $oDefCurr->name );
                $oListItem->oxpricealarm__oxcurrency->setValue($oDefCurr->name);
            }

            // #889C - Netto prices in Admin
            // (we have to call $oArticle->getPrice() to get price with VAT)
            $dArtPrice = $oArticle->getPrice()->getBruttoPrice() * $oThisCurr->rate;
            $dArtPrice = $myUtils->fRound( $dArtPrice );

            $oListItem->fprice = $myLang->formatCurrency( $dArtPrice, $oThisCurr );

            if ( $oArticle->oxarticles__oxparentid->value && !$oArticle->oxarticles__oxtitle->value) {
                $oParent = oxNew( "oxarticle" );
                $oParent->load($oArticle->oxarticles__oxparentid->value);
                $oListItem->oxpricealarm__articletitle = new oxField( $oParent->oxarticles__oxtitle->value." ".$oArticle->oxarticles__oxvarselect->value );
            }

            $oListItem->fpricealarmprice = $myLang->formatCurrency( $oListItem->oxpricealarm__oxprice->value, $oThisCurr);

            // neutral status
            $oListItem->iStatus = 0;

            // shop price is less or equal
            if ( $oListItem->oxpricealarm__oxprice->value >= $dArtPrice)
                $oListItem->iStatus = 1;

            // suggestion to user is sent
            if ( $oListItem->oxpricealarm__oxsended->value != "0000-00-00 00:00:00")
                $oListItem->iStatus = 2;
        }

        return "pricealarm_list.tpl";
    }

    public function buildWhere()
    {
        $this->_aWhere = parent::buildWhere();

        if ( !is_array($this->_aWhere))
            $this->_aWhere = array();

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

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

        return $this->_aWhere;
    }

}

---