public function testGetToggleStarStatusLink()
{
$super = User::getByUsername('super');
Yii::app()->user->userModel = $super;
$account = new Account();
$account->owner = $super;
$account->name = 'Test Account';
$account->officePhone = '1234567890';
$this->assertTrue($account->save());
$dataProvider = new RedBeanModelDataProvider('Account');
$data = $dataProvider->getData();
$link = StarredUtil::getToggleStarStatusLink($data[0], null);
$this->assertContains('unstarred', $link);
$this->assertContains('star-Account-' . $account->id, $link);
}
/**
* @depends testSearchMemberOfAndMembers
*/
public function testSearchByCustomFieldWithEscapedContent()
{
$super = User::getByUsername('super');
Yii::app()->user->userModel = $super;
//Searching with a custom field that is not blank should not produce any errors.
//The data returned should be no accounts.
$fakePostData = array('name' => null, 'officePhone' => null, 'industry' => array('value' => "Ban'king"), 'officeFax' => null);
$account = new Account(false);
$searchForm = new AccountsSearchForm($account);
$metadataAdapter = new SearchDataProviderMetadataAdapter($searchForm, $super->id, $fakePostData);
$searchAttributeData = $metadataAdapter->getAdaptedMetadata();
//Run search and make sure the data returned matches how many total accounts are available.
$dataProvider = new RedBeanModelDataProvider('Account', null, false, $searchAttributeData);
$data = $dataProvider->getData();
$this->assertEquals(0, count($data));
}
public function testGetStarredModelsWithSearchAttributeData()
{
$searchAttributeData = array();
$searchAttributeData['clauses'] = array(1 => array('attributeName' => 'name', 'operatorType' => 'contains', 'value' => 'Test'));
$searchAttributeData['structure'] = '1';
$dataProvider = new RedBeanModelDataProvider('Account', null, false, $searchAttributeData);
$this->assertCount(2, $dataProvider->getData());
$dataProvider = new StarredModelDataProvider('Account', null, false, $searchAttributeData);
$this->assertCount(1, $dataProvider->getData());
$searchAttributeData = array();
$searchAttributeData['clauses'] = array(1 => array('attributeName' => 'name', 'operatorType' => 'equals', 'value' => 'Test'));
$searchAttributeData['structure'] = '1';
$dataProvider = new RedBeanModelDataProvider('Account', null, false, $searchAttributeData);
$this->assertCount(0, $dataProvider->getData());
$dataProvider = new StarredModelDataProvider('Account', null, false, $searchAttributeData);
$this->assertCount(0, $dataProvider->getData());
}
public function testGetDataReturningAllResults()
{
$allGG = GG::getAll();
foreach ($allGG as $gg) {
$gg->delete();
}
$numberOfRecords = rand(12, 100);
for ($i = 1; $i <= $numberOfRecords; $i++) {
$gg = new GG();
$gg->g = 'a';
$this->assertTrue($gg->save());
}
$dataProvider = new RedBeanModelDataProvider('GG', 'g', false);
$totalItems = (int) $dataProvider->calculateTotalItemCount();
$dataProvider->getPagination()->setPageSize($totalItems);
$data = $dataProvider->getData();
$this->assertEquals($numberOfRecords, count($data));
}
/**
* @depends testSearchByOwnerId
*/
public function testSearchByRelatedAttributeName()
{
$super = User::getByUsername('super');
Yii::app()->user->userModel = $super;
$quote = DatabaseCompatibilityUtil::getQuote();
//Test searching contacts where the related account is ABC with account id = 5.
$fakePostData = array('account' => array('name' => 'abc'));
$metadataAdapter = new SearchDataProviderMetadataAdapter(new Contact(false), 1, $fakePostData);
$searchAttributeData = $metadataAdapter->getAdaptedMetadata();
$joinTablesAdapter = new RedBeanModelJoinTablesQueryAdapter('Contact');
$where = RedBeanModelDataProvider::makeWhere('Contact', $searchAttributeData, $joinTablesAdapter);
$compareWhere = "({$quote}account{$quote}.{$quote}name{$quote} like 'abc%')";
$this->assertEquals($compareWhere, $where);
//Now test that the joinTablesAdapter has correct information.
$this->assertEquals(0, $joinTablesAdapter->getFromTableJoinCount());
$this->assertEquals(1, $joinTablesAdapter->getLeftTableJoinCount());
$leftTables = $joinTablesAdapter->getLeftTablesAndAliases();
$this->assertEquals('account', $leftTables[0]['tableName']);
//Make sure the sql runs properly.
$dataProvider = new RedBeanModelDataProvider('Contact', null, false, $searchAttributeData);
$data = $dataProvider->getData();
}
public function testSearchByType()
{
$super = User::getByUsername('super');
$steven = User::getByUsername('steven');
Yii::app()->user->userModel = $super;
$conversationModel = new Conversation(false);
$searchAttributes = array();
$conversation = new Conversation();
$conversation->owner = $steven;
$conversation->subject = 'My test subject';
$conversation->description = 'My test description';
$this->assertTrue($conversation->save());
$conversationId = $conversation->id;
//Super dont have created conversations
$metadataAdapter = new ConversationsSearchDataProviderMetadataAdapter($conversationModel, $super->id, $searchAttributes, ConversationsSearchDataProviderMetadataAdapter::LIST_TYPE_CREATED);
$searchAttributeData = $metadataAdapter->getAdaptedMetadata();
$dataProvider = new RedBeanModelDataProvider('Conversation', null, false, $searchAttributeData);
$data = $dataProvider->getData();
$this->assertEquals(0, count($data));
//Super dont participate in any conversations
$metadataAdapter = new ConversationsSearchDataProviderMetadataAdapter($conversationModel, $super->id, $searchAttributes, ConversationsSearchDataProviderMetadataAdapter::LIST_TYPE_PARTICIPANT);
$searchAttributeData = $metadataAdapter->getAdaptedMetadata();
$dataProvider = new RedBeanModelDataProvider('Conversation', null, false, $searchAttributeData);
$data = $dataProvider->getData();
$this->assertEquals(0, count($data));
//Super dont participate in any closed conversations
$metadataAdapter = new ConversationsSearchDataProviderMetadataAdapter($conversationModel, $super->id, $searchAttributes, ConversationsSearchDataProviderMetadataAdapter::LIST_TYPE_CLOSED);
$searchAttributeData = $metadataAdapter->getAdaptedMetadata();
$dataProvider = new RedBeanModelDataProvider('Conversation', null, false, $searchAttributeData);
$data = $dataProvider->getData();
$this->assertEquals(0, count($data));
//Super participate in one conversation
$conversation = Conversation::getById($conversationId);
$conversationParticipant = new ConversationParticipant();
$conversationParticipant->person = $super;
$conversation->conversationParticipants->add($conversationParticipant);
$this->assertTrue($conversation->save());
$metadataAdapter = new ConversationsSearchDataProviderMetadataAdapter($conversationModel, $super->id, $searchAttributes, ConversationsSearchDataProviderMetadataAdapter::LIST_TYPE_PARTICIPANT);
$searchAttributeData = $metadataAdapter->getAdaptedMetadata();
$dataProvider = new RedBeanModelDataProvider('Conversation', null, false, $searchAttributeData);
$data = $dataProvider->getData();
$this->assertEquals(1, count($data));
//Super participate in a closed conversation
$conversation = Conversation::getById($conversationId);
$conversation->isClosed = true;
$this->assertTrue($conversation->save());
$metadataAdapter = new ConversationsSearchDataProviderMetadataAdapter($conversationModel, $super->id, $searchAttributes, ConversationsSearchDataProviderMetadataAdapter::LIST_TYPE_CLOSED);
$searchAttributeData = $metadataAdapter->getAdaptedMetadata();
$dataProvider = new RedBeanModelDataProvider('Conversation', null, false, $searchAttributeData);
$data = $dataProvider->getData();
$this->assertEquals(1, count($data));
}
/**
* @depends testSetAndGetMultiSelectDropDownAttribute
*/
public function testSearchForMultiSelectDropDownAttributePlacedForAccountsModule()
{
//Test that the multiple select attribute can query properly for search.
$super = User::getByUsername('super');
Yii::app()->user->userModel = $super;
//Create an account to test searching multiple fields on for search.
$account = new Account();
$this->assertEquals(1, $account->testHobbiesCstm->values->count());
$account->name = 'my test account';
$account->owner = Yii::app()->user->userModel;
$customFieldValue2 = new CustomFieldValue();
$customFieldValue2->value = 'Reading';
$account->testHobbiesCstm->values->add($customFieldValue2);
$this->assertTrue($account->save());
$accountId = $account->id;
$account = Account::getById($accountId);
$this->assertEquals(2, $account->testHobbiesCstm->values->count());
$this->assertContains('Writing', $account->testHobbiesCstm->values);
$this->assertContains('Reading', $account->testHobbiesCstm->values);
//Create a second account with different hobbies
$account = new Account();
//Remove the default value of 'Writing';
$account->testHobbiesCstm->values->removeByIndex(0);
$account->name = 'my test account2';
$account->owner = Yii::app()->user->userModel;
$customFieldValue1 = new CustomFieldValue();
$customFieldValue1->value = 'Singing';
$account->testHobbiesCstm->values->add($customFieldValue1);
$customFieldValue2 = new CustomFieldValue();
$customFieldValue2->value = 'Surfing';
$account->testHobbiesCstm->values->add($customFieldValue2);
$this->assertTrue($account->save());
$accountId = $account->id;
$account = Account::getById($accountId);
$this->assertEquals(2, $account->testHobbiesCstm->values->count());
$this->assertContains('Singing', $account->testHobbiesCstm->values);
$this->assertContains('Surfing', $account->testHobbiesCstm->values);
//Searching with a custom field that is not blank should not produce an errors.
$searchPostData = array('name' => 'my test account', 'officePhone' => '', 'testHobbies' => array('values' => array(0 => '')), 'officeFax' => '');
$modifiedSearchPostData = SearchUtil::getSearchAttributesFromSearchArray($searchPostData);
$this->assertEquals(array('name' => 'my test account', 'officePhone' => null, 'officeFax' => null), $modifiedSearchPostData);
$account = new Account(false);
$searchForm = new AccountsSearchForm($account);
$metadataAdapter = new SearchDataProviderMetadataAdapter($searchForm, $super->id, $modifiedSearchPostData);
$searchAttributeData = $metadataAdapter->getAdaptedMetadata();
//Make sure the search params are empty
$compareClauses = array(1 => array('attributeName' => 'name', 'operatorType' => 'startsWith', 'value' => 'my test account'));
$compareStructure = '1';
$this->assertEquals($compareClauses, $searchAttributeData['clauses']);
$this->assertEquals($compareStructure, $searchAttributeData['structure']);
//Run search and make sure the data returned matches how many total accounts are available.
$dataProvider = new RedBeanModelDataProvider('Account', null, false, $searchAttributeData);
$data = $dataProvider->getData();
$this->assertEquals(2, count($data));
}
public function testSearch()
{
$super = User::getByUsername('super');
$steven = User::getByUsername('steven');
Yii::app()->user->userModel = $super;
$createdConversation = $this->createAndSaveNewConversationForUser($super, $steven);
$metadataForSearch = $this->rules->getSearchAttributeData();
$dataProvider = new RedBeanModelDataProvider('Conversation', null, false, $metadataForSearch);
$data = $dataProvider->getData();
$this->assertEquals(1, count($data));
$metadataForSearch = $this->rules->getSearchAttributeData("sub");
$dataProvider = new RedBeanModelDataProvider('Conversation', null, false, $metadataForSearch);
$data = $dataProvider->getData();
$this->assertEquals(1, count($data));
$metadataForSearch = $this->rules->getSearchAttributeData("description");
$dataProvider = new RedBeanModelDataProvider('Conversation', null, false, $metadataForSearch);
$data = $dataProvider->getData();
$this->assertEquals(0, count($data));
}
public function testDefaultFullnameOrderOnContacts()
{
$super = User::getByUsername('super');
Yii::app()->user->userModel = $super;
$contact = new Contact();
$contact->firstName = 'Jackie';
$contact->lastName = 'Bonn';
$contact->owner = $super;
$contact->state = ContactsUtil::getStartingState();
$this->assertTrue($contact->save());
$searchAttributeData = array();
$dataProvider = new RedBeanModelDataProvider('Contact', null, false, $searchAttributeData);
$data = $dataProvider->getData();
$contacts = array();
foreach ($data as $contact) {
$contacts[] = strval($contact);
}
$sortedContacts = $contacts;
sort($sortedContacts);
$compareContacts = array('Dino Dinoson', 'Jackie Bonn', 'Jackie Jackieson', 'Jackie Tyler');
$this->assertEquals($compareContacts, $sortedContacts);
}
/**
* @depends testSearchByMultipleValuesCustomField
*/
public function testSearchByTwoMultipleValuesCustomField()
{
if (!RedBeanDatabase::isFrozen()) {
$quote = DatabaseCompatibilityUtil::getQuote();
//Test where relatioon id is in a joining table. Many to Many relationship
$_FAKEPOST['TestOwnedCustomFieldsModel'] = array();
$_FAKEPOST['TestOwnedCustomFieldsModel']['multipleIndustries']['values'] = array('A', 'B', 'C');
$_FAKEPOST['TestOwnedCustomFieldsModel']['multipleSomethings']['values'] = array('D', 'E', 'F');
$metadataAdapter = new SearchDataProviderMetadataAdapter(new TestOwnedCustomFieldsModel(false), 1, $_FAKEPOST['TestOwnedCustomFieldsModel']);
$searchAttributeData = $metadataAdapter->getAdaptedMetadata();
$joinTablesAdapter = new RedBeanModelJoinTablesQueryAdapter('TestOwnedCustomFieldsModel');
$where = RedBeanModelDataProvider::makeWhere('TestOwnedCustomFieldsModel', $searchAttributeData, $joinTablesAdapter);
$compareWhere = "(1 = (select 1 from {$quote}customfieldvalue{$quote} customfieldvalue " . "where {$quote}customfieldvalue{$quote}.{$quote}multiplevaluescustomfield_id{$quote} = " . "{$quote}multiplevaluescustomfield{$quote}.id " . "and {$quote}customfieldvalue{$quote}.{$quote}value{$quote} IN('A','B','C') limit 1))";
// Not Coding Standard
$compareWhere .= " and (1 = (select 1 from {$quote}customfieldvalue{$quote} customfieldvalue " . "where {$quote}customfieldvalue{$quote}.{$quote}multiplevaluescustomfield_id{$quote} = " . "{$quote}multiplevaluescustomfield1{$quote}.id " . "and {$quote}customfieldvalue{$quote}.{$quote}value{$quote} IN('D','E','F') limit 1))";
// Not Coding Standard
$this->assertEquals($compareWhere, $where);
//Now test that the joinTablesAdapter has correct information.
$this->assertEquals(0, $joinTablesAdapter->getFromTableJoinCount());
$this->assertEquals(2, $joinTablesAdapter->getLeftTableJoinCount());
$leftTables = $joinTablesAdapter->getLeftTablesAndAliases();
$this->assertEquals('multiplevaluescustomfield', $leftTables[0]['tableName']);
$this->assertEquals('multiplevaluescustomfield', $leftTables[1]['tableName']);
//Now test that the subsetSQL query produced is correct.
$subsetSql = TestOwnedCustomFieldsModel::makeSubsetOrCountSqlQuery('testcustomfieldsmodel', $joinTablesAdapter, 1, 5, $where, null);
$compareSubsetSql = "select {$quote}testcustomfieldsmodel{$quote}.{$quote}id{$quote} id ";
$compareSubsetSql .= "from {$quote}testcustomfieldsmodel{$quote} ";
$compareSubsetSql .= "left join {$quote}multiplevaluescustomfield{$quote} on ";
$compareSubsetSql .= "{$quote}multiplevaluescustomfield{$quote}.{$quote}id{$quote} = ";
$compareSubsetSql .= "{$quote}testownedcustomfieldsmodel{$quote}.{$quote}multipleindustries_multiplevaluescustomfield_id{$quote} ";
$compareSubsetSql .= "left join {$quote}multiplevaluescustomfield{$quote} multiplevaluescustomfield1 on ";
$compareSubsetSql .= "{$quote}multiplevaluescustomfield1{$quote}.{$quote}id{$quote} = ";
$compareSubsetSql .= "{$quote}testownedcustomfieldsmodel{$quote}.{$quote}multiplesomethings_multiplevaluescustomfield_id{$quote} ";
$compareSubsetSql .= "where " . $compareWhere . ' ';
$compareSubsetSql .= 'limit 5 offset 1';
$this->assertEquals($compareSubsetSql, $subsetSql);
//Make sure the sql runs properly.
$dataProvider = new RedBeanModelDataProvider('TestOwnedCustomFieldsModel', null, false, $searchAttributeData);
$data = $dataProvider->getData();
$this->assertEquals(1, count($data));
}
}
/**
* @depends testSearchCrossingTables
* @depends testGetAllModels
*/
public function testSearchUserFirstName()
{
$_FAKEPOST = array('User' => array('firstName' => 'billy'));
$metadataAdapter = new SearchDataProviderMetadataAdapter(new User(false), 1, $_FAKEPOST['User']);
$searchAttributeData = $metadataAdapter->getAdaptedMetadata();
$dataProvider = new RedBeanModelDataProvider('User', null, false, $searchAttributeData);
$users = $dataProvider->getData();
$this->assertEquals(1, count($users));
$this->assertEquals(1, $dataProvider->calculateTotalItemCount());
}
public function testSearch()
{
$super = User::getByUsername('super');
Yii::app()->user->userModel = $super;
$this->deleteAllMissions();
$this->createAndSaveNewMissionForUser($super);
$searchAttributeData = $this->rules->getSearchAttributeData();
$dataProvider = new RedBeanModelDataProvider('Mission', null, false, $searchAttributeData);
$data = $dataProvider->getData();
$this->assertEquals(1, count($data));
$metadataForSearch = $this->rules->getSearchAttributeData("mis");
$dataProvider = new RedBeanModelDataProvider('Mission', null, false, $metadataForSearch);
$data = $dataProvider->getData();
$this->assertEquals(1, count($data));
$metadataForSearch = $this->rules->getSearchAttributeData("subject");
$dataProvider = new RedBeanModelDataProvider('Mission', null, false, $metadataForSearch);
$data = $dataProvider->getData();
$this->assertEquals(0, count($data));
}
/**
* @depends testDefaultFullnameOrderOnUsers
*/
public function testLastNameOrderOnUsers()
{
$searchAttributeData = array();
$dataProvider = new RedBeanModelDataProvider('User', 'lastName', false, $searchAttributeData);
$data = $dataProvider->getData();
$this->assertTrue($this->user3->id == $data[0]->id || $this->user3->id == $data[1]->id);
$this->assertTrue($this->user2->id == $data[1]->id || $this->user2->id == $data[0]->id);
$this->assertEquals($this->super, $data[2]);
$this->assertEquals($this->user1, $data[3]);
}
/**
* @depends testManyManyRelationSqlQuery
* See ModelDataProviderUtilTest for more order by testing.
*/
public function testOrderByCombinations()
{
$gg = new GG();
$gg->gg = 'a';
$gg->g = 'v';
$this->assertTrue($gg->save());
$gg = new GG();
$gg->gg = 'b';
$gg->g = 't';
$this->assertTrue($gg->save());
$gg = new GG();
$gg->gg = 'c';
$gg->g = 'u';
$this->assertTrue($gg->save());
$quote = DatabaseCompatibilityUtil::getQuote();
$_FAKEPOST['GG'] = array();
$metadataAdapter = new SearchDataProviderMetadataAdapter(new GG(false), 1, $_FAKEPOST['GG']);
$searchAttributeData = $metadataAdapter->getAdaptedMetadata();
$dataProvider = new RedBeanModelDataProvider('GG', 'gg', false, $searchAttributeData);
$data = $dataProvider->getData();
$this->assertEquals(3, count($data));
$this->assertEquals('a', $data[0]->gg);
$this->assertEquals('b', $data[1]->gg);
$this->assertEquals('c', $data[2]->gg);
$dataProvider = new RedBeanModelDataProvider('GG', 'gg', true, $searchAttributeData);
$data = $dataProvider->getData();
$this->assertEquals(3, count($data));
$this->assertEquals('c', $data[0]->gg);
$this->assertEquals('b', $data[1]->gg);
$this->assertEquals('a', $data[2]->gg);
$compareString = "{$quote}gg{$quote}.{$quote}gg{$quote}";
$joinTablesAdapter = new RedBeanModelJoinTablesQueryAdapter('GG');
$this->assertEquals($compareString, RedBeanModelDataProvider::resolveSortAttributeColumnName('GG', $joinTablesAdapter, 'gg'));
$compareString = "{$quote}g{$quote}.{$quote}g{$quote}";
$joinTablesAdapter = new RedBeanModelJoinTablesQueryAdapter('GG');
$this->assertEquals($compareString, RedBeanModelDataProvider::resolveSortAttributeColumnName('GG', $joinTablesAdapter, 'g'));
//test ordering by castedUp model.
$dataProvider = new RedBeanModelDataProvider('GG', 'g', false, $searchAttributeData);
$data = $dataProvider->getData();
$this->assertEquals(3, count($data));
$this->assertEquals('b', $data[0]->gg);
$this->assertEquals('c', $data[1]->gg);
$this->assertEquals('a', $data[2]->gg);
$dataProvider = new RedBeanModelDataProvider('GG', 'g', true, $searchAttributeData);
$data = $dataProvider->getData();
$this->assertEquals(3, count($data));
$this->assertEquals('a', $data[0]->gg);
$this->assertEquals('c', $data[1]->gg);
$this->assertEquals('b', $data[2]->gg);
//test ordering by custom attribute value.
}
