Examples of OrderStatusRowMapper

Examples of com.jpoweredcart.common.entity.localisation.jdbc.OrderStatusRowMapper

71
72
73
74
75
76
77
  @Override
  public OrderStatus get(Integer orderStatusId) {
    String sql = "SELECT * FROM " +quoteTable("order_status")+ " WHERE order_status_id = ? and language_id = ?";
    Integer languageId = getSettingService().getConfig(SettingKey.ADMIN_LANGUAGE_ID, Integer.class);
    return getJdbcOperations().queryForObject(sql, new Object[]{orderStatusId, languageId},
        new OrderStatusRowMapper());
  }
View Full Code Here

Examples of com.jpoweredcart.common.entity.localisation.jdbc.OrderStatusRowMapper

82
83
84
85
86
87
88
89
90
    //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

Examples of com.jpoweredcart.common.entity.localisation.jdbc.OrderStatusRowMapper

92
93
94
95
96
97
98
99
100
  @Override
  public OrderStatuses getOrderStatuses(Integer orderStatusId) {
    String sql = "SELECT s.order_status_id, s.name, s.language_id, l.name AS language_name, l.image AS language_image FROM " +
        quoteTable("order_status")+" s INNER JOIN "+quoteTable("language")+" l ON s.language_id=l.language_id WHERE order_status_id=?";
    List<OrderStatus> list = getJdbcOperations().query(sql, new Object[]{orderStatusId},
        new OrderStatusRowMapper());
    OrderStatuses orderStatuses = new OrderStatuses(list);
    return orderStatuses;
  }
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.