天天看點

潤乾報表中對時間的自動計算和合法性校驗

鎶ヨ〃鎻愪緵浜嗚嚜鍔ㄨ绠楀拰鍚堟硶鎬ф牎楠岋紝浣嗘槸鏈変簺鐢ㄦ埛涓嶅お娓呮鎬庝箞浣跨敤锛屾湰鏂囩敤浜嗕竴涓緥瀛愮粰澶у浠嬬粛涓€涓嬪浣曚嬌鐢ㄥ揩閫告姤琛ㄥ疄鐜拌嚜鍔ㄨ绠楀拰鍚堟硶鎬ф牎楠岀殑鍔熻兘銆?

绗竴姝ラ渶瑕佽璁′竴寮犵畝鍗曠殑濉姤琛ㄣ€?

棣栧厛鏂闆緩涓€寮犵┖鐧界殑鎶ヨ〃锛岃缃姤琛ㄥ睘鎬т負鍙互濉姤銆傜劧鍚庡湪鍚勫崟鍏冩牸閲屽~鍏ュ涓嬪浘鎵€绀虹殑琛ㄨ揪寮忥紝鎶ヨ〃鐨勫叿浣撴牱寮忓涓嬪浘鎵€绀恒€?

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽

潤乾報表中對時間的自動計算和合法性校驗

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽

鍏朵腑B2鍜孋2鍗曞厓鏍奸噷鍒╃敤mid锛堬級鍑芥暟灏嗚璐ф棩鏈熷拰鍙戣揣鏃ユ湡杞崲鎴愬瓧绗︿覆鐨勫艦寮忥紝浠ヤ究鍦ㄥ悗缁殑姝ラ涓幓杩欎釜瀛楃涓蹭腑鐨勬煇浜涗綅锛屾嫾鍑戞垚JS涓牎楠岀殑鏃堕棿锛屽苟涓旇缃瓸2鍜孋2鍗曞厓鏍肩殑缂栬緫椋庢牸涓轟笅鎷夋棩鍘嗭紝鍙栧€肩被鍨嬩負鈥滃勾鏈?鏃モ€濓紝璁劇疆B2鍜孋2鍗曞厓鏍肩殑鏄劇ず鏍煎紡涓衡€測yyy-mm-dd鈥濄€傛姤琛ㄩ瑙堝悗鐨勬牱寮忓涓嬪浘鎵€绀恒€?

潤乾報表中對時間的自動計算和合法性校驗

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽

绗簩姝ヨ瀹炵幇鍦‥2鍗曞厓鏍奸噷鑷姩璁$畻鍑哄彂璐ф棩鏈熷拰璁㈣揣鏃ユ湡涔嬮棿鐨勬椂闂村樊銆?

闅忕潃鍦ㄥ~鎶ヨ繃绋嬩腑B2鍜孋2鐨勬棩鏈熷彂鐢熷彉鍖栵紝鍦‥2鍗曞厓鏍奸噷鐨勬椂闂村樊涔熶細鑷姩鍙樺寲銆傚湪蹇€告姤琛ㄤ腑锛岃嚜鍔ㄨ绠楀彲浠ラ€氳繃JavaScript鍑芥暟鏉ュ疄鐜幫紝鎵€浠ユ垜浠€夋嫨E2鍗曞厓鏍肩殑濉姤灞炴€э紝鍦ㄥ父瑙勯€夐」鍗′腑鍐欏叆JavaScript鍑芥暟鏉ヨ嚜鍔ㄨ绠楀嚭C2鍜孊2涓や釜鍗曞厓鏍肩殑鏃ユ湡宸紝鍐欏叆鐨凧S鍑芥暟濡備笅锛?newDate(${C2}.substr(0,4)+"/"+${C2}.substr(5,7)).getTime()-newDate(${B2}.substr(0,4)+"/"+${B2}.substr(5,7)).getTime())/1000/3600/24銆傝繖娈礘S鍑芥暟鐨勫惈涔夋槸鍙朇2鍜孊2鍗曞厓鏍奸噷鐨勫瓧绗︿覆锛屽彇鍓?浣嶅拰绗?銆?浣嶏紝鐒跺悗鍦ㄥ墠4浣嶅拰6銆?浣嶄箣闂村姞涓婂瓧绗︹€?鈥濓紝鎷兼垚涓€涓畬鏁寸殑瀛楃涓詫紝鐒跺悗鐢╣etTime()鏂規硶灏咮2鍜孋2鍗曞厓鏍間腑鎷兼垚鐨勫瓧绗︿覆杞崲鎴愭椂闂達紝鐒跺悗鍋氬樊锛岃繖鏃跺€欒绠楀嚭鏉ョ殑鏄袱涓棩鏈熶箣闂寸浉宸殑姣鏁幫紝鍐嶅皢杩欎釜姣鏁扳€?1000/3600/24鈥濓紝杞崲鎴愬ぉ鏁般€?

