# JA Square Parcel Booking & Tracking System

A modern, Bootstrap 5-based logistics management system designed for efficient parcel booking, real-time status updates, and public tracking.

## 🚀 Quick Setup
1. **Database Configuration**: Ensure your MySQL server is running.
2. **Environment Sync**: The system uses `jasquare_ai` as the default database with a `parcel_` table prefix.
3. **Initialization**: Run the automated setup script in your browser:
`http://localhost/Parcel_Booking_And_Tracking_System/db_setup.php`
4. **Default Credentials**:
- **Username**: `admin`
- **Password**: `admin123`

## 📂 Project Structure
- `header.php`: Global navigation and GitHub-style dark theme sidebar.
- `footer.php`: Global scripts and layout closing tags.
- `db_connection.php`: Centralized PDO/MySQLi connection using `$prefix`.
- `db_setup.php`: Automated database, table, and seed data creator.
- `settings.php`: Business identity management with real-time live preview.
- `dashboard.php`: Overview of logistics statistics.
- `booking.php`: Parcel entry and tracking ID generation.

## 🛠 Technical Specifications
- **Framework**: Bootstrap 5.3.0 (Dark Mode)
- **Icons**: FontAwesome 6.4.0
- **Backend**: PHP 8.x + MySQLi
- **Prefixing**: All tables are prefixed with `parcel_` for security and organization.

---

## 📝 Change Log

### [2025-12-19 14:30] - Initial System Architecture
- **Header Update**: Standardized `header.php` with branding and session-based operator display.
- **Database Schema**: Established `jasquare_ai` database structure.
- **Tables Created**:
- `parcel_users`: User authentication and roles.
- `parcel_shipments`: Core parcel data.
- `parcel_settings`: Global business parameters (Company name, contact, etc.).
- `parcel_tracking_updates`: Historical logs for shipment movement.
- **Settings Module**: Developed `settings.php` with a JavaScript-powered live preview snippet that updates as the operator types.
- **Setup Utility**: Created `db_setup.php` for one-click environment deployment and data seeding.

---
*Authored by Salim Nazir | Powered by JA Square*