Просмотр файла app/Http/Controllers/User/SearchController.php

<?php
 
declare(strict_types=1);
 
namespace App\Http\Controllers\User;
 
use App\Http\Controllers\Controller;
use App\Models\User;
use Illuminate\Http\RedirectResponse;
use Illuminate\Http\Request;
use Illuminate\View\View;
 
class SearchController extends Controller
{
    /**
     * Main page
     *
     * @return View
     */
    public function index(): View
    {
        return view('users/search');
    }
 
    /**
     * User search
     *
     * @param Request $request
     *
     * @return View|RedirectResponse
     */
    public function search(Request $request)
    {
        $find   = $request->input('find');
        $strlen = utfStrlen($find);
 
        if ($strlen < 2 || $strlen > 20) {
            setInput($request->all());
            setFlash('danger', ['find' => __('users.request_requirements')]);
 
            return redirect('searchusers');
        }
 
        $users = User::query()
            ->where('login', 'like', '%' . $find . '%')
            ->orWhere('name', 'like', '%' . $find . '%')
            ->orderByDesc('point')
            ->paginate(setting('usersearch'))
            ->appends(compact('find'));
 
        return view('users/search_result', compact('users'));
    }
 
    /**
     * First letter search
     *
     * @param string $letter
     *
     * @return View
     */
    public function sort(string $letter): View
    {
        $search = is_numeric($letter) ? "RLIKE '^[-0-9]'" : "LIKE '$letter%'";
 
        $users = User::query()
            ->whereRaw('login ' . $search)
            ->orderByDesc('point')
            ->paginate(setting('usersearch'));
 
        return view('users/search_result', compact('users'));
    }
}