firebox / Inc / Core / Analytics / QueryBuilders / ConversionRate / BaseConversionRateQueryStrategy.php

BaseConversionRateQueryStrategy.php in FireBox – WooCommerce Popup Builder, Exit Intent Popup, Email Optin & Cart Abandonment 3.1.8, at Inc/Core/Analytics/QueryBuilders/ConversionRate/BaseConversionRateQueryStrategy.php

41 lines 1.0 KB

Raw Download Zip

1	<?php
2	/**
3	* @package FireBox
4	* @version 3.1.8 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\QueryBuilders\ConversionRate;
13
14	use FireBox\Core\Analytics\QueryBuilders\BaseQueryStrategy;
15
16	if (!defined('ABSPATH'))
17	{
18	exit; // Exit if accessed directly.
19	}
20
21	abstract class BaseConversionRateQueryStrategy extends BaseQueryStrategy
22	{
23	/**
24	* ConversionRate uses logs table date column
25	*/
26	protected function getDateColumn(): string
27	{
28	return 'l.date';
29	}
30
31	/**
32	* ConversionRate-specific FROM/JOIN logic
33	* Uses logs as primary table with LEFT JOIN to logs_details
34	*/
35	protected function getDefaultFromAndJoins(): string
36	{
37	return "{$this->metric->getTableLogs()} as l
38	LEFT JOIN {$this->metric->getTableDetails()} as bld ON l.id = bld.log_id AND bld.event = 'conversion'";
39	}
40	}
41