<%@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" /> <% response.setHeader("Cache-Control","must-revalidate"); response.setContentType("application/vnd.ms-excel; UTF-8"); response.setHeader("Content-Disposition", "inline; filename=" + "export.xls"); 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("__document")); CscCalendar sDate = new CscCalendar(start_date); CscCalendar eDate = new CscCalendar(end_date); if( !employeeid.equals("") ){ 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 WI_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()); } //out.print(screenHelp.getInquiry().getFilter()); screenHelp.getInquiry().setOrderBy("DOC_NO DESC"); screenHelp.referLangOn(); screenHelp.setMaxLine(-1); %> <html> <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 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 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){ // alert(__filter.value); // 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="+lateCheck.value+"&__document="+wf_document.value+"&admin_condition=<%=admin_condition%>"; window.open(param); // __export.value = "1"; // action = "PRU212_EXP.jsp"; // target = ""; // submit(); } } </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="<%=chkNull.chkNullString(request.getParameter("__wf_id"))%>"> <INPUT TYPE="hidden" NAME="employeeid" VALUE="<%=chkNull.chkNullString(request.getParameter("employeeid"))%>"> <INPUT TYPE="hidden" NAME="doc_no" VALUE="<%=chkNull.chkNullString(request.getParameter("doc_no"))%>"> <INPUT TYPE="hidden" NAME="start_date" VALUE="<%=chkNull.chkNullString(request.getParameter("start_date"))%>"> <INPUT TYPE="hidden" NAME="end_date" VALUE="<%=chkNull.chkNullString(request.getParameter("end_date"))%>"> <INPUT TYPE="hidden" NAME="lateCheck" VALUE="<%=chkNull.chkNullString(request.getParameter("lateCheck"))%>"> <INPUT TYPE="hidden" NAME="__document" VALUE="<%=chkNull.chkNullString(request.getParameter("__document"))%>"> <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> <table height="" align="center" cellpadding="0" cellspacing="0" border="1" width="" class="maxsize"> <tr align="center"> <td> <b>รายงานเอกสารปัจจุบัน</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="0" border="1" width="" class="maxsize" bgcolor=""> <tr align="center"> <td>ลำดับ</td> <td>วันที่</td> <td>ผู้เริ่มงาน</td> <td>ผู้ส่งเอกสาร</td> <td>เลขที่เอกสาร</td> <td>ชื่อเอกสาร</td> <td>สถานะ</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("FWI_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")){ out.print("รออนุมัติ"); }else if(screenHelp.getInquiry().getString("WI_STATUS").equals("1")){ out.print("อนุุมัติ"); }else if(screenHelp.getInquiry().getString("WI_STATUS").equals("2")){ out.print("ไม่อนุมัติ"); }else if(screenHelp.getInquiry().getString("WI_STATUS").equals("3")){ out.print("ไม่มีผู้รับงาน"); }else if(screenHelp.getInquiry().getString("WI_STATUS").equals("4")){ out.print("ยกเลิก"); }else if(screenHelp.getInquiry().getString("WI_STATUS").equals("5")){ out.print("ยกเลิก"); }else if(screenHelp.getInquiry().getString("WI_STATUS").equals("6")){ out.print("ส่งงานกลับ"); } %> </td> </tr> <% seq++; } } %> </table> </td> </tr> </table> </td> </tr> </table> </form> </body> </html> <%}%>