Package com.jpoweredcart.common

Examples of com.jpoweredcart.common.QueryBean

115
116
117
118
119
120
121
122
123
124
 
  @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
109
110
111
112
113
114
115
116
117
118
119
120
121
122
    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
78
79
80
81
82
83
84
85
86
87
88
89
90
 
  @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
99
100
101
102
103
104
105
106
107
108
 
  @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
50
51
52
53
54
55
56
57
58
59
  @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
57
58
59
60
61
62
63
64
65
66
67
68
69
  @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
273
274
275
276
277
278
279
280
281
282
 
  @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
200
201
202
203
204
205
206
207
208
209
210
211
    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
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
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
TOP

Related Classes of com.jpoweredcart.common.QueryBean

  • com.jpoweredcart.admin.model.catalog.impl.AttributeAdminModelImpl
  • com.jpoweredcart.admin.model.catalog.impl.AttributeGroupAdminModelImpl
  • com.jpoweredcart.admin.model.catalog.impl.CategoryAdminModelImpl
  • com.jpoweredcart.admin.model.catalog.impl.DownloadAdminModelImpl
  • com.jpoweredcart.admin.model.catalog.impl.InformationAdminModelImpl
  • com.jpoweredcart.admin.model.catalog.impl.ReviewAdminModelImpl
  • com.jpoweredcart.admin.model.design.impl.BannerAdminModelImpl
  • com.jpoweredcart.admin.model.design.impl.LayoutAdminModelImpl
  • com.jpoweredcart.admin.model.localisation.impl.CountryAdminModelImpl
  • com.jpoweredcart.admin.model.localisation.impl.CurrencyAdminModelImpl
    • 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.