/**
  * Statistic data about sending process
  *
  * @return array
  */
 function getSendItemsStatistic()
 {
     $editionSendId = $this->attribute('id');
     $itemsCount = CjwNewsletterEditionSendItem::fetchListBySendIdAndStatusCount($editionSendId, false);
     $itemsNotSend = CjwNewsletterEditionSendItem::fetchListBySendIdAndStatusCount($editionSendId, CjwNewsletterEditionSendItem::STATUS_NEW);
     $itemsSend = CjwNewsletterEditionSendItem::fetchListBySendIdAndStatusCount($editionSendId, CjwNewsletterEditionSendItem::STATUS_SEND);
     $itemsBounced = CjwNewsletterEditionSendItem::fetchBounceCountByEditionSendId($editionSendId);
     $itemsSendInPersent = 0;
     // catch division by zero
     if ($itemsCount > 0) {
         $itemsSendInPersent = round($itemsSend / $itemsCount * 100, 1);
     }
     return array('items_count' => $itemsCount, 'items_not_send' => $itemsNotSend, 'items_send' => $itemsSend, 'items_send_in_percent' => $itemsSendInPersent, 'items_bounced' => $itemsBounced);
 }
 /**
  * saved parsed infos from ezcMailObject into database
  *
  * @param $parsedResult
  */
 private function saveParsedInfos($parsedResult)
 {
     $this->setAttribute('email_from', $parsedResult['from']);
     $this->setAttribute('email_to', $parsedResult['to']);
     $this->setAttribute('email_subject', $parsedResult['subject']);
     $this->setAttribute('bounce_code', $parsedResult['error_code']);
     //$this->setAttribute( 'final_recipient', $parsedResult[ 'final_recipient' ] );
     $this->setAttribute('email_send_date', $this->convertEmailSendDateToTimestamp($parsedResult['email_send_date']));
     // if x-cjwnl-senditem hash was set in bounce mail than fetch some ez data
     if (isset($parsedResult['x-cjwnl-senditem'])) {
         $sendItemHash = $parsedResult['x-cjwnl-senditem'];
         // try to fetch edition send item object
         $sendItemObject = CjwNewsletterEditionSendItem::fetchByHash($sendItemHash, true);
         if (is_object($sendItemObject)) {
             $newsletterUserId = $sendItemObject->attribute('newsletter_user_id');
             $editionSendId = $sendItemObject->attribute('edition_send_id');
             $editionSendItemId = $sendItemObject->attribute('id');
             $this->setAttribute('newsletter_user_id', $newsletterUserId);
             $this->setAttribute('edition_send_id', $editionSendId);
             $this->setAttribute('edition_send_item_id', $editionSendItemId);
             if ($this->isBounce()) {
                 $sendItemObject->setBounced();
                 $newsletterUser = $sendItemObject->attribute('newsletter_user_object');
                 if (is_object($newsletterUser)) {
                     // bounce nl user
                     $isHardBounce = false;
                     $newsletterUser->setBounced($isHardBounce);
                 }
             }
         }
     } elseif (isset($parsedResult['x-cjwnl-user'])) {
         $newsletterUser = CjwNewsletterUser::fetchByHash($sendItemHash, true);
         if (is_object($sendItemObject)) {
             $newsletterUserId = $newsletterUser->attribute('id');
             $this->setAttribute('newsletter_user_id', $newsletterUserId);
             if ($this->isBounce()) {
                 // bounce nl user
                 $isHardBounce = false;
                 $newsletterUser->setBounced($isHardBounce);
             }
         }
     }
     CjwNewsletterLog::writeDebug('parse_result CjwNewsletterMailboxItem::saveParsedInfos', 'mailbox_item', $this->attribute('id'), $parsedResult);
     // item is parsed
     $this->setAttribute('processed', time());
     $this->store();
 }
 /**
  *
  * @param integer $newsletterUserId
  * @return array
  */
 static function fetchEditonSendItemListCount($newsletterUserId)
 {
     $count = CjwNewsletterEditionSendItem::fetchListByNewsletterIdCount($newsletterUserId);
     return array('result' => $count);
 }
