File: /var/www/ivs.kaunokolegija.lt/laravel/app/Http/Controllers/Admin/ArtWorkController.php
<?php
namespace App\Http\Controllers\Admin;
use Gate;
use App\Models\ArtWork;
use App\Models\Scientist;
use App\Models\ArtWorkType;
use App\Models\ScienceArea;
use Illuminate\Http\Request;
use App\Models\ResearcherGroup;
use App\Models\ScienceDirection;
use App\Models\ResearcherSubGroup;
use App\Http\Controllers\Controller;
use Yajra\DataTables\Facades\DataTables;
use App\Http\Requests\StoreArtWorkRequest;
use App\Http\Requests\UpdateArtWorkRequest;
use Symfony\Component\HttpFoundation\Response;
use App\Http\Controllers\Traits\CsvImportTrait;
use App\Http\Requests\MassDestroyArtWorkRequest;
class ArtWorkController extends Controller
{
use CsvImportTrait;
public function index(Request $request)
{
abort_if(Gate::denies('art_work_access'), Response::HTTP_FORBIDDEN, '403 Forbidden');
if ($request->ajax()) {
$query = ArtWork::with(['scientists', 'science_areas', 'science_directions', 'tags'])->select(sprintf('%s.*', (new ArtWork)->table));
$table = Datatables::of($query);
$table->addColumn('placeholder', ' ');
$table->addColumn('actions', ' ');
$table->editColumn('actions', function ($row) {
$viewGate = 'art_work_show';
$editGate = 'art_work_edit';
$deleteGate = 'art_work_delete';
$crudRoutePart = 'art-works';
$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('tag', function ($row) {
$labels = [];
foreach ($row->tags as $tag) {
$labels[] = sprintf('<span class="label label-info label-many">%s</span>', $tag->name);
}
return implode(' ', $labels);
});
$table->editColumn('title', function ($row) {
return $row->title ? $row->title : '';
});
$table->editColumn('number', function ($row) {
return $row->number ? $row->number : '';
});
$table->editColumn('input', function ($row) {
return $row->input ? $row->input : '';
});
$table->rawColumns(['actions', 'placeholder', 'scientist', 'science_area', 'science_direction', 'tag']);
return $table->make(true);
}
$scientists = Scientist::get();
$science_areas = ScienceArea::get();
$science_directions = ScienceDirection::get();
$art_work_types = ArtWorkType::get();
$groups = ResearcherGroup::pluck('title', 'id');
$subgroups = ResearcherSubGroup::pluck('title', 'id');
$tags = ArtWorkType::pluck('name', 'id');
return view('admin.artWorks.index', compact('scientists', 'science_areas', 'science_directions', 'art_work_types', 'groups', 'subgroups', 'tags'));
}
public function create()
{
abort_if(Gate::denies('art_work_create'), Response::HTTP_FORBIDDEN, '403 Forbidden');
$scientists = Scientist::pluck('name', 'id');
$science_areas = ScienceArea::pluck('name', 'id');
$science_directions = ScienceDirection::pluck('name', 'id');
$tags = ArtWorkType::pluck('name', 'id');
return view('admin.artWorks.create', compact('science_areas', 'science_directions', 'scientists', 'tags'));
}
public function store(StoreArtWorkRequest $request)
{
$artWork = ArtWork::create($request->all());
$artWork->scientists()->sync($request->input('scientists', []));
$artWork->science_areas()->sync($request->input('science_areas', []));
$artWork->science_directions()->sync($request->input('science_directions', []));
$artWork->tags()->sync($request->input('tags', []));
if ($request->ajax()) {
return response()->json([
'success' => true,
'message' => __('global.create_success'),
'data' => $artWork,
], 201);
}
return redirect()->route('admin.art-works.index');
}
public function edit(ArtWork $artWork)
{
abort_if(Gate::denies('art_work_edit'), Response::HTTP_FORBIDDEN, '403 Forbidden');
$scientists = Scientist::pluck('name', 'id');
$science_areas = ScienceArea::pluck('name', 'id');
$science_directions = ScienceDirection::pluck('name', 'id');
$tags = ArtWorkType::pluck('name', 'id');
$artWork->load('scientists', 'science_areas', 'science_directions', 'tags');
return view('admin.artWorks.edit', compact('artWork', 'science_areas', 'science_directions', 'scientists', 'tags'));
}
public function update(UpdateArtWorkRequest $request, ArtWork $artWork)
{
$artWork->update($request->all());
$artWork->scientists()->sync($request->input('scientists', []));
$artWork->science_areas()->sync($request->input('science_areas', []));
$artWork->science_directions()->sync($request->input('science_directions', []));
$artWork->tags()->sync($request->input('tags', []));
if ($request->ajax()) {
return response()->json([
'success' => true,
'data' => $artWork,
], 201);
}
return redirect()->route('admin.art-works.index');
}
public function destroy(ArtWork $artWork)
{
abort_if(Gate::denies('art_work_delete'), Response::HTTP_FORBIDDEN, '403 Forbidden');
$artWork->delete();
return back();
}
public function massDestroy(MassDestroyArtWorkRequest $request)
{
$artWorks = ArtWork::find(request('ids'));
foreach ($artWorks as $artWork) {
$artWork->delete();
}
return response(null, Response::HTTP_NO_CONTENT);
}
}