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 com.jpoweredcart.common.QueryBean

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

View Full Code Here

Examples of com.jpoweredcart.common.QueryBean

      sql += "AND c.date_added <= ?";
      params.add(filter.getDateEnd());
    }
    sql += " GROUP BY ch.coupon_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 SaleCouponRptRowMapper());
  }

View Full Code Here

Examples of com.jpoweredcart.common.QueryBean

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

View Full Code Here

Examples of com.jpoweredcart.common.QueryBean

    Integer languageId = getSettingService().getConfig(SettingKey.ADMIN_LANGUAGE_ID, Integer.class);
    String sql = "SELECT *, (SELECT agd.name FROM "+quoteTable("attribute_group_description")
        +" agd WHERE agd.attribute_group_id = a.attribute_group_id AND agd.language_id = ?) AS attribute_group FROM "
        +quoteTable("attribute")+ " a LEFT JOIN " +quoteTable("attribute_description")+ " ad ON (a.attribute_id = ad.attribute_id) WHERE ad.language_id =?";
    //sortedKeys={"ad.name", "attribute_group", "a.sort_order"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    query.addParameters(languageId, languageId);
    return getJdbcOperations().query(query.getSql(), 
        query.getParameters(), new AttributeRowMapper(){
          @Override
          public Attribute mapRow(ResultSet rs, int rowNum)
              throws SQLException {
            Attribute attr = super.mapRow(rs, rowNum);
            attr.setName(rs.getString("name"));

View Full Code Here

Examples of com.jpoweredcart.common.QueryBean

  
  @Override
  public List<OrderStatus> getList(PageParam pageParam) {
    String sql = "SELECT * FROM "+quoteTable("order_status")+" WHERE language_id=?";
    //sortedKeys={"name"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    Integer languageId = getSettingService().getConfig(SettingKey.ADMIN_LANGUAGE_ID, Integer.class);
    query.addParameters(languageId);
    List<OrderStatus> orderStatusList = getJdbcOperations()
        .query(query.getSql(), query.getParameters(), new OrderStatusRowMapper());
    
    return orderStatusList;
  }

View Full Code Here

Examples of com.jpoweredcart.common.QueryBean

  
  @Override
  public List<TaxClass> getList(PageParam pageParam) {
    String sql = "SELECT * FROM "+quoteTable("tax_class");
    //sortedKeys={"tax_class_id"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    List<TaxClass> taxClassList = getJdbcOperations()
        .query(query.getSql(), query.getParameters(), new TaxClassRowMapper());
    return taxClassList;
  }

View Full Code Here

Examples of com.jpoweredcart.common.QueryBean

  @Override
  public List<Zone> getList(PageParam pageParam) {
    String sql = "SELECT z.zone_id, z.country_id, z.code, z.name, z.status, c.name AS country_name FROM " +
        quoteTable("zone") + " z LEFT JOIN "+quoteTable("country") + " c ON (z.country_id = c.country_id)";
    //sortedKeys={"c.name", "z.name", "z.code"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    List<Zone> zoneList = getJdbcOperations().query(query.getSql(), 
        query.getParameters(), new ZoneRowMapper());
    return zoneList;
  }

View Full Code Here

Examples of com.jpoweredcart.common.QueryBean

  @Override
  public List<IpBlacklist> getList(PageParam pageParam) {
    String sql = "SELECT *, (SELECT COUNT(DISTINCT customer_id) FROM " +quoteTable("customer_ip")
        + " ci WHERE ci.ip = cib.ip) AS total FROM " +quoteTable("customer_ip_blacklist")+" cib";
    //sortedKeys={"ip"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    List<IpBlacklist> blacklists = getJdbcOperations().query(query.getSql(), 
        query.getParameters(), new IpBlacklistRowMapper(){
          @Override
          public IpBlacklist mapRow(ResultSet rs, int rowNum)
              throws SQLException {
            IpBlacklist blacklist = super.mapRow(rs, rowNum);
            blacklist.setTotalCustomers(rs.getInt("total"));

View Full Code Here

Examples of com.jpoweredcart.common.QueryBean

  
  @Override
  public List<Language> getList(PageParam pageParam) {
    String sql = "SELECT * FROM "+quoteTable("language");
    //sortedKeys={"name", "code", "sort_order"};
    QueryBean query = createPaginationQuery(sql, pageParam);
    List<Language> languageList = getJdbcOperations()
        .query(query.getSql(), query.getParameters(), new LanguageRowMapper());
    return languageList;
  }

View Full Code Here

Examples of com.jpoweredcart.common.QueryBean

    String sql = "SELECT vh.order_id, o.firstname, o.lastname, vh.amount, vh.date_added FROM "+
      quoteTable("voucher_history")+" vh LEFT JOIN "+quoteTable("order")+
      " o ON (vh.order_id = o.order_id) WHERE vh.voucher_id =?";
    PageParam pageParam = PageParam.list(start, limit);
    pageParam.addOrder("vh.date_added", "ASC");
    QueryBean query = createPaginationQuery(sql, pageParam);
    return getJdbcOperations().query(query.getSql(), query.getParameters(), 
      new VoucherHistoryRowMapper(){
      @Override
      public VoucherHistory mapRow(ResultSet rs, int rowNum)
          throws SQLException {
        VoucherHistory vh = super.mapRow(rs, rowNum);

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.