Find more Desktop Applications Remote Jobs posted recently Worldwide

Required Delphi,Google App Engine,sql freelancer for Route planner with database and Map. job

Posted at - Nov 6, 2017

We want to have the desktop application for plan our installer truck.
What the input :

Fix starting address for beginning

Scheduler database ( SQL database ), with the following data
1. ID : int ( as a record primary key )
2. Schedule_date : datetime
3. Schedule_Type : string (' Installation, measurement, other')
4. Installer_name : string
5. Time_slot : string , ('9.AM - 12.PM', '1.PM - 3.PM','3.PM - 5.PM','5.PM-7.PM' ,'Anytime')
6. Address: string (where they need to go , details address )
7. Route_Order : int ( still empty, will be filling after process )

Time slot capacity :
9.AM - 12.PM , 3 jobs
1.PM - 3.PM, 2 jobs
3.PM - 5.PM , 2 jobs
5.PM - 7.PM, 2 Jobs

Sample Data , inputdata.csv

What the output :

Fill in the [Route_Order] with the sequence, base on the following priority :
1. Time_Slot
2. Schedule_type
3. Nearest location. --> calculate the distance between the previous job and the next job.

If some slot_time only have 1 Job, then we need to take from the nearest another job with the time_slot is 'Anytime'.

show the map of their route planning and can print.
Can use google map to show also.

Output data expected, Outputdata.csv

About the recuiterMember since Sep 4, 2017 Andrei Ivanov
from Sankt-Peterburg, Russia

Skills & Expertise Required

Delphi Google App Engine sql 

Candidate shortlisted and hiredHiring open till - Oct 26, 2018

Work from Anywhere
40 hrs / week
Fixed Type
Remote Job

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Apply on more work from home jobs posted in Desktop Applications category.