<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*,java.lang.*"%>
<%@ page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*,java.util.*,java.rmi.RemoteException" %>
<jsp:useBean id="TAU180" class="com.csc.library.system.Task" scope="page" />
<%ThaiUtilities th= new ThaiUtilities();%>
<%
TAU180.setChannel(request, response);
HelpEntry screen = (HelpEntry) TAU180.process("HelpEntry", "TAU180HELP");
screen.setMaxLine(20);
screen.process();
%>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link href="../CSS/TISCO.css" rel="stylesheet" type="text/css">
<script language="JavaScript" src="../JS/SCREEN.js"></script>
<script type='text/javascript' src='../JS/ICONSMENU.js'></script>
<script type='text/javascript' src='../JS/VIEWCALENDAR.js'></script>
<script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</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 submitform() {
with (document.cscform) {
__cmd.value="search";
//action = "TAU159.jsp";
submit();
}
}
function checkConfirm(year,month,employeeid){
//var workareaname='<%=request.getParameter("workareaname")%>';
document.cscform.month.value=month;
document.cscform.selectyear.value=year;
with(document.cscform){
__employeeid.value = employeeid;
fullname.value = '<%=th.ASCII2Unicode(request.getParameter("fullname"))%>';
}
}
function linkPage(){
document.cscform.__cmd.value="search";
document.cscform.action="TAU160_LPN.jsp";
document.cscform.submit();
}
function goHelp(helpName,inputName){
with(document.cscform){
var helpReturn="";
var fcon=__fixCon.value;
if(inputName=="__employeeid" )
helpReturn="__employeeid:employeeid,fullname:fullname";
if(fcon=="")
linkHelp_Return(helpName,helpReturn);
else
helpPageCon(helpName,helpReturn,fcon);
}
}
function listDblClick(objmyList){
for(i=objmyList.length;i > 0;i--){
if(objmyList.options[i-1].selected==true){
bCon=confirm("ต้องการลบ "+objmyList.options[i-1].text+" หรือไม่ ?");
if (bCon==true){
objmyList.options[i-1] = null;
}
}
}
}
</script>
<style type="text/css">
<!--
.style1 {color: #FF0000}
-->
</style>
</head>
<body leftmargin="0" topmargin="0" >
<form name="cscform" method="post" action="TAU180.jsp">
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%=screen.InitialVariable()%>
<!----------END CSC INITIAL ZONE -------------------------->
<input type="hidden" name="__screen" value="TAU180">
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__goPage" value="">
<input type="hidden" name="__orderBy" value="">
<input type="hidden" name="__helpReturn" value="">
<input type="hidden" name="__helpName" value="">
<input type="hidden" name="__pageCall" value="">
<input type="hidden" name="__fixCon" value="">
<input type="hidden" name="__calendar">
<input type="hidden" name="__link">
<!--input type="hidden" name="__confirm"-->
<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
<script language="javascript">getInputFormatDate();</script>
<br>
<table width="640" align="center" cellpadding="0" cellspacing="0" >
<tr >
<td class="header" colspan="7"> TAU180, <script language="javascript">swapLang("Define Shift Sleep Pattern");</script> </td>
</tr>
<tr>
<td colspan="7" class="blankspace"></td>
</tr>
<tr >
<%
String month=request.getParameter("month");
String year=request.getParameter("selectyear");
String employeeid = request.getParameter("__employeeid");
String fullname = request.getParameter("fullname");
CscCalendar csc= new CscCalendar();
CscCalendar cscmonth= new CscCalendar();
int getyear=csc.getYear();
int getmonth=cscmonth.getMonth();
// out.println(getmonth);
%>
<td colspan="7" align="center">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="columnlabel"><%=screen.getLabel("employeeid")%> </td>
<td><input type="text" name="__employeeid" value="" size="10" >
<a href="javascript:goHelp('MEMPLOYEEHELP','__employeeid');"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif"align="absmiddle" border="0"/></a>
<input type="text" name="fullname" value="" size="30" readonly="true"></td>
</tr>
<tr>
<td class="columnlabel"><script language="javascript">swapLang("Month");</script> </td>
<td><select name="month">
<%
String[]months={"JANUARY","FEBRUARY","MARCH","APRIL","MAY","JUNE","JULY","AUGUST","SEPTEMBER","OCTOBER","NOVEMBER","DECEMBER"};
for(int m=0;m<12;m++){
if(m==getmonth){%>
<option value="<%=m+1%>" selected>
<script language="javascript">swapLang("<%=months[m]%>");</script>
</option>
<%}
else{%>
<option value="<%=m+1%>" >
<script language="javascript">swapLang("<%=months[m]%>");</script>
</option>
<%}}%>
</select>
<script language="javascript">swapLang("Year");</script>
<input type="text" name="selectyear" size="5" value="<%=getyear%>" onKeyPress="javascript:chkInteger();" maxlength="4">
<a href="javascript:submitform();"><img src="../IMAGES/BUTTON/SUBMIT.gif" alt="Submit" border="0" align="absmiddle"></a></td>
</tr>
<tr>
<td colspan="2" class="blankspace"> </td>
</tr>
</table>
</td>
</tr>
<%
if(month!=null && year!=null && employeeid!=null){
//out.println(th.ASCII2Unicode(workareaname));%>
<script language="javascript">checkConfirm('<%=year%>','<%=month%>','<%=employeeid%>');</script>
<tr>
<td colspan="7">
<table width="100%" height="58" border="1" cellpadding="1" cellspacing="1" bgcolor="#333333">
<tr>
<td width="14%" class="row3" align="center"><strong><script language="javascript">swapLang("Mon");</script></strong></td>
<td width="14%" class="row3" align="center"><strong><script language="javascript">swapLang("Tue");</script></strong></td>
<td width="14%" class="row3" align="center"><strong><script language="javascript">swapLang("Wed");</script></strong></td>
<td width="14%" class="row3" align="center"><strong><script language="javascript">swapLang("Thu");</script></strong></td>
<td width="14%" class="row3" align="center"><strong><script language="javascript">swapLang("Fri");</script></strong></td>
<td width="14%" class="row3" align="center"><div class="style1"><strong><script language="javascript">swapLang("Sat");</script></strong></div></td>
<td width="14%" class="title1" align="center"><div class="style1"><strong><script language="javascript">swapLang("Sun");</script></strong></div></td>
</tr>
<%
int i=1;
int td=0;
int temp=Integer.parseInt(month)+1;
//month=Integet.toString(temp);
//out.println(month);
String datebeginofmonth="01-"+month+"-"+year;
CscCalendar csc1= new CscCalendar(datebeginofmonth);
String enddate=Integer.toString(csc1.getEndDateOfMonth());
String dateendofmonth=enddate+"-"+month+"-"+year;
String time0id="";
CscCalendar csc2= new CscCalendar(dateendofmonth);
HashMap hmHoliday = new HashMap();
try {
DbInquiry inqHoliday = new InitialInquiry(screen.getUProfile()).getDbInquiry();
inqHoliday.setSchemaName(screen.getUProfile().getSchemaName());
inqHoliday.initMyTable("Mholiday1","","");
inqHoliday.setColumn("*");
DbInquiry inqShift = new InitialInquiry(screen.getUProfile()).getDbInquiry();
inqShift.setSchemaName(screen.getUProfile().getSchemaName());
inqShift.initMyTable("Mtime0","","");
inqShift.setColumn("*");
inqShift.putChild(inqHoliday);
/*getChild ออกมาแสดง*/
String filter1 = "employeeid='"+employeeid+"'";
DbInquiry inqTime = new InitialInquiry(screen.getUProfile()).getDbInquiry();
inqTime.setSchemaName(screen.getUProfile().getSchemaName());
inqTime.initMyTable("Ttime_current","","");
inqTime.setColumn("*");
inqTime.putChild(inqShift);
DbInquiry inqEmp = new InitialInquiry(screen.getUProfile()).getDbInquiry();
inqEmp.setSchemaName(screen.getUProfile().getSchemaName());
inqEmp.initMyTable("Memployee", filter1,"");
inqEmp.setColumn("*");
inqEmp.putChild(inqTime);
inqEmp.refresh();
while(inqEmp.next()){
DbRecord rec = inqEmp.getCurrentDbRecord();
time0id = rec.getString("time0");
DbInquiry child = (DbInquiry) inqEmp.getChild("Mholiday1");
do{
hmHoliday.put(child.getString("hdate"),child.getString("edesc"));
}while(child.next());
}
} catch (RemoteException e) {
// TODO Auto-generated catch block
e.printStackTrace();
out.println(e);
}
while (csc1.beforeEqualsDate(csc2)) {
String check =csc1.getYYYYMMDD().substring(8,10);
String getDate =csc1.getYYYYMMDD();
int checkdate=Integer.parseInt(check);
if(checkdate==1){
String d=csc1.getLongEngDOW();//เช็ควันที่ 1 ของทุกเดือน
if(d.equals("Tuesday")){
i=2;
out.println("<td width='14%'></td>");
}
if(d.equals("Wednesday")){
i=3;
out.println("<td width='14%'></td><td width='14%'></td>");
}
if(d.equals("Thursday")){
i=4;
out.println("<td width='14%'></td><td width='14%'></td><td width='14%'></td>");
}
if(d.equals("Friday")){
i=5;
out.println("<td width='14%'></td><td width='14%'></td><td width='14%'></td><td width='14%'></td>");
}
if(d.equals("Saturday")){
i=6;
out.println("<td width='14%'></td><td width='14%'></td><td width='14%'></td><td width='14%'></td><td width='14%'></td>");
}
if(d.equals("Sunday")){
i=7;
out.println("<td width='14%'></td><td width='14%'></td><td width='14%'></td><td width='14%'></td><td width='14%'></td><td width='14%'></td>");
}
}// endif day
String c =csc1.getYYYYMMDD().substring(8,10);
int date=Integer.parseInt(c);
if(i<=7){ %><%
if(i==6 || i==7){
%>
<td width="14%" align="center" height="200" class="style1" valign="top"><a href="TAU181.jsp?__employeeid=<%=employeeid%>&__dateid=<%=getDate%>&__time0id=<%=time0id%>&__link=true" ><%out.println(date);%></a><p>
<%
String filter="dateid='"+getDate+"' and employeeid = '"+employeeid+"'";
DbInquiry inq = new InitialInquiry(screen.getUProfile()).getDbInquiry();
inq.setSchemaName(screen.getUProfile().getSchemaName());
inq.initMyTable("Ttime_current", filter, "employeeid");
inq.setColumn("*");
inq.refresh();
int j=0;
while (inq.next()) {
DbRecord rec = inq.getCurrentDbRecord();
/*if (rec.getString("eventgrp").equalsIgnoreCase("j")) {
out.print("<img src='../IMAGES/ICONS/absent.gif' width='16' height='16'>");
}*/
if (Double.valueOf(rec.getString("absent")).doubleValue() > 0){
out.print("<img src='../IMAGES/ICONS/absent.gif' width='16' height='16'>");
}
if (Double.valueOf(rec.getString("lv")).doubleValue() > 0){
out.print("<img src='../IMAGES/ICONS/leave.gif' width='16' height='16'>");
}
if (Double.valueOf(rec.getString("lt")).doubleValue() > 0){
out.print("<img src='../IMAGES/ICONS/late.gif' width='16' height='16'>");
}
if (Double.valueOf(rec.getString("ot")).doubleValue() > 0){
out.print("<img src='../IMAGES/ICONS/ot.gif' width='16' height='16'>");
}
if (rec.getString("sleep").equals("1")){
out.print("<img src='../IMAGES/ICONS/sleepturn.gif' width='16' height='16'>");
}
}// end while
if (hmHoliday.containsKey(getDate)){
out.println(hmHoliday.get(getDate));
}
%>
</td>
<%}else{
%><td width="14%" height="200" align="center" valign="top"><a href="TAU181.jsp?__employeeid=<%=employeeid%>&__dateid=<%=getDate%>&__time0id=<%=time0id%>&__link=true" ><%out.println(date);%></a><p><%
String filter="dateid='"+getDate+"' and employeeid = '"+employeeid+"'";
DbInquiry inq = new InitialInquiry(screen.getUProfile()).getDbInquiry();
inq.setSchemaName(screen.getUProfile().getSchemaName());
inq.initMyTable("Ttime_current", filter, "employeeid");
inq.setColumn("*");
inq.refresh();
int j=0;
while (inq.next()) {
DbRecord rec = inq.getCurrentDbRecord();
/*if (rec.getString("eventgrp").equalsIgnoreCase("j")) {
out.print("<img src='../IMAGES/ICONS/absent.gif' width='16' height='16'>");
}*/
if (Double.valueOf(rec.getString("absent")).doubleValue() > 0){
out.print("<img src='../IMAGES/ICONS/absent.gif' width='16' height='16'>");
}
if (Double.valueOf(rec.getString("lv")).doubleValue() > 0){
out.print("<img src='../IMAGES/ICONS/leave.gif' width='16' height='16'>");
}
if (Double.valueOf(rec.getString("lt")).doubleValue() > 0){
out.print("<img src='../IMAGES/ICONS/late.gif' width='16' height='16'>");
}
if (Double.valueOf(rec.getString("ot")).doubleValue() > 0){
out.print("<img src='../IMAGES/ICONS/ot.gif' width='16' height='16'>");
}
if (rec.getString("sleep").equals("1")){
out.print("<img src='../IMAGES/ICONS/sleepturn.gif' width='16' height='16'>");
}
}
if (hmHoliday.containsKey(getDate)){
out.println(hmHoliday.get(getDate));
}
%>
</td>
<%
}//else i=6 and i=7
}//end if i<=7
if(i>7){%>
</tr><tr><td width="14%" height="200" align="center" valign="top"><a href="TAU181.jsp?__employeeid=<%=employeeid%>&__dateid=<%=getDate%>&__time0id=<%=time0id%>&__link=true" ><%out.println(date);%></a><p>
<%
String filter="dateid='"+getDate+"' and employeeid = '"+employeeid+"'";
DbInquiry inq = new InitialInquiry(screen.getUProfile()).getDbInquiry();
inq.setSchemaName(screen.getUProfile().getSchemaName());
inq.initMyTable("Ttime_current", filter, "employeeid");
inq.setColumn("*");
inq.refresh();
int j=0;
while (inq.next()) {
DbRecord rec = inq.getCurrentDbRecord();
/*if (rec.getString("eventgrp").equalsIgnoreCase("j")) {
out.print("<img src='../IMAGES/ICONS/absent.gif' width='16' height='16'>");
}*/
if (Double.valueOf(rec.getString("absent")).doubleValue() > 0){
out.print("<img src='../IMAGES/ICONS/absent.gif' width='16' height='16'>");
}
if (Double.valueOf(rec.getString("lv")).doubleValue() > 0){
out.print("<img src='../IMAGES/ICONS/leave.gif' width='16' height='16'>");
}
if (Double.valueOf(rec.getString("lt")).doubleValue() > 0){
out.print("<img src='../IMAGES/ICONS/late.gif' width='16' height='16'>");
}
if (Double.valueOf(rec.getString("ot")).doubleValue() > 0){
out.print("<img src='../IMAGES/ICONS/ot.gif' width='16' height='16'>");
}
if (rec.getString("sleep").equals("1")){
out.print("<img src='../IMAGES/ICONS/sleepturn.gif' width='16' height='16'>");
}
}//end while
//เอาวันหยุดนักขตฤกษ์ มาแสดงในแต่ละเดือนที่มีอยู่ใน HashMap
if (hmHoliday.containsKey(getDate)){
out.println(hmHoliday.get(getDate));
}
%>
</td>
<% i =1;
}// end if i>7
csc1.incDate();
i++;
}//whileif
if(enddate.equals("28") ||enddate.equals("29") ||enddate.equals("30") ||enddate.equals("31")){
int d=7-i;
for(int k=0;k<=d;k++){%>
<td width="14%"> </td>
<%
}//end for
}//end if
%>
</table>
</td>
</tr>
<%}//end if month and year%>
<tr>
<td class="inframe" colspan="7" valign="middle"><br>
<img src="../IMAGES/ICONS/absent.gif" width="16" height="16"> = <script language="javascript">swapLang('Absent')</script>,
<img src="../IMAGES/ICONS/leave.gif" width="16" height="16"> = <script language="javascript">swapLang('Leave')</script>,
<img src="../IMAGES/ICONS/late.gif" width="16" height="16"> = <script language="javascript">swapLang('Late')</script>,
<img src="../IMAGES/ICONS/sleepturn.gif" width="16" height="16"> = <script language="javascript">swapLang('Sleep Pattern')</script>,
<img src="../IMAGES/ICONS/ot.gif" width="16" height="16"> = <script language="javascript">swapLang('OT')</script>
<br>
<br></td>
</tr>
<tr>
<td class="bottom" colspan="7"> </td>
</tr>
</table>
</form>
</body>
</html>