stagfe2/app/Http/Controllers/PatientController.php

<?php

namespace App\Http\Controllers;

use App\Models\Appointment;
use App\Models\BDTDevice;
use App\Models\CareMonth;
use App\Models\Client;
use App\Models\ClientBDTDevice;
use App\Models\ClientInfoLine;
use App\Models\ClientPrimaryCoverage;
use App\Models\ClientProAccess;
use App\Models\CompanyPro;
use App\Models\Customer;
use App\Models\Erx;
use App\Models\Facility;
use App\Models\Handout;
use App\Models\HandoutClient;
use App\Models\IncomingReport;
use App\Models\Invoice;
use App\Models\MBClaim;
use App\Models\MBPayer;
use App\Models\Note;
use App\Models\NoteTemplate;
use App\Models\Pro;
use App\Models\Product;
use App\Models\ProProAccess;
use App\Models\SectionTemplate;
use App\Models\Shipment;
use App\Models\SupplyOrder;
use App\Models\Ticket;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\File;
use App\Models\Measurement;
use App\Models\ClientReviewRequest;

use Illuminate\Support\Facades\Http;
use PDF;

class PatientController extends Controller
{

    public function invoicingCompanies(Request $request, Client $patient) {
        return view('app.patient.invoicing.companies', compact('patient'));
    }

    public function invoicingInvoices(Request $request, Client $patient, Customer $customer) {
        return view('app.patient.invoicing.invoices', compact('patient', 'customer'));
    }

    public function invoicingCustomerTransactions(Request $request, Client $patient, Customer $customer) {
        return view('app.patient.invoicing.customer-transactions', compact('patient', 'customer'));
    }

    public function invoicingInvoiceTransactions(Request $request, Client $patient, Invoice $invoice) {
        $customer = $invoice->customer;
        return view('app.patient.invoicing.invoice-transactions', compact('patient', 'invoice', 'customer'));
    }

    public function claimsResolver(Request $request, Client $patient)
    {
        $notes = $patient->notesAscending;
        $hcpSignedNotesCount = 0;
        foreach($notes as $note){
            if($note->is_signed_by_hcp){
                $hcpSignedNotesCount += 1;
            }
        }
        $data = [
            'dog' => 'bark',
            'patient' => $patient,
            'hcpSignedNotesCount' => $hcpSignedNotesCount
        ];
        return view('app.patient.claims-resolver', $data);
    }

    public function dashboard(Request $request, Client $patient )
    {
        $mcpPros = Pro::where('is_enrolled_as_mcp', true)->get();
        $facilities = []; // Facility::where('is_active', true)->get();

        // get assigned devices
        $assignedDeviceIDs = DB::select(DB::raw("SELECT device_id from client_bdt_device where is_active = true"));
        $assignedDeviceIDs = array_map(function($_x) {
            return $_x->device_id;
        }, $assignedDeviceIDs);

        // get all except assigned ones
        $devices = BDTDevice::where('is_active', true)
            ->whereNotIn('id', $assignedDeviceIDs)
            ->orderBy('imei', 'asc')
            ->get();

        $assignedDeviceIDs = null;
        unset($assignedDeviceIDs);

        $dxInfoLines = ClientInfoLine::where('client_id', $patient->id)
            ->where('category', 'dx')
            ->where('is_removed', false)
            ->orderBy('content_text', 'asc')
            ->get();
        return view('app.patient.dashboard',
            compact('patient', 'facilities', 'devices', 'dxInfoLines'));
    }

    public function canvasMigrate(Request $request, Client $patient )
    {
        $mcpPros = Pro::where('is_enrolled_as_mcp', true)->get();
        $facilities = []; // Facility::where('is_active', true)->get();

        // get assigned devices
        $assignedDeviceIDs = DB::select(DB::raw("SELECT device_id from client_bdt_device where is_active = true"));
        $assignedDeviceIDs = array_map(function($_x) {
            return $_x->device_id;
        }, $assignedDeviceIDs);

        // get all except assigned ones
        $devices = BDTDevice::where('is_active', true)
            ->whereNotIn('id', $assignedDeviceIDs)
            ->orderBy('imei', 'asc')
            ->get();

        $assignedDeviceIDs = null;
        unset($assignedDeviceIDs);

        $dxInfoLines = ClientInfoLine::where('client_id', $patient->id)
            ->where('category', 'dx')
            ->where('is_removed', false)
            ->orderBy('content_text', 'asc')
            ->get();
        return view('app.patient.canvas-migrate',
            compact('patient', 'facilities', 'devices', 'dxInfoLines'));
    }

