Ubuntu Connect

DB Integration

Project: Website Development

$200.00 1 day Qty 2

About this role

Project Type: Programming
Experience Level: Expert

Scope & Deliverables:
Design DB structure and add tables

Responsibilities:
Manage DB

Required Skills:
Mysql, PHPMyAdmin

Timeline:
1 day

Duration:
1 day

Quantity:
2

Screening Question:
how long have you been working with Apache

Project context

Project deadline 2026-06-30
Open Sands Safaris Website Development
This scope outlines the functional and design requirements for the Open Sands Safaris digital platform. The goal is to create a high-end, conversion-optimized presence that streamlines the booking process from initial inquiry to automated itinerary generation.

1. Visual Design & User Experience (UX)

The website will feature a "Clean Design" aesthetic, prioritizing high-resolution imagery of the Okavango Delta and surrounding regions while maintaining a professional, uncluttered interface.

Responsive Design: Fully optimized for mobile, tablet, and desktop.

Minimalist Interface: Use of whitespace, elegant typography, and a natural color palette (earthy tones, sands, and sky blues).

Interactive Media: Support for full-width hero videos and masonry-style photo galleries to showcase lodge interiors and wildlife.

2. Content Management System (CMS)

A robust backend allowing the Open Sands team to manage site content without technical knowledge.

Page Management: Ability to create, edit, or delete pages (e.g., About Us, Safari Packages, Conservation).

Media Library: Centralized hub for managing high-quality images and video assets.

Blog/News Module: For SEO-rich updates on wildlife sightings, travel tips, and company news.

User Roles: Multiple permission levels (e.g., Administrator, Editor).

3. Advanced RFQ & Automated Itinerary Planner

This is the core functional engine of the site, designed to reduce manual admin time.

Dynamic RFQ Form: A multi-step form collecting traveler details, dates, guest count, and specific interests (e.g., photography, birding, luxury).

Itinerary Logic: A logic-based system where users select specific camps or activities to "build" a rough trip.

Automated Quote Drafting:

Generates a PDF or Digital Proposal based on selected inputs.

Includes a preliminary cost estimate (standard vs. luxury rates).

Suggested Addition: Integration with a live currency converter (BWP/USD/EUR).

Email Automation: Instant delivery of the draft itinerary to the user, with a blind copy (BCC) sent to the sales team for follow-up.

4. Availability Calendar & Booking Management

A visual tool to manage the logistics of safari tours and vehicle/guide availability.

Live Availability: A front-end calendar showing "Available," "Limited," or "Sold Out" dates for specific safari packages.

Internal Booking Dashboard: A backend view for staff to manually block out dates or confirm incoming requests.

Suggested Addition: iCal/Google Calendar Integration to sync bookings across external platforms or with lodge partners.

5. Standard Functional Features

Contact Form: A simple, direct inquiry form with CAPTCHA protection.

Social Media Integration: Live feeds (Instagram) and sharing buttons to leverage visual content.

SEO Setup: Schema markup for travel agencies, meta-tag optimization, and Google Analytics 4 integration.

Suggested Enhancements

To further elevate the platform, I recommend considering:

Client Portal: A secure area where booked guests can upload passport copies, sign indemnity forms, and view their final travel vouchers.

Interactive Map: A custom-coded map showing the locations of the camps and the typical travel routes between them.

WhatsApp Integration: A floating chat widget for real-time inquiries, which is highly effective for the Southern African travel market.