ru.bgcrm.dao.process

Class QueueDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.process.QueueDAO

public class QueueDAO
extends CommonDAO

Nested Class Summary

Nested classes/interfaces inherited from class ru.bgcrm.dao.CommonDAO

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

Field Summary

Fields inherited from class ru.bgcrm.dao.CommonDAO

con, dateFormat_DDMMYYYY, dateFormat_DDMMYYYY_HHMM, log, SQL_AND, SQL_DELETE, SQL_DESC, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT, SQL_INSERT_IGNORE, SQL_LEFT_JOIN, SQL_LEFT_OUTER_JOIN, SQL_LIMIT, SQL_ON_DUP_KEY_UPDATE, SQL_OR, SQL_ORDER_BY, SQL_REPLACE, SQL_SELECT, SQL_SELECT_ALL_FROM, SQL_SELECT_COUNT_ROWS, SQL_SET, SQL_UPDATE, SQL_WHERE

Constructor Summary

Constructors

Constructor and Description
QueueDAO(java.sql.Connection con)

Method Summary

Modifier and Type	Method and Description
void	delete(int id)
Queue	getQueue(int id)
java.util.List<Queue>	getQueueList()
java.util.List<QueueProcessStat>	getQueueProcessStat(Queue queue)
java.util.Set<java.lang.Integer>	getQueueProcessTypeIds(int id)
QueueStat	getQueueStat(Queue queue, java.lang.String userIds)
java.util.List<QueueUserStat>	getQueueUserStat(Queue queue, java.lang.String userIds)
void	searchQueue(SearchResult<Queue> searchResult, java.util.Set<java.lang.Integer> queueIds, int queueId, java.lang.String filter, int typeId)
void	updateQueue(Queue queue, int user)

Methods inherited from class ru.bgcrm.dao.CommonDAO

deleteById, execute, execute, execute, executeInsert, executeUpdate, getById, getFoundRows, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePattern, getLikePatternEnd, getLikePatternStart, getLikePatternSub, getMySQLLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, update, updateColumn, updateIds, updateIds

Methods inherited from class java.lang.Object

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

Constructor Detail

QueueDAO

public QueueDAO(java.sql.Connection con)

Method Detail

searchQueue

public void searchQueue(SearchResult<Queue> searchResult,
                        java.util.Set<java.lang.Integer> queueIds,
                        int queueId,
                        java.lang.String filter,
                        int typeId)
                 throws java.sql.SQLException

Throws:

java.sql.SQLException

getQueueList

public java.util.List<Queue> getQueueList()
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

getQueue

public Queue getQueue(int id)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

updateQueue

public void updateQueue(Queue queue,
                        int user)
                 throws BGException

Throws:

BGException

getQueueProcessTypeIds

public java.util.Set<java.lang.Integer> getQueueProcessTypeIds(int id)
                                                        throws BGException

Throws:

BGException

getQueueStat

public QueueStat getQueueStat(Queue queue,
                              java.lang.String userIds)
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

getQueueProcessStat

public java.util.List<QueueProcessStat> getQueueProcessStat(Queue queue)
                                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

getQueueUserStat

public java.util.List<QueueUserStat> getQueueUserStat(Queue queue,
                                                      java.lang.String userIds)
                                               throws java.sql.SQLException

Throws:

java.sql.SQLException

delete

public void delete(int id)
            throws java.sql.SQLException

Throws:

java.sql.SQLException