    public function canvas(Request $request, Client $patient){
        return view('app.patient.canvas_dump', compact('patient'));
    }

    public function actionItems(Request $request, Client $patient )
    {
        $facilities = []; // Facility::where('is_active', true)->get();
        return view('app.patient.action-items', compact('patient', 'facilities'));
    }

    public function actionItemsErx(Request $request, Client $patient, $filter = 'open')
    {
        $allPros = Pro::all();
        $facilities = []; // Facility::where('is_active', true)->get();
        return view('app.patient.action-items-erx', compact('patient', 'facilities', 'filter', 'allPros'));
    }

    public function actionItemsLab(Request $request, Client $patient, $filter = 'open')
    {
        $allPros = Pro::all();
        $facilities = []; // Facility::where('is_active', true)->get();
        return view('app.patient.action-items-lab', compact('patient', 'facilities', 'filter', 'allPros'));
    }

    public function actionItemsImaging(Request $request, Client $patient, $filter = 'open')
    {
        $allPros = Pro::all();
        $facilities = []; // Facility::where('is_active', true)->get();
        return view('app.patient.action-items-imaging', compact('patient', 'facilities', 'filter', 'allPros'));
    }

    public function actionItemsEquipment(Request $request, Client $patient, $filter = 'open')
    {
        $allPros = Pro::all();
        $facilities = []; // Facility::where('is_active', true)->get();
        return view('app.patient.action-items-equipment', compact('patient', 'facilities', 'filter', 'allPros'));
    }

    public function actionItemsOther(Request $request, Client $patient, $filter = 'open')
    {
        $allPros = Pro::all();
        $facilities = []; // Facility::where('is_active', true)->get();
        return view('app.patient.action-items-other', compact('patient', 'facilities', 'filter', 'allPros'));
    }

    public function actionItemsErxSingle(Request $request, Client $patient, Ticket $ticket) {
        $allPros = Pro::all();
        $facilities = []; // Facility::where('is_active', true)->get();
        return view('app.patient.action-items-erx-single', compact('patient', 'facilities', 'allPros', 'ticket'));
    }
    public function actionItemsLabSingle(Request $request, Client $patient, Ticket $ticket) {
        $allPros = Pro::all();
        $facilities = []; // Facility::where('is_active', true)->get();
        return view('app.patient.action-items-lab-single', compact('patient', 'facilities', 'allPros', 'ticket'));
    }
    public function actionItemsImagingSingle(Request $request, Client $patient, Ticket $ticket) {
        $allPros = Pro::all();
        $facilities = []; // Facility::where('is_active', true)->get();
        return view('app.patient.action-items-imaging-single', compact('patient', 'facilities', 'allPros', 'ticket'));
    }
    public function actionItemsEquipmentSingle(Request $request, Client $patient, Ticket $ticket) {
        $allPros = Pro::all();
        $facilities = []; // Facility::where('is_active', true)->get();
        return view('app.patient.action-items-equipment-single', compact('patient', 'facilities', 'allPros', 'ticket'));
    }
    public function actionItemsOtherSingle(Request $request, Client $patient, Ticket $ticket) {
        $allPros = Pro::all();
        $facilities = []; // Facility::where('is_active', true)->get();
        return view('app.patient.action-items-other-single', compact('patient', 'facilities', 'allPros', 'ticket'));
    }

    public function intake(Request $request, Client $patient )
    {
        $files = File::allFiles(resource_path('views/app/intake-templates'));
        $templates = [];
        foreach ($files as $file) {
            $templates[] = str_replace(".blade.php", "", $file->getFilename());
        }
        return view('app.patient.intake', compact('patient', 'templates'));
    }

    public function carePlan(Request $request, Client $patient )
    {
        return view('app.patient.care-plan', compact('patient'));
    }

    public function medications(Request $request, Client $patient )
    {
        $infoLines = ClientInfoLine::where('client_id', $patient->id)
            ->where('category', 'rx')
            ->where('is_removed', false)
            ->orderBy('content_text', 'asc')
            ->get();
        return view('app.patient.medications', compact('patient', 'infoLines'));
    }

