<!DOCTYPE html>
<%@page contentType="text/html; charset=UTF-8" language="java" %>
<%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*,java.util.*"%>
<%@page import="com.csc.library.utilities.CscCalendar,com.csc.library.entry.HelpEntry,com.csc.library.system.*"%>
<%@page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*,com.csc.library.formula.FormulaString" %>
<%@page import="java.text.DecimalFormat, com.csc.library.report.*" %>
<%@ include file="../CHECKPROFILE.jsp" %>
<% request.setCharacterEncoding("UTF-8"); %>
<jsp:useBean id="EMV" class="com.csc.library.system.Task" scope="page" />
<jsp:setProperty name="EMV" property="appname" value="empview" />
<%
EMV.setChannel(request, response);
CscCalendar cs1 = new CscCalendar();
cs1.decDate(5);
CscCalendar cs2 = new CscCalendar();
if (request.getParameter("date_start")!=null && request.getParameter("date_end")!=null) {
cs1 = new CscCalendar(request.getParameter("date_start"));
cs2 = new CscCalendar(request.getParameter("date_end"));
}
EmvHelpEntry screen = (EmvHelpEntry) EMV.process("EmvHelpEntry", "PI_ERRORHELP");
screen.inq.setFilter("employeeid = '"+EMV.getUProfile().getEmvEmpId()+"' ");
//out.println("CHILD===>"+screen.inq.getChildTable());
//out.println("EMV.getUProfile().dbType() ==> "+EMV.getUProfile().getDbType());
String filter = "";
if (request.getParameter("__childFilter")!=null) {
filter = request.getParameter("__childFilter");
} else {
if(EMV.getUProfile().getDbType().equalsIgnoreCase("PGSQL") || EMV.getUProfile().getDbType().equalsIgnoreCase("ORACLE")){
filter = "employeeid = '"+EMV.getUProfile().getEmvEmpId()+"' "+
"and (dateid between '"+cs1.getYYYYMMDD()+"' and '"+cs2.getYYYYMMDD()+"') "+
"and ((warn00 is not null and length(warn00)>0) or (warn01 is not null length(warn01)>0) or (warn02 is not null length(warn02)>0) or (warn05 is not null length(warn05)>0) or (warn11 is not null length(warn11)>0))";
} else {
filter = "employeeid = '"+EMV.getUProfile().getEmvEmpId()+"' "+
"and (dateid between '"+cs1.getYYYYMMDD()+"' and '"+cs2.getYYYYMMDD()+"') "+
"and ((warn00 is not null and len(warn00)>0) or (warn01 is not null len(warn01)>0) or (warn02 is not null len(warn02)>0) or (warn05 is not null len(warn05)>0) or (warn11 is not null len(warn11)>0))";
}
}
//out.print("--->" + filter);
DbInquiry inqChild = (DbInquiry) screen.inq.getChild("ttime_current1_warning");
inqChild.setFilter(filter);
inqChild.setOrderBy("dateid");
FormulaString fs = new FormulaString();
DecimalFormat df = new DecimalFormat("0.00");
DecimalFormat df2 = new DecimalFormat("00.00");
ThaiUtilities thai = new ThaiUtilities();
ReportUDF rt = new ReportUDF();
CheckNull chk = new CheckNull();
screen.process();
screen.inq.refresh();
screen.nextRec();
%>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<html xmlns="http://www.w3.org/1999/xhtml" ng-app="myHR">
<head>
<title>Employee View</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
</head>
<body>
<div class="bg-com"></div>
<jsp:include page="EMV_HEADMENU.jsp" flush="true" />
<script>
var myLang='<%=screen.getUProfile().get("lang")%>';
var swap = new swaplang();
var titlename = swap.swap2String("SW001910");
setPageTitle(titlename);
$(document).ready(function(){
$(".warning").css("color","red");
//datepicker function
if (myLang=="tha"){
$.datepicker.setDefaults($.datepicker.regional['tha']);
}
$("input[name=date_start]").hover(function(){
$("input[name=date_start]").datepicker({
dateFormat:"dd-mm-yy",
maxDate:-1,
defaultDate:-1,
changeMonth: true,
changeYear: true
});
$("input[name=date_end]").datepicker("destroy");
});
$("input[name=date_end]").change(function(){
if ($("input[name=date_start]").val()>$("input[name=date_end]").val()){
$("input[name=date_start]").val($("input[name=date_end]").val());
} else if ($("input[name=date_start]").val()==""){
$("input[name=date_start]").val($("input[name=date_end]").val());
}
});
$("input[name=date_end]").hover(function(){
$("input[name=date_end]").datepicker({
minDate: new Date(ConvertDate($("input[name=date_start]").val())),
dateFormat:"dd-mm-yy",
changeMonth: true,
changeYear: true
});
});
});
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){
var sqlDate="";
if (date_start.value.length>0 && date_end.value.length>0)
sqlDate = " (dateid between '"+chkDateTime1(date_start.value)+"' and '"+chkDateTime1(date_end.value)+"') ";
else if (date_start.value.length>0 && date_end.value.length==0)
sqlDate = " dateid='"+chkDateTime1(date_start.value)+"' ";
else if (__date2.value.length>0 && date_start.value.length==0)
sqlDate = " dateid='"+chkDateTime1(date_end.value)+"' ";
if (sqlDate!="") {
__childFilter.value = "employeeid = '<%=EMV.getUProfile().getEmvEmpId()%>' and "+sqlDate;
} else __childFilter.value = "employeeid ='<%=EMV.getUProfile().getEmvEmpId()%>' ";
//กรองข้อผิดพลาดที่ต้องการ
var etype = "";
var err = "";
var dbType = "<%=EMV.getUProfile().getDbType()%>";
for (j=0; j<elements.length; j++){
if (elements[j].name.indexOf("error_") > -1){
if (elements[j].checked){
if (etype != ""){
etype +=" or ";
}
if(dbType === "PGSQL" || dbType === "ORACLE"){
etype += elements[j].value+" is not null and length(" +elements[j].value+")>0 ";// ใช้ in not null ไม่ได้ เพราะข้อมูลถูกเซพลงเป็นค่าว่าง
} else {
etype += elements[j].value+" is not null and len(" +elements[j].value+")>0 ";// ใช้ in not null ไม่ได้ เพราะข้อมูลถูกเซพลงเป็นค่าว่าง
}
//etype += elements[j].value+" != ''";
err += elements[j].value+",";
}
}
}
if (!etype==""){
__error.value = err;
__childFilter.value += " and ("+etype+")";
search();
} else {
if(__language.value=="tha") {
alert("กรุณาเลือกเงื่อนไขข้อผิดพลาดที่ต้องการอย่างน้อย 1 ประเภท");
} else alert("Please select error type less 1 type");
//return false;
}
} //end with
}
function pageDesc(empid, dateid, sequence){
with(document.cscform) {
var d=chkDateTime1(dateid);
var filterCon = "employeeid='"+empid+"' and (dateid='"+d+"') and sequence='"+sequence+"'";
//alert(filterCon);
window.open("PI_ERROR_DESC.jsp?__cmd="+
"&__fixCon="+filterCon,
"ShowWarning","left=150,top=100,width=900,height=600,toolbar=no,status=yes,scrollbars=yes,resizable=yes"
);
}
}
</script>
<section>
<div class="container csc-content">
<form name="cscform" class="form-horizontal" method="post" action="PI_ERROR.jsp">
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__screen" value="PI_ERROR">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__helpReturn" value="">
<input type="hidden" name="__helpName" value="">
<input type="hidden" name="__pageCall" >
<input type="hidden" name="__referPage" value="">
<INPUT TYPE="hidden" NAME="__goPage" VALUE="">
<input type="hidden" name="__calendar">
<script>getInputFormatDate();</script>
<input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>">
<input type="hidden" name="__fixCon" >
<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
<input type="hidden" name="__childFilter" value="<%=request.getParameter("__childFilter")%>">
<input type="hidden" name="__empID" value="<%=screen.getString("employeeid")%>">
<input type="hidden" name="__empName" value="<%=screen.getString("fullname")%>">
<input type="hidden" name="__error" value="<%=request.getParameter("__error")%>">
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<script>initToolTips();</script>
<div class="csc-block">
<div class="center">
<h2 class="csc-block-head" swlang code='SW001910'>Punch In/Out Checking Data</h2>
</div>
<%
response.setHeader("x-xss-Protection","0"); // cross site script
String browserType = request.getHeader("User-Agent"); // check browser
%>
<%
/*
* 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[][] 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")).equals("tha")) {
value = value.substring(value.indexOf(",") + 1);
} else {
value = value.substring(0, value.indexOf(","));
}
if(!key.equals("warn06")){
hmErrorType.put(key, value);
}
}
String date1="", date2="", warn_c01="", warn_c02="", warn_c03="", warn_c04="", warn_c05="";
if (request.getParameter("date_start")!=null) date1=request.getParameter("date_start");
if (request.getParameter("date_end")!=null) date2=request.getParameter("date_end");
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";
} else error = chk.chkNullString(request.getParameter("__error"));
StringTokenizer str = new StringTokenizer(error,",");
while (str.hasMoreTokens()) {
type = str.nextToken();
hm.put(type,type);
}
%>
<div class="form-horizontal">
<div class="row">
<div class="form-group">
<div class="col-md-1 col-sm-1 col-xs-1"></div>
<div class="col-md-2 col-sm-2 col-xs-2">
<label class="control-label label-right" swlang code='SW001033'>Date</label>
</div>
<div class="col-md-2 col-sm-2 col-xs-3">
<% if (request.getParameter("date_start")==null) { %>
<input class="form-control" name="date_start" type="text" value="<%=cs1.getDDMMYYYY()%>" size="9" maxlength="10" onKeyup = "formatDate(this)" onBlur = "chkInputDate2(this,date_end)" onKeypress = "chkIntegerOfDate(this.value)">
<% } else {%>
<input class="form-control" name="date_start" type="text" value="<%=request.getParameter("date_start")%>" size="9" maxlength="10" onKeyup = "formatDate(this)" onBlur = "chkInputDate2(this,date_end)" onKeypress = "chkIntegerOfDate(this.value)">
<% }%>
</div>
<div class="col-md-2 col-sm-2 col-xs-2">
<label class="control-label label-right" swlang code='SW002095'>to</label>
</div>
<div class="col-md-2 col-sm-2 col-xs-3">
<% if (request.getParameter("date_end")==null) { %>
<input class="form-control" name="date_end" type="text" value="<%=cs2.getDDMMYYYY()%>" size="9" maxlength="10" onKeyup = "formatDate(this)" onBlur = "chkInputDate2(date_start,this)" onKeypress = "chkIntegerOfDate(this.value)">
<% } else {%>
<input class="form-control" name="date_end" type="text" value="<%=request.getParameter("date_end")%>" size="9" maxlength="10" onKeyup = "formatDate(this)" onBlur = "chkInputDate2(date_start,this)" onKeypress = "chkIntegerOfDate(this.value)">
<% }%>
</div>
</div>
</div>
<div class="row">
<div class="form-group">
<div class="col-md-1 col-sm-1 col-xs-1"></div>
<div class="col-md-2 col-sm-2 col-xs-2">
<label class="control-label label-right"><label swlang code='SW002184'>Column</label> 1 </label>
</div>
<div class="col-md-2 col-sm-2 col-xs-3">
<select class="form-control" name="warn_col01">
<%
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>
</div>
<div class="col-md-2 col-sm-2 col-xs-2">
<label class="control-label label-right"><label swlang code='SW002184'>Column</label> 2 </label>
</div>
<div class="col-md-2 col-sm-2 col-xs-3">
<select class="form-control" name="warn_col02">
<%
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%>" selected><%=value%></option>
<%
} else {
%>
<option value="<%=key%>" <% if (warn_c02.equals(key)) out.println("selected");%>><%=value%></option>
<%
}
} //end while
%>
</select>
</div>
</div>
</div>
<div class="row">
<div class="form-group">
<div class="col-md-1 col-sm-1 col-xs-1"></div>
<div class="col-md-2 col-sm-2 col-xs-2">
<label class="control-label label-right"><label swlang code='SW002184'>Column</label> 3 </label>
</div>
<div class="col-md-2 col-sm-2 col-xs-3">
<select class="form-control" name="warn_col03">
<%
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%>" selected><%=value%></option>
<%
} else {
%>
<option value="<%=key%>" <% if (warn_c03.equals(key)) out.println("selected");%>><%=value%></option>
<%
}
} //end while
%>
</select>
</div>
<div class="col-md-2 col-sm-2 col-xs-2">
<label class="control-label label-right"><label swlang code='SW002184'>Column</label> 4 </label>
</div>
<div class="col-md-2 col-sm-2 col-xs-3">
<select class="form-control" name="warn_col04">
<%
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%>" selected><%=value%></option>
<%
} else {
%>
<option value="<%=key%>" <% if (warn_c04.equals(key)) out.println("selected");%>><%=value%></option>
<%
}
} //end while
%>
</select>
</div>
</div>
</div>
<div class="row">
<div class="form-group">
<div class="col-md-1 col-sm-1 col-xs-1"></div>
<div class="col-md-2 col-sm-2 col-xs-2">
<label class="control-label label-right"><label swlang code='SW002184'>Column</label> 5 </label>
</div>
<div class="col-md-2 col-sm-2 col-xs-3">
<select class="form-control" name="warn_col05">
<%
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%>" selected><%=value%></option>
<%
} else {
%>
<option value="<%=key%>" <% if (warn_c05.equals(key)) out.println("selected");%>><%=value%></option>
<%
}
} //end while
%>
</select>
</div>
</div>
</div>
</br>
<div class="row">
<div class="form-group">
<div class="col-md-2 col-sm-2 col-xs-2"></div>
<div class="col-md-3 col-sm-3 col-xs-3">
<label class="control-label">
<input name="error_00" type="checkbox" value="warn00" <% if (hm.containsKey("warn00")) out.println("checked");%>><%=rt.getSystemCode("ERROR_TYPE",screen.getUProfile().get("lang"),"0")%>
</label>
</div>
<div class="col-md-3 col-sm-3 col-xs-3">
<label class="control-label">
<input name="error_01" type="checkbox" value="warn01" <% if (hm.containsKey("warn01")) out.println("checked");%>><%=rt.getSystemCode("ERROR_TYPE",screen.getUProfile().get("lang"),"1")%>
</label>
</div>
<div class="col-md-3 col-sm-3 col-xs-3">
<label class="control-label">
<input name="error_02" type="checkbox" value="warn02" <% if (hm.containsKey("warn02")) out.println("checked");%>><%=rt.getSystemCode("ERROR_TYPE",screen.getUProfile().get("lang"),"2")%>
</label>
</div>
</div>
</div>
<div class="row">
<div class="form-group">
<div class="col-md-2 col-sm-2 col-xs-2"></div>
<div class="col-md-3 col-sm-3 col-xs-3">
<label class="control-label">
<input name="error_03" type="checkbox" value="warn03" <% if (hm.containsKey("warn03")) out.println("checked");%>><%=rt.getSystemCode("ERROR_TYPE",screen.getUProfile().get("lang"),"3")%>
</label>
</div>
<div class="col-md-3 col-sm-3 col-xs-3">
<label class="control-label">
<input name="error_04" type="checkbox" value="warn04" <% if (hm.containsKey("warn04")) out.println("checked");%>><%=rt.getSystemCode("ERROR_TYPE",screen.getUProfile().get("lang"),"4")%>
</label>
</div>
<div class="col-md-3 col-sm-3 col-xs-3">
<label class="control-label">
<input name="error_05" type="checkbox" value="warn05" <% if (hm.containsKey("warn05")) out.println("checked");%>><%=rt.getSystemCode("ERROR_TYPE",screen.getUProfile().get("lang"),"5")%>
</label>
</div>
</div>
</div>
<div class="row">
<div class="form-group">
<div class="col-md-2 col-sm-2 col-xs-2"></div>
<div class="col-md-3 col-sm-3 col-xs-3">
<label class="control-label">
<input name="error_11" type="checkbox" value="warn11" <% if (hm.containsKey("warn11")) out.println("checked");%>><%=rt.getSystemCode("ERROR_TYPE",screen.getUProfile().get("lang"),"11")%>
</label>
</div>
<div class="col-md-3 col-sm-3 col-xs-3">
<label class="control-label">
<input name="error_12" type="checkbox" value="warn12" <% if (hm.containsKey("warn12")) out.println("checked");%>><%=rt.getSystemCode("ERROR_TYPE",screen.getUProfile().get("lang"),"12")%>
</label>
</div>
<div class="col-md-3 col-sm-3 col-xs-3">
<label class="control-label">
<input name="error_13" type="checkbox" value="warn13" <% if (hm.containsKey("warn13")) out.println("checked");%>><%=rt.getSystemCode("ERROR_TYPE",screen.getUProfile().get("lang"),"13")%>
</label>
</div>
</div>
</div>
<div class="row">
<div class="form-group">
<div class="col-md-2 col-sm-2 col-xs-2"></div>
<div class="col-md-3 col-sm-3 col-xs-3">
<label class="control-label">
<input name="error_14" type="checkbox" value="warn14" <% if (hm.containsKey("warn14")) out.println("checked");%>><%=rt.getSystemCode("ERROR_TYPE",screen.getUProfile().get("lang"),"14")%>
</label>
</div>
<div class="col-md-3 col-sm-3 col-xs-3">
<label class="control-label">
<input name="error_15" type="checkbox" value="warn15" <% if (hm.containsKey("warn06")) out.println("checked");%>><%=rt.getSystemCode("ERROR_TYPE",screen.getUProfile().get("lang"),"15")%>
</label>
</div>
<div class="col-md-3 col-sm-3 col-xs-3">
<label class="control-label">
<input type="checkbox" name="errorall" value="warn16" onClick="javascript:chkAll();"><label swlang code='SW002185'>Select All</label>
</label>
</div>
</div>
</div>
<div class="center">
<a class="btn btn-primary" href="javascript:setFilter();" swlang code='SW003537'>Search</a>
</div>
</div>
</div>
<%
int i = 0;
%>
<div class="table-responsive">
<table class="table table-head table-hover table-bordered table-content-center">
<thead>
<%
DbInquiry inq = (DbInquiry) screen.inq.getChild("ttime_current1_warning");
//out.print("Count : "+inq.recCount());
if (inq.recCount() > 0) {
do {
if (i==0) {
%>
<div align = "right"><script language="javascript">sw.write('SW000471');</script></div>
<tr>
<div align = "right" swlang code='SW013247'>unit : HH.MM</div>
<th swlang code='SW000262'>Day</th>
<th swlang code='SW001033'>Date</th>
<th><%=screen.getLabel("ttime_current1_warning","warn_col01")%></th>
<th><%=screen.getLabel("ttime_current1_warning","warn_col02")%></th>
<th><%=screen.getLabel("ttime_current1_warning","warn_col03")%></th>
<th><%=screen.getLabel("ttime_current1_warning","warn_col04")%></th>
<th><%=screen.getLabel("ttime_current1_warning","warn_col05")%></th>
<th><%=screen.getLabel("ttime_current1_warning","warn_col06")%></th>
</tr>
</thead>
<tbody>
<%
} //end if (i==0)
CscCalendar cDate = new CscCalendar(inq.getString("dateid"));
String descDate = cDate.getDOWTHI();
if(screen.getUProfile().get("lang").equals("eng"))descDate = cDate.getDOWENG();
if (!inq.getString("warn_col01").equals("-")||!inq.getString("warn_col02").equals("-")||!inq.getString("warn_col03").equals("-")||!inq.getString("warn_col04").equals("-")||!inq.getString("warn_col05").equals("-")||inq.getString("warn_col06").equals("YES") || inq.getString("warn_col06").equals("มี")){
%>
<tr>
<td><%=descDate%></td>
<td><%=cDate.getDDMMYYYY()%></td>
<% if (warn_c01.equals("warn00") || warn_c01.equals("warn01")) { %>
<td class="warning"><%=inq.getString("warn_col01")%></td>
<% } else { %>
<td><%=inq.getString("warn_col01")%></td>
<% }%>
<% if (warn_c02.equals("warn00") || warn_c02.equals("warn01")) { %>
<td class="warning"><%=inq.getString("warn_col02")%></td>
<% } else { %>
<td><%=inq.getString("warn_col02")%></td>
<% }%>
<% if (warn_c03.equals("warn00") || warn_c03.equals("warn01")) { %>
<td class="warning"><%=inq.getString("warn_col03")%></td>
<% } else { %>
<td><%=inq.getString("warn_col03")%></td>
<% }%>
<% if (warn_c04.equals("warn00") || warn_c04.equals("warn01")) { %>
<td class="warning"><%=inq.getString("warn_col04")%></td>
<% } else { %>
<td><%=inq.getString("warn_col04")%></td>
<% }%>
<% if (warn_c05.equals("warn00") || warn_c05.equals("warn01")) { %>
<td class="warning"><%=inq.getString("warn_col05")%></td>
<% } else { %>
<td><%=inq.getString("warn_col05")%></td>
<% }%>
<td>
<%
if (inq.getString("warn_col06").equals("YES") || inq.getString("warn_col06").equals("มี")) {
%>
<a href="javascript:pageDesc('<%=screen.getString("employeeid")%>','<%=cDate.getDDMMYYYY()%>','<%=screen.getString("ttime_current1_warning","sequence")%>')">
<i class="changepage-icon fa fa-info"></i>
</a>
<%
} else { out.println("-"); }
%>
</td>
</tr>
<%
}
i++;
} while(inq.next()); //end while
} //end if
%>
</tbody>
</table>
</div>
</form>
</div>
<a href="#top" id="top-button">
<i class="fa fa-angle-up"></i>
<div class="top-word">Back to top</div>
</a>
</section>
<jsp:include page="FOOTER.jsp" flush="true" />
</body>
</html>