<?php

namespace App\Http\Controllers;

use App\Classes\RusDate;
use App\Classes\Tools;
use App\Http\Requests\BaseUser_min_Request;
use App\Http\Requests\BaseUserRequest;
use App\Http\Requests\FlotRequest;
use App\Http\Requests\MessagesRequiest;
use App\Http\Requests\VacancyRequestEdit;
use App\Http\Requests\VacansiaRequiest;
use App\Mail\MailSotrudnichestvo;
use App\Mail\SendAllMessages;
use App\Models\Ad_employer;
use App\Models\Ad_jobs;
use App\Models\ad_response;
use App\Models\Category;
use App\Models\Education;
use App\Models\Employer;
use App\Models\employers_main;
use App\Models\Flot;
use App\Models\Job_title;
use App\Models\Like_vacancy;
use App\Models\Like_worker;
use App\Models\Message;
use App\Models\Positions;
use App\Models\Worker;
use Carbon\Carbon;
use Illuminate\Auth\Events\Registered;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Foundation\Auth\User;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\Hash;
use Illuminate\Support\Facades\Mail;
use Illuminate\Support\Facades\Storage;
use App\Models\User as User_Model;
use Illuminate\Support\Facades\Validator;

class EmployerController extends Controller
{
    public function vacancie($vacancy, Request $request) {
        $title = 'Заголовок вакансии';
        $Query = Ad_employer::with('jobs')->
                              with('cat')->
                              with('employer')->
                              with('jobs_code')->
                              select('ad_employers.*')->
                              where('id', '=', $vacancy)->get();

        if (isset(Auth()->user()->id))
            $uid = Auth()->user()->id;
        else
            $uid = 0;
        $title = $Query[0]->name;
        if ($request->ajax()) {
            return view('ajax.vacance-item', compact('Query','uid'));
        } else {
            return view('vacance-item', compact('title', 'Query', 'uid'));
        }
    }

    public function logout() {
        Auth::logout();
        return redirect()->route('index')
            ->with('success', 'Вы вышли из личного кабинета');
    }

    public function employer_info() {
        // код юзера
        $user_info = Auth()->user();
        // вьюшка для вывода данных
        return view('employers.info', compact('user_info'));
    }

    public function employer_info_save(User_Model $user, BaseUser_min_Request $request) {
        // Все данные через реквест
        $all = $request->all();
        unset($all['_token']);
        // обновление
        $user->update($all);
        return redirect()->route('employer.employer_info');
    }

    public function cabinet() {
        $id = Auth()->user()->id;
        $Employer = Employer::query()->with('users')->with('ads')->with('flots')->
                                        WhereHas('users',
                                            function (Builder $query) use ($id) {$query->Where('id', $id);
                                        })->get();
        return view('employers.cabinet45', compact('Employer'));
    }

    public function slider_flot() {
        $id = Auth()->user()->id;
        $Employer = Employer::query()->with('users')->with('ads')->with('flots')->
        WhereHas('users',
            function (Builder $query) use ($id) {$query->Where('id', $id);
            })->get();
        return view('employers.fly-flot', compact('Employer'));
    }