Esempio n. 4
0
 /**
  * This should be called if a user is bounced or blacklisted
  * all related subscriptions and active senditems will be updated
  *
  * @param $status
  * @return unknown_type
  */
 private function setAllNewsletterUserRelatedItemsToStatus($status)
 {
     $newsletterUserId = $this->attribute('id');
     $updateSubcriptions = false;
     switch ($status) {
         case CjwNewsletterSubscription::STATUS_BOUNCED_SOFT:
         case CjwNewsletterSubscription::STATUS_BOUNCED_HARD:
             $bounceCount = CjwNewsletterEditionSendItem::setAllActiveItemsToStatusAbortAndBouncedByNewsletterUserId($newsletterUserId);
             $updateSubcriptions = true;
             break;
         case CjwNewsletterSubscription::STATUS_BLACKLISTED:
             // update active senditems
             $abortCount = CjwNewsletterEditionSendItem::setAllActiveItemsToStatusAbortByNewsletterUserId($newsletterUserId);
             $updateSubcriptions = true;
             break;
     }
     if ($updateSubcriptions === true) {
         // update active subscriptions
         $activeSubscriptionList = CjwNewsletterSubscription::fetchListNotRemovedOrBlacklistedByNewsletterUserId($newsletterUserId, true);
         foreach ($activeSubscriptionList as $subscription) {
             if ($subscription->attribute('status') == $status) {
                 CjwNewsletterLog::writeDebug('skip - already set this status - CjwNewsletterUser::setAllNewsletterUserRelatedItemsToStatus', 'subscription', 'status', array('status' => $status, 'subscription_id' => $subscription->attribute('id'), 'nl_user' => $newsletterUserId));
             } else {
                 $subscription->setAttribute('status', $status);
                 $subscription->store();
                 /*    CjwNewsletterLog::writeDebug(
                        'set CjwNewsletterUser::setAllNewsletterUserRelatedItemsToStatus',
                       'subscription',
                       'status',
                       array( 'status' => $status,
                       'subscription_id' => $subscription->attribute('id'),
                       'nl_user' => $newsletterUserId ) );
                       */
             }
         }
     }
 }
 /**
  * fetcht edition_send_item object from hash code
  *
  * @param string $hashCode
  * @return object / boolean
  */
 public static function fetchByHash($hashCode, $asObject)
 {
     return eZPersistentObject::fetchObject(CjwNewsletterEditionSendItem::definition(), null, array('hash' => $hashCode), $asObject);
 }
         $outputFormatStringArray[$outputFormatId] = CjwNewsletterEdition::prepareImageInclude($outputFormatNewsletterContentArray);
     }
 }
 // embed images ends
 $emailSender = $sendObject->attribute('email_sender');
 $emailSenderName = $sendObject->attribute('email_sender_name');
 $limit = 50;
 $offset = 0;
 $itemCounter = 1;
 $progressMonitor = new ezcConsoleProgressMonitor($output, $itemsNotSend);
 $cjwMail = new CjwNewsletterMail();
 $cjwMail->setTransportMethodCronjobFromIni();
 // process every send_item of current sendobject
 for ($i = 0; $i < $itemsNotSend; $i += $limit) {
     //  $progressBar->advance();
     $sendItemList = CjwNewsletterEditionSendItem::fetchListSendIdAndStatus($editionSendId, CjwNewsletterEditionSendItem::STATUS_NEW, $limit, $offset);
     $count = count($sendItemList);
     foreach ($sendItemList as $sendItem) {
         $id = $sendItem->attribute('id');
         $outputFormatId = $sendItem->attribute('output_format_id');
         // ### get newsletter user data through send_item_object
         $newsletterUserObject = $sendItem->attribute('newsletter_user_object');
         $emailReceiver = $newsletterUserObject->attribute('email');
         $emailReceiverName = $newsletterUserObject->attribute('email_name');
         // fetch html & text content of parsed outputxml from senmdobject
         // data of outputformate
         $outputStringArray = $outputFormatStringArray[$outputFormatId]['body'];
         $emailSubject = $outputFormatStringArray[$outputFormatId]['subject'];
         $outputStringArrayNew = array('html' => '', 'text' => '');
         foreach ($outputStringArray as $index => $string) {
             $outputStringArrayNew[$index] = CjwNewsletterUtils::replaceNewsletterMarkers($string, $sendObject, $newsletterUserObject);
 $message = "++ Find SubscriptionObjects with STATUS_APPROVED: " . count($subscriptionObjectList);
 $cli->output($message);
 $counter = 0;
 foreach ($subscriptionObjectList as $subscriptionObject) {
     $subscriptionId = $subscriptionObject->attribute('id');
     $editionContentObjectId = $subscriptionObject->attribute('edition_contentobject_id');
     $newsletterUserId = $subscriptionObject->attribute('newsletter_user_id');
     $subscriptionOutputFormatArray = $subscriptionObject->attribute('output_format_array');
     $counter++;
     // status == STATUS_WAIT_FOR_PROCESS || != ABORT ?
     $newsletterEdtionSendObject->sync();
     if ($newsletterEdtionSendObject->attribute('status') == CjwNewsletterEditionSend::STATUS_WAIT_FOR_PROCESS) {
         // every subscription can have multiple outputformats
         // create for every outputformat one send_item
         foreach ($subscriptionOutputFormatArray as $outputFormatId => $outputFormatName) {
             $newSendItemResult = CjwNewsletterEditionSendItem::create($sendId, $newsletterUserId, $outputFormatId, $subscriptionId);
             if (is_object($newSendItemResult)) {
                 // create edtion_send_item
                 $message = "++ [SEND_ITEM][{$counter}] create new sendItem id: " . $newSendItemResult->attribute('id');
                 $cli->output($message);
             } else {
                 // create edtion_send_item
                 $message = "++ [Error][SEND_ITEM][{$counter}] sendItem already exist do nothing with it!";
                 $cli->output($message);
             }
         }
     } else {
         $message = "++ [ABBORT][{$counter}] Abborting EditionSendObject has not Status STATUS_WAIT_FOR_PROCESS or : " . $sendId;
         $cli->output($message);
     }
 }