如何比较Javascript日期以过滤数组中的对象?

问题描述:

我一直坚持这几天和JavaScript中的日期是相当混乱。 我需要迭代一些JSON和过滤对象,这些对象比提前少于2小时和超过2个月。如何比较Javascript日期以过滤数组中的对象?

这里是JSON的示例:

[ 
    { 
     "Email":"[email protected]", 
     "TimeSlotsDate":"2017-01-28", 
     "TimeSlotsAvailable":[ 
     { 
      "start":"11:00", 
      "end":"12:00" 
     }, 
     { 
      "start":"12:00", 
      "end":"13:00" 
     }, 
     { 
      "start":"13:00", 
      "end":"14:00" 
     }, 
     { 
      "start":"15:00", 
      "end":"16:00" 
     }, 
     { 
      "start":"16:00", 
      "end":"17:00" 
     }, 
     { 
      "start":"17:00", 
      "end":"18:00" 
     } 
     ], 
    }, 
    { 
     "Email":"[email protected]", 
     "TimeSlotsDate":"2017-02-01", 
     "TimeSlotsAvailable":[ 
     { 
      "start":"12:00", 
      "end":"13:00" 
     }, 
     { 
      "start":"13:00", 
      "end":"14:00" 
     }, 
     { 
      "start":"14:00", 
      "end":"15:00" 
     }, 
     { 
      "start":"15:00", 
      "end":"16:00" 
     }, 
     { 
      "start":"16:00", 
      "end":"17:00" 
     }, 
     { 
      "start":"17:00", 
      "end":"18:00" 
     } 
     ], 
    }] 

我已经写从JSON创建可用日期的函数,但我在该部分粘贴在我请从TimeSlotsAvailable阵列是较少的对象比提前2小时提前2个月。

下面是函数:

var filterTimeslots = function (_timeSlots) { 

    var result = []; 
    var currentDate = new Date(); 
    var timeZoneOffset = currentDate.getTimezoneOffset()/60; 

    for (var i in _timeSlots) { 
     var day = _timeSlots[i].TimeSlotsDate.substring(8, 10); 
     var month = _timeSlots[i].TimeSlotsDate.substring(5, 7); 
     var year = _timeSlots[i].TimeSlotsDate.substring(0, 4); 

     for (var x in _timeSlots[i].TimeSlotsAvailable) { 
      var timeSlotStrt = _timeSlots[i].TimeSlotsAvailable[x].start.substring(0, 2); 
      var timeZoneTime = parseInt(timeSlotStrt) - timeZoneOffset; 

      var timeSlotDate = new Date(year, month, day, timeZoneTime); 

      if (timeSlotDate < currentDate) { 
       //the timeslot is less than 2 hours away 
      } 

      if (timeSlotDate > currentDate) { 
       //the timeslot is more than 2 months ahead 
      } 

      return result; 
     } 
    } 
}; 

该函数应返回的滤波阵列排除无效时隙。

任何帮助将不胜感激。

+1

我建议使用像图书馆http://momentjs.com/ – jcubic

使用一刻应该很容易

var arr = [{ 
 
    "Email": "[email protected]", 
 
    "TimeSlotsDate": "2016-08-16", 
 
    "TimeSlotsAvailable": [{ 
 
    "start": "17:00", 
 
    "end": "18:00" 
 
    }], 
 
}, { 
 
    "Email": "[email protected]", 
 
    "TimeSlotsDate": "2017-02-08", 
 
    "TimeSlotsAvailable": [{ 
 
    "start": "11:00", 
 
    "end": "12:00" 
 
    }, { 
 
    "start": "12:00", 
 
    "end": "13:00" 
 
    }, { 
 
    "start": "13:00", 
 
    "end": "14:00" 
 
    }, { 
 
    "start": "15:00", 
 
    "end": "16:00" 
 
    }, { 
 
    "start": "16:00", 
 
    "end": "17:00" 
 
    }, { 
 
    "start": "17:00", 
 
    "end": "18:00" 
 
    }], 
 
}, { 
 
    "Email": "[email protected]", 
 
    "TimeSlotsDate": "2017-02-01", 
 
    "TimeSlotsAvailable": [{ 
 
    "start": "12:00", 
 
    "end": "13:00" 
 
    }, { 
 
    "start": "13:00", 
 
    "end": "14:00" 
 
    }, { 
 
    "start": "14:00", 
 
    "end": "15:00" 
 
    }, { 
 
    "start": "15:00", 
 
    "end": "16:00" 
 
    }, { 
 
    "start": "16:00", 
 
    "end": "17:00" 
 
    }, { 
 
    "start": "17:00", 
 
    "end": "18:00" 
 
    }], 
 
}]; 
 
var now = moment(); 
 
var start = now.clone().add(2, 'hours'); 
 
var end = now.clone().add(2, "months"); 
 
console.log("NOW: ",now); 
 
console.log("START: ",start); 
 
console.log("END: ",end); 
 
var res = arr.filter(function(el) { 
 
    return el.TimeSlotsAvailable.filter(function(subEl) { 
 
    var c = moment(el.TimeSlotsDate + " " + subEl.start); 
 
    return c >= start && c <= end; 
 
    }).length == el.TimeSlotsAvailable.length; 
 
}); 
 
console.log(res.length, res);
<script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.14.1/moment.min.js"></script>