Package ru.bgcrm.dao

Class NewsDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.NewsDAO

public class NewsDAO
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
NewsDAO(Connection con)

Method Summary

Modifier and Type	Method	Description
void	deleteExpiredNews()
void	deleteInvalidUserLinks()
void	deleteNews(int newsId)
void	deleteNewsUser(int newsId)
void	deleteOrphanNewsLinks()
@Nullable News	getNews(int newsId)
Set<Integer>	getNewsUserIds(int newsId)
void	markExpiredAsRead()
void	searchNewsList(SearchResult<News> searchResult, int userId, Boolean read, String text)
void	setNewsAllRead(int userId)
void	setNewsRead(int newsId, int userId, boolean value)
int	updateNews(News news)
void	updateNewsGroups(News news, Set<Integer> groupIds)
void	updateNewsUser(int newsId, int userId)
void	updateNewsUser(int newsId, Set<Integer> userIds)
void	updateNewsUsers(News news, Set<Integer> userIds)

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

NewsDAO

public NewsDAO(Connection con)

Method Details

getNews

@Nullable
public @Nullable News getNews(int newsId)
                       throws BGException

Throws:

BGException

getNewsUserIds

public Set<Integer> getNewsUserIds(int newsId)
                            throws BGException

Throws:

BGException

searchNewsList

public void searchNewsList(SearchResult<News> searchResult,
 int userId,
 Boolean read,
 String text)
                    throws BGException

Throws:

BGException

updateNews

public int updateNews(News news)
               throws BGException

Throws:

BGException

updateNewsUsers

public void updateNewsUsers(News news,
 Set<Integer> userIds)
                     throws BGException

Throws:

BGException

updateNewsUser

public void updateNewsUser(int newsId,
 int userId)
                    throws BGException

Throws:

BGException

updateNewsUser

public void updateNewsUser(int newsId,
 Set<Integer> userIds)
                    throws BGException

Throws:

BGException

updateNewsGroups

public void updateNewsGroups(News news,
 Set<Integer> groupIds)
                      throws BGException

Throws:

BGException

setNewsRead

public void setNewsRead(int newsId,
 int userId,
 boolean value)
                 throws BGException

Throws:

BGException

setNewsAllRead

public void setNewsAllRead(int userId)
                    throws BGException

Throws:

BGException

deleteNews

public void deleteNews(int newsId)
                throws BGException

Throws:

BGException

deleteNewsUser

public void deleteNewsUser(int newsId)
                    throws BGException

Throws:

BGException

deleteExpiredNews

public void deleteExpiredNews()
                       throws BGException

Throws:

BGException

deleteOrphanNewsLinks

public void deleteOrphanNewsLinks()
                           throws BGException

Throws:

BGException

deleteInvalidUserLinks

public void deleteInvalidUserLinks()
                            throws BGException

Throws:

BGException

markExpiredAsRead

public void markExpiredAsRead()
                       throws BGException

Throws:

BGException