/** Function to get the Currency name from the vtiger_currency_info * @param $currencyid -- vtiger_currencyid:: Type integer * @returns $currencyname -- Currency Name:: Type varchar * */ function getCurrencyName($currencyid, $show_symbol = true) { global $log; $log->debug("Entering getCurrencyName(" . $currencyid . ") method ..."); // Look at cache first $currencyinfo = VTCacheUtils::lookupCurrencyInfo($currencyid); if ($currencyinfo === false) { global $adb; $sql1 = "select * from vtiger_currency_info where id= ?"; $result = $adb->pquery($sql1, array($currencyid)); $resultinfo = $adb->fetch_array($result); // Update cache VTCacheUtils::updateCurrencyInfo($currencyid, $resultinfo['currency_name'], $resultinfo['currency_code'], $resultinfo['currency_symbol'], $resultinfo['conversion_rate']); // Re-look at the cache now $currencyinfo = VTCacheUtils::lookupCurrencyInfo($currencyid); } $currencyname = $currencyinfo['name']; $curr_symbol = $currencyinfo['symbol']; $log->debug("Exiting getCurrencyName method ..."); if ($show_symbol) { return getTranslatedCurrencyString($currencyname) . ' : ' . $curr_symbol; } else { return $currencyname; } // NOTE: Without symbol the value could be used for filtering/lookup hence avoiding the translation }
function getCurrencyInfo($currencyid) { $currencyinfo = VTCacheUtils::lookupCurrencyInfo($currencyid); if ($currencyinfo === false) { global $adb; $sql1 = "select * from vtiger_currency_info where id= ?"; $result = $adb->pquery($sql1, array($currencyid)); $resultinfo = $adb->fetch_array($result); // Update cache VTCacheUtils::updateCurrencyInfo($currencyid, $resultinfo['currency_name'], $resultinfo['currency_code'], $resultinfo['currency_symbol'], $resultinfo['conversion_rate']); // Re-look at the cache now $currencyinfo = VTCacheUtils::lookupCurrencyInfo($currencyid); } return $currencyinfo; }