<%@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">&nbsp;</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>