<?php declare(strict_types = 1);

class Widget
{
    public static function getDefault()
    {
        $order = [0, 0];
        [$column1, $column2] = [
            ['Foo1', 'Foo2', 'Foo3', 'Foo4'],
            ['Bar1', 'Bar2', 'Bar3', 'Bar4'],
        ];

        return collect()
            ->map(function ($widget) use ($column1, $column2, &$order) {
                if (in_array($widget->name, $column1)) {
                    $column = 1;
                } elseif (in_array($widget->name, $column2)) {
                    $column = 2;
                } else {
                    $column = count($column1) > count($column2) ? 2 : 1;
                }

                return [
                    'widget_id' => $widget->id,
                    'enabled'   => 1,
                    'column'    => $column,                 // 1-based indexing
                    'order'     => $order[$column - 1]++    // 0-based indexing
                ];
            })
            ->all();
    }
}