public static function getClicksOverview($domainID, $resolution, $url)
{
$query = '
SELECT
resolution,
x,
y
FROM
interface_click
WHERE
domain_id = ?
AND resolution = ?
AND url = ?
';
return Database::selectFetchAll($query, [$domainID, $resolution, $url]);
}
public function setCampaigns($value = '')
{
$query = '
SELECT
interface_campaigns.name,
interface_campaigns_type.name AS type_name,
DATE(interface_campaigns.start) AS start,
DATE(interface_campaigns.end) AS end
FROM
interface_campaigns
JOIN interface_campaigns_type
ON interface_campaigns.type_id = interface_campaigns_type.type_id
';
foreach (Database::selectFetchAll($query, []) as $row) {
if (!in_array($row['type_name'], $this->campaign_types)) {
$this->campaign_types[] = ['type_name' => $row['type_name']];
}
$this->campaigns[] = new Campaign($row['name'], $row['type_name'], $row['start'], $row['end']);
}
}