File: /var/www/ivs.kaunokolegija.lt/laravel/app/Http/Controllers/Admin/NatScienceProjectController.php
<?php
namespace App\Http\Controllers\Admin;
use Gate;
use App\Models\Scientist;
use Illuminate\Http\Request;
use App\Models\ResearcherGroup;
use App\Models\NatScienceProject;
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\StoreNatScienceProjectRequest;
use App\Http\Requests\UpdateNatScienceProjectRequest;
use App\Http\Requests\MassDestroyNatScienceProjectRequest;
class NatScienceProjectController extends Controller
{
use CsvImportTrait;
public function index(Request $request)
{
abort_if(Gate::denies('nat_science_project_access'), Response::HTTP_FORBIDDEN, '403 Forbidden');
if ($request->ajax()) {
$query = NatScienceProject::with(['scientists'])->select(sprintf('%s.*', (new NatScienceProject)->table));
$table = Datatables::of($query);
$table->addColumn('placeholder', ' ');
$table->addColumn('actions', ' ');
$table->editColumn('actions', function ($row) {
$viewGate = 'nat_science_project_show';
$editGate = 'nat_science_project_edit';
$deleteGate = 'nat_science_project_delete';
$crudRoutePart = 'nat-science-projects';
$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('leaded_participated', function ($row) {
return $row->leaded_participated ? NatScienceProject::LEADED_PARTICIPATED_SELECT[$row->leaded_participated] : '';
});
$table->editColumn('leader', function ($row) {
return $row->leader ? $row->leader : '';
});
$table->editColumn('title', function ($row) {
return $row->title ? $row->title : '';
});
$table->editColumn('number', function ($row) {
return $row->number ? $row->number : '';
});
$table->editColumn('budget', function ($row) {
return $row->budget ? $row->budget : '';
});
$table->rawColumns(['actions', 'placeholder', 'scientist']);
return $table->make(true);
}
$scientists = Scientist::pluck('name', 'id');
$groups = ResearcherGroup::pluck('title', 'id');
$subgroups = ResearcherSubGroup::pluck('title', 'id');
return view('admin.natScienceProjects.index', compact('scientists', 'groups', 'subgroups'));
}
public function create()
{
abort_if(Gate::denies('nat_science_project_create'), Response::HTTP_FORBIDDEN, '403 Forbidden');
$scientists = Scientist::pluck('name', 'id');
return view('admin.natScienceProjects.create', compact('scientists'));
}
public function store(StoreNatScienceProjectRequest $request)
{
$natScienceProject = NatScienceProject::create($request->all());
$natScienceProject->scientists()->sync($request->input('scientists', []));
if ($request->ajax()) {
return response()->json([
'success' => true,
'message' => __('global.create_success'),
'data' => $natScienceProject,
], 201);
}
return redirect()->route('admin.nat-science-projects.index');
}
public function edit(NatScienceProject $natScienceProject)
{
abort_if(Gate::denies('nat_science_project_edit'), Response::HTTP_FORBIDDEN, '403 Forbidden');
$scientists = Scientist::pluck('name', 'id');
$natScienceProject->load('scientists');
return view('admin.natScienceProjects.edit', compact('natScienceProject', 'scientists'));
}
public function update(UpdateNatScienceProjectRequest $request, NatScienceProject $natScienceProject)
{
$natScienceProject->update($request->all());
$natScienceProject->scientists()->sync($request->input('scientists', []));
if ($request->ajax()) {
return response()->json([
'success' => true,
'data' => $natScienceProject,
], 201);
}
return redirect()->route('admin.nat-science-projects.index');
}
public function destroy(NatScienceProject $natScienceProject)
{
abort_if(Gate::denies('nat_science_project_delete'), Response::HTTP_FORBIDDEN, '403 Forbidden');
$natScienceProject->delete();
return back();
}
public function massDestroy(MassDestroyNatScienceProjectRequest $request)
{
$natScienceProjects = NatScienceProject::find(request('ids'));
foreach ($natScienceProjects as $natScienceProject) {
$natScienceProject->delete();
}
return response(null, Response::HTTP_NO_CONTENT);
}
}