$PaymentDate = trim(formData('payment_date'));
$QueryString .= "Select * from ar_session where ";
$And = '';
if ($PaymentDate == 'date_val') {
$PaymentDateString = ' check_date ';
} elseif ($PaymentDate == 'post_to_date') {
$PaymentDateString = ' post_to_date ';
} elseif ($PaymentDate == 'deposit_date') {
$PaymentDateString = ' deposit_date ';
}
if ($FromDate != '') {
$QueryString .= " {$And} {$PaymentDateString} >='" . DateToYYYYMMDD($FromDate) . "'";
$And = ' and ';
}
if ($ToDate != '') {
$QueryString .= " {$And} {$PaymentDateString} <='" . DateToYYYYMMDD($ToDate) . "'";
$And = ' and ';
}
if ($PaymentMethod != '') {
$QueryString .= " {$And} payment_method ='" . $PaymentMethod . "'";
$And = ' and ';
}
if ($CheckNumber != '') {
$QueryString .= " {$And} reference like '%" . $CheckNumber . "%'";
$And = ' and ';
}
if ($PaymentAmount != '') {
$QueryString .= " {$And} pay_total ='" . $PaymentAmount . "'";
$And = ' and ';
}
if ($PayingEntity != '') {
if (isset($_POST["mode"])) {
if ($_POST["mode"] == "ModifyPayments" || $_POST["mode"] == "FinishPayments") {
$payment_id = $_REQUEST['payment_id'];
//ar_session Code
//===============================================================================
if (trim(formData('type_name')) == 'insurance') {
$QueryPart = "payer_id = '" . trim(formData('hidden_type_code')) . "', patient_id = '" . 0;
} elseif (trim(formData('type_name')) == 'patient') {
$QueryPart = "payer_id = '" . 0 . "', patient_id = '" . trim(formData('hidden_type_code'));
}
$user_id = $_SESSION['authUserID'];
$closed = 0;
$modified_time = date('Y-m-d H:i:s');
$check_date = DateToYYYYMMDD(formData('check_date'));
$deposit_date = DateToYYYYMMDD(formData('deposit_date'));
$post_to_date = DateToYYYYMMDD(formData('post_to_date'));
if ($post_to_date == '') {
$post_to_date = date('Y-m-d');
}
if (formData('deposit_date') == '') {
$deposit_date = $post_to_date;
}
sqlStatement("update ar_session set " . $QueryPart . "', user_id = '" . trim($user_id) . "', closed = '" . trim($closed) . "', reference = '" . trim(formData('check_number')) . "', check_date = '" . trim($check_date) . "', deposit_date = '" . trim($deposit_date) . "', pay_total = '" . trim(formData('payment_amount')) . "', modified_time = '" . trim($modified_time) . "', payment_type = '" . trim(formData('type_name')) . "', description = '" . trim(formData('description')) . "', adjustment_code = '" . trim(formData('adjustment_code')) . "', post_to_date = '" . trim($post_to_date) . "', payment_method = '" . trim(formData('payment_method')) . "'\twhere session_id='{$payment_id}'");
//===============================================================================
$CountIndexAbove = $_REQUEST['CountIndexAbove'];
$CountIndexBelow = $_REQUEST['CountIndexBelow'];
$hidden_patient_code = $_REQUEST['hidden_patient_code'];
$user_id = $_SESSION['authUserID'];
$created_time = date('Y-m-d H:i:s');
//==================================================================
//UPDATION
<?php
if ($alertmsg) {
echo " alert('" . htmlspecialchars($alertmsg, ENT_QUOTES) . "');\n";
}
?>
</script>
<input type="hidden" name="paydate" value="<?php
echo DateToYYYYMMDD($_REQUEST['paydate']);
?>
" />
<input type="hidden" name="post_to_date" value="<?php
echo DateToYYYYMMDD($_REQUEST['post_to_date']);
?>
" />
<input type="hidden" name="deposit_date" value="<?php
echo DateToYYYYMMDD($_REQUEST['deposit_date']);
?>
" />
<input type="hidden" name="debug" value="<?php
echo $_REQUEST['debug'];
?>
" />
<input type="hidden" name="InsId" value="<?php
echo $_REQUEST['InsId'];
?>
" />
<input type="hidden" name="eraname" value="<?php
echo $eraname;
?>
" />
</form>
<div id='docdiv' <?php
echo $display_div;
?>
>
<?php
$current_user = $_SESSION["authId"];
$date_filter = '';
$query_array = array();
if ($form_from_doc_date) {
$form_from_doc_date = DateToYYYYMMDD($form_from_doc_date);
$date_filter = " DATE(d.date) >= ? ";
array_push($query_array, $form_from_doc_date);
}
if ($form_to_doc_date) {
$form_to_doc_date = DateToYYYYMMDD($form_to_doc_date);
$date_filter .= " AND DATE(d.date) <= ? ";
array_push($query_array, $form_to_doc_date);
}
// Get the category ID for lab reports.
$query = "SELECT rght FROM categories WHERE name = ?";
$catIDRs = sqlQuery($query, array($GLOBALS['lab_results_category_name']));
$catID = $catIDRs['rght'];
$query = "SELECT d.*,CONCAT(pd.fname,' ',pd.lname) AS pname,GROUP_CONCAT(n.note ORDER BY n.date DESC SEPARATOR '|') AS docNotes, \n\t\tGROUP_CONCAT(n.date ORDER BY n.date DESC SEPARATOR '|') AS docDates FROM documents d \n\t\tINNER JOIN patient_data pd ON d.foreign_id = pd.pid \n\t\tINNER JOIN categories_to_documents ctd ON d.id = ctd.document_id AND ctd.category_id = ? \n\t\tLEFT JOIN notes n ON d.id = n.foreign_id \n\t\tWHERE " . $date_filter . " GROUP BY d.id ORDER BY date DESC";
array_unshift($query_array, $catID);
$resultSet = sqlStatement($query, $query_array);
?>
<table border="1" cellpadding=3 cellspacing=0>
<tr class='text bold'>
<th align="left" width="10%"><?php
include_once "{$srcdir}/sql.inc";
include_once "{$srcdir}/options.inc.php";
$DateFormat = DateFormatRead();
if (isset($_POST['mode'])) {
$currentUser = $_SESSION['authUserID'];
$created_time = date('Y-m-d H:i');
if ($_POST["amendment_id"] == "") {
// New. Insert
$query = "INSERT INTO amendments SET \n\t\t\tamendment_date = ?,\n\t\t\tamendment_by = ?,\n\t\t\tamendment_status = ?,\n\t\t\tpid = ?,\n\t\t\tamendment_desc = ?,\n\t\t\tcreated_by = ?,\n\t\t\tcreated_time = ?";
$sqlBindArray = array(DateToYYYYMMDD($_POST['amendment_date']), $_POST['form_amendment_by'], $_POST['form_amendment_status'], $pid, $_POST['desc'], $currentUser, $created_time);
$amendment_id = sqlInsert($query, $sqlBindArray);
} else {
$amendment_id = $_POST['amendment_id'];
// Existing. Update
$query = "UPDATE amendments SET \n\t\t\tamendment_date = ?,\n\t\t\tamendment_by = ?,\n\t\t\tamendment_status = ?,\n\t\t\tamendment_desc = ?,\n\t\t\tmodified_by = ?,\n\t\t\tmodified_time = ?\n\t\t\tWHERE amendment_id = ?";
$sqlBindArray = array(DateToYYYYMMDD($_POST['amendment_date']), $_POST['form_amendment_by'], $_POST['form_amendment_status'], $_POST['desc'], $currentUser, $created_time, $_POST['amendment_id']);
sqlStatement($query, $sqlBindArray);
}
// Insert into amendments_history
$query = "INSERT INTO amendments_history SET \n\t\tamendment_id = ? ,\n\t\tamendment_note = ?,\n\t\tamendment_status = ?,\n\t\tcreated_by = ?,\n\t\tcreated_time = ?";
$sqlBindArray = array($amendment_id, $_POST['note'], $_POST["form_amendment_status"], $currentUser, $created_time);
sqlStatement($query, $sqlBindArray);
header("Location:add_edit_amendments.php?id={$amendment_id}");
exit;
}
$amendment_id = $amendment_id ? $amendment_id : $_REQUEST['id'];
if ($amendment_id) {
$query = "SELECT * FROM amendments WHERE amendment_id = ? ";
$resultSet = sqlQuery($query, array($amendment_id));
$amendment_date = $resultSet['amendment_date'];
$amendment_status = $resultSet['amendment_status'];
