<?php
  
  namespace App\Http\Controllers;

  use App\Classes\RusDate;
  use App\Classes\Tools;
  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 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 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;

          $categories = Category::query()->active()->get();

          $Positions = Category::query()->active()->get();

          if ($Positions->count()) {
              $jobs = Job_title::query()->OrderBy('name')->where('position_id', $Positions[0]->id)->get();
          } else {
              $jobs = Job_title::query()->OrderBy('name')->where('position_id', 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', 'Positions'));

      }
  
      // Сохранение вакансии

      public function cabinet_vacancy_save1(VacancyRequestEdit $request) {

          $params = $request->all();

          $ad_jobs = Ad_employer::create($params);

          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()->active()->get();

          if ($Positions->count()) {
              $jobs = Job_title::query()->OrderBy('name')->where('position_id', $Positions[0]->id)->get();
          } else {
              $jobs = Job_title::query()->OrderBy('name')->where('position_id', 0)->get();
          }

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

          return view('employers.edit_vacancy', compact('ad_employer', 'Positions', 'categories','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')->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(15);
          }
  
          if ($type_message == 'output') {
              $messages = $messages_output->paginate(15);
          }
  
          return view('employers.messages', compact('messages', 'count_input', 'count_output', 'type_message', 'user_id'));
      }
  
      // Диалог между пользователями
      public function dialog(User_Model $user1, User_Model $user2) {
          if (isset($user2->id)) {
              $companion = User_Model::query()->with('workers')->
                                          with('employers')->
                                          where('id', $user2->id)->first();
          }
  
          $Messages = Message::query()->with('response')->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);
          })->OrderBy('created_at')->get();
  
          $id_vac = null;
          foreach ($Messages as $it) {
              if (isset($it->response)) {
                  foreach ($it->response as $r) {
                      if (isset($r->ad_employer_id)) {
                          $id_vac = $r->ad_employer_id;
                          break;
                      }
                  }
              }
              if (!is_null($id_vac)) break;
          }
  
          $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', 'Messages', 'ad_employer'));
      }

      // Регистрация работодателя
      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:8'],
          ];
  
  
          $messages = [
              'required' => 'Укажите обязательное поле',
              'min' => [
                  'string' => 'Поле «:attribute» должно быть не меньше :min символов',
                  'integer' => 'Поле «:attribute» должно быть :min или больше',
                  'file' => 'Файл «:attribute» должен быть не меньше :min Кбайт'
              ],
              'max' => [
                  'string' => 'Поле «:attribute» должно быть не больше :max символов',
                  'integer' => 'Поле «:attribute» должно быть :max или меньше',
                  'file' => 'Файл «:attribute» должен быть не больше :max Кбайт'
              ]
          ];
  
          if ($request->get('password') !== $request->get('confirmed')){
              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'))->

                          paginate(5);

          return view('employers.bd', compact('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() {
          return view('employers.send_all');
      }
  
      // Отправка сообщений для информации
      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->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()->where('position_id', $id)->get();

          return view('favorite_people', compact('favorite_people'));

      }

  }