<%@page contentType="text/html; charset=UTF-8"%>
<%@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.utilities.*"%>
<%@page import="java.util.Calendar,java.util.GregorianCalendar,java.util.HashMap,java.util.Hashtable"%>
 <jsp:useBean id="AS_VOTE2_RESULT_LIST" class="com.csc.library.system.Task" scope="page" /> 
<%
	CheckNull chkNull=new CheckNull();
	ThaiUtilities thatUtils = new ThaiUtilities();	

 	AS_VOTE2_RESULT_LIST.setChannel(request,response); 

 	HelpEntry screenHelp = (HelpEntry) AS_VOTE2_RESULT_LIST.process("HelpEntry", "AS_VOTE2_RESULT_LIST");   
	//out.print("<br><br>>>>>>"+screen.getRecord());
	String Qs_Vote2id = request.getParameter("__vote2id");
	String whereClause=" apsid=(select group_quesid from mgroup_vote where status =1) "
								+" and apsassessor ='"+Qs_Vote2id+"' " ;
	screenHelp.getInquiry().setFilter(whereClause);
	screenHelp.process();
	screenHelp.nextRec();
%>
 
<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 type='text/javascript' src='../JS/SCREEN.js'></script>
<script type='text/javascript' src='../JS/DATEINPUT.js'></script>
<script type='text/javascript' src='../JS/VIEWCALENDAR.js'></script>
<script type='text/javascript' src='../JS/ICONSMENU.js'></script>
<script language='javascript'>setLang('<%=screenHelp.getUProfile().get("lang")%>');</script>
<script language="javascript">getTitleName();</script>
<script language='javascript' src='../JS/HOTKEY.js'></script>
</head>
<body leftmargin="0" topmargin="0">
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div> 
<form name="cscform" method="post" action="AS_VOTE2_RESULT_LIST.jsp">

<!----------q CSC INITIAL ZONE ------------------------>
<%=screenHelp.InitialVariable()%>
<!----------BEGIN CSC INITIAL ZONE -------------------------->

<!---------------- HIDDEN FIELD ZONE ---------------------->
	<!-- All Use -->
	<input type="hidden" name="__screen" value="AS_TAPSTRAN">
	<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="__dateid" value="">
	<input type="hidden" name="__time0id" value="">
	<input type="hidden" name="__language" value="<%=screenHelp.getUProfile().get("lang")%>">
	<input type="hidden" name="__companyid" value="<%=screenHelp.getUProfile().get("companyid")%>">
	<!---------------- HIDDEN FIELD ZONE ---------------------->

	<script language="javascript">getInputFormatDate();</script>
	<script language="javascript">initToolTips();</script>   
	<script language="JavaScript" type="text/JavaScript">
		function closeMe(){
			 self.close();
		}//end function 
    </script>
	<!--JavaScript Zone-->
	<table id='mainTbl' cellpadding="0" cellspacing="0"  border="1"  class = "largest" align='center'>
	<tr><td>
		<table id='headerTab' cellpadding="0" cellspacing="0"  border="1"  class = "largest">
			<tr bgcolor="#3366CC">
			  <td  height="20" class="header" colspan="9">
			  <div id='nameTab'>VOTE2 RESULT LIST,
				  <script language="javascript"> 
							swapLang("AS VOTE2 RESULT LIST");
				  </script>&nbsp;</div>
			  </td>
			</tr>
		</table>
	</td></tr>
	<tr><td class="blankspace"></td></tr>
	<tr><td>
		<table id='tblVote1Detail' width="100%"  border="0" cellpadding="0" cellspacing="0" bgcolor="#666666" align='center'>
			<tr>
				<td align="right"><b>V2U-ID:&nbsp</b></td>
				<td><%=screenHelp.getString("TAPSTRAN","APSID")%></td>
			</tr>
			<tr>
				<td align="right"><b><script language="javascript">swapLang("Full Name Vote2");</script>:&nbsp</b></td>
				<td><%=screenHelp.getString("MEMPLOYEE","FULLNAME")%></td>
			</tr>
			<tr>
				<td align="right"><b><script language="javascript">swapLang("Position");</script>:&nbsp</b></td>
				<td><%=screenHelp.getString("MPOSITION","TDESC")%></td>
			</tr>
			<tr>
				<td align="right"><b><script language="javascript">swapLang("BU1");</script>:&nbsp</b></td>
				<td><%=screenHelp.getString("MBU1","TDESC")%></td>
			</tr>
			<tr>
				<td align="right"><b><script language="javascript">swapLang("Work Age");</script>:&nbsp</b></td>
				<td>
					<%
						String thWorkAge1 = screenHelp.getDataLabel("MEMPLOYEE","empworkages");
						String newWorkAge1 = thWorkAge1.replace(" ปี ","/");
								  newWorkAge1 = newWorkAge1.replace(" เดือน ","/");
								  newWorkAge1 = newWorkAge1.replace("วัน","");
						String[] workage1=  newWorkAge1.split("/");
						out.print(workage1[0]+"/"+workage1[1]);
					%>
				</td>
			</tr>
		</table>
	</td></tr>
	<tr><td class="blankspace"></td></tr>
	<tr><td>รายชื่อผู้ที่ยังไม่โหวต</td></tr>
	<tr><td>
	<!--Display data from Table tapstran-->
		<table id='tblTapstran' width="100%"  border="0" cellpadding="1" cellspacing="1" bgcolor="#666666" class='largest'>
			<thead>
				<tr>
					<td width="3%" class="row3"><div align="center"><b>
					<script language="javascript">swapLang("Seq");</script></b></div>
					</td> 
					<td width="5%" class="row3">
						<div align="center"><b>
							<script language="javascript">
									swapLang("VOTE1ID");
							</script>
						</b></div>
					</td> 
					<td width="20%" class="row3">
						<div align="center"><b>
							<script language="javascript">
									swapLang("Full Name Vote1");
							</script>
						</b></div>
					</td> 
					 <td width="15%" class="row3"><div align="center"><b>
						<script language="javascript">swapLang("Position");</script></b></div></td>
					 <td width="20%" class="row3"><div align="center"><b>
						<script language="javascript">swapLang("BU1");</script></b></div></td>
					<td width="20%" class="row3"><div align="center"><b> 
						<script language="javascript">swapLang("BU2");</script></b></div></td>
					<td width="5%" class="row3"><div align="center"><b>
					<script language="javascript">swapLang("Work Age");</script></b></div></td>
					<td width="10%" class="row3"><div align="center"><b>
					<script language="javascript">swapLang("TEL EXT");</script></b></div></td>
				</tr>
		</thead>
			<tbody>
			<%
				String whereClause1=" apsstatus<>'A' " 
								+" and apsid=(select group_quesid from mgroup_vote where status =1) "
								+" and apsassessor ='"+Qs_Vote2id+"' " ;
				screenHelp.getInquiry().setFilter(whereClause1);
				screenHelp.process();
				int row = 0; 
				while(screenHelp.nextRec()){ 
						row++;	
			%>
				<tr>	    		
					<td class="forborder"><div align="center"><%=row%></div></td>
					<td class="forborder"><div align="center"><%=screenHelp.getString("TAPSTRAN","APSASSESSY")%></div></td>
					<td class="forborder"> <div align="center" style='color:red'><%=screenHelp.getString("SIMEMP","FULLNAME")%></div></td>
					<td class="forborder"> <div align="center"><%=screenHelp.getString("MPOSITION","TDESC")%></div></td>
					<td class="forborder"> <div align="center"><%=screenHelp.getString("MBU1","TDESC")%></div></td>
					<td class="forborder"> <div align="center"><%=screenHelp.getString("MBU2","TDESC")%></div></td>	
					<td><div align="center">
					<%
						String thWorkAge = screenHelp.getDataLabel("SIMEMP","empworkages");
						String newWorkAge = thWorkAge.replace(" ปี ","/");
								  newWorkAge = newWorkAge.replace(" เดือน ","/");
								  newWorkAge = newWorkAge.replace("วัน","");
						String[] workage=  newWorkAge.split("/");
						out.print(workage[0]+"/"+workage[1]);
					%>
					</div>
					</td>
					<td class="forborder">
						<div align="center">
							<% if(screenHelp.getString("SIMEMP","TEL_EXT").equals("")||screenHelp.getString("SIMEMP","TEL_EXT")==null){
										out.print("&nbsp");
									}else{
										out.print(screenHelp.getString("SIMEMP","TEL_EXT"));
									}//end if 
							%>
						</div>
					</td>	
					<!--td class="forborder"><div align="center"><%=screenHelp.getString("TAPSTRAN","APSSTATUS")%></div></td--> 
				</tr>
			<%	  
				}//end while 
			%>
			</tbody>
		</table>
	</td></tr>
	<tr><td class="blankspace"></td></tr>
	<tr><td>รายชื่อผู้ที่โหวตแล้ว</td></tr>
	<tr><td>
	<!--Display data from Table tblTapstranVoted-->
		<table id='tblTapstranVoted' width="100%"  border="0" cellpadding="1" cellspacing="1" bgcolor="#666666" class='largest'>
			<thead>
				<tr>
					<td width="3%" class="row3"><div align="center"><b>
					<script language="javascript">swapLang("Seq");</script></b></div>
					</td> 
					<td width="5%" class="row3">
						<div align="center"><b>
							<script language="javascript">
									swapLang("VOTE1ID");
							</script>
						</b></div>
					</td> 
					<td width="20%" class="row3">
						<div align="center"><b>
							<script language="javascript">
									swapLang("Full Name Vote1");
							</script>
						</b></div>
					</td> 
					 <td width="15%" class="row3"><div align="center"><b>
						<script language="javascript">swapLang("Position");</script></b></div></td>
					 <td width="20%" class="row3"><div align="center"><b>
						<script language="javascript">swapLang("BU1");</script></b></div></td>
					<td width="20%" class="row3"><div align="center"><b> 
						<script language="javascript">swapLang("BU2");</script></b></div></td>
					<td width="5%" class="row3"><div align="center"><b>
					<script language="javascript">swapLang("Work Age");</script></b></div></td>
					<td width="10%" class="row3"><div align="center"><b>
					<script language="javascript">swapLang("TEL EXT");</script></b></div></td>
				</tr>
		</thead>
			<tbody>
			<%
				String whereClause2=" apsstatus='A' " 
								+" and apsid=(select group_quesid from mgroup_vote where status =1) "
								+" and apsassessor ='"+Qs_Vote2id+"' " ;
				screenHelp.getInquiry().setFilter(whereClause2);
				screenHelp.process();
				int row2 = 0; 
				while(screenHelp.nextRec()){ 
						row2++;	
			%>
				<tr>	    		
					<td class="forborder"><div align="center"><%=row2%></div></td>
					<td class="forborder"><div align="center"><%=screenHelp.getString("TAPSTRAN","APSASSESSY")%></div></td>
					<td class="forborder"> 
						<div align="center" style='color:blue'><%=screenHelp.getString("SIMEMP","FULLNAME")%></div></td>
					<td class="forborder"> <div align="center"><%=screenHelp.getString("MPOSITION","TDESC")%></div></td>
					<td class="forborder"> <div align="center"><%=screenHelp.getString("MBU1","TDESC")%></div></td>
					<td class="forborder"> <div align="center"><%=screenHelp.getString("MBU2","TDESC")%></div></td>	
					<td><div align="center">
					<%
						String thWorkAge = screenHelp.getDataLabel("SIMEMP","empworkages");
						String newWorkAge = thWorkAge.replace(" ปี ","/");
								  newWorkAge = newWorkAge.replace(" เดือน ","/");
								  newWorkAge = newWorkAge.replace("วัน","");
						String[] workage=  newWorkAge.split("/");
						out.print(workage[0]+"/"+workage[1]);
					%>
					</div>
					</td>
					<td class="forborder">
						<div align="center">
							<% if(screenHelp.getString("SIMEMP","TEL_EXT").equals("")||screenHelp.getString("SIMEMP","TEL_EXT")==null){
										out.print("&nbsp");
									}else{
										out.print(screenHelp.getString("SIMEMP","TEL_EXT"));
									}//end if 
							%>
						</div>
					</td>	
					<!--td class="forborder"><div align="center"><%=screenHelp.getString("TAPSTRAN","APSSTATUS")%></div></td--> 
				</tr>
			<%	  
				}//end while 
			%>
			</tbody>
		</table>
	</td></tr>
	<tr><td class="blankspace"></td></tr>
	<tr><td>
			<div align="center" >
					<a href="javascript:closeMe();"><img src="../IMAGES/BUTTON/BACK.gif" border="0"></a>
			</div>
	</td></tr>
	<tr><td class="blankspace"></td></tr>
	<tr bordercolor="0069B3"><td class="bottom"></td></tr>
</table>
<!----------END CSC ENDING ZONE ------------------------>
<%=screenHelp.endJSP()%>
<!----------END CSC ENDING ZONE -------------------------->
</form>
</body>
</html>