<%@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.*"%>
<%@page import="jxl.Workbook,java.io.File"%>
<%@ page import="java.text.SimpleDateFormat" %>
<%@ page import="java.util.*" %>
<%@ page import="java.text.DecimalFormat" %>
<%@ page import="org.jdom.Element" %>
<%@ page import="com.csc.library.database.*" %>
<jsp:useBean id="XLSDASHBOARD" class="com.csc.library.system.Task" scope="page" />
<%
	XLSDASHBOARD.setChannel(request, response);
	XLSDASHBOARD.checkProfile();
	UProfile up=XLSDASHBOARD.getUProfile();
	String xlsname=request.getParameter("__xlsname");
	String reporttype=request.getParameter("__reporttype");
	//out.print(reporttype);
	JxlOption jop=new JxlOption(xlsname,up);

	File exlFile=new File(JxlConfig.TEMPLATE_PATH.concat(xlsname));

	Workbook workbook = Workbook.getWorkbook(exlFile);
	JxlTemplateRecord templateRecord=new JxlTemplateRecord(workbook , up);

	CheckNull chk = new CheckNull();
	CscCalendar calendar = new CscCalendar();
	DecimalFormat dfdate = new DecimalFormat("00");
	String filter_date= calendar.getEngYYYY()+"-"+dfdate.format(calendar.getMonth());
	SimpleDateFormat df = new SimpleDateFormat("hh:mm a", Locale.ENGLISH);
	GregorianCalendar gc= new GregorianCalendar();
	//String cmd = chk.chkNullString(request.getParameter("__cmd"));
	String screenname = chk.chkNullString(request.getParameter("__screen"));
	String conf = chk.chkNullString(request.getParameter("__confirm"));
	String conditionid = "";
	String conditiondesc ="";
	String condition="";
	String orderby="";
	String groupby="";
	String pagebreak="";
	String language="";
	String template="";
	String defaultreport="";
	String defaultcon="0";
	String norelationreport="0";

	String descReport = templateRecord.getTdesc();

%>
<%!

%>
<html ng-app="myHR">
<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" />
<link href="./JS/jquery/css/redmond/jquery-ui-1.7.1.custom.css" rel="stylesheet" type="text/css">
<link rel="stylesheet" href="JS/jquery-ui-1.11.4.custom/jquery-ui.css"/>
<link rel="stylesheet" href="JS/QueryBuilder/dist/css/query-builder.default.min.css"/>
<link rel="stylesheet" href="JS/QueryBuilder/bootstrap-3.3.5/css/bootstrap.min.css"/>
<link rel="stylesheet" href="JS/QueryBuilder/bootstrap-3.3.5/css/bootstrap-theme.min.css"/>
<link rel="stylesheet" href="JS/QueryBuilder/dist/css/custom.css"/>
<script language='javascript' src="./JS/VIEWCALENDAR.js"></script>
<script  language="JavaScript" src="./JS/SCREEN.js"></script>
<script type='text/javascript' src="./JS/ICONSMENU.js"></script>
<script language='javascript' src="./JS/HOTKEY.js"></script>
<script language='javascript'>setLang('<%=XLSDASHBOARD.getUProfile().get("lang")%>');</script>
<script type='text/javascript' src='/hr/dwr/engine.js'></script>
<script type='text/javascript' src='/hr/dwr/util.js'></script>
<script type="text/javascript" src="/hr/dwr/interface/GetPasswordFromMuser.js"></script>
<script src="JS/ANGULAR/angular.js"></script>
<script type='text/JavaScript' SRC='JS/ANGULAR/SCREEN_ANGULAR.js'></script>
<script type='text/javascript' src='JS/jquery-1.11.3.min.js'></script>

<link rel="stylesheet" href="codebase/webix/webix.css" type="text/css" charset="windows-874">
<script src="codebase/webix/webix.js" type="text/javascript" charset="windows-874"></script>
<link rel="stylesheet" href="codebase/pivot.css" type="text/css" charset="windows-874">
<script src="codebase/pivotCSC.js" type="text/javascript" charset="windows-874"></script>
<link rel="stylesheet" href="codebase/common/samples.css" type="text/css" charset="windows-874">




