$strmessage .= "Sincerely \r\n";
$strmessage .= "{$_SESSION['gw_emails_sales']} \r\n";
$strmessage .= "{$_SESSION['gw_title']} \r\n";
$str_from = "{$_SESSION['gw_emails_sales']}";
func_send_mail($str_from, $toemail, $str_subject, $strmessage);
} else {
if ($i_bnk_creditcard == 9 || $i_bnk_creditcard == 10) {
$toemail = func_get_value_of_field($cnn_cs, "cs_bank", "bank_email", "bank_id", $i_bnk_creditcard);
$refer_num = func_get_value_of_field($cnn_cs, "cs_scanorder", "ScanOrderId", "transactionId", $oldtrans_id);
$str_subject = "Cancellation of Transaction";
$strmessage = "Please cancel the transaction having Identification Number: {$refer_num} .\r\n";
$strmessage .= "Sincerely \r\n";
$strmessage .= "{$_SESSION['gw_emails_sales']} \r\n";
$strmessage .= "{$_SESSION['gw_title']} \r\n";
$str_from = "{$_SESSION['gw_emails_sales']}";
func_send_mail($str_from, $toemail, $str_subject, $strmessage);
}
}
}
//exit();
// print($qryUpdate."<br>");
if (!mysql_query($qryUpdate, $cnn_cs)) {
print mysql_errno() . ": " . mysql_error() . "<BR>";
print "Can not execute query cancel update query";
exit;
}
$qryUpdate = "update cs_transactiondetails set reason='Customer Cancel', other=null,admin_approval_for_cancellation='A' where transactionId={$iTransactionId}";
if (!mysql_query($qryUpdate, $cnn_cs)) {
print mysql_errno() . ": " . mysql_error() . "<BR>";
print "Can not execute query cancel update query";
exit;
$mail_sent = mysql_result($rst_select_sent, 0, 1);
}
$email_from = $email1;
$email_to = $email1;
$email_subject = "Registration Confirmation";
$transactiontype = func_get_merchant_name($transaction_type);
$email_message = func_getreplymailbody_admin($companyname, $username, $password, $user_reference_num, $transactiontype, $how_about_us, $voulmeNumber);
if (!func_send_mail($email_from, $email_to, $email_subject, $email_message)) {
print "An error encountered while sending the mail.";
}
if ($mail_sent == 1) {
$email_from = $email1;
$email_to = $email;
$email_subject = "Registration Confirmation";
$email_message = func_getreplymailbody_gateway($companyname, $username, $password, $companyname1, $email1, $url1, $user_reference_num);
if (!func_send_mail($email_from, $email_to, $email_subject, $email_message)) {
print "An error encountered while sending the mail.";
exit;
}
}
}
/*************************************************************************/
$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'>An email has been sent with your offshore merchant account infomation</font></td></tr><tr><td align='center'><a href='javascript:window.history.back();'><img border='0' src='images/back.jpg'></a></td></tr></table>";
// $msgtodisplay = $email_message;
}
}
}
?>
<html>
<head>
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);
}
}
}
$str_email_content = str_replace("[customername]", $first_name . " " . $last_name, $str_email_content);
$str_email_content = str_replace("[companyname]", $company_name, $str_email_content);
$str_email_content = str_replace("[amount]", $total_amt, $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]", $total_amt, $str_email_content);
$str_email_content = str_replace("[cardtype]", $trans_type, $str_email_content);
$str_email_content = str_replace("[name]", $first_name, $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($account_numb, strlen($account_numb) - 4, 4), $str_email_content);
//echo $str_email_content;
$b_mail = func_send_mail($fromaddress, $to_id, "Ecommerce letter", $str_email_content);
if ($b_mail) {
$mail_status = "Mail Send";
} else {
$mail_status = "Failed";
}
?>
<tr>
<td bgcolor="#E2E2E2" height="30"><font size="1" face="Verdana" ><?php
echo $i_loop;
?>
</font></td>
<td bgcolor="#E2E2E2"><font size="1" face="Verdana" ><?php
echo $i_trans_id;
?>
function func_send_cancel_mail($iCompanyId, $strTransactionType)
{
$str_trans_type = $strTransactionType == "C" ? "Check" : "Card";
$str_from_id = "*****@*****.**";
$str_mail_subject = "Cancellation Of Transaction";
$str_mail_body = "Please Cancel the Following Transaction";
/*$str_to_id = func_get_value_of_field($cnn_cs,"cs_bankdetails","bank_email","bank_routing_code",$strBankRoutingCode);*/
$str_to_id = "";
$qry = "select bank_email from cs_bankdetails where bank_user_id = {$iCompanyId}";
if (!($result_set = mysql_query($qry))) {
dieLog(mysql_errno() . ": " . mysql_error() . "<BR>");
}
while ($arr_result = mysql_fetch_row($result_set)) {
$str_to_id = $arr_result[0];
/*$str_to_id = func_get_value_of_field($cnn_cs,"cs_bankdetails","bank_email","bank_routing_code",$strBankRoutingCode);*/
if ($str_to_id != "") {
//print($str_to_id."<br>");
func_send_mail($str_from_id, $str_to_id, $str_mail_subject, $str_mail_body);
}
}
$qry = "select bank_email from cs_company_bankdetails where bank_user_id = {$iCompanyId} and bank_transaction_type = '{$str_trans_type}'";
if (!($result_set = mysql_query($qry))) {
dieLog(mysql_errno() . ": " . mysql_error() . "<BR>");
}
while ($arr_result = mysql_fetch_row($result_set)) {
$str_to_id = $arr_result[0];
if ($str_to_id != "") {
//print($str_to_id."<br>");
func_send_mail($str_from_id, $str_to_id, $str_mail_subject, $str_mail_body);
}
}
}
<html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <?php $str_from = "*****@*****.**"; $str_to = "*****@*****.**"; $str_subject = "Test mail from CS"; $str_message = "Test content"; func_send_mail($str_from, $str_to, $str_subject, $str_message); ?> </body> </html>
$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]", "Check", $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]", $zip, $str_email_content);
$str_email_content = str_replace("[ccnumber]", substr($chequenumber, strlen($chequenumber) - 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($i_company_id,$subject,$message,$headers);
}
//$msgtodisplay="Order number ".$voiceauth." entered";
$msgtodisplay = "The Order number {$reference_number} details have been entered successfully";
$outhtml = "y";
message($msgtodisplay, $outhtml, $headerInclude);
}
}
}
exit;
}
$company_name = mysql_result($show_sql, 0, 1);
$user_name = mysql_result($show_sql, 0, 2);
$pass_word = mysql_result($show_sql, 0, 3);
$mail_confirm = mysql_result($show_sql, 0, 4);
$strMaildata = func_getreplymailbody($company_name, $user_name, $pass_word);
/* $str_current_path = "csv/confirmationmail.htm";
// print $str_current_path;
$create_file = fopen($str_current_path,'w');
// print $create_file;
$file_content = $strMaildata;
fwrite($create_file,$file_content);
fclose($create_file);
*/
$txtBody = $strMaildata;
if ($mail_confirm == 1) {
if (!func_send_mail($fromaddress, $to_id, $subject, $txtBody)) {
$msgtodisplay = "Sorry, some of the emails could not be sent.";
} else {
$msgtodisplay = "Mails successfully send to the users.";
}
}
}
$outhtml = "y";
message($msgtodisplay, $outhtml, $headerInclude);
exit;
}
/* if ($i_mail_id==0)
{
$qry_query = "Insert into cs_registrationmail (mail_sent) values ($str_mail_send)";
}
else
function func_canceledTransaction_receipt($user_id, $transactionId, $cnn_connection)
{
$qry_select = "SELECT A.name,A.surname,A.email,B.url1,B.companyname,B.transaction_type,A.reference_number,A.cancel_refer_num FROM cs_transactiondetails as A, cs_companydetails as B WHERE A.userId = B.userId and A.transactionId ={$transactionId}";
$rst_select = mysql_query($qry_select, $cnn_connection) or dieLog("Error: " . mysql_error());
$str_return_value = "";
if (mysql_num_rows($rst_select) > 0) {
$str_UserName = mysql_result($rst_select, 0, 0);
$str_UserSurName = mysql_result($rst_select, 0, 1);
$str_UserEmail = mysql_result($rst_select, 0, 2);
$str_URL = mysql_result($rst_select, 0, 3);
$str_CompanyName = mysql_result($rst_select, 0, 4);
$str_merchant_type = mysql_result($rst_select, 0, 5);
$str_RefNum = mysql_result($rst_select, 0, 6);
$str_CancelNum = mysql_result($rst_select, 0, 7);
}
if ($str_merchant_type != "tele") {
$str_from = "*****@*****.**";
$str_to = $str_UserEmail;
$str_subject = "Ecommerce Letter for Canceled Transaction.";
$str_message = "{$str_UserName} {$str_UserSurName},\r\n\r\n\n\tYour charge to {$str_URL} {$str_CompanyName} has been cancelled. You will NOT be billed again.\r\n\r\n\n\tReference Number: {$str_RefNum} \r\n\r\n\n\tCancelation Number: {$str_CancelNum} \r\n\r\n\n\tFor any additional questions regarding billing, please contact eTeleGate at customerservice@etelegate.com.";
func_send_mail($str_from, $str_to, $str_subject, $str_message);
}
}
