public function test_getQueryToSelect()
{
/** === Test Data === */
$sql = "SELECT `paa`.`id` AS `Id`, `paa`.`balance` AS `Balance`, `pata`.`code` AS `Asset`, (CONCAT(firstname, ' ', lastname)) AS `CustName`, `ce`.`email` AS `CustEmail` FROM `prxgt_acc_account` AS `paa`\n LEFT JOIN `prxgt_acc_type_asset` AS `pata` ON pata.id=paa.asset_type_id\n 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->getQueryToSelect();
$this->assertEquals($sql, (string) $res);
}
public function getQueryToSelect()
{
$result = parent::getQueryToSelect();
$this->_populateSelect($result);
return $result;
}
