예제 #1
0
  private String getUrl(final String url) {
    StringBuffer content = new StringBuffer();
    try {
      // check to see if this URL failed before thia session
      if ((getSession() != null)
          && (getSession().getAttribute("pentaho-HtmlComponent-failed-url-" + url)
              != null)) { //$NON-NLS-1$
        return errorMessage;
      }
      if (BaseUIComponent.debug) {
        debug(Messages.getInstance().getString("Html.DEBUG_GETTING_CONTENT", url)); // $NON-NLS-1$
      }
      if (HttpUtil.getURLContent(url, content)) {
        return content.toString();
      } else {
        getSession()
            .setAttribute(
                "pentaho-HtmlComponent-failed-url-" + url, ""); // $NON-NLS-1$ //$NON-NLS-2$
        return errorMessage;
      }
    } catch (Exception e) {

      if (errorMessage != null) {
        return errorMessage;
      } else {
        error(
            Messages.getInstance()
                .getErrorString("Html.ERROR_0001_COULD_NOT_GET_CONTENT", url)); // $NON-NLS-1$
        return Messages.getInstance()
            .getErrorString("Html.ERROR_0001_COULD_NOT_GET_CONTENT", url); // $NON-NLS-1$
      }
    }
  }
 public boolean init() {
   if (filterPanel == null) {
     // load the XML document that defines the dial
     Document filterDocument = null;
     try {
       org.dom4j.io.SAXReader reader = new org.dom4j.io.SAXReader();
       reader.setEntityResolver(new SolutionURIResolver());
       filterDocument =
           reader.read(
               ActionSequenceResource.getInputStream(definitionPath, LocaleHelper.getLocale()));
     } catch (Throwable t) {
       FilterPanelComponent.logger.error(
           Messages.getInstance().getString("FilterPanelComponent.ERROR_0002_CREATE_XML"),
           t); //$NON-NLS-1$
       return false;
     }
     try {
       filterPanel = getFilterPanel(filterDocument);
     } catch (FilterPanelException e) {
       // TODO sbarkdull localize
       FilterPanelComponent.logger.error(
           Messages.getInstance().getString("FilterPanelComponent.ERROR_0003_CREATE"),
           e); //$NON-NLS-1$
       return false;
     }
   }
   return true;
 }
  private void setDataByRow(final IPentahoResultSet data) {
    // TODO Make this routine MDX friendly
    if (data == null) {
      noDataMessage =
          Messages.getInstance().getString("CHART.USER_NO_DATA_AVAILABLE"); // $NON-NLS-1$
      return; // No data so we've got nothing to set
      // TODO come up with some sort of error strategy here.
    }
    Class timePeriodClass =
        TimeSeriesCollectionChartDefinition.getTimePeriodClass(getDomainPeriodType());
    Object[] rowData = data.next();
    while (rowData != null) {
      String seriesName = (String) rowData[0];
      TimeSeries wrkSeries = new TimeSeries(seriesName, timePeriodClass);
      for (int column = 1; column < rowData.length - 1; column = column + 2) {
        Date keyDate = getValidDate(rowData[column]);
        TimeSeriesDataItem timeSeriesDataItem =
            new TimeSeriesDataItem(
                RegularTimePeriod.createInstance(
                    timePeriodClass, keyDate, RegularTimePeriod.DEFAULT_TIME_ZONE),
                ((Number) rowData[column + 1]).doubleValue());
        wrkSeries.add(timeSeriesDataItem);
      }
      addSeries(wrkSeries);
      rowData = data.next();
    }

    if ((data.getRowCount() > 0) && (this.getSeriesCount() <= 0)) {
      noDataMessage =
          Messages.getInstance().getString("CHART.USER_INCORRECT_DATA_FORMAT"); // $NON-NLS-1$
    }
  }
