ROUTES
434:        Route::get('live-tables', [Restaurant\LiveTableController::class, 'index']);
435:        Route::post('live-tables/{id}/persons', [Restaurant\LiveTableController::class, 'updatePersons']);
436:        Route::get('live-tables/{id}/availability', [Restaurant\LiveTableController::class, 'availability']);
437:        Route::post('live-tables/{id}/status', [Restaurant\LiveTableController::class, 'updateStatus']);
CONTROLLER
     1	<?php
     2	
     3	namespace App\Http\Controllers\Restaurant;
     4	
     5	use App\Restaurant\ResFloor;
     6	use App\Restaurant\ResTable;
     7	use App\Transaction;
     8	use App\User;
     9	use App\Utils\ModuleUtil;
    10	use Illuminate\Http\Request;
    11	use Illuminate\Routing\Controller;
    12	
    13	class LiveTableController extends Controller
    14	{
    15	    public function index(Request $request)
    16	    {
    17	        if (!app(ModuleUtil::class)->isModuleEnabled('live_tables')) {
    18	            abort(403, 'Live Tables module is disabled.');
    19	        }
    20	
    21	        if (!auth()->user()->can('access_tables')) {
    22	            abort(403, 'Unauthorized action.');
    23	        }
    24	
    25	        $business_id = $request->session()->get('user.business_id');
    26	        $location_id = $request->get('location_id');
    27	        $floor_id = $request->get('floor_id');
    28	
    29	        $floors = ResFloor::where('business_id', $business_id)
    30	            ->where('is_active', 1)
    31	            ->when($location_id, function ($query) use ($location_id) {
    32	                $query->where('location_id', $location_id);
    33	            })
    34	            ->orderBy('name')
    35	            ->get();
    36	
    37	        $tables = ResTable::where('business_id', $business_id)
    38	            ->when($location_id, function ($query) use ($location_id) {
    39	                $query->where('location_id', $location_id);
    40	            })
    41	            ->when($floor_id, function ($query) use ($floor_id) {
    42	                $query->where('floor_id', $floor_id);
    43	            })
    44	            ->with('floor')
    45	            ->orderBy('floor_id')
    46	            ->orderBy('name')
    47	            ->get();
    48	
    49	        $table_ids = $tables->pluck('id');
    50	
    51	        /*
    52	         * Sirf draft/suspended bill table ko occupied rakhega.
    53	         * Final/Cash bill occupied nahi mana jayega.
    54	         */
    55	        $active_orders = Transaction::where('business_id', $business_id)
    56	            ->where('type', 'sell')
    57	            ->whereIn('res_table_id', $table_ids)
    58	            ->where('status', 'draft')
    59	            ->with('contact')
    60	            ->orderByDesc('transaction_date')
    61	            ->get()
    62	            ->groupBy('res_table_id')
    63	            ->map(function ($orders) {
    64	                return $orders->first();
    65	            });
    66	
    67	        /*
    68	         * Paid/final bill ke baad purana occupied flag clear karein.
    69	         */
    70	        $active_table_ids = $active_orders->keys()
    71	            ->map(function ($id) {
    72	                return (int) $id;
    73	            })
    74	            ->all();
    75	
    76	        foreach ($tables as $table) {
    77	            $table_id = (int) $table->id;
    78	
    79	            if (
    80	                $table->table_status === 'occupied'
    81	                && !in_array($table_id, $active_table_ids, true)
    82	            ) {
    83	                $table->table_status = 'available';
    84	                $table->current_persons = 0;
    85	                $table->save();
    86	            }
    87	        }
    88	
    89	        $waiter_ids = $active_orders
    90	            ->pluck('res_waiter_id')
    91	            ->filter();
    92	
    93	        $waiter_names = User::whereIn('id', $waiter_ids)
    94	            ->pluck('first_name', 'id');
    95	
    96	        return view('restaurant.live_tables.index', compact(
    97	            'floors',
    98	            'tables',
    99	            'active_orders',
   100	            'waiter_names',
   101	            'floor_id',
   102	            'location_id'
   103	        ));
   104	    }
   105	
   106	    public function updatePersons(Request $request, $id)
   107	    {
   108	        if (!app(ModuleUtil::class)->isModuleEnabled('live_tables')) {
   109	            abort(403, 'Live Tables module is disabled.');
   110	        }
   111	
   112	        if (!auth()->user()->can('access_tables')) {
   113	            abort(403, 'Unauthorized action.');
   114	        }
   115	
   116	        $business_id = $request->session()->get('user.business_id');
   117	
   118	        $table = ResTable::where('business_id', $business_id)
   119	            ->findOrFail($id);
   120	
   121	        $persons = (int) $request->input('persons', 0);
   122	        $persons = max(0, min($persons, (int) $table->seats));
   123	
   124	        $table->current_persons = $persons;
   125	        $table->table_status = $persons > 0
   126	            ? 'occupied'
   127	            : 'available';
   128	
   129	        $table->save();
   130	
   131	        return [
   132	            'success' => true,
   133	            'persons' => $persons,
   134	            'available' => max(0, $table->seats - $persons),
   135	        ];
   136	    }
   137	
   138	    public function availability(Request $request, $id)
   139	    {
   140	        if (!app(ModuleUtil::class)->isModuleEnabled('live_tables')) {
   141	            abort(403, 'Live Tables module is disabled.');
   142	        }
   143	
   144	        if (!auth()->user()->can('access_tables')) {
   145	            abort(403, 'Unauthorized action.');
   146	        }
   147	
   148	        $business_id = $request->session()->get('user.business_id');
   149	
   150	        $table = ResTable::where('business_id', $business_id)
   151	            ->findOrFail($id);
   152	
   153	        $current_transaction_id = $request->get('transaction_id');
   154	
   155	        /*
   156	         * Sirf draft transaction running order hai.
   157	         * Final/Cash transaction ko ignore kiya jayega.
   158	         */
   159	        $running_order = Transaction::where('business_id', $business_id)
   160	            ->where('type', 'sell')
   161	            ->where('res_table_id', $table->id)
   162	            ->where('status', 'draft')
   163	            ->when($current_transaction_id, function ($query, $transaction_id) {
   164	                $query->where('id', '!=', $transaction_id);
   165	            })
   166	            ->orderByDesc('transaction_date')
   167	            ->first();
   168	
   169	        /*
   170	         * Running draft order nahi hai to occupied table free karein.
   171	         */
   172	        if (
   173	            empty($running_order)
   174	            && $table->table_status === 'occupied'
   175	        ) {
   176	            $table->table_status = 'available';
   177	            $table->current_persons = 0;
   178	            $table->save();
   179	        }
   180	
   181	        $blocked_by_status = in_array(
   182	            $table->table_status,
   183	            ['cleaning', 'disabled'],
   184	            true
   185	        );
   186	
   187	        return [
   188	            'success' => true,
   189	            'occupied' => !empty($running_order) || $blocked_by_status,
   190	            'seats' => (int) $table->seats,
   191	            'persons' => (int) $table->current_persons,
   192	            'invoice_no' => !empty($running_order)
   193	                ? $running_order->invoice_no
   194	                : null,
   195	            'table_status' => $table->table_status,
   196	        ];
   197	    }
   198	
   199	    public function updateStatus(Request $request, $id)
   200	    {
   201	        if (!app(ModuleUtil::class)->isModuleEnabled('live_tables')) {
   202	            abort(403, 'Live Tables module is disabled.');
   203	        }
   204	
   205	        if (!auth()->user()->can('access_tables')) {
   206	            abort(403, 'Unauthorized action.');
   207	        }
   208	
   209	        $request->validate([
   210	            'table_status' => 'required|in:available,cleaning,disabled',
   211	        ]);
   212	
   213	        $business_id = $request->session()->get('user.business_id');
   214	
   215	        $table = ResTable::where('business_id', $business_id)
   216	            ->findOrFail($id);
   217	
   218	        $table->table_status = $request->input('table_status');
   219	
   220	        if ($table->table_status === 'available') {
   221	            $table->current_persons = 0;
   222	        }
   223	
   224	        $table->save();
   225	
   226	        return [
   227	            'success' => true,
   228	            'table_status' => $table->table_status,
   229	        ];
   230	    }
   231	}
