stagfe2/app/Http/Controllers/AdminController.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\Erx;
use App\Models\Facility;
use App\Models\Handout;
use App\Models\IncomingReport;
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\Bill;
use App\Models\ClientSMS;

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

class AdminController extends Controller
{

    public function patients(Request $request)
    {
        $filters = $request->all();
        $patients = Client::whereNull('shadow_pro_id');

        // filters
        /*
        array:18 [▼
          "age_category" => "LESS_THAN"
          "age_value_1" => "34"
          "age_value_2" => null
          "sex" => "M"
          "bmi_category" => "BETWEEN"
          "bmi_value_1" => "20"
          "bmi_value_2" => "25"
          "last_visit_category" => "LESS_THAN"
          "last_visit_value_1" => "2021-10-14"
          "last_visit_value_2" => null
          "next_appointment_category" => "LESS_THAN"
          "next_appointment_value_1" => "2021-10-15"
          "status" => "ACTIVE"
          "last_weighed_in_category" => "EXACTLY"
          "last_weighed_in_value_1" => "2021-10-07"
          "last_bp_category" => "BETWEEN"
          "last_bp_value_1" => "2021-10-01"
          "last_bp_value_2" => "2021-10-31"
        ]
        */

        if ($request->input('name')) {
            $name = trim($request->input('name'));
            if ($name) {
                $patients = $patients->where(function ($q) use ($name) {
                    $q->where('name_first', 'ILIKE', '%' . $name . '%')
                        ->orWhere('name_last', 'ILIKE', '%' . $name . '%');
                });
            }
        }

        if ($request->input('mcp')) {
            if($request->input('mcp') == 'NO_MCP'){
                $patients = $patients->whereNull('mcp_pro_id');
            }else{
                $mcp = Pro::where('uid', trim($request->input('mcp')))->first();
                if ($mcp) {
                    $patients = $patients->where('mcp_pro_id', $mcp->id);
                }
            }
        }

        if ($request->input('na')) {
            if($request->input('na') == 'NO_NA'){
                $patients = $patients->whereNull('default_na_pro_id');
            }else{
                $na = Pro::where('uid', trim($request->input('na')))->first();
                if ($na) {
                    $patients = $patients->where('default_na_pro_id', $na->id);
                }
            }
           
        }

        if ($request->input('next_appointment_category')) {
            if($request->input('next_appointment_category') == 'NONE'){
                $patients = $patients->whereNull('next_mcp_appointment_id');
            }
        }

        if ($request->input('chart_number')) {
            $patients = $patients->where('chart_number', 'ILIKE' , '%'.$request->input('chart_number').'%');
        }

        if ($request->input('home_address_state')) {

            if($request->input('home_address_state') == 'NONE'){
                $patients = $patients->whereNull('mailing_address_state');
            }else if($request->input('home_address_state') == 'NOT_MD'){
                $patients = $patients->where('mailing_address_state', '<>' , 'MD');
            }else{
                $patients = $patients->where('mailing_address_state', '=' , $request->input('home_address_state'));
            }
        }

        $this->filterMultiQuery($request, $patients, 'age_in_years', 'age_category', 'age_value_1', 'age_value_2');
        $this->filterSimpleQuery($request, $patients, 'sex', 'sex');
        $this->filterMultiQuery($request, $patients, 'usual_bmi_max', 'bmi_category', 'bmi_value_1', 'bmi_value_2');
        $this->filterMultiQuery($request, $patients, 'most_recent_weight_at', 'last_weighed_in_category', 'last_weighed_in_value_1', 'last_weighed_in_value_2');
        $this->filterMultiQuery($request, $patients, 'most_recent_bp_at', 'last_bp_category', 'last_bp_value_1', 'last_bp_value_2');

        if($request->input('number_of_measurements')){
            $keyName = $request->input('number_of_measurements');
            $measurementCountQuery = '(SELECT COUNT(*) FROM measurement WHERE measurement.client_id = client.id AND is_active IS TRUE AND is_cellular IS TRUE AND is_cellular_zero IS NOT TRUE)';
            switch($keyName) {
                case 'EXACTLY':
                    if($request->input('number_of_measurements_value_1')) {
                        $patients->whereRaw($measurementCountQuery . '='.$request->input('number_of_measurements_value_1'));
                    }
                    break;
                case 'LESS_THAN':
                    if($request->input('number_of_measurements_value_1')) {
                        $patients->whereRaw($measurementCountQuery . '<='.$request->input('number_of_measurements_value_1'));
                    }
                    break;
                case 'GREATER_THAN':
                    if($request->input('number_of_measurements_value_1')) {
                        $patients->whereRaw($measurementCountQuery . '>='.$request->input('number_of_measurements_value_1'));
                    }
                    break;
                case 'BETWEEN':
                    if($request->input('number_of_measurements_value_1') && $request->input('number_of_measurements_value_2')) { 
                        $patients->whereRaw($measurementCountQuery.'>='.$request->input('number_of_measurements_value_1') .' AND '. $measurementCountQuery . '<='.$request->input('number_of_measurements_value_2'));
                    }
                    break;
                case 'NOT_BETWEEN':
                    if($request->input('number_of_measurements_value_1') && $request->input('number_of_measurements_value_2')) {
                        $patients->where(function ($q) use ($request, $measurementCountQuery) {
                                $q->whereRaw($measurementCountQuery . '<'.$request->input('number_of_measurements_value_1') .' OR '. $measurementCountQuery . '>'.$request->input('number_of_measurements_value_2'));                               
                        });
                    }
                    break;
            }
        }

        switch($request->input('status')) {
            case 'ACTIVE':
                $patients->where('is_active', true)->where('has_mcp_done_onboarding_visit', true);
                break;
            case 'AWAITING_VISIT':
                $patients->where('is_active', true)->where('has_mcp_done_onboarding_visit', false);
                break;
            case 'INACTIVE':
                $patients->where('is_active', '<>', true);
                break;
        }

        $initiative = $request->input('initiative');
        if($initiative){
            $wildCardedInitiative = '%'.$initiative.'%';
            $patients->where('initiative', 'ilike', $wildCardedInitiative);
        }

        $include_test_records = $request->input('include_test_records');
        if(!$include_test_records){
            $patients = $patients->where(function ($q) {
                $q->whereNull('client_engagement_status_category')
                    ->orWhere('client_engagement_status_category', '<>', 'DUMMY');
            });
        }

        $insurance = $request->get('insurance');
        if($insurance){
            if($insurance === 'MEDICARE'){
                $patients = $patients->whereHas('latestClientPrimaryCoverage', function($cpcQuery){
                    return $cpcQuery->where('is_partbprimary', '=', 'YES');
                });
            }else{
                $patients = $patients->whereDoesntHave('latestClientPrimaryCoverage', function($cpcQuery){
                    return $cpcQuery->where('is_partbprimary', '=', 'YES');
                });
            }
        }

        $patients = $patients->orderBy('created_at', 'DESC')->paginate(25);
        return view('app.admin.patients', compact('patients', 'filters'));
    }

