mirror of
https://github.com/VTECRM/vtenext.git
synced 2026-02-26 16:18:47 +00:00
43 lines
2.0 KiB
PHP
43 lines
2.0 KiB
PHP
<?php
|
|
/*************************************
|
|
* SPDX-FileCopyrightText: 2009-2020 Vtenext S.r.l. <info@vtenext.com>
|
|
* SPDX-License-Identifier: AGPL-3.0-only
|
|
************************************/
|
|
|
|
global $adb,$table_prefix;
|
|
|
|
$currency_name = $_REQUEST['currency_name'];
|
|
$conversion_rate= $_REQUEST['conversion_rate'];
|
|
|
|
// crmv@42266
|
|
// retrieve currency code and symbol from db
|
|
$CurrencyUtils = CurrencyUtils::getInstance();
|
|
$currInfo = $CurrencyUtils->getCurrencyInfoFromName($currency_name);
|
|
$currency_code = $currInfo['currency_code'];
|
|
$currency_symbol= $currInfo['currency_symbol'];
|
|
// crmv@42266e
|
|
|
|
if(isset($_REQUEST['currency_status']) && $_REQUEST['currency_status'] != '')
|
|
$currency_status= $_REQUEST['currency_status'];
|
|
else
|
|
$currency_status= 'Active';
|
|
|
|
if(isset($_REQUEST['record']) && $_REQUEST['record']!='') {
|
|
$cur_status_res = $adb->pquery("select currency_status from ".$table_prefix."_currency_info where id=?", array($_REQUEST['record']));
|
|
$old_cur_status = $adb->query_result($cur_status_res,0,'currency_status');
|
|
|
|
if($currency_status != $old_cur_status && $currency_status == 'Inactive') {
|
|
$transfer_cur_id = $_REQUEST['transfer_currency_id'];
|
|
if($transfer_cur_id != null) transferCurrency($_REQUEST['record'], $transfer_cur_id);
|
|
}
|
|
|
|
$sql = "update ".$table_prefix."_currency_info set currency_name =?, currency_code =?, currency_symbol =?, conversion_rate =?,currency_status=? where id =?";
|
|
$params = array($currency_name, $currency_code, $currency_symbol, $conversion_rate, $currency_status, $_REQUEST['record']);
|
|
} else {
|
|
$params = array($adb->getUniqueID($table_prefix."_currency_info"), $currency_name, $currency_code, $currency_symbol, $conversion_rate, $currency_status,'0','0');
|
|
$sql = "INSERT INTO {$table_prefix}_currency_info (id, currency_name, currency_code, currency_symbol, conversion_rate, currency_status, defaultid, deleted) values (".generateQuestionMarks($params).")";
|
|
}
|
|
$adb->pquery($sql, $params);
|
|
|
|
header("Location: index.php?module=Settings&action=CurrencyListView&parenttab=".vtlib_purify($_REQUEST['parenttab']));
|