Skip to main content

DVT stuff

I am currently playing around with some of the gauge, graph and data visualization components in ADF.

At the moment it is all going well provided I drag the ADF BC components on the screen, the custom stuff takes a bit of work.

Here is a silly example to show the number of days until password expiry in a gauge:

JSF COMPONENT

<dvt:gauge id="gauge1" gaugeType="DIAL"

  value="#{viewScope.dashboardBean.gaugeValue}">
  <dvt:gaugeBackground>
    <dvt:specialEffects/>
  </dvt:gaugeBackground>
  <dvt:thresholdSet>
    <dvt:threshold thresholdMaxValue="5" fillColor="#ff0000"/>
    <dvt:threshold thresholdMaxValue="15" fillColor="#FF7F27"/>
    <dvt:threshold fillColor="#00ff00"/>
  </dvt:thresholdSet>
  <dvt:gaugeFrame/>
  <dvt:indicator/>
  <dvt:indicatorBase/>
  <dvt:gaugePlotArea/>
  <dvt:tickLabel/>
  <dvt:tickMark/>
  <dvt:topLabel text="Number of days until password change"/>

  <dvt:bottomLabel/>


  <dvt:metricLabel position="LP_WITH_BOTTOM_LABEL"/>

</dvt:gauge>


BEAN CODE

  public Integer getGaugeValue() {
    OperationBinding resultBinding = 

      ADFUtils.executeOperationBindingWithoutException(
      "calculateDashboard", null);
    if(resultBinding.getErrors() != null && 
      resultBinding.getErrors().size() < 1) {
      return (Integer) resultBinding.getResult();
    }
    return new Integer(0);
  }

AM CODE
public Integer calculateDashboard() {
  String sql = "SELECT trunc(U.PASSWORD_EXPIRY_DATE - SYSDATE) "
    + "as diff   FROM USERS u WHERE u.userid = ?";
  BigDecimal count = (BigDecimal) DbUtils.getSingleResult(
    this.getDBTransaction(), sql, getUserPrincipalName());
  return count.intValue();
}

Labels

Labels:

Comments

Post a Comment

Popular posts from this blog

ADF sort of generic screen for tables with the same structure

We have a couple (about a hundred) of tables with the same structure (Code, Description, Create Date, Update Date). So I wanted to do something simple so that I did not have to create all these screens 1) EO   I created the EO based on one of the tables I had that had the above columns. I then Added a transient attribute called table name to my EO based on a groovy expression. (the expression needs to change as I am reading web tier stuff from the model layer but I will fix this later) I then generated a java class for my EO. And added the following overriden method to my newly created java class. protected StringBuffer buildDMLStatement(int i, AttributeDefImpl[] attributeDefImpl,   AttributeDefImpl[] attributeDefImpl2, AttributeDefImpl[] attributeDefImpl3, boolean b) {   StringBuffer statement = super.buildDMLStatement(   i, attributeDefImpl, attributeDefImpl2, attributeDefImpl3, b); return new StringBuffer(StringUtils.replace(statement.to...
Post a Comment
Read more

Util code

public static MethodExpression getMethodExpression( String expr, Class returnType, Class[] argTypes){ FacesContext fc = FacesContext.getCurrentInstance(); ELContext elctx = fc.getELContext(); ExpressionFactory elFactory = fc.getApplication().getExpressionFactory(); return elFactory.createMethodExpression( elctx, expr, returnType, argTypes); } public static javax.faces.el.MethodBinding getMethodBinding( String expr, Class[] argTypes){ FacesContext fc = FacesContext.getCurrentInstance(); ELContext elctx = fc.getELContext(); return fc.getApplication().createMethodBinding(expr, argTypes); } SetPropertyListener listener = new SetPropertyListener( ActionEvent.class.getName()); listener.setFrom(link.getRoute()); listener.setValueExpression("to", JSFUtils.getValueExpression("#{pageFlowScope.route}", String.class)); action.addActionListener(listener); AdfFacesContext.getCurrentInstance().getPageFlowScope() .put("route", lin...
Post a Comment
Read more

MANIFEST.MF merge JDeveloper for an executable jar

Goto your project > properties. Then click on deployment in the menu. Edit or add a jar deployment profile. Fill in the details under jar options (select Include manifest and give it a main class name) Also remember that the merge functionality only works with a BLANK line at the end of the merge file. REALLY this caught me. My merge file contents: Class-Path: commons-codec-1.3.jar [...empty line here CRLF...]
1 comment
Read more