/**
* Test zone daily statistics.
*
*/
function testGetZoneDailyStatistics()
{
$doAgency = OA_Dal::factoryDO('agency');
$doPublisher = OA_Dal::factoryDO('affiliates');
$doZone = OA_Dal::factoryDO('zones');
$this->generateZoneWithParents($doAgency, $doPublisher, $doZone);
$doDataSummaryAdHourly = OA_Dal::factoryDO('data_summary_ad_hourly');
$doDataSummaryAdHourly->impressions = 121;
$doDataSummaryAdHourly->requests = 223;
$doDataSummaryAdHourly->total_revenue = 433;
$doDataSummaryAdHourly->clicks = 9894;
$doDataSummaryAdHourly->date_time = '2006-06-06';
$this->generateDataSummaryAdHourlyForZone($doDataSummaryAdHourly, $doZone);
// 1. Get data existing range
$aData = $this->_dalZoneStatistics->getZoneDailyStatistics($doZone->zoneid, new Date('2005-08-20'), new Date('2007-08-20'));
$this->assertEqual(count($aData), 1, 'Some records should be returned');
$aRow = current($aData);
// 2. Check return fields names
$this->assertFieldExists($aRow, 'day');
$this->assertFieldExists($aRow, 'requests');
$this->assertFieldExists($aRow, 'impressions');
$this->assertFieldExists($aRow, 'clicks');
$this->assertFieldExists($aRow, 'revenue');
// 3. Check return fields value
$this->assertFieldEqual($aRow, 'impressions', 121);
$this->assertFieldEqual($aRow, 'requests', 223);
$this->assertFieldEqual($aRow, 'revenue', 433);
$this->assertFieldEqual($aRow, 'clicks', 9894);
$this->assertFieldEqual($aRow, 'day', '2006-06-06');
// 4. Get data in not existing range
$aData = $this->_dalZoneStatistics->getZoneDailyStatistics($doZone->zoneid, new Date('2001-12-01'), new Date('2006-01-19'));
$this->assertEqual(count($aData), 0, 'Recordset should be empty');
}
/**
* This method returns daily statistics for a zone for a specified period.
*
* @access public
*
* @param integer $zoneId The ID of the zone to view statistics
* @param date $oStartDate The date from which to get statistics (inclusive)
* @param date $oEndDate The date to which to get statistics (inclusive)
* @param bool $localTZ Should stats be using the manager TZ or UTC?
* @param array $rsStatisticsData The data returned by the function
* <ul>
* <li><b>day date</b> The day
* <li><b>requests integer</b> The number of requests for the day
* <li><b>impressions integer</b> The number of impressions for the day
* <li><b>clicks integer</b> The number of clicks for the day
* <li><b>revenue decimal</b> The revenue earned for the day
* </ul>
*
* @return boolean True if the operation was successful and false if not.
*
*/
function getZoneDailyStatistics($zoneId, $oStartDate, $oEndDate, $localTZ, &$rsStatisticsData)
{
if (!$this->checkStatisticsPermissions($zoneId)) {
return false;
}
if ($this->_validateForStatistics($zoneId, $oStartDate, $oEndDate)) {
$dalZone = new OA_Dal_Statistics_Zone();
$rsStatisticsData = $dalZone->getZoneDailyStatistics($zoneId, $oStartDate, $oEndDate, $localTZ);
return true;
} else {
return false;
}
}