PHP currencies::get_value方法代码示例

 function process_button()
 {
     global $order, $currencies, $currency;
     $my_currency = MODULE_PAYMENT_PAYPAL_CURRENCY;
     if (!in_array($my_currency, array('CAD', 'EUR', 'GBP', 'JPY', 'USD'))) {
         $my_currency = 'USD';
     }
     $currencyObject = new currencies();
     $process_button_string = tep_draw_hidden_field('cmd', '_xclick') . tep_draw_hidden_field('business', MODULE_PAYMENT_PAYPAL_ID) . tep_draw_hidden_field('item_name', STORE_NAME) . tep_draw_hidden_field('rm', '2') . tep_draw_hidden_field('no_shipping', '1') . tep_draw_hidden_field('PHPSESSID', session_id()) . tep_draw_hidden_field('amount', number_format(($order->info['total'] - $order->info['shipping_cost']) * $currencyObject->get_value($my_currency), $currencyObject->get_decimal_places($my_currency))) . tep_draw_hidden_field('currency_code', $my_currency) . tep_draw_hidden_field('return', tep_href_link("checkout_process.php?sess_id=" . session_id(), '', 'SSL')) . tep_draw_hidden_field('cancel_return', tep_href_link("checkout_payment.php", '', 'SSL'));
     return $process_button_string;
 }

 function process_button()
 {
     global $order, $currencies, $currency;
     $my_language = MODULE_PAYMENT_MONEYBOOKERS_LANGUAGE;
     $my_currency = MODULE_PAYMENT_MONEYBOOKERS_CURRENCY;
     if (!in_array($my_currency, array('EUR', 'USD', 'GBP', 'HKD', 'SGD', 'JPY', 'CAD', 'AUD', 'CHF', 'DKK', 'SEK', 'NOK', 'ILS', 'MYR', 'NZD', 'TWD', 'THB', 'CZK', 'HUF', 'SKK', 'ISK', 'INR'))) {
         $my_currency = 'USD';
     }
     $currencyObject = new currencies();
     $process_button_string = tep_draw_hidden_field('pay_to_email', MODULE_PAYMENT_MONEYBOOKERS_ID) . tep_draw_hidden_field('language', $my_language) . tep_draw_hidden_field('amount', number_format($order->info['total'] * $currencyObject->get_value($my_currency), $currencyObject->get_decimal_places($my_currency))) . tep_draw_hidden_field('currency', $my_currency) . tep_draw_hidden_field('detail1_description', STORE_NAME) . tep_draw_hidden_field('detail1_text', 'Order - ' . date('d. M Y - H:i')) . tep_draw_hidden_field('firstname', $order->billing['firstname']) . tep_draw_hidden_field('lastname', $order->billing['lastname']) . tep_draw_hidden_field('address', $order->billing['street_address']) . tep_draw_hidden_field('postal_code', $order->billing['postcode']) . tep_draw_hidden_field('city', $order->billing['city']) . tep_draw_hidden_field('country', $order->billing['country']['moneybookers']) . tep_draw_hidden_field('pay_from_email', $order->customer['email_address']) . tep_draw_hidden_field('status_url', tep_href_link("checkout_process.php?sess_id=" . session_id(), '', 'SSL')) . tep_draw_hidden_field('cancel_url', tep_href_link("checkout_payment.php", '', 'SSL'));
     return $process_button_string;
 }

                tep_db_query("update " . TABLE_PRODUCTS_INFO . " set products_status = '" . (int) $product_new_status . "' where products_id = '" . (int) $product_check['products_id'] . "'");
                if (tep_db_table_exists($shops['shops_database'], 'temp_' . TABLE_PRODUCTS)) {
                    tep_db_query("update temp_" . TABLE_PRODUCTS . " set products_status = '" . (int) $product_new_status . "' where products_id = '" . (int) $product_check['products_id'] . "'");
                }
                if (tep_db_table_exists($shops['shops_database'], 'temp_' . TABLE_PRODUCTS_INFO)) {
                    tep_db_query("update temp_" . TABLE_PRODUCTS_INFO . " set products_status = '" . (int) $product_new_status . "' where products_id = '" . (int) $product_check['products_id'] . "'");
                }
            }
            tep_db_select_db(DB_DATABASE);
            //		tep_db_query("update " . TABLE_PRODUCTS_TYPES . " set products_last_modified = now() where products_types_id = '1'");
            die('OK');
        }
    }
    die('FAIL');
} elseif ($HTTP_GET_VARS['action'] == 'get_currency_value') {
    die($currencies->get_value($HTTP_GET_VARS['currency']));
} elseif ($HTTP_GET_VARS['action'] == 'get_product_price') {
    $product_info_query = tep_db_query("select if(s.specials_new_products_price>'0', s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on (s.products_id = p.products_id and s.status = '1' and s.specials_new_products_price > 0 and s.language_id = '" . (int) $languages_id . "') where p.products_code = 'bbk" . sprintf('%010d', (int) $HTTP_GET_VARS['code']) . "' and p.products_types_id = '" . (int) $HTTP_GET_VARS['type'] . "'");
    $product_info = tep_db_fetch_array($product_info_query);
    die($product_info['products_price']);
}
$http_r = preg_replace('/^https?:\\/\\//i', '', str_replace('www.', '', $_SERVER['HTTP_REFERER']));
$http_s = preg_replace('/^https?:\\/\\//i', '', str_replace('www.', '', HTTP_SERVER . DIR_WS_CATALOG));
if ($HTTP_GET_VARS['link'] == 'mail') {
    $allow_action = true;
} elseif (strpos($http_r, $http_s) !== false) {
    $allow_action = true;
} elseif (strpos($_SERVER['HTTP_USER_AGENT'], 'Firefox/1.5') !== false) {
    $allow_action = true;
} else {
    $allow_action = false;

     $customers_state_error = false;
 }
 if (strlen($customers_country) < 2) {
     $error = true;
     $entry_country_error = true;
 } else {
     $entry_country_error = false;
 }
 if (strlen($customers_email_address) < 2) {
     $error = true;
     $entry_email_address_error = true;
 } else {
     $entry_email_address_error = false;
 }
 if ($error == false) {
     $boards_currency_value = $currencies->get_value($boards_currency);
     $currency_check_query = tep_db_query("select boards_currency, boards_currency_value from " . TABLE_BOARDS . " where boards_id = '" . (int) $boards_id . "'");
     $currency_check = tep_db_fetch_array($currency_check_query);
     if ($currency_check['boards_currency'] == $boards_currency) {
         $boards_currency_value = $currency_check['boards_currency_value'];
     }
     $price = str_replace(',', '.', $boards_price / $boards_currency_value);
     $sql_data_array = array('customers_name' => $customers_name, 'customers_email_address' => $customers_email_address, 'customers_telephone' => $customers_telephone, 'customers_other_contacts' => $customers_other_contacts, 'customers_country' => $customers_country, 'customers_state' => $customers_state, 'customers_city' => $customers_city, 'boards_name' => $boards_name, 'boards_description' => $boards_description, 'boards_status' => $boards_status, 'boards_price' => $price, 'boards_currency' => $boards_currency, 'boards_currency_value' => $boards_currency_value, 'boards_quantity' => $boards_quantity, 'boards_condition' => $boards_condition, 'last_modified' => 'now()');
     tep_db_perform(TABLE_BOARDS, $sql_data_array, 'update', "boards_id = '" . (int) $boards_id . "'");
     $prev_image_query = tep_db_query("select boards_image from " . TABLE_BOARDS . " where boards_id = '" . (int) $boards_id . "'");
     $prev_image = tep_db_fetch_array($prev_image_query);
     $prev_images_array = explode("\n", $prev_image['boards_image']);
     if (!is_array($prev_images_array)) {
         $prev_images_array = array();
     }
     $boards_images = array();

 $billing_suburb = !empty($_POST['update_billing_suburb']) && $_POST['update_billing_suburb'] != $order->billing['suburb'] ? tep_db_prepare_input($_POST['update_billing_suburb']) : $order->billing['suburb'];
 $billing_city = !empty($_POST['update_customer_city']) && $_POST['update_customer_city'] != $order->billing['city'] ? tep_db_prepare_input($_POST['update_customer_city']) : $order->billing['city'];
 $billing_state = !empty($_POST['update_customer_state']) && $_POST['update_customer_state'] != $order->billing['state'] ? tep_db_prepare_input($_POST['update_customer_state']) : $order->billing['state'];
 $billing_postcode = !empty($_POST['update_customer_postcode']) && $_POST['update_customer_postcode'] != $order->billing['postcode'] ? tep_db_prepare_input($_POST['update_customer_postcode']) : $order->billing['postcode'];
 $billing_country = !empty($_POST['update_customer_country']) && $_POST['update_customer_country'] != $order->billing['country'] ? tep_db_prepare_input($_POST['update_customer_country']) : $order->billing['country'];
 $delivery_name = !empty($_POST['update_delivery_name']) && $_POST['update_delivery_name'] != $order->delivery['name'] ? tep_db_prepare_input($_POST['update_delivery_name']) : $order->delivery['name'];
 $delivery_company = !empty($_POST['update_delivery_company']) && $_POST['update_delivery_company'] != $order->delivery['company'] ? tep_db_prepare_input($_POST['update_delivery_company']) : $order->delivery['company'];
 $delivery_street_address = !empty($_POST['update_delivery_street_address']) && $_POST['update_delivery_street_address'] != $order->delivery['street_address'] ? tep_db_prepare_input($_POST['update_delivery_street_address']) : $order->delivery['street_address'];
 $delivery_suburb = !empty($_POST['update_delivery_suburb']) && $_POST['update_delivery_suburb'] != $order->delivery['suburb'] ? tep_db_prepare_input($_POST['update_delivery_suburb']) : $order->delivery['suburb'];
 $delivery_city = !empty($_POST['update_delivery_city']) && $_POST['update_delivery_city'] != $order->delivery['city'] ? tep_db_prepare_input($_POST['update_delivery_city']) : $order->delivery['city'];
 $delivery_postcode = !empty($_POST['update_delivery_postcode']) && $_POST['update_delivery_postcode'] != $order->delivery['postcode'] ? tep_db_prepare_input($_POST['update_delivery_postcode']) : $order->delivery['postcode'];
 $delivery_state = !empty($_POST['update_delivery_state']) && $_POST['update_delivery_state'] != $order->delivery['state'] ? tep_db_prepare_input($_POST['update_delivery_state']) : $order->delivery['state'];
 $delivery_country = !empty($_POST['update_delivery_country']) && $_POST['update_delivery_country'] != $order->delivery['country'] ? tep_db_prepare_input($_POST['update_delivery_country']) : $order->delivery['country'];
 $update_shipping_method = !empty($_POST['update_shipping_method']) ? tep_db_prepare_input($_POST['update_shipping_method']) : $order->info['shipping_method'];
 $update_currency = !empty($_POST['update_currency']) ? tep_db_prepare_input($_POST['update_currency']) : $order->info['update_currency'];
 $update_orders_array = array('customers_name' => $customers_name, 'customers_company' => $customers_company, 'customers_street_address' => $customers_street_address, 'customers_suburb' => $customers_suburb, 'customers_city' => $customers_city, 'customers_postcode' => $customers_postcode, 'customers_state' => $customers_state, 'customers_country' => $customers_country, 'customers_telephone' => $customers_telephone, 'customers_email_address' => $customers_email_address, 'billing_name' => $billing_name, 'billing_company' => $billing_company, 'billing_street_address' => $billing_street_address, 'billing_suburb' => $billing_suburb, 'billing_city' => $billing_city, 'billing_state' => $billing_state, 'billing_postcode' => $billing_postcode, 'billing_country' => $billing_country, 'delivery_name' => $delivery_name, 'delivery_company' => $delivery_company, 'delivery_street_address' => $delivery_street_address, 'delivery_suburb' => $delivery_suburb, 'delivery_city' => $delivery_city, 'delivery_postcode' => $delivery_postcode, 'delivery_state' => $delivery_state, 'delivery_country' => $delivery_country, 'payment_method' => $pay_method, 'cc_type' => $cc_type, 'cc_owner' => $cc_owner, 'cc_number' => $cc_number, 'shipping_method' => $update_shipping_method, 'currency' => $update_currency, 'currency_value' => $currencies->get_value($update_currency), 'last_modified' => date('Y-m-d H:i:s', time()), 'date_purchased' => !empty($check_status['date_purchased']) ? $check_status['date_purchased'] : date('Y-m-d H:i:s', time()), 'orders_source' => $orders_source);
 if (!$oID) {
     $oID = tep_db_insert_id();
 }
 tep_db_perform(TABLE_ORDERS, $update_orders_array, 'update', "orders_id = '" . $oID . "'");
 // # Send email notifications
 $customer_notified = 0;
 if (!empty($cc_cvv2) && !empty($cc_number)) {
     $process = 1;
 } else {
     $process = 0;
 }
 if ($check_status['orders_status'] != $status) {
     $order->setStatus($status, $process);
     $order_updated = true;
     $thestatus = sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]) . "\n\n";

