em lấy danh sách theo mức giá… nhưng khi chạy dữ liệu trả về sai.
{
"sessionId": "",
"wsCode": "",
"token": "",
"wsRequest": {
"id":1,
"idArea":[61,62],
"minPrice":200000000000,
"maxPrice":99999999999,
"limit":10,
"page":1
}
}
@Override
public List<ProjectModel> findProjectAdvance(int id, List<Integer> idArea, double minPrice, double maxPrice, int limit, int page) {
List<Object[]> result = entityManager.createQuery(
"select DISTINCT p.idProject, p.name, t.name, p.idArea" +
"from Project p, ProductType t, SegmentPrice s, Sector st, Building b, Apartment a " +
"where " +
"p.idArea in (idArea) and " +
"p.idProductType=:id and " +
"p.idProductType=t.id and " +
"p.idProject=st.idProject and " +
"st.idSector=b.idSector and " +
"b.idBuilding=a.idBuilding and " +
"a.sellPrice between 'minPrice' and 'maxPrice'"
)
.setParameter("idArea", idArea)
.setParameter("id", id)
.setParameter("minPrice", minPrice)
.setParameter("maxPrice", maxPrice)
.setMaxResults(limit)
.setFirstResult((page - 1) * limit)
.getResultList();
List<ProjectModel> list = new ArrayList<>();
for (Object[] obj : result)
{
ProjectModel projectModel = new ProjectModel();
projectModel.setIdProject(Integer.parseInt(obj[0].toString()));
projectModel.setName(String.valueOf(obj[1]));
projectModel.setNameType(String.valueOf(obj[2]));
projectModel.setIdArea(Integer.parseInt(obj[3].toString()));
list.add(projectModel);
}
return list;
}
83% thành viên diễn đàn không hỏi bài tập, còn bạn thì sao?