public function getTestEvent()
{
$event = $this->_getEvent();
$event->rrule = 'FREQ=DAILY;INTERVAL=1';
$exceptions = new Tinebase_Record_RecordSet('Calendar_Model_Event');
$event->attendee[1]->transp = Calendar_Model_Event::TRANSP_TRANSP;
$event->alarms = new Tinebase_Record_RecordSet('Tinebase_Model_Alarm', array(array('minutes_before' => 15), array('minutes_before' => 30), array('minutes_before' => 'custom', 'alarm_time' => '2009-03-25 04:33:00'), array('minutes_before' => 60), array('minutes_before' => 90)), TRUE);
$event->alarms[0]->setOption('skip', array(array('user_type' => Calendar_Model_Attender::USERTYPE_USER, 'user_id' => $this->_getTestUserContact()->getId(), 'organizer' => Tinebase_Core::getUser()->contact_id)));
$event->alarms[1]->setOption('attendee', array('user_type' => Calendar_Model_Attender::USERTYPE_USER, 'user_id' => $this->_getTestUserContact()->getId(), 'organizer' => Tinebase_Core::getUser()->contact_id));
$event->alarms[2]->setOption('skip', array(array('user_type' => Calendar_Model_Attender::USERTYPE_USER, 'user_id' => $this->_getPersonasContacts('sclever')->getId(), 'organizer' => Tinebase_Core::getUser()->contact_id)));
$event->alarms[3]->setOption('attendee', array('user_type' => Calendar_Model_Attender::USERTYPE_USER, 'user_id' => $this->_getPersonasContacts('sclever')->getId(), 'organizer' => Tinebase_Core::getUser()->contact_id));
$persistentException = clone $event;
$persistentException->recurid = clone $persistentException->dtstart;
$persistentException->recurid->addDay(1);
$persistentException->dtstart->addDay(1)->addHour(2);
$persistentException->dtend->addDay(1)->addHour(2);
$persistentException->summary = 'exception';
$exceptions->addRecord($persistentException);
$deletedInstance = clone $event;
$deletedInstance->dtstart->addDay(2);
$deletedInstance->dtend->addDay(2);
$deletedInstance->recurid = clone $deletedInstance->dtstart;
$deletedInstance->is_deleted = TRUE;
$exceptions->addRecord($deletedInstance);
$event->exdate = $exceptions;
return $event;
}
/**
* get grants for records
*
* @param Tinebase_Record_RecordSet $records
*/
public function getGrantsForRecords(Tinebase_Record_RecordSet $records)
{
$recordIds = $records->getArrayOfIds();
if (empty($recordIds)) {
return;
}
$select = $this->_getAclSelectByRecordIds($recordIds)->group(array('record_id', 'account_type', 'account_id'));
Tinebase_Backend_Sql_Abstract::traitGroup($select);
if (Tinebase_Core::isLogLevel(Zend_Log::TRACE)) {
Tinebase_Core::getLogger()->trace(__METHOD__ . '::' . __LINE__ . ' ' . $select);
}
$stmt = $this->_db->query($select);
$grantsData = $stmt->fetchAll(Zend_Db::FETCH_ASSOC);
if (Tinebase_Core::isLogLevel(Zend_Log::TRACE)) {
Tinebase_Core::getLogger()->trace(__METHOD__ . '::' . __LINE__ . ' grantsData: ' . print_r($grantsData, true));
}
foreach ($grantsData as $grantData) {
$givenGrants = explode(',', $grantData['account_grants']);
foreach ($givenGrants as $grant) {
$grantData[$grant] = TRUE;
}
$recordGrant = new $this->_modelName($grantData, true);
unset($recordGrant->account_grant);
$record = $records->getById($recordGrant->record_id);
if (!$record->grants instanceof Tinebase_Record_RecordSet) {
$record->grants = new Tinebase_Record_RecordSet($this->_modelName);
}
$record->grants->addRecord($recordGrant);
}
if (Tinebase_Core::isLogLevel(Zend_Log::TRACE)) {
Tinebase_Core::getLogger()->trace(__METHOD__ . '::' . __LINE__ . ' Records with grants: ' . print_r($records->toArray(), true));
}
}
/**
* @param Tinebase_Record_RecordSet $_records
* @throws Tinebase_Exception_NotImplemented
*/
public function processIteration($_records)
{
$record = $_records->getFirstRecord();
$converter = Tinebase_Convert_Factory::factory($record);
$resolved = $converter->fromTine20Model($record);
$this->_docTemplate->setValue('salutation_letter', $this->_getSalutation($resolved));
$this->_docTemplate->setValue('salutation_resolved', $this->_getShortSalutation($resolved));
parent::processIteration($_records);
}
public function getLastOpenItem(Tinebase_Record_RecordSet $batchJobMonitionItems)
{
if ($batchJobMonitionItems->getCount() == 0) {
throw new Billing_Exception_OpenItem('Recordset does not contain any monition open items and therefore no related order.');
}
$batchJobMonitionItems->sort('open_item_id', 'DESC');
$record = $batchJobMonitionItems->getFirstRecord();
$openItem = $record->getForeignRecord('open_item_id', Billing_Controller_OpenItem::getInstance());
return $openItem;
}
public function getByReceiptId($receiptId)
{
$recordSet = $this->getMultipleByProperty($receiptId, 'receipt_id', false, 'position_nr');
$resultRecordSet = new Tinebase_Record_RecordSet('Billing_Model_OrderPosition');
if ($recordSet instanceof Tinebase_Record_RecordSet && $recordSet->count() > 0) {
$it = $recordSet->getIterator();
foreach ($it as $key => $record) {
$resultRecordSet->addRecord($this->loadOrderPosition($record));
}
}
return $resultRecordSet;
}
/**
* Lets update a record tree times
*
* @access protected
*/
protected function setUp()
{
$now = new Tinebase_DateTime();
$this->_modLogClass = Tinebase_Timemachine_ModificationLog::getInstance();
$this->_persistantLogEntries = new Tinebase_Record_RecordSet('Tinebase_Model_ModificationLog');
$this->_recordIds = array('5dea69be9c72ea3d263613277c3b02d529fbd8bc');
$tinebaseApp = Tinebase_Application::getInstance()->getApplicationByName('Tinebase');
$this->_logEntries = new Tinebase_Record_RecordSet('Tinebase_Model_ModificationLog', array(array('application_id' => $tinebaseApp, 'record_id' => $this->_recordIds[0], 'record_type' => 'TestType', 'record_backend' => 'TestBackend', 'modification_time' => $this->Cloner($now)->addDay(-2), 'modification_account' => 7, 'modified_attribute' => 'FirstTestAttribute', 'old_value' => 'Hamburg', 'new_value' => 'Bremen'), array('application_id' => $tinebaseApp, 'record_id' => $this->_recordIds[0], 'record_type' => 'TestType', 'record_backend' => 'TestBackend', 'modification_time' => $this->Cloner($now)->addDay(-1), 'modification_account' => 7, 'modified_attribute' => 'FirstTestAttribute', 'old_value' => 'Bremen', 'new_value' => 'Frankfurt'), array('application_id' => $tinebaseApp, 'record_id' => $this->_recordIds[0], 'record_type' => 'TestType', 'record_backend' => 'TestBackend', 'modification_time' => $this->Cloner($now), 'modification_account' => 7, 'modified_attribute' => 'FirstTestAttribute', 'old_value' => 'Frankfurt', 'new_value' => 'Stuttgart'), array('application_id' => $tinebaseApp, 'record_id' => $this->_recordIds[0], 'record_type' => 'TestType', 'record_backend' => 'TestBackend', 'modification_time' => $this->Cloner($now)->addDay(-2), 'modification_account' => 7, 'modified_attribute' => 'SecondTestAttribute', 'old_value' => 'Deutschland', 'new_value' => 'Östereich'), array('application_id' => $tinebaseApp, 'record_id' => $this->_recordIds[0], 'record_type' => 'TestType', 'record_backend' => 'TestBackend', 'modification_time' => $this->Cloner($now)->addDay(-1)->addSecond(1), 'modification_account' => 7, 'modified_attribute' => 'SecondTestAttribute', 'old_value' => 'Östereich', 'new_value' => 'Schweitz'), array('application_id' => $tinebaseApp->getId(), 'record_id' => $this->_recordIds[0], 'record_type' => 'TestType', 'record_backend' => 'TestBackend', 'modification_time' => $this->Cloner($now), 'modification_account' => 7, 'modified_attribute' => 'SecondTestAttribute', 'old_value' => 'Schweitz', 'new_value' => 'Italien')), true, false);
foreach ($this->_logEntries as $logEntry) {
$id = $this->_modLogClass->setModification($logEntry);
$this->_persistantLogEntries->addRecord($this->_modLogClass->getModification($id));
}
}
/**
* resolve tag ids to tag record
*
* @todo find a generic solution for this!
*/
protected function _resolveClientRecordTags()
{
if (!$this->_clientRecord->has('tags') || empty($this->_clientRecord->tags)) {
return;
}
$tags = new Tinebase_Record_RecordSet('Tinebase_Model_Tag');
foreach ($this->_clientRecord->tags as $tag) {
if (is_string($tag)) {
$tag = Tinebase_Tags::getInstance()->get($tag);
}
$tags->addRecord($tag);
}
$this->_clientRecord->tags = $tags;
}
protected function _testFullFixtures()
{
$this->assertEquals(4, $this->_customerRecords->count());
$this->assertEquals(12, $this->_addressRecords->count());
$this->assertEquals(4, $this->_contractRecords->count());
$this->assertEquals(20, $this->_contactRecords->count());
}
/**
* resolves an array with usernames to an array of user ids
*
* @param array $users
*/
protected function _resolveUsers($users)
{
if (!$this->_userRecords) {
$this->_userRecords = new Tinebase_Record_RecordSet('Tinebase_Model_User');
}
$resolved = array();
if (is_array($users) && !empty($users)) {
foreach ($users as $userName) {
$user = $this->_userRecords->filter('name', $userName)->getFirstRecord();
if (!$user) {
try {
$user = Tinebase_User::getInstance()->getUserByLoginName($userName);
} catch (Tinebase_Exception_NotFound $tenf) {
if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) {
Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . ' Skipping user ' . $userName);
}
Tinebase_Exception::log($tenf);
continue;
}
$this->_userRecords->addRecord($user);
}
$resolved[] = $user->getId();
}
}
return $resolved;
}
/**
* creates missing accounts for all employees having a valid contract
* if a year is given, missing accounts for this year will be built, otherwise the current and following year will be used
*
* @param integer $year
* @param HumanResources_Model_Employee
* @param boolean $useBackend Use Backend instead of this Controller (may called by setup also, skips rigts, creating modlog etc.)
*/
public function createMissingAccounts($year = NULL, $employee = NULL, $useBackend = FALSE)
{
// if no year is given, call myself with this year and just go on with the next year
if (!$year) {
$date = new Tinebase_DateTime();
$year = (int) $date->format('Y');
$this->createMissingAccounts($year, $employee);
$date->addYear(1);
$year = (int) $date->format('Y');
}
// tine20 should last a hundred years :)
if ($year < 2006 || $year >= 2106 || !is_int($year)) {
throw new Tinebase_Exception_Data('The year must be between 2006 and 2106');
}
// borders
$year_starts = new Tinebase_DateTime($year . '-01-01 00:00:00');
$year_ends = new Tinebase_DateTime($year . '-12-31 23:59:59');
$validEmployeeIds = array_unique($this->_contractController->getValidContracts($year_starts, $year_ends, $employee)->employee_id);
$existingFilter = new HumanResources_Model_AccountFilter(array(array('field' => 'year', 'operator' => 'equals', 'value' => $year)));
$existingFilter->addFilter(new Tinebase_Model_Filter_Text(array('field' => 'employee_id', 'operator' => 'in', 'value' => $validEmployeeIds)));
$result = $this->search($existingFilter)->employee_id;
$validEmployeeIds = array_diff($validEmployeeIds, $result);
$createdAccounts = new Tinebase_Record_RecordSet('HumanResources_Model_Account');
if ($useBackend) {
$be = new HumanResources_Backend_Account();
foreach ($validEmployeeIds as $id) {
$createdAccounts->addRecord($be->create(new HumanResources_Model_Account(array('employee_id' => $id, 'year' => $year))));
}
} else {
foreach ($validEmployeeIds as $id) {
$createdAccounts->addRecord($this->create(new HumanResources_Model_Account(array('employee_id' => $id, 'year' => $year))));
}
}
return $createdAccounts;
}
/**
* import file
*
* @param string $_filename
* @param Tinebase_Model_ImportExportDefinition $_definition
* @param boolean $_useJsonImportFn
* @param boolean $removeGroupList
* @return array course data
*/
protected function _importHelper($_filename, Tinebase_Model_ImportExportDefinition $_definition = NULL, $_useJsonImportFn = FALSE, $removeGroupList = FALSE)
{
$definition = $_definition !== NULL ? $_definition : $this->_getCourseImportDefinition();
$course = $this->_getCourseData();
$courseData = $this->_json->saveCourse($course);
$this->_groupsToDelete->addRecord(Tinebase_Group::getInstance()->getGroupById($courseData['group_id']));
if ($removeGroupList) {
$group = Admin_Controller_Group::getInstance()->get($courseData['group_id']);
Addressbook_Controller_List::getInstance()->delete($group->list_id);
}
if ($_useJsonImportFn) {
$tempFileBackend = new Tinebase_TempFile();
$tempFile = $tempFileBackend->createTempFile($_filename);
Courses_Config::getInstance()->set(Courses_Config::STUDENTS_IMPORT_DEFINITION, $definition->name);
$result = $this->_json->importMembers($tempFile->getId(), $courseData['group_id'], $courseData['id']);
$this->assertGreaterThan(0, $result['results']);
} else {
$maildomain = TestServer::getPrimaryMailDomain();
$importer = call_user_func($definition->plugin . '::createFromDefinition', $definition, array('group_id' => $courseData['group_id'], 'accountHomeDirectoryPrefix' => '//base/school/' . $courseData['name'] . '/', 'accountEmailDomain' => $maildomain, 'password' => $courseData['name'], 'samba' => array('homePath' => '//basehome/', 'homeDrive' => 'H:', 'logonScript' => 'logon.bat', 'profilePath' => '\\\\profile\\')));
$tempFilename = TestServer::replaceEmailDomainInFile($_filename);
$importer->importFile($tempFilename);
}
$courseData = $this->_json->getCourse($courseData['id']);
return $courseData;
}
/**
* get folder status and return all folders where something needs to be done
*
* @param Felamimail_Model_FolderFilter $_filter
* @return Tinebase_Record_RecordSet
*/
public function getFolderStatus(Felamimail_Model_FolderFilter $_filter)
{
$this->_availableUpdateTime = NULL;
// add user account ids to filter and use the folder backend to search as the folder controller has some special handling in its search function
$_filter->createFilter(array('field' => 'account_id', 'operator' => 'in', 'value' => Felamimail_Controller_Account::getInstance()->search()->getArrayOfIds()));
$folderBackend = Felamimail_Backend_Folder::getInstance();
$folders = $folderBackend->search($_filter);
if (Tinebase_Core::isLogLevel(Zend_Log::TRACE)) {
Tinebase_Core::getLogger()->trace(__METHOD__ . '::' . __LINE__ . ' ' . print_r($_filter->toArray(), TRUE));
}
if (Tinebase_Core::isLogLevel(Zend_Log::INFO)) {
Tinebase_Core::getLogger()->info(__METHOD__ . '::' . __LINE__ . " Checking status of " . count($folders) . ' folders.');
}
$result = new Tinebase_Record_RecordSet('Felamimail_Model_Folder');
foreach ($folders as $folder) {
if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) {
Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . ' Checking folder ' . $folder->globalname);
}
if ($this->_doNotUpdateCache($folder, FALSE)) {
continue;
}
$imap = Felamimail_Backend_ImapFactory::factory($folder->account_id);
$folder = Felamimail_Controller_Cache_Folder::getInstance()->getIMAPFolderCounter($folder);
if ($this->_cacheIsInvalid($folder) || $this->_messagesInCacheButNotOnIMAP($folder)) {
$result->addRecord($folder);
continue;
}
if ($folder->imap_totalcount > 0) {
try {
$this->_updateMessageSequence($folder, $imap);
} catch (Felamimail_Exception_IMAPMessageNotFound $feimnf) {
$result->addRecord($folder);
continue;
}
if ($this->_messagesDeletedOnIMAP($folder) || $this->_messagesToBeAddedToCache($folder) || $this->_messagesMissingFromCache($folder)) {
$result->addRecord($folder);
continue;
}
}
}
if (Tinebase_Core::isLogLevel(Zend_Log::INFO)) {
Tinebase_Core::getLogger()->info(__METHOD__ . '::' . __LINE__ . " Found " . count($result) . ' folders that need an update.');
}
return $result;
}
public function getTestEvent()
{
$event = $this->_getEvent();
$event->rrule = 'FREQ=DAILY;INTERVAL=1';
$exceptions = new Tinebase_Record_RecordSet('Calendar_Model_Event');
$persistentException = clone $event;
$persistentException->recurid = clone $persistentException->dtstart;
$persistentException->recurid->addDay(1);
$persistentException->dtstart->addDay(1)->addHour(2);
$persistentException->dtend->addDay(1)->addHour(2);
$persistentException->summary = 'exception';
$exceptions->addRecord($persistentException);
$deletedInstance = clone $event;
$deletedInstance->dtstart->addDay(2);
$deletedInstance->dtend->addDay(2);
$deletedInstance->recurid = clone $deletedInstance->dtstart;
$deletedInstance->is_deleted = TRUE;
$exceptions->addRecord($deletedInstance);
$event->exdate = $exceptions;
return $event;
}
/**
* search message by header (X-Tine20TestMessage) and add it to cache
*
* @param string $_testHeaderValue
* @param Felamimail_Model_Folder $_folder
* @return Felamimail_Model_Message
*/
public function searchAndCacheMessage($_testHeaderValue, $_folder = NULL)
{
$folder = $_folder !== NULL ? $_folder : $this->_folder;
$message = $this->_searchMessage($_testHeaderValue, $folder);
$cachedMessage = $this->_cache->addMessage($message, $folder);
if ($cachedMessage === FALSE) {
// try to add message again (it had a duplicate)
$this->_cache->clear($folder);
$cachedMessage = $this->_cache->addMessage($message, $folder);
}
$this->assertTrue($cachedMessage instanceof Felamimail_Model_Message, 'could not add message to cache');
$this->_createdMessages->addRecord($cachedMessage);
return $cachedMessage;
}
/**
* test (plain text) mail sending via ActiveSync_Command_SendMail
*/
public function testSendMail()
{
$email = file_get_contents(dirname(__FILE__) . '/../../Felamimail/files/text_plain.eml');
$email = str_replace('gentoo-dev@lists.gentoo.org, webmaster@changchung.org', $this->_emailTestClass->getEmailAddress(), $email);
$stream = fopen('data://text/plain;base64,' . base64_encode($email), 'r');
$sendMail = new Syncope_Command_SendMail($stream);
$sendMail->handle();
$sendMail->getResponse();
// check if mail is in INBOX of test account
$inbox = $this->_emailTestClass->getFolder('INBOX');
$testHeaderValue = 'text/plain';
$message = $this->_emailTestClass->searchAndCacheMessage($testHeaderValue, $inbox);
$this->_createdMessages->addRecord($message);
$this->assertEquals("Re: [gentoo-dev] `paludis --info' is not like `emerge --info'", $message->subject);
// check duplicate headers
$completeMessage = Felamimail_Controller_Message::getInstance()->getCompleteMessage($message);
$this->assertEquals(1, count($completeMessage->headers['mime-version']));
$this->assertEquals(1, count($completeMessage->headers['content-type']));
}
/**
* get special field value
*
* @param Tinebase_Record_Interface $_record
* @param array $_param
* @param string $_key
* @param string $_cellType
* @return string
*/
protected function _getSpecialFieldValue(Tinebase_Record_Interface $_record, $_param, $_key = NULL, &$_cellType = NULL)
{
$supplierId = $_record->getId();
if (!isset($this->_supplierAddresses[$supplierId])) {
$all = $this->_addresses->filter('customer_id', $supplierId);
$this->_addresses->removeRecords($all);
$this->_supplierAddresses[$supplierId] = array('postal' => $all->filter('type', 'postal')->getFirstRecord(), 'billing' => array('records' => $all->filter('type', 'billing'), 'index' => 0), 'delivery' => array('records' => $all->filter('type', 'delivery'), 'index' => 0));
}
switch ($_param['type']) {
case 'postal':
$address = $this->_supplierAddresses[$supplierId]['postal'];
break;
default:
if (isset($this->_supplierAddresses[$supplierId][$_param['type']]['records'])) {
$address = $this->_supplierAddresses[$supplierId][$_param['type']]['records']->getByIndex($this->_supplierAddresses[$supplierId][$_param['type']]['index']);
$this->_supplierAddresses[$supplierId][$_param['type']]['index']++;
}
}
return $address ? $this->_renderAddress($address, $_param['type']) : '';
}
/**
* test search with cache
* - test text_plain.eml message
* - test from header
*/
public function testSearchWithCache()
{
// get inbox folder id
Expressomail_Controller_Folder::getInstance()->update($this->_account->getId());
$folderBackend = new Expressomail_Backend_Folder();
$folder = Expressomail_Controller_Folder::getInstance()->getByBackendAndGlobalName($this->_account->getId(), $this->_testFolderName);
// clear empty folder
Expressomail_Controller_Folder::getInstance()->emptyFolder($folder->getId());
// append message
$this->_appendMessage('text_plain.eml', $this->_folder);
// search messages in test folder
$result = $this->_controller->search($this->_getFilter($folder->getId()));
//print_r($result->toArray());
// check result
$firstMessage = $result->getFirstRecord();
$this->_createdMessages->addRecord($firstMessage);
$this->assertGreaterThan(0, count($result));
$this->assertEquals($folder->getId(), $firstMessage->folder_id);
$this->assertEquals("Re: [gentoo-dev] `paludis --info' is not like `emerge --info'", $firstMessage->subject);
$this->assertEquals('Pipping, Sebastian (Luxembourg)', $firstMessage->from_name);
$this->assertEquals('*****@*****.**', $firstMessage->from_email);
$this->assertEquals(array('*****@*****.**', '*****@*****.**'), $firstMessage->to);
}
/**
* inspect creation of one record (before create)
*
* @param Tinebase_Record_Interface $_record
* @return void
*/
protected function _inspectBeforeCreate(Tinebase_Record_Interface $_record)
{
$this->_freedaysToCreate = new Tinebase_Record_RecordSet('HumanResources_Model_FreeDay');
if (is_array($_record->employee_id)) {
$_record->employee_id = $_record->employee_id['id'];
}
if ($_record->freedays && !empty($_record->freedays)) {
foreach ($_record->freedays as $fd) {
if (!$fd instanceof HumanResources_Model_FreeDay) {
$fd = new HumanResources_Model_FreeDay($fd);
}
$this->_freedaysToCreate->addRecord($fd);
}
// normalize first-, last date and days_count
$this->_freedaysToCreate->sort('date', 'ASC');
$_record->firstday_date = $this->_freedaysToCreate->getFirstRecord()->date;
$this->_freedaysToCreate->sort('date', 'DESC');
$_record->lastday_date = $this->_freedaysToCreate->getFirstRecord()->date;
$_record->days_count = $this->_freedaysToCreate->count();
} else {
$_record->firstday_date = NULL;
}
}
/**
* get list of records
*
* @param Tinebase_Model_Filter_FilterGroup|optional $_filter
* @param Tinebase_Model_Pagination|optional $_pagination
* @param boolean|array $_getRelations
* @param boolean $_onlyIds
* @param string $_action for right/acl check
* @return Tinebase_Record_RecordSet|array
*/
public function search(Tinebase_Model_Filter_FilterGroup $_filter = NULL, Tinebase_Record_Interface $_pagination = NULL, $_getRelations = FALSE, $_onlyIds = FALSE, $_action = 'get')
{
//@TODO support more appfilter combinations when needed
$appFilter = $_filter->getFilter('application_id');
$app = Tinebase_Application::getInstance()->getApplicationById($appFilter->getValue());
$appname = $app->name;
if (!Tinebase_Core::getUser()->hasRight($appname, 'admin')) {
throw new Tinebase_Exception_AccessDenied("You do not have admin rights for {$appname}");
}
$configRecords = new Tinebase_Record_RecordSet('Tinebase_Model_Config');
$appConfigObject = Tinebase_Config::getAppConfig($appname);
$appConfigDefinitions = $appConfigObject->getProperties();
$appDBConfig = $this->_configBackend->search($_filter);
foreach ($appConfigDefinitions as $name => $definition) {
if (array_key_exists('setByAdminModule', $definition) && $definition['setByAdminModule']) {
$configFromFile = $appConfigObject->getConfigFileSection($name);
$configFromDb = $appDBConfig->filter('name', $name)->getFirstRecord();
if ($configFromDb && !$configFromFile) {
$configRecord = $this->_mergeDefinition($configFromDb, $definition);
$configRecord->source = Tinebase_Model_Config::SOURCE_DB;
} else {
$definition['id'] = 'virtual-' . $name;
$definition['application_id'] = $app->getId();
$definition['name'] = $name;
$definition['value'] = json_encode($configFromFile);
$definition['source'] = is_null($configFromFile) ? Tinebase_Model_Config::SOURCE_DEFAULT : Tinebase_Model_Config::SOURCE_FILE;
$configRecord = new Tinebase_Model_Config($definition);
}
// exclude config's which the admin can't set
if ($configRecord->source != Tinebase_Model_Config::SOURCE_FILE) {
$configRecords->addRecord($configRecord);
}
}
}
return $configRecords;
}
/**
* getPathsForRecords
*
* @param Tinebase_Record_Interface|Tinebase_Record_RecordSet $records
* @return Tinebase_Record_RecordSet
* @throws Tinebase_Exception_NotFound
*/
public function getPathsForRecords($records)
{
$ids = $records instanceof Tinebase_Record_Interface ? array($records->getId()) : $records->getArrayOfIds();
return $this->search(new Tinebase_Model_PathFilter(array(array('field' => 'record_id', 'operator' => 'in', 'value' => $ids))));
}
/**
* import the addressbook from egw14
*
* @param string $_oldTableName [OPTIONAL]
* @param int $_useOldId [OPTIONAL]
*
* @todo use old group name for the (shared) container ?
* @todo add more config params (
*/
public function importAddressbook($_oldTableName = NULL, $_useOldId = TRUE)
{
// did nothing
//@set_time_limit (120);
$sharedContactsGroupId = -15;
$sharedContactsContainerName = "Metaways Kontakte";
$setFileasFromName = TRUE;
$tableName = $_oldTableName != NULL ? $_oldTableName : $this->oldTablePrefix . 'addressbook';
$contactsTable = new Tinebase_Db_Table(array('name' => $tableName));
// get contacts
$contacts = $contactsTable->fetchAll();
// get categories
$categories = $this->getCategories();
echo "Import Contacts from table " . $tableName . " ... <br/>";
foreach ($contacts as $contact) {
echo "importing " . $contact->n_given . " " . $contact->n_family . " ...";
/******************** add container ************************/
if ($contact->contact_owner > 0) {
// personal container for owner
try {
$container = Tinebase_Container::getInstance()->getContainerByName('Addressbook', 'Personal Contacts', Tinebase_Model_Container::TYPE_PERSONAL, Tinebase_Core::getUser());
} catch (Tinebase_Exception_NotFound $e) {
$container = new Tinebase_Model_Container(array('name' => 'Personal Contacts', 'type' => Tinebase_Model_Container::TYPE_PERSONAL, 'owner_id' => Tinebase_Core::getUser(), 'backend' => 'Sql', 'application_id' => Tinebase_Application::getInstance()->getApplicationByName('Addressbook')->getId()));
$container = Tinebase_Container::getInstance()->addContainer($container, NULL, TRUE);
}
} else {
if ($contact->contact_owner == $sharedContactsGroupId) {
// default users group -> shared container
$userGroup = Tinebase_Group::getInstance()->getGroupByName('Users');
try {
$container = Tinebase_Container::getInstance()->getContainerByName('Addressbook', $sharedContactsContainerName, Tinebase_Model_Container::TYPE_SHARED);
} catch (Tinebase_Exception_NotFound $e) {
$container = new Tinebase_Model_Container(array('name' => $sharedContactsContainerName, 'type' => Tinebase_Model_Container::TYPE_SHARED, 'backend' => 'Sql', 'application_id' => Tinebase_Application::getInstance()->getApplicationByName('Addressbook')->getId()));
$container = Tinebase_Container::getInstance()->addContainer($container, NULL, TRUE);
Tinebase_Container::getInstance()->addGrants($container, Tinebase_Acl_Rights::ACCOUNT_TYPE_GROUP, $userGroup, array(Tinebase_Model_Grants::GRANT_READ, Tinebase_Model_Grants::GRANT_ADD, Tinebase_Model_Grants::GRANT_EDIT, Tinebase_Model_Grants::GRANT_DELETE), TRUE);
}
} else {
echo "skipped.<br/>";
continue;
}
}
$containerId = $container->getId();
/******************** set fileas ************************/
if ($setFileasFromName) {
$fileas = "";
if (!empty($contact->n_family)) {
if (!empty($contact->n_given)) {
$fileas = $contact->n_family . ", " . $contact->n_given;
} else {
$fileas = $contact->n_family;
}
} else {
$fileas = $contact->n_given;
}
if (empty($fileas)) {
$fileas = $contact->org_name;
} elseif (!empty($contact->n_middle)) {
$fileas .= " " . $contact->n_middle;
}
} else {
$fileas = empty($contact->n_fileas) ? $contact->org_name : $contact->n_fileas;
}
/******************** set urls (add 'http://' if missing) ************************/
if (!preg_match("/https*:\\/\\//i", $contact->contact_url) && !empty($contact->contact_url)) {
$url = "http://" . $contact->contact_url;
} else {
$url = $contact->contact_url;
}
if (!preg_match("/https*:\\/\\//i", $contact->contact_url_home) && !empty($contact->contact_url_home)) {
$urlHome = "http://" . $contact->contact_url_home;
} else {
$urlHome = $contact->contact_url_home;
}
/******************** create contact record ************************/
$tineContact = new Addressbook_Model_Contact(array('id' => $_useOldId ? $contact->contact_id : 0, 'account_id' => $contact->account_id, 'owner' => $containerId, 'n_family' => empty($contact->n_family) ? 'imported' : $contact->n_family, 'n_fileas' => $fileas, 'n_fn' => empty($contact->n_fn) ? 'imported' : $contact->n_fn, 'adr_one_countryname' => isset($this->countryMapping[$contact->adr_one_countryname]) ? $this->countryMapping[$contact->adr_one_countryname] : "", 'adr_one_locality' => $contact->adr_one_locality, 'adr_one_postalcode' => $contact->adr_one_postalcode, 'adr_one_region' => $contact->adr_one_region, 'adr_one_street' => $contact->adr_one_street, 'adr_one_street2' => $contact->adr_one_street2, 'adr_two_countryname' => isset($this->countryMapping[$contact->adr_two_countryname]) ? $this->countryMapping[$contact->adr_two_countryname] : "", 'adr_two_locality' => $contact->adr_two_locality, 'adr_two_postalcode' => $contact->adr_two_postalcode, 'adr_two_region' => $contact->adr_two_region, 'adr_two_street' => $contact->adr_two_street, 'adr_two_street2' => $contact->adr_two_street2, 'last_modified_time' => new Tinebase_DateTime($contact->contact_modified), 'assistent' => $contact->contact_assistent, 'bday' => $contact->contact_bday, 'email' => $contact->contact_email, 'email_home' => $contact->contact_email_home, 'note' => $contact->contact_note, 'role' => $contact->contact_role, 'title' => $contact->contact_title, 'url' => $url, 'url_home' => $urlHome, 'n_given' => $contact->n_given, 'n_middle' => $contact->n_middle, 'n_prefix' => $contact->n_prefix, 'n_suffix' => $contact->n_suffix, 'org_name' => $contact->org_name, 'org_unit' => $contact->org_unit, 'tel_assistent' => $contact->tel_assistent, 'tel_car' => $contact->tel_car, 'tel_cell' => $contact->tel_cell, 'tel_cell_private' => $contact->tel_cell_private, 'tel_fax' => $contact->tel_fax, 'tel_fax_home' => $contact->tel_fax_home, 'tel_home' => $contact->tel_home, 'tel_pager' => $contact->tel_pager, 'tel_work' => $contact->tel_work, 'tags' => array()));
$tineContact = Addressbook_Controller_Contact::getInstance()->create($tineContact);
echo " ok.<br/>";
// get categories -> tags
if (!empty($contact->cat_id)) {
$catIds = explode(',', $contact->cat_id);
$filter = new Tinebase_Model_TagFilter(array('name' => '%', 'application' => 'Addressbook'));
$paging = new Tinebase_Model_Pagination();
$contactTags = new Tinebase_Record_RecordSet('Tinebase_Model_Tag');
foreach ($catIds as $catId) {
if (isset($categories[$catId])) {
$filter->name = $categories[$catId]->cat_name;
$tags = Tinebase_Tags::getInstance()->searchTags($filter, $paging)->toArray();
if (empty($tags)) {
$tag = new Tinebase_Model_Tag(array('type' => Tinebase_Model_Tag::TYPE_SHARED, 'name' => $categories[$catId]->cat_name));
$tag = Tinebase_Tags::getInstance()->createTag($tag);
$contactTags->addRecord($tag);
} else {
$contactTags->addRecord(new Tinebase_Model_Tag($tags[0]));
}
}
}
$tineContact->tags = $contactTags;
Tinebase_Tags::getInstance()->setTagsOfRecord($tineContact);
}
}
echo "done! got " . sizeof($contacts) . " contacts.<br>";
}
/**
* sort folder record set
* - begin with INBOX + other standard/system folders, add other folders
*
* @param Tinebase_Record_RecordSet $_folders
* @param string $_parentFolder
* @return Tinebase_Record_RecordSet
*/
protected function _sortFolders(Tinebase_Record_RecordSet $_folders, $_parentFolder)
{
$sortedFolders = new Tinebase_Record_RecordSet('Felamimail_Model_Folder');
$_folders->sort('localname', 'ASC', 'natcasesort');
$_folders->addIndices(array('globalname'));
Tinebase_Core::getLogger()->info(__METHOD__ . '::' . __LINE__ . ' Sorting subfolders of "' . $_parentFolder . '".');
if (Tinebase_Core::isLogLevel(Zend_Log::TRACE)) {
Tinebase_Core::getLogger()->trace(__METHOD__ . '::' . __LINE__ . ' ' . print_r($_folders->globalname, TRUE));
}
foreach ($this->_systemFolders as $systemFolderName) {
$folders = $_folders->filter('globalname', '@^' . $systemFolderName . '$@i', TRUE);
//if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . ' ' . $systemFolderName . ' => ' . print_r($folders->toArray(), TRUE));
if (count($folders) > 0) {
$sortedFolders->addRecord($folders->getFirstRecord());
}
}
foreach ($_folders as $folder) {
if (!in_array(strtolower($folder->globalname), $this->_systemFolders)) {
$sortedFolders->addRecord($folder);
}
}
//if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . ' ' . print_r($sortedFolders->globalname, TRUE));
return $sortedFolders;
}
/**
* joins all given tempfiles in given order to a single new tempFile
*
* @param array of tempfiles arrays $tempFiles
* @return array new tempFile
*/
public function joinTempFiles($tempFilesData)
{
$tempFileRecords = new Tinebase_Record_RecordSet('Tinebase_Model_TempFile');
foreach ($tempFilesData as $tempFileData) {
$record = new Tinebase_Model_TempFile(array(), TRUE);
$record->setFromJsonInUsersTimezone($tempFileData);
$tempFileRecords->addRecord($record);
}
$joinedTempFile = Tinebase_TempFile::getInstance()->joinTempFiles($tempFileRecords);
return $joinedTempFile->toArray();
}
/**
* returns multiple records prepared for json transport
*
* @param Tinebase_Record_RecordSet $_records Tinebase_Record_Abstract
* @param Tinebase_Model_Filter_FilterGroup $_filter
* @param Tinebase_Model_Pagination $_pagination
* @return array data
*/
protected function _multipleRecordsToJson(Tinebase_Record_RecordSet $_records, $_filter = NULL, $_pagination = NULL)
{
$result = array();
if ($_records->getFirstRecord()) {
$converter = Tinebase_Convert_Factory::factory($_records->getFirstRecord());
$result = $converter->fromTine20RecordSet($_records, $_filter, $_pagination);
}
return $result;
}
/**
* get not disabled users
*
*/
public function testGetNotDisabledUsers()
{
$user1 = Tinebase_User::getInstance()->getUserByLoginName('jsmith');
$user2 = Tinebase_User::getInstance()->getUserByLoginName('pwulf');
Tinebase_User::getInstance()->setStatus($user2, 'enabled');
$container = Tinebase_Container::getInstance()->getPersonalContainer($user1, 'Calendar', $user1, Tinebase_Model_Grants::GRANT_READ);
$oldGrants = Tinebase_Container::getInstance()->getGrantsOfContainer($container->getFirstRecord()->id, TRUE);
$newGrants = new Tinebase_Record_RecordSet('Tinebase_Model_Grants');
$newGrants->addRecord(new Tinebase_Model_Grants(array('account_id' => $user1->accountId, 'account_type' => 'user', Tinebase_Model_Grants::GRANT_READ => true, Tinebase_Model_Grants::GRANT_ADD => true, Tinebase_Model_Grants::GRANT_EDIT => true, Tinebase_Model_Grants::GRANT_DELETE => true, Tinebase_Model_Grants::GRANT_ADMIN => true)));
$newGrants->addRecord(new Tinebase_Model_Grants(array('account_id' => $user2->accountId, 'account_type' => 'user', Tinebase_Model_Grants::GRANT_READ => true, Tinebase_Model_Grants::GRANT_ADD => true, Tinebase_Model_Grants::GRANT_EDIT => true, Tinebase_Model_Grants::GRANT_DELETE => true, Tinebase_Model_Grants::GRANT_ADMIN => true)));
Tinebase_Container::getInstance()->setGrants($container->getFirstRecord()->id, $newGrants, TRUE);
$otherUsers = Tinebase_Container::getInstance()->getOtherUsers($user1, 'Calendar', array(Tinebase_Model_Grants::GRANT_READ));
$this->assertEquals(1, $otherUsers->filter('accountId', $user2->accountId)->count());
Tinebase_User::getInstance()->setStatus($user2, 'disabled');
Tinebase_Cache_PerRequest::getInstance()->reset();
$otherUsers = Tinebase_Container::getInstance()->getOtherUsers($user1, 'Calendar', array(Tinebase_Model_Grants::GRANT_READ));
Tinebase_User::getInstance()->setStatus($user2, 'enabled');
Tinebase_Container::getInstance()->setGrants($container->getFirstRecord()->id, $oldGrants, TRUE);
$this->assertEquals(0, $otherUsers->filter('accountId', $user2->accountId)->count());
}
/**
* deletes user in tine20 db that no longer exist in sync backend
*
* @param Tinebase_Record_RecordSet $usersInSyncBackend
*/
protected static function _syncDeletedUsers(Tinebase_Record_RecordSet $usersInSyncBackend)
{
$userIdsInSqlBackend = Tinebase_User::getInstance()->getAllUserIdsFromSqlBackend();
$deletedInSyncBackend = array_diff($userIdsInSqlBackend, $usersInSyncBackend->getArrayOfIds());
if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) {
Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . ' About to delete ' . count($deletedInSyncBackend) . ' users in SQL backend...');
}
foreach ($deletedInSyncBackend as $userToDelete) {
$user = Tinebase_User::getInstance()->getUserByPropertyFromSqlBackend('accountId', $userToDelete, 'Tinebase_Model_FullUser');
Tinebase_User::getInstance()->deleteUserInSqlBackend($userToDelete);
if (Tinebase_Application::getInstance()->isInstalled('Addressbook') === true && !empty($user->contact_id)) {
if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) {
Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . ' Deleting user contact of ' . $user->accountLoginName);
}
$contactsBackend = Addressbook_Backend_Factory::factory(Addressbook_Backend_Factory::SQL);
$contactsBackend->delete($user->contact_id);
}
}
}
/**
* returns next occurrence _ignoring exceptions_ or NULL if there is none/not computable
*
* NOTE: an ongoing event during $from [start, end[ is considered as next
* NOTE: for previous events on ongoing event is considered as previous
*
* NOTE: computing the next occurrence of an open end rrule can be dangerous, as it might result
* in a endless loop. Therefore we only make a limited number of attempts before giving up.
*
* @param Calendar_Model_Event $_event
* @param Tinebase_Record_RecordSet $_exceptions
* @param Tinebase_DateTime $_from
* @param Int $_which
* @return Calendar_Model_Event|NULL
*/
public static function computeNextOccurrence($_event, $_exceptions, $_from, $_which = 1)
{
if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) {
Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . ' $from = ' . $_from->toString());
}
if ($_which === 0 || $_event->dtstart >= $_from && $_event->dtend > $_from) {
return $_event;
}
$freqMap = array(self::FREQ_DAILY => Tinebase_DateTime::MODIFIER_DAY, self::FREQ_WEEKLY => Tinebase_DateTime::MODIFIER_WEEK, self::FREQ_MONTHLY => Tinebase_DateTime::MODIFIER_MONTH, self::FREQ_YEARLY => Tinebase_DateTime::MODIFIER_YEAR);
$rrule = new Calendar_Model_Rrule(NULL, TRUE);
$rrule->setFromString($_event->rrule);
$from = clone $_from;
$until = clone $from;
$interval = $_which * $rrule->interval;
// we don't want to compute ourself
$ownEvent = clone $_event;
$ownEvent->setRecurId($_event->getId());
$exceptions = clone $_exceptions;
$exceptions->addRecord($ownEvent);
$recurSet = new Tinebase_Record_RecordSet('Calendar_Model_Event');
if ($_from->isEarlier($_event->dtstart)) {
if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) {
Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . ' from is ealier dtstart -> given event is next occurrence');
}
return $_event;
}
$rangeDate = $_which > 0 ? $until : $from;
if (!isset($freqMap[$rrule->freq])) {
if (Tinebase_Core::isLogLevel(Zend_Log::ERR)) {
Tinebase_Core::getLogger()->err(__METHOD__ . '::' . __LINE__ . ' Invalid RRULE:' . print_r($rrule->toArray(), true));
}
throw new Calendar_Exception('Invalid freq in RRULE: ' . $rrule->freq);
}
$rangeDate->add($interval, $freqMap[$rrule->freq]);
$attempts = 0;
if ($_event->rrule_until instanceof DateTime && Tinebase_Core::isLogLevel(Zend_Log::TRACE)) {
Tinebase_Core::getLogger()->trace(__METHOD__ . '::' . __LINE__ . ' Event rrule_until: ' . $_event->rrule_until->toString());
}
while (TRUE) {
if (Tinebase_Core::isLogLevel(Zend_Log::TRACE)) {
Tinebase_Core::getLogger()->trace(__METHOD__ . '::' . __LINE__ . ' trying to find next occurrence from ' . $from->toString());
}
if ($_event->rrule_until instanceof DateTime && $from->isLater($_event->rrule_until)) {
if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) {
Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . ' passed rrule_until -> no further occurrences');
}
return NULL;
}
$until = $_event->rrule_until instanceof DateTime && $until->isLater($_event->rrule_until) ? clone $_event->rrule_until : $until;
$recurSet->merge(self::computeRecurrenceSet($_event, $exceptions, $from, $until));
$attempts++;
// NOTE: computeRecurrenceSet also returns events during $from in some cases, but we need
// to events later than $from.
$recurSet = $recurSet->filter(function ($event) use($from) {
return $event->dtstart >= $from;
});
if (count($recurSet) >= abs($_which)) {
if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) {
Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . " found next occurrence after {$attempts} attempt(s)");
}
break;
}
if ($attempts > count($exceptions) + 5) {
if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) {
Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . " could not find the next occurrence after {$attempts} attempts, giving up");
}
return NULL;
}
$from->add($interval, $freqMap[$rrule->freq]);
$until->add($interval, $freqMap[$rrule->freq]);
}
$recurSet->sort('dtstart', $_which > 0 ? 'ASC' : 'DESC');
$nextOccurrence = $recurSet[abs($_which) - 1];
if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) {
Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . ' $nextOccurrence->dtstart = ' . $nextOccurrence->dtstart->toString());
}
return $nextOccurrence;
}
/**
* prepare message parts that could be interesting for other apps
*
* @param Expressomail_Model_Message $_message
*/
public function prepareAndProcessParts(Expressomail_Model_Message $_message)
{
$preparedParts = new Tinebase_Record_RecordSet('Expressomail_Model_PreparedMessagePart');
foreach ($this->_supportedForeignContentTypes as $application => $contentType) {
if (!Tinebase_Application::getInstance()->isInstalled($application) || !Tinebase_Core::getUser()->hasRight($application, Tinebase_Acl_Rights::RUN)) {
if (Tinebase_Core::isLogLevel(Zend_Log::INFO)) {
Tinebase_Core::getLogger()->info(__METHOD__ . '::' . __LINE__ . ' ' . $application . ' not installed or access denied.');
}
continue;
}
if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) {
Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . ' Looking for ' . $application . '[' . $contentType . '] content ...');
}
$parts = $_message->getBodyParts(NULL, $contentType);
foreach ($parts as $partId => $partData) {
if ($partData['contentType'] !== $contentType) {
continue;
}
if (Tinebase_Core::isLogLevel(Zend_Log::INFO)) {
Tinebase_Core::getLogger()->info(__METHOD__ . '::' . __LINE__ . ' ' . $application . '[' . $contentType . '] content found.');
}
$preparedPart = $this->_getForeignMessagePart($_message, $partId, $partData);
if ($preparedPart) {
$this->_processForeignMessagePart($application, $preparedPart);
$preparedParts->addRecord(new Expressomail_Model_PreparedMessagePart(array('id' => $_message->getId() . '_' . $partId, 'contentType' => $contentType, 'preparedData' => $preparedPart)));
}
}
}
$_message->preparedParts = $preparedParts;
}
/**
* calls method with each event matching given rid
*
* breaks if method returns false
*
* @param Calendar_Model_Event $event
* @param array $rid
* @param callable $method
* @return Tinebase_Record_RecordSet affectedEvents
*/
protected function _iterateByRid($event, $rid, $method)
{
$affectedEvents = new Tinebase_Record_RecordSet('Calendar_Model_Event');
if (!$rid || in_array('M', $rid)) {
$affectedEvents->addRecord($event);
}
if ($event->exdate instanceof Tinebase_Record_RecordSet) {
foreach ($event->exdate as $exception) {
if (!$rid) {
$affectedEvents->addRecord($exception);
}
}
}
foreach ($affectedEvents as $record) {
if ($method($record) === false) {
break;
}
}
return $affectedEvents;
}
/**
* create new folders or get existing folders from db and return record set
*
* @param array $_folders
* @param Felamimail_Model_Account $_account
* @param string $_parentFolder
* @return Tinebase_Record_RecordSet of Felamimail_Model_Folder
*
* @todo move delete sync to extra function
*/
protected function _getOrCreateFolders(array $_folders, $_account, $_parentFolder)
{
$parentFolder = $_parentFolder !== NULL ? $_parentFolder : '';
$result = new Tinebase_Record_RecordSet('Felamimail_Model_Folder');
$systemFolders = Felamimail_Controller_Folder::getInstance()->getSystemFolders($_account);
// get configured account standard folders here
if (strtolower($_account->sent_folder) != $systemFolders[2]) {
$systemFolders[2] = strtolower($_account->sent_folder);
}
if (strtolower($_account->trash_folder) != $systemFolders[5]) {
$systemFolders[5] = strtolower($_account->trash_folder);
}
if (Tinebase_Core::isLogLevel(Zend_Log::TRACE)) {
Tinebase_Core::getLogger()->trace(__METHOD__ . '::' . __LINE__ . ' ' . print_r($_folders, TRUE));
}
// do some mapping and save folder in db (if it doesn't exist
foreach ($_folders as $folderData) {
try {
$folderData['localName'] = Felamimail_Model_Folder::decodeFolderName($folderData['localName']);
$folderData['globalName'] = Felamimail_Model_Folder::decodeFolderName($folderData['globalName']);
$isSelectable = $this->_isSelectable($folderData, $_account);
$folder = Felamimail_Controller_Folder::getInstance()->getByBackendAndGlobalName($_account->getId(), $folderData['globalName']);
$folder->is_selectable = $isSelectable;
$folder->supports_condstore = $this->_supportsCondStore($folder, $_account);
$folder->imap_status = Felamimail_Model_Folder::IMAP_STATUS_OK;
$folder->has_children = $folderData['hasChildren'] == '1';
$folder->parent = $parentFolder;
if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) {
Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . ' Update cached folder ' . $folderData['globalName']);
}
} catch (Tinebase_Exception_NotFound $tenf) {
// create new folder
if (empty($folderData['localName'])) {
// skip
if (Tinebase_Core::isLogLevel(Zend_Log::INFO)) {
Tinebase_Core::getLogger()->info(__METHOD__ . '::' . __LINE__ . ' Do not add folder ' . $folderData['globalName'] . '. Localname is empty.');
}
continue;
} else {
$delimiter = strlen($folderData['delimiter']) === 1 ? $folderData['delimiter'] : '';
$folder = new Felamimail_Model_Folder(array('localname' => $folderData['localName'], 'globalname' => $folderData['globalName'], 'is_selectable' => $isSelectable, 'supports_condstore' => $this->_supportsCondStore($folderData['globalName'], $_account), 'has_children' => $folderData['hasChildren'] == '1', 'account_id' => $_account->getId(), 'imap_timestamp' => Tinebase_DateTime::now(), 'imap_status' => Felamimail_Model_Folder::IMAP_STATUS_OK, 'user_id' => Tinebase_Core::getUser()->getId(), 'parent' => $parentFolder, 'system_folder' => in_array(strtolower($folderData['localName']), $systemFolders), 'delimiter' => $delimiter));
// update delimiter setting of account
if ($folder->delimiter && $folder->delimiter !== $_account->delimiter && $folder->localname === 'INBOX') {
$_account->delimiter = $folder->delimiter;
$_account = Felamimail_Controller_Account::getInstance()->update($_account);
}
if (Tinebase_Core::isLogLevel(Zend_Log::INFO)) {
Tinebase_Core::getLogger()->info(__METHOD__ . '::' . __LINE__ . ' Adding new folder ' . $folderData['globalName'] . ' to cache.');
}
if (Tinebase_Core::isLogLevel(Zend_Log::TRACE)) {
Tinebase_Core::getLogger()->trace(__METHOD__ . '::' . __LINE__ . print_r($folder->toArray(), true));
}
$folder = $this->_backend->create($folder);
}
}
$result->addRecord($folder);
}
if (count($_folders) > 0) {
$this->_removeFromCache($_account, $parentFolder, $result->getArrayOfIds());
}
return $result;
}
