<%-- ================================================================================ eCOMP Portal SDK ================================================================================ Copyright (C) 2017 AT&T Intellectual Property ================================================================================ Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. ================================================================================ --%> <%-- Name: wizard_adhoc_schedule.jsp Use : This JSP is used for accepting user parameters for scheduling the report. Change Log ========== 28-Aug-2009 : Version 8.4 (Sundar); initFormFields function is removed as it is handled in back end. 23-Jun-2009 : Version 8.4 (Sundar);

Bug related to creating startDate variable (in Javascript) for the Validation purpose is fixed.

--%> <%@ page import="org.openecomp.portalsdk.analytics.xmlobj.DataColumnType" %> <%@ page import="org.openecomp.portalsdk.analytics.util.AppConstants" %> <%@ page import="org.openecomp.portalsdk.analytics.model.definition.ReportDefinition" %> <%@ page import="org.openecomp.portalsdk.analytics.system.AppUtils" %> <%@ page import="org.openecomp.portalsdk.analytics.system.Globals" %> <%@ page import="org.openecomp.portalsdk.analytics.controller.WizardSequence" %> <%@ page import="java.util.Vector" %> <%@ page import="java.util.List" %> <%@ page import="org.openecomp.portalsdk.analytics.model.DataCache" %> <%@ page import="java.util.Iterator" %> <%@ page import="org.openecomp.portalsdk.analytics.xmlobj.DataSourceType" %> <%@ page import="org.openecomp.portalsdk.analytics.model.definition.DBColumnInfo" %> <%@ page import="org.openecomp.portalsdk.analytics.model.definition.TableSource" %> <%@ page import="org.openecomp.portalsdk.analytics.model.base.IdNameValue" %> <%@ page import="org.openecomp.portalsdk.analytics.xmlobj.SemaphoreType" %> <%@ page import="org.openecomp.portalsdk.analytics.xmlobj.FormFieldType" %> <%@ page import="org.openecomp.portalsdk.analytics.model.definition.ReportSchedule" %> <%@ page import="org.openecomp.portalsdk.analytics.util.Utils" %> <% ReportSchedule reportSchedule = (ReportSchedule) request.getSession().getAttribute(AppConstants.SI_REPORT_SCHEDULE); ReportDefinition rdefRecurrance = (ReportDefinition) request.getAttribute(AppConstants.SI_REPORT_DEFINITION); session.setAttribute("login_id", AppUtils.getUserBackdoorLoginId(request)); if(reportSchedule==null) reportSchedule = (ReportSchedule) request.getAttribute(AppConstants.SI_REPORT_SCHEDULE); String remoteDbPrefix = (String) session.getAttribute("remoteDB"); boolean isSQLAllowed = Globals.getAllowSQLBasedReports(); %> <%@page import="java.util.Calendar"%> <%@page import="java.text.DateFormat"%> <%@page import="java.text.SimpleDateFormat"%> <%@page import="java.util.TimeZone"%> <%@page import="java.util.Date"%> <%@page import="org.openecomp.portalsdk.analytics.model.ReportLoader"%>

