Campaigns.php
2 years ago
Cities.php
2 years ago
Countries.php
2 years ago
Current_Traffic_Finder.php
3 years ago
Device_Browsers.php
2 years ago
Device_Operating_Systems.php
2 years ago
Device_Types.php
2 years ago
Referrers.php
2 years ago
Resources.php
2 years ago
Table_Data.php
3 years ago
Visitors_Over_Time_Finder.php
3 years ago
Visitors_Over_Time_Finder.php
57 lines
| 1 | <?php |
| 2 | |
| 3 | namespace IAWP_SCOPED\IAWP\Queries; |
| 4 | |
| 5 | use IAWP_SCOPED\IAWP\Date_Range\Date_Range; |
| 6 | use IAWP_SCOPED\IAWP\Interval\Interval; |
| 7 | use IAWP_SCOPED\IAWP\Query; |
| 8 | class Visitors_Over_Time_Finder |
| 9 | { |
| 10 | /** |
| 11 | * @var Date_Range |
| 12 | */ |
| 13 | private $date_range; |
| 14 | private $interval; |
| 15 | /** |
| 16 | * @param Date_Range $date_range Range to fetch referrers for |
| 17 | */ |
| 18 | public function __construct(Date_Range $date_range, Interval $interval) |
| 19 | { |
| 20 | $this->date_range = $date_range; |
| 21 | $this->interval = $interval; |
| 22 | } |
| 23 | public function fetch() |
| 24 | { |
| 25 | $rows = Query::query($this->interval->get_query_name(), ['start' => $this->date_range->iso_start(), 'end' => $this->date_range->iso_end()])->rows(); |
| 26 | return $this->rows_to_class($rows); |
| 27 | } |
| 28 | private function rows_to_class(array $rows) : object |
| 29 | { |
| 30 | $date_interval = $this->interval->get_date_interval(); |
| 31 | $date_period = new \DatePeriod($this->date_range->start(), $date_interval, $this->date_range->end()); |
| 32 | $interval_data = []; |
| 33 | $visitors_data = []; |
| 34 | $views_data = []; |
| 35 | foreach ($date_period as $index => $date) { |
| 36 | $current_interval = $index; |
| 37 | $current_visitors = 0; |
| 38 | $current_views = 0; |
| 39 | foreach ($rows as $row) { |
| 40 | $row_interval = \intval($row->interval_ago); |
| 41 | $row_visitors = \intval($row->visitors); |
| 42 | $row_views = \intval($row->views); |
| 43 | if ($row_interval === $index) { |
| 44 | $current_interval = $row_interval; |
| 45 | $current_visitors = $row_visitors; |
| 46 | $current_views = $row_views; |
| 47 | break; |
| 48 | } |
| 49 | } |
| 50 | $interval_data[] = $current_interval; |
| 51 | $visitors_data[] = $current_visitors; |
| 52 | $views_data[] = $current_views; |
| 53 | } |
| 54 | return (object) ['visitors' => $visitors_data, 'views' => $views_data, 'interval_labels_short' => $this->interval->get_short_labels($interval_data), 'interval_labels_full' => $this->interval->get_full_labels($interval_data)]; |
| 55 | } |
| 56 | } |
| 57 |