function customSortingSQL($params) { $multipriceTableAlias = "mp"; if (isset($params['table_alias_suffix'])) { $multipriceTableAlias .= $params['table_alias_suffix']; } $sql = array('from' => '', 'where' => '', 'sorting_field' => ''); $sql['from'] = "ezmultipricedata {$multipriceTableAlias}"; $and = ''; if (isset($params['contentobject_attr_id'])) { $sql['where'] = "\n {$multipriceTableAlias}.contentobject_attr_id = {$params['contentobject_attr_id']}"; $and = ' AND'; } if (isset($params['contentobject_attr_version'])) { $sql['where'] .= "\n {$and} {$multipriceTableAlias}.contentobject_attr_version = {$params['contentobject_attr_version']}"; $and = ' AND'; } if (!isset($params['currency_code'])) { $params['currency_code'] = eZShopFunctions::preferredCurrencyCode(); } if ($params['currency_code'] !== false) { $sql['where'] .= "\n {$and} {$multipriceTableAlias}.currency_code = '{$params['currency_code']}'"; $and = ' AND'; } $sql['sorting_field'] = "{$multipriceTableAlias}.value"; return $sql; }
function fetchPreferredCurrencyCode() { $currency = eZShopFunctions::preferredCurrencyCode(); $result = array( 'result' => $currency ); return $result; }
static function isPreferredCurrencyValid($currencyCode = false) { $error = eZError::SHOP_OK; if ($currencyCode === false) { $currencyCode = eZShopFunctions::preferredCurrencyCode(); } $currency = eZCurrencyData::fetch($currencyCode); if ($currency) { if (!$currency->isActive()) { $error = eZError::SHOP_PREFERRED_CURRENCY_INACTIVE; eZDebug::writeWarning("Currency '{$currencyCode}' is inactive.", __METHOD__); } } else { $error = eZError::SHOP_PREFERRED_CURRENCY_DOESNOT_EXIST; eZDebug::writeWarning("Currency '{$currencyCode}' doesn't exist", __METHOD__); } return $error; }
function preferredCurrencyCode() { return eZShopFunctions::preferredCurrencyCode(); }