<%@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>ตั้งแต่วันที่&nbsp;&nbsp;</b><%=sDate.getDDMMYYYY()%>&nbsp;&nbsp;<b>ถึง</b>&nbsp;&nbsp;<%=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>
<%}%>