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;
}
} else {
// IMPORTANT 5-6-05, DONT ALLOW THIS ANYMORE AFTER A WEEK = CONCAT($companyid,'-',`rd_subName`
$sql = "SELECT rd_subaccount FROM `cs_rebillingdetails` WHERE (`rd_subName` = '{$mt_subAccount}') AND `company_user_id` = " . $companyid;
if (!($result = mysql_query($sql, $cnn_cs))) {
print mysql_errno() . ": " . mysql_error() . "<BR>";
print $qry_update . "<br>";
print "Failed to access company Product Database";
exit;
} else {
if (mysql_num_rows($result) <= 0) {
$strMessage = "INV";
$msgtodisplay = "<form name='Frmname' action='{$mt_return_url}' method='post'><input type='hidden' name='mt_transaction_result' value='{$strMessage}'><table width='350' height='100' align='center' valign='middle' style='border:1px solid black' cellpading='0' cellspacing='0'><tr><td align='center' valign='middle'>SubAccount '{$mt_subAccount}' not found for this company. Please contact an administrator. If you are a merchant seeing this message, please make sure the <strong>Entire</strong> SubAccount is sent (ex. '425-00101', not '00101')</td></tr><tr><td align='center'><input type='image' border='0' src='https://www.etelegate.com/images/back.jpg'></td></tr></table></form>";
die($msgtodisplay);
}
$subAccID = mysql_fetch_assoc($result);
$subAcc = getRebillInfo($subAccID['rd_subaccount'], time(), true);
//print_r($subAcc);
if ($companyInfo['cd_enable_price_points'] == 0 || $subAcc['rd_subaccount'] == -1) {
$strMessage = "INV";
$msgtodisplay = "<form name='Frmname' action='{$mt_return_url}' method='post'><input type='hidden' name='mt_transaction_result' value='{$strMessage}'><table width='350' height='100' align='center' valign='middle' style='border:1px solid black' cellpading='0' cellspacing='0'><tr><td align='center' valign='middle'>Invalid PricePoint Account or Price Points Not Enabled for this site. Please contact an administrator.</td></tr><tr><td align='center'><input type='image' border='0' src='https://www.etelegate.com/images/back.jpg'></td></tr></table></form>";
die($msgtodisplay);
}
$_SESSION['rd_subaccount'] = $subAcc['rd_subaccount'];
$_SESSION['td_enable_rebill'] = $subAcc['td_enable_rebill'];
$_SESSION['td_one_time_subscription'] = $subAcc['td_one_time_subscription'];
$_SESSION['td_recur_next_date'] = $subAcc['td_recur_next_date'];
$_SESSION['nextDateInfo'] = $subAcc['nextDateInfo'];
$_SESSION['amount'] = $subAcc['chargeAmount'];
$_SESSION['payment_schedule'] = $subAcc['payment_schedule'];
if (!$_SESSION['mt_prod_desc']) {
$_SESSION['mt_prod_desc'] = $subAcc['rd_description'];
