Class TaskDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.plugin.task.dao.TaskDAO

public class TaskDAO
extends CommonDAO

Nested Class Summary

Nested classes/interfaces inherited from class CommonDAO

CommonDAO.ObjectExtractor<T>, CommonDAO.RecordUpdater<T>

Field Summary

Fields inherited from class CommonDAO

con, log, SQL_AND, SQL_DELETE, SQL_DELETE_FROM, SQL_DESC, SQL_DISTINCT, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT_IGNORE_INTO, SQL_INSERT_INTO, SQL_LEFT_JOIN, SQL_LIMIT, SQL_ON_DUP_KEY_UPDATE, SQL_ORDER_BY, SQL_REPLACE, SQL_SELECT, SQL_SELECT_ALL_FROM, SQL_SELECT_COUNT_ROWS, SQL_SET, SQL_UNION_ALL, SQL_UPDATE, SQL_VALUES, SQL_VALUES_1, SQL_VALUES_2, SQL_VALUES_3, SQL_VALUES_4, SQL_VALUES_5, SQL_WHERE

Constructor Summary

Constructors

Constructor	Description
TaskDAO(Connection con)

Method Summary

Modifier and Type	Method	Description
void	deleteTasks(int processId, String typeId)	Deletes tasks by process and type
List<Task>	getScheduledTasks(int limit)	Returns a list of tasks scheduled for execution
void	searchTasks(Pageable<Task> result, int processId, int typeId, boolean onlyOpen)	Returns a list of tasks filtered by process and type
void	updateTask(Task task)	Adds a new task (id <= 0), or updates the execution date and log of an existing one

Methods inherited from class CommonDAO

deleteById, foundRows, getById, getGroupedIds, getGroupedIds, getIds, getIds, getPageLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, update, updateColumn, updateIds, updateIds, updateOrInsert

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

TaskDAO

public TaskDAO(Connection con)

Method Details

searchTasks

public void searchTasks(Pageable<Task> result,
 int processId,
 int typeId,
 boolean onlyOpen)
                 throws SQLException

Returns a list of tasks filtered by process and type

Parameters:

processId - the required process filter

typeId - if > 0, filter by process type

onlyOpen - only not executed ones

Throws:

SQLException

getScheduledTasks

public List<Task> getScheduledTasks(int limit)
                             throws SQLException

Returns a list of tasks scheduled for execution

Parameters:

limit - the max count

Returns:

the scheduled tasks

Throws:

SQLException

updateTask

public void updateTask(Task task)
                throws SQLException

Adds a new task (id <= 0), or updates the execution date and log of an existing one

Parameters:

task - the task

Throws:

SQLException

deleteTasks

public void deleteTasks(int processId,
 String typeId)
                 throws SQLException

Deletes tasks by process and type

Parameters:

processId - the process ID

typeId - the type ID

Throws:

SQLException