/** * Saves a sent email into the database. * * @param Conjoon_Modules_Groupware_Email_Draft $message * @param Conjoon_Modules_Groupware_Email_Account $account * @param integer $userId * @param Conjoon_Mail_Sent $mailSent * @param string $type * @param integer $referencesId The id of the email that was refernced sending this * message. This argument will only be taken into account if $type euqals to * reply or reply_all * @param array $postedAttachments * @param array $removeAttachmentIds * * @return array the data from groupware_email_item associated with * the newly saved entry */ public function saveSentEmail(Conjoon_Modules_Groupware_Email_Draft $message, Conjoon_Modules_Groupware_Email_Account $account, $userId, Conjoon_Mail_Sent $mailSent, $type = "", $referencesId = -1, $postedAttachments = array(), $removeAttachmentIds = array()) { $mail = $mailSent->getMailObject(); $userId = (int) $userId; $accountId = (int) $account->getId(); $messageId = (int) $message->getId(); $referenceId = $referencesId <= 0 ? 0 : $referencesId; if ($userId <= 0 || $accountId <= 0) { return array(); } $referencesModel = new Conjoon_Modules_Groupware_Email_Item_Model_References(); $emailRecipientsFilter = new Conjoon_Filter_EmailRecipients(); $emailRecipientsToStringFilter = new Conjoon_Filter_EmailRecipientsToString(); $outboxModel = new Conjoon_Modules_Groupware_Email_Item_Model_Outbox(); $folderModel = new Conjoon_Modules_Groupware_Email_Folder_Model_Folder(); // first check the folder type of the email $folderId = $message->getGroupwareEmailFoldersId(); $messageType = 'scratch'; // negative/0, means the message was created from draft if ($folderId <= 0) { $messageType = 'scratch'; } else { // anything else needs the meta info type fetched out of the folder model $metaInfo = $folderModel->getMetaInfo($folderId); switch ($metaInfo) { case Conjoon_Modules_Groupware_Email_Folder_Model_Folder::META_INFO_OUTBOX: $messageType = 'outbox'; break; case Conjoon_Modules_Groupware_Email_Folder_Model_Folder::META_INFO_DRAFT: $messageType = 'draft'; break; // anything else is probably a reply or forward to an existing message in any other // folder // anything else is probably a reply or forward to an existing message in any other // folder default: $messageType = 'scratch'; break; } } // adjust the message type depending on the type if ($type == 'reply' || $type == 'reply_all' || $type == 'forward') { $messageType = 'scratch'; } // prefill update/insert arrays $sentFolderId = $folderModel->getSentFolder($accountId, $userId); $date = new Zend_Date($mail->getDate(), Zend_Date::RFC_2822); $replyTo = (string) $mail->getReplyTo(); $to = $message->getTo(); $cc = $message->getCc(); $bcc = $message->getBcc(); $fromAddress = new Conjoon_Modules_Groupware_Email_Address(array($account->getAddress(), $account->getUserName())); $toString = array(); foreach ($to as $recipient) { $toString[] = $recipient->__toString(); } $toString = implode(', ', $toString); $ccString = array(); foreach ($cc as $recipient) { $ccString[] = $recipient->__toString(); } $ccString = implode(', ', $ccString); $bccString = array(); foreach ($bcc as $recipient) { $bccString[] = $recipient->__toString(); } $bccString = implode(', ', $bccString); $outboxUpdate = array('sent_timestamp' => time(), 'raw_header' => $mailSent->getSentHeaderText(), 'raw_body' => $mailSent->getSentBodyText(), 'groupware_email_accounts_id' => $message->getGroupwareEmailAccountsId()); /** * @see Conjoon_Filter_DateToUtc */ require_once 'Conjoon/Filter/DateToUtc.php'; $filterToUtc = new Conjoon_Filter_DateToUtc(); $itemUpdate = array('reply_to' => $replyTo, 'from' => $fromAddress->__toString(), 'recipients' => $emailRecipientsToStringFilter->filter($emailRecipientsFilter->filter(array($toString, $ccString, $bccString))), 'sender' => $emailRecipientsToStringFilter->filter($emailRecipientsFilter->filter(array($fromAddress->__toString()))), 'groupware_email_folders_id' => $sentFolderId, 'date' => $filterToUtc->filter($date->get(Zend_Date::ISO_8601))); switch ($messageType) { // if the message was sent from an opened draft or from the outbox, // we simply can create a new entry in the tables, // as if it was created from scratch // if, however, the email was sent from drafts, a user might have updated // the addresses, the subject, the email text and the attachments. // those fields have to be updated in the datastorage as well case 'draft': Conjoon_Util_Array::apply($itemUpdate, array('subject' => $message->getSubject(), 'to' => $toString, 'cc' => $ccString, 'bcc' => $bccString, 'content_text_plain' => $message->getContentTextPlain(), 'content_text_html' => $message->getContentTextHtml())); $this->saveAttachmentsForDraft($message, $postedAttachments, $removeAttachmentIds); // most simple: mesageType is outbox which means we have simply to update a few fields // most simple: mesageType is outbox which means we have simply to update a few fields case 'outbox': if ($messageId <= 0 || $sentFolderId == 0) { return array(); } // the message might have referenced an item when it was created. // look up entry in reference table and set this to is_pending = false $referencesWhere = $referencesModel->getAdapter()->quoteInto('groupware_email_items_id = ?', $messageId) . ' AND ' . $referencesModel->getAdapter()->quoteInto('user_id = ?', $userId); $referencesModel->update(array('is_pending' => 0), $referencesWhere); $outboxWhere = $outboxModel->getAdapter()->quoteInto('groupware_email_items_id = ?', $messageId); $outboxModel->update($outboxUpdate, $outboxWhere); $itemWhere = $this->getAdapter()->quoteInto('id = ?', $messageId); $this->update($itemUpdate, $itemWhere); return $this->getItemForUser($messageId, $userId); break; // if the message was created from scratch, i.e. has no id and no folderId, // save a fresh row into the tables groupware_email_items_id, groupware_email_items_flags, // groupware_email_items_outbox // if the message was created from scratch, i.e. has no id and no folderId, // save a fresh row into the tables groupware_email_items_id, groupware_email_items_flags, // groupware_email_items_outbox case 'scratch': Conjoon_Util_Array::apply($itemUpdate, array('subject' => $message->getSubject(), 'to' => $toString, 'cc' => $ccString, 'bcc' => $bccString, 'in_reply_to' => $message->getInReplyTo(), 'references' => $message->getReferences(), 'content_text_plain' => $message->getContentTextPlain(), 'content_text_html' => $message->getContentTextHtml())); $messageId = (int) $this->insert($itemUpdate); if ($messageId <= 0) { return array(); } $flagModel = new Conjoon_Modules_Groupware_Email_Item_Model_Flag(); $referenceType = ''; if (($type == Conjoon_Modules_Groupware_Email_Keys::REFERENCE_TYPE_REPLY || $type == Conjoon_Modules_Groupware_Email_Keys::REFERENCE_TYPE_REPLY_ALL || $type == Conjoon_Modules_Groupware_Email_Keys::REFERENCE_TYPE_FORWARD) && $referenceId != 0) { $referenceType = $type; $referenceUpdate = array('groupware_email_items_id' => $messageId, 'user_id' => $userId, 'reference_items_id' => $referenceId, 'reference_type' => $referenceType); $referencesModel->insert($referenceUpdate); } $flagUpdate = array('groupware_email_items_id' => $messageId, 'user_id' => $userId, 'is_read' => 1, 'is_spam' => 0, 'is_deleted' => 0); $flagModel->insert($flagUpdate); Conjoon_Util_Array::apply($outboxUpdate, array('groupware_email_items_id' => $messageId)); $outboxModel->insert($outboxUpdate); $message->setId($messageId); $this->saveAttachmentsForDraft($message, $postedAttachments, $removeAttachmentIds); return $this->getItemForUser($messageId, $userId); break; } return null; }
public function getProcessedData() { $data = parent::getProcessedData(); $data['contentTextHtml'] = ""; switch ($this->_context) { case self::CONTEXT_NEW: $name = $data['name']; $address = $data['address']; unset($data['name']); unset($data['type']); unset($data['address']); $data['to'] = array(); if ($address != "") { /** * @see Conjoon_Modules_Groupware_Email_Address */ require_once 'Conjoon/Modules/Groupware/Email/Address.php'; if ($name === $address) { $data['to'] = array(new Conjoon_Modules_Groupware_Email_Address(array($address))); } else { /** * @see Conjoon_Filter_EmailRecipientsToString */ require_once 'Conjoon/Filter/EmailRecipientsToString.php'; $recipientToStringFilter = new Conjoon_Filter_EmailRecipientsToString(); $str = $recipientToStringFilter->filter(array(array($address, $name))); $data['to'] = array(new Conjoon_Modules_Groupware_Email_Address(array($address, $str))); } } return $data; break; case self::CONTEXT_REPLY: if (!empty($data['replyTo'])) { $data['to'] = $data['replyTo']; } else { $data['to'] = $data['from']; } $data['cc'] = array(); $data['bcc'] = array(); break; case self::CONTEXT_REPLY_ALL: $data['userEmailAddresses'] = (array) $data['userEmailAddresses']; $merge = array(); for ($i = 0, $len = max(count($data['cc']), count($data['to'])); $i < $len; $i++) { if (isset($data['cc'][$i]) && !in_array($data['cc'][$i][0], $data['userEmailAddresses'])) { $merge[] = $data['cc'][$i]; } if (isset($data['to'][$i]) && !in_array($data['to'][$i][0], $data['userEmailAddresses'])) { $merge[] = $data['to'][$i]; } } $data['cc'] = $merge; if (!empty($data['replyTo'])) { $data['to'] = $data['replyTo']; } else { $data['to'] = $data['from']; } break; case self::CONTEXT_EDIT: break; case self::CONTEXT_FORWARD: $data['inReplyTo'] = ""; $data['bcc'] = array(); break; } // unsetting is now donw in the controller //unset($data['userEmailAddresses']); //unset($data['from']); //unset($data['replyTo']); /** * @see Conjoon_Filter_QuoteToBlockquote */ require_once 'Conjoon/Filter/QuoteToBlockquote.php'; /** * @see Conjoon_Filter_NormalizeLineFeeds */ require_once 'Conjoon/Filter/NormalizeLineFeeds.php'; /** * @see Conjoon_Filter_PlainToHtml */ require_once 'Conjoon/Filter/PlainToHtml.php'; /** * @see Conjoon_Filter_SignatureStrip */ require_once 'Conjoon/Filter/SignatureStrip.php'; $signatureStripper = new Conjoon_Filter_SignatureStrip(); $quoteFilter = new Conjoon_Filter_QuoteToBlockquote(); $lineFeedFilter = new Conjoon_Filter_NormalizeLineFeeds(); $plainToHtmlFilter = new Conjoon_Filter_PlainToHtml(); $data['contentTextPlain'] = $signatureStripper->filter($lineFeedFilter->filter($data['contentTextPlain'])); // if signature stripper returned empty messagem, return the data if (trim($data['contentTextPlain']) == "") { $data['contentTextPlain'] = trim($data['contentTextPlain']); return $data; } $startTag = ""; $endTag = ""; switch ($this->_context) { case self::CONTEXT_REPLY: case self::CONTEXT_REPLY_ALL: $startTag = "<blockquote>"; $endTag = "</blockquote>"; break; } /** * @see \Conjoon_Text_Transformer_Mail_EmailAddressToHtmlTransformer */ require_once 'Conjoon/Text/Transformer/Mail/EmailAddressToHtmlTransformer.php'; $transformer = new \Conjoon_Text_Transformer_Mail_EmailAddressToHtmlTransformer(); /** * @see \Conjoon_Filter_UrlToATag */ require_once 'Conjoon/Filter/UrlToATag.php'; $urlFilter = new \Conjoon_Filter_UrlToATag(array('target' => '_blank')); /** * @see \Conjoon\Text\Transformer\Html\SanitizeOpeningBracketForLinkTransformer */ require_once 'Conjoon/Text/Transformer/Html/SanitizeOpeningBracketForLinkTransformer.php'; $openingBracketForLinkTransformer = new \Conjoon\Text\Transformer\Html\SanitizeOpeningBracketForLinkTransformer(); $data['contentTextPlain'] = $startTag . $openingBracketForLinkTransformer->transform($transformer->transform($plainToHtmlFilter->filter($quoteFilter->filter($urlFilter->filter($data['contentTextPlain']))))) . $endTag; return $data; }
public function getProcessedData() { $data = parent::getProcessedData(); if ($this->_context == self::CONTEXT_DELETE || $this->_context == self::CONTEXT_MOVE) { return $data; } $recs = array($data['to'], $data['cc'], $data['bcc']); /** * @see Conjoon_Filter_EmailRecipients */ require_once 'Conjoon/Filter/EmailRecipients.php'; /** * @see Conjoon_Filter_EmailRecipientsToString */ require_once 'Conjoon/Filter/EmailRecipientsToString.php'; $emailRecipientsFilter = new Conjoon_Filter_EmailRecipients(); $emailSenderFilter = new Conjoon_Filter_EmailRecipients(false, false); $emailRecipientsToStringFilter = new Conjoon_Filter_EmailRecipientsToString(); $emailSenderToStringFilter = new Conjoon_Filter_EmailRecipientsToString(false); $data['recipients'] = $emailRecipientsToStringFilter->filter($emailRecipientsFilter->filter($recs)); // it should be safe to store the sender without additional slashes $data['sender'] = $emailSenderToStringFilter->filter($emailSenderFilter->filter($data['from'])); return $data; }