    public function dxAndFocusAreas(Request $request, Client $patient )
    {
        $dxInfoLines = ClientInfoLine::where('client_id', $patient->id)
            ->where('category', 'dx')
            ->where('is_removed', false)
            ->orderBy('content_text', 'asc')
            ->get();
        return view('app.patient.dx-and-focus-areas', compact('patient', 'dxInfoLines'));
    }

    public function careTeam(Request $request, Client $patient )
    {
        $infoLines = ClientInfoLine::where('client_id', $patient->id)
            ->where('category', 'care_team')
            ->where('is_removed', false)
            ->get();
        return view('app.patient.care-team', compact('patient', 'infoLines'));
    }

    public function devices(Request $request, Client $patient )
    {
        // get assigned devices
        $assignedDeviceIDs = DB::select(DB::raw("SELECT device_id from client_bdt_device where is_active = true"));
        $assignedDeviceIDs = array_map(function($_x) {
            return $_x->device_id;
        }, $assignedDeviceIDs);

        // get all except assigned ones
        $devices = BDTDevice::where('is_active', true)
            ->whereNotIn('id', $assignedDeviceIDs)
            ->orderBy('imei', 'asc')
            ->get();

        $assignedDeviceIDs = null;
        unset($assignedDeviceIDs);

        return view('app.patient.devices', compact('patient', 'devices'));
    }

    public function measurements(Request $request, Client $patient )
    {
        $measurements = Measurement::where('client_id', $patient->id)->where('is_active', true)->orderByRaw('ts DESC NULLS LAST')->paginate(30);
        return view('app.patient.measurements', compact('patient', 'measurements'));
    }

    public function labsAndStudies(Request $request, Client $patient )
    {
        return view('app.patient.labs-and-studies', compact('patient'));
    }

    public function history(Request $request, Client $patient )
    {
        $infoLines = ClientInfoLine::where('client_id', $patient->id)
            ->where('category', 'LIKE', 'history_%')
            ->where('is_removed', false)
            ->get();
        return view('app.patient.history', compact('patient', 'infoLines'));
    }

    public function memos(Request $request, Client $patient )
    {
        return view('app.patient.memos', compact('patient'));
    }

    public function memosThread(Request $request, Client $patient )
    {
        return view('app.patient.memos-thread', compact('patient'));
    }

    public function messagesThread(Request $request, Client $patient )
    {
        return view('app.patient.messages-thread', compact('patient'));
    }

    public function sms(Request $request, Client $patient )
    {
        return view('app.patient.sms', compact('patient'));
    }

    public function outgoingSmsLog(Request $request, Client $patient )
    {
        return view('app.patient.outgoing-sms-log', compact('patient'));
    }

    public function reviewRequests(Request $request, Client $patient){
        $pro = $this->performer->pro;

        $reviewRequests = ClientReviewRequest::where('client_id', $patient->id);
        if($pro->pro_type !== 'ADMIN'){
            $reviewRequests = $reviewRequests->where('pro_id', $pro->id)->where('is_active', true);
        }
        $reviewRequests = $reviewRequests->orderBy('created_at', 'DESC')->paginate(50);
        return view('app.patient.review-requests.list', compact('patient', 'reviewRequests'));
    }

    public function smsNumbers(Request $request, Client $patient )
    {
        return view('app.patient.sms-numbers', compact('patient'));
    }

    public function immunizations(Request $request, Client $patient )
    {
        return view('app.patient.immunizations', compact('patient'));
    }

    public function allergies(Request $request, Client $patient )
    {
        $infoLines = ClientInfoLine::where('client_id', $patient->id)
            ->where('category', 'allergy')
            ->where('is_removed', false)
            ->get();
        return view('app.patient.allergies', compact('patient', 'infoLines'));
    }

    public function notes(Request $request, Client $patient, $filter = 'active')
    {
        $pros = $this->pros;
        return view('app.patient.notes', compact('patient','pros', 'filter'));
    }

    public function genericBills(Request $request, Client $patient)
    {
        return view('app.patient.generic-bills', compact('patient'));
    }

    public function rmSetup(Request $request, Client $patient)
    {

        // get assigned devices
        $assignedDeviceIDs = DB::select(DB::raw("SELECT device_id from client_bdt_device where is_active = true"));
        $assignedDeviceIDs = array_map(function($_x) {
            return $_x->device_id;
        }, $assignedDeviceIDs);

        // get all except assigned ones
        $devices = BDTDevice::where('is_active', true)
            ->whereNotIn('id', $assignedDeviceIDs)
            ->orderBy('imei', 'asc')
            ->get();

        $assignedDeviceIDs = null;
        unset($assignedDeviceIDs);

        return view('app.patient.rm-setup', compact('patient', 'devices'));
    }

