<%@ 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\"> </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")%> : <%=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+" "+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>