App\Http\Controllers\Admin\StudentCrudController::setupListOperation()

Complexity

Conditions	6
Paths	5

Size

Total Lines	181
Code Lines	114

Duplication

Lines	0
Ratio	0 %

Importance

Changes	6
Bugs	3	Features	0

<?php
    public function setupListOperation()
    {

        // display lead status counts on page top
        foreach (LeadType::all() as $leadType) {
            if ($leadType->id === 4) {
                $count = Student::where('lead_type_id', $leadType->id)->orWhereNull('lead_type_id')->count();
            } else {
                $count = Student::where('lead_type_id', $leadType->id)->count();
            }
            if ($count > 0) {
                Widget::add([
                    'type' => 'view',
                    'view' => 'students.lead-type-insights-widget',
                    'studentCount' => $count,
                    'name' => Str::plural($leadType->name),
                    'icon' => $leadType->icon,
                    'leadTypeId' => $leadType->id,
                    'description' => $leadType->description,
                ])->to('before_content');
            }
        }

        // Columns.
        CRUD::setColumns([
            [
                'label' => __('ID number'),
                'type' => 'text',
                'name' => 'idnumber',
            ],
            [
                // 1-n relationship
                'label' => __('Last Name'),
                'type' => 'relationship',
                'key' => 'lastname',
                'name' => 'user',
                'attribute' => 'lastname',
                'model' => User::class,
                'orderable' => true,
                'orderLogic' => fn ($query, $column, $columnDirection) => $query->leftJoin('users', 'users.id', '=', 'students.id')
                    ->orderBy('users.lastname', $columnDirection)->select('students.*'),
                'searchLogic' => function ($query, $column, $searchTerm) {
                    $query->orWhereHas('user', function ($q) use ($searchTerm) {
                        $q->where('lastname', 'like', '%'.$searchTerm.'%');
                    });
                },
            ],

            [
                // 1-n relationship
                'label' => __('First Name'),
                'type' => 'relationship',
                'key' => 'firstname',
                'name' => 'user',
                'attribute' => 'firstname',
                'model' => User::class,
                'orderable' => true,
                'orderLogic' => fn ($query, $column, $columnDirection) => $query->leftJoin('users', 'users.id', '=', 'students.id')
                    ->orderBy('users.firstname', $columnDirection)->select('students.*'),
                'searchLogic' => function ($query, $column, $searchTerm) {
                    $query->orWhereHas('user', function ($q) use ($searchTerm) {
                        $q->where('firstname', 'like', '%'.$searchTerm.'%');
                    });
                },
            ],

            [
                // 1-n relationship
                'label' => __('Email'),
                'type' => 'relationship',
                'name' => 'user',
                'attribute' => 'email',
                'model' => User::class,
                'orderable' => true,
                'orderLogic' => fn ($query, $column, $columnDirection) => $query->leftJoin('users', 'users.id', '=', 'students.id')
                    ->orderBy('users.email', $columnDirection)->select('students.*'),
                'searchLogic' => function ($query, $column, $searchTerm) {
                    $query->orWhereHas('user', function ($q) use ($searchTerm) {
                        $q->where('email', 'like', '%'.$searchTerm.'%');
                    });
                },
            ],

            [
                'label' => __('Username'),
                'type' => 'relationship',
                'key' => 'username',
                'name' => 'user',
                'attribute' => 'username',
                'model' => User::class,
                'orderable' => false,
                'searchLogic' => false,
            ],

            [
                'label' => __('Age'),
                'name' => 'student_age',
            ],

            [
                'label' => __('Birthdate'),
                'name' => 'student_birthdate',
            ],

            [
                // n-n relationship (with pivot table)
                'label' => __('Phone number'),
                'type' => 'select_multiple',
                'name' => 'phone',
                'attribute' => 'phone_number',
                'model' => PhoneNumber::class,
            ],

            [
                // 1-n relationship
                'label' => __('Status'),
                'type' => 'text',
                'name' => 'lead_status_name',
                'orderable' => false,
            ],

        ]);

        CRUD::addFilter(
            [ // select2 filter
                'name' => 'enrolled',
                'type' => 'select2',
                'label' => __('Is Enrolled in'),
            ],
            fn () => Period::all()->pluck('name', 'id')->toArray(),
            function ($value) {
                $this->crud->query = $this->crud->query->whereHas('enrollments', fn ($query) => $query->whereHas('course', function ($q) use ($value) {
                    $q->where('period_id', $value);
                }));
            },
            function () { // if the filter is NOT active (the GET parameter "checkbox" does not exit)
            }
        );

        CRUD::addFilter([ // select2_multiple filter
            'name' => 'notenrolled',
            'type' => 'select2_multiple',
            'label' => __('Is Not Enrolled in'),
        ], fn () => Period::all()->pluck('name', 'id')->toArray(), function ($values) {
            foreach (json_decode($values, null, 512, JSON_THROW_ON_ERROR) as $value) {
                $this->crud->query = $this->crud->query->whereDoesntHave('enrollments', fn ($query) => $query->whereHas('course', function ($q) use ($value) {
                    $q->where('period_id', $value);
                }));
            }
        });

        CRUD::addFilter(
            [
                'name' => 'new_students',
                'type' => 'select2',
                'label' => __('New In'),
            ],
            fn () => Period::all()->pluck('name', 'id')->toArray(),
            function ($value) {
                CRUD::addClause('newInPeriod', $value);
            }
        );

        // select2 filter
        $this->crud->addFilter([
            'name' => 'institution_id',
            'type' => 'select2',
            'label' => __('Institution'),
        ], fn () => Institution::all()->pluck('name', 'id')->toArray(), function ($value) {
            $this->crud->addClause('where', 'institution_id', $value);
        });

        $this->crud->addFilter([
            'name' => 'lead_type_id',
            'type' => 'select2',
            'label' => __('Lead Status'),
        ], fn () => LeadType::all()->pluck('name', 'id')->toArray(), function ($value) {
            if ($value === '4') {
                $this->crud->query = $this->crud->query->where('lead_type_id', $value)->orWhere('lead_type_id', null);
            } else {
                $this->crud->addClause('where', 'lead_type_id', $value);
            }