Vorgehensweise zum berechnen der Anzahl von 'Arbeitstagen zwischen zwei Datumsangaben in Javascript mit moment.js?

So berechnen Sie die Anzahl der Arbeitstage zwischen zwei Datumsangaben in JavaScript mit moment.js. Ich habe eine funktionierende Formel, die berechnen, in diesen Tagen, aber die Formel nicht erfüllt alle Bedingungen:

hier ist mein code:

var start= moment(data[x].start_date);
                var end= moment(data[x].est_end_date);
                var difference= end.diff(start, 'days');
                var workingDays= Math.round((difference/7)*5);
//data[x] is for iterating over a loop

Bekomme ich fünf Tage pro 7 Tage hier, weil Samstag und Sonntag werden NICHT als Arbeitstage, aber diese Formel wird scheitern, wenn die Zählung der Tage gestartet wurden, die von Sonntag oder Samstag.

Please jemand helfen könnte, in dieser Hinsicht, dass das, was notwendig ist, müssen die änderungen gemacht werden, um dieses problem zu vermeiden.

InformationsquelleAutor Ali Shaan | 2015-02-10
  1. 19

    Nur teilen es in 3 Teile.. der erste Woche, die Letzte Woche und die in-zwischen, so etwas wie dieses:

    function workday_count(start,end) {
  var first = start.clone().endOf('week'); //end of first week
  var last = end.clone().startOf('week'); //start of last week
  var days = last.diff(first,'days') * 5 / 7; //this will always multiply of 7
  var wfirst = first.day() - start.day(); //check first week
  if(start.day() == 0) --wfirst; //-1 if start with sunday 
  var wlast = end.day() - last.day(); //check last week
  if(end.day() == 6) --wlast; //-1 if end with saturday
  return wfirst + days + wlast; //get the total
}

    Den test-code

    var ftest = {date:'2015-02-0',start:1,end:7};
var ltest = {date:'2015-02-2',start:2,end:8};
var f = 'YYYY-MM-DD';
for(var z=ftest.start; z<=ftest.end; ++z) {
  var start = moment(ftest.date + z);
  for(var y=ltest.start; y<=ltest.end; ++y) {
    var end = moment(ltest.date + y);
    var wd = workday_count(start,end);
    console.log('from: '+start.format(f),'to: '+end.format(f),'is '+wd+' workday(s)');
  }
}

    Ausgabe von test-code:

    from: 2015-02-01 to: 2015-02-22 is 15 workday(s)
