Back to PhocacartSpecification class

Method getSpecificationsById

public static
getSpecificationsById
(mixed $productId, mixed $return = 0)

Method getSpecificationsById - Source code

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