鍐橨S鍑芥暟鐨勫叿浣撶殑鏍峰紡濡備笅鍥炬墍绀猴細

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽

潤乾報表中對時間的自動計算和合法性校驗

鎺ヤ笅鏉ユ垜浠敤蹇€告姤琛ㄩ泦鎴愮殑tomcat鍙戝竷杩欏紶濉姤琛紝灏卞彲浠ョ湅鍒闆湪鏃堕棿宸搴旂殑鍒楅噷鑳芥樉绀哄嚭鍙戣揣鏃ユ湡璺熻璐ф棩鏈熶箣闂寸殑澶╂暟宸紝闅忕潃B2鍜孋2鍗曞厓鏍間腑鐨勬棩鏈熷彂鐢熸敼鍙橈紝鏃堕棿宸垪閲岄潰鐨勫ぉ鏁頒細鑷姩鐨勬敼鍙橈紝鏁堟灉鍥懼鍥句笁鍜屽浘鍥涙墍绀恒€?

潤乾報表中對時間的自動計算和合法性校驗

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽

绗笁姝ヨ缃悎娉曟€ф牎楠屻€?

鍦ㄦ暟鎹牎楠岀殑鏃跺€欙紝瑕佸厛瀹氫箟鏍¢獙js锛岀劧鍚庡湪鏍¢獙鐨勭紪杈戞涓皟鐢╦s锛屾墍浠ュ湪鍒╃敤JSP鍙戝竷鎶ヨ〃鐨勬椂鍊欙紝闇€瑕佸湪JSP閲屽啓鍑烘牎楠岀殑鍑芥暟锛屽苟鍦ㄦ牎楠岀殑琛ㄨ揪寮忎腑璋冪敤銆傛垜浠繖閲岃瀹氬鏋滃彂璐ф棩鏈熷皬浜庤璐ф棩鏈熷垯杈撳叆鐨勬暟鎹笉绗﹀悎瀹為檯锛屾彁绀鴻緭鍏ョ殑鏁版嵁涓嶅悎娉曪紝骞跺湪椤甸潰涓婃樉绀烘槸鍝簺璁㈠崟瀵瑰簲鐨勬暟鎹笉鍚堟硶銆?

棣栧厛鎴戜滑瑕佸啓涓€涓櫘閫氱殑鍙戝竷鎶ヨ〃鐨勭畝鍗曠殑JSP鏂囦歡锛孞SP鏂囦歡鐨勫唴瀹瑰鍥句簲鎵€绀恒€傜劧鍚庡湪JSP鐨?lt;html>鍚庨潰鍔犲叆濡備笅涓€娈典唬鐮侊細

<SCRIPTLANGUAGE="JavaScript">

