<!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="com.csc.library.timeattendance.DayShift,com.csc.library.timeattendance.Shift,com.csc.library.timeattendance.WorkingShift"  %>
<%@page import="java.text.DecimalFormat,com.csc.library.database.MyHashMap"  %>
<%@ 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);
	EmvHelpEntry screen = (EmvHelpEntry) EMV.process("EmvHelpEntry", "STAT_ATTHELP");

	CheckNull chk = new CheckNull();
	String fixcon = chk.chkNullString(request.getParameter("__fixCon"));
	String employeeid = chk.chkNullString(request.getParameter("__employeeid"));
	String emp_name = chk.chkNullString(request.getParameter("MEMPLOYEE@FULLNAME"));
	CscCalendar sdate = new CscCalendar(chk.chkNullString(request.getParameter("date_start")));
	CscCalendar edate = new CscCalendar(chk.chkNullString(request.getParameter("date_end")));

	// actor detail
	String lang = screen.getUProfile().get("lang");
	String actorid = screen.getUProfile().get("employeeid");
	String actor_name = (lang.equalsIgnoreCase("tha"))?screen.getUProfile().get("tfullname"):screen.getUProfile().get("efullname");

	// employee display
	String emp_display = (employeeid.length() > 0)? employeeid:actorid;
	String name_display = (employeeid.length() > 0)? emp_name:actor_name;

	screen.setMaxLine(15);
	screen.getInquiry().setFilter(fixcon);	// set filter to tot_m_date0
	int beginRow=((Integer.parseInt(screen.goPage)-1)*screen.maxLine)+1;
    int endRow=(Integer.parseInt(screen.goPage))*screen.maxLine;
    screen.getInquiry().setBetween(beginRow, endRow);
	screen.process();
