/** 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. */ /** * ExecReportsAtUI.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.text.DateFormat; import java.text.SimpleDateFormat; import java.util.Date; import java.util.GregorianCalendar; import java.io.File; import java.net.URL; 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.JTextField; 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 ExecReportsAtUI extends JFrame { private CRNConnect connect; // The following variables represent the dialog components. private JEditorPane htmlAreaPane; private JTextField cmURL; private JTextField selectedSearchPath; private JButton runReportButton; private JComboBox repTypeOption; private JComboBox repSelectOption; private static Logon sessionLogon; private static final String REP_TYPE_HTML = "HTML"; private static final String REP_TYPE_HTMLFRAG = "HTML Fragment"; private static final String REP_TYPE_MHT = "HTML Web Archive"; private static final String REP_TYPE_XML = "XML"; private static final String REP_TYPE_PDF = "PDF"; private static final String REP_TYPE_CSV = "CSV"; private static final String REP_TYPE_XLWA = "Excel Web Archive"; private static final int REP_TYPE_ENUM_HTML = 0; private static final int REP_TYPE_ENUM_XML = 1; private static final int REP_TYPE_ENUM_PDF = 2; private static final int REP_TYPE_ENUM_CSV = 3; private static final int REP_TYPE_ENUM_HTMLFRAG = 4; private static final int REP_TYPE_ENUM_MHT = 5; private static final int REP_TYPE_ENUM_XLWA = 6; private static int reportType = 0; private BaseClassWrapper selectedReport = null; private allButtonsHandler buttonListener = new allButtonsHandler(); private File tmpHTMLFile = null; // This is the constructor. public ExecReportsAtUI(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() { // //Create and add menu components // 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()); //Create panels 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 html scrollPane htmlAreaPane = new JEditorPane(); JScrollPane htmlScrollPane = new JScrollPane(htmlAreaPane); htmlScrollPane.setVerticalScrollBarPolicy( JScrollPane.VERTICAL_SCROLLBAR_ALWAYS); htmlScrollPane.setPreferredSize(new Dimension(500, 275)); //Create the output panel and it's layout objects GridBagLayout layout = new GridBagLayout(); JPanel outputNavPanel = 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(htmlScrollPane, layoutConstraints); outputNavPanel.add(htmlScrollPane); //put a border around the output and nav buttons outputNavPanel.setBorder( BorderFactory.createCompoundBorder( BorderFactory.createCompoundBorder( BorderFactory.createTitledBorder("Output"), BorderFactory.createEmptyBorder(5, 5, 5, 5)), outputNavPanel.getBorder())); return outputNavPanel; } private JPanel createMainPanel() { // Create 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(new JLabel("SearchPath:")); 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 report output type combo box String repType[] = { REP_TYPE_HTML, REP_TYPE_HTMLFRAG, REP_TYPE_MHT, REP_TYPE_XML, REP_TYPE_PDF, REP_TYPE_CSV, REP_TYPE_XLWA }; repTypeOption = new JComboBox(repType); repTypeOption.setSelectedItem(null); repTypeOption.addActionListener(new ReportTypeSelectionHandler()); buttonPanel.add(repTypeOption, BorderLayout.WEST); // 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 runReportButton = new JButton("Execute At ..."); runReportButton.addActionListener(buttonListener); runReportButton.setToolTipText( "Click this button to have the selected report execute 2 minutes from now"); buttonPanel.add(runReportButton, 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 ExecuteAt Sample"); File explainFile = new File("Java_ExecReportsAtUI_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 { private RunReport runReport = new RunReport(); 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 == runReportButton) { //runReport = new RunReport(); try { //Get a Date to use, roughly now Date execDate = new Date(); //Set execTime for 5 minutes after now long execTimeInMillis = execDate.getTime(); execDate.setTime(execTimeInMillis + (2 * 60000)); GregorianCalendar execTime = new GregorianCalendar(); execTime.setTime(execDate); DateFormat dateFormatter = new SimpleDateFormat(); //Run the selected report. output = runReport.runReportAt( connect, selectedReport, reportType, execTime); } catch (Exception ex) { htmlAreaPane.setContentType("text/html"); output = "
" + ex.toString() + ""; htmlAreaPane.setText(output); return; } } if (output.compareTo("") != 0) { htmlAreaPane.setText(output); } } } // This is the reportType combo box event handler. private class ReportTypeSelectionHandler implements ActionListener { public void actionPerformed(ActionEvent repTypeSelectedEvent) { String chosenType = (String)repTypeOption.getSelectedItem(); if (chosenType == REP_TYPE_HTML) { reportType = REP_TYPE_ENUM_HTML; } else if (chosenType == REP_TYPE_XML) { reportType = REP_TYPE_ENUM_XML; } else if (chosenType == REP_TYPE_PDF) { reportType = REP_TYPE_ENUM_PDF; } else if (chosenType == REP_TYPE_CSV) { reportType = REP_TYPE_ENUM_CSV; } else if (chosenType == REP_TYPE_HTMLFRAG) { reportType = REP_TYPE_ENUM_HTMLFRAG; } else if (chosenType == REP_TYPE_MHT) { reportType = REP_TYPE_ENUM_MHT; } else if (chosenType == REP_TYPE_XLWA) { reportType = REP_TYPE_ENUM_XLWA; } else { //error, force HTML (default) ?? reportType = REP_TYPE_ENUM_HTML; } } } 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 == 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) {} } SearchPathMultipleObject reportsPath = new SearchPathMultipleObject("/content//report"); SearchPathMultipleObject queriesPath = new SearchPathMultipleObject("/content//query"); try { reports = connection.getCMService().query( reportsPath, props, sortOptions, new QueryOptions()); queries = connection.getCMService().query( queriesPath, 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); } } } ExecReportsAtUI frame = new ExecReportsAtUI("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.htmlAreaPane.setText( output + System.getProperty("line.separator")); // Set the size of the frame and display it. frame.setSize(800, 440); frame.setVisible(true); frame.setResizable(true); } }