$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'];