File: /var/www/ivs.kaunokolegija.lt/laravel/app/Http/Controllers/Admin/ScientificReviewController.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\ScientificReview;
use App\Models\ResearcherSubGroup;
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\StoreScientificReviewRequest;
use App\Http\Requests\UpdateScientificReviewRequest;
use App\Http\Requests\MassDestroyScientificReviewRequest;
class ScientificReviewController extends Controller
{
use CsvImportTrait;
public function index(Request $request)
{
abort_if(Gate::denies('scientific_review_access'), Response::HTTP_FORBIDDEN, '403 Forbidden');
if ($request->ajax()) {
$query = ScientificReview::with(['scientists', 'science_areas', 'science_directions', 'publisher'])->select(sprintf('%s.*', (new ScientificReview)->table));
$table = Datatables::of($query);
$table->addColumn('placeholder', ' ');
$table->addColumn('actions', ' ');
$table->editColumn('actions', function ($row) {
$viewGate = 'scientific_review_show';
$editGate = 'scientific_review_edit';
$deleteGate = 'scientific_review_delete';
$crudRoutePart = 'scientific-reviews';
$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('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', '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.scientificReviews.index', compact('scientists', 'science_areas', 'science_directions', 'publishers', 'groups', 'subgroups'));
}
public function create()
{
abort_if(Gate::denies('scientific_review_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.scientificReviews.create', compact('publishers', 'science_areas', 'science_directions', 'scientists'));
}
public function store(StoreScientificReviewRequest $request)
{
$scientificReview = ScientificReview::create($request->all());
$scientificReview->scientists()->sync($request->input('scientists', []));
$scientificReview->science_areas()->sync($request->input('science_areas', []));
$scientificReview->science_directions()->sync($request->input('science_directions', []));
if ($request->ajax()) {
return response()->json([
'success' => true,
'message' => __('global.create_success'),
'data' => $scientificReview,
], 201);
}
return redirect()->route('admin.scientific-reviews.index');
}
public function edit(ScientificReview $scientificReview)
{
abort_if(Gate::denies('scientific_review_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'), '');
$scientificReview->load('scientists', 'science_areas', 'science_directions', 'publisher');
return view('admin.scientificReviews.edit', compact('publishers', 'science_areas', 'science_directions', 'scientificReview', 'scientists'));
}
public function update(UpdateScientificReviewRequest $request, ScientificReview $scientificReview)
{
$scientificReview->update($request->all());
$scientificReview->scientists()->sync($request->input('scientists', []));
$scientificReview->science_areas()->sync($request->input('science_areas', []));
$scientificReview->science_directions()->sync($request->input('science_directions', []));
if ($request->ajax()) {
return response()->json([
'success' => true,
'data' => $scientificReview,
], 201);
}
return redirect()->route('admin.scientific-reviews.index');
}
public function destroy(ScientificReview $scientificReview)
{
abort_if(Gate::denies('scientific_review_delete'), Response::HTTP_FORBIDDEN, '403 Forbidden');
$scientificReview->delete();
return back();
}
public function massDestroy(MassDestroyScientificReviewRequest $request)
{
$scientificReviews = ScientificReview::find(request('ids'));
foreach ($scientificReviews as $scientificReview) {
$scientificReview->delete();
}
return response(null, Response::HTTP_NO_CONTENT);
}
}