public function rcopia_sync($practice_id) { // Update Notification $row0 = Practiceinfo::find($practice_id); Config::set('app.timezone', $row0->timezone); if ($row0->rcopia_update_notification_lastupdate == "") { $date0 = date('m/d/Y H:i:s', time()); } else { $date0 = $row0->rcopia_update_notification_lastupdate; } $xml0 = "<Request><Command>update_notification</Command>"; $xml0 .= "<LastUpdateDate>" . $date0 . "</LastUpdateDate>"; $xml0 .= "</Request></RCExtRequest>"; $result0 = $this->rcopia($xml0, $practice_id); $response0 = new SimpleXMLElement($result0); if ($response0->Response->Status == "error") { $description0 = $response0->Response->Error->Text . ""; $data0a = array('action' => 'update_notification', 'pid' => '0', 'extensions_name' => 'rcopia', 'description' => $description0, 'practice_id' => $practice_id); DB::table('extensions_log')->insert($data0a); } else { $last_update_date = $response0->Response->LastUpdateDate . ""; $number = $response0->Response->NotificationList->Number . ""; if ($number != "0") { foreach ($response0->Response->NotificationList->Notification as $notification) { $type = $notification->Type . ""; $status = $notification->Status . ""; $rcopia_username = $notification->Provider->Username . ""; $medication_message = $notification->Sig->Drug->BrandName . ""; $form_message = $notification->Sig->Drug->Form . ""; $dose_message = $notification->Sig->Drug->Strength . ""; $sig_message = $notification->Sig->Dose . ""; $sig1_message = $notification->Sig->DoseUnit . ""; $route_message = $notification->Sig->Route . ""; $frequency_message = $notification->Sig->DoseTiming . ""; $instructions_message = $notification->Sig->DoseOther . ""; $quantity_message = $notification->Sig->Quantity . ""; $quantity_message1 = $notification->Sig->QuantityUnit . ""; $refill_message = $notification->Sig->Refills . ""; $pharmacy_message = $notification->Pharmacy->Name . ""; $medication_message = "Medication: " . $medication_message . ", " . $form_message . ", " . $dose_message; $medication_message .= "\nInstructions: " . $sig_message . " " . $sig1_message . " " . $route_message . ", " . $frequency_message; $medication_message .= "\nOther Instructions: " . $instructions_message; $medication_message .= "\nQuantity: " . $quantity_message . " " . $quantity_message1; $medication_message .= "\nRefills: " . $refill_message; $medication_message .= "\nPharmacy: " . $pharmacy_message; $messages_pid = $notification->Patient->ExternalID . ""; $sender = $notification->Sender . ""; $title = $notification->Title . ""; $text = $notification->Text . ""; $full_text = "From: " . $sender . "\nMessage: " . $text; $patient_row = Demographics::where('pid', '=', $messages_pid)->first(); $dob_message = date("m/d/Y", strtotime($patient_row->DOB)); $patient_name = $patient_row->lastname . ', ' . $patient_row->firstname . ' (DOB: ' . $dob_message . ') (ID: ' . $messages_pid . ')'; $provider_row = DB::table('users')->join('providers', 'providers.id', '=', 'users.id')->select('users.lastname', 'users.firstname', 'users.title', 'users.id')->where('providers.rcopia_username', '=', $rcopia_username)->first(); if ($provider_row) { $provider_name = $provider_row->firstname . " " . $provider_row->lastname . ", " . $provider_row->title . " (" . $provider_row->id . ")"; if ($type == "refill") { $subject = "Refill Request for " . $patient_name; $body = $medication_message; } if ($type == "message") { $subject = $title; $body = $full_text; } $data_message = array('pid' => $messages_pid, 'message_to' => $provider_name, 'message_from' => $provider_row->id, 'subject' => $subject, 'body' => $body, 'patient_name' => $patient_name, 'status' => 'Sent', 'mailbox' => $provider_row->id, 'practice_id' => $practice_id); DB::table('messaging')->insert($data_message); $this->audit('Add'); } } } $data_update = array('rcopia_update_notification_lastupdate' => $last_update_date); DB::table('practiceinfo')->where('practice_id', '=', $practice_id)->update($data_update); } // Send Patient $query1 = Demographics::where('rcopia_sync', '=', 'n')->get(); if ($query1) { foreach ($query1 as $row1) { if ($this->check_practice_id($row1->pid, $practice_id)) { $dob = explode(" ", $row1->DOB); $dob1 = explode("-", $dob[0]); $dob_final = $dob1[1] . "/" . $dob1[2] . "/" . $dob1[0]; $xml1 = "<Request><Command>send_patient</Command><Synchronous>y</Synchronous><CheckEligibility>y</CheckEligibility>"; $xml1 .= "<PatientList><Patient>"; $xml1 .= "<FirstName>" . $row1->firstname . "</FirstName>"; $xml1 .= "<LastName>" . $row1->lastname . "</LastName>"; $xml1 .= "<MiddleName>" . $row1->middle . "</MiddleName>"; $xml1 .= "<DOB>" . $dob_final . "</DOB>"; $xml1 .= "<Sex>" . $row1->sex . "</Sex>"; $xml1 .= "<ExternalID>" . $row1->pid . "</ExternalID>"; $xml1 .= "<HomePhone>" . $row1->phone_home . "</HomePhone>"; $xml1 .= "<WorkPhone>" . $row1->phone_work . "</WorkPhone>"; $xml1 .= "<Address1>" . $row1->address . "</Address1>"; $xml1 .= "<Address2></Address2>"; $xml1 .= "<City>" . $row1->city . "</City>"; $xml1 .= "<State>" . $row1->state . "</State>"; $xml1 .= "<Zip>" . $row1->zip . "</Zip>"; $xml1 .= "</Patient></PatientList></Request></RCExtRequest>"; $result1 = $this->rcopia($xml1, $practice_id); $response1 = new SimpleXMLElement($result1); $status1 = $response1->Response->PatientList->Patient->Status . ""; if ($status1 == "error") { $description1 = $response1->Response->PatientList->Patient->Error->Text . ""; $data1a = array('action' => 'send_patient', 'pid' => $row1->pid, 'extensions_name' => 'rcopia', 'description' => $description1, 'practice_id' => $practice_id); DB::table('extensions_log')->insert($data1a); } else { $data1b = array('rcopia_sync' => 'y'); DB::table('demographics')->where('pid', '=', $row1->pid)->update($data1b); $this->audit('Update'); } } } } // Send Allergy $query2 = Allergies::where('rcopia_sync', '=', 'n')->where('allergies_date_inactive', '=', '0000-00-00 00:00:00')->get(); if ($query2) { foreach ($query2 as $row2) { if ($this->check_practice_id($row2->pid, $practice_id)) { $da = explode(" ", $row2->allergies_date_active); $da1 = explode("-", $da[0]); $da_final = $da1[1] . "/" . $da1[2] . "/" . $da1[0]; $xml2 = "<Request><Command>send_allergy</Command><Synchronous>y</Synchronous>"; $xml2 .= "<AllergyList><Allergy>"; $xml2 .= "<ExternalID>" . $row2->allergies_id . "</ExternalID>"; $xml2 .= "<Patient><ExternalID>" . $row2->pid . "</ExternalID></Patient>"; $xml2 .= "<Allergen><Name>" . $row2->allergies_med . "</Name>"; $xml2 .= "<Drug><NDCID>" . $row2->meds_ndcid . "</NDCID></Drug></Allergen>"; $xml2 .= "<Reaction>" . $row2->allergies_reaction . "</Reaction>"; $xml2 .= "<OnsetDate>" . $da_final . "</OnsetDate>"; $xml2 .= "</Allergy></AllergyList></Request></RCExtRequest>"; $result2 = $this->rcopia($xml2, $practice_id); $response2 = new SimpleXMLElement($result2); $status2 = $response2->Response->AllergyList->Allergy->Status . ""; if ($status2 == "error") { $description2 = $response2->Response->AllergyList->Allergy->Error->Text . ""; $data2a = array('action' => 'send_allergy', 'pid' => $row2->pid, 'extensions_name' => 'rcopia', 'description' => $description2, 'practice_id' => $practice_id); DB::table('extensions_log')->insert($data2a); if ($description2 == "Can find neither name, Rcopia ID, or NDC ID for drug.") { $data2c = array('rcopia_sync' => 'ye'); DB::table('allergies')->where('allergies_id', '=', $row2->allergies_id)->update($data2c); $this->audit('Update'); } } else { $data2b = array('rcopia_sync' => 'y'); DB::table('allergies')->where('allergies_id', '=', $row2->allergies_id)->update($data2b); $this->audit('Update'); } } } } //Send Medication $query3 = Rx_list::where('rcopia_sync', '=', 'n')->where('rxl_date_inactive', '=', '0000-00-00 00:00:00')->where('rxl_date_old', '=', '0000-00-00 00:00:00')->get(); if ($query3) { foreach ($query3 as $row3) { if ($this->check_practice_id($row3->pid, $practice_id)) { $dm = explode(" ", $row3->rxl_date_active); $dm1 = explode("-", $dm[0]); $dm_final = $dm1[1] . "/" . $dm1[2] . "/" . $dm1[0]; if ($row3->rxl_due_date != '') { $dn = explode(" ", $row3->rxl_due_date); $dn1 = explode("-", $dn[0]); $dn_final = $dn1[1] . "/" . $dn1[2] . "/" . $dn1[0]; } else { $dn_final = ""; } if ($row3->rxl_ndcid != '') { $ndcid = $row3->rxl_ndcid; } else { $ndcid = ''; } $medication_parts1 = explode(", ", $row3->rxl_medication); $generic_name = $medication_parts1[0]; if (isset($medication_parts[1])) { $form = $medication_parts1[1]; } else { $form = ''; } $strength = $row3->rxl_dosage . " " . $row3->rxl_dosage_unit; if ($row3->rxl_sig != '') { if (strpos($row3->rxl_sig, ' ') !== false) { $sig_parts1 = explode(" ", $row3->rxl_sig); $dose = $sig_parts1[0]; $dose_unit = $sig_parts1[1]; } else { $dose = $row3->rxl_sig; $dose_unit = ''; } } else { $dose = ''; $dose_unit = ''; } if ($row3->rxl_quantity != '') { if (strpos($row3->rxl_quantity, ' ') !== false) { $quantity_parts1 = explode(" ", $row3->rxl_quantity); $quantity = $quantity_parts1[0]; $quantity_unit = $quantity_parts1[1]; } else { $quantity = $row3->rxl_quantity; $quantity_unit = ''; } } else { $quantity = ''; $quantity_unit = ''; } if ($row3->rxl_daw != '') { $daw = 'n'; } else { $daw = 'y'; } $xml3 = "<Request><Command>send_medication</Command><Synchronous>y</Synchronous>"; $xml3 .= "<MedicationList><Medication>"; $xml3 .= "<ExternalID>" . $row3->rxl_id . "</ExternalID>"; $xml3 .= "<Patient><ExternalID>" . $row3->pid . "</ExternalID></Patient>"; $xml3 .= "<Sig>"; $xml3 .= "<Drug><NDCID>" . $ndcid . "</NDCID>"; $xml3 .= "<GenericName>" . $generic_name . "</GenericName>"; $xml3 .= "<Form>" . $form . "</Form>"; $xml3 .= "<Strength>" . $strength . "</Strength></Drug>"; $xml3 .= "<Dose>" . $dose . "</Dose>"; $xml3 .= "<DoseUnit>" . $dose_unit . "</DoseUnit>"; $xml3 .= "<Route>" . $row3->rxl_route . "</Route>"; $xml3 .= "<DoseTiming>" . $row3->rxl_frequency . "</DoseTiming>"; $xml3 .= "<DoseOther>" . $row3->rxl_instructions . "</DoseOther>"; $xml3 .= "<Quantity>" . $quantity . "</Quantity>"; $xml3 .= "<QuantityUnit>" . $quantity_unit . "</QuantityUnit>"; $xml3 .= "<Refills>" . $row3->rxl_refill . "</Refills>"; $xml3 .= "<SubstitutionPermitted>" . $daw . "</SubstitutionPermitted>"; $xml3 .= "</Sig>"; $xml3 .= "<StartDate>" . $dm_final . "</StartDate>"; $xml3 .= "<StopDate>" . $dn_final . "</StopDate>"; $xml3 .= "</Medication></MedicationList></Request></RCExtRequest>"; $result3 = $this->rcopia($xml3, $practice_id); $response3 = new SimpleXMLElement($result3); $status3 = $response3->Response->MedicationList->Medication->Status . ""; if ($status3 == "error") { $description3 = $response3->Response->MedicationList->Medication->Error->Text . ""; $data3a = array('action' => 'send_medication', 'pid' => $row3->pid, 'extensions_name' => 'rcopia', 'description' => $description3, 'practice_id' => $practice_id); DB::table('extensions_log')->insert($data3a); } else { $data3b = array('rcopia_sync' => 'y'); DB::table('rx_list')->where('rxl_id', '=', $row3->rxl_id)->update($data3b); $this->audit('Update'); } } } } //Send Problem List $query4 = Issues::where('rcopia_sync', '=', 'n')->where('issue_date_inactive', '=', '0000-00-00 00:00:00')->get(); if ($query4) { foreach ($query4 as $row4) { if ($this->check_practice_id($row4->pid, $practice_id)) { $di = explode(" [", $row4->issue); $code = str_replace("]", "", $di[1]); $xml4 = "<Request><Command>send_problem</Command><Synchronous>y</Synchronous>"; $xml4 .= "<ProblemList><Problem>"; $xml4 .= "<ExternalID>" . $row4->issue_id . "</ExternalID>"; $xml4 .= "<Patient><ExternalID>" . $row4->pid . "</ExternalID></Patient>"; $xml4 .= "<Code>" . $code . "</Code>"; $xml4 .= "<Description>" . $di[0] . "</Description>"; $xml4 .= "</Problem></ProblemList></Request></RCExtRequest>"; $result4 = $this->rcopia($xml4, $practice_id); $response4 = new SimpleXMLElement($result4); $status4 = $response4->Response->ProblemList->Problem->Status . ""; if ($status4 == "error") { $description4 = $response4->Response->ProblemList->Problem->Error->Text . ""; $data4a = array('action' => 'send_problem', 'pid' => $row4->pid, 'extensions_name' => 'rcopia', 'description' => $description4, 'practice_id' => $practice_id); DB::table('extensions_log')->insert($data4a); } else { $data4b = array('rcopia_sync' => 'y'); DB::table('issues')->where('issue_id', '=', $row4->issue_id)->update($data4b); $this->audit('Update'); } } } } //Delete Allergy $query5 = Allergies::where('rcopia_sync', '=', 'nd')->orWhere('rcopia_sync', '=', 'nd1')->get(); if ($query5) { foreach ($query5 as $row5) { if ($this->check_practice_id($row5->pid, $practice_id)) { $dda = explode(" ", $row5->allergies_date_active); $daa1 = explode("-", $dda[0]); $dda_final = $dda1[1] . "/" . $dda1[2] . "/" . $dda1[0]; $xml5 = "<Request><Command>send_allergy</Command><Synchronous>y</Synchronous>"; $xml5 .= "<AllergyList><Allergy><Deleted>y</Deleted>"; $xml5 .= "<ExternalID>" . $row5->allergies_id . "</ExternalID>"; $xml5 .= "<Patient><ExternalID>" . $row5->pid . "</ExternalID></Patient>"; $xml5 .= "<Allergen><Name>" . $row5->allergies_med . "</Name>"; $xml5 .= "<Drug><NDCID>" . $row5->meds_ndcid . "</NDCID></Drug></Allergen>"; $xml5 .= "<Reaction>" . $row5->allergies_reaction . "</Reaction>"; $xml5 .= "<OnsetDate>" . $dda_final . "</OnsetDate>"; $xml5 .= "</Allergy></AllergyList></Request></RCExtRequest>"; $result5 = $this->rcopia($xml5, $practice_id); $response5 = new SimpleXMLElement($result5); $status5 = $response5->Response->AllergyList->Allergy->Status . ""; if ($status5 == "error") { $description5 = $response5->Response->AllergyList->Allergy->Error->Text . ""; $data5a = array('action' => 'delete_allergy', 'pid' => $row5->pid, 'extensions_name' => 'rcopia', 'description' => $description5, 'practice_id' => $practice_id); DB::table('extensions_log')->insert($data5a); $data5b = array('rcopia_sync' => 'y'); DB::table('allergies')->where('pid', $row5->pid)->update($data5b); $this->audit('Update'); } else { $data5b = array('rcopia_sync' => 'y'); DB::table('allergies')->where('allergies_id', $row5->allergies_id)->update($data5b); $this->audit('Update'); } } } } //Delete Medication $query6 = Rx_list::where('rcopia_sync', '=', 'nd')->orWhere('rcopia_sync', '=', 'nd1')->get(); if ($query6) { foreach ($query6 as $row6) { if ($this->check_practice_id($row6->pid, $practice_id)) { $ddm = explode(" ", $row6->rxl_date_active); $ddm1 = explode("-", $ddm[0]); $ddm_final = $ddm1[1] . "/" . $ddm1[2] . "/" . $ddm1[0]; if ($row3->rxl_due_date != '') { $ddn = explode(" ", $row6->rxl_due_date); $ddn1 = explode("-", $ddn[0]); $ddn_final = $ddn1[1] . "/" . $ddn1[2] . "/" . $ddn1[0]; } else { $ddn_final = ""; } if ($row6->rxl_ndcid != '') { $ndcid1 = $row6->rxl_ndcid; $generic_name1 = ''; $form1 = ''; $strength1 = ''; } else { $ndcid1 = ''; $medication_parts2 = explode(", ", $row6->rxl_medication); if (count($medication_parts2) > 1) { $generic_name1 = $medication_parts2[0]; $form1 = $medication_parts2[1]; } else { $generic_name1 = $medication_parts2[0]; $form1 = ''; } $strength1 = $row6->rxl_dosage . " " . $row6->rxl_dosage_unit; } $sig_parts2 = explode(" ", $row6->rxl_sig); if (count($sig_parts2) > 1) { $dose = $sig_parts2[0]; $doseunit = $sig_parts2[1]; } else { $dose = $sig_parts2[0]; $doseunit = ''; } if ($row6->rxl_quantity != '') { if (strpos($row6->rxl_quantity, ' ') !== false) { $quantity_parts2 = explode(" ", $row6->rxl_quantity); $quantity1 = $quantity_parts2[0]; $quantity_unit1 = $quantity_parts2[1]; } else { $quantity1 = $row6->rxl_quantity; $quantity_unit1 = ''; } } else { $quantity1 = ''; $quantity_unit1 = ''; } if ($row6->rxl_daw != '') { $daw1 = 'n'; } else { $daw1 = 'y'; } $xml6 = "<Request><Command>send_medication</Command><Synchronous>y</Synchronous>"; $xml6 .= "<MedicationList><Medication><Deleted>y</Deleted>"; $xml6 .= "<ExternalID>" . $row6->rxl_id . "</ExternalID>"; $xml6 .= "<Patient><ExternalID>" . $row6->pid . "</ExternalID></Patient>"; $xml6 .= "<Sig>"; $xml6 .= "<Drug><NDCID>" . $ndcid1 . "</NDCID>"; $xml6 .= "<GenericName>" . $generic_name1 . "</GenericName>"; $xml6 .= "<Form>" . $form1 . "</Form>"; $xml6 .= "<Strength>" . $strength1 . "</Strength></Drug>"; $xml6 .= "<Dose>" . $dose . "</Dose>"; $xml6 .= "<DoseUnit>" . $doseunit . "</DoseUnit>"; $xml6 .= "<Route>" . $row6->rxl_route . "</Route>"; $xml6 .= "<DoseTiming>" . $row6->rxl_frequency . "</DoseTiming>"; $xml6 .= "<DoseOther>" . $row6->rxl_instructions . "</DoseOther>"; $xml6 .= "<Quantity>" . $quantity1 . "</Quantity>"; $xml6 .= "<QuantityUnit>" . $quantity_unit1 . "</QuantityUnit>"; $xml6 .= "<Refills>" . $row6->rxl_refill . "</Refills>"; $xml6 .= "<SubstitutionPermitted>" . $daw1 . "</SubstitutionPermitted>"; $xml6 .= "</Sig>"; $xml6 .= "<StartDate>" . $ddm_final . "</StartDate>"; $xml6 .= "<StopDate>" . $ddn_final . "</StopDate>"; $xml6 .= "</Medication></MedicationList></Request></RCExtRequest>"; $result6 = $this->rcopia($xml6, $practice_id); $response6 = new SimpleXMLElement($result6); $status6 = $response6->Response->MedicationList->Medication->Status . ""; if ($status6 == "error") { $description6 = $response3->Response->MedicationList->Medication->Error->Text . ""; $data6a = array('action' => 'delete_medication', 'pid' => $row6->pid, 'extensions_name' => 'rcopia', 'description' => $description6, 'practice_id' => $practice_id); DB::table('extensions_log')->insert($data6a); $data6b = array('rcopia_sync' => 'y'); DB::table('rx_list')->where('pid', '=', $row6->pid)->update($data6b); $this->audit('Update'); } else { $data6b = array('rcopia_sync' => 'y'); DB::table('rx_list')->where('rxl_id', '=', $row6->rxl_id)->update($data6b); $this->audit('Update'); } } } } //Delete Problem List $query7 = Issues::where('rcopia_sync', '=', 'nd')->orWhere('rcopia_sync', '=', 'nd1')->get(); if ($query7) { foreach ($query7 as $row7) { if ($this->check_practice_id($row7->pid, $practice_id)) { $ddi = explode(" [", $row7->issue); $code1 = str_replace("]", "", $ddi[1]); $xml7 = "<Request><Command>send_problem</Command><Synchronous>y</Synchronous>"; $xml7 .= "<ProblemList><Problem><Deleted>y</Deleted>"; $xml7 .= "<ExternalID>" . $row7->issue_id . "</ExternalID>"; $xml7 .= "<Patient><ExternalID>" . $row7->pid . "</ExternalID></Patient>"; $xml7 .= "<Code>" . $code1 . "</Code>"; $xml7 .= "<Description>" . $ddi[0] . "</Description>"; $xml7 .= "</Problem></ProblemList></Request></RCExtRequest>"; $result7 = $this->rcopia($xml7, $practice_id); $response7 = new SimpleXMLElement($result7); $status7 = $response7->Response->ProblemList->Problem->Status . ""; if ($status7 == "error") { $description7 = $response7->Response->ProblemList->Problem->Error->Text . ""; $data7a = array('action' => 'delete_problem', 'pid' => $row7->pid, 'extensions_name' => 'rcopia', 'description' => $description7, 'practice_id' => $practice_id); DB::table('extensions_log')->insert($data7a); $data7b = array('rcopia_sync' => 'y'); DB::table('issues')->where('pid', '=', $row7->pid)->update($data7b); $this->audit('Update'); } else { $data7b = array('rcopia_sync' => 'y'); DB::table('issues')->where('issue_id', '=', $row7->issue_id)->update($data7b); $this->audit('Update'); } } } } }
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 postCopyIssues() { $query = Issues::where('pid', '=', Session::get('pid'))->where('issue_date_inactive', '=', '0000-00-00 00:00:00')->get(); if ($query) { $result = ''; foreach ($query as $row) { $result .= $row->issue . ', ' . date('Y-m-d', $this->human_to_unix($row->issue_date_active)) . ';'; } echo $result; } else { echo 'No'; } }
public function postIssuesList($mobile = false) { $query = Issues::where('pid', '=', Session::get('pid'))->where('issue_date_inactive', '=', '0000-00-00 00:00:00')->get(); $result = ''; if ($query) { if ($mobile == false) { $result .= '<ul>'; foreach ($query as $row) { $result .= '<li>' . $row->issue . '</li>'; } $result .= '</ul>'; } else { $list_array = []; $form = []; $i = 1; $columns = Schema::getColumnListing('issues'); $row_index = $columns[0]; $list_array[] = ['label' => 'Add Issue', 'pid' => Session::get('pid'), 'href' => action('MobileController@editpage', array('issues', $row_index, ''))]; foreach ($query as $row) { $list_array[] = ['label' => $row->issue, 'pid' => Session::get('pid'), 'href' => action('MobileController@editpage', array('issues', $row_index, $row->{$row_index}))]; } $result .= $this->mobile_result_build($list_array, 'mobile_issues_list'); } } else { $result .= ' None.'; } echo $result; }