<%@page contentType="text/html; charset=UTF-8"%> <%@page import="com.csc.library.util.ManageDocument"%> <%@page import="com.csc.library.entry.*,com.csc.library.utilities.*"%> <%@page import="com.csc.library.session.*"%> <%request.setCharacterEncoding("UTF-8");%> <jsp:useBean id="ADMIN_VIEW" class="com.csc.library.system.Task" scope="page" /> <% ADMIN_VIEW.setChannel(request, response); ADMIN_VIEW.checkProfile(); if( ADMIN_VIEW.getUProfile() != null ){ ADMIN_VIEW.getUProfile().set("appname","WORKFLOW_ADMIN"); CheckNull chkNull = new CheckNull(); //String sort_field = chkNull.chkNullString(request.getParameter("sort_field")); String filter = chkNull.chkNullString(request.getParameter("filter")); //String next_page = chkNull.chkNullString(request.getParameter("next_page")); StringBuffer admin_condition = new StringBuffer(); String empCheck = chkNull.chkNullString(request.getParameter("empCheck")); String employeeid = chkNull.chkNullString(request.getParameter("employeeid")); String fullname = chkNull.chkNullString(request.getParameter("fullname")); String wfCheck = chkNull.chkNullString(request.getParameter("wfCheck")); String wf_id = chkNull.chkNullString(request.getParameter("wf_id")); String wf_id_desc = chkNull.chkNullString(request.getParameter("wf_id_desc")); String docNoCheck = chkNull.chkNullString(request.getParameter("docNoCheck")); String doc_no = chkNull.chkNullString(request.getParameter("doc_no")); String dateCheck = chkNull.chkNullString(request.getParameter("dateCheck")); String start_date = chkNull.chkNullString(request.getParameter("start_date")); String end_date = chkNull.chkNullString(request.getParameter("end_date")); String lateCheck = chkNull.chkNullString(request.getParameter("lateCheck")); String document = chkNull.chkNullString(request.getParameter("wf_document")); CscCalendar sDate = new CscCalendar(start_date); CscCalendar eDate = new CscCalendar(end_date); if( chkNull.chkNullString(request.getParameter("__cmd")).equals("admin_search") ){ if( !employeeid.equals("") ){ //admin_condition.append(" AND ACTOR_ID = '" + employeeid + "'"); if(document.equals("activeDoc")){ admin_condition.append(" AND (ACTOR_ID = '" + employeeid + "' AND (AI_STATUS = '1' OR AI_STATUS = '13') AND STEP_SEQ_NO <> 1 AND DEL_CHECK = '0') OR (ACTOR_ID = '" + employeeid + "' AND ACTOR_SEQ_NO = 1 AND STEP_ID = 1 AND STEP_SEQ_NO = 1 AND WI_COMPLETION_TIME > 0 AND DEL_CHECK = '0') AND (Q_STATUS !='W' AND Q_STATUS !='R' ) AND SI_STATUS = '0'"); }else{ admin_condition.append(" AND ACTOR_ID = '" + employeeid + "'"); } } if( !wf_id.equals("") ){ admin_condition.append(" AND WF_ID = '" + wf_id + "'"); } if( !doc_no.equals("") ){ admin_condition.append(" AND DOC_NO = '" + doc_no + "'"); } if( !start_date.equals("")&&!end_date.equals("")){ admin_condition.append(" AND SI_START_TIME BETWEEN " + new CscCalendar(start_date).getTime() + " AND " + new CscCalendar(end_date).incDate().getTime()); } if( !lateCheck.equals("") ){ admin_condition.append(" AND SI_LATE_DOCUMENT = '2'"); } if( !document.equals("") && document.equals("allDoc")){ admin_condition.append(" AND WI_STATUS IN ('0','1')"); }else if(document.equals("activeDoc")){ admin_condition.append(" AND WI_STATUS = '0'"); }else if(document.equals("completeDoc")){ admin_condition.append(" AND WI_STATUS = '1'"); } if( admin_condition.length() > 0 ){ admin_condition.delete(0, 4); } } HelpEntry screenHelp = (HelpEntry) ADMIN_VIEW.process("HelpEntry","INBOXADMINLIST"); if( !filter.equals("") ){ screenHelp.getInquiry().setFilter(admin_condition.toString() + " AND " + "CATEGORY_ID = '"+filter+"'"); }else{ screenHelp.getInquiry().setFilter(admin_condition.toString()); } screenHelp.getInquiry().setOrderBy("DOC_NO DESC"); //out.print(screenHelp.getInquiry().getFilter()); //out.print(screenHelp.getInquiry().getTableName()); screenHelp.referLangOn(); screenHelp.setMaxLine(100); %> <html ng-app="myHR"> <head> <title>Business Process Management Service</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link href="../CSS/TISCO.css" rel="stylesheet" type="text/css"> <script type='text/javascript' src='../JS/SCREEN.js'></script> <script type="text/javascript" src="../JS/jquery-2.1.3.min.js"></script> <script type="text/javascript" src="../JS/angular-1.3.15/angular.js"></script> <script type="text/javascript" src="../JS/ANGULAR/SCREEN_ANGULAR.js"></script> <script language='javascript'>setLang('<%=screenHelp.getUProfile().get("lang")%>');</script> <script type='text/javascript' src='../JS/DATEINPUT.js'></script> <script type='text/javascript' src='../JS/VIEWCALENDAR.js'></script> <script language="javascript">getTitleName();</script> <SCRIPT LANGUAGE="JavaScript" TYPE="text/JavaScript"> 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_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_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 MM_jumpMenu(targ,selObj,restore){ //v3.0 eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'"); if (restore) selObj.selectedIndex=0; } function goSearch(){ with( document.cscform ){ __cmd.value = "admin_search"; // next_page.value = ""; __goPage.value = ""; submit(); } } function goHelp(helpName,inputName){ with( document.cscform ){ var helpReturn; var temp; var fixcon; if( inputName=="employeeid" ){ temp=__fixCon.value; helpReturn="employeeid:employeeid,fullname:fullname"; }else if( inputName=="wf_id" ){ temp=__fixCon.value; helpReturn="wf_id:wf_id,wf_id_desc:tname"; }else if( inputName=="doc_no" ){ temp=__fixCon.value; helpReturn="doc_no:doc_no"; } linkHelp_Return(helpName,helpReturn); } } function linkHelp_Return(help,input,filter){ with(document.cscform){ if (__fixCon.value!="") __fixCon.value=__fixCon.value ; var nInput = input; if(input.indexOf(":")>0){ nInput=input.substring(0,input.indexOf(":")); } obj = eval("document.cscform."+nInput); if(obj.value==""){ var param="PRU084.jsp?__helpName="+help+"&__helpReturn="+input+"&__pageCall="+__screen.value+"&__fixCon=&__checkVerify=off"; }else{ var param="PRU084.jsp?__helpName="+help+"&__helpReturn="+input+"&__pageCall="+__screen.value+"&__fixCon=&__checkVerify=off"+"&__valueSearch="+obj.value; } window.open(param,"Help","left=150,top=150,width=650,height=450,toolbar=no,status=yes,scrollbars=yes,resizable=yes"); } } function goFilter(con_value){ with( document.cscform ){ if( con_value != 0 ){ filter.value = con_value; //sort_field.value = ""; }else{ filter.value = ""; //sort_field.value = ""; } // next_page.value = ""; __goPage.value = ""; submit(); } } function goPage(select_page){ with( document.cscform ){ if( select_page != "#" ){ //next_page.value = select_page; __cmd.value = '<%=chkNull.chkNullString(request.getParameter("__cmd"))%>'; __goPage.value = select_page; submit(); } } } function getRadio(){ with(document.cscform){ if(__document[1].checked){ wf_document.value=__document[1].value; }else if(__document[2].checked){ wf_document.value=__document[2].value; }if(__document[0].checked){ wf_document.value=__document[0].value; } // alert(wf_document.value); } } function GoExport(){ with(document.cscform){ var late =""; if(lateCheck.checked){ late = lateCheck; } // var param = "TAR1125_EXP.jsp?__start_date="+__start_date.value+"&__end_date="+__end_date.value+"&__bu1="+__bu1.value+"&__bu2="+__bu2.value+"&__bu3="+__bu3.value+"&__bu4="+__bu4.value+"&__salatype="+__salatype.value+""; var param = "ADMIN_VIEW_EXP.jsp?employeeid="+employeeid.value+"&wf_id="+wf_id.value+"&doc_no="+doc_no.value+"&start_date="+start_date.value+"&end_date="+end_date.value+"&lateCheck="+late+"&__document="+wf_document.value; window.open(param); // __export.value = "1"; // action = "PRU212_EXP.jsp"; // target = ""; // submit(); } } function viewCal2(objName){ with(document.cscform){ __calendar.value = objName; __dateformat.value = "DD-MM-YYYY"; } win = window.open("CALENDAR.htm","CALENDAR","left=350,top=250,width=280,height=220,toolbar=no,status=no,scrollbars=no"); if(window.focus){win.focus();} } </script> </head> <body leftmargin="0" topmargin="0" > <script language="javascript">initToolTips();</script> <form name="cscform" method="post" action="ADMIN_VIEW.jsp"> <!----------BEGIN CSC INITIAL ZONE ------------------------> <%=screenHelp.InitialVariable()%> <!----------END CSC INITIAL ZONE --------------------------> <INPUT TYPE="hidden" NAME="__screen" VALUE="ADMIN_VIEW"> <INPUT TYPE="hidden" NAME="__cmd" VALUE=""> <INPUT TYPE="hidden" NAME="__calendar" VALUE=""> <INPUT TYPE="hidden" NAME="__help" VALUE=""> <INPUT TYPE="hidden" NAME="__fixCon" VALUE=""> <INPUT TYPE="hidden" NAME="__language" VALUE="<%=screenHelp.getUProfile().get("lang")%>"> <SCRIPT LANGUAGE="JavaScript">getInputFormatDate();</SCRIPT> <INPUT TYPE="hidden" NAME="filter" VALUE="<%=filter%>"> <INPUT TYPE="hidden" NAME="__goPage" VALUE=""> <INPUT TYPE="hidden" NAME="__wf_id" VALUE=""> <INPUT TYPE="hidden" NAME="__wf_ver" VALUE=""> <INPUT TYPE="hidden" NAME="__wf_seq_no" VALUE=""> <INPUT TYPE="hidden" NAME="param_document" VALUE=""> <INPUT TYPE="hidden" NAME="wf_command" VALUE=""> <INPUT TYPE="hidden" NAME="wf_document" VALUE="<%=chkNull.chkNullString(request.getParameter("wf_document"),"allDoc")%>"> <table height="" align="center" cellpadding="0" cellspacing="0" border="1" class="maxsize"> <tr> <td class="blankspace"></td> </tr> <tr> <td class="header">ADMIN_VIEW,<span swlang code="SW012981">Workflow Document Report</span> </td> </tr> <tr> <td> <table height="" align="center" cellpadding="0" cellspacing="0" border="1" width="80%" class="maxsize"> <tr> <td colspan=2 class="blankspace"></td> </tr> <tr align="center" > <td align="right"><span swlang code="SW011939">Employee Code</span> : </td> <td align="left"> <input type="text" size="10" name="employeeid" value="<%=chkNull.chkNullString(request.getParameter("employeeid"),employeeid)%>" > <a href="javascript:goHelp('MEMPLOYEEHELP','employeeid')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu1','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu1" border="0" align="absmiddle"></a> <input type="text" name="fullname" size="35" value="<%=fullname%>" readonly> </td> </tr> <tr align="center" > <td align="right"><span swlang code="SW012811">Documents Type</span> : </td> <td align="left"> <input type="text" size="10" name="wf_id" value="<%=chkNull.chkNullString(request.getParameter("wf_id"),wf_id)%>" > <a href="javascript:goHelp('WORKFLOW_DEFINITIONHELP','wf_id')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu1','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu1" border="0" align="absmiddle"></a> <input type="text" name="wf_id_desc" size="35" value="<%=wf_id_desc%>" readonly> </td> </tr> <tr align="center" > <td align="right"><span swlang code="SW012812">Documents No</span> : </td> <td align="left"> <input type="text" size="10" name="doc_no" value="<%=chkNull.chkNullString(request.getParameter("doc_no"),doc_no)%>" > <a href="javascript:goHelp('WORKFLOW_DATAHELP','doc_no')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu1','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu1" border="0" align="absmiddle"></a> </td> </tr> <tr align="center" > <td align="right"><span swlang code="SW001033">Date</span> : </td> <td align="left"> <input type="text" name="start_date" size="10" value="<%=start_date%>" onKeyPress="chkIntegerOfDate(this.value);" onKeyUp="formatDate(this);" onBlur="chkInputDate2(this,end_date);checkInput('start_date','dateCheck','')" onFocus="this.select();"> <a href="javascript:;" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('StartDate','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)" onClick="viewCal2('start_date')"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="StartDate" width="20" height="20" border="0" align="absmiddle" id="StartDate"></a> <span swlang code="SW005755">To</span> <input type="text" NAME="end_date" SIZE="10" value="<%=end_date%>" onKeyPress="chkIntegerOfDate(this.value);" onKeyUp="formatDate(this);" onBlur="chkInputDate2(start_date,this);checkInput('end_date','dateCheck','')" onFocus="this.select();"> <a href="javascript:;" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('EndDate','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)" onClick="viewCal2('end_date')"><IMG src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="EndDate" width="20" height="20" border="0" align="absmiddle" ID="EndDate"></a> </td> </tr> <tr align="center" > <td align="right"><span swlang code="SW012813">Documents Late</span> : </td> <td align="left"> <INPUT TYPE="checkbox" NAME="lateCheck" VALUE="lateCheck" <%=(!lateCheck.equals("")?"CHECKED":"")%>> </td> </tr> <tr align="center" > <td align="right"><script language="javascript">swapLang('')</script> </td> <td align="left"> <INPUT TYPE="radio" NAME="__document" VALUE="allDoc" <%=(document.equals("") || document.equals("allDoc")?"CHECKED":"")%> onClick="getRadio();"> <span swlang code="SW012978">All Document</span> <INPUT TYPE="radio" NAME="__document" VALUE="activeDoc" <%=( document.equals("activeDoc")?"CHECKED":"")%> onClick="getRadio();"> <span swlang code="SW012979">Active Document</span> <INPUT TYPE="radio" NAME="__document" VALUE="completeDoc" <%=(document.equals("completeDoc")?"CHECKED":"")%> onClick="getRadio();"> <span swlang code="SW012980">Complete Document</span> </td> </tr> <tr> <td colspan=2 class="blankspace"></td> </tr> <tr> <td colspan=2><div align="center"><a href="javascript:goSearch();"><img src="../IMAGES/BUTTON/SEARCH.gif" alt="Submit" border="0" align="absmiddle"></a></div></td> </tr> <tr> <td colspan=2 class="blankspace"></td> </tr> </table> </td> </tr> <tr> <td colspan=2 class="blankspace"></td> </tr> <%if( chkNull.chkNullString(request.getParameter("__cmd")).equals("admin_search") ){%> <tr> <td> <table height="" align="center" cellpadding="0" cellspacing="0" border="1" width="80%" class="maxsize"> <tr align="center"> <td> <b><span swlang code="SW012981">Workflow Document Report</span></b> </td> </tr> <%if(!start_date.equals("")&&!end_date.equals("")){%> <tr align="center"> <td> <b>ตั้งแต่วันที่ </b><%=sDate.getDDMMYYYY()%> <b>ถึง</b> <%=eDate.getDDMMYYYY()%> </td> </tr> <%}%> <tr align="center"> <td> <table height="" align="center" cellpadding="0" cellspacing="1" border="1" width="80%" class="maxsize" bgcolor="FFFFF"> <tr align="center"> <td class="row1"><span swlang code="SW000193">Seq</span></td> <td class="row1"><span swlang code="SW001033">Date</span></td> <td class="row1"><span swlang code="SW001104">Initiator</span></td> <td class="row1"><span swlang code="SW009638">Receive Doc</span></td> <td class="row1"><span swlang code="SW009639">DocNo</span></td> <td class="row1"><span swlang code="SW000352">Doc Type</span></td> <td class="row1"><span swlang code="SW000019">Status</span></td> </tr> <% String temp=""; int browse_page = Integer.parseInt(screenHelp.goPage); screenHelp.process(); int seq =1; while( screenHelp.nextRec() ){ if(!temp.equals(screenHelp.getInquiry().getString("FDOC_NO"))){ temp=screenHelp.getInquiry().getString("FDOC_NO"); %> <tr align="center"> <td class="center"><%=seq%></td> <td align="left" class=""><%=screenHelp.getInquiry().getString("FSI_START_TIME")%></td> <td align="left" class=""><%=screenHelp.getInquiry().getString("FBEGINER")%></td> <td align="left" class=""><%=screenHelp.getInquiry().getString("FRECEIVER")%></td> <td align="center" class=""><%=screenHelp.getInquiry().getString("FDOC_NO")%></td> <td align="left" class=""><%=screenHelp.getInquiry().getString("SUBJECT")%></td> <td align="center" class=""> <% if(screenHelp.getInquiry().getString("WI_STATUS").equals("0")){ %> <span swlang code="SW009656">Working</span> <% }else if(screenHelp.getInquiry().getString("WI_STATUS").equals("1")){ %> <span swlang code="SW002211">Approved</span> <% }else if(screenHelp.getInquiry().getString("WI_STATUS").equals("2")){ %> <span swlang code="SW009621">Disapprove</span> <% }else if(screenHelp.getInquiry().getString("WI_STATUS").equals("3")){ %> <span swlang code="SW009705">No Recipient</span> <% }else if(screenHelp.getInquiry().getString("WI_STATUS").equals("4")){ %> <span swlang code="SW012132">Cancel</span> <% }else if(screenHelp.getInquiry().getString("WI_STATUS").equals("5")){ %> <span swlang code="SW012132">Cancel</span> <% }else if(screenHelp.getInquiry().getString("WI_STATUS").equals("6")){ %> <span swlang code="SW009700">Return</span> <% } %> </td> </tr> <% seq++; } } %> </table> </td> </tr> </table> </td> </tr> <tr> <td align="right"> <b><span swlang code="SW001120">Page</span> </b> <SELECT NAME="listpage" onChange="goPage(this.value)" CLASS="txtInbox"> <% for( int i = 1 ; i <= screenHelp.getMaxPage() ; i++ ){ %> <OPTION VALUE="<%=i%>" <%=(browse_page==i?"SELECTED":"")%>><%=i%></OPTION> <% } %> </SELECT> </td> </tr> <tr> <td colspan=2 class="blankspace"></td> </tr> <tr> <td > <table class="maxsize" align="center" cellpadding="0" cellspacing="0" class="large"> <tr> <td align="center"><div class="button"><a href="javascript:GoExport();"><img src="../IMAGES/BUTTON/EXPORT.gif" border=0 /></a></div></td> </tr> </table> </td> </tr> <%}%> <tr> <td colspan=2 class="blankspace"></td> </tr> </table> </form> </body> </html> <%}%>