function generateReportsQuery($module)
{
global $current_user;
$query = parent::generateReportsQuery($module);
$query .= " LEFT JOIN (\n\t\t\t\tSELECT vtiger_service.serviceid,\n\t\t\t\t\t\t(CASE WHEN (vtiger_service.currency_id = 1 ) THEN vtiger_service.unit_price\n\t\t\t\t\t\t\tELSE (vtiger_service.unit_price / vtiger_currency_info.conversion_rate) END\n\t\t\t\t\t\t) AS actual_unit_price\n\t\t\t\tFROM vtiger_service\n\t\t\t\tLEFT JOIN vtiger_currency_info ON vtiger_service.currency_id = vtiger_currency_info.id\n\t\t\t\tLEFT JOIN vtiger_productcurrencyrel ON vtiger_service.serviceid = vtiger_productcurrencyrel.productid\n\t\t\t\tAND vtiger_productcurrencyrel.currencyid = " . $current_user->currency_id . "\n\t\t\t) AS innerService ON innerService.serviceid = vtiger_service.serviceid";
return $query;
}
