public function postTimeline()
{
$pid = Session::get('pid');
$json = array();
$date_arr = array();
$query0 = DB::table('encounters')->where('pid', '=', $pid)->where('addendum', '=', 'n')->get();
if ($query0) {
foreach ($query0 as $row0) {
$description = '';
$procedureInfo = Procedure::find($row0->eid);
if ($procedureInfo) {
$description .= '<br><h4>Procedures:</h4><p class="view">';
if ($procedureInfo->proc_type != '') {
$description .= '<strong>Procedure: </strong>';
$description .= nl2br($procedureInfo->proc_type);
$description .= '<br /><br />';
}
$description .= '</p>';
}
$assessmentInfo = Assessment::find($row0->eid);
if ($assessmentInfo) {
$description .= '<br><h4>Assessment:</h4><p class="view">';
if ($assessmentInfo->assessment_1 != '') {
$description .= '<strong>' . $assessmentInfo->assessment_1 . '</strong><br />';
if ($assessmentInfo->assessment_2 == '') {
$description .= '<br />';
}
}
if ($assessmentInfo->assessment_2 != '') {
$description .= '<strong>' . $assessmentInfo->assessment_2 . '</strong><br />';
if ($assessmentInfo->assessment_3 == '') {
$description .= '<br />';
}
}
if ($assessmentInfo->assessment_3 != '') {
$description .= '<strong>' . $assessmentInfo->assessment_3 . '</strong><br />';
if ($assessmentInfo->assessment_4 == '') {
$description .= '<br />';
}
}
if ($assessmentInfo->assessment_4 != '') {
$description .= '<strong>' . $assessmentInfo->assessment_4 . '</strong><br />';
if ($assessmentInfo->assessment_5 == '') {
$description .= '<br />';
}
}
if ($assessmentInfo->assessment_5 != '') {
$description .= '<strong>' . $assessmentInfo->assessment_5 . '</strong><br />';
if ($assessmentInfo->assessment_6 == '') {
$description .= '<br />';
}
}
if ($assessmentInfo->assessment_6 != '') {
$description .= '<strong>' . $assessmentInfo->assessment_6 . '</strong><br />';
if ($assessmentInfo->assessment_7 == '') {
$description .= '<br />';
}
}
if ($assessmentInfo->assessment_7 != '') {
$description .= '<strong>' . $assessmentInfo->assessment_7 . '</strong><br />';
if ($assessmentInfo->assessment_8 == '') {
$description .= '<br />';
}
}
if ($assessmentInfo->assessment_8 != '') {
$description .= '<strong>' . $assessmentInfo->assessment_8 . '</strong><br /><br />';
}
if ($assessmentInfo->assessment_other != '') {
if ($row0->encounter_template == 'standardmtm') {
$description .= '<strong>SOAP Note: </strong>';
} else {
$description .= '<strong>Additional Diagnoses: </strong>';
}
$description .= nl2br($assessmentInfo->assessment_other);
$description .= '<br /><br />';
}
if ($assessmentInfo->assessment_ddx != '') {
if ($row0->encounter_template == 'standardmtm') {
$description .= '<strong>MAP2: </strong>';
} else {
$description .= '<strong>Differential Diagnoses Considered: </strong>';
}
$description .= nl2br($assessmentInfo->assessment_ddx);
$description .= '<br /><br />';
}
if ($assessmentInfo->assessment_notes != '') {
if ($row0->encounter_template == 'standardmtm') {
$description .= '<strong>Pharmacist Note: </strong>';
} else {
$description .= '<strong>Assessment Discussion: </strong>';
}
$description .= nl2br($assessmentInfo->assessment_notes);
$description .= '<br /><br />';
}
$description .= '</p>';
}
$json[] = array('title' => "<span class='timeline_event' value='" . $row0->eid . "' type='eid' status='" . $row0->encounter_signed . "'>Encounter: " . $row0->encounter_cc . "</span>", 'description' => $description, 'startDate' => $this->human_to_unix($row0->encounter_DOS));
$date_arr[] = $this->human_to_unix($row0->encounter_DOS);
}
}
$query1 = DB::table('t_messages')->where('pid', '=', $pid)->get();
if ($query1) {
foreach ($query1 as $row1) {
$json[] = array('title' => "<span class='timeline_event' value='" . $row1->t_messages_id . "' type='t_messages_id' status='" . $row1->t_messages_signed . "'>Message: " . $row1->t_messages_subject . "</span>", 'description' => substr($row1->t_messages_message, 0, 500) . '...', 'startDate' => $this->human_to_unix($row1->t_messages_dos));
$date_arr[] = $this->human_to_unix($row1->t_messages_dos);
}
}
$query2 = DB::table('rx_list')->where('pid', '=', $pid)->orderBy('rxl_date_active', 'asc')->groupBy('rxl_medication')->get();
if ($query2) {
foreach ($query2 as $row2) {
$row2a = DB::table('rx_list')->where('rxl_id', '=', $row2->rxl_id)->first();
if ($row2->rxl_sig == '') {
$instructions = $row2->rxl_instructions;
} else {
$instructions = $row2->rxl_sig . ' ' . $row2->rxl_route . ' ' . $row2->rxl_frequency;
}
$description2 = $row2->rxl_medication . ' ' . $row2->rxl_dosage . ' ' . $row2->rxl_dosage_unit . ', ' . $instructions . ' for ' . $row2->rxl_reason;
$json[] = array('title' => "<span class='timeline_event' value='" . $row2->rxl_id . "' type='rxl_id'>New Medication Started</span>", 'description' => $description2, 'startDate' => $this->human_to_unix($row2->rxl_date_active));
$date_arr[] = $this->human_to_unix($row2->rxl_date_active);
}
}
$query3 = DB::table('issues')->where('pid', '=', $pid)->get();
if ($query3) {
foreach ($query3 as $row3) {
if ($row3->type == 'Problem List') {
$title = 'New Problem';
}
if ($row3->type == 'Medical History') {
$title = 'New Medical Event';
}
if ($row3->type == 'Problem List') {
$title = 'New Surgical Event';
}
$json[] = array('title' => "<span class='timeline_event' value='" . $row3->issue_id . "' type='issue_id'>" . $title . "</span>", 'description' => $row3->issue, 'startDate' => $this->human_to_unix($row3->issue_date_active));
$date_arr[] = $this->human_to_unix($row3->issue_date_active);
}
}
$query4 = DB::table('immunizations')->where('pid', '=', $pid)->get();
if ($query4) {
foreach ($query4 as $row4) {
$json[] = array('title' => "<span class='timeline_event' value='" . $row4->imm_id . "' type='imm_id'>Immunization Given</span>", 'description' => $row4->imm_immunization, 'startDate' => $this->human_to_unix($row4->imm_date));
$date_arr[] = $this->human_to_unix($row4->imm_date);
}
}
$query5 = DB::table('rx_list')->where('pid', '=', $pid)->where('rxl_date_inactive', '!=', '0000-00-00 00:00:00')->get();
if ($query5) {
foreach ($query5 as $row5) {
$row5a = DB::table('rx_list')->where('rxl_id', '=', $row5->rxl_id)->first();
if ($row5->rxl_sig == '') {
$instructions5 = $row5->rxl_instructions;
} else {
$instructions5 = $row5->rxl_sig . ' ' . $row5->rxl_route . ' ' . $row5->rxl_frequency;
}
$description5 = $row5->rxl_medication . ' ' . $row5->rxl_dosage . ' ' . $row5->rxl_dosage_unit . ', ' . $instructions5 . ' for ' . $row5->rxl_reason;
$json[] = array('title' => "<span class='timeline_event' value='" . $row5->rxl_id . "' type='rxl_id'>Medication Stopped</span>", 'description' => $description5, 'startDate' => $this->human_to_unix($row5->rxl_date_inactive));
$date_arr[] = $this->human_to_unix($row5->rxl_date_inactive);
}
}
$query6 = DB::table('allergies')->where('pid', '=', $pid)->where('allergies_date_inactive', '=', '0000-00-00 00:00:00')->get();
if ($query6) {
foreach ($query6 as $row6) {
$json[] = array('title' => "<span class='timeline_event' value='" . $row6->allergies_id . "' type='allergies_id'>New Allergy</span>", 'description' => $row6->allergies_med, 'startDate' => $this->human_to_unix($row6->allergies_date_active));
$date_arr[] = $this->human_to_unix($row6->allergies_date_active);
}
}
foreach ($json as $key => $value) {
$item[$key] = $value['startDate'];
}
array_multisort($item, SORT_ASC, $json);
asort($date_arr);
$arr['start'] = reset($date_arr);
$arr['end'] = end($date_arr);
if ($arr['end'] - $arr['start'] >= 315569260) {
$arr['granular'] = 'decade';
}
if ($arr['end'] - $arr['start'] > 31556926 && $arr['end'] - $arr['start'] < 315569260) {
$arr['granular'] = 'year';
}
if ($arr['end'] - $arr['start'] <= 31556926) {
$arr['granular'] = 'month';
}
$arr['json'] = $json;
echo json_encode($arr);
}
public function postCompileBilling()
{
$eid = Session::get('eid');
$pid = Session::get('pid');
$practice_id = Session::get('practice_id');
$row = Demographics::find($pid);
$encounterInfo = Encounters::find($eid);
$dos1 = $this->human_to_unix($encounterInfo->encounter_DOS);
$dos = date('mdY', $dos1);
$dos2 = date('m/d/Y', $dos1);
$pos = $encounterInfo->encounter_location;
$assessment_data = Assessment::find($eid);
$icd_pointer = '';
if ($assessment_data->assessment_1 != '') {
$icd_pointer .= "A";
}
if ($assessment_data->assessment_2 != '') {
$icd_pointer .= "B";
}
if ($assessment_data->assessment_3 != '') {
$icd_pointer .= "C";
}
if ($assessment_data->assessment_4 != '') {
$icd_pointer .= "D";
}
$labsInfo = Labs::find($eid);
if ($labsInfo) {
if ($labsInfo->labs_ua_urobili != '' || $labsInfo->labs_ua_bilirubin != '' || $labsInfo->labs_ua_ketones != '' || $labsInfo->labs_ua_glucose != '' || $labsInfo->labs_ua_protein != '' || $labsInfo->labs_ua_nitrites != '' || $labsInfo->labs_ua_leukocytes != '' || $labsInfo->labs_ua_blood != '' || $labsInfo->labs_ua_ph != '' || $labsInfo->labs_ua_spgr != '' || $labsInfo->labs_ua_color != '' || $labsInfo->labs_ua_clarity != '') {
$this->compile_procedure_billing('81002', $eid, $pid, $dos2, $icd_pointer, $practice_id);
}
if ($labsInfo->labs_upt != '') {
$this->compile_procedure_billing('81025', $eid, $pid, $dos2, $icd_pointer, $practice_id);
}
if ($labsInfo->labs_strep != '') {
$this->compile_procedure_billing('87880', $eid, $pid, $dos2, $icd_pointer, $practice_id);
}
if ($labsInfo->labs_mono != '') {
$this->compile_procedure_billing('86308', $eid, $pid, $dos2, $icd_pointer, $practice_id);
}
if ($labsInfo->labs_flu != '') {
$this->compile_procedure_billing('87804', $eid, $pid, $dos2, $icd_pointer, $practice_id);
}
if ($labsInfo->labs_glucose != '') {
$this->compile_procedure_billing('82962', $eid, $pid, $dos2, $icd_pointer, $practice_id);
}
}
$result9 = Procedure::find($eid);
if ($result9) {
$this->compile_procedure_billing($result9->proc_cpt, $eid, $pid, $dos2, $icd_pointer, $practice_id);
}
$result11 = Immunizations::where('eid', '=', $eid)->get();
if ($result11) {
foreach ($result11 as $row11) {
$this->compile_procedure_billing($row11->cpt, $eid, $pid, $dos2, $icd_pointer, $practice_id);
}
}
echo 'CPT codes complied from the encounter!';
}
public function postGetBilling($eid = '')
{
if ($eid == '') {
$eid = Session::get('eid');
}
$data = Assessment::find($eid);
if ($data) {
$data1['message'] = "OK";
if ($data->assessment_1 != '') {
$data1['A'] = "A - " . $data->assessment_1;
} else {
$data1['message'] = "No diagnoses available.";
}
if ($data->assessment_2 != '') {
$data1['B'] = "B - " . $data->assessment_2;
}
if ($data->assessment_3 != '') {
$data1['C'] = "C - " . $data->assessment_3;
}
if ($data->assessment_4 != '') {
$data1['D'] = "D - " . $data->assessment_4;
}
if ($data->assessment_5 != '') {
$data1['E'] = "E - " . $data->assessment_5;
}
if ($data->assessment_6 != '') {
$data1['F'] = "F - " . $data->assessment_6;
}
if ($data->assessment_7 != '') {
$data1['G'] = "G - " . $data->assessment_7;
}
if ($data->assessment_8 != '') {
$data1['H'] = "H - " . $data->assessment_8;
}
if ($data->assessment_9 != '') {
$data1['I'] = "I - " . $data->assessment_9;
}
if ($data->assessment_10 != '') {
$data1['J'] = "J - " . $data->assessment_10;
}
if ($data->assessment_11 != '') {
$data1['K'] = "K - " . $data->assessment_11;
}
if ($data->assessment_12 != '') {
$data1['L'] = "L - " . $data->assessment_12;
}
} else {
$data1['message'] = "No diagnoses available.";
}
echo json_encode($data1);
}
protected function timeline_new()
{
$pid = Session::get('pid');
$json = array();
$date_arr = array();
$query0 = DB::table('encounters')->where('pid', '=', $pid)->where('addendum', '=', 'n')->get();
if ($query0) {
foreach ($query0 as $row0) {
$description = '';
$procedureInfo = Procedure::find($row0->eid);
if ($procedureInfo) {
$description .= '<span class="nosh_bold">Procedures:</span>';
if ($procedureInfo->proc_type != '') {
$description .= '<strong>Procedure: </strong>';
$description .= nl2br($procedureInfo->proc_type);
}
}
$assessmentInfo = Assessment::find($row0->eid);
if ($assessmentInfo) {
if ($assessmentInfo->assessment_1 != '') {
$description .= '<span class="nosh_bold">Assessment:</span>';
$description .= '<br><strong>' . $assessmentInfo->assessment_1 . '</strong><br />';
if ($assessmentInfo->assessment_2 == '') {
$description .= '<br />';
}
}
if ($assessmentInfo->assessment_2 != '') {
$description .= '<strong>' . $assessmentInfo->assessment_2 . '</strong><br />';
if ($assessmentInfo->assessment_3 == '') {
$description .= '<br />';
}
}
if ($assessmentInfo->assessment_3 != '') {
$description .= '<strong>' . $assessmentInfo->assessment_3 . '</strong><br />';
if ($assessmentInfo->assessment_4 == '') {
$description .= '<br />';
}
}
if ($assessmentInfo->assessment_4 != '') {
$description .= '<strong>' . $assessmentInfo->assessment_4 . '</strong><br />';
if ($assessmentInfo->assessment_5 == '') {
$description .= '<br />';
}
}
if ($assessmentInfo->assessment_5 != '') {
$description .= '<strong>' . $assessmentInfo->assessment_5 . '</strong><br />';
if ($assessmentInfo->assessment_6 == '') {
$description .= '<br />';
}
}
if ($assessmentInfo->assessment_6 != '') {
$description .= '<strong>' . $assessmentInfo->assessment_6 . '</strong><br />';
if ($assessmentInfo->assessment_7 == '') {
$description .= '<br />';
}
}
if ($assessmentInfo->assessment_7 != '') {
$description .= '<strong>' . $assessmentInfo->assessment_7 . '</strong><br />';
if ($assessmentInfo->assessment_8 == '') {
$description .= '<br />';
}
}
if ($assessmentInfo->assessment_8 != '') {
$description .= '<strong>' . $assessmentInfo->assessment_8 . '</strong><br /><br />';
}
if ($assessmentInfo->assessment_other != '') {
if ($row0->encounter_template == 'standardmtm') {
$description .= '<br /><strong>SOAP Note: </strong>';
} else {
$description .= '<br /><strong>Additional Diagnoses: </strong>';
}
$description .= nl2br($assessmentInfo->assessment_other);
$description .= '<br /><br />';
}
if ($assessmentInfo->assessment_ddx != '') {
if ($row0->encounter_template == 'standardmtm') {
$description .= '<br /><strong>MAP2: </strong>';
} else {
$description .= '<br /><strong>Differential Diagnoses Considered: </strong>';
}
$description .= nl2br($assessmentInfo->assessment_ddx);
$description .= '<br /><br />';
}
if ($assessmentInfo->assessment_notes != '') {
if ($row0->encounter_template == 'standardmtm') {
$description .= '<br /><strong>Pharmacist Note: </strong>';
} else {
$description .= '<br /><strong>Assessment Discussion: </strong>';
}
$description .= nl2br($assessmentInfo->assessment_notes);
$description .= '<br /><br />';
}
}
$div0 = $this->timeline_item($row0->eid, 'eid', 'Encounter', $this->human_to_unix($row0->encounter_DOS), 'Encounter: ' . $row0->encounter_cc, $description, $row0->encounter_signed);
$json[] = array('div' => $div0, 'startDate' => $this->human_to_unix($row0->encounter_DOS));
$date_arr[] = $this->human_to_unix($row0->encounter_DOS);
}
}
$query1 = DB::table('t_messages')->where('pid', '=', $pid)->get();
if ($query1) {
foreach ($query1 as $row1) {
$div1 = $this->timeline_item($row1->t_messages_id, 't_messages_id', 'Telephone Message', $this->human_to_unix($row1->t_messages_dos), 'Telephone Message', substr($row1->t_messages_message, 0, 500) . '...', $row1->t_messages_signed);
$json[] = array('div' => $div1, 'startDate' => $this->human_to_unix($row1->t_messages_dos));
$date_arr[] = $this->human_to_unix($row1->t_messages_dos);
}
}
$query2 = DB::table('rx_list')->where('pid', '=', $pid)->orderBy('rxl_date_active', 'asc')->groupBy('rxl_medication')->get();
if ($query2) {
foreach ($query2 as $row2) {
$row2a = DB::table('rx_list')->where('rxl_id', '=', $row2->rxl_id)->first();
if ($row2->rxl_sig == '') {
$instructions = $row2->rxl_instructions;
} else {
$instructions = $row2->rxl_sig . ' ' . $row2->rxl_route . ' ' . $row2->rxl_frequency;
}
$description2 = $row2->rxl_medication . ' ' . $row2->rxl_dosage . ' ' . $row2->rxl_dosage_unit . ', ' . $instructions . ' for ' . $row2->rxl_reason;
$div2 = $this->timeline_item($row2->rxl_id, 'rxl_id', 'New Medication', $this->human_to_unix($row2->rxl_date_active), 'New Medication', $description2);
$json[] = array('div' => $div2, 'startDate' => $this->human_to_unix($row2->rxl_date_active));
$date_arr[] = $this->human_to_unix($row2->rxl_date_active);
}
}
$query3 = DB::table('issues')->where('pid', '=', $pid)->get();
if ($query3) {
foreach ($query3 as $row3) {
if ($row3->type == 'Problem List') {
$title = 'New Problem';
}
if ($row3->type == 'Medical History') {
$title = 'New Medical Event';
}
if ($row3->type == 'Problem List') {
$title = 'New Surgical Event';
}
$div3 = $this->timeline_item($row3->issue_id, 'issue_id', $title, $this->human_to_unix($row3->issue_date_active), $title, $row3->issue);
$json[] = array('div' => $div3, 'startDate' => $this->human_to_unix($row3->issue_date_active));
$date_arr[] = $this->human_to_unix($row3->issue_date_active);
}
}
$query4 = DB::table('immunizations')->where('pid', '=', $pid)->get();
if ($query4) {
foreach ($query4 as $row4) {
$div4 = $this->timeline_item($row4->imm_id, 'imm_id', 'Immunization Given', $this->human_to_unix($row4->imm_date), 'Immunization Given', $row4->imm_immunization);
$json[] = array('div' => $div4, 'startDate' => $this->human_to_unix($row4->imm_date));
$date_arr[] = $this->human_to_unix($row4->imm_date);
}
}
$query5 = DB::table('rx_list')->where('pid', '=', $pid)->where('rxl_date_inactive', '!=', '0000-00-00 00:00:00')->get();
if ($query5) {
foreach ($query5 as $row5) {
$row5a = DB::table('rx_list')->where('rxl_id', '=', $row5->rxl_id)->first();
if ($row5->rxl_sig == '') {
$instructions5 = $row5->rxl_instructions;
} else {
$instructions5 = $row5->rxl_sig . ' ' . $row5->rxl_route . ' ' . $row5->rxl_frequency;
}
$description5 = $row5->rxl_medication . ' ' . $row5->rxl_dosage . ' ' . $row5->rxl_dosage_unit . ', ' . $instructions5 . ' for ' . $row5->rxl_reason;
$div5 = $this->timeline_item($row5->rxl_id, 'rxl_id', 'Medication Stopped', $this->human_to_unix($row5->rxl_date_inactive), 'Medication Stopped', $description5);
$json[] = array('div' => $div5, 'startDate' => $this->human_to_unix($row5->rxl_date_inactive));
$date_arr[] = $this->human_to_unix($row5->rxl_date_inactive);
}
}
$query6 = DB::table('allergies')->where('pid', '=', $pid)->where('allergies_date_inactive', '=', '0000-00-00 00:00:00')->get();
if ($query6) {
foreach ($query6 as $row6) {
$div6 = $this->timeline_item($row6->allergies_id, 'allergies_id', 'New Allergy', $this->human_to_unix($row6->allergies_date_active), 'New Allergy', $row6->allergies_med);
$json[] = array('div' => $div6, 'startDate' => $this->human_to_unix($row6->allergies_date_active));
$date_arr[] = $this->human_to_unix($row6->allergies_date_active);
}
}
foreach ($json as $key => $value) {
$item[$key] = $value['startDate'];
}
array_multisort($item, SORT_DESC, $json);
asort($date_arr);
$arr['start'] = reset($date_arr);
$arr['end'] = end($date_arr);
if ($arr['end'] - $arr['start'] >= 315569260) {
$arr['granular'] = 'decade';
}
if ($arr['end'] - $arr['start'] > 31556926 && $arr['end'] - $arr['start'] < 315569260) {
$arr['granular'] = 'year';
}
if ($arr['end'] - $arr['start'] <= 31556926) {
$arr['granular'] = 'month';
}
$arr['json'] = $json;
return $arr;
}
protected function page_invoice1($eid)
{
$pid = Session::get('pid');
$assessmentInfo = Assessment::find($eid);
if ($assessmentInfo) {
$data['assessment'] = '';
if ($assessmentInfo->assessment_1 != '') {
$data['assessment'] .= $assessmentInfo->assessment_1 . '<br />';
if ($assessmentInfo->assessment_2 == '') {
$data['assessment'] .= '<br />';
}
}
if ($assessmentInfo->assessment_2 != '') {
$data['assessment'] .= $assessmentInfo->assessment_2 . '<br />';
if ($assessmentInfo->assessment_3 == '') {
$data['assessment'] .= '<br />';
}
}
if ($assessmentInfo->assessment_3 != '') {
$data['assessment'] .= $assessmentInfo->assessment_3 . '<br />';
if ($assessmentInfo->assessment_4 == '') {
$data['assessment'] .= '<br />';
}
}
if ($assessmentInfo->assessment_4 != '') {
$data['assessment'] .= $assessmentInfo->assessment_4 . '<br />';
if ($assessmentInfo->assessment_5 == '') {
$data['assessment'] .= '<br />';
}
}
if ($assessmentInfo->assessment_5 != '') {
$data['assessment'] .= $assessmentInfo->assessment_5 . '<br />';
if ($assessmentInfo->assessment_6 == '') {
$data['assessment'] .= '<br />';
}
}
if ($assessmentInfo->assessment_6 != '') {
$data['assessment'] .= $assessmentInfo->assessment_6 . '<br />';
if ($assessmentInfo->assessment_7 == '') {
$data['assessment'] .= '<br />';
}
}
if ($assessmentInfo->assessment_7 != '') {
$data['assessment'] .= $assessmentInfo->assessment_7 . '<br />';
if ($assessmentInfo->assessment_8 == '') {
$data['assessment'] .= '<br />';
}
}
if ($assessmentInfo->assessment_8 != '') {
$data['assessment'] .= $assessmentInfo->assessment_8 . '<br /><br />';
}
} else {
$data['assessment'] = '';
}
$result1 = DB::table('billing_core')->where('eid', '=', $eid)->orderBy('cpt_charge', 'desc')->get();
if ($result1) {
$charge = 0;
$payment = 0;
$data['text'] = '<table class="pure-table"><tr><th style="width:14%">PROCEDURE</th><th style="width:14%">UNITS</th><th style="width:50%">DESCRIPTION</th><th style="width:22%">CHARGE PER UNIT</th></tr>';
foreach ($result1 as $key1 => $value1) {
$cpt_charge1[$key1] = $value1->cpt_charge;
}
array_multisort($cpt_charge1, SORT_DESC, $result1);
foreach ($result1 as $result1a) {
if ($result1a->cpt) {
$query2 = DB::table('cpt_relate')->where('cpt', '=', $result1a->cpt)->first();
if ($query2) {
$result2 = DB::table('cpt_relate')->where('cpt', '=', $result1a->cpt)->first();
} else {
$result2 = DB::table('cpt')->where('cpt', '=', $result1a->cpt)->first();
}
$data['text'] .= '<tr><td>' . $result1a->cpt . '</td><td>' . $result1a->unit . '</td><td>' . $result2->cpt_description . '</td><td>$' . $result1a->cpt_charge . '</td></tr>';
$charge += $result1a->cpt_charge * $result1a->unit;
} else {
$data['text'] .= '<tr><td>Date of Payment:</td><td>' . $result1a->dos_f . '</td><td>' . $result1a->payment_type . '</td><td">$(' . $result1a->payment . ')</td></tr>';
$payment = $payment + $result1a->payment;
}
}
$balance = $charge - $payment;
$charge = number_format($charge, 2, '.', ',');
$payment = number_format($payment, 2, '.', ',');
$balance = number_format($balance, 2, '.', ',');
$data['text'] .= '<tr><td></td><td></td><td><strong>Total Charges:</strong></td><td><strong>$' . $charge . '</strong></td></tr><tr><td></td><td></td><td><strong>Total Payments:</strong></td><td><strong>$' . $payment . '</strong></td></tr><tr><td></td><td></td><td></td><td><hr/></td></tr><tr><td></td><td></td><td><strong>Remaining Balance:</strong></td><td><strong>$' . $balance . '</strong></td></tr></table>';
} else {
$data['text'] = 'No procedures.';
}
$row = Demographics::find($pid);
$practice = Practiceinfo::find(Session::get('practice_id'));
$data['practiceName'] = $practice->practice_name;
$data['practiceInfo1'] = $practice->street_address1;
if ($practice->street_address2 != '') {
$data['practiceInfo1'] .= ', ' . $practice->street_address2;
}
$data['practiceInfo2'] = $practice->city . ', ' . $practice->state . ' ' . $practice->zip;
$data['practiceInfo3'] = 'Phone: ' . $practice->phone . ', Fax: ' . $practice->fax;
$data['disclaimer'] = '<br>Please send a check payable to ' . $practice->practice_name . ' and mail it to:';
$data['disclaimer'] .= '<br>' . $practice->billing_street_address1;
if ($practice->billing_street_address2 != '') {
$data['text'] .= ', ' . $practice->billing_street_address2;
}
$data['disclaimer'] .= '<br>' . $practice->billing_city . ', ' . $practice->billing_state . ' ' . $practice->billing_zip;
$data['patientInfo1'] = $row->firstname . ' ' . $row->lastname;
$data['patientInfo2'] = $row->address;
$data['patientInfo3'] = $row->city . ', ' . $row->state . ' ' . $row->zip;
$data['patientInfo'] = $row;
$data['dob'] = date('m/d/Y', $this->human_to_unix($row->DOB));
$encounterInfo = Encounters::find($eid);
$data['encounter_DOS'] = date('F jS, Y', $this->human_to_unix($encounterInfo->encounter_DOS));
$data['encounter_provider'] = $encounterInfo->encounter_provider;
$query1 = DB::table('insurance')->where('pid', '=', $pid)->where('insurance_plan_active', '=', 'Yes')->get();
$data['insuranceInfo'] = '';
if ($query1) {
foreach ($query1 as $row1) {
$data['insuranceInfo'] .= $row1->insurance_plan_name . '; ID: ' . $row1->insurance_id_num . '; Group: ' . $row1->insurance_group . '; ' . $row1->insurance_insu_lastname . ', ' . $row1->insurance_insu_firstname . '<br><br>';
}
}
$data['title'] = "INVOICE";
$data['date'] = date('F jS, Y', time());
$result = DB::table('demographics_notes')->where('pid', '=', Session::get('pid'))->where('practice_id', '=', Session::get('practice_id'))->first();
if (is_null($result->billing_notes) || $result->billing_notes == '') {
$billing_notes = 'Invoice for encounter (Date of Service: ' . $data['encounter_DOS'] . ') printed on ' . $data['date'] . '.';
} else {
$billing_notes = $result->billing_notes . "\n" . 'Invoice for encounter (Date of Service: ' . $data['encounter_DOS'] . ') printed on ' . $data['date'] . '.';
}
$billing_notes_data = array('billing_notes' => $billing_notes);
DB::table('demographics_notes')->where('pid', '=', Session::get('pid'))->where('practice_id', '=', Session::get('practice_id'))->update($billing_notes_data);
$this->audit('Update');
return View::make('pdf.invoice_page', $data);
}
