ru.bgcrm.dao.process

Class QueueDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.process.QueueDAO

public class QueueDAO
extends CommonDAO

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_LEFT_JOIN, SQL_LIMIT, 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

Methods

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, java.lang.String title)
void	updateQueue(Queue queue, int user)

Methods inherited from class ru.bgcrm.dao.CommonDAO

addLikeSql, convertDateToSqlDate, convertDateToTimestamp, deleteById, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePattern, getMySQLLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, 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,
               java.lang.String title)
                 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