<%@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>