Double value = rowSet.getDouble( VALUE_ID );
private void getEvents( EventQueryParams params, Grid grid, String sql ) { log.debug( String.format( "Analytics event query SQL: %s", sql ) ); SqlRowSet rowSet = jdbcTemplate.queryForRowSet( sql ); while ( rowSet.next() ) { grid.addRow(); int index = 1; for ( GridHeader header : grid.getHeaders() ) { if ( ITEM_LONGITUDE.equals( header.getName() ) || ITEM_LATITUDE.equals( header.getName() ) ) { double val = rowSet.getDouble( index ); grid.addValue( Precision.round( val, COORD_DEC ) ); } else if ( Double.class.getName().equals( header.getType() ) && !header.hasLegendSet() ) { double val = rowSet.getDouble( index ); grid.addValue( params.isSkipRounding() ? val : MathUtils.getRounded( val ) ); } else { grid.addValue( rowSet.getString( index ) ); } index++; } } }
@Override public Grid getRawDataValues( DataQueryParams params, Grid grid ) { Assert.isTrue( params.hasStartEndDate(), "Start and end dates must be specified" ); List<DimensionalObject> dimensions = new ArrayList<>(); dimensions.addAll( params.getDimensions() ); dimensions.addAll( params.getOrgUnitLevelsAsDimensions() ); if ( params.isIncludePeriodStartEndDates() ) { dimensions.add( new BaseDimensionalObject( PERIOD_START_DATE_ID, DimensionType.STATIC, PERIOD_START_DATE_NAME, Lists.newArrayList() ) ); dimensions.add( new BaseDimensionalObject( PERIOD_END_DATE_ID, DimensionType.STATIC, PERIOD_END_DATE_NAME, Lists.newArrayList() ) ); } String sql = getSelectStatement( params, dimensions ); log.debug( "Get raw data SQL: " + sql ); SqlRowSet rowSet = jdbcTemplate.queryForRowSet( sql ); while ( rowSet.next() ) { grid.addRow(); for ( DimensionalObject dim : dimensions ) { grid.addValue( rowSet.getString( dim.getDimensionName() ) ); } grid.addValue( rowSet.getDouble( "value" ) ); } return grid; }
double value = rowSet.getDouble( "value" ); grid.addValue( params.isSkipRounding() ? value : getRounded( value ) ); double value = rowSet.getDouble( "value" ); ProgramIndicator indicator = params.getProgramIndicator(); grid.addValue( AnalyticsUtils.getRoundedValue( params, indicator.getDecimals(), value ) );