stagfe2/app/Http/Controllers/McpController.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 McpController extends Controller
{

    public function patients(Request $request)
    {
        $filters = $request->all();
        $patients = Client::whereNull('shadow_pro_id')->where('mcp_pro_id', $this->performer->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 . '%');
                });
            }
        }

        $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', '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');

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

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

    private function filterSimpleQuery(Request $request, $query, $columnName, $valueName) {
        if($request->input($valueName)) {
            $query->where($columnName, $request->input($valueName));
        }
    }
    private function filterMultiQuery(Request $request, $query, $columnName, $keyName, $valueName1, $valueName2) {
        switch($request->input($keyName)) {
            case 'EXACTLY':
                if($request->input($valueName1)) {
                    $query->where($columnName, $request->input($valueName1));
                }
                break;
            case 'LESS_THAN':
                if($request->input($valueName1)) {
                    $query->where($columnName, '<', $request->input($valueName1));
                }
                break;
            case 'GREATER_THAN':
                if($request->input($valueName1)) {
                    $query->where($columnName, '>', $request->input($valueName1));
                }
                break;
            case 'BETWEEN':
                if($request->input($valueName1) && $request->input($valueName2)) {
                    $query
                        ->where($columnName, '>=', $request->input($valueName1))
                        ->where($columnName, '<=', $request->input($valueName2));
                }
                break;
            case 'NOT_BETWEEN':
                if($request->input($valueName1) && $request->input($valueName2)) {
                    $query
                        ->where(function ($q) use ($request, $columnName, $valueName1, $valueName2) {
                            $q->where($columnName, '<', $request->input($valueName1))
                                ->orWhere($columnName, '>', $request->input($valueName2));
                        });
                }
                break;
        }
    }

    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 appointments(Request $request)
    {
        $appointments = Appointment::paginate(5);
        return view('app.mcp.appointments', compact('appointments'));
    }

    public function bills(Request $request)
    {
        $filters = $request->all();
        $bills = Bill::where('hcp_pro_id', $this->performer->pro->id);
        $this->filterMultiQuery($request, $bills, 'created_at', 'date_category', 'date_value_1', 'date_value_2');
        $status = $request->get('status');
        if($status){
            if($status == 'CANCELLED') $bills = $bills->where('is_cancelled', true);
            if($status == 'NOT_CANCELLED') $bills = $bills->where('is_cancelled', false);
        }
        $bills = $bills->orderBy('created_at', 'DESC')->paginate(20);
        return view('app.mcp.bills', compact('bills', 'filters'));
    }

    public function erx_and_orders(Request $request)
    {
        $filters = $request->all();
        $erxAndOrders = Erx::query();
        $erxAndOrders = $erxAndOrders->where('hcp_pro_id', $this->performer->pro->id);
        $this->filterMultiQuery($request, $erxAndOrders, 'created_at', 'date_category', 'date_value_1', 'date_value_2');
        $this->filterSimpleQuery($request, $erxAndOrders, 'pro_declared_status', 'status');

        $erxAndOrders = $erxAndOrders->orderBy('created_at', 'DESC')->paginate(20);
        return view('app.mcp.erx_and_orders', compact('erxAndOrders', 'filters'));
    }

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

    public function supply_orders(Request $request)
    {
        $filters = $request->all();
        $supplyOrders = SupplyOrder::select('supply_order.*')->where('supply_order.signed_by_pro_id', $this->performer->pro->id);
        $this->filterMultiQuery($request, $supplyOrders, 'created_at', 'date_category', 'date_value_1', 'date_value_2');
        $status = $request->get('status');        
        if($status){
            if($status == 'CLEARED_FOR_SHIPMENT'){
                $supplyOrders = $supplyOrders->where('is_cleared_for_shipment', true);
            }elseif($status == 'NOT_CLEARED_FOR_SHIPMENT'){
                $supplyOrders = $supplyOrders->where('is_cleared_for_shipment', false);
            }elseif($status == 'CANCELLED'){
                $supplyOrders = $supplyOrders->where('is_cancelled', true);
            }else{
             $supplyOrders = $supplyOrders->join('shipment', 'shipment.id', '=', 'supply_order.shipment_id')->where('shipment.status', $status);   
            }
            
        }
        $supplyOrders = $supplyOrders->orderBy('created_at', 'DESC')->paginate(20);
        return view('app.mcp.supply_orders', compact('supplyOrders', 'filters'));
    }

    public function client_messages(Request $request)
    {      
        $filters = $request->all();

        $clientMessages = ClientSMS::select('client_sms.*')
        ->join('client', 'client.id', '=', 'client_sms.client_id')
        ->where('client.mcp_pro_id', $this->performer->pro->id);

        $this->filterMultiQuery($request, $clientMessages, 'client_sms.created_at', 'date_category', 'date_value_1', 'date_value_2');
        $this->filterSimpleQuery($request, $clientMessages, 'sms_status', 'sms_status');

        $clientMessages = $clientMessages->orderBy('client_sms.created_at', 'DESC');
        $clientMessages = $clientMessages->paginate(20);
        return view('app.mcp.client_messages', compact('clientMessages', 'filters'));
    }

    public function new_patients_awaiting_visit(Request $request){
        $data = [
            'records' => Client::where('mcp_pro_id', $this->performer->pro->id)
                ->where('has_mcp_done_onboarding_visit', '!=', 'YES')
                ->orderBy('created_at')
                ->get()
        ];
        return view('app.mcp.new_patients_awaiting_visit', $data);
    }
    public function notes_pending_signature(Request $request){
        $data = [
            'records' => Note::where('hcp_pro_id', $this->performer->pro->id)
                ->where('is_cancelled', '<>', true)
                ->where('is_signed_by_hcp', '<>', true)
                ->where('is_core_note', false)
                ->orderBy('created_at')
                ->get()
        ];
        return view('app.mcp.notes_pending_signature', $data);
    }
    public function notes_pending_billing(Request $request){
        $data = [
            'records' => Note::where('hcp_pro_id', $this->performer->pro->id)
                ->where('is_cancelled', '<>', true)
                ->where('is_signed_by_hcp', true)
                ->where('is_billing_marked_done', '<>', true)
                ->orderBy('created_at')
                ->get()
        ];
        return view('app.mcp.notes_pending_billing', $data);
    }
    public function reports_pending_signature(Request $request){
        $data = [
            'records' => IncomingReport::where('hcp_pro_id', $this->performer->pro->id)
                ->where('has_hcp_pro_signed', '<>', true)
                ->where('is_entry_error', '<>', true)
                ->orderBy('created_at')
                ->get()
        ];
        return view('app.mcp.reports_pending_signature', $data);
    }
    public function patients_without_appointments(Request $request){
        $patients = $this->performer->pro->get_patients_without_appointment_query()->paginate(20);
        return view('app.mcp.patients_without_appointments', compact('patients'));
    }
    public function patients_overdue_for_visit(Request $request){
        $patients = $this->performer->pro->get_patients_overdue_for_visit_query()->paginate(20);
        return view('app.mcp.patients_overdue_for_visit', compact('patients'));
    }
    public function cancelled_appointments_pending_review(Request $request){
        $data = [];
        return view('app.mcp.cancelled_appointments_pending_review', $data);
    }
    public function cancelled_bills_pending_review(Request $request){
        $data = [
            'records' => Bill::where('hcp_pro_id', $this->performer->pro->id)
                ->where('bill_service_type', 'NOTE')
                ->where('is_cancelled', true)
                ->where('is_cancellation_acknowledged', '<>', true)
                ->orderBy('created_at')
                ->get()
        ];
        return view('app.mcp.cancelled_bills_pending_review', $data);
    }
    public function cancelled_supply_orders_pending_review(Request $request){
        $data = [
            'records' => SupplyOrder::where('signed_by_pro_id', $this->performer->pro->id)
                ->where('is_cancelled', true)
                ->where('is_cancellation_acknowledged', '<>', true)
                ->orderBy('created_at')
                ->get()
        ];
        return view('app.mcp.cancelled_supply_orders_pending_review', $data);
    }
    public function erx_and_orders_pending_signature(Request $request){
        $data = [
            'records' => Erx::where('hcp_pro_id', $this->performer->pro->id)
                ->where('pro_declared_status', '<>', 'CANCELLED')
                ->where('has_hcp_pro_signed', '<>', true)
                ->orderBy('created_at')
                ->get()
        ];
        return view('app.mcp.erx_and_orders_pending_signature', $data);
    }
    public function supply_orders_pending_signature(Request $request){
        $data = [
            'records' => SupplyOrder::where('created_by_pro_id', $this->performer->pro->id)
                ->whereNull('signed_by_pro_id')
                ->where('is_cancelled', '<>', true)
                ->orderBy('created_at')
                ->get()
        ];
        return view('app.mcp.supply_orders_pending_signature', $data);
    }
    public function measurements_pending_stamping(Request $request){
        $data = [
            'records' => CareMonth::where('mcp_pro_id', $this->performer->pro->id)
                ->where('rm_num_measurements_not_stamped_by_mcp', '>', 0)
                ->whereNotNull('rm_num_measurements_not_stamped_by_mcp')
                ->orderBy('created_at', 'DESC')
                ->paginate(15)
        ];
        return view('app.mcp.measurements_pending_stamping', $data);
    }

}