表头格式: 年,月,周号,星期一,星期二,星期三,星期四,星期五,星期六,星期日
条件1:星期六,星期天在表格中要自动默认加入“休息”,
条件2,如果一个月总天数除七余数小于三天,就把这三天放到下一个月的一周算,如果是大于三天就把下月的四天放到上月增加一周算。
年 月 周号 星期日 星期一 星期二 星期三 星期四 星期五 星期六
2009 11 45 2009-11-22休息 2009-11-23 2009-11-24 2009-11-25 2009-11-26 2009-11-27 2009-11-28休息
2009 12 46 2009-11-29休息 2009-22-30 2009-12-1 2009-12-2 2009-12-3 2009-12-4 2009-12-5休息
条件1:星期六,星期天在表格中要自动默认加入“休息”,
条件2,如果一个月总天数除七余数小于三天,就把这三天放到下一个月的一周算,如果是大于三天就把下月的四天放到上月增加一周算。
年 月 周号 星期日 星期一 星期二 星期三 星期四 星期五 星期六
2009 11 45 2009-11-22休息 2009-11-23 2009-11-24 2009-11-25 2009-11-26 2009-11-27 2009-11-28休息
2009 12 46 2009-11-29休息 2009-22-30 2009-12-1 2009-12-2 2009-12-3 2009-12-4 2009-12-5休息
解决方案 »
- 大虾们,给点建议吧
- 如何将 Session从一个Servlet传递到另一个Servlet中
- 我的主页上要显示数据库中表A、表B、表C的内容,我现在的做法是:分别建立con、和rs,但这样做就是在主页加载时就会产生三条数据库连接,
- 哪位大侠 能把下面的Sql Server数据库脚本转化成mysql脚本呢?
- 标签中的1个语句问题
- eclipse的简单问题
- 哪位大虾能给我一份JSP做的小型项目吗??谢谢(大概几十个页面)
- sqlserver 7跟jdbc连接的问题
- 如何用JSP调用Excel,在网页上显示
- 怎样用jsp对html中的select里的option进行添加和删除
- java反编译高人请进
- Velocity模板语言中遇到的问题
var goSelectTag = new Array();
var gcGray = "#cccccc";
var gcToggle = "#cccccc";
var gcToggleBorder = "#666666";
var gcLinkText = '#ffff00';
var gcToggleText = '#00ff00';
var gcBG = "#efefef";
var gcTitleBG="#cccccc";
var gcTitleText="#006600"
var previousObject = null;var gdCurDate = new Date();
var giYear = gdCurDate.getFullYear();
var giMonth = gdCurDate.getMonth()+1;
var giDay = gdCurDate.getDate();var gCalMode = "";
var gCalDefDate = "";var CAL_MODE_NOBLANK = "2";function fSetDate(iYear, iMonth, iDay){
//VicPopCal.style.visibility = "hidden";
if ((iYear == 0) && (iMonth == 0) && (iDay == 0)){
gdCtrl.value = "";
}else{
iMonth = iMonth + 100 + "";
iMonth = iMonth.substring(1);
iDay = iDay + 100 + "";
iDay = iDay.substring(1);
gdCtrl.value = iYear+"-"+iMonth+"-"+iDay;
} for (i in goSelectTag){
//goSelectTag[i].style.visibility = "visible";
} goSelectTag.length = 0; window.returnValue=gdCtrl.value;
// alert(window.returnValue);
window.returnValue = gdCtrl.value;
// window.close(); HiddenDiv();
}function HiddenDiv()
{
var i;
VicPopCal.style.visibility = "hidden";
for (i in goSelectTag)
goSelectTag[i].style.visibility = "visible";
goSelectTag.length = 0;}
function fSetSelected(aCell){
var iOffset = 0;
var iYear = parseInt(tbSelYear.value);
var iMonth = parseInt(tbSelMonth.value); aCell.bgColor = gcBG;
with (aCell.children["cellText"]){
var iDay = parseInt(innerText);
if (color==gcGray)
iOffset = (Victor<10)?-1:1; /*** below temp patch by maxiang ***/
if( color == gcGray ){
iOffset = (iDay < 15 )?1:-1;
}
/*** above temp patch by maxiang ***/ iMonth += iOffset;
if (iMonth<1) {
iYear--;
iMonth = 12;
}else if (iMonth>12){
iYear++;
iMonth = 1;
}
} fSetDate(iYear, iMonth, iDay);}function Point(iX, iY){
this.x = iX;
this.y = iY;
}function fBuildCal(iYear, iMonth) {
var aMonth=new Array();
for(i=1;i<7;i++)
aMonth[i]=new Array(i); var dCalDate=new Date(iYear, iMonth-1, 1);
var iDayOfFirst=dCalDate.getDay();
var iDaysInMonth=new Date(iYear, iMonth, 0).getDate();
var iOffsetLast=new Date(iYear, iMonth-1, 0).getDate()-iDayOfFirst+1;
var iDate = 1;
var iNext = 1; for (d = 0; d < 7; d++)
aMonth[1][d] = (d<iDayOfFirst)?-(iOffsetLast+d):iDate++;
for (w = 2; w < 7; w++)
for (d = 0; d < 7; d++)
aMonth[w][d] = (iDate<=iDaysInMonth)?iDate++:-(iNext++);
return aMonth;
}function fDrawCal(iYear, iMonth, iCellHeight, sDateTextSize) {
var WeekDay = new Array("日","一","二","三","四","五","六");
var styleTitleTD = " bgcolor='"+gcTitleBG+"' bordercolor='"+gcTitleBG+"' valign='middle' align='center' height='"+iCellHeight+"' style='font-size:12px; ";
var styleTD = " bgcolor='"+gcBG+"' bordercolor='"+gcBG+"' valign='middle' align='center' height='"+iCellHeight+"' style='font-size:12px; "; with (document) {
write("<tr>");
for(i=0; i<7; i++)
write("<td "+styleTitleTD+" color:"+gcTitleText+"' style='padding:3'><b>" + WeekDay[i] + "</b></td>");
write("</tr>"); for (w = 1; w < 7; w++) {
write("<tr>");
for (d = 0; d < 7; d++) {
write("<td id=calCell "+styleTD+"cursor:hand;' style='padding-left:2.5;padding-right:2.5;padding-top:0;padding-bottom:0' onMouseOver='this.bgColor=gcToggle;this.borderColor=gcToggleBorder' onMouseOut='this.bgColor=gcBG;this.borderColor=gcBG' onclick='fSetSelected(this)'>");
write("<font id=cellText face=Verdana><b> </b></font>");
write("</td>")
}
write("</tr>");
}
}
}function fUpdateCal(iYear, iMonth) {
myMonth = fBuildCal(iYear, iMonth);
var i = 0;
for (w = 0; w < 6; w++)
for (d = 0; d < 7; d++)
with (cellText[(7*w)+d]) {
Victor = i++;
if (myMonth[w+1][d]<0) {
color = gcGray;
innerText = -myMonth[w+1][d];
}else{
// Modified by maxiang for we need
// Saturday displayed in blue font color.
//color = ((d==0)||(d==6))?"red":"black";
if( d == 0 ){
color = "red";
}else if( d == 6 ){
color = "red";
}else{
color = "black";
}
// End of above maxiang
innerText = myMonth[w+1][d];
}
}
}function fSetYearMon(iYear, iMon){
tbSelMonth.options[iMon-1].selected = true;
for (i = 0; i < tbSelYear.length; i++)
if (tbSelYear.options[i].value == iYear)
tbSelYear.options[i].selected = true;
fUpdateCal(iYear, iMon);
}function fPrevMonth(){
var iMon = tbSelMonth.value;
var iYear = tbSelYear.value; if (--iMon<1) {
iMon = 12;
iYear--;
} fSetYearMon(iYear, iMon);
}function fNextMonth(){
var iMon = tbSelMonth.value;
var iYear = tbSelYear.value; if (++iMon>12) {
iMon = 1;
iYear++;
} fSetYearMon(iYear, iMon);
}function fToggleTags(){
with (document.all.tags("SELECT")){
for (i=0; i<length; i++)
if ((item(i).Victor!="Won")&&fTagInBound(item(i))){
item(i).style.visibility = "hidden";
goSelectTag[goSelectTag.length] = item(i);
}
}
}function fTagInBound(aTag){
with (VicPopCal.style){
var l = parseInt(left);
var t = parseInt(top);
var r = l+parseInt(width);
var b = t+parseInt(height);
var ptLT = fGetXY(aTag);
return !((ptLT.x>r)||(ptLT.x+aTag.offsetWidth<l)||(ptLT.y>b)||(ptLT.y+aTag.offsetHeight<t));
}
}function fGetXY(aTag){
var oTmp = aTag;
var pt = new Point(0,0);
do {
pt.x += oTmp.offsetLeft;
pt.y += oTmp.offsetTop;
oTmp = oTmp.offsetParent;
} while(oTmp.tagName!="BODY");
return pt;
}// Main: popCtrl is the widget beyond which you want this calendar to appear;
// dateCtrl is the widget into which you want to put the selected date.
// i.e.: <input type="text" name="dc" style="text-align:center" readonly><INPUT type="button" value="V" onclick="fPopCalendar(dc,dc);return false">
function fPopCalendar(popCtrl, dateCtrl, mode, defDate){
gCalMode = mode;
gCalDefDate = defDate; if (popCtrl == previousObject){
if (VicPopCal.style.visibility == "visible"){
//HiddenDiv();
return true;
} }
previousObject = popCtrl;
gdCtrl = dateCtrl;
fSetYearMon(giYear, giMonth);
var point = fGetXY(popCtrl); if( gCalMode == CAL_MODE_NOBLANK ){
document.all.CAL_B_BLANK.style.visibility = "hidden";
}else{
document.all.CAL_B_BLANK.style.visibility = "visible";
} with (VicPopCal.style) {
left = point.x;
top = point.y+popCtrl.offsetHeight;
width = VicPopCal.offsetWidth;
height = VicPopCal.offsetHeight;
fToggleTags(point);
visibility = 'visible';
}
}var gMonths = new Array("1月","2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月");
with (document) {
write("<Div id='VicPopCal' style='OVERFLOW:hidden;POSITION:absolute;VISIBILITY:hidden;border:0px ridge;top:0;left:0;z-index:100;overflow:hidden'>");
write("<table border='0' bgcolor='#3366cc' cellspacing=0 cellpadding=1>");
write("<TR>");
write("<td valign='middle' align='left'>");
write("<SELECT name='tbSelYear' onChange='fUpdateCal(tbSelYear.value, tbSelMonth.value)' Victor='Won'>");
for(i=1900;i<2100;i++)
write("<OPTION value='"+i+"'>"+i+"年</OPTION>");
write("</SELECT>");
write(" <select name='tbSelMonth' onChange='fUpdateCal(tbSelYear.value, tbSelMonth.value)' Victor='Won'>");
for (i=0; i<12; i++)
write("<option value='"+(i+1)+"'>"+gMonths[i]+"</option>");
write("</SELECT>");
write(" <span title='上一月份' onclick='javascript:fPrevMonth()' onmouseover='this.style.color=gcToggleText' onMouseOut='this.style.color=gcLinkText' style='cursor:hand; font-family:webdings; color:"+gcLinkText+"'>3</span>");
write("<span title='下一月份' onclick='javascript:fNextMonth()' onmouseover='this.style.color=gcToggleText' onMouseOut='this.style.color=gcLinkText' style='cursor:hand; font-family:webdings; color:"+gcLinkText+"'>4</span>");
write("</td>");
write("</TR><TR>");
write("<td align='right'>");
write("<DIV style='background-color:#cccccc'><table width='100%' border='1' cellspacing=1 cellpadding=0>");
fDrawCal(giYear, giMonth, 8, '12');
write("</table></DIV>");
write("</td>");
write("</TR><TR><TD align='center'>");
write("<TABLE width='100%'><TR><TD align='right'>");
write("<span ID=\"CAL_B_BLANK\" style='color:"+gcLinkText+"; visibility:visible; cursor:hand; font-size:9pt' onclick='fSetDate(0,0,0)' onMouseOver='this.style.color=gcToggleText' onMouseOut='this.style.color=gcLinkText' title=清除日期框中的值>[清空]</span>");
write("<span style='color:"+gcLinkText+"; visibility:visible; cursor:hand; font-size:9pt' onclick='HiddenDiv();' onMouseOver='this.style.color=gcToggleText' onMouseOut='this.style.color=gcLinkText' title=关闭日期窗口>[关闭]</span>");
write("<span style='color:"+gcLinkText+";cursor:hand; font-size:9pt' onclick='fSetDate(giYear,giMonth,giDay)' onMouseOver='this.style.color=gcToggleText' onMouseOut='this.style.color=gcLinkText' title=选择当前日期> ["+giYear+"/"+giMonth+"/"+giDay+"]</span>");write("</td></tr></table>");
write("</TD></TR>");
write("</TABLE></Div>");
}