eventdao.java

开源项目CRM之OpenCustomer

/*******************************************************************************
 * ***** BEGIN LICENSE BLOCK Version: MPL 1.1
 * 
 * The contents of this file are subject to the Mozilla Public License Version
 * 1.1 (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.mozilla.org/MPL/
 * 
 * Software distributed under the License is distributed on an "AS IS" basis,
 * WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License for
 * the specific language governing rights and limitations under the License.
 * 
 * The Original Code is the OpenCustomer CRM.
 * 
 * The Initial Developer of the Original Code is Thomas Bader (Bader & Jene
 * Software-Ingenieurb黵o). Portions created by the Initial Developer are
 * Copyright (C) 2005 the Initial Developer. All Rights Reserved.
 * 
 * Contributor(s): Thomas Bader <[e-mail]>
 * 
 * ***** END LICENSE BLOCK *****
 */

package org.opencustomer.application.db.dao.calendar;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import org.apache.log4j.Logger;
import org.hibernate.HibernateException;
import org.opencustomer.application.db.vo.calendar.EventVO;
import org.opencustomer.application.db.vo.system.UserVO;
import org.opencustomer.db.dao.UndeletableDAO;
import org.opencustomer.db.vo.EntityAccess;

public final class EventDAO extends UndeletableDAO<EventVO>
{
    private static final Logger log = Logger.getLogger(EventDAO.class);

    public EventDAO() throws HibernateException
    {
        super();
    }

    protected Class getEntityClass()
    {
        return EventVO.class;
    }

    public List<EventVO> getByTimePeriod(Integer calendarId, Date periodStart, Date periodEnd, UserVO user)
    {
        List<EventVO> events = new ArrayList<EventVO>();

        try
        {
            StringBuilder hql = new StringBuilder();
            hql.append(" FROM ").append(getEntityClass().getName()).append(" e ");
            hql.append(" WHERE e.calendar.id = :calendarId ");
            hql.append(" AND e.deleted = 0 ");
            
            hql.append(" AND (((e.startDate BETWEEN :startDate AND :endDate ");
            hql.append(" OR e.endDate BETWEEN :startDate AND :endDate ");
            hql.append(" OR (e.startDate < :startDate AND e.endDate > :endDate)) ");
            hql.append(" AND e.recurrenceType = '"+EventVO.RecurrenceType.NONE+"') ");

            hql.append(" OR ((e.recurrenceStartDate BETWEEN :startDate AND :endDate ");
            hql.append(" OR e.recurrenceEndDate BETWEEN :startDate AND :endDate ");
            hql.append(" OR (e.recurrenceStartDate < :startDate AND e.recurrenceEndDate > :endDate)) ");
            hql.append(" AND e.recurrenceType <> '"+EventVO.RecurrenceType.NONE+"') ");

            hql.append(" OR (e.recurrenceStartDate < :endDate AND e.recurrenceEndDate is null ");
            hql.append(" AND e.recurrenceType <> '"+EventVO.RecurrenceType.NONE+"')) ");

            hql.append(" AND (e.globalAccess != '"+EntityAccess.Access.NONE+"' ");
            hql.append(" OR (e.groupAccess != '"+EntityAccess.Access.NONE+"' ");
            hql.append(" AND exists (from ").append(UserVO.class.getName()).append(" as u where u.id = :userId and u.usergroups.id = e.groupOwner)) ");
            hql.append(" OR (e.userAccess != '"+EntityAccess.Access.NONE+"' ");
            hql.append(" AND e.userOwner = :userId)) ");

            hql.append(" ORDER BY e.startDate, e.endDate");

            events = toTypeSafeList(this.session.createQuery(hql.toString())
                        .setInteger("calendarId", calendarId)
                        .setTimestamp("startDate", periodStart)
                        .setTimestamp("endDate", periodEnd)
                        .setInteger("userId", user.getId())
                        .list());

            if (log.isDebugEnabled())
                log.debug("found " + events.size() + " events in time period from " + periodStart + " to " + periodEnd);
        }
        catch (HibernateException e)
        {
            log.error("Could not read events in time period from " + periodStart + " to " + periodEnd, e);
            throw e;
        }

        return events;
    }
}