    public function handouts(Request $request, Client $patient )
    {
        $clientHandouts = HandoutClient::where('client_id', $patient->id)->get();
        $handouts = Handout::where('is_active', true)->orderBy('display_name', 'ASC')->get();
        return view('app.patient.handouts', compact('patient', 'clientHandouts', 'handouts'));
    }

    public function settings(Request $request, Client $patient )
    {
        return view('app.patient.settings', compact('patient'));
    }

    public function smsReminders(Request $request, Client $patient )
    {
        return view('app.patient.sms-reminders', compact('patient'));
    }

    public function measurementConfirmationNumbers(Request $request, Client $patient )
    {
        return view('app.patient.measurement-confirmation-numbers', compact('patient'));
    }

    public function pros(Request $request, Client $patient )
    {
        return view('app.patient.pros', compact('patient'));
    }

    public function proChanges(Request $request, Client $patient )
    {
        return view('app.patient.client-pro-changes', compact('patient'));
    }

    public function account(Request $request, Client $patient )
    {
        return view('app.patient.account', compact('patient'));
    }

    public function careChecklist(Request $request, Client $patient )
    {
        return view('app.patient.care-checklist', compact('patient'));
    }

    public function documents(Request $request, Client $patient )
    {
        return view('app.patient.documents', compact('patient'));
    }

    public function incomingReports(Request $request, Client $patient, IncomingReport $currentReport = null)
    {
        return view('app.patient.incoming-reports', compact('patient', 'currentReport'));
    }

    public function education(Request $request, Client $patient )
    {
        return view('app.patient.education', compact('patient'));
    }

    public function messaging(Request $request, Client $patient )
    {
        return view('app.patient.messaging', compact('patient'));
    }

    public function duplicate(Request $request, Client $patient )
    {
        return view('app.patient.duplicate', compact('patient'));
    }

    public function careMonths(Request $request, Client $patient )
    {
        $careMonths = CareMonth::where('client_id', $patient->id)->orderBy('start_date', 'desc')->get();
        $notes = Note::where('is_cancelled', false)->get();
        return view('app.patient.care-months', compact('patient', 'careMonths', 'notes'));
    }

    public function presence(Request $request, Client $patient )
    {
        return json_encode([
            "online" => $patient->is_online
        ]);
    }

    public function embedSection(Request $request, Client $patient, $section, $selectable) {
        return view('app.patient.partials.' . $section, compact('patient', 'selectable'));
    }

    public function calendar(Request $request, Client $patient, Appointment $currentAppointment) {

        $pros = [];

        if($this->pro && $this->pro->pro_type != 'ADMIN') {

            $accessiblePros = ProProAccess::where('owner_pro_id', $this->pro->id)->get();

            $accessibleProIds = [];
            foreach($accessiblePros as $accessiblePro){
                $accessibleProIds[] = $accessiblePro->accessible_pro_id;
            }
            $accessibleProIds[] = $this->pro->id;

            // for dna, add pros accessible via pro teams
            if($this->performer->pro->isDefaultNA()) {
                $teams = $this->performer->pro->teamsWhereAssistant;
                foreach ($teams as $team) {
                    if(!in_array($team->mcp_pro_id, $accessibleProIds)) {
                        $accessibleProIds[] = $team->mcp_pro_id;
                    }
                }
            }

            $pros = Pro::whereIn('id', $accessibleProIds)->get();
        }

        $dateLastWeek = date_sub(date_create(), date_interval_create_from_date_string("14 days"));
        $dateLastWeek = date_format($dateLastWeek, "Y-m-d");
        $appointments = Appointment::where('client_id', $patient->id)
            ->orderBy('raw_date', 'desc')->orderBy('raw_start_time', 'desc')
            ->where('raw_date', '>=', $dateLastWeek)
            ->get();
        $appointmentProIDs = $appointments->map(function($_item) {
            return $_item->pro_id;
        });
        $appointmentPros = Pro::whereIn('id', $appointmentProIDs)->get();

        return view('app.patient.appointment-calendar',
            compact('pros', 'patient', 'currentAppointment', 'appointments', 'appointmentPros'));
    }

