Examples of QueryBean

Examples of com.jpoweredcart.common.QueryBean

106
107
108
109
110
111
112
113
114
115
116
117
118
  @Override
  public List<TaxRate> getList(PageParam pageParam) {
    String sql = "SELECT tr.tax_rate_id, tr.name AS name, tr.rate, tr.type, tr.geo_zone_id, gz.name AS geo_zone, tr.date_added, tr.date_modified FROM "
        +quoteTable("tax_rate")+ " tr LEFT JOIN " +quoteTable("geo_zone")+ " gz ON (tr.geo_zone_id = gz.geo_zone_id)";
    //sortedKeys={"tr.name", "tr.rate", "tr.type", "gz.name", "tr.date_added", "tr.date_modified"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    List<TaxRate> taxRateList = getJdbcOperations()
        .query(query.getSql(), query.getParameters(), new TaxRateRowMapper(){
          @Override
          public TaxRate mapRow(ResultSet rs, int rowNum)
              throws SQLException {
            TaxRate taxRate = super.mapRow(rs, rowNum);
            taxRate.setGeoZone(rs.getString("geo_zone"));
View Full Code Here

Examples of com.jpoweredcart.common.QueryBean

96
97
98
99
100
101
102
103
104
105
106
   
    Integer languageId = getSettingService().getConfig(SettingKey.ADMIN_LANGUAGE_ID, Integer.class);
    String sql = "SELECT * FROM " +quoteTable("weight_class")+ " wc LEFT JOIN " +quoteTable("weight_class_description")+
        " wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = ?";
    //sortedKeys={"title", "unit", "value"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    query.addParameters(languageId);
    List<WeightClass> weightClassList = getJdbcOperations().query(query.getSql(),
        query.getParameters(), new WeightClassRowMapper());
    return weightClassList;
  }
View Full Code Here

Examples of com.jpoweredcart.common.QueryBean

146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
      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

Examples of com.jpoweredcart.common.QueryBean

78
79
80
81
82
83
84
85
86
87
88
89
90
 
  @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

Examples of com.jpoweredcart.common.QueryBean

78
79
80
81
82
83
84
85
86
87
88
89
90
 
  @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

Examples of com.jpoweredcart.common.QueryBean

108
109
110
111
112
113
114
115
116
117
118
119
120
121
  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

Examples of com.jpoweredcart.common.QueryBean

78
79
80
81
82
83
84
85
86
87
88
89
90
 
  @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

Examples of com.jpoweredcart.common.QueryBean

78
79
80
81
82
83
84
85
86
87
88
89
90
 
  @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

Examples of com.jpoweredcart.common.QueryBean

69
70
71
72
73
74
75
76
77
78
79
 
  @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

Examples of com.jpoweredcart.common.QueryBean

113
114
115
116
117
118
119
120
121
122
123
124
125
126
  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
TOP
Copyright © 2018 www.massapi.com. 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.