<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*"%>
<%@ page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*" %>
<jsp:useBean id="TAU161_LPN" class="com.csc.library.system.Task" scope="page" />
<%ThaiUtilities th= new ThaiUtilities();%>
<%
TAU161_LPN.setChannel(request, response);
HelpEntry screen = (HelpEntry) TAU161_LPN.process("HelpEntry", "TAU159HELP_LPN");
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 = "TAU161.jsp";
submit();
}
}
function checkConfirm(year,month,workarea){
//var workareaname='<%=request.getParameter("workareaname")%>';
document.cscform.month.value=month;
document.cscform.selectyear.value=year;
document.cscform.workarea.value=workarea;
document.cscform.workareaname.value='<%=th.ASCII2Unicode(request.getParameter("workareaname"))%>';
}
function linkPage(){
document.cscform.__cmd.value="search";
document.cscform.action="TAU162_LPN.jsp";
document.cscform.submit();
}
function goHelp(helpName,inputName){
var helpReturn;
var key;
helpReturn = inputName+":workareaid,workareaname:tdesc"
linkHelp_Return(helpName,helpReturn);
with(document.cscform){
if (__fixCon.value!="")
__fixCon.value=__fixCon.value;
var param="PRU084.jsp?__helpName="+helpName+"&__helpReturn="+helpReturn
+"&__pageCall="+__screen.value+"&__fixCon="+__fixCon.value+"&__checkVerify=off"
+"&__listName="+listName+"&__key="+key;
window.open(param,"Help","left=150,top=150,width=600,height=400,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
}
}
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="TAU161_LPN.jsp">
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%=screen.InitialVariable()%>
<!----------END CSC INITIAL ZONE -------------------------->
<input type="hidden" name="__screen" value="TAU161_LPN">
<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"> TAU161_LPN, <script language="javascript">swapLang("Define Shift Sleep Pattern");</script> </td>
</tr>
<tr>
<td colspan="7"></td>
</tr>
<tr >
<%
String month=request.getParameter("month");
String year=request.getParameter("selectyear");
String workarea=request.getParameter("workarea");
String workareaname=th.ASCII2Unicode(request.getParameter("workareaname"));
CscCalendar csc= new CscCalendar();
CscCalendar cscmonth= new CscCalendar();
int getyear=csc.getYear();
int getmonth=cscmonth.getMonth();
// out.println(getmonth);
%>
<td colspan="7"><div align="center"><script language="javascript">swapLang("Month");</script>
<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%>">
</div></td>
</tr>
<tr >
<td colspan="7"><div align="center"><script language="javascript">swapLang("Workarea");</script>
<input type="text" name="workarea" value="" size="10">
<img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif"align="absmiddle" onClick="javascript:goHelp('MWORKAREAHELP','workarea')"/>
<input type="text" name="workareaname" value="" size="30" readonly="true">
<img src="../IMAGES/BUTTON/SUBMIT.gif" width="73" height="23" align="absmiddle" onClick="submitform();"></div> </td>
</tr>
<tr >
<td colspan="7"></td>
</tr>
<%
if(month!=null && year!=null){
//out.println(th.ASCII2Unicode(workareaname));%>
<script language="javascript">checkConfirm('<%=year%>','<%=month%>','<%=workarea%>');</script>
<tr>
<td width="14%" class="title1"><div align="center"><script language="javascript">swapLang("Mon");</script></div></td>
<td width="14%" class="title1"><div align="center"><script language="javascript">swapLang("Tue");</script></div></td>
<td width="14%" class="title1"><div align="center"><script language="javascript">swapLang("Wed");</script></div></td>
<td width="14%" class="title1"><div align="center"><script language="javascript">swapLang("Thu");</script></div></td>
<td width="14%" class="title1"><div align="center"><script language="javascript">swapLang("Fri");</script></div></td>
<td width="14%" class="title1"><div align="center" class="style1"><script language="javascript">swapLang("Sat");</script></div></td>
<td width="14%" class="title1"><div align="center" class="style1"><script language="javascript">swapLang("Sun");</script></div></td>
</tr>
<tr>
<td colspan="7"><table width="100%" height="58" border="1" cellpadding="1" cellspacing="1" bgcolor="#666666">
<tr>
<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;
CscCalendar csc2= new CscCalendar(dateendofmonth);
while (csc1.beforeEqualsDate(csc2)) {
String check =csc1.getYYYYMMDD().substring(8,10);
String test=csc1.getDDMMYY();
int checkdate=Integer.parseInt(check);
if(checkdate==1){
String d=csc1.getLongEngDOW();//เช็ควันที่ 1 ของทุกเดือน
if(d.equals("Tuesday")){i=2;
%><td width="14%"></td>
<%}
if(d.equals("Wednesday")){i=3;
%><td width="14%"></td><td width="14%"></td>
<%}
if(d.equals("Thursday")){i=4;
%><td width="14%"></td><td width="14%"></td><td width="14%"></td>
<%}
if(d.equals("Friday")){i=5;
%><td width="14%"></td><td width="14%"></td><td width="14%"></td><td width="14%"></td>
<%}
if(d.equals("Saturday")){i=6;
%><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;
%><td width="14%"></td><td width="14%"></td><td width="14%"></td><td width="14%"></td><td width="14%"></td><td width="14%"></td>
<%}
}
String c =csc1.getYYYYMMDD().substring(8,10);int date=Integer.parseInt(c);
if(i<=7){ %><%
if(i==6 || i==7){
%>
<td width="14%"><div align="center" class="style1"><a href="TAU162_LPN.jsp?month=<%=month%>&workarea=<%=workarea%>&workareaname=<%=workareaname%>&selectyear=<%=year%>&dateid=<%=date%>&__cmd=search&__link=true" ><%out.println(date);%></a><p>
<%
String filter="monthid="+month+" and yearid="+year+" and workarea='"+workarea+"' and dateid="+date;
DbInquiry inq = new InitialInquiry(screen.getUProfile()).getDbInquiry();
inq.setSchemaName(screen.getUProfile().getSchemaName());
inq.initMyTable("Msleep_pattern", filter, "employeeid");
inq.setColumn("*");
inq.refresh();
int j=0;
while (inq.next()) {
DbRecord rec = inq.getCurrentDbRecord();
if(j==0){
out.println(rec.getString("employeeid"));
}if(j==1){
out.println(",*");
}
j++;
}if(j==0){%><p>...<%}%>
</p><p>[<%=j%>]</p><div></td>
<%}else{%><td width="14%"><div align="center"><a href="TAU162_LPN.jsp?month=<%=month%>&workarea=<%=workarea%>&workareaname=<%=workareaname%>&selectyear=<%=year%>&dateid=<%=date%>&__cmd=search&__link=true" ><%out.println(date);%></a><p><%
String filter="monthid="+month+" and yearid="+year+" and workarea='"+workarea+"' and dateid="+date;
DbInquiry inq = new InitialInquiry(screen.getUProfile()).getDbInquiry();
inq.setSchemaName(screen.getUProfile().getSchemaName());
inq.initMyTable("Msleep_pattern", filter, "employeeid");
inq.setColumn("*");
inq.refresh();
int j=0;
while (inq.next()) {
DbRecord rec = inq.getCurrentDbRecord();
if(j==0){
out.println(rec.getString("employeeid"));
}if(j==1){
out.println(",*");
}
j++;
}if(j==0){%><p>...<%}%></p><p>[<%=j%>]</p><div></td>
<%
}
}
if(i>7){%>
</tr><tr><td width="14%"><div align="center"><a href="TAU162_LPN.jsp?month=<%=month%>&workarea=<%=workarea%>&workareaname=<%=workareaname%>&selectyear=<%=year%>&dateid=<%=date%>&__cmd=search&__link=true" ><%out.println(date);%></a><p>
<%
String filter="monthid="+month+" and yearid="+year+" and workarea='"+workarea+"' and dateid="+date;
DbInquiry inq = new InitialInquiry(screen.getUProfile()).getDbInquiry();
inq.setSchemaName(screen.getUProfile().getSchemaName());
inq.initMyTable("Msleep_pattern", filter, "employeeid");
inq.setColumn("*");
inq.refresh();
int j=0;
while (inq.next()) {
DbRecord rec = inq.getCurrentDbRecord();
if(j==0){
out.println(rec.getString("employeeid"));
}if(j==1){
out.println(",*");
}
j++;
}if(j==0){%><p>...<%}%></p><p>[<%=j%>]</p><div></td>
<% i =1;
}
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>
<%}}%>
</table> </td>
</tr>
<%}%>
<tr>
<td class="bottom" colspan="7"> </td>
</tr>
</table>
</form>
</body>
</html>