/**
  * @param CEvent $event
  */
 public function processFromContactSide(CEvent $event)
 {
     $model = $event->sender;
     if (isset($model->originalAttributeValues['account'])) {
         if ($model->originalAttributeValues['account'][1] > 0) {
             //lookup to see if there is a 'primary' affiliation for old acc/con pairing and unmark as primary
             $accountContactAffiliations = AccountContactAffiliation::getPrimaryByAccountIdAndContactId((int) $model->originalAttributeValues['account'][1], (int) $model->id);
             //shouldn't be more than one, but if there is unset all of them
             foreach ($accountContactAffiliations as $accountContactAffiliation) {
                 $accountContactAffiliation->primary = false;
                 $accountContactAffiliation->save();
             }
         }
         //lookup and see if there is an affiliation for the new acc/con pairing
         if ($model->account->id > 0) {
             $accountContactAffiliations = AccountContactAffiliation::getByAccountAndContact($model->account, $model);
             //Shouldn't be more than one, but if there is, just mark the first primary.
             if (count($accountContactAffiliations) > 0) {
                 //If so - mark primary.
                 $accountContactAffiliations[0]->primary = true;
                 $accountContactAffiliations[0]->save();
             } else {
                 //If not, create and mark primary.
                 $accountContactAffiliation = new AccountContactAffiliation();
                 $accountContactAffiliation->primary = true;
                 $accountContactAffiliation->contact = $model;
                 $accountContactAffiliation->account = $model->account;
                 if ($accountContactAffiliation->isAttributeRequired('role') && $accountContactAffiliation->role->value == null) {
                     $accountContactAffiliation->role->value = $this->resolveRoleValue($accountContactAffiliation);
                 }
                 $accountContactAffiliation->save();
             }
         }
     }
 }
 public static function getPrimaryByAccountIdAndContactId($accountId, $contactId)
 {
     assert('is_int($accountId)');
     assert('is_int($contactId)');
     $searchAttributeData = array();
     $searchAttributeData['clauses'] = array(1 => array('attributeName' => 'account', 'operatorType' => 'equals', 'value' => $accountId), 2 => array('attributeName' => 'contact', 'operatorType' => 'equals', 'value' => $contactId));
     $searchAttributeData['structure'] = '(1 and 2)';
     $joinTablesAdapter = new RedBeanModelJoinTablesQueryAdapter('AccountContactAffiliation');
     $where = RedBeanModelDataProvider::makeWhere('AccountContactAffiliation', $searchAttributeData, $joinTablesAdapter);
     $tableName = AccountContactAffiliation::getTableName();
     $q = DatabaseCompatibilityUtil::getQuote();
     $where .= " and {$q}{$tableName}{$q}.{$q}primary{$q} = '1'";
     return self::getSubset($joinTablesAdapter, null, null, $where);
 }
 public function testSimpleUserImportWhereAllRowsSucceed()
 {
     Yii::app()->user->userModel = User::getByUsername('super');
     $account = AccountTestHelper::createAccountByNameForOwner('Account', Yii::app()->user->userModel);
     $contact = ContactTestHelper::createContactByNameForOwner('Contact', Yii::app()->user->userModel);
     $accountContactAffiliations = AccountContactAffiliation::getAll();
     $this->assertEquals(0, count($accountContactAffiliations));
     $import = new Import();
     $serializedData['importRulesType'] = 'AccountContactAffiliations';
     $serializedData['firstRowIsHeaderRow'] = true;
     $import->serializedData = serialize($serializedData);
     $this->assertTrue($import->save());
     ImportTestHelper::createTempTableByFileNameAndTableName('importTest.csv', $import->getTempTableName(), true, Yii::getPathOfAlias('application.modules.accountContactAffiliations.tests.unit.files'));
     //update the ids of the account column to match the parent account.
     ZurmoRedBean::exec("update " . $import->getTempTableName() . " set column_2 = " . $account->id . " where id != 1 limit 4");
     ZurmoRedBean::exec("update " . $import->getTempTableName() . " set column_1 = " . $contact->id . " where id != 1 limit 4");
     $this->assertEquals(4, ImportDatabaseUtil::getCount($import->getTempTableName()));
     // includes header rows.
     $mappingData = array('column_0' => ImportMappingUtil::makeDropDownColumnMappingData('role'), 'column_1' => ImportMappingUtil::makeHasOneColumnMappingData('contact'), 'column_2' => ImportMappingUtil::makeHasOneColumnMappingData('account'));
     $importRules = ImportRulesUtil::makeImportRulesByType('AccountContactAffiliations');
     $page = 0;
     $config = array('pagination' => array('pageSize' => 50));
     //This way all rows are processed.
     $dataProvider = new ImportDataProvider($import->getTempTableName(), true, $config);
     $dataProvider->getPagination()->setCurrentPage($page);
     $importResultsUtil = new ImportResultsUtil($import);
     $messageLogger = new ImportMessageLogger();
     ImportUtil::importByDataProvider($dataProvider, $importRules, $mappingData, $importResultsUtil, new ExplicitReadWriteModelPermissions(), $messageLogger);
     $importResultsUtil->processStatusAndMessagesForEachRow();
     //Confirm that 3 models where created.
     $accountContactAffiliations = AccountContactAffiliation::getAll();
     $this->assertEquals(3, count($accountContactAffiliations));
     $this->assertEquals('0', $accountContactAffiliations[0]->primary);
     $this->assertTrue($accountContactAffiliations[0]->account->isSame($account));
     $this->assertTrue($accountContactAffiliations[0]->contact->isSame($contact));
     $this->assertEquals('', $accountContactAffiliations[0]->role->value);
     $this->assertEquals('0', $accountContactAffiliations[1]->primary);
     $this->assertTrue($accountContactAffiliations[1]->account->isSame($account));
     $this->assertTrue($accountContactAffiliations[1]->contact->isSame($contact));
     $this->assertEquals('Support', $accountContactAffiliations[1]->role->value);
     $this->assertEquals('0', $accountContactAffiliations[2]->primary);
     $this->assertTrue($accountContactAffiliations[2]->account->isSame($account));
     $this->assertTrue($accountContactAffiliations[2]->contact->isSame($contact));
     $this->assertEquals('Technical', $accountContactAffiliations[2]->role->value);
     //Confirm 3 rows were processed as 'created'.
     $this->assertEquals(3, ImportDatabaseUtil::getCount($import->getTempTableName(), "status = " . ImportRowDataResultsUtil::CREATED));
     //Confirm that 0 rows were processed as 'updated'.
     $this->assertEquals(0, ImportDatabaseUtil::getCount($import->getTempTableName(), "status = " . ImportRowDataResultsUtil::UPDATED));
 }
