Project 1 - Automated Scheduling System

The client approached us with the need to streamline and improve the efficiency of their job scheduling process. The primary goal was to reduce the manual effort involved in scheduling jobs while ensuring that client information could be managed with ease. To address these challenges, we developed an automated scheduling system with integrated route optimization.

Web App Interface

The approach to building the system was to create the UI as minimalistic as possible whilst providing all the required minimum viable functionality that was asked for.

MySQL Database Integration

This page provides functionality for managing client data in the scheduling system through integration of MySQL. It allows you to view, edit, delete, and add new client entries. The data is fetched from a backend server and displayed in a table format, with options for search and filtering.

Roster and Team Creation

The Roster Management and Scheduling System simplifies the scheduling process by automating job assignments and team management. It allows users to manage clients, create teams, assign tasks, and generate weekly schedules based on client availability. The system also supports importing/exporting rosters, real-time updates, and Excel exports for easy record-keeping.

Area Clustering API Integration

The Job Clustering and Location is designed to optimize job scheduling by clustering tasks based on geographical location, team availability, and utilises OpenCage API for the forward addressing. The system utilizes a map interface to visualize job locations and clusters, assigning jobs to teams with balanced workloads. Using geolocation and turf.js for clustering, the system ensures an efficient assignment of tasks, maximizing team productivity and minimizing travel time.

Roster Scheduling and Interactive Map

The Schedule Management optimizes job scheduling by dynamically managing teams and clients, integrating an initial location-based route optimization feature through RouteXL API, and offering a drag-and-drop interface for easy job management. This system allows users to assign jobs, view detailed schedules, and visualize job routes on an interactive map, ensuring efficient task distribution across teams.

Google Calendar Compatible Export

The Export to ICS functionality allows you to generate a fully compatible iCalendar file that can be imported into Google Calendar or any other calendar software. This ensures that there is no manual data entry required, provides accurate start and end times, client details, and location information.