0) {
$row = mysqli_fetch_array($result);
$send_row = mysqli_fetch_array(smart_mysql_query("SELECT * FROM exchangerix_currencies WHERE currency_id='".(int)$row['from_currency_id']."' LIMIT 1"));
$receive_row = mysqli_fetch_array(smart_mysql_query("SELECT * FROM exchangerix_currencies WHERE currency_id='".(int)$row['to_currency_id']."' LIMIT 1"));
if (isset($_POST['action']) && $_POST['action'] == "change_status")
{
unset($errors);
$errors = array();
$exchange_id = (int)$row['exchange_id'];
$send_notification = (int)getPostParameter('send_notification');
$status = mysqli_real_escape_string($conn, getPostParameter('status'));
if (in_array($status, $statuses_arr))
{
if ($status == "confirmed")
{
//smart_mysql_query("UPDATE exchangerix_currencies SET total_exchanges=total_exchanges+1 WHERE currency_id='".(int)$trow['from_currency_id']."' LIMIT 1");
smart_mysql_query("UPDATE exchangerix_exdirections SET today_exchanges=today_exchanges+1, total_exchanges=total_exchanges+1, last_exchange_date=NOW() WHERE exdirection_id='".(int)$row['exdirection_id']."' LIMIT 1");
//smart_mysql_query("UPDATE exchangerix_settings SET setting_value='' WHERE setting_key='total_exchanges_usd' LIMIT 1");
//dev
}elseif ($status == "declined" || $status == "cancelled")
{
// update reserve
smart_mysql_query("UPDATE exchangerix_currencies SET reserve+='".floatval($row['receive_amount'])."', status='pending' WHERE currency_id='".(int)$row['to_currency_id']."' LIMIT 1");
}
smart_mysql_query("UPDATE exchangerix_exchanges SET status='$status', updated=NOW(), process_date=NOW() WHERE exchange_id='$exchange_id' LIMIT 1");
}
if ($send_notification == 1)
{
//////////////////////////////// Send notification ////////////////////////
if ($status == "paid")
{
$etemplate = GetEmailTemplate('payment_success');
}
elseif ($status == "declined")
{
$etemplate = GetEmailTemplate('payment_declined');
}
$esubject = $etemplate['email_subject'];
$emessage = $etemplate['email_message'];
$emessage = str_replace("{transaction_id}", $row['reference_id'], $emessage);
$emessage = str_replace("{first_name}", $row['client_details'], $emessage);
if ($trow['transaction_commision'] != "0.0000")
$amount = $row['receive_amount']-$row['transaction_commision'];
else
$amount = $row['receive_amount'];
//$emessage = str_replace("{amount}", DisplayMoney($amount), $emessage);
//$row['exchange_amount']
$emessage = str_replace("{reason}", $reason, $emessage);
$to_email = $row['client_email'].' <'.$row['client_email'].'>';
SendEmail($to_email, $esubject, $emessage, $noreply_mail = 1);
}
header("Location: exchanges.php?msg=updated");
exit();
}
////////////////
$title = "Exchange Details";
require_once ("inc/header.inc.php");
?>
Exchange Details #
| ID: |
|
| Reference ID: |
|
0) { ?>
| Member: |
|
| Exchanges: |
|
| User: |
Visitor |
| Country: |
 |
0) { ?>
| Referral ID: |
(ID: ) |
| Comment: |
|
| Created: |
|
| Updated: |
|
| Process Date: |
|
| Status: |
confirmed"; break;
case "pending": echo "awaiting confirmation"; break;
case "waiting": echo "waiting for payment"; break;
case "declined": echo " declined"; break;
case "failed": echo "failed"; break;
case "cancelled": echo " cancelled"; break;
case "timeout": echo " timeout"; break;
case "request": echo "awaiting approval"; break;
case "paid": echo "paid"; break;
default: echo "".$row['status'].""; break;
}
?>
|
Proceed Exchange
Edit Exchange
Go Back
Delete
Exchange Details
Sorry, no exchange found.