<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.utilities.CscCalendar,com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*"%>
<%@page import="com.csc.library.utilities.CscTime, com.csc.library.database.SystemCode, java.util.*,com.csc.library.report.*"%>
<%@page import="com.csc.library.session.*"%>
<jsp:useBean id="TAU1211" class="com.csc.library.system.Task" scope="page" />
<%
	TAU1211.setChannel(request, response);
	HelpEntry screen = (HelpEntry) TAU1211.process("HelpEntry", "TAU1211");
	screen.setMaxLine(20);
	screen.process();
	//out.print("select * from "+screen.inq.getTableName()+" where "+screen.inq.getFilter());
	ThaiUtilities thai=new ThaiUtilities();
	ReportUDF rt=new ReportUDF();
	CheckNull chk = new CheckNull();
	/*
	 * Error_Type
	 *		ลืมรูดเข้า = FORGOT-IN ---> 0
	 * 		ลืมรูดออก = FORGOT-OUT ---> 1
	 * 		สาย = LATE ---> 2
	 * 		โอทีก่อนเวลา = OT-BEFORE ---> 3
	 * 		โอทีหลังเวลา = OT-AFTER ---> 4
	 * 		ออกก่อนเวลา = OUT-ABSENT ---> 5
	 * 		เข้าช้า = IN-ABSENT ---> 6
	 * 		//รูดเข้าหลายครั้ง = IN-MORE ---> 7 NOT USE
	 * 		//รูดออกหลายครั้ง = OUT-MORE ---> 8 NOT USE
	 * 		//ทำงานก่อนเวลางาน WK-BEFORE ---> 9 NOT USE
	 * 		//ทำงานหลังเวลางาน WK-AFTER ---> 10 NOT USE
	 * 		รูดบัตรในวันหยุดงาน WK-HOLIDAY ---> 11
	 * 		โอทีเกินก่อนเวลา OT-OVER-BEFORE ---> 12
	 * 		โอทีเกินหลังเวลา OT-OVER-AFTER ---> 13
	 *    	โอทีขาดก่อนเวลา OT-LESS-BEFORE ---> 14
	 * 		โอทีขาดหลังเวลา OT-LESS-AFTER ---> 15
	 */
	TreeMap hmErrorType = new TreeMap();
	String lang = screen.getUProfile().get("lang");
	String[][] sysCode = SystemCode.getContent("ERROR_TYPE");
	for(int i=0;i<sysCode.length;i++){
		String key = sysCode[i][0];
		if (Integer.parseInt(key)>=7 && Integer.parseInt(key)<=10) {
			continue;
		}

		if (Integer.parseInt(key)<10) {
			key = "warn0"+key;
		} else {
			key = "warn"+key;
		}

		String value = sysCode[i][1];
		if (((String)screen.getUProfile().get("lang")).equalsIgnoreCase("tha")) {
			value = value.substring(value.indexOf(",") + 1);
		} else {
			value = value.substring(0, value.indexOf(","));
		}
		hmErrorType.put(key, value);
	}


	DbInquiry dbssec = new InitialInquiry(screen.getUProfile()).getDbInquiry("ssecurity");
	dbssec.setColumn("*");
	dbssec.setFilter("employeeid = '"+screen.getUProfile().get("employeeid")+"' AND isviewall ='1'");
	dbssec.refresh();
	String filter = "1=1";
	String reportfilter = "1=1";

	if (dbssec.recCount()>0){
		dbssec.next();

		if (dbssec.getString("isemp_position").equalsIgnoreCase("1")){
			filter +=chkMySecurity(dbssec.getString("positionstatus"),"emp_position",dbssec.getString("positionlist"));
			reportfilter +=chkMySecurity(dbssec.getString("positionstatus"),"emp_position",dbssec.getString("positionlist"));
		}

		if (dbssec.getString("isemp_group").equalsIgnoreCase("1")){
			filter +=chkMySecurity(dbssec.getString("empgroupstatus"),"emp_group",dbssec.getString("empgrouplist"));
			reportfilter +=chkMySecurity(dbssec.getString("empgroupstatus"),"emp_group",dbssec.getString("empgrouplist"));
		}

		if (dbssec.getString("isbu1").equalsIgnoreCase("1")){
			filter +=chkMySecurity(dbssec.getString("bu1status"),"bu1",dbssec.getString("bu1list"));
			reportfilter +=chkMySecurity(dbssec.getString("bu1status"),"bu1",dbssec.getString("bu1list"));
		}

		if (dbssec.getString("isbu2").equalsIgnoreCase("1")){
			filter +=chkMySecurity(dbssec.getString("bu2status"),"bu2",dbssec.getString("bu2list"));
			reportfilter +=chkMySecurity(dbssec.getString("bu2status"),"bu2",dbssec.getString("bu2list"));
		}

		if (dbssec.getString("isbu3").equalsIgnoreCase("1")){
			filter +=chkMySecurity(dbssec.getString("bu3status"),"bu3",dbssec.getString("bu3list"));
			reportfilter +=chkMySecurity(dbssec.getString("bu3status"),"bu3",dbssec.getString("bu3list"));
		}

		if (dbssec.getString("isbu4").equalsIgnoreCase("1")){
			filter +=chkMySecurity(dbssec.getString("bu4status"),"bu4",dbssec.getString("bu4list"));
			reportfilter +=chkMySecurity(dbssec.getString("bu4status"),"bu4",dbssec.getString("bu4list"));
		}

		if (dbssec.getString("isjob").equalsIgnoreCase("1")){
			filter +=chkMySecurity(dbssec.getString("jobstatus"),"job",dbssec.getString("joblist"));
			reportfilter +=chkMySecurity(dbssec.getString("jobstatus"),"job",dbssec.getString("joblist"));
		}

		if (dbssec.getString("isbranch").equalsIgnoreCase("1")){
			filter +=chkMySecurity(dbssec.getString("branchstatus"),"branch",dbssec.getString("branchlist"));
			reportfilter +=chkMySecurity(dbssec.getString("branchstatus"),"branch",dbssec.getString("branchlist"));
		}

		if (dbssec.getString("issalatype").equalsIgnoreCase("1")){
			filter +=chkMySecurity(dbssec.getString("salatypestatus"),"salatype",dbssec.getString("salatypelist"));
			reportfilter +=chkMySecurity(dbssec.getString("salatypestatus"),"salatype",dbssec.getString("salatypelist"));
		}

		if (dbssec.getString("ispl").equalsIgnoreCase("1")){
			filter +=chkMySecurity(dbssec.getString("plstatus"),"pl",dbssec.getString("pllist"));
			reportfilter +=chkMySecurity(dbssec.getString("plstatus"),"pl",dbssec.getString("pllist"));
		}

		if (dbssec.getString("isworkarea").equalsIgnoreCase("1")){
			filter +=chkMySecurity(dbssec.getString("workareastatus"),"workarea",dbssec.getString("workarealist"));
			reportfilter +=chkMySecurity(dbssec.getString("workareastatus"),"workarea",dbssec.getString("workarealist"));
		}
	}
	//out.print("filter :: "+filter);

