DIV CSS 佈局教程網

用 JavaScript 計算時間差並排除週六、週日的實作
編輯:關於JavaScript     

排班、工時計算等場景常需要「兩個日期相差幾個工作日」,也就是要把週六、週日排除掉。以下是一個可實際運作的函式:

function GetDayNum(no,type) {
if (type == "35") {
var num7 = document.getElementById("6").value;
var value = document.getElementById("7").value;
var valueR = num7;
if (no == "7") {valueR = value;}//標識時間值
if (num7 != "" && value != "") {
var numValue = 0;
var day = 24 * 60 * 60 * 1000;
var dateArr = value.split("-");
var checkDate = new Date();
checkDate.setFullYear(dateArr[0], dateArr[1] - 1, dateArr[2]);
var checkTime = checkDate.getTime();
var dateArr2 = num7.split("-");
var checkDate2 = new Date();
checkDate2.setFullYear(dateArr2[0], dateArr2[1] - 1, dateArr2[2]);
var checkTime2 = checkDate2.getTime();
var numValue = (checkTime - checkTime2) / day; //相差的總天數
var totleWeek = numValue / 7; //差別多少周
var yuDay = numValue % 7; //除了整個星期的天數
var lastDay = 0;
var startWeek = num7.replace(/-/g, "/"); //把「-」改為「/」
var date = Date.parse(startWeek);
var dateNew = new Date(date);
var weekDay = dateNew.getDay(); //星期幾
var endWeekDay = 0; //多餘的天數有幾天是週六或週日
if ((weekDay == 6 && yuDay >= 2) || (weekDay == 7 && yuDay >= 1) || (weekDay == 5 && yuDay >= 3) || (weekDay == 4 && yuDay >= 4) || (weekDay == 3 && yuDay >= 5) || (weekDay == 2 && yuDay >= 6) || (weekDay == 1 && yuDay >= 7)) { endWeekDay = 2; }
if ((weekDay == 6 && yuDay < 1) || (weekDay == 7 && yuDay < 5) || (weekDay == 5 && yuDay < 2) || (weekDay == 4 && yuDay < 3) || (weekDay == 3 && yuDay < 4) || (weekDay == 2 && yuDay < 5) || (weekDay == 1 && yuDay < 6)) { endWeekDay = 1; }
numValue = numValue - (totleWeek * 2) - endWeekDay; //最終時間
}
}
}

計算邏輯是:先算出兩個日期相差的總天數,接著看涵蓋了幾個完整週(每周扣掉 2 天週末),再判斷「多出來的那幾天」裡是否落在週六或週日,最後把這些該扣除的天數減掉,剩下的就是實際工作日數。要注意的是,作者特別提醒把日期字串裡的「-」換成「/」再解析,時間才會準確。

XML學習教程| jQuery入門知識| AJAX入門| Dreamweaver教程| Fireworks入門知識| SEO技巧| SEO優化集錦|
Copyright © DIV+CSS佈局教程網 All Rights Reserved