private static SQLQuery constructMembersQuery(String query) {
DatabaseSession session = sessionFactory.newDatabaseSession();
String finalQry =
"select distinct userflatmapping.* from userflatmapping,flat,person"
+ " where userflatmapping.flatid=flat.id and flat.registeredpersonid=person.id and userflatmapping.enabled=true and "
+ query
+ " order by userflatmapping.id";
SQLQuery sqlQuery = session.createSQLQuery(finalQry);
return sqlQuery;
}
public static List<UserFlatMapping> checkMobileNumberValidForGroupz(String query) {
List<UserFlatMapping> membersList = null;
DatabaseSession session = sessionFactory.newDatabaseSession();
try {
SQLQuery results = constructMobileNumberValidForGroupzQuery(query);
System.out.println("Final SQL Qry:" + results.toString());
membersList =
(List<UserFlatMapping>)
results.addEntity("userflatmapping", UserFlatMapping.class).list();
System.out.println("Final Groupz List:" + membersList.size());
session.close();
} catch (Exception e) {
// TODO: handle exception
}
return membersList;
}