<%@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>
<%}%>