    public function partBPatients(Request $request){
        
        $filters = $request->all();
        $patients = Client::whereNull('shadow_pro_id');

      
        if ($request->input('name')) {
            $name = trim($request->input('name'));
            if ($name) {
                $patients = $patients->where(function ($q) use ($name) {
                    $q->where('name_first', 'ILIKE', '%' . $name . '%')
                        ->orWhere('name_last', 'ILIKE', '%' . $name . '%');
                });
            }
        }

        if ($request->input('mcp')) {
            if($request->input('mcp') == 'NO_MCP'){
                $patients = $patients->whereNull('mcp_pro_id');
            }else{
                $mcp = Pro::where('uid', trim($request->input('mcp')))->first();
                if ($mcp) {
                    $patients = $patients->where('mcp_pro_id', $mcp->id);
                }
            }
        }

        if ($request->input('na')) {
            if($request->input('na') == 'NO_NA'){
                $patients = $patients->whereNull('default_na_pro_id');
            }else{
                $na = Pro::where('uid', trim($request->input('na')))->first();
                if ($na) {
                    $patients = $patients->where('default_na_pro_id', $na->id);
                }
            }
           
        }

        if ($request->input('next_appointment_category')) {
            if($request->input('next_appointment_category') == 'NONE'){
                $patients = $patients->whereNull('next_mcp_appointment_id');
            }
        }

        if ($request->input('chart_number')) {
            $patients = $patients->where('chart_number', 'ILIKE' , '%'.$request->input('chart_number').'%');
        }

        if ($request->input('home_address_state')) {

            if($request->input('home_address_state') == 'NONE'){
                $patients = $patients->whereNull('mailing_address_state');
            }else if($request->input('home_address_state') == 'NOT_MD'){
                $patients = $patients->where('mailing_address_state', '<>' , 'MD');
            }else{
                $patients = $patients->where('mailing_address_state', '=' , $request->input('home_address_state'));
            }
        }

        $this->filterMultiQuery($request, $patients, 'age_in_years', 'age_category', 'age_value_1', 'age_value_2');
        $this->filterSimpleQuery($request, $patients, 'sex', 'sex');
        $this->filterMultiQuery($request, $patients, 'usual_bmi_max', 'bmi_category', 'bmi_value_1', 'bmi_value_2');
        $this->filterMultiQuery($request, $patients, 'most_recent_weight_at', 'last_weighed_in_category', 'last_weighed_in_value_1', 'last_weighed_in_value_2');
        $this->filterMultiQuery($request, $patients, 'most_recent_bp_at', 'last_bp_category', 'last_bp_value_1', 'last_bp_value_2');

        if($request->input('deductible')){
            $keyName = $request->input('deductible');

            switch($keyName) {
                case 'EXACTLY':
                        $patients = $patients->whereHas('latestClientPrimaryCoverage', function($q) use ($request){
                            return $q->where('auto_medicare_mpb_deductible', '=', $request->input('deductible_value_1'));
                        });
                    break;
                case 'LESS_THAN':
                    if($request->input('deductible_value_1')) {
                        $patients = $patients->whereHas('latestClientPrimaryCoverage', function($q) use ($request){
                            return $q->where('auto_medicare_mpb_deductible', '<=', $request->input('deductible_value_1'));
                        });
                    }
                    break;
                case 'GREATER_THAN':
                    if($request->input('deductible_value_1')) {
                        $patients = $patients->whereHas('latestClientPrimaryCoverage', function($q) use ($request){
                            return $q->where('auto_medicare_mpb_deductible', '>=', $request->input('deductible_value_1'));
                        });
                    }
                    break;
                case 'BETWEEN':
                    $patients = $patients->whereHas('latestClientPrimaryCoverage', function($q) use ($request){
                        return $q->where('auto_medicare_mpb_deductible', '>=', $request->input('deductible_value_1'))
                        ->where('auto_medicare_mpb_deductible', '<=', $request->input('deductible_value_2'));
                    });
                    break;
                case 'NOT_BETWEEN':
                    if($request->input('deductible_value_1') && $request->input('deductible_value_2')) {
                        $patients = $patients->whereHas('latestClientPrimaryCoverage', function($q) use ($request){

                            return $q->where(function($qq) use ($request){
                                return $qq->where('auto_medicare_mpb_deductible', '<', $request->input('deductible_value_1'))
                                    ->orWhere('auto_medicare_mpb_deductible', '>', $request->input('deductible_value_2'));
                            });
                        });
                    }
                    break;
            }
        }

        switch($request->input('status')) {
            case 'ACTIVE':
                $patients->where('is_active', true)->where('has_mcp_done_onboarding_visit', true);
                break;
            case 'AWAITING_VISIT':
                $patients->where('is_active', true)->where('has_mcp_done_onboarding_visit', false);
                break;
            case 'INACTIVE':
                $patients->where('is_active', '<>', true);
                break;
        }

        $initiative = $request->input('initiative');
        if($initiative){
            $wildCardedInitiative = '%'.$initiative.'%';
            $patients->where('initiative', 'ilike', $wildCardedInitiative);
        }

        $include_test_records = $request->input('include_test_records');
        if(!$include_test_records){
            $patients = $patients->where(function ($q) {
                return $q->whereNull('client_engagement_status_category')
                    ->orWhere('client_engagement_status_category', '<>', 'DUMMY');
            });
        }

        
        $with_claim_not_closed = $request->input('with_claim_not_closed');
        if($with_claim_not_closed){
            $patients = $patients->whereHas('notes', function ($q) {
                return $q->where('is_claim_closed', false)
                ->where('is_signed_by_hcp', true)
                ->where('is_cancelled', false);
            });
        }

        $patients = $patients->whereHas('latestClientPrimaryCoverage', function($cpcQuery){
            return $cpcQuery->where('is_partbprimary', '=', 'YES');
        });

        $patients = $patients->orderBy('created_at', 'DESC')->paginate(25);
        return view('app.admin.part_b_patients', compact('patients', 'filters'));
    }

