Back to PhocacartGroup class

Method getProductPriceGroupsById

public static
getProductPriceGroupsById
(mixed $productId)

Method getProductPriceGroupsById - Source code

// Group prices and points
public static function getProductPriceGroupsById($productId)
{
    $db = Factory::getDBO();
    $query = 'SELECT a.id, a.product_id, a.group_id, a.price' . ' FROM #__phocacart_product_price_groups AS a' . ' WHERE a.product_id = ' . (int) $productId . ' ORDER BY a.id';
    $db->setQuery($query);
    $items = $db->loadAssocList();
    $itemsNew = array();
    if (!empty($items)) {
        foreach ($items as $k => $v) {
            $newK = $v['group_id'];
            $itemsNew[$newK] = $v;
        }
    }
    return $itemsNew;
}