Package com.logicaldoc.calendar

Interface EventDAO

All Superinterfaces:

com.logicaldoc.core.PersistentObjectDAO<Event>

All Known Implementing Classes:

HibernateEventDAO

public interface EventDAO
extends com.logicaldoc.core.PersistentObjectDAO<Event>

DAO for events handling.

Since:

6.7

Author:

Marco Meschieri - LogicalDOC

Method Summary

Modifier and Type	Method	Description
int	cleanOldEvents(int ttl)	This method deletes all the events oldest than the given days from now.
List<Long>	createOccurrences(Event master, Date start, Date end)	This will create all the occurrences of a recurrent master event in a given time range. Attention: the collections are not propagated.
int	deleteOccurrences(long parentId, boolean remindedOnly)	Deletes all the occurrences of a given event, but not the event itelf.
List<Event>	find(Date startDate, Date endDate, Date deadLineFrom, Date deadLineTo, Integer frequency, String title, String type, String subtype, Integer status, Long tenantId, Integer maxRecords)	Finder method for events.
List<Event>	findByParticipant(long participantId, Date startDate)	Retrieves the events associated to the given participant
List<Long>	findIdsByParticipantAndDocument(Long participantId, Long documentId, Date startDate, Date endDate)	Retrieves the identifiers of the events that have a given participant.
List<Long>	findIdsToNotify(Date actualDate)	Finds all the events that needs to be notified.
List<Event>	findOccurrences(long masterId, Date start, Date end)	Retrieves the occurrences of a master event
int	updateOccurrences(Event master)	This will update all existing occurrences with the master's properties.

Methods inherited from interface com.logicaldoc.core.PersistentObjectDAO

bulkUpdate, delete, delete, deleteAll, deleteAll, findAll, findAll, findAllIds, findAllIds, findById, findById, findByObjectQuery, findByQuery, findByWhere, findByWhere, findIdsByWhere, findIdsByWhere, getDbms, initialize, isOracle, jdbcUpdate, jdbcUpdate, query, queryForInt, queryForList, queryForList, queryForLong, queryForObject, queryForRowSet, queryForString, store

Method Detail

findByParticipant

List<Event> findByParticipant(long participantId,
                              Date startDate)

Retrieves the events associated to the given participant

Parameters:

participantId - The id of one or the participant

startDate - oldest date for the events

Returns:

list of vents ordered by startDate asc

findIdsByParticipantAndDocument

List<Long> findIdsByParticipantAndDocument(Long participantId,
                                           Long documentId,
                                           Date startDate,
                                           Date endDate)

Retrieves the identifiers of the events that have a given participant.

Parameters:

participantId - The id of one or the participant

documentId - The id of one of the documents

startDate - oldest date for the event

endDate - latest date for the event

Returns:

list of event Ids

find

List<Event> find(Date startDate,
                 Date endDate,
                 Date deadLineFrom,
                 Date deadLineTo,
                 Integer frequency,
                 String title,
                 String type,
                 String subtype,
                 Integer status,
                 Long tenantId,
                 Integer maxRecords)

Finder method for events.

Parameters:

startDate - Start date (optional)

endDate - End date (optional)

deadLineFrom - (optional)

deadLineTo - (optional)

frequency - The frequency of the event (1,15, 30 ... optional)

title - The title (used with like operator, optional)

type - The type (used with like operator, optional)

subtype - The subtype (used with like operator, optional)

status - The status of the events to find (optional)

tenantId - identifier of the tenant (optional)

maxRecords - Maximum number of records (optional)

Returns:

The list of events ordered by ascending date

findIdsToNotify

List<Long> findIdsToNotify(Date actualDate)

Finds all the events that needs to be notified. The events older than one month(the start date older than one month ago) will be discarded.

Parameters:

actualDate - actual date to consider, if null the current date will be used

Returns:

List of ids to be notified

findOccurrences

List<Event> findOccurrences(long masterId,
                            Date start,
                            Date end)

Retrieves the occurrences of a master event

Parameters:

masterId - identifier of the master event

start - Oldest date, optional

end - Latest date, optional

Returns:

list of events ordered by startDate asc

createOccurrences

List<Long> createOccurrences(Event master,
                             Date start,
                             Date end)
                      throws com.logicaldoc.core.PersistenceException

This will create all the occurrences of a recurrent master event in a given time range.
Attention: the collections are not propagated. All already reminded occurrences are left untouched.

Parameters:

master - The starting point event

start - Oldest date, optional

end - Latest date, mandatory

Returns:

The list of ids of the newly created events

Throws:

com.logicaldoc.core.PersistenceException - error in the database

updateOccurrences

int updateOccurrences(Event master)
               throws com.logicaldoc.core.PersistenceException

This will update all existing occurrences with the master's properties.
Attention: the collections are not propagated nor the timing attributes.

Parameters:

master - The parent event

Returns:

The number of updated records

Throws:

com.logicaldoc.core.PersistenceException - error in the database

deleteOccurrences

int deleteOccurrences(long parentId,
                      boolean remindedOnly)
               throws com.logicaldoc.core.PersistenceException

Deletes all the occurrences of a given event, but not the event itelf.

Parameters:

parentId - identifier of the parent event

remindedOnly - Delete the reminded occurrences only

Returns:

Number of deleted events

Throws:

com.logicaldoc.core.PersistenceException - error in the database

cleanOldEvents

int cleanOldEvents(int ttl)

This method deletes all the events oldest than the given days from now. If ttl is 0 or -1, the cancellation is not made.
Attention: Master events with a frequency will not be deleted.

Parameters:

ttl - The maximum number of days over which the event is considered old

Returns:

Number of deleted events