예제 #4
0
 private String getFile(final String solutionPath) {
   IActionSequenceResource resource =
       new ActionSequenceResource(
           "",
           IActionSequenceResource.SOLUTION_FILE_RESOURCE,
           "text/html",
           solutionPath); //$NON-NLS-1$ //$NON-NLS-2$
   try {
     byte[] bytes =
         IOUtils.toByteArray(
             resource.getInputStream(
                 ISolutionRepository.ACTION_EXECUTE, LocaleHelper.getLocale()));
     return new String(bytes, LocaleHelper.getSystemEncoding());
   } catch (Exception e) {
     if (errorMessage != null) {
       return errorMessage;
     } else {
       error(
           Messages.getInstance()
               .getErrorString(
                   "Html.ERROR_0001_COULD_NOT_GET_CONTENT", solutionPath)); // $NON-NLS-1$
       return Messages.getInstance()
           .getErrorString("Html.ERROR_0001_COULD_NOT_GET_CONTENT", solutionPath); // $NON-NLS-1$
     }
   }
 }
  private Document listModels() {

    // Create a document that describes the result
    Document doc = DocumentHelper.createDocument();

    Element root = doc.addElement("metadata"); // $NON-NLS-1$

    Element modelsNode = root.addElement("models"); // $NON-NLS-1$
    if (domainName == null) {
      try {
        for (String domain : getMetadataRepository().getDomainIds()) {
          addThinDomainModels(domain, modelsNode, root);
        }
      } catch (Throwable t) {
        error(
            Messages.getInstance()
                .getString("PMDUIComponent.ERROR_0001_GET_MODEL_LIST")); // $NON-NLS-1$
        t.printStackTrace();
        root.addElement("message")
            .setText(
                Messages.getInstance()
                    .getString(
                        "PMDUIComponent.USER_NO_DOMAIN_SPECIFIED")); //$NON-NLS-1$ //$NON-NLS-2$
      }

    } else {
      addThinDomainModels(domainName, modelsNode, root);
    }
    return doc;
  }
  private Date getValidDate(Object raw) {

    if (raw instanceof String) {
      try {
        try {
          return formatter1.parse((String) raw);
        } catch (ParseException e) {
          // try w/o hours
        }
        return formatter2.parse((String) raw);
      } catch (ParseException e) {
        getLogger()
            .error(
                Messages.getInstance()
                    .getString(
                        "TimeSeriesCollectionChartDefinition.ERROR_0001_INVALID_DATE", //$NON-NLS-1$
                        (String) raw),
                e);
        return null;
      }
    } else {
      // This was the original code; if we have an unknown object
      // it will throw an exception, but would anyway.
      // It's a small atempt to make MDX queries work here
      return (Date) raw;
    }
  }
  /** @return String that represents the file path to a temporary file */
  protected String[] createTempFile() {
    // create temporary file names
    String solutionDir = "system/tmp/"; // $NON-NLS-1$
    String fileNamePrefix = "tmp_chart_"; // $NON-NLS-1$
    String extension = ".png"; // $NON-NLS-1$
    String fileName = null;
    String filePathWithoutExtension = null;
    try {
      File file =
          PentahoSystem.getApplicationContext()
              .createTempFile(getSession(), fileNamePrefix, extension, true);
      fileName = file.getName();
      filePathWithoutExtension = solutionDir + fileName.substring(0, fileName.indexOf('.'));
    } catch (IOException e) {
      getLogger()
          .error(
              Messages.getInstance()
                  .getErrorString("AbstractChartComponent.ERROR_0001_CANT_CREATE_TEMP_CHART"),
              e); //$NON-NLS-1$
    }
    String[] value = new String[2];
    value[AbstractChartComponent.FILENAME_INDEX] = fileName;
    value[AbstractChartComponent.FILENAME_WITHOUT_EXTENSION_INDEX] = filePathWithoutExtension;

    return value;
  }
 private void setDataByColumn(final IPentahoResultSet data) {
   // TODO Make this routine MDX friendly
   if (data == null) {
     noDataMessage =
         Messages.getInstance().getString("CHART.USER_NO_DATA_AVAILABLE"); // $NON-NLS-1$
     return; // No data so we've got nothing to set
     // TODO come up with some sort of error strategy here.
   }
   boolean firstPass = true;
   String lastSeries = ""; // $NON-NLS-1$
   String seriesName = ""; // $NON-NLS-1$
   Class timePeriodClass =
       TimeSeriesCollectionChartDefinition.getTimePeriodClass(getDomainPeriodType());
   Object[] rowData = data.next();
   TimeSeries wrkSeries = null;
   while (rowData != null) {
     seriesName = (String) rowData[0];
     if (firstPass || !seriesName.equalsIgnoreCase(lastSeries)) {
       if (!firstPass) {
         addSeries(wrkSeries);
       }
       wrkSeries = new TimeSeries(seriesName, timePeriodClass);
       lastSeries = seriesName;
       firstPass = false;
     }
     Date keyDate = getValidDate(rowData[1]);
     RegularTimePeriod regularTimePeriod =
         RegularTimePeriod.createInstance(
             timePeriodClass, keyDate, RegularTimePeriod.DEFAULT_TIME_ZONE);
     TimeSeriesDataItem timeSeriesDataItem =
         new TimeSeriesDataItem(regularTimePeriod, ((Number) rowData[2]).doubleValue());
     if (wrkSeries != null) {
       wrkSeries.add(timeSeriesDataItem);
     }
     rowData = data.next();
   }
   if (!firstPass) {
     addSeries(wrkSeries);
   }
   if ((data.getRowCount() > 0) && (this.getSeriesCount() <= 0)) {
     noDataMessage =
         Messages.getInstance().getString("CHART.USER_INCORRECT_DATA_FORMAT"); // $NON-NLS-1$
   }
 }
 public void setDateMinimum(final Node dateMinimumNode) {
   if (dateMinimumNode != null) {
     try {
       setDateMinimum(DateFormat.getDateInstance().parse(dateMinimumNode.getText()));
     } catch (ParseException e) {
       getLogger()
           .error(
               Messages.getInstance()
                   .getString(
                       "TimeSeriesCollectionChartDefinition.ERROR_0001_INVALID_DATE", //$NON-NLS-1$
                       dateMinimumNode.getText()),
               e);
     }
   }
 }
  protected void applyOuterURLTemplateParam() {
    if (outerParamNames == null) {
      return;
    }
    for (String outerParamName : outerParamNames) {
      Object value = null;
      if ((context != null) && context.getInputNames().contains(outerParamName)) {
        value = context.getInputParameterValue(outerParamName);
      }
      if (value == null) {
        return;
      }
      try {
        if (value.getClass().isArray()) {
          if (Array.getLength(value) > 0) {
            String[] encodedVals = new String[Array.getLength(value)];
            for (int i = 0; i < Array.getLength(value); ++i) // ESCA-JAVA0049:
            {
              encodedVals[i] =
                  URLEncoder.encode(
                      Array.get(value, i).toString(), LocaleHelper.getSystemEncoding());
            }
            // TODO Sleeze Alert!!! This is a temporary hack for making the
            // URLs generated support multiple selections.  A JIRA case PLATFORM-393
            // has been generated to address this issue.
            //
            // For now, applyTemplate looks for an "&" or "?" preceding and following the param,
            // uses all
            // the characters between them as the template and repeats it once for each param value
            // separating them with '&'
            urlTemplate = TemplateUtil.applyTemplate(urlTemplate, outerParamName, encodedVals);
          }
        } else {
          String encodedVal = URLEncoder.encode(value.toString(), LocaleHelper.getSystemEncoding());
          urlTemplate = TemplateUtil.applyTemplate(urlTemplate, outerParamName, encodedVal);
        }

        // encodedVal = URLEncoder.encode(stringVal, LocaleHelper.getSystemEncoding());
        // //$NON-NLS-1$
      } catch (UnsupportedEncodingException e) {
        getLogger()
            .error(
                Messages.getInstance()
                    .getErrorString("AbstractChartComponent.ERROR_0002_URL_ENCODE_FAILED"),
                e); //$NON-NLS-1$
      }
    }
  }
  @Override
  public Document getXmlContent() {

    if (action == PMDUIComponent.ACTION_LIST_MODELS) {
      return listModels();
    } else if (action == PMDUIComponent.ACTION_LOAD_MODEL) {
      return loadModel();
    } else if (action == PMDUIComponent.ACTION_LOOKUP) {
      return getLookup();
    } else {
      throw new RuntimeException(
          Messages.getInstance()
              .getErrorString(
                  "PMDUIComponent.ERROR_0002_ILLEGAL_ACTION",
                  String.valueOf(action))); // $NON-NLS-1$
    }
  }
 public boolean setDataAction(final String widgetGridDataDefinition) {
   try {
     Document dataActionDocument = null;
     try {
       org.dom4j.io.SAXReader reader = new org.dom4j.io.SAXReader();
       reader.setEntityResolver(new SolutionURIResolver());
       dataActionDocument =
           reader.read(
               ActionSequenceResource.getInputStream(
                   widgetGridDataDefinition, LocaleHelper.getLocale()));
     } catch (Throwable t) {
       return false;
     }
     Node dataNode = dataActionDocument.selectSingleNode("widgetgrid/data"); // $NON-NLS-1$
     solution = XmlDom4JHelper.getNodeText("data-solution", dataNode); // $NON-NLS-1$
     actionPath = XmlDom4JHelper.getNodeText("data-path", dataNode); // $NON-NLS-1$
     actionName = XmlDom4JHelper.getNodeText("data-action", dataNode); // $NON-NLS-1$
     actionOutput = XmlDom4JHelper.getNodeText("data-output", dataNode); // $NON-NLS-1$
     valueItem = XmlDom4JHelper.getNodeText("data-value", dataNode); // $NON-NLS-1$
     nameItem = XmlDom4JHelper.getNodeText("data-name", dataNode); // $NON-NLS-1$
     widgetWidth =
         (int)
             XmlDom4JHelper.getNodeText(
                 "widgetgrid/width", dataActionDocument, 125); // $NON-NLS-1$
     widgetHeight =
         (int)
             XmlDom4JHelper.getNodeText(
                 "widgetgrid/height", dataActionDocument, 125); // $NON-NLS-1$
     columns =
         (int)
             XmlDom4JHelper.getNodeText(
                 "widgetgrid/columns", dataActionDocument, 2); // $NON-NLS-1$
     style = XmlDom4JHelper.getNodeText("widgetgrid/style", dataActionDocument); // $NON-NLS-1$
   } catch (Exception e) {
     error(
         Messages.getInstance()
             .getErrorString(
                 "WidgetGrid.ERROR_0003_DEFINITION_NOT_VALID", widgetGridDataDefinition),
         e); //$NON-NLS-1$
     return false;
   }
   return true;
 }
  @Override
  public Document getXmlContent() {
    //      assert null != urlFactory :
    // Messages.getInstance().getString("FilterPanelComponent.ERROR_0000_FACTORY_CANNOT_BE_NULL");
    // //$NON-NLS-1$

    boolean ok = filterPanel.populate(getParameterProviders(), defaultValues);

    if (!ok) {
      String msg =
          Messages.getInstance()
              .getString("FilterPanelComponent.ERROR_0001_POPULATE"); // $NON-NLS-1$
      FilterPanelComponent.log.error(msg);
      throw new UIException(msg);
    }

    String actionUrl = urlFactory.getActionUrlBuilder().getUrl();
    Document xForm = filterPanel.getXForm(actionUrl);

    setXsl("text/html", xslName); // $NON-NLS-1$

    return xForm;
  }
  protected Document createDials(
      final IPentahoResultSet resultSet, final WidgetDefinition widgetDefinition) {

    if (resultSet == null) {
      error(
          Messages.getInstance()
              .getErrorString("WidgetGrid.ERROR_0001_NO_RESULTS_FROM_ACTION")); // $NON-NLS-1$
      return null;
    }

    if (valueItem == null) {
      error(
          Messages.getInstance()
              .getErrorString("WidgetGrid.ERROR_0002_NO_VALUE_ITEM")); // $NON-NLS-1$
    }

    // Create a document that describes the result
    Document result = DocumentHelper.createDocument();
    IPentahoRequestContext requestContext = PentahoRequestContextHolder.getRequestContext();
    setXslProperty(
        "baseUrl", requestContext.getContextPath()); // $NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
    setXslProperty(
        "fullyQualifiedServerUrl",
        PentahoSystem.getApplicationContext()
            .getFullyQualifiedServerURL()); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$

    Element root = result.addElement("widgets"); // $NON-NLS-1$

    IPentahoMetaData metaData = resultSet.getMetaData();
    // TODO support multiple column headers / row headers
    // TODO support an iteration across columns for a given row

    // find the column that we have been told to you
    Object[][] columnHeaders = metaData.getColumnHeaders();
    int nameColumnNo = -1;
    int valueColumnNo = -1;
    for (int idx = 0; idx < columnHeaders[0].length; idx++) {
      if (columnHeaders[0][idx].toString().equalsIgnoreCase(nameItem)) {
        nameColumnNo = idx;
      }
      if (columnHeaders[0][idx].toString().equalsIgnoreCase(valueItem)) {
        valueColumnNo = idx;
      }
    }

    if (nameColumnNo == -1) {
      // we did not find the specified name column
      error(
          Messages.getInstance()
              .getErrorString(
                  "WidgetGrid.ERROR_0004_NAME_COLUMN_MISSING", nameItem)); // $NON-NLS-1$
      return null;
    }

    if (valueColumnNo == -1) {
      // we did not find the specified name column
      error(
          Messages.getInstance()
              .getErrorString(
                  "WidgetGrid.ERROR_0005_VALUE_COLUMN_MISSING", valueItem)); // $NON-NLS-1$
      return null;
    }

    double value;
    String name;
    Object[] row = resultSet.next();
    while (row != null) {
      name = row[nameColumnNo].toString();
      try {
        value = Double.parseDouble(row[valueColumnNo].toString());
        createDial(value, name, root, widgetDefinition);
      } catch (Exception e) {
      }

      row = resultSet.next();
    }
    setXslProperty("urlTarget", "pentaho_popup"); // $NON-NLS-1$ //$NON-NLS-2$
    setXslProperty("columns", Integer.toString(columns)); // $NON-NLS-1$
    if (style != null) {
      setXslProperty("style", style); // $NON-NLS-1$
    }
    return result;
  }
  public Document getLookup() {
    // Create a document that describes the result
    Document doc = DocumentHelper.createDocument();

    Element root = doc.addElement("metadata"); // $NON-NLS-1$

    if (domainName == null) {
      // we can't do this without a model
      root.addElement("message")
          .setText(
              Messages.getInstance()
                  .getString(
                      "PMDUIComponent.USER_NO_DOMAIN_SPECIFIED")); //$NON-NLS-1$ //$NON-NLS-2$
      return doc;
    }

    if (modelId == null) {
      // we can't do this without a view
      root.addElement("message")
          .setText(
              Messages.getInstance()
                  .getString(
                      "PMDUIComponent.USER_NO_MODEL_SPECIFIED")); //$NON-NLS-1$ //$NON-NLS-2$
      return doc;
    }

    if (columnId == null) {
      // we can't do this without a view
      root.addElement("message")
          .setText(
              Messages.getInstance()
                  .getString(
                      "PMDUIComponent.USER_NO_COLUMN_SPECIFIED")); //$NON-NLS-1$ //$NON-NLS-2$
      return doc;
    }

    Domain domain = getMetadataRepository().getDomain(domainName);
    String locale =
        LocaleHelper.getClosestLocale(LocaleHelper.getLocale().toString(), domain.getLocaleCodes());
    LogicalModel model =
        domain.findLogicalModel(modelId); // This is the business view that was selected.
    if (model == null) {
      root.addElement("message")
          .setText(
              Messages.getInstance()
                  .getString(
                      "PMDUIComponent.USER_MODEL_LOADING_ERROR",
                      modelId)); //$NON-NLS-1$ //$NON-NLS-2$
      return doc;
    }

    LogicalColumn column = model.findLogicalColumn(columnId);
    if (column == null) {
      root.addElement("message")
          .setText(
              Messages.getInstance()
                  .getString("PMDUIComponent.USER_COLUMN_NOT_FOUND")); // $NON-NLS-1$ //$NON-NLS-2$
      return doc;
    }

    // Temporary hack to get the BusinessCategory. When fixed properly, you should be able to
    // interrogate the
    // business column thingie for it's containing BusinessCategory.
    Category view = null;
    for (Category category : model.getCategories()) {
      for (LogicalColumn col : category.getLogicalColumns()) {
        if (col.getId().equals(column.getId())) {
          view = category;
          break;
        }
      }
    }

    if (view == null) {
      root.addElement("message")
          .setText(
              Messages.getInstance()
                  .getString("PMDUIComponent.USER_VIEW_NOT_FOUND")); // $NON-NLS-1$ //$NON-NLS-2$
      return doc;
    }

    String mql =
        "<mql><domain_type>relational</domain_type><domain_id>"
            + domainName
            + "</domain_id><model_id>"
            + modelId
            + "</model_id>"; //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
    if (column.getProperty("lookup") == null) { // $NON-NLS-1$
      mql +=
          "<selection><view>"
              + view.getId()
              + "</view><column>"
              + column.getId()
              + "</column></selection>"; //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
      mql +=
          "<orders><order><direction>asc</direction><view_id>"
              + view.getId()
              + "</view_id><column_id>"
              + column.getId()
              + "</column_id></order></orders>"; //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$

    } else {

      String lookup = (String) column.getProperty("lookup"); // $NON-NLS-1$
      // assume model and view are the same...
      StringTokenizer tokenizer1 = new StringTokenizer(lookup, ";"); // $NON-NLS-1$
      while (tokenizer1.hasMoreTokens()) {
        StringTokenizer tokenizer2 =
            new StringTokenizer(tokenizer1.nextToken(), "."); // $NON-NLS-1$
        if (tokenizer2.countTokens() == 2) {
          String lookupViewId = tokenizer2.nextToken();
          String lookupColumnId = tokenizer2.nextToken();
          mql +=
              "<selection><view>"
                  + lookupViewId
                  + "</view><column>"
                  + lookupColumnId
                  + "</column></selection>"; //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
        }
      }
    }
    mql += "</mql>"; // $NON-NLS-1$
    ArrayList messages = new ArrayList();
    SimpleParameterProvider lookupParameters = new SimpleParameterProvider();
    lookupParameters.setParameter("mql", mql); // $NON-NLS-1$

    IRuntimeContext runtime =
        SolutionHelper.doAction(
            "/system/metadata/PickList.xaction",
            "lookup-list",
            lookupParameters,
            getSession(),
            messages,
            this); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$
    IPentahoResultSet results = null;
    if (runtime != null) {
      if (runtime.getStatus() == IRuntimeContext.RUNTIME_STATUS_SUCCESS) {
        if (runtime.getOutputNames().contains("data")) { // $NON-NLS-1$
          results = runtime.getOutputParameter("data").getValueAsResultSet(); // $NON-NLS-1$
          Object[][] columnHeaders = results.getMetaData().getColumnHeaders();
          boolean hasColumnHeaders = columnHeaders != null;

          Element rowElement;
          Element dataElement = root.addElement("data"); // $NON-NLS-1$
          if (hasColumnHeaders) {
            for (int rowNo = 0; rowNo < columnHeaders.length; rowNo++) {
              rowElement = dataElement.addElement("COLUMN-HDR-ROW"); // $NON-NLS-1$
              for (int columnNo = 0; columnNo < columnHeaders[rowNo].length; columnNo++) {
                Object nameAttr =
                    results.getMetaData().getAttribute(rowNo, columnNo, "name"); // $NON-NLS-1$
                if ((nameAttr != null) && (nameAttr instanceof LocalizedString)) {
                  LocalizedString str = (LocalizedString) nameAttr;
                  String name = str.getLocalizedString(locale);
                  if (name != null) {
                    rowElement.addElement("COLUMN-HDR-ITEM").setText(name); // $NON-NLS-1$
                  } else {
                    rowElement
                        .addElement("COLUMN-HDR-ITEM")
                        .setText(columnHeaders[rowNo][columnNo].toString()); // $NON-NLS-1$
                  }
                } else {
                  rowElement
                      .addElement("COLUMN-HDR-ITEM")
                      .setText(columnHeaders[rowNo][columnNo].toString()); // $NON-NLS-1$
                }
              }
            }
          }
          Object[] row = results.next();
          while (row != null) {
            rowElement = dataElement.addElement("DATA-ROW"); // $NON-NLS-1$
            for (Object element : row) {
              if (element == null) {
                rowElement.addElement("DATA-ITEM").setText(""); // $NON-NLS-1$ //$NON-NLS-2$
              } else {
                rowElement.addElement("DATA-ITEM").setText(element.toString()); // $NON-NLS-1$
              }
            }
            row = results.next();
          }
        }
      }
    }

    return doc;
  }
  /**
   * Create a dial image.
   *
   * <ul>
   *   <li>Load the specified XML document describing the dial definition
   *   <li>Create a dial definition object from the XML definition
   *   <li>Use the JFreeChartEngine to create a dial image
   *   <li>Create an XML document describing the dial
   *   <li>Return the XML document
   * </ul>
   *
   * @return The XML document describing this dial
   */
  @Override
  public Document getXmlContent() {

    WidgetDefinition widget = null;
    if (type == DashboardWidgetComponent.TYPE_DIAL) {

      // load the XML document that defines the dial
      IActionSequenceResource resource =
          new ActionSequenceResource(
              title,
              IActionSequenceResource.SOLUTION_FILE_RESOURCE,
              "text/xml", //$NON-NLS-1$
              definitionPath);
      Document dialDefinition = null;
      try {
        org.dom4j.io.SAXReader reader = new org.dom4j.io.SAXReader();
        reader.setEntityResolver(new SolutionURIResolver());
        dialDefinition =
            reader.read(
                resource.getInputStream(RepositoryFilePermission.READ, LocaleHelper.getLocale()));
      } catch (Throwable t) {
        // XML document can't be read. We'll just return a null document.
      }

      if (dialDefinition == null) {
        error(
            Messages.getInstance()
                .getErrorString(
                    "Widget.ERROR_0002_INVALID_RESOURCE", definitionPath)); // $NON-NLS-1$
        return null;
      }
      // create a dial definition from the XML definition
      widget = new DialWidgetDefinition(dialDefinition, 0, width, height, getSession());

      if (widget != null) {
        // set the value to be displayed on the dial
        widget.setValue(new Double(value));
      }
    }
    /*
     * else if( type == TYPE_THERMOMETER ) { // load the XML document that
     * defines the thermometer
     *
     * ActionResource resource = new ActionResource( title,
     * IActionResource.SOLUTION_FILE_RESOURCE, "text/xml", //$NON-NLS-1$
     * PentahoSystem.getApplicationContext().getSolutionPath( definitionPath ) );
     * //$NON-NLS-1$ Document thermometerDefinition = null; try {
     * thermometerDefinition = PentahoSystem.getResourceAsDocument( resource ); }
     * catch (IOException e) {} // create a dial definition from the XML
     * definition widget = createThermometer( thermometerDefinition );
     *
     * if( widget != null ) { // set the value to be displayed on the dial
     * widget.setValue( new Double(value) ); // Set the XSL file to be used
     * to generate the HTML setXsl( "text/html", "DialWidget.xsl" );
     * //$NON-NLS-1$ //$NON-NLS-2$ } else { error(
     * Messages.getInstance().getString("Widget.ERROR_0001_COULD_NOT_CREATE") );
     * //$NON-NLS-1$ return null; } }
     */
    if (widget == null) {
      error(Messages.getInstance().getString("Widget.ERROR_0001_COULD_NOT_CREATE")); // $NON-NLS-1$
      return null;
    }
    // create an image for the dial using the JFreeChart engine
    StringWriter stringWriter = new StringWriter();
    PrintWriter printWriter = new PrintWriter(stringWriter);
    // create temporary file names
    String solutionDir = "system/tmp/"; // $NON-NLS-1$
    String fileNamePrefix = "tmp_pie_"; // $NON-NLS-1$
    String extension = ".png"; // $NON-NLS-1$
    String fileName = null;
    String filePathWithoutExtension = null;
    try {
      File file =
          PentahoSystem.getApplicationContext()
              .createTempFile(getSession(), fileNamePrefix, extension, true);
      fileName = file.getName();
      filePathWithoutExtension = solutionDir + fileName.substring(0, fileName.indexOf('.'));
    } catch (IOException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }
    String dialTitle = ""; // $NON-NLS-1$
    JFreeChartEngine.saveChart(
        widget,
        dialTitle,
        units,
        filePathWithoutExtension,
        width,
        height,
        JFreeChartEngine.OUTPUT_PNG,
        printWriter,
        this);

    // Create a document that describes the result
    Document result = DocumentHelper.createDocument();
    IPentahoRequestContext requestContext = PentahoRequestContextHolder.getRequestContext();
    setXslProperty(
        "baseUrl", requestContext.getContextPath()); // $NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
    setXslProperty(
        "fullyQualifiedServerUrl",
        PentahoSystem.getApplicationContext()
            .getFullyQualifiedServerURL()); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
    Element root = result.addElement("widget"); // $NON-NLS-1$
    root.addElement("title").setText(title); // $NON-NLS-1$
    root.addElement("units").setText(units); // $NON-NLS-1$
    root.addElement("width").setText(Integer.toString(width)); // $NON-NLS-1$
    root.addElement("height").setText(Integer.toString(height)); // $NON-NLS-1$
    Element valueNode = root.addElement("value"); // $NON-NLS-1$
    valueNode.setText(Double.toString(value));
    valueNode.addAttribute(
        "in-image", Boolean.toString(widget.getValueFont() != null)); // $NON-NLS-1$
    root.addElement("image").setText(fileName); // $NON-NLS-1$
    return result;
  }
  @Override
  public Document getXmlContent() {

    // Create a document that describes the result
    Document result = DocumentHelper.createDocument();
    IPentahoRequestContext requestContext = PentahoRequestContextHolder.getRequestContext();
    setXslProperty(
        "baseUrl", requestContext.getContextPath()); // $NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
    setXslProperty(
        "fullyQualifiedServerUrl",
        PentahoSystem.getApplicationContext()
            .getFullyQualifiedServerURL()); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
    String mapName = "chart" + AbstractChartComponent.chartCount++; // $NON-NLS-1$
    Document chartDefinition =
        jcrHelper.getSolutionDocument(definitionPath, RepositoryFilePermission.READ);

    if (chartDefinition == null) {
      Element errorElement = result.addElement("error"); // $NON-NLS-1$
      errorElement
          .addElement("title")
          .setText(
              Messages.getInstance()
                  .getString(
                      "ABSTRACTCHARTEXPRESSION.ERROR_0001_ERROR_GENERATING_CHART")); //$NON-NLS-1$
                                                                                     // //$NON-NLS-2$
      String message =
          Messages.getInstance()
              .getString(
                  "CHARTS.ERROR_0001_CHART_DEFINIION_MISSING", definitionPath); // $NON-NLS-1$
      errorElement.addElement("message").setText(message); // $NON-NLS-1$
      error(message);
      return result;
    }
    // create a pie definition from the XML definition
    dataDefinition = createChart(chartDefinition);

    if (dataDefinition == null) {
      Element errorElement = result.addElement("error"); // $NON-NLS-1$
      errorElement
          .addElement("title")
          .setText(
              Messages.getInstance()
                  .getString(
                      "ABSTRACTCHARTEXPRESSION.ERROR_0001_ERROR_GENERATING_CHART")); //$NON-NLS-1$
                                                                                     // //$NON-NLS-2$
      String message =
          Messages.getInstance()
              .getString(
                  "CHARTS.ERROR_0002_CHART_DATA_MISSING",
                  actionPath); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
      errorElement.addElement("message").setText(message); // $NON-NLS-1$
      // System .out.println( result.asXML() );
      return result;
    }

    // create an image for the dial using the JFreeChart engine
    PrintWriter printWriter = new PrintWriter(new StringWriter());
    // we'll dispay the title in HTML so that the dial image does not have
    // to
    // accommodate it
    String chartTitle = ""; // $NON-NLS-1$
    try {
      if (width == -1) {
        width =
            Integer.parseInt(
                chartDefinition.selectSingleNode("/chart/width").getText()); // $NON-NLS-1$
      }
      if (height == -1) {
        height =
            Integer.parseInt(
                chartDefinition.selectSingleNode("/chart/height").getText()); // $NON-NLS-1$
      }
    } catch (Exception e) {
      // go with the default
    }
    if (chartDefinition.selectSingleNode("/chart/" + AbstractChartComponent.URLTEMPLATE_NODE_NAME)
        != null) { //$NON-NLS-1$
      urlTemplate =
          chartDefinition
              .selectSingleNode("/chart/" + AbstractChartComponent.URLTEMPLATE_NODE_NAME)
              .getText(); //$NON-NLS-1$
    }

    if (chartDefinition.selectSingleNode("/chart/paramName") != null) { // $NON-NLS-1$
      paramName = chartDefinition.selectSingleNode("/chart/paramName").getText(); // $NON-NLS-1$
    }

    Element root = result.addElement("charts"); // $NON-NLS-1$
    TimeSeriesCollection chartDataDefinition = (TimeSeriesCollection) dataDefinition;
    if (chartDataDefinition.getSeriesCount() > 0) {
      // create temporary file names
      String[] tempFileInfo = createTempFile();
      String fileName = tempFileInfo[AbstractChartComponent.FILENAME_INDEX];
      String filePathWithoutExtension =
          tempFileInfo[AbstractChartComponent.FILENAME_WITHOUT_EXTENSION_INDEX];

      ChartRenderingInfo info = new ChartRenderingInfo(new StandardEntityCollection());
      JFreeChartEngine.saveChart(
          chartDataDefinition,
          chartTitle,
          "",
          filePathWithoutExtension,
          width,
          height,
          JFreeChartEngine.OUTPUT_PNG,
          printWriter,
          info,
          this); //$NON-NLS-1$
      applyOuterURLTemplateParam();
      populateInfo(info);
      Element chartElement = root.addElement("chart"); // $NON-NLS-1$
      chartElement.addElement("mapName").setText(mapName); // $NON-NLS-1$
      chartElement.addElement("width").setText(Integer.toString(width)); // $NON-NLS-1$
      chartElement.addElement("height").setText(Integer.toString(height)); // $NON-NLS-1$
      for (int row = 0; row < chartDataDefinition.getSeriesCount(); row++) {
        for (int column = 0; column < chartDataDefinition.getItemCount(row); column++) {
          Number value = chartDataDefinition.getY(row, column);
          Comparable rowKey = chartDataDefinition.getSeriesKey(row);
          RegularTimePeriod columnKey = chartDataDefinition.getSeries(row).getTimePeriod(column);
          Element valueElement = chartElement.addElement("value2D"); // $NON-NLS-1$
          valueElement.addElement("value").setText(value.toString()); // $NON-NLS-1$
          valueElement.addElement("row-key").setText(rowKey.toString()); // $NON-NLS-1$
          valueElement.addElement("column-key").setText(columnKey.toString()); // $NON-NLS-1$
        }
      }
      String mapString = ImageMapUtilities.getImageMap(mapName, info);
      chartElement.addElement("imageMap").setText(mapString); // $NON-NLS-1$
      chartElement.addElement("image").setText(fileName); // $NON-NLS-1$
    }
    return result;
  }
  private void setChartAttributes(final Node chartAttributes) {
    if (chartAttributes == null) {
      return;
    }
    // get the chart type from the chart node -- this overrides the current
    // chart type
    setChartType(chartAttributes.selectSingleNode(ChartDefinition.TYPE_NODE_NAME));

    // set the chart background
    setChartBackground(
        chartAttributes.selectSingleNode(ChartDefinition.CHART_BACKGROUND_NODE_NAME));

    // set the plot background
    setPlotBackground(chartAttributes.selectSingleNode(ChartDefinition.PLOT_BACKGROUND_NODE_NAME));

    // set the orientation
    setOrientation(chartAttributes.selectSingleNode(XYChartDefinition.ORIENTATION_NODE_NAME));

    // do we want a legend
    setLegendIncluded(chartAttributes.selectSingleNode(ChartDefinition.INCLUDE_LEGEND_NODE_NAME));

    // get the chart title
    setTitle(chartAttributes.selectSingleNode(ChartDefinition.TITLE_NODE_NAME));

    // A list of <subtitle> nodes should not be allowed to exist as a child of the main XML element
    // (for XML schema to
    // be well constructed and validate the XML .
    // We have deprecated <subtitle> as a child of the main node , and now require a <subtitles>
    // parent node
    // under which <subtitle> can exist.

    List subtitles = chartAttributes.selectNodes(ChartDefinition.SUBTITLE_NODE_NAME);

    if ((subtitles == null) || (subtitles.isEmpty())) {
      Node subTitlesNode = chartAttributes.selectSingleNode(ChartDefinition.SUBTITLES_NODE_NAME);
      if (subTitlesNode != null) {
        subtitles = subTitlesNode.selectNodes(ChartDefinition.SUBTITLE_NODE_NAME);
      }
    } else {
      // log a deprecation warning for this property...
      getLogger()
          .warn(
              Messages.getInstance()
                  .getString(
                      "CHART.WARN_DEPRECATED_CHILD",
                      ChartDefinition.SUBTITLE_NODE_NAME,
                      ChartDefinition.SUBTITLES_NODE_NAME)); // $NON-NLS-1$
      getLogger()
          .warn(
              Messages.getInstance()
                  .getString(
                      "CHART.WARN_PROPERTY_WILL_NOT_VALIDATE",
                      ChartDefinition.SUBTITLE_NODE_NAME)); // $NON-NLS-1$
    }

    if (subtitles != null) {
      addSubTitles(subtitles);
    }

    // get the paint sequence
    setPaintSequence(chartAttributes.selectSingleNode(ChartDefinition.PALETTE_NODE_NAME));
    Node backgroundAlphaNode =
        chartAttributes.selectSingleNode(ChartDefinition.BACKGROUND_ALPHA_NODE_NAME);
    Node foregroundAlphaNode =
        chartAttributes.selectSingleNode(ChartDefinition.FOREGROUND_ALPHA_NODE_NAME);

    if (backgroundAlphaNode != null) {
      setBackgroundAlpha(
          chartAttributes.selectSingleNode(ChartDefinition.BACKGROUND_ALPHA_NODE_NAME));
    }
    if (foregroundAlphaNode != null) {
      setForegroundAlpha(
          chartAttributes.selectSingleNode(ChartDefinition.FOREGROUND_ALPHA_NODE_NAME));
    }
    // get the stacked value
    setStacked(chartAttributes.selectSingleNode(ChartDefinition.STACKED_NODE_NAME));

    // get the 3D value
    setThreeD(chartAttributes.selectSingleNode(ChartDefinition.THREED_NODE_NAME));

    // set the width
    setWidth(chartAttributes.selectSingleNode(ChartDefinition.WIDTH_NODE_NAME));

    // set the height
    setHeight(chartAttributes.selectSingleNode(ChartDefinition.HEIGHT_NODE_NAME));

    // set the dot width
    setDotWidth(chartAttributes.selectSingleNode(ChartDefinition.DOT_WIDTH_NODE_NAME));

    // set the dot height
    setDotHeight(chartAttributes.selectSingleNode(ChartDefinition.DOT_HEIGHT_NODE_NAME));

    // set vertical tick labels flag
    setDomainVerticalTickLabels(
        chartAttributes.selectSingleNode(XYChartDefinition.DOMAIN_VERTICAL_TICK_LABELS_NODE_NAME));

    // set the border on or off
    setBorderVisible(
        chartAttributes.selectSingleNode(ChartDefinition.CHART_BORDER_VISIBLE_NODE_NAME));

    // set the border Paint
    setBorderPaint(
        JFreeChartEngine.getPaint(
            chartAttributes.selectSingleNode(XYChartDefinition.CHART_BORDER_PAINT_NODE_NAME)));

    // set the title location
    setTitlePosition(chartAttributes.selectSingleNode(ChartDefinition.TITLE_POSITION_NODE_NAME));

    // set the legend location
    setLegendPosition(chartAttributes.selectSingleNode(ChartDefinition.LEGEND_POSITION_NODE_NAME));

    // set the title font
    setTitleFont(chartAttributes.selectSingleNode(ChartDefinition.TITLE_FONT_NODE_NAME));

    // set the domain title
    setDomainTitle(chartAttributes.selectSingleNode(XYChartDefinition.DOMAIN_TITLE_NODE_NAME));

    // set the domain font
    setDomainTitleFont(
        chartAttributes.selectSingleNode(XYChartDefinition.DOMAIN_TITLE_FONT_NODE_NAME));

    // set the range title
    setRangeTitle(chartAttributes.selectSingleNode(XYChartDefinition.RANGE_TITLE_NODE_NAME));

    // the the range font
    setRangeTitleFont(
        chartAttributes.selectSingleNode(XYChartDefinition.RANGE_TITLE_FONT_NODE_NAME));

    // set the range minimum
    setRangeMinimum(chartAttributes.selectSingleNode(XYChartDefinition.RANGE_MINIMUM_NODE_NAME));

    // set the range minimum
    setRangeMaximum(chartAttributes.selectSingleNode(XYChartDefinition.RANGE_MAXIMUM_NODE_NAME));

    // set the date minimum
    setDateMinimum(
        chartAttributes.selectSingleNode(
            TimeSeriesCollectionChartDefinition.DATE_MINIMUM_NODE_NAME));

    // set the date minimum
    setDateMaximum(
        chartAttributes.selectSingleNode(
            TimeSeriesCollectionChartDefinition.DATE_MAXIMUM_NODE_NAME));

    // set the Period type
    setDomainPeriodType(
        chartAttributes.selectSingleNode(XYChartDefinition.DOMAIN_PERIOD_TYPE_NODE_NAME));

    // set the line style
    setLineStyle(chartAttributes.selectSingleNode(ChartDefinition.LINE_STYLE_NODE_NAME));

    // set the line width
    setLineWidth(chartAttributes.selectSingleNode(ChartDefinition.LINE_WIDTH_NODE_NAME));

    // set the marker visibility
    setMarkersVisible(chartAttributes.selectSingleNode(ChartDefinition.MARKER_VISIBLE_NODE_NAME));

    // set legend font
    setLegendFont(chartAttributes.selectSingleNode(ChartDefinition.LEGEND_FONT_NODE_NAME));

    // set legend border visible
    setLegendBorderVisible(
        chartAttributes.selectSingleNode(ChartDefinition.DISPLAY_LEGEND_BORDER_NODE_NAME));

    setTooltipContent(
        chartAttributes.selectSingleNode(XYChartDefinition.TOOLTIP_CONTENT_NODE_NAME));

    setTooltipYFormat(
        chartAttributes.selectSingleNode(XYChartDefinition.TOOLTIP_Y_FORMAT_NODE_NAME));

    setTooltipXFormat(
        chartAttributes.selectSingleNode(XYChartDefinition.TOOLTIP_X_FORMAT_NODE_NAME));
  }
  private Document loadModel() {
    // Create a document that describes the result
    Document doc = DocumentHelper.createDocument();

    Element root = doc.addElement("metadata"); // $NON-NLS-1$

    if (domainName == null) {
      // we can't do this without a model
      root.addElement("message")
          .setText(
              Messages.getInstance()
                  .getString(
                      "PMDUIComponent.USER_NO_DOMAIN_SPECIFIED")); //$NON-NLS-1$ //$NON-NLS-2$
      return doc;
    }

    if (modelId == null) {
      // we can't do this without a model
      root.addElement("message")
          .setText(
              Messages.getInstance()
                  .getString(
                      "PMDUIComponent.USER_NO_MODEL_SPECIFIED")); //$NON-NLS-1$ //$NON-NLS-2$
      return doc;
    }

    Element modelNode = root.addElement("model"); // $NON-NLS-1$

    // because it's lighter weight, check the thin model
    Domain domain = getMetadataRepository().getDomain(domainName);
    if (domain == null) {
      root.addElement("message")
          .setText(
              Messages.getInstance()
                  .getString(
                      "PMDUIComponent.USER_DOMAIN_LOADING_ERROR",
                      domainName)); //$NON-NLS-1$ //$NON-NLS-2$
      return doc;
    }
    String locale =
        LocaleHelper.getClosestLocale(LocaleHelper.getLocale().toString(), domain.getLocaleCodes());
    LogicalModel model = domain.findLogicalModel(modelId);

    if (model == null) {
      root.addElement("message")
          .setText(
              Messages.getInstance()
                  .getString(
                      "PMDUIComponent.USER_MODEL_LOADING_ERROR",
                      modelId)); //$NON-NLS-1$ //$NON-NLS-2$
      error(
          Messages.getInstance()
              .getString("PMDUIComponent.USER_MODEL_LOADING_ERROR", modelId)); // $NON-NLS-1$
      return doc;
    }
    modelNode.addElement("domain_id").setText(domainName); // $NON-NLS-1$
    if (model.getId() != null) {
      modelNode.addElement("model_id").setText(model.getId()); // $NON-NLS-1$
    }
    if (model.getName(locale) != null) {
      modelNode.addElement("model_name").setText(model.getName(locale)); // $NON-NLS-1$
    }
    if (model.getDescription(locale) != null) {
      modelNode
          .addElement("model_description")
          .setText(model.getDescription(locale)); // $NON-NLS-1$
    }

    Element tableNode;

    for (Category category : model.getCategories()) {
      tableNode = modelNode.addElement("view"); // $NON-NLS-1$
      if (category.getId() != null) {
        tableNode.addElement("view_id").setText(category.getId()); // $NON-NLS-1$
      }
      if (category.getName(locale) != null) {
        tableNode.addElement("view_name").setText(category.getName(locale)); // $NON-NLS-1$
      }
      if (category.getDescription(locale) != null) {
        tableNode
            .addElement("view_description")
            .setText(category.getDescription(locale)); // $NON-NLS-1$
      }
      for (LogicalColumn column : category.getLogicalColumns()) {
        Boolean hidden = (Boolean) column.getProperty("hidden"); // $NON-NLS-1$
        if (hidden != null && hidden) {
          continue;
        }
        addColumn(column, tableNode, locale);
      }
    }

    return doc;
  }