File: /var/www/ivs.kaunokolegija.lt/laravel/app/Http/Controllers/Admin/ConferenceAbstractController.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\ConferenceAbstract;
use App\Models\ResearcherSubGroup;
use App\Http\Controllers\Controller;
use App\Models\ScientificConferenceType;
use Yajra\DataTables\Facades\DataTables;
use Symfony\Component\HttpFoundation\Response;
use App\Http\Controllers\Traits\CsvImportTrait;
use App\Http\Requests\StoreConferenceAbstractRequest;
use App\Http\Requests\UpdateConferenceAbstractRequest;
use App\Http\Requests\MassDestroyConferenceAbstractRequest;
class ConferenceAbstractController extends Controller
{
use CsvImportTrait;
public function index(Request $request)
{
abort_if(Gate::denies('conference_abstract_access'), Response::HTTP_FORBIDDEN, '403 Forbidden');
if ($request->ajax()) {
$query = ConferenceAbstract::with(['scientists', 'science_areas', 'science_directions', 'natures', 'publisher'])->select(sprintf('%s.*', (new ConferenceAbstract)->table));
$table = Datatables::of($query);
$table->addColumn('placeholder', ' ');
$table->addColumn('actions', ' ');
$table->editColumn('actions', function ($row) {
$viewGate = 'conference_abstract_show';
$editGate = 'conference_abstract_edit';
$deleteGate = 'conference_abstract_delete';
$crudRoutePart = 'conference-abstracts';
$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('nature', function ($row) {
$labels = [];
foreach ($row->natures as $nature) {
$labels[] = sprintf('<span class="label label-info label-many">%s</span>', $nature->name);
}
return implode(' ', $labels);
});
$table->editColumn('title', function ($row) {
return $row->title ? $row->title : '';
});
$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('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', 'nature', 'publisher']);
return $table->make(true);
}
$scientists = Scientist::get();
$science_areas = ScienceArea::get();
$science_directions = ScienceDirection::get();
$scientific_conference_types = ScientificConferenceType::get();
$publishers = Publisher::get();
$groups = ResearcherGroup::pluck('title', 'id');
$subgroups = ResearcherSubGroup::pluck('title', 'id');
$natures = ScientificConferenceType::pluck('name', 'id');
return view('admin.conferenceAbstracts.index', compact('scientists', 'science_areas', 'science_directions', 'scientific_conference_types', 'publishers', 'groups', 'subgroups', 'natures'));
}
public function create()
{
abort_if(Gate::denies('conference_abstract_create'), Response::HTTP_FORBIDDEN, '403 Forbidden');
$scientists = Scientist::pluck('name', 'id');
$science_areas = ScienceArea::pluck('name', 'id');
$science_directions = ScienceDirection::pluck('name', 'id');
$natures = ScientificConferenceType::pluck('name', 'id');
$publishers = Publisher::pluck('name', 'id')->prepend(trans('global.pleaseSelect'), '');
return view('admin.conferenceAbstracts.create', compact('natures', 'publishers', 'science_areas', 'science_directions', 'scientists'));
}
public function store(StoreConferenceAbstractRequest $request)
{
$conferenceAbstract = ConferenceAbstract::create($request->all());
$conferenceAbstract->scientists()->sync($request->input('scientists', []));
$conferenceAbstract->science_areas()->sync($request->input('science_areas', []));
$conferenceAbstract->science_directions()->sync($request->input('science_directions', []));
$conferenceAbstract->natures()->sync($request->input('natures', []));
if ($request->ajax()) {
return response()->json([
'success' => true,
'message' => __('global.create_success'),
'data' => $conferenceAbstract,
], 201);
}
return redirect()->route('admin.conference-abstracts.index');
}
public function edit(ConferenceAbstract $conferenceAbstract)
{
abort_if(Gate::denies('conference_abstract_edit'), Response::HTTP_FORBIDDEN, '403 Forbidden');
$scientists = Scientist::pluck('name', 'id');
$science_areas = ScienceArea::pluck('name', 'id');
$science_directions = ScienceDirection::pluck('name', 'id');
$natures = ScientificConferenceType::pluck('name', 'id');
$publishers = Publisher::pluck('name', 'id')->prepend(trans('global.pleaseSelect'), '');
$conferenceAbstract->load('scientists', 'science_areas', 'science_directions', 'natures', 'publisher');
return view('admin.conferenceAbstracts.edit', compact('conferenceAbstract', 'natures', 'publishers', 'science_areas', 'science_directions', 'scientists'));
}
public function update(UpdateConferenceAbstractRequest $request, ConferenceAbstract $conferenceAbstract)
{
$conferenceAbstract->update($request->all());
$conferenceAbstract->scientists()->sync($request->input('scientists', []));
$conferenceAbstract->science_areas()->sync($request->input('science_areas', []));
$conferenceAbstract->science_directions()->sync($request->input('science_directions', []));
$conferenceAbstract->natures()->sync($request->input('natures', []));
if ($request->ajax()) {
return response()->json([
'success' => true,
'data' => $conferenceAbstract,
], 201);
}
return redirect()->route('admin.conference-abstracts.index');
}
public function destroy(ConferenceAbstract $conferenceAbstract)
{
abort_if(Gate::denies('conference_abstract_delete'), Response::HTTP_FORBIDDEN, '403 Forbidden');
$conferenceAbstract->delete();
return back();
}
public function massDestroy(MassDestroyConferenceAbstractRequest $request)
{
$conferenceAbstracts = ConferenceAbstract::find(request('ids'));
foreach ($conferenceAbstracts as $conferenceAbstract) {
$conferenceAbstract->delete();
}
return response(null, Response::HTTP_NO_CONTENT);
}
}