<%@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>&nbsp;</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>&nbsp;:&nbsp;</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>&nbsp;:&nbsp;</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>&nbsp;:&nbsp;</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>&nbsp;:&nbsp;</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>&nbsp;

						<span swlang code="SW005755">To</span>&nbsp;

						<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>&nbsp;:&nbsp;</td>
					<td align="left">
						<INPUT TYPE="checkbox" NAME="lateCheck" VALUE="lateCheck" <%=(!lateCheck.equals("")?"CHECKED":"")%>>&nbsp;&nbsp;
					</td>
				</tr>
				<tr align="center" >
					<td align="right"><script language="javascript">swapLang('')</script>&nbsp;&nbsp;</td>
					<td align="left">
						<INPUT TYPE="radio" NAME="__document" VALUE="allDoc" <%=(document.equals("") || document.equals("allDoc")?"CHECKED":"")%> onClick="getRadio();">&nbsp;&nbsp;<span swlang code="SW012978">All Document</span>&nbsp;
						<INPUT TYPE="radio" NAME="__document" VALUE="activeDoc" <%=( document.equals("activeDoc")?"CHECKED":"")%> onClick="getRadio();">&nbsp;&nbsp;<span swlang code="SW012979">Active Document</span>&nbsp;
						<INPUT TYPE="radio" NAME="__document" VALUE="completeDoc" <%=(document.equals("completeDoc")?"CHECKED":"")%> onClick="getRadio();">&nbsp;&nbsp;<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>ตั้งแต่วันที่&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="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>&nbsp;&nbsp;</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>
<%}%>