Examples of QueryBean

coldfusion.xml.rpc.QueryBean
Extends the Query with a Bean initalizer for WebService deserializer
com.jpoweredcart.common.QueryBean
org.xdams.page.query.bean.QueryBean

Examples of coldfusion.xml.rpc.QueryBean

            for(int i=0;i<columns.length;i++) {
              data[row-1][i]=_toAxisType(tm,null,null,columns[i].get(row,null),targetClass,done);
            }
        }
      
      QueryBean qb = new QueryBean();
      qb.setColumnList(columnList);
      qb.setData(data);
      return qb;
      
    }

View Full Code Here

Examples of coldfusion.xml.rpc.QueryBean

          
          
          //return StructUtil.copyToStruct((Map)value);
        }
        if(isQueryBean(value)) {
          QueryBean qb = (QueryBean) value;
            String[] strColumns = qb.getColumnList();
            Object[][] data = qb.getData();
            int recorcount=data.length;
            Query qry=new QueryImpl(strColumns,recorcount,"QueryBean");
            QueryColumn[] columns=new QueryColumn[strColumns.length];
            for(int i=0;i<columns.length;i++) {
              columns[i]=qry.getColumn(strColumns[i]);

View Full Code Here

Examples of com.jpoweredcart.common.QueryBean

  public List<Category> getList(final String separator, PageParam pageParam) {
    
    Integer languageId = getSettingService().getConfig(SettingKey.ADMIN_LANGUAGE_ID, Integer.class);
    String sql = "SELECT * FROM " +quoteTable("category")+" c LEFT JOIN "+quoteTable("category_description")
      +" cd ON (c.category_id = cd.category_id) WHERE cd.language_id = ? ORDER BY c.sort_order, cd.name ASC";
    QueryBean query = createPaginationQuery(sql, pageParam);
    query.addParameters(languageId);
    
    List<Category> catList = getJdbcOperations().query(query.getSql(), 
        query.getParameters(), new CategoryRowMapper(){
      @Override
      public Category mapRow(ResultSet rs, int rowNum)
          throws SQLException {
        Category cat = super.mapRow(rs, rowNum);
        cat.setName(getPath(cat.getId(), separator));

View Full Code Here

Examples of com.jpoweredcart.common.QueryBean

  @Override
  public List<UserGroup> getList(PageParam pageParam) {
    
    String sql = "SELECT * FROM "+quoteTable("user_group");
    //sortedKeys={"name"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    List<UserGroup> userGroupList = getJdbcOperations().query(query.getSql(), 
        query.getParameters(), new UserGroupRowMapper());
    return userGroupList;
  }

View Full Code Here

Examples of com.jpoweredcart.common.QueryBean

    int languageId = getSettingService().getConfig(SettingKey.ADMIN_LANGUAGE_ID, Integer.class);
    String sql = "SELECT pd.name, p.model, p.viewed FROM "+quoteTable("product")+" p LEFT JOIN " +
      quoteTable("product_description")+ " pd ON (p.product_id = pd.product_id) WHERE pd.language_id = ? AND p.viewed > 0 ORDER BY p.viewed DESC";
    params.add(languageId);
    
    QueryBean query = createPaginationQuery(sql, pageParam);
    params.add(query.getStart());
    params.add(query.getLimit());
    
    int totalProductViews = getTotalProductViews(); 
    
    return getJdbcOperations().query(query.getSql(), 
        params.toArray(), new ProductViewedRptRowMapper(totalProductViews));
  }

View Full Code Here

Examples of com.jpoweredcart.common.QueryBean

      sql += " AND o.date_added <= ?";
      params.add(filter.getDateEnd());
    }
    sql += " GROUP BY op.model ORDER BY total DESC";
    
    QueryBean query = createPaginationQuery(sql, pageParam);
    params.add(query.getStart());
    params.add(query.getLimit());
    
    return getJdbcOperations().query(query.getSql(), 
        params.toArray(), new ProductPurchasedRptRowMapper());
  }

View Full Code Here

Examples of com.jpoweredcart.common.QueryBean

  @Override
  public List<User> getList(PageParam pageParam) {
    
    //sortedKeys={"username", "status", "date_added"}
    String sql = "SELECT * FROM "+quoteTable("user");
    QueryBean query = createPaginationQuery(sql, pageParam);
    List<User> userList = getJdbcOperations().query(query.getSql(), 
        query.getParameters(), new UserRowMapper());
    return userList;
  }

View Full Code Here

Examples of com.jpoweredcart.common.QueryBean

      sql += " AND o.date_added <= ?";
      params.add(filter.getDateEnd());
    }
    sql +=  " GROUP BY o.customer_id ORDER BY total DESC";
    
    QueryBean query = createPaginationQuery(sql, pageParam);
    params.add(query.getStart());
    params.add(query.getLimit());
    
    return getJdbcOperations().query(query.getSql(), 
        params.toArray(), new CustomerOrderRptRowMapper());
  }

View Full Code Here

Examples of com.jpoweredcart.common.QueryBean

      sql += " AND cr.date_added <= ?";
      params.add(filter.getDateEnd());
    }
    sql += " GROUP BY cr.customer_id ORDER BY points DESC";
    
    QueryBean query = createPaginationQuery(sql, pageParam);
    params.add(query.getStart());
    params.add(query.getLimit());
    
    return getJdbcOperations().query(query.getSql(), 
        params.toArray(), new CustomerRewardRptRowMapper());
  }

View Full Code Here

Examples of com.jpoweredcart.common.QueryBean

      sql += " AND ct.date_added <= ?";
      params.add(filter.getDateEnd());
    }
    sql += " GROUP BY ct.customer_id ORDER BY total DESC";
    
    QueryBean query = createPaginationQuery(sql, pageParam);
    params.add(query.getStart());
    params.add(query.getLimit());
    
    return getJdbcOperations().query(query.getSql(), 
        params.toArray(), new CustomerCreditRptRowMapper());
  }

View Full Code Here

0 1 2 3 4

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.