    public function programs(Request $request, Client $patient, $filter = '') {
        $pros = $this->pros;
        return view('app.patient.programs', compact('patient', 'pros', 'filter'));
    }

    public function flowsheets(Request $request, Client $patient, $filter = '') {
        $pros = $this->pros;
        return view('app.patient.flowsheets', compact('patient', 'pros', 'filter'));
    }

    public function vitalsSettings(Request $request, Client $patient) {
        return view('app.patient.vitals-settings', compact('patient'));
    }

    public function vitalsGraph(Request $request, Client $patient, $filter = '') {
        $pros = $this->pros;
        return view('app.patient.vitals-graph', compact('patient', 'pros', 'filter'));
    }

    public function tickets(Request $request, Client $patient, $type = '', String $currentTicket = '') {
        $pros = $this->pros;
        $allPros = Pro::all();
        $qlTicket = $currentTicket;
        if(!!$currentTicket) {
            $qlTicket = Ticket::where('uid', $currentTicket)->first();
            if($qlTicket) {
                $currentTicket = $qlTicket;
            }
        }
        return view('app.patient.tickets', compact('patient', 'pros', 'allPros', 'type', 'currentTicket'));
    }

    public function prescriptions(Request $request, Client $patient, String $type = '', String $currentErx = '') {
        if(!!$currentErx) {
            $currentErx = Erx::where('uid', $currentErx)->first();
        }
        $note = $patient->coreNote;
        return view('app.patient.prescriptions.index', compact('patient', 'type', 'currentErx', 'note'));
    }

    public function prescriptionsPopup(Request $request, Client $patient, String $type = '', String $currentErx = '') {
        if(!!$currentErx) {
            $currentErx = Erx::where('uid', $currentErx)->first();
        }
        $note = null;
        if($request->input('noteUid')) {
            $note = Note::where('uid', $request->input('noteUid'))->first();
        }
        return view('app.patient.prescriptions-popup.list-popup', compact('patient', 'type', 'currentErx', 'note'));
    }

    public function prescriptionsList(Request $request, Client $patient, String $type = '', String $currentErx = '') {
        if(!!$currentErx) {
            $currentErx = Erx::where('uid', $currentErx)->first();
        }
        $note = null;
        if($request->input('noteUid')) {
            $note = Note::where('uid', $request->input('noteUid'))->first();
        }
        return view('app.patient.prescriptions.list', compact('patient', 'type', 'currentErx', 'note'));
    }

    public function downloadPrescriptionAsPdf(Request $request, Erx $prescription){
        if($request->input('html')) {
            return view('app.patient.prescriptions.pdf.pdf-preview', compact('prescription'));
        }
        else {
            $pdf = PDF::loadView('app.patient.prescriptions.pdf.pdf-preview', compact('prescription'));
            return $pdf->download($prescription->created_at .'_' . 'erx.pdf');
        }
    }

    public function transmitPrescription(Request $request, Erx $prescription){

        // re-generate pdf with cover sheet as first page and save it to FS
        $filePath = config('app.temp_dir') . "/{$prescription->uid}.pdf";
        $pdf = PDF::loadView('app.patient.prescriptions.pdf.pdf-preview-with-cover-sheet', compact('prescription'));
        $pdf->save($filePath);

        // send it along with the rest of the params to /api/erx/transmit [multi-part POST]
        $url =  config('stag.backendUrl') . '/erx/transmit';
        $params = [
            "uid" => $request->input('uid'),
            "toWho" => $request->input('toWho'),
            "toEmail" => $request->input('toEmail'),
            "toFaxNumber" => $request->input('toFaxNumber'),
            "toFaxNumberAttentionLine" => $request->input('toFaxNumberAttentionLine'),
            "toFaxNumberCoverSheetMemo" => $request->input('toFaxNumberCoverSheetMemo'),
        ];
        if($request->input('copyToPatient')) {
            $params["copyToPatientFaxNumber"] = $request->input('copyToPatientFaxNumber');
            $params["copyToPatientEmail"] = $request->input('copyToPatientEmail');
        }
        $pdf = fopen($filePath, 'r');
        $response = Http
            ::attach('pdfSystemFile', $filePath, "{$prescription->uid}.pdf")
            ->withHeaders(['sessionKey' => $request->cookie('sessionKey')])
            ->post($url, $params)
            ->json();
        return $response;

    }

