<%@page contentType="text/html; charset=UTF-8"%> <%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*,com.csc.library.session.*,com.csc.library.report.*;"%> <jsp:useBean id="WEL050" class="com.csc.library.system.Task" scope="page" /> <% WEL050.setChannel(request, response); HelpEntry screen = (HelpEntry) WEL050.process("HelpEntry","WEL050"); screen.getInquiry().clearSubFilter(); screen.inq.setFilter("status='1' and approvestatus<>'2' and employeeid='"+screen.getUProfile().get("employeeid")+"'"); CheckNull chk=new CheckNull(); ReportUDF rf=new ReportUDF(); ThaiUtilities thail = new ThaiUtilities(); CscCalendar cs=new CscCalendar(); cs.decYear(1); java.text.DecimalFormat df=new java.text.DecimalFormat("#,###,##0.00"); String condition=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__fixCon"))); String years1=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__year"),String.valueOf(cs.getYear()))); String welid1=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__welid1"))); String welid2=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__welid2"))); String stdate=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__startdate"))); String endate=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__enddate"))); DbInquiry dbi=(DbInquiry)screen.getInquiry(); if(years1.trim().length()>0){ dbi.setFilter("budyear",years1,"","between"); } if(welid1.trim().length()>0){ dbi.setFilter("welid",welid1,welid1,"between"); } if(stdate.trim().length()>0){ dbi.setFilter("approvedate",stdate,endate,"between"); } screen.process(); %> <html> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" > <link href="../CSS/MENU.css" rel="stylesheet" type="text/css"> <link href="../CSS/TISCO.css" rel="stylesheet" type="text/css"> <link href="../CSS/bootstrap.css" rel="stylesheet" type="text/css"> <link href="../CSS/bootstrap_csc_backend.css" rel="stylesheet" type="text/css"> <script type="text/javascript" src="../JS/jquery-2.1.3.min.js"></script> <script type='text/javascript' src="../JS/bootstrap.js"></script> <script language='javascript' src="../JS/VIEWCALENDAR.js"></script> <script language="JavaScript" src="../JS/SCREEN.js"></script> <script type='text/javascript' src="../JS/ICONSMENU.js"></script> <script language='javascript' src="../JS/HOTKEY.js"></script> <script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script> <script language="JavaScript" type="text/JavaScript"> <!-- function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} } function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc; } function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; } function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} } function edelete(){ with(document.cscform){ bCon=confirm("เกินสิทธิ"); if (bCon==true) { // setAction(__jspname.value,"delete"); __cmd.value="delete"; submit(); } } } function postnew(page){ with(document.cscform){ open(page,"post","height=420,width=600"); } } function gotopage(page,idno){ with(document.cscform){ action=page; __webid.value=idno; __fixCon.value="webid='"+idno+"'"; __cmd.value="search"; __readposter.value="count"; submit(); } } function setFixCon(fixCon){ var _fix=(fixCon.length>0)?(fixCon+" and status='1' and approvestatus<>'2'") : ("status='1' and approvestatus<>'2'"); return _fix; } function GoSearch() { with(document.cscform) { if(__employeeid1.value==""&&__employeeid2.value==""&&__welid1.value=="" && __welid2.value=="" && __startdate.value=="" && __enddate.value=="") { __fixCon.value=""; } else if(__employeeid1.value==""&&__employeeid2.value!=""||__employeeid1.value!=""&&__employeeid2.value=="" ||__welid1.value=="" && __welid2.value!="" || __welid1.value!="" && __welid2.value=="" || __startdate.value=="" && __enddate.value!="" || __startdate.value!="" && __enddate.value=="") { alert("Please Input Value.!!"); } else if(__welid1.value==""&&__welid2.value==""&& __startdate.value=="" && __enddate.value=="") { if(__employeeid1.value>__employeeid2.value) { var tmp=__employeeid2.value; __employeeid2.value=__employeeid1.value; __employeeid1.value=tmp; } __fixCon.value="(EMPLOYEEID>='"+__employeeid1.value+"')and(EMPLOYEEID<='"+__employeeid2.value+"')"; } else if(__employeeid1.value==""&&__employeeid2.value==""&& __startdate.value=="" && __enddate.value=="") { if(__welid1.value>__welid2.value) { var tmp=__welid2.value; __welid2.value=__welid1.value; __welid1.value=tmp; } __fixCon.value="(WELID>='"+__welid1.value+"')and(WELID<='"+__welid2.value+"')"; } else if(__employeeid1.value==""&&__employeeid2.value==""&&__welid1.value=="" && __welid2.value=="") { var stdate=""; var endate=""; stdate=chkDateTime2(__startdate.value,"-"); endate=chkDateTime2(__enddate.value,"-"); __fixCon.value="(startdate >='"+stdate+"')and(enddate <='"+endate+"')"; } else if( __startdate.value=="" && __enddate.value=="") { if(__welid1.value>__welid2.value) { var tmp=__welid2.value; __welid2.value=__welid1.value; __welid1.value=tmp; } if(__employeeid1.value>__employeeid2.value) { var tmp=__employeeid2.value; __employeeid2.value=__employeeid1.value; __employeeid1.value=tmp; } __fixCon.value="(WELID>='"+__welid1.value+"')and(WELID<='"+__welid2.value+"')and(EMPLOYEEID>='"+__employeeid1.value+"')and(EMPLOYEEID<='"+__employeeid2.value+"')"; } else if(__welid1.value=="" && __welid2.value=="") { if(__employeeid1.value>__employeeid2.value) { var tmp=__employeeid2.value; __employeeid2.value=__employeeid1.value; __employeeid1.value=tmp; } var stdate=""; var endate=""; stdate=chkDateTime2(__startdate.value,"-"); endate=chkDateTime2(__enddate.value,"-"); __fixCon.value="(startdate >='"+stdate+"')and(enddate <='"+endate+"')and(EMPLOYEEID>='"+__employeeid1.value+"')and(EMPLOYEEID<='"+__employeeid2.value+"')"; } else if(__employeeid1.value==""&&__employeeid2.value=="") { if(__welid1.value>__welid2.value) { var tmp=__welid2.value; __welid2.value=__welid1.value; __welid1.value=tmp; } var stdate=""; var endate=""; stdate=chkDateTime2(__startdate.value,"-"); endate=chkDateTime2(__enddate.value,"-"); __fixCon.value="(startdate >='"+stdate+"')and(enddate <='"+endate+"')and(WELID>='"+__welid1.value+"')and(WELID<='"+__welid2.value+"')"; } else { var stdate=""; var endate=""; stdate=chkDateTime2(__startdate.value,"-"); endate=chkDateTime2(__enddate.value,"-"); if(__employeeid1.value>__employeeid2.value) { var tmp=__employeeid2.value; __employeeid2.value=__employeeid1.value; __employeeid1.value=tmp; } if(__welid1.value>__welid2.value) { var tmp=__welid2.value; __welid2.value=__welid1.value; __welid1.value=tmp; } __fixCon.value="(EMPLOYEEID>='"+__employeeid1.value+"')and(EMPLOYEEID<='"+__employeeid2.value+"')and(welid>='"+__welid1.value+"')and(welid<='"+__welid2.value+"')and(startdate>='"+stdate+"')and(enddate<='"+endate+"')"; } __fixCon.value=setFixCon(__fixCon.value); search(); } } function goHelp(helpName,inputName){ var helpReturn; if(inputName=="__employeeid1" ) helpReturn="__employeeid1:EMPLOYEEID,MEMPLOYEE@EMPLOYEEID"; else if(inputName=="__employeeid2" ) helpReturn="__employeeid2:EMPLOYEEID,MEMPLOYEE@EMPLOYEEID"; else if(inputName=="__provinceid" ) helpReturn="__provinceid:provinceid,MPROVINCE@long_tname,MPROVINCE@long_ename"; else if(inputName=="__welid1" ) helpReturn="__welid1:WELID,MWELFARE@WELID"; else if(inputName=="__welid2" ) helpReturn="__welid2:WELID,MWELFARE@WELID"; linkHelp_Return(helpName,helpReturn); } function chkDateTime2(valueSearch,comm){ // 23/03/2004 var tmpval=""; with(document.cscform){ // tmpval=valueSearch.substring(2,3); var valueSearch1=valueSearch.split(comm); if(valueSearch1.length==3){ if(valueSearch1[1].length==1){ valueSearch1[1]="0"+valueSearch1[1]; } if(valueSearch1[0].length==1){ valueSearch1[0]="0"+valueSearch1[0]; } valueSearch1[2]=parseInt(valueSearch1[2]); return valueSearch=valueSearch1[2]+"-"+valueSearch1[1]+"-"+valueSearch1[0]; } } } function gotopage1(page,idno,no1,empid){ with(document.cscform){ action=page; __complainid.value=idno; __fixCon.value="complainid='"+idno+"' and caseid='"+no1+"' and employeeid='"+empid+"'"; __cmd.value="search"; submit(); } } function GoClean() { with(document.cscform) { __employeeid1.value=""; __employeeid2.value=""; __welid1.value=""; __welid2.value=""; __startdate.value=""; __enddate.value=""; } } //--> </script> <style type="text/css"> <!-- .style1 {color: #FF0000} --> </style> </head> <body onLoad="MM_preloadImages('../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif')" > <div class="centered"> <div id="toolTipLayer" style="position:absolute; visibility: hidden"></div> <script language="javascript">initToolTips();</script> <form name="cscform" method="post" action=""> <!----------BEGIN CSC INITIAL ZONE ------------------------> <%=screen.InitialVariable()%> <!----------END CSC INITIAL ZONE --------------------------> <input type="hidden" name="__cmd" value=""> <input type="hidden" name="__help" value=""> <input type="hidden" name="__goPage" value=""> <input name="__notNull" type="hidden" value="<%//=screen.getRequire()%>"> <input type="hidden" name="__helpReturn" value=""> <input type="hidden" name="__helpName" value=""> <input type="hidden" name="__pageCall" value=""> <input type="hidden" name="__referPage" value=""> <input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>"> <input type="hidden" name="__lockPage" value=""> <input type="hidden" name="__calendar"> <input type="hidden" name="__screen"> <input type="hidden" name="__webid"> <input type="hidden" name="__readposter"> <script language="javascript">getInputFormatDate();</script> <input type="hidden" name="__employeeid" value=""> <input type="hidden" name="__docno" value=""> <input type="hidden" name="__formulaid" value=""> <input type="hidden" name="__fixCon" value="<%=condition%>"> <input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>"> <input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>"> <input type="hidden" name="__complainid" value=""> <script language="JavaScript" src="../JS/HOTKEY.js"></script> <script language="javascript"> var titlename=swap2String('History of welfare in budget year ago'); document.write(Icons("WEL050,"+titlename)); </script> <br> <div align="center"> <table cellpadding="0" cellspacing="0" class="largest"> <tr > <td colspan="2" class="header" >WEL050, <script language="javascript">swapLang('History of welfare in budget year ago');</script> </td> </tr> <tr > <td ><table class="maxsize" border="0" align="center" cellpadding="0" cellspacing="1"> <tr> <td colspan="12" class="blankspace"> <table width="638" border="0" align="center" cellpadding="0" cellspacing="1" class="inframe"> <tr> <td colspan="2" class="blankspace"> </td> </tr> <tr class="maxsize"> <td width="15%"> <div align="right"> <script language="javascript">swapLang('Order By');</script> </div></td> <td width="538"><%=screen.getTagOrder()%></td> </tr> <tr> <td class="columnlabel_baseline"><script language="javascript">swapLang('Budget Year');</script> </td> <td><input name="__year" type="text" size="7" maxlength="4" value="<%=years1%>"> </td> </tr> <tr> <td class="columnlabel_baseline"><script language="javascript">swapLang('Welfare ID');</script> </td> <td><input name="__welid1" type="text" size="15" value="<%=welid1%>"> <a href="javascript:goHelp('MWELFAREHELP','__welid1');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image32','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image32" width="20" border="0" align="absmiddle" id="Image32"></a> - <input name="__welid2" type="text" size="15" value="<%=welid2%>"> <a href="javascript:goHelp('MWELFAREHELP','__welid2');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image321','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image321" width="20" border="0" align="absmiddle" id="Image32"></a></td> </tr> <tr> <td class="columnlabel_baseline"><script language="javascript">swapLang('Date Between');</script> </td> <td> <input name="__startdate" type="text" size="10" maxlength="8" value="<%=stdate%>" ONKEYPRESS="chkInteger()" ONKEYUP="formatDate(this)" ONBLUR="chkInputDate2(this,__enddate)"> <a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image12','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image12" width="20" border="0" align="absmiddle" id="Image12" onClick="viewCal('__startdate')"></a> - <input name="__enddate" type="text" size="10" maxlength="8" value="<%=endate%>" ONKEYPRESS="chkInteger()" ONKEYUP="formatDate(this)" ONBLUR="chkInputDate2(__startdate,this)"> <a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image121','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image121" width="20" border="0" align="absmiddle" id="Image12" onClick="viewCal('__enddate')"></a></td> </tr> <tr> <td class="columnlabel_baseline"> </td> <td><!--input name="__keyword" type="text" size="30" value="<=keyword%>" --> <button type="button" class="btn btn-primary width100" swlang code="SW013174" onClick="GoSearch();">SEARCH</button></td> </tr> <tr> <td colspan="2" class="columnlabel_baseline2"><div align="right"></div></td> </tr> </table> <div align="right"><br> <%=screen.getPageTag()%></div> <table width="638" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#808080" class="inframe tablewithborder"> <tr class="title1"> <td width="6%" nowrap class="title1"><div align="center" ><%=screen.getLabel("approvedate")%></div></td> <td width="8%" nowrap class="title1"><div align="center" ><%=screen.getLabel("budyear")%></div></td> <td nowrap class="title1"><div align="center"><%=screen.getLabel("COMPLAINID")%></div></td> <td nowrap class="title1"><div align="center"><%=screen.getLabel("CASEID")%></div></td> <td nowrap class="title1"> <div align="center"><%=screen.getLabel("WELID")%></div></td> <td nowrap class="title1"><div align="center"><%=screen.getLabel("CASEDESC")%></div></td> <td nowrap class="title1"><div align="center"> <script language="javascript">swapLang('Name-Surname');</script> </div></td> <td nowrap class="title1"><div align="center"><%=screen.getLabel("MWELFARE","QUANTITY")%></div></td> <td nowrap class="title1"><div align="center"><%=screen.getLabel("COST")%></div></td> <td nowrap class="title1"><div align="center"><%=screen.getLabel("STATUS")%></div></td> <td nowrap class="title1"><div align="center"><%=screen.getLabel("APPROVESTATUS")%></div></td> <td width="8%" nowrap class="title1"><div align="center"><%=screen.getLabel("REFDOC")%></div></td> </tr> <% double i=0,j=0,k=0,cost=0,quantity=0; String webid=""; %> <% while (screen.nextRec()) { if(screen.checkLinePage()){ if(screen.getString("APPROVESTATUS").equals("1")){ ((DbInquiry)screen.getInquiry().getCurrentDbRecord().getChild("MWELFARE")).getCurrentDbRecord().set("_empid",screen.getString("EMPLOYEEID")); j+=Double.parseDouble(chk.chkNullString(screen.getString("MWELFARE","WELQTY"),"0")); k+=Double.parseDouble(chk.chkNullString(screen.getString("COST"),"0")); } quantity=Double.parseDouble(chk.chkNullString(screen.getString("MWELFARE","WELQTY"),"0")); cost=Double.parseDouble(chk.chkNullString(screen.getString("COST"),"0")); if(screen.getString("webid").length()>0){ webid+="'"+screen.getString("webid")+"',"; } %> <tr> <td nowrap><div align="center"><%=screen.getString("approvedate")%></div></td> <td nowrap><div align="center"><%=screen.getString("budyear")%></div></td> <td width="7%" nowrap><div align="center"><a href="javascript:gotopage1('WEL042.jsp','<%=screen.getString("COMPLAINID")%>','<%=screen.getString("CASEID")%>','<%=screen.getString("EMPLOYEEID")%>');"><%=screen.getString("COMPLAINID")%></a></div></td> <td width="6%"><div align="center"><%=screen.getString("CASEID")%></div></td> <td width="8%"><div align="center"><%=screen.getString("WELID")%></div></td> <td width="23%"><%=screen.getString("MWELFARE","TDESC")%>(<%=screen.getString("MSITEWEL","TDESC")%>)</td> <td width="14%" nowrap><%=screen.getString("MEMPLOYEE","FNAME")%> <%=screen.getString("MEMPLOYEE","LNAME")%></td> <td width="7%"><div align="right"><%=df.format(quantity)%></div></td> <td width="7%"><div align="right"><%=df.format(cost)%></div></td> <td width="8%" nowrap><div align="center"><%=screen.getInquiry().getCurrentDbRecord().getSystemCode("STATUS")%></div></td> <td width="8%" nowrap><div align="center"><%=rf.getSystemCode("APPROVE_STATUS",screen.getUProfile().get("lang"),screen.getString("APPROVESTATUS"))%></div></td> <td><div align="center"><%=screen.getString("REFDOC")%></div></tr> <%i++;%> <% } if(screen.outLinePage()){ break; } } %> <tr> <td colspan="5"><div align="right"><strong> <script language="javascript">swapLang('total');</script> </strong></div></td> <td nowrap><div align="right"> <%=i%> </div></td> <td><div align="right"> <script language="javascript">swapLang('List');</script> </div></td> <td nowrap><%=df.format(j)%></td> <td nowrap><%=df.format(k)%></td> <td nowrap> </td> <td nowrap></td> <td nowrap></td> </tr> </table> </td> </tr> <tr> <td colspan="12" class="blankspace"></td> </tr> <tr> <td colspan="12" class="bottom"></td> </tr> </table></td> </tr> </table> <br> </div> </form> </body> </html>