Project Description
I need a compact, two-page web app that helps me stay on top of every vehicle-tracking permit and installation certificate we issue.
Page 1 – Dashboard
The landing page must pull live data and clearly show:
• Permit and certificate status for each vehicle, colour-coded so anything nearing or past expiry stands out.
• Total number of tracked vehicles, updating automatically as records are added or removed.
• Real-time notifications and alerts, with an obvious counter or banner for anything overdue.
Whenever a permit or certificate is about to expire—or has already done so—the dashboard should flag it immediately and trigger an automated WhatsApp message to the contact stored for that vehicle. I am happy to use the official WhatsApp Business Cloud API (or any compliant gateway you suggest) as long as messages reach the recipient reliably.
Page 2 – Certificate of Installation
This page stores and displays all details tied to a particular installation, including at minimum:
• Certificate No.
• Vehicle No.
• Chassis No.
I also need the flexibility to add other fields later (for example installer name, installation date, or custom notes), so keep the data model open for easy extensions.
Core requirements
• Clean, responsive interface so it works on desktop, tablet and mobile.
• Simple admin section or inline edit mode to create, update, or delete records.
• Secure database (MySQL, PostgreSQL, or similar) with clear table structure and migration files.
• Expiry logic that checks dates daily and fires WhatsApp alerts automatically.
• Source code delivered in a well-structured repository with brief setup instructions.
If you have experience integrating messaging APIs and can turn around a lightweight but reliable system quickly, I’d love to see your approach and timeframe.