$i_discount_rate = 0;
$i_reserve = 0;
$i_total_amt = 0;
$i_total_deduction = 0;
$i_grand_deduction = 0;
$i_grand_amt = 0;
$str_date = "";
$str_temp_date = "";
while ($show_select_details = mysql_fetch_array($rs_select_details)) {
$str_temp_date = $str_date;
$iloop = $iloop + 1;
$str_company = $show_select_details[9];
$arr_day = split(" ", $show_select_details[0]);
$str_day = $arr_day[0];
if ($str_frequency == "D") {
$str_date = func_get_date_inmmddyy($str_day);
} else {
if ($str_frequency == "W") {
$str_date = func_get_weekrange_from_date($str_day);
} else {
if ($str_frequency == "M") {
$str_date = func_get_month_from_date($str_day);
}
}
}
//print("day= ".$str_day."; temp= ".$str_temp_day);
if (($str_temp_date != $str_date || $str_temp_company != $str_company) && $str_temp_date != "") {
$i_total_deduction = $i_trans_fee + $i_voice_auth_fee + $i_charge_back_fee + $i_credit + $i_discount_rate + $i_reserve;
?>
<tr>
<?php
}
?>
</td>
</tr>
<?php
if ($str_cancel_status == "Y") {
?>
<tr>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Cancel
Date</font></div></td>
<td> </td>
<td>
<table cellpadding="0" cellspacing="0"><tr><td style="border:1 solid red">
<font size="1" face="Verdana, Arial, Helvetica, sans-serif"><?php
echo func_get_date_inmmddyy($strCancelDate);
?>
</font>
</td></tr>
</table>
</td>
</tr>
<?php
}
?>
<?php
if ($strApprovalStatus == "Declined") {
?>
<tr>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Decline Reason </font></div></td>
<td> </td>
" disabled>
</font>
<!-- <select size="1" name="accounttype" style="font-size: 8pt; font-family: Verdana">
<option value="Xchoose">Choose</option>
<option value="checking">Checking</option>
<option value="savings">Savings</option>
</select>
-->
</td>
</tr>
<tr>
<td align="right" class="tdbdr1"><font size="2" face="Verdana" color="#000000">Billing
Date : </font></td>
<td class="tdbdr"> <font color="#001188">
<input type="text" name="setbilldate2" size="20" value="<?php
echo func_get_date_inmmddyy($show_select_val[38]);
?>
" disabled>
<!--<font color="#001188"><input type="text" name="setbilldate" size="20"></font>-->
</font> </td>
</tr>
<!-- <tr>
<td align="right" class="tdbdr1"><font size="2" face="Verdana" color="#000000">Memo
: </font></td>
<td class="tdbdr"> <font color="#001188">
<input type="text" name="memo" size="44">
</font></td>
</tr>
-->
<tr bgcolor="#CCCCCC">
<td colspan="2" align="center" valign="middle" class="tdbdr"><span class="subhd"><strong>Bank
<input type="radio" name="accounttype" value="savings" <?php
echo $checks;
?>
>
<font size="1" face="Verdana" color="#000000">Savings</font> </font> </td>
</tr>
<tr>
<td align="right" class="tdbdr1"><font size="2" face="Verdana" color="#000000">Billing Date(mm-dd-yyyy) : </font></td>
<td class="tdbdr"> <font color="#001188">
<input type="text" name="setbilldate" size="20" value="<?php
echo func_get_date_inmmddyy($transactionInfo['billingDate']);
?>
" >
</font><font color="#001188">
<!-- <input type="text" name="setbilldate2" size="20" value="<?php
echo func_get_date_inmmddyy($transactionInfo[38]);
?>
" > -->
</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">
<font color="#001188">
<input type="text" name="txtproductDescription" size="30" maxlength="200" value="<?php
echo $transactionInfo['productdescription'];
?>
" >
</font> </font></td>
</tr>
<tr bgcolor="#CCCCCC">
$str_data .= "<tr>";
if ($rejected == "") {
$str_data .= "<td width='2%' bgcolor='#CCCCCC'><span class='subhd'>Accept</span></td>";
$str_data .= "<td width='2%' bgcolor='#CCCCCC'><span class='subhd'>Reject</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='#' onClick='showWindow({$i_transid})'>" . $i_refnum . "</a> </font></td>";
$str_data .= "<td bgcolor='#E2E2E2'><font size='1' face='Verdana' >" . $bank_trid . " </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' >" . $str_checkorcard . " </font></td>";
$str_data .= "<td bgcolor='#E2E2E2' align='right'><font size='1' face='Verdana' >(" . $currency . ") " . formatMoney($i_amount) . "</font></td>";
$str_data .= "<td bgcolor='#E2E2E2'><font size='1' face='Verdana' >" . func_get_date_inmmddyy($str_bill_date) . "</font></td>";
$str_data .= "<td bgcolor='#E2E2E2'><font size='1' face='Verdana' >" . $str_cancellation_reason . " </font></td>";
if ($rejected == "") {
$str_data .= "<td bgcolor='#E2E2E2' align='center'><input type='radio' name='cancel_status" . $i . "' value='accept'></td>";
$str_data .= "<td bgcolor='#E2E2E2' align='center'><input type='radio' name='cancel_status" . $i . "' value='reject'></td>";
}
$str_data .= "</tr>";
$str_data .= "<input type='hidden' name='hid_trans_id" . $i . "' value='" . $i_transid . "'>";
$str_data .= "<input type='hidden' name='payment_type" . $i . "' value='" . $str_checkorcard . "'>";
$str_data .= "<input type='hidden' name='company_id" . $i . "' value='" . $i_company_id . "'>";
$str_data .= "<input type='hidden' name='i_bnk_creditcard" . $i . "' value='" . $i_bnk_creditcard . "'>";
$str_data .= "<input type='hidden' name='i_bnk_chek" . $i . "' value='" . $i_bnk_chek . "'>";
}
if ($yes == 0) {
$msgtodisplay = "No Cancel Requests under this Bank ({$bname}).";
$outhtml = "y";
$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">
<table width="98%" border="0" cellspacing="0" cellpadding="0">
$str_call_duration = mysql_result($rssel_report, $i, 7);
$i_customer_service_id = mysql_result($rssel_report, $i, 8);
$str_prev_bill_date = mysql_result($rssel_report, $i, 9);
$str_phone = mysql_result($rssel_report, $i, 10);
$str_new_bill_date = mysql_result($rssel_report, $i, 11);
$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'";
