Back to PhocacartAttribute class

Method getCombinationsStockByKey

public static
getCombinationsStockByKey
(mixed $productKey)

Method getCombinationsStockByKey - Source code

public static function getCombinationsStockByKey($productKey)
{
    $db = Factory::getDBO();
    $query = 'SELECT stock' . ' FROM #__phocacart_product_stock' . ' WHERE product_key = ' . $db->quote($productKey) . ' ORDER BY product_key' . ' LIMIT 1';
    $db->setQuery($query);
    $stock = $db->loadResult();
    if (isset($stock) && $stock > 0) {
        return $stock;
    }
    return 0;
}