public final class NewsLetterDAO extends Object implements INewsLetterDAO
Constructor and Description |
---|
NewsLetterDAO() |
Modifier and Type | Method and Description |
---|---|
boolean |
checkLinkedPortlet(int nIdNewsletter)
Checks whether a portlet uses the newsletter
|
boolean |
checkPrimaryKey(int nKey,
fr.paris.lutece.portal.service.plugin.Plugin plugin)
Check the unicity of the primary key
|
void |
delete(int nNewsLetterId,
fr.paris.lutece.portal.service.plugin.Plugin plugin)
Remove a record from the table
|
void |
deleteOldUnconfirmed(Timestamp confirmLimitDate,
fr.paris.lutece.portal.service.plugin.Plugin plugin)
Performs confirm unsubscription process
|
void |
deleteSubscriber(int nNewsLetterId,
int nSubscriberId,
fr.paris.lutece.portal.service.plugin.Plugin plugin)
Remove the subscriber's inscription to a newsletter
|
void |
insert(NewsLetter newsLetter,
fr.paris.lutece.portal.service.plugin.Plugin plugin)
Insert a new record in the table.
|
void |
insertSubscriber(int nNewsLetterId,
int nSubscriberId,
boolean bValidate,
Timestamp tToday,
fr.paris.lutece.portal.service.plugin.Plugin plugin)
Insert a new subscriber for a newsletter
|
void |
insertSubscriber(int nNewsLetterId,
int nSubscriberId,
Timestamp tToday,
fr.paris.lutece.portal.service.plugin.Plugin plugin)
Insert a new subscriber for a newsletter
|
boolean |
isRegistered(int nNewsLetterId,
int nSubscriberId,
fr.paris.lutece.portal.service.plugin.Plugin plugin)
check if the subscriber is not yet registered to a newsletter
|
boolean |
isTemplateUsed(int nTemplateId,
fr.paris.lutece.portal.service.plugin.Plugin plugin)
controls that a template is used by a newsletter
|
NewsLetter |
load(int nNewsLetterId,
fr.paris.lutece.portal.service.plugin.Plugin plugin)
loads the data of the newsletter from the table
|
int |
newPrimaryKey(fr.paris.lutece.portal.service.plugin.Plugin plugin)
Generate a new primary key to add a newsletter
|
Collection<NewsLetter> |
selectAll(fr.paris.lutece.portal.service.plugin.Plugin plugin)
Select the list of the newsletters available
|
Collection<NewsLetter> |
selectAllByTemplateId(int nTemplateId,
fr.paris.lutece.portal.service.plugin.Plugin plugin)
Gets a collection of NewsLetter associated with a given template
|
fr.paris.lutece.util.ReferenceList |
selectAllId(fr.paris.lutece.portal.service.plugin.Plugin plugin)
Select the list of the newsletters available
|
int |
selectNbrActiveSubscribers(int nNewsLetterId,
String strSearchString,
fr.paris.lutece.portal.service.plugin.Plugin plugin)
Counts the active subscribers for a newsletter
|
int |
selectNbrSubscribers(int nNewsLetterId,
String strSearchString,
fr.paris.lutece.portal.service.plugin.Plugin plugin)
Counts the subscribers for a newsletter
|
void |
store(NewsLetter newsLetter,
fr.paris.lutece.portal.service.plugin.Plugin plugin)
Update the record in the table
|
void |
validateSubscriber(int nNewsLetterId,
int nSubscriberId,
fr.paris.lutece.portal.service.plugin.Plugin plugin)
Updates a subscriber for a newsletter
|
public void insert(NewsLetter newsLetter, fr.paris.lutece.portal.service.plugin.Plugin plugin)
insert
in interface INewsLetterDAO
newsLetter
- the object to insertplugin
- the Pluginpublic void delete(int nNewsLetterId, fr.paris.lutece.portal.service.plugin.Plugin plugin)
delete
in interface INewsLetterDAO
nNewsLetterId
- the newsletter identifierplugin
- the Pluginpublic NewsLetter load(int nNewsLetterId, fr.paris.lutece.portal.service.plugin.Plugin plugin)
load
in interface INewsLetterDAO
nNewsLetterId
- the newsletter identifierplugin
- the Pluginpublic void store(NewsLetter newsLetter, fr.paris.lutece.portal.service.plugin.Plugin plugin)
store
in interface INewsLetterDAO
newsLetter
- the object to be updatedplugin
- the Pluginpublic boolean checkPrimaryKey(int nKey, fr.paris.lutece.portal.service.plugin.Plugin plugin)
checkPrimaryKey
in interface INewsLetterDAO
nKey
- the key to be checkedplugin
- the Pluginpublic boolean checkLinkedPortlet(int nIdNewsletter)
checkLinkedPortlet
in interface INewsLetterDAO
nIdNewsletter
- the id of the newsletterpublic int newPrimaryKey(fr.paris.lutece.portal.service.plugin.Plugin plugin)
newPrimaryKey
in interface INewsLetterDAO
plugin
- the Pluginpublic Collection<NewsLetter> selectAll(fr.paris.lutece.portal.service.plugin.Plugin plugin)
selectAll
in interface INewsLetterDAO
plugin
- the Pluginpublic fr.paris.lutece.util.ReferenceList selectAllId(fr.paris.lutece.portal.service.plugin.Plugin plugin)
selectAllId
in interface INewsLetterDAO
plugin
- the PluginReferenceList
of id and namepublic Collection<NewsLetter> selectAllByTemplateId(int nTemplateId, fr.paris.lutece.portal.service.plugin.Plugin plugin)
selectAllByTemplateId
in interface INewsLetterDAO
nTemplateId
- The id of the templateplugin
- the Pluginpublic void insertSubscriber(int nNewsLetterId, int nSubscriberId, Timestamp tToday, fr.paris.lutece.portal.service.plugin.Plugin plugin)
insertSubscriber
in interface INewsLetterDAO
nNewsLetterId
- the newsletter identifiernSubscriberId
- the subscriber identifiertToday
- The dayplugin
- the Pluginpublic void insertSubscriber(int nNewsLetterId, int nSubscriberId, boolean bValidate, Timestamp tToday, fr.paris.lutece.portal.service.plugin.Plugin plugin)
insertSubscriber
in interface INewsLetterDAO
nNewsLetterId
- the newsletter identifiernSubscriberId
- the subscriber identifierbValidate
- the validation statustToday
- The dayplugin
- the Pluginpublic void deleteSubscriber(int nNewsLetterId, int nSubscriberId, fr.paris.lutece.portal.service.plugin.Plugin plugin)
deleteSubscriber
in interface INewsLetterDAO
nNewsLetterId
- the newsletter identifiernSubscriberId
- the subscriber identifierplugin
- the Pluginpublic void deleteOldUnconfirmed(Timestamp confirmLimitDate, fr.paris.lutece.portal.service.plugin.Plugin plugin)
deleteOldUnconfirmed
in interface INewsLetterDAO
confirmLimitDate
- all unconfirmed subscriber which subscription
date is below confirmLimitDate will be deletedplugin
- the pluginpublic boolean isRegistered(int nNewsLetterId, int nSubscriberId, fr.paris.lutece.portal.service.plugin.Plugin plugin)
isRegistered
in interface INewsLetterDAO
nNewsLetterId
- the newsletter identifiernSubscriberId
- the subscriber identifierplugin
- the Pluginpublic boolean isTemplateUsed(int nTemplateId, fr.paris.lutece.portal.service.plugin.Plugin plugin)
isTemplateUsed
in interface INewsLetterDAO
nTemplateId
- the template identifierplugin
- the Pluginpublic int selectNbrSubscribers(int nNewsLetterId, String strSearchString, fr.paris.lutece.portal.service.plugin.Plugin plugin)
selectNbrSubscribers
in interface INewsLetterDAO
nNewsLetterId
- the newsletter newsletterstrSearchString
- the string to search in the subscriber's emailplugin
- the Pluginpublic int selectNbrActiveSubscribers(int nNewsLetterId, String strSearchString, fr.paris.lutece.portal.service.plugin.Plugin plugin)
selectNbrActiveSubscribers
in interface INewsLetterDAO
nNewsLetterId
- the newsletter newsletterstrSearchString
- the string to search in the subscriber's emailplugin
- the Pluginpublic void validateSubscriber(int nNewsLetterId, int nSubscriberId, fr.paris.lutece.portal.service.plugin.Plugin plugin)
validateSubscriber
in interface INewsLetterDAO
nNewsLetterId
- the newsletter identifiernSubscriberId
- the subscriber identifierplugin
- the PluginCopyright © 2019 City of Paris. All rights reserved.