/**
* Test to confirm joins are working correctly when ordering by an attribute on item.
* Testing when the join adapter has already added a display attribute from a related account
*/
public function testOrderByNoteCreatedDateTimeAndConfirmJoinsAreCorrect()
{
$q = DatabaseCompatibilityUtil::getQuote();
$joinTablesAdapter = new RedBeanModelJoinTablesQueryAdapter('Note');
$selectQueryAdapter = new RedBeanModelSelectQueryAdapter();
$builder = new DisplayAttributesReportQueryBuilder($joinTablesAdapter, $selectQueryAdapter);
$displayAttribute = new DisplayAttributeForReportForm('NotesModule', 'Note', Report::TYPE_ROWS_AND_COLUMNS);
$displayAttribute->attributeIndexOrDerivedType = 'Account__activityItems__Inferred___name';
//First build the display attributes from clauses
$builder->makeQueryContent(array($displayAttribute));
$builder = new OrderBysReportQueryBuilder($joinTablesAdapter);
$orderBy = new OrderByForReportForm('NotesModule', 'Note', Report::TYPE_ROWS_AND_COLUMNS);
$orderBy->attributeIndexOrDerivedType = 'createdDateTime';
//Second build the order by from clauses
$builder->makeQueryContent(array($orderBy));
$fromTablesAndAliases = $joinTablesAdapter->getFromTablesAndAliases();
$this->assertEquals('activity', $fromTablesAndAliases[0]['tableAliasName']);
$this->assertEquals('note', $fromTablesAndAliases[0]['onTableAliasName']);
$this->assertEquals('ownedsecurableitem1', $fromTablesAndAliases[1]['tableAliasName']);
$this->assertEquals('activity', $fromTablesAndAliases[1]['onTableAliasName']);
$this->assertEquals('securableitem1', $fromTablesAndAliases[2]['tableAliasName']);
$this->assertEquals('ownedsecurableitem1', $fromTablesAndAliases[2]['onTableAliasName']);
$this->assertEquals('item1', $fromTablesAndAliases[3]['tableAliasName']);
$this->assertEquals('securableitem1', $fromTablesAndAliases[3]['onTableAliasName']);
}
/**
* @param RedBeanModelJoinTablesQueryAdapter $joinTablesAdapter
* @return null|string
*/
protected function makeOrderBysContent(RedBeanModelJoinTablesQueryAdapter $joinTablesAdapter)
{
$builder = new OrderBysReportQueryBuilder($joinTablesAdapter, $this->report->getCurrencyConversionType());
return $builder->makeQueryContent($this->report->getOrderBys());
}
public function testInferredRelationModelAttributeWithCastingHintToNotCastDowButAlsoWithFullCastDown()
{
$q = DatabaseCompatibilityUtil::getQuote();
$joinTablesAdapter = new RedBeanModelJoinTablesQueryAdapter('Meeting');
$builder = new OrderBysReportQueryBuilder($joinTablesAdapter);
$orderBy = new OrderByForReportForm('MeetingsModule', 'Meeting', Report::TYPE_ROWS_AND_COLUMNS);
$orderBy->attributeIndexOrDerivedType = 'Account__activityItems__Inferred___createdDateTime';
$orderBy2 = new OrderByForReportForm('MeetingsModule', 'Meeting', Report::TYPE_ROWS_AND_COLUMNS);
$orderBy2->attributeIndexOrDerivedType = 'Account__activityItems__Inferred___name';
$content = $builder->makeQueryContent(array($orderBy, $orderBy2));
$compareContent = "{$q}item{$q}.{$q}createddatetime{$q} asc, " . "{$q}account{$q}.{$q}name{$q} asc";
$this->assertEquals($compareContent, $content);
$leftTablesAndAliases = $joinTablesAdapter->getLeftTablesAndAliases();
$fromTablesAndAliases = $joinTablesAdapter->getFromTablesAndAliases();
$this->assertEquals(1, $joinTablesAdapter->getFromTableJoinCount());
$this->assertEquals(5, $joinTablesAdapter->getLeftTableJoinCount());
$this->assertEquals('activity_item', $leftTablesAndAliases[0]['tableAliasName']);
$this->assertEquals('activity', $leftTablesAndAliases[0]['onTableAliasName']);
$this->assertEquals('item', $leftTablesAndAliases[1]['tableAliasName']);
$this->assertEquals('activity_item', $leftTablesAndAliases[1]['onTableAliasName']);
$this->assertEquals('securableitem', $leftTablesAndAliases[2]['tableAliasName']);
$this->assertEquals('item', $leftTablesAndAliases[2]['onTableAliasName']);
$this->assertEquals('ownedsecurableitem', $leftTablesAndAliases[3]['tableAliasName']);
$this->assertEquals('securableitem', $leftTablesAndAliases[3]['onTableAliasName']);
$this->assertEquals('account', $leftTablesAndAliases[4]['tableAliasName']);
$this->assertEquals('ownedsecurableitem', $leftTablesAndAliases[4]['onTableAliasName']);
}
