Back to PhocacartGroup class

Method getProductPointGroupsById

public static
getProductPointGroupsById
(mixed $productId)

Method getProductPointGroupsById - Source code

public static function getProductPointGroupsById($productId)
{
    $db = Factory::getDBO();
    $query = 'SELECT a.id, a.product_id, a.group_id, a.points_received' . ' FROM #__phocacart_product_point_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;
}