聽 function聽Timer(name,first,second){

聽聽 var mark=true;

聽聽 varyear1=first.substring(0,4);

聽聽 varmonth1=first.substring(5,7);

聽聽 varday1=first.substring(8,10);

聽聽 var a=new Date(year1+"/"+month1+"/"+day1);

聽聽 varyear2=second.substring(0,4);

聽聽 varmonth2=second.substring(5,7);

聽聽 varday2=second.substring(8,10);

聽聽 var b=newDate(year2+"/"+month2+"/"+day2);

聽聽 varn=(b.getTime()-a.getTime())/1000/3600/24;

聽聽 if(n<0){

聽聽聽聽聽聽聽document.getElementById("warning").innerHTML="瀹氬崟ID:"+name+"鍙戣揣鏃ユ湡灏忎簬璁㈣喘鏃ユ湡";

聽聽聽聽聽聽聽聽mark=false;

聽聽 } else{

聽 聽聽 mark=true

聽聽 }

聽聽 return mark;

}

</SCRIPT>

杩欐浠g爜鐨勪綔鐢ㄥ氨鏄绠楁棩鏈熷樊骞跺垽鏂棩鏈熷樊鏄笉鏄皬浜?锛屽鏋滃皬浜?灏辨彁绀哄嚭閿欙紝骞跺湪缃戦〉涓婃樉绀哄嚭鏄摢涓鍗曞嚭閿欙紝璁$畻鏃ユ湡宸殑鏂規硶涓嶥2鍗曞厓鏍奸噷浣跨敤JS鍑芥暟鑷姩璁$畻鐨勬柟娉曠浉鍚屻€侸SP鏂囦歡鐨勪唬鐮佸涓嬮潰鎵€绀猴細

<%@ pagecontentType="text/html;charset=GBK" %>

<%@ tagliburi="/WEB-INF/runqianReport4.tld" prefix="report" %>

<%聽聽聽 //杩欓噷涓轟袱绉嶆柟娉曞噯澶囧浘鐗囪繛鎺ョ殑鍏叡閮ㄥ垎

聽 String appmap =request.getContextPath();

聽 String printImage = "<img alt=鎵撳嵃 src='" + appmap +"/images/print.gif' vertical-align:middle'>";

聽 String wordImage = "<img alt=瀵煎嚭Word src='" + appmap+ "/images/doc.gif' vertical-align:middle'>";

聽 String excelImage = "<img alt=瀵煎嚭excel src='" + appmap+ "/images/excel.gif' vertical-align:middle'>";

聽 String pdfImage = "<img alt=瀵煎嚭PDF鏂囦歡 src='" + appmap + "/images/pdf.gif' vertical-align:middle'>";

聽 String firstPageImage = "<imgsrc='" + appmap + "/images/firstpage.gif' vertical-align:middle'>";

聽 String lastPageImage = "<imgsrc='" + appmap + "/images/lastpage.gif' vertical-align:middle'>";

聽 String nextPageImage = "<imgsrc='" + appmap + "/images/nextpage.gif' vertical-align:middle'>";

聽 String prevPageImage = "<imgsrc='" + appmap + "/images/prevpage.gif' vertical-align:middle'>";

聽 String submitImage = "<imgalt=淇濆瓨鍒版暟鎹簱 src='" +appmap + "/images/savedata.gif' vertical-align:middle'>";

聽 String importExcelImage ="<img alt=瀵煎叆Excel鏂囦歡 src='" + appmap +"/images/importExcel.gif' vertical-align:middle'>";聽聽聽聽聽聽

%>

聽 <html>

聽聽 <SCRIPTLANGUAGE="JavaScript">

聽 function Timer(name,first,second){

聽聽 var mark=true;

聽聽 var year1=first.substring(0,4);

聽聽 var month1=first.substring(5,7);

聽聽 var day1=first.substring(8,10);

聽聽 var a=newDate(year1+"/"+month1+"/"+day1);

聽聽 var year2=second.substring(0,4);

聽聽 varmonth2=second.substring(5,7);

聽聽 var day2=second.substring(8,10);

聽聽 var b=newDate(year2+"/"+month2+"/"+day2);

聽聽 varn=(b.getTime()-a.getTime())/1000/3600/24;

聽聽 if(n<0){

聽聽聽聽聽聽聽document.getElementById("warning").innerHTML="瀹氬崟ID:"+name+"鍙戣揣鏃ユ湡灏忎簬璁㈣喘鏃ユ湡";

聽聽聽聽聽聽聽聽mark=false;

聽聽 }else if(n>30){

聽 聽聽聽document.getElementById("warning").innerHTML="瀹氬崟ID:"+name+"璁㈣喘鏃ユ湡涓庡彂璐ф棩鏈熺浉宸秴杩囦簡30澶?;

聽聽聽聽聽聽聽聽mark=false;

聽聽 }else{

聽 聽聽 mark=true

聽聽 }

聽聽 return mark;

}

