<?php
require_once 'functions.php';
spl_autoload_register(function ($class) {
require_once 'lib' . DIRECTORY_SEPARATOR . $class . '.php';
});
$result = null;
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
if (isset($_POST['conversion-rate'])) {
$from = trim($_POST['from']);
$to = trim($_POST['to']);
if (!empty($from) && !empty($to)) {
if (isset($_POST['use-curl'])) {
$result = getConversionRateUsingCurl(strtoupper($from), strtoupper($to));
} else {
$conversionRate = new ConversionRate();
$result = $conversionRate->get(strtoupper($from), strtoupper($to));
}
}
}
if (isset($_POST['location'])) {
$ip = trim($_POST['ip']);
if (!empty($ip)) {
if (isset($_POST['use-curl'])) {
$result = getLocationUsingCurl($ip);
} else {
$locator = new Location();
$result = $locator->locate($ip);
}
}
}
public function saveConversionRate()
{
$choosecurrencyfrom_id = $_REQUEST['choosecurrencyfrom_id'];
$this->log->showLog(2, "Access saveConversionRate, currencyfrom_id: {$choosecurrencyfrom_id}");
global $xoopsDB, $saveHandler, $createdby, $timestamp, $defaultorganization_id;
$tablename = "sim_conversionrate";
$insertCount = $saveHandler->ReturnInsertCount();
$this->log->showLog(3, "Start Insert({$insertCount} records)");
if ($insertCount > 0) {
$arrfield = array("currencyfrom_id", "currencyto_id", "multiplyvalue", "effectivedate", "organization_id", "description", "isactive", "created", "createdby", "updated", "updatedby");
$arrfieldtype = array('%d', '%d', '%d', '%s', '%s', '%d', '%s', '%d', '%s', '%d', '%s', '%d');
// Yes there are INSERTs to perform...
for ($currentRecord = 0; $currentRecord < $insertCount; $currentRecord++) {
$arrvalue = array($choosecurrencyfrom_id, $saveHandler->ReturnInsertField($currentRecord, "currencyto_id"), $saveHandler->ReturnInsertField($currentRecord, "multiplyvalue"), $saveHandler->ReturnInsertField($currentRecord, "effectivedate"), $defaultorganization_id, $saveHandler->ReturnInsertField($currentRecord, "description"), $saveHandler->ReturnInsertField($currentRecord, "isactive"), $timestamp, $createdby, $timestamp, $createdby);
$controlvalue = $saveHandler->ReturnInsertField($currentRecord, "description");
$this->InsertRecord($tablename, $arrfield, $arrvalue, $arrfieldtype, $controlvalue, "conversion_id");
// Now we execute this query
}
}
$updateCount = $saveHandler->ReturnUpdateCount();
$this->log->showLog(3, "Start update({$updateCount} records)");
if ($updateCount > 0) {
$arrfield = array("currencyto_id", "multiplyvalue", "effectivedate", "description", "isactive", "updated", "updatedby", "isdeleted");
$arrfieldtype = array('%d', '%d', '%s', '%s', '%s', '%d', '%s', '%d', '%d');
// Yes there are UPDATEs to perform...
for ($currentRecord = 0; $currentRecord < $updateCount; $currentRecord++) {
$arrvalue = array($saveHandler->ReturnUpdateField($currentRecord, "currencyto_id"), $saveHandler->ReturnUpdateField($currentRecord, "multiplyvalue"), $saveHandler->ReturnUpdateField($currentRecord, "effectivedate"), $saveHandler->ReturnUpdateField($currentRecord, "description"), $saveHandler->ReturnUpdateField($currentRecord, "isactive"), $timestamp, $createdby, $saveHandler->ReturnUpdateField($currentRecord, "isdeleted"));
$controlvalue = $saveHandler->ReturnUpdateField($currentRecord, "description");
$this->UpdateRecord($tablename, "conversion_id", $saveHandler->ReturnUpdateField($currentRecord), $arrfield, $arrvalue, $arrfieldtype, $controlvalue);
}
}
$ispurge = 0;
$deleteCount = $saveHandler->ReturnDeleteCount();
$this->log->showLog(3, "Start delete/purge({$deleteCount} records)");
include "class/ConversionRate.inc.php";
$o = new ConversionRate();
if ($deleteCount > 0) {
for ($currentRecord = 0; $currentRecord < $deleteCount; $currentRecord++) {
$record_id = $saveHandler->ReturnDeleteField($currentRecord);
if ($o->allowDelete($record_id)) {
$o->fetchConversionRate($record_id);
$controlvalue = $o->description;
$isdeleted = $country->isdeleted;
$this->DeleteRecord("sim_conversionrate", "conversion_id", $record_id, $controlvalue, 1);
} else {
$this->failfeedback .= "Current record id:{$currentRecord} is not deletetable<br/>\n";
}
}
}
if ($this->failfeedback != "") {
$this->failfeedback .= "Warning!<br/>\n" . $this->failfeedback;
}
$saveHandler->setErrorMessage($this->failfeedback);
$saveHandler->CompleteSave();
}
<?php
include "system.php";
include "menu.php";
include_once 'class/Log.php';
include_once 'class/Currency.php';
include_once "class/ConversionRate.php";
include_once 'class/SelectCtrl.php';
$log = new Log();
$o = new Currency();
$cvr = new ConversionRate();
$s = new XoopsSecurity();
$ctrl = new SelectCtrl();
//$orgctrl="";
$action = "";
echo <<<EOF
<script type="text/javascript">
function IsNumeric(sText)
{
var ValidChars = "0123456789.-";
var IsNumber=true;
var Char;
for (i = 0; i < sText.length && IsNumber == true; i++)
{
Char = sText.charAt(i);
if (ValidChars.indexOf(Char) == -1)
{
IsNumber = false;
}
