Project Overview We currently manage our yacht inventory through an internal Excel file that includes up-to-date availability dates, pricing, capacities, ports, and other key details. When preparing offers, our team manually extracts data from this file and creates quotation emails. We want to transform this workflow into a secure, internal web-based backend system that will only be accessible to company staff. The system will serve as a centralized yacht database with availability management, advanced filtering, and automated quotation email generation. This is not a public-facing website, but a staff-only admin panel/backend tool integrated into our existing website environment. Project Goals Replace Excel-based workflow with a structured backend system Manage yacht data, pricing, and availability via an admin panel Search and filter yachts based on date and multiple criteria Automatically generate professional quotation email drafts Core Features & Requirements 1) User Authentication & Access Control Secure login system Staff-only access (no public users) Role-based permissions (Admin / Staff) User management (create, edit, deactivate users) 2) Yacht Database Management Each yacht record should include at least the following fields: Yacht name Yacht type (gulet, motor yacht, sailing yacht, catamaran, trawler, etc.) Number of cabins Guest capacity Home port / embarkation port (and optional alternative ports) Central Agency status (CA / non-CA) Central agency notes Contact phone number Contact email Internal notes / special conditions Full CRUD functionality (create, edit, delete, duplicate yachts). 3) Pricing Module Monthly pricing structure (e.g. May–October) Price type (weekly / nightly) Currency support Optional season labels (Low / Mid / High Season) Easy editing and clear overview per yacht 4) Availability Calendar Yacht-based calendar view Status types: Available / Booked / Option / Maintenance Date range selection (start–end) Visual calendar interface Ability to quickly block or free dates Optional notes per booking/block 5) Advanced Search & Filtering Engine Search yachts based on: Date range (availability check) Guest capacity Number of cabins Port / embarkation location Yacht type Price range Central agency status Results should show: Matching yachts only Clear availability indication Key summary info for fast comparison 6) Quotation Email Generator Select one or multiple yachts from search results Auto-generate a structured quotation email draft including: Yacht name Dates Price Capacity & cabins Port Notes Editable before sending Copy-to-clipboard and/or downloadable format (PDF or text) Email sending itself can be optional (draft generation is mandatory) 7) Admin Panel & UX Clean, fast, and intuitive backend UI Optimized for daily operational use Desktop-first (mobile responsiveness is a plus) Technical Expectations Backend-focused solution (framework open to suggestion) Secure authentication and data handling Scalable database structure Clean, well-documented code Ability to migrate/import existing Excel data (CSV import is sufficient) Deliverables Fully functional backend system Admin panel with all modules listed above Deployment-ready version on our server or staging environment Basic documentation (setup + usage) Nice to Have (Optional) Excel/CSV import & export Activity logs (who changed what & when) Future API readiness for possible CRM/website integration