<?php

namespace App\Http\Controllers\Admin;

use Gate;
use App\Models\Scientist;
use App\Models\InstProject;
use App\Models\ProjectType;
use Illuminate\Http\Request;
use App\Models\ResearcherGroup;
use App\Models\ResearcherSubGroup;
use App\Http\Controllers\Controller;
use Yajra\DataTables\Facades\DataTables;
use App\Http\Requests\StoreInstProjectRequest;
use Symfony\Component\HttpFoundation\Response;
use App\Http\Controllers\Traits\CsvImportTrait;
use App\Http\Requests\UpdateInstProjectRequest;
use App\Http\Requests\MassDestroyInstProjectRequest;

class InstProjectController extends Controller
{
    use CsvImportTrait;

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

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

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

            $table->editColumn('actions', function ($row) {
                $viewGate      = 'inst_project_show';
                $editGate      = 'inst_project_edit';
                $deleteGate    = 'inst_project_delete';
                $crudRoutePart = 'inst-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->addColumn('project_type_name', function ($row) {
                return $row->project_type ? $row->project_type->name : '';
            });

            $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 ? InstProject::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', 'project_type', 'scientist']);

            return $table->make(true);
        }

        $project_types = ProjectType::get();
        $scientists    = Scientist::get();
        $groups = ResearcherGroup::pluck('title', 'id');
        $subgroups = ResearcherSubGroup::pluck('title', 'id');

        return view('admin.instProjects.index', compact('project_types', 'scientists', 'groups', 'subgroups'));
    }

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

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

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

        return view('admin.instProjects.create', compact('project_types', 'scientists'));
    }

    public function store(StoreInstProjectRequest $request)
    {
        $instProject = InstProject::create($request->all());
        $instProject->scientists()->sync($request->input('scientists', []));

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

        return redirect()->route('admin.inst-projects.index');
    }

    public function edit(InstProject $instProject)
    {
        abort_if(Gate::denies('inst_project_edit'), Response::HTTP_FORBIDDEN, '403 Forbidden');

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

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

        $instProject->load('project_type', 'scientists');

        return view('admin.instProjects.edit', compact('instProject', 'project_types', 'scientists'));
    }

    public function update(UpdateInstProjectRequest $request, InstProject $instProject)
    {
        $instProject->update($request->all());
        $instProject->scientists()->sync($request->input('scientists', []));

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

        return redirect()->route('admin.inst-projects.index');
    }

    public function destroy(InstProject $instProject)
    {
        abort_if(Gate::denies('inst_project_delete'), Response::HTTP_FORBIDDEN, '403 Forbidden');

        $instProject->delete();

        return back();
    }

    public function massDestroy(MassDestroyInstProjectRequest $request)
    {
        $instProjects = InstProject::find(request('ids'));

        foreach ($instProjects as $instProject) {
            $instProject->delete();
        }

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