from: 2015-02-01 to: 2015-02-23 is 16 workday(s)
from: 2015-02-01 to: 2015-02-24 is 17 workday(s)
from: 2015-02-01 to: 2015-02-25 is 18 workday(s)
from: 2015-02-01 to: 2015-02-26 is 19 workday(s)
from: 2015-02-01 to: 2015-02-27 is 20 workday(s)
from: 2015-02-01 to: 2015-02-28 is 20 workday(s)
from: 2015-02-02 to: 2015-02-22 is 15 workday(s)
from: 2015-02-02 to: 2015-02-23 is 16 workday(s)
from: 2015-02-02 to: 2015-02-24 is 17 workday(s)
from: 2015-02-02 to: 2015-02-25 is 18 workday(s)
from: 2015-02-02 to: 2015-02-26 is 19 workday(s)
from: 2015-02-02 to: 2015-02-27 is 20 workday(s)
from: 2015-02-02 to: 2015-02-28 is 20 workday(s)
from: 2015-02-03 to: 2015-02-22 is 14 workday(s)
from: 2015-02-03 to: 2015-02-23 is 15 workday(s)
from: 2015-02-03 to: 2015-02-24 is 16 workday(s)
from: 2015-02-03 to: 2015-02-25 is 17 workday(s)
from: 2015-02-03 to: 2015-02-26 is 18 workday(s)
from: 2015-02-03 to: 2015-02-27 is 19 workday(s)
from: 2015-02-03 to: 2015-02-28 is 19 workday(s)
from: 2015-02-04 to: 2015-02-22 is 13 workday(s)
from: 2015-02-04 to: 2015-02-23 is 14 workday(s)
from: 2015-02-04 to: 2015-02-24 is 15 workday(s)
from: 2015-02-04 to: 2015-02-25 is 16 workday(s)
from: 2015-02-04 to: 2015-02-26 is 17 workday(s)
from: 2015-02-04 to: 2015-02-27 is 18 workday(s)
from: 2015-02-04 to: 2015-02-28 is 18 workday(s)
from: 2015-02-05 to: 2015-02-22 is 12 workday(s)
from: 2015-02-05 to: 2015-02-23 is 13 workday(s)
from: 2015-02-05 to: 2015-02-24 is 14 workday(s)
from: 2015-02-05 to: 2015-02-25 is 15 workday(s)
from: 2015-02-05 to: 2015-02-26 is 16 workday(s)
from: 2015-02-05 to: 2015-02-27 is 17 workday(s)
from: 2015-02-05 to: 2015-02-28 is 17 workday(s)
from: 2015-02-06 to: 2015-02-22 is 11 workday(s)
from: 2015-02-06 to: 2015-02-23 is 12 workday(s)
from: 2015-02-06 to: 2015-02-24 is 13 workday(s)
from: 2015-02-06 to: 2015-02-25 is 14 workday(s)
from: 2015-02-06 to: 2015-02-26 is 15 workday(s)
from: 2015-02-06 to: 2015-02-27 is 16 workday(s)
from: 2015-02-06 to: 2015-02-28 is 16 workday(s)
from: 2015-02-07 to: 2015-02-22 is 10 workday(s)
from: 2015-02-07 to: 2015-02-23 is 11 workday(s)
from: 2015-02-07 to: 2015-02-24 is 12 workday(s)
from: 2015-02-07 to: 2015-02-25 is 13 workday(s)
from: 2015-02-07 to: 2015-02-26 is 14 workday(s)
from: 2015-02-07 to: 2015-02-27 is 15 workday(s)
from: 2015-02-07 to: 2015-02-28 is 15 workday(s)
    • Super, danke sehr !
    • Für einen Zeitraum von 5 Tagen, es gibt 5.7 Tage.
    • In der Tat, für einen Zeitraum von weniger als 7 Tagen, ist der Wert in dezimal zahlen.
    • Ich hatte das gleiche problem. Es war aufgrund der Sommer-Zeit, die Unterschiede zwischen dem Anfang und dem Ende der Woche. Das Update ist weiter unten.
    InformationsquelleAutor Kokizzu
  2. 6

    Verwende ich eine einfache Funktion, um zu erreichen, dass. Ist vielleicht nicht die effizienteste, aber es funktioniert. Es erfordert nicht Moment.js. es ist nur Javascript.

    function getNumWorkDays(startDate, endDate) {
    var numWorkDays = 0;
    var currentDate = new Date(startDate);
    while (currentDate <= endDate) {
        //Skips Sunday and Saturday
        if (currentDate.getDay() !== 0 && currentDate.getDay() !== 6) {
            numWorkDays++;
        }
        currentDate = currentDate.addDays(1);
    }
    return numWorkDays;
}

    Zu addDays ich folgende Funktion verwenden:

    Date.prototype.addDays = function (days) {
    var date = new Date(this.valueOf());
    date.setDate(date.getDate() + days);
    return date;
};
    InformationsquelleAutor Juan García
  3. 3

    Fand ich kokizzu Antwort hat nicht funktioniert, wenn die Tage waren in der gleichen Woche (z.B. so, sa), so dass sich für dieses statt :

        function calcBusinessDays(startDate, endDate) { 
      var day = moment(startDate);
      var businessDays = 0;

      while (day.isSameOrBefore(endDate,'day')) {
        if (day.day()!=0 && day.day()!=6) businessDays++;
        day.add(1,'d');
      }
      return businessDays;
    }
    InformationsquelleAutor simonberry
  4. 2

    Ich habe eine Anpassung an Kokizzu Antwort, um zu beheben, ein Sommer-Zeit-problem. In der brasilianischen Zeitzone (GMT -3), der Unterschied zwischen 17/10/2017 und 18/10/2017 war -2.71 statt 2.

    Beginn der Woche war 15/10/2017 00:00 UTC oder 14/10/2017 21:00-03:00 Uhr

    Ende der Woche war 22/10/2017 00:00 UTC oder 21/10/2017 22:00-02:00 (Sommerzeit)

    Daher, statt der 7, die Differenz zwischen "first" und "last" - variable in Tagen lag bei 6 (oder 8, je nach Zeitzone).

    Den code fixiert ist unten:

    start = moment(start).utc().add(start.utcOffset(), 'm'); //Ignore timezones
end = moment(end).utc().add(end.utcOffset(), 'm'); //Ignore timezones

var first = start.clone().endOf('week'); //end of first week
var last = end.clone().startOf('week'); //start of last week

//Fixing Summer Time problems
firstCorrection = moment(first).utc().add(60, 'm').toDate(); //
var days = last.diff(firstCorrection,'days') * 5 / 7; //this will always multiply of 7

var wfirst = first.day() - start.day(); //check first week
if(start.day() == 0) --wfirst; //-1 if start with sunday
var wlast = end.day() - last.day(); //check last week
if(end.day() == 6) --wlast; //-1 if end with saturday
return wfirst + days + wlast; //get the total (subtract holidays if needed)
    InformationsquelleAutor João Bruno Abou Hatem de Liz
  5. 0

    können Sie versuchen, diese(ohne Schlaufe):

      function getBusinessDays(endDate, startDate) {
    var lastDay = moment(endDate);
    var firstDay = moment(startDate);
    let calcBusinessDays = 1 + (lastDay.diff(firstDay, 'days') * 5 -
      (firstDay.day() - lastDay.day()) * 2) / 7;

    if (lastDay.day() == 6) calcBusinessDays--;//SAT
    if (firstDay.day() == 0) calcBusinessDays--;//SUN

    return calcBusinessDays;
  }

    Original Source

    InformationsquelleAutor Adem Aygun
Schreibe einen Kommentar