public static function getSpecificationsById($productId, $return = 0)
{
$db = Factory::getDBO();
$query = 'SELECT a.id, a.title, a.alias, a.value, a.alias_value, a.group_id, a.image, a.image_medium, a.image_small, a.color' . ' FROM #__phocacart_specifications AS a' . ' WHERE a.product_id = ' . (int) $productId . ' ORDER BY a.ordering';
$db->setQuery($query);
if ($return == 0) {
return $db->loadObjectList();
} else {
if ($return == 1) {
return $db->loadAssocList();
} else {
$specifications = $db->loadAssocList();
$specificationsSubform = array();
$i = 0;
if (!empty($specifications)) {
foreach ($specifications as $k => $v) {
$specificationsSubform['specifications' . $i]['id'] = (int) $v['id'];
$specificationsSubform['specifications' . $i]['title'] = (string) $v['title'];
$specificationsSubform['specifications' . $i]['alias'] = (string) $v['alias'];
$specificationsSubform['specifications' . $i]['value'] = (string) $v['value'];
$specificationsSubform['specifications' . $i]['alias_value'] = (string) $v['alias_value'];
$specificationsSubform['specifications' . $i]['group_id'] = (int) $v['group_id'];
$specificationsSubform['specifications' . $i]['image'] = (string) $v['image'];
$specificationsSubform['specifications' . $i]['image_medium'] = (string) $v['image_medium'];
$specificationsSubform['specifications' . $i]['image_small'] = (string) $v['image_small'];
$specificationsSubform['specifications' . $i]['color'] = (string) $v['color'];
$i++;
}
}
return $specifications;
}
}
return false;
}