/**
* test timeaccount - sales contract filter
* also tests Tinebase_Model_Filter_ExplicitRelatedRecord
*/
public function testTimeaccountContractFilter()
{
$this->_getTimeaccount(array('title' => 'TA1', 'number' => 12345, 'description' => 'UnitTest'), true);
$ta1 = $this->_timeaccountController->get($this->_lastCreatedRecord['id']);
$this->_getTimeaccount(array('title' => 'TA2', 'number' => 12346, 'description' => 'UnitTest'), true);
$ta2 = $this->_timeaccountController->get($this->_lastCreatedRecord['id']);
$cId = Tinebase_Container::getInstance()->getDefaultContainer('Sales_Model_Contract')->getId();
$contract = Sales_Controller_Contract::getInstance()->create(new Sales_Model_Contract(array('title' => 'testRelateTimeaccount', 'number' => Tinebase_Record_Abstract::generateUID(), 'container_id' => $cId)));
$ta1->relations = array($this->_getRelation($contract, $ta1));
$this->_timeaccountController->update($ta1);
// search by contract
$f = new Timetracker_Model_TimeaccountFilter(array(array('field' => 'contract', 'operator' => 'AND', 'value' => array(array('field' => ':id', 'operator' => 'equals', 'value' => $contract->getId())))));
$filterArray = $f->toArray();
$this->assertEquals($contract->getId(), $filterArray[0]['value'][0]['value']['id']);
$result = $this->_timeaccountController->search($f);
$this->assertEquals(1, $result->count());
$this->assertEquals('TA1', $result->getFirstRecord()->title);
// test empty filter (without contract)
$f = new Timetracker_Model_TimeaccountFilter(array(array('field' => 'contract', 'operator' => 'AND', 'value' => array(array('field' => ':id', 'operator' => 'equals', 'value' => null))), array('field' => 'description', 'operator' => 'equals', 'value' => 'UnitTest')));
$result = $this->_timeaccountController->search($f);
$this->assertEquals(1, $result->count(), 'Only one record should have been found!');
$this->assertEquals('TA2', $result->getFirstRecord()->title);
// test generic relation filter
$f = new Timetracker_Model_TimeaccountFilter(array(array('field' => 'foreignRecord', 'operator' => 'AND', 'value' => array('appName' => 'Sales', 'linkType' => 'relation', 'modelName' => 'Contract', 'filters' => array('field' => 'query', 'operator' => 'contains', 'value' => 'TA1')))));
$result = $this->_timeaccountController->search($f);
$this->assertEquals(1, $result->count());
$this->assertEquals('TA1', $result->getFirstRecord()->title);
// test "not" operator
$f = new Timetracker_Model_TimeaccountFilter(array(array('field' => 'contract', 'operator' => 'AND', 'value' => array(array('field' => ':id', 'operator' => 'not', 'value' => $contract->getId()))), array('field' => 'description', 'operator' => 'equals', 'value' => 'UnitTest')));
$result = $this->_timeaccountController->search($f);
// TODO is this correct? do we expect the timaccount without contract to be missing from results?
$this->assertEquals(0, $result->count(), 'No record should be found');
}
public function __construct(array $_values = array())
{
$this->_id = Tinebase_Record_Abstract::generateUID();
foreach ($_values as $key => $value) {
$this->{$key} = $value;
}
}
/**
* set up tests
*
*/
protected function setUp()
{
parent::setUp();
$this->_instance = Tinebase_Notes::getInstance();
$this->_objects['contact'] = new Addressbook_Model_Contact(array('id' => Tinebase_Record_Abstract::generateUID(), 'n_family' => 'phpunit notes contact'));
$this->_objects['record'] = array('id' => $this->_objects['contact']->getId(), 'model' => 'Addressbook_Model_Contact', 'backend' => 'Sql');
}
public function testToArrayJsonNonExisting()
{
$nonExistingId = Tinebase_Record_Abstract::generateUID();
$filter = new Addressbook_Model_ContactIdFilter('id', 'equals', $nonExistingId);
$filterArray = $filter->toArray(TRUE);
$this->assertEquals($nonExistingId, $filterArray['value']);
}
/**
* Sets up the fixture.
*
* This method is called before a test is executed.
*/
protected function setUp()
{
Tinebase_TransactionManager::getInstance()->startTransaction(Tinebase_Core::getDb());
// we need that because the voip db tables can have a different prefix
Tinebase_Core::set('voipdbTablePrefix', SQL_TABLE_PREFIX);
$phoneId = Tinebase_Record_Abstract::generateUID();
$this->_objects['location'] = new Voipmanager_Model_Snom_Location(array('id' => Tinebase_Record_Abstract::generateUID(), 'name' => 'phpunit test location', 'registrar' => 'registrar'));
$this->_objects['software'] = new Voipmanager_Model_Snom_Software(array('id' => Tinebase_Record_Abstract::generateUID()));
$this->_objects['setting'] = new Voipmanager_Model_Snom_Setting(array('id' => Tinebase_Record_Abstract::generateUID(), 'name' => Tinebase_Record_Abstract::generateUID(), 'description' => Tinebase_Record_Abstract::generateUID(), 'language_w' => true));
$this->_objects['phonesettings'] = new Voipmanager_Model_Snom_PhoneSettings(array('phone_id' => $phoneId, 'language' => 'Deutsch'));
$this->_objects['template'] = new Voipmanager_Model_Snom_Template(array('id' => Tinebase_Record_Abstract::generateUID(), 'name' => 'phpunit test location', 'software_id' => $this->_objects['software']->getId(), 'setting_id' => $this->_objects['setting']->getId()));
$this->_objects['phone'] = new Voipmanager_Model_Snom_Phone(array('id' => $phoneId, 'macaddress' => "1234567890cd", 'location_id' => $this->_objects['location']->getId(), 'template_id' => $this->_objects['template']->getId(), 'current_model' => 'snom320', 'redirect_event' => 'none'));
$this->_objects['phoneOwner'] = array('account_id' => Zend_Registry::get('currentAccount')->getId(), 'account_type' => 'user');
$rights = new Tinebase_Record_RecordSet('Voipmanager_Model_Snom_PhoneRight', array($this->_objects['phoneOwner']));
$this->_objects['phone']->rights = $rights;
// create phone, location, template
$snomLocationBackend = new Voipmanager_Backend_Snom_Location();
$snomTemplateBackend = new Voipmanager_Backend_Snom_Template();
$snomSoftwareBackend = new Voipmanager_Backend_Snom_Software();
$snomPhoneBackend = new Voipmanager_Backend_Snom_Phone();
$snomSettingBackend = new Voipmanager_Backend_Snom_Setting();
$snomPhoneSettingsBackend = new Voipmanager_Backend_Snom_PhoneSettings();
$snomSoftwareBackend->create($this->_objects['software']);
$snomLocationBackend->create($this->_objects['location']);
$snomTemplateBackend->create($this->_objects['template']);
$snomSettingBackend->create($this->_objects['setting']);
$snomPhoneBackend->create($this->_objects['phone']);
$snomPhoneSettingsBackend->create($this->_objects['phonesettings']);
}
/**
* do conversions
*
* @param array $_data
* @return array
*/
protected function _doConversions($_data)
{
$result = parent::_doConversions($_data);
if ((isset($result['warranty']) || array_key_exists('warranty', $result)) && empty($_data['warranty'])) {
unset($result['warranty']);
}
if ((isset($result['invoice_date']) || array_key_exists('invoice_date', $result)) && empty($_data['invoice_date'])) {
unset($result['invoice_date']);
}
if ((isset($result["name"]) || array_key_exists("name", $result)) && $result['name'] == "") {
$result['name'] = "!Not defined!";
}
if ((isset($result["inventory_id"]) || array_key_exists("inventory_id", $result)) && $result['inventory_id'] == "") {
$result['inventory_id'] = Tinebase_Record_Abstract::generateUID(40);
}
if (isset($result["costcentre"]) || array_key_exists("costcentre", $result)) {
$result["costcentre"] = $c = Sales_Controller_CostCenter::getInstance()->search(new Sales_Model_CostCenterFilter(array(array('field' => 'number', 'operator' => 'equals', 'value' => $result["costcentre"]))))->getFirstRecord();
}
if (isset($result["status"]) || array_key_exists("status", $result)) {
$statusRecord = Inventory_Config::getInstance()->get(Inventory_Config::INVENTORY_STATUS)->getKeyfieldRecordByValue($result["status"]);
if (empty($statusRecord)) {
$statusRecord = Inventory_Config::getInstance()->get(Inventory_Config::INVENTORY_STATUS)->getKeyfieldDefault();
}
$result["status"] = $statusRecord['id'];
}
return $result;
}
/**
* overwritten parent constructor to load configuration, calls parent constructor
*
* supported configuration keys:
* logruntime => prepend time passed since request started
* logdifftime => prepend time passed since last log message
*
* @param string $format
*/
function __construct(string $format = null)
{
parent::__construct($format);
if (!self::$_prefix) {
self::$_prefix = Tinebase_Record_Abstract::generateUID(5);
}
if (self::$_starttime === NULL) {
self::$_starttime = Tinebase_Core::get(Tinebase_Core::STARTTIME);
if (self::$_starttime === NULL) {
self::$_starttime = microtime(true);
}
}
if (self::$_logruntime === NULL || self::$_logdifftime === NULL) {
$config = Tinebase_Core::getConfig();
if ($config->logger->logruntime) {
self::$_logruntime = true;
} else {
self::$_logruntime = false;
}
if ($config->logger->logdifftime) {
self::$_logdifftime = true;
} else {
self::$_logdifftime = false;
}
}
}
/**
* appends sql to given select statement
*
* @param Zend_Db_Select $_select
* @param Tinebase_Backend_Sql_Abstract $_backend
* @throws Tinebase_Exception_UnexpectedValue
*/
public function appendFilterSql($_select, $_backend)
{
// don't take empty filter into account
if (empty($this->_value) || !is_array($this->_value) || !isset($this->_value['cfId']) || empty($this->_value['cfId']) || !isset($this->_value['value'])) {
return;
} else {
if ($this->_operator == 'in') {
throw new Tinebase_Exception_UnexpectedValue('Operator "in" not supported.');
}
}
// make sure $correlationName is a string
$correlationName = Tinebase_Record_Abstract::generateUID() . $this->_value['cfId'] . 'cf';
if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) {
Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . ' Adding custom field filter: ' . print_r($this->_value, true));
}
$db = Tinebase_Core::getDb();
$idProperty = $db->quoteIdentifier($this->_options['idProperty']);
// per left join we add a customfield column named as the customfield and filter this joined column
// NOTE: we name the column we join like the customfield, to be able to join multiple customfield criteria (multiple invocations of this function)
$what = array($correlationName => SQL_TABLE_PREFIX . 'customfield');
$on = $db->quoteIdentifier("{$correlationName}.record_id") . " = {$idProperty} AND " . $db->quoteIdentifier("{$correlationName}.customfield_id") . " = " . $db->quote($this->_value['cfId']);
$_select->joinLeft($what, $on, array());
$valueIdentifier = $db->quoteIdentifier("{$correlationName}.value");
if ($this->_value['value'] === '') {
$where = $db->quoteInto($valueIdentifier . ' IS NULL OR ' . $valueIdentifier . ' = ?', $this->_value['value']);
} else {
$value = $this->_replaceWildcards($this->_value['value']);
$where = $db->quoteInto($valueIdentifier . $this->_opSqlMap[$this->_operator]['sqlop'], $value);
}
$_select->where($where . ' /* add cf filter */');
}
/**
* appends sql to given select statement
*
* @param Zend_Db_Select $_select
* @param Tinebase_Backend_Sql_Abstract $_backend
*/
public function appendFilterSql($_select, $_backend)
{
$correlationName = Tinebase_Record_Abstract::generateUID(30);
$db = $_backend->getAdapter();
$_select->joinLeft(array($correlationName => $db->table_prefix . 'adb_list_m_role'), $db->quoteIdentifier($correlationName . '.contact_id') . ' = ' . $db->quoteIdentifier('addressbook.id'), array());
$_select->where($db->quoteIdentifier($correlationName . '.list_role_id') . ' IN (?)', (array) $this->_value);
}
/**
* testBackslashInDescription
*
* @see 0009176: iCal adds another backslash to description field
*/
public function testBackslashInDescription()
{
$event = new Calendar_Model_Event(array('summary' => 'CalDAV test', 'dtstart' => Tinebase_DateTime::now(), 'dtend' => Tinebase_DateTime::now()->addHour(1), 'description' => 'lalala \\\\', 'originator_tz' => 'Europe/Berlin', 'creation_time' => Tinebase_DateTime::now(), 'uid' => Tinebase_Record_Abstract::generateUID(), 'seq' => 1));
$converter = Calendar_Convert_Event_VCalendar_Factory::factory(Calendar_Convert_Event_VCalendar_Factory::CLIENT_MACOSX);
$vevent = $converter->fromTine20Model($event)->serialize();
$convertedEvent = $converter->toTine20Model($vevent);
$this->assertEquals($event->description, $convertedEvent->description);
}
/**
* Test create a scheduled import
*/
public function createScheduledImport($source = 'http://localhost/test.ics')
{
$id = Tinebase_Record_Abstract::generateUID();
$import = new Tinebase_Model_Import(array('id' => $id, 'user_id' => $this->_originalTestUser->getId(), 'interval' => Tinebase_Model_Import::INTERVAL_HOURLY, 'model' => Calendar_Controller::getInstance()->getDefaultModel(), 'application_id' => Tinebase_Application::getInstance()->getApplicationByName('Calendar')->getId(), 'container_id' => $this->_testCalendar->getId(), 'sourcetype' => Tinebase_Model_Import::SOURCETYPE_REMOTE, 'source' => $source, 'options' => json_encode(array('forceUpdateExisting' => TRUE, 'import_defintion' => NULL, 'plugin' => 'Calendar_Import_Ical'))));
$record = $this->_uit->create($import);
$this->assertEquals(Calendar_Controller::getInstance()->getDefaultModel(), $this->_uit->get($id)->model);
return $record;
}
/**
* test to create a new directory
*/
public function testCreateDirectory()
{
$randomName = Tinebase_Record_Abstract::generateUID();
$collection = new Addressbook_Frontend_WebDAV(\Sabre\CardDAV\Plugin::ADDRESSBOOK_ROOT . '/' . Tinebase_Core::getUser()->contact_id, true);
$collection->createDirectory($randomName);
$container = Tinebase_Container::getInstance()->getContainerByName('Addressbook', $randomName, Tinebase_Model_Container::TYPE_PERSONAL, Tinebase_Core::getUser());
$this->assertTrue($container instanceof Tinebase_Model_Container);
}
/**
* Test create a access log and logout to set logout time
*
* @see 0010728: Strange error in tine20 log when performing logout from Web
*/
public function testSetLogout()
{
$accessLog = new Tinebase_Model_AccessLog(array('ip' => '127.0.0.1', 'li' => Tinebase_DateTime::now(), 'result' => Zend_Auth_Result::SUCCESS, 'clienttype' => 'unittest', 'login_name' => 'unittest', 'user_agent' => 'phpunit', 'sessionid' => Tinebase_Record_Abstract::generateUID()), true);
$this->_uit->setSessionId($accessLog);
$this->_uit->create($accessLog);
$accessLog = $this->_uit->setLogout();
$this->assertEquals(Tinebase_DateTime::now()->toString(), $accessLog->lo->toString(), 'logout time mismatch/empty: ' . print_r($accessLog, true));
}
/**
* appends sql to given select statement
*
* @param Zend_Db_Select $_select
* @param Tinebase_Backend_Sql_Abstract $_backend
* @throws Tinebase_Exception_NotFound
*/
public function appendFilterSql($_select, $_backend)
{
$db = $_backend->getAdapter();
$correlationName = Tinebase_Record_Abstract::generateUID() . $this->_value . 'owner';
$_select->joinLeft(array($correlationName => SQL_TABLE_PREFIX . 'container_acl'), $db->quoteIdentifier("{$correlationName}.container_id") . " = container.id", array());
// only personal containers have an owner!
$_select->where("{$db->quoteIdentifier('container.type')} = ?", Tinebase_Model_Container::TYPE_PERSONAL);
// assure admin grant
$_select->where($db->quoteIdentifier("{$correlationName}.account_id") . " = " . $db->quote($this->_value) . ' AND ' . $db->quoteIdentifier("{$correlationName}.account_grant") . " = ?", Tinebase_Model_Grants::GRANT_ADMIN);
}
/**
* test create contact with photo
*
* @return Addressbook_Frontend_WebDAV_Contact
*/
public function testCreateContactWithPhoto()
{
$vcardStream = fopen(dirname(__FILE__) . '/../../Import/files/jan.vcf', 'r');
$id = Tinebase_Record_Abstract::generateUID();
$contact = Addressbook_Frontend_WebDAV_Contact::create($this->objects['initialContainer'], "{$id}.vcf", $vcardStream);
$record = $contact->getRecord();
$imgBlob = $record->getSmallContactImage();
$this->assertTrue(strlen($imgBlob) > 0);
$this->assertTrue(strlen($imgBlob) < Addressbook_Model_Contact::SMALL_PHOTO_SIZE);
}
/**
* @param $shadowPath
* @param $newPath
* @param $oldPath
* @param $newShadowPath
* @param $oldShadowPath
*/
public function copyTreeByShadowPath($shadowPath, $newPath, $oldPath, $newShadowPath, $oldShadowPath)
{
$select = $this->_db->select()->from($this->_tablePrefix . $this->_tableName, array('path' => new Zend_Db_Expr($this->_db->quoteInto($this->_db->quoteInto('REPLACE(path, ?', $oldPath) . ', ?)', $newPath)), 'shadow_path' => new Zend_Db_Expr($this->_db->quoteInto($this->_db->quoteInto('REPLACE(shadow_path, ?', $oldShadowPath) . ', ?)', $newShadowPath)), 'record_id' => 'record_id', 'creation_time' => new Zend_Db_Expr('NOW()')))->where($this->_db->quoteInto($this->_db->quoteIdentifier('shadow_path') . ' like ?', $shadowPath . '/%'));
$stmt = $this->_db->query($select);
$entries = $stmt->fetchAll(Zend_Db::FETCH_ASSOC);
foreach ($entries as $entry) {
$entry['id'] = Tinebase_Record_Abstract::generateUID();
$this->_db->insert($this->_tablePrefix . $this->_tableName, $entry);
}
}
/**
* Sets up the fixture.
* This method is called before a test is executed.
*
* @access protected
*/
protected function setUp()
{
parent::setUp();
$this->objects['initialContainer'] = Tinebase_Container::getInstance()->addContainer(new Tinebase_Model_Container(array('name' => Tinebase_Record_Abstract::generateUID(), 'type' => Tinebase_Model_Container::TYPE_PERSONAL, 'backend' => 'Sql', 'application_id' => Tinebase_Application::getInstance()->getApplicationByName('Calendar')->getId())));
$this->server = new Sabre\DAV\Server(new Tinebase_WebDav_Root());
$this->plugin = new Tinebase_WebDav_Plugin_Inverse();
$this->server->addPlugin($this->plugin);
$this->response = new Sabre\HTTP\ResponseMock();
$this->server->httpResponse = $this->response;
}
/**
* Formats data into a single line to be written by the writer.
*
* @param array $event event data
* @return string formatted line to write to the log
*/
public function format($event)
{
if (!self::$_sessionId) {
self::$_sessionId = substr(Tinebase_Record_Abstract::generateUID(), 0, 5);
}
$user = Tinebase_Core::getUser();
$userName = $user && is_object($user) ? $user->accountDisplayName : '-- none --';
$output = parent::format($event);
return self::$_sessionId . " {$userName} - {$output}";
}
/**
* tests the correct replacement of markers with different contents
*/
public function testMarkerReplacement()
{
$doc = new OpenDocument_Document(OpenDocument_Document::SPREADSHEET);
$table = $doc->getBody()->appendTable('UNITTEST');
$titleText = 'Hello unittest!';
$row = $table->appendRow();
$cell = $row->appendCell($titleText);
$row = $table->appendRow();
$row = $table->appendRow();
$cell = $row->appendCell('###MATRIX###');
$row = $table->appendRow();
$row = $table->appendRow();
$cell = $row->appendCell('###MARKER###');
$filename = Tinebase_Config::getInstance()->get('tmpdir') . DIRECTORY_SEPARATOR . Tinebase_Record_Abstract::generateUID(4) . '-ods-unittest.ods';
$ccc = Sales_Controller_CostCenter::getInstance();
$cc1 = $ccc->create(new Sales_Model_CostCenter(array('number' => 'cc1', 'remark' => 'unittest-cc1')));
$cc2 = $ccc->create(new Sales_Model_CostCenter(array('number' => 'cc2', 'remark' => 'unittest-cc2')));
$colInfo = array();
$colInfo[$cc1->getId()] = $cc1->number;
$colInfo[$cc2->getId()] = $cc2->number;
$matrixArray = array($cc1->getId() => array($cc2->getId() => '100'), $cc2->getId() => array($cc1->getId() => '200'));
$matrix = new OpenDocument_Matrix($matrixArray, $colInfo, $colInfo, OpenDocument_Matrix::TYPE_FLOAT);
$matrix->setColumnLegendDescription('Cat');
$matrix->setRowLegendDescription('Dog');
$markerText = 'unittest-marker';
$doc->replaceMarker('marker', $markerText)->replaceMatrix('matrix', $matrix);
$doc->getDocument($filename);
$contentXml = file_get_contents('zip://' . $filename . '#content.xml');
$xml = simplexml_load_string($contentXml);
unlink($filename);
$spreadSheets = $xml->xpath('//office:body/office:spreadsheet');
$this->assertEquals(1, count($spreadSheets));
$spreadSheet = $spreadSheets[0];
$results = $spreadSheet->xpath("//text()[contains(., '{$markerText}')]");
$this->assertEquals(1, count($results));
$results = $spreadSheet->xpath("//text()[contains(., '{$titleText}')]");
$this->assertEquals(1, count($results));
$results = $spreadSheet->xpath("//text()[contains(., '{$cc1->number}')]");
$this->assertEquals(2, count($results));
$results = $spreadSheet->xpath("//text()[contains(., '{$cc2->number}')]");
$this->assertEquals(2, count($results));
$results = $spreadSheet->xpath("//text()[contains(., 'Sum')]");
$this->assertEquals(2, count($results));
$results = $spreadSheet->xpath("//text()[contains(., 'Cat')]");
$this->assertEquals(1, count($results));
$results = $spreadSheet->xpath("//text()[contains(., 'Dog')]");
$this->assertEquals(1, count($results));
$results = $spreadSheet->xpath("//text()[contains(., '100')]");
$this->assertEquals(3, count($results));
$results = $spreadSheet->xpath("//text()[contains(., '200')]");
$this->assertEquals(3, count($results));
$results = $spreadSheet->xpath("//text()[contains(., '300')]");
$this->assertEquals(1, count($results));
}
/**
* set up tests
*
*/
public function setUp()
{
$user = Tinebase_Core::getUser();
$container = $user->getPersonalContainer('Tasks', $user, Tinebase_Model_Grants::GRANT_ADMIN);
$container_id = $container[0]->getId();
$backend = new Tasks_Backend_Sql();
$testTask1 = new Tasks_Model_Task(array('uid' => Tinebase_Record_Abstract::generateUID(), 'container_id' => $container_id, 'created_by' => 6, 'creation_time' => '2009-03-31 17:35:00', 'is_deleted' => 0, 'deleted_time' => NULL, 'deleted_by' => NULL, 'percent' => 70, 'completed' => NULL, 'due' => '2009-04-30 17:35:00', 'description' => "Test Task", 'geo' => 0.2345, 'location' => 'here and there', 'organizer' => Tinebase_Core::getUser()->getId(), 'priority' => 2, 'status' => 'NEEDS-ACTION', 'summary' => 'our first test task', 'url' => 'http://www.testtask.com'));
$backend->create($testTask1);
$pfe = new Tinebase_PersistentFilter_Backend_Sql();
$pfe->create(new Tinebase_Model_PersistentFilter(array('name' => Tasks_Preference::DEFAULTPERSISTENTFILTER_NAME, 'description' => "All my tasks", 'account_id' => NULL, 'application_id' => Tinebase_Application::getInstance()->getApplicationByName('Tasks')->getId(), 'model' => 'Tasks_Model_TaskFilter', 'filters' => array(array('condition' => 'OR', 'filters' => array(array('field' => 'container_id', 'operator' => 'equals', 'value' => '/personal/' . Tinebase_Model_User::CURRENTACCOUNT), array('field' => 'organizer', 'operator' => 'equals', 'value' => Tinebase_Model_User::CURRENTACCOUNT)))))));
}
protected function setupCalendarContent()
{
$eventController = Calendar_Controller_Event::getInstance();
$event = new Calendar_Model_Event(array('uid' => Tinebase_Record_Abstract::generateUID(), 'container_id' => $this->objects['initialContainer']->id, 'summary' => 'change socks', 'dtstart' => '1979-06-05 07:55:00', 'dtend' => '1979-06-05 08:00:00', 'rrule' => 'FREQ=DAILY;INTERVAL=2;UNTIL=2009-04-01 08:00:00', 'exdate' => '2009-03-31 07:00:00', 'originator_tz' => 'Europe/Berlin', 'rrule_until' => '2009-04-01 08:00:00', Tinebase_Model_Grants::GRANT_EDIT => true));
$eventController->create($event);
$event = new Calendar_Model_Event(array('uid' => Tinebase_Record_Abstract::generateUID(), 'container_id' => $this->objects['initialContainer']->id, 'summary' => 'change t-shirt', 'dtstart' => '1979-06-05 08:00:00', 'dtend' => '1979-06-05 08:05:00', 'rrule' => 'FREQ=DAILY;INTERVAL=2;UNTIL=2009-04-01 08:00:00', 'exdate' => '2009-03-31 07:00:00', 'originator_tz' => 'Europe/Berlin', 'rrule_until' => '2009-04-01 08:00:00', Tinebase_Model_Grants::GRANT_EDIT => true));
$persistentEvent = $eventController->create($event);
$exception = clone $persistentEvent;
$exception->summary = 'use blue t-shirt today';
$eventController->createRecurException($exception);
}
/**
* test if config from config.inc.php overwrites config in db
*
*/
public function testConfigFromFileOverwrites()
{
$configData = (include 'config.inc.php');
if (!(isset($configData['Overwrite Test']) || array_key_exists('Overwrite Test', $configData))) {
$this->markTestSkipped('config.inc.php has no test key "Overwrite Test"');
return;
}
$overwrittenValue = Tinebase_Record_Abstract::generateUID();
$this->_instance->{'Overwrite Test'} = $overwrittenValue;
$this->assertEquals($configData['Overwrite Test'], $this->_instance->{'Overwrite Test'});
$this->_instance->delete('Overwrite Test');
}
protected function _createFailingContracts()
{
// add contract not to bill
$this->_contractRecords->addRecord($this->_contractController->create(new Sales_Model_Contract(array('number' => 5, 'title' => Tinebase_Record_Abstract::generateUID(), 'description' => '5 unittest no auto', 'container_id' => $this->_sharedContractsContainerId, 'billing_address_id' => $this->_addressRecords->filter('customer_id', $this->_customerRecords->filter('name', 'Customer3')->getFirstRecord()->getId())->filter('type', 'billing')->getFirstRecord()->getId(), 'start_date' => $this->_referenceDate, 'end_date' => NULL))));
// add contract without customer
$contract = new Sales_Model_Contract(array('number' => 6, 'title' => Tinebase_Record_Abstract::generateUID(), 'description' => '6 unittest auto not possible', 'container_id' => $this->_sharedContractsContainerId, 'start_date' => $this->_referenceDate, 'end_date' => NULL, 'billing_address_id' => $this->_addressRecords->filter('customer_id', $this->_customerRecords->filter('name', 'Customer3')->getFirstRecord()->getId())->filter('type', 'billing')->getFirstRecord()->getId()));
$contract->relations = array(array('own_model' => 'Sales_Model_Contract', 'own_backend' => Tasks_Backend_Factory::SQL, 'own_id' => NULL, 'own_degree' => Tinebase_Model_Relation::DEGREE_SIBLING, 'related_model' => 'Sales_Model_CostCenter', 'related_backend' => Tasks_Backend_Factory::SQL, 'related_id' => $this->_costcenterRecords->getFirstRecord()->getId(), 'type' => 'LEAD_COST_CENTER'));
$this->_contractRecords->addRecord($this->_contractController->create($contract));
// add contract without address
$contract = new Sales_Model_Contract(array('number' => 7, 'title' => Tinebase_Record_Abstract::generateUID(), 'description' => '7 unittest auto not possible', 'container_id' => $this->_sharedContractsContainerId, 'start_date' => $this->_referenceDate, 'end_date' => NULL));
$this->_contractRecords->addRecord($this->_contractController->create($contract));
}
/**
* Sets up the fixture, for example, opens a network connection.
* This method is called before a test is executed.
*
* @access protected
*/
protected function setUp()
{
parent::setUp();
Sales_Controller_Contract::getInstance()->setNumberPrefix();
Sales_Controller_Contract::getInstance()->setNumberZerofill();
$this->_object = Tinebase_Relations::getInstance();
$this->_relations = array();
$this->_crmId = array('model' => 'Crm_Model_Lead', 'backend' => 'SQL', 'id' => Tinebase_Record_Abstract::generateUID());
$this->_crmId2 = array('model' => 'Crm_Model_Lead', 'backend' => 'SQL', 'id' => Tinebase_Record_Abstract::generateUID());
$this->_relationData = array(array('own_model' => 'Crm_Model_Lead', 'own_backend' => 'SQL', 'own_id' => $this->_crmId['id'], 'own_degree' => Tinebase_Model_Relation::DEGREE_SIBLING, 'related_model' => 'Tasks_Model_Task', 'related_backend' => Tasks_Backend_Factory::SQL, 'related_id' => Tinebase_Record_Abstract::generateUID(), 'type' => 'CRM_TASK'), array('own_model' => 'Crm_Model_Lead', 'own_backend' => 'SQL', 'own_id' => $this->_crmId['id'], 'own_degree' => Tinebase_Model_Relation::DEGREE_PARENT, 'related_model' => 'Tasks_Model_Task', 'related_backend' => '', 'related_id' => '', 'related_record' => array('summary' => 'phpunit test task for relations from crm', 'description' => 'This task was created by phpunit when testing relations', 'due' => '2010-06-11T15:47:40'), 'type' => 'CRM_TASK'), array('own_model' => '', 'own_backend' => '', 'own_id' => '', 'own_degree' => Tinebase_Model_Relation::DEGREE_PARENT, 'related_model' => 'Addressbook_Model_Contact', 'related_backend' => '', 'related_id' => '', 'related_record' => array('n_family' => 'Weiss', 'n_given' => 'Cornelius', 'bday' => '1979-06-05T00:00:00', 'container_id' => ''), 'type' => 'PARTNER'));
$this->_object->setRelations($this->_crmId['model'], $this->_crmId['backend'], $this->_crmId['id'], $this->_relationData);
}
/**
* (non-PHPdoc)
* @see ActiveSync/ActiveSync_TestCase::setUp()
*/
protected function setUp()
{
parent::setUp();
// replace email to make current user organizer and attendee
$this->_testXMLInput = str_replace('*****@*****.**', Tinebase_Core::getUser()->accountEmailAddress, $this->_testXMLInput);
$event = new Calendar_Model_Event(array('uid' => Tinebase_Record_Abstract::generateUID(), 'summary' => 'SyncTest', 'dtstart' => Tinebase_DateTime::now()->addMonth(1)->toString(Tinebase_Record_Abstract::ISO8601LONG), 'dtend' => Tinebase_DateTime::now()->addMonth(1)->addHour(1)->toString(Tinebase_Record_Abstract::ISO8601LONG), 'originator_tz' => 'Europe/Berlin', 'container_id' => $this->_getContainerWithSyncGrant()->getId(), Tinebase_Model_Grants::GRANT_EDIT => true, 'attendee' => new Tinebase_Record_RecordSet('Calendar_Model_Attender', array(array('user_id' => Tinebase_Core::getUser()->contact_id, 'user_type' => Calendar_Model_Attender::USERTYPE_USER, 'status' => Calendar_Model_Attender::STATUS_ACCEPTED)))));
$event = Calendar_Controller_Event::getInstance()->create($event);
$this->objects['event'] = $event;
$event2MonthsBack = new Calendar_Model_Event(array('uid' => Tinebase_Record_Abstract::generateUID(), 'summary' => 'SyncTest', 'dtstart' => Tinebase_DateTime::now()->subMonth(2)->toString(Tinebase_Record_Abstract::ISO8601LONG), 'dtend' => Tinebase_DateTime::now()->subMonth(2)->addHour(1)->toString(Tinebase_Record_Abstract::ISO8601LONG), 'originator_tz' => 'Europe/Berlin', 'container_id' => $this->_getContainerWithSyncGrant()->getId(), Tinebase_Model_Grants::GRANT_EDIT => true));
$event = Calendar_Controller_Event::getInstance()->create($event2MonthsBack);
$this->objects['event2MonthsBack'] = $event;
$eventDaily = new Calendar_Model_Event(array('uid' => Tinebase_Record_Abstract::generateUID(), 'summary' => 'SyncTest', 'dtstart' => Tinebase_DateTime::now()->addMonth(1)->toString(Tinebase_Record_Abstract::ISO8601LONG), 'dtend' => Tinebase_DateTime::now()->addMonth(1)->addHour(1)->toString(Tinebase_Record_Abstract::ISO8601LONG), 'originator_tz' => 'Europe/Berlin', 'rrule' => 'FREQ=DAILY;INTERVAL=1;UNTIL=' . Tinebase_DateTime::now()->addMonth(1)->addDay(6)->setHour(22)->setMinute(59)->setSecond(59)->toString(Tinebase_Record_Abstract::ISO8601LONG), 'container_id' => $this->_getContainerWithSyncGrant()->getId(), Tinebase_Model_Grants::GRANT_EDIT => true));
$eventDaily = Calendar_Controller_Event::getInstance()->create($eventDaily);
// compute recurset
$recurSet = Calendar_Model_Rrule::computeRecurrenceSet($eventDaily, new Tinebase_Record_RecordSet('Calendar_Model_Event'), $eventDaily->dtstart, $eventDaily->rrule_until);
// first deleted instance
Calendar_Controller_Event::getInstance()->createRecurException($recurSet[0], true);
// second deleted instance
Calendar_Controller_Event::getInstance()->createRecurException($recurSet[1], true);
// first exception instance
$recurSet[2]->dtstart->addHour(2);
$recurSet[2]->dtend->addHour(2);
$recurSet[2]->summary = 'Test Exception 1';
Calendar_Controller_Event::getInstance()->createRecurException($recurSet[2]);
// first exception instance
$recurSet[3]->dtstart->addHour(3);
$recurSet[3]->dtend->addHour(3);
$recurSet[3]->summary = 'Test Exception 2';
Calendar_Controller_Event::getInstance()->createRecurException($recurSet[3]);
// reread event from database again
$eventDaily = Calendar_Controller_Event::getInstance()->get($eventDaily);
#var_dump($eventDaily->toArray());
$this->objects['eventDaily'] = $eventDaily;
Tinebase_Core::getPreference('ActiveSync')->setValue(ActiveSync_Preference::DEFAULTCALENDAR, $this->_getContainerWithSyncGrant()->getId());
########### define test filter
$filterBackend = new Tinebase_PersistentFilter_Backend_Sql();
try {
$filter = $filterBackend->getByProperty('Calendar Sync Test', 'name');
} catch (Tinebase_Exception_NotFound $e) {
$filter = new Tinebase_Model_PersistentFilter(array('application_id' => Tinebase_Application::getInstance()->getApplicationByName('Calendar')->getId(), 'account_id' => Tinebase_Core::getUser()->getId(), 'model' => 'Calendar_Model_EventFilter', 'filters' => array(array('field' => 'container_id', 'operator' => 'equals', 'value' => $this->_getContainerWithSyncGrant()->getId())), 'name' => 'Calendar Sync Test', 'description' => 'Created by unit test'));
$filter = $filterBackend->create($filter);
}
$this->objects['filter'] = $filter;
########### define test devices
$palm = ActiveSync_Backend_DeviceTests::getTestDevice(Syncope_Model_Device::TYPE_WEBOS);
$palm->owner_id = $this->_testUser->getId();
$palm->calendarfilter_id = $this->objects['filter']->getId();
$this->objects['deviceWebOS'] = ActiveSync_Controller_Device::getInstance()->create($palm);
$iphone = ActiveSync_Backend_DeviceTests::getTestDevice(Syncope_Model_Device::TYPE_IPHONE);
$iphone->owner_id = $this->_testUser->getId();
$iphone->calendarfilter_id = $this->objects['filter']->getId();
$this->objects['deviceIPhone'] = ActiveSync_Controller_Device::getInstance()->create($iphone);
}
/**
* interceptor before add
*
* @param array $emailUserData
*/
protected function _beforeAddOrUpdate(&$emailUserData)
{
// add configured domain to domains table
$select = $this->_db->select()->from(array('domains'), array('name'))->where($this->_db->quoteIdentifier('domains.name') . ' = ?', $this->_config['domain']);
$stmt = $this->_db->query($select);
$domains = $stmt->fetchAll(Zend_Db::FETCH_COLUMN);
// did we find all domains in domains table?
if (count($domains) < 1) {
$this->_db->insert('domains', array('id' => Tinebase_Record_Abstract::generateUID(), 'name' => $this->_config['domain'], 'backupmx' => 0, 'active' => 1));
}
$emailUserData['last_modified'] = Tinebase_DateTime::now()->format(Tinebase_Record_Abstract::ISO8601LONG);
}
/**
* startSetupSession
*
* TODO remove redundancy with Tinebase_Core::startCoreSession()
*/
public static function startSetupSession()
{
Tinebase_Session::setSessionBackend();
Zend_Session::start();
$setupSession = Setup_Session::getSessionNamespace();
if (isset($setupSession->setupuser)) {
self::set(self::USER, $setupSession->setupuser);
}
if (!isset($setupSession->jsonKey)) {
$setupSession->jsonKey = Tinebase_Record_Abstract::generateUID();
}
self::set('jsonKey', $setupSession->jsonKey);
}
public function testCreateMinimalTask()
{
$summary = 'minimal task by phpunit';
$task = new Tasks_Model_Task(array('uid' => Tinebase_Record_Abstract::generateUID(), 'summary' => $summary, 'container_id' => $this->container_id));
$persitantTask = $this->_backend->create($task);
$pagination = new Tasks_Model_Pagination();
$filter = new Tasks_Model_TaskFilter(array(array('field' => 'summary', 'operator' => 'contains', 'value' => $summary), array('field' => 'container_id', 'operator' => 'equals', 'value' => $task->container_id)));
$tasks = $this->_backend->search($filter, $pagination);
$this->assertEquals(1, count($tasks));
$db = new Tinebase_Db_Table(array('name' => SQL_TABLE_PREFIX . 'tasks'));
$db->delete("summary LIKE '{$summary}'");
Tinebase_Timemachine_ModificationLogTest::purgeLogs($persitantTask->getId());
}
/**
* @return void
*/
public function testEmailsToAttendee()
{
$event = $this->_getEvent();
$persistentEvent = Calendar_Controller_Event::getInstance()->create($event);
$sclever = Tinebase_User::getInstance()->getUserByLoginName('sclever', 'Tinebase_Model_FullUser');
$newEmail = Tinebase_Record_Abstract::generateUID() . '@unittest.com';
// delete newly created contact in tearDown()
$this->_testEmailContacts[] = $newEmail;
$newAttendees = array(array('userType' => Calendar_Model_Attender::USERTYPE_USER, 'firstName' => $this->_originalTestUser->accountFirstName, 'lastName' => $this->_originalTestUser->accountLastName, 'partStat' => Calendar_Model_Attender::STATUS_ACCEPTED, 'role' => Calendar_Model_Attender::ROLE_REQUIRED, 'email' => $this->_originalTestUser->accountEmailAddress), array('userType' => Calendar_Model_Attender::USERTYPE_USER, 'displayName' => $sclever->accountDisplayName, 'partStat' => Calendar_Model_Attender::STATUS_DECLINED, 'role' => Calendar_Model_Attender::ROLE_REQUIRED, 'email' => $sclever->accountEmailAddress), array('userType' => Calendar_Model_Attender::USERTYPE_USER, 'firstName' => 'Lars', 'lastName' => 'Kneschke', 'partStat' => Calendar_Model_Attender::STATUS_TENTATIVE, 'role' => Calendar_Model_Attender::ROLE_REQUIRED, 'email' => $newEmail));
Calendar_Model_Attender::emailsToAttendee($persistentEvent, $newAttendees, TRUE);
$this->assertEquals(3, count($persistentEvent->attendee));
$this->assertEquals(1, count($persistentEvent->attendee->filter('status', Calendar_Model_Attender::STATUS_ACCEPTED)));
$this->assertEquals(1, count($persistentEvent->attendee->filter('status', Calendar_Model_Attender::STATUS_DECLINED)));
$this->assertEquals(1, count($persistentEvent->attendee->filter('status', Calendar_Model_Attender::STATUS_TENTATIVE)));
}
/**
* test create contact
*
* @return Addressbook_Frontend_WebDAV_Contact
*/
public function testCreateContact()
{
if (!isset($_SERVER['HTTP_USER_AGENT'])) {
$_SERVER['HTTP_USER_AGENT'] = 'FooBar User Agent';
}
$vcardStream = fopen(dirname(__FILE__) . '/../../Import/files/sogo_connector.vcf', 'r');
$id = Tinebase_Record_Abstract::generateUID();
$contact = Addressbook_Frontend_WebDAV_Contact::create($this->objects['initialContainer'], "{$id}.vcf", $vcardStream);
$this->objects['contactsToDelete'][] = $contact;
$record = $contact->getRecord();
$this->assertEquals('*****@*****.**', $record->email);
$this->assertEquals('Kneschke', $record->n_family);
$this->assertEquals('+49 BUSINESS', $record->tel_work);
return $contact;
}