// config.php,reportBottom.php,reportBottomNext.php,useraccount.php,viewCompany.php,viewCompanyNext.php,ViewreportPage.php
// CompanyUser.php: The admin page functions for selecting the company for adding company user.
include "../includes/sessioncheckserviceuser.php";
require_once "../includes/function.php";
include "../admin/includes/serviceheader.php";
$headerInclude = "service";
session_register("sessionactivity_type");
$_SESSION["sessionactivity_type"] = "";
include "../admin/includes/topheader.php";
$i_service_user_id = isset($_SESSION["sessionServiceUserId"]) ? $_SESSION["sessionServiceUserId"] : "";
$str_company_ids = "";
$is_valid_service_user = true;
$qry_select_company = "select distinct userid,companyname from cs_companydetails";
if ($i_service_user_id != "") {
$str_company_ids = func_get_company_ids_for_service_user($cnn_cs, $i_service_user_id);
$i_gateway_id = func_get_value_of_field($cnn_cs, "cs_customerserviceusers", "gateway_id", "id", $i_service_user_id);
if ($str_company_ids != "") {
if ($str_company_ids != "A") {
$qry_select_company .= " where userid in ({$str_company_ids})";
} else {
if ($i_gateway_id != -1) {
$qry_select_company .= " where gateway_id = '{$i_gateway_id}'";
}
}
} else {
$is_valid_service_user = false;
}
}
$qry_select_company .= " order by companyname";
if (!($show_sql = mysql_query($qry_select_company))) {
print mysql_errno() . ": " . mysql_error() . "<BR>";
<?php
include "../includes/sessioncheckserviceuser.php";
require_once "../includes/function.php";
$strReasonCombo = isset($HTTP_POST_VARS["optReason"]) ? Trim($HTTP_POST_VARS["optReason"]) : "";
$strOtherReason = isset($HTTP_POST_VARS["txtReason"]) ? Trim($HTTP_POST_VARS["txtReason"]) : "";
$iTransactionId = isset($HTTP_POST_VARS["hdTransactionId"]) ? Trim($HTTP_POST_VARS["hdTransactionId"]) : "";
$strDateTime = func_get_current_date_time();
$return_insertId = func_transaction_updatenew($iTransactionId, $cnn_cs);
$qryUpdate = "update cs_transactiondetails set cancelstatus ='Y',cancellationDate = '{$strDateTime}',reason='{$strReasonCombo}',other='{$strOtherReason}'";
$qryUpdate .= " where transactionId =" . $return_insertId;
if (!mysql_query($qryUpdate)) {
print "Can not execute query";
exit;
}
$user_id = func_get_value_of_field($cnn_cs, "cs_transactiondetails", "userId", "transactionId", $return_insertId);
func_canceledTransaction_receipt($user_id, $return_insertId, $cnn_cs);
header('location:customerservice.php');
$i_cancel = 0;
$trans_total_count = 0;
$i_count = 0;
for ($iLoop = 0; $iLoop < count($arrCompanies); $iLoop++) {
if ($companyids1 == "") {
$companyids .= $arrCompanies[$iLoop] . ",";
}
if (Trim($arrCompanies[$iLoop]) != "") {
if ($arrCompanies[$iLoop] == "A") {
if ($companytrans_type == "A" && $tele_nontele_type == "A") {
$is_ecommerce = false;
}
break;
} else {
if ($i_count == 0) {
if (func_get_value_of_field(1, "cs_companydetails", "transaction_type", "userid", $arrCompanies[$iLoop]) == "tele") {
$is_ecommerce = false;
$i_count++;
}
}
//if($companytype!="A" || $companytrans_type != "A" || $tele_nontele_type != "A" || $bank_id != "A") {
if ($strCompanyCondition == "") {
$strCompanyCondition .= " a.userid = '{$arrCompanies[$iLoop]}'";
} else {
$strCompanyCondition .= " or a.userid = '{$arrCompanies[$iLoop]}'";
}
/*} else{
if($strCompanyCondition == ""){
$strCompanyCondition .= " userid = $arrCompanies[$iLoop]";
}else{
$strCompanyCondition .= " or userid = $arrCompanies[$iLoop]";
function func_show_reseller_ledger_details($str_query, $cnn_connection, $crorcq, $str_type, $str_company_id)
{
$strReturn = "";
$pending = 0;
$pendingAmt = 0;
$pendingPer = 0;
$approved = 0;
$approvedAmt = 0;
$approvedPer = 0;
//$declined=0;
//$declinedAmt=0;
//$declinedPer=0;
$canceled = 0;
$canceledAmt = 0;
$canceledPer = 0;
$totamount = 0;
$chequepending = 0;
$chequependingAmt = 0;
$chequependingPer = 0;
$chequeapproved = 0;
$chequeapprovedAmt = 0;
$chequeapprovedPer = 0;
//$chequedeclined=0;
//$chequedeclinedAmt=0;
//$chequedeclinedPer=0;
$creditpending = 0;
$creditpendingAmt = 0;
$creditpendingPer = 0;
$creditapproved = 0;
$creditapprovedAmt = 0;
$creditapprovedPer = 0;
//$creditdeclined=0;
//$creditdeclinedAmt=0;
//$creditdeclinedPer=0;
$creditcard = 0;
$cheque = 0;
$totalnum = 0;
$chequeAmt = 0;
$chequePer = 0;
$creditcardAmt = 0;
$creditcardPer = 0;
$chequecanceled = 0;
$chequecanceledAmt = 0;
$chequecanceledPer = 0;
$creditcanceled = 0;
$creditcanceledAmt = 0;
$creditcanceledPer = 0;
$deducted_amt = 0;
$credit_count = 0;
$cardPer = 0;
//$trans_voicefee = 0;
$charge_back_amount = 0;
$charge_back_count = 0;
$str_companyname = "";
$i_charge_back = "";
$cancel_reason = "";
$i_credit = "";
//$i_discount_rate = "";
//$i_transaction_fee = "";
//$i_reserve = "";
///$voice_authcount =0;
//$i_voiceauth_amt = 0;
//$chequenonpass =0;
//$chequenonpassAmt = 0;
//$chequepass =0;
//$chequepassAmt = 0;
//$creditnonpass =0;
//$creditnonpassAmt = 0;
//$creditpass =0;
//$creditpassAmt = 0;
//$passedPer=0;
//$nonpassedPer=0;
//$chequepassedPer=0;
//$chequenonpassPer=0;
//$creditpassedPer=0;
//$creditnonpassPer=0;
//$passed=0;
//$passedAmt=0;
//$nonpassed=0;
//$nonpassedAmt=0;
//$voice_count_uploads=0;
$i_net_Per = "";
$reseller_fee = 0;
$reseller_check_fee = 0;
$reseller_credit_fee = 0;
$i = 0;
if ($str_type != "") {
if ($str_type != "A") {
if ($str_type == "S") {
$str_type = "savings";
} else {
if ($str_type == "C") {
$str_type = "checking";
} else {
if ($str_type == "M") {
$str_type = "Master";
} else {
if ($str_type == "V") {
$str_type = "Visa";
}
}
}
}
}
} else {
$str_type = "A";
}
/*if(!($show_voice_sql = mysql_query($qrt_voice_select,$cnn_connection))){ dieLog(mysql_errno().": ".mysql_error()."<BR>");
}*/
if (!($show_sql = mysql_query($str_query, $cnn_connection))) {
dieLog(mysql_errno() . ": " . mysql_error() . "<BR>");
}
/*if(mysql_num_rows($show_voice_sql)>0)
{
$voice_count_uploads = mysql_result($show_voice_sql,0,0);
}*/
// print $voice_count_uploads;
// print($str_query);
while ($showval = mysql_fetch_array($show_sql)) {
$i = $i + 1;
$trans_type = $showval[0];
$trans_status = $showval[1];
$trans_cancelstatus = $showval[2];
$trans_companyName = $showval[3];
$i_charge_back = $showval[4];
$i_credit = $showval[5];
//$i_discount_rate = $showval[6];
//$i_transaction_fee = $showval[7];
//$i_reserve = $showval[8];
$trans_accounttype = $showval[9];
$trans_cardtype = $showval[10];
$cancel_reason = $showval[11];
$trans_passstatus = $showval[12];
$trans_amount = $showval[13];
//$trans_voicefee = $showval[14];
$reseller_fee = $showval[15];
// Check and credit card calculation.
if ($trans_type == "C") {
if ($trans_cancelstatus == "N") {
if ($trans_passstatus != "PE") {
/*if($trans_passstatus == "NP" && $trans_status =="P") {
$chequenonpass = $chequenonpass + 1;
$chequenonpassAmt = $chequenonpassAmt + $trans_amount;
} elseif($trans_passstatus == "PA" && $trans_status =="P") {
$chequepass = $chequepass + 1;
$chequepassAmt = $chequepassAmt + $trans_amount;
}*/
if ($trans_status == "A") {
$totalnum = $totalnum + 1;
$cheque = $cheque + 1;
$chequeAmt = $chequeAmt + $trans_amount;
$chequeapproved = $chequeapproved + 1;
$chequeapprovedAmt = $chequeapprovedAmt + $trans_amount;
}
/*if($trans_status =="D") {
$chequedeclined = $chequedeclined + 1;
$chequedeclinedAmt = $chequedeclinedAmt + $trans_amount;
}
$voice_authcount = $voice_authcount + 1;*/
} else {
$totalnum = $totalnum + 1;
$cheque = $cheque + 1;
$chequeAmt = $chequeAmt + $trans_amount;
$chequepending = $chequepending + 1;
$chequependingAmt = $chequependingAmt + $trans_amount;
}
} else {
//$voice_authcount = $voice_authcount + 1;
$totalnum = $totalnum + 1;
$cheque = $cheque + 1;
$chequeAmt = $chequeAmt + $trans_amount;
$chequecanceled = $chequecanceled + 1;
$chequecanceledAmt = $chequecanceledAmt + $trans_amount;
if ($cancel_reason == "Chargeback") {
$charge_back_count = $charge_back_count + 1;
} else {
$credit_count = $credit_count + 1;
}
}
} else {
if ($trans_cancelstatus == "N") {
if ($trans_passstatus != "PE") {
/*if($trans_passstatus == "NP" && $trans_status =="P") {
$creditnonpass = $creditnonpass + 1;
$creditnonpassAmt = $creditnonpassAmt + $trans_amount;
} elseif($trans_passstatus == "PA" && $trans_status =="P") {
$creditpass = $creditpass + 1;
$creditpassAmt = $creditpassAmt + $trans_amount;
}*/
if ($trans_status == "A") {
$totalnum = $totalnum + 1;
$creditcard = $creditcard + 1;
$creditcardAmt = $creditcardAmt + $trans_amount;
$creditapproved = $creditapproved + 1;
$creditapprovedAmt = $creditapprovedAmt + $trans_amount;
}
/*if($trans_status =="D") {
$creditdeclined = $creditdeclined + 1;
$creditdeclinedAmt = $creditdeclinedAmt + $trans_amount;
}
$voice_authcount = $voice_authcount + 1;*/
} else {
$totalnum = $totalnum + 1;
$creditcard = $creditcard + 1;
$creditcardAmt = $creditcardAmt + $trans_amount;
$creditpending = $creditpending + 1;
$creditpendingAmt = $creditpendingAmt + $trans_amount;
}
} else {
//$voice_authcount = $voice_authcount + 1;
$totalnum = $totalnum + 1;
$creditcard = $creditcard + 1;
$creditcardAmt = $creditcardAmt + $trans_amount;
$creditcanceled = $creditcanceled + 1;
$creditcanceledAmt = $creditcanceledAmt + $trans_amount;
if ($cancel_reason == "Chargeback") {
$charge_back_count = $charge_back_count + 1;
} else {
$credit_count = $credit_count + 1;
}
}
}
}
// Total Amount and Quantity Summary Display.
$pending = $chequepending + $creditpending;
$pendingAmt = $chequependingAmt + $creditpendingAmt;
//$passed = $chequepass + $creditpass;
//$passedAmt = $chequepassAmt + $creditpassAmt;
//$nonpassed = $chequenonpass + $creditnonpass;
//$nonpassedAmt = $chequenonpassAmt + $creditnonpassAmt;
$approved = $chequeapproved + $creditapproved;
$approvedAmt = $chequeapprovedAmt + $creditapprovedAmt;
//$declined= $chequedeclined + $creditdeclined;
//$declinedAmt= $chequedeclinedAmt + $creditdeclinedAmt;
$canceled = $chequecanceled + $creditcanceled;
$canceledAmt = $chequecanceledAmt + $creditcanceledAmt;
$totamount = $creditcardAmt + $chequeAmt;
$charge_back_amount = $charge_back_count * $i_charge_back;
$credit_amount = $credit_count * $i_credit;
//$i_discount_amt = (($i_discount_rate * $approvedAmt) / 100);
//$i_transaction_amt = ($i_transaction_fee * $totalnum);
//$i_reserve_amt = (($i_reserve * ($approvedAmt + $declinedAmt)) / 100);
//$i_voiceauth_amt = ($voice_authcount * ($trans_voicefee * 2));
//$i_total_voice_amt = ($voice_count_uploads * $trans_voicefee);
//$deducted_amt = ($charge_back_amount + $credit_amount + $i_discount_amt + $i_transaction_amt + $i_reserve_amt + $i_voiceauth_amt);
$reseller_check_fee = number_format($reseller_fee * $chequeapproved);
$reseller_credit_fee = number_format($reseller_fee * $creditapproved);
$deducted_amt = $charge_back_amount + $credit_amount;
//$i_net_amt = ($totamount - $deducted_amt);
$i_net_amt = $reseller_check_fee + $reseller_credit_fee - $deducted_amt;
// $i_net_Per = (($totamount - $deducted_amt)/$totamount);
if ($chequeAmt != 0) {
$chequependingPer = number_format($chequependingAmt / $chequeAmt * 100, 2);
//$chequepassedPer=number_format(($chequepassAmt/$chequeAmt)*100,2);
//$chequenonpassPer=number_format(($chequenonpassAmt/$chequeAmt)*100,2);
$chequeapprovedPer = number_format($chequeapprovedAmt / $chequeAmt * 100, 2);
//$chequedeclinedPer=number_format(($chequedeclinedAmt/$chequeAmt)*100,2);
$chequecanceledPer = number_format($chequecanceledAmt / $chequeAmt * 100, 2);
//$chequePer =number_format($chequedeclinedPer + $chequeapprovedPer + $chequependingPer+$chequecanceledPer+$chequenonpassPer+$chequepassedPer,2);
$chequePer = number_format($chequeapprovedPer + $chequependingPer + $chequecanceledPer, 2);
}
if ($creditcardAmt != 0) {
$creditpendingPer = number_format($creditpendingAmt / $creditcardAmt * 100, 2);
//$creditpassedPer=number_format(($creditpassAmt/$creditcardAmt)*100,2);
//$creditnonpassPer=number_format(($creditnonpassAmt/$creditcardAmt)*100,2);
$creditapprovedPer = number_format($creditapprovedAmt / $creditcardAmt * 100, 2);
//$creditdeclinedPer=number_format(($creditdeclinedAmt/$creditcardAmt)*100,2);
$creditcanceledPer = number_format($creditcanceledAmt / $creditcardAmt * 100, 2);
//$creditcardPer =number_format($creditdeclinedPer + $creditapprovedPer + $creditpendingPer+$creditcanceledPer+ $creditpassedPer+ $creditnonpassPer,2);
$creditcardPer = number_format($creditapprovedPer + $creditpendingPer + $creditcanceledPer, 2);
}
if ($totamount != 0) {
$pendingPer = number_format($pendingAmt / $totamount * 100, 2);
//$passedPer=number_format(($passedAmt/$totamount)*100,2);
//$nonpassedPer=number_format(($nonpassedAmt/$totamount)*100,2);
$approvedPer = number_format($approvedAmt / $totamount * 100, 2);
//$declinedPer=number_format(($declinedAmt/$totamount)*100,2);
$canceledPer = number_format($canceledAmt / $totamount * 100, 2);
//$voiceauthPre=number_format(($i_total_voice_amt/$totamount)*100,2);
//$cardPer =number_format($declinedPer + $approvedPer + $pendingPer+$canceledPer+$passedPer+$nonpassedPer,2);
$cardPer = number_format($approvedPer + $pendingPer + $canceledPer, 2);
}
if ($i > 0) {
print "<table width='100%' border='0'>";
if ($str_company_id != "A") {
print "<tr><td align='center' colspan='3'><br><P align='center'><font face='verdana' size='2'><B>{$trans_companyName}</B></font><br></td></tr>";
}
if ($crorcq == 'H' || $crorcq == 'A') {
print "<tr><td valign='top'><br>";
print "<P align='center'><font face='verdana' size='2'><B>Credit Card Summary</span><br>";
print "<table class='lefttopright' cellpadding='5' cellspacing='0' valign='top' bgColor='#ffffff' ID='Table1' style=' margin-left: 4; margin-top: 4; margin-bottom: 5'><tr height='30' bgcolor='#CCCCCC'>";
print "<td align='center' class='cl1'><span class='subhd'>Card Details</span></td>";
print "<td align='center' class='cl1'><span class='subhd'>Quantity</span></td>";
print "<td align='right' class='cl1'><span class='subhd'>Amount (\$)</span></td>";
print "<td align='right' class='bottom'><span class='subhd'>Percentage (%)</span></td></tr><tr>";
print "<td align='left' class='cl1'><font face='verdana' size='1'><b>Pending</b></font></td>";
print "<td align='center' class='cl1'><font face='verdana' size='1'> {$creditpending}</font></td>";
print "<td align='right' class='cl1'><font face='verdana' size='1'> " . number_format($creditpendingAmt, 2) . "</font></td>";
print "<td align='right' class='bottom'><font face='verdana' size='1'> " . number_format($creditpendingPer, 2) . "</font></td>";
/*print("</tr><tr><td align='left' class='cl1'><font face='verdana' size='1'><b>Non Pass</b></font></td>");
print("<td align='center' class='cl1'><font face='verdana' size='1'> $creditnonpass</font></td>");
print("<td align='right' class='cl1'><font face='verdana' size='1'> ".number_format($creditnonpassAmt,2)."</font></td>");
print("<td align='right' class='cl1'><font face='verdana' size='1'> ".number_format($creditnonpassPer,2)."</font></td>");
print("</tr><tr><td align='left' class='cl1'><font face='verdana' size='1'><b>Passed</b></font></td>");
print("<td align='center' class='cl1'><font face='verdana' size='1'> $creditpass</font></td>");
print("<td align='right' class='cl1'><font face='verdana' size='1'> ".number_format($creditpassAmt,2)."</font></td>");
print("<td align='right' class='cl1'><font face='verdana' size='1'> ".number_format($creditpassedPer,2)."</font></td>");*/
print "</tr><tr><td align='left' class='cl1'><font face='verdana' size='1'><b>Approved</b></font></td>";
print "<td align='center' class='cl1'><font face='verdana' size='1'> {$creditapproved}</font></td>";
print "<td align='right' class='cl1'><font face='verdana' size='1'> " . number_format($creditapprovedAmt, 2) . "</font></td>";
print "<td align='right' class='bottom'><font face='verdana' size='1'> " . number_format($creditapprovedPer, 2) . "</font></td></tr>";
/*print("<tr><td align='left' class='cl1'><font face='verdana' size='1'><b>Declined</b></font></td>");
print("<td align='center' class='cl1'><font face='verdana' size='1'> $creditdeclined</font></td>");
print("<td align='right' class='cl1'><font face='verdana' size='1'> ".number_format($creditdeclinedAmt,2)."</font></td>");
print("<td align='right' class='cl1'><font face='verdana' size='1'> ".number_format($creditdeclinedPer,2)."</font></td></tr>");*/
print "<tr><td align='left' class='cl1'><font face='verdana' size='1'><b>Credit</b></font></td>";
print "<td align='center' class='cl1'><font face='verdana' size='1'> {$creditcanceled}</font></td>";
print "<td align='right' class='cl1'><font face='verdana' size='1'> " . number_format($creditcanceledAmt, 2) . "</font></td>";
print "<td align='right' class='bottom'><font face='verdana' size='1'> " . number_format($creditcanceledPer, 2) . "</font></td>";
print "</tr><tr><td align='left' class='cl1'><font face='verdana' size='1'><b>Total</b></font></td>";
print "<td align='center' class='cl1'><font face='verdana' size='1'><b> {$creditcard}</b></font></td>";
print "<td align='right' class='cl1'><font face='verdana' size='1'><b> " . number_format($creditcardAmt, 2) . "</b></font></td>";
print "<td align='right' class='bottom'><font face='verdana' size='1'> " . number_format(round($creditcardPer), 2) . "</font></td></tr>";
print "<tr><td align='left' class='cl1'><font face='verdana' size='1'><b>Reseller Fee</b></font></td>";
print "<td align='center' class='cl1'><font face='verdana' size='1'> {$creditapproved}</font></td>";
print "<td align='right' class='cl1'><font face='verdana' size='1'> " . number_format($reseller_fee * $creditapproved, 2) . "</font></td>";
print "<td align='right' class='bottom'><font face='verdana' size='1'> </font></td></tr>";
print "</table>";
print "</td>";
}
$valgg = "";
if ($crorcq == 'C') {
$valgg = " colspan=2 ";
}
if ($crorcq == 'C') {
$valgg = " colspan=2 ";
}
if ($crorcq == 'C' || $crorcq == 'A') {
$valgg = true;
print "<td {$valgg} valign='top'><br>";
print "<P align='center'><font face='verdana' size='2'><B>Check Summary</span><br>";
print "<table class='lefttopright' cellpadding='5' cellspacing='0' valign='top' bgColor='#ffffff' ID='Table1' style=' margin-left: 4; margin-top: 4; margin-bottom: 5'><tr height='30' bgcolor='#CCCCCC'>";
print "<td align='center' class='cl1'><span class='subhd'>Check Details</span></td>";
print "<td align='center' class='cl1'><span class='subhd'>Quantity</span></td>";
print "<td align='right' class='cl1'><span class='subhd'>Amount (\$)</span></td>";
print "<td align='right' class='bottom'><span class='subhd'>Percentage (%)</span></td></tr><tr>";
print "<td align='left' class='cl1'><font face='verdana' size='1'><b>Pending</b></font></td>";
print "<td align='center' class='cl1'><font face='verdana' size='1'> {$chequepending}</font></td>";
print "<td align='right' class='cl1'><font face='verdana' size='1'> " . number_format($chequependingAmt, 2) . "</font></td>";
print "<td align='right' class='bottom'><font face='verdana' size='1'> " . number_format($chequependingPer, 2) . "</font></td>";
/*print("</tr><tr><td align='left' class='cl1'><font face='verdana' size='1'><b>Non Pass</b></font></td>");
print("<td align='center' class='cl1'><font face='verdana' size='1'> $chequenonpass</font></td>");
print("<td align='right' class='cl1'><font face='verdana' size='1'> ".number_format($chequenonpassAmt,2)."</font></td>");
print("<td align='right' class='cl1'><font face='verdana' size='1'> ".number_format($chequenonpassPer,2)."</font></td>");
print("</tr><tr><td align='left' class='cl1'><font face='verdana' size='1'><b>Passed</b></font></td>");
print("<td align='center' class='cl1'><font face='verdana' size='1'> $chequepass</font></td>");
print("<td align='right' class='cl1'><font face='verdana' size='1'> ".number_format($chequepassAmt,2)."</font></td>");
print("<td align='right' class='cl1'><font face='verdana' size='1'> ".number_format($chequepassedPer,2)."</font></td>");*/
print "</tr><tr><td align='left' class='cl1'><font face='verdana' size='1'><b>Approved</b></font></td>";
print "<td align='center' class='cl1'><font face='verdana' size='1'> {$chequeapproved}</font></td>";
print "<td align='right' class='cl1'><font face='verdana' size='1'> " . number_format($chequeapprovedAmt, 2) . "</font></td>";
print "<td align='right' class='bottom'><font face='verdana' size='1'> " . number_format($chequeapprovedPer, 2) . "</font></td></tr>";
/*print("<tr><td align='left' class='cl1'><font face='verdana' size='1'><b>Declined</b></font></td>");
print("<td align='center' class='cl1'><font face='verdana' size='1'> $chequedeclined</font></td>");
print("<td align='right' class='cl1'><font face='verdana' size='1'> ".number_format($chequedeclinedAmt,2)."</font></td>");
print("<td align='right' class='cl1'><font face='verdana' size='1'> ".number_format($chequedeclinedPer,2)."</font></td></tr>");*/
print "<tr><td align='left' class='cl1'><font face='verdana' size='1'><b>Credit</b></font></td>";
print "<td align='center' class='cl1'><font face='verdana' size='1'> {$chequecanceled}</font></td>";
print "<td align='right' class='cl1'><font face='verdana' size='1'> " . number_format($chequecanceledAmt, 2) . "</font></td>";
print "<td align='right' class='bottom'><font face='verdana' size='1'> " . number_format($chequecanceledPer, 2) . "</font></td>";
print "</tr><tr><td align='left' class='cl1'><font face='verdana' size='1'><b>Total</b></font></td>";
print "<td align='center' class='cl1'><font face='verdana' size='1'><b> {$cheque}</b></font></td>";
print "<td align='right' class='cl1'><font face='verdana' size='1'><b> " . number_format($chequeAmt, 2) . "</b></font></td>";
print "<td align='right' class='bottom'><font face='verdana' size='1'> " . number_format(round($chequePer), 2) . "</font></td></tr>";
print "<tr><td align='left' class='cl1'><font face='verdana' size='1'><b>Reseller Fee</b></font></td>";
print "<td align='center' class='cl1'><font face='verdana' size='1'> {$chequeapproved}</font></td>";
print "<td align='right' class='cl1'><font face='verdana' size='1'> " . number_format($reseller_fee * $chequeapproved, 2) . "</font></td>";
print "<td align='right' class='bottom'><font face='verdana' size='1'> </font></td></tr>";
print "</table>";
print "</td>";
}
print "<td {$valgg} valign='top'><br>";
print "<P align='center'><font face='verdana' size='2'><B>Total Summary</span><br>";
print "<table class='lefttopright' cellpadding='5' cellspacing='0' valign='top' bgColor='#ffffff' ID='Table1' style=' margin-left: 4; margin-top: 4; margin-bottom: 5'>";
print "<tr height='30' bgcolor='#CCCCCC'><td align='center' class='cl1'><span class='subhd'>Total Details</span></td>";
print "<td align='center' class='cl1'><span class='subhd'>Quantity</span></td>";
print "<td align='right' class='cl1'><span class='subhd'>Amount (\$)</span></td>";
print "<td align='right' class='cl1'><span class='subhd'>Percentage (%)</span></td></tr>";
print "<tr><td align='left' class='cl1'><font face='verdana' size='1'><b>Total</b></font></td>";
print "<td align='center' class='cl1'><font face='verdana' size='1'><b> {$totalnum}</b></font></td>";
print "<td align='right' class='cl1'><font face='verdana' size='1'><b> " . number_format($totamount, 2) . "</b></font></td>";
print "<td align='right' class='bottom'><font face='verdana' size='1'> " . number_format($cardPer, 2) . "</font></td></tr>";
print "<tr><td align='left' class='cl1'><font face='verdana' size='1'><b>Pending</span></td>";
print "<td align='center' class='cl1'><font face='verdana' size='1'> {$pending}</font></td>";
print "<td align='right' class='cl1'><font face='verdana' size='1'> " . number_format($pendingAmt, 2) . "</font></td>";
print "<td align='right' class='bottom'><font face='verdana' size='1'> " . number_format($pendingPer, 2) . "</font></td></tr>";
/*print("<tr><td align='left' class='cl1'><font face='verdana' size='1'><b>Passed</b></font></td>");
print("<td align='center' class='cl1'><font face='verdana' size='1'> $passed</font></td>");
print("<td align='right' class='cl1'><font face='verdana' size='1'> ".number_format($passedAmt,2)."</font></td>");
print("<td align='right' class='cl1'><font face='verdana' size='1'> ".number_format($passedPer,2)."</font></td></tr>");
print("<tr><td align='left' class='cl1'><font face='verdana' size='1'><b>Non Pass</b></font></td>");
print("<td align='center' class='cl1'><font face='verdana' size='1'> $nonpassed</font></td>");
print("<td align='right' class='cl1'><font face='verdana' size='1'> ".number_format($nonpassedAmt,2)."</font></td>");
print("<td align='right' class='cl1'><font face='verdana' size='1'> ".number_format($nonpassedPer,2)."</font></td></tr>");*/
print "<tr><td align='left' class='cl1'><font face='verdana' size='1'><b>Approved</b></font></td>";
print "<td align='center' class='cl1'><font face='verdana' size='1'> {$approved}</font></td>";
print "<td align='right' class='cl1'><font face='verdana' size='1'> " . number_format($approvedAmt, 2) . "</font></td>";
print "<td align='right' class='bottom'><font face='verdana' size='1'> " . number_format($approvedPer, 2) . "</font></td></tr>";
/*print("<tr><td align='left' class='cl1'><font face='verdana' size='1'><b>Declined</b></font></td>");
print("<td align='center' class='cl1'><font face='verdana' size='1'> $declined</font></td>");
print("<td align='right' class='cl1'><font face='verdana' size='1'> ".number_format($declinedAmt,2)."</font></td>");
print("<td align='right' class='cl1'><font face='verdana' size='1'> ".number_format($declinedPer,2)."</font></td></tr>");*/
print "<tr><td align='left' class='cl1'><font face='verdana' size='1'><b>Credit</b></font></td>";
print "<td align='center' class='cl1'><font face='verdana' size='1'> {$canceled}</font></td>";
print "<td align='right' class='cl1'><font face='verdana' size='1'> " . number_format($canceledAmt, 2) . "</font></td>";
print "<td align='right' class='bottom'><font face='verdana' size='1'> " . number_format($canceledPer, 2) . "</font></td></tr>";
/*print("<tr><td align='left' class='cl1'><font face='verdana' size='1'><b>Voice Upload</b></font></td>");
print("<td align='center' class='cl1'><font face='verdana' size='1'> $voice_count_uploads</font></td>");
print("<td align='right' class='cl1'><font face='verdana' size='1'> ".number_format($i_total_voice_amt,2)."</font></td>");
print("<td align='right' class='cl1'><font face='verdana' size='1'> ".number_format($voiceauthPre,2)."</font></td></tr>");*/
print "<tr><td align='left' class='cl1'><font face='verdana' size='1'><b>Reseller Fee</b></font></td>";
print "<td align='center' class='cl1'><font face='verdana' size='1'> " . ($chequeapproved + $creditapproved) . "</font></td>";
print "<td align='right' class='cl1'><font face='verdana' size='1'> " . number_format($reseller_fee * $chequeapproved + $reseller_fee * $creditapproved, 2) . "</font></td>";
print "<td align='right' class='bottom'><font face='verdana' size='1'> </font></td></tr>";
print "<tr bgcolor='#CCCCCC'><td align='left' class='cl1' colspan='2'><span class='subhd'>Deductions</span></td>";
print "<td align='right' class='cl1'><span class='subhd'>Deducted Amount</span></td>";
print "<td align='right' class='cl1'><span class='subhd'>Amount per transaction</span></td></td></tr>";
print "<tr><td align='left' class='cl1' colspan='2'><font face='verdana' size='1'><b>Charge Back</b></font></td>";
print "<td align='right' class='cl1'><font face='verdana' size='1'> " . number_format($charge_back_amount, 2) . "</font></td>";
print "<td align='right' class='bottom'><font face='verdana' size='1'> " . number_format($i_charge_back, 2) . "</font></td></tr>";
print "<tr><td align='left' class='cl1' colspan='2'><font face='verdana' size='1'><b>Credit</b></font></td>";
print "<td align='right' class='cl1'><font face='verdana' size='1'> " . number_format($credit_amount, 2) . "</font></td>";
print "<td align='right' class='bottom'><font face='verdana' size='1'> " . number_format($i_credit, 2) . "</font></td></tr>";
/*print("<tr><td align='left' class='cl1' colspan='2'><font face='verdana' size='1'><b>Discount</b></font></td>");
print("<td align='right' class='cl1'><font face='verdana' size='1'> ".number_format($i_discount_amt,2)."</font></td>");
print("<td align='right' class='bottom'><font face='verdana' size='1'> ".number_format($i_discount_rate,2)."%</font></td></tr>");
print("<tr><td align='left' class='cl1' colspan='2'><font face='verdana' size='1'><b>Transaction Fee</b></font></td>");
print("<td align='right' class='cl1'><font face='verdana' size='1'> ".number_format($i_transaction_amt,2)."</font></td>");
print("<td align='right' class='bottom'><font face='verdana' size='1'> ".number_format($i_transaction_fee,2)."</font></td></tr>");
print("<tr><td align='left' class='cl1' colspan='2'><font face='verdana' size='1'><b>Reserve Fee</b></font></td>");
print("<td align='right' class='cl1'><font face='verdana' size='1'> ".number_format($i_reserve_amt,2)."</font></td>");
print("<td align='right' class='bottom'><font face='verdana' size='1'> ".number_format($i_reserve,2)."%</font></td></tr>");
print("<tr><td align='left' class='cl1' colspan='2'><font face='verdana' size='1'><b>Voice Authorization</b></font></td>");
print("<td align='right' class='cl1'><font face='verdana' size='1'> ".number_format($i_voiceauth_amt,2)."</font></td>");
print("<td align='right' class='bottom'><font face='verdana' size='1'> ".number_format($trans_voicefee,2)."</font></td></tr>");*/
print "<tr><td align='left' class='cl1' colspan='2'><font face='verdana' size='1'><b>Net Amount</b></font></td>";
print "<td align='right' class='cl1'><font face='verdana' size='1'><b> " . number_format($i_net_amt, 2) . "</b></font></td>";
print "<td align='right' class='bottom'><font face='verdana' size='1'> " . number_format($i_net_Per) . "</font></td></tr>";
print "</table>";
print "</td>";
print "</tr></table>";
} else {
print "<br>";
if ($str_company_id != "A") {
print "<P align='center'><font face='verdana' size='2'><B>" . func_get_value_of_field($cnn_connection, "cs_companydetails", "companyname", "userid", $str_company_id) . "</B></font></p>";
}
print "<center><font face='verdana' size='1' ><B>No transactions for this period</B></font><center><br>";
}
}
if (sizeof($arr_company_ids) != 0) {
if (in_array($strUserId, $arr_company_ids)) {
$isValidUser = true;
}
}
}
}
}
if (!$isValidUser) {
$msgtodisplay = "You are not Authorized to attend calls from this Company";
$outhtml = "y";
print "<br>";
message($msgtodisplay, $outhtml, $headerInclude);
exit;
} else {
$strSecurityNumber = func_get_value_of_field($cnn_cs, "cs_companydetails", "securityNumber", "userId", $strUserId);
if ($str_back == "") {
$qryInsert = "insert into cs_callnotes (transaction_id,call_date_time,customer_service_id) values ({$strTransactionID},'{$strCurrentDateTime}','{$i_customer_service_id}')";
if (!mysql_query($qryInsert, $cnn_cs)) {
print "Can not execute insert query";
exit;
} else {
$i_call_note_id = mysql_insert_id($cnn_cs);
}
}
?>
<table border="0" cellpadding="0" width="100%" cellspacing="0" height="80%">
<tr>
<td width="83%" valign="top" align="center" >
<table border="0" cellpadding="0" cellspacing="0" width="100%" >
$tran_login_type = "tele";
} else {
$tran_login_type = "pmtg";
}
}
if ($i_company_id != "") {
$str_atm_verify = func_get_value_of_field($cnn_cs, "cs_companydetails", "atm_verify", "userid", $i_company_id);
$str_currency = func_get_processing_currency($i_company_id);
$sql_trans_type = "Select transaction_type from cs_companydetails where userid={$i_company_id}";
if ($show_trans_show = mysql_query($sql_trans_type)) {
if ($show_val = mysql_fetch_array($show_trans_show)) {
$tran_login_type = $show_val[0];
}
}
} else {
$str_atm_verify = func_get_value_of_field($cnn_cs, "cs_companydetails", "atm_verify", "userid", $str_company_id);
$str_currency = func_get_processing_currency($str_company_id);
}
$i_from_day = date("d");
$i_from_month = date("m");
$i_from_year = date("Y");
$i_to_day = date("d");
$i_to_month = date("m");
$i_to_year = date("Y");
$str_return_date = date("Y m d H:i", mktime(0, 0, 0, $i_from_month, $i_from_day, $i_from_year));
$i_from_year = substr($str_return_date, 0, 4);
$i_from_month = substr($str_return_date, 5, 2);
$i_from_day = substr($str_return_date, 8, 2);
$str_return_date = date("Y m d H:i", mktime(0, 0, 0, $i_to_month, $i_to_day, $i_to_year));
$i_to_year = substr($str_return_date, 0, 4);
$i_to_month = substr($str_return_date, 5, 2);
$str_payment_type = isset($HTTP_POST_VARS["hid_payment_type{$iLoop}"]) ? quote_smart($HTTP_POST_VARS["hid_payment_type{$iLoop}"]) : "";
$iCompanyId = isset($HTTP_POST_VARS["hid_company_id{$iLoop}"]) ? quote_smart($HTTP_POST_VARS["hid_company_id{$iLoop}"]) : "";
$strBillingDate = isset($HTTP_POST_VARS["hid_billing_date{$iLoop}"]) ? quote_smart($HTTP_POST_VARS["hid_billing_date{$iLoop}"]) : "";
$strPassStatus = isset($HTTP_POST_VARS["radpass{$iLoop}"]) ? quote_smart($HTTP_POST_VARS["radpass{$iLoop}"]) : "";
$strStatus = isset($HTTP_POST_VARS["radpending{$iLoop}"]) ? quote_smart($HTTP_POST_VARS["radpending{$iLoop}"]) : "";
$strCancel = isset($HTTP_POST_VARS["chk{$iLoop}"]) ? quote_smart($HTTP_POST_VARS["chk{$iLoop}"]) : "";
$strtxt = isset($HTTP_POST_VARS["txt{$iLoop}"]) ? quote_smart($HTTP_POST_VARS["txt{$iLoop}"]) : "";
$strCancelReason = isset($HTTP_POST_VARS["optReason{$iLoop}"]) ? quote_smart($HTTP_POST_VARS["optReason{$iLoop}"]) : "";
$strOtherReason = isset($HTTP_POST_VARS["txt{$iLoop}"]) ? quote_smart($HTTP_POST_VARS["txt{$iLoop}"]) : "";
$strNoPassReason = isset($HTTP_POST_VARS["txtarea{$iLoop}"]) ? quote_smart($HTTP_POST_VARS["txtarea{$iLoop}"]) : "";
$strDeclinedReason = isset($HTTP_POST_VARS["declineReason{$iLoop}"]) ? quote_smart($HTTP_POST_VARS["declineReason{$iLoop}"]) : "";
$td_is_chargeback = isset($HTTP_POST_VARS["td_is_chargeback{$iLoop}"]) ? quote_smart($HTTP_POST_VARS["td_is_chargeback{$iLoop}"]) : "";
$cancelstatus = isset($HTTP_POST_VARS["cancelstatus{$iLoop}"]) ? quote_smart($HTTP_POST_VARS["cancelstatus{$iLoop}"]) : "";
$qryUpdate = "";
if ($iTransactionId != "" && 0) {
$status = func_get_value_of_field($cnn_cs, "cs_transactiondetails", "status", "transactionId", $iTransactionId);
$qry_select_status = "Select passStatus,status,cancelstatus,pass_count,approval_count from cs_transactiondetails where transactionId={$iTransactionId}";
if (!($rst_select_status = mysql_query($qry_select_status, $cnn_cs))) {
print "Can not execute query";
print "<br>";
exit;
}
if (mysql_num_rows($rst_select_status) > 0) {
$db_passstatus = mysql_result($rst_select_status, 0, 0);
$db_status = mysql_result($rst_select_status, 0, 1);
$db_cancelstatus = mysql_result($rst_select_status, 0, 2);
$db_passcount = mysql_result($rst_select_status, 0, 3);
$db_approvalcount = mysql_result($rst_select_status, 0, 4);
}
$qrydeclineUpdate = "update cs_transactiondetails set td_is_chargeback = '{$td_is_chargeback}', cancelstatus = '{$cancelstatus}',reason='{$strtxt}' where transactionId={$iTransactionId}";
if (!mysql_query($qrydeclineUpdate, $cnn_cs)) {
<tr>
<td height="22" align="left" valign="top" width="1%" background="images/menucenterbg.gif" nowrap><img border="0" src="images/menutopleft.gif" width="8" height="22"></td>
<td height="22" align="center" valign="middle" width="50%" background="images/menucenterbg.gif" ><span class="whitehd">Ledger
Details</span></td>
<td height="22" align="left" valign="top" width="3%" nowrap><img border="0" src="images/menutopcurve.gif" width="49" height="22"></td>
<td height="22" align="left" valign="top" width="45%" background="images/menutoprightbg.gif" ><img alt="" src="images/spacer.gif" width="1" height="1"></td>
<td height="22" align="right" valign="top" background="images/menutoprightbg.gif" width="1%" nowrap><img border="0" src="images/menuright.gif" width="10" height="22"></td>
</tr>
<tr>
<td width="100%" valign="top" align="left" class="lgnbd" colspan="5">
<form name="summery" action="javascript:window.history.back()">
<?php
$querystr = $querystr . " cs_transactiondetails.userid ={$sessionlogin} and " . $querystr1;
$qrt_voice_select = " select count(*) from cs_voice_system_upload_log where user_id={$sessionlogin} and upload_date_time between '{$dateToEnter}' and '{$dateToEnter1}'";
$str_merchant_type = func_get_value_of_field($cnn_cs, "cs_companydetails", "transaction_type", "userid", $sessionlogin);
if ($str_merchant_type == "tele") {
func_show_ledger_details($querystr, $cnn_cs, $crorcq, $str_type, "A", $qrt_voice_select);
} else {
func_show_ecommerce_ledger_details($querystr, $cnn_cs, $crorcq, $str_type, "A");
}
//echo($querystr);
?>
<center>
<table align="center" ><tr>
<td align="center" valign="center" height="30" colspan="2"><input type="image" id="backsummery" src="images/back.jpg" border="0"></input></td></tr>
</table></center>
</form>
</td>
</tr>
$customerZipCode = isset($HTTP_POST_VARS['CUSTOMER_ZIP_CODE']) ? trim($HTTP_POST_VARS['CUSTOMER_ZIP_CODE']) : "";
$customerState = isset($HTTP_POST_VARS['CUSTOMER_STATE']) ? trim($HTTP_POST_VARS['CUSTOMER_STATE']) : "";
$customerCountry = isset($HTTP_POST_VARS['CUSTOMER_COUNTRY']) ? trim($HTTP_POST_VARS['CUSTOMER_COUNTRY']) : "";
$customerPhone = isset($HTTP_POST_VARS['CUSTOMER_PHONE']) ? trim($HTTP_POST_VARS['CUSTOMER_PHONE']) : "";
$customerIp = isset($HTTP_POST_VARS['CUSTOMER_IP']) ? trim($HTTP_POST_VARS['CUSTOMER_IP']) : "";
$productName = isset($HTTP_POST_VARS['PRODUCT_NAME']) ? trim($HTTP_POST_VARS['PRODUCT_NAME']) : "";
$transactAmount = isset($HTTP_POST_VARS['TRANSAC_AMOUNT']) ? trim($HTTP_POST_VARS['TRANSAC_AMOUNT']) : "";
$currencyCode = isset($HTTP_POST_VARS['CURRENCY_CODE']) ? trim($HTTP_POST_VARS['CURRENCY_CODE']) : "";
$cardType = isset($HTTP_POST_VARS['CB_TYPE']) ? trim($HTTP_POST_VARS['CB_TYPE']) : "";
$cardNumber = isset($HTTP_POST_VARS['CB_NUMBER']) ? trim($HTTP_POST_VARS['CB_NUMBER']) : "";
$cardExpire = isset($HTTP_POST_VARS['CB_EXPIRE']) ? trim($HTTP_POST_VARS['CB_EXPIRE']) : "";
$cardCvcNumber = isset($HTTP_POST_VARS['CB_CVC']) ? trim($HTTP_POST_VARS['CB_CVC']) : "";
$transactionType = isset($HTTP_POST_VARS['TRANS_TYPE']) ? trim($HTTP_POST_VARS['TRANS_TYPE']) : "";
$transactionId = isset($HTTP_POST_VARS['TRANS_ID']) ? trim($HTTP_POST_VARS['TRANS_ID']) : "";
$xml_string = "<epxml><header>\n\t\t\t<responsetype>direct</responsetype>\n\t\t\t\t<mid>{$UserId}</mid>\n\t\t\t\t<password>{$UserPassword}</password>\n\t\t\t<type>charge</type>\n\t\t\t</header>\n\t\t\t<request><charge>\n\t\t\t\t<etan>{$ReferenceNo}</etan>\n\t\t\t<card>\n\t\t\t\t<cctype>{$cardType}</cctype>\n\t\t\t\t<cc>{$cardNumber}</cc>\n\t\t\t\t<expire>{$cardExpire}</expire>\n\t\t\t\t<cvv>{$cardCvcNumber}</cvv>\n\t\t\t</card>\n\t\t\t<cardholder>\n\t\t\t\t<name>{$customerFirstName}</name>\n\t\t\t\t<surname>{$customerLastName}</surname>\n\t\t\t\t<street>{$customerAddress}</street>\n\t\t\t\t<housenumber>123</housenumber>\n\t\t\t\t<zip>{$customerZipCode}</zip>\n\t\t\t\t<city>{$customerCity}</city>\n\t\t\t\t<country>{$customerCountry}</country>\n\t\t\t\t<telephone>{$customerPhone}</telephone>\n\t\t\t\t<state>{$customerState}</state>\n\t\t\t\t<email>{$customerEmail}</email>\n\t\t\t</cardholder>\n\t\t\t<amount>\n\t\t\t\t<currency>{$currencyCode}</currency>\n\t\t\t\t<value>{$transactAmount}</value>\n\t\t\t</amount>\n\t\t\t</charge>\n\t\t\t</request></epxml>";
$is_existTransId = func_get_value_of_field($cnn_cs, "cs_volpay", "trans_id", "trans_id", $transactionId);
if ($is_existTransId == "") {
$data = func_volpaybank_integration_result($xml_string);
} else {
$strMessage = "<h3>The Order number already exist.</h3>Please process with a new transaction.";
}
$Nodes = array();
$count = 0;
$pos = 0;
// Goes throw XML file and creates an array of all <XML_TAG> tags.
while ($node = GetElementByName($data, "<epxml>", "</epxml>")) {
$Nodes[$count] = $node;
$count++;
$data = substr($data, $pos);
}
// Gets infomation from tag siblings.
}
} else {
$msgtodisplay = "Invalid File";
}
} else {
$msgtodisplay = "No file uploaded";
}
} else {
$msgtodisplay = "No file uploaded";
}
if ($msgtodisplay != "") {
$outhtml = "y";
message($msgtodisplay, $outhtml, $headerInclude);
exit;
} else {
$str_company_name = func_get_value_of_field($cnn_cs, "cs_companydetails", "companyname", "userId", $i_company_id);
if (!$is_valid_report) {
$msgtodisplay = "Uploaded report is not valid for {$str_company_name}";
$outhtml = "y";
message($msgtodisplay, $outhtml, $headerInclude);
exit;
} else {
if ($str_report != "") {
$msgtodisplay = "The following Voice Authorization Id(s) were not found for {$str_company_name}:<br><br>";
$msgtodisplay .= $str_report;
$outhtml = "y";
message($msgtodisplay, $outhtml, $headerInclude);
exit;
} else {
$msgtodisplay = "Voice System Reports Updated Successfully";
$outhtml = "y";
$str_first_name = mysql_result($rssel_report, $i, 12);
$str_surname = mysql_result($rssel_report, $i, 13);
$str_company = mysql_result($rssel_report, $i, 14);
$str_cancellation_date = mysql_result($rssel_report, $i, 15);
$str_approval_status = mysql_result($rssel_report, $i, 16);
$i_transref = mysql_result($rssel_report, $i, 17);
$str_customer_service_rep = "";
$str_new_date = "";
$str_prev_bill_date = $str_prev_bill_date == "0000:00:00" ? "" : func_get_date_inmmddyy($str_prev_bill_date);
if ($str_prev_bill_date != "") {
$str_new_date = $str_bill_date_changed == "Y" ? func_get_date_inmmddyy($str_new_bill_date) : "Unchanged";
}
if ($i_customer_service_id == 0) {
$str_customer_service_rep = "service";
} else {
$str_customer_service_rep = func_get_value_of_field($cnn_cs, "cs_customerserviceusers", "username", "id", $i_customer_service_id);
}
$arr_total_duration[$i] = $str_call_duration;
$str_cancelled_after_bill_date = "";
$str_call_date = substr($str_calldatetime, 0, 10);
if ($str_cancel_status == "Cancelled" && $str_cancellation_date >= $str_new_bill_date) {
if ($str_approval_status == "A") {
$str_cancelled_after_bill_date = "style='border:1 solid red'";
} else {
if ($str_approval_status == "D") {
$str_cancelled_after_bill_date = "style='border:1 solid orange'";
} else {
$str_cancelled_after_bill_date = "style='border:1 solid brown'";
}
}
}
$i_start_day_diff = $i_end_day_diff + ($i_to_week_day - $i_from_week_day);
//$str_from_date = date("Y-m-d", mktime (0, 0, 0, $str_month, $str_day - ($i_num_days_back + $i_start_day_diff), $str_year));
//$str_to_date = date("Y-m-d", mktime (0, 0, 0, $str_month, $str_day - ($i_num_days_back + $i_end_day_diff), $str_year));
$str_from_date = date("Y-m-d", mktime (0, 0, 0, $str_month, $str_day , $str_year));
$str_to_date = date("Y-m-d", mktime (0, 0, 0, $str_month, $str_day, $str_year));
print("start= $str_from_date; end= $str_to_date");
exit();
// print("num days= $i_num_days_back");
//}*/
$str_from_date = date("Y-m-d", mktime(0, 0, 0, $i_from_month, $i_from_day, $i_from_year));
$str_to_date = date("Y-m-d", mktime(0, 0, 0, $i_to_month, $i_to_day, $i_to_year));
$selected_company = "";
if ($companyid) {
$qry_select_details = "Select a.transactionDate,a.passStatus,a.status,a.cancelstatus,a.reason,a.amount,b.chargeback,b.transactionfee,b.voiceauthfee,b.companyname,b.credit,b.discountrate,b.reserve from cs_transactiondetails as a,cs_companydetails as b where a.userid=b.userid and a.userid={$companyid} and a.transactionDate >='{$str_from_date}' and a.transactionDate <='{$str_to_date}'";
$qry_select_details .= " order by b.companyname,a.transactionDate";
$companytype = func_get_value_of_field($cnn_cs, "cs_companydetails", "transaction_type", "userId", $companyid);
}
//print($qry_select_details);
if (!($rs_select_details = mysql_query($qry_select_details, $cnn_cs))) {
print mysql_errno() . ": " . mysql_error() . "<BR>";
print "<br>";
print $qry_select_details;
print "Cannot execute query";
exit;
}
$i_count = mysql_num_rows($rs_select_details);
//echo $i_count;
if ($i_count == 0) {
$msgtodisplay = "No transactions for this period.";
$outhtml = "y";
message($msgtodisplay, $outhtml, $headerInclude);
$crorcq1 = isset($HTTP_POST_VARS['crorcq1']) ? Trim($HTTP_POST_VARS['crorcq1']) : "";
$str_bill_date = isset($HTTP_POST_VARS['billDate']) ? Trim($HTTP_POST_VARS['billDate']) : "";
$cancelreason = "Customer cancel";
$msgtodisplay = "";
if ($trans_id != "") {
if ($cancel != "") {
$str_is_cancelled = func_get_value_of_field($cnn_cs, "cs_transactiondetails", "cancelstatus", "transactionId", $return_insertId);
//$return_insertId = func_transaction_updatenew($iTransactionId,$cnn_cs);
if ($str_is_cancelled == "Y") {
$outhtml = "y";
$msgtodisplay = "This transaction has been already canceled";
message($msgtodisplay, $outhtml, $headerInclude);
exit;
} else {
$strCurrentDateTime = func_get_current_date();
$str_approval_status = func_get_value_of_field($cnn_cs, "cs_transactiondetails", "status", "transactionId", $return_insertId);
if ($strCurrentDateTime >= $str_bill_date && $str_approval_status == "A") {
$qrt_update_details = "Update cs_transactiondetails set reason='{$cancelreason}',cancellationDate='{$canceldate}',admin_approval_for_cancellation = 'P' where transactionId={$trans_id} and userid={$user_id}";
if (!($qrt_update_run = mysql_query($qrt_update_details))) {
dieLog(mysql_errno() . ": " . mysql_error() . "<BR>");
} else {
$msgtodisplay = "<table width='370' height='100' align='center' valign='top' style='border:2px solid black'><tr><td align='center' valign='middle'><font face='verdana' size='2' color='red'>Selected transaction has been canceled and is waiting for Admin's Approval.</font></td></tr><tr><td align='center'><a href='index.htm'><img border='0' src='images/back_tran.gif'></a></td></tr></table>";
}
} else {
$return_insertId = func_transaction_updatenew($trans_id, $cnn_cs);
$qryUpdate = "update cs_transactiondetails set passStatus='ND',cancelstatus='Y',reason='{$cancelreason}',cancellationDate='{$canceldate}' where transactionId={$trans_id} and userid={$user_id}";
//print($qryUpdate."<br>");
if (!mysql_query($qryUpdate, $cnn_cs)) {
print mysql_errno() . ": " . mysql_error() . "<BR>";
print "Can not execute query cancel update query";
exit;
?>
</select>
</td>
</tr>
<tr>
<td align="left" valign="center" height="30" width="50%" bgcolor="#F8FAFC"><font face="verdana" size="1"> Totals </font></td>
<td align="left" height="30" width="50%" bgcolor="#F8FAFC"><input type="text" src='req' maxlength="15" name="totals" style="font-family:arial;font-size:10px;width:120px" value="<?php
echo $show_select_value['totals'];
?>
">
</td>
</tr>
<?php
$gateway_id = $show_select_value['gateway_id'];
if ($gateway_id != -1) {
$gatewayCompanyName = func_get_value_of_field($cnn_cs, "cs_companydetails", "companyname", "userid", $gateway_id);
}
?>
<tr>
<td align="left" valign="center" height="30" width="50%" bgcolor="#F8FAFC"><font face="verdana" size="1"> <b>Forecasted Volume </b> </font></td>
<td align="left" height="30" width="50%" bgcolor="#F8FAFC"> </td>
</tr>
<tr>
<td align="left" valign="center" height="30" width="50%" bgcolor="#F8FAFC"><font face="verdana" size="1"> First Month </font></td>
<td align="left" height="30" width="50%" bgcolor="#F8FAFC"><select name="forecast_first_month" style="font-family:arial;font-size:10px;width:120px" title="reqmenu">
<?php
func_select_merchant_volume($show_select_value['forecast_volume_1month']);
?>
</select>
</td>
</tr>
$str_user_type = "Rebilling";
} else {
$str_user_type = "VT ";
}
}
}
}
}
}
}
$strServiceUser = "";
if ($iServiceUserId != "") {
if ($iServiceUserId == 0) {
$strServiceUser = "******";
} else {
$strServiceUser = func_get_value_of_field($cnn_cs, "cs_customerserviceusers", "username", "id", $iServiceUserId);
}
}
?>
<tr height='30' >
<td align='center' class='cl1'><font face='verdana' size='1'><a href="javascript:func_submit('<?php
echo $iTransactionId;
?>
');" class="link1"> <?php
echo $ireferenceNumber;
?>
</a><br><?php
print func_get_date_time_12hr($strTransactiontime);
?>
</font></td>
<td align='left' class='cl1'><font face='verdana' size='1'>
$customerState = isset($HTTP_POST_VARS['CUSTOMER_STATE']) ? trim($HTTP_POST_VARS['CUSTOMER_STATE']) : "";
$customerCountry = isset($HTTP_POST_VARS['CUSTOMER_COUNTRY']) ? trim($HTTP_POST_VARS['CUSTOMER_COUNTRY']) : "";
$customerPhone = isset($HTTP_POST_VARS['CUSTOMER_PHONE']) ? trim($HTTP_POST_VARS['CUSTOMER_PHONE']) : "";
$customerIp = isset($HTTP_POST_VARS['CUSTOMER_IP']) ? trim($HTTP_POST_VARS['CUSTOMER_IP']) : "";
$productName = isset($HTTP_POST_VARS['PRODUCT_NAME']) ? trim($HTTP_POST_VARS['PRODUCT_NAME']) : "";
$transactAmount = isset($HTTP_POST_VARS['TRANSAC_AMOUNT']) ? trim($HTTP_POST_VARS['TRANSAC_AMOUNT']) : "";
$currencyCode = isset($HTTP_POST_VARS['CURRENCY_CODE']) ? trim($HTTP_POST_VARS['CURRENCY_CODE']) : "";
$cardType = isset($HTTP_POST_VARS['CB_TYPE']) ? trim($HTTP_POST_VARS['CB_TYPE']) : "";
$cardNumber = isset($HTTP_POST_VARS['CB_NUMBER']) ? trim($HTTP_POST_VARS['CB_NUMBER']) : "";
$cardExpire = isset($HTTP_POST_VARS['CB_EXPIRE']) ? trim($HTTP_POST_VARS['CB_EXPIRE']) : "";
$cardCvcNumber = isset($HTTP_POST_VARS['CB_CVC']) ? trim($HTTP_POST_VARS['CB_CVC']) : "";
if ($currencyCode == "") {
$currencyCode = "USD";
}
$xml_string = "<epxml><header>\n\t\t\t<responsetype>direct</responsetype>\n\t\t\t\t<mid>{$UserId}</mid>\n\t\t\t\t<password>{$UserPassword}</password>\n\t\t\t<type>charge</type>\n\t\t\t</header>\n\t\t\t<request><charge>\n\t\t\t\t<etan>{$TransNumber}</etan>\n\t\t\t<card>\n\t\t\t\t<cctype>{$cardType}</cctype>\n\t\t\t\t<cc>{$cardNumber}</cc>\n\t\t\t\t<expire>{$cardExpire}</expire>\n\t\t\t\t<cvv>{$cardCvcNumber}</cvv>\n\t\t\t</card>\n\t\t\t<cardholder>\n\t\t\t\t<name>{$customerFirstName}</name>\n\t\t\t\t<surname>{$customerLastName}</surname>\n\t\t\t\t<street>{$customerAddress}</street>\n\t\t\t\t<housenumber>123</housenumber>\n\t\t\t\t<zip>{$customerZipCode}</zip>\n\t\t\t\t<city>{$customerCity}</city>\n\t\t\t\t<country>{$customerCountry}</country>\n\t\t\t\t<telephone>{$customerPhone}</telephone>\n\t\t\t\t<state>{$customerState}</state>\n\t\t\t\t<email>{$customerEmail}</email>\n\t\t\t</cardholder>\n\t\t\t<amount>\n\t\t\t\t<currency>{$currencyCode}</currency>\n\t\t\t\t<value>{$transactAmount}</value>\n\t\t\t</amount>\n\t\t\t</charge>\n\t\t\t</request></epxml>";
$is_existTransId = func_get_value_of_field($cnn_cs, "cs_volpay", "trans_id", "trans_id", $TransNumber);
if ($is_existTransId == "") {
$data = func_volpaybank_integration_result($xml_string);
} else {
$strMessage = "<h3>The Order number already exist.</h3>Please process with a new transaction.";
}
$Nodes = array();
$count = 0;
$pos = 0;
// Goes throw XML file and creates an array of all <XML_TAG> tags.
while ($node = GetElementByName($data, "<epxml>", "</epxml>")) {
$Nodes[$count] = $node;
$count++;
$data = substr($data, $pos);
}
// Gets infomation from tag siblings.
} else {
if ($bank == "s") {
$bname = "ScandOrder";
} else {
if ($bank == "v") {
$bname = "Volpay";
}
}
}
if ($bank_Creditcard == 3) {
$bank_trid = func_get_value_of_field($cnn_cs, "cs_bardo", "bardo_number", "shop_number", $old_tr_id);
} else {
if ($bank_Creditcard == 6 || $bank_Creditcard == 7 || $bank_Creditcard == 8) {
$bank_trid = func_get_value_of_field($cnn_cs, "cs_volpay", "return_code", "trans_id", $old_tr_id);
} elseif ($bank_Creditcard == 9 || $bank_Creditcard == 10) {
$bank_trid = func_get_value_of_field($cnn_cs, "cs_scanorder", "scanOrderId", "transactionId", $old_tr_id);
}
}
}
//!=
if ($str_temp_company != $str_company) {
$str_temp_company = $str_company;
$i_num_record = 0;
$str_data .= "<tr><td colspan='10' align='center' height='40'><font face='verdana' size='1'><b>{$str_company} {$bname}</b></font></td></tr>";
$str_data .= "<tr>";
$str_data .= "<td width='2%' bgcolor='#CCCCCC' height='30' rowspan='2'><span class='subhd'>No.</span></td>";
$str_data .= "<td width='4%' bgcolor='#CCCCCC' rowspan='2'><span class='subhd'>Tran ID</span></td>";
$str_data .= "<td width='4%' bgcolor='#CCCCCC' rowspan='2'><span class='subhd'>Bank Tran ID</span></td>";
$str_data .= "<td width='10%' bgcolor='#CCCCCC' rowspan='2'><span class='subhd'>Customer Name</span></td>";
$str_data .= "<td width='6%' bgcolor='#CCCCCC' rowspan='2'><span class='subhd'>Phone Number</span></td>";
$str_data .= "<td width='6%' bgcolor='#CCCCCC' rowspan='2'><span class='subhd'>Check / Card</span></td>";
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;
}
if ($strPaymentType == "C") {
// func_send_cancel_mail($iCompanyId,$strPaymentType);
}
//func_canceledTransaction_receipt($iCompanyId, $return_insertId,$cnn_cs);
} else {
if ($strCancel == "reject") {
$ref_oldnum = func_get_value_of_field($cnn_cs, "cs_transactiondetails", "cancel_refer_num ", "transactionId", $iTransactionId);
$qry_update = "update cs_transactiondetails set cancel_count=0 where reference_number='{$ref_oldnum}'";
mysql_query($qry_update, $cnn_cs);
$qry_reject = "update cs_transactiondetails set transactionDate='{$strCurrentDateTime}', admin_approval_for_cancellation ='R' where transactionId={$iTransactionId}";
if (!mysql_query($qry_reject, $cnn_cs)) {
print mysql_errno() . ": " . mysql_error() . "<BR>";
print "Can not execute query cancel update query";
exit;
}
}
}
}
}
}
$headerInclude = "transactions";
$msgtodisplay = "Cancel Status Updated Successfully.";
$message .= "Zipcode : {$zip}\r\n\r\n";
$message .= "Phone Number : {$phonenumber}\r\n\r\n";
$message .= "Account Type : {$accounttype}\r\n\r\n";
$message .= "Check Type : {$chequetype}\r\n\r\n";
$message .= "Check No : {$lastFour}\r\n\r\n";
$message .= "Amount : {$amount}\r\n\r\n";
$message .= "Bank Verification : {$bank_return}\r\n\r\n";
$message .= "Bank Name : {$bankname}\r\n\r\n";
$message .= "Bank Routing Code : {$bankroutingcode}\r\n\r\n";
$message .= "Bank Account Number : {$bankaccountno}\r\n\r\n";
$message .= "Date : {$dateToEnter}\r\n\r\n";
$message .= "Misc : {$misc}\r\n\r\n";
$message .= "IP Address : {$domain1}\r\n\r\n\r\n";
$message .= "Your checking account 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);
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]", "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);
include 'includes/header.php';
$iShopNumber = $HTTP_GET_VARS["SHOP_NUMBER"];
$selectBankUpdates = "Select * from cs_scanorder where transactionId = {$iShopNumber}";
if (!($run_Select_Qry = mysql_query($selectBankUpdates))) {
dieLog(mysql_errno() . ": " . mysql_error() . "<BR>");
}
$str_status = "";
$str_decline_reason = "";
if (mysql_num_rows($run_Select_Qry) != 0) {
$str_status = mysql_result($run_Select_Qry, 0, 3);
$decline_reason = $str_status == "yes" ? "" : mysql_result($run_Select_Qry, 0, 4);
}
$approval_status = $str_status == "yes" ? "A" : "D";
$pass_status = "PA";
func_update_approval_status($cnn_cs, $iShopNumber, $approval_status, $pass_status, $decline_reason);
$referenceNumber = func_get_value_of_field($cnn_cs, "cs_transactiondetails", "reference_number", "transactionId", $iShopNumber);
if ($str_status == "yes") {
$strMessage = "SUC";
$strMessage = "<center><br><br><h3>Thank-you for your order</h3>Your order number is {$referenceNumber}. Please refer to this in any correspondence.</center>";
} else {
$strMessage = "DEC";
$strMessage = "<p style='margin-left:40;margin-right:40'><b>Sorry</b>, there was a mistake with your credit card details. Your Order Number {$referenceNumber} has been declined - " . $decline_reason . ".</p>";
}
?>
<table border="0" cellpadding="0" width="100%" cellspacing="0" height="60%" >
<tr><td width="83%" valign="top" align="center" height="333">
<table border="0" cellpadding="0" cellspacing="0" width="600" class="disbd">
<tr>
<td width="100%" valign="top" align="center" bgcolor="#999999" height="20">
<img border="0" src="images/spacer.gif" width="1" height="1"></td>
</tr>
include "includes/sessioncheck.php";
$headerInclude = "startHere";
include "includes/header.php";
$companyid = isset($HTTP_SESSION_VARS["sessionlogin"]) ? quote_smart($HTTP_SESSION_VARS["sessionlogin"]) : "";
if ($_GET['goLive']) {
$sql = "UPDATE cs_companydetails set `cd_completion` = 9 WHERE `cd_completion` = 7 AND `userId` = '{$companyid}'";
toLog('requestlive', 'merchant', '', $curUserInfo['userId']);
if ($curUserInfo['cd_completion'] == 7) {
mysql_query($sql) or dieLog(mysql_error());
print "<script>document.location.href='Listdetails.php?msg=You have successfully requested to go Live!';</script>";
en_status_change_notify($curUserInfo['en_ID']);
die;
}
}
if ($str_UserId != "") {
$gateway_id = func_get_value_of_field($cnn_cs, "cs_companydetails", "gateway_id", "userid", $str_UserId);
} else {
$gateway_id = -1;
}
$msg = $_GET['msg'];
if ($msg) {
beginTable();
}
?>
<div align="center">
<strong><?php
echo $msg;
?>
</strong>
</div>
<?php
<?php
include 'includes/sessioncheck.php';
require_once "includes/dbconnection.php";
require_once 'includes/function.php';
$sessionlogin = isset($HTTP_SESSION_VARS["sessionlogin"]) ? $HTTP_SESSION_VARS["sessionlogin"] : "";
$gateway_id = func_get_value_of_field($cnn_cs, "cs_companydetails", "gateway_id", "gateway_id", $sessionlogin);
$trans_type = isset($HTTP_GET_VARS['cctype']) ? $HTTP_GET_VARS['cctype'] : "";
if ($trans_type == "check") {
header("Content-type: application/csv");
header("Content-Disposition: attachment; filename=check_report.csv");
if (!($file = fopen("downloads/check_report.csv", "r"))) {
print "Can not open file";
exit;
}
$content = fread($file, filesize("downloads/check_report.csv"));
} else {
if ($trans_type == "credit") {
header("Content-type: application/csv");
header("Content-Disposition: attachment; filename=creditcard_report.csv");
if (!($file = fopen("downloads/creditcard_report.csv", "r"))) {
print "Can not open file";
exit;
}
$content = fread($file, filesize("downloads/creditcard_report.csv"));
} else {
header("Content-type: application/pdf");
if ($gateway_id == -1) {
header("Content-Disposition: attachment; filename=EtelegateIntegrationGuide.pdf");
if (!($file = fopen("downloads/EtelegateIntegrationGuide.pdf", "r"))) {
print "Can not open file";
$sessionService = isset($HTTP_SESSION_VARS["sessionService"]) ? $HTTP_SESSION_VARS["sessionService"] : "";
$sessionServiceUser = isset($HTTP_SESSION_VARS["sessionServiceUser"]) ? $HTTP_SESSION_VARS["sessionServiceUser"] : "";
$str_company_id = $sessionlogin;
if ($str_company_id == "") {
$str_company_id = $sessionCompanyUser;
}
if ($str_company_id == "") {
$str_company_id = $sessionService;
}
if ($str_company_id == "") {
$str_company_id = $sessionServiceUser;
}
$int_get_permission = "";
if ($str_company_id != "") {
require_once 'includes/function.php';
$int_get_permission = func_get_value_of_field($cnn_cs, "cs_companydetails", "block_virtualterminal", "userid", $str_company_id);
}
?>
<html>
<head>
<title>:: Payment Gateway ::</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="includes/styles/comp_set.css" type="text/css" rel="stylesheet">
<link href="includes/styles/style.css" type="text/css" rel="stylesheet">
<link href="includes/styles/text.css" type="text/css" rel="stylesheet">
</head>
<body topmargin="0" leftmargin="0" bgcolor="#ffffff" marginheight="0" marginwidth="0">
<!--header-->
<div id="testMode" style="position:absolute;width:150px;height:40px;z-index:0; overflow: hidden;visibility:visible;left:160;top:85">
<table><tr>
<td><span style="font-face:verdana;font-weight:bold;Color:#448A99;"><strong><font face='verdana' color='#448A99' size='2'><?php