20) { $errors[] = "Table capacity must be between 1 and 20"; } // Check for duplicate table number if (empty($errors)) { try { $stmt = $pdo->prepare("SELECT table_id FROM branch_tables WHERE branch_id = :branch_id AND table_number = :table_number"); $stmt->execute([':branch_id' => $branch_id, ':table_number' => $table_number]); if ($stmt->fetch()) { $errors[] = "Table number '$table_number' already exists in this branch"; } } catch (PDOException $e) { $errors[] = "Error checking table existence: " . $e->getMessage(); } } // Insert new table if (empty($errors)) { try { $stmt = $pdo->prepare(" INSERT INTO branch_tables (branch_id, table_number, table_capacity, status) VALUES (:branch_id, :table_number, :table_capacity, :status) "); $stmt->execute([ ':branch_id' => $branch_id, ':table_number' => $table_number, ':table_capacity' => $table_capacity, ':status' => $status ]); $success = "Table '$table_number' added successfully!"; } catch (PDOException $e) { $errors[] = "Error adding table: " . $e->getMessage(); } } } elseif (isset($_POST['update_table'])) { // Update table $table_id = (int)$_POST['table_id']; $table_number = trim($_POST['table_number']); $table_capacity = (int)$_POST['table_capacity']; $status = $_POST['status']; // Validation if (empty($table_number)) { $errors[] = "Table number is required"; } if ($table_capacity < 1 || $table_capacity > 20) { $errors[] = "Table capacity must be between 1 and 20"; } // Check for duplicate table number (excluding current table) if (empty($errors)) { try { $stmt = $pdo->prepare(" SELECT table_id FROM branch_tables WHERE branch_id = :branch_id AND table_number = :table_number AND table_id != :table_id "); $stmt->execute([ ':branch_id' => $branch_id, ':table_number' => $table_number, ':table_id' => $table_id ]); if ($stmt->fetch()) { $errors[] = "Table number '$table_number' already exists in this branch"; } } catch (PDOException $e) { $errors[] = "Error checking table existence: " . $e->getMessage(); } } // Update table if (empty($errors)) { try { $stmt = $pdo->prepare(" UPDATE branch_tables SET table_number = :table_number, table_capacity = :table_capacity, status = :status WHERE table_id = :table_id AND branch_id = :branch_id "); $stmt->execute([ ':table_number' => $table_number, ':table_capacity' => $table_capacity, ':status' => $status, ':table_id' => $table_id, ':branch_id' => $branch_id ]); $success = "Table '$table_number' updated successfully!"; } catch (PDOException $e) { $errors[] = "Error updating table: " . $e->getMessage(); } } } elseif (isset($_POST['delete_table'])) { // Delete table $table_id = (int)$_POST['table_id']; // Check if table has active orders try { $stmt = $pdo->prepare(" SELECT COUNT(*) as order_count FROM orders WHERE branch_id = :branch_id AND table_number IN ( SELECT table_number FROM branch_tables WHERE table_id = :table_id ) AND status IN ('pending', 'processing') "); $stmt->execute([':branch_id' => $branch_id, ':table_id' => $table_id]); $result = $stmt->fetch(PDO::FETCH_ASSOC); if ($result['order_count'] > 0) { $errors[] = "Cannot delete table with active orders. Please complete or cancel orders first."; } else { // Delete table $stmt = $pdo->prepare("DELETE FROM branch_tables WHERE table_id = :table_id AND branch_id = :branch_id"); $stmt->execute([':table_id' => $table_id, ':branch_id' => $branch_id]); if ($stmt->rowCount() > 0) { $success = "Table deleted successfully!"; } else { $errors[] = "Table not found or you don't have permission to delete it"; } } } catch (PDOException $e) { $errors[] = "Error deleting table: " . $e->getMessage(); } } } // Fetch all tables for this branch try { $stmt = $pdo->prepare(" SELECT table_id, table_number, table_capacity, status, created_at FROM branch_tables WHERE branch_id = :branch_id ORDER BY CASE WHEN table_number REGEXP '^[0-9]+$' THEN CAST(table_number AS UNSIGNED) ELSE 999999 END, table_number "); $stmt->execute([':branch_id' => $branch_id]); $tables = $stmt->fetchAll(PDO::FETCH_ASSOC); } catch (PDOException $e) { $errors[] = "Error fetching tables: " . $e->getMessage(); } include './partials/layouts/layoutTop.php'; ?>
Table Management
Add New Table
Unique identifier for the table
Number of people the table can accommodate (1-20)
All Tables ()
No Tables Found

Start by adding your first table using the form on the left.

['class' => 'bg-success', 'text' => 'Available'], 'occupied' => ['class' => 'bg-danger', 'text' => 'Occupied'], 'reserved' => ['class' => 'bg-warning text-dark', 'text' => 'Reserved'], 'maintenance' => ['class' => 'bg-secondary', 'text' => 'Maintenance'] ]; ?>
Capacity: seats
Added:
['class' => 'bg-success', 'text' => 'Available'], 'occupied' => ['class' => 'bg-danger', 'text' => 'Occupied'], 'reserved' => ['class' => 'bg-warning text-dark', 'text' => 'Reserved'], 'maintenance' => ['class' => 'bg-secondary', 'text' => 'Maintenance'] ]; ?>
Table Number Capacity Status Created Actions
seats