source/Application/Model/ArticleList.php
public function loadStockRemindProducts($aBasketContents)
    {
        if (is_array($aBasketContents) && count($aBasketContents)) {
            $oDb = \OxidEsales\Eshop\Core\DatabaseProvider::getDb();
            foreach ($aBasketContents as $oBasketItem) {
                $aArtIds[] = $oDb->quote($oBasketItem->getProductId());
            }

            $oBaseObject = $this->getBaseObject();

            $sFieldNames = $oBaseObject->getSelectFields();
            $sTable = $oBaseObject->getViewName();

            // fetching actual db stock state and reminder status
            $sQ = "select {$sFieldNames} from {$sTable} where {$sTable}.oxid in ( " . implode(",", $aArtIds) . " ) and
                          oxremindactive = '1' and oxstock <= oxremindamount";
            $this->selectString($sQ);

            // updating stock reminder state
            if ($this->count()) {
                $sQ = "update {$sTable} set oxremindactive = '2' where {$sTable}.oxid in ( " . implode(",", $aArtIds) . " ) and
                              oxremindactive = '1' and oxstock <= oxremindamount";
                $oDb->execute($sQ);
            }
        }
    }
public function loadStockRemindProducts($aBasketContents)
    {
        if (is_array($aBasketContents) && count($aBasketContents)) {
            $oDb = \OxidEsales\Eshop\Core\DatabaseProvider::getDb();
            foreach ($aBasketContents as $oBasketItem) {
                $aArtIds[] = $oDb->quote($oBasketItem->getProductId());
            }

            $oBaseObject = $this->getBaseObject();

            $sFieldNames = $oBaseObject->getSelectFields();
            $sTable = $oBaseObject->getViewName();

            // fetching actual db stock state and reminder status
            $sQ = "select {$sFieldNames} from {$sTable} where {$sTable}.oxid in ( " . implode(",", $aArtIds) . " ) and
                          oxremindactive = '1' and oxstock <= oxremindamount";
            $this->selectString($sQ);

            // updating stock reminder state
            if ($this->count()) {
                $sQ = "update {$sTable} set oxremindactive = '2' where {$sTable}.oxid in ( " . implode(",", $aArtIds) . " ) and
                              oxremindactive = '1' and oxstock <= oxremindamount";
                $oDb->execute($sQ);
            }
        }
    }
public function loadStockRemindProducts ( $ aBasketContents ) { if ( is_array ( $ aBasketContents ) && count ( $ aBasketContents ) ) { $ oDb = \ OxidEsales \ Eshop \ Core \ DatabaseProvider :: getDb ( ) ; foreach ( $ aBasketContents as $ oBasketItem ) { $ aArtIds [ ] = $ oDb -> quote ( $ oBasketItem -> getProductId ( ) ) ; } $ oBaseObject = $ this -> getBaseObject ( ) ; $ sFieldNames = $ oBaseObject -> getSelectFields ( ) ; $ sTable = $ oBaseObject -> getViewName ( ) ; // fetching actual db stock state and reminder status $ sQ = "select {$sFieldNames} from {$sTable} where {$sTable}.oxid in ( " . implode ( "," , $ aArtIds ) . " ) and
                          oxremindactive = '1' and oxstock <= oxremindamount" ; $ this -> selectString ( $ sQ ) ; // updating stock reminder state if ( $ this -> count ( ) ) { $ sQ = "update {$sTable} set oxremindactive = '2' where {$sTable}.oxid in ( " . implode ( "," , $ aArtIds ) . " ) and
                              oxremindactive = '1' and oxstock <= oxremindamount" ; $ oDb -> execute ( $ sQ ) ; } } }
Loads list of low stock state products

@param array $aBasketContents product ids array
Loads list of low stock state products