// 执行周查询
type:表示查询的种类(上周:-1 本周:0 下周:1)
function doWeekQuery(type){
vMonday = 0;
vSunday = 0;
if(type == 0){// 如果是本周直接以当前时间为基数计算
vMonday = getMonday(new Date());
vSunday = getSunday(new Date());
}else{// 如果是上周或下周以开始时间为基数计算
var vPlanStartTimeBegin = sheetManForm.queryPlanStartTimeBegin.valu e;(表单文本框对应的数据)
vMonday = compareDate(vPlanStartTimeBegin)+type*7*24*60*60*1000;
vSunday = vMonday+6*24*60*60*1000;
}
function doWeekQuery(type){
vMonday = 0;
vSunday = 0;
if(type == 0){// 如果是本周直接以当前时间为基数计算
vMonday = getMonday(new Date());
vSunday = getSunday(new Date());
}else{// 如果是上周或下周以开始时间为基数计算
var vPlanStartTimeBegin = sheetManForm.queryPlanStartTimeBegin.valu e;(表单文本框对应的数据)
vMonday = compareDate(vPlanStartTimeBegin)+type*7*24*60*60*1000;
vSunday = vMonday+6*24*60*60*1000;
}
// 获得周一时间
sheetManForm.queryPlanStartTimeBegin.value = getDate(vMonday)+" 00:00";
// 获得周日时间
sheetManForm.queryPlanFinishTimeEnd.value = getDate(vSunday)+" 23:59";
sheetManForm.queryPlanStartTimeBegin.value = getDate(vMonday)+" 00:00";
// 获得周日时间
sheetManForm.queryPlanFinishTimeEnd.value = getDate(vSunday)+" 23:59";
sheetManForm.actionType.value = "query";
sheetManForm.submit();
}
sheetManForm.submit();
}
// 根据时间字符串组装时间,获得需要的周一时间
function compareDate(stringDate){
var vReturn;
// 如果开始时间为空则返回当前时间对应的周一的时间
if(stringDate == "" || stringDate == null){
vReturn = getMonday(new Date());
}else{
var vArrDate = stringDate.split(" ")[0].split("-");
vReturn = getMonday(new Date(vArrDate[0],parseInt(vArrDate[1])-1,vArrDate[2]));
}
return vReturn;
}
function compareDate(stringDate){
var vReturn;
// 如果开始时间为空则返回当前时间对应的周一的时间
if(stringDate == "" || stringDate == null){
vReturn = getMonday(new Date());
}else{
var vArrDate = stringDate.split(" ")[0].split("-");
vReturn = getMonday(new Date(vArrDate[0],parseInt(vArrDate[1])-1,vArrDate[2]));
}
return vReturn;
}
// 获得一个时间对应的周一的时间
function getMonday(date){
var vDateInt = date.valueOf();
var vDayOfWeek = getDayOfWeek(date)-1;
vDateInt = vDateInt - vDayOfWeek*24*60*60*1000;
return vDateInt;
}
function getMonday(date){
var vDateInt = date.valueOf();
var vDayOfWeek = getDayOfWeek(date)-1;
vDateInt = vDateInt - vDayOfWeek*24*60*60*1000;
return vDateInt;
}
// 获得一个时间对应的周日的时间
function getSunday(date){
var vDateInt = date.valueOf();
var vDayOfWeek = 7-getDayOfWeek(date);
vDateInt = vDateInt + vDayOfWeek*24*60*60*1000;
return vDateInt;
}
function getSunday(date){
var vDateInt = date.valueOf();
var vDayOfWeek = 7-getDayOfWeek(date);
vDateInt = vDateInt + vDayOfWeek*24*60*60*1000;
return vDateInt;
}
// 获得一个时间是本周的的几天,星期一:1 星期天:7
function getDayOfWeek(date){
// 获得一个日期是一个星期中的第几天,星期日:0 星期六:6
var vDateOfWeek = date.getDay();
if(vDateOfWeek == 0){
vDateOfWeek = 7;
}
return vDateOfWeek;
}
function getDayOfWeek(date){
// 获得一个日期是一个星期中的第几天,星期日:0 星期六:6
var vDateOfWeek = date.getDay();
if(vDateOfWeek == 0){
vDateOfWeek = 7;
}
return vDateOfWeek;
}
// 根据自1970年1月1的毫秒数换算成时间
function getDate(milliseconds){
var vNewDate = new Date(milliseconds);
var vYear = vNewDate.getFullYear();
var vMonth = (vNewDate.getMonth() + 1);
if(vMonth < 10){
vMonth = "0"+vMonth;
}
var vDay = vNewDate.getDate();
if(vDay < 10){
vDay = "0"+vDay;
}
return vYear + "-" + vMonth + "-" + vDay;
}
function getDate(milliseconds){
var vNewDate = new Date(milliseconds);
var vYear = vNewDate.getFullYear();
var vMonth = (vNewDate.getMonth() + 1);
if(vMonth < 10){
vMonth = "0"+vMonth;
}
var vDay = vNewDate.getDate();
if(vDay < 10){
vDay = "0"+vDay;
}
return vYear + "-" + vMonth + "-" + vDay;
}
相关热门文章
给主人留下些什么吧!~~
评论热议