# Hotel POS update — 4 November 2026

Base: POS_PRODUCTS_OPENING_STOCK_IMPORT_EXPORT(1).zip
Database reference: beygoxhc_jacaranda.sql

## Implemented in this update
- Products list page-size options: 20, 50, 100, 250, 500, 1,000 and All.
- Cashier route gate: users with the Cashier role are redirected to Open Shift before using other authenticated routes. Shift management routes remain accessible.
- POS menu products and search results now eager-load stock and show available quantity for stock-tracked products.
- Existing per-order-item remove/void controls are preserved.

## Database foundations added
- Optional feature flags for Butchery and Guest Rooms (both disabled by default).
- Butchery batch/wastage and sales tables; quantities stored in kg/grams.
- Guest room types, rooms and booking tables.
- Branch registry table.

## Important scope notes
The new database foundations are not a complete operational Butchery, Guest Room or multi-branch implementation yet. Branch-level data isolation, the five-branch enforcement/UI, room booking/check-in/check-out screens, butchery receiving/cutting/wastage/sales screens, and feature-toggle settings UI require further application work. They are not represented as finished features in this package.

## Installation
1. Back up files and database.
2. Deploy to a staging copy first.
3. Run `php artisan migrate` OR import `HOTEL_POS_OPTIONAL_MODULES_SQL.sql` in phpMyAdmin, not both.
4. Test cashier shift access, product pagination and stock quantities.
5. Do not deploy to production until the remaining module workflows and regression tests are completed.
