本帖最后由 yhdata_xrvXuQqg 于 2025-7-7 16:55 编辑
var a = 下拉列表参数1.getSelectedObjects()[0];
if(a == '昨日'){
var star_date = param["_LAST_FULL_DAY_"];
var end_date = param["_LAST_FULL_DAY_"];
var year1 = year(star_date);
var month1 = month(star_date);
var day1 = day(star_date);
开始日期.value=formatDate(date(year1,month1,day1),"yyyy-MM-dd") ;
结束日期.value=formatDate(date(year1,month1,day1),"yyyy-MM-dd") ;
}else if(a == '本周'){
var star_date = param["_THIS_YEAR_WEEK_"];
var end_date = param["_LAST_FULL_DAY_"];
var week_date= weekdayname(param["_THIS_FULL_DAY_"]);
var lastweek_date = param["_LAST_YEAR_WEEK_"];
var lastweekend_date = dateAdd(param["_THIS_YEAR_WEEK_"],"dayofyear",-1);
if(week_date=='星期一'){
var year1 = year(lastweek_date);
var month1 = month(lastweek_date);
var day1 = day(lastweek_date);
var year2 = year(lastweekend_date);
var month2 = month(lastweekend_date);
var day2 = day(lastweekend_date);
}else{
var year1 = year(star_date);
var month1 = month(star_date);
var day1 = day(star_date);
var year2 = year(end_date);
var month2 = month(end_date);
var day2 = day(end_date);
}
开始日期.value=formatDate(date(year1,month1,day1),"yyyy-MM-dd") ;
结束日期.value=formatDate(date(year2,month2,day2),"yyyy-MM-dd") ;
}else if(a == '本月'){
var star_date = param["_THIS_YEAR_MONTH_"];
var end_date = param["_LAST_FULL_DAY_"];
var month_date= param["_THIS_FULL_DAY_"];
var lastmonth_date = param["_LAST_YEAR_MONTH_"];
var lastmonthend_date = dateAdd(param["_THIS_YEAR_MONTH_"],"dayofyear",-1);
if(day(month_date)=='01'){
var year1 = year(lastmonth_date);
var month1 = month(lastmonth_date);
var day1 = day(lastmonth_date);
var year2 = year(lastmonthend_date);
var month2 = month(lastmonthend_date);
var day2 = day(lastmonthend_date);
}else{
var year1 = year(star_date);
var month1 = month(star_date);
var day1 = day(star_date);
var year2 = year(end_date);
var month2 = month(end_date);
var day2 = day(end_date);
}
开始日期.value=formatDate(date(year1,month1,day1),"yyyy-MM-dd") ;
结束日期.value=formatDate(date(year2,month2,day2),"yyyy-MM-dd") ;
}else if(a == '本季'){
var star_date = param["_THIS_YEAR_QUARTER_"];
var end_date = param["_LAST_FULL_DAY_"];
var quarter_date= param["_THIS_FULL_DAY_"];
var lastquarter_date = param["_LAST_YEAR_QUARTER_"];
var lastquarterend_date = dateAdd(param["_THIS_YEAR_QUARTER_"],"dayofyear",-1);
if(year(star_date)==year(quarter_date)&&month(star_date)==month(quarter_date)&&day(star_date)==day(quarter_date)){
var year1 = year(lastquarter_date);
var month1 = month(lastquarter_date);
var day1 = day(lastquarter_date);
var year2 = year(lastquarterend_date);
var month2 = month(lastquarterend_date);
var day2 = day(lastquarterend_date);
}else{
var year1 = year(star_date);
var month1 = month(star_date);
var day1 = day(star_date);
var year2 = year(end_date);
var month2 = month(end_date);
var day2 = day(end_date);
}
开始日期.value=formatDate(date(year1,month1,day1),"yyyy-MM-dd") ;
结束日期.value=formatDate(date(year2,month2,day2),"yyyy-MM-dd") ;
}else if(a == '本年'){
var star_date = param["_THIS_YEAR_MONTH_"];
var end_date = param["_LAST_FULL_DAY_"];
var year_date= param["_THIS_FULL_DAY_"];
if(month(star_date)=='01'&&day(star_date)=='01'){
var year1 = year(star_date)-1;
var month1 = month(star_date);
var day1 = day(star_date);
var year2 = year(end_date);
var month2 = month(end_date);
var day2 = day(end_date);
}else{
var year1 = year(star_date);
var month1 = month(star_date);
var day1 = day(star_date);
var year2 = year(end_date);
var month2 = month(end_date);
var day2 = day(end_date);
}
开始日期.value=formatDate(date(year1,'01','01'),"yyyy-MM-dd") ;
结束日期.value=formatDate(date(year2,month2,day2),"yyyy-MM-dd") ;
}
else if(a == '自定义'){
}
else{
//无需写脚本
}
|