Пример #4
0
 public function actionDelete($id)
 {
     $accountContactAffiliation = AccountContactAffiliation::getById(intval($id));
     $accountContactAffiliation->delete();
     //Do not redirect since there is no index view to go to. Also delete is called from related portlets only
 }
 public function testSuperUserDeleteAction()
 {
     $super = $this->logoutCurrentUserLoginNewUserAndGetByUsername('super');
     $accountContactAffiliations = AccountContactAffiliation::getAll();
     $this->assertEquals(2, count($accountContactAffiliations));
     //Delete an AccountContactAffiliation model.
     $this->setGetArray(array('id' => $accountContactAffiliations[0]->id));
     $this->resetPostArray();
     $this->runControllerWithNoExceptionsAndGetContent('accountContactAffiliations/default/delete', true);
     $accountContactAffiliations = AccountContactAffiliation::getAll();
     $this->assertEquals(1, count($accountContactAffiliations));
 }
 public function testGetAffiliatedAccountsAndContacts()
 {
     $super = User::getByUsername('super');
     Yii::app()->user->userModel = $super;
     $authenticationData = $this->login();
     $headers = array('Accept: application/json', 'ZURMO_SESSION_ID: ' . $authenticationData['sessionId'], 'ZURMO_TOKEN: ' . $authenticationData['token'], 'ZURMO_API_REQUEST_TYPE: REST');
     $account = AccountTestHelper::createAccountByNameForOwner('firstAffAccount', Yii::app()->user->userModel);
     $account2 = AccountTestHelper::createAccountByNameForOwner('secondAffAccount', Yii::app()->user->userModel);
     $account3 = AccountTestHelper::createAccountByNameForOwner('thirdAffAccount', Yii::app()->user->userModel);
     $contact = ContactTestHelper::createContactByNameForOwner('firstAffContact', Yii::app()->user->userModel);
     $contact2 = ContactTestHelper::createContactByNameForOwner('secondAffContact', Yii::app()->user->userModel);
     $contact3 = ContactTestHelper::createContactByNameForOwner('thirdAffContact', Yii::app()->user->userModel);
     $accountContactAffiliation = new AccountContactAffiliation();
     $accountContactAffiliation->account = $account;
     $accountContactAffiliation->contact = $contact;
     $this->assertTrue($accountContactAffiliation->save());
     sleep(1);
     $accountContactAffiliation2 = new AccountContactAffiliation();
     $accountContactAffiliation2->account = $account;
     $accountContactAffiliation2->contact = $contact2;
     $this->assertTrue($accountContactAffiliation2->save());
     sleep(1);
     $accountContactAffiliation = new AccountContactAffiliation();
     $accountContactAffiliation->account = $account2;
     $accountContactAffiliation->contact = $contact2;
     $this->assertTrue($accountContactAffiliation->save());
     sleep(1);
     $accountContactAffiliation = new AccountContactAffiliation();
     $accountContactAffiliation->account = $account3;
     $accountContactAffiliation->contact = $contact3;
     $this->assertTrue($accountContactAffiliation->save());
     // Get all contacts affiliated with account
     $data = array('search' => array('modelClassName' => 'AccountContactAffiliation', 'searchAttributeData' => array('clauses' => array(1 => array('attributeName' => 'account', 'relatedAttributeName' => 'id', 'operatorType' => 'equals', 'value' => $account->id)), 'structure' => '1')), 'pagination' => array('page' => 1, 'pageSize' => 5), 'sort' => 'id asc');
     $response = $this->createApiCallWithRelativeUrl('search/filter/', 'POST', $headers, array('data' => $data));
     $response = json_decode($response, true);
     $this->assertEquals(ApiResponse::STATUS_SUCCESS, $response['status']);
     $this->assertEquals(2, $response['data']['totalCount']);
     $this->assertEquals(2, count($response['data']['items']));
     $this->assertEquals($account->id, $response['data']['items'][0]['account']['id']);
     $this->assertEquals($contact->id, $response['data']['items'][0]['contact']['id']);
     $this->assertEquals($account->id, $response['data']['items'][1]['account']['id']);
     $this->assertEquals($contact2->id, $response['data']['items'][1]['contact']['id']);
     // Get all accounts affiliated with account
     $data = array('search' => array('modelClassName' => 'AccountContactAffiliation', 'searchAttributeData' => array('clauses' => array(1 => array('attributeName' => 'contact', 'relatedAttributeName' => 'id', 'operatorType' => 'equals', 'value' => $contact2->id)), 'structure' => '1')), 'pagination' => array('page' => 1, 'pageSize' => 5), 'sort' => 'id asc');
     $response = $this->createApiCallWithRelativeUrl('search/filter/', 'POST', $headers, array('data' => $data));
     $response = json_decode($response, true);
     $this->assertEquals(ApiResponse::STATUS_SUCCESS, $response['status']);
     $this->assertEquals(2, $response['data']['totalCount']);
     $this->assertEquals(2, count($response['data']['items']));
     $this->assertEquals($account->id, $response['data']['items'][0]['account']['id']);
     $this->assertEquals($contact2->id, $response['data']['items'][0]['contact']['id']);
     $this->assertEquals($account2->id, $response['data']['items'][1]['account']['id']);
     $this->assertEquals($contact2->id, $response['data']['items'][1]['contact']['id']);
 }
 /**
  * @depends testGetByAccountAndContact
  */
 public function testGetPrimaryByAccountIdAndContactId()
 {
     $accountContactAffiliations = AccountContactAffiliation::getAll();
     $this->assertEquals(1, count($accountContactAffiliations));
     $accountContactAffiliations = AccountContactAffiliation::getPrimaryByAccountIdAndContactId($accountContactAffiliations[0]->account->id, $accountContactAffiliations[0]->contact->id);
     $this->assertEquals(0, count($accountContactAffiliations));
     $accountContactAffiliations = AccountContactAffiliation::getAll();
     $accountContactAffiliations[0]->primary = true;
     $this->assertTrue($accountContactAffiliations[0]->save());
     $accountContactAffiliations = AccountContactAffiliation::getPrimaryByAccountIdAndContactId($accountContactAffiliations[0]->account->id, $accountContactAffiliations[0]->contact->id);
     $this->assertEquals(1, count($accountContactAffiliations));
 }
 public function testWhenRoleIsRequired()
 {
     $super = User::getByUsername('super');
     Yii::app()->user->userModel = $super;
     //Set role as required but without a default value.
     $attributeForm = AttributesFormFactory::createAttributeFormByAttributeName(new AccountContactAffiliation(), 'role');
     $attributeForm->isRequired = true;
     $modelAttributesAdapterClassName = $attributeForm::getModelAttributeAdapterNameForSavingAttributeFormData();
     $adapter = new $modelAttributesAdapterClassName(new AccountContactAffiliation());
     try {
         $adapter->setAttributeMetadataFromForm($attributeForm);
     } catch (FailedDatabaseSchemaChangeException $e) {
         echo $e->getMessage();
         $this->fail();
     }
     //Now create an affiliation, the role should be the first value.
     $this->assertEquals(0, count(AccountContactAffiliation::getAll()));
     $account = AccountTestHelper::createAccountByNameForOwner('thirdAccount', $super);
     $contact = ContactTestHelper::createContactWithAccountByNameForOwner('thirdContact', $super, $account);
     $accountContactAffiliations = AccountContactAffiliation::getAll();
     $this->assertEquals(1, count($accountContactAffiliations));
     $this->assertEquals(1, $accountContactAffiliations[0]->primary);
     $this->assertEquals('AAA', $accountContactAffiliations[0]->role->value);
     $this->assertTrue($accountContactAffiliations[0]->account->isSame($account));
     $this->assertTrue($accountContactAffiliations[0]->contact->isSame($contact));
     $this->assertTrue($contact->delete());
     $accountContactAffiliations = AccountContactAffiliation::getAll();
     $this->assertEquals(0, count($accountContactAffiliations));
     //Now add a default value, so the role should be the default value.
     $attributeForm = AttributesFormFactory::createAttributeFormByAttributeName(new AccountContactAffiliation(), 'role');
     $attributeForm->defaultValueOrder = 1;
     $modelAttributesAdapterClassName = $attributeForm::getModelAttributeAdapterNameForSavingAttributeFormData();
     $adapter = new $modelAttributesAdapterClassName(new AccountContactAffiliation());
     try {
         $adapter->setAttributeMetadataFromForm($attributeForm);
     } catch (FailedDatabaseSchemaChangeException $e) {
         echo $e->getMessage();
         $this->fail();
     }
     //Now create an account/contact and an affiliation. The role should be BBB
     $this->assertEquals(0, count(AccountContactAffiliation::getAll()));
     $account = AccountTestHelper::createAccountByNameForOwner('fourthAccount', $super);
     $contact = ContactTestHelper::createContactWithAccountByNameForOwner('fourthContact', $super, $account);
     $accountContactAffiliations = AccountContactAffiliation::getAll();
     $this->assertEquals(1, count($accountContactAffiliations));
     $this->assertEquals(1, $accountContactAffiliations[0]->primary);
     $this->assertEquals('BBB', $accountContactAffiliations[0]->role->value);
     $this->assertTrue($accountContactAffiliations[0]->account->isSame($account));
     $this->assertTrue($accountContactAffiliations[0]->contact->isSame($contact));
     $this->assertTrue($contact->delete());
     $accountContactAffiliations = AccountContactAffiliation::getAll();
     $this->assertEquals(0, count($accountContactAffiliations));
 }
 /**
  * @depends testSuperUserCustomFieldsWalkthroughForAccountContactAffiliationsModule
  */
 public function testLayoutsLoadOkAfterCustomFieldsPlacedForAccountContactAffiliationsModule()
 {
     $super = $this->logoutCurrentUserLoginNewUserAndGetByUsername('super');
     //Load create, edit views.
     $this->runControllerWithNoExceptionsAndGetContent('accountContactAffiliations/default/create');
     $accountContactAffiliation = AccountContactAffiliation::getAll();
     $this->assertEquals(0, count($accountContactAffiliation));
     //Create a new AccountContactAffiliation from a related account.
     $this->setGetArray(array('relationAttributeName' => 'account', 'relationModelId' => self::$account->id, 'relationModuleId' => 'accounts', 'redirectUrl' => 'someRedirect'));
     $this->setPostArray(array('AccountContactAffiliation' => array('role' => array('value' => 'TechnicalX'), 'contact' => array('id' => self::$contact->id))));
     $this->runControllerWithRedirectExceptionAndGetContent('accountContactAffiliations/default/createFromRelation');
     $accountContactAffiliation = AccountContactAffiliation::getAll();
     $this->assertEquals(1, count($accountContactAffiliation));
     $this->setGetArray(array('id' => $accountContactAffiliation[0]->id));
     $this->runControllerWithRedirectExceptionAndGetContent('accountContactAffiliations/default/edit');
 }