/**
* @depends testMakeStringForMultipleLinks
*/
public function testMakeStringForLinkOrLinks()
{
$accounts = Account::getByName('account1');
$account1 = $accounts[0];
$account2 = $accounts[1];
$displayAttribute = new DisplayAttributeForReportForm('AccountsModule', 'Account', Report::TYPE_ROWS_AND_COLUMNS);
$displayAttribute->setModelAliasUsingTableAliasName('abc');
$displayAttribute->attributeIndexOrDerivedType = 'name';
$reportResultsRowData = new ReportResultsRowData(array($displayAttribute), 4);
$reportResultsRowData->addModelAndAlias($account2, 'abc');
$result = ReportResultsGridUtil::makeStringForLinkOrLinks('attribute0', $reportResultsRowData, true, 'account1');
$this->assertContains('<span class="tooltip">2</span>', $result);
$result = ReportResultsGridUtil::makeStringForLinkOrLinks('attribute0', $reportResultsRowData, false, 'account1');
$this->assertContains('a target="new"', $result);
$this->assertContains('id=' . $account2->id, $result);
$this->assertNotContains('tooltip', $result);
}
/**
* @param int $offset
* @param int $limit
* @return array
*/
protected function runQueryAndGetResolveResultsData($offset, $limit)
{
assert('is_int($offset) || $offset == null');
assert('is_int($limit) || $limit == null');
$selectQueryAdapter = $this->makeSelectQueryAdapter();
$sql = $this->makeSqlQueryForFetchingData($selectQueryAdapter, $offset, $limit);
$rows = $this->getRowsData($sql);
$resultsData = array();
$idByOffset = self::resolveIdByOffset($offset);
foreach ($rows as $key => $row) {
$reportResultsRowData = new ReportResultsRowData($this->resolveDisplayAttributes(), $idByOffset);
foreach ($selectQueryAdapter->getIdTableAliasesAndModelClassNames() as $tableAlias => $modelClassName) {
$idColumnName = $selectQueryAdapter->getIdColumNameByTableAlias($tableAlias);
$id = (int) $row[$idColumnName];
if ($id != null) {
$reportResultsRowData->addModelAndAlias($modelClassName::getById($id), $tableAlias);
}
unset($row[$idColumnName]);
}
foreach ($row as $columnName => $value) {
$reportResultsRowData->addSelectedColumnNameAndValue($columnName, $value);
}
$resultsData[$key] = $reportResultsRowData;
$idByOffset++;
}
return $resultsData;
}
/**
* There was a bug with showing address->state on a contact rows and columns report. it was showing the
* contact->state instead. this test passes after this bug was fixed
*/
public function testDisplayingAOwnedModelAttributeThatIsAlsoDefinedAsAnAttributeOnTheOwningModel()
{
$contactStates = ContactState::getByName('Qualified');
$contact = new Contact();
$contact->owner = Yii::app()->user->userModel;
$contact->title->value = 'Mr.';
$contact->firstName = 'Super';
$contact->lastName = 'Man';
$contact->jobTitle = 'Superhero';
$contact->description = 'Some Description';
$contact->department = 'Red Tape';
$contact->officePhone = '1234567890';
$contact->mobilePhone = '0987654321';
$contact->officeFax = '1222222222';
$contact->state = $contactStates[0];
$contact->primaryAddress->state = 'IL';
$this->assertTrue($contact->save());
$displayAttribute = new DisplayAttributeForReportForm('ContactsModule', 'Contact', Report::TYPE_ROWS_AND_COLUMNS);
$displayAttribute->setModelAliasUsingTableAliasName('abc');
$displayAttribute->attributeIndexOrDerivedType = 'primaryAddress___state';
$this->assertEquals('col0', $displayAttribute->columnAliasName);
$reportResultsRowData = new ReportResultsRowData(array($displayAttribute), 4);
$reportResultsRowData->addModelAndAlias($contact, 'abc');
$model = $reportResultsRowData->getModel('attribute0');
$this->assertEquals('IL', $model->primaryAddress->state);
$this->assertEquals('IL', $reportResultsRowData->attribute0);
}
/**
* Test for viaSelect and viaModel together
* @depends testExportSummationAttributes
*/
public function testViaSelectAndViaModelTogether()
{
$reportModelTestItem = new ReportModelTestItem();
$report = new Report();
//viaSelect attribute
$displayAttribute1 = new DisplayAttributeForReportForm('ReportsTestModule', 'ReportModelTestItem', Report::TYPE_SUMMATION);
$displayAttribute1->attributeIndexOrDerivedType = 'integer__Minimum';
$displayAttribute1->madeViaSelectInsteadOfViaModel = true;
$this->assertTrue($displayAttribute1->columnAliasName == 'col0');
//viaModel attribute
$reportModelTestItem->boolean = true;
$displayAttribute2 = new DisplayAttributeForReportForm('ReportsTestModule', 'ReportModelTestItem', Report::TYPE_ROWS_AND_COLUMNS);
$displayAttribute2->setModelAliasUsingTableAliasName('model1');
$displayAttribute2->attributeIndexOrDerivedType = 'boolean';
$reportResultsRowData = new ReportResultsRowData(array($displayAttribute1, $displayAttribute2), 4);
$reportResultsRowData->addSelectedColumnNameAndValue('col0', 9000);
$reportResultsRowData->addModelAndAlias($reportModelTestItem, 'model1');
$adapter = new ReportToExportAdapter($reportResultsRowData, $report);
$compareHeaderData = array('Integer -(Min)', 'Boolean');
$compareRowData = array(9000, true);
$this->assertEquals($compareHeaderData, $adapter->getHeaderData());
$this->assertEquals($compareRowData, $adapter->getData());
}
public function testResolveValueOnBaseModelAndRelatedModel()
{
$reportModelTestItem11 = new ReportModelTestItem11();
$reportModelTestItem11->integer = 5;
$currencies = Currency::getAll();
$currencyValue = new CurrencyValue();
$currencyValue->value = 100;
$currencyValue->currency = $currencies[0];
$reportModelTestItem11->amount = $currencyValue;
$reportModelTestItem11b = new ReportModelTestItem11();
$reportModelTestItem11b->integer = 7;
$currencyValue = new CurrencyValue();
$currencyValue->value = 200;
$currencyValue->currency = $currencies[0];
$reportModelTestItem11b->amount = $currencyValue;
$reportModelTestItem10 = new ReportModelTestItem10();
$reportModelTestItem10->integer = 12;
$currencyValue = new CurrencyValue();
$currencyValue->value = 400;
$currencyValue->currency = $currencies[0];
$reportModelTestItem10->currencyValue = $currencyValue;
$reportModelTestItem10->reportModelTestItem11->add($reportModelTestItem11);
$reportModelTestItem10->reportModelTestItem11->add($reportModelTestItem11b);
$saved = $reportModelTestItem10->save();
$this->assertTrue($saved);
$displayAttributeX = new DisplayAttributeForReportForm('ReportsTestModule', 'ReportModelTestItem10', Report::TYPE_ROWS_AND_COLUMNS);
$displayAttributeX->setModelAliasUsingTableAliasName('abc');
$displayAttributeX->attributeIndexOrDerivedType = 'reportModelTestItem11___calculated2';
$this->assertEquals('col0', $displayAttributeX->columnAliasName);
$displayAttributeY = new DisplayAttributeForReportForm('ReportsTestModule', 'ReportModelTestItem10', Report::TYPE_ROWS_AND_COLUMNS);
$displayAttributeY->setModelAliasUsingTableAliasName('def');
$displayAttributeY->attributeIndexOrDerivedType = 'calculated';
$this->assertEquals('col1', $displayAttributeY->columnAliasName);
$reportResultsRowData = new ReportResultsRowData(array($displayAttributeX, $displayAttributeY), 4);
$reportResultsRowData->addModelAndAlias($reportModelTestItem11b, 'abc');
$reportResultsRowData->addModelAndAlias($reportModelTestItem10, 'def');
//Get value for calculated which is on base model
$value = CalculatedNumberForReportListViewColumnAdapter::resolveValue('attribute1', $reportResultsRowData);
$this->assertEquals('$412.00', $value);
//Get value for calculated2 which is on a relateds model
$value = CalculatedNumberForReportListViewColumnAdapter::resolveValue('attribute0', $reportResultsRowData);
$this->assertEquals('$207.00', $value);
}
public function testGetAttributeLabel()
{
$reportModelTestItemX = new ReportModelTestItem();
$reportModelTestItemX->string = 'someString';
$displayAttributeX = new DisplayAttributeForReportForm('ReportsTestModule', 'ReportModelTestItem', Report::TYPE_SUMMATION);
$displayAttributeX->setModelAliasUsingTableAliasName('abc');
$displayAttributeX->attributeIndexOrDerivedType = 'string';
$displayAttributeY = new DisplayAttributeForReportForm('ReportsTestModule', 'ReportModelTestItem', Report::TYPE_SUMMATION);
$displayAttributeY->attributeIndexOrDerivedType = 'integer__Maximum';
$reportResultsRowData = new ReportResultsRowData(array($displayAttributeX, $displayAttributeY), 4);
$reportResultsRowData->addModelAndAlias($reportModelTestItemX, 'abc');
$reportResultsRowData->addSelectedColumnNameAndValue('col1', 55);
//Test a viaModel attribute
$this->assertEquals('String', $reportResultsRowData->getAttributeLabel('attribute0'));
//Test a viaSelect attriubte
$this->assertEquals('Integer -(Max)', $reportResultsRowData->getAttributeLabel('col1'));
}