Package ru.bitel.bgbilling.plugins.organizer.server.dao

Class OrganizerDao

java.lang.Object

ru.bitel.bgbilling.kernel.base.server.logger.BGLogger

ru.bitel.bgbilling.common.dao.AbstractDaoConstant

ru.bitel.bgbilling.plugins.organizer.server.dao.OrganizerDao

public class OrganizerDao
extends ru.bitel.bgbilling.common.dao.AbstractDaoConstant

Field Summary

Fields

Modifier and Type	Field	Description
int	RecordsTotal

Fields inherited from class ru.bitel.bgbilling.common.dao.AbstractDaoConstant

con, ERROR, fields, moduleId, SQL_ALL, SQL_AND, SQL_DELETE, SQL_DISTINCT, SQL_EQ, SQL_EQCS, SQL_FROM, SQL_GROUP, SQL_IN, SQL_INSERT, SQL_JOIN, SQL_LEFT_JOIN, SQL_LIMIT, SQL_NOT_IN, SQL_ON, SQL_ORDER, SQL_SELECT, SQL_SET, SQL_UPDATE, SQL_VALUES, SQL_WHERE, tableName

Constructor Summary

Constructors

Constructor	Description
OrganizerDao(Connection con)

Method Summary

Modifier and Type	Method	Description
void	addToJournal(int rid, int userID, String messageType)
int	countJournalList(Page page, Period per, int uid)
OrganizerCounter	countRecords(int uid)
int	countTotalRecords(RecordFilter filter)
void	deleteRecordById(int rid)
List<JournalEntry>	getJournalList(Page page, Period period, int uid)
OrganizerRecord	getRecordById(int rid)
List<OrganizerRecord>	getRecords(RecordFilter filter)
List<OrganizerRecord>	getTodoRecords(int uid, int status)	Deprecated. Использовать searchTodoRecords(SearchResult, int, int)
String	getUserGroups(int uid)
void	searchTodoRecords(SearchResult<OrganizerRecord> searchResult, int uid, int status)	Постраничный вывод записей
void	updateRecord(OrganizerRecord rec)

Methods inherited from class ru.bitel.bgbilling.common.dao.AbstractDaoConstant

getPeriod, getPlaceholders, getSQLOrder, getSQLOrderFields, getTableName, psSetDate, psSetDateOrNull, psSetInt, psSetIntOrNull, psSetPeriod, psSetString, psSetStringOrNull, psSetTimestampOrNull, queryAndIn, setStatementParam, sqlDelete, sqlDeleteBatch, sqlInsert, sqlInsertBatch, sqlInsertGetId, sqlInsertGetLongId, sqlInsertOnDuplicateKeyUpdate, sqlInsertSelect, sqlInsertUpdateById, sqlSelectCountAsInt, sqlUpdate, sqlUpdateBatch

Methods inherited from class ru.bitel.bgbilling.kernel.base.server.logger.BGLogger

error, error, error, getLogger, logError, logError, warn

Methods inherited from class java.lang.Object

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

Field Details

RecordsTotal

public int RecordsTotal

Constructor Details

OrganizerDao

public OrganizerDao(Connection con)

Method Details

getRecords

public List<OrganizerRecord> getRecords(RecordFilter filter)
                                 throws SQLException

Throws:

SQLException

countTotalRecords

public int countTotalRecords(RecordFilter filter)
                      throws SQLException

Throws:

SQLException

getRecordById

public OrganizerRecord getRecordById(int rid)
                              throws SQLException

Throws:

SQLException

updateRecord

public void updateRecord(OrganizerRecord rec)
                  throws SQLException

Throws:

SQLException

getUserGroups

public String getUserGroups(int uid)
                     throws SQLException

Throws:

SQLException

searchTodoRecords

public void searchTodoRecords(SearchResult<OrganizerRecord> searchResult,
 int uid,
 int status)
                       throws ru.bitel.bgbilling.common.BGException

Постраничный вывод записей

Parameters:

searchResult -

uid -

status -

Throws:

ru.bitel.bgbilling.common.BGException

getTodoRecords

@Deprecated
public List<OrganizerRecord> getTodoRecords(int uid,
 int status)
                                     throws ru.bitel.bgbilling.common.BGException

Deprecated.

Использовать searchTodoRecords(SearchResult, int, int)

Parameters:

uid -

status -

Returns:

Throws:

ru.bitel.bgbilling.common.BGException

countRecords

public OrganizerCounter countRecords(int uid)
                              throws SQLException

Throws:

SQLException

addToJournal

public void addToJournal(int rid,
 int userID,
 String messageType)
                  throws SQLException

Throws:

SQLException

deleteRecordById

public void deleteRecordById(int rid)
                      throws SQLException

Throws:

SQLException

getJournalList

public List<JournalEntry> getJournalList(Page page,
 Period period,
 int uid)
                                  throws SQLException

Throws:

SQLException

countJournalList

public int countJournalList(Page page,
 Period per,
 int uid)
                     throws SQLException

Throws:

SQLException