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

Complexity

Conditions	9
Paths	2

Size

Total Lines	130
Code Lines	97

Duplication

Lines	0
Ratio	0 %

Importance

Changes	4
Bugs	0	Features	2

<?php
    public function setupListOperation()
    {
        // Required for order logic.
        $locale = 'en';
        if (null !== $this->request->input('locale')) {
            $locale = $this->request->input('locale');
        }
        App::setLocale($locale);

        // Add the custom blade buttons found in resources/views/vendor/backpack/crud/buttons/.
        $this->crud->addButtonFromView('line', 'job_admin_edit', 'job_admin_edit', 'end');
        $this->crud->addButtonFromView('line', 'spb_link', 'spb_link', 'end');
        $this->crud->addButtonFromView('line', 'jpb_link', 'jpb_link', 'end');
        $this->crud->addButtonFromView('line', 'job_poster_link', 'job_poster_link', 'end');
        $this->crud->addButtonFromView('line', 'applicants_download', 'applicants_download', 'end');

        $this->crud->addColumn([
            'name' => 'id',
            'type' => 'number',
            'label' => 'ID'
        ]);
        $this->crud->addColumn([
            'name' => 'title',
            'type' => 'text',
            'label' => 'Title',
            'searchLogic' => function ($query, $column, $searchTerm) use ($locale): void {
                $query->orWhere('title->' . $locale, 'ilike', "%$searchTerm%");
            },
            'orderLogic' => function ($query, $column, $columnDirection) use ($locale) {
                return $query->orderBy('title->' . $locale, $columnDirection)->select('*');
            }
        ]);
        $this->crud->addColumn([
            'name' => 'job_poster_status.key',
            'label' => 'Status',
            'type' => 'text',
            'orderable' => true,
            'orderLogic' => function ($query, $column, $columnDirection) {
                return $query->leftJoin('job_poster_status', 'job_poster_status.id', '=', 'job_posters.job_poster_status_id')
                    ->orderBy('job_poster_status.key', $columnDirection)->select('job_posters.*');
            }
        ]);
        $this->crud->addColumn([
            'name' => 'isOpen',
            'label' => 'Open',
            'type' => 'closure',
            'orderable' => false,
            'function' => function ($entry) {
                return $entry->isOpen() ?
                    '<span><i class="fa fa-check-circle"></i></span>' :
                    '<span><i class="fa fa-circle"></i></span>';
            }
        ]);
        $this->crud->addColumn([
            'name' => 'isClosed',
            'label' => 'Closed',
            'type' => 'closure',
            'orderable' => false,
            'function' => function ($entry) {
                return $entry->isClosed() ?
                    '<span><i class="fa fa-check-circle"></i></span>' :
                    '<span><i class="fa fa-circle"></i></span>';
            }
        ]);

        $this->crud->addColumn([
            'name' => 'internal_only',
            'label' => 'Internal Only',
            'type' => 'check',
        ]);

        $this->crud->addColumn([
            'name' => 'manager_user_name',
            'type' => 'closure',
            'label' => 'Manager',
            'orderable' => false,
            'function' => function ($entry) {
                return '<a href="' . route('manager.profile.edit', $entry->manager->id) . '" target="_blank">' . $entry->manager->user->full_name . '</a>';

The function route was not found. Maybe you did not declare it correctly or list all dependencies?

            }
        ]);
        $this->crud->addColumn([
            'name' => 'department.name',
            'label' => 'Department',
            'type' => 'text'
        ]);
        $this->crud->addColumn([
            'name' => 'submitted_applications_count',
            'label' => 'Applications',
            'type' => 'closure',
            'function' =>
            function ($entry) {
                return $entry->submitted_applications_count() > 0 ?
                    '<a target="_blank" href="' . route('manager.jobs.applications', $entry->id) . '">' . $entry->submitted_applications_count() . ' (View <i class="fa fa-external-link"></i>)</a>' :

The function route was not found. Maybe you did not declare it correctly or list all dependencies?

                    $entry->submitted_applications_count();
            }
        ]);

        // Filters.
        $this->crud->addFilter([
            'name' => 'departments',
            'type' => 'select2_multiple',
            'label' => 'Filter by department'
        ], function () {
            return Department::all()->pluck('name', 'id')->toArray();
        }, function ($values) {
            $this->crud->addClause('WhereHas', 'department', function ($query) use ($values) {
                foreach (json_decode($values) as $key => $value) {
                    if ($key === 0) {
                        $query->where('id', $value);
                    } else {
                        $query->orWhere('id', $value);
                    }
                }
            });
        });

        $this->crud->addFilter([
            'name' => 'statuses',
            'type' => 'select2_multiple',
            'label' => 'Filter by status'
        ], function () {
            // Using key because some of the job status names are the same.
            return JobPosterStatus::all()->pluck('key', 'id')->toArray();
        }, function ($values) {
            $this->crud->addClause('WhereHas', 'job_poster_status', function ($query) use ($values) {
                foreach (json_decode($values) as $key => $value) {
                    if ($key === 0) {
                        $query->where('id', $value);
                    } else {
                        $query->orWhere('id', $value);
                    }