public function getCustomListElements()
{
if (SubscriberGroupQuery::create()->count() > 0) {
return array(array('id' => CriteriaListWidgetDelegate::SELECT_ALL, 'readable_name' => TranslationPeer::getString('wns.subscriber_group.select_all_title'), 'magic_column' => 'all'), array('id' => CriteriaListWidgetDelegate::SELECT_WITHOUT, 'readable_name' => TranslationPeer::getString('wns.subscriber_group.select_without_title'), 'magic_column' => 'without'));
}
return array();
}
public function saveData($aSubscriberGroupData)
{
if ($this->iSubscriberGroupId) {
$oSubscriberGroup = SubscriberGroupQuery::create()->findPk($this->iSubscriberGroupId);
} else {
$oSubscriberGroup = new SubscriberGroup();
$oSubscriberGroup->setCreatedBy(Session::getSession()->getUserId());
$oSubscriberGroup->setCreatedAt(date('c'));
}
$oSubscriberGroup->setName($aSubscriberGroupData['name']);
$oSubscriberGroup->setDisplayName($aSubscriberGroupData['display_name'] == null ? null : $aSubscriberGroupData['display_name']);
$this->validate($aSubscriberGroupData);
if (!Flash::noErrors()) {
throw new ValidationException();
}
$oSubscriberGroup->save();
$oResult = new stdClass();
$oResult->id = $oSubscriberGroup->getId();
if ($this->iSubscriberGroupId === null) {
$oResult->inserted = true;
} else {
$oResult->updated = true;
}
$this->iSubscriberGroupId = $oResult->id;
return $oResult;
}
public function subscriberGroups()
{
$aSubscriberGroups = SubscriberGroupQuery::create()->orderByName()->select(array('Id', 'Name'))->find()->toKeyValue('Id', 'Name');
// @todo: handle external mail groups
// FilterModule::getFilters()->handleMailGroups(&$aSubscriberGroups));
return $aSubscriberGroups;
}
public function getSubscriberGroups()
{
if (SubscriberGroupQuery::create()->count() === 0) {
$oSubscriberGroup = new SubscriberGroup();
$oSubscriberGroup->setName(TranslationPeer::getString('wns.subscriber_group.default.name'));
$oSubscriberGroup->setDisplayName(TranslationPeer::getString('wns.subscriber_group.default.display_name'));
$oSubscriberGroup->save();
}
return SubscriberGroupQuery::create()->select(array('Id', 'Name'))->orderByName()->find()->toKeyValue('Id', 'Name');
}
public function getSubscriberGroupName()
{
if (is_numeric($this->oDelegateProxy->getSubscriberGroupId())) {
$oSubscriberGroup = SubscriberGroupQuery::create()->findPk($this->oDelegateProxy->getSubscriberGroupId());
if ($oSubscriberGroup) {
return $oSubscriberGroup->getName();
}
}
if ($this->oDelegateProxy->getSubscriberGroupId() === CriteriaListWidgetDelegate::SELECT_WITHOUT) {
return TranslationPeer::getString('wns.subscriber_group.without');
}
return $this->oDelegateProxy->getSubscriberGroupId();
}
public function listMailGroups($bIncludeExternalMailGroups = true, $bIncludeGeneratedMailGroups = true)
{
// Get subscriber groups with membership count in not used for subscriber import
$bUsedForSubscriberImport = $bIncludeExternalMailGroups === false && ($bIncludeGeneratedMailGroups = false);
$oQuery = SubscriberGroupQuery::create()->excludeTemporary($bIncludeGeneratedMailGroups)->orderByName();
$aMailGroups = array();
foreach ($oQuery->find() as $oSubscriberGroup) {
$sId = (string) $oSubscriberGroup->getId();
$aMailGroups[$sId] = $oSubscriberGroup->getName() . (!$bUsedForSubscriberImport ? ' (' . $oSubscriberGroup->countSubscriberGroupMemberships() . ')' : '');
}
// If filter is implemented in project this allows to add on-the-fly mail groups
// E.g. a group of recipients that have registered for an event and there for create a temporary mail group
if ($bIncludeExternalMailGroups) {
FilterModule::getFilters()->handleMailGroups(array(&$aMailGroups));
}
return $aMailGroups;
}
/**
* newsletterSubscribe()
*
* @param int/array subscriber group
*
* Description
* • validate post subscribe action
* • process post and display confirm message
*
* @return Template object
*/
private function newsletterSubscribe($mSubscriberGroupId)
{
/**
* @todo: consider array to become scalar as there is no need for multiple values, or is there?
* could this subscribe form provide also multiple (checkboxes) subscriptions?
*/
if (is_array($mSubscriberGroupId) && count($mSubscriberGroupId) > 0) {
$mSubscriberGroupId = $mSubscriberGroupId[0];
}
if (!SubscriberGroupQuery::create()->findPk($mSubscriberGroupId)) {
throw new Exception(__CLASS__ . ': configured subscriber_group_id ' . $mSubscriberGroupId . ' does not exist!');
}
$oTemplate = $this->constructTemplate("newsletter_subscribe");
// Process form
if (Manager::isPost() && isset($_POST['newsletter_subscribe'])) {
$this->processSubscribe($mSubscriberGroupId, $oTemplate);
}
return $oTemplate;
}
private function getNewsletterMailings()
{
$aResult = array();
$aSubscriberGroups = SubscriberGroupQuery::create()->distinct()->joinNewsletterMailing(null, Criteria::INNER_JOIN)->orderByName()->find();
foreach ($aSubscriberGroups as $oSubscriberGroup) {
$aNewsletterMailing = NewsletterMailingQuery::create()->filterByNewsletterId($this->iNewsletterId)->orderByCreatedAt(Criteria::DESC)->filterBySubscriberGroup($oSubscriberGroup)->find();
$iCountMailings = count($aNewsletterMailing);
$bHasMailing = $iCountMailings > 0;
if ($bHasMailing) {
$aSubscriberGroup = array('UserInitials' => array(), 'DateSent' => array(), 'RecipientCount' => array());
foreach ($aNewsletterMailing as $i => $oNewsletterMailing) {
$sAdditionalMailingCount = '';
// Fill Groupname only once
if ($i === 0) {
if ($oNewsletterMailing->getSubscriberGroupName()) {
$aSubscriberGroup['MailGroupName'] = $oNewsletterMailing->getSubscriberGroupName();
$aSubscriberGroup['MailGroupType'] = TranslationPeer::getString('wns.mail_group.subscribers');
} else {
$aSubscriberGroup['MailGroupName'] = $oNewsletterMailing->getMailGroupId();
$aSubscriberGroup['MailGroupType'] = TranslationPeer::getString('wns.mail_group.external');
}
if ($iCountMailings - 1 > 0) {
$sAdditionalMailingCount = ' (+' . ($iCountMailings - 1) . ')';
}
} else {
continue;
}
// Fill all mailing infos
$aSubscriberGroup['UserInitials'][] = $oNewsletterMailing->getUserRelatedByCreatedBy() ? $oNewsletterMailing->getUserRelatedByCreatedBy()->getInitials() : '';
$aSubscriberGroup['DateSent'][] = $oNewsletterMailing->getDateSentFormatted('H:i') . $sAdditionalMailingCount;
$aSubscriberGroup['RecipientCount'][] = $oNewsletterMailing->getRecipientCount();
$aSubscriberGroup['CountAdditionalMailings'] = null;
}
$aResult[] = $aSubscriberGroup;
}
}
return $aResult;
}
/**
* Get the associated SubscriberGroup object
*
* @param PropelPDO $con Optional Connection object.
* @param $doQuery Executes a query to get the object if required
* @return SubscriberGroup The associated SubscriberGroup object.
* @throws PropelException
*/
public function getSubscriberGroup(PropelPDO $con = null, $doQuery = true)
{
if ($this->aSubscriberGroup === null && $this->subscriber_group_id !== null && $doQuery) {
$this->aSubscriberGroup = SubscriberGroupQuery::create()->findPk($this->subscriber_group_id, $con);
/* The following can be used additionally to
guarantee the related object contains a reference
to this object. This level of coupling may, however, be
undesirable since it could result in an only partially populated collection
in the referenced object.
$this->aSubscriberGroup->addNewsletterMailings($this);
*/
}
return $this->aSubscriberGroup;
}
/**
* Returns a new SubscriberGroupQuery object.
*
* @param string $modelAlias The alias of a model in the query
* @param SubscriberGroupQuery|Criteria $criteria Optional Criteria to build the query from
*
* @return SubscriberGroupQuery
*/
public static function create($modelAlias = null, $criteria = null)
{
if ($criteria instanceof SubscriberGroupQuery) {
return $criteria;
}
$query = new SubscriberGroupQuery(null, null, $modelAlias);
if ($criteria instanceof Criteria) {
$query->mergeWith($criteria);
}
return $query;
}
/**
* Removes this object from datastore and sets delete attribute.
*
* @param PropelPDO $con
* @return void
* @throws PropelException
* @throws Exception
* @see BaseObject::setDeleted()
* @see BaseObject::isDeleted()
*/
public function delete(PropelPDO $con = null)
{
if ($this->isDeleted()) {
throw new PropelException("This object has already been deleted.");
}
if ($con === null) {
$con = Propel::getConnection(SubscriberGroupPeer::DATABASE_NAME, Propel::CONNECTION_WRITE);
}
$con->beginTransaction();
try {
$deleteQuery = SubscriberGroupQuery::create()->filterByPrimaryKey($this->getPrimaryKey());
$ret = $this->preDelete($con);
// denyable behavior
if (!(SubscriberGroupPeer::isIgnoringRights() || $this->mayOperate("delete"))) {
throw new PropelException(new NotPermittedException("delete.by_role", array("role_key" => "subscriber_groups")));
}
if ($ret) {
$deleteQuery->delete($con);
$this->postDelete($con);
$con->commit();
$this->setDeleted(true);
} else {
$con->commit();
}
} catch (Exception $e) {
$con->rollBack();
throw $e;
}
}