
<?php

namespace App\Http\Controllers\Web;

use App\Http\Controllers\Controller;
use App\Models\Cv;
use App\Models\News;
use App\Models\Work;
use App\Models\Vacancy;
use App\Models\Position;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

class BlogController extends Controller
{

    public function blog() {
        $positions = Position::all();
        $vacancys = Vacancy::orderBy('id', 'desc')->paginate(9);
        $works = Work::all();
        return view('blog',compact('positions', 'vacancys','works'));
    }

    //
    public function blog_category($category_slug)
    {

        $positions = Position::where('position_title', $category_slug)->first();
        $works = Work::where('work_title', $category_slug)->first();
        $position = Position::all();
        $work = Work::all();
        if ($positions) {
            $post = Vacancy::where('position_id', $positions->id)->get();
            return view('blog-category', compact('post', 'positions', 'position', 'work'));
        }
        if ($works) {
            $post = Vacancy::where('work_id', $works->id)->get();
            return view('blog-category', compact('post', 'works', 'position', 'work'));
        } else {
            return redirect('/');
        }
    }

    public function vacancyabout(int $id)
    {
        $vacancy = Vacancy::findOrFail($id);
        $vacancy->vacancy_reviev += 1;
        $vacancy->save();
        $specials = DB::table('vacancies')->where('special', 1)->get();
        return view('vacancy_about', compact('vacancy', 'specials'));
    }
}