%>
<html ng-app="myHR">
<head>
<title></title>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link href="../CSS/TISCO.css" rel="stylesheet" type="text/css">
<link href="../CSS/bootstrap.css" rel="stylesheet"  type="text/css">
<link href="../CSS/bootstrap_csc_backend.css" rel="stylesheet"  type="text/css">
<script type="text/javascript" src="../JS/jquery-2.1.3.min.js"></script>
<script type='text/javascript' src="../JS/bootstrap.js"></script>
<script type='text/javascript' src='../JS/SCREEN.js'></script>
<script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script type='text/javascript' src='../JS/DATEINPUT.js'></script>
<script type='text/javascript' src='../JS/VIEWCALENDAR.js'></script>
<script src="../JS/angular-1.3.15/angular.js"></script>
<script type='text/JavaScript' SRC='../JS/ANGULAR/SCREEN_ANGULAR.js'></script>
<script language="javascript">getTitleName();</script>
<STYLE type=text/css>
FONT.holiday {
	FONT-FAMILY: "MS Sans Serif", sans-serif, "Microsoft Sans Serif";
	font-size: 12px;
	color: #FF00FF;
	}
FONT.absent {
	FONT-FAMILY: "MS Sans Serif", sans-serif, "Microsoft Sans Serif";
	font-size: 12px;
	color: #FF0000;
	}
</style>

<script language="JavaScript" type="text/JavaScript">

function pageDesc(empid, dateid,seq){
	with(document.cscform) {
		var d=chkDateTime1(dateid);
		var filterCon = "employeeid='"+empid+"' and (dateid='"+d+"') and sequence='"+seq+"'";

		//alert(filterCon);
		window.open("TAU1212.jsp?__cmd="+
			"&__fixCon="+filterCon,
			"ShowWarning","left=150,top=100,width=550,height=300,toolbar=no,status=yes,scrollbars=yes,resizable=yes"
		);
	}
}

