public function createInformasiBed(Request $request)
        {
            $infoBed = new InformasiBed();
            $objSave = [
                'ruanganfk' => $request->input('ruanganfk'),
                'totalbed' => $request->input('totalbed'),
                'terisi' => $request->input('terisi'),
                'tersisa' => $request->input('totalbed') - $request->input('terisi'),
                'kelas_3_isi' => $request->input('kelas3terisi'),
                'kelas_3_kosong' => $request->input('kelas3kosong'),
                'kelas_2_isi' => $request->input('kelas2terisi'),
                'kelas_2_kosong' => $request->input('kelas2kosong'),
                'kelas_1_isi' => $request->input('kelas1terisi'),
                'kelas_1_kosong' => $request->input('kelas1kosong'),
                'vip_isi' => $request->input('kelasvipterisi'),
                'vip_kosong' => $request->input('kelasvipkosong'),
                'vvip_isi' => $request->input('kelasvvipterisi'),
                'vvip_kosong' => $request->input('kelasvvipkosong'),
                'icu_isi' => $request->input('icuterisi'),
                'icu_kosong' => $request->input('icukosong'),
                'iccu_isi' => $request->input('iccuterisi'),
                'iccu_kosong' => $request->input('iccukosong'),
                'nicu_isi' => $request->input('nicuterisi'),
                'nicu_kosong' => $request->input('nicukosong'),
                'picu_isi' => $request->input('picuterisi'),
                'picu_kosong' => $request->input('picukosong'),
                'ruang_isolasi_isi' => $request->input('ruangisolasiisi'),
                'ruang_isolasi_kosong' => $request->input('ruangisolasikosong'),
                'kdprofile' => 43,
                'statusenabled' => true,
                'norec' => $request->input('ruanganfk'),
            ];

                try {
                DB::beginTransaction();
                DB::table('informasibed_t')->insert($objSave);
                DB::commit();
                $transStatus = 'true';
            } catch (\Exception $e) {
                DB::rollback();
                $transStatus = 'false';
                $transMessage = "Simpan Info Bed Gagal!";
            }

            if ($transStatus == 'true') {
                $transMessage = "Simpan Bed Berhasil";
                DB::commit();
                $result = [
                    "status" => 201,
                    "message" => $transMessage,
                    "as" => 'ea@timp',
                ];
            } else {
                $transMessage = "Simpan Bed Gagal!!";
                $result = [
                    "status" => 400,
                    "message" => $transMessage,
                    "as" => 'ea@timp',
                ];
            }

            return $this->setStatusCode($result['status'])->respond($result, $transMessage);

            }
        
        public function editInformasiBed(Request $request)
        {
            $ruanganfk = $request['ruanganfk'];
            $infoBed = InformasiBed::where('ruanganfk', $ruanganfk)->first();
            if (!$infoBed) {
                //notip edror
                return $this->setStatusCode(400)->respond(['message' => '400'], 'TIDAK ADA DATA');
            } else {
            }

            $objSave = [
                'totalbed' => $request->input('totalbed'),
                'terisi' => $request->input('terisi'),
                'tersisa' => $request->input('totalbed') - $request->input('terisi'),
                'kelas_3_isi' => $request->input('kelas3terisi'),
                'kelas_3_kosong' => $request->input('kelas3kosong'),
                'kelas_2_isi' => $request->input('kelas2terisi'),
                'kelas_2_kosong' => $request->input('kelas2kosong'),
                'kelas_1_isi' => $request->input('kelas1terisi'),
                'kelas_1_kosong' => $request->input('kelas1kosong'),
                'vip_isi' => $request->input('kelasvipterisi'),
                'vip_kosong' => $request->input('kelasvipkosong'),
                'vvip_isi' => $request->input('kelasvvipterisi'),
                'vvip_kosong' => $request->input('kelasvvipkosong'),
                'icu_isi' => $request->input('icuterisi'),
                'icu_kosong' => $request->input('icukosong'),
                'iccu_isi' => $request->input('iccuterisi'),
                'iccu_kosong' => $request->input('iccukosong'),
                'nicu_isi' => $request->input('nicuterisi'),
                'nicu_kosong' => $request->input('nicukosong'),
                'picu_isi' => $request->input('picuterisi'),
                'picu_kosong' => $request->input('picukosong'),
                'ruang_isolasi_isi' => $request->input('ruangisolasiisi'),
                'ruang_isolasi_kosong' => $request->input('ruangisolasikosong'),
            ];

            try {
                DB::beginTransaction();
                DB::table('informasibed_t')
                    ->where('ruanganfk', $ruanganfk)
                    ->update($objSave);
                DB::commit();
                $transStatus = 'true';
            } catch (\Exception $e) {
                DB::rollback();
                $transStatus = 'false';
                $transMessage = "Simpan Gagal!";
            }

            if ($transStatus == 'true') {
                $transMessage = "Simpan Berhasil";
                DB::commit();
                $result = [
                    "status" => 201,
                    "message" => $transMessage,
                    "as" => 'ea@timp',
                ];
            } else {
                $transMessage = "Simpan Gagal!!";
                $result = [
                    "status" => 400,
                    "message" => $transMessage,
                    "as" => 'ea@timp',
                ];
            }

            return $this->setStatusCode($result['status'])->respond($result, $transMessage);
        }

        public function deleteInformasiBed(Request $request)
        {
            $ruanganfk = $request['ruanganfk'];

            try {
                DB::beginTransaction();
                
                $infoBed = InformasiBed::where('ruanganfk', $ruanganfk)->first();
                
                if (!$infoBed) {
                    $result = [
                        "status" => 404,
                        "message" => "Data tidak ditemukan",
                        "as" => 'ea@timp',
                    ];
                } else {
                    $infoBed->delete();
                    DB::commit();
                    $result = [
                        "status" => 200,
                        "message" => "Data berhasil dihapus",
                        "as" => 'ea@timp',
                    ];
                }
            } catch (\Exception $e) {
                DB::rollback();
                $result = [
                    "status" => 400,
                    "message" => "Gagal menghapus data",
                    "as" => 'ea@timp',
                ];
            }

            return $this->setStatusCode($result['status'])->respond($result, $result['message']);
        }

        public function getDetailInformasiBed()
        {
            try {
                //query
                $infoBed = DB::table('informasibed_t as ibt')
                    ->join('ruangan_m', 'ibt.ruanganfk', '=', 'ruangan_m.id')
                    ->select('ibt.*','ruangan_m.namaruangan')
                    ->get();

                // validasi apa ada tidak datanya
                if (!$infoBed) {
                    $result = [
                        "status" => 404,
                        "message" => "Data tidak ditemukan",
                        "as" => 'ea@timp',
                    ];
                } else {
                //kalo nyatanya ada maka tampung ke array
                $keseluruhanTotalBed = 0;
                $keseluruhanTerisi = 0;
                $sisaKeseluruhan = 0;
                $totalruangan = 0;
                $data = [];

                foreach ($infoBed as $item) {
                $keseluruhanTotalBed += $item->totalbed;
                $keseluruhanTerisi += $item->terisi; 
                $sisaKeseluruhan = $keseluruhanTotalBed - $keseluruhanTerisi;
                $data[] = [
                        "ruanganfk" => $item->ruanganfk,
                        "namaruangan" => $item->namaruangan,
                        "totalbed" => $item->totalbed,
                        "terisi" => $item->terisi,
                        "kelas_3_kosong" => ($item->kelas_3_kosong == null? 0 : $item->kelas_3_kosong),
                        "kelas_3_isi" => ($item->kelas_3_isi == null?0:$item->kelas_3_isi),
                        "kelas_2_kosong" => ($item->kelas_2_kosong == null?0:$item->kelas_2_kosong),
                        "kelas_2_isi" => ($item->kelas_2_isi == null?0:$item->kelas_2_isi),
                        "kelas_1_kosong" => ($item->kelas_1_kosong == null?0:$item->kelas_1_kosong),
                        "kelas_1_isi" =>($item->kelas_1_isi == null?0:$item->kelas_1_isi),
                        "vip_kosong" => ($item->vip_kosong == null?0:$item->vip_kosong),
                        "vip_isi" => ($item->vip_isi == null?0:$item->vip_isi),
                        "vvip_kosong" => ($item->vvip_kosong == null?0:$item->vvip_kosong),
                        "vvip_isi" => ($item->vvip_isi == null?0:$item->vvip_isi),
                        "icu_isi" => ($item->icu_isi == null?0:$item->icu_isi),
                        "icu_kosong" => ($item->icu_kosong == null?0:$item->icu_kosong),
                        "iccu_isi" => ($item->iccu_isi == null?0:$item->iccu_isi),
                        "iccu_kosong" => ($item->iccu_kosong == null?0:$item->iccu_kosong),
                        "nicu_isi" => ($item->nicu_isi == null?0:$item->nicu_isi),
                        "nicu_kosong" => ($item->nicu_kosong == null?0:$item->nicu_kosong),
                        "picu_isi" => ($item->picu_isi == null?0:$item->picu_isi),
                        "picu_kosong" => ($item->picu_kosong == null?0:$item->picu_kosong),
                        "ruang_isolasi_isi" => ($item->ruang_isolasi_isi == null?0:$item->ruang_isolasi_isi),
                        "ruang_isolasi_kosong" => ($item->ruang_isolasi_kosong == null?0:$item->ruang_isolasi_kosong),
                        "sisa" => $item->tersisa,
                    ];
                $totalruangan++;
                }
                //kirim ke frontend jika sudah
                $result = [
                        "status" => 200,
                        "message" => "Data ditemukan",
                        "data" => $data,
                        "totalKeseluruhanBed" => $keseluruhanTotalBed,
                        "totalTerisi" => $keseluruhanTerisi,
                        "sisaKeseluruhan" => $sisaKeseluruhan,
                        "totalruangan" => $totalruangan,
                        "as" => 'ea@timp',
                    ];
                }
                } catch (\Exception $e) {
                $result = [
                    "status" => 400,
                    "message" => "Gagal mengambil data",
                    "as" => 'ea@timp',
                ];
            }
            return $this->setStatusCode($result['status'])->respond($result, $result['message']);
        }