</SCRIPT>

<table align=center>

聽聽聽聽聽聽聽聽<tr>

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽<td>聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽<span id="warning" style="color: black"></span>

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽</td>

聽聽聽聽聽聽聽聽</tr>

聽聽聽聽聽聽聽聽<tr>

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽<td>

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽<report:html name="report1" reportFileName="2.raq"

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽funcBarLocation="top" needPageMark="yes" generateParamForm="no"

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽width="-1" exceptionPage="/reportJsp/myError2.jsp"

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽needSaveAsWord="yes"

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽needSaveAsPdf="yes"

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽needSaveAsExcel="yes"

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽needImportExcel="yes"

聽聽聽聽聽聽聽聽

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽wordLabel="<%=wordImage%>"

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽pdfLabel="<%=pdfImage%>"

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽submit="<%=submitImage%>"

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽excelLabel="<%=excelImage%>"

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽importExcelLabel="<%=importExcelImage%>"

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽/>

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽</td>

聽聽聽聽聽聽聽聽</tr>

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽

聽 </table>

</html>

鎺ヤ笅鏉ラ渶瑕侀€夋嫨D2鍗曞厓鏍肩殑濉姤灞炴€э紝閫夋嫨鏍¢獙閫夐」鍗★紝澧炲姞涓€涓牎楠岋紝鍦ㄦ牎楠岀殑琛ㄨ揪寮忛噷杈撳叆浠ヤ笅琛ㄨ揪寮忥細Timer(${A2},${B2}.toString(),${C2}.toString())锛屼綔鐢ㄦ槸璋冪敤JSP閲岄潰鐨凾imer锛堬級鏂規硶锛岀劧鍚庡湪閿欒鎻愮ず閲屽啓鍏ユ暟鎹笉鍚堟硶锛屽叿浣撶殑褰㈠紡濡傚浘涓冪ず銆?

潤乾報表中對時間的自動計算和合法性校驗

杩欐牱鎴戜滑鐨勮繖寮犳姤琛ㄨ璁″氨閮藉畬鎴愪簡锛岀幇鍦ㄦ垜浠敤鑷繁鍐欑殑JSP鍙戝竷鎶ヨ〃灏卞彲浠ョ湅鍒版垜浠兂瑕佺殑鏁堟灉浜嗭紝鏁堟灉濡備笅鍥炬墍绀恒€?

聽聽聽聽聽聽聽聽聽聽聽聽

潤乾報表中對時間的自動計算和合法性校驗

聽聽聽聽聽聽聽聽聽

瀹屾垚浠ヤ笂姝ラ鎴戜滑灏卞彲浠ュ疄鐜闆褰曞叆鏁版嵁鐨勬牎楠屼互鍙婂閿欒淇℃伅鍔ㄦ€佹彁绀虹殑鍔熻兘浜嗭紝濡傛灉鏌愰」鏁版嵁鏈夐棶棰樺氨浼氬湪椤甸潰鐨勪笂鏂規樉绀哄嚭鏉ワ紝杩樹細鏄劇ず鍑烘槸鍏蜂綋鍑洪敊鐨勫師鍥犳槸浠€涔堬紝鏂逛究浜嗘搷浣滆€呭鍑洪敊鏁版嵁鐨勬鏌ワ紝鍦ㄤ竴瀹氱▼搴︿笂鍑忓皯浜嗗伐浣滈噺銆?

繼續閱讀