/**
* 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;
}
/**
* Returns an assoc array with the data of an draft. The returned array
* has all properties as according to Conjoon_Modules_Groupware_Email_Draft.
*
* @param integer $itemId
* @param integer $userId
* @param string $context The context used to fetch the draft. Important
* when dealign with contexts "reply", "reply_all" and "forward".
* - context "forward": fields "references" and "in_reply_to" will be set
* to an empty string
* - context "reply", "reply_all": "in_reply_to" will be set to the message-id
* of the email, references will be concatenated with the message-id
*
* @return array
*/
public function getDraft($itemId, $userId, $context = '')
{
$itemId = (int) $itemId;
if ($itemId <= 0) {
return array();
}
$itemModel = new Conjoon_Modules_Groupware_Email_Item_Model_Item();
$row = $itemModel->fetchRow($itemModel->select()->from($itemModel)->where('id = ?', $itemId));
if (!$row) {
return array();
}
$draft = array('id' => $row->id, 'date' => $row->date, 'subject' => $row->subject, 'from' => $row->from, 'reply_to' => $row->reply_to, 'to' => $row->to, 'cc' => $row->cc, 'bcc' => $row->bcc, 'in_reply_to' => $row->in_reply_to, 'references' => $row->references, 'content_text_plain' => $row->content_text_plain, 'content_text_html' => $row->content_text_html, 'groupware_email_folders_id' => $row->groupware_email_folders_id, 'attachments' => array());
// clear memory
unset($row);
// set in_reply_to, references according to the context
switch ($context) {
case Conjoon_Modules_Groupware_Email_Keys::REFERENCE_TYPE_REPLY:
case Conjoon_Modules_Groupware_Email_Keys::REFERENCE_TYPE_REPLY_ALL:
$inboxModel = new Conjoon_Modules_Groupware_Email_Item_Model_Inbox();
$messageId = $inboxModel->getMessageIdForItem($draft['id']);
if ($messageId != "") {
$draft['in_reply_to'] = $messageId;
$draft['references'] = $draft['references'] != '' ? $draft['references'] . ' ' . $messageId : $messageId;
} else {
$draft['in_reply_to'] = '';
$draft['references'] = '';
}
break;
case Conjoon_Modules_Groupware_Email_Keys::REFERENCE_TYPE_FORWARD:
$draft['in_reply_to'] = '';
$draft['references'] = '';
case '':
case Conjoon_Modules_Groupware_Email_Keys::REFERENCE_TYPE_EDIT:
/**
* @see Conjoon_Modules_Groupware_Email_Attachment_Model_Attachment
*/
require_once 'Conjoon/Modules/Groupware/Email/Attachment/Model/Attachment.php';
$attachmentModel = new Conjoon_Modules_Groupware_Email_Attachment_Model_Attachment();
$draft['attachments'] = $attachmentModel->getAttachmentsForItem($draft['id'])->toArray();
break;
}
// check if the item is available in outbox and get the id of it under which it was
// created. Otherwise, get the standard account out of the accounts-table
$outboxModel = new Conjoon_Modules_Groupware_Email_Item_Model_Outbox();
$accIdRow = $outboxModel->fetchRow($outboxModel->select()->from($outboxModel, array('groupware_email_accounts_id'))->where('groupware_email_items_id = ? ', $draft['id']));
$accountModel = new Conjoon_Modules_Groupware_Email_Account_Model_Account();
if (!$accIdRow) {
$accId = $accountModel->getStandardAccountIdForUser($userId);
} else {
$accId = $accIdRow->groupware_email_accounts_id;
// check if the account still exists
$account = $accountModel->getAccount($accId, $userId);
if (empty($account)) {
$accId = $accountModel->getStandardAccountIdForUser($userId);
if ($accId == 0) {
return array();
}
}
}
$draft['groupware_email_accounts_id'] = $accId;
return $draft;
}
