View file app/Controllers/Load/SearchController.php

<?php

declare(strict_types=1);

namespace App\Controllers\Load;

use App\Controllers\BaseController;
use App\Models\Down;
use App\Models\Load;
use Illuminate\Http\Request;

class SearchController extends BaseController
{
    /**
     * Поиск
     *
     * @param Request $request
     * @return string
     */
    public function index(Request $request): ?string
    {
        $cid     = int($request->input('cid'));
        $find    = check($request->input('find'));
        $type    = int($request->input('type'));
        $where   = int($request->input('where'));
        $section = int($request->input('section'));

        if (! $find) {
            $categories = Load::query()
                ->where('parent_id', 0)
                ->with('children')
                ->orderBy('sort')
                ->get();

            if ($categories->isEmpty()) {
                abort('default', __('loads.empty_loads'));
            }

            return view('loads/search', compact('categories', 'cid'));
        }

        $find = str_replace(['@', '+', '-', '*', '~', '<', '>', '(', ')', '"', "'"], '', $find);

        if (! isUtf($find)) {
            $find = winToUtf($find);
        }

        $strlen = utfStrlen($find);
        if ($strlen >= 3 && $strlen <= 50) {
            $findmewords = explode(' ', utfLower($find));

            $arrfind = [];
            foreach ($findmewords as $val) {
                if (utfStrlen($val) >= 3) {
                    $arrfind[] = empty($type) ? '+' . $val . '*' : $val . '*';
                }
            }

            $findme = implode(' ', $arrfind);

            if ($type === 2 && count($findmewords) > 1) {
                $findme = "\"$find\"";
            }

            $wheres = empty($where) ? 'title' : 'text';

            $loadfind = ($type . $wheres . $section . $find);

            // Поиск в названии
            if ($wheres === 'title') {
                if (empty($_SESSION['loadfindres']) || $loadfind !== $_SESSION['loadfind']) {
                    $searchsec = ($section > 0) ? 'category_id = ' . $section . ' AND' : '';

                    $result = Down::query()
                        ->select('id')
                        ->where('active', 1)
                        ->whereRaw($searchsec . ' MATCH (`title`) AGAINST (? IN BOOLEAN MODE)', [$findme])
                        ->limit(100)
                        ->pluck('id')
                        ->all();

                    $_SESSION['loadfind'] = $loadfind;
                    $_SESSION['loadfindres'] = $result;
                }

                $total = count($_SESSION['loadfindres']);

                if ($total > 0) {
                    $downs = Down::query()
                        ->whereIn('id', $_SESSION['loadfindres'])
                        ->orderByDesc('created_at')
                        ->with('user', 'category')
                        ->paginate(setting('downlist'))
                        ->appends([
                            'cid'     => $cid,
                            'find'    => $find,
                            'section' => $section,
                            'where'   => $where,
                            'type'    => $type,
                        ]);

                    return view('loads/search_title', compact('downs', 'find', 'type', 'where', 'section'));
                }

                setInput($request->all());
                setFlash('danger', __('main.empty_found'));
                redirect('/loads/search');
            }

            // Поиск в описании
            if ($wheres === 'text') {
                if (empty($_SESSION['loadfindres']) || $loadfind !== $_SESSION['loadfind']) {
                    $searchsec = ($section > 0) ? 'category_id = ' . $section . ' AND' : '';

                    $result = Down::query()
                        ->select('id')
                        ->where('active', 1)
                        ->whereRaw($searchsec . ' MATCH (`text`) AGAINST (? IN BOOLEAN MODE)', [$findme])
                        ->limit(100)
                        ->pluck('id')
                        ->all();

                    $_SESSION['loadfind'] = $loadfind;
                    $_SESSION['loadfindres'] = $result;
                }

                $total = count($_SESSION['loadfindres']);

                if ($total > 0) {
                    $downs = Down::query()
                        ->whereIn('id', $_SESSION['loadfindres'])
                        ->orderByDesc('created_at')
                        ->with('user', 'category')
                        ->paginate(setting('downlist'))
                        ->appends([
                            'cid'     => $cid,
                            'find'    => $find,
                            'section' => $section,
                            'where'   => $where,
                            'type'    => $type,
                        ]);

                    return view('loads/search_text', compact('downs', 'find', 'type', 'where', 'section'));
                }

                setInput($request->all());
                setFlash('danger', __('main.empty_found'));
                redirect('/loads/search');
            }

        } else {
            setInput($request->all());
            setFlash('danger', ['find' => __('main.request_requirements')]);
            redirect('/loads/search');
        }
    }
}