376 lines
12 KiB
PHP
376 lines
12 KiB
PHP
<?php
|
|
|
|
namespace App\Http\Controllers;
|
|
|
|
use App\Models\Asuransi;
|
|
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 RegistrasiController extends Controller
|
|
{
|
|
/**
|
|
* Display a listing of the resource.
|
|
*/
|
|
public function index()
|
|
{
|
|
//
|
|
$data['title'] = 'registrasi';
|
|
return view('registrasi.index', $data);
|
|
}
|
|
|
|
public function get_list_table(Request $request)
|
|
{
|
|
$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');
|
|
|
|
return DataTables::of($registrasi)
|
|
->editColumn('registrasi_tanggal', function ($row) {
|
|
return Carbon::parse($row->registrasi_tanggal)->format('d-m-Y');
|
|
})
|
|
->editColumn('status', function ($row) {
|
|
$str = '';
|
|
if($row->status == 0){
|
|
$str = '<span class="badge badge-light-warning">Belum Print</span>';
|
|
} else if($row->status == 1){
|
|
$str = '<span class="badge badge-light-primary">Sudah Print</span>';
|
|
} else if($row->status == 2) {
|
|
$str = '<span class="badge badge-light-danger">Belum Bayar</span>';
|
|
} else if($row->status == 3){
|
|
$str = '<span class="badge badge-light-success">Sudah Bayar</span>';
|
|
} else if($row->status == 4) {
|
|
$str = '<span class="badge badge-light-danger">Batal</span>';
|
|
}
|
|
|
|
return $str;
|
|
})
|
|
->addColumn('action', function ($row) {
|
|
if($row->status == 0){
|
|
return '<a href="' . url('/registrasi/edit/' . $row->id) . '" class="btn btn-sm btn-primary edit" data-id="' . $row->id . '">Edit</a>
|
|
<a href="' . url('/registrasi/detail/' . $row->id) . '" class="btn btn-sm btn-secondary edit" data-id="' . $row->id . '">Detail</a>
|
|
<button class="btn btn-sm btn-danger" onclick="deleteData(' . $row->id . ')" data-id="' . $row->id . '">Void</button>';
|
|
} else {
|
|
return '<a href="' . url('/registrasi/detail/' . $row->id) . '" class="btn btn-sm btn-secondary edit" data-id="' . $row->id . '">Detail</a>';
|
|
}
|
|
})
|
|
->rawColumns(['action', 'status'])
|
|
->make(true);
|
|
}
|
|
|
|
/**
|
|
* Show the form for creating a new resource.
|
|
*/
|
|
public function create()
|
|
{
|
|
//
|
|
$data['title'] = 'REGISTRASI FORM';
|
|
$data['asuransi'] = Asuransi::all();
|
|
$data['pegawai'] = Pegawai::all();
|
|
return view('registrasi.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);
|
|
}
|
|
}
|
|
|
|
/**
|
|
* Store a newly created resource in storage.
|
|
*/
|
|
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.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.pdf', $data);
|
|
return $pdf->stream('registrasi.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.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);
|
|
}
|
|
}
|
|
}
|