sql += "AND a.date_added >= ? ";
params.add(filter.getDateAdded().getTime());
}
//sortedKeys = {"name","a.email","a.code","a.status","a.approved","a.date_added"}
QueryBean query = createPaginationQuery(sql, pageParam);
query.addParameters(params.toArray());
System.out.println(query.getSql());
System.out.println(query.getParameterList());
return getJdbcOperations().query(query.getSql(),
query.getParameters(), new AffiliateRowMapper(){
@Override
public Affiliate mapRow(ResultSet rs, int rowNum)
throws SQLException {
Affiliate aff = super.mapRow(rs, rowNum);
aff.setBalance(rs.getBigDecimal("balance"));