Closed

From now need to be done SQL query + javascript function few hours job

From now soon, 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.

Skills: JavaScript, jQuery / Prototype, MySQL, PHP, AJAX

See more: sql business days holidays, calculate working days between two dates in sql server, sql calculate working days between two dates excluding weekends and holidays, sql query to calculate working hours, datediff sql, sql add business days, sql working days in month, sql count number of days between two dates excluding weekends, write javascript function mysql query, call select sql javascript function, write sql query display job title employees manager, alfresco javascript sql query, backend query javascript sql form, need sql query, sql query builder javascript, javascript onchange sql query, sql query for fetch mails from the contact 7 , call javascript function from angular 4, sql query examples from multiple tables, ssis package does not run when called from a sql server agent job step

About the Employer:
( 3 reviews ) epinay, France

Project ID: #25548389

11 freelancers are bidding on average $35 for this job

webdesignexpert1

Hi,I build function in javascript that calculates a user home location based.I have extensive experience in photoshop,illustrator,psd to html,HTML, HTML5, XHTML, CSS3, JQuery, JavaScript, Angular Javascript, Bootstra More

$25 USD in 1 day
(22 Reviews)
5.7
renato0216

Hello! I've read your description and understood your requirements. I had vast experience of PHP, Ajax, jquery, Html, MySql etc. Hope to discuss about your task more detail via chat. Thanks regards. Renato.

$30 USD in 1 day
(47 Reviews)
5.1
kholmogorovadev

Hello, I have read and understood your project description. Can you clear more via chat. I have +7 years experience in website building and manage. Please no worries about your project. I am good to the skills such More

$30 USD in 7 days
(6 Reviews)
3.6
Joelatkins830

Hi Client. I am very interested in this project. I have a lot of experience in complex SQL. If you have any questions or concerns don't hesitate to let me know. I hope to hear from you. Best regards, Joel E. Atkins

$30 USD in 1 day
(4 Reviews)
3.5
lazarlyu

Hi. I have gone through all the details and I think I am the right person for this project. The budget is not important for me. I only want the good relationship with you This task is very easy for me because I have th More

$29 USD in 3 days
(6 Reviews)
3.4
Danishmehmood12

Hi, how could you tell me what you need, I have 7 years of experience in .net (c # and vb.net) with background processes (consoles, windows services), desktop applications ([login to view URL], WPF MVVM with PRISM) soap serv More

$20 USD in 1 day
(9 Reviews)
2.2
MostafElkady

Hello, I will be happy to help. I would like to chat with you to get more clarification about home location. Please let me know. Thank you

$30 USD in 2 days
(3 Reviews)
2.1
pyatakov71

⭐⭐⭐Thanks for your posting project⭐⭐⭐ Hello, I have been working as a professional PHP developer for 9 years and I've gained rich experience with it in other companies. Please review my portfolio if you have one sec. B More

$50 USD in 1 day
(4 Reviews)
1.8
greendeam1216

Hello, I am very proficient in JavaScript, PHP, mysql query and I can build the query for your requirements. So do you need me to calculate the location with. the parameters from database? As I have worked for big dat More

$100 USD in 7 days
(2 Reviews)
1.7
Manikproxx

I JUST READ YOUR DESCRIPTION AND I CAN DO THE PROJECT!! Hello I am a senior developer. I want to do it for you if you want. we can discuss more about this project. if you can send a reply. I waiting for you best respo More

$20 USD in 1 day
(0 Reviews)
0.0
marktwen2k20

Hi, how are you today? Thank you for your posting. I'm sure I can make the queries to implement your requirements. I'm ready to start work right now or your project, so feel free to contact me to discuss in detail. Lo More

$20 USD in 1 day
(0 Reviews)
0.0