Skip to content

Beautiful Open-Source Form Builder

6.5 KB
Raw Blame
<?php

use Illuminate\Support\Facades\Artisan;

it('check formstat chart data', function () {
    $user = $this->actingAsProUser();
    $workspace = $this->createUserWorkspace($user);
    $form = $this->createForm($user, $workspace, []);

    $views = [];
    $submissions = [];
    // Create 10 views & submissions for past days
    for ($i = 1; $i <= 10; $i++) {
        $date = now()->subDays($i);
        $dateString = $date->format('d-m-Y');

        $submission = $form->submissions()->create();
        $submission->created_at = $date;
        $submission->save();
        $view = $form->views()->create();
        $view->created_at = $date;
        $view->save();

        $views[$dateString] = isset($views[$dateString]) ? ($views[$dateString] + 1) : 1;
        $submissions[$dateString] = isset($submissions[$dateString]) ? ($submissions[$dateString] + 1) : 1;
    }

    // Run Command
    Artisan::call('forms:database-cleanup');

    // Create 5 views & submissions
    for ($i = 1; $i <= 5; $i++) {
        $form->views()->create();
        $form->submissions()->create();

        $dateString = now()->format('d-m-Y');
        $views[$dateString] = isset($views[$dateString]) ? ($views[$dateString] + 1) : 1;
        $submissions[$dateString] = isset($submissions[$dateString]) ? ($submissions[$dateString] + 1) : 1;
    }

    // Now check chart data
    $this->getJson(route('open.workspaces.form.stats', [$workspace, $form]) . '?date_from=' . now()->subDays(29)->format('Y-m-d') . '&date_to=' . now()->format('Y-m-d'))
        ->assertSuccessful()
        ->assertJson(function (\Illuminate\Testing\Fluent\AssertableJson $json) use ($views, $submissions) {
            return $json->whereType('views', 'array')
                ->whereType('submissions', 'array')
                ->where('views', function ($values) use ($views) {
                    foreach ($values as $date => $count) {
                        if ((isset($views[$date]) && $views[$date] != $count) || (!isset($views[$date]) && $count != 0)) {
                            return false;
                        }
                    }

                    return true;
                })
                ->where('submissions', function ($values) use ($submissions) {
                    foreach ($values as $date => $count) {
                        if ((isset($submissions[$date]) && $submissions[$date] != $count) || (!isset($submissions[$date]) && $count != 0)) {
                            return false;
                        }
                    }

                    return true;
                })
                ->etc();
        });
});


it('checks form stats details', function () {
    $user = $this->actingAsProUser();
    $workspace = $this->createUserWorkspace($user);
    $form = $this->createForm($user, $workspace, []);

    // Create form submissions with varying completion times
    $form->submissions()->createMany([
        ['completion_time' => 60],  // 1 minute
        ['completion_time' => 60],  // 1 minute
        ['completion_time' => 60],  // 1 minute
        ['completion_time' => 120], // 2 minutes
        ['completion_time' => 120], // 2 minutes
        [] // Incomplete submission
    ]);

    // Create form views with metadata for testing aggregation
    $form->views()->createMany([
        ['meta' => ['source' => 'Google', 'device' => 'Desktop', 'country' => 'US', 'browser' => 'Chrome', 'os' => 'Windows']],
        ['meta' => ['source' => 'Google', 'device' => 'Mobile', 'country' => 'US', 'browser' => 'Chrome', 'os' => 'Android']],
        ['meta' => ['source' => 'Facebook', 'device' => 'Desktop', 'country' => 'UK', 'browser' => 'Firefox', 'os' => 'MacOS']],
        ['meta' => ['source' => 'Direct', 'device' => 'Desktop', 'country' => 'CA', 'browser' => 'Safari', 'os' => 'MacOS']],
        ['meta' => ['source' => 'Google', 'device' => 'Tablet', 'country' => 'US', 'browser' => 'Safari', 'os' => 'iOS']],
        // Views with incomplete metadata (should default to 'Unknown')
        ['meta' => ['source' => null]],
        ['meta' => ['device' => null]],
        ['meta' => []],  // Empty metadata object
        ['meta' => null], // Null metadata
        []  // No metadata field at all
    ]);

    $this->getJson(route('open.workspaces.form.stats-details', [$workspace, $form]))
        ->assertSuccessful()
        ->assertJson(function (\Illuminate\Testing\Fluent\AssertableJson $json) {
            return $json->has('views')
                ->has('submissions')
                ->has('completion_rate')
                ->has('average_duration')
                ->has('meta_stats')
                ->where('views', 10)
                ->where('submissions', 6)
                ->where('completion_rate', 60)
                ->where('average_duration', '1m 24s')
                // Test metadata aggregation
                ->where('meta_stats.source.Google', 3)
                ->where('meta_stats.source.Facebook', 1)
                ->where('meta_stats.source.Direct', 1)
                ->where('meta_stats.source.Unknown', 5)
                ->where('meta_stats.device.Desktop', 3)
                ->where('meta_stats.device.Mobile', 1)
                ->where('meta_stats.device.Tablet', 1)
                ->where('meta_stats.device.Unknown', 5)
                ->where('meta_stats.country.US', 3)
                ->where('meta_stats.country.UK', 1)
                ->where('meta_stats.country.CA', 1)
                ->where('meta_stats.country.Unknown', 5)
                ->where('meta_stats.browser.Chrome', 2)
                ->where('meta_stats.browser.Firefox', 1)
                ->where('meta_stats.browser.Safari', 2)
                ->where('meta_stats.browser.Unknown', 5)
                ->where('meta_stats.os.Windows', 1)
                ->where('meta_stats.os.Android', 1)
                ->where('meta_stats.os.MacOS', 2)
                ->where('meta_stats.os.iOS', 1)
                ->where('meta_stats.os.Unknown', 5)
                ->etc();
        });
});

it('returns 404 when workspace and form do not match on stats endpoints', function () {
    $user = $this->actingAsProUser();
    $workspaceA = $this->createUserWorkspace($user);
    $workspaceB = $this->createUserWorkspace($user);
    $formInWorkspaceA = $this->createForm($user, $workspaceA);

    $this->getJson(route('open.workspaces.form.stats', [$workspaceB, $formInWorkspaceA]) . '?date_from=' . now()->subDays(7)->format('Y-m-d') . '&date_to=' . now()->format('Y-m-d'))
        ->assertStatus(404);

    $this->getJson(route('open.workspaces.form.stats-details', [$workspaceB, $formInWorkspaceA]))
        ->assertStatus(404);
});