API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 24th, 2019
70
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.52 KB | None | 0 0
raw download clone embed print report
  1. //msg is result from sql query
  2. var msg = '[{"SENSOR_ID": 0, "LAT": 58.39845, "LONG": 15.57773, "DATA_TYPE": "battery", "VALUE": 25, "DATE": 1563785582471, "OBJECT_ID": "0", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 0, "LAT": 58.39845, "LONG": 15.57773, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582471, "OBJECT_ID": "1", "TYPE": "car", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 0, "LAT": 58.39845, "LONG": 15.57773, "DATA_TYPE": "gsr", "VALUE": 50, "DATE": 1563785582471, "OBJECT_ID": "2", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 0, "LAT": 58.39845, "LONG": 15.57773, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582471, "OBJECT_ID": "3", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 0, "LAT": 58.39845, "LONG": 15.57773, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582471, "OBJECT_ID": "4", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 1, "LAT": 58.39422, "LONG": 15.57777, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785581249, "OBJECT_ID": "0", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 1, "LAT": 58.39422, "LONG": 15.57777, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785581249, "OBJECT_ID": "1", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 1, "LAT": 58.39422, "LONG": 15.57777, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785581249, "OBJECT_ID": "2", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 1, "LAT": 58.39422, "LONG": 15.57777, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785581249, "OBJECT_ID": "3", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 1, "LAT": 58.39422, "LONG": 15.57777, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785581249, "OBJECT_ID": "4", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 2, "LAT": 58.4049, "LONG": 15.5762, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785581554, "OBJECT_ID": "0", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 2, "LAT": 58.4049, "LONG": 15.5762, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785581554, "OBJECT_ID": "1", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 2, "LAT": 58.4049, "LONG": 15.5762, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785581554, "OBJECT_ID": "2", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 2, "LAT": 58.4049, "LONG": 15.5762, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785581554, "OBJECT_ID": "3", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 2, "LAT": 58.4049, "LONG": 15.5762, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785581554, "OBJECT_ID": "4", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 3, "LAT": 58.40372, "LONG": 15.57202, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582165, "OBJECT_ID": "0", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 3, "LAT": 58.40372, "LONG": 15.57202, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582165, "OBJECT_ID": "1", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 3, "LAT": 58.40372, "LONG": 15.57202, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582165, "OBJECT_ID": "2", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 3, "LAT": 58.40372, "LONG": 15.57202, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582165, "OBJECT_ID": "3", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 3, "LAT": 58.40372, "LONG": 15.57202, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582165, "OBJECT_ID": "4", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 4, "LAT": 58.39877, "LONG": 15.57668, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785583094, "OBJECT_ID": "0", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 4, "LAT": 58.39877, "LONG": 15.57668, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785583094, "OBJECT_ID": "1", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 4, "LAT": 58.39877, "LONG": 15.57668, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785583094, "OBJECT_ID": "2", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 4, "LAT": 58.39877, "LONG": 15.57668, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785583094, "OBJECT_ID": "3", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 4, "LAT": 58.39877, "LONG": 15.57668, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785583094, "OBJECT_ID": "4", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 5, "LAT": 58.40502, "LONG": 15.58131, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582788, "OBJECT_ID": "0", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 5, "LAT": 58.40502, "LONG": 15.58131, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582788, "OBJECT_ID": "1", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 5, "LAT": 58.40502, "LONG": 15.58131, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582788, "OBJECT_ID": "2", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 5, "LAT": 58.40502, "LONG": 15.58131, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582788, "OBJECT_ID": "3", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 5, "LAT": 58.40502, "LONG": 15.58131, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582788, "OBJECT_ID": "4", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 6, "LAT": 58.40693, "LONG": 15.58172, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785583299, "OBJECT_ID": "0", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 6, "LAT": 58.40693, "LONG": 15.58172, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785583299, "OBJECT_ID": "1", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 6, "LAT": 58.40693, "LONG": 15.58172, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785583299, "OBJECT_ID": "2", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 6, "LAT": 58.40693, "LONG": 15.58172, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785583299, "OBJECT_ID": "3", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 6, "LAT": 58.40693, "LONG": 15.58172, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785583299, "OBJECT_ID": "4", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 7, "LAT": 58.40097, "LONG": 15.57262, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582992, "OBJECT_ID": "0", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 7, "LAT": 58.40097, "LONG": 15.57262, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582992, "OBJECT_ID": "1", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 7, "LAT": 58.40097, "LONG": 15.57262, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582992, "OBJECT_ID": "2", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 7, "LAT": 58.40097, "LONG": 15.57262, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582992, "OBJECT_ID": "3", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 7, "LAT": 58.40097, "LONG": 15.57262, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582992, "OBJECT_ID": "4", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 8, "LAT": 58.40444, "LONG": 15.57294, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582573, "OBJECT_ID": "0", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 8, "LAT": 58.40444, "LONG": 15.57294, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582573, "OBJECT_ID": "1", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 8, "LAT": 58.40444, "LONG": 15.57294, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582573, "OBJECT_ID": "2", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 8, "LAT": 58.40444, "LONG": 15.57294, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582573, "OBJECT_ID": "3", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 8, "LAT": 58.40444, "LONG": 15.57294, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582573, "OBJECT_ID": "4", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 9, "LAT": 58.40261, "LONG": 15.57208, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582369, "OBJECT_ID": "0", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 9, "LAT": 58.40261, "LONG": 15.57208, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582369, "OBJECT_ID": "1", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 9, "LAT": 58.40261, "LONG": 15.57208, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582369, "OBJECT_ID": "2", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 9, "LAT": 58.40261, "LONG": 15.57208, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582369, "OBJECT_ID": "3", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null},{"SENSOR_ID": 9, "LAT": 58.40261, "LONG": 15.57208, "DATA_TYPE": "temperature", "VALUE": 20.3, "DATE": 1563785582369, "OBJECT_ID": "4", "TYPE": "person", "NAME": null, "PERSON_NUMBER": null}]'
  3.  
  4.  
  5. var content = JSON.parse(msg)
  6. var output = {}
  7. var real_output = {}
  8.  
  9. for (var item in content) {
  10. if (!(content[item]['OBJECT_ID'] in output)) {
  11. var temp = content[item]
  12. temp[temp['DATA_TYPE'].toUpperCase()] = temp['VALUE']
  13. delete temp.DATA_TYPE
  14. delete temp.VALUE
  15. output[content[item]['OBJECT_ID']] = temp
  16. }
  17. else {
  18. var temp = output[content[item]['OBJECT_ID']]
  19. if(item['LAT'] != 0 && item['LAT'] != null){
  20. avg_lat = (output[item['OBJECT_ID']]['LAT'] + item['LAT'])/2
  21. temp['LAT'] = avg_lat
  22. }
  23. if(item['LONG'] != 0 && item['LONG'] != null){
  24. avg_lat = (output[item['OBJECT_ID']]['LONG'] + item['LONG'])/2
  25. temp['LONG'] = avg_lat
  26. }
  27. temp[content[item]['DATA_TYPE'].toUpperCase()] = content[item]['VALUE']
  28. }
  29. }
  30. for(var entry in output) {
  31. if (!(output[entry]['TYPE'] in real_output)){
  32. var temp = {}
  33. temp[entry] = output[entry]
  34. real_output[output[entry]['TYPE']] = temp
  35. }
  36. else {
  37. var temp = real_output[output[entry]['TYPE']]
  38. temp[entry] = output[entry]
  39. real_output[output[entry]['TYPE']] = temp
  40. }
  41. }
  42.  
  43. //send real_output to oliver
  44.  
  45. console.log(real_output)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!