<%-- ================================================================================ 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. ================================================================================ --%> <%@ 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" %> <% ReportDefinition rdef = (ReportDefinition) request.getAttribute(AppConstants.SI_REPORT_DEFINITION); WizardSequence ws = rdef.getWizardSequence(); ReportSchedule reportSchedule = rdef.getReportSchedule(); 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()); //dtimestamp.setTimeZone(TimeZone.getTimeZone(Globals.getTimeZone())); %> <% if(request.getAttribute("schedule_only")!=null) { %> <% } %> <% 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 %>
Step <%= ws.getCurrentStepIndex() %> of <%= ws.getStepCount() %> - Report <%= ws.getCurrentStep() %>
Please enter Time in <%= Globals.getTimeZone()%>. The Current System Time is <%=dtimestamp.format(sysdate)%> <%=Globals.getTimeZone()%>

Quick Help:

Schedule Emails: />Yes   />No
Email Attachment: />PDF Attachment    />Excel Attachment
Recurrence:
Start Date:      
End Date:
Use Condition: > Send Emails Only When Condition Is Met
Condition SQL: SELECT 1 FROM DUAL WHERE EXISTS (
)       
Max rows in attachment:
<%= (i==0)?"Email To: ":" " %> <%= userValue.getName() %>      
<%= (emailToUsers.size()==0&&i==0)?"Email To: ":" " %> Everyone With Role:  <%= roleValue.getName() %>      
<%= (emailToUsers.size()+emailToRoles.size()==0)?"Email To: ":" " %> <% if(remainingUsers.size()>0) { %> <% } else { %> No user emails available <% } %>       <% if(remainingRoles.size()>0) { %> <% } else { %> No roles available <% } %>

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