/**
 * Process a <merchant-calculation-callback>.
 */
function process_merchant_calculation_callback_single($google_response)
{
    global $google_checkout, $order, $cart, $total_weight, $total_count;
    list($root, $gc_data) = $google_response->GetParsedXML();
    $currencies = new currencies();
    // Get a hash array with the description of each shipping method
    $shipping_methods = $google_checkout->getMethods();
    require DIR_WS_CLASSES . 'order.php';
    $order = new order();
    $items = gc_get_arr_result($gc_data[$root]['shopping-cart']['items']['item']);
    // Get Coustoms OT
    $custom_order_totals_total = 0;
    $custom_order_totals = array();
    $order->products = array();
    foreach ($items as $item) {
        if (isset($item['merchant-private-item-data']['item']['VALUE'])) {
            $order->products[] = unserialize(base64_decode($item['merchant-private-item-data']['item']['VALUE']));
        } else {
            if ($item['merchant-private-item-data']['order_total']['VALUE']) {
                $ot = unserialize(base64_decode($item['merchant-private-item-data']['order_total']['VALUE']));
                $custom_order_totals[] = $ot;
                $order_total_value = $ot['value'] * (strrpos($ot['text'], '-') === false ? 1 : -1);
                $custom_order_totals_total += $currencies->get_value($gc_data[$root]['order-total']['currency']) * $order_total_value;
            } else {
                // For invoices.
                $order->products[] = array('qty' => $item['quantity']['VALUE'], 'name' => $item['item-name']['VALUE'], 'model' => $item['item-description']['VALUE'], 'tax' => 0, 'tax_description' => @$item['tax-table-selector']['VALUE'], 'price' => $item['unit-price']['VALUE'], 'final_price' => $item['unit-price']['VALUE'], 'onetime_charges' => 0, 'weight' => 0, 'products_priced_by_attribute' => 0, 'product_is_free' => 0, 'products_discount_type' => 0, 'products_discount_type_from' => 0, 'id' => @$item['merchant-item-id']['VALUE']);
            }
        }
    }
    $ex_cart = $cart;
    $cart = new shoppingCart();
    $prod_attr = gc_get_prattr($order->products);
    foreach ($prod_attr as $product_id => $item_data) {
        //$products_id, $qty = '1', $attributes = '
        $cart->add_cart($product_id, $item_data['qty'], $item_data['attr']);
    }
    // Register a random ID in the session to check throughout the checkout procedure
    // against alterations in the shopping cart contents.
    // TODO(eddavisson): Why is this commented out?
    //if (!tep_session_is_registered('cartID')) {
    //  tep_session_register('cartID');
    //}
    //$cartID = $cart->cartID;
    $total_weight = $cart->show_weight();
    $total_count = $cart->count_contents();
    // Create the results and send it
    $merchant_calc = new GoogleMerchantCalculations(DEFAULT_CURRENCY);
    // Loop through the list of address ids from the callback.
    $addresses = gc_get_arr_result($gc_data[$root]['calculate']['addresses']['anonymous-address']);
    // Get all the enabled shipping methods.
    require_once DIR_WS_CLASSES . 'shipping.php';
    // Required for some shipping methods (ie. USPS).
    require_once 'includes/classes/http_client.php';
    foreach ($addresses as $curr_address) {
        // Set up the order address.
        $curr_id = $curr_address['id'];
        $country = $curr_address['country-code']['VALUE'];
        $city = $curr_address['city']['VALUE'];
        $region = $curr_address['region']['VALUE'];
        $postal_code = $curr_address['postal-code']['VALUE'];
        $row = tep_db_fetch_array(tep_db_query("select * from " . TABLE_COUNTRIES . " where countries_iso_code_2 = '" . gc_make_sql_string($country) . "'"));
        $order->delivery['country'] = array('id' => $row['countries_id'], 'title' => $row['countries_name'], 'iso_code_2' => $country, 'iso_code_3' => $row['countries_iso_code_3']);
        $order->delivery['country_id'] = $row['countries_id'];
        $order->delivery['format_id'] = $row['address_format_id'];
        $row = tep_db_fetch_array(tep_db_query("select * from " . TABLE_ZONES . " where zone_code = '" . gc_make_sql_string($region) . "'"));
        $order->delivery['zone_id'] = $row['zone_id'];
        $order->delivery['state'] = $row['zone_name'];
        $order->delivery['city'] = $city;
        $order->delivery['postcode'] = $postal_code;
        //print_r($order);
        $shipping_modules = new shipping();
        // Loop through each shipping method if merchant-calculated shipping
        // support is to be provided
        //print_r($gc_data[$root]['calculate']['shipping']['method']);
        if (isset($gc_data[$root]['calculate']['shipping'])) {
            $shipping = gc_get_arr_result($gc_data[$root]['calculate']['shipping']['method']);
            // TODO(eddavisson): If we reactivate this, need to move to new configuration system.
            if (MODULE_PAYMENT_GOOGLECHECKOUT_MULTISOCKET == 'True') {
                // Single.
                // Get all the enabled shipping methods.
                $name = $shipping[0]['name'];
                // Compute the price for this shipping method and address id
                list($a, $method_name) = explode(': ', $name);
                if ($order->delivery['country']['id'] == SHIPPING_ORIGIN_COUNTRY && $shipping_methods[$method_name][1] == 'domestic_types' || $order->delivery['country']['id'] != SHIPPING_ORIGIN_COUNTRY && $shipping_methods[$method_name][1] == 'international_types') {
                    // Reset the shipping class to set the new address
                    if (class_exists($shipping_methods[$method_name][2])) {
                        $GLOBALS[$shipping_methods[$method_name][2]] = new $shipping_methods[$method_name][2]();
                    }
                }
                $quotes = $shipping_modules->quote('', $shipping_methods[$method_name][2]);
            } else {
                // Standard
                foreach ($shipping as $curr_ship) {
                    $name = $curr_ship['name'];
                    // Compute the price for this shipping method and address id
                    list($a, $method_name) = explode(': ', $name);
                    if ($order->delivery['country']['id'] == SHIPPING_ORIGIN_COUNTRY && $shipping_methods[$method_name][1] == 'domestic_types' || $order->delivery['country']['id'] != SHIPPING_ORIGIN_COUNTRY && $shipping_methods[$method_name][1] == 'international_types') {
//.........这里部分代码省略.........

$payment_modules = new payment($transaction_data[0][4]);
// load the before_process function from the payment modules
//$payment_modules->before_process();
$QUERY = "SELECT id, credit, lastname, firstname, address, city, state, country, zipcode, phone, email, fax, currency " . "FROM cc_agent WHERE id = '" . $transaction_data[0][1] . "'";
$resmax = $DBHandle_max->Execute($QUERY);
if ($resmax) {
    $numrow = $resmax->RecordCount();
} else {
    write_log(LOGFILE_EPAYMENT, basename(__FILE__) . ' line:' . __LINE__ . "-transactionID={$transactionID}" . " ERROR NO SUCH CUSTOMER EXISTS, CUSTOMER ID = " . $transaction_data[0][1]);
    exit(gettext("No Such Customer exists."));
}
$customer_info = $resmax->fetchRow();
$nowDate = date("Y-m-d H:i:s");
$pmodule = $transaction_data[0][4];
$orderStatus = $payment_modules->get_OrderStatus();
$Query = "INSERT INTO cc_payments_agent ( agent_id, agent_name, agent_email_address, item_name, item_id, item_quantity, payment_method, cc_type, cc_owner, cc_number, " . " cc_expires, orders_status, last_modified, date_purchased, orders_date_finished, orders_amount, currency, currency_value) values (" . " '" . $transaction_data[0][1] . "', '" . $customer_info[3] . " " . $customer_info[2] . "', '" . $customer_info["email"] . "', 'balance', '" . $customer_info[0] . "', 1, '{$pmodule}', '" . $_SESSION["p_cardtype"] . "', '" . $transaction_data[0][5] . "', '" . $transaction_data[0][6] . "', '" . $transaction_data[0][7] . "',  {$orderStatus}, '" . $nowDate . "', '" . $nowDate . "', '" . $nowDate . "',  " . $amount_paid . ",  '" . $currCurrency . "', '" . $currencyObject->get_value($currCurrency) . "' )";
$result = $DBHandle_max->Execute($Query);
//************************UPDATE THE CREDIT IN THE CARD***********************
$id = $customer_info[0];
if ($id > 0) {
    $addcredit = $transaction_data[0][2];
    $instance_table = new Table("cc_agent", "");
    $param_update .= " credit = credit + '" . $amount_without_vat . "'";
    $FG_EDITION_CLAUSE = " id='{$id}'";
    $instance_table->Update_table($DBHandle, $param_update, $FG_EDITION_CLAUSE, $func_table = null);
    write_log(LOGFILE_EPAYMENT, basename(__FILE__) . ' line:' . __LINE__ . "-transactionID={$transactionID}" . " Update_table cc_card : {$param_update} - CLAUSE : {$FG_EDITION_CLAUSE}");
    $field_insert = "date, credit, agent_id, description";
    $value_insert = "'{$nowDate}', '" . $amount_without_vat . "', '{$id}', '" . $transaction_data[0][4] . "'";
    $instance_sub_table = new Table("cc_logrefill_agent", $field_insert);
    $id_logrefill = $instance_sub_table->Add_table($DBHandle, $value_insert, null, null, 'id');
    write_log(LOGFILE_EPAYMENT, basename(__FILE__) . ' line:' . __LINE__ . "-transactionID={$transactionID}" . " Add_table cc_logrefill : {$field_insert} - VALUES {$value_insert}");

     if (tep_not_null($author_name)) {
         $product_name .= ' by ' . $author_name;
     }
     $buyer_phone_number = '';
     $quantity_purchased = 1;
     $curr = 'USD';
     $item_tax = 0;
     $shipping_tax = 0;
     $shipping_price = $total_price - $item_price;
     $ship_phone_number = '';
 } else {
     list($order_code, $order_item_id, $purchase_date, $payments_date, $buyer_email, $buyer_name, $buyer_phone_number, $sku, $product_name, $quantity_purchased, $curr, $item_price, $item_tax, $shipping_price, $shipping_tax, $ship_service_level, $recipient_name, $ship_address_1, $ship_address_2, $ship_address_3, $ship_city, $ship_state, $ship_postal_code, $ship_country, $ship_phone_number) = $cell;
 }
 //			if ((int)$sku > 0) { echo 'order_code - ' . $order_code . '; order_item_id = ' . $order_item_id . '; purchase_date = ' . $purchase_date . '; payments_date = ' . $payments_date . '; buyer_email = ' . $buyer_email . '; buyer_name = ' . $buyer_name . '; buyer_phone_number = ' . $buyer_phone_number . '; sku = ' . $sku . '; product_name = ' . $product_name . '; quantity_purchased = ' . $quantity_purchased . '; curr = ' . $curr . '; item_price = ' . $item_price . '; item_tax = ' . $item_tax . '; shipping_price = ' . $shipping_price . '; shipping_tax = ' . $shipping_tax . '; ship_service_level = ' . $ship_service_level . '; recipient_name = ' . $recipient_name . '; ship_address_1 = ' . $ship_address_1 . '; ship_address_2 = ' . $ship_address_2 . '; ship_address_3 = ' . $ship_address_3 . '; ship_city= ' . $ship_city . '; ship_date = ' . $ship_state . '; ship_postal_code = ' . $ship_postal_code . '; ship_country = ' . $ship_country . '; ship_phone_number = ' . $ship_phone_number . '<br>'; die; }
 if ((int) $sku > 0 && in_array($order_code, $orders_to_upload)) {
     $currency_value = $currencies->get_value($curr);
     if ($order_code != $order_old_code) {
         if (tep_not_null($order_old_code)) {
             $global_queries = array_merge($global_queries, $sql_queries);
         }
         $ship_address = trim($ship_address_1 . ' ' . $ship_address_2 . '  ' . $ship_address_3);
         if (strpos($purchase_date, '+') !== false) {
             $purchase_date = str_replace('T', ' ', substr($purchase_date, 0, strrpos($purchase_date, '+')));
         } elseif (strpos($purchase_date, 'T') !== false) {
             $purchase_date = str_replace('T', ' ', substr($purchase_date, 0, strrpos($purchase_date, '-')));
         }
         $sql_data_array = array('orders_code' => $order_code, 'customers_id' => 0, 'customers_name' => $buyer_name, 'customers_street_address' => $ship_address, 'customers_suburb' => '', 'customers_city' => $ship_city, 'customers_postcode' => $ship_postal_code, 'customers_state' => $ship_state, 'customers_country' => $ship_country, 'customers_telephone' => $buyer_phone_number, 'customers_email_address' => $buyer_email, 'customers_address_format_id' => 5, 'delivery_name' => $recipient_name, 'delivery_company' => '', 'delivery_street_address' => $ship_address, 'delivery_suburb' => '', 'delivery_city' => $ship_city, 'delivery_postcode' => $ship_postal_code, 'delivery_state' => $ship_state, 'delivery_country' => $ship_country, 'delivery_telephone' => $ship_phone_number, 'delivery_address_format_id' => 5, 'billing_name' => $buyer_name, 'billing_company' => '', 'billing_street_address' => $ship_address, 'billing_suburb' => '', 'billing_city' => $ship_city, 'billing_postcode' => $ship_postal_code, 'billing_state' => $ship_state, 'billing_country' => $ship_country, 'billing_telephone' => $buyer_phone_number, 'billing_address_format_id' => 5, 'payment_method' => 'Bank card', 'date_purchased' => $purchase_date, 'orders_status' => DEFAULT_ORDERS_STATUS_ID, 'currency' => $curr, 'currency_value' => $currency_value, 'delivery_transfer' => '', 'orders_ssl_enabled' => 1, 'shops_id' => $upload_to_shop);
         //				echo '<pre>' . print_r($sql_data_array, true); die;
         tep_db_perform(TABLE_ORDERS, $sql_data_array);
         $insert_id = tep_db_insert_id();
         $uploaded_orders[] = $insert_id;

    write_log(LOGFILE_EPAYMENT, basename(__FILE__).' line:'.__LINE__."-transactionID=$transactionID"." ERROR NO SUCH CUSTOMER EXISTS, CUSTOMER ID = ".$transaction_data[0][1]);
    exit(gettext("No Such Customer exists."));
}
$customer_info = $resmax -> fetchRow();
$nowDate = date("Y-m-d H:i:s");

$pmodule = $transaction_data[0][4];

$orderStatus = $payment_modules->get_OrderStatus();

$Query = "Insert into cc_payments_agent ( agent_id, agent_name, agent_email_address, item_name, item_id, item_quantity, payment_method, cc_type, cc_owner, cc_number, " .
									" cc_expires, orders_status, last_modified, date_purchased, orders_date_finished, orders_amount, currency, currency_value) values (" .
									" '".$transaction_data[0][1]."', '".$customer_info[3]." ".$customer_info[2]."', '".$customer_info["email"]."', 'balance', '".
									$customer_info[0]."', 1, '$pmodule', '".$_SESSION["p_cardtype"]."', '".$transaction_data[0][5]."', '".$transaction_data[0][6]."', '".
									$transaction_data[0][7]."',  $orderStatus, '".$nowDate."', '".$nowDate."', '".$nowDate."',  ".$amount_paid.",  '".$currCurrency."', '".
									$currencyObject->get_value($currCurrency)."' )";
$result = $DBHandle_max -> Execute($Query);


//************************UPDATE THE CREDIT IN THE CARD***********************
$id = $customer_info[0];

if ($id > 0 ) {
    $addcredit = $transaction_data[0][2]; 
	$instance_table = new Table("cc_agent", "");
	$param_update .= " credit = credit+'".$amount_without_vat."'";
	$FG_EDITION_CLAUSE = " id='$id'";
	$instance_table -> Update_table ($DBHandle, $param_update, $FG_EDITION_CLAUSE, $func_table = null);
	write_log(LOGFILE_EPAYMENT, basename(__FILE__).' line:'.__LINE__."-transactionID=$transactionID"." Update_table cc_card : $param_update - CLAUSE : $FG_EDITION_CLAUSE");

	$field_insert = "date, credit, agent_id, description";

//.........这里部分代码省略.........
            //              && ($methods_hash[$method_name][1] == 'domestic_types'))
            //           || (($order->delivery['country']['id'] != SHIPPING_ORIGIN_COUNTRY)
            //              && ($methods_hash[$method_name][1] == 'international_types'))) {
            //          //								reset the shipping class to set the new address
            //          if (class_exists($methods_hash[$method_name][2])) {
            //            $GLOBALS[$methods_hash[$method_name][2]] = new $methods_hash[$method_name][2];
            //          }
            //        }
            //        $quotes = $shipping_modules->quote('', $methods_hash[$method_name][2]);
            //      } else {
            // Standard
            foreach ($shipping as $curr_ship) {
                $name = $curr_ship['name'];
                //            Compute the price for this shipping method and address id
                list($a, $method_name) = explode(': ', $name, 2);
                if ($order->delivery['country']['id'] == SHIPPING_ORIGIN_COUNTRY && $methods_hash[$method_name][1] == 'domestic_types' || $order->delivery['country']['id'] != SHIPPING_ORIGIN_COUNTRY && $methods_hash[$method_name][1] == 'international_types') {
                    //								reset the shipping class to set the new address
                    if (class_exists($methods_hash[$method_name][2])) {
                        $GLOBALS[$methods_hash[$method_name][2]] = new $methods_hash[$method_name][2]();
                    }
                }
            }
            $quotes = $shipping_modules->quote();
            //      }
            reset($shipping);
            foreach ($shipping as $curr_ship) {
                $name = $curr_ship['name'];
                //            Compute the price for this shipping method and address id
                list($a, $method_name) = explode(': ', $name, 2);
                unset($quote_povider);
                unset($quote_method);
                if ($order->delivery['country']['id'] == SHIPPING_ORIGIN_COUNTRY && $methods_hash[$method_name][1] == 'domestic_types' || $order->delivery['country']['id'] != SHIPPING_ORIGIN_COUNTRY && $methods_hash[$method_name][1] == 'international_types') {
                    foreach ($quotes as $key_provider => $shipping_provider) {
                        // privider name (class)
                        if ($shipping_provider['id'] == $methods_hash[$method_name][2]) {
                            // method name
                            $quote_povider = $key_provider;
                            if (is_array($shipping_provider['methods'])) {
                                foreach ($shipping_provider['methods'] as $key_method => $shipping_method) {
                                    if ($shipping_method['id'] == $methods_hash[$method_name][0]) {
                                        $quote_method = $key_method;
                                        break;
                                    }
                                }
                            }
                            break;
                        }
                    }
                }
                //if there is a problem with the method, i mark it as non-shippable
                if (isset($quotes[$quote_povider]['error']) || !isset($quotes[$quote_povider]['methods'][$quote_method]['cost'])) {
                    $price = "9999.09";
                    $shippable = "false";
                } else {
                    $price = $quotes[$quote_povider]['methods'][$quote_method]['cost'];
                    $shippable = "true";
                }
                // fix for item shipping function bug if called more than once in a session.
                $price = $price >= 0 ? $price : 0;
                $merchant_result = new GoogleResult($curr_id);
                $merchant_result->SetShippingDetails($name, $currencies->get_value(DEFAULT_CURRENCY) * $price, $shippable);
                if ($data[$root]['calculate']['tax']['VALUE'] == "true") {
                    //Compute tax for this address id and shipping type
                    $amount = 15;
                    // Modify this to the actual tax value
                    $merchant_result->SetTaxDetails($currencies->get_value(DEFAULT_CURRENCY) * $amount);
                }
                ////							 start cupons and gift processing (working)
                //								// only one coupon per order is valid!
                //                $_POST['dc_redeem_code'] = 'ROPU';
                //
                ////                require(DIR_WS_CLASSES . 'order.php');
                ////                $order = new order;
                //                require_once(DIR_WS_CLASSES . 'order_total.php');
                //                $order_total_modules = new order_total;
                ////                $order_total_modules->collect_posts();
                ////                $order_total_modules->pre_confirmation_check();
                //
                ////                print_r($order_total_modules);
                //                   $order_totals = $order_total_modules->process();
                ////                print_r($order_totals);
                //
                calculate_coupons($Gresponse, $merchant_result, $price);
                // end cupons
                $merchant_calc->AddResult($merchant_result);
            }
        } else {
            $merchant_result = new GoogleResult($curr_id);
            if ($data[$root]['calculate']['tax']['VALUE'] == "true") {
                //Compute tax for this address id and shipping type
                $amount = 15;
                // Modify this to the actual tax value
                $merchant_result->SetTaxDetails($currencies->get_value(DEFAULT_CURRENCY) * $amount);
            }
            calculate_coupons($Gresponse, $merchant_result);
            $merchant_calc->AddResult($merchant_result);
        }
    }
    $Gresponse->ProcessMerchantCalculations($merchant_calc);
}

$tansaction_ID = null;
$QUERY = "SELECT  username, credit, lastname, firstname, address, city, state, country, zipcode, phone, email, fax, lastuse, activated, currency FROM cc_card WHERE id = '" . $transaction_data[0][1] . "'";
$numrow = 0;
$resmax = $DBHandle_max->Execute($QUERY);
if ($resmax) {
    $numrow = $resmax->RecordCount();
}
if ($numrow == 0) {
    write_log(LOGFILE_EPAYMENT, basename(__FILE__) . ' line:' . __LINE__ . "-transactionID={$transactionID}" . " ERROR NO SUCH CUSTOMER EXISTS, CUSTOMER ID = " . $transaction_data[0][1]);
    exit(gettext("No Such Customer exists."));
}
$customer_info = $resmax->fetchRow();
$nowDate = date("Y-m-d H:i:s");
$pmodule = $transaction_data[0][4];
$orderStatus = $payment_modules->get_OrderStatus();
$Query = "Insert into cc_payments ( customers_id,\n                                    customers_name,\n                                    customers_email_address,\n                                    item_name,\n                                    item_id,\n                                    item_quantity,\n                                    payment_method,\n                                    cc_type,\n                                    cc_owner,\n                                    cc_number,\n                                    cc_expires,\n                                    orders_status,\n                                    last_modified,\n                                    date_purchased,\n                                    orders_date_finished,\n                                    orders_amount,\n                                    currency,\n                                    currency_value)\n                                    values\n                                    (\n                                    '" . $transaction_data[0][1] . "',\n                                    '" . $customer_info[3] . " " . $customer_info[2] . "',\n                                    '" . $customer_info["email"] . "',\n                                    'balance',\n                                    '" . $customer_info[0] . "',\n                                    1,\n                                    '{$pmodule}',\n                                    '" . $_SESSION["p_cardtype"] . "',\n                                    '" . $transaction_data[0][5] . "',\n                                    '" . $transaction_data[0][6] . "',\n                                    '" . $transaction_data[0][7] . "',\n                                     {$orderStatus},\n                                    '" . $nowDate . "',\n                                    '" . $nowDate . "',\n                                    '" . $nowDate . "',\n                                     " . $amount_paid . ",\n                                     '" . $currCurrency . "',\n                                     '" . $currencyObject->get_value($currCurrency) . "'\n                                    )";
$result = $DBHandle_max->Execute($Query);
//************************UPDATE THE CREDIT IN THE CARD***********************
$id = 0;
if ($customer_info[0] > 0 && $orderStatus == 2) {
    /* CHECK IF THE CARDNUMBER IS ON THE DATABASE */
    $instance_table_card = new Table("cc_card", "username, id");
    $FG_TABLE_CLAUSE_card = "username='" . $customer_info[0] . "'";
    $list_tariff_card = $instance_table_card->Get_list($DBHandle, $FG_TABLE_CLAUSE_card, null, null, null, null, null, null);
    //print_r($list_tariff_card);
    if ($customer_info[0] == $list_tariff_card[0][0]) {
        $id = $list_tariff_card[0][1];
    }
    write_log(LOGFILE_EPAYMENT, basename(__FILE__) . ' line:' . __LINE__ . "-transactionID={$transactionID}" . " CARD FOUND IN DB ({$id})");
}
if ($id > 0) {

             $ot_shipping = $v['value'];
             break;
         default:
             if (substr($v['text'], 0, 1) === '-') {
                 $discount += (double) $v['value'];
             }
             break;
     }
     $orders_totals .= '<tr>
             <td align="right" class="ot-subtotal-Text">' . $v['title'] . '</td>
             <td align="right" class="ot-subtotal-Amount">' . $currencies->format($v['value'], true, $order->info['currency']) . '</td>
           </tr>';
 }
 $orders_totals .= '</tbody></table>';
 $shipping_cost = $ot_shipping;
 $var['amount'] = number_format($order->info['total'] * $currencies->get_value($var['currency']), 2, '.', '');
 // 商品价格
 $var['shippingfee'] = number_format($shipping_cost * $currencies->get_value($var['currency']), 2, '.', '');
 // 运费
 $var['vat'] = number_format(($ot_total + $discount - $ot_subtotal - $ot_shipping) * $currencies->get_value($var['currency']), 2, '.', '');
 // 附加费用
 $var['discount'] = number_format($discount * $currencies->get_value($var['currency']), 2, '.', '');
 // 打折
 $var['total_output'] = base64_encode($orders_totals);
 // 商品名称、商品描述、商户数据包
 foreach ($order->products as $k => $products) {
     $var["product_name[{$k}]"] = ' ';
     //$products['name'];
     if (is_array($products['attributes'])) {
         foreach ($products['attributes'] as $attribute) {
             $var["product_name[{$k}]"] .= "\n {$attribute['option']}:{$attribute['value']}";