VIEW
     1	@extends('layouts.app')
     2	@section('title', 'Live Tables')
     3	
     4	@section('content')
     5	<section class="content-header">
     6	    <h1 class="tw-text-xl md:tw-text-3xl tw-font-bold tw-text-black">
     7	        Live Tables <small>Floor-wise restaurant table status</small>
     8	    </h1>
     9	</section>
    10	
    11	<section class="content">
    12	
    13	    <div class="live-toolbar">
    14	        <a href="{{ action([\App\Http\Controllers\Restaurant\LiveTableController::class,'index']) }}"
    15	           class="floor-tab {{ empty($floor_id) ? 'active' : '' }}">
    16	            All Floors
    17	        </a>
    18	
    19	        @foreach($floors as $floor)
    20	            <a href="{{ action([\App\Http\Controllers\Restaurant\LiveTableController::class,'index'], ['floor_id'=>$floor->id]) }}"
    21	               class="floor-tab {{ (string)$floor_id === (string)$floor->id ? 'active' : '' }}">
    22	                {{ $floor->name }}
    23	            </a>
    24	        @endforeach
    25	
    26	        <a href="{{ action([\App\Http\Controllers\Restaurant\FloorController::class,'index']) }}"
    27	           class="btn btn-info pull-right">
    28	            <i class="fas fa-layer-group"></i> Manage Floors
    29	        </a>
    30	    </div>
    31	
    32	    <div class="status-legend">
    33	        <span class="dot available"></span> Available
    34	        <span class="dot occupied"></span> Occupied
    35	        <span class="dot cleaning"></span> Cleaning
    36	        <span class="dot disabled"></span> Disabled
    37	    </div>
    38	
    39	    {{-- OCCUPIED TABLE SEARCH --}}
    40	    <div class="occupied-search-box">
    41	        <div class="row">
    42	            <div class="col-md-6 col-sm-8 col-xs-12">
    43	                <div class="input-group">
    44	                    <span class="input-group-addon">
    45	                        <i class="fa fa-search"></i>
    46	                    </span>
    47	                    <input type="text"
    48	                           id="occupied_table_search"
    49	                           class="form-control input-lg"
    50	                           placeholder="Search occupied table / order / customer / waiter...">
    51	                    <span class="input-group-btn">
    52	                        <button type="button"
    53	                                id="clear_occupied_search"
    54	                                class="btn btn-default btn-lg"
    55	                                title="Clear Search">
    56	                            <i class="fa fa-times"></i>
    57	                        </button>
    58	                    </span>
    59	                </div>
    60	                <small class="text-muted">
    61	                    Search only filters occupied tables. Leave empty to show all tables.
    62	                </small>
    63	            </div>
    64	        </div>
    65	    </div>
    66	
    67	    <div id="occupied_search_no_result" class="alert alert-warning" style="display:none;">
    68	        <i class="fa fa-search"></i> No occupied table found for this search.
    69	    </div>
    70	
    71	    <div class="row" id="live_tables_grid">
    72	        @forelse($tables as $table)
    73	            @php
    74	                $order = $active_orders->get($table->id);
    75	                $status = $order ? 'occupied' : ($table->table_status ?: 'available');
    76	                $availableSeats = max(0, (int)$table->seats - (int)$table->current_persons);
    77	
    78	                $customerName = $order ? (optional($order->contact)->name ?: 'Walk-In') : '';
    79	                $customerMobile = $order ? (optional($order->contact)->mobile ?: '') : '';
    80	                $waiterName = $order ? ($waiter_names[$order->res_waiter_id] ?? '') : '';
    81	                $invoiceNo = $order ? ($order->invoice_no ?? '') : '';
    82	
    83	                $searchText = strtolower(
    84	                    ($table->name ?? '') . ' ' .
    85	                    (optional($table->floor)->name ?? '') . ' ' .
    86	                    $invoiceNo . ' ' .
    87	                    $customerName . ' ' .
    88	                    $customerMobile . ' ' .
    89	                    $waiterName
    90	                );
    91	            @endphp
    92	
    93	            <div class="col-lg-2 col-md-4 col-sm-6 live-table-wrapper"
    94	                 data-status="{{ $status }}"
    95	                 data-search="{{ $searchText }}">
    96	
    97	                <div class="live-table-card status-{{ $status }}"
    98	                     data-table-id="{{ $table->id }}">
    99	
   100	                    <div class="card-head">
   101	                        <div>
   102	                            <small>{{ optional($table->floor)->name ?: 'No Floor' }}</small>
   103	                            <h3>{{ $table->name }}</h3>
   104	                        </div>
   105	                        <span class="status-pill">{{ strtoupper($status) }}</span>
   106	                    </div>
   107	
   108	                    <div class="seat-row">
   109	                        <span>Total Seats <b>{{ $table->seats }}</b></span>
   110	                        <span>Persons <b class="persons-value">{{ $table->current_persons }}</b></span>
   111	                        <span>Available <b class="available-value">{{ $availableSeats }}</b></span>
   112	                    </div>
   113	
   114	                    @if($order)
   115	                        <div class="order-info">
   116	                            <div><b>Order:</b> {{ $order->invoice_no }}</div>
   117	                            <div><b>Customer:</b> {{ optional($order->contact)->name ?: 'Walk-In' }}</div>
   118	                            @if(!empty(optional($order->contact)->mobile))
   119	                                <div><b>Mobile:</b> {{ optional($order->contact)->mobile }}</div>
   120	                            @endif
   121	                            <div><b>Waiter:</b> {{ $waiter_names[$order->res_waiter_id] ?? '-' }}</div>
   122	                            <div><b>Time:</b> {{ @format_datetime($order->transaction_date) }}</div>
   123	                            <div><b>Total:</b> @format_currency($order->final_total)</div>
   124	                        </div>
   125	                    @else
   126	                        <div class="no-order">No running order</div>
   127	                    @endif
   128	
   129	                    <div class="person-control">
   130	                        <button type="button" class="person-minus">−</button>
   131	                        <input class="person-input"
   132	                               type="number"
   133	                               min="0"
   134	                               max="{{ $table->seats }}"
   135	                               value="{{ $table->current_persons }}">
   136	                        <button type="button" class="person-plus">+</button>
   137	                    </div>
   138	
   139	                    <div class="card-actions">
   140	                        @if($order)
   141	                            <a href="{{ action([\App\Http\Controllers\SellPosController::class,'edit'],$order->id) }}"
   142	                               class="btn btn-primary btn-sm">
   143	                                <i class="fa fa-edit"></i> Open Order
   144	                            </a>
   145	                        @else
   146	                            <a href="{{ action([\App\Http\Controllers\SellPosController::class,'create'], ['restaurant_order_type'=>'dine_in','res_table_id'=>$table->id]) }}"
   147	                               class="btn btn-success btn-sm">
   148	                                <i class="fa fa-plus"></i> New Order
   149	                            </a>
   150	                        @endif
   151	
   152	                        <select class="table-status-select form-control input-sm">
   153	                            <option value="available" {{ $table->table_status === 'available' ? 'selected' : '' }}>Available</option>
   154	                            <option value="cleaning" {{ $table->table_status === 'cleaning' ? 'selected' : '' }}>Cleaning</option>
   155	                            <option value="disabled" {{ $table->table_status === 'disabled' ? 'selected' : '' }}>Disabled</option>
   156	                        </select>
   157	                    </div>
   158	
   159	                </div>
   160	            </div>
   161	        @empty
   162	            <div class="col-md-12">
   163	                <div class="alert alert-info">
   164	                    No tables found. Add floors and tables first.
   165	                </div>
   166	            </div>
   167	        @endforelse
   168	    </div>
   169	
   170	</section>
   171	@endsection
   172	
   173	@section('css')
   174	<style>
   175	.live-toolbar{background:#fff;padding:14px;border-radius:10px;margin-bottom:12px}
   176	.floor-tab{display:inline-block;padding:11px 18px;margin:2px;background:#198754;color:#fff;border-radius:7px;font-weight:800}
   177	.floor-tab:hover,.floor-tab.active{background:#0d6efd;color:#fff}
   178	.status-legend{background:#fff;padding:10px 15px;margin-bottom:15px;border-radius:8px}
   179	.dot{display:inline-block;width:12px;height:12px;border-radius:50%;margin:0 5px 0 14px}
   180	.dot.available{background:#22c55e}
   181	.dot.occupied{background:#ef4444}
   182	.dot.cleaning{background:#f59e0b}
   183	.dot.disabled{background:#64748b}
   184	
   185	.occupied-search-box{
   186	    background:#fff;
   187	    padding:14px;
   188	    border-radius:10px;
   189	    margin-bottom:15px;
   190	    box-shadow:0 3px 10px rgba(0,0,0,.05)
   191	}
   192	.occupied-search-box .input-group-addon{
   193	    background:#fff;
   194	    font-size:18px
   195	}
   196	.occupied-search-box small{
   197	    display:block;
   198	    margin-top:6px
   199	}
   200	
   201	.live-table-card{background:#fff;border:2px solid #22c55e;border-radius:10px;padding:9px;margin-bottom:12px;box-shadow:0 4px 12px rgba(0,0,0,.08)}
   202	.status-occupied{border-color:#ef4444}
   203	.status-cleaning{border-color:#f59e0b}
   204	.status-disabled{border-color:#64748b;opacity:.75}
   205	.card-head{display:flex;justify-content:space-between;align-items:center}
   206	.card-head h3{margin:2px 0;font-size:17px;line-height:1.15;font-weight:900}
   207	.card-head small{font-size:10px}
   208	.status-pill{padding:4px 6px;border-radius:16px;background:#22c55e;color:#fff;font-size:9px;font-weight:900}
   209	.status-occupied .status-pill{background:#ef4444}
   210	.status-cleaning .status-pill{background:#f59e0b}
   211	.status-disabled .status-pill{background:#64748b}
   212	.seat-row{display:flex;justify-content:space-between;gap:4px;background:#f8fafc;padding:6px;margin:7px 0;border-radius:6px;font-size:10px}
   213	.order-info{min-height:105px;line-height:18px;font-size:12px;overflow-wrap:anywhere}
   214	.no-order{min-height:105px;display:flex;align-items:center;justify-content:center;color:#94a3b8;font-size:12px}
   215	.person-control{display:flex;margin-bottom:7px}
   216	.person-control button{width:32px;height:30px;background:#1e293b;color:#fff;border:0;font-size:16px}
   217	.person-input{width:46px;height:30px;text-align:center;border:1px solid #cbd5e1}
   218	.card-actions{display:flex;flex-direction:column;gap:6px}
   219	.card-actions .btn{width:100%;padding:5px 7px;font-size:11px}
   220	.table-status-select{width:100%;height:30px;margin-left:0;font-size:11px}
   221	</style>
   222	@endsection
   223	
   224	@section('javascript')
   225	<script>
   226	$(function(){
   227	
   228	    function savePersons(card){
   229	        var id = card.data('table-id');
   230	        var input = card.find('.person-input');
   231	
   232	        $.post('/modules/live-tables/' + id + '/persons', {
   233	            _token: $('meta[name="csrf-token"]').attr('content'),
   234	            persons: input.val()
   235	        }, function(r){
   236	            if(r.success){
   237	                card.find('.persons-value').text(r.persons);
   238	                card.find('.available-value').text(r.available);
   239	            }
   240	        });
   241	    }
   242	
   243	    $('.person-plus').click(function(){
   244	        var c = $(this).closest('.live-table-card');
   245	        var i = c.find('.person-input');
   246	        var m = parseInt(i.attr('max')) || 0;
   247	
   248	        i.val(Math.min(m, (parseInt(i.val()) || 0) + 1));
   249	        savePersons(c);
   250	    });
   251	
   252	    $('.person-minus').click(function(){
   253	        var c = $(this).closest('.live-table-card');
   254	        var i = c.find('.person-input');
   255	
   256	        i.val(Math.max(0, (parseInt(i.val()) || 0) - 1));
   257	        savePersons(c);
   258	    });
   259	
   260	    $('.person-input').change(function(){
   261	        savePersons($(this).closest('.live-table-card'));
   262	    });
   263	
   264	    $('.table-status-select').change(function(){
   265	        var c = $(this).closest('.live-table-card');
   266	
   267	        $.post('/modules/live-tables/' + c.data('table-id') + '/status', {
   268	            _token: $('meta[name="csrf-token"]').attr('content'),
   269	            table_status: $(this).val()
   270	        }, function(r){
   271	            if(r.success){
   272	                location.reload();
   273	            }
   274	        });
   275	    });
   276	
   277	    // =====================================================
   278	    // OCCUPIED TABLE SEARCH
   279	    // Empty search = all tables
   280	    // Typed search = occupied tables only
   281	    // Searches: table, floor, invoice, customer, mobile, waiter
   282	    // =====================================================
   283	    function filterOccupiedTables(){
   284	        var search = $.trim($('#occupied_table_search').val()).toLowerCase();
   285	        var found = 0;
   286	
   287	        $('.live-table-wrapper').each(function(){
   288	            var wrapper = $(this);
   289	
   290	            if(search === ''){
   291	                wrapper.show();
   292	                return;
   293	            }
   294	
   295	            if(wrapper.attr('data-status') !== 'occupied'){
   296	                wrapper.hide();
   297	                return;
   298	            }
   299	
   300	            var searchableText = (wrapper.attr('data-search') || '').toLowerCase();
   301	
   302	            if(searchableText.indexOf(search) !== -1){
   303	                wrapper.show();
   304	                found++;
   305	            } else {
   306	                wrapper.hide();
   307	            }
   308	        });
   309	
   310	        if(search !== '' && found === 0){
   311	            $('#occupied_search_no_result').show();
   312	        } else {
   313	            $('#occupied_search_no_result').hide();
   314	        }
   315	    }
   316	
   317	    $('#occupied_table_search').on('keyup input', filterOccupiedTables);
   318	
   319	    $('#clear_occupied_search').click(function(){
   320	        $('#occupied_table_search').val('');