<script language="JavaScript" type="text/JavaScript">

function goUpload(page){
    with(document.cscform){
	           open(page,"header","height=600,width=800");
	}
}

function goPreview(filter){
	with(document.cscform){
		__filter.value = filter;
		bCon=confirm(MyCode[10]);
		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 export data?");
		if (bCon==true)	{
					//__cmd.value="save";
					action = "/hr/EXPEXCEL.jsp";
					var temp =  target;
					target = "_blank";
					method="post";
					submit();
					target=temp;
		}
	}
}

function goHelp(helpName,helpReturn){
	linkHelp_Return(helpName,helpReturn);
}
function goFilter(){
	with(document.cscform){
		document.getElementById("__dashcolumn").style.display = 'none';
		document.getElementById("__dashfilter").style.display = '';
		document.getElementById("__dashPivot").style.display = 'none';
		document.getElementById("__dashPivotChart").style.display = 'none';
		var lis = document.getElementById("sortable2").getElementsByTagName("li");
		//alert(lis[0].id);
	}
}
function goColumn(){
	with(document.cscform){
		document.getElementById("__dashcolumn").style.display = '';
		document.getElementById("__dashfilter").style.display = 'none';
		document.getElementById("__dashPivot").style.display = 'none';
		document.getElementById("__dashPivotChart").style.display = 'none';

	}
}
function goPivot(){
	with(document.cscform){
		document.getElementById("__dashcolumn").style.display = 'none';
		document.getElementById("__dashfilter").style.display = 'none';
		document.getElementById("__dashPivot").style.display = '';
		document.getElementById("__dashPivotChart").style.display = 'none';
		document.getElementById("pivotZone").innerHTML = "";
		getDataPivot();
	}
}
function goPivotChart(){
	with(document.cscform){
		document.getElementById("__dashcolumn").style.display = 'none';
		document.getElementById("__dashfilter").style.display = 'none';
		document.getElementById("__dashPivot").style.display = 'none';
		document.getElementById("__dashPivotChart").style.display = '';
		document.getElementById("pivotChartZone").innerHTML = "";
		goDataPivotChart();
	}
}
</script>


</head>
<br>
<body>
<div class="centered">
	<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
	<script language="javascript">initToolTips();</script>
	<form name="cscform" method="post" action="XLSDASHBOARD.jsp">

	<input type="hidden" name="__help" value="">
	<input type="hidden" name="__goPage" value="">
	<input  type="hidden" name="__notNull" value="<%//=XLSDASHBOARD.getRequire()%>">
	<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="<%=XLSDASHBOARD.getUProfile().get("lang")%>">
	<input type="hidden" name="__calendar">
	<input type="hidden" name="__screen" value="XLSDASHBOARD">
	<input type="hidden" name="__dateformat" value="YYYY-MM-DD"/>
	<input name="__fixCon" type="hidden" value="">
	<input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>">
	<input type="hidden" name="__companyid"  value="<%=XLSDASHBOARD.getUProfile().get("companyid")%>">
	<input type="hidden" name="__xlsname" value="<%=xlsname%>">
	<input type="hidden" name="__reporttype" value="<%=reporttype%>">
	<input type="hidden" name="__tname" value="Export Excel">
	<input type="hidden" name="__ename" value="Export Excel">
	<input type="hidden" name="__ptype" value="">
	<input type="hidden" name="__prclass" value="ExcelExportFile">
	<input type="hidden" name="__filter" value="">
	<div class="container">
		<div id="__dashcolumn" align="center" style="display:">
			<jsp:include page="XLSDASHBOARDCOLUMN.jsp" flush="true" />
		</div>
	</div>
	<div class="container">
		<div id="__dashfilter" align="center" style="display:none">
			<jsp:include page="XLSDASHBOARDFILTER.jsp" flush="true" />
		</div>
	</div>
	<div class="container">
		<div id="__dashPivot" align="" style="display:none">
			<jsp:include page="XLSPIVOT.jsp" flush="true" />
		</div>
	</div>
	<div class="container">
		<div id="__dashPivotChart" align="" style="display:none">
			<jsp:include page="XLSPIVOTCHART.jsp" flush="true" />
		</div>
	</div>
</div>
</body>
</html>