| 1 |
<?php |
| 2 |
/** |
| 3 |
* @package FireBox |
| 4 |
* @version 3.1.13 Free |
| 5 |
* |
| 6 |
* @author FirePlugins <info@fireplugins.com> |
| 7 |
* @link https://www.fireplugins.com |
| 8 |
* @copyright Copyright © 2026 FirePlugins All Rights Reserved |
| 9 |
* @license GNU GPLv3 <http://www.gnu.org/licenses/gpl.html> or later |
| 10 |
*/ |
| 11 |
|
| 12 |
namespace FireBox\Core\Analytics\Metrics; |
| 13 |
|
| 14 |
use FireBox\Core\Analytics\QueryBuilders\ViewsQueryStrategyFactory; |
| 15 |
|
| 16 |
if (!defined('ABSPATH')) |
| 17 |
{ |
| 18 |
exit; // Exit if accessed directly. |
| 19 |
} |
| 20 |
|
| 21 |
class Views extends Metric |
| 22 |
{ |
| 23 |
/** |
| 24 |
* Create the Views-specific query strategy |
| 25 |
*/ |
| 26 |
protected function createQueryStrategy() |
| 27 |
{ |
| 28 |
return ViewsQueryStrategyFactory::create($this->type, $this); |
| 29 |
} |
| 30 |
|
| 31 |
/** |
| 32 |
* Get data using strategy pattern |
| 33 |
*/ |
| 34 |
public function getData() |
| 35 |
{ |
| 36 |
$strategy = $this->createQueryStrategy(); |
| 37 |
|
| 38 |
$sql = "SELECT |
| 39 |
{$strategy->getSelect()} |
| 40 |
FROM |
| 41 |
{$strategy->getFromAndJoins()} |
| 42 |
WHERE |
| 43 |
1 |
| 44 |
{$strategy->getWherePeriod()} |
| 45 |
{$strategy->getWhere()} |
| 46 |
{$strategy->getFilters()} |
| 47 |
{$strategy->getGroupBy()} |
| 48 |
{$strategy->getHaving()} |
| 49 |
{$strategy->getOrderBy()} |
| 50 |
{$strategy->getLimitOffset()} |
| 51 |
"; |
| 52 |
|
| 53 |
return $this->executeQuery($sql); |
| 54 |
} |
| 55 |
|
| 56 |
/** |
| 57 |
* Indicates this class handles timezone conversion in SQL |
| 58 |
*/ |
| 59 |
public function hasTimezoneSQLConversion() |
| 60 |
{ |
| 61 |
return true; |
| 62 |
} |
| 63 |
} |
