<td align="left" height="30" class='cl1'><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> <?php
echo $showval[44];
?>
</font></td>
</tr>
<tr>
<td align="left" valign="center" height="30" class='cl1'><strong><font face="verdana" size="1">URL3 </font></strong></td>
<td align="left" height="30" class='cl1'><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> <?php
echo $showval[45];
?>
</font></td>
</tr> <tr>
<td align='left' class='cl1'><font face='verdana' size='1'><b>Signup Date & Time</b></font></td>
<td align='left' class='cl1'><font face='verdana' size='1'>
<?php
echo $showval[46] == "0000-00-00 00:00:00" ? "Not Available" : func_get_date_time_12hr($showval[46]);
?>
</font></td>
</tr>
<tr>
<td height="30" align="right" valign="center" class='cl1' bgcolor="#CCCCCC"><font face="verdana" size="1" color="#FFFFFF"><strong>E-mail
Template Setup</strong> </font></td>
<td height="30" class='cl1' align="left"> </td>
</tr>
<tr>
<td height="25" class='cl1'><strong><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Merchant
Name</font></strong></td>
<td class='cl1'> <font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<?php
echo $showval[13];
<input type="text" name="driverlicense" size="25" maxlength="100">
</font></td>
</tr>
<tr>
<td align="right" valign="middle" class="tdbdr1" height="30"><font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">Misc
: </font></td>
<td valign="middle" class="tdbdr"><font color="#001188">
<input type="text" name="misc" size="35" maxlength="100">
</font></td>
</tr>
<tr>
<td align="right" valign="middle" class="tdbdr1" height="30"><font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">Date/Time
:</font></td>
<td valign="middle" class="tdbdr"><font size="1" face="Verdana" color="#000000">
<?php
print func_get_date_time_12hr($dateToEnter);
?>
</font></td>
</tr>
<tr>
<td align="right" valign="middle" class="tdbdr1" height="30"><font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">IP
Address :</font> </td>
<td valign="middle" class="tdbdr"><font size="1" face="Verdana" color="#000000">
<?php
echo $domain;
?>
</font> </td>
</tr>
<input type="hidden" name="domain1" value="<?php
</font></td>
</tr>
<tr>
<td align="right" class="tdbdr1"><font size="2" face="Verdana" color="#000000">Product Description : </font></td>
<td class="tdbdr"> <font color="#001188">
<input type="text" name="txtproductDescription" size="30" maxlength="200" value="<?php
echo $transactionInfo['productdescription'];
?>
" >
</font></td>
</tr>
<tr>
<td align="right" valign="middle" class="tdbdr1"><font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">Date/Time :</font></td>
<td valign="middle" class="tdbdr"><font size="1" face="Verdana" color="#000000">
<?php
echo func_get_date_time_12hr($transactionInfo['transactionDate']);
?>
</font></td>
</tr>
<tr>
<td align="right" valign="middle" class="tdbdr2"><font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">IP Address :</font> </td>
<td valign="middle" ><font size="1" face="Verdana" color="#000000">
<?php
echo $transactionInfo['ipaddress'];
?>
</font> <img border="0" SRC="<?php
echo $tmpl_dir;
?>
/images/mastercard.jpg"> <img border="0" SRC="<?php
echo $tmpl_dir;
?>
<td align='center' width='79' class='cl1'><font face='verdana' size='1'><a href="viewreportpage.php?date=<?php
echo $show_select_val[8];
?>
& id=<?php
echo $transactionInfo['transactionId'];
?>
&test=<?php
echo $display_test_transactions;
?>
" class="link">
<?php
echo $show_select_val['reference_number'] == "" ? $show_select_val[1] : $show_select_val['reference_number'];
?>
</a><br>
<?php
echo func_get_date_time_12hr($show_select_val[8]);
?>
</font></td>
<td align='left' class='cl1' ><font face='verdana' size='1'> <?php
echo $str_user_type;
?>
</font></td>
<?php
if ($_SESSION["sessionlogin_type"] == "tele") {
?>
<td align='left' class='cl1' ><font face='verdana' size='1'> <?php
echo $str_company_type == 2 ? $str_user_name : "";
?>
</font></td>
<td align='left' class='cl1' ><font face='verdana' size='1'> <?php
echo $str_company_type == 1 ? $str_user_name : "";
$yearval = date("Y");
$monthval = date("m");
$dateval = date("d");
$hr = date("G");
$mn = date("i");
$tt = date("A");
$str_current_date = func_get_current_date();
$i_to_year = substr($str_current_date, 0, 4);
$i_to_month = substr($str_current_date, 5, 2);
$i_to_day = substr($str_current_date, 8, 2);
/*$i_to_day = date("d");
$i_to_month = date("m");
$i_to_year = date("Y");*/
//$dateToEnter="$yearval-$monthval-$dateval";
$curr_date = func_get_current_date_time();
$dateToEnter = func_get_date_time_12hr($curr_date);
//EST Time.
$tran_login_type = "";
if ($i_company_id != "") {
$sql_trans_type = "Select transaction_type,bank_Creditcard 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];
$bank_Creditcard = $show_val[1];
}
}
}
if ($tran_login_type == "tele") {
$i_to_day = date("d", mktime(0, 0, 0, $i_to_month, $i_to_day + 1, $i_to_year));
$i_to_month = date("m", mktime(0, 0, 0, $i_to_month, $i_to_day + 1, $i_to_year));
$i_to_year = date("Y", mktime(0, 0, 0, $i_to_month, $i_to_day + 1, $i_to_year));
if ($str_pass_status_code == 'PA') {
$i_pass++;
$str_pass_status = "Pass";
} else {
if ($str_pass_status_code == 'NP') {
$i_no_pass++;
$str_pass_status = "No Pass";
} else {
if ($str_pass_status_code == 'ND') {
$str_pass_status = "Negative Database";
}
}
}
$str_report .= "<input type='hidden' name='upload_id{$iloop}' value='{$show_select_details['0']}'>";
$str_report .= "<tr>";
$str_report .= "<td class='leftbottomright' height='30'><font size='1' face='Verdana'>" . func_get_date_time_12hr($show_select_details[6]) . "</font></td>";
$str_report .= "<td class='rightbottomtd' ><font size='1' face='Verdana' >{$show_select_details['2']}</font></td>";
$str_report .= "<td class='rightbottomtd' ><font size='1' face='Verdana' >{$show_select_details['8']}</font></td>";
$str_report .= "<td class='rightbottomtd' ><font size='1' face='Verdana' >{$show_select_details['3']}</font></td>";
$str_report .= "<td class='rightbottomtd' ><font size='1' face='Verdana' >{$str_pass_status}</font></td>";
$str_report .= "<td class='rightbottomtd' ><font size='1' face='Verdana' >{$show_select_details['5']} </font></td>";
$str_report .= "</tr>";
}
?>
<tr>
<td class="lgnbd" colspan="5" height="30">
<font face="verdana" size="2"><strong>Total Records Updated: <?php
echo $i_count;
?>
Pass: <?php
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'>
<?php
if ($str_user_type) {
echo $str_user_type . "/ <br>";
}
?>
<?php
echo $strServiceUser != "" ? $strServiceUser . " / " . $strCompany : $strCompany;
?>
</font> </td>
<td align='left' class='cl1' ><font face='verdana' size='1'><?php
$str_data .= "<td width='5%' bgcolor='#CCCCCC' ><span class='subhd'>Customer Name</span></td>";
$str_data .= "<td width='6%' bgcolor='#CCCCCC' ><span class='subhd'>Amount</span></td>";
$str_data .= "<td width='6%' bgcolor='#CCCCCC' ><span class='subhd'>Phone Number</span></td>";
$str_data .= "<td width='12%' bgcolor='#CCCCCC'><span class='subhd'>Call DateTime</span></td>";
$str_data .= "<td width='19%' bgcolor='#CCCCCC' ><span class='subhd'>Reason</span></td>";
$str_data .= "<td width='8%' bgcolor='#CCCCCC' ><span class='subhd'>Bill Date</span></td>";
$str_data .= "<td width='5%' bgcolor='#CCCCCC' ><span class='subhd'>Customer Service Rep.</span></td>";
$str_data .= "</tr>";
}
$str_data .= "<tr>";
$str_data .= "<td bgcolor='#E2E2E2' height='30'><font size='1' face='Verdana' >" . ++$i_num_record . "</font></td>";
$str_data .= "<td bgcolor='#E2E2E2'><font size='1' face='Verdana' ><a href='viewreportpage.php?id=" . $transInfo['transactionId'] . "'>" . $transInfo['cancel_refer_num'] . "</a></font></td>";
$str_data .= "<td bgcolor='#E2E2E2'><font size='1' face='Verdana' >" . $transInfo['name'] . " " . $transInfo['surname'] . "</font></td>";
$str_data .= "<td bgcolor='#E2E2E2'><font size='1' face='Verdana' >" . $transInfo['amount'] . " </font></td>";
$str_data .= "<td bgcolor='#E2E2E2'><font size='1' face='Verdana' >" . $transInfo['phonenumber'] . " </font></td>";
$str_data .= "<td bgcolor='#E2E2E2'><font size='1' face='Verdana' >" . func_get_date_time_12hr($transInfo['cancellationDate']) . "</font></td>";
$str_data .= "<td bgcolor='#E2E2E2'><font size='1' face='Verdana' >" . $transInfo['reason'] . "<br>" . $transInfo['other'] . "</font></td>";
$str_data .= "<td bgcolor='#E2E2E2'><font size='1' face='Verdana' >" . func_get_date_inmmddyy($transInfo['transactionDate']) . "</font></td>";
$str_data .= "<td bgcolor='#E2E2E2'><font size='1' face='Verdana' >" . $str_customer_service_rep . " </font></td>";
$str_data .= "</tr>";
$str_data .= "<input type='hidden' name='hid_trans_id" . $i . "' value='" . $i_transid . "'>";
$str_data .= "<input type='hidden' name='hid_note_id" . $i . "' value='" . $i_noteid . "'>";
$str_data .= "<input type='hidden' name='payment_type" . $i . "' value='" . $str_payment_type . "'>";
$str_data .= "<input type='hidden' name='bank_routing_code" . $i . "' value='" . $str_bank_routing_code . "'>";
$str_data .= "<input type='hidden' name='company_id" . $i . "' value='" . $i_company_id . "'>";
}
?>
<form name="frm_cancel_requests" action="" method="post">
<table border="0" cellpadding="0" width="100%" cellspacing="0" height="55%" align="center">
<tr>
<td width="95%" valign="top" align="center">
$str_data .= "<td width='12%' bgcolor='#CCCCCC'><span class='subhd'>Call DateTime</span></td>";
$str_data .= "<td width='19%' bgcolor='#CCCCCC'><span class='subhd'>Service Notes</span></td>";
//$str_data .= "<td width='9%' bgcolor='#CCCCCC'><span class='subhd'>Prev. Bill Date</span></td>";
//$str_data .= "<td width='9%' bgcolor='#CCCCCC'><span class='subhd'>New Bill Date</span></td>";
$str_data .= "<td width='6%' bgcolor='#CCCCCC'><span class='subhd'>Order Cancel Status</span></td>";
//$str_data .= "<td width='5%' bgcolor='#CCCCCC'><span class='subhd'>Solved</span></td>";
$str_data .= "<td width='7%' bgcolor='#CCCCCC'><span class='subhd'>Call Duration</span></td>";
$str_data .= "<td width='5%' bgcolor='#CCCCCC'><span class='subhd'>Customer Service Rep.</span></td>";
$str_data .= "</tr>";
}
$str_data .= "<tr>";
$str_data .= "<td bgcolor='#E2E2E2' height='30'><font size='1' face='Verdana' >" . ++$i_num_record . "</font></td>";
$str_data .= "<td bgcolor='#E2E2E2'><font size='1' face='Verdana' ><a href='viewreportpage.php?id={$i_transid}'>{$i_transref}</a></font></td>";
$str_data .= "<td bgcolor='#E2E2E2'><font size='1' face='Verdana' >{$str_first_name} {$str_surname}</font></td>";
$str_data .= "<td bgcolor='#E2E2E2'><font size='1' face='Verdana' >{$str_phone}</font></td>";
$str_data .= "<td bgcolor='#E2E2E2'><font size='1' face='Verdana' >" . func_get_date_time_12hr($str_calldatetime) . "</font></td>";
$str_data .= "<td bgcolor='#E2E2E2'><font size='1' face='Verdana' >";
if ($str_notes == "") {
$str_data .= " ";
} else {
$str_data .= "{$str_notes}";
}
$str_data .= "</font></td>";
//$str_data .= "<td bgcolor='#E2E2E2'><font size='1' face='Verdana' >$str_prev_bill_date</font></td>";
//$str_data .= "<td bgcolor='#E2E2E2'><font size='1' face='Verdana' >$str_new_date</font></td>";
$str_data .= "<td bgcolor='#E2E2E2' >";
$str_data .= "<table cellpadding='0' cellspacing='0'><tr><td {$str_cancelled_after_bill_date}>";
$str_data .= "<font size='1' face='Verdana, Arial, Helvetica, sans-serif'>{$str_cancel_status}</font>";
$str_data .= "</td></tr>";
$str_data .= "</table>";
$str_data .= "</td>";
if ($transactionInfo['status'] == "A") {
echo "<input name='Submit' type='submit' value='Set Chargeback' title='Chargeback'>";
}
}
}
}
?>
<br>
</p>
<?php
echo $transactionInfo['cancel_refer_num'] ? $transactionInfo['cancel_refer_num'] : "";
?>
<?php
print func_get_date_time_12hr($transactionInfo['cancellationDate']);
?>
</font></strong></td>
<td class='cl1 style3'><font face='verdana' size='1'>
<?php
echo $transactionInfo['reason'];
?>
<?php
if ($transactionInfo['hasRefundRequest']) {
echo "<BR>Refund Requested:<BR>" . $transactionInfo['service_notes'];
}
?>
</font> </td>
<td class='cl1' width="100"><font face='verdana' size='1'>
$i_customer_service_id = mysql_result($rssel_enqiry, $i, 7);
$str_cancel_status = mysql_result($rssel_enqiry, $i, 8);
$arr_call_duration[$i] = $str_callDuration;
$str_customer_service_rep = "";
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);
}
$str_data .= "<tr>";
$str_data .= "<td height='30' bgcolor='#E2E2E2'><font size='1' face='Verdana' >" . ($i + 1) . "</font></td>";
$str_data .= "<td height='30' bgcolor='#E2E2E2'><font size='1' face='Verdana' >{$str_customerName}</font></td>";
$str_data .= "<td height='30' bgcolor='#E2E2E2'><font size='1' face='Verdana' >{$str_customerAddress}</font></td>";
$str_data .= "<td height='30' bgcolor='#E2E2E2'><font size='1' face='Verdana' >{$str_customerPhone}</font></td>";
$str_data .= "<td height='30' bgcolor='#E2E2E2'><font size='1' face='Verdana' >{$str_notes}</font></td>";
$str_data .= "<td height='30' bgcolor='#E2E2E2'><font size='1' face='Verdana' >" . func_get_date_time_12hr($str_currentDateTime) . "</font></td>";
$str_data .= "<td height='30' bgcolor='#E2E2E2'><font size='1' face='Verdana' >{$str_callDuration}</font></td>";
$str_data .= "<td height='30' bgcolor='#E2E2E2'><font size='1' face='Verdana' >{$str_customer_service_rep}</font></td>";
$str_data .= "</tr>";
}
?>
<table border="0" cellpadding="0" width="100%" cellspacing="0" height="61%" align="center">
<tr>
<td width="95%" valign="top" align="center" ><br>
<form name="frm_enquires" action="enquires.php" method="post">
<table width="90%" border="0" cellspacing="0" cellpadding="0" height="10">
<tr>
<td height="22" align="left" valign="top" width="1%" background="../images/menucenterbg.gif" nowrap><img border="0" SRC="<?php
echo $tmpl_dir;