" q.documentType" +
" from Question as q left join q.documentType").list();
Map<Integer, Question> qmap = new HashMap<Integer, Question>();
for (Object o : qlist){
Object[] cols = (Object[]) o;
Question question = new Question();
question.setQuestionId((Integer) cols[0]);
question.setQuestionPriority((Integer) cols[1]);
question.setContents((String) cols[2]);
question.setForAllConstructions((Boolean) cols[3]);
question.setForObjectStructure((Boolean) cols[4]);
question.setNecessary((Boolean) cols[5]);
question.setNoVariants((Boolean) cols[6]);
question.setFewAnswers((Boolean) cols[7]);
question.setQuestionType((QuestionType) cols[8]);
if (cols[9] != null) {
question.setDocumentType((DocumentType) cols[9]);
} else {
question.setDocumentType(new DocumentType());
}
// q.setAnswers(new ArrayList<Answer>());
qmap.put(question.getQuestionId(), question);
}
Map<Integer, Answer> amap = new HashMap<Integer, Answer>();
List<?> alist = getSession().createQuery(
"select " +
" answerId, "+
" contents, "+
" answerInterpritation, "+
" letter," +
" question.questionId" +
" from Answer").list();
for (Object o : alist){
Object[] cols = (Object[]) o;
Answer answer = new Answer();
answer.setAnswerId((Integer) cols[0]);
answer.setContents((String) cols[1]);
answer.setAnswerInterpritation((String) cols[2]);
answer.setLetter((String) cols[3]);
Question question = qmap.get((Integer) cols[4]);
if (question!=null) {
question.getAnswers().add(answer);
answer.setQuestion(question);
}
amap.put(answer.getAnswerId(), answer);
}
getSession().createQuery(
"from DangerCategory").list();
getSession().createQuery(
"from ObjectType").list();
getSession().createQuery(
"from User u left join fetch u.roles").list();
String boHQL =
"select new BuildingObject(objectId," +
" technicalTask,wayToTechnicalTask, " +
"(select object(user) from User user " +
" where user.id=buildingObject.user.id), " +
" name, " +
" description, " +
" country, " +
" region, " +
" city, " +
" street, " +
" house, " +
" block, " +
" organizationName, " +
" organizationZip, " +
" organizationCountry, " +
" organizationRegion, " +
" organizationCity, " +
"organizationHouse,organizationStreet,organizationBlock,organizationFlat, " +
"headerFamily,headerMiddleName,headerName,organozationPhone, " +
"(select object(dangerCategory) from DangerCategory dangerCategory " +
" where dangerCategory.dangerCategoryId=buildingObject.dangerCategory.dangerCategoryId), " +
" (select object(objectType) from ObjectType objectType where objectType.objectTypeId=buildingObject.objectType.objectTypeId))" +
" from BuildingObject buildingObject";
List<?> buildingObjectList = null;
if (buildingObjectId ==null) {
buildingObjectList = getSession().createQuery(
boHQL).list();
} else {
boHQL = boHQL + " where buildingObject.objectId=?";
buildingObjectList = getSession().createQuery(
boHQL).setString(0, buildingObjectId.toString()).list();
}
Map<Integer, BuildingObject> boMap = new HashMap<Integer, BuildingObject>();
for(Object o : buildingObjectList){
BuildingObject bo = (BuildingObject) o;
List objectAnswers = getSession().createQuery("select new ObjectAnswer(objectAnswerId,objectConstructionId,answerContents,answerComment,buildingObjectId,question) from ObjectAnswer where objectId=?").setString(0, String.valueOf(bo.getObjectId())).list();
for (int j = 0; j < objectAnswers.size(); j++) {
ObjectAnswer objectAnswer = (ObjectAnswer) objectAnswers.get(j);
objectAnswer.setAnswers(super.getSession().createQuery("from Answer where answerId in (select answers.answerId from ObjectAnswer objectAnswer inner join objectAnswer.answers as answers where objectAnswer.objectAnswerId=?)").setString(0, objectAnswer.getObjectAnswerId().toString()).list());
}
bo.setDocumentationQuestions(objectAnswers);
//we have already lazy list
//bo.setDocQuestions(new ArrayList<ObjectAnswer>());
//bo.setObjectQuestions(new ArrayList<ObjectAnswer>());
//bo.setDocumentationQuestions(new ArrayList<ObjectAnswer>());
boMap.put(bo.getObjectId(), bo);
}
String oaHQL = "select objectAnswerId, " +
" buildingObjectId, " +
" answerContents, " +
" answerComment, " +
" question.questionId from ObjectAnswer";
List<?> oqustion = null;
if (buildingObjectId ==null) {
oqustion = getSession().createQuery(
oaHQL).list();
} else {
oaHQL = oaHQL + " where buildingObjectId=?";
oqustion = getSession().createQuery(
oaHQL).setString(0, buildingObjectId.toString()).list();
}
Map<Integer, ObjectAnswer> oaMap = new HashMap<Integer, ObjectAnswer>();
for (Object o : oqustion) {
Object[] cols = (Object[]) o;
ObjectAnswer oa = new ObjectAnswer();
oa.setObjectAnswerId((Integer) cols[0]);
oa.setBuildingObjectId((Integer) cols[1]);
oa.setAnswerContents((String) cols[2]);
oa.setAnswerComment((String) cols[3]);
// oa.setAnswers(new ArrayList<Answer>());
Question q = qmap.get((Integer) cols[4]);
if (q != null) {
oa.setQuestion(q);
BuildingObject bo = boMap.get(oa.getBuildingObjectId());
if (bo != null) {
oa.setBuildingObject(bo);
if (q.isForObjectStructure()) {
bo.getObjectQuestions().add(oa);
} else {
bo.getDocQuestions().add(oa);
}
if (q.getQuestionType().getQuestionTypeId() == 1){
bo.getDocumentationQuestions().add(oa);
}
}
}
oaMap.put(oa.getObjectAnswerId(), oa);