%>
<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>

			$(document).ready(function(){

				//datepicker function
				var myLang='<%=screen.getUProfile().get("lang")%>';

				var swap = new swaplang();
	            var titlename = swap.swap2String("SW012359");
				setPageTitle(titlename);

				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 goHelp(helpName,inputName){
				var helpReturn;
				var actid = "<%=actorid%>";
				//var con = "employeeid = '1000180'";
				var con = "employeeid = '" + actid + "' or employeeid in (select employeeid from msupervisor where supervisor like ',%25"+actid+"%25,')";
				helpReturn="__employeeid:employeeid,MEMPLOYEE@FULLNAME";
				linkHelp_Return(helpName,helpReturn,con);
			}

			function GoSearch(){
				with(document.cscform){
					//__fixCon.value = "employeeid = '" + __employeeid.value + "' and (wf_ref_doc is not null or wf_ref_doc != ' ')";
					__fixCon.value = "forget_date between '" + getConDate(date_start) + "' and '" + getConDate(date_end) + "' and fscardid in (select fscardid from tforgetcard0 where employeeid = '" + __employeeid.value + "')";
					search();
				}
			}

			function getConDate(obj){
				with(document.cscform){
					var d = obj.value.split("-");
					return d[2] + "-" + d[1] + "-" + d[0];
				}
			}

			function pageDesc(empCode, empName){
				with(document.cscform){
					var a=chkDateTime1(date_start.value);
					var b=chkDateTime1(date_end.value);

					window.open("EMP_SWIPETIME.jsp?__cmd="+
						"&__date_start="+a+"&__date_end="+b+
						"&date_start="+a+"&date_end="+b+
						"&__empID="+empCode+"&__empName="+empName,
						"Memployee","left=150,top=100,width=750,height=350,toolbar=no,status=yes,scrollbars=yes,resizable=yes"
					);
					//submit();
				}
			}

			function goPage(select_page){
				with( document.cscform ){
					if( select_page != "#" ){
						__goPage.value = select_page;
						submit();
					}
				}
			}
		</script>

		<section>
			<div class="container csc-content">
				<form name="cscform" class="form-horizontal" method="post" action="STAT_ATT_VIEW.jsp">
					<%=screen.InitialVariable()%>
					<input type="hidden" name="__cmd" value="">
					<input type="hidden" name="__screen"  value="STAT_ATT_VIEW">
					<input type="hidden" name="__help" value="">
					<INPUT TYPE="hidden" NAME="__goPage" 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="__calendar">
					<script language="javascript">getInputFormatDate();</script>
					<input type="hidden" name="__companyid"  value="<%=screen.getUProfile().get("companyid")%>">
					<input type="hidden" name="__fixCon" value="<%=fixcon%>">
					<input type="hidden" name="__language" value="<%=lang%>">
					<input type="hidden" name="__childFilter" >
					<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
					<script language="javascript">initToolTips();</script>

					<div class="csc-block">
						<div class="center">
							<h2 class="csc-block-head" swlang code='SW012359'>Statistic of Change Requisition</h2>
						</div>

						<div class="form-horizontal">
							<div class="row">
								<div class="form-group">
									<div class="col-md-2 col-sm-2"></div>
									<div class="col-md-2 col-sm-2 col-xs-2">
										<label class="control-label label-right" swlang code='SW000307'>Employee</label>
									</div>

									<div class="col-md-2 col-sm-2 col-xs-4">
										<div class="input-group">
											<input class="form-control" name="__employeeid" readonly value="<%=emp_display%>" size="10">
											<a class="input-group-addon" href="javascript:goHelp('MEMPLOYEEHELP','__employeeid')">
												<i class="fa fa-search"></i>
											</a>
										</div>
									</div>
									<div class="col-md-3 col-sm-3 col-xs-5">
										<input class="form-control" type="text" name="MEMPLOYEE@FULLNAME" value="<%=name_display%>" readonly size="40"></td>
									</div>
								</div>
							</div>

							<div class="row">
								<div class="form-group">
									<div class="col-md-2 col-sm-2"></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-4">
										<%
											CscCalendar cs = new CscCalendar();
											if (request.getParameter("date_start")==null) {
												CscCalendar csNow = new CscCalendar();
										%>
										<input class="form-control" name="date_start" type="text" value="<%=csNow.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-1 col-sm-1 col-xs-1">
										<label class="control-label label-right" swlang code='SW002095'>To</label>
									</div>

									<div class="col-md-2 col-sm-2 col-xs-4">
										<% if (request.getParameter("date_end")==null) { %>
										<input class="form-control" name="date_end" type="text" value="<%=cs.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="center">
								<a class="btn btn-primary" href="javascript:GoSearch();" swlang code='SW003537'>Search</a>
							</div>
						</div>
					</div>

					<%
						int browse_page = 0;
						int row = 0;

						if(fixcon.length() > 0){

							screen.process();

							browse_page = Integer.parseInt(screen.goPage);
							row = screen.inq.recCount();
						}
					%>

					<span class="detail-table">
						<span swlang code='SW001771'>Found Data</span> :&nbsp;&nbsp;<%=row%>&nbsp;
						<span swlang code='SW001780'>records</span>
					</span>
					<span class="detail-table label-right">
						<span swlang code='SW001120'>Page</span> : <%=screen.getPageTagNew()%>
					</span>

					<div class="table-responsive">
						<table class="table table-head table-hover table-bordered table-title-left table-content-center">
							<thead>
								<tr>
									<th class="table-title" colspan=5>
										<span swlang code='SW002350'>Stat att</span>
										(
										<%
											CscCalendar c1 = new CscCalendar();
											CscCalendar c2 = new CscCalendar();
											if (request.getParameter("date_start")==null && request.getParameter("date_end")==null) {
												//.
											} else {
												c1 = new CscCalendar(request.getParameter("date_start"));
												c2 = new CscCalendar(request.getParameter("date_end"));
											}
											if (screen.getUProfile().get("lang").equals("tha")) {
												out.println(c1.getThaiFull()+" - "+c2.getThaiFull());
											} else {
												out.println(c1.getEngFull()+" - "+c2.getEngFull());
											}
										%>
										)
									</th>
								</tr>
								<tr>
									<th swlang code='SW002354'>FSCARDID</th>
									<th swlang code='SW002355'>Forget date</th>
									<th swlang code='SW002356'>Forget time</th>
									<th swlang code='SW000302'>Remark</th>
									<th swlang code='SW002347'>Wf ref doc</th>
								</tr>
							</thead>
							<tbody>
								<%

									if(fixcon.length() > 0){
										screen.process();

										browse_page = Integer.parseInt(screen.goPage);
										row = screen.inq.recCount();
										while( screen.nextRec() ){
											DbInquiry child = (DbInquiry) screen.getInquiry().getCurrentDbRecord().getChild("tforgetcard0");

								%>
								<tr>
									<td><%=screen.getString("fscardid")%></td>
									<td><%=screen.getString("forget_date")%></td>
									<td><%=screen.getString("forget_time")%></td>
									<td><%=screen.getString("remark")%></td>
									<td><%=child.getString("wf_ref_doc")%></td>
								</tr>
								<%
										}
									}
								%>
							</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>