$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);
$i_to_day = substr($str_return_date, 8, 2);
$str_from_date = $i_from_year . "-" . $i_from_month . "-" . $i_from_day;
$str_to_date = $i_to_year . "-" . $i_to_month . "-" . $i_to_day;
$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));
$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_year = substr($str_return_date,0,4);
$i_to_month = substr($str_return_date,5,2);
$i_to_day = substr($str_return_date,8,2); */
$str_from_date = $i_from_year . "-" . $i_from_month . "-" . $i_from_day;
$str_to_date = $i_to_year . "-" . $i_to_month . "-" . $i_to_day;
if ($tran_login_type == "tele") {
$str_return_date = date("Y m d H:i", mktime(0, 0, 0, $i_to_month, $i_to_day + 1, $i_to_year));
$i_to_year = substr($str_return_date, 0, 4);
$i_to_month = substr($str_return_date, 5, 2);
$i_to_day = substr($str_return_date, 8, 2);
}
$dateToEnter = func_get_current_date_time();
function func_is_future_date($strBillDate)
{
$is_future_date = false;
$str_current_date = func_get_current_date();
if ($strBillDate > $str_current_date) {
$is_future_date = true;
}
//print("is future date= ".$is_future_date."*");
return $is_future_date;
}
$ref_no = func_Trans_Ref_No($trans_id);
$table = "`cs_transactiondetails` as t ";
$show_select_val = getTransactionInfo($trans_id, false);
if ($refund != "") {
$etel_debug_mode = 0;
$msg = exec_refund_request($trans_id, "Customer Service Refund", "{$cancelreason}:{$cancelreasonother}");
$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'>{$msg}. Callback through '{$contactmethod}'.<br></font></td></tr><tr><td align='center'><a href='startpage.php'><img border='0' src='../images/back.gif'></a></td></tr></table>";
} else {
if ($cancel != "") {
$cancelreason = isset($HTTP_POST_VARS['selectReason']) ? quote_smart($HTTP_POST_VARS['selectReason']) : "";
$cancelreasonother = isset($HTTP_POST_VARS['txtNotes']) ? quote_smart($HTTP_POST_VARS['txtNotes']) : "";
//$str_is_cancelled = func_get_value_of_field($cnn_cs,"cs_transactiondetails","cancelstatus","transactionId",$return_insertId);
if ($show_select_val['td_enable_rebill'] == "0") {
$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'>This transaction/subscription has been already canceled.<br>You will no longer be rebilled for this subscription.</font></td></tr><tr><td align='center'><a href='startpage.php'><img border='0' src='../images/back.gif'></a></td></tr></table>";
} else {
$strCurrentDateTime = func_get_current_date();
$str_approval_status = $show_select_val['status'];
if ($strCurrentDateTime >= $str_bill_date && $str_approval_status == "A") {
$qrt_update_details = "Update cs_transactiondetails set td_enable_rebill='0' where transactionId={$trans_id} AND reference_number = '{$reference_number}'";
// and userid=$user_id";
if (!($qrt_update_run = mysql_query($qrt_update_details))) {
print mysql_errno() . ": " . mysql_error() . "<BR>";
die("Cannot execute query '{$qrt_update_details}'");
} 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='startpage.php'><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 td_enable_rebill='0' where transactionId={$trans_id}";
//print($qryUpdate."<br>");
if (!mysql_query($qryUpdate, $cnn_cs)) {
function func_update_approval_status($cnn_cs, $trans_id, $approval_status, $pass_status, $decline_reason)
{
$strCurrentDateTime = func_get_current_date();
$str_approval_date = "";
$str_pass_status = "";
if ($approval_status == "A") {
$str_approval_date = "approvaldate = '{$strCurrentDateTime}',";
}
if ($pass_status != "") {
$str_pass_status = "passStatus = '{$pass_status}',";
}
$qryUpdate = "update cs_transactiondetails set status = '{$approval_status}', {$str_approval_date} {$str_pass_status} declinedReason = '{$decline_reason}' where transactionId={$trans_id}";
if (!mysql_query($qryUpdate, $cnn_cs)) {
print mysql_errno() . ": " . mysql_error() . "<BR>";
print "Can not execute approval status update query";
exit;
}
}
if (isset($_SESSION["sessionService"])) {
$i_customer_service_id = 0;
} else {
if (isset($_SESSION["sessionServiceUserId"])) {
$i_customer_service_id = $_SESSION["sessionServiceUserId"];
}
}
$str_new_bill_date = $str_orig_bill_date;
//else
//{
// $str_new_bill_date = $str_bill_date;
//}
$strDateTime = func_get_current_date_time();
$strCurrentDate1 = func_get_current_date();
$strCurrentDate1 .= " 00:00:00";
$strCurrentDate2 = func_get_current_date();
$strCurrentDate2 .= " 23:59:59";
$str_cancel_status = "0";
$str_set_query = "";
//$str_bill_date_changed = "N";
if ($str_callback == "Y") {
funcCallBack($cnn_cs, $strTransactionId);
}
if ($i_bill_month != "") {
$i_bill_month = $i_bill_month < 10 ? "0" . $i_bill_month : $i_bill_month;
$i_bill_day = $i_bill_day < 10 ? "0" . $i_bill_day : $i_bill_day;
$str_new_bill_date = $i_bill_year . "-" . $i_bill_month . "-" . $i_bill_day;
if ($str_new_bill_date != $str_orig_bill_date) {
$str_changed_bill_date = "Y";
if ($str_set_query == "") {
$str_set_query = "billingDate = '{$str_new_bill_date}'";
