<%@page contentType="text/html; charset=UTF-8"%> <%@page import="com.csc.library.entry.*,com.csc.library.system.*,com.csc.library.utilities.*"%> <jsp:useBean id="WEL022_KKB" class="com.csc.library.system.Task" scope="page" /> <% WEL022_KKB.setChannel(request, response); HelpEntry screen = (HelpEntry) WEL022_KKB.process("HelpEntry","WEL022_KKB"); screen.inq.setFilter("status<>'1' and employeeid='"+screen.getUProfile().get("employeeid")+"' and approvestatus<>'3' "); screen.process(); CheckNull chk=new CheckNull(); ThaiUtilities thail = new ThaiUtilities(); java.text.DecimalFormat df=new java.text.DecimalFormat("#,###,##0.00"); String condition=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__fixCon"))); 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"))); // String keyword=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__keyword"))); %> <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"> <script language="JavaScript" src="../JS/SCREEN.js"></script> <script language='javascript' src="../JS/VIEWCALENDAR.js"></script> <script language='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 postnew(page){ with(document.cscform){ open(page,"post","height=420,width=600"); } } function helpSearch(empid,docno,formula){ with(document.cscform){ //alert("empid="+empid+",docno="+docno+",formula="+formula); __help.value="__employeeid#"+empid+",__docno#"+docno+",__formulaid#"+formula+",__companyid#"+__companyid.value; __lockPage.value="true"; alert("__help="+__help.value); action="PRU071.jsp"; submit(); } } function gotopage(page){ with(document.cscform){ action=page; submit(); } } function gotopage2(page,idno,caseid,empid){ with(document.cscform){ action=page; __complainid.value=idno; __fixCon.value="complainid='"+idno+"' and caseid='"+caseid+"' and employeeid='"+empid+"'"; __cmd.value="search"; submit(); } } function GoSave() {} function GoDelete(){} function setFixCon(fixCon){ var _fix=(fixCon.length>0)?(fixCon+" and status<>'1' and employeeid='<%=screen.getUProfile().get("employeeid")%>' and approvestatus<>'3' ") : (" status<>'1' and employeeid='<%=screen.getUProfile().get("employeeid")%>' and approvestatus<>'3' "); return _fix; } function GoSearch() { with(document.cscform) { if(__welid1.value=="" && __welid2.value=="" && __startdate.value=="" && __enddate.value=="") { __fixCon.value=""; } else if(__welid1.value=="" && __welid2.value!="" || __welid1.value!="" && __welid2.value=="" || __startdate.value=="" && __enddate.value!="" || __startdate.value!="" && __enddate.value=="") { alert("Invalid Input!!"); } else if(__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(__welid1.value=="" && __welid2.value=="") { var stdate=""; var endate=""; stdate=chkDateTime2(__startdate.value,"-"); endate=chkDateTime2(__enddate.value,"-"); if(stdate>endate) { var tmp=endate; endate=stdate; stdate=tmp; } __fixCon.value="(STARTDATE >='"+stdate+"')and(ENDDATE <='"+endate+"')"; } else { var stdate=""; var endate=""; stdate=chkDateTime2(__startdate.value,"-"); endate=chkDateTime2(__enddate.value,"-"); if(__welid1.value>__welid2.value) { var tmp=__welid2.value; __welid2.value=__welid1.value; __welid1.value=tmp; } if(stdate>endate) { var tmp=endate; endate=stdate; stdate=tmp; } __fixCon.value="(welid>='"+__welid1.value+"')and(welid<='"+__welid2.value+"')and(startdate>='"+stdate+"')and(enddate<='"+endate+"')"; } __fixCon.value=setFixCon(__fixCon.value); search(); } } function GoUpdate(){} function goHelp(helpName,inputName){ var helpReturn; if(inputName=="__welid1" ) helpReturn="__welid1:WELID,MWELFARE@WELID"; else if(inputName=="__welid2" ) helpReturn="__welid2:WELID,MWELFARE@WELID"; helpPageCon(helpName,helpReturn,""); } function gotopage1(page,idno,caseid,docgid,empid,budid,whouse,edu){ with(document.cscform){ action=page; __complainid.value=idno; if(caseid!=""){ __caseid.value=caseid; } __budid1.value=budid; __whouse1.value=whouse; __edu.value=edu; __help.value="__complainid#"+idno+",__caseid#"+caseid+",__docgid#"+docgid+""; //__fixCon.value="complainid='"+idno+"' and caseid='"+caseid+"' and employeeid='"+empid+"'"; __cmd.value="search"; submit(); } } //--> </script> <style type="text/css"> <!-- .style1 {color: #FF0000} --> </style> </head> <body> <div class="centered"> <div id="toolTipLayer" style="position:absolute; visibility: hidden"></div> <script language="javascript">initToolTips();</script> <form name="cscform" method="post"> <!----------BEGIN CSC INITIAL ZONE ------------------------> <%=screen.InitialVariable()%> <!----------END CSC INITIAL ZONE --------------------------> <input type="hidden" name="__calendar"> <script language="javascript">getInputFormatDate();</script> <input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>"> <input type="hidden" name="__cmd" value=""> <input type="hidden" name="__help" value=""> <input type="hidden" name="__goPage" value=""> <input type="hidden" name="__orderBy" value=""> <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="__lockPage" value=""> <input type="hidden" name="__employeeid" value=""> <input type="hidden" name="__docno" value=""> <input type="hidden" name="__formulaid" value=""> <input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>"> <input type="hidden" name="__webid" value=""> <input type="hidden" name="__complainid" value=""> <input type="hidden" name="__whouse1" value=""> <input type="hidden" name="__budid1" value=""> <input type="hidden" name="__caseid" value=""> <input type="hidden" name="__fixCon" value=""> <input type="hidden" name="__reader" value=""> <input type="hidden" name="__edu" value=""> <input name="__screen" type="hidden" value="WEL022_KKB"> <script language="javascript"> var titlename=swap2String('Requisition of welfare'); document.write(Icons("WEL022_KKB,"+titlename)); </script> <div align="center"> <table class="largest" cellpadding="0" cellspacing="0"> <tr > <td colspan="2" class="header" >WEL022, <script language="javascript">swapLang('Requisition of welfare');</script> </td> </tr> <tr > <td ><table class="maxsize" border="0" align="center" cellpadding="0" cellspacing="1"> <tr> <td colspan="11" class="blankspace"> <table width="638" border="0" align="center" cellpadding="0" cellspacing="1" class="inframe"> <tr> <td colspan="2" class="columnlabel_baseline2"><div align="right"></div></td> </tr> <tr> <td colspan="2" class="row1"><span class="header"> <script language="javascript">swapLang('Requisition of welfare');</script> </span></td> </tr> <tr> <td class="columnlabel_baseline"> <strong> <script language="javascript">swapLang('Order By');</script> </strong></td> <td nowrap class="maxsize"><%=screen.getTagOrder()%></td> </tr> <tr> <td class="columnlabel_baseline"><strong> <script language="javascript">swapLang('Welfare ID');</script> </strong></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"><strong> <script language="javascript">swapLang('Date Between');</script> </strong></td> <td><input name="__startdate" type="text" size="10" readonly value="<%=stdate%>"> <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" readonly value="<%=endate%>"> <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"><strong> </strong></td> <td><a href="javascript:GoSearch();"><img src="../IMAGES/BUTTON/SEARCH.gif" border="0"></a></td> </tr> <tr> <td colspan="2" class="columnlabel_baseline2"><div align="right"><%=screen.getPageTag()%></div></td> </tr> </table> <table width="200" border="0" cellpadding="0" cellspacing="1" bgcolor="#808080" class="inframe"> <tr class="title1"> <td width="6%" nowrap class="title1"><div align="center"></div></td> <td width="8%" nowrap class="title1"><div align="center" ><strong><%=screen.getLabel("STARTDATE")%></strong></div></td> <td width="6%" nowrap class="title1"><div align="center"><strong><%=screen.getLabel("ENDDATE")%></strong></div></td> <td width="7%" nowrap class="title1"><div align="center"><strong><%=screen.getLabel("COMPLAINID")%></strong></div></td> <td width="6%" nowrap class="title1"><div align="center"><strong><%=screen.getLabel("CASEID")%></strong></div></td> <td width="8%" nowrap class="title1"> <div align="center"><strong><%=screen.getLabel("WELID")%></strong></div></td> <td width="23%" nowrap class="title1"><div align="center"><strong><%=screen.getLabel("CASEDESC")%></strong></div></td> <td width="7%" nowrap class="title1"><div align="center"><strong><%=screen.getLabel("MWELFARE","QUANTITY")%></strong></div></td> <td width="7%" nowrap class="title1"><div align="center"><strong><%=screen.getLabel("COST")%></strong></div></td> <td width="8%" nowrap class="title1"><div align="center"><strong><%=screen.getLabel("STATUS")%></strong></div></td> </tr> <% int i=0; double quantity=0,mquantity=0; double cost=0,mcost=0; while (screen.nextRec()) { if(screen.checkLinePage()){ i++; mquantity=Double.parseDouble(chk.chkNullString(screen.getString("MWELFARE","QUANTITY"),"0")); quantity+=mquantity; mcost=Double.parseDouble(chk.chkNullString(screen.getString("COST"),"0")); cost+=mcost; %> <!--% int i=1,j=0,k=0%--> <tr> <td nowrap><div align="center"><span class="blankspace style1"><a href="javascript:gotopage1('WEL015_NSTDA.jsp','<%=screen.getString("COMPLAINID")%>','<%=screen.getString("CASEID")%>','<%=screen.getString("MWELFARE","DOCGID")%>','<%=screen.getString("EMPLOYEEID")%>','<%=screen.getString("MWELFARE","BUDID")%>','<%=screen.getString("MWELFARE","WHOUSE")%>','<%=screen.getString("MWELFARE","ISEDUCATION")%>');"><img src="../IMAGES/BUTTON/MAIN/NEW20.gif" alt="new case" width="16" height="16" border="0" ></a></span></div></td> <td nowrap> <div align="center"> <%=screen.getString("STARTDATE")%></div></td> <td nowrap> <div align="center"> <%=screen.getString("ENDDATE")%></div></td> <td> <div align="center"><a href="javascript:gotopage2('WEL017.jsp','<%=screen.getString("COMPLAINID")%>','<%=screen.getString("CASEID")%>','<%=screen.getString("EMPLOYEEID")%>');" ><%=screen.getString("COMPLAINID")%></a></div></td> <td><div align="center"><%=screen.getString("CASEID")%></div></td> <td> <div align="center"><%=screen.getString("WELID")%></div></td> <td> <div align="center"><%=screen.getString("CASEDESC")%></div></td> <td><div align="center"><%=df.format(mquantity)%></div></td> <td> <div align="right"><%=df.format(mcost)%></div></td> <td nowrap> <div align="center"><%=screen.getInquiry().getCurrentDbRecord().getSystemCode("STATUS")%></div></td> </tr> <% } if(screen.outLinePage()){ break; } }%> <tr> <td colspan="6" class="blankspace"><div align="right"><strong> <script language="javascript">swapLang('total');</script> </strong></div></td> <td><div align="right"><strong> </strong></div> <div align="right"><%=i%> <script language="javascript">swapLang('List');</script> </div></td> <td align="center"><%=df.format(quantity)%></td> <td align="center"><%=df.format(cost)%></td> <td></td> </tr> </table> </td> </tr> <tr> <td colspan="11" class="blankspace"></td> </tr> <tr> <td colspan="11" class="blankspace"><div align="center"><a href="javascript:gotopage('WEL015_KKB.jsp')"><img src="../IMAGES/BUTTON/ADD.gif" alt="เพิ่มรายการใหม่" border="0"></a></div></td> </tr> <tr> <td colspan="11" class="bottom"></td> </tr> </table> </td> </tr> </table> </div> </form> </body> </html>