Rows.php
| 1 | <?php |
| 2 | |
| 3 | namespace IAWP\Rows; |
| 4 | |
| 5 | use IAWP\Date_Range\Date_Range; |
| 6 | use IAWP\Form_Submissions\Form; |
| 7 | use IAWP\Illuminate_Builder; |
| 8 | use IAWP\Query; |
| 9 | use IAWP\Sort_Configuration; |
| 10 | use IAWPSCOPED\Illuminate\Database\Query\Builder; |
| 11 | /** @internal */ |
| 12 | abstract class Rows |
| 13 | { |
| 14 | protected $date_range; |
| 15 | protected $number_of_rows; |
| 16 | /** @var Filter[] */ |
| 17 | protected $filters; |
| 18 | protected $sort_configuration; |
| 19 | private $rows = null; |
| 20 | public function __construct(Date_Range $date_range, ?int $number_of_rows = null, ?array $filters = null, ?Sort_Configuration $sort_configuration = null) |
| 21 | { |
| 22 | $this->date_range = $date_range; |
| 23 | $this->number_of_rows = $number_of_rows; |
| 24 | $this->filters = $filters ?? []; |
| 25 | $this->sort_configuration = $sort_configuration ?? new Sort_Configuration(); |
| 26 | } |
| 27 | protected abstract function fetch_rows() : array; |
| 28 | public abstract function attach_filters(Builder $query) : void; |
| 29 | public function rows() |
| 30 | { |
| 31 | if (\is_array($this->rows)) { |
| 32 | return $this->rows; |
| 33 | } |
| 34 | $this->rows = $this->fetch_rows(); |
| 35 | return $this->rows; |
| 36 | } |
| 37 | /** |
| 38 | * @return string[] |
| 39 | */ |
| 40 | protected function calculated_columns() : array |
| 41 | { |
| 42 | $calculated_columns = ['comments', 'exit_percent', 'views_per_session', 'views_growth', 'visitors_growth', 'bounce_rate', 'wc_net_sales', 'wc_conversion_rate', 'wc_earnings_per_visitor', 'wc_average_order_volume', 'form_conversion_rate']; |
| 43 | foreach (Form::get_forms() as $form) { |
| 44 | $calculated_columns[] = $form->conversion_rate_column(); |
| 45 | } |
| 46 | return $calculated_columns; |
| 47 | } |
| 48 | protected function is_a_calculated_column(string $column_name) : bool |
| 49 | { |
| 50 | return \in_array($column_name, $this->calculated_columns()); |
| 51 | } |
| 52 | protected function is_using_a_calculated_column() : bool |
| 53 | { |
| 54 | $is_using_a_calculated_column = \false; |
| 55 | foreach ($this->filters as $filter) { |
| 56 | if (\in_array($filter->column(), $this->calculated_columns())) { |
| 57 | $is_using_a_calculated_column = \true; |
| 58 | } |
| 59 | } |
| 60 | if (\in_array($this->sort_configuration->column(), $this->calculated_columns())) { |
| 61 | $is_using_a_calculated_column = \true; |
| 62 | } |
| 63 | return $is_using_a_calculated_column; |
| 64 | } |
| 65 | protected function get_current_period_iso_range() : array |
| 66 | { |
| 67 | return [$this->date_range->iso_start(), $this->date_range->iso_end()]; |
| 68 | } |
| 69 | protected function get_previous_period_iso_range() : array |
| 70 | { |
| 71 | return [$this->date_range->previous_period()->iso_start(), $this->date_range->previous_period()->iso_end()]; |
| 72 | } |
| 73 | protected function get_form_submissions_query() : Builder |
| 74 | { |
| 75 | $form_submissions_table = Query::get_table_name(Query::FORM_SUBMISSIONS); |
| 76 | return Illuminate_Builder::get_builder()->select(['form_id', 'view_id'])->selectRaw('COUNT(*) AS form_submissions')->from($form_submissions_table, 'form_submissions')->whereBetween('created_at', $this->get_current_period_iso_range())->groupBy(['form_id', 'view_id']); |
| 77 | } |
| 78 | } |
| 79 |