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();
}