Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.55 KB | None | 0 0
  1. function myTime() {
  2.  
  3.  
  4. var startValue = document.getElementById("startTime").value;
  5. var endValue = document.getElementById("endTime").value;
  6. var intervalValue = document.getElementById("interval").value;
  7. var startDate = new Date("1/1/2015 " + startValue);
  8. var endDate = new Date("1/1/2015 " + endValue);
  9. var offset = intervalValue * 1000 * 60;
  10. }
  11.  
  12. { $match : { datetime : { $gt : startDate, $lt : endDate } } },
  13. {
  14. $group: {
  15. _id:{
  16. "$add": [
  17. { "$subtract": [
  18. { "$subtract": [ "$datetime", new Date(0) ] },
  19. { "$mod": [
  20. { "$subtract": ["$datetime" , new Date(0) ] },
  21. offset]}] },
  22. new Date(0)
  23. ]},
  24. Humidity: {$avg: "$humidity"},
  25. Temperature: {$avg: "$temperature"}
  26.  
  27. },
  28. },
  29.  
  30. { $project : { _id : 1 , Humidity : 1, Temperature: 1 } },
  31. // { $limit : 10 },
  32. { $sort : {"_id":1, "Humidity":1, "Temperature": 1}}
  33.  
  34. function myTime() {
  35. var result = {}
  36. result.startValue = document.getElementById("startTime").value;
  37. result.endValue = document.getElementById("endTime").value;
  38. result.intervalValue = document.getElementById("interval").value;
  39. result.startDate = new Date("1/1/2015 " + startValue);
  40. result.endDate = new Date("1/1/2015 " + endValue);
  41. result.offset = intervalValue * 1000 * 60;
  42. return result;
  43. }
  44.  
  45. function getMongoObject(values) {
  46. return { "$match" : { "datetime" : { "$gt" : values.startDate, "$lt" : values.endDate } } },
  47. {
  48. "$group": {
  49. "_id":{
  50. "$add": [
  51. { "$subtract": [
  52. { "$subtract": [ "$datetime", new Date(0) ] },
  53. { "$mod": [
  54. { "$subtract": ["$datetime" , new Date(0) ] },
  55. values.offset]}] },
  56. new Date(0)
  57. ]},
  58. "Humidity": {$avg: "$humidity"},
  59. "Temperature": {$avg: "$temperature"}
  60.  
  61. },
  62. },
  63.  
  64. { "$project" : { "_id" : 1 , "Humidity" : 1, "Temperature": 1 } },
  65. // { "$limit" : 10 },
  66. { "$sort" : {"_id":1, "Humidity":1, "Temperature": 1}}
  67. }
  68.  
  69. var mongoValues = getTime();
  70. var mongoObject = getMongoObject(mongoValues);
  71.  
  72. var startValue, endValue, intervalValue, startDate, endDate, offset;
  73. function myTime() {
  74. startValue = document.getElementById("startTime").value;
  75. endValue = document.getElementById("endTime").value;
  76. intervalValue = document.getElementById("interval").value;
  77. startDate = new Date("1/1/2015 " + startValue);
  78. endDate = new Date("1/1/2015 " + endValue);
  79. offset = intervalValue * 1000 * 60;
  80. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement