<?php

namespace App\Http\Controllers\Admin;

use App\Http\Controllers\Controller;
use App\Models\Ad_employer;
use App\Models\Ad_jobs;
use App\Models\Category;
use App\Models\Employer;
use App\Models\Job_title;
use App\Models\User;
use Carbon\Carbon;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\Validator;

class Ad_EmployersController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request)
    {
        $title = 'Админка - Вакансии работодателей';
        if ($request->ajax()) {
           $params = $request->all();
           foreach ($params['data'] as $item) {
               $emp = Ad_employer::find($item);
               $emp->updated_at = Carbon::now();
               $emp->save();
           }
        }

        $select_job = Job_title::query()->active()->get();
        $all_ad = Ad_employer::with('employer')->with('jobs')
            ->where('is_remove', '0')->get()->count();

        $ad_employers = Ad_employer::where('is_remove', '0');

        $find_job = "";
        if (isset($request->category_job)) {
            if ($request->category_job != 'Все вакансии') {
                $find_job = $request->category_job;
                $ad_employers = $ad_employers->WhereHas('jobs', function($query) use ($find_job){
                     return $query->where('name', 'LIKE', '%'.$find_job.'%');
                });
            }
        } else {
            $ad_employers = $ad_employers->with('jobs');
        }

        $find_key = "";
        if (isset($request->find)) {
            $find_key = $request->find;
            $ad_employers = $ad_employers->whereHas('employer', function($query) use($find_key) {
                $query->Where('name_company', 'LIKE', "%$find_key%");
                $query->orWhere('name', 'LIKE', "%$find_key%");
            });

        } else {
            $ad_employers = $ad_employers->with('employer');
        }

        $ad_employers = $ad_employers->OrderBy('updated_at', 'desc')->paginate(15);

        if ($request->ajax()) {
            return view('admin.ad_employers.index_ajax', compact('ad_employers', 'params'));
        } else {
            // конец
            return view('admin.ad_employers.index', compact('ad_employers',
                                                                'title',
                                                                          'all_ad',
                                                                          'find_job',
                                                                          'find_key',
                                                                          'select_job'));
        }
    }

    public function create()
    {
        $job_titles = Job_title::query()->active()->get();
        $categories = Category::query()->get();
        return view('admin.ad_employers.add', compact('job_titles', 'categories'));
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        $params = $request->all();
        unset($params->position_work);
        $rules = [
            'name' => 'required|min:3',
        ];
        $messages = [
            'required' => 'Укажите обязательное поле',
        ];
        $validator = Validator::make($params, $rules, $messages);

        if ($validator->fails()) {
            return redirect()->route('admin.add-ad-employers')
                ->withErrors($validator);
        } else {
            $ad_employer = new Ad_employer();
            $params['employer_id'] = 1;
            $data_ad = $ad_employer->create($params);
            $data_ad->jobs()->sync($request->position_work);
            //$ad_employer->jobs()->sync($request->position_work);


            return redirect()->route('admin.ad-employers')
                ->with('success', 'Данные были успешно сохранены');
        }
        return redirect()->route('admin.ad-employers');
    }

    /**
     * Display the specified resource.
     *
     * @param  \App\Models\Ad_employer  $ad_employer
     * @return \Illuminate\Http\Response
     */
    public function show(Ad_employer $ad_employer)
    {
        //
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  \App\Models\Ad_employer  $ad_employer
     * @return \Illuminate\Http\Response
     */
    public function edit(Ad_employer $ad_employer)
    {
        $sel = Array();
        $job_titles = Job_title::active()->get();
        $categories = Category::query()->get();
        foreach ($ad_employer->jobs as $j) {
            $sel[] = $j->id;
        }

        return view('admin.ad_employers.edit', compact('ad_employer', 'categories', 'job_titles', 'sel'));
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\Models\Ad_employer  $ad_employer
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, Ad_employer $ad_employer)
    {
        $params = $request->all();
        unset($params->position_work);
        $rules = [
            'name' => 'required|min:3',
        ];
        $messages = [
            'required' => 'Укажите обязательное поле',
        ];
        $validator = Validator::make($params, $rules, $messages);

        if ($validator->fails()) {
            return redirect()->route('admin.edit-ad-employers', ['ad_employer' => $ad_employer->id])
                ->withErrors($validator);
        } else {
            $ad_employer->update($params);
            $ad_employer->jobs()->sync($request->position_work);

            return redirect()->route('admin.ad-employers')
                ->with('success', 'Данные были успешно сохранены');
        }

        return redirect()->route('admin.ad-employers');
    }

    public function destroy(Ad_employer $ad_employer)
    {
        $ad_employer->is_remove = 1;
        $ad_employer->save();

        return redirect()->route('admin.ad-employers');
    }


    public function update_ad_jobs(Ad_jobs $ad_jobs, Request $request) {
        $params = $request->all();

        $rules = [
            'min_salary' => 'required|integer|min:0|max:99999999',
            'max_salary' => 'required|integer|min:0|max:99999999',

        ];
        $messages = [
            'required' => 'Укажите обязательное поле',
            'min' => 'Минимальное значение 0',
            'max' => 'Превышено максимальное значение',
            'integer' => 'Это должно быть числом'
        ];

        $validator = Validator::make($params, $rules, $messages);

        if ($validator->fails()) {
            return redirect()->route('admin.edit_jobs', ['ad_jobs' => $ad_jobs->id])
                ->withErrors($validator);
        } else {
            $ad_jobs->update($params);
            return redirect()->route('admin.ad-employers')
                ->with('success', 'Данные были успешно сохранены');
        }

        return redirect()->route('admin.ad-employers');
    }

    public function edit_jobs(Ad_jobs $ad_jobs) {
        return view('admin.ad_jobs.edit', compact('ad_jobs'));
    }
}