Tuesday, September 13, 2011

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

No comments:

Post a Comment