<% Calendar startCalendarDate = Calendar.getInstance(); startCalendarDate.add(Calendar.DAY_OF_MONTH, - 540); Calendar endCalendarDate = Calendar.getInstance(); endCalendarDate.add(Calendar.DAY_OF_MONTH, 540); SimpleDateFormat dtf = new SimpleDateFormat("MM/dd/yyyy"); SimpleDateFormat oracleDateFormat = new SimpleDateFormat("MM/dd/yyyy kk:mm:ss"); Date sysdate = oracleDateFormat.parse(ReportLoader.getSystemDateTime()); SimpleDateFormat dtimestamp = new SimpleDateFormat(Globals.getScheduleDatePattern()); Calendar systemCalendar = Calendar.getInstance(); systemCalendar.setTime(sysdate); Date sysNext15date = oracleDateFormat.parse(ReportLoader.getNext15MinutesOfSystemDateTime()); //dtimestamp = new SimpleDateFormat(Globals.getScheduleDatePattern()); Calendar systemNext15Calendar = Calendar.getInstance(); systemNext15Calendar.setTime(sysNext15date); Date sysNext30date = oracleDateFormat.parse(ReportLoader.getNext30MinutesOfSystemDateTime()); //dtimestamp = new SimpleDateFormat(Globals.getScheduleDatePattern()); Calendar systemNext30Calendar = Calendar.getInstance(); systemNext30Calendar.setTime(sysNext30date); System.out.println(" systemNext15Calendar " + systemNext15Calendar); System.out.println(" systemNext30Calendar " + systemNext30Calendar); //dtimestamp.setTimeZone(TimeZone.getTimeZone(Globals.getTimeZone())); %> <%if(nvl(Globals.getScheduleHelpMessage()).length()>0) { %> <% } %> <% if(AppUtils.isAdminUser(request) || isSQLAllowed ) { %> <% } %> <% List emailToUsers = reportSchedule.getEmailToUsers(); for(int i=0; i <% } // for List emailToRoles = reportSchedule.getEmailToRoles(); for(int i=0; i <% } // for Vector remainingUsers = Utils.getUsersNotInList(emailToUsers,request); Vector remainingRoles = Utils.getRolesNotInList(emailToRoles,request); if((emailToUsers.size()+emailToRoles.size()==0)||(remainingUsers.size()>0)||(remainingRoles.size()>0)) { %> <% } // if %>

<%if(nvl(Globals.getScheduleHelpMessage()).trim().length()>0) { %> <% } %> Please enter Time in <%= Globals.getTimeZone()%>. The Current System Time is <%=dtimestamp.format(sysdate)%> <%=Globals.getTimeZone()%>

Report Desc: <%= Globals.getScheduleHelpMessage() %>

Schedule Emails:

toolTipText="This is used for the enabling or disabling the scheduling feature for this report."/>Yes toolTipText="This is used for the enabling or disabling the scheduling feature for this report."/>No

Email Attachment:

<%if(!rdefRecurrance.getReportType().equals(AppConstants.RT_HIVE)) {%> toolTipText="Provides the capability to attach reports as PDF format to the email."/>PDF Attachment toolTipText="Provides the capability to attach reports as Excel format to the email."/>Excel Attachment <% } %> toolTipText="Provides the capability to attach reports as Excel format to the email."/>Excelx Attachment toolTipText="Provides the capability to attach reports as CSV format to the email."/>CSV Attachment <%if(!rdefRecurrance.getReportType().equals(AppConstants.RT_HIVE)) {%> <% if(nvl(Globals.getShellScriptDir()).length()>1) { %> toolTipText="Provides the capability to send only links to the generated report in the email."/>Link to Generated report <% } %> <% } %>

Recurrence:

First Schedule Date:

<%= Globals.getTimeZone()%>

Last Schedule Date:

<%= Globals.getTimeZone()%>

Use Condition:

> Send Emails Only When Condition Is Met

Condition SQL:

Max rows in attachment:

Form Fields

<%= (i==0)?"Email To: ":" " %>

<%= userValue.getName() %>

<%= (emailToUsers.size()==0&&i==0)?"Email To: ":" " %>

Everyone With Role: <%= roleValue.getName() %>

<% if ( nvl(Globals.getEncryptedSMTPServer(),"").length() > 0 ) { %> <% } %> <% if (Globals.generateSchedReportsInFileSystem()) { %> <% } %>

<%= (emailToUsers.size()+emailToRoles.size()==0)?"Email To: ":" " %>

<% if(remainingUsers.size()>0) { %> <% } else { %> No user emails available <% } %> <% if(remainingRoles.size()>0) { %> <% } else { %> No roles available <% } %>

Encrypt Attachment toolTipText="Choose the encryption mode."/>Yes toolTipText="Choose the encryption mode."/>No

Send as Attachment toolTipText="Send As Attachment"/>Yes toolTipText="Store it in file system."/>No

<%! private String nvl(String s) { return (s==null)?"":s; } private String nvl(String s, String sDefault) { return nvl(s).equals("")?sDefault:s; } %>