Package com.jpoweredcart.common

Examples of com.jpoweredcart.common.QueryBean


      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"));
View Full Code Here


 
  @Override
  public List<StockStatus> getStockStatuses(PageParam pageParam) {
    String sql = "SELECT * FROM "+quoteTable("stock_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<StockStatus> stockStatusList = getJdbcOperations()
        .query(query.getSql(), query.getParameters(), new StockStatusRowMapper());
   
    return stockStatusList;
  }
View Full Code Here

 
  @Override
  public List<ReturnStatus> getList(PageParam pageParam) {
    String sql = "SELECT * FROM "+quoteTable("return_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<ReturnStatus> returnStatusList = getJdbcOperations()
        .query(query.getSql(), query.getParameters(), new ReturnStatusRowMapper());
   
    return returnStatusList;
  }
View Full Code Here

  public List<VoucherTheme> getList(PageParam pageParam) {
    Integer languageId = getSettingService().getConfig(SettingKey.ADMIN_LANGUAGE_ID, Integer.class);
    String sql = "SELECT * FROM " +quoteTable("voucher_theme")+ " vt LEFT JOIN " +quoteTable("voucher_theme_description")
        + " vtd ON (vt.voucher_theme_id = vtd.voucher_theme_id) WHERE vtd.language_id = ?";
    //sortedKeys={"vtd.name"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    query.addParameters(languageId);
    List<VoucherTheme> customerGroupList = getJdbcOperations()
        .query(query.getSql(), query.getParameters(), new VoucherThemeRowMapper(){
          @Override
          public VoucherTheme mapRow(ResultSet rs, int rowNum)
              throws SQLException {
            VoucherTheme vt = super.mapRow(rs, rowNum);
            vt.setName(rs.getString("name"));
View Full Code Here

 
  @Override
  public List<ReturnReason> getList(PageParam pageParam) {
    String sql = "SELECT * FROM "+quoteTable("return_reason")+" WHERE language_id=?";
    //sortedKeys={"name"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    Integer languageId = getSettingService().getConfig(SettingKey.ADMIN_LANGUAGE_ID, Integer.class);
    query.addParameters(languageId);
    List<ReturnReason> returnReasonList = getJdbcOperations()
        .query(query.getSql(), query.getParameters(), new ReturnReasonRowMapper());
   
    return returnReasonList;
  }
View Full Code Here

 
  @Override
  public List<ReturnAction> getList(PageParam pageParam) {
    String sql = "SELECT * FROM "+quoteTable("return_action")+" WHERE language_id=?";
    //sortedKeys={"name"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    Integer languageId = getSettingService().getConfig(SettingKey.ADMIN_LANGUAGE_ID, Integer.class);
    query.addParameters(languageId);
    List<ReturnAction> returnActionList = getJdbcOperations()
        .query(query.getSql(), query.getParameters(), new ReturnActionRowMapper());
   
    return returnActionList;
  }
View Full Code Here

 
  @Override
  public List<Currency> getList(PageParam pageParam) {
    String sql = "SELECT * FROM "+quoteTable("currency");
    //sortedKeys="title", "code", "value", "date_modified"
    QueryBean query = createPaginationQuery(sql, pageParam);
    List<Currency> currencyList = getJdbcOperations().query(query.getSql(),
        query.getParameters(), new CurrencyRowMapper());
    //TODO: Do we need to update the cache here?
    return currencyList;
  }
View Full Code Here

  public List<CustomerGroup> getList(PageParam pageParam) {
    Integer languageId = getSettingService().getConfig(SettingKey.ADMIN_LANGUAGE_ID, Integer.class);
    String sql = "SELECT * FROM " +quoteTable("customer_group")+ " cg LEFT JOIN " +quoteTable("customer_group_description")
        + " cgd ON (cg.customer_group_id = cgd.customer_group_id) WHERE cgd.language_id = ?";
    //sortedKeys={"cgd.name", "cg.sort_order"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    query.addParameters(languageId);
    List<CustomerGroup> customerGroupList = getJdbcOperations()
        .query(query.getSql(), query.getParameters(), new CustomerGroupRowMapper(){
          @Override
          public CustomerGroup mapRow(ResultSet rs, CustomerGroup object)
              throws SQLException {
            CustomerGroup customerGroup = super.mapRow(rs, object);
            customerGroup.setName(rs.getString("name"));
View Full Code Here

   
    Integer languageId = getSettingService().getConfig(SettingKey.ADMIN_LANGUAGE_ID, Integer.class);
    String sql = "SELECT * FROM " +quoteTable("length_class")+ " wc LEFT JOIN " +quoteTable("length_class_description")+
        " wcd ON (wc.length_class_id = wcd.length_class_id) WHERE wcd.language_id = ?";
    //sortedKeys={"title", "unit", "value"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    query.addParameters(languageId);
    List<LengthClass> lengthClassList = getJdbcOperations().query(query.getSql(),
        query.getParameters(), new LengthClassRowMapper(){
          @Override
          public LengthClass mapRow(ResultSet rs, int rowNum)
              throws SQLException {
            LengthClass lc = super.mapRow(rs, rowNum);
            lc.setTitle(rs.getString("title"));
View Full Code Here

 
  @Override
  public List<Country> getList(PageParam pageParam) {
    //sortedKeys={"name", "iso_code_2", "iso_code_3"}
    String sql = "SELECT * FROM "+quoteTable("country");
    QueryBean query = createPaginationQuery(sql, pageParam);
    List<Country> countries = getJdbcOperations().query(query.getSql(),
        query.getParameters(), new CountryRowMapper());
    return countries;
  }
View Full Code Here

TOP

Related Classes of com.jpoweredcart.common.QueryBean

Copyright © 2018 www.massapicom. All rights reserved.
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.