function linkHelp_Return(help,input,filter){
	with(document.cscform){
		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="+filter+"&__checkVerify=off";
		}else{
				var param="PRU084.jsp?__helpName="+help+"&__helpReturn="+input+"&__pageCall="+__screen.value+"&__fixCon="+filter+"&__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 chkDateTime1(valueSearch){
	var tmpval="";
	with(document.cscform){
		var valueSearch1=valueSearch.split("-");
		if(valueSearch1.length==3){
			if(valueSearch1[1].length==1){
				valueSearch1[1]="0"+valueSearch1[1];
			}
			if(valueSearch1[0].length==1){
				valueSearch1[0]="0"+valueSearch1[0];
			}
			valueSearch1[2]=parseInt(valueSearch1[2]);
			return valueSearch=valueSearch1[2]+"-"+valueSearch1[1]+"-"+valueSearch1[0];
		}
	}
}

function goHelp(helpName,inputName,filter){
	var helpReturn;
	var fixcon;
	if(inputName.indexOf("__emp") > -1){
		helpReturn = inputName+":employeeid"
	}
	fixcon="";
	linkHelp_Return(helpName,helpReturn,fixcon);
}

function goHelpBu(helpName,inputName,filter){
	var helpReturn;
	var fixcon;

	if(inputName=="__bu1"){
		helpReturn = inputName+":bu1id,"+inputName+"_desc:edesc";
	}else	if(inputName=="__bu2"){
		helpReturn = inputName+":bu2id,"+inputName+"_desc:edesc";
	}else	if(inputName=="__bu3"){
		helpReturn = inputName+":bu3id,"+inputName+"_desc:edesc";
	}else	if(inputName=="__bu4"){
		helpReturn = inputName+":bu4id,"+inputName+"_desc:edesc";
	}else	if(inputName=="__bu5"){
		helpReturn = inputName+":bu5id,"+inputName+"_desc:edesc";
	}
	fixcon="";
	linkHelp_Return(helpName,helpReturn,fixcon);
}

function setSubmit(){
	var altEmp="Please Insert Employee 1 Less Employee 2";
	with(document.cscform){
		if(__language.value=="tha") altEmp="กรุณากรอกข้อมูลพนักงาน 1 น้อยกว่าพนักงาน 2";
		if(__emp1.value <= __emp2.value){
			setFilter();
		} else alert(MyCode[101]);
	}

}

function chkAll(){
	with (document.cscform){
		for (i=0;i<elements.length;i++){
			if (elements[i].name.indexOf("error_") > -1){
				if(errorall.checked){
				//alert(i);
					elements[i].checked=true;
				}else{
					elements[i].checked=false;
				}
			}
		}
	}
}

function setFilter(){
	with(document.cscform){
		__cmd.value="search";
		var temp = __fixCon.value;
		var ssecurity=__filter.value;
		var sqlEmp="1=1 ";
		var sqlDate="";
		var sqlBu1="";
		var sqlBu2="";
		var sqlBu3="";
		var sqlBu4="";
		var sqlBu5="";
		var sqlResigdate = " dateid between (select startdate from memployee m where m.employeeid=ttime_current1.employeeid) and (select endworkdate from memployee m where m.employeeid=ttime_current1.employeeid)";

		if (__emp1.value.length>0 && __emp2.value.length>0)
			sqlEmp = " (employeeid between '"+__emp1.value+"' and '"+__emp2.value+"') ";
		else if (__emp1.value.length>0 && __emp2.value.length==0)
			sqlEmp = " employeeid='"+__emp1.value+"' ";
		else if (__emp2.value.length>0 && __emp1.value.length==0)
			sqlEmp = " employeeid='"+__emp2.value+"' ";

		if (__date1.value.length>0 && __date2.value.length>0)
			sqlDate = " (dateid between '"+chkDateTime1(__date1.value)+"' and '"+chkDateTime1(__date2.value)+"') ";
		else if (__date1.value.length>0 && __date2.value.length==0)
			sqlDate = " dateid='"+chkDateTime1(__date1.value)+"' ";
		else if (__date2.value.length>0 && __date1.value.length==0)
			sqlDate = " dateid='"+chkDateTime1(__date2.value)+"' ";

		if (__bu1.value.length>0)
			sqlBu1 = " bu1='"+__bu1.value+"' ";
		else __bu1_desc.value="";

		if (__bu2.value.length>0)
			sqlBu2 = " bu2='"+__bu2.value+"' ";
		else __bu2_desc.value="";

		if (__bu3.value.length>0)
			sqlBu3 = " bu3='"+__bu3.value+"' ";
		else __bu3_desc.value="";

		if (__bu4.value.length>0)
			sqlBu4 = " bu4='"+__bu4.value+"' ";
		else __bu4_desc.value="";

		if (__bu5.value.length>0)
			sqlBu5 = " bu5='"+__bu5.value+"' ";
		else __bu5_desc.value="";

		var setFixcon = new Array(ssecurity,sqlEmp,sqlDate,sqlBu1,sqlBu2,sqlBu3,sqlBu4,sqlBu5,sqlResigdate);
		__fixCon.value = "";

		for(i=0; i<setFixcon.length; i++){
			if(setFixcon[i] != ""){
				__fixCon.value += setFixcon[i] + " and ";
			}
		}
		__fixCon.value = __fixCon.value.substring(0,__fixCon.value.length-5);

		var dbType = "oracal"; //รับค่าชนิดดาต้าเบส เนื่องจากใช้ SQL (ไม่เท่ากับ) ไม่เหมือนกัน
		//กรองข้อผิดพลาดที่ต้องการ
		var etype = "";
		var err = "";
		for (j=0; j<elements.length; j++){
			if (elements[j].name.indexOf("error_") > -1){
				if (elements[j].checked){
				//	alert(elements[j].value);
					if (etype != ""){
						etype +=" or ";
					}
					if(dbType=='oracal'){
						//if(elements[j].value == "warn16"){
						//	etype += " ( EVENTGRP = 'j') ";
						//}else{
							if(elements[j].value=="warn00"){
								etype += "("+elements[j].value+" !='' and warn01 ='') ";
							}else if(elements[j].value=="warn01"){
								etype += "("+elements[j].value+" !='' and warn00 ='') ";
							}else if(elements[j].value=="warn16"){
								etype += "(warn00 !='' and warn01 !='') ";
							}else if(elements[j].value=="absent"){
								etype += "eventgrp = 'J' ";
							}else{
								etype += elements[j].value+" !='' ";
							}
						//}
					}else{
						if(elements[j].value=="absent"){
							etype += "eventgrp = 'J' ";
						}else{
							etype += elements[j].value+"<>''";
						}
					}

					err += elements[j].value+",";
				}
			}
		}
	//	alert(etype);
		if (!etype==""){
			__error.value = err;
			__fixCon.value += " and ("+etype+")";
		} else {
			if(__language.value=="tha") {
				alert("กรุณาเลือกเงื่อนไขข้อผิดพลาดที่ต้องการอย่างน้อย 1 ประเภท");
			} else alert("Please select error type less 1 type");
			return false;
		}


		submit();
	}
}
	function goExportExcel(){
		with(document.cscform){
			var param = "TAU1211_Exp.jsp?__Filter="+__fixCon.value;
			//alert(param);
			window.open(param);
		}
	}

	function setCheck(obj){
		with(document.cscform){
			if(obj.value!="warn16"){
				if(obj.checked){
					if(!(error_16.checked && (obj.value=="warn00" || obj.value=="warn01"))){
						__showList.value += ","+obj.value;
					}
				}else{
					if(!(error_16.checked && (obj.value=="warn00" || obj.value=="warn01"))){
						__showList.value = __showList.value.replace(","+obj.value,"");
					}
				}
			//	if(error_16.checked){}
			}else{
				if(obj.checked){
					//__showList.value += ","+obj.value;
					if(__showList.value.indexOf(",warn00")==-1){
						__showList.value += ",warn00";
					}
					if(__showList.value.indexOf(",warn01")==-1){
						__showList.value += ",warn01";
					}
				}else{
					if(!error_00.checked){
						__showList.value = __showList.value.replace(",warn00","");
					}
					if(!error_01.checked){
						__showList.value = __showList.value.replace(",warn01","");
					}
				}
			}
			setShow();
		}
	}

	function setShow(){
		with(document.cscform){
			var showList = __showList.value.split(",");
			for(var i=1 ; i<=5 ; i++){
				eval("warn_col0"+i).value = "warn99";
				if(showList[i]!="" && showList[i]!=undefined){
					eval("warn_col0"+i).value = showList[i];
				}
			}
		}
	}


</script>
</head>

<body leftmargin="0" topmargin="0" onLoad="MM_preloadImages('../IMAGES/BUTTON/SEARCH.gif')">
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<script language="javascript">initToolTips();</script>
<form name="cscform" method="post" action="TAU1211.jsp" ng-controller="Swaplang as sw">


<!----------BEGIN CSC INITIAL ZONE ------------------------>

<%=screen.InitialVariable()%>

<!----------END CSC INITIAL ZONE -------------------------->

<input type="hidden" name="__screen" value="TAU1211">
	<input type="hidden" name="__cmd" value="search">
	<input type="hidden" name="__help" value="">
	<input type="hidden" name="__goPage" value="">
	<input type="hidden" name="__calendar">
	<input type="hidden" name="__employeeid" value="">
	<input type="hidden" name="__dateid" value="">
	<input type="hidden" name="__time0id" value="">
	<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
	<input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>">
	<input type="hidden" name="__helpReturn" value="<%=request.getParameter("__helpReturn")%>">
	<input type="hidden" name="__helpName" value="<%=request.getParameter("__helpName")%>">
	<input type="hidden" name="__pageCall" value="<%=request.getParameter("__screen")%>">
	<input type="hidden" name="__filter" value="<%=filter%>">
	<input type="hidden" name="__fixCon" value="<%=request.getParameter("__fixCon")%>">

  	<script language="javascript">getInputFormatDate();</script>
	<input type="hidden" name="__error" value="<%=request.getParameter("__error")%>">

	<%
		String emp1="",emp2="",bu1="",bu2="",bu3="",bu4="",bu5="",date1="",date2="",bu1_desc="",bu2_desc="",bu3_desc="",bu4_desc="",bu5_desc="";
		if (request.getParameter("__date1")!=null) date1=request.getParameter("__date1");
		if (request.getParameter("__date2")!=null) date2=request.getParameter("__date2");
		if (request.getParameter("__emp1")!=null) emp1=request.getParameter("__emp1");
		if (request.getParameter("__emp2")!=null) emp2=request.getParameter("__emp2");
		if (request.getParameter("__bu1")!=null) bu1=request.getParameter("__bu1");
		if (request.getParameter("__bu2")!=null) bu2=request.getParameter("__bu2");
		if (request.getParameter("__bu3")!=null) bu3=request.getParameter("__bu3");
		if (request.getParameter("__bu4")!=null) bu4=request.getParameter("__bu4");
		if (request.getParameter("__bu5")!=null) bu5=request.getParameter("__bu5");
		if (request.getParameter("__bu1_desc")!=null) bu1_desc=request.getParameter("__bu1_desc");
		if (request.getParameter("__bu2_desc")!=null) bu2_desc=request.getParameter("__bu2_desc");
		if (request.getParameter("__bu3_desc")!=null) bu3_desc=request.getParameter("__bu3_desc");
		if (request.getParameter("__bu4_desc")!=null) bu4_desc=request.getParameter("__bu4_desc");
		if (request.getParameter("__bu5_desc")!=null) bu5_desc=request.getParameter("__bu5_desc");

		String warn_c01="", warn_c02="", warn_c03="", warn_c04="", warn_c05="";
		if (request.getParameter("warn_col01")!=null) warn_c01=request.getParameter("warn_col01");
		if (request.getParameter("warn_col02")!=null) warn_c02=request.getParameter("warn_col02");
		if (request.getParameter("warn_col03")!=null) warn_c03=request.getParameter("warn_col03");
		if (request.getParameter("warn_col04")!=null) warn_c04=request.getParameter("warn_col04");
		if (request.getParameter("warn_col05")!=null) warn_c05=request.getParameter("warn_col05");

		HashMap hm = new HashMap();
		String type = "";
		String error = "";
		if (request.getParameter("__error")==null) {
		//	error = "warn00,warn01,warn02,warn05,warn11";
			error = "warn00,warn01,warn02,warn05";
		} else error = chk.chkNullString(request.getParameter("__error"));
		StringTokenizer str = new StringTokenizer(error,",");
		while (str.hasMoreTokens()) {
			type = str.nextToken();
			hm.put(type,type);
		}
	%>
	<input type="hidden" size="100" name="__showList" value="<%=chk.chkNullString(request.getParameter("__showList"),","+error)%>">

	<br>
	<table height="" align="center" cellpadding="0" cellspacing="0"  border="1" class="largest">
    <tr bgcolor="#3366CC">
		<td  height="20" class="header" colspan="4">TAU1211, <script language="javascript">swapLang("WorkingTime Warning");</script>&nbsp;</td>
  	</tr>
	<tr>
		<td class="blankspace" colspan="4"></td>
    </tr>
	<tr>
		<td align="right"><strong><%=screen.getLabel("employeeid")%>&nbsp;</strong></td>
		<td colspan="3"><input type="text" name="__emp1" size="15" value="<%=emp1%>">
			<a href="javascript:goHelp('MEMPLOYEEHELP','__emp1','')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image2','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="Image2"  border="0" align="absmiddle"></a> &nbsp;&nbsp;-&nbsp;&nbsp;
			<input type="text" name="__emp2" size="15" value="<%=emp2%>">
			<a href="javascript:goHelp('MEMPLOYEEHELP','__emp2','')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image3','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="Image3"  border="0" align="absmiddle"></a></span>
		</td>
	</tr>
	<tr>
		<td align="right"><%=screen.getLabel("memployee","bu1")%>&nbsp;</td>
		<td colspan="3"><input type="text" name="__bu1" size="15" value="<%=bu1%>">
			<a href="javascript:goHelpBu('MBU1HELP','__bu1','')" 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 name="__bu1_desc" type="text" value="<%=thai.ASCII2Unicode(bu1_desc)%>" size="40" readonly="">

			&nbsp;&nbsp;&nbsp;
			<script language="javascript">swapLang('Column');</script>&nbsp;1&nbsp;
			<select name="warn_col01">
				<option value="warn99">ไม่แสดงข้อมูล</option>
				<%
					Iterator it = hmErrorType.keySet().iterator();
					while (it.hasNext()) {
						String key = (String) it.next();
						String value = (String) hmErrorType.get(key);

						if (warn_c01.equals("") && key.equals("warn00")) {
				%>
						<option value="<%=key%>" selected><%=value%></option>
				<%
						} else {
				%>
						<option value="<%=key%>" <% if (warn_c01.equals(key)) out.println("selected");%>><%=value%></option>
				<%
						}
					} //end while
				%>
			</select>
		</td>
	</tr>
	<tr>
		<td align="right"><%=screen.getLabel("memployee","bu2")%>&nbsp; </td>
		<td colspan="3"><input type="text" name="__bu2" size="15" value="<%=bu2%>">
			<a href="javascript:goHelpBu('MBU2HELP','__bu2','')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu2','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu2"  border="0" align="absmiddle"></a>
			<input name="__bu2_desc" type="text" id="__bu2_desc" value="<%=thai.ASCII2Unicode(bu2_desc)%>" size="40" readonly="">

			&nbsp;&nbsp;&nbsp;
			<script language="javascript">swapLang('Column');</script>&nbsp;2&nbsp;
			<select name="warn_col02">
				<option value="warn99" selected>ไม่แสดงข้อมูล</option>
				<%
					it = hmErrorType.keySet().iterator();
					while (it.hasNext()) {
						String key = (String) it.next();
						String value = (String) hmErrorType.get(key);
						if (warn_c02.equals("") && key.equals("warn01")) {
				%>
						<option value="<%=key%>"><%=value%></option>
				<%
						} else {
				%>
						<option value="<%=key%>" <% if (warn_c02.equals(key)) out.println("selected");%>><%=value%></option>
				<%
						}
					} //end while
				%>
			</select>
		</td>
	</tr>
	<tr>
		<td align="right"><%=screen.getLabel("memployee","bu3")%>&nbsp;</td>
		<td colspan="3"><input type="text" name="__bu3" size="15" value="<%=bu3%>">
			<a href="javascript:goHelpBu('MBU3HELP','__bu3','')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu3','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu3"  border="0" align="absmiddle"></a>
			<input name="__bu3_desc" type="text" value="<%=thai.ASCII2Unicode(bu3_desc)%>" size="40" readonly="">

			&nbsp;&nbsp;&nbsp;
			<script language="javascript">swapLang('Column');</script>&nbsp;3&nbsp;
			<select name="warn_col03">
				<option value="warn99" selected>ไม่แสดงข้อมูล</option>
				<%
					it = hmErrorType.keySet().iterator();
					while (it.hasNext()) {
						String key = (String) it.next();
						String value = (String) hmErrorType.get(key);
						if (warn_c03.equals("") && key.equals("warn02")) {
				%>
						<option value="<%=key%>"><%=value%></option>
				<%
						} else {
				%>
						<option value="<%=key%>" <% if (warn_c03.equals(key)) out.println("selected");%>><%=value%></option>
				<%
						}
					} //end while
				%>
			</select>
		</td>
	</tr>
	<tr>
		<td align="right"><%=screen.getLabel("memployee","bu4")%>&nbsp;</td>
		<td colspan="3"><input type="text" name="__bu4" size="15" value="<%=bu4%>">
			<a href="javascript:goHelpBu('MBU4HELP','__bu4','')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu4','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu4"  border="0" align="absmiddle"></a>
			<input name="__bu4_desc" type="text" value="<%=thai.ASCII2Unicode(bu4_desc)%>" size="40" readonly="">

			&nbsp;&nbsp;&nbsp;
			<script language="javascript">swapLang('Column');</script>&nbsp;4&nbsp;
			<select name="warn_col04">
				<option value="warn99" selected>ไม่แสดงข้อมูล</option>
				<%
					it = hmErrorType.keySet().iterator();
					while (it.hasNext()) {
						String key = (String) it.next();
						String value = (String) hmErrorType.get(key);
						if (warn_c04.equals("") && key.equals("warn05")) {
				%>
						<option value="<%=key%>"><%=value%></option>
				<%
						} else {
				%>
						<option value="<%=key%>" <% if (warn_c04.equals(key)) out.println("selected");%>><%=value%></option>
				<%
						}
					} //end while
				%>
			</select>
	</td>
	</tr>
	<tr>
		<td align="right"><%=screen.getLabel("memployee","bu5")%>&nbsp;</td>
		<td colspan="3"><input type="text" name="__bu5" size="15" value="<%=bu5%>">
			<a href="javascript:goHelpBu('MBU5HELP','__bu5','')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu5','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu5"  border="0" align="absmiddle"></a>
			<input name="__bu5_desc" type="text" value="<%=thai.ASCII2Unicode(bu5_desc)%>" size="40" readonly="">

			&nbsp;&nbsp;&nbsp;
			<script language="javascript">swapLang('Column');</script>&nbsp;5&nbsp;
			<select name="warn_col05">
			<option value="warn99" selected><%=screen.getUProfile().get("lang").equalsIgnoreCase("THA")?"ไม่แสดงข้อมูล":"No Select Data"%></option>
				<%
					it = hmErrorType.keySet().iterator();
					while (it.hasNext()) {
						String key = (String) it.next();
						String value = (String) hmErrorType.get(key);
					if (warn_c05.equals("") && key.equals("warn11")) {
				%>
						<option value="<%=key%>"><%=value%></option>
				<%
						} else {
				%>
						<option value="<%=key%>" <% if (warn_c05.equals(key)) out.println("selected");%>><%=value%></option>
				<%
						}
					} //end while
				%>
			</select>
		</td>
	</tr>
	<tr>
		<td align="right"><script language="javascript">swapLang('Period Date');</script>&nbsp;</td>
		<td colspan="3"><span class="columnobject1">
			<input type="text" name="__date1" size="10" maxlength="10" value="<%=date1%>" onKeyup = "formatDate(this)" onBlur = "chkInputDate2(this,__date2)" onKeypress = "chkIntegerOfDate(this.value)" onMouseOver="toolTip('DDMMYYYY')" onMouseOut="toolTip()">&nbsp;
			<a href="javascript:;" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('calendar1','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" name="calendar1"  border="0" align="absmiddle" onClick="viewCal('__date1')" alt="Calendar"></a> &nbsp;&nbsp;-&nbsp;&nbsp;
			<input type="text" name="__date2" size="10" maxlength="10" value="<%=date2%>" onKeyup = "formatDate(this)" onBlur = "chkInputDate2(__date1,this)" onKeypress = "chkIntegerOfDate(this.value)" onMouseOver="toolTip('DDMMYYYY')" onMouseOut="toolTip()">&nbsp;
			<a href="javascript:;" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('calendar2','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" name="calendar2"  border="0" align="absmiddle" onClick="viewCal('__date2')" alt="Calendar"></a></span>
		</td>
	</tr>
	<tr>
		<td class="blankspace" colspan="4"></td>
	</tr>
	<tr>
		<td align="right">&nbsp;</td>
		<td colspan="3">
			<table border="0" cellspacing="0" cellpadding="0" class="maxsize">
				<tr>
					<td><label>
						<input name="error_00" type="checkbox" value="warn00" <% if (hm.containsKey("warn00")) out.println("checked");%> onclick="setCheck(this);">&nbsp;<%=rt.getSystemCode("ERROR_TYPE_FILTER",lang,"0")%>
					</label></td>
					<td><label>
						<input name="error_01" type="checkbox" value="warn01" <% if (hm.containsKey("warn01")) out.println("checked");%> onclick="setCheck(this);">&nbsp;<%=rt.getSystemCode("ERROR_TYPE_FILTER",lang,"1")%>
					</label></td>
					<td><label>
						<input name="error_16" type="checkbox" value="warn16" <% if (hm.containsKey("warn16")) out.println("checked");%> onclick="setCheck(this);">&nbsp;<%=rt.getSystemCode("ERROR_TYPE_FILTER",lang,"16")%>
					</label></td>
					<td><label>
						<input name="error_02" type="checkbox" value="warn02" <% if (hm.containsKey("warn02")) out.println("checked");%> onclick="setCheck(this);">&nbsp;<%=rt.getSystemCode("ERROR_TYPE_FILTER",lang,"2")%>
					</label></td>
					<td><label>
						<input name="error_03" type="checkbox" value="warn03" <% if (hm.containsKey("warn03")) out.println("checked");%> onclick="setCheck(this);">&nbsp;<%=rt.getSystemCode("ERROR_TYPE_FILTER",lang,"3")%>
					</label></td>

				</tr>
				<tr>
					<td><label>
						<input name="error_04" type="checkbox" value="warn04" <% if (hm.containsKey("warn04")) out.println("checked");%> onclick="setCheck(this);">&nbsp;<%=rt.getSystemCode("ERROR_TYPE_FILTER",lang,"4")%>
					</label></td>
					<td><label>
						<input name="error_05" type="checkbox" value="warn05" <% if (hm.containsKey("warn05")) out.println("checked");%> onclick="setCheck(this);">&nbsp;<%=rt.getSystemCode("ERROR_TYPE_FILTER",lang,"5")%>
					</label></td>
					<td><label>
						<input name="error_06" type="checkbox" value="warn06" <% if (hm.containsKey("warn06")) out.println("checked");%> onclick="setCheck(this);">&nbsp;<%=rt.getSystemCode("ERROR_TYPE_FILTER",lang,"6")%>
					</label></td>
					<td><label>
						<input name="error_11" type="checkbox" value="warn11" <% if (hm.containsKey("warn11")) out.println("checked");%> onclick="setCheck(this);">&nbsp;<%=rt.getSystemCode("ERROR_TYPE_FILTER",lang,"11")%>
					</label></td>
					<td><label>
						<input name="error_12" type="checkbox" value="warn12" <% if (hm.containsKey("warn12")) out.println("checked");%> onclick="setCheck(this);">&nbsp;<%=rt.getSystemCode("ERROR_TYPE_FILTER",lang,"12")%>
					</label></td>
				</tr>
				<tr>
					<td><label>
						<input name="error_13" type="checkbox" value="warn13" <% if (hm.containsKey("warn13")) out.println("checked");%> onclick="setCheck(this);">&nbsp;<%=rt.getSystemCode("ERROR_TYPE_FILTER",lang,"13")%>
					</label></td>
					<td><label>
						<input name="error_14" type="checkbox" value="warn14" <% if (hm.containsKey("warn14")) out.println("checked");%> onclick="setCheck(this);">&nbsp;<%=rt.getSystemCode("ERROR_TYPE_FILTER",lang,"14")%>
					</label></td>
					<td><label>
						<input name="error_15" type="checkbox" value="warn15" <% if (hm.containsKey("warn15")) out.println("checked");%> onclick="setCheck(this);">&nbsp;<%=rt.getSystemCode("ERROR_TYPE_FILTER",lang,"15")%>
					</label></td>
					<td>
						<label>
							<input type="checkbox" name="error_absent" value="absent" <%if (hm.containsKey("absent")) out.println("checked");%> onclick="setCheck(this);">&nbsp;<%=screen.getUProfile().get("lang").equals("THA")?"ขาดงาน":"Absent"%>
						</label>
					</td>
					<td><label>
						<input type="checkbox" name="errorall" value="warn17" onClick="javascript:chkAll();"><script language="javascript">swapLang('Select All')</script>
					</label></td>
				</tr>
            </table>
		</td>
	</tr>
	<tr>
		<td class="blankspace" colspan="4"></td>
	</tr>

		<tr>
			<td  class="buttonline" colspan="7"><div align="center">
				<button type="button" class="btn btn-primary width100" swlang code="SW012098" onClick="setSubmit();">SUBMIT</button>&nbsp;
				<button type="button" class="btn btn-primary width100" swlang code="SW013178" onClick="goExportExcel();">EXPORT</button>
			</div>
			</td>
		</tr>
	<tr>
		<td class="blankspace" colspan="4"></td>
	</tr>
	</table>

	<%
		String cmd = request.getParameter("__cmd");
		String goPage = request.getParameter("__goPage");
		if((cmd != null && cmd.equals("search")) || (goPage != null && !goPage.equals(""))){
	%>
	<table height="" align="center" cellpadding="0" cellspacing="0" class="largest">
		<tr>
			<td class="blankspace" colspan="9"><div align="right">&lt; <%=screen.getPageTag()%> &gt;</div></td>
		</tr>
		<tr>
			<td class="blankspace" colspan="9"></td>
		</tr>
		<%
			int i = 0;
		//	out.print("fiter :: "+screen.inq.getFilter());
		//	out.print("fiter :: "+screen.inq.getTableName());
			while(screen.nextRec())	{
				if (i==0) {
		%>
		<tr>
			<td width="25%" class="forborder"><div align="center"><strong><%=screen.getLabel("employeeid")%></strong></div></td>
			<td width="10%" class="forborder"><div align="center"><strong><%=screen.getLabel("dateid")%></strong></div></td>
			<td width="10%" class="forborder"><div align="center"><strong><%=screen.getLabel("time0id")%></strong></div></td>
			<td width="10%" class="forborder">
				<div align="center"><strong><%=screen.getLabel("warn_col01")=="warn_col01"?"ไม่แสดงข้อมูล":screen.getLabel("warn_col01")%></strong></div>
			</td>
			<td width="10%" class="forborder">
				<div align="center"><strong><%=screen.getLabel("warn_col02")=="warn_col02"?"ไม่แสดงข้อมูล":screen.getLabel("warn_col02")%></strong></div>
			</td>
			<td width="10%" class="forborder">
				<div align="center"><strong><%=screen.getLabel("warn_col03")=="warn_col03"?"ไม่แสดงข้อมูล":screen.getLabel("warn_col03")%></strong></div>
			</td>
			<td width="10%" class="forborder">
				<div align="center"><strong><%=screen.getLabel("warn_col04")=="warn_col04"?"ไม่แสดงข้อมูล":screen.getLabel("warn_col04")%></strong></div>
			</td>
			<td width="10%" class="forborder">
				<div align="center"><strong>
				<%=screen.getLabel("warn_col05")=="warn_col05"?"ไม่แสดงข้อมูล":screen.getLabel("warn_col05")
				%></strong></div>
			</td>
			<td width="5%" class="forborder"><div align="center"><strong><%=screen.getLabel("warn_col06")%></strong></div></td>
		</tr>
		<%
				}
				i++;
				if( screen.checkLinePage() ) {
		%>
		<tr>
			<td class="forborder"><div align="center"><%=screen.getString("employeeid")%> <%=screen.getString("memployee","fullname")%></font></div></td>
			<td class="forborder"><div align="center"><%=screen.getString("dateid")%></font></div></td>
			<td class="forborder"><div align="center"><%=screen.getString("time0id")%></font></div></td>
			<td class="forborder"><div align="center"><%=screen.getLabel("warn_col01").equals("warn_col01") || chkCond(screen.getLabel("warn_col01"), screen.getString("eventgrp"), lang) ?"-":screen.getString("warn_col01")%></font></div></td>
			<td class="forborder"><div align="center"><%=screen.getLabel("warn_col02").equals("warn_col02") || chkCond(screen.getLabel("warn_col02"), screen.getString("eventgrp"), lang) ?"-":screen.getString("warn_col02")%></font></div></td>
			<td class="forborder"><div align="center"><%=screen.getLabel("warn_col03").equals("warn_col03") || chkCond(screen.getLabel("warn_col03"), screen.getString("eventgrp"), lang) ?"-":screen.getString("warn_col03")%></font></div></td>
			<td class="forborder"><div align="center"><%=screen.getLabel("warn_col04").equals("warn_col04") || chkCond(screen.getLabel("warn_col04"), screen.getString("eventgrp"), lang) ?"-":screen.getString("warn_col04")%></font></div></td>
			<td class="forborder"><div align="center"><%=screen.getLabel("warn_col05").equals("warn_col05") || chkCond(screen.getLabel("warn_col05"), screen.getString("eventgrp"), lang) ?"-":screen.getString("warn_col05")%></font></div></td>
			<td class="forborder"><div align="center">
			<%
				//if (screen.getString("warn_col06").equals("YES") || screen.getString("warn_col06").equals("มี")) {
			%>
			<a href="javascript:pageDesc('<%=screen.getString("employeeid")%>','<%=screen.getString("dateid")%>','<%=screen.getString("sequence")%>')"><img src="../IMAGES/BUTTON/MAIN/EDIT20.gif" border="0"></a></div>
			</td>
			<%
				//}  else { out.println("-"); }
			%>
		</tr>
		<%
				}
				if(screen.outLinePage()) {
					break;
				}
			}
		%>
		<tr>
			<td class="blankspace" colspan="9"></td>
		</tr>
		<tr>
			<td  class="bottom"  colspan="9"></td>
		</tr>
	</table>
	<% } %>
	<%!
		public boolean chkCond(String label, String eventgrp, String lang){
			ReportUDF rt=new ReportUDF();
			if(eventgrp.equalsIgnoreCase("H")
				&&
				(
					label.equalsIgnoreCase( rt.getSystemCode("ERROR_TYPE", lang,"0") )
					|| label.equalsIgnoreCase( rt.getSystemCode("ERROR_TYPE", lang,"1") )
					|| label.equalsIgnoreCase( rt.getSystemCode("ERROR_TYPE", lang,"2") )
					|| label.equalsIgnoreCase( rt.getSystemCode("ERROR_TYPE", lang,"5") )
					|| label.equalsIgnoreCase( rt.getSystemCode("ERROR_TYPE", lang,"6") )
				)
				){
				return true;
			}else{
				return false;
			}
		}

		private String chkMySecurity(String p_status,String p_field,String p_data){
			String mfilter = "";
			if (p_status.equalsIgnoreCase("1")){
				mfilter =" AND "+p_field+" NOT IN (";
			}else if (p_status.equalsIgnoreCase("0")){
				mfilter = " AND "+p_field+" IN (";
			}

			String mdata[] = p_data.split(",");

			for (int i=0;i<mdata.length; i++){
				mfilter += "'"+mdata[i]+"',";
			}

			mfilter = mfilter.substring(0,mfilter.length()-1);
			mfilter += ")";

			return mfilter;
		}
	%>
	<%
		if (request.getParameter("__error")==null) {
	%>
			<script language="javascript">setShow();</script>
	<%
		}
	%>
	<br>
</form>
</body>
</html>