This project is a web-based Travel Agency Management System built using Laravel and MySQL.
It helps travel agencies manage all their daily operations in one place — from clients and flight tickets to invoices, receipts, guest files, and financial accounts.
The system includes many modules, each handling a specific part of the business:
---
Main Features
1. Accountant Module
Manages the chart of accounts (financial structure).
Users can add, edit, delete, and view accounts with a clear hierarchy.
2. Airline Module
Stores all airline information (code, name, symbol) and allows adding, editing, and deleting airline records.
3. Client Module
Manages client data—individuals or companies.
Includes phone & email validation, filtering, search, and viewing full client history.
4. Flight Ticket Module
Handles flight ticket creation, pricing, transits, filtering, printing, and prevents editing tickets that are already invoiced.
5. Guest File Module
Creates and manages guest files for Hajj, Umrah, Tourism, Visas, etc.
Tracks passengers, dates, approval/closing, and shows dashboard charts.
6. Transaction Module
Records financial transactions (in/out) for each guest file.
Maintains a running balance, supports file uploads, and prints bills.
7. Invoice Module
Generates invoices from selected tickets.
Auto-calculates VAT, totals, invoice codes, and supports printing in Arabic & English.
8. Receipt Module
Creates receipts for income/expenses.
Links them automatically to the correct account (guest files or flight invoices).
Supports approval, rejection, and printing.
9. Profile Module
Allows users to view and update their profile or delete their account securely.
10. Settings Module
Stores company information, logo, contact details, and supports bilingual data.
---
Security & Technical Details
Role-based permissions for every module
SQL injection & XSS protection
CSRF protection
Fast performance requirements
Daily backup and high reliability
Bilingual UI (Arabic & English)
---
Database
Includes tables for:
Accounts, Airlines, Clients, Tickets, Invoices, Guest Files, Transactions, Receipts, and Settings — all connected with clear relationships.
---
Business Rules
VAT fixed at 14%
Only closed guest files can be approved
Tickets must belong to the same client to create an invoice
Validations for phone, email, account codes, and dates
