Package com.jpoweredcart.common

Examples of com.jpoweredcart.common.QueryBean

201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
  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
75
76
77
78
79
80
81
82
83
84
  @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
26
27
28
29
30
31
32
33
34
35
36
37
38
39
    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
82
83
84
85
86
87
88
89
90
91
92
93
      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
97
98
99
100
101
102
103
104
105
106
  @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
50
51
52
53
54
55
56
57
58
59
60
61
      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
104
105
106
107
108
109
110
111
112
113
114
115
      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
148
149
150
151
152
153
154
155
156
157
158
159
      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
184
185
186
187
188
189
190
191
192
193
194
195
196
197
  public List<Information> getList(PageParam pageParam) {
    Integer languageId = getSettingService().getConfig(SettingKey.ADMIN_LANGUAGE_ID, Integer.class);
    String sql = "SELECT * FROM " +quoteTable("information")+ " i LEFT JOIN " +quoteTable("information_description")
        + " id ON (i.information_id = id.information_id) WHERE id.language_id = ?";
    //sortedKeys={"id.title", "i.sort_order"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    query.addParameters(languageId);
    List<Information> infoList = getJdbcOperations().query(query.getSql(),
        query.getParameters(), new InformationRowMapper(){
      @Override
      public Information mapRow(ResultSet rs, int rowNum)
          throws SQLException {
        Information info = super.mapRow(rs, rowNum);
        info.setTitle(rs.getString("title"));
View Full Code Here
189
190
191
192
193
194
195
196
197
198
199
200
      sql += " AND co.customer_id > 0 AND CONCAT(c.firstname, ' ', c.lastname) LIKE ?";
      params.add("%"+filter.getCustomerName()+"%");
    }
    sql += " ORDER BY co.date_added DESC";
   
    QueryBean query = createPaginationQuery(sql, pageParam);
    params.add(query.getStart());
    params.add(query.getLimit());
   
    return getJdbcOperations().query(query.getSql(),
        params.toArray(), new CustomerOnlineRptRowMapper());
  }
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.