304 lines
12 KiB
PHP
304 lines
12 KiB
PHP
<?php
|
|
/*
|
|
+--------------------------------------------------------------------------
|
|
| CubeCart 4
|
|
| ========================================
|
|
| CubeCart is a registered trade mark of Devellion Limited
|
|
| Copyright Devellion Limited 2006. All rights reserved.
|
|
| Devellion Limited,
|
|
| 5 Bridge Street,
|
|
| Bishops Stortford,
|
|
| HERTFORDSHIRE.
|
|
| CM23 2JU
|
|
| UNITED KINGDOM
|
|
| http://www.devellion.com
|
|
| UK Private Limited Company No. 5323904
|
|
| ========================================
|
|
| Web: http://www.cubecart.com
|
|
| Email: info (at) cubecart (dot) com
|
|
| License Type: CubeCart is NOT Open Source Software and Limitations Apply
|
|
| Licence Info: http://www.cubecart.com/site/faq/license.php
|
|
+--------------------------------------------------------------------------
|
|
| currency.inc.php
|
|
| ========================================
|
|
| Manage Store Currencies
|
|
+--------------------------------------------------------------------------
|
|
*/
|
|
|
|
if (!defined('CC_INI_SET')) die("Access Denied");
|
|
|
|
$lang = getLang("admin".CC_DS."admin_settings.inc.php");
|
|
permission('settings', 'read', true);
|
|
|
|
if (isset($_GET['currencyISO'])) {
|
|
$cache = new cache();
|
|
$cache->clearCache();
|
|
|
|
if (!$config['currecyAuto']) {
|
|
if (function_exists('curl_init')) {
|
|
$curl_handle = curl_init();
|
|
curl_setopt($curl_handle, CURLOPT_URL, 'http://download.finance.yahoo.com/d/quotes.csv?s='.$config['defaultCurrency'].$_GET['currencyISO'].'=X&f=sl1d1t1c1ohgv&e=.csv');
|
|
curl_setopt($curl_handle, CURLOPT_CONNECTTIMEOUT, 10);
|
|
curl_setopt($curl_handle, CURLOPT_RETURNTRANSFER, 1);
|
|
$contents = curl_exec($curl_handle);
|
|
curl_close($curl_handle);
|
|
|
|
} else {
|
|
|
|
if (!$handle = fopen("http://finance.yahoo.com/d/quotes.csv?s=".$config['defaultCurrency'].$_GET['currencyISO']."=X&f=sl1d1t1c1ohgv&e=.csv", "rb")) {
|
|
$handle = fopen("http://uk.old.finance.yahoo.com/d/quotes.csv?s=".$config['defaultCurrency'].$_GET['currencyISO']."=X&f=sl1d1t1c1ohgv&e=.csv", "rb");
|
|
}
|
|
if (function_exists('stream_get_contents')) {
|
|
$contents = stream_get_contents($handle);
|
|
} else {
|
|
while (!feof($handle)) {
|
|
$contents .= fread($handle, 8192);
|
|
}
|
|
}
|
|
fclose($handle);
|
|
}
|
|
|
|
$pieces = explode(',', $contents);
|
|
$rate = $pieces[1];
|
|
}
|
|
|
|
$where = "code = ".$db->mySQLSafe($_GET['currencyISO']);
|
|
$record['value'] = $db->mySQLSafe($rate);
|
|
$record['lastUpdated'] = $db->mySQLSafe(time());
|
|
|
|
$update = $db->update($glob['dbprefix']."CubeCart_currencies", $record, $where);
|
|
|
|
// clear cache
|
|
$cache = new cache('glob.currencyVars.'.$_GET['currencyISO']);
|
|
$cache->clearCache();
|
|
|
|
if($update == TRUE)
|
|
{
|
|
$msg = '<p class="infoText">"' .$_GET['currencyISO']."' ".$lang['admin']['settings_update_success']."</p>";
|
|
}
|
|
else
|
|
{
|
|
$msg = "<p class='warnText'>'".$_GET['currencyISO']."' ".$lang['admin']['settings_update_fail']."</p>";
|
|
}
|
|
|
|
}
|
|
elseif(isset($_POST['currencyId']))
|
|
{
|
|
|
|
$cache = new cache();
|
|
$cache->clearCache();
|
|
|
|
$record["code"] = $db->mySQLSafe($_POST['code']);
|
|
$record["name"] = $db->mySQLSafe($_POST['name']);
|
|
$record["symbolLeft"] = $db->mySQLSafe(validHTML($_POST['symbolLeft']));
|
|
$record["symbolRight"] = $db->mySQLSafe(validHTML($_POST['symbolRight']));
|
|
$record["value"] = $db->mySQLSafe($_POST['value']);
|
|
$record["decimalPlaces"] = $db->mySQLSafe($_POST['decimalPlaces']);
|
|
$record["decimalSymbol"] = $db->mySQLSafe($_POST['decimalSymbol']);
|
|
$record["lastUpdated"] = $db->mySQLSafe(time());
|
|
|
|
if($_POST['currencyId']>0)
|
|
{
|
|
|
|
$where = "currencyId = ".$db->mySQLSafe($_POST['currencyId']);
|
|
|
|
$update = $db->update($glob['dbprefix']."CubeCart_currencies", $record, $where);
|
|
|
|
if($update == TRUE)
|
|
{
|
|
$msg = "<p class='infoText'>'".$_POST['name']."' ".$lang['admin']['settings_update_success']."</p>";
|
|
}
|
|
else
|
|
{
|
|
$msg = "<p class='warnText'>'".$_POST['name']."' ".$lang['admin']['settings_update_fail']."</p>";
|
|
}
|
|
|
|
}
|
|
else
|
|
{
|
|
|
|
$insert =$db->insert($glob['dbprefix']."CubeCart_currencies", $record);
|
|
|
|
if($insert == TRUE)
|
|
{
|
|
$msg = "<p class='infoText'>'".$_POST['name']."' ".$lang['admin']['settings_add_success']."</p>";
|
|
}
|
|
else
|
|
{
|
|
$msg = "<p class='warnText'>'".$_POST['name']."' ".$lang['admin']['settings_add_fail']."</p>";
|
|
}
|
|
|
|
}
|
|
|
|
}
|
|
elseif(isset($_GET['deleteCurrency']))
|
|
{
|
|
|
|
$cache = new cache();
|
|
$cache->clearCache();
|
|
|
|
$where = "currencyId = ".$db->mySQLSafe($_GET['deleteCurrency']);
|
|
$delete = $db->delete($glob['dbprefix']."CubeCart_currencies", $where, "");
|
|
|
|
if($delete == TRUE)
|
|
{
|
|
$msg = "<p class='infoText'>".$lang['admin']['settings_delete_success']."</p>";
|
|
}
|
|
else
|
|
{
|
|
$msg = "<p class='warnText'>".$lang['admin']['settings_delete_failed']."</p>";
|
|
}
|
|
|
|
}
|
|
elseif(isset($_GET['active']) && $_GET['currencyId']>0)
|
|
{
|
|
|
|
$cache = new cache();
|
|
$cache->clearCache();
|
|
|
|
$record["active"] = $_GET['active'];
|
|
|
|
$where = "currencyId = ".$db->mySQLSafe($_GET['currencyId']);
|
|
|
|
$update =$db->update($glob['dbprefix']."CubeCart_currencies", $record, $where);
|
|
|
|
}
|
|
|
|
$currenciesPerPage = 20;
|
|
|
|
// get countries
|
|
$query ="SELECT * FROM ".$glob['dbprefix']."CubeCart_currencies ORDER BY name ASC";
|
|
|
|
if(isset($_GET['page']))
|
|
{
|
|
$page = $_GET['page'];
|
|
}
|
|
else
|
|
{
|
|
$page = 0;
|
|
}
|
|
|
|
$currencies = $db->select($query, $currenciesPerPage, $page);
|
|
$numrows = $db->numrows($query);
|
|
$pagination = paginate($numrows, $currenciesPerPage, $page, "page");
|
|
|
|
|
|
require($glob['adminFolder'].CC_DS."includes".CC_DS."header.inc.php");
|
|
?>
|
|
<p class="pageTitle"><?php echo $lang['admin']['settings_currencies'];?></p>
|
|
<?php
|
|
if(isset($msg))
|
|
{
|
|
echo msg($msg);
|
|
}
|
|
else
|
|
{
|
|
?>
|
|
<p class="copyText"><?php echo $lang['admin']['settings_currencies_desc'];?></p>
|
|
<?php
|
|
}
|
|
?>
|
|
<form name="countries" method="post" enctype="multipart/form-data" target="_self" action="<?php echo $glob['adminFile']; ?>?_g=settings/currency">
|
|
<table border="0" cellspacing="1" cellpadding="3" class="mainTable">
|
|
<tr>
|
|
<td align="center" class="tdTitle"><?php echo $lang['admin']['settings_c_code'];?></td>
|
|
<td class="tdTitle"><?php echo $lang['admin']['settings_c_name'];?></td>
|
|
<td align="center" class="tdTitle"><?php echo $lang['admin']['settings_c_value'];?></td>
|
|
<td align="center" class="tdTitle"><?php echo $lang['admin']['settings_symbol_left'];?></td>
|
|
<td align="center" class="tdTitle"><?php echo $lang['admin']['settings_symbol_right'];?></td>
|
|
<td align="center" class="tdTitle"><?php echo $lang['admin']['settings_decimal_places'];?></td>
|
|
<td align="center" class="tdTitle"><?php echo $lang['admin']['settings_decimal_format'];?></td>
|
|
<td align="center" class="tdTitle"><?php echo $lang['admin']['settings_last_updated'];?></td>
|
|
<td align="center" class="tdTitle"><?php echo $lang['admin']['settings_c_status'];?></td>
|
|
<td align="center" class="tdTitle"><?php echo $lang['admin']['settings_action'];?></td>
|
|
</tr>
|
|
<?php
|
|
if($currencies == TRUE){
|
|
|
|
for ($i=0; $i<count($currencies); $i++){
|
|
|
|
$cellColor = "";
|
|
$cellColor = cellColor($i);
|
|
|
|
?>
|
|
<tr>
|
|
<td align="center" class="<?php echo $cellColor; ?> copyText"><?php echo $currencies[$i]['code']; ?></td>
|
|
<td class="<?php echo $cellColor; ?> copyText"><?php echo $currencies[$i]['name']; ?></td>
|
|
<td align="center" class="<?php echo $cellColor; ?> copyText"><?php echo $currencies[$i]['value']; ?>
|
|
<?php
|
|
if($currencies[$i]['code']!==$config['defaultCurrency'])
|
|
{
|
|
?>
|
|
<br />
|
|
<a <?php if(permission("settings","edit")==TRUE){ ?>href="<?php echo $glob['adminFile']; ?>?_g=settings/currency&currencyISO=<?php echo $currencies[$i]['code']; ?>" class="txtLink"<?php } else { echo $link401; } ?>><?php echo $lang['admin']['settings_autoupdate'];?></a>
|
|
<?php
|
|
}
|
|
?>
|
|
</td>
|
|
<td align="center" class="<?php echo $cellColor; ?> copyText"><?php echo $currencies[$i]['symbolLeft']; ?></td>
|
|
<td align="center" class="<?php echo $cellColor; ?> copyText"><?php echo $currencies[$i]['symbolRight']; ?></td>
|
|
<td align="center" class="<?php echo $cellColor; ?> copyText"><?php echo $currencies[$i]['decimalPlaces']; ?></td>
|
|
<td align="center" class="<?php echo $cellColor; ?> copyText">
|
|
<?php
|
|
if($currencies[$i]['decimalSymbol']==1)
|
|
{
|
|
echo ", ".$lang['admin']['settings_comma'];
|
|
}
|
|
else
|
|
{
|
|
echo ". ".$lang['admin']['settings_decimal_point'];
|
|
}
|
|
?> </td>
|
|
<td align="center" class="<?php echo $cellColor; ?> copyText"><?php echo formatTime($currencies[$i]['lastUpdated']); ?></td>
|
|
<td align="center" class="<?php echo $cellColor; ?>"><img src="<?php echo $glob['adminFolder']; ?>/images/<?php echo $currencies[$i]['active']; ?>.gif" alt="" title="" /></td>
|
|
<td align="center" class="<?php echo $cellColor; ?>"> <?php if($currencies[$i]['active']>0){ ?>
|
|
<a <?php if(permission("settings","edit")==TRUE){ ?>href="<?php echo $glob['adminFile']; ?>?_g=settings/currency&currencyId=<?php echo $currencies[$i]['currencyId']; ?>&code=<?php echo $currencies[$i]['code']; ?>&active=0" class="txtLink"<?php } else { echo $link401; } ?>><?php echo $lang['admin']['settings_disable'];?></a>
|
|
<?php } else { ?>
|
|
<a <?php if(permission("settings","edit")==TRUE){ ?>href="<?php echo $glob['adminFile']; ?>?_g=settings/currency&currencyId=<?php echo $currencies[$i]['currencyId']; ?>&code=<?php echo $currencies[$i]['code']; ?>&active=1" class="txtLink"<?php } else { echo $link401; } ?>><?php echo $lang['admin']['settings_enable'];?></a>
|
|
<?php } ?>
|
|
<br />
|
|
|
|
<a <?php if(permission("settings","edit")==TRUE){ ?>href="<?php echo $glob['adminFile']; ?>?_g=settings/currency&editCurrency=<?php echo $currencies[$i]['currencyId']; ?>" class="txtLink"<?php } else { echo $link401; } ?>><?php echo $lang['admin_common']['edit'];?></a>
|
|
|
|
<br />
|
|
|
|
<a <?php if(permission("settings","delete")==TRUE){ ?>href="javascript:decision('<?php echo $lang['admin_common']['delete_q'];?>','<?php echo $glob['adminFile']; ?>?_g=settings/currency&deleteCurrency=<?php echo $currencies[$i]['currencyId']; ?>&code=<?php echo $currencies[$i]['code']; ?>');" class="txtLink"<?php } else { echo $link401; } ?>><?php echo $lang['admin_common']['delete'];?></a>
|
|
</td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
}
|
|
else
|
|
{
|
|
?>
|
|
<tr>
|
|
<td colspan="10" class="tdText"><?php echo $lang['admin']['settings_no_currencies'];?></td>
|
|
</tr>
|
|
<?php }
|
|
if(isset($_GET['editCurrency']) && $_GET['editCurrency']>0)
|
|
{
|
|
|
|
$editCurrency = $db->select("select * FROM ".$glob['dbprefix']."CubeCart_currencies WHERE currencyId = ".$db->mySQLsafe($_GET['editCurrency']));
|
|
|
|
}
|
|
?>
|
|
<tr>
|
|
<td align="center" class="<?php echo $cellColor; ?>"><input name="code" type="text" class="textbox" id="code" value="<?php if(isset($editCurrency[0]['code'])) echo $editCurrency[0]['code']; ?>" size="4" /></td>
|
|
<td class="<?php echo $cellColor; ?>"><input name="name" type="text" class="textbox" id="name" value="<?php if(isset($editCurrency[0]['name'])) echo $editCurrency[0]['name']; ?>" /></td>
|
|
<td align="center" class="<?php echo $cellColor; ?>"><input name="value" type="text" class="textbox" id="value" value="<?php if(isset($editCurrency[0]['value'])) echo $editCurrency[0]['value']; ?>" size="8" /></td>
|
|
<td align="center" class="<?php echo $cellColor; ?>"><input name="symbolLeft" type="text" class="textbox" id="symbolLeft" value="<?php if(isset($editCurrency[0]['symbolLeft'])) echo $editCurrency[0]['symbolLeft']; ?>" size="4" /></td>
|
|
<td align="center" class="<?php echo $cellColor; ?>"><input name="symbolRight" type="text" class="textbox" id="symbolRight" value="<?php if(isset($editCurrency[0]['symbolRight'])) echo $editCurrency[0]['symbolRight']; ?>" size="4" /></td>
|
|
<td align="center" class="<?php echo $cellColor; ?>"><input name="decimalPlaces" type="text" class="textbox" id="decimalPlaces" value="<?php if(isset($editCurrency[0]['decimalPlaces'])) echo $editCurrency[0]['decimalPlaces']; ?>" size="4" /></td>
|
|
<td align="center" class="<?php echo $cellColor; ?>">
|
|
<select name="decimalSymbol">
|
|
<option value="0">. <?php echo $lang['admin']['settings_decimal_point'];?></option>
|
|
<option value="1" <?php if($editCurrency[0]['decimalPlaces']==1) { echo "selected='selected'"; } ?>>, <?php echo $lang['admin']['settings_comma'];?></option>
|
|
</select> </td>
|
|
<td align="center" class="<?php echo $cellColor; ?>"> </td>
|
|
<td colspan="2" align="left" class="<?php echo $cellColor; ?>"><input name="submit" type="submit" class="submit" id="submit" value="<?php if(isset($editCurrency) && $editCurrency == TRUE) { echo $lang['admin_common']['edit']; } else { echo $lang['admin_common']['add']; } ?> <?php echo $lang['admin']['settings_currency'];?>" />
|
|
<input type="hidden" name="currencyId" value="<?php if(isset($editCurrency[0]['currencyId'])) echo $editCurrency[0]['currencyId']; ?>" /> </td>
|
|
</tr>
|
|
</table>
|
|
<p class="copyText"><?php echo $pagination; ?></p>
|
|
|
|
</form>
|