Java tutorial
/* * Licensed to The Apereo Foundation under one or more contributor license * agreements. See the NOTICE file distributed with this work for * additional information regarding copyright ownership. * * The Apereo Foundation licenses this file to you under the Apache License, * Version 2.0 (the "License"); you may not use this file except in * compliance with the License. You may obtain a copy of the License at: * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * * See the License for the specific language governing permissions and * limitations under the License. * */ package org.unitime.colleague.model.dao; import java.text.DateFormat; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Date; import java.util.Iterator; import java.util.List; import java.util.Set; import org.hibernate.HibernateException; import org.hibernate.Query; import org.hibernate.Transaction; import org.unitime.colleague.model.ColleagueSession; import org.unitime.colleague.model.base.BaseColleagueResponseDAO; import org.unitime.colleague.queueprocessor.exception.LoggableException; import org.unitime.timetable.model.SubjectArea; import org.unitime.timetable.model.dao.SubjectAreaDAO; public class ColleagueResponseDAO extends BaseColleagueResponseDAO { public ColleagueResponseDAO() { } public List find(Long sessionId, String startDate, String stopDate, Long searchSubject, Set subjects, Long searchManager, Long searchDepartment, String searchCourseNumber, String searchColleagueId, String searchMessage, int maxResults, boolean showHistory, boolean actionAudit, boolean actionUpdate, boolean actionDelete, boolean typeSuccess, boolean typeError, boolean typeWarning) throws LoggableException { try { String subjectCode = null; if (searchSubject != null && searchSubject > 0) { subjectCode = SubjectAreaDAO.getInstance().get(searchSubject).getSubjectAreaAbbreviation(); } DateFormat df = new SimpleDateFormat("MM/dd/yyyy"); Date startDateDte = null; if (startDate != null && !startDate.equals("")) { startDateDte = df.parse(startDate); } Date stopDateDte = null; if (stopDate != null && !stopDate.equals("")) { stopDateDte = df.parse(stopDate); } return find(sessionId, startDateDte, stopDateDte, subjectCode, subjects, searchManager, searchDepartment, searchCourseNumber, searchColleagueId, searchMessage, maxResults, showHistory, actionAudit, actionUpdate, actionDelete, typeSuccess, typeError, typeWarning); } catch (ParseException e) { throw new LoggableException(e); } } public List find(Long sessionId, Date startDate, Date stopDate, String searchSubject, Set subjects, Long searchManager, Long searchDepartment, String searchCourseNumber, String searchColleagueId, String searchMessage, int maxResults, boolean showHistory, boolean actionAudit, boolean actionUpdate, boolean actionDelete, boolean typeSuccess, boolean typeError, boolean typeWarning) throws LoggableException { List queueOuts = null; Transaction tx = null; try { tx = getSession().beginTransaction(); String whereHql = " where rp.termCode=:termCode "; org.hibernate.Session hibSession = new ColleagueResponseDAO().getSession(); ColleagueSession bs = ColleagueSession.findColleagueSessionForSession(sessionId, hibSession); String joinHql = ""; if ((searchManager != null && searchManager > 0) || (searchDepartment != null && searchDepartment > 0)) { joinHql += " SubjectArea as sa " + " inner join sa.department as dept "; whereHql += " and sa.session = :sessionId " + "and sa.subjectAreaAbbreviation = rp.subjectCode "; if (searchDepartment != null && searchDepartment > 0) { whereHql += " and dept.uniqueId = :departmentId "; } } if (searchManager != null && searchManager > 0) { joinHql += " inner join dept.timetableManagers as mgr "; whereHql += " and mgr.uniqueId=:managerId"; } if (startDate != null) { whereHql += " and rp.activityDate >= :startDate"; } String fromHql = " from "; if (joinHql.length() > 0) { fromHql += joinHql + ","; } fromHql += " ColleagueResponse as rp"; if (stopDate != null) { whereHql += " and rp.activityDate <= :stopDate"; } if (searchSubject != null && searchSubject != "") { whereHql += " and upper(rp.subjectCode) = upper(:searchSubject) "; } else { int i = 1; for (Iterator it = subjects.iterator(); it.hasNext();) { SubjectArea s = (SubjectArea) it.next(); if (i == 1) { whereHql += " and ( rp.subjectCode in ( "; } else { whereHql += " , "; } whereHql += " '" + s.getSubjectAreaAbbreviation() + "'"; i++; } if (i > 1) { whereHql += "))"; } } if (searchCourseNumber != null && searchCourseNumber != "") { whereHql += " and upper(rp.courseNumber) = upper(:searchCourseNumber) "; } if (searchColleagueId != null && searchColleagueId != "") { whereHql += " and rp.colleagueId = upper(:searchColleagueId) "; } if ((actionUpdate || actionAudit || actionDelete) && !(actionUpdate && actionAudit && actionDelete)) { whereHql += " and rp.action in ("; if (actionUpdate) { whereHql += "'UPDATE'"; } if (actionAudit) { if (!whereHql.endsWith("(")) whereHql += ","; whereHql += "'AUDIT'"; } if (actionDelete) { if (!whereHql.endsWith("(")) whereHql += ","; whereHql += "'DELETE'"; } whereHql += ") "; } if ((typeError || typeSuccess || typeWarning) && !(typeError && typeSuccess && typeWarning)) { whereHql += " and rp.type in ("; if (typeError) { whereHql += "'ERROR'"; } if (typeSuccess) { if (!whereHql.endsWith("(")) whereHql += ","; whereHql += "'SUCCESS'"; } if (typeWarning) { if (!whereHql.endsWith("(")) whereHql += ","; whereHql += "'WARNING'"; } whereHql += ") "; } if (searchMessage != null && searchMessage != "") { whereHql += " and upper(rp.message) like upper(:searchMessage) "; } if (!showHistory) { whereHql += " and rp.queueId = (select max(queueId) from ColleagueResponse rp3 where rp3.termCode = rp.termCode and rp3.colleagueId = rp.colleagueId) "; } String hql = "select rp " + fromHql + whereHql + " order by rp.activityDate desc, rp.sequenceNumber desc "; Query query = getSession().createQuery(hql); query.setString("termCode", bs.getColleagueTermCode()); if (startDate != null) { query.setDate("startDate", startDate); } if (stopDate != null) { query.setDate("stopDate", stopDate); } if ((searchManager != null && searchManager > 0) || (searchDepartment != null && searchDepartment > 0)) { query.setLong("sessionId", sessionId); if (searchDepartment != null && searchDepartment > 0) { query.setLong("departmentId", searchDepartment); } } if (searchManager != null && searchManager > 0) { query.setLong("managerId", searchManager); } if (searchSubject != null && searchSubject != "") { query.setString("searchSubject", searchSubject); } if (searchCourseNumber != null && searchCourseNumber != "") { query.setString("searchCourseNumber", searchCourseNumber); } if (searchColleagueId != null && searchColleagueId != "") { query.setString("searchColleagueId", searchColleagueId); } if (searchMessage != null && searchMessage != "") { query.setString("searchMessage", searchMessage.replace('*', '%')); } if (maxResults < 0) maxResults = 0; if (maxResults > 0) { query.setMaxResults(maxResults); } query.setCacheable(false); queueOuts = query.list(); tx.commit(); } catch (HibernateException e) { tx.rollback(); throw new LoggableException(e); } finally { getSession().close(); } return queueOuts; } }