|
Server IP : 103.191.208.50 / Your IP : 216.73.216.53 Web Server : LiteSpeed System : Linux orion.herosite.pro 4.18.0-553.53.1.lve.el8.x86_64 #1 SMP Wed May 28 17:01:02 UTC 2025 x86_64 User : celkcksm ( 1031) PHP Version : 7.4.33 Disable Function : show_source, system, shell_exec, passthru, popen, exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home/celkcksm/cms.ncriptech.com/app/Http/Controllers/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Models\HostelRoom;
class HostelController extends Controller
{
public function filterRoom(Request $request)
{
//
$data=$request->all();
$rooms = HostelRoom::where('hostel_id', $data['hostel'])->where('status', '1')->get();
$booked_rooms = array();
foreach($rooms as $room){
if($room->bed <= $room->hostelMembers->where('status', '1')->count()){
array_push($booked_rooms, $room->id);
}
}
$available_rooms = HostelRoom::where('hostel_id', $data['hostel'])->whereNotIn('id', $booked_rooms)->where('status', '1')->orderBy('name', 'asc')->get();
return response()->json($available_rooms);
}
}