    public function supplyOrders(Request $request, Client $patient, SupplyOrder $supplyOrder = null)
    {
        $products = Product::where('is_active', true)->orderBy('created_at', 'desc')->get();
        return view('app.patient.supply-orders', compact('patient', 'supplyOrder', 'products'));
    }

    public function shipments(Request $request, Client $patient, Shipment $shipment = null)
    {
        return view('app.patient.shipments', compact('patient', 'shipment'));
    }

    public function appointments(Request $request, Client $patient, $forPro = 'all', $status = 'all') {
        $pros = $this->pros;
        $appointments = $patient->appointmentsForProByStatus($forPro, strtoupper($status));
        $appointmentProIDs = $appointments->map(function($_item) {
            return $_item->pro_id;
        });
        $appointmentPros = Pro::whereIn('id', $appointmentProIDs)->get();
        return view('app.patient.appointments',
            compact('patient', 'pros', 'appointments', 'appointmentPros', 'forPro', 'status'));
    }

    public function mcpRequests(Request $request, Client $patient) {
        return view('app.patient.mcp-requests', compact('patient'));
    }

    public function eligibleRefreshes(Request $request, Client $patient) {
        return view('app.patient.eligible-refreshes', compact('patient'));
    }

    public function insuranceCoverage(Request $request, Client $patient) {
        $mbPayers = MBPayer::all();
        return view('app.patient.insurance-coverage', compact('patient', 'mbPayers'));
    }

    public function clientPrimaryCoverages(Request $request, Client $patient) {
        $mbPayers = MBPayer::all();
        return view('app.patient.client-primary-coverages', compact('patient', 'mbPayers'));
    }

    public function primaryCoverage(Request $request, Client $patient) {
        $mbPayers = MBPayer::all();
        return view('app.patient.primary-coverage', compact('patient', 'mbPayers'));
    }

    public function primaryCoverageForm(Request $request, Client $patient) {
        $mbPayers = MBPayer::all();
        return view('app.patient.primary-coverage-form', compact('patient', 'mbPayers'));
    }

    public function primaryCoverageManualDeterminationModal(Request $request, Client $patient) {
        $coverageUid = $request->get('coverageUid');
        $coverage = ClientPrimaryCoverage::where('uid', $coverageUid)->first();

        if($patient->latestClientPrimaryCoverage->plan_type === 'MEDICARE'){
            return view('app.patient.primary-coverage-manual-determination-medicare-modal', compact('patient', 'coverage'));
        }
        if($patient->latestClientPrimaryCoverage->plan_type === 'MEDICAID'){
            return view('app.patient.primary-coverage-manual-determination-medicaid-modal', compact('patient', 'coverage'));
        }
        if($patient->latestClientPrimaryCoverage->plan_type === 'COMMERCIAL'){
            return view('app.patient.primary-coverage-manual-determination-commercial-modal', compact('patient', 'coverage'));
        }

        return "Plan Type is missing!";
    }

    public function mbClaim(Request $request, MBClaim $mbClaim) {
        return view('app.patient.mb-claim-single', compact('mbClaim'));
    }

    public function accounts(Request $request, Client $patient) {
        return view('app.patient.accounts', compact('patient'));
    }

    public function careMonthMatrix(Request $request, CareMonth $careMonth) {
        return view('app.patient.care-month.matrix', [
            'patient' => $careMonth->patient,
            'careMonth' => $careMonth,
        ]);
    }

    public function clientProAccess(Request $request, Client $patient) {
        $rows = ClientProAccess::where('client_id', $patient->id)->get();
        return view('app.patient.client-pro-access', compact('patient', 'rows'));
    }

    public function clientDocuments(Request $request, Client $patient){
        $templates =  get_doc_templates();
        
        $companyProIDs = DB::select('SELECT company_pro_id FROM company_pro_document WHERE related_client_id  = ?', [$patient->id]);

        $companyProIDInts = [];
        foreach($companyProIDs as $cpId){
            $companyProIDInts[] = $cpId->company_pro_id; 
        }
        
        $companyPros = CompanyPro::whereIn('id', $companyProIDInts)->get();

        return view('app.patient.client-documents', compact('templates', 'companyPros', 'patient'));
    }

    public function insuranceCoverageHistory(Request $request, Client $patient){
        $insuranceCoverageHistory = ClientPrimaryCoverage::where('client_id', $patient->id)->orderBy('created_at', 'DESC')->get();
        return view('app.patient.insurance-coverage-history', compact('patient', 'insuranceCoverageHistory'));
    }
}