<?php

namespace App\Http\Controllers;

use App\Models\Asuransi;
use App\Models\Pasien;
use App\Models\Pegawai;
use App\Models\Registrasi;
use App\Models\Ruang_pelayanan;
use Barryvdh\DomPDF\Facade\Pdf;
use Carbon\Carbon;
use Exception;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Yajra\DataTables\Facades\DataTables;

class RegistrasiNoAuthController extends Controller
{
    public function index()
    {
        $data['title'] = 'GUEST';
        return view('registrasi_no_auth.index', $data);
    }
    public function create_pasien()
    {
        //
        $data['title'] = 'PASIEN FORM';
        $data['asuransi'] = Asuransi::all();
        $data['pegawai'] = Pegawai::all();
        return view('registrasi_no_auth.create_pasien', $data);
    }

    public function create()
    {
        //
        $data['title'] = 'REGISTRASI FORM';
        $data['asuransi'] = Asuransi::all();
        $data['pegawai'] = Pegawai::all();
        return view('registrasi_no_auth.create', $data);
    }

    public function get_ruang_pelayanan_by_pegawai(Request $request)
    {
        $id = $request->ruang_id;
        $get_ruang_pelayanan = Ruang_pelayanan::findorFail($id);

        if ($get_ruang_pelayanan) {
            $data_return = [
                'status' => true,
                'data' => $get_ruang_pelayanan,
                'msg' => null
            ];
            return response()->json($data_return, 200);
        } else {
            $data_return = [
                'status' => false,
                'data' => null,
                'msg' => 'Data Not Found!'
            ];
            return response()->json($data_return, 404);
        }
    }

    public function get_data_by_nik(Request $request)
    {
        $nik = $request->nik;
        $get_data = Pasien::where('pasien_nik', $nik)->first();

        if ($get_data) {
            $data_return = [
                'status' => true,
                'data' => $get_data,
                'msg' => null
            ];
            return response()->json($data_return, 200);
        } else {
            $data_return = [
                'status' => false,
                'data' => null,
                'msg' => 'Data Not Found!'
            ];
            return response()->json($data_return, 404);
        }
    }

    /**
     * Store a newly created resource in storage.
     */
    public function store_pasien(Request $request)
    {
        //
        $nik = $request->nik;
        $name = $request->name;
        $tanggal_lahir = $request->tanggal_lahir;
        $jenis_kelamin = $request->jenis_kelamin;

        try {
            DB::beginTransaction();

            $insert = Pasien::create([
                'pasien_nik' => $nik,
                'pasien_name' => $name,
                'tanggal_lahir' => $tanggal_lahir,
                'jenis_kelamin' => $jenis_kelamin
            ]);

            DB::commit();
            $data_return = [
                'status' => true,
                'data' => null,
                'msg' => null
            ];
            return response()->json($data_return, 200);
        } catch (Exception $e) {
            DB::rollBack();
            // Handle the exception or log the error
            dd($e);
            $data_return = [
                'status' => false,
                'data' => null,
                'msg' => 'something wrong!!'
            ];
            return response()->json($data_return, 500);
        }
    }

    public function store(Request $request)
    {
        //
        $tanggal_berobat = $request->tanggal_berobat;
        $no_urut = 'RSHK'. Registrasi::where('registrasi_tanggal', $tanggal_berobat)->count() + 1;
        $pasien_id = $request->pasien_id;
        $asuransi_id = $request->asuransi_id;
        $asuransi_no = $request->asuransi_no ?? "";
        $pegawai_id = $request->pegawai_id;
        $ruang_pelayanan_id = $request->ruang_pelayanan_id;

        try {
            DB::beginTransaction();

            $insert = Registrasi::create([
                'nomor_urut' => $no_urut,
                'registrasi_tanggal' => $tanggal_berobat,
                'pasien_id' => $pasien_id,
                'asuransi_id' => $asuransi_id,
                'asuransi_no' => $asuransi_no,
                'pegawai_id' => $pegawai_id,
                'ruang_pelayanan_id' => $ruang_pelayanan_id,
                'status' => 0
            ]);

            DB::commit();
            $data_return = [
                'status' => true,
                'data' => $insert->id,
                'msg' => null
            ];
            return response()->json($data_return, 200);
        } catch (Exception $e) {
            DB::rollBack();
            // Handle the exception or log the error
            dd($e);
            $data_return = [
                'status' => false,
                'data' => null,
                'msg' => 'something wrong!!'
            ];
            return response()->json($data_return, 500);
        }
    }

    /**
     * Display the specified resource.
     */
    public function detail(string $id)
    {
        //
        $registrasi = Registrasi::select([
            'registrasis.id',
            'registrasis.nomor_urut',
            'registrasis.registrasi_tanggal',
            'pasiens.pasien_name',
            'asuransis.asuransi_name',
            'registrasis.asuransi_no',
            'pegawais.pegawai_name',
            'ruang_pelayanans.ruang_pelayanan_name',
            'registrasis.status'
        ])
        ->leftJoin('pasiens', 'pasiens.id', '=', 'registrasis.pasien_id')
        ->leftJoin('asuransis', 'asuransis.id', '=', 'registrasis.asuransi_id')
        ->leftJoin('pegawais', 'pegawais.id', '=', 'registrasis.pegawai_id')
        ->leftJoin('ruang_pelayanans', 'ruang_pelayanans.id', '=', 'registrasis.ruang_pelayanan_id')
        ->where('registrasis.id', $id)
        ->first();

        if($registrasi){
            $data['title'] = 'DETAIL REGISTRASI';
            $data['registrasi'] = $registrasi;

            return view('registrasi_no_auth.detail', $data);
        } else {
            abort(404);
        }
    }

