Package 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	Description
QueueDAO(Connection con)

Method Summary

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

Methods inherited from class ru.bgcrm.dao.CommonDAO

buildPlaceholders, deleteById, execute, execute, execute, executeBatch, 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 Details

QueueDAO

public QueueDAO(Connection con)

Method Details

searchQueue

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

Throws:

SQLException

getQueueList

public List<Queue> getQueueList()
                         throws SQLException

Throws:

SQLException

getQueue

public Queue getQueue(int id)
               throws SQLException

Throws:

SQLException

updateQueue

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

Throws:

BGException

getQueueProcessTypeIds

public Set<Integer> getQueueProcessTypeIds(int id)
                                    throws BGException

Throws:

BGException

getQueueStat

public QueueStat getQueueStat(Queue queue,
 String userIds)
                       throws SQLException

Throws:

SQLException

getQueueProcessStat

public List<QueueProcessStat> getQueueProcessStat(Queue queue)
                                           throws SQLException

Throws:

SQLException

getQueueUserStat

public List<QueueUserStat> getQueueUserStat(Queue queue,
 String userIds)
                                     throws SQLException

Throws:

SQLException

delete

public void delete(int id)
            throws SQLException

Throws:

SQLException