    public function notes(Request $request)
    {
        $notes = Note::paginate(5);

        // SELECT * FROM note WHERE client_id IN (SELECT id FROM client WHERE mcp_pro_id = :me.id);

        return view('app.mcp.notes', compact('notes'));
    }

    public function notes_pending_summary_suggestion(Request $request){
        $pro = $this->performer->pro;
        $data = [
            'records' => $pro->get_notes_pending_summary_suggestion_as_admin()
        ];
        return view('app.admin.notes_pending_summary_suggestion', $data);
    }

    public function notes_rejected_summary_suggestion(Request $request){
        $pro = $this->performer->pro;
        $data = [
            'records' => $pro->get_notes_rejected_summary_suggestion_as_admin()
        ];
        return view('app.admin.notes_rejected_summary_suggestion', $data);
    }


    public function appointments(Request $request)
    {
        $appointments = Appointment::paginate(5);
        return view('app.mcp.appointments', compact('appointments'));
    }

    public function bills(Request $request)
    {
        $bills = Bill::paginate(5);
        return view('app.mcp.bills', compact('bills'));
    }

    public function erx_and_orders(Request $request)
    {
        $erxAndOrders = Erx::paginate(5);
        return view('app.mcp.erx_and_orders', compact('erxAndOrders'));
    }

    public function reports(Request $request)
    {
        $data = [];
        return view('app.mcp.reports', $data);
    }

    public function supply_orders(Request $request)
    {
        $supplyOrders = SupplyOrder::paginate(5);
        return view('app.mcp.supply_orders', compact('supplyOrders'));
    }

    public function getCreateNewPatientScriptTemplate(Request $request){
        $template = $request->get('template');
        if(!$template) return $this->fail('No script template');

        $path = resource_path() . '/views/app/patient/create-patient/scripts/' . $template . '.blade.php';
        
        if(!File::exists($path)) return $this->fail('Invalid script template');

        $templateContent = file_get_contents($path);
        return $this->pass($templateContent);
    }
    
    public function bdtDevices(Request $request)
    {
        $filters = $request->all();

        $bdtDevices = BDTDevice::paginate(20);
        return view('app.admin.bdt_devices', compact('bdtDevices', 'filters'));
    }

}