<%@page contentType="text/html; charset=UTF-8"%> <%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*,com.csc.library.session.*,com.csc.library.report.*"%> <%@page import="com.csc.library.export.*"%> <jsp:useBean id="XLSOPTION_WITH_SECURITY" class="com.csc.library.system.Task" scope="page" /> <% XLSOPTION_WITH_SECURITY.setChannel(request, response); XLSOPTION_WITH_SECURITY.checkProfile(); UProfile up=XLSOPTION_WITH_SECURITY.getUProfile(); String xlsname=request.getParameter("__xlsname"); JxlOption jop=new JxlOption(xlsname,up); String branch = ""; String position = ""; String bu1 = ""; String bu2 = ""; String bu3 = ""; String bu4 = ""; String bu5 = ""; HelpEntry screen = (HelpEntry) XLSOPTION_WITH_SECURITY.process("HelpEntry","MEMPLOYEEHELP"); screen.inq.setFilter("employeeid = '"+up.get("employeeid")+"'"); screen.process(); screen.nextRec(); screen.referLangOn(); DbInquiry inq_emp = new InitialInquiry(up).getDbInquiry("Memployee"); inq_emp.setColumn("*"); inq_emp.setFilter("employeeid = '"+up.get("employeeid")+"'"); inq_emp.refresh(); while (inq_emp.next()) { branch = inq_emp.getString("branch"); position = inq_emp.getString("emp_position"); bu1 = inq_emp.getString("bu1"); bu2 = inq_emp.getString("bu2"); bu3 = inq_emp.getString("bu3"); bu4 = inq_emp.getString("bu4"); bu5 = inq_emp.getString("bu5"); } %> <html> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/> <link rel="stylesheet" type="text/css" href="./CSS/EMV_LAYOUT.css" /> <link rel="stylesheet" type="text/css" href="./CSS/EMV_TEXT.css" /> <script language="JavaScript" src="./JS/VIEWCALENDAR.js"></script> <script language="JavaScript" src="./JS/SCREEN.js"></script> <script language="JavaScript" src="./JS/ICONSMENU.js"></script> <script language="JavaScript" src="./JS/HOTKEY.js"></script> <script type="text/javascript" src="./JS/jquery-1.3.2.min.js"></script> <script type="text/javascript" src="./JS/jquery/js/jquery-ui.js"></script> <script type="text/javascript" src="./JS/jquery.blockUI.js"></script> <link href="./JS/jquery/css/redmond/jquery-ui-1.7.1.custom.css" rel="stylesheet" type="text/css"/> <script language='javascript'>setLang('<%=XLSOPTION_WITH_SECURITY.getUProfile().get("lang")%>');</script> <script language="JavaScript" type="text/JavaScript"> function goUpload(page){ with(document.cscform){ open(page,"header","height=600,width=800"); } } function goPreview(){ with(document.cscform){ bCon=confirm("Do you want to print data?"); if (bCon==true) { action = "/hr/servlet/exportexcel/"; var temp = target; target = "_blank"; method="post"; submit(); target=temp; } } } function goExport(){ with(document.cscform){ bCon=confirm("Do you want to export data?"); if (bCon==true) { __cmd.value="save"; action = "/hr/EXPEXCEL.jsp"; var temp = target; target = "_blank"; method="post"; submit(); target=temp; } } } function showDate(mypicker){ $("#"+mypicker.id).datepicker({dateFormat: "dd-mm-yy",showAnim: "fadeIn",showOn: "focus",direction: 'up',showOtherMonths: true,selectOtherMonths: true,changeMonth: true,changeYear: true }); } function goHelp(helpName,helpReturn){ var fixcon = ""; if(helpName === "MBRANCHHELP") { fixcon = "branchid = '<%=branch%>'"; } else if(helpName === "MPOSITIONHELP") { fixcon = "positionid = '<%=position%>'"; } else if(helpName === "MBU1HELP") { fixcon = "bu1id = '<%=bu1%>'"; } else if(helpName === "MBU2HELP") { fixcon = "bu2id = '<%=bu2%>'"; } else if(helpName === "MBU3HELP") { fixcon = "bu3id = '<%=bu3%>'"; } else if(helpName === "MBU4HELP") { fixcon = "bu4id = '<%=bu4%>'"; } else if(helpName === "MBU5HELP") { fixcon = "bu5id = '<%=bu5%>'"; } linkHelp_Return(helpName,helpReturn,fixcon); } $(function(){ $('input[name="__branch"]').attr('readonly',true).addClass('disabled').val('<%=screen.getString("branch")%>'); $('input[name="__branchdesc"]').attr('readonly',true).addClass('disabled').val('<%=screen.getString("mbranch","tdesc")%>'); $('input[name="__position"]').attr('readonly',true).addClass('disabled').val('<%=screen.getString("emp_position")%>'); $('input[name="__positiondesc"]').attr('readonly',true).addClass('disabled').val('<%=screen.getString("mposition","tdesc")%>'); $('input[name="__bu1"]').attr('readonly',true).addClass('disabled').val('<%=screen.getString("bu1")%>'); $('input[name="__bu1desc"]').attr('readonly',true).addClass('disabled').val('<%=screen.getString("mbu1","tdesc")%>'); $('input[name="__bu2"]').attr('readonly',true).addClass('disabled').val('<%=screen.getString("bu2")%>'); $('input[name="__bu2desc"]').attr('readonly',true).addClass('disabled').val('<%=screen.getString("mbu2","tdesc")%>'); $('input[name="__bu3"]').attr('readonly',true).addClass('disabled').val('<%=screen.getString("bu3")%>'); $('input[name="__bu3desc"]').attr('readonly',true).addClass('disabled').val('<%=screen.getString("mbu3","tdesc")%>'); $('input[name="__bu4"]').attr('readonly',true).addClass('disabled').val('<%=screen.getString("bu4")%>'); $('input[name="__bu4desc"]').attr('readonly',true).addClass('disabled').val('<%=screen.getString("mbu4","tdesc")%>'); $('input[name="__bu5"]').attr('readonly',true).addClass('disabled').val('<%=screen.getString("bu5")%>'); $('input[name="__bu5desc"]').attr('readonly',true).addClass('disabled').val('<%=screen.getString("mbu5","tdesc")%>'); }); </script> <style> .disabled { background:#ebebe4; } </style> </head> <body> <div class="centered"> <div id="toolTipLayer" style="position:absolute; visibility: hidden"></div> <script language="javascript">initToolTips();</script> <form name="cscform" method="post" action="XLSOPTION_WITH_SECURITY.jsp"> <input type="hidden" name="__cmd" value=""/> <input type="hidden" name="__help" value=""/> <input type="hidden" name="__goPage" value=""/> <input type="hidden" name="__notNull" value=""/> <input type="hidden" name="__helpReturn" value=""/> <input type="hidden" name="__helpName" value=""/> <input type="hidden" name="__pageCall" value=""/> <input type="hidden" name="__referPage" value=""/> <input type="hidden" name="__language" value="<%=XLSOPTION_WITH_SECURITY.getUProfile().get("lang")%>"/> <input type="hidden" name="__calendar"/> <input type="hidden" name="__screen" value="XLSOPTION_WITH_SECURITY"/> <script language="javascript">getInputFormatDate();</script> <input type="hidden" name="__fixCon" value=""/> <input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>"/> <input type="hidden" name="__companyid" value="<%=XLSOPTION_WITH_SECURITY.getUProfile().get("companyid")%>"/> <input type="hidden" name="__xlsname" value="<%=xlsname%>"/> <input type="hidden" name="__tname" value="นำข้อมูลออกเป็นรูปแบบ excel"/> <input type="hidden" name="__ename" value="Export Excel"/> <input type="hidden" name="__ptype" value=""/> <input type="hidden" name="__prclass" value="ExcelExportFile"/> <br/> <jsp:include page="XLS_CHOOCE_COLUMN.jsp" flush="true"/> <div class="box-search-condition"> <div class="content-title">กำหนดเงื่อนไข</div> <table width="100%" border="0" cellpadding="0" cellspacing="0" class="table-search-condition"> <tr> <td colspan="5" class="column-label"> </td> </tr> <%=jop.getOption()%> <tr> <td colspan="5" class="column-label"><div align="center"><a href="javascript:goPreview()"><img src="IMAGES/MYNOTE/BUTTON/BUTTON_PRINT.gif" border="0"></a> <a href="javascript:goExport();"><img src="IMAGES/MYNOTE/BUTTON/BUTTON_EXPORT.gif" width="89" height="37" border="0"></a></div></td> </tr> </table> </div> <!-- End --> <br/> <br/> </form> </div> </body> </html>