I need a website that uses the Google Maps API to displays Google Maps in full screen and visualizes data from the MySQL database on the map.
On the one hand there are employees (name, photo, maximum number of orders) and on the other hand the orders (icon with number of orders in this area). The orders can be assigned to the employees by drag and drop, simply drag the orders onto the employee. The number of jobs the employee has is updated live (example: 2/4 instead of 0/4 - 4 is the maximum orders he can have), furthermore a line is created from the job to the employee and a button (X) given the opportunity to disconnect this connection again.
This is just an idea, drag & drop would be great but do some clicks is also ok. The areas can also be highlighted in color instead of creating a line.
Existing database structure:
Employees = employeeID, name, geo-coordinates, maximum orders (data to show employees on the map)
Orders = orderID, geo-coordinates, number of orders (data to show orders on the map)
Work = EmployeeID, OrderID (each drag & drop action insert or delete data in this table)
Hi, Thank you for the Spec. I had a full review on your specification with clear idea about it. Relevant Skills and Experience i have done a lot of work in google maps api Proposed Milestones €100 EUR - Lets discuss