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']); } }