<?php
$by = 'transactionId';
if (!$id && !$reference_number) {
doTable("Transaction Invalid", "Error", NULL, true, true, true);
die;
}
if (!$id && $reference_number) {
$transactionInfo = getTransactionInfo($reference_number, $display_test_transactions, 'reference_number');
} else {
$transactionInfo = getTransactionInfo($id, $display_test_transactions);
}
if (!is_array($transactionInfo)) {
doTable("Transaction Not Found", "Error", NULL, true, true, true);
die;
}
$activity = UserActivity($transactionInfo);
if ($activity == "ACT") {
$act = "User Account is Active (Active).";
} else {
if ($activity == "UNF") {
$act = "User Account Not Found (Inactive).";
} else {
if ($activity == "PNF") {
$act = "Password Incorrect (Inactive).";
} else {
if ($activity == "SNF") {
$act = "Site Not Found (Inactive).";
} else {
if ($activity == "INA") {
$act = "User Account is inactive (Inactive).";
} else {
function getTransactionInfo($id, $test = false, $by = 'transactionId', $where_sql = "")
{
global $cnn_cs;
$trans_table_name = "cs_transactiondetails";
if ($test) {
$trans_table_name = "cs_test_transactiondetails";
}
$sql = "\n\t\t\tSELECT \n\t\t\t\tt.*, DATE_FORMAT(t.transactionDate,'%M %D %Y at %r') as transaction_date_formatted,\n\t\t\t\tsub.*,\n\t\t\t\t\tc.contact_email,\n\t\t\t\t\tc.customer_service_phone,\n\t\t\t\t\tc.cc_billingdescriptor,\n\t\t\t\t\tc.ch_billingdescriptor,\n\t\t\t\t\tc.cc_visa_billingdescriptor,\n\t\t\t\t\tc.cc_master_billingdescriptor,\n\t\t\t\t\tc.we_billingdescriptor, \n\t\t\t\t\tc.cd_recieve_order_confirmations,\n\t\t\t\t\tc.we_billingdescriptor,\n\t\t\t\t\tc.companyname, \n\t\t\t\t\tc.cd_tracking_init_response, \n\t\t\t\t\tc.cd_enable_tracking, \n\t\t\t\t\tc.gateway_id, \n\t\t\t\t\tc.bank_Creditcard,\n\t\t\t\t\ts.*, \n\t\t\t\t\t(r.note_id is not null) as hasRefundRequest,\n\t\t\t\t\t r.call_date_time, \n\t\t\t\t\t r.service_notes \n\t\t\tFROM \n\t\t\t\t{$trans_table_name} as t\n\t\t\tLEFT JOIN `cs_subscription` as sub ON sub.`ss_ID` = t.`td_ss_ID`\n\t\t\tLEFT JOIN `cs_companydetails` as c ON c.`userId` = t.`userId`\n\t\t\tLEFT JOIN `cs_company_sites` as s ON `cs_ID` = `td_site_ID`\n\t\t\tleft join cs_callnotes as r on r.`transaction_id`=t.`transactionId` AND r.cn_type = 'refundrequest' \n\t\t\tWHERE \n\t\t\t\t`{$by}` = '{$id}' \n\t\t\t\t{$where_sql}\n\t\t\t\t";
$result = sql_query_read($sql, $cnn_cs) or dieLog(mysql_errno() . ": " . mysql_error() . "<BR>{$sql}<BR>");
if (mysql_num_rows($result) <= 0) {
return -1;
}
$transactionInfo = mysql_fetch_assoc($result);
$transactionInfo['CCnumber'] = etelDec($transactionInfo['CCnumber']);
$transactionInfo['bankaccountnumber'] = etelDec($transactionInfo['bankaccountnumber']);
$transactionInfo['bankaccountnumber'] = "XXXXXX" . substr($transactionInfo['bankaccountnumber'], -4, 4);
$transactionInfo['CCnumber_format'] = "XXXXXXXXXXXX" . substr($transactionInfo['CCnumber'], -4, 4);
$time = strtotime($transactionInfo['transactionDate']);
$subAcc = getRebillInfo($transactionInfo['td_rebillingID'], $time, false);
$transactionInfo['userActiveCode'] = UserActivity(&$transactionInfo);
$transactionInfo['userRebillCode'] = UserRebill(&$transactionInfo);
//Shipping
if ($transactionInfo['cd_enable_tracking'] == 'on') {
$transactionInfo['Tracking_Deadline'] = $time + $transactionInfo['cd_tracking_init_response'] * 24 * 60 * 60;
$transactionInfo['Tracking_Days_Left'] = floor(($transactionInfo['Tracking_Deadline'] - time()) / (24 * 60 * 60));
}
if ($transactionInfo['userActiveCode'] == "ACT") {
$transactionInfo['userActiveMsg'] = "Account is Active, ";
} else {
if ($transactionInfo['userActiveCode'] == "INA") {
$transactionInfo['userActiveMsg'] = "Account is Inactive, ";
} else {
if ($transactionInfo['userActiveCode'] == "CAN") {
$transactionInfo['userActiveMsg'] = "Account is Cancelled, ";
} else {
if ($transactionInfo['userActiveCode'] == "CHB") {
$transactionInfo['userActiveMsg'] = "Account has been Charged Back, ";
}
}
}
}
if ($transactionInfo['userRebillCode'] == "ACT") {
$transactionInfo['userActiveMsg'] .= "Rebilling is Active.";
} else {
if ($transactionInfo['userRebillCode'] == "INA") {
$transactionInfo['userActiveMsg'] .= "Rebilling is Inactive.";
}
}
if ($transactionInfo['checkorcard'] == 'H') {
$transactionInfo['charge_type_info'] = "Credit Card (" . $transactionInfo['cardtype'] . ")";
if ($transactionInfo['cardtype'] == "Visa") {
$transactionInfo['billingdescriptor'] = $transactionInfo['cc_visa_billingdescriptor'];
}
if ($transactionInfo['cardtype'] == "Master") {
$transactionInfo['billingdescriptor'] = $transactionInfo['cc_master_billingdescriptor'];
}
}
if ($transactionInfo['checkorcard'] == 'C') {
$transactionInfo['charge_type_info'] = "Check Account";
$transactionInfo['billingdescriptor'] = $transactionInfo['ch_billingdescriptor'];
}
if ($transactionInfo['checkorcard'] == 'W') {
$transactionInfo['charge_type_info'] = "Web900 ";
$transactionInfo['billingdescriptor'] = $transactionInfo['we_billingdescriptor'];
}
// Next Payment
$transactionInfo['subAccountName'] = $subAcc['rd_subName'];
$transactionInfo['chargeAmount'] = $subAcc['chargeAmount'];
$transactionInfo['schedule'] = $subAcc['schedule'];
$transactionInfo['nextDateInfo'] = $subAcc['nextDateInfo'];
$transactionInfo['nextRecurDate'] = $subAcc['nextRecurDate'];
if ($transactionInfo['nextRecurDate'] == -1) {
$transactionInfo['nextRecurDate'] = "N/A";
}
if ($transactionInfo['td_enable_rebill'] == 0) {
$transactionInfo['nextRecurDate'] = "No/Canceled Subscription";
}
$transactionInfo['td_recur_next_date_next'] = $subAcc['td_recur_next_date'];
$transactionInfo['subAcc'] = $subAcc;
$recurDate = $subAcc['nextRecurDate'];
$transactionInfo['expires'] = 'N/A';
$transactionInfo['expired'] = 'N/A';
if ($transactionInfo['ss_account_status'] == 'inactive') {
$transactionInfo['expired'] = "Expired on " . date("F j, Y", strtotime($transactionInfo['ss_account_expire_date']));
} else {
if ($transactionInfo['ss_account_status'] == 'active') {
$transactionInfo['expires'] = date("F j, Y", strtotime($transactionInfo['ss_account_expire_date']));
}
}
//Formatting
$transactionInfo['phonenumber_format'] = formatPhone($transactionInfo['phonenumber']);
$transactionInfo['fullname'] = $transactionInfo['name'] . " " . $transactionInfo['surname'];
return $transactionInfo;
}
$sql = "SELECT cs_ID,cs_company_id FROM `cs_company_sites` as s WHERE `cs_gatewayId` = " . $_SESSION["gw_id"] . " AND `cs_reference_id` = '{$mt_reference_id}' ";
$result = mysql_query($sql, $cnn_cs) or dieLog(mysql_errno() . ": " . mysql_error() . "<br>Cannot execute query");
$num = mysql_num_rows($result);
if ($num < 1) {
die("SNF");
}
$siteInfo = mysql_fetch_assoc($result);
$cs_ID = $siteInfo['cs_ID'];
$cs_company_id = $siteInfo['cs_company_id'];
$affiliation = "`td_site_ID` = '{$cs_ID}'";
if ($allow_any_site) {
$affiliation = "`userId` = '{$cs_company_id}'";
}
$trans_table = "`cs_transactiondetails`";
if ($testmode) {
$trans_table = "`cs_test_transactiondetails`";
}
$sql = "SELECT * FROM {$trans_table} WHERE {$affiliation} AND (reference_number = '{$td_reference_number}') AND `td_recur_processed` = 0 AND `td_recur_next_date`>=CURDATE()";
$result = mysql_query($sql, $cnn_cs) or dieLog("ERR");
$num = mysql_num_rows($result);
if ($num < 1) {
die("UNF");
}
$accountInfo = mysql_fetch_assoc($result);
if ($accountInfo['td_password'] != $td_password && $accountInfo['reference_number'] != $td_reference_number) {
die("PNF");
}
$activity = UserActivity(&$accountInfo);
toLogAppend("Activity Request Successful for '" . $accountInfo['reference_number'] . "': {$activity}", $lg_id, $accountInfo['transactionId']);
print $activity;
die;
