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;
}
public class UserOperations {
private static DatabaseSessionFactory sessionFactory = DatabaseSessionFactory.getInstance();
public static List<UserFlatMapping> getMembersListForGroupz(String query) {
List<UserFlatMapping> membersList = null;
DatabaseSession session = sessionFactory.newDatabaseSession();
try {
SQLQuery results = constructMembersQuery(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;
}
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;
}
private static SQLQuery constructMobileNumberValidForGroupzQuery(String query) {
DatabaseSession session = sessionFactory.newDatabaseSession();
String finalQry =
"select distinct userflatmapping.* from userflatmapping,flat,person,roledefinition"
+ " where userflatmapping.flatid=flat.id and flat.registeredpersonid=person.id and userflatmapping.enabled=true and "
+ "userflatmapping.roleid=roledefinition.id and "
+ query
+ " order by userflatmapping.id";
SQLQuery sqlQuery = session.createSQLQuery(finalQry);
return sqlQuery;
}
// getting role group list
public static List<Group> getIVRGroupsList(String query) {
List<Group> roleGroupsList = (List<Group>) DBOperations.getDatabaseObjects(Group.class, query);
return roleGroupsList;
}
}