/** Licensed Materials - Property of IBM IBM Cognos Products: DOCS (C) Copyright IBM Corp. 2005, 2008 US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. */ /** * NewSchedulerUI.java * * Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved. * Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated). * */ import java.awt.BorderLayout; import java.awt.Dimension; import java.awt.GridBagConstraints; import java.awt.GridBagLayout; import java.awt.GridLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.WindowAdapter; import java.awt.event.WindowEvent; import java.io.File; import java.net.URL; import java.util.Date; import java.util.GregorianCalendar; import javax.swing.BorderFactory; import javax.swing.ImageIcon; import javax.swing.JButton; import javax.swing.JComboBox; import javax.swing.JEditorPane; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JMenu; import javax.swing.JMenuBar; import javax.swing.JMenuItem; import javax.swing.JOptionPane; import javax.swing.JPanel; import javax.swing.JScrollPane; import javax.swing.JTextArea; import javax.swing.JTextField; import com.cognos.developer.schemas.bibus._3.AddressSMTP; import com.cognos.developer.schemas.bibus._3.BaseClass; import com.cognos.developer.schemas.bibus._3.OrderEnum; import com.cognos.developer.schemas.bibus._3.PropEnum; import com.cognos.developer.schemas.bibus._3.QueryOptions; import com.cognos.developer.schemas.bibus._3.SearchPathMultipleObject; import com.cognos.developer.schemas.bibus._3.Sort; // This Java class extends the JFrame class so that you can // display a window. public class NewSchedulerUI extends JFrame { private CRNConnect connect; // The following variables represent the dialog components. private JTextArea textAreaPane; private JTextField cmURL; private JTextField selectedSearchPath; private JButton scheduleReportButton; private JComboBox repSelectOption; private static Logon sessionLogon; private static BaseClassWrapper selectedReport = null; // This is the constructor. public NewSchedulerUI(String title, CRNConnect connection) { // Set the title of the frame, even before the variables are declared. super(title); connect = connection; addComponents(); } // Add all components to the frame's panel. private void addComponents() { JMenuBar mBar = new JMenuBar(); this.setJMenuBar(mBar); //declare menuItems JMenuItem exit; JMenuItem about; JMenuItem overview; //Add and populate the File menu. JMenu fileMenu = new JMenu("File"); mBar.add(fileMenu); exit = new JMenuItem("Exit"); fileMenu.add(exit); exit.addActionListener(new MenuHandler()); //Add and populate the Help menu. JMenu helpMenu = new JMenu("Help"); mBar.add(helpMenu); about = new JMenuItem("About"); helpMenu.add(about); about.addActionListener(new MenuHandler()); overview = new JMenuItem("Overview"); helpMenu.add(overview); overview.addActionListener(new MenuHandler()); JPanel mainPanel = createMainPanel(); JPanel outputNavPanel = createOutputPanel(); JPanel panel = new JPanel(new BorderLayout()); panel.add(mainPanel, BorderLayout.NORTH); panel.add(outputNavPanel); setContentPane(panel); } private JPanel createOutputPanel() { //Create the text scrollPane textAreaPane = new JTextArea(); JScrollPane textScrollPane = new JScrollPane(textAreaPane); textScrollPane.setVerticalScrollBarPolicy( JScrollPane.VERTICAL_SCROLLBAR_ALWAYS); textScrollPane.setPreferredSize(new Dimension(500, 275)); //Create the output panel and its layout objects GridBagLayout layout = new GridBagLayout(); JPanel outputPanel = new JPanel(layout); GridBagConstraints layoutConstraints = new GridBagConstraints(); //Set the layout for the scroll pane and add it layoutConstraints.weightx = 1.0; layoutConstraints.weighty = 1.0; layoutConstraints.fill = GridBagConstraints.BOTH; layout.setConstraints(textScrollPane, layoutConstraints); outputPanel.add(textScrollPane); //put a border around the output and nav buttons outputPanel.setBorder( BorderFactory.createCompoundBorder( BorderFactory.createCompoundBorder( BorderFactory.createTitledBorder("Output"), BorderFactory.createEmptyBorder(5, 5, 5, 5)), outputPanel.getBorder())); return outputPanel; } private JPanel createMainPanel() { // Add the URL text field and label cmURL = new JTextField(CRNConnect.CM_URL.length() - 10); cmURL.setText(CRNConnect.CM_URL); cmURL.setEditable(false); //Put together a panel for the URL JPanel cmURLPanel = new JPanel(); cmURLPanel.add(new JLabel("Server URL:")); cmURLPanel.add(cmURL); // Create the searchPath text field and label selectedSearchPath = new JTextField(CRNConnect.CM_URL.length() - 10); //same as above selectedSearchPath.setText(""); selectedSearchPath.setEditable(false); selectedSearchPath.setAutoscrolls(true); //Put together a panel for the search path JPanel searchPathPanel = new JPanel(); searchPathPanel.add(selectedSearchPath); //get the button panel JPanel buttonPanel = createMainButtonPanel(); // // create the main panel and add the components // JPanel mainPanel = new JPanel(new GridLayout(3,0)); // Add everything to the main panel mainPanel.add(cmURLPanel); mainPanel.add(buttonPanel); mainPanel.add(searchPathPanel); return mainPanel; } private JPanel createMainButtonPanel() { // Create the button Panel JPanel buttonPanel = new JPanel(); // Create and add the select report combo box BaseClassWrapper listOfReports[] = getListOfReports(connect); repSelectOption = new JComboBox(listOfReports); repSelectOption.setSelectedItem(null); repSelectOption.addActionListener(new ReportSelectionHandler()); buttonPanel.add(repSelectOption, BorderLayout.CENTER); // Create and add the Button scheduleReportButton = new JButton("Schedule Report"); scheduleReportButton.addActionListener(new allButtonsHandler()); buttonPanel.add(scheduleReportButton, BorderLayout.EAST); return buttonPanel; } private class MenuHandler implements ActionListener { public void actionPerformed(ActionEvent e) { if (e.getActionCommand().startsWith("http://")) { connect.connectionChange(e.getActionCommand()); } try { JMenuItem menuClicked = (JMenuItem)e.getSource(); if (menuClicked.getText() == "Exit") { System.exit(0); } if (menuClicked.getText() == "About") { JOptionPane.showMessageDialog( ((JMenuItem)e.getSource()).getParent(), "IBM Cognos Sample Application\n\n" + "Version 1.0.0\n" + "This application uses the IBM Cognos Software Development Kit", "About IBM Cognos Samples", JOptionPane.INFORMATION_MESSAGE, new ImageIcon("../Common/about.gif")); } if (menuClicked.getText().compareTo("Overview") == 0) { JFrame explainWindow = new JFrame("Overview for NewScheduler"); File explainFile = new File("Java_NewScheduler_Explain.html"); if (! explainFile.exists()) { JOptionPane.showMessageDialog(null, "Explain file not found"); return; } URL explainURL = new URL("file:///" + explainFile.getAbsolutePath()); JEditorPane explainPane = new JEditorPane(); explainPane.setPage(explainURL); explainPane.setEditable(false); JScrollPane explainScroll = new JScrollPane( explainPane, JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED, JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED); explainWindow.getContentPane().add(explainScroll); explainWindow.setSize(640, 480); explainWindow.setVisible(true); } } catch (Exception ex) {} } } // The following is the button event handler. // Note: A SWITCH statement cannot be used here because we are comparing // objects. private class allButtonsHandler implements ActionListener { public void actionPerformed(ActionEvent e) { if (!Logon.loggedIn(connect)) { try { sessionLogon.logon(connect); } catch (Exception logonException) {} } JButton buttonPressed = ((JButton)e.getSource()); String output = new String(); if (buttonPressed == scheduleReportButton) { NewScheduler scheduleReport = new NewScheduler(); try { //Get a Date to use, relative to now Date scheduleStartDate = new Date(); Date scheduleEndDate = new Date(); //Set start for a minute from now long scheduleTimeInMillis = scheduleStartDate.getTime(); scheduleStartDate.setTime(scheduleTimeInMillis + 60000); GregorianCalendar startTime = new GregorianCalendar(); startTime.setTime(scheduleStartDate); //Set end for a minute after the startTime scheduleTimeInMillis = scheduleStartDate.getTime(); scheduleEndDate.setTime(scheduleTimeInMillis + 360000); GregorianCalendar endTime = new GregorianCalendar(); endTime.setTime(scheduleEndDate); textAreaPane.append( "Scheduling report: " + repSelectOption.getSelectedItem() + System.getProperty("line.separator")); //Run the selected report. output = scheduleReport.setSchedule( connect, (BaseClassWrapper)repSelectOption.getSelectedItem(), "HTML", "", "", "saveas", "", repSelectOption.getSelectedItem() + " View", new AddressSMTP[] {}, 6, "", "january", "", "", "minute", "3", "ByDay", startTime, endTime, "onDate"); } catch (java.rmi.RemoteException remoteEx) { System.out.println(remoteEx.getMessage()); remoteEx.printStackTrace(); output = "Run Report:\nAn error occurred\nMake sure a " + "Report Name is selected and IBM Cognos is running"; } } if (output.compareTo("") != 0) { textAreaPane.setText(""); textAreaPane.append(output); } } } private class ReportSelectionHandler implements ActionListener { public void actionPerformed(ActionEvent repSelectedEvent) { selectedReport = (BaseClassWrapper) repSelectOption.getSelectedItem(); selectedSearchPath.setText(selectedReport.getBaseClassObject().getSearchPath().getValue()); } } //This is a method for retrieving a list of the available reports to run protected BaseClassWrapper[] getListOfReports(CRNConnect connection) { BaseClassWrapper reportAndQueryList[] = null; BaseClass reports[] = new BaseClass[0]; BaseClass queries[] = new BaseClass[0]; int reportAndQueryIndex = 0; int reportIndex = 0; int queryIndex = 0; if (connection.getCMService() == null) { System.out.println( "Invalid parameter passed to getListOfReports()\n"); return null; } PropEnum props[] = new PropEnum[] { PropEnum.searchPath, PropEnum.defaultName }; Sort sortOptions[] = { new Sort()}; sortOptions[0].setOrder(OrderEnum.ascending); sortOptions[0].setPropName(PropEnum.defaultName); if (!Logon.loggedIn(connect)) { try { sessionLogon.logon(connect); } catch (Exception logonException) {} } try { reports = connection.getCMService().query( new SearchPathMultipleObject("/content//report"), props, sortOptions, new QueryOptions()); queries = connection.getCMService().query( new SearchPathMultipleObject("/content//query"), props, sortOptions, new QueryOptions()); } catch (java.rmi.RemoteException remoteEx) { System.out.println("Caught Remote Exception:\n"); remoteEx.printStackTrace(); } reportAndQueryList = new BaseClassWrapper[reports.length + queries.length]; if ((reports != null) && (reports.length > 0)) { for (reportIndex = 0; reportIndex < reports.length; reportIndex++) { reportAndQueryList[reportAndQueryIndex++] = new BaseClassWrapper(reports[reportIndex]); } } if ((queries != null) && (queries.length > 0)) { for (queryIndex = 0; queryIndex < queries.length; queryIndex++) { reportAndQueryList[reportAndQueryIndex++] = new BaseClassWrapper(queries[queryIndex]); } } return reportAndQueryList; } // Create the main method to execute the application. public static void main(String args[]) { CRNConnect connection = new CRNConnect(); connection.connectToCognosServer(); sessionLogon = new Logon(); String output = ""; while (!Logon.loggedIn(connection)) { output = sessionLogon.logon(connection); if (!Logon.loggedIn(connection)) { int retry = JOptionPane.showConfirmDialog( null, "Login Failed. Please try again.", "Login Failed", JOptionPane.OK_CANCEL_OPTION); if (retry != JOptionPane.OK_OPTION) { System.exit(0); } } } NewSchedulerUI frame = new NewSchedulerUI("IBM Cognos Sample", connection); // Create a WindowAdapter so the application // is exited when the window is closed. frame.addWindowListener(new WindowAdapter() { public void windowClosing(WindowEvent e) { System.exit(0); } }); frame.textAreaPane.setText(output); // Set the size of the frame and display it. frame.setSize(680, 440); frame.setVisible(true); frame.setResizable(true); } }