source/Application/Model/DeliveryList.php
public function loadDeliveryListForProduct($oProduct)
    {
        $oDb = \OxidEsales\Eshop\Core\DatabaseProvider::getDb();
        $dPrice = $oDb->quote($oProduct->getPrice()->getBruttoPrice());
        $dSize = $oDb->quote($oProduct->getSize());
        $dWeight = $oDb->quote($oProduct->getWeight());

        $sTable = getViewName('oxdelivery');

        $sQ = "select $sTable.* from $sTable";
        $sQ .= " where " . $this->getBaseObject()->getSqlActiveSnippet();
        $sQ .= " and ($sTable.oxdeltype != 'a' || ( $sTable.oxparam <= 1 && $sTable.oxparamend >= 1))";
        if ($dPrice) {
            $sQ .= " and ($sTable.oxdeltype != 'p' || ( $sTable.oxparam <= $dPrice && $sTable.oxparamend >= $dPrice))";
        }
        if ($dSize) {
            $sQ .= " and ($sTable.oxdeltype != 's' || ( $sTable.oxparam <= $dSize && $sTable.oxparamend >= $dSize))";
        }
        if ($dWeight) {
            $sQ .= " and ($sTable.oxdeltype != 'w' || ( $sTable.oxparam <= $dWeight && $sTable.oxparamend >= $dWeight))";
        }
        $this->selectString($sQ);
    }
public function loadDeliveryListForProduct($oProduct)
    {
        $oDb = \OxidEsales\Eshop\Core\DatabaseProvider::getDb();
        $dPrice = $oDb->quote($oProduct->getPrice()->getBruttoPrice());
        $dSize = $oDb->quote($oProduct->getSize());
        $dWeight = $oDb->quote($oProduct->getWeight());

        $sTable = getViewName('oxdelivery');

        $sQ = "select $sTable.* from $sTable";
        $sQ .= " where " . $this->getBaseObject()->getSqlActiveSnippet();
        $sQ .= " and ($sTable.oxdeltype != 'a' || ( $sTable.oxparam <= 1 && $sTable.oxparamend >= 1))";
        if ($dPrice) {
            $sQ .= " and ($sTable.oxdeltype != 'p' || ( $sTable.oxparam <= $dPrice && $sTable.oxparamend >= $dPrice))";
        }
        if ($dSize) {
            $sQ .= " and ($sTable.oxdeltype != 's' || ( $sTable.oxparam <= $dSize && $sTable.oxparamend >= $dSize))";
        }
        if ($dWeight) {
            $sQ .= " and ($sTable.oxdeltype != 'w' || ( $sTable.oxparam <= $dWeight && $sTable.oxparamend >= $dWeight))";
        }
        $this->selectString($sQ);
    }
public function loadDeliveryListForProduct ( $ oProduct ) { $ oDb = \ OxidEsales \ Eshop \ Core \ DatabaseProvider :: getDb ( ) ; $ dPrice = $ oDb -> quote ( $ oProduct -> getPrice ( ) -> getBruttoPrice ( ) ) ; $ dSize = $ oDb -> quote ( $ oProduct -> getSize ( ) ) ; $ dWeight = $ oDb -> quote ( $ oProduct -> getWeight ( ) ) ; $ sTable = getViewName ( 'oxdelivery' ) ; $ sQ = "select $sTable.* from $sTable" ; $ sQ .= " where " . $ this -> getBaseObject ( ) -> getSqlActiveSnippet ( ) ; $ sQ .= " and ($sTable.oxdeltype != 'a' || ( $sTable.oxparam <= 1 && $sTable.oxparamend >= 1))" ; if ( $ dPrice ) { $ sQ .= " and ($sTable.oxdeltype != 'p' || ( $sTable.oxparam <= $dPrice && $sTable.oxparamend >= $dPrice))" ; } if ( $ dSize ) { $ sQ .= " and ($sTable.oxdeltype != 's' || ( $sTable.oxparam <= $dSize && $sTable.oxparamend >= $dSize))" ; } if ( $ dWeight ) { $ sQ .= " and ($sTable.oxdeltype != 'w' || ( $sTable.oxparam <= $dWeight && $sTable.oxparamend >= $dWeight))" ; } $ this -> selectString ( $ sQ ) ; }
Load oxDeliveryList for product

@param object $oProduct oxArticle object
Load oxDeliveryList for product