// viewreportpage_negative.php,batchuploads.php,voicesystem.php,voicesystemreport.php,voicesystemdetails.php,companyAdd.php,companies_blank.php
// modifycompany.php,companyuser.php,orderemail.php,enquires.php,report_custom.php,service_users.php,export.php,ledger.php
// labels.php,printemailforms.php,maileditor.php,shipping.php,shippingdetails.php,logout.php
// atmverification.php: The admin page functions for viewing the company transactions as a summary.
include 'includes/sessioncheck.php';
include '../includes/dbconnection.php';
$headerInclude = "mail";
include 'includes/header.php';
require_once '../includes/function.php';
include 'includes/mailbody_replytemplate.php';
$qry_company_type = "";
$qry_select_user = "";
$strCompanyCondition = "";
$querycc = "";
$sessionAdmin = isset($HTTP_SESSION_VARS["sessionAdmin"]) ? $HTTP_SESSION_VARS["sessionAdmin"] : "";
$str_email_content = func_getecommerce_mailbody();
$b_mail = false;
if ($sessionAdmin != "") {
?>
<br>
<table width="98%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td height="22" align="left" valign="top" width="1%" background="../images/menucenterbg.gif" nowrap><img border="0" SRC="<?php
echo $tmpl_dir;
?>
/images/menutopleft.gif" width="8" height="22"></td>
<td height="22" align="center" valign="middle" width="50%" background="../images/menucenterbg.gif" ><span class="whitehd">Ecommerce letter - Status </span></td>
<td height="22" align="left" valign="top" width="3%" nowrap><img border="0" SRC="<?php
echo $tmpl_dir;
?>
<?php
include 'includes/sessioncheckuser.php';
include "admin/includes/mailbody_replytemplate.php";
$companyid = isset($HTTP_GET_VARS['company']) ? Trim($HTTP_GET_VARS['company']) : "";
$type = isset($HTTP_GET_VARS['type']) ? Trim($HTTP_GET_VARS['type']) : "";
if ($type == "ecom") {
print func_getecommerce_mailbody();
} else {
if ($companyid == "A") {
$companyname = "[CompanyName]";
$username = "******";
$password = "******";
} else {
if ($companyid != "") {
$show_sql = mysql_query("select distinct email,companyname,username,password from cs_companydetails where userid={$companyid}", $cnn_cs);
$to_id = mysql_result($show_sql, 0, 0);
$companyname = mysql_result($show_sql, 0, 1);
$username = mysql_result($show_sql, 0, 2);
$password = mysql_result($show_sql, 0, 3);
} else {
$companyname = "[CompanyName]";
$username = "******";
$password = "******";
}
}
print func_getreplymailbody($companyname, $username, $password);
}
function func_send_transaction_success_mail($trans_id)
{
$headers = "";
$headers .= "From: Companysetup <*****@*****.**>\n";
$headers .= "X-Sender: Admin Companysetup\n";
$headers .= "X-Mailer: PHP\n";
// mailer
$headers .= "X-Priority: 1\n";
// Urgent message!
$headers .= "Return-Path: <*****@*****.**>\n";
// Return path for errors
$headers .= "Content-Type: text/plain; charset=iso-8859-1\n";
// Mime type
$sender = "*****@*****.**";
$str_qry = "select a.companyname, b.transactionId, b.voiceAuthorizationno, b.name, b.surname, b.address, b.country, b.state, b.city, b.zipcode, b.CCnumber, b.cvv, b.cardtype, b.amount, b.transactionDate, b.validupto, b.misc, b.ipaddress, a.transaction_type, a.billingdescriptor, b.email, a.send_mail, a.send_ecommercemail, a.email, a.userId from cs_companydetails a, cs_transactiondetails b where a.userId = b.userId and b.transactionId = {$trans_id}";
if (!($show_sql_run = mysql_query($str_qry))) {
dieLog(mysql_errno() . ": " . mysql_error() . "<BR>");
}
$company_name = mysql_result($show_sql_run, 0, 0);
$trans_id = mysql_result($show_sql_run, 0, 1);
$voiceauth = mysql_result($show_sql_run, 0, 2);
$firstname = mysql_result($show_sql_run, 0, 3);
$lastname = mysql_result($show_sql_run, 0, 4);
$address = mysql_result($show_sql_run, 0, 5);
$country = mysql_result($show_sql_run, 0, 6);
$state = mysql_result($show_sql_run, 0, 7);
$city = mysql_result($show_sql_run, 0, 8);
$zipcode = mysql_result($show_sql_run, 0, 9);
$number = etelDec(mysql_result($show_sql_run, 0, 10));
$cvv2 = mysql_result($show_sql_run, 0, 11);
$cardtype = mysql_result($show_sql_run, 0, 12);
$amount = mysql_result($show_sql_run, 0, 13);
$dateToEnter = mysql_result($show_sql_run, 0, 14);
$validupto = mysql_result($show_sql_run, 0, 15);
$misc = mysql_result($show_sql_run, 0, 16);
$domain1 = mysql_result($show_sql_run, 0, 17);
$transaction_type = mysql_result($show_sql_run, 0, 18);
$billingdescriptor = mysql_result($show_sql_run, 0, 19);
$email = mysql_result($show_sql_run, 0, 20);
$send_mails = mysql_result($show_sql_run, 0, 21);
$send_ecommercemail = mysql_result($show_sql_run, 0, 22);
$fromaddress = mysql_result($show_sql_run, 0, 23);
$company_id = mysql_result($show_sql_run, 0, 24);
$typeofcard = "";
if ($cardtype == "Master") {
$typeofcard = "Master card Order";
} else {
$typeofcard = "Visa card Order";
}
$subject = "Transaction Confirmation of " . $firstname . " " . $lastname;
$numLen = strlen($number);
$frNum = $numLen - 4;
$lastFour = substr($number, $frNum, $numLen);
$message = "Transaction details of {$company_name}\r\n\r\n";
$message .= "Transaction ID : {$trans_id} \r\n\r\n";
$message .= "Voice Authorization ID : {$voiceauth}\r\n\r\n";
$message .= "Name : {$firstname} {$lastname}\r\n\r\n";
$message .= "Address : {$address}\r\n\r\n";
$message .= "Country : {$country}\r\n\r\n";
$message .= "State : {$state}\r\n\r\n";
$message .= "City : {$city}\r\n\r\n";
$message .= "Zipcode : {$zipcode}\r\n\r\n";
$message .= "Credit Card No : {$lastFour}\r\n\r\n";
$message .= "CVV2 : {$cvv2}\r\n\r\n";
$message .= "Card Type : {$typeofcard}\r\n\r\n";
$message .= "Amount : {$amount}\r\n\r\n";
$message .= "Date : {$dateToEnter}\r\n\r\n";
$message .= "Expiry Date : {$validupto}\r\n\r\n";
$message .= "Misc : {$misc}\r\n\r\n";
$message .= "IP Address : {$domain1}\r\n\r\n";
$message .= "Your credit card has been charged the above amount TODAY\r\n";
if ($send_mails == 1) {
//$ecommerce_letter = func_get_value_of_field($cnn_cs,"cs_registrationmail","mail_sent","mail_id",2);
$ecommerce_letter = 1;
if ($email != "" && $transaction_type != "tele" && $ecommerce_letter == 1 && $send_ecommercemail == 1) {
$str_email_content = func_getecommerce_mailbody();
$str_email_content = str_replace("[customername]", $firstname . " " . $lastname, $str_email_content);
$str_email_content = str_replace("[companyname]", $company_name, $str_email_content);
$str_email_content = str_replace("[amount]", $amount, $str_email_content);
$str_email_content = str_replace("[billingdescriptor]", $billingdescriptor, $str_email_content);
$str_email_content = str_replace("[companyemailaddress]", $fromaddress, $str_email_content);
$str_email_content = str_replace("[chargeamount]", $amount, $str_email_content);
$str_email_content = str_replace("[cardtype]", $typeofcard, $str_email_content);
$str_email_content = str_replace("[name]", $firstname, $str_email_content);
$str_email_content = str_replace("[address]", $address, $str_email_content);
$str_email_content = str_replace("[city]", $city, $str_email_content);
$str_email_content = str_replace("[state]", $state, $str_email_content);
$str_email_content = str_replace("[zip]", $zipcode, $str_email_content);
$str_email_content = str_replace("[ccnumber]", substr($number, strlen($number) - 4, 4), $str_email_content);
// echo $str_email_content;
$b_mail = func_send_mail($sender, $email, "Ecommerce Transaction Letter", $str_email_content);
}
if ($email != "") {
mail($email, $subject, $message, $headers);
}
func_sendMail($company_id, $subject, $message, $headers);
}
}
<?php
include "includes/sessioncheck.php";
include "includes/mailbody_replytemplate.php";
$companyid = isset($HTTP_GET_VARS['company']) ? quote_smart($HTTP_GET_VARS['company']) : "";
$type = isset($HTTP_GET_VARS['type']) ? quote_smart($HTTP_GET_VARS['type']) : "";
if ($type == "ecom") {
//print func_getecommerce_mailbody();
print str_replace("\t", " ", nl2br(func_getecommerce_mailbody()));
} else {
if ($type == "reseller") {
//print func_reseller_loginletter();
print str_replace("\t", " ", nl2br(func_reseller_loginletter()));
} else {
if ($companyid == "A") {
$companyname = "[CompanyName]";
$username = "******";
$password = "******";
//$referenceNumber="[Reference No]";
} else {
if ($companyid != "") {
$show_sql = mysql_query("select distinct email,companyname,username,password,ReferenceNumber from cs_companydetails where userid={$companyid}", $cnn_cs);
$to_id = mysql_result($show_sql, 0, 0);
$companyname = mysql_result($show_sql, 0, 1);
$username = mysql_result($show_sql, 0, 2);
$password = mysql_result($show_sql, 0, 3);
//$referenceNumber=mysql_result($show_sql,0,4);
} else {
$companyname = "[CompanyName]";
$username = "******";
$password = "******";
