Package com.jpoweredcart.common

Examples of com.jpoweredcart.common.QueryBean.addParameters()

202
203
204
205
206
207
208
209
210
211
212
   
    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)
View Full Code Here
185
186
187
188
189
190
191
192
193
194
195
    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 {
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
        +quoteTable("review")+" r LEFT JOIN " +quoteTable("product_description")
        +" pd ON (r.product_id = pd.product_id) WHERE pd.language_id = ?";
    //sortedKeys={"pd.name","r.author","r.rating","r.status","r.date_added"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    Integer languageId = getSettingService().getConfig(SettingKey.ADMIN_LANGUAGE_ID, Integer.class);
    query.addParameters(languageId);
    return getJdbcOperations().query(query.getSql(),
        query.getParameters(), new RowMapper<Review>(){
          @Override
          public Review mapRow(ResultSet rs, int rowNum)
              throws SQLException {
View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
    Integer languageId = getSettingService().getConfig(SettingKey.ADMIN_LANGUAGE_ID, Integer.class);
    String sql = "SELECT * FROM "+quoteTable("attribute_group")+" ag LEFT JOIN "+quoteTable("attribute_group_description")
        +" agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE agd.language_id = ?";
    //sortedKeys={"agd.name", "ag.sort_order"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    query.addParameters(languageId);
    return getJdbcOperations().query(query.getSql(),
        query.getParameters(), new AttributeGroupRowMapper(){
          @Override
          public AttributeGroup mapRow(ResultSet rs, int rowNum)
              throws SQLException {
View Full Code Here
151
152
153
154
155
156
157
158
159
160
161
    Integer languageId = getSettingService().getConfig(SettingKey.ADMIN_LANGUAGE_ID, Integer.class);
    String sql = "SELECT * FROM "+quoteTable("download")+" d LEFT JOIN "+quoteTable("download_description")+
        " dd ON (d.download_id = dd.download_id) WHERE dd.language_id =?";
    //sortedKeys={"dd.name", "d.remaining"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    query.addParameters(languageId);
    return getJdbcOperations().query(query.getSql(),
        query.getParameters(), new DownloadRowMapper(){
          @Override
          public Download mapRow(ResultSet rs, int rowNum)
              throws SQLException {
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
    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 {
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
  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
111
112
113
114
115
116
117
118
119
120
121
    String sql = "SELECT *, (SELECT vtd.name FROM "
        +quoteTable("voucher_theme_description")+ " vtd WHERE vtd.voucher_theme_id = v.voucher_theme_id AND vtd.language_id = ?) AS theme, v.amount, v.status, v.date_added FROM " +quoteTable("voucher")+ " v";
    Integer languageId = getSettingService().getConfig(SettingKey.ADMIN_LANGUAGE_ID, Integer.class);
    //sortedKeys={"v.code", "v.from_name", "v.from_email", "v.to_name", "v.to_email","v.theme", "v.amount", "v.status", "v.date_added"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    query.addParameters(languageId);
    List<Voucher> vouchers = getJdbcOperations().query(query.getSql(),
        query.getParameters(), new VoucherRowMapper(){
          @Override
          public Voucher mapRow(ResultSet rs, Voucher object)
              throws SQLException {
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
    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
147
148
149
150
151
152
153
154
155
156
157
      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
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.