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); }