src/db/java/org/apache/openmeetings/db/dao/calendar/AppointmentDao.java - openmeetings - Git at Google

 /*
  * Licensed to the Apache Software Foundation (ASF) under one
  * or more contributor license agreements.  See the NOTICE file
  * distributed with this work for additional information
  * regarding copyright ownership.  The ASF 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.apache.openmeetings.db.dao.calendar;

 import static org.apache.openmeetings.util.OpenmeetingsVariables.webAppRootKey;

 import java.util.ArrayList;
 import java.util.Calendar;
 import java.util.Date;
 import java.util.HashSet;
 import java.util.List;
 import java.util.Set;
 import java.util.TimeZone;

 import javax.persistence.EntityManager;
 import javax.persistence.NoResultException;
 import javax.persistence.PersistenceContext;
 import javax.persistence.TypedQuery;

 import org.apache.openmeetings.db.dao.basic.ConfigurationDao;
 import org.apache.openmeetings.db.dao.calendar.IInvitationManager.MessageType;
 import org.apache.openmeetings.db.dao.room.RoomDao;
 import org.apache.openmeetings.db.dao.user.UserDao;
 import org.apache.openmeetings.db.entity.calendar.Appointment;
 import org.apache.openmeetings.db.entity.calendar.MeetingMember;
 import org.apache.openmeetings.db.entity.room.Room;
 import org.apache.openmeetings.db.util.TimezoneUtil;
 import org.red5.logging.Red5LoggerFactory;
 import org.slf4j.Logger;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.transaction.annotation.Transactional;

 @Transactional
 public class AppointmentDao {
 	private static final Logger log = Red5LoggerFactory.getLogger(AppointmentDao.class, webAppRootKey);
 	@PersistenceContext
 	private EntityManager em;
 	@Autowired
 	private MeetingMemberDao meetingMemberDao;
 	@Autowired
 	private UserDao usersDao;
 	@Autowired
 	private RoomDao roomDao;
 	@Autowired
 	private ConfigurationDao cfgDao;
 	@Autowired
 	private IInvitationManager invitationManager;
 	@Autowired
 	private TimezoneUtil timezoneUtil;

 	/*
 	 * insert, update, delete, select
 	 */

 	/**
 	 * @author o.becherer Retrievment of Appointment for room
 	 */
 	// -----------------------------------------------------------------------------------------------
 	public Appointment getAppointmentByRoom(Long room_id) {
 		log.debug("AppointMentDaoImpl.getAppointmentByRoom");

 		TypedQuery<Appointment> query = em.createNamedQuery("getAppointmentByRoomId", Appointment.class);
 		query.setParameter("room_id", room_id);

 		List<Appointment> appoint = query.getResultList();

 		if (appoint.size() > 0) {
 			return appoint.get(0);
 		}

 		return null;
 	}

 	// -----------------------------------------------------------------------------------------------

 	public Appointment get(Long id) {
 		TypedQuery<Appointment> query = em.createNamedQuery("getAppointmentById", Appointment.class);
 		query.setParameter("id", id);

 		Appointment appoint = null;
 		try {
 			appoint = query.getSingleResult();
 		} catch (NoResultException ex) {
 		}
 		return appoint;
 	}

 	public Appointment getAppointmentByIdBackup(Long appointmentId) {
 		TypedQuery<Appointment> query = em.createNamedQuery("getAppointmentByIdAny", Appointment.class).setParameter("id", appointmentId);

 		Appointment appoint = null;
 		try {
 			appoint = query.getSingleResult();
 		} catch (NoResultException ex) {
 		}

 		return appoint;
 	}

 	public List<Appointment> getAppointments() {
 		return em.createNamedQuery("getAppointments", Appointment.class).getResultList();
 	}

 	public Appointment update(Appointment a, Long userId) {
 		return update(a, userId, true);
 	}

 	public Appointment update(Appointment a, Long userId, boolean sendmails) {
 		Room r = a.getRoom();
 		if (r.getRooms_id() == null) {
 			r.setName(a.getTitle());
 			r.setNumberOfPartizipants(cfgDao.getConfValue("calendar.conference.rooms.default.size", Long.class, "50"));
 		}
 		roomDao.update(r, userId);
 		if (sendmails) {
 			Set<Long> mmIds = a.getId() == null ? new HashSet<Long>()
 					: meetingMemberDao.getMeetingMemberIdsByAppointment(a.getId());
 			// update meeting members
 			Appointment a0 = a.getId() == null ? null : get(a.getId());
 			boolean sendMail = a0 == null || !a0.getTitle().equals(a.getTitle()) ||
 					!(a0.getDescription() != null ? a0.getDescription().equals(a.getDescription()) : true) ||
 					!(a0.getLocation() != null ? a0.getLocation().equals(a.getLocation()) : true) ||
 					!a0.getStart().equals(a.getStart()) ||
 					!a0.getEnd().equals(a.getEnd());
 			List<MeetingMember> mmList = a.getMeetingMembers();
 			if (mmList != null){
 				for (MeetingMember mm : mmList) {
 					if (mm.getId() == null || !mmIds.contains(mm.getId())) {
 						invitationManager.processInvitation(a, mm, MessageType.Create);
 					} else {
 						mmIds.remove(mm.getId());
 						invitationManager.processInvitation(a, mm, MessageType.Update, sendMail);
 					}
 				}
 			}
 			for (long id : mmIds) {
 				invitationManager.processInvitation(a, meetingMemberDao.get(id), MessageType.Cancel);
 			}
 			//notify owner
 			MeetingMember owner = new MeetingMember();
 			owner.setUser(a.getOwner());
 			if (a.getId() == null) {
 				invitationManager.processInvitation(a, owner, MessageType.Create);
 			} else if (a.isDeleted()) {
 				invitationManager.processInvitation(a, owner, MessageType.Cancel);
 			} else if (sendMail) {
 				invitationManager.processInvitation(a, owner, MessageType.Update, sendMail);
 			}
 		}
 		if (a.getId() == null) {
 			a.setInserted(new Date());
 			em.persist(a);
 		} else {
 			a.setUpdated(new Date());
 			a =	em.merge(a);
 		}
 		return a;
 	}

 	public List<Appointment> getAppointmentsByRoomId(Long roomId) {
 		try {

 			String hql = "select a from Appointment a "
 					+ "WHERE a.room.rooms_id = :roomId ";

 			TypedQuery<Appointment> query = em.createQuery(hql,
 					Appointment.class);
 			query.setParameter("roomId", roomId);
 			List<Appointment> ll = query.getResultList();

 			return ll;
 		} catch (Exception e) {
 			log.error("[getAppointmentsByRoomId]", e);
 		}
 		return null;
 	}

 	// ----------------------------------------------------------------------------------------------------------

 	public void delete(Appointment a, Long userId) {
 		a.setUpdated(new Date());
 		a.setDeleted(true);
 		a.setMeetingMembers(null);
 		if (Boolean.TRUE.equals(a.getRoom().getAppointment())) {
 			a.getRoom().setDeleted(true);
 		}
 		update(a, userId);
 	}

 	public List<Appointment> getAppointmentsByRange(Long userId, Date start, Date end) {
 		log.debug("Start " + start + " End " + end);

 		TypedQuery<Appointment> query = em.createNamedQuery("appointmentsInRange", Appointment.class);
 		query.setParameter("starttime", start);
 		query.setParameter("endtime", end);
 		query.setParameter("userId", userId);

 		List<Appointment> listAppoints = new ArrayList<Appointment>(query.getResultList());
 		TypedQuery<Appointment> q1 = em.createNamedQuery("joinedAppointmentsInRange", Appointment.class);
 		q1.setParameter("starttime", start);
 		q1.setParameter("endtime", end);
 		q1.setParameter("userId", userId);
 		for (Appointment a : q1.getResultList()) {
 			a.setConnectedEvent(true); //TODO need to be reviewed
 			listAppoints.add(a);
 		}

 		return listAppoints;
 	}

 	public List<Appointment> getAppointmentsInRange(Calendar start, Calendar end) {
 		TypedQuery<Appointment> q = em.createNamedQuery("appointmentsInRangeRemind", Appointment.class);
 		q.setParameter("starttime", start.getTime());
 		q.setParameter("endtime", end.getTime());
 		return q.getResultList();
 	}

 	public List<Appointment> getAppointmentsByCat(Long categoryId) {
 		try {

 			String hql = "select a from Appointments a "
 					+ "WHERE a.deleted false "
 					+ "AND a.appointmentCategory.categoryId = :categoryId";

 			TypedQuery<Appointment> query = em.createQuery(hql,
 					Appointment.class);
 			query.setParameter("categoryId", categoryId);

 			List<Appointment> listAppoints = query.getResultList();
 			return listAppoints;
 		} catch (Exception ex2) {
 			log.error("[getAppointements]: ", ex2);
 		}
 		return null;
 	}

 	// next appointment to select date
 	public Appointment getNextAppointment(Long userId, Date start) {
 		List<Appointment> list = em.createNamedQuery("getNextAppointment", Appointment.class)
 				.setParameter("start", start).setParameter("userId", userId).getResultList();
 		return list == null || list.isEmpty() ? null : list.get(0);
 	}

 	public List<Appointment> searchAppointmentsByTitle(Long userId, String title) {
 		return em.createNamedQuery("getNextAppointment", Appointment.class)
 				.setParameter("title", title).setParameter("userId", userId).getResultList();
 	}

 	/**
 	 * @author becherer
 	 * @param userId
 	 * @return
 	 */
 	public List<Appointment> getTodaysAppointmentsbyRangeAndMember(Long userId) {
 		log.debug("getAppoitmentbyRangeAndMember : UserID - " + userId);

 		TimeZone timeZone = timezoneUtil.getTimeZone(usersDao.get(userId));

 		Calendar startCal = Calendar.getInstance(timeZone);
 		startCal.set(Calendar.MINUTE, 0);
 		startCal.set(Calendar.HOUR, 0);
 		startCal.set(Calendar.SECOND, 1);

 		Calendar endCal = Calendar.getInstance(timeZone);
 		endCal.set(Calendar.MINUTE, 23);
 		endCal.set(Calendar.HOUR, 59);
 		endCal.set(Calendar.SECOND, 59);

 		TypedQuery<Appointment> query = em.createNamedQuery("appointmentsInRangeByUser", Appointment.class);

 		query.setParameter("userId", userId);

 		query.setParameter("starttime", startCal.getTime());
 		query.setParameter("endtime", endCal.getTime());

 		List<Appointment> listAppoints = query.getResultList();
 		return listAppoints;
 	}

 	// ---------------------------------------------------------------------------------------------

 	public Appointment getAppointmentByRoomId(Long user_id, Long rooms_id) {
 		try {

 			String hql = "select a from Appointment a "
 					+ "WHERE a.deleted <> :deleted "
 					+ "AND a.owner.user_id = :user_id "
 					+ "AND a.room.rooms_id = :rooms_id ";

 			TypedQuery<Appointment> query = em.createQuery(hql,
 					Appointment.class);

 			query.setParameter("deleted", true);
 			query.setParameter("user_id", user_id);
 			query.setParameter("rooms_id", rooms_id);

 			List<Appointment> listAppoints = query.getResultList();

 			if (listAppoints.size() > 0) {
 				return listAppoints.get(0);
 			}

 			return null;

 		} catch (Exception e) {
 			log.error("[getAppointmentByRoomId]", e);
 			return null;
 		}
 	}

 }
	/*
	* Licensed to the Apache Software Foundation (ASF) under one
	* or more contributor license agreements. See the NOTICE file
	* distributed with this work for additional information
	* regarding copyright ownership. The ASF 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.apache.openmeetings.db.dao.calendar;

	import static org.apache.openmeetings.util.OpenmeetingsVariables.webAppRootKey;

	import java.util.ArrayList;
	import java.util.Calendar;
	import java.util.Date;
	import java.util.HashSet;
	import java.util.List;
	import java.util.Set;
	import java.util.TimeZone;

	import javax.persistence.EntityManager;
	import javax.persistence.NoResultException;
	import javax.persistence.PersistenceContext;
	import javax.persistence.TypedQuery;

	import org.apache.openmeetings.db.dao.basic.ConfigurationDao;
	import org.apache.openmeetings.db.dao.calendar.IInvitationManager.MessageType;
	import org.apache.openmeetings.db.dao.room.RoomDao;
	import org.apache.openmeetings.db.dao.user.UserDao;
	import org.apache.openmeetings.db.entity.calendar.Appointment;
	import org.apache.openmeetings.db.entity.calendar.MeetingMember;
	import org.apache.openmeetings.db.entity.room.Room;
	import org.apache.openmeetings.db.util.TimezoneUtil;
	import org.red5.logging.Red5LoggerFactory;
	import org.slf4j.Logger;
	import org.springframework.beans.factory.annotation.Autowired;
	import org.springframework.transaction.annotation.Transactional;

	@Transactional
	public class AppointmentDao {
	private static final Logger log = Red5LoggerFactory.getLogger(AppointmentDao.class, webAppRootKey);
	@PersistenceContext
	private EntityManager em;
	@Autowired
	private MeetingMemberDao meetingMemberDao;
	@Autowired
	private UserDao usersDao;
	@Autowired
	private RoomDao roomDao;
	@Autowired
	private ConfigurationDao cfgDao;
	@Autowired
	private IInvitationManager invitationManager;
	@Autowired
	private TimezoneUtil timezoneUtil;

	/*
	* insert, update, delete, select
	*/

	/**
	* @author o.becherer Retrievment of Appointment for room
	*/
	// -----------------------------------------------------------------------------------------------
	public Appointment getAppointmentByRoom(Long room_id) {
	log.debug("AppointMentDaoImpl.getAppointmentByRoom");

	TypedQuery<Appointment> query = em.createNamedQuery("getAppointmentByRoomId", Appointment.class);
	query.setParameter("room_id", room_id);

	List<Appointment> appoint = query.getResultList();

	if (appoint.size() > 0) {
	return appoint.get(0);
	}

	return null;
	}

	// -----------------------------------------------------------------------------------------------

	public Appointment get(Long id) {
	TypedQuery<Appointment> query = em.createNamedQuery("getAppointmentById", Appointment.class);
	query.setParameter("id", id);

	Appointment appoint = null;
	try {
	appoint = query.getSingleResult();
	} catch (NoResultException ex) {
	}
	return appoint;
	}

	public Appointment getAppointmentByIdBackup(Long appointmentId) {
	TypedQuery<Appointment> query = em.createNamedQuery("getAppointmentByIdAny", Appointment.class).setParameter("id", appointmentId);

	Appointment appoint = null;
	try {
	appoint = query.getSingleResult();
	} catch (NoResultException ex) {
	}

	return appoint;
	}

	public List<Appointment> getAppointments() {
	return em.createNamedQuery("getAppointments", Appointment.class).getResultList();
	}

	public Appointment update(Appointment a, Long userId) {
	return update(a, userId, true);
	}

	public Appointment update(Appointment a, Long userId, boolean sendmails) {
	Room r = a.getRoom();
	if (r.getRooms_id() == null) {
	r.setName(a.getTitle());
	r.setNumberOfPartizipants(cfgDao.getConfValue("calendar.conference.rooms.default.size", Long.class, "50"));
	}
	roomDao.update(r, userId);
	if (sendmails) {
	Set<Long> mmIds = a.getId() == null ? new HashSet<Long>()
	: meetingMemberDao.getMeetingMemberIdsByAppointment(a.getId());
	// update meeting members
	Appointment a0 = a.getId() == null ? null : get(a.getId());
	boolean sendMail = a0 == null \|\| !a0.getTitle().equals(a.getTitle()) \|\|
	!(a0.getDescription() != null ? a0.getDescription().equals(a.getDescription()) : true) \|\|
	!(a0.getLocation() != null ? a0.getLocation().equals(a.getLocation()) : true) \|\|
	!a0.getStart().equals(a.getStart()) \|\|
	!a0.getEnd().equals(a.getEnd());
	List<MeetingMember> mmList = a.getMeetingMembers();
	if (mmList != null){
	for (MeetingMember mm : mmList) {
	if (mm.getId() == null \|\| !mmIds.contains(mm.getId())) {
	invitationManager.processInvitation(a, mm, MessageType.Create);
	} else {
	mmIds.remove(mm.getId());
	invitationManager.processInvitation(a, mm, MessageType.Update, sendMail);
	}
	}
	}
	for (long id : mmIds) {
	invitationManager.processInvitation(a, meetingMemberDao.get(id), MessageType.Cancel);
	}
	//notify owner
	MeetingMember owner = new MeetingMember();
	owner.setUser(a.getOwner());
	if (a.getId() == null) {
	invitationManager.processInvitation(a, owner, MessageType.Create);
	} else if (a.isDeleted()) {
	invitationManager.processInvitation(a, owner, MessageType.Cancel);
	} else if (sendMail) {
	invitationManager.processInvitation(a, owner, MessageType.Update, sendMail);
	}
	}
	if (a.getId() == null) {
	a.setInserted(new Date());
	em.persist(a);
	} else {
	a.setUpdated(new Date());
	a = em.merge(a);
	}
	return a;
	}

	public List<Appointment> getAppointmentsByRoomId(Long roomId) {
	try {

	String hql = "select a from Appointment a "
	+ "WHERE a.room.rooms_id = :roomId ";

	TypedQuery<Appointment> query = em.createQuery(hql,
	Appointment.class);
	query.setParameter("roomId", roomId);
	List<Appointment> ll = query.getResultList();

	return ll;
	} catch (Exception e) {
	log.error("[getAppointmentsByRoomId]", e);
	}
	return null;
	}

	// ----------------------------------------------------------------------------------------------------------

	public void delete(Appointment a, Long userId) {
	a.setUpdated(new Date());
	a.setDeleted(true);
	a.setMeetingMembers(null);
	if (Boolean.TRUE.equals(a.getRoom().getAppointment())) {
	a.getRoom().setDeleted(true);
	}
	update(a, userId);
	}

	public List<Appointment> getAppointmentsByRange(Long userId, Date start, Date end) {
	log.debug("Start " + start + " End " + end);

	TypedQuery<Appointment> query = em.createNamedQuery("appointmentsInRange", Appointment.class);
	query.setParameter("starttime", start);
	query.setParameter("endtime", end);
	query.setParameter("userId", userId);

	List<Appointment> listAppoints = new ArrayList<Appointment>(query.getResultList());
	TypedQuery<Appointment> q1 = em.createNamedQuery("joinedAppointmentsInRange", Appointment.class);
	q1.setParameter("starttime", start);
	q1.setParameter("endtime", end);
	q1.setParameter("userId", userId);
	for (Appointment a : q1.getResultList()) {
	a.setConnectedEvent(true); //TODO need to be reviewed
	listAppoints.add(a);
	}

	return listAppoints;
	}

	public List<Appointment> getAppointmentsInRange(Calendar start, Calendar end) {
	TypedQuery<Appointment> q = em.createNamedQuery("appointmentsInRangeRemind", Appointment.class);
	q.setParameter("starttime", start.getTime());
	q.setParameter("endtime", end.getTime());
	return q.getResultList();
	}

	public List<Appointment> getAppointmentsByCat(Long categoryId) {
	try {

	String hql = "select a from Appointments a "
	+ "WHERE a.deleted false "
	+ "AND a.appointmentCategory.categoryId = :categoryId";

	TypedQuery<Appointment> query = em.createQuery(hql,
	Appointment.class);
	query.setParameter("categoryId", categoryId);

	List<Appointment> listAppoints = query.getResultList();
	return listAppoints;
	} catch (Exception ex2) {
	log.error("[getAppointements]: ", ex2);
	}
	return null;
	}

	// next appointment to select date
	public Appointment getNextAppointment(Long userId, Date start) {
	List<Appointment> list = em.createNamedQuery("getNextAppointment", Appointment.class)
	.setParameter("start", start).setParameter("userId", userId).getResultList();
	return list == null \|\| list.isEmpty() ? null : list.get(0);
	}

	public List<Appointment> searchAppointmentsByTitle(Long userId, String title) {
	return em.createNamedQuery("getNextAppointment", Appointment.class)
	.setParameter("title", title).setParameter("userId", userId).getResultList();
	}

	/**
	* @author becherer
	* @param userId
	* @return
	*/
	public List<Appointment> getTodaysAppointmentsbyRangeAndMember(Long userId) {
	log.debug("getAppoitmentbyRangeAndMember : UserID - " + userId);

	TimeZone timeZone = timezoneUtil.getTimeZone(usersDao.get(userId));

	Calendar startCal = Calendar.getInstance(timeZone);
	startCal.set(Calendar.MINUTE, 0);
	startCal.set(Calendar.HOUR, 0);
	startCal.set(Calendar.SECOND, 1);

	Calendar endCal = Calendar.getInstance(timeZone);
	endCal.set(Calendar.MINUTE, 23);
	endCal.set(Calendar.HOUR, 59);
	endCal.set(Calendar.SECOND, 59);

	TypedQuery<Appointment> query = em.createNamedQuery("appointmentsInRangeByUser", Appointment.class);

	query.setParameter("userId", userId);

	query.setParameter("starttime", startCal.getTime());
	query.setParameter("endtime", endCal.getTime());

	List<Appointment> listAppoints = query.getResultList();
	return listAppoints;
	}

	// ---------------------------------------------------------------------------------------------

	public Appointment getAppointmentByRoomId(Long user_id, Long rooms_id) {
	try {

	String hql = "select a from Appointment a "
	+ "WHERE a.deleted <> :deleted "
	+ "AND a.owner.user_id = :user_id "
	+ "AND a.room.rooms_id = :rooms_id ";

	TypedQuery<Appointment> query = em.createQuery(hql,
	Appointment.class);

	query.setParameter("deleted", true);
	query.setParameter("user_id", user_id);
	query.setParameter("rooms_id", rooms_id);

	List<Appointment> listAppoints = query.getResultList();

	if (listAppoints.size() > 0) {
	return listAppoints.get(0);
	}

	return null;

	} catch (Exception e) {
	log.error("[getAppointmentByRoomId]", e);
	return null;
	}
	}

	}