/**
* Imports and adds the items for the requested feed uri and adds them
* to the account specified in $accountId if they do not already exist.
* The account's lastUpdated property will also be set, and the item lists
* cache will be cleaned, if feed items have been actually added.
*
*
* @param integer $accountId
* @param integer $userId
* @param boolean $useReaderCache
* @param boolean $useConditionalGet
*
* @return array Returns an array with the recently added
* Conjoon_Modules_Groupware_Feeds_Item_Dto
*
* @throws Exception
*/
public function importAndAddFeedItems($accountId, $userId, $useReaderCache = false, $useConditionalGet = false)
{
$accountId = (int) $accountId;
$userId = (int) $userId;
if ($accountId <= 0 || $userId <= 0) {
throw new InvalidArgumentException("Invalid argument supplied, accountId was \"{$accountId}\", " . "userId was \"{$userId}\"");
}
$accountDto = $this->_getAccountFacade()->getAccount($accountId, $userId);
$uri = $accountDto->uri;
$requestTimeout = $accountDto->requestTimeout;
/**
* @see Conjoon_Modules_Groupware_Feeds_ImportHelper
*/
require_once 'Conjoon/Modules/Groupware/Feeds/ImportHelper.php';
// get the feeds metadata
try {
$import = Conjoon_Modules_Groupware_Feeds_ImportHelper::importFeedItems($uri, $requestTimeout, $useReaderCache, $useConditionalGet);
} catch (Exception $e) {
Conjoon_Log::log(get_class($this) . "::importAndAddFeedItems could not import " . "feed items from {$uri}: \"" . get_class($e) . "\" - \"" . $e->getMessage() . "\"", Zend_Log::INFO);
// return an empty array, do not delete cache for the account and do not
// update last_updated timestamp!
return array();
}
/**
* @see Conjoon_Modules_Groupware_Feeds_Item_Filter_Item
*/
require_once 'Conjoon/Modules/Groupware/Feeds/Item/Filter/Item.php';
$filter = new Conjoon_Modules_Groupware_Feeds_Item_Filter_Item(array(), Conjoon_Filter_Input::CONTEXT_CREATE);
$itemResponseFilter = new Conjoon_Modules_Groupware_Feeds_Item_Filter_Item(array(), Conjoon_Filter_Input::CONTEXT_RESPONSE);
/**
* @see Conjoon_Util_Array
*/
require_once 'Conjoon/Util/Array.php';
/**
* @see Conjoon_BeanContext_Inspector
*/
require_once 'Conjoon/BeanContext/Inspector.php';
$added = array();
$cCache = false;
foreach ($import as $item) {
$normalized = Conjoon_Modules_Groupware_Feeds_ImportHelper::normalizeFeedItem($item);
$normalized['groupwareFeedsAccountsId'] = $accountId;
$filter->setData($normalized);
try {
$fillIn = $filter->getProcessedData();
} catch (Zend_Filter_Exception $e) {
/**
* @see Conjoon_Error
*/
require_once 'Conjoon/Error.php';
Conjoon_Log::log(Conjoon_Error::fromFilter($filter, $e), Zend_Log::ERR);
continue;
}
$dtoData = $fillIn;
Conjoon_Util_Array::underscoreKeys($fillIn);
$isAdded = $this->_addItemIfNotExists($fillIn, $accountId, false);
if ($isAdded > 0) {
$cCache = true;
$dtoData['id'] = $isAdded;
$dtoData['name'] = $accountDto->name;
$itemResponseFilter->setData($dtoData);
$dtoData = $itemResponseFilter->getProcessedData();
$added[] = Conjoon_BeanContext_Inspector::create('Conjoon_Modules_Groupware_Feeds_Item', $dtoData)->getDto();
}
}
if ($cCache) {
$this->_removeListCacheForAccountIds(array($accountId));
}
$this->_getAccountFacade()->setLastUpdated(array($accountId), time());
return $added;
}
/**
* Updates a single account with the data from $data for the specified
* $userId.
*
* @param integer $accountId the id of the account to update.
* @param Array $data
* @param integer $userId
*
* @return boolean true, if updating the account was successfull, otherwise
* false
*
* @throws Exception
*/
public function updateAccount($accountId, array $data, $userId)
{
$accountId = (int) $accountId;
$userId = (int) $userId;
if ($userId <= 0 || $accountId <= 0) {
throw new InvalidArgumentException("Invalid argument supplied, userId was \"{$userId}\", " . "accountId was \"{$accountId}\"");
}
$filter = $this->_getUpdateAccountFilter();
$filter->setData($data);
try {
$data = $filter->getProcessedData();
} catch (Zend_Filter_Exception $e) {
/**
* @see Conjoon_Error
*/
require_once 'Conjoon/Error.php';
Conjoon_Log::log(Conjoon_Error::fromFilter($filter, $e), Zend_Log::ERR);
return false;
}
if (array_key_exists('id', $data)) {
unset($data['id']);
}
/**
* @see Conjoon_Util_Array
*/
require_once 'Conjoon/Util/Array.php';
Conjoon_Util_Array::underscoreKeys($data);
$affected = $this->_getAccountModel()->updateAccount($accountId, $data);
if ($affected === true) {
$this->_getBuilder()->remove(array('accountId' => $accountId));
$this->_getListBuilder()->cleanCacheForTags(array('userId' => $userId));
}
return $affected === true ? true : false;
}
/**
* This action will update email accounts according to the POST params
* that come along with the request.
* Depending of the current context the action was called, the format of the
* POST params will differ: For json, it will be an array holding json-encoded parameters.
* Despite all different formats the POST params may come in, each request sends
* values for 'updated' and 'deleted' accounts: 'deleted' as an array, holding all
* ids that should become deleted, and 'updated' an array holding information about
* the records that get edited, represented by specific associative array, representing
* the fields of the record.
* The view will await values assigned to 'updated_failed' and 'deleted_failed', whereas
* 'deleted_failed' is an array containing all ids that couldn't be deleted, and
* 'updated_failed' an array containing the records (in associative array notation)
* that could not be updated.
*
* Note: If any error in the user-input was detected, no update-action will happen, but
* deltes may already have been submitted to the underlying datastore.
* The first error found in the passed data will be returned as an error of the type
* Conjoon_Error_Form, containing the fields that where errorneous.
*
*/
public function updateEmailAccountsAction()
{
require_once 'Conjoon/Modules/Groupware/Email/Account/Filter/Account.php';
require_once 'Conjoon/Util/Array.php';
require_once 'Conjoon/Modules/Groupware/Email/Account/Model/Account.php';
$toDelete = array();
$toUpdate = array();
$deletedFailed = array();
$updatedFailed = array();
$model = new Conjoon_Modules_Groupware_Email_Account_Model_Account();
$data = array();
$error = null;
if ($this->_helper->conjoonContext()->getCurrentContext() == self::CONTEXT_JSON) {
require_once 'Zend/Json.php';
$toDelete = Zend_Json::decode($_POST['deleted'], Zend_Json::TYPE_ARRAY);
$toUpdate = Zend_Json::decode($_POST['updated'], Zend_Json::TYPE_ARRAY);
}
$numToUpdate = count($toUpdate);
$numToDelete = count($toDelete);
if ($numToUpdate != 0 || $numToDelete != 0) {
/**
* @see Conjoon_Builder_Factory
*/
require_once 'Conjoon/Builder/Factory.php';
Conjoon_Builder_Factory::getBuilder(Conjoon_Keys::CACHE_EMAIL_ACCOUNTS, Zend_Registry::get(Conjoon_Keys::REGISTRY_CONFIG_OBJECT)->toArray())->cleanCacheForTags(array('userId' => Zend_Registry::get(Conjoon_Keys::REGISTRY_AUTH_OBJECT)->getIdentity()->getId()));
}
$userId = $this->_helper->registryAccess()->getUserId();
for ($i = 0; $i < $numToDelete; $i++) {
$affected = $model->deleteAccount($toDelete[$i], $userId);
if ($affected == 0) {
$deletedFailed[] = $toDelete[$i];
}
}
$folderMappingData = array();
for ($i = 0; $i < $numToUpdate; $i++) {
$_ = $toUpdate[$i];
$folderMappingData[$toUpdate[$i]['id']] = $toUpdate[$i]['folderMappings'];
$filter = new Conjoon_Modules_Groupware_Email_Account_Filter_Account($_, Conjoon_Filter_Input::CONTEXT_UPDATE);
try {
$data[$i] = $filter->getProcessedData();
Conjoon_Util_Array::underscoreKeys($data[$i]);
} catch (Zend_Filter_Exception $e) {
require_once 'Conjoon/Error.php';
$error = Conjoon_Error::fromFilter($filter, $e);
$this->view->success = false;
$this->view->updatedFailed = array($_['id']);
$this->view->deletedFailed = $deletedFailed;
$this->view->error = $error->getDto();
return;
}
}
$createdLocalRootMailFolders = array();
$removedLocalRootMailFolders = array();
/**
* @see Conjoon_BeanContext_Decorator
*/
require_once 'Conjoon/BeanContext/Decorator.php';
$decoratedFolderModel = new Conjoon_BeanContext_Decorator('Conjoon_Modules_Groupware_Email_Folder_Model_Folder', null, false);
$decoratedAccountModel = new Conjoon_BeanContext_Decorator('Conjoon_Modules_Groupware_Email_Account_Model_Account');
/**
* @see Conjoon_Modules_Groupware_Email_Folder_Model_Folder
*/
require_once 'Conjoon/Modules/Groupware/Email/Folder/Model/Folder.php';
$folderModel = new Conjoon_Modules_Groupware_Email_Folder_Model_Folder();
/**
* @see Conjoon_Modules_Groupware_Email_Folder_Model_FoldersAccounts
*/
require_once 'Conjoon/Modules/Groupware/Email/Folder/Model/FoldersAccounts.php';
$foldersAccounts = new Conjoon_Modules_Groupware_Email_Folder_Model_FoldersAccounts();
for ($i = 0, $len = count($data); $i < $len; $i++) {
$id = $data[$i]['id'];
unset($data[$i]['id']);
// check here for duplicates
$duplicates = $model->getAccountWithNameForUser($data[$i]['name'], $userId);
$affected = 0;
if (!empty($duplicates)) {
for ($a = 0, $lena = count($duplicates); $a < $lena; $a++) {
if ($duplicates[$a]['id'] != $id) {
$affected = -1;
break;
}
}
}
if ($affected != -1) {
$affected = $model->updateAccount($id, $data[$i]);
$entityManager = Zend_Registry::get(Conjoon_Keys::DOCTRINE_ENTITY_MANAGER);
// update folderMappings
if (isset($folderMappingData[$id])) {
$fmRep = $entityManager->getRepository('\\Conjoon\\Data\\Entity\\Mail\\DefaultFolderMappingEntity');
for ($u = 0, $lenu = count($folderMappingData[$id]); $u < $lenu; $u++) {
if (isset($folderMappingData[$id][$u]['id']) && empty($folderMappingData[$id][$u]['path'])) {
$updEnt = $fmRep->findById($folderMappingData[$id][$u]['id']);
$updEnt->setGlobalName("");
$fmRep->register($updEnt);
} else {
if (isset($folderMappingData[$id][$u]['id']) && !empty($folderMappingData[$id][$u]['path'])) {
/**
* @see \Conjoon\Data\Entity\Mail\DefaultFolderMappingEntity
*/
require_once 'Conjoon/Data/Entity/Mail/DefaultFolderMappingEntity.php';
/**
* @see Conjoon_Modules_Groupware_Email_ImapHelper
*/
require_once 'Conjoon/Modules/Groupware/Email/ImapHelper.php';
$accDto = $decoratedAccountModel->getAccountAsDto($id, $userId);
$delim = Conjoon_Modules_Groupware_Email_ImapHelper::getFolderDelimiterForImapAccount($accDto);
$p = $folderMappingData[$id][$u]['path'];
array_shift($p);
array_shift($p);
$globalName = implode($delim, $p);
$updEnt = $fmRep->findById($folderMappingData[$id][$u]['id']);
$updEnt->setGlobalName($globalName);
$fmRep->register($updEnt);
continue;
}
}
}
$fmRep->flush();
}
// take care of folder heirarchies
if ($affected != -1) {
/**
* @todo Facade
*/
$hasSeparateFolderHierarchy = array_key_exists('has_separate_folder_hierarchy', $data[$i]) ? (bool) (int) $data[$i]['has_separate_folder_hierarchy'] : null;
// get org protocol of account so it cannot be changed from
// the outside
$orgAccount = $model->getAccount($id, $userId);
$orgProtocol = $orgAccount['protocol'];
if ($hasSeparateFolderHierarchy !== null && strtolower($orgProtocol) !== 'imap') {
// the original folder ids, before remapping occures
$oldAccountFolderIds = $foldersAccounts->getFolderIdsForAccountId($id);
// read out folder base data of folder for associated account
$rootFolderBaseData = $decoratedFolderModel->getAnyRootMailFolderBaseDataAsDto($id, $userId);
if (!$rootFolderBaseData) {
throw new RuntimeException("No root folder base data available.");
}
if (!$hasSeparateFolderHierarchy) {
// do nothing if type is already accounts_root and
// separateFolderHierarchy = false is submitted;
// but if the type is root and the folderHierarchy
// (i.e. "root) should be removed,
// we need to switch from root to accounts_root
if ($rootFolderBaseData->type == 'root') {
// check first if accounts_root exist!
$accountsRootFolderId = $folderModel->getAccountsRootMailFolderBaseData($userId);
// accounts root not yet existing
if (!$accountsRootFolderId) {
$folderModel->createFolderBaseHierarchyAndMapAccountIdForUserId($id, $userId);
} else {
$newFolderIds = $folderModel->getFoldersForAccountsRoot($userId);
// accounts root already existing.
// remove the root and remap to accounts_root
foreach ($oldAccountFolderIds as $oldFolderId) {
$folderModel->deleteFolder($oldFolderId, $userId, false);
}
$removedLocalRootMailFolders[$id] = $rootFolderBaseData;
$foldersAccounts->mapFolderIdsToAccountId($newFolderIds, $id);
}
$createdLocalRootMailFolders[$id] = $decoratedFolderModel->getAnyRootMailFolderBaseDataAsDto($id, $userId);
}
} else {
// do nothing if the type is already root which means
// there already exists a separate folder hierarchy
// if the type is accounts_root, we need to switch
// to a root hierarchy
if ($rootFolderBaseData->type == 'accounts_root') {
// remove old mappings
$foldersAccounts->deleteForAccountId($id);
$folderModel->createFolderHierarchyAndMapAccountIdForUserId($id, $userId, $data[$i]['name']);
$createdLocalRootMailFolders[$id] = $decoratedFolderModel->getAnyRootMailFolderBaseDataAsDto($id, $userId);
}
}
}
}
}
if ($affected == -1) {
$updatedFailed[] = $id;
}
}
$this->view->success = empty($updatedFailed) ? true : false;
$this->view->updatedFailed = $updatedFailed;
$this->view->deletedFailed = $deletedFailed;
$this->view->error = null;
$this->view->createdLocalRootMailFolders = $createdLocalRootMailFolders;
$this->view->removedLocalRootMailFolders = $removedLocalRootMailFolders;
}
/**
* Saves the email and it's attachments. Uses the default db adapter as
* configured by the application. If an exception occurs, the exception's
* message will be stored in an array (together with other exceptions that
* may have occured) and returned later on. Any db operation that failed will
* be rolled back.
*
* @param array $emailItem An associative array with the data to insert into the
* different tables. All attachments will be stored in the key/value pair "attachments",
* which is itself a numeric array
*
* @return mixed Return the id of the last inserted email item, or an
* error message if an error occured.
*/
private function _saveEmail(array $emailItem)
{
$filterAttachment = $this->_filterAttachment;
$filterFlag = $this->_filterFlag;
$filterItem = $this->_filterItem;
$filterInbox = $this->_filterInbox;
$modelAttachment = $this->_modelAttachment;
$modelFlag = $this->_modelFlag;
$modelItem = $this->_modelItem;
$modelInbox = $this->_modelInbox;
$dbAdapter = Zend_Db_Table::getDefaultAdapter();
if (!$this->_maxAllowedPacket) {
$config = Zend_Registry::get(Conjoon_Keys::REGISTRY_CONFIG_OBJECT);
$this->_maxAllowedPacket = $config->database->variables->max_allowed_packet;
if (!$this->_maxAllowedPacket) {
$this->_maxAllowedPacket = Conjoon_Db_Util::getMaxAllowedPacket($dbAdapter);
}
}
$this->_setPlainFromHtml($emailItem);
// filter and insert into groupware_email_items
$filterItem->setData($emailItem);
$itemData = $filterItem->getProcessedData();
if ($this->_maxAllowedPacket < strlen($emailItem['rawBody'])) {
return 'Could not save message with subject "' . $itemData['subject'] . '" - message is larger than available packet size (' . $this->_maxAllowedPacket . ' bytes).';
}
$dbAdapter->beginTransaction();
$currFilter = null;
try {
Conjoon_Util_Array::underscoreKeys($itemData);
try {
$id = (int) $modelItem->insert($itemData);
} catch (Zend_Db_Statement_Exception $zdse) {
// in very rare cases, there are 4-byte characters in a utf-8
// string, and mysql cannot handle them right since we use
// utf-8 collations. We'll strip those 4-byte characters away.
// see CN-619
$content = $itemData['content_text_plain'];
$i = 0;
$len = strlen($content);
$fourByteDetected = false;
while ($i < $len) {
$ord = ord($content[$i]);
switch (true) {
case $ord <= 127:
$i += 1;
break;
case $ord < 224:
$i += 2;
break;
case $ord < 240:
$i += 3;
break;
default:
$fourByteDetected = true;
$content = substr($content, 0, $i) . substr($content, $i + 4);
$len -= 4;
break;
}
}
if ($fourByteDetected === true) {
$lastResortData = $emailItem;
$lastResortData['contentTextPlain'] = $content;
$filterItem->setData($lastResortData);
$lastResortItemData = $filterItem->getProcessedData();
Conjoon_Util_Array::underscoreKeys($lastResortItemData);
$id = (int) $modelItem->insert($lastResortItemData);
/**
* @see Conjoon_Log
*/
require_once 'Conjoon/Log.php';
Conjoon_Log::log("Detected 4-byte character in content_text_plain for " . "Email message with id {$id}", Zend_Log::NOTICE);
}
}
if ($id <= 0) {
return null;
}
// assign needed (reference) keys
$emailItem['isRead'] = 0;
$emailItem['id'] = $id;
$emailItem['groupwareEmailItemsId'] = $id;
// filter and insert into groupware_email_items_inbox
$currFilter = $filterInbox;
$filterInbox->setData($emailItem);
$itemData = $filterInbox->getProcessedData();
Conjoon_Util_Array::underscoreKeys($itemData);
$modelInbox->addInboxData($itemData);
// filter and insert into groupware_email_items_flag
$currFilter = $filterFlag;
$filterFlag->setData($emailItem);
$itemData = $filterFlag->getProcessedData();
Conjoon_Util_Array::underscoreKeys($itemData);
$modelFlag->insert($itemData);
// loop through attachments and insert into groupware_email_items_attachments
$attachmentCount = count($emailItem['attachments']);
$currFilter = $filterAttachment;
for ($i = 0; $i < $attachmentCount; $i++) {
$emailItem['attachments'][$i]['groupwareEmailItemsId'] = $id;
$filterAttachment->setData($emailItem['attachments'][$i]);
$itemData = $filterAttachment->getProcessedData();
Conjoon_Util_Array::underscoreKeys($itemData);
$modelAttachment->addAttachmentForItem($itemData, $id);
}
$dbAdapter->commit();
return $id;
} catch (Exception $e) {
if ($e instanceof Zend_Filter_Exception) {
$error = Conjoon_Error::fromFilter($currFilter, $e);
$error = $error->getMessage();
} else {
$error = $e->getMessage();
}
try {
$dbAdapter->rollBack();
} catch (Exception $m) {
$error .= '; ' . $m->getMessage();
}
return $error;
}
}
