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;
}