Back to PhocacartParameter class

Method getParameterValues

public static
getParameterValues
(mixed $itemId, mixed $parameterId, mixed $select = 0)

Method getParameterValues - Source code

/*
 * PARAMETER VALUES (stored in products) Field PhocacartParameterValues
 */
public static function getParameterValues($itemId, $parameterId, $select = 0)
{
    $db = Factory::getDBO();
    if ($select == 1) {
        $query = 'SELECT r.parameter_value_id';
    } else {
        if ($select == 2) {
            $query = 'SELECT a.id, a.alias ';
        } else {
            $query = 'SELECT a.id, a.title, a.alias, a.type, a.display_format';
        }
    }
    $query .= ' FROM #__phocacart_parameter_values AS a' . ' LEFT JOIN #__phocacart_parameter_values_related AS r ON a.id = r.parameter_value_id' . ' LEFT JOIN #__phocacart_parameters AS p ON a.parameter_id = p.id' . ' WHERE r.item_id = ' . (int) $itemId . ' AND p.id = ' . (int) $parameterId . ' ORDER BY a.id';
    $db->setQuery($query);
    if ($select == 1) {
        $params = $db->loadColumn();
    } else {
        $params = $db->loadObjectList();
    }
    return $params;
}