/**
* Get sales amount expression
*
* Override to use store not base values
*
* @return string
*/
protected function _getSalesAmountExpression()
{
if (is_null($this->_salesAmountExpression)) {
$adapter = $this->getConnection();
$expressionDTO = new Varien_Object(array('expression' => '%s - %s - %s - (%s - %s - %s)', 'arguments' => array($adapter->getIfNullSql('main_table.total_invoiced', 0), $adapter->getIfNullSql('main_table.tax_invoiced', 0), $adapter->getIfNullSql('main_table.shipping_invoiced', 0), $adapter->getIfNullSql('main_table.total_refunded', 0), $adapter->getIfNullSql('main_table.tax_refunded', 0), $adapter->getIfNullSql('main_table.shipping_refunded', 0))));
Mage::dispatchEvent('sales_prepare_amount_expression', array('collection' => $this, 'expression_object' => $expressionDTO));
$this->_salesAmountExpression = vsprintf($expressionDTO->getExpression(), $expressionDTO->getArguments());
}
return $this->_salesAmountExpression;
}
/**
* get sales amount expression
*
* @param $collection
*
* @return string
*/
public function getSalesAmountExpression($collection)
{
$adapter = $collection->getConnection();
$expressionTransferObject = new Varien_Object(array('expression' => '%s - %s - %s - (%s - %s - %s)', 'arguments' => array($adapter->getIfNullSql('main_table.base_total_invoiced', 0), $adapter->getIfNullSql('main_table.base_tax_invoiced', 0), $adapter->getIfNullSql('main_table.base_shipping_invoiced', 0), $adapter->getIfNullSql('main_table.base_total_refunded', 0), $adapter->getIfNullSql('main_table.base_tax_refunded', 0), $adapter->getIfNullSql('main_table.base_shipping_refunded', 0))));
return vsprintf($expressionTransferObject->getExpression(), $expressionTransferObject->getArguments());
}
