3 * main file for the 270 batch creation.
4 * This report is the batch report required for batch eligibility verification.
6 * This program creates the batch for the x12 270 eligibility file
9 * @link http://www.open-emr.org
10 * @author Terry Hill <terry@lilysystems.com>
11 * @author Brady Miller <brady.g.miller@gmail.com>
12 * @copyright Copyright (c) 2010 MMF Systems, Inc
13 * @copyright Copyright (c) 2016 Terry Hill <terry@lillysystems.com>
14 * @copyright Copyright (c) 2017 Brady Miller <brady.g.miller@gmail.com>
15 * @license https://github.com/openemr/openemr/blob/master/LICENSE GNU General Public License 3
19 require_once("../globals.php");
20 require_once("$srcdir/forms.inc");
21 require_once("$srcdir/billing.inc");
22 require_once("$srcdir/patient.inc");
23 require_once "$srcdir/options.inc.php";
24 require_once("$srcdir/calendar.inc");
25 require_once("$srcdir/edi.inc");
27 use OpenEMR\Core\Header
;
29 // Element data seperator
35 // Component Element seperator
38 // filter conditions for the report and batch creation
40 $from_date = (isset($_POST['form_from_date'])) ?
DateToYYYYMMDD($_POST['form_from_date']) : date('Y-m-d');
41 $to_date = (isset($_POST['form_to_date'])) ?
DateToYYYYMMDD($_POST['form_to_date']) : date('Y-m-d');
42 $form_facility = $_POST['form_facility'] ?
$_POST['form_facility'] : '';
43 $form_provider = $_POST['form_users'] ?
$_POST['form_users'] : '';
44 $exclude_policy = $_POST['removedrows'] ?
$_POST['removedrows'] : '';
45 $X12info = $_POST['form_x12'] ?
explode("|", $_POST['form_x12']) : '';
47 //Set up the sql variable binding array (this prevents sql-injection attacks)
48 $sqlBindArray = array();
50 $where = "e.pc_pid IS NOT NULL AND e.pc_eventDate >= ?";
51 array_push($sqlBindArray, $from_date);
53 //$where .="and e.pc_eventDate = (select max(pc_eventDate) from openemr_postcalendar_events where pc_aid = d.id)";
56 $where .= " AND e.pc_eventDate <= ?";
57 array_push($sqlBindArray, $to_date);
60 if ($form_facility != "") {
61 $where .= " AND f.id = ? ";
62 array_push($sqlBindArray, $form_facility);
65 if ($form_provider != "") {
66 $where .= " AND d.id = ? ";
67 array_push($sqlBindArray, $form_provider);
70 if ($exclude_policy != "") {
71 $arrayExplode = explode(",", $exclude_policy);
72 array_walk($arrayExplode, 'arrFormated');
73 $exclude_policy = implode(",", $arrayExplode);
74 $where .= " AND i.policy_number not in (".add_escape_custom($exclude_policy).")";
77 $where .= " AND (i.policy_number is not null and i.policy_number != '')";
79 $query = sprintf(" SELECT DATE_FORMAT(e.pc_eventDate, '%%Y%%m%%d') as pc_eventDate,
84 DATE_FORMAT(p.dob, '%%Y%%m%%d') as dob,
90 i.provider as payer_id,
91 i.subscriber_relationship,
95 DATE_FORMAT(i.subscriber_dob, '%%m/%%d/%%Y') as subscriber_dob,
98 DATE_FORMAT(i.date,'%%Y%%m%%d') as date,
99 d.lname as provider_lname,
100 d.fname as provider_fname,
101 d.npi as provider_npi,
102 d.upin as provider_pin,
103 f.federal_ein as federal_ein,
104 f.facility_npi as facility_npi,
105 f.name as facility_name,
107 FROM openemr_postcalendar_events AS e
108 LEFT JOIN users AS d on (e.pc_aid is not null and e.pc_aid = d.id)
109 LEFT JOIN facility AS f on (f.id = e.pc_facility)
110 LEFT JOIN patient_data AS p ON p.pid = e.pc_pid
111 LEFT JOIN insurance_data AS i ON (i.id =(
113 FROM insurance_data AS i
114 WHERE pid = p.pid AND type = 'primary'
119 LEFT JOIN insurance_companies as c ON (c.id = i.provider)
123 $res = sqlStatement($query, $sqlBindArray);
125 // Get the facilities information
126 $facilities = getUserFacilities($_SESSION['authId']);
128 // Get the Providers information
129 $providers = getUsernames();
131 //Get the x12 partners information
132 $clearinghouses = getX12Partner();
135 if (isset($_POST['form_savefile']) && !empty($_POST['form_savefile']) && $res) {
136 header('Content-Type: text/plain');
138 'Content-Disposition: attachment; filename="elig-270..%s.%s.txt"',
142 print_elig($res, $X12info, $segTer, $compEleSep);
151 <title
><?php
echo xlt('Eligibility 270 Inquiry Batch'); ?
></title
>
153 <?php Header
::setupHeader('datetime-picker'); ?
>
155 <style type
="text/css">
157 /* specifically include & exclude from printing */
163 #report_parameters_daterange {
167 #report_results table {
172 /* specifically exclude some from the screen */
174 #report_parameters_daterange {
182 <script type
="text/javascript">
184 var stringDelete
= "<?php echo xla('Do you want to remove this record?'); ?>?";
185 var stringBatch
= "<?php echo xla('Please select X12 partner, required to create the 270 batch'); ?>";
189 function refreshme() {
190 document
.forms
[0].submit();
193 // To delete the row from the reports section
194 function deletetherow(id
){
195 var suredelete
= confirm(stringDelete
);
196 if(suredelete
== true){
197 document
.getElementById('PR'+id
).style
.display
="none";
198 if(document
.getElementById('removedrows').value
== ""){
199 document
.getElementById('removedrows').value
= "'" + id +
"'";
201 document
.getElementById('removedrows').value
= document
.getElementById('removedrows').value +
",'" + id +
"'";
208 // To validate the batch file generation - for the required field [clearing house/x12 partner]
209 function validate_batch()
211 if(document
.getElementById('form_x12').value
=='')
218 document
.getElementById('form_savefile').value
= "true";
219 document
.theform
.submit();
226 // To Clear the hidden input field
228 function validate_policy()
230 document
.getElementById('removedrows').value
= "";
231 document
.getElementById('form_savefile').value
= "";
235 // To toggle the clearing house empty validation message
236 function toggleMessage(id
,x12
){
238 var spanstyle
= new String();
240 spanstyle
= document
.getElementById(id
).style
.visibility
;
241 selectoption
= document
.getElementById(x12
).value
;
243 if(selectoption
!= '')
245 document
.getElementById(id
).style
.visibility
= "hidden";
249 document
.getElementById(id
).style
.visibility
= "visible";
250 document
.getElementById(id
).style
.display
= "inline";
256 $
(document
).ready(function() {
257 $
('.datepicker').datetimepicker({
258 <?php
$datetimepicker_timepicker = false; ?
>
259 <?php
$datetimepicker_showseconds = false; ?
>
260 <?php
$datetimepicker_formatInput = true; ?
>
261 <?php
require($GLOBALS['srcdir'] . '/js/xl/jquery-datetimepicker-2-5-4.js.php'); ?
>
262 <?php
// can add any additional javascript settings to datetimepicker here; need to prepend first setting with a comma ?>
269 <body
class="body_top">
271 <!-- Required
for the popup date selectors
-->
272 <div id
="overDiv" style
="position:absolute; visibility:hidden; z-index:1000;"></div
>
274 <span
class='title'><?php
echo xlt('Report'); ?
> - <?php
echo xlt('Eligibility 270 Inquiry Batch'); ?
></span
>
276 <div id
="report_parameters_daterange">
277 <?php
echo text(oeFormatShortDate($form_from_date)) . " " . xlt('to') . " ". text(oeFormatShortDate($form_to_date)); ?
>
280 <form method
='post' name
='theform' id
='theform' action
='edi_270.php' onsubmit
="return top.restoreSession()">
281 <input type
="hidden" name
="removedrows" id
="removedrows" value
="">
282 <div id
="report_parameters">
286 <div style
='float:left'>
289 <td
class='control-label'>
290 <?php
echo xlt('From'); ?
>:
293 <input type
='text' class='datepicker form-control' name
='form_from_date' id
="form_from_date" size
='10' value
='<?php echo attr(oeFormatShortDate($from_date)); ?>'>
295 <td
class='control-label'>
296 <?php
echo xlt('To'); ?
>:
299 <input type
='text' class='datepicker form-control' name
='form_to_date' id
="form_to_date" size
='10' value
='<?php echo attr(oeFormatShortDate($to_date)); ?>'>
305 <td
class='control-label'>
306 <?php
echo xlt('Facility'); ?
>:
309 <?php
dropdown_facility($form_facility, 'form_facility', false); ?
>
311 <td
class='control-label'>
312 <?php
echo xlt('Provider'); ?
>:
315 <select name
='form_users' class='form-control' onchange
='form.submit();'>
316 <option value
=''>-- <?php
echo xlt('All'); ?
> --</option
>
317 <?php
foreach ($providers as $user) : ?
>
318 <option value
='<?php echo attr($user['id
']); ?>'
319 <?php
echo $form_provider == $user['id'] ?
" selected " : null; ?
>
320 ><?php
echo text($user['fname']." ".$user['lname']); ?
></option
>
329 <td
class='control-label'>
330 <?php
echo xlt('X12 Partner'); ?
>:
333 <select name
='form_x12' id
='form_x12' class='form-control' onchange
='return toggleMessage("emptyVald","form_x12");' >
334 <option value
=''>--<?php
echo xlt('select'); ?
>--</option
>
336 if (isset($clearinghouses) && !empty($clearinghouses)) {
337 foreach ($clearinghouses as $clearinghouse) { ?
>
338 <option value
='<?php echo attr($clearinghouse['id
']."|".$clearinghouse['id_number
']."|".$clearinghouse['x12_sender_id
']."|".$clearinghouse['x12_receiver_id
']."|".$clearinghouse['x12_version
']."|".$clearinghouse['processing_format
']); ?>'
339 <?php
echo $clearinghouse['id'] == $X12info[0] ?
" selected " : null; ?
>
340 ><?php
echo text($clearinghouse['name']); ?
></option
>
346 <span id
='emptyVald' style
='color:red;font-size:12px;'> * <?php
echo xlt('Clearing house info required for EDI 270 batch creation.'); ?
></span
>
352 <td align
='left' valign
='middle' height
="100%">
353 <table style
='border-left:1px solid; width:100%; height:100%' >
356 <div
class="text-center">
357 <div
class="btn-group" role
="group">
358 <a href
='#' class='btn btn-default btn-refresh' onclick
='validate_policy(); $("#theform").submit();'>
359 <?php
echo xlt('Refresh'); ?
>
361 <a href
='#' class='btn btn-default btn-transmit' onclick
='return validate_batch();'>
362 <?php
echo xlt('Create batch'); ?
>
363 <input type
='hidden' name
='form_savefile' id
='form_savefile' value
=''></input
>
376 <?php
echo xlt('Please choose date range criteria above, and click Refresh to view results.'); ?
>
383 show_elig($res, $X12info, $segTer, $compEleSep);
388 <script language
='JavaScript'>
391 echo " alert('$alertmsg');\n";