    public function download_pdf($id)
    {
        $registrasi = Registrasi::select([
            'registrasis.id',
            'registrasis.nomor_urut',
            'registrasis.registrasi_tanggal',
            'pasiens.pasien_name',
            'asuransis.asuransi_name',
            'registrasis.asuransi_no',
            'pegawais.pegawai_name',
            'ruang_pelayanans.ruang_pelayanan_name',
            'registrasis.status'
        ])
        ->leftJoin('pasiens', 'pasiens.id', '=', 'registrasis.pasien_id')
        ->leftJoin('asuransis', 'asuransis.id', '=', 'registrasis.asuransi_id')
        ->leftJoin('pegawais', 'pegawais.id', '=', 'registrasis.pegawai_id')
        ->leftJoin('ruang_pelayanans', 'ruang_pelayanans.id', '=', 'registrasis.ruang_pelayanan_id')
        ->where('registrasis.id', $id)
        ->first();

        if($registrasi){
            $registrasi_update = Registrasi::findorFail($id);
            $registrasi_update->update([
                'status' => 1
            ]);

            $data['registrasi'] = $registrasi;
            // Render view to PDF
            $pdf = Pdf::loadView('registrasi_no_auth.pdf', $data);
            return $pdf->stream('registrasi_no_auth.pdf');
        } else {
            abort(404);
        }
    }

    /**
     * Show the form for editing the specified resource.
     */
    public function edit(string $id)
    {
        //
        $registrasi = Registrasi::select([
            'registrasis.id',
            'registrasis.nomor_urut',
            'registrasis.registrasi_tanggal',
            'registrasis.pasien_id',
            'pasiens.pasien_nik',
            'pasiens.pasien_name',
            'pasiens.tanggal_lahir',
            'pasiens.jenis_kelamin',
            'registrasis.asuransi_id',
            'asuransis.asuransi_name',
            'registrasis.asuransi_no',
            'registrasis.pegawai_id',
            'pegawais.pegawai_name',
            'registrasis.ruang_pelayanan_id',
            'ruang_pelayanans.ruang_pelayanan_name'
        ])
        ->leftJoin('pasiens', 'pasiens.id', '=', 'registrasis.pasien_id')
        ->leftJoin('asuransis', 'asuransis.id', '=', 'registrasis.asuransi_id')
        ->leftJoin('pegawais', 'pegawais.id', '=', 'registrasis.pegawai_id')
        ->leftJoin('ruang_pelayanans', 'ruang_pelayanans.id', '=', 'registrasis.ruang_pelayanan_id')
        ->where('registrasis.id', $id)
        ->first();

        if($registrasi){
            $data['title'] = 'EDIT REGISTRASI';
            $data['asuransi'] = Asuransi::all();
            $data['pegawai'] = Pegawai::all();
            $data['registrasi'] = $registrasi;

            return view('registrasi_no_auth.edit', $data);
        } else {
            abort(404);
        }
    }

    /**
     * Update the specified resource in storage.
     */
    public function update(Request $request)
    {
        //
        $id = $request->registrasi_id;
        $tanggal_berobat = $request->tanggal_berobat;
        $pasien_id = $request->pasien_id;
        $asuransi_id = $request->asuransi_id;
        $asuransi_no = $request->asuransi_no ?? "";
        $pegawai_id = $request->pegawai_id;
        $ruang_pelayanan_id = $request->ruang_pelayanan_id;

        $registrasi = Registrasi::findorFail($id);

        if (!$registrasi) {
            $data_return = [
                'status' => false,
                'data' => null,
                'msg' => 'Data Not Found!'
            ];
            return response()->json($data_return, 404);
        }

        try {
            DB::beginTransaction();

            $registrasi->update([
                'registrasi_tanggal' => $tanggal_berobat,
                'pasien_id' => $pasien_id,
                'asuransi_id' => $asuransi_id,
                'asuransi_no' => $asuransi_no,
                'pegawai_id' => $pegawai_id,
                'ruang_pelayanan_id' => $ruang_pelayanan_id
            ]);

            DB::commit();

            $data_return = [
                'status' => true,
                'data' => null,
                'msg' => null
            ];
            return response()->json($data_return, 200);
        } catch (Exception $e) {
            //throw $th;
            DB::rollBack();
            $data_return = [
                'status' => false,
                'data' => null,
                'msg' => 'something wrong!!',
                'msg_for_dev' => $e->getMessage()
            ];
            return response()->json($data_return, 500);
        }
    }

    /**
     * Remove the specified resource from storage.
     */
    public function destroy(Request $request)
    {
       
        //
        $id = $request->id;

        $registrasi = Registrasi::findorFail($id);

        if (!$registrasi) {
            $data_return = [
                'status' => false,
                'data' => null,
                'msg' => 'Data Not Found!'
            ];
            return response()->json($data_return, 404);
        }

        try {
            DB::beginTransaction();

            $registrasi->update(['status' => 4]);

            DB::commit();

            $data_return = [
                'status' => true,
                'data' => null,
                'msg' => null
            ];
            return response()->json($data_return, 200);
        } catch (Exception $e) {
            //throw $th;
            DB::rollBack();
            $data_return = [
                'status' => false,
                'data' => null,
                'msg' => 'something wrong!!',
                'msg_for_dev' => $e->getMessage()
            ];
            return response()->json($data_return, 500);
        }
    }
}