<?php
include 'includes/dbconnection.php';
require_once 'includes/function.php';
include 'includes/function1.php';
include 'admin/includes/mailbody_replytemplate.php';
echo "BARDO";
$data7 = "";
$data1 = isset($HTTP_GET_VARS["SHOP_NUMBER"]) ? $HTTP_GET_VARS["SHOP_NUMBER"] : "0";
$data2 = isset($HTTP_GET_VARS["BARDO_NUMBER"]) ? $HTTP_GET_VARS["BARDO_NUMBER"] : "N";
$data3 = isset($HTTP_GET_VARS["TRANSAC_STATUS"]) ? $HTTP_GET_VARS["TRANSAC_STATUS"] : "S";
$data4 = isset($HTTP_GET_VARS["STATUS_DETAILLED"]) ? $HTTP_GET_VARS["STATUS_DETAILLED"] : "D";
$data5 = isset($HTTP_GET_VARS["3DS"]) ? $HTTP_GET_VARS["3DS"] : "3";
$data6 = func_get_current_date_time();
if ($data3 == "00") {
$data7 = "S";
} else {
$data7 = "F";
}
/*$qryInsert = "insert into cs_bardo (shop_number,bardo_number,transac_status,status_detailed,ds,trans_date,status) values ";
$qryInsert .= " ($data1,'$data2','$data3','$data4','$data5','$data6','$data7')";
if(!mysql_query($qryInsert,$cnn_cs)) { dieLog(mysql_errno().": ".mysql_error()."<BR>");
}*/
if ($data3 == "00") {
func_send_transaction_success_mail($data1);
} else {
func_send_transaction_failure_mail($data1, $data4);
}
$qrt_insert_bankdetails = "insert into cs_volpay (trans_id,user_id,currency,amount,trans_status,return_code,return_message) values({$TransNumber},{$i_company_id},'{$currencyCode}',{$transactAmount},'{$transStatus}','{$returnCode}','{$returnMessage}') ";
// print($qrt_insert_bankdetails);
if (!($show_sql = mysql_query($qrt_insert_bankdetails, $cnn_cs))) {
print mysql_errno() . ": " . mysql_error() . "<BR>";
print "Cannot execute queryin";
exit;
}
$approval_status = $transStatus == "Success" ? "A" : "D";
$decline_reason = $transStatus == "Success" ? "" : $returnCode . " : " . $returnMessage;
$pass_status = "";
if ($transaction_type != "tele") {
$pass_status = "PA";
}
func_update_approval_status($cnn_cs, $TransNumber, $approval_status, $pass_status, $decline_reason);
if ($transStatus == "Success") {
func_send_transaction_success_mail($trans_id);
} else {
// func_send_transaction_failure_mail($TransNumber, $returnMessage."-".$returnCode);
}
}
?>
<title>Volpay display result</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table border="0" cellpadding="0" width="100%" cellspacing="0" height="60%" >
<tr><td width="83%" valign="top" align="center" height="333">
<table border="0" cellpadding="0" cellspacing="0" width="600" height="70%" class="disbd">
<tr>
<td width="100%" valign="top" align="center" bgcolor="#999999" height="20">
<img border="0" SRC="<?php
$strMessage .= $returnMessage . "-" . $returnCode;
$transStatus = "Failure";
}
if (strpos($responseDesc, "success")) {
$returnMessage = GetElementByName($Nodes[$i], "<message>", "</message>");
$returnCode = GetElementByName($Nodes[$i], "<tan>", "</tan>");
$transNo = GetElementByName($Nodes[$i], "<etan>", "</etan>");
$strMessage = "<h3>Thank-you for your order</h3>Your order number is {$TransNumber}.Your Order has been Approved and Please refer to this in any correspondence.";
//$msgtodisplay .= $returnMessage."-".$returnCode ;
$transStatus = "Success";
}
$qry_select = "select reference_number from cs_transactiondetails where transactionId={$TransNumber}";
$select_sql = mysql_query($qry_select, $cnn_cs);
$value = mysql_fetch_array($select_sql);
$ref_num = $value[0];
$qrt_insert_bankdetails = "insert into cs_volpay (trans_id,user_id,currency,amount,trans_status,return_code,return_message,reference_number) values('{$TransNumber}','{$i_company_id}','{$currencyCode}',{$transactAmount},'{$transStatus}','{$returnCode}','{$returnMessage}','{$ref_num}') ";
if (!($show_sql = mysql_query($qrt_insert_bankdetails, $cnn_cs))) {
dieLog(mysql_errno() . ": " . mysql_error() . "<BR>");
}
$approval_status = $transStatus == "Success" ? "A" : "D";
$decline_reason = $transStatus == "Success" ? "" : $returnCode . " : " . $returnMessage;
$pass_status = "";
if ($transactionType != "tele") {
$pass_status = "PA";
}
func_update_approval_status($cnn_cs, $TransNumber, $approval_status, $pass_status, $decline_reason);
if ($transStatus == "Success") {
func_send_transaction_success_mail($TransNumber);
}
}
exit;
<?php
require_once "includes/dbconnection.php";
require_once 'includes/function.php';
include 'admin/includes/mailbody_replytemplate.php';
$email_from = "";
$email_to = "*****@*****.**";
$email_subject = "Txt Mail Test";
$strCompanyName = "Gale";
$strUserName = "******";
$strPassword = "******";
func_send_transaction_success_mail("2023");
/*$email_message = func_getreplymailbody_txt();
$email_message = str_replace("[CompanyName]", "Gale Technologies Pvt. Ltd.", $email_message);
$email_message = str_replace("[CustomerName]", "Jayakrishnan.V", $email_message);
$email_message = str_replace("[CreditCardNumber]", "411111111111111", $email_message);
$email_message = str_replace("[CardExpiry]", "12/04", $email_message);
$email_message = str_replace("[BillingDescriptor]", "Test Billing Descriptor", $email_message);
$email_message = str_replace("[OrderTime]", "2004-07-22 06:56:22", $email_message);
$email_message = str_replace("[ChargeAmount]", "1250.00", $email_message);
$email_message = str_replace("[Currency]", "USD", $email_message);
if(!func_send_mail_txtformat($email_from,$email_to,$email_subject,$email_message))
{
print "An error encountered while sending the mail.";
exit();
} else {
print "mail sent successfully";
}*/
function func_send_transaction_success_mail($trans_id)
{
$headers = "";