public void updateSchoolFinalRating(SchoolRating schoolRating) {
String HQL =
"SELECT COUNT(id) as userCount, SUM(rating) as totalRating from UserRating where school.id = :schoolId";
HibernateUtil hibernateUtil = new HibernateUtil();
Session session = hibernateUtil.openSession();
Query query =
session.createQuery(HQL).setResultTransformer(Transformers.aliasToBean(TotalRating.class));
query.setParameter("schoolId", schoolRating.getSchool().getId());
List<TotalRating> totalRatings = query.list();
session.flush();
System.out.println(
"total rating:"
+ totalRatings.get(0).getTotalRating()
+ " count"
+ totalRatings.get(0).getUserCount());
if (totalRatings.size() > 0) {
String sql = "from SchoolRating where school.id =" + schoolRating.getSchool().getId();
Session sqlseSession = hibernateUtil.openSession();
Query sqlQuery = sqlseSession.createQuery(sql);
boolean newRating = sqlQuery.list().size() > 0 ? true : false;
sqlseSession.flush();
/*String newhql = "SELECT id from RatingCategoryType";
Session newsession1 = hibernateUtil.openSession();
Query newquery1 = newsession1.createQuery(newhql);
int catSize = newquery1.list().size() > 0 ?newquery1.list().size():0;
newsession1.flush();*/
if (newRating) {
long calculated_rating =
Math.round(
totalRatings.get(0).getTotalRating() / totalRatings.get(0).getUserCount() * 100);
float final_rating = (float) calculated_rating / 100;
System.out.println("Rating:" + final_rating);
String updatehql =
"UPDATE SchoolRating set rating="
+ final_rating
+ " where school.id="
+ schoolRating.getSchool().getId();
Session newsession = hibernateUtil.openSession();
newsession.beginTransaction();
Query newquery = newsession.createQuery(updatehql);
newquery.executeUpdate();
newsession.getTransaction().commit();
newsession.flush();
} else {
long calculated_rating =
Math.round(
totalRatings.get(0).getTotalRating() / totalRatings.get(0).getUserCount() * 100);
float final_rating = (float) calculated_rating / 100;
System.out.println("Rating:" + final_rating);
schoolRating.setRating(final_rating);
Session newsession = hibernateUtil.openSession();
newsession.beginTransaction();
newsession.save(schoolRating);
newsession.getTransaction().commit();
newsession.flush();
}
}
}
public ResponseMessage addSchoolRating(RatingData ratingData) {
ResponseMessage msg = new ResponseMessage();
ArrayList<String> errors = new ArrayList<String>();
if (ratingData.getSchoolId() > 0
&& ratingData.getUserId() > 0
&& ratingData.getRatings().size() > 0) {
try {
String HQL =
"SELECT ur.id as id, ur.ratingCategoryType.id as catid "
+ " FROM UserRating ur WHERE ur.school.id = :schoolId AND ur.userRegistrationInfo.id = :userId ";
HibernateUtil hibernateUtil = new HibernateUtil();
Session sess = hibernateUtil.openSession();
Query query =
sess.createQuery(HQL)
.setResultTransformer(Transformers.aliasToBean(Rating.class))
.setParameter("schoolId", ratingData.getSchoolId())
.setParameter("userId", ratingData.getUserId());
List<Rating> ratings = query.list();
sess.close();
School school = new School();
school.setId(ratingData.getSchoolId());
UserRegistrationInfo userRegistrationInfo = new UserRegistrationInfo();
userRegistrationInfo.setId(ratingData.getUserId());
SchoolRating schoolRating = new SchoolRating();
schoolRating.setSchool(school);
Session session = hibernateUtil.openSession();
session.beginTransaction();
for (int i = 0; i < ratingData.getRatings().size(); i++) {
UserRating userRating = new UserRating();
if (ratings.isEmpty() == false) {
for (int j = 0; j < ratings.size(); j++) {
if (ratingData.getRatings().get(i).getCatid() == ratings.get(j).getCatid()) {
userRating.setId(ratings.get(j).getId());
}
}
}
userRating.setSchool(school);
userRating.setUserRegistrationInfo(userRegistrationInfo);
userRating.setRating((float) ratingData.getRatings().get(i).getRating());
userRating.setAddedDate(new Date());
RatingCategoryType ratingCategoryType = new RatingCategoryType();
ratingCategoryType.setId(ratingData.getRatings().get(i).getCatid());
userRating.setRatingCategoryType(ratingCategoryType);
session.saveOrUpdate(userRating);
}
session.getTransaction().commit();
session.flush();
updateSchoolFinalRating(schoolRating);
msg.setStatus(1);
msg.setMessage("Rating saved successfully.");
} catch (Exception e) {
errors.add(e.getMessage());
msg.setStatus(0);
msg.setErrors(errors);
}
} else {
if (ratingData.getSchoolId() <= 0) {
errors.add("School Id Can not be empty");
}
if (ratingData.getUserId() <= 0) {
errors.add("User Id Can not be empty");
}
if (ratingData.getRatings().size() <= 0) {
errors.add("Rating data can not be empty");
}
msg.setStatus(0);
msg.setErrors(errors);
}
return msg;
}