<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

class FDBPGController extends Controller
{

    public function index(Request $request)
    {
        return view('app.fdb-pg.index');
    }

    public function medSuggest(Request $request)
    {
        $term = $request->input('term') ? trim($request->input('term')) : '';
        if (empty($term)) return '';
        $matches = DB::connection('pgsql_fdb')->select(
            "SELECT med_name_id, med_name FROM rminmid1_med_name WHERE med_status_cd = '0' AND med_name ILIKE :term ORDER BY med_name",
            ['term' => '%' . $term . '%']
        );
        return view('app.fdb-pg.fdb-med-suggest', compact('matches'));
    }

    public function routedMeds(Request $request)
    {
        $medNameID = $request->input('med-name-id') ? trim($request->input('med-name-id')) : '';
        if (empty($medNameID)) return '';
        $matches = DB::connection('pgsql_fdb')->select(
            "SELECT routed_med_id, med_routed_med_id_desc FROM rmirmid1_routed_med WHERE med_status_cd = '0' AND med_name_id = :medNameID ORDER BY med_routed_med_id_desc",
            ['medNameID' => $medNameID]
        );
        return json_encode($matches);
    }

    public function routedDosages(Request $request)
    {
        $routedMedID = $request->input('routed-med-id') ? trim($request->input('routed-med-id')) : '';
        if (empty($routedMedID)) return '';
        $matches = DB::connection('pgsql_fdb')->select(
            "SELECT routed_dosage_form_med_id, med_routed_df_med_id_desc FROM rmidfid1_routed_dose_form_med WHERE med_status_cd = '0' AND routed_med_id = :routedMedID ORDER BY med_routed_df_med_id_desc",
            ['routedMedID' => $routedMedID]
        );
        return json_encode($matches);
    }

    public function meds(Request $request)
    {
        $dosageFormMedId = $request->input('dosage-form-med-id') ? trim($request->input('dosage-form-med-id')) : '';
        if (empty($dosageFormMedId)) return '';
        $matches = DB::connection('pgsql_fdb')->select(
            "SELECT medid, med_medid_desc, gcn_seqno FROM rmiid1_med WHERE med_status_cd = '0' AND routed_dosage_form_med_id = :dosageFormMedId ORDER BY med_medid_desc",
            ['dosageFormMedId' => $dosageFormMedId]
        );
        return json_encode($matches);
    }

    public function sideEffects(Request $request)
    {
        $gcnSeqNo = $request->input('gcn-seq-no') ? trim($request->input('gcn-seq-no')) : '';
        if (empty($gcnSeqNo)) return '';
        $sides = DB::connection('pgsql_fdb')->select("
SELECT r1.side, sm.side_freq, sm.side_sev, sm.dxid, dx.dxid_desc56 
FROM rsidegc0_gcnseqno_link r1 
    JOIN rsidema3_mstr sm ON r1.side = sm.side
    JOIN rfmldx0_dxid dx ON sm.dxid = dx.dxid
WHERE r1.gcn_seqno = :gcnSeqNo
ORDER BY sm.side_sev DESC, sm.side_freq ASC
            ",
            ['gcnSeqNo' => $gcnSeqNo]
        );
        return view('app.fdb-pg.fdb-side-effects', compact('sides'));
    }

    public function geriatricPrecautions(Request $request)
    {
        $gcnSeqNo = $request->input('gcn-seq-no') ? trim($request->input('gcn-seq-no')) : '';
        if (empty($gcnSeqNo)) return '';
        $precautions = DB::connection('pgsql_fdb')->select("
SELECT r1.geri_code, gm.geri_sl, gm.geri_desc, gm.geri_narrative
FROM rgerigc0_geri_gcnseqno_link r1 
    JOIN rgerima1_geri_mstr gm ON r1.geri_code = gm.geri_code
WHERE r1.gcn_seqno = :gcnSeqNo
ORDER BY gm.geri_desc
            ",
            ['gcnSeqNo' => $gcnSeqNo]
        );
        return view('app.fdb-pg.fdb-geriatric-precautions', compact('precautions'));
    }

    public function indications(Request $request)
    {
        $gcnSeqNo = $request->input('gcn-seq-no') ? trim($request->input('gcn-seq-no')) : '';
        if (empty($gcnSeqNo)) return '';
        $indications = DB::connection('pgsql_fdb')->select("
SELECT r1.indcts, r2.indcts_sn, r2.indcts_lbl, r2.dxid, r2.proxy_ind, r3.dxid_desc56
FROM rindmgc0_indcts_gcnseqno_link r1 
    JOIN rindmma2_indcts_mstr r2 ON r1.indcts = r2.indcts
    JOIN rfmldx0_dxid r3 ON r2.dxid = r3.dxid
WHERE r1.gcn_seqno = :gcnSeqNo
ORDER BY r3.dxid_desc56
            ",
            ['gcnSeqNo' => $gcnSeqNo]
        );
        return view('app.fdb-pg.fdb-indications', compact('indications'));
    }

    public function contraindications(Request $request)
    {
        $routedMedID = $request->input('routed-med-id') ? trim($request->input('routed-med-id')) : '';
        if (empty($routedMedID)) return '';
        $contraindications = DB::connection('pgsql_fdb')->select("
SELECT r1.ddxcn, r2.dxid, r2.ddxcn_sl, r3.dxid_desc56
FROM rddcmrm0_routed_med_link r1 
    JOIN rddcmma1_contra_mstr r2 ON r1.ddxcn = r2.ddxcn
    JOIN rfmldx0_dxid r3 ON r2.dxid = r3.dxid
WHERE r1.routed_med_id = :routedMedID
ORDER BY r2.ddxcn_sl
            ",
            ['routedMedID' => $routedMedID]
        );
        return view('app.fdb-pg.fdb-contraindications', compact('contraindications'));
    }
}