HEX
Server: Apache
System: Linux WWW 6.1.0-40-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.153-1 (2025-09-20) x86_64
User: web11 (1011)
PHP: 8.2.29
Disabled: NONE
Upload Files
File: /var/www/ivs.kaunokolegija.lt/laravel/app/Http/Controllers/Admin/SciencePublicationController.php
<?php

namespace App\Http\Controllers\Admin;

use Gate;
use App\Models\Publisher;
use App\Models\Scientist;
use App\Models\ScienceArea;
use Illuminate\Http\Request;
use App\Models\ResearcherGroup;
use App\Models\ScienceDirection;
use App\Models\ResearcherSubGroup;
use App\Models\SciencePublication;
use App\Http\Controllers\Controller;
use Yajra\DataTables\Facades\DataTables;
use Symfony\Component\HttpFoundation\Response;
use App\Http\Controllers\Traits\CsvImportTrait;
use App\Http\Requests\StoreSciencePublicationRequest;
use App\Http\Requests\UpdateSciencePublicationRequest;
use App\Http\Requests\MassDestroySciencePublicationRequest;

class SciencePublicationController extends Controller
{
    use CsvImportTrait;

    public function index(Request $request)
    {
        abort_if(Gate::denies('science_publication_access'), Response::HTTP_FORBIDDEN, '403 Forbidden');

        if ($request->ajax()) {
            $query = SciencePublication::with(['scientists', 'science_areas', 'science_directions', 'publisher'])->select(sprintf('%s.*', (new SciencePublication)->table));
            $table = Datatables::of($query);

            $table->addColumn('placeholder', '&nbsp;');
            $table->addColumn('actions', '&nbsp;');

            $table->editColumn('actions', function ($row) {
                $viewGate      = 'science_publication_show';
                $editGate      = 'science_publication_edit';
                $deleteGate    = 'science_publication_delete';
                $crudRoutePart = 'science-publications';
                $modal         = true;
                $rowData       = $row;

                return view('partials.datatablesActions', compact(
                    'viewGate',
                    'editGate',
                    'deleteGate',
                    'crudRoutePart',
                    'row',
                    'modal',
                    'rowData'
                ));
            });

            $table->editColumn('id', function ($row) {
                return $row->id ? $row->id : '';
            });
            $table->editColumn('scientist', function ($row) {
                $labels = [];
                foreach ($row->scientists as $scientist) {
                    $labels[] = sprintf('<span class="label label-info label-many">%s</span>', $scientist->name);
                }

                return implode(' ', $labels);
            });

            $table->editColumn('science_area', function ($row) {
                $labels = [];
                foreach ($row->science_areas as $science_area) {
                    $labels[] = sprintf('<span class="label label-info label-many">%s</span>', $science_area->name);
                }

                return implode(' ', $labels);
            });
            $table->editColumn('science_direction', function ($row) {
                $labels = [];
                foreach ($row->science_directions as $science_direction) {
                    $labels[] = sprintf('<span class="label label-info label-many">%s</span>', $science_direction->name);
                }

                return implode(' ', $labels);
            });
            $table->editColumn('title', function ($row) {
                return $row->title ? $row->title : '';
            });
            $table->editColumn('citation', function ($row) {
                return $row->citation ? $row->citation : '';
            });
            $table->editColumn('input_time', function ($row) {
                return $row->input_time ? $row->input_time : '';
            });
            $table->editColumn('authorship_field', function ($row) {
                return $row->authorship_field ? $row->authorship_field : '';
            });
            $table->editColumn('page_count', function ($row) {
                return $row->page_count ? $row->page_count : '';
            });
            $table->addColumn('publisher_name', function ($row) {
                return $row->publisher ? $row->publisher->name : '';
            });

            $table->editColumn('publishment', function ($row) {
                return $row->publishment ? $row->publishment : '';
            });
            $table->editColumn('isbn', function ($row) {
                return $row->isbn ? $row->isbn : '';
            });
            $table->editColumn('doi', function ($row) {
                return $row->doi ? $row->doi : '';
            });

            $table->rawColumns(['actions', 'placeholder', 'scientist', 'science_area', 'science_direction', 'publisher']);

            return $table->make(true);
        }

        $scientists         = Scientist::get();
        $science_areas      = ScienceArea::get();
        $science_directions = ScienceDirection::get();
        $publishers         = Publisher::get();
        $groups = ResearcherGroup::pluck('title', 'id');
        $subgroups = ResearcherSubGroup::pluck('title', 'id');

        return view('admin.sciencePublications.index', compact('scientists', 'science_areas', 'science_directions', 'publishers', 'groups', 'subgroups'));
    }

    public function create()
    {
        abort_if(Gate::denies('science_publication_create'), Response::HTTP_FORBIDDEN, '403 Forbidden');

        $scientists = Scientist::pluck('name', 'id');

        $science_areas = ScienceArea::pluck('name', 'id');

        $science_directions = ScienceDirection::pluck('name', 'id');

        $publishers = Publisher::pluck('name', 'id')->prepend(trans('global.pleaseSelect'), '');

        return view('admin.sciencePublications.create', compact('publishers', 'science_areas', 'science_directions', 'scientists'));
    }

    public function store(StoreSciencePublicationRequest $request)
    {
        $sciencePublication = SciencePublication::create($request->all());
        $sciencePublication->scientists()->sync($request->input('scientists', []));
        $sciencePublication->science_areas()->sync($request->input('science_areas', []));
        $sciencePublication->science_directions()->sync($request->input('science_directions', []));

        if ($request->ajax()) {
            return response()->json([
                'success' => true,
                'message' => __('global.create_success'),
                'data' => $sciencePublication,
            ], 201);
        }

        return redirect()->route('admin.science-publications.index');
    }

    public function edit(SciencePublication $sciencePublication)
    {
        abort_if(Gate::denies('science_publication_edit'), Response::HTTP_FORBIDDEN, '403 Forbidden');

        $scientists = Scientist::pluck('name', 'id');

        $science_areas = ScienceArea::pluck('name', 'id');

        $science_directions = ScienceDirection::pluck('name', 'id');

        $publishers = Publisher::pluck('name', 'id')->prepend(trans('global.pleaseSelect'), '');

        $sciencePublication->load('scientists', 'science_areas', 'science_directions', 'publisher');

        return view('admin.sciencePublications.edit', compact('publishers', 'sciencePublication', 'science_areas', 'science_directions', 'scientists'));
    }

    public function update(UpdateSciencePublicationRequest $request, SciencePublication $sciencePublication)
    {
        $sciencePublication->update($request->all());
        $sciencePublication->scientists()->sync($request->input('scientists', []));
        $sciencePublication->science_areas()->sync($request->input('science_areas', []));
        $sciencePublication->science_directions()->sync($request->input('science_directions', []));

        if ($request->ajax()) {
            return response()->json([
                'success' => true,
                'data' => $sciencePublication,
            ], 201);
        }

        return redirect()->route('admin.science-publications.index');
    }

    public function destroy(SciencePublication $sciencePublication)
    {
        abort_if(Gate::denies('science_publication_delete'), Response::HTTP_FORBIDDEN, '403 Forbidden');

        $sciencePublication->delete();

        return back();
    }

    public function massDestroy(MassDestroySciencePublicationRequest $request)
    {
        $sciencePublications = SciencePublication::find(request('ids'));

        foreach ($sciencePublications as $sciencePublication) {
            $sciencePublication->delete();
        }

        return response(null, Response::HTTP_NO_CONTENT);
    }
}