
<?php

namespace App\Http\Controllers\Web;

use App\Http\Controllers\Controller;
use App\Models\Useful;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use \JordanMiguel\LaravelPopular\Traits\Visitable;

class UsefulController extends Controller
{
    public function faydali(){
        $usefuls = Useful::orderBy('id', 'desc')->paginate(9);
        return view('faydali',compact('usefuls'));
    }
    public function faydaliabout(int $id){
        $usefuls = Useful::findOrFail($id);
        $usefuls->useful_review += 1;
        $usefuls->save();
        $counts =  DB::table('usefuls')
        ->select('useful_title', 'id','useful_content', 'useful_image',DB::raw('count(id) as count'))
        ->groupBy('id')
        ->orderBy('useful_review','DESC')
        ->limit(3)
        ->get();
    return view('faydali-about',compact('usefuls', 'counts'));
//
    }
    public function search(Request $request){
        // Get the search value from the request
        $search = $request->input('search');

        // Search in the title and body columns from the posts table
        $posts = Useful::query()
            ->where('useful_title', 'LIKE', "%{$search}%")
            ->orWhere('useful_content', 'LIKE', "%{$search}%")
            ->get();

        // Return the search view with the resluts compacted
        return view('faydali-search', compact('posts'));
    }
}