    public function cabinet_save(Employer $Employer, Request $request) {
        $params = $request->all();
        $params['user_id'] = Auth()->user()->id;
        $id = $Employer->id;

        if ($request->has('logo')) {
            if (!empty($Employer->logo)) {
                Storage::delete($Employer->logo);
            }
            $params['logo'] = $request->file('logo')->store("employer/$id", 'public');
        }

        $Employer->update($params);

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

    public function save_add_flot(FlotRequest $request) {
        // отмена
        $params = $request->all();

        if ($request->has('image')) {
            $params['image'] = $request->file('image')->store("flot", 'public');
        }
        Flot::create($params);
        $data_flots = Flot::query()->where('employer_id', $request->get('employer_if'))->get();
        return redirect()->route('employer.slider_flot')->with('success', 'Новый корабль был добавлен');
    }

    public function edit_flot(Flot $Flot, Employer $Employer) {
        return view('employers.edit-flot', compact('Flot', 'Employer'));
    }

    public function update_flot(FlotRequest $request, Flot $Flot) {
        $params = $request->all();

        if ($request->has('image')) {
            if (!empty($flot->image)) {
                Storage::delete($flot->image);
            }
            $params['image'] = $request->file('image')->store("flot", 'public');
        } else {
            if (!empty($flot->image)) $params['image'] = $flot->image;
        }

        $Flot->update($params);
        return redirect()->route('employer.slider_flot')->with('success', 'Новый корабль был добавлен');
    }

    public function delete_flot(Flot $Flot) {
        $data_flots = Flot::query()->where('employer_id', $Flot->employer_id)->get();

        if (isset($Flot->id)) $Flot->delete();
        return redirect()->route('employer.slider_flot')->with('success', 'Корабль был удален');
    }

    // Форма добавления вакансий
    public function cabinet_vacancie() {
        $id = Auth()->user()->id;

        if (Auth()->user()->is_public) {
            $categories = Category::query()->active()->get();

            $jobs = Job_title::query()->orderByDesc('sort')->OrderBy('name')->
                    where('is_remove', '=', '0')->
                    where('is_bd', '=', '0')->
                    get();
            $Employer = Employer::query()->with('users')->with('ads')->with('flots')->

            WhereHas('users',
                function (Builder $query) use ($id) {
                    $query->Where('id', $id);
                })->get();

            return view('employers.add_vacancy', compact('Employer', 'jobs', 'categories'));
        } else {
            return redirect()->route('employer.cabinet_vacancie_danger');
        }
    }

    // Форма предупреждения об оплате
    public function cabinet_vacancie_danger() {
        return view('employers.add_vacancy_danger');
    }

    // Сохранение вакансии
    public function cabinet_vacancy_save1(VacancyRequestEdit $request) {
        $params_emp = $request->all();

        $params_job["job_title_id"] = $params_emp['job_title_id'];
        //$params_job["min_salary"] = $params_emp['min_salary'];
        //$params_job["max_salary"] = $params_emp['max_salary'];
        //$params_job["region"] = $params_emp['region'];
        //$params_job["power"] = $params_emp['power'];
        //$params_job["sytki"] = $params_emp['sytki'];
        //$params_job["start"] = $params_emp['start'];
        //$params_job["flot"] = $params_emp['flot'];
        //$params_job["description"] = $params_emp['description'];

        $ad_jobs = Ad_employer::create($params_emp);
        //$params_job['ad_employer_id'] = $ad_jobs->id;
        //Ad_jobs::create($params_job);
        $ad_jobs->jobs()->sync($request->get('job_title_id'));

        return redirect()->route('employer.vacancy_list');
    }

    // Список вакансий
    public function vacancy_list(Request $request) {
        $id = Auth()->user()->id;
        $Employer = Employer::query()->where('user_id', $id)->first();
        $vacancy_list = Ad_employer::query()->with('jobs')->
                        with('jobs_code')->
                        where('employer_id', $Employer->id);

        if ($request->get('sort')) {
            $sort = $request->get('sort');
            switch ($sort) {
                case 'name_up': $vacancy_list = $vacancy_list->orderBy('name')->orderBy('id'); break;
                case 'name_down': $vacancy_list = $vacancy_list->orderByDesc('name')->orderby('id'); break;
                case 'created_at_up': $vacancy_list = $vacancy_list->OrderBy('created_at')->orderBy('id'); break;
                case 'created_at_down': $vacancy_list = $vacancy_list->orderByDesc('created_at')->orderBy('id'); break;
                case 'default': $vacancy_list = $vacancy_list->orderBy('id')->orderby('updated_at'); break;
                default: $vacancy_list = $vacancy_list->orderBy('id')->orderby('updated_at'); break;
            }
        }
        $vacancy_list = $vacancy_list->paginate(4);

        //ajax
        if ($request->ajax()) {
            return view('employers.ajax.list_vacancy', compact('vacancy_list', 'Employer'));
        } else {
            return view('employers.list_vacancy', compact('vacancy_list', 'Employer'));
        }
    }

    // Карточка вакансии
    public function vacancy_edit(Ad_employer $ad_employer) {
        $id = Auth()->user()->id;
        $Positions = Category::query()->where('is_remove', '=', '0')->get();
        $jobs = Job_title::query()->OrderBy('name')->
            where('is_remove', 0)->where('is_bd', '=' , '0')->get();

        $Employer = Employer::query()->with('users')->with('ads')->with('flots')->
                                    where('user_id', $id)->first();

        return view('employers.edit_vacancy', compact('ad_employer', 'Positions','Employer', 'jobs'));
    }

    // Сохранение-редактирование записи
    public function vacancy_save_me(VacancyRequestEdit $request, Ad_employer $ad_employer) {
        $params = $request->all();

        //$jobs['flot'] = $params['flot'];
        //$jobs['job_title_id'] = $params['job_title_id'];
        //$titles['position_id'] = $params['position_id'];
        //unset($params['job_title_id']);

        $ad_employer->update($params);

        //$job_ = Ad_jobs::query()->where('job_title_id', $jobs['job_title_id'])->
        //                      where('ad_employer_id', $ad_employer->id)->first();
        //$data = Ad_jobs::find($job_->id);
        //$ad_jobs = $data->update($jobs);

        return redirect()->route('employer.vacancy_list');
    }

    // Сохранение карточки вакансии
    public function vacancy_save(Request $request, Ad_employer $ad_employer) {
        $all = $request->all();
        $ad_employer->update($all);
        return redirect()->route('employer.cabinet_vacancie');
    }

    // Удаление карточки вакансии
    public function vacancy_delete(Ad_employer $ad_employer) {
        $ad_employer->delete();

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

    // Обновление даты
    public function vacancy_up(Ad_employer $ad_employer) {
        $up = date('m/d/Y h:i:s', time());;
        $vac_emp = Ad_employer::findOrFail($ad_employer->id);
        $vac_emp->updated_at = $up;
        $vac_emp->save();

        return redirect()->route('employer.vacancy_list');
        // начало конца
    }

    //Видимость вакансии
    public function vacancy_eye(Ad_employer $ad_employer, $status) {
        $vac_emp = Ad_employer::findOrFail($ad_employer->id);
        $vac_emp->active_is = $status;
        $vac_emp->save();

        return redirect()->route('employer.vacancy_list');
    }

    //Вакансия редактирования (шаблон)
    public function vacancy_update(Ad_employer $id) {

    }

    //Отклики на вакансию - лист
    public function answers(Employer $employer, Request $request) {
        $user_id = Auth()->user()->id;
        $answer = Ad_employer::query()->where('employer_id', $employer->id);
        if ($request->has('search')) {
            $search = trim($request->get('search'));
            if (!empty($search)) $answer = $answer->where('name', 'LIKE', "%$search%");
        }

        $answer = $answer->with('response')->OrderByDESC('id')->get();

        return view('employers.list_answer', compact('answer', 'user_id', 'employer'));
    }

    //Обновление статуса
    public function supple_status(employer $employer, ad_response $ad_response,  $flag) {
        $ad_response->update(Array('flag' => $flag));
        return redirect()->route('employer.answers', ['employer' => $employer->id]);
    }

    //Страницы сообщений список
    public function messages($type_message) {
        $user_id = Auth()->user()->id;

        $messages_input = Message::query()->with('vacancies')->with('user_from')->
                                Where('to_user_id', $user_id)->OrderByDesc('created_at');

        $messages_output = Message::query()->with('vacancies')->
                                    with('user_to')->where('user_id', $user_id)->
                                    OrderByDesc('created_at');


        $count_input = $messages_input->count();
        $count_output = $messages_output->count();

        if ($type_message == 'input') {
            $messages = $messages_input->paginate(5);
        }

        if ($type_message == 'output') {
            $messages = $messages_output->paginate(5);
        }

        //dd($user_id, $messages[2]->vacancies);
        //jobs);

        return view('employers.messages', compact('messages', 'count_input', 'count_output', 'type_message', 'user_id'));
    }

    // Диалог между пользователями
    public function dialog(Request $request, User_Model $user1, User_Model $user2) {
        // Получение параметров.
        if ($request->has('ad_employer')){
            $ad_employer = $request->get('ad_employer');
        } else {
            $ad_employer = 0;
        }

        if (isset($user2->id)) {
            $companion = User_Model::query()->with('workers')->
                                        with('employers')->
                                        where('id', $user2->id)->first();
        }

        $Messages = Message::query()->
            where('ad_employer_id', '=', $ad_employer)->
            where(function($query) use ($user1, $user2) {
            $query->where('user_id', $user1->id)->where('to_user_id', $user2->id);
        })->orWhere(function($query) use ($user1, $user2) {
            $query->where('user_id', $user2->id)->where('to_user_id', $user1->id);
        })->where('ad_employer_id', '=', $ad_employer)->OrderBy('created_at')->get();

        $id_vac = $Messages[$Messages->count() - 1]->ad_employer_id;

        //$ad_employer = null;
        //if (!is_null($id_vac)) $ad_employer = Ad_employer::query()->where('id', $id_vac)->first();
        $sender = $user1;

        return view('employers.dialog', compact('companion', 'sender', 'ad_employer', 'Messages'));
    }

    // Регистрация работодателя
    public function register_employer(Request $request) {
        $params = $request->all();

        $rules = [
            //'surname' => ['required', 'string', 'max:255'],
            //'name_man' => ['required', 'string', 'max:255'],
            'email' => ['required', 'string', 'email', 'max:255', 'unique:users'],
            'name_company' => ['required', 'string', 'max:255'],
            'password' => ['required', 'string', 'min:6'],
        ];


        $messages = [
            'required' => 'Укажите обязательное поле',
            'min' => [
                'string' => 'Поле «:attribute» должно быть не меньше :min символов',
                'integer' => 'Поле «:attribute» должно быть :min или больше',
                'file' => 'Файл «:attribute» должен быть не меньше :min Кбайт'
            ],
            'max' => [
                'string' => 'Поле «:attribute» должно быть не больше :max символов',
                'integer' => 'Поле «:attribute» должно быть :max или меньше',
                'file' => 'Файл «:attribute» должен быть не больше :max Кбайт'
            ]
        ];

        $email =  $request->get('email');
        if (!preg_match("/^[a-zA-Z0-9_\-.]+@[a-zA-Z0-9\-]+\.[a-zA-Z0-9\-.]+$/", $email)) {
            return json_encode(Array("ERROR" => "Error: Отсутствует емайл или некорректный емайл"));
        }

        if ($request->get('password') !== $request->get('confirmed')){
            return json_encode(Array("ERROR" => "Error: Не совпадают пароль и подтверждение пароля"));
        }

        if (strlen($request->get('password')) < 6) {
            return json_encode(Array("ERROR" => "Error: Недостаточная длина пароля! Увеличьте себе длину пароля!"));
        }
        /*
        $specsumbol   = Array('!','~', '#', '$', '%', '^', '&', '*', '(', ')', '-', '=', ';', ':', '<', '>', '?');
        $alpha = Array('Q', 'W', 'E', 'R', 'T', 'Y', 'U', 'I', 'O', 'P', 'A', 'S', 'D', 'F', 'G', 'H', 'J', 'K', 'L', 'Z',
            'X', 'C', 'V', 'B', 'N', 'M');
        $spec_bool = false;
        $alpha_bool = false;

        $haystack = $request->get('password');

        foreach ($specsumbol as $it) {
            if (strpos($haystack, $it) !== false) {
                $spec_bool = true;
            }
        }

        foreach ($alpha as $it) {
            if (strpos($haystack, $it) !== false) {
                $alpha_bool = true;
            }
        }

        if ((!$spec_bool) || (!$alpha_bool)) {
            return json_encode(Array("ERROR" => "Error: Нет спецсимволов в пароле, латинские буквы заглавные, а также один из символов: !~#$%^&*()-=;,:<>?"));
        }*/

        if (empty($request->get('surname'))) {
            $params['surname'] = 'Неизвестно';
        }
        if (empty($request->get('name_man'))) {
            $params['name_man'] = 'Неизвестно';
        }
        $validator = Validator::make($params, $rules, $messages);

        if ($validator->fails()) {
            return json_encode(Array("ERROR" => "Error1: Регистрация оборвалась ошибкой! Не все обязательные поля заполнены. Либо вы уже были зарегистрированы в системе."));
        } else {
            $user = $this->create($params);
            event(new Registered($user));
            Auth::guard()->login($user);
        }

        if ($user) {
            return json_encode(Array("REDIRECT" => redirect()->route('employer.cabinet')->getTargetUrl()));;
        } else {
            return json_encode(Array("ERROR" => "Error2: Данные были утеряны!"));
        }
    }

    // Создание пользователя
    protected function create(array $data)
    {
        $Use = new User_Model();
        $Code_user = $Use->create([
            'name' => $data['surname']." ".$data['name_man'],
            'name_man' => $data['name_man'],
            'surname' => $data['surname'],
            'surname2' => $data['surname2'],
            'subscribe_email' => $data['email'],
            'email' => $data['email'],
            'telephone' => $data['telephone'],
            'is_worker' => 0,
            'password' => Hash::make($data['password']),
            'pubpassword' => base64_encode($data['password']),
            'email_verified_at' => Carbon::now()
        ]);

        if ($Code_user->id > 0) {
            $Employer = new Employer();
            $Employer->user_id = $Code_user->id;
            $Employer->name_company = $data['name_company'];
            $Employer->email = $data['email'];
            $Employer->telephone = $data['telephone'];
            $Employer->code = Tools::generator_id(10);
            $Employer->save();

            return $Code_user;
        }
    }

    // Отправка сообщения от работодателя
    public function send_message(MessagesRequiest $request) {
        $params = $request->all();
        dd($params);
        $user1 = $params['user_id'];
        $user2 = $params['to_user_id'];

        if ($request->has('file')) {
            $params['file'] = $request->file('file')->store("messages", 'public');
        }
        Message::create($params);
        return redirect()->route('employer.dialog', ['user1' => $user1, 'user2' => $user2]);
    }

    public function test123(Request $request) {
        $params = $request->all();
        $user1 = $params['user_id'];
        $user2 = $params['to_user_id'];

        $rules = [
            'text' => 'required|min:1|max:150000',
            'file' => 'file|mimes:doc,docx,xlsx,csv,txt,xlx,xls,pdf|max:150000'
        ];
        $messages = [
            'required' => 'Укажите обязательное поле',
            'min' => [
                'string' => 'Поле «:attribute» должно быть не меньше :min символов',
                'integer' => 'Поле «:attribute» должно быть :min или больше',
                'file' => 'Файл «:attribute» должен быть не меньше :min Кбайт'
            ],
            'max' => [
                'string' => 'Поле «:attribute» должно быть не больше :max символов',
                'integer' => 'Поле «:attribute» должно быть :max или меньше',
                'file' => 'Файл «:attribute» должен быть не больше :max Кбайт'
            ]
        ];

        $validator = Validator::make($request->all(), $rules, $messages);

        if ($validator->fails()) {
            return redirect()->route('employer.dialog', ['user1' => $user1, 'user2' => $user2])
                ->withErrors($validator);
        } else {
            if ($request->has('file')) {
                $params['file'] = $request->file('file')->store("messages", 'public');
            }
            Message::create($params);
            return redirect()->route('employer.dialog', ['user1' => $user1, 'user2' => $user2]);

        }
    }

    //Избранные люди
    public function favorites(Request $request) {
        $IP_address = RusDate::ip_addr_client();
        $Arr = Like_worker::Query()->select('code_record')->where('ip_address', '=', $IP_address)->get();

        if ($Arr->count()) {
            $A = Array();
            foreach ($Arr as $it) {
                $A[] = $it->code_record;
            }

            $Workers = Worker::query()->whereIn('id', $A);
        } else {
            $Workers = Worker::query()->where('id', '=', '0');
        }

        if (($request->has('search')) && (!empty($request->get('search')))) {
            $search = $request->get('search');

            $Workers =  $Workers->WhereHas('users',
                function (Builder $query) use ($search) {
                    $query->Where('surname', 'LIKE', "%$search%")
                        ->orWhere('name_man', 'LIKE', "%$search%")
                        ->orWhere('surname2', 'LIKE', "%$search%");
                });
        } else {
            $Workers = $Workers->with('users');
        }

        $Workers = $Workers->get();


        return view('employers.favorite', compact('Workers'));
    }

    // База данных
    public function bd(Request $request) {
        // для типа BelongsTo
        //$documents = Document::query()->orderBy(Location::select('name')
        //    ->whereColumn('locations.id', 'documents.location_id')
        //);

        // для типа HasOne/Many
        // $documents = Document::::query()->orderBy(Location::select('name')
        //   ->whereColumn('locations.document_id', 'documents.id')
        //);


        $users = User_Model::query()->with('workers');

        if ($request->has('search')) {
            $find_key = $request->get('search');
            $users = $users->where('name', 'LIKE', "%$find_key%")
                ->orWhere('surname', 'LIKE', "%$find_key%")
                ->orWhere('name_man', 'LIKE', "%$find_key%")
                ->orWhere('email', 'LIKE', "%$find_key%")
                ->orWhere('telephone', 'LIKE', "%$find_key%");
        }

        // Данные
        $users = $users->Baseuser()->
                        orderBy(Worker::select('position_work')->whereColumn('Workers.user_id', 'users.id'));
        $count_users = $users;
        $users = $users->paginate(5);


        return view('employers.bd', compact('users', 'count_users'));
    }

    //Настройка уведомлений
    public function subscribe() {
        return view('employers.subcribe');
    }

    //Установка уведомлений сохранение
    public function save_subscribe(Request $request) {
        dd($request->all());
        $msg = $request->validate([
            'subscribe_email' => 'required|email|min:5|max:255',
        ]);
        return redirect()->route('employer.subscribe')->with('Вы успешно подписались на рассылку');
    }

    //Сбросить форму с паролем
    public function password_reset() {
        $email = Auth()->user()->email;
        return view('employers.password-reset', compact('email'));
    }

    //Обновление пароля
    public function new_password(Request $request) {
        $use = Auth()->user();
        $request->validate([
            'password' => 'required|string',
            'new_password' => 'required|string',
            'new_password2' => 'required|string'
        ]);

        if ($request->get('new_password') == $request->get('new_password2'))
            if ($request->get('password') !== $request->get('new_password')) {
                $credentials = $request->only('email', 'password');
                if (Auth::attempt($credentials)) {

                    if (!is_null($use->email_verified_at)){

                        $user_data = User_Model::find($use->id);
                        $user_data->update([
                            'password' => Hash::make($request->get('new_password')),
                            'pubpassword' => base64_encode($request->get('new_password')),
                        ]);
                        return redirect()
                            ->route('employer.password_reset')
                            ->with('success', 'Поздравляю! Вы обновили свой пароль!');
                    }

                    return redirect()
                        ->route('employer.password_reset')
                        ->withError('Данная учетная запись не было верифицированна!');
                }
            }

        return redirect()
            ->route('employer.password_reset')
            ->withErrors('Не совпадение данных, обновите пароли!');
    }



    // Форма Удаление пипла
    public function delete_people() {
        $login = Auth()->user()->email;
        return view('employers.delete_people', compact('login'));
    }

    // Удаление аккаунта
    public function action_delete_user(Request $request) {
        $Answer = $request->all();
        $user_id = Auth()->user()->id;
        $request->validate([
            'password' => 'required|string',
        ]);

        $credentials = $request->only('email', 'password');
        if (Auth::attempt($credentials)) {
            Auth::logout();
            $it = User_Model::find($user_id);
            $it->delete();
            return redirect()->route('index')->with('success', 'Вы успешно удалили свой аккаунт');
        } else {
            return redirect()->route('employer.delete_people')
                ->withErrors( 'Неверный пароль! Нужен корректный пароль');
        }
    }

    public function ajax_delete_user(Request $request) {
        $Answer = $request->all();
        $user_id = Auth()->user()->id;
        $request->validate([
            'password' => 'required|string',
        ]);
        $credentials = $request->only('email', 'password');
        if (Auth::attempt($credentials)) {

            return json_encode(Array('SUCCESS' => 'Вы успешно удалили свой аккаунт',
                                     'email' => $request->get('email'),
                                     'password' => $request->get('password')));
        } else {
            return json_encode(Array('ERROR' => 'Неверный пароль! Нужен корректный пароль'));
        }
    }

    // FAQ - Вопросы/ответы для работодателей и соискателей
    public function faq() {
        return view('employers.faq');
    }

    // Рассылка сообщений
    public function send_all_messages() {
        $id = Auth()->user()->id;
        $sending = Employer::query()->where('user_id', '=', "$id")->first();
        if ($sending->sending_is)
            return view('employers.send_all');
        else
            return view('employers.send_all_danger');
    }

    // Отправка сообщений для информации
    public function send_all_post(Request $request) {
        $data = $request->all();

        $emails = User_Model::query()->where('is_worker', '1')->get();

        foreach ($emails as $e) {
            Mail::to($e->email)->send(new SendAllMessages($data));
        }

        return redirect()->route('employer.send_all_messages')->with('success', 'Письма были отправлены');
    }

    // База резюме
    public function bd_tupe(Request $request) {
        $Resume = User_Model::query()->with('workers')->where('is_bd', '=', '1')->get();

        return view('employers.bd_tupe', compact('Resume'));
    }

    //////////////////////////////////////////////////////////////////
    // Отправил сообщение
    //////////////////////////////////////////////////////////////////
    public function new_message(Request $request) {
        $params = $request->all();
        $id = $params['_user_id'];
        $message = new Message();
        $message->user_id = $params['_user_id'];
        $message->to_user_id = $params['_to_user_id'];
        $message->title = $params['title'];
        $message->text = $params['text'];
        if ($request->has('_file')) {
            $message->file = $request->file('_file')->store("worker/$id", 'public');
        }
        $message->ad_employer_id = $params['_vacancy'];
        $message->flag_new = 1;
        $id_message = $message->save();

        //$data['message_id'] = $id_message;
        //$data['ad_employer_id'] = $params['_vacancy'];
        //$data['job_title_id'] = 0;

        $data['flag'] = 1;
        //$ad_responce = ad_response::create($data);
        return redirect()->route('employer.messages', ['type_message' => 'output']);
    }

    // Восстановление пароля
    public function repair_password(Request $request) {
        $params = $request->get('email');
    }

    // Избранные люди на корабль
    public function selected_people(Request $request) {
        $id = $request->get('id');
        $favorite_people = Job_title::query()->Notbdif()->where('is_remove', '=', '0')->where('position_id', $id)->get();
        return view('favorite_people', compact('favorite_people'));
    }
}