<%@ page contentType="text/html; charset=UTF-8" language="java" %>
<%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*"%>
<%@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.*"  %>
<%@page import="com.csc.library.myutil.FormatUtil"%>
<% request.setCharacterEncoding("UTF-8"); %>
<jsp:useBean id="EMV" class="com.csc.library.system.Task" scope="page"/>
<jsp:setProperty name="EMV" property="appname" value="empview" />
<%
	String curr_date = "";
	String btn_label = "";
	String lang = "";
	CheckNull chk=new CheckNull();
	CscCalendar cale = new CscCalendar();
	curr_date = cale.getYYYYMMDD();
	
	EMV.setChannel(request, response);	
	HelpEntry screen = (HelpEntry) EMV.process("HelpEntry", "EMV017HELP"); 
	lang = screen.getUProfile().get("lang");
	screen.inq.getChild("ER_SV_CAR_SERVICE_INFO").setFilter(" CONTRACT_END_DATE >= '"+curr_date+"' ");
	screen.inq.refresh();	
	screen.referLangOn();
	
	if(lang.equals("tha")){
		btn_label = "แนะนำ/ติชม";
	}else btn_label = "Suggestion/Comment";	
	
	int num_tr =0;
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/template-emv-main.dwt.jsp" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Employee View</title>
<!-- InstanceEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=TIS620" />
<!-- InstanceBeginEditable name="head" -->
<!-- Begin CSS Links -->
<link rel="stylesheet" type="text/css" href="../CSS/EMV_DEFAULT.css" />
<link rel="stylesheet" type="text/css" href="../CSS/EMV_LAYOUT.css" />
<link rel="stylesheet" type="text/css" href="../CSS/EMV_LAYOUT_TWO.css" />
<link rel="stylesheet" type="text/css" href="../CSS/EMV_TEXT.css" />
<link rel="stylesheet" type="text/css" href="../CSS/DDMENU.css" />

<!-- End CSS Links -->
<!-- Begin Scripts -->
<script language="JavaScript"  type="text/javascript"src="../JS/SCREEN.js"></script>
<script language='javascript'>
<!--
setLang('<%=lang%>');

//-->
</script>
<script language="JavaScript"  type="text/javascript"src="../JS/EVENTS.js"></script>
<script language="JavaScript"  type="text/javascript" src="../JS/UTILITIES.js"></script>
<script language="JavaScript"  type="text/javascript"src="../JS/ACTIVE_OBJECT.js"></script>
<!-- Begin script for Dropdown Menu -->
<!-- DO NOT EDIT -->
<script language="JavaScript"  type="text/javascript" src="../JS/DDMENU.js"></script>
<!--[if lt IE 7]><script language="JavaScript" type="text/javascript" src="../JS/IEHOVER-FIX.js"></script><![endif]-->
<!-- DO NOT EDIT -->
<!-- End script for Dropdown Menu -->
<style type="text/css">
#header {
 	background: #FFFFFF ;
}
</style>
<!-- End Scripts -->
<!-- Begin Head -->

<!-- End Head -->
<!-- InstanceEndEditable -->
</head>
<body>
<div id="wrapper">
  <div id="header"><!-- InstanceBeginEditable name="header" -->
    <jsp:include page="EMV_HEADER.jsp" flush="true" />
   <!-- InstanceEndEditable -->  </div>
  <div id="topnav"><!-- InstanceBeginEditable name="top_navigation" -->
  	<jsp:include page="EMV_TOPMENU.jsp" flush="true" />
    <!-- InstanceEndEditable -->  </div>
  <div id="container">
    <div id="sidebar"><!-- InstanceBeginEditable name="side_bar" -->
    <jsp:include page="EMV_SIDEBAR.jsp" flush="true" />
      <!-- InstanceEndEditable -->    </div>
    <div id="content"><!-- InstanceBeginEditable name="main_content" -->
    <!-- Begin Main Content -->
      <jsp:include page="../EMPVIEW/EMV_HELPBAR.jsp" flush="true" />
      <div class="content">
      <form name="cscform" method="post" action="?">
          <input type="hidden" name="__cmd" value="">
          <input type="hidden" name="__screen" value="EMV017">
          <input type="hidden" name="__language" value ="<%=screen.getUProfile().get("lang")%>">
	  
	<div class="content-box1">
      <div class="content-header">
        <h2> <script language="javascript">swapLang('Car Service Employee Table');</script></h2>
      </div>
      <table width="100%" border="0" cellpadding="0" cellspacing="1" class="table-content-list">
        <tr>
          <td colspan="3" ><h3 align="center"><script language="javascript">swapLang('Committee List ');</script></h3></td>
          <td >
 <%
			boolean first = true;
			String temp_id = "";
			String id = "";	
			String e_mail= "";
			String way_id = "";
			DbInquiry dbe = null;
			
			if(screen.nextRec()){
				dbe = (DbInquiry) screen.getInquiry().getCurrentDbRecord().getChild("ER_SV_CAR_SERVICE_INFO").getChild("ER_SV_CAR_SERVICE_INFO_COM");
				dbe.refresh();
				if(dbe.recCount()>0){
					while(dbe.next()){
						temp_id = dbe.getString("EMPLOYEEID");
						if(first){	
							id = dbe.getString("EMPLOYEEID");		
							e_mail = chk.chkNullString(dbe.getString("MEMPLOYEE","EMAIL"),"");	
							first = false;			
						}
						
						if(!temp_id.equals(id)){
							id = dbe.getString("EMPLOYEEID");		
							if(!dbe.getString("MEMPLOYEE","EMAIL").equals("")){
								e_mail =  (!e_mail.equals(""))?e_mail+","+dbe.getString("MEMPLOYEE","EMAIL"):dbe.getString("MEMPLOYEE","EMAIL");
							}						
						}
					}//end while
				}//end if 
			}//end while			
		%>		  
		  <a href="mailto:<%=e_mail%>"><img src="../IMAGES/EMPVIEW/BUTTON/COMMENT.gif" width="80" height="23"  align="baseline" /></a></td>
        </tr>
        <tr>
          <td width="55" class="column-header"> <script language="javascript">swapLang('ID ');</script></td>
          <td width="293" class="column-header"><script language="javascript">swapLang('Fullname');</script></td>
          <td  width="159" class="column-header"> <script language="javascript">swapLang('Current Working');</script> </td>
          <td width="216" class="column-header"><script language="javascript">swapLang('Period Induction Date');</script></td>
        </tr>
            <%
			
				first = true;
				temp_id = "";
				id = "";		
				DbInquiry dbc = null;
				screen.inq.first();
				if(screen.nextRec()){
					 dbc =(DbInquiry) screen.getInquiry().getCurrentDbRecord().getChild("ER_SV_CAR_SERVICE_INFO").getChild("ER_SV_CAR_SERVICE_INFO_COM");
					 dbc.refresh();
					if(dbc.recCount()>0){
						while(dbc.next()){
							temp_id = dbc.getString("EMPLOYEEID");
							if(first){	
								id = dbc.getString("EMPLOYEEID");						
							}
							
							if(!temp_id.equals(id) || first){
								first = false;	
						%>		
            <tr>
          <td class="column-text-center" ><%=temp_id%></td>
          <td class="column-text"  ><span class="Text"><%=dbc.getString("FULL_NAME")%></span></td>
          <td class="column-text"  ><%=chk.chkNullString(dbc.getString("BU2"),"-")%></td>
          <td class="column-text"  ><%
								  	if(!dbc.getString("START_DATE").equals("1900-01-01") && !dbc.getString("END_DATE").equals("1900-01-01")){
										out.print(dbc.getCurrentDbRecord().getCscCalendar("START_DATE").getDDMMYYYY()+" - "+
										dbc.getCurrentDbRecord().getCscCalendar("END_DATE").getDDMMYYYY());
									}else if(!dbc.getString("START_DATE").equals("1900-01-01")){
										out.print(dbc.getCurrentDbRecord().getCscCalendar("START_DATE").getDDMMYYYY());
									}else if(!dbc.getString("END_DATE").equals("1900-01-01")){
										out.print(dbc.getCurrentDbRecord().getCscCalendar("END_DATE").getDDMMYYYY());
									}else{ out.print("-"); }
								  %></td>
        </tr>
<%								
							id = temp_id;								
						}//end if					
					}//end while
				}//end if
			}//end while	
		%>	
      </table>
	  <br>
      <table width="100%" border="0" cellpadding="0" cellspacing="1" >
	  <%
  	DbInquiry dbs = null;
	DbInquiry dbp = null;
	String open_tr ="<tr>";
	String close_tr ="</tr>  ";
	String open_td ="<td  valign=\"top\" width=\"48%\" class=\"column-text-center\">";
	String close_td ="</td>";	
	String gap = "<td width=\"2%\"  class=\"column-text-center\">&nbsp;</td>";

  	screen.inq.first();
	while(screen.nextRec()){
		way_id ="";
				
				if(!way_id.equals(screen.getString("WAYID"))){
					way_id=screen.getString("WAYID");
					num_tr++;	
					if((num_tr%2) == 1){
						out.print(open_tr);	
						out.print(open_td);				
					}
	%>
			<table width="100%" border="0" cellpadding="0" cellspacing="1" class="table-content-list">
              <tr class="title_box" >
                <td width="80%" height="35"  class="column-header"><script language="javascript">swapLang('Car Service ID');</script> 
            <%=screen.getString("WAYID")%>&nbsp;:&nbsp;<%=chk.chkNullString(screen.inq.getChild("ER_SV_CAR_WAY").getString("TDESC"),"-")%> 
			<% 
				String lead_name = screen.getInquiry().getChild("ER_SV_CAR_SERVICE_INFO_LEAD").getString("f_fullname"); 
				if( !lead_name.equals("") ){
			%>
			<%="("+lead_name +")"%>
			<%//="("+screen.getInquiry().getChild("ER_SV_CAR_SERVICE_INFO").getChild("ER_SV_CAR_SERVICE_INFO_LEAD").getChild("memployee").getString("fullname")+")"%>
			<% } %>
			</td>
			<td width="20%" class="column-header"><script language="javascript">swapLang('Arrived time');</script></td>
              </tr>
					<%
						dbp = (DbInquiry) screen.getInquiry().getCurrentDbRecord().getChild("ER_SV_CAR_WAY").getChild("ER_SV_CAR_WAY_PASS");
						dbp.refresh();
							if(dbp.recCount()>0){
								while(dbp.next()){
					%>			  
              <tr>
                <td class="column-text"><%=chk.chkNullString(dbp.getString("LOCATIONS"),"-")%></td>
                <td class="column-text center"><%=chk.chkNullString(FormatUtil.formatTime(dbp.getCurrentDbRecord().getDouble("PASS_TIME")),"-")%></td>
              </tr>
					<%						
								}
							}
					%>									
          </table>
					<%				 
					out.print(close_td);
					if((num_tr%2) == 1){
						out.print(open_td);		
					}else if ((num_tr%2) == 0){
						out.print(close_tr);						
						//out.print(open_tr+open_td+"&nbsp;"+close_td+close_tr);
					}	
				//}//end if		
			//}	//end while	
		} //end if
	}//end while
	screen.referLangOff();
  %>		  
      </table>
      <div class="content-footer"><img src="../IMAGES/SPACER.gif" width="3" height="3" /></div>
    </div>   
    </form>  
	  </div>
      <!-- End Main Content -->
      <!-- InstanceEndEditable -->    </div>
  </div>
  <div id="footer"><!-- InstanceBeginEditable name="footer" -->
  <jsp:include page="EMV_FOOTER.jsp" flush="true" />
  <!-- InstanceEndEditable -->  </div>
</div>
</body>
<!-- InstanceEnd --></html>