leftJoin('pasiens', 'pasiens.id', '=', 'registrasis.pasien_id') ->where('registrasis.registrasi_tanggal', date('Y-m-d')) ->where('registrasis.status', 1); if (session('role') != 1) { $registrasi->where('registrasis.pegawai_id', session('pegawai_id')); } return DataTables::of($registrasi) ->addColumn('action', function ($row) { return 'Periksa'; }) ->rawColumns(['action']) ->make(true); } /** * Show the form for creating a new resource. */ public function periksa(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'] = 'PERIKSA FORM'; $data['registrasi'] = $registrasi; $data['tindakan'] = Tindakan::all(); return view('dokter.periksa', $data); } else { abort(404); } } /** * Store a newly created resource in storage. */ public function store(Request $request) { // $tindakan_id = $request->tindakan; $pegawai_id = $request->pegawai_id; $registrasi_id = $request->registrasi_id; $tindakan_tambahan = $request->tindakan_tambahan; $catatan = $request->catatan; $registrasi = Registrasi::findorFail($registrasi_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' => 2]); $get_total = Tindakan::select([DB::raw('SUM(tarif) as total_tarif')])->whereIn('id', $tindakan_id)->first(); $insert = Transaksi::create([ 'registrasi_id' => $registrasi_id, 'catatan' => $catatan, 'pegawai_id' => $pegawai_id, 'tindakan_tarif_total' => $get_total->total_tarif ?? 0 ]); foreach ($tindakan_id as $value) { $get_tindakan = Tindakan::findorFail($value); TransaksiDetail::create([ 'transaksi_id' => $insert->id, 'tindakan_id' => $value, 'tarif' => $get_tindakan->tarif ?? 0 ]); } if($tindakan_tambahan == 1){ TransaksiDetail::create([ 'transaksi_id' => $insert->id, 'tindakan_id' => -1, 'tarif' => 0 ]); } 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); } } /** * Display the specified resource. */ public function show(string $id) { // } /** * Show the form for editing the specified resource. */ public function edit(string $id) { // } /** * Update the specified resource in storage. */ public function update(Request $request, string $id) { // } /** * Remove the specified resource from storage. */ public function destroy(string $id) { // } }