🐍 Python Property Management System (Hotel Reservation System)

[MrLoki28]

Baka may want ng Hotel Reservation System, ito na yung buong specs

User Roles

• Admin
• Staff
• Guest

Authentication and Security

• Login with email and password
• Guest registration
• Login verification flow
• Forgot-password and reset-password flow
• Admin re-authentication flow for sensitive actions
• CSRF protection on forms
• Password strength validation
• Session idle timeout
• Session max lifetime
• Optional strict admin IP binding
• Request throttling/rate limiting on sensitive flows

Main Functional Modules

• Operations dashboard
• Room management
• Room type management through seeded catalog
• Guest management
• Reservation management
• Online guest booking portal
• Check-in and checkout workflow
• Billing and folio management
• Guest payment proof submission
• Invoice and folio PDF generation
• Housekeeping management
• Maintenance management
• Inventory and room inventory management
• Notifications center
• Audit trail
• Reports and CSV exports
• Database backup, export, verify, and restore tools
• Calendar/day-booking operations view
• Transactions view

Reservation and Front Desk Coverage

• Create reservation
• Modify reservation
• Confirm pending booking
• Mark no-show
• Cancel reservation
• Check-in
• Checkout
• Guest booking history
• Availability search with date, time, adults, and children
• Booking source channels: Direct, Online, Agent, Corporate

Room and Operations Coverage

• Room status handling: available, occupied, maintenance
• Housekeeping status handling: clean, dirty, plus operational tracking states
• Active maintenance tracking per room
• Per-room inventory
• Room detail modal and operational action buttons
• Default seeded catalog: 6 room types and 10 rooms

Billing and Payment Coverage

• Charges, payments, discounts, adjustments, and service entries
• Billing entry actions and reversals
• Payment attachment/proof storage
• Guest payment methods configured: GCash, Maya, Bank transfer, Debit/Credit card
• Payment proof allowed file types: PNG, JPG, JPEG, WEBP, PDF
• Payment proof max size: 5 MB

Reports and Documents

• Invoice PDF
• Folio PDF
• Reservations CSV export
• Audit trail CSV export
• Housekeeping CSV export
• Occupancy report CSV export
• Payment methods report CSV export
• Room-type revenue CSV export

Database Design

• Backend database: single local SQLite file
• Core table count: 18
• Main tables:
• users
• reservations
• rooms
• room_types
• room_images
• billing
• housekeeping_tasks
• maintenance_logs
• inventory_items
• room_inventory
• inventory_logs
• notifications
• audit_logs
• auth_login_throttle
• auth_login_challenges
• auth_password_resets
• auth_user_sessions
• card_tokens

System Admin and Data Safety

• Automatic local backup support
• Database export/dump support
• Database restore support
• Integrity/readiness checks
• Backup retention
• Export retention
• Logs stored locally
• Payment proofs stored locally

 

[LinkMe]

Solid, patikim naman hahah

 

[MrLoki28]

Solid, patikim naman hahah

PM lang po if need nyo po

 

[mr-yuso]

Pamigay to sir?

 

[MrLoki28]

Pamigay to sir?

May bayad po pero di malaki

 

[Fallen24]

wow, nice one ts