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


- 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.

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

Lihat lebih lanjut: 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

Tentang Pemberi kerja:
( 3 ulasan ) epinay, France

ID Proyek: #25548389

11 freelancer menawar dengan rata-rata $35 untuk pekerjaan ini


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 Lebih banyak

$25 USD dalam 1 hari
(22 Ulasan)

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 dalam 1 hari
(47 Ulasan)

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 Lebih banyak

$30 USD dalam 7 hari
(6 Ulasan)

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 dalam 1 hari
(4 Ulasan)

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 Lebih banyak

$29 USD dalam 3 hari
(6 Ulasan)

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 Lebih banyak

$20 USD dalam 1 hari
(9 Ulasan)

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 dalam 2 hari
(3 Ulasan)

⭐⭐⭐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 Lebih banyak

$50 USD dalam 1 hari
(4 Ulasan)

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 Lebih banyak

$100 USD dalam 7 hari
(2 Ulasan)

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 Lebih banyak

$20 USD dalam 1 hari
(0 Ulasan)

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 Lebih banyak

$20 USD dalam 1 hari
(0 Ulasan)