PHP transferCurrency 예제들

예제 #1

파일: Module.php 프로젝트: Bergdahls/YetiForceCRM

 public static function tranformCurrency($oldCurrencyId, $newCurrencyId)
 {
     return transferCurrency($oldCurrencyId, $newCurrencyId);
 }

예제 #2

파일: SaveCurrencyInfo.php 프로젝트: sacredwebsite/vtigercrm

 ********************************************************************************/
require_once 'include/database/PearDatabase.php';
global $adb;
$db = PearDatabase::getInstance();
$currency_name = $_REQUEST['currency_name'];
$currency_code = $_REQUEST['currency_code'];
$currency_symbol = $_REQUEST['currency_symbol'];
$conversion_rate = $_REQUEST['conversion_rate'];
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 vtiger_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 vtiger_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 {
    $sql = "insert into vtiger_currency_info values(?,?,?,?,?,?,?,?)";
    $params = array($db->getUniqueID("vtiger_currency_info"), $currency_name, $currency_code, $currency_symbol, $conversion_rate, $currency_status, '0', '0');
}
$adb->pquery($sql, $params);
$loc = "Location: index.php?module=Settings&action=CurrencyListView&parenttab=" . vtlib_purify($_REQUEST['parenttab']);
header($loc);

예제 #3

파일: CurrencyDelete.php 프로젝트: sacredwebsite/vtigercrm

<?php

/*********************************************************************************
** The contents of this file are subject to the vtiger CRM Public License Version 1.0
 * ("License"); You may not use this file except in compliance with the License
 * The Original Code is:  vtiger CRM Open Source
 * The Initial Developer of the Original Code is vtiger.
 * Portions created by vtiger are Copyright (C) vtiger.
 * All Rights Reserved.
*
 ********************************************************************************/
$del_id = $_REQUEST['delete_currency_id'];
$tran_id = $_REQUEST['transfer_currency_id'];
// Transfer all the data refering to currency $del_id to currency $tran_id
transferCurrency($del_id, $tran_id);
// Mark Currency as deleted
$sql = "update vtiger_currency_info set deleted=1 where id =?";
$adb->pquery($sql, array($del_id));
header("Location: index.php?action=SettingsAjax&module=Settings&file=CurrencyListView&ajax=true");
?>

예제 #4

파일: SaveCurrencyInfo.php 프로젝트: casati-dolibarr/corebos

 ********************************************************************************/
require_once 'include/database/PearDatabase.php';
global $adb;
$db = PearDatabase::getInstance();
$currency_name = vtlib_purify($_REQUEST['currency_name']);
$currency_code = vtlib_purify($_REQUEST['currency_code']);
$currency_symbol = vtlib_purify($_REQUEST['currency_symbol']);
$conversion_rate = vtlib_purify($_REQUEST['conversion_rate']);
if (isset($_REQUEST['currency_status']) && $_REQUEST['currency_status'] != '') {
    $currency_status = vtlib_purify($_REQUEST['currency_status']);
} else {
    $currency_status = 'Active';
}
if (isset($_REQUEST['record']) && $_REQUEST['record'] != '') {
    $cur_status_res = $adb->pquery("select currency_status from vtiger_currency_info where id=?", array(vtlib_purify($_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 = vtlib_purify($_REQUEST['transfer_currency_id']);
        if ($transfer_cur_id != null) {
            transferCurrency(vtlib_purify($_REQUEST['record']), $transfer_cur_id);
        }
    }
    $sql = "update vtiger_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, vtlib_purify($_REQUEST['record']));
} else {
    $sql = "insert into vtiger_currency_info values(?,?,?,?,?,?,?,?)";
    $params = array($db->getUniqueID("vtiger_currency_info"), $currency_name, $currency_code, $currency_symbol, $conversion_rate, $currency_status, '0', '0');
}
$adb->pquery($sql, $params);
$loc = "Location: index.php?module=Settings&action=CurrencyListView&parenttab=" . vtlib_purify($_REQUEST['parenttab']);
header($loc);