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 postImmunizationsList()
{
$query = Immunizations::where('pid', '=', Session::get('pid'))->orderBy('imm_immunization', 'asc')->orderBy('imm_sequence', 'asc')->get();
$result = '';
if ($query) {
$result .= '<ul>';
foreach ($query as $row) {
$sequence = '';
if ($row->imm_sequence == '1') {
$sequence = ', first';
}
if ($row->imm_sequence == '2') {
$sequence = ', second';
}
if ($row->imm_sequence == '3') {
$sequence = ', third';
}
if ($row->imm_sequence == '4') {
$sequence = ', fourth';
}
if ($row->imm_sequence == '5') {
$sequence = ', fifth';
}
$result .= '<li>' . $row->imm_immunization . $sequence . '</li>';
}
$result .= '</ul>';
} else {
$result .= ' None.';
}
echo $result;
}
protected function page_ccr($pid)
{
$data['patientInfo'] = Demographics::find($pid);
$data['dob'] = date('m/d/Y', $this->human_to_unix($data['patientInfo']->DOB));
$data['insuranceInfo'] = '';
$query_in = Insurance::where('pid', '=', $pid)->where('insurance_plan_active', '=', 'Yes')->get();
if ($query_in) {
foreach ($query_in as $row_in) {
$data['insuranceInfo'] .= $row_in->insurance_plan_name . '; ID: ' . $row_in->insurance_id_num . '; Group: ' . $row_in->insurance_group . '; ' . $row_in->insurance_insu_lastname . ', ' . $row_in->insurance_insu_firstname . '<br><br>';
}
}
$body = 'Active Issues:<br />';
$query = Issues::where('pid', '=', $pid)->where('issue_date_inactive', '=', '0000-00-00 00:00:00')->get();
if ($query) {
$body .= '<ul>';
foreach ($query as $row) {
$body .= '<li>' . $row->issue . '</li>';
}
$body .= '</ul>';
} else {
$body .= 'None.';
}
$body .= '<hr />Active Medications:<br />';
$query1 = Rx_list::where('pid', '=', $pid)->where('rxl_date_inactive', '=', '0000-00-00 00:00:00')->where('rxl_date_old', '=', '0000-00-00 00:00:00')->get();
if ($query1) {
$body .= '<ul>';
foreach ($query1 as $row1) {
if ($row1->rxl_sig == '') {
$body .= '<li>' . $row1->rxl_medication . ' ' . $row1->rxl_dosage . ' ' . $row1->rxl_dosage_unit . ', ' . $row1->rxl_instructions . ' for ' . $row1->rxl_reason . '</li>';
} else {
$body .= '<li>' . $row1->rxl_medication . ' ' . $row1->rxl_dosage . ' ' . $row1->rxl_dosage_unit . ', ' . $row1->rxl_sig . ' ' . $row1->rxl_route . ' ' . $row1->rxl_frequency . ' for ' . $row1->rxl_reason . '</li>';
}
}
$body .= '</ul>';
} else {
$body .= 'None.';
}
$body .= '<hr />Immunizations:<br />';
$query2 = Immunizations::where('pid', '=', $pid)->orderBy('imm_immunization', 'asc')->orderBy('imm_sequence', 'asc')->get();
if ($query2) {
$body .= '<ul>';
foreach ($query2 as $row2) {
$sequence = '';
if ($row2->imm_sequence == '1') {
$sequence = ', first,';
}
if ($row2->imm_sequence == '2') {
$sequence = ', second,';
}
if ($row2->imm_sequence == '3') {
$sequence = ', third,';
}
if ($row2->imm_sequence == '4') {
$sequence = ', fourth,';
}
if ($row2->imm_sequence == '5') {
$sequence = ', fifth,';
}
$body .= '<li>' . $row2->imm_immunization . $sequence . ' given on ' . date('F jS, Y', $this->human_to_unix($row2->imm_date)) . '</li>';
}
$body .= '</ul>';
} else {
$body .= 'None.';
}
$body .= '<hr />Allergies:<br />';
$query3 = Allergies::where('pid', '=', $pid)->where('allergies_date_inactive', '=', '0000-00-00 00:00:00')->get();
if ($query3) {
$body .= '<ul>';
foreach ($query3 as $row3) {
$body .= '<li>' . $row3->allergies_med . ' - ' . $row3->allergies_reaction . '</li>';
}
$body .= '</ul>';
} else {
$body .= 'No known allergies.';
}
$body .= '<br />Printed by ' . Session::get('displayname') . '.';
$data['letter'] = $body;
return View::make('pdf.ccr_page', $data);
}
public function postImmunizationsList($mobile = false)
{
$query = Immunizations::where('pid', '=', Session::get('pid'))->orderBy('imm_immunization', 'asc')->orderBy('imm_sequence', 'asc')->get();
$result = '';
if ($query) {
if ($mobile == false) {
$result .= '<ul>';
foreach ($query as $row) {
$sequence = '';
if ($row->imm_sequence == '1') {
$sequence = ', first';
}
if ($row->imm_sequence == '2') {
$sequence = ', second';
}
if ($row->imm_sequence == '3') {
$sequence = ', third';
}
if ($row->imm_sequence == '4') {
$sequence = ', fourth';
}
if ($row->imm_sequence == '5') {
$sequence = ', fifth';
}
$result .= '<li>' . $row->imm_immunization . $sequence . '</li>';
}
$result .= '</ul>';
} else {
$list_array = [];
$form = [];
$i = 1;
$columns = Schema::getColumnListing('immunizations');
$row_index = $columns[0];
$list_array[] = ['label' => 'Add Immunization', 'pid' => Session::get('pid'), 'href' => action('AjaxChartController@postMobileEditPage', array('immunizations', $row_index, '0')), 'origin' => '../ajaxchart/immunizations-list/true'];
foreach ($query as $row) {
$sequence = '';
if ($row->imm_sequence == '1') {
$sequence = ', first';
}
if ($row->imm_sequence == '2') {
$sequence = ', second';
}
if ($row->imm_sequence == '3') {
$sequence = ', third';
}
if ($row->imm_sequence == '4') {
$sequence = ', fourth';
}
if ($row->imm_sequence == '5') {
$sequence = ', fifth';
}
$label = $row->imm_immunization . $sequence;
$list_array[] = ['label' => $label, 'pid' => Session::get('pid'), 'href' => action('AjaxChartController@postMobileEditPage', array('immunizations', $row_index, $row->{$row_index})), 'origin' => '../ajaxchart/immunizations-list/true'];
}
$result .= $this->mobile_result_build($list_array, 'mobile_immunizations_list');
}
} else {
$result .= ' None.';
}
echo $result;
}
