<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <%@page contentType="text/html; charset=UTF-8"%> <%@page import="com.csc.library.entry.*,com.csc.library.system.*,com.csc.library.session.*,com.csc.library.utilities.*,com.csc.library.components.*;"%> <jsp:useBean id="TAMC01" scope="page" class="com.csc.library.system.Task"/> <% TAMC01.setChannel(request ,response); HelpEntry screen=(HelpEntry)TAMC01.process("HelpEntry","MEMPL_BOXHELP"); CheckNull chk = new CheckNull(); int maxRec = 100; screen.setMaxLine(maxRec); String orderBy = chk.chkNullString(request.getParameter("__orderBy")); //out.println("<br>"); //out.println("orderBy : " + orderBy); //String goPage = chk.chkNullString(request.getParameter("__goPage"),"0").replace("+", ""); String filter = "EMPLOYEEID IN(select EMPLOYEEID from MEMPL_BOX where BOX_TYPE='0' group by EMPLOYEEID having COUNT(1)>1 union all select EMPLOYEEID from MEMPL_BOX where BOX_TYPE='0' group by EMPLOYEEID having COUNT(1)=0)"; String filter2 = "EMPLOYEEID IN(select EMPLOYEEID from MEMPL_BOX where BOX_TYPE='0' group by EMPLOYEEID having COUNT(1)>1 )"; screen.inq.setFilter(filter); //screen.getInquiry().setOrderBy("EMPLOYEEID,BOX_TYPE"); //out.println("order by ="+screen.getInquiry().getOrderBy()); screen.process(); screen.getInquiry().setOrderBy("EMPLOYEEID,BOX_TYPE"); //screen.getInquiry().refresh(); %> <html ng-app="myHR"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link href="../CSS/TISCO.css" rel="stylesheet" type="text/css"> <script language="javascript" type="text/javascript" src="../JS/SCREEN.js"></script> <script src="../JS/angular-1.3.15/angular.js" type="text/javascript"></script> <script src="../JS/ANGULAR/SCREEN_ANGULAR.js" type="text/javascript"></script> <script language="javascript" type="text/javascript">setLang("<%=screen.getUProfile().get("lang")%>");</script> <script language="javascript" type="text/javascript">getTitleName();</script> <script language="javascript" type="text/javascript" src="../JS/EMPLOYEE.js"></script> <script language="javascript" type="text/javascript" src="../JS/VIEWCALENDAR.js"></script> <script language="javascript" type="text/javascript" src="../JS/ICONSMENU.js"></script> <script language="javascript" type="text/javascript" src="../JS/HOTKEY.js"></script> <script language="javascript" type="text/javascript"> function foundData(m){ document.getElementById("sizeData").innerHTML = m; } function goPageEdit(page,boxid,empid){ var conSearch = "__boxid$"+boxid+";__employeeid$"+empid+";"; var win = window.open(page+"?__help="+conSearch,"Child","left=150,top=20,width=700,height=200,toolbar=no,status=yes,scrollbars=yes,resizable=yes"); win.focus(); } function goReturn(){ with (document.cscform){ submit(); } } </script> </head> <% String helpReturn=""; if(request.getParameter("__helpReturn")!=null){ helpReturn=request.getParameter("__helpReturn"); } String fieldSearch=""; if(request.getParameter("__fieldSearch")!=null){ fieldSearch=request.getParameter("__fieldSearch"); } %> <body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_preloadImages('../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif')" > <div id="toolTipLayer" style="position:absolute; visibility: hidden"></div> <script language="javascript">initToolTips();</script> <form name="cscform" method="post" action="TAMC01.jsp"> <!----------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 type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>"> <input type="hidden" name="__orderBy" value=""> <input type="hidden" name="__helpReturn" value="<%=helpReturn%>"> <input type="hidden" name="__fieldSearch" value="<%=fieldSearch%>"> <input type="hidden" name="__helpName" value=""> <input type="hidden" name="__pageCall" value=""> <input type="hidden" name="__fixCon" value=""> <input type="hidden" name="__maxRec" value="<%=screen.getRecCount()%>"> <input type="hidden" name="__recCount" value="<%=maxRec%>"> <input type="hidden" name="__screen" value="MAPPROVE_BOX"> <input type="hidden" name="__action" value=""> <input type="hidden" name="__listEmp" value=""> <input type="hidden" name="__confirm" value="s"> <input type="hidden" name="__headMulti" value="TAMC01"> <input type="hidden" name="__childMulti" value="TAMC011"> <br> <table height="" align="center" cellpadding="0" cellspacing="0" class="large"> <tr bgcolor="#3366CC"> <td class="header"><strong>TAMC01, <span swlang code="SW001769">Tamc01</span> </strong></td> </tr> <tr bgcolor="#3366CC"> <td> <table class="maxsize" border="1" cellspacing="1" cellpadding="1"> <tr> <td><table class="maxsize" align="center" cellpadding="0" cellspacing="0"> <tr> <td colspan="4" class="blankspace" ></td> </tr> <tr> <td width="20%"> <div align="right"> <td class="columnlabel"><span swlang code="SW000005">Search By</span> </div></td> <td><div align="left"><%=screen.getTagSearchBy()%></div></td> </tr> <tr> <td><div align="right"> <td class="columnlabel"><span swlang code="SW000006">Condition</span> </div></td> <td><%=screen.getTagConSearch()%></td> </tr> <tr> <td> <div align="right"> <td class="columnlabel"><span swlang code="SW000007">Key Value</span> </div></td> <td><div align="left"><%=screen.getTagValueSearch()%> <a href="javascript:searchH();"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" width="20" height="20" border="0" align="middle"></a></div></td> </tr> <tr> <td colspan="4" class="blankspace" ></td> </tr> <tr> <td colspan="4"> <span swlang code="SW000927">Found Data</span> <span id="sizeData"></span></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td> <br> <table width="" cellpadding="0" cellspacing="1" cols="6" bgcolor="#333333" class="inframe" id="rsTable" name="rsTable"> <tr bgcolor="#3366CC"> <td width="2%" class="row3"><div align="center"><span swlang code="SW000193">Seq</span></td> <td width="3%" class="row3"><div align="center"><span swlang code="SW000011">Code</span></div></td> <td width="10%" class="row3"><div align="center"><span swlang code="SW007745">Name Surname</span></div></td> <td width="15%" class="row3"><div align="center"><span swlang code="SW001766">Work model</span></div></td> <td width="12%" class="row3"><div align="center"><span swlang code="SW000057">Position</span></div></td> </tr> <% /*int c = Integer.parseInt(goPage); int i=0; int j; if(c== 0 || c==1){ j = 1; }else{ j = ((c*maxRec)-maxRec)+1; } */ int j=1; String empId = ""; String tmp=""; while(screen.nextRec()){ screen.referLangOn(); tmp = screen.getString("MEMPLOYEE","EMPLOYEEID"); if(!(empId.equals(tmp))){ %> <tr> <td><div align="center"><%=j%></div></td> <td><div align="center"><%=screen.getString("MEMPLOYEE","EMPLOYEEID")%></div></td> <td><div align="left"><%=screen.getString("MEMPLOYEE","FULLNAME")%></div></td> <td><div align="center"><%=screen.getString("MJOBCODE","TDESC")%></div></td> <td><div align="center"><%=screen.getString("mposition","tdesc")%></div> </tr> <% j++; } %> <tr> <td colspan="2"><div align="center"></div></td> <td colspan ="4"><div align="left"><a href="javaScript:goPageEdit('TAMC011.jsp','<%=screen.getString("BOXID")%>','<%=screen.getString("MEMPLOYEE","EMPLOYEEID")%>')"><%=screen.getString("BOXID") + " " + screen.getInquiry().getCurrentDbRecord().getSystemCode("BOX_TYPE")%></a></div></td> </tr> <% empId = screen.getString("MEMPLOYEE","EMPLOYEEID"); } screen.referLangOff(); %> <script language="javascript">foundData('<%=j-1%>');</script> </table> </td> </tr> <tr> <td colspan="6" class="blankspace"></td> </tr> <tr> <td colspan="6" class="blankspace"></td> </tr> <tr> <td colspan="6" class="bottom"></td> </tr> </table> <!--script language="javascript">passValue();</script--> </form> </body> </html>