strprfcrm/app/Http/Controllers/ResponsibleController.php

<?php

namespace App\Http\Controllers;

use App\Http\Requests\StoreResponsibleRequest;
use App\Models\Dictionary\Area;
use App\Models\Responsible;
use App\Models\ResponsibleView;
use Illuminate\Http\RedirectResponse;
use Illuminate\Http\Request;

class ResponsibleController extends Controller
{

    protected array $data = [
        'active'    => 'responsibles',
        'title'     => 'Ответственные',
        'id'        => 'responsibles',
        'header'    => [
            'id'            => 'ID',
            'area_name'     => 'Район',
            'name'          => 'ФИО',
            'phone'         => 'Телефон',
            'post'          => 'Должность',
            'created_at'    => 'Дата создания'
        ],
        'searchFields' => [
            'name',
            'phone',
            'post',
        ],
        'ranges' => [],
        'filters' => [],
    ];
    public function __construct()
    {
        $areas = Area::query()
            ->orderBy('name')
            ->get(['id', 'name']);

        $this->data['areas'] = ['' => '-'] + $areas
            ->pluck('name', 'id')
            ->toArray();
        $this->data['areasForSearch'] = $areas
            ->map(fn (Area $area) => ['id' => (string) $area->id, 'name' => $area->name])
            ->values()
            ->toArray();
    }


    public function index(Request $request)
    {
        session(['gp_responsibles' => $request->query()]);

        $model = new ResponsibleView;
        $this->createFilters($model, 'area_name');
        $this->createDateFilters($model, 'created_at');

        $q = $model::query();
        $this->acceptFilters($q, $request);
        $this->acceptSearch($q, $request);
        $this->setSortAndOrderBy($model, $request);

        $this->applyStableSorting($q);
        $this->data['responsibles'] = $q->paginate($this->data['per_page'])->withQueryString();

        return view('responsibles.index', $this->data);
    }

    /**
     * @param StoreResponsibleRequest $request
     * @return RedirectResponse
     */
    public function store(StoreResponsibleRequest $request)
    {
        $responsible = Responsible::query()->create($request->validated());
        Area::query()->where('areas.responsible_id', $responsible->id)->update(['responsible_id' => null]);
        Area::query()->where('id', $request->validated('area_id'))->update(['responsible_id' => $responsible->id]);
        return redirect()->route('responsible.index');
    }

    /**
     * @param Responsible $responsible
     * @return \Illuminate\Contracts\View\Factory|\Illuminate\Contracts\View\View|\Illuminate\Foundation\Application|\Illuminate\View\View
     */
    public function show(Responsible $responsible)
    {
        $this->data['responsible'] = $responsible;
        return view('responsibles.edit', $this->data);
    }

    /**
     * @param StoreResponsibleRequest $request
     * @param Responsible $responsible
     * @return RedirectResponse
     */
    public function update(StoreResponsibleRequest $request, Responsible $responsible)
    {
        $responsible->update($request->validated());
        Area::query()->where('areas.responsible_id', $responsible->id)->update(['responsible_id' => null]);
        Area::query()->where('id', $request->validated('area_id'))->update(['responsible_id' => $responsible->id]);
        return redirect()->route('responsible.index');
    }

    /**
     * @param Responsible $responsible
     * @return RedirectResponse
     */
    public function destroy(Responsible $responsible)
    {
        $responsible->delete();
        return redirect()->route('responsible.index');
    }
}