ldc-com-app-bo/app/Http/Controllers/Bo/AppUserController.php

<?php

namespace App\Http\Controllers\Bo;

use App\Http\Controllers\Controller;
use App\Http\Requests\Bo\AppUser\StoreAppUserRequest;
use App\Http\Requests\Bo\AppUser\UpdateAppUserRequest;
use App\Http\Requests\Bo\ImportRequest;
use App\Imports\AppUserImport;
use App\Models\AppUser;
use App\Models\Directory;
use App\Traits\Controllers\ChangesModelOrder;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Str;
use Maatwebsite\Excel\Facades\Excel;

class AppUserController extends Controller
{
    use ChangesModelOrder;

    /**
     * Display a listing of the resource.
     *
     * @param \Illuminate\Http\Request $request
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request)
    {
        /** @var \Illuminate\Database\Eloquent\Builder $query */
        $query = AppUser::query();

        /** @var string $search Search field */
        if ($request->search) {
            $this->searchQuery(
                $query,
                $request->search,
                null,
                'lastname',
                'firstname',
                'email'
            );
        }
        $searchFields = trans('Nom, Prénom, Email');

        /** Sort columns with a query */
        $this->sortQuery($query);

        $app_users = $this->paginate($query);

        return view('bo.pages.app-users.index', compact('app_users', 'searchFields'));
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        $directories = Directory::renderDirectories(Directory::where('needAuthorization', 1)
            ->orderBy('name', 'ASC')->get());

        return view('bo.pages.app-users.create', compact('directories'));
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \App\Http\Requests\Bo\AppUser\StoreAppUserRequest $request
     * @return \Illuminate\Http\Response
     */
    public function store(StoreAppUserRequest $request)
    {
        return DB::transaction(function () use ($request) {
            $app_user = new AppUser();
            $app_user->fill($request->validated());

            if ($app_user->saveOrFail()) {
                $app_user->directories()->sync(collect($request->directories)->pluck('id'));
                return redirect()
                    ->route('bo.app-users.edit', $app_user)
                    ->with('success', trans(
                        ':model a été créé',
                        ['model' => Str::singular(trans('models.classes.app_users'))]
                    ));
            }

            return redirect()
                ->back()
                ->with('error', trans(
                    ':model n\'a pas été créé',
                    ['model' => Str::singular(trans('models.classes.app_users'))]
                ));
        });
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param \App\Models\AppUser $app_user
     * @return \Illuminate\Http\Response
     */
    public function edit(AppUser $app_user)
    {
        $directories           = Directory::renderDirectories(Directory::query()->where('needAuthorization', 1)
            ->orderBy('name', 'ASC')->get());
        $app_user->directories = Directory::renderDirectories($app_user->directories);

        return view('bo.pages.app-users.edit', [
            'app_userModel' => $app_user,
            'directories' => $directories
        ]);
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \App\Http\Requests\Bo\AppUser\UpdateAppUserRequest $request
     * @param  \App\Models\AppUser                                $app_user
     * @return \Illuminate\Http\Response
     */
    public function update(UpdateAppUserRequest $request, AppUser $app_user)
    {
        $app_user->directories()->sync(collect($request->directories)->pluck('id'));
        $params = $request->validated();
        if (\is_null($params['password'])) {
            unset($params['password']);
        }
        return DB::transaction(function () use ($params, $app_user) {
            $app_user->fill($params);

            if ($app_user->saveOrFail()) {
                return redirect()
                    ->route('bo.app-users.edit', $app_user)
                    ->with('success', trans(
                        ':model a été mis à jour',
                        ['model' => Str::singular(trans('models.classes.app_users'))]
                    ));
            }
            return redirect()
                ->back()
                ->with('error', trans(
                    ':model n\'a pas été mis à jour',
                    ['model' => Str::singular(trans('models.classes.app_users'))]
                ));
        });
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  \App\Models\AppUser $app_user
     * @return \Illuminate\Http\Response
     */
    public function destroy(AppUser $app_user)
    {
        if ($app_user->deleteOrFail()) {
            return redirect()
                ->route('bo.app-users.index')
                ->with('warning', trans(
                    ':model a bien été supprimé',
                    ['model' => Str::singular(trans('models.classes.app_users'))]
                ));
        }

        return redirect()
            ->back()
            ->with('error', trans(
                ':model n\'a pas été supprimé',
                ['model' => Str::singular(trans('models.classes.app_users'))]
            ));
    }

    /**
     * Mass import by CSV.
     * matricule;lastname;firstname;email
     * default role = user
     *
     * @param \App\Http\Requests\Bo\ImportRequest $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function import(ImportRequest $request)
    {
        Excel::import(new AppUserImport(), $request->import, null, \Maatwebsite\Excel\Excel::CSV);

        return redirect()->route('bo.app-users.index')->with('success', 'Import terminé.');
    }
}