<?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);
}
$how_about_us = isset($HTTP_POST_VARS['how_about_us']) ? Trim($HTTP_POST_VARS['how_about_us']) : "";
$voulmeNumber = isset($HTTP_POST_VARS['merchant_voulme']) ? Trim($HTTP_POST_VARS['merchant_voulme']) : "";
$reseller = isset($HTTP_POST_VARS['reseller']) ? Trim($HTTP_POST_VARS['reseller']) : "";
$msgtodisplay = "";
if ($transaction_type == "tele") {
$send_ecommercemail = 0;
} else {
$send_ecommercemail = 1;
}
$qry_select1 = "Select companyname,email ,url1 from cs_companydetails where userid='{$gatewayid}'";
$rst_select1 = mysql_query($qry_select1, $cnn_cs);
$rst_result1 = mysql_fetch_array($rst_select1);
$companyname1 = $rst_result1['companyname'];
$email1 = $rst_result1['email'];
$url1 = $rst_result1['url1'];
$current_date_time = func_get_current_date_time();
$user_nameexist = 0;
if ($company) {
$user_nameexist = func_checkUsernameExistInAnyTable($username, $cnn_cs);
$user_companyexist = func_checkCompanynameExistInAnyTable($companyname, $cnn_cs);
$user_mailidexist = func_checkEmailExistInAnyTable($email, $cnn_cs);
$qry_select_user = "******";
//print $qry_select_user;
if ($user_nameexist == 1) {
$msgtodisplay = "<table width='350' height='100' align='center' valign='middle' style='border:1px solid black'><tr><td align='center' valign='middle'><font face='verdana' size='1' color='red'>Existing username !! </font></td></tr><tr><td align='center'><a href='javascript:window.history.back();'><img border='0' src='images/back.jpg'></a></td></tr></table>";
} elseif ($user_companyexist == 1) {
$msgtodisplay = "<table width='350' height='100' align='center' valign='middle' style='border:1px solid black'><tr><td align='center' valign='middle'><font face='verdana' size='1' color='red'>Existing Company name !! </font></td></tr><tr><td align='center'><a href='javascript:window.history.back();'><img border='0' src='images/back.jpg'></a></td></tr></table>";
} elseif ($user_mailidexist == 1) {
$msgtodisplay = "<table width='350' height='100' align='center' valign='middle' style='border:1px solid black'><tr><td align='center' valign='middle'><font face='verdana' size='1' color='red'>Existing Mail ID !! </font></td></tr><tr><td align='center'><a href='javascript:window.history.back();'><img border='0' src='images/back.jpg'></a></td></tr></table>";
} else {
$qry_insert_user = "******";
<head>
<title>Call Back Setting</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" bgcolor="#F2F2F2">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" height="100%">
<tr>
<td align="center">
<?php
$iTransactionId = isset($HTTP_GET_VARS["id"]) ? Trim($HTTP_GET_VARS["id"]) : "";
if ($iTransactionId != "") {
$qryGetUser = "******" . $iTransactionId;
$iUserId = funcGetValueByQuery($qryGetUser, $cnn_cs);
$qryGetUserName = "******" . $iUserId;
$iUserName = funcGetValueByQuery($qryGetUserName, $cnn_cs);
$strCurrentDateTime = func_get_current_date_time();
$qryInsert = "insert into cs_callback (userid,transactionid,dateandtime) values (";
$qryInsert .= "'{$iUserId}','{$iTransactionId}','{$strCurrentDateTime}')";
if (!mysql_query($qryInsert)) {
print "Can not execute query";
exit;
}
?>
<font face="Verdana, Arial, Helvetica, sans-serif" size="2">A call back message is set for <?php
echo $iUserName;
?>
</font>
<br><br>
<input type="button" value="Close" onClick="window.close();">
<?php
$str_current_date = func_get_current_date();
$i_to_year = substr($str_current_date, 0, 4);
$i_to_month = substr($str_current_date, 5, 2);
$i_to_day = substr($str_current_date, 8, 2);
/*$i_to_year = substr($str_return_date,0,4);
$i_to_month = substr($str_return_date,5,2);
$i_to_day = substr($str_return_date,8,2); */
$str_from_date = $i_from_year . "-" . $i_from_month . "-" . $i_from_day;
$str_to_date = $i_to_year . "-" . $i_to_month . "-" . $i_to_day;
if ($tran_login_type == "tele") {
$str_return_date = date("Y m d H:i", mktime(0, 0, 0, $i_to_month, $i_to_day + 1, $i_to_year));
$i_to_year = substr($str_return_date, 0, 4);
$i_to_month = substr($str_return_date, 5, 2);
$i_to_day = substr($str_return_date, 8, 2);
}
$dateToEnter = func_get_current_date_time();
//EST Time.
//$dateToEnter="$yyyy-$mm-$dd $hr:$mn:$tt";
// $dateToEnter1="$yyyy-$mm-$dd";
$domain = GetHostByName($_SERVER["REMOTE_ADDR"]);
?>
<script language="javascript" src="scripts/general.js"></script>
<script language="javascript">
function showDetails(the_sub){
/*if(the_sub =="div1" ){
if(document.getElementById(the_sub).style.display=="") {
document.chequeFrm.statusdiv1.value="";
document.getElementById(the_sub).style.display = "none";
return false;
} else {
document.chequeFrm.statusdiv1.value=true;
$usdi_crddiscount_amt = $i_discount_rate * $trans_amount / 100 + $usdi_crddiscount_amt;
$usdi_crdreserve_amt = $i_reserve * $trans_amount / 100 + $usdi_crdreserve_amt;
}
if ($trans_status == "D") {
$usdcreditdeclined = $usdcreditdeclined + 1;
$usdcreditdeclinedAmt = $usdcreditdeclinedAmt + $trans_amount;
}
} else {
$usdcreditpending = $usdcreditpending + 1;
$usdcreditpendingAmt = $usdcreditpendingAmt + $trans_amount;
}
}
}
}
//end of for loop
$approvedstatusdate = func_get_current_date_time();
$qry_bankexit = "select * from cs_invoicedetails where bank_id='{$ibankid}' and userId={$iuserid}";
if (!($rst_bankexist = mysql_query($qry_bankexit, $cnn_cs))) {
print mysql_errno() . ": " . mysql_error() . "<BR>";
exit;
print "cannot execute select query nnnn";
} else {
$num_records = mysql_num_rows($rst_bankexist);
if ($num_records > 0) {
$datearray = explode("-", $approvedstatusdate);
$year = $datearray[0] . "<br>";
$month = $datearray[1] . "<br>";
$day = $datearray[2] . "<br>";
$time = mktime(0, 0, 0, $month, $day, $year);
$cancelenddate = strtotime("-1 day", $time);
$cancelenddate = date('Y-m-d', $cancelenddate);
// VT_blank.php,creditcardfb.php,customerservice_blank.php,report_custom.php,callback.php,ledger.php
//viewcancelpage.php: The cancel page functions for viewing the company transaction details.
include 'includes/sessioncheck.php';
require_once "includes/dbconnection.php";
include 'includes/header.php';
require_once 'includes/function.php';
$headerInclude = "transactions";
include "includes/topheader.php";
$sessionlogin = isset($HTTP_SESSION_VARS["sessionlogin"]) ? $HTTP_SESSION_VARS["sessionlogin"] : "";
if ($sessionlogin != "") {
$cancel = isset($HTTP_GET_VARS['cancel']) ? Trim($HTTP_GET_VARS['cancel']) : "";
$cancelreason = isset($HTTP_GET_VARS['cancelreason']) ? Trim($HTTP_GET_VARS['cancelreason']) : "";
$id = isset($HTTP_GET_VARS['id']) ? Trim($HTTP_GET_VARS['id']) : "";
$cnumber = isset($HTTP_GET_VARS['cnumber']) ? Trim($HTTP_GET_VARS['cnumber']) : "";
$tele_number = isset($HTTP_GET_VARS['telnumber']) ? Trim($HTTP_GET_VARS['telnumber']) : "";
$canceldate = func_get_current_date_time();
if ($id == "") {
$id = isset($HTTP_POST_VARS['id']) ? Trim($HTTP_POST_VARS['id']) : "";
if ($cnumber == "") {
$cnumber = isset($HTTP_POST_VARS['cnumber']) ? Trim($HTTP_POST_VARS['cnumber']) : "";
}
}
$other = isset($HTTP_GET_VARS['other']) ? Trim($HTTP_GET_VARS['other']) : "";
if ($cancel) {
$iTransactionId = $id;
$return_insertId = func_transaction_updatenew($iTransactionId, $cnn_cs);
$query = "Update transactiondetails set cancelstatus='Y' where transactionId={$return_insertId} and userid={$sessionlogin}";
// echo $query;
mysql_query($query);
if (mysql_affected_rows() == 0) {
$outhtml = "y";
function funcCallBack($cnn_cs, $iTransactionId)
{
if ($iTransactionId != "") {
$qryGetUser = "******" . $iTransactionId;
$iUserId = funcGetValueByQuery($qryGetUser, $cnn_cs);
$qryGetUserName = "******" . $iUserId;
$iUserName = funcGetValueByQuery($qryGetUserName, $cnn_cs);
$strCurrentDateTime = func_get_current_date_time();
$qryInsert = "insert into cs_callback (userid,transactionid,dateandtime) values (";
$qryInsert .= "'{$iUserId}','{$iTransactionId}','{$strCurrentDateTime}')";
if (!mysql_query($qryInsert)) {
print "Can not execute query";
exit;
}
}
}
function func_upload_file($cnn_cs, $file_object, $company_id, $file_type)
{
$return_status = "Success";
$b_file_exists = false;
$str_current_date_time = func_get_current_date_time();
extract($file_object, EXTR_PREFIX_ALL, 'uf2');
if ($uf2_name != "") {
$svr = $_SERVER["PATH_TRANSLATED"];
$path_parts = pathinfo($svr);
$str_current_path = $path_parts["dirname"];
$str_file_name = $uf2_name;
$str_current_path = "";
$str_file_name = str_replace(" ", "", $str_file_name);
$str_current_path .= "../gateway/" . $_SESSION['gw_folder'] . "UserDocuments/{$file_type}/" . $company_id . "_" . $str_file_name;
//print ("path=$str_current_path");
if (filesize($uf2_tmp_name) != 0) {
if (file_exists($str_current_path)) {
$b_file_exists = true;
}
if (copy($uf2_tmp_name, $str_current_path)) {
if (!$b_file_exists) {
$str_query = "insert into cs_uploaded_documents(user_id, file_type, file_name, date_uploaded, status) values({$company_id}, '{$file_type}', '" . $company_id . "_" . $str_file_name . "', '{$str_current_date_time}', 'P')";
if (!sql_query_write($str_query, $cnn_cs)) {
dieLog(mysql_errno() . ": " . mysql_error() . "<BR>{$str_query}");
}
}
} else {
$return_status = "Upload failed, please try again";
}
} else {
$return_status = "Invalid file, please upload a valid file";
}
}
return $return_status;
}
function func_upload_file($cnn_cs, $file_object, $company_id, $file_type)
{
global $curUserInfo;
$return_status = "";
$b_file_exists = false;
$str_current_date_time = func_get_current_date_time();
extract($file_object, EXTR_PREFIX_ALL, 'uf2');
if ($uf2_name != "") {
$svr = $_SERVER["PATH_TRANSLATED"];
$path_parts = pathinfo($svr);
$str_current_path = $path_parts["dirname"];
$str_file_name = $uf2_name;
$str_current_path = "";
$str_file_name = str_replace(" ", "", $str_file_name);
if ($file_type == "License") {
$str_current_path .= "gateway/" . $_SESSION['gw_folder'] . "UserDocuments/License/" . $company_id . "_" . $str_file_name;
} else {
if ($file_type == "Articles") {
$str_current_path .= "gateway/" . $_SESSION['gw_folder'] . "UserDocuments/Articles/" . $company_id . "_" . $str_file_name;
} else {
if ($file_type == "History") {
$str_current_path .= "gateway/" . $_SESSION['gw_folder'] . "UserDocuments/History/" . $company_id . "_" . $str_file_name;
} else {
if ($file_type == "Contract") {
$str_current_path .= "gateway/" . $_SESSION['gw_folder'] . "UserDocuments/Contract/" . $company_id . "_" . $str_file_name;
} else {
if ($file_type == "Professional_Reference") {
$str_current_path .= "gateway/" . $_SESSION['gw_folder'] . "UserDocuments/Professional_Reference/" . $company_id . "_" . $str_file_name;
}
}
}
}
}
if (filesize($uf2_tmp_name) != 0) {
if (file_exists($str_current_path)) {
$b_file_exists = true;
}
if (copy($uf2_tmp_name, $str_current_path)) {
$return_status = "{$str_file_name}@#@Upload Success";
if (!$b_file_exists) {
$str_query = "insert into cs_uploaded_documents(user_id, ud_en_ID, file_type, file_name, date_uploaded) values( '" . $curUserInfo['userId'] . "', '" . $curUserInfo['en_ID'] . "', '{$file_type}', '" . $company_id . "_" . $str_file_name . "', '{$str_current_date_time}')";
if (!mysql_query($str_query, $cnn_cs)) {
dieLog(mysql_errno() . ": " . mysql_error() . "<BR>{$str_query}");
}
$i_num_documents = 0;
$str_query = "select count(distinct(file_type)) from cs_uploaded_documents where ud_en_ID = " . $curUserInfo['en_ID'] . "";
if (!($show_sql = mysql_query($str_query, $cnn_cs))) {
dieLog(mysql_errno() . ": " . mysql_error() . "<BR>{$str_query}");
}
if (mysql_num_rows($show_sql) > 0) {
$i_num_documents = mysql_result($show_sql, 0, 0);
}
$completion = "";
}
} else {
$return_status = "{$str_file_name}@#@Upload Failed";
}
} else {
$return_status = "{$str_file_name}@#@Invalid file";
}
}
return $return_status;
}
