public function test_getQueryToSelectCount()
{
/** === Test Data === */
$sql = 'SELECT (COUNT(paa.id)) FROM `prxgt_acc_account` AS `paa`
LEFT JOIN `prxgt_acc_type_asset` AS `pata` ON pata.id=paa.asset_type_id
LEFT JOIN `customer_entity` AS `ce` ON ce.entity_id=paa.customer_id';
/** === Setup Mocks === */
$this->_setTableNames([EAccount::ENTITY_NAME, Cfg::ENTITY_MAGE_CUSTOMER, ETypeAsset::ENTITY_NAME]);
/** === Call and asserts === */
$res = $this->obj->getQueryToSelectCount();
$this->assertEquals($sql, (string) $res);
}
public function getQueryToSelect()
{
$result = parent::getQueryToSelect();
$this->_populateSelect($result);
return $result;
}
