SQL query + javascript function
$10-30 USD
Paid on delivery
NOTE: Your bid is final. Don't bid if you want to negotiate price.
Timing: This project needs to be executed in 1 day.
I'm looking for a SQL Query set of queries + a javascript function to calculate user's home location:
A database includes rows with the following columns (realnames, will be given after the project):
Table locations
- latitude, longitude
- timestamp
Table activity
- stationary: true/false
- timestamp
Table event
- charging: true / false
- timestamp
Table wifi
- SSID
- timestamp
I need a function in javascript that calculates a user home location based on the following rules:
- stationary in the same place (or with a radius of 300m)
- 5 days in a row in the last 10 days window
- during at least 5 hours in row between 9pm and 6am
- there's at least one a day (on the 5 mentioned days) a charging TRUE event during the period at the location
- there's at least one a day (on the 5 mentioned days) the SSID is the same during the mentioned period
Please consider that the queries results will be passed to the javascript and you would need to iterate over the data structure to get to the result.
Project ID: #25500742
About the project
2 freelancers are bidding on average $25 for this job
Dear client How are you? i am hoping you and your are safe from covid-19. i am web expert with over 6 years experience in web development. Upon reading your project description this seems like a task which i can start More
Hello. I can make it with datatables My Skills: PHP , JS, MYSQL, codeigniter, Wordpress, Opencart and other