flying-coders /
SIFIKS
| 1 | <?php |
||
| 2 | |||
| 3 | namespace App\Http\Controllers; |
||
| 4 | |||
| 5 | use App\Room; |
||
| 6 | use Illuminate\Support\Facades\DB; |
||
| 7 | use Illuminate\Http\Request; |
||
| 8 | use App\Hospital; |
||
| 9 | use App\City; |
||
| 10 | |||
| 11 | class HospitalController extends Controller |
||
| 12 | { |
||
| 13 | /** |
||
| 14 | * Display a listing of the resource. |
||
| 15 | * |
||
| 16 | * @return \Illuminate\Http\Response |
||
| 17 | */ |
||
| 18 | public function index() |
||
| 19 | { |
||
| 20 | $hospital = Hospital::orderBy('city_id','asc')->paginate(10); |
||
| 21 | $data = [ |
||
| 22 | 'role' => session('role'), |
||
| 23 | 'hospital' => $hospital |
||
| 24 | ]; |
||
| 25 | return view('pages.hospital')->with('data',$data); |
||
|
0 ignored issues
–
show
Bug
Best Practice
introduced
by
Loading history...
|
|||
| 26 | } |
||
| 27 | |||
| 28 | /** |
||
| 29 | * Show the form for creating a new resource. |
||
| 30 | * |
||
| 31 | * @return \Illuminate\Http\Response |
||
| 32 | */ |
||
| 33 | public function create() |
||
| 34 | { |
||
| 35 | $city_id = City::pluck('name', 'id'); |
||
| 36 | return view('pages.ext.add-hospital')->with('city_id', $city_id); |
||
|
0 ignored issues
–
show
|
|||
| 37 | } |
||
| 38 | |||
| 39 | /** |
||
| 40 | * Store a newly created resource in storage. |
||
| 41 | * |
||
| 42 | * @param Request $request |
||
| 43 | * @return \Illuminate\Http\RedirectResponse|\Illuminate\Routing\Redirector |
||
| 44 | * @throws \Illuminate\Validation\ValidationException |
||
| 45 | */ |
||
| 46 | public function store(Request $request) |
||
| 47 | { |
||
| 48 | $this->validate($request, [ |
||
| 49 | 'name'=>'required|min:3', |
||
| 50 | 'city_id'=>'required', |
||
| 51 | 'biography'=>'required', |
||
| 52 | 'address'=>'required|min:3', |
||
| 53 | 'medical_services'=>'required', |
||
| 54 | 'public_services'=>'required', |
||
| 55 | ]); |
||
| 56 | |||
| 57 | $hospital = new Hospital; |
||
| 58 | $hospital->name = $request->input('name'); |
||
| 59 | $hospital->city_id = $request->input('city_id'); |
||
| 60 | $hospital->biography = $request->input('biography'); |
||
| 61 | $hospital->address = $request->input('address'); |
||
| 62 | $hospital->medical_services = $request->input('medical_services'); |
||
| 63 | $hospital->public_services = $request->input('public_services'); |
||
| 64 | $hospital->cover_images_id = 1; |
||
| 65 | |||
| 66 | if($hospital->save()) { |
||
| 67 | return redirect (route('hospital.index'))->with('success', 'Rumah sakit berhasil di tambahkan !'); |
||
| 68 | } |
||
| 69 | |||
| 70 | return redirect (route('hospital.index'))->with('failed', 'Gagal menambahkan rumah sakit !'); |
||
| 71 | } |
||
| 72 | |||
| 73 | /** |
||
| 74 | * Display the specified resource. |
||
| 75 | * |
||
| 76 | * @param int $id |
||
| 77 | * @return \Illuminate\Http\Response |
||
| 78 | */ |
||
| 79 | public function show($id) |
||
| 80 | { |
||
| 81 | $hospital = Hospital::find($id); |
||
| 82 | if(!$hospital) { |
||
| 83 | abort(401); |
||
| 84 | } |
||
| 85 | $data = [ |
||
| 86 | 'hospital' => $hospital, |
||
| 87 | 'rooms' => $this->getRooms($id), |
||
| 88 | ]; |
||
| 89 | |||
| 90 | return view('pages.ext.view-hospital')->with('data', $data); |
||
|
0 ignored issues
–
show
|
|||
| 91 | } |
||
| 92 | |||
| 93 | /** |
||
| 94 | * Show the form for editing the specified resource. |
||
| 95 | * |
||
| 96 | * @param int $id |
||
| 97 | * @return \Illuminate\Http\Response |
||
| 98 | */ |
||
| 99 | public function edit($id) |
||
| 100 | { |
||
| 101 | $hospital = Hospital::find($id); |
||
| 102 | $city_id = City::pluck('name', 'id'); |
||
| 103 | $data = [ |
||
| 104 | 'role' => session('role'), |
||
| 105 | 'hospital' => $hospital, |
||
| 106 | 'city_id' => $city_id |
||
| 107 | ]; |
||
| 108 | return view('pages.ext.edit-hospital')->with('data', $data); |
||
|
0 ignored issues
–
show
|
|||
| 109 | } |
||
| 110 | |||
| 111 | /** |
||
| 112 | * Update the specified resource in storage. |
||
| 113 | * |
||
| 114 | * @param Request $request |
||
| 115 | * @param $id |
||
| 116 | * @return \Illuminate\Http\RedirectResponse|\Illuminate\Routing\Redirector |
||
| 117 | * @throws \Illuminate\Validation\ValidationException |
||
| 118 | */ |
||
| 119 | public function update(Request $request, $id) |
||
| 120 | { |
||
| 121 | $this->validate($request, [ |
||
| 122 | 'name'=>'required|min:3', |
||
| 123 | 'city_id'=>'required', |
||
| 124 | 'biography'=>'required', |
||
| 125 | 'address'=>'required|min:3', |
||
| 126 | 'medical_services'=>'required', |
||
| 127 | 'public_services'=>'required', |
||
| 128 | ]); |
||
| 129 | |||
| 130 | $hospital = Hospital::find($id); |
||
| 131 | $hospital->name = $request->input('name'); |
||
| 132 | $hospital->city_id = $request->input('city_id'); |
||
| 133 | $hospital->biography = $request->input('biography'); |
||
| 134 | $hospital->address = $request->input('address'); |
||
| 135 | $hospital->medical_services = $request->input('medical_services'); |
||
| 136 | $hospital->public_services = $request->input('public_services'); |
||
| 137 | $hospital->cover_images_id = 1; |
||
| 138 | |||
| 139 | if($hospital->save()) { |
||
| 140 | return redirect (route('hospital.index'))->with('success', 'Rumah sakit berhasil di perbaharui'); |
||
| 141 | } |
||
| 142 | |||
| 143 | return redirect (route('hospital.edit', $id))->with('failed', 'Gagal memperbaharui rumah sakit !'); |
||
| 144 | } |
||
| 145 | |||
| 146 | /** |
||
| 147 | * Remove the specified resource from storage. |
||
| 148 | * |
||
| 149 | * @param int $id |
||
| 150 | * @return \Illuminate\Http\Response |
||
| 151 | */ |
||
| 152 | public function destroy($id) |
||
| 153 | { |
||
| 154 | $hospital = Hospital::find($id); |
||
| 155 | $delrooms = $this->deleteRoomsAndRoomDetail($id); |
||
| 156 | |||
| 157 | if($delrooms){ |
||
| 158 | if($hospital->delete()) { |
||
| 159 | return redirect(route('hospital.index'))->with('success', 'Rumah sakit dihapus !'); |
||
|
0 ignored issues
–
show
|
|||
| 160 | } |
||
| 161 | return redirect(route('hospital.index'))->with('failed', 'Gagal menghapus rumah sakit !'); |
||
|
0 ignored issues
–
show
|
|||
| 162 | } |
||
| 163 | return redirect(route('hospital.index'))->with('failed', 'Error ! Telah terjadi kesalahan pada server !'); |
||
|
0 ignored issues
–
show
|
|||
| 164 | } |
||
| 165 | |||
| 166 | /** |
||
| 167 | * @param $hospital_id |
||
| 168 | * @return bool |
||
| 169 | */ |
||
| 170 | private function deleteRoomsAndRoomDetail($hospital_id) |
||
| 171 | { |
||
| 172 | $rooms = $this->getRooms($hospital_id); |
||
| 173 | $ids = $rooms->pluck('id')->toArray(); |
||
| 174 | if(count($ids) < 1) { |
||
| 175 | return true; |
||
| 176 | } |
||
| 177 | |||
| 178 | $delroom = Room::whereIn('id', $ids)->delete(); |
||
| 179 | $deldetail = DB::table('room_details') |
||
| 180 | ->where('hospital_id', '=', $hospital_id) |
||
| 181 | ->delete(); |
||
| 182 | |||
| 183 | if($delroom && $deldetail) { |
||
| 184 | return true; |
||
| 185 | } |
||
| 186 | |||
| 187 | return false; |
||
| 188 | } |
||
| 189 | |||
| 190 | /** |
||
| 191 | * @param $hospital_id |
||
| 192 | * @return \Illuminate\Support\Collection |
||
| 193 | */ |
||
| 194 | private function getRooms($hospital_id) |
||
| 195 | { |
||
| 196 | $rooms = DB::table('rooms') |
||
| 197 | ->selectRaw(DB::raw('rooms.*')) |
||
| 198 | ->leftJoin('room_details', 'rooms.id', '=', 'room_details.room_id') |
||
| 199 | ->where('room_details.hospital_id','=',$hospital_id) |
||
| 200 | ->get(); |
||
| 201 | |||
| 202 | return $rooms; |
||
| 203 | } |
||
| 204 | |||
| 205 | public function indexUser() |
||
| 206 | { |
||
| 207 | $location = City::orderBy('name','asc')->pluck('name', 'id'); |
||
| 208 | $img = 'storage/images/hospital-icon.jpg'; |
||
| 209 | $data = [ |
||
| 210 | 'img' => $img, |
||
| 211 | 'location' => $location |
||
| 212 | ]; |
||
| 213 | return view ('SearchRS')->with('data',$data); |
||
| 214 | } |
||
| 215 | |||
| 216 | public function showList() |
||
| 217 | { |
||
| 218 | return view('LSRumahSakit'); |
||
| 219 | } |
||
| 220 | |||
| 221 | public function searchHospital(Request $request) |
||
| 222 | { |
||
| 223 | if($request->nama == null AND $request->location != null){ |
||
| 224 | $hospital = Hospital::where('city_id',$request->location)->orderBy('name','asc')->paginate(5); |
||
| 225 | }elseif ($request->location == null AND $request->nama != null){ |
||
| 226 | $hospital = Hospital::where('biography','LIKE','%'.$request->nama.'%')->orderBy('name','asc')->paginate(5); |
||
| 227 | }else{ |
||
| 228 | $hospital = Hospital::where('biography','LIKE','%'.$request->nama.'%')->where('city_id',$request->location)->orderBy('name','asc')->paginate(5); |
||
| 229 | } |
||
| 230 | $location = City::orderBy('name','asc')->pluck('name','id'); |
||
| 231 | $data = [ |
||
| 232 | 'hospital' => $hospital, |
||
| 233 | 'location' => $location |
||
| 234 | ]; |
||
| 235 | return view ('listHospital')->with('data',$data); |
||
| 236 | } |
||
| 237 | |||
| 238 | public function searchContent($content) |
||
| 239 | { |
||
| 240 | $hospital = Hospital::where('biography','LIKE','%'.$content.'%')->orderBy('name','asc')->paginate(5); |
||
| 241 | $location = City::orderBy('name','asc')->pluck('name','id'); |
||
| 242 | $data = [ |
||
| 243 | 'hospital' => $hospital, |
||
| 244 | 'location' => $location |
||
| 245 | ]; |
||
| 246 | return view ('listHospital')->with('data',$data); |
||
| 247 | } |
||
| 248 | |||
| 249 | public function viewHospital($id) |
||
| 250 | { |
||
| 251 | $hospital = Hospital::find($id); |
||
| 252 | $data = [ |
||
| 253 | 'hospital' => $hospital, |
||
| 254 | 'room' => $this->getRooms($id), |
||
| 255 | ]; |
||
| 256 | return view ('viewhospital')->with('data',$data); |
||
| 257 | } |
||
| 258 | } |
||
| 259 |