Campaigns.php
10 months ago
Cities.php
10 months ago
Countries.php
10 months ago
Device_Browsers.php
10 months ago
Device_OSS.php
10 months ago
Device_Types.php
10 months ago
Filter.php
1 year ago
Forms.php
10 months ago
Link_Patterns.php
10 months ago
Links.php
10 months ago
Pages.php
10 months ago
Referrers.php
10 months ago
Rows.php
11 months ago
Forms.php
39 lines
| 1 | <?php |
| 2 | |
| 3 | namespace IAWP\Rows; |
| 4 | |
| 5 | use IAWP\Illuminate_Builder; |
| 6 | use IAWP\Models\Form; |
| 7 | use IAWPSCOPED\Illuminate\Database\Query\Builder; |
| 8 | /** @internal */ |
| 9 | class Forms extends \IAWP\Rows\Rows |
| 10 | { |
| 11 | public function attach_filters(Builder $query) : void |
| 12 | { |
| 13 | // There are no filters to attach as this is used for the email report and not a dashboard |
| 14 | } |
| 15 | protected function fetch_rows() : array |
| 16 | { |
| 17 | $rows = $this->query()->get()->all(); |
| 18 | return \array_map(function ($row) { |
| 19 | return new Form($row); |
| 20 | }, $rows); |
| 21 | } |
| 22 | private function query(?bool $skip_pagination = \false) : Builder |
| 23 | { |
| 24 | if ($skip_pagination) { |
| 25 | $this->number_of_rows = null; |
| 26 | } |
| 27 | $query = Illuminate_Builder::new()->select(['forms.form_id', 'forms.cached_form_title AS form_title'])->selectRaw('COUNT(DISTINCT form_submissions.form_submission_id) AS submissions')->from($this->tables::forms(), 'forms')->leftJoin($this->tables::form_submissions() . ' AS form_submissions', 'form_submissions.form_id', '=', 'forms.form_id')->whereBetween('form_submissions.created_at', $this->get_current_period_iso_range())->when(\count($this->filters) > 0, function (Builder $query) { |
| 28 | foreach ($this->filters as $filter) { |
| 29 | if (!$this->is_a_calculated_column($filter->column())) { |
| 30 | $filter->apply_to_query($query); |
| 31 | } |
| 32 | } |
| 33 | })->when(\is_int($this->number_of_rows), function (Builder $query) { |
| 34 | $query->limit($this->number_of_rows); |
| 35 | })->orderBy($this->sort_configuration->column(), $this->sort_configuration->direction())->orderBy('form_title')->groupBy('forms.form_id'); |
| 36 | return $query; |
| 37 | } |
| 38 | } |
| 39 |