function fetchNewsletterBounceCountGroupedByAddress() { return array('result' => eZBounce::count(eZBounce::definition(), null, "DISTINCT ADDRESS")); }
static function fetchAddress($id, $asObject = true) { $bounce = eZPersistentObject::fetchObject(eZBounce::definition(), null, array('address' => $id)); return $bounce; }
function handleBounce($type, $id, $bounceType) { $previousBounce = eZBounce::fetchObject(eZBounce::definition(), null, array('newslettersenditem_id' => $id, 'bounce_type' => $bounceType), true); if ($previousBounce) { //Update the bounce count for this mailling $previousCount = $previousBounce->attribute('bounce_count'); $previousBounce->setAttribute('bounce_count', ++$previousCount); $previousBounce->setAttribute('bounce_message', $type['bounce_message']); $previousBounce->store(); $sendItem = eZSendNewsletterItem::fetch($id, true); if ($sendItem) { if ($bounceType == EZSOFTBOUNCE && $previousCount < $bounceCountStop) { $sendItem->setAttribute('send_status', eZSendNewsletterItem::SendStatusNone); $sendItem->store(); } $subscriptionObject = eZSubscription::fetch($sendItem->attribute('subscription_id')); if ($subscriptionObject) { $bounce_count = $subscriptionObject->attribute('bounce_count'); $subscriptionObject->setAttribute('bounce_count', ++$bounce_count); $subscriptionObject->store(); } } } else { //We create a new bounce entry $db = eZDB::instance(); $db->begin(); $bounceData = new eZBounce(array()); $bounceData->store(); $bounceData->setAttribute('address', $type['address']); $bounceData->setAttribute('bounce_type', $bounceType); $bounceData->setAttribute('bounce_count', 1); $bounceData->setAttribute('bounce_arrived', $type['bounce_arrived']); $bounceData->setAttribute('newslettersenditem_id', $id); $bounceData->setAttribute('bounce_message', $type['bounce_message']); $bounceData->store(); $db->commit(); //Update the sendnewsletteritem table with reference to this bounce entry $sendItem = eZSendNewsletterItem::fetch($id, true); if ($sendItem) { $current_bounceID = $sendItem->attribute('bounce_id'); if ($current_bounceID == 0) { $sendItem->setAttribute('bounce_id', $bounceData->attribute('id')); $sendItem->store(); } else { eZDebug::writeNotice("Bounce ID already in place", 'check_bounce'); } if ($bounceType == EZSOFTBOUNCE) { $sendItem->setAttribute('send_status', eZSendNewsletterItem::SendStatusNone); $sendItem->store(); } //Set the bounce count for the matching subscription_id directly in the subscription table $subscription_id = $sendItem->attribute('subscription_id'); $subscriptionObject = eZSubscription::fetch($subscription_id); if ($subscriptionObject) { $bounce_count = $subscriptionObject->attribute('bounce_count'); $subscriptionObject->setAttribute('bounce_count', ++$bounce_count); $subscriptionObject->store(); } } } }