<?php
  
  namespace App\Http\Controllers;

  use App\Classes\RusDate;

  use App\Http\Requests\DocumentsRequest;

  use App\Http\Requests\PrevCompanyRequest;
  use App\Http\Requests\SertificationRequest;

  use App\Models\Ad_employer;

  use App\Models\ad_response;

  use App\Models\Chat;

  use App\Models\Dop_info;

  use App\Models\infobloks;

  use App\Models\Job_title;

  use App\Models\Like_vacancy;

  use App\Models\Message;

  use App\Models\place_works;

  use App\Models\PrevCompany;

  use App\Models\ResponseWork;

  use App\Models\sertification;

  use App\Models\Static_worker;

  use App\Models\Title_worker;

  use App\Models\User;

  use App\Models\User as User_Model;

  use App\Models\Worker;

  use Barryvdh\DomPDF\Facade\Pdf;

  use Carbon\Carbon;

  use Illuminate\Auth\Events\Registered;

  use Illuminate\Database\Eloquent\Builder;

  use Illuminate\Http\Request;

  use Illuminate\Support\Facades\Auth;
  use Illuminate\Support\Facades\Hash;

  use Illuminate\Support\Facades\Storage;

  use Illuminate\Support\Facades\Validator;

  use PhpOffice\PhpSpreadsheet\Spreadsheet;
  use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  use Symfony\Component\HttpFoundation\StreamedResponse;
  use App\Enums\DbExportColumns;

  use App\Enums\WorkerStatuses;

  use DateTime;

  
  class WorkerController extends Controller
  {

      //профиль

      public function profile(Worker $worker)
      {

          $get_date = date('Y.m');

  
          $c = Static_worker::query()->where('year_month', '=', $get_date)
              ->where('user_id', '=', $worker->users->id)
              ->get();
  
          if ($c->count() > 0) {
              $upd = Static_worker::find($c[0]->id);
              $upd->lookin = $upd->lookin + 1;
              $upd->save();
          } else {
              $crt = new Static_worker();
              $crt->lookin = 1;
              $crt->year_month = $get_date;
              $crt->user_id = $worker->user_id;
              $crt->save();
          }
  
          $stat = Static_worker::query()->where('year_month', '=', $get_date)

              ->where('user_id', '=', $worker->users->id)
              ->get();

  
          return view('public.workers.profile', compact('worker', 'stat'));
      }

      // лист база резюме

      public function bd_resume(Request $request)

      {

          $look = false;
          $idiot = 0;

          if (isset(Auth()->user()->id)) {
              $idiot = Auth()->user()->id;

              if ((!Auth()->user()->is_worker) && (Auth()->user()->is_lookin))
                  $look = true;

          }

          if ($look) {

              $status_work = WorkerStatuses::getWorkerStatuses();
              $resumes = Worker::query()->with('users')->with('job_titles')->orderByDesc('updated_at');;

              $resumes = $resumes->whereHas('users', function (Builder $query) {
                  $query->Where('is_worker', '=', '1')
                      ->Where('is_bd', '=', '0');

              });

              //dd($request->get('job'));
              if (($request->has('job')) && ($request->get('job') > 0)) {
                  $resumes = $resumes->whereHas('job_titles', function (Builder $query) use ($request) {
                      $query->Where('job_titles.id', $request->get('job'));
                  });

              }

              $Job_title = Job_title::query()->
                              where('is_remove', '=', '0')->
                              where('is_bd', '=' , '1')->
                              get();

  
              if ($request->get('sort')) {
                  $sort = $request->get('sort');
                  switch ($sort) {

                      case 'looking_for_work':
                          $resumes->where('status_work', '=', WorkerStatuses::LookingForWork->value);

                          break;

                      case 'considering_offers':
                          $resumes->where('status_work', '=', WorkerStatuses::ConsideringOffers->value);

                          break;

                      case 'not_looking_for_work':
                          $resumes->where('status_work', '=', WorkerStatuses::NotLookingForWork->value);

                          break;
                  }

              }

              $res_count = $resumes->count();
              //$resumes = $resumes->get();
              $resumes = $resumes->paginate(4);
              if ($request->ajax()) {
                  // Условия обставлены
                  if ($request->has('block') && ($request->get('block') == 1)) {
                      return view('ajax.resume_1', compact('resumes', 'status_work', 'res_count', 'idiot'));
                  }

              } else {
                  return view('resume', compact('resumes', 'status_work', 'res_count', 'idiot', 'Job_title'));

              }
          } else {

              return redirect()->route('index')->withErrors(['errors' => ['Вы не можете просматривать базу резюме. Подробнее в меню: "Условия размещения"']]);

          }

      }

      public function basic_information(){
          if (!isset(Auth()->user()->id)) {
              abort(404);
          }
  
          $user_id = Auth()->user()->id;
  
          $user = User::query()
              ->with('workers')
              ->with(['jobtitles' => function ($query) {
                  $query->select('job_titles.id');
              }])
              ->where('id', '=', $user_id)
              ->first();
          $user->workers[0]->job_titles = $user->workers[0]->job_titles->pluck('id')->toArray();

          $job_titles = Job_title::query()
              ->where('is_remove', '=', 0)
              ->where('is_bd', '=', 1)

              ->orderByDesc('sort')
              ->get()

          ;

  
          return view('workers.form_basic_information', compact('user', 'job_titles'));
      }
  
      public function additional_documents(){
          if (!isset(Auth()->user()->id)) {
              abort(404);
          }
  
          $user_id = Auth()->user()->id;
  
          $info_blocks = infobloks::query()->OrderBy('name')->get();
          $additional_document_statuses = [0 => 'Не указано', 1 => 'В наличии', 2 => 'Отсутствует'];
  
          $worker = Worker::query()
              ->with('users')
              ->with('infobloks')
              ->WhereHas('users', function (Builder $query) use ($user_id) {
                  $query->Where('id', $user_id);
              })
              ->first();
          if ($worker->dop_info->count()){
              $worker->dop_info = $worker->dop_info->keyBy('infoblok_id')->toArray();
          }
  
          return view('workers.form_additional_documents', compact('worker', 'info_blocks', 'additional_document_statuses'));
      }

      //Лайк резюме
      public function like_controller() {
  
      }

      // анкета соискателя

      public function resume_profile(Worker $worker)
      {

          if (isset(Auth()->user()->id)) {
              $idiot = Auth()->user()->id;
          } else {
              $idiot = 0;
          }

          $status_work = WorkerStatuses::getWorkerStatuses();

          $Query = Worker::query()->with('users')->with('job_titles')
              ->with('place_worker')->with('sertificate')->with('prev_company')

              ->with('infobloks')->with('response');

          $Query = $Query->where('id', '=', $worker->id);
          $Query = $Query->get();

  
          $get_date = date('Y.m');

          $infoblocks = infobloks::query()->get();

          $c = Static_worker::query()->where('year_month', '=', $get_date)

              ->where('user_id', '=', $worker->user_id)

              ->get();
  
          if ($c->count() > 0) {
              $upd = Static_worker::find($c[0]->id);
              $upd->lookin = $upd->lookin + 1;
              $upd->save();
          } else {
              $crt = new Static_worker();
              $crt->lookin = 1;
              $crt->year_month = $get_date;
              $crt->user_id = $worker->user_id;

              $status = $crt->save();

          }

          $stat = Static_worker::query()->where('year_month', '=', $get_date)

              ->where('user_id', '=', $worker->user_id)

              ->get();

          return view('worker', compact('Query', 'infoblocks', 'status_work', 'idiot', 'stat'));

      }
  
      // скачать анкету соискателя

      public function resume_download(Worker $worker)
      {

          $status_work = WorkerStatuses::getWorkerStatuses();

          $Query = Worker::query()->with('users')->with('job_titles')
              ->with('place_worker')->with('sertificate')->with('prev_company')
              ->with('infobloks');
          $Query = $Query->where('id', '=', $worker->id);

          $Query = $Query->get();

          view()->share('Query',$Query);

          $status_work = WorkerStatuses::getWorkerStatuses();

          $infoblocks = infobloks::query()->get();

          //return view('layout.pdf', compact('Query', 'status_work', 'infoblocks'));

          $pdf = PDF::loadView('layout.pdf', [
              'Query' => $Query,
              'status_work' => $status_work,
              'infoblocks' => $infoblocks
          ])->setPaper('a4', 'landscape');

  
          return $pdf->stream();

      }

      public function resume_download_all(Request $request) {
          $spreadsheet = new Spreadsheet();
          $sheet = $spreadsheet->getActiveSheet();

          $columnMap = range('A', 'Z');
          $columns = [];

          foreach (DbExportColumns::toArray() as $key => $value){
              if ($request->input($key, 0)){

                  $sheet->setCellValue("{$columnMap[count($columns)]}1", ucfirst($value));
                  $columns[] = str_replace('__', '.', $key);

              }
          }

          if (empty($columns)) {
              return redirect()->back()->with('error', 'Пожалуйста выберите хотя бы 1 колонку для экспорта.');
          }
  
          $query = User::select($columns)
              ->leftJoin('workers', 'users.id', '=', 'workers.user_id')
              ->leftJoin('job_titles', 'workers.position_work', '=', 'job_titles.id')
              ->where('users.is_bd', '=', 1)
              ;
  
          $job_title_list = $request->input('job_title_list', []);
          if (!empty($job_title_list)){
              $query->whereIn('job_titles.id', $job_title_list);
          }
  
          $users = $query->get();
          if ($users->count()){
              $i = 2;
              foreach ($users->toArray() as $user){
                  $j = 0;
                  foreach ($user as $field){
                      $sheet->setCellValue("{$columnMap[$j++]}$i", $field);
                  }
                  $i++;
              }
          }
          $writer = new Xlsx($spreadsheet);
          $fileName = 'DB.xlsx';
  
          $response = new StreamedResponse(function() use ($writer) {
              $writer->save('php://output');
          });
  
          $response->headers->set('Content-Type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
          $response->headers->set('Content-Disposition', 'attachment;filename="' . $fileName . '"');
          $response->headers->set('Cache-Control', 'max-age=0');
  
          return $response;

      }

      // Кабинет работника

      public function cabinet(Request $request)

      {

          // дата год и месяц

          $get_date = date('Y.m');

          $id = Auth()->user()->id;

  
          $Infobloks = infobloks::query()->get();

          $Worker = Worker::query()->with('users')->with('sertificate')->with('prev_company')->

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

          $Job_titles = Job_title::query()->where('is_remove', '=', '0')->
              where('is_bd', '=' , '1')->

              OrderByDesc('sort')->OrderBy('name')->get();

          $stat = Static_worker::query()->where('year_month', '=', $get_date)

              ->where('user_id', '=', $id)

              ->get();

          // 10%

          $persent = 10;

          $persent1 = 0;
          $persent2 = 0;
          $persent3 = 0;
          $persent4 = 0;
          $persent5 = 0;
  
          if ((!empty($Worker[0]->telephone)) &&

              (!empty($Worker[0]->email)) && (!empty($Worker[0]->experience)) &&
              (!empty($Worker[0]->city)) && (!empty($Worker[0]->old_year))) {

              // 40%

              $persent = $persent + 40;

              $persent1 = 40;

          }

          //dd($Worker[0]->status_work, $Worker[0]->telephone, $Worker[0]->email, $Worker[0]->experience, $Worker[0]->city, $Worker[0]->old_year);

          if ($Worker[0]->sertificate->count() > 0) {

              // 15%

              $persent = $persent + 15;

              $persent2 = 15;

          }
  
          if ($Worker[0]->infobloks->count() > 0) {

              // 20%

              $persent = $persent + 20;

              $persent3 = 20;

          }
  
          if ($Worker[0]->prev_company->count() > 0) {

              // 10%

              $persent = $persent + 10;

              $persent4 = 10;

          }
  
          if (!empty($Worker[0]->photo)) {
              // 5%
              $persent = $persent + 5;

              $persent5 = 5;

          }

          $status_work = WorkerStatuses::getWorkerStatuses();

          $additional_document_statuses = [0 => 'Не указано', 1 => 'В наличии', 2 => 'Отсутствует'];
          $info_blocks = infobloks::query()->OrderBy('name')->get();
  
          $worker = Worker::query()
              ->with('users')
              ->with('sertificate')
              ->with('prev_company')
              ->with('infobloks')
              ->with('place_worker')
              ->with('job_titles')
              ->WhereHas('users', function (Builder $query) use ($id) {
                  $query->Where('id', $id);
              })
              ->first();
          if ($worker->dop_info->count()){
              $worker->dop_info = $worker->dop_info->keyBy('infoblok_id')->toArray();
          }
  
          //dd($worker->dop_info);

          if ($request->has('print')) {
             dd($Worker);
          } else {

              return view('workers.cabinet', compact( 'persent', 'Job_titles', 'stat',
                  'worker', 'info_blocks', 'status_work', 'additional_document_statuses'
              ));

          }

      }
  
      // Сохранение данных

      public function cabinet_save(Worker $worker, Request $request)
      {

          $id = $worker->id;
          $params = $request->all();

          $job_title_id = $request->get('job_title_id');

          $rules = [
              'surname' => ['required', 'string', 'max:255'],
              'name_man' => ['required', 'string', 'max:255'],
              'email' => ['required', 'string', 'email', 'max:255'],
  
          ];
  
          $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($params, $rules, $messages);
  
          if ($validator->fails()) {
              return redirect()->route('worker.cabinet')->withErrors($validator);
          } else {
  
              if ($request->has('photo')) {

                  if (!empty($worker->photo)) {
                      Storage::delete($worker->photo);

                  }
                  $params['photo'] = $request->file('photo')->store("worker/$id", 'public');
              }
  
              if ($request->has('file')) {

                  if (!empty($worker->file)) {
                      Storage::delete($worker->file);

                  }
                  $params['file'] = $request->file('file')->store("worker/$id", 'public');
              }

              $worker->update($params);

              $use = User::find($worker->user_id);

              $use->surname = $request->get('surname');
              $use->name_man = $request->get('name_man');
              $use->surname2 = $request->get('surname2');
  
              $use->save();
              $worker->job_titles()->sync($job_title_id);

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

          }

      }

      public function cabinet_save_foto(Worker $worker, Request $request){
          $params = ['photo' => null];

          if ($request->has('photo')) {
              if (!empty($worker->photo)) {
                  Storage::delete($worker->photo);
              }
              $params['photo'] = $request->file('photo')->store("worker/$worker->id", 'public');
          }
  
          if ($request->has('file')) {
              if (!empty($worker->file)) {
                  Storage::delete($worker->file);
              }
              $params['file'] = $request->file('file')->store("worker/$worker->id", 'public');
          }
  
          $worker->update($params);
  
          return redirect()->route('worker.cabinet');
      }

      // Сообщения данные

      public function messages($type_message)
      {

          $user_id = Auth()->user()->id;

          $chats = Chat::get_user_chats($user_id);

          $admin_chat = Chat::get_user_admin_chat($user_id);

          $user_type = 'worker';

          return view('workers.messages', compact('chats', 'admin_chat','user_id', 'user_type'));

      }
  
      // Избранный

      public function favorite()
      {

          return view('workers.favorite');
      }

      // Сменить пароль

      public function new_password()
      {

          $email = Auth()->user()->email;
          return view('workers.new_password', compact('email'));

      }

      // Обновление пароля
      public function save_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, $request->has('save_me'))) {

  
                      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('worker.new_password')
                              ->with('success', 'Поздравляю! Вы обновили свой пароль!');
                      }
  
                      return redirect()
                          ->route('worker.new_password')
                          ->withError('Данная учетная запись не было верифицированна!');
                  }
              }
  
          return redirect()
              ->route('worker.new_password')
              ->withErrors('Не совпадение данных, обновите пароли!');
      }
  
      // Удаление профиля форма

      public function delete_profile()
      {

          $login = Auth()->user()->email;
          return view('workers.delete_profile', compact('login'));
      }

      // Удаление профиля код
      public function delete_profile_result(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('worker.delete_profile')
                  ->withErrors( 'Неверный пароль! Нужен корректный пароль');
          }

      }

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

          $params['is_worker'] = 1;

          $rules = [
              'surname' => ['required', 'string', 'max:255'],
              'name_man' => ['required', 'string', 'max:255'],

              'email' => ['required', 'email', 'max:255', 'unique:users'],

              '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: Недостаточная длина пароля! Увеличьте себе длину пароля!"));
          }
  
          /*$haystack = $request->get('password');

  
          $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');

          $lenpwd_bool = true;

          $spec_bool = false;
          $alpha_bool = false;

          if (strlen($haystack) < 8)  $lenpwd_bool = false;

          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 (($request->has('politik')) && ($request->get('politik') == 1)) {

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

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

                  //dd($params);

                  $user = $this->create($params);
                  event(new Registered($user));

                  Auth::guard()->login($user);
              }

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

          } else {

              return json_encode(Array("ERROR" => "Error3: Вы не согласились с политикой  конфидициальности!"));

          }
      }

      // Звездная оценка и ответ
      public function stars_answer(Request $request) {
          $params = $request->all();
          $rules = [
              'message' => ['required', 'string', 'max:255'],
          ];
  
          $messages = [
              'required' => 'Укажите обязательное поле',
              'min' => [
                  'string' => 'Поле «:attribute» должно быть не меньше :min символов',
                  'integer' => 'Поле «:attribute» должно быть :min или больше',
                  'file' => 'Файл «:attribute» должен быть не меньше :min Кбайт'
              ],
              'max' => [
                  'string' => 'Поле «:attribute» должно быть не больше :max символов',
                  'integer' => 'Поле «:attribute» должно быть :max или меньше',
                  'file' => 'Файл «:attribute» должен быть не больше :max Кбайт'
              ]
          ];
          $response_worker = ResponseWork::create($params);
          return redirect()->route('resume_profile', ['worker' => $request->get('worker_id')])->with('success', 'Ваше сообщение было отправлено!');
      }

      public function TestWorker()
      {
          $Use = new User();
  
          $Code_user = $Use->create([
              'name' => 'surname name_man',
              'name_man' => 'name_man',
              'surname' => 'surname',
              'surname2' => 'surname2',
              'subscribe_email' => '1',
              'email' => 'email@mail.com',
              'telephone' => '1234567890',
              'password' => Hash::make('password'),
              'pubpassword' => base64_encode('password'),
              'email_verified_at' => Carbon::now(),
              'is_worker' => 1,
          ]);
  
          if ($Code_user->id > 0) {
              $Worker = new Worker();
              $Worker->user_id = $Code_user->id;
              $Worker->position_work =  1; //'job_titles';
              $Worker->email = 'email@email.com';
              $Worker->telephone = '1234567890';
              $status = $Worker->save();
  
              $Title_Worker = new Title_worker();
              $Title_Worker->worker_id = $Worker->id;
              $Title_Worker->job_title_id = 1;
              $Title_Worker->save();
          }
      }

      // Создание пользователя
      protected function create(array $data)
      {
          $Use = new User();

          $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'],
                              'password' => Hash::make($data['password']),
                              'pubpassword' => base64_encode($data['password']),

                              'email_verified_at' => Carbon::now(),
                              'is_worker' => $data['is_worker'],

                          ]);

          if ($Code_user->id > 0) {
              $Worker = new Worker();
              $Worker->user_id = $Code_user->id;
              $Worker->position_work = $data['job_titles'];
              $Worker->email = $data['email'];
              $Worker->telephone = $data['telephone'];
              $Worker->save();

              if (isset($Worker->id)) {
                  $Title_Worker = new Title_worker();
                  $Title_Worker->worker_id = $Worker->id;
                  $Title_Worker->job_title_id = $data['job_titles'];
                  $Title_Worker->save();
              }

              return $Code_user;
          }

      }

      // Вакансии избранные

      public function colorado(Request $request) {

          $IP_address = RusDate::ip_addr_client();
          $Arr = Like_vacancy::Query()->select('code_record')->where('ip_address', '=', $IP_address)->get();
  
          if ($Arr->count()) {
              $A = Array();
              foreach ($Arr as $it) {
                  $A[] = $it->code_record;
              }
  
              $Query = Ad_employer::query()->whereIn('id', $A);

          } else {

              $Query = Ad_employer::query()->where('id', '=', '0');

          }

          $Query = $Query->with('jobs')->
          with('cat')->
          with('employer')->
          whereHas('jobs_code', function ($query) use ($request) {
              if ($request->ajax()) {
                  if (null !== ($request->get('job'))) {
                      $query->where('job_title_id', $request->get('job'));
                  }
              }
          })->select('ad_employers.*');
  
          $Job_title = Job_title::query()->OrderBy('name')->get();
  
          $Query_count = $Query->count();
  
          $Query = $Query->OrderBy('updated_at')->paginate(3);
  
          return view('workers.favorite', compact('Query',
                                                      'Query_count',
                                                                  'Job_title'));
  
      }

      //Переписка

      public function dialog(Chat $chat, Request $request) {

          // Получение параметров.
          if ($request->has('ad_employer')){
              $ad_employer = $request->get('ad_employer');
          } else {
              $ad_employer = 0;
          }

          $sender = User_Model::query()->with('workers')->with('employers')->where('id', $chat->user_id)->first();
          $companion = User_Model::query()->with('workers')->with('employers')->where('id', $chat->to_user_id)->first();

          $Messages = Chat::get_chat_messages($chat);

          Message::where('user_id', '=', $chat->to_user_id)
              ->where('to_user_id', '=', $chat->user_id)

              ->update(['flag_new' => 0]);

          return view('workers.dialog', compact('companion', 'sender', 'chat', 'Messages', 'ad_employer'));

      }

      // Даунылоады

      public function download(Worker $worker) {

          $arr_house = ['0' => 'Проверка, проверка, проверка, проверка, проверка...'];
          view()->share('house',$arr_house);
          $pdf = PDF::loadView('layout.pdf', $arr_house)->setPaper('a4', 'landscape');
          return $pdf->stream();

      }
  
      // Поднятие анкеты
      public function up(Worker $worker) {
          $worker->updated_at = Carbon::now();
          $worker->save();

          // 0

          return redirect()->route('worker.cabinet')->with('success', 'Ваша анкета была поднята выше остальных');
      }

      // Форма сертификате
      public function new_sertificate(Worker $worker) {
          return view('workers.sertificate_add', compact('worker'));
      }

      // Добавление сертификата

      public function add_serificate(SertificationRequest $request) {

          $request->validate([
              'name' => 'required|string|max:255',
              'end_begin' => 'required|date|date_format:d.m.Y'
          ],
          [
              'name' => 'Навание сертификата обязательно для заполнения.',
              'end_begin' => 'Формат даты должен соответствовать дд.мм.гггг'
          ]);

          $params = $request->all();

          $end_begin = DateTime::createFromFormat('d.m.Y', $params['end_begin']);
          $params['end_begin'] = $end_begin->format('Y-m-d');

          $Sertificate = new sertification();
          $Sertificate->create($params);

  
          return response()->json([
              'success' => true
          ]);

      }

      // Удалить сертификат
      public function delete_sertificate(sertification $doc) {
          $doc->delete();
  
          return redirect()->route('worker.cabinet');
      }

      // Редактирование сертификата
      public function edit_sertificate(Worker $worker, sertification $doc) {
          return view('workers.sertificate_edit', compact('doc', 'worker'));
      }
  
      // Редактирование обновление сертификата
      public function update_serificate(SertificationRequest $request, sertification $doc) {

          $request->validate([
              'name' => 'required|string|max:255',
              'end_begin' => 'required|date|date_format:d.m.Y'
          ],
          [
              'name' => 'Навание сертификата обязательно для заполнения.',
              'end_begin' => 'Формат даты должен соответствовать дд.мм.гггг'
          ]);

          $all = $request->all();

  
          $end_begin = DateTime::createFromFormat('d.m.Y', $all['end_begin']);
          $all['end_begin'] = $end_begin->format('Y-m-d');

          $doc->worker_id = $all['worker_id'];
          $doc->name = $all['name'];
          $doc->end_begin = $all['end_begin'];
          $doc->save();
  
          return redirect()->route('worker.cabinet')->with('success', 'Вы успешно отредактировали запись!');
      }

      public function edit_diploms(Request $request, Worker $worker) {
          $dop_info_data = $request->input('diploms');
  
          if (empty($dop_info_data)) {
              return redirect()->route('worker.additional_documents')->with('error', 'Данные не предоставлены!');
          }
  
          foreach ($dop_info_data as $infoblok_id => $status) {
              Dop_info::updateOrCreate(
                  ['worker_id' => $worker->id, 'infoblok_id' => $infoblok_id],
                  ['status' => $status]
              );
          }
  
          return redirect()->route('worker.additional_documents')->with('success', 'Успешно сохранено!');
      }

      public function delete_add_diplom(Request $request, Worker $worker) {
          $infoblok_id = $request->get('infoblok_id');
  
          if (Dop_info::query()->where('worker_id', $worker->id)->where('infoblok_id', $infoblok_id)->count() > 0)
              $id = Dop_info::query()->where('worker_id', $worker->id)->where('infoblok_id', $infoblok_id)->delete();
          else {
              $params['infoblok_id'] = $infoblok_id;
              $params['worker_id'] = $worker->id;

              $params['status'] = $request->get('val');

              $id = Dop_info::create($params);
              //$id = $worker->infobloks()->sync([$infoblok_id]);
          }
  
          //$Infoblocks = infobloks::query()->get();
          return $id; //redirect()->route('worker.cabinet')->getTargetUrl(); //view('workers.ajax.diploms_dop', compact('worker', 'Infoblocks'));
      }

      // Добавление диплома
      public function add_diplom_ajax(Request $request) {
          // конец
          $params = $request->all();
          $count = Dop_info::query()->where('worker_id', $request->get('worker_id'))->where('infoblok_id', $request->get('infoblok_id'))->count();
  
          if ($count == 0) $dop_info = Dop_info::create($params);
          $Infoblocks = infobloks::query()->get();
          $Worker = Worker::query()->where('id', $request->get('worker_id'))->get();
          $data = Dop_info::query()->where('worker_id', $request->has('worker_id'));
          return view('ajax.dop_info', compact('data', 'Infoblocks', 'Worker'));
      }
  
      // Добавление диплома без ajax
      public function add_diplom(Worker $worker) {
          $worker_id = $worker->id;
          $Infoblocks = infobloks::query()->get();
          return view('workers.dop_info', compact('worker_id', 'worker', 'Infoblocks'));
      }
      // Сохранить
      // Сохраняю диплом
      public function add_diplom_save(Request $request) {
          $params = $request->all();
          $count = Dop_info::query()->where('worker_id', $request->get('worker_id'))->where('infoblok_id', $request->get('infoblok_id'))->count();
          if ($count == 0) $dop_info = Dop_info::create($params);
          return redirect()->route('worker.cabinet');
      }

  
      // Добавление стандартного документа
      public function add_document(Worker $worker) {
          return view('workers.docs', compact('worker'));
      }
  
      //Сохранение стандартого документа
      public function add_document_save(DocumentsRequest $request) {
          $params = $request->all();

          place_works::create($params);
          return response()->json(['success' => true]);

      }
  
      // Редактирование документа
      public function edit_document(place_works $doc, Worker $worker) {
          return view('workers.docs-edit', compact('doc', 'worker'));
      }
  
      //Сохранение отредактированного документа
      public function edit_document_save(DocumentsRequest $request, place_works $doc) {
          $params = $request->all();
          $doc->update($params);
  
          return redirect()->route('worker.cabinet')->with('success', 'Вы успешно отредактировали запись!');
      }
  
      // Удаление документа
      public function delete_document(place_works $doc) {
          $doc->delete();
          return redirect()->route('worker.cabinet')->with('success', 'Вы успешно удалили запись!');
      }
  
      //Отправка нового сообщения
      public function new_message(Request $request) {
          $params = $request->all();
  
          $id = $params['send_user_id'];

          $message_params = [
              'title' => $params['send_title'],
              'text' => $params['send_text'],
              'ad_employer_id' => $params['send_vacancy'],
              'flag_new' => 1
          ];
  
          $id_message = Message::add_message(
              $request,
              $params['send_user_id'],
              $params['send_to_user_id'],
              $message_params,
              file_store_path: "worker/$id"
          );

  
          $data['message_id'] = $id_message;
          $data['ad_employer_id'] = $params['send_vacancy'];
          $data['job_title_id'] = $params['send_job_title_id'];
          $data['flag'] = 1;
          $ad_responce = ad_response::create($data);
          return redirect()->route('worker.messages', ['type_message' => 'output']);
      }

  
      public function test123(Request $request) {
          $params = $request->all();
          $user1 = $params['user_id'];
          $user2 = $params['to_user_id'];
          $id_vacancy = $params['ad_employer_id'];
          $ad_name = $params['ad_name'];
  
          $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('worker.dialog', ['user1' => $user1, 'user2' => $user2, 'ad_employer' => $id_vacancy, 'ad_name' => $ad_name])
                  ->withErrors($validator);
          } else {

              $new_message = Message::add_message($request, $user1, $user2, $request->all(), file_store_path: 'messages');

              return redirect()->route('worker.dialog',

                  ['user1' => $user1, 'user2' => $user2, 'chat' => $new_message->chat_id_from]);

  
          }
      }

      // Информация о предыдущих компаниях
      public function new_prev_company(Worker $worker) {
          return view('workers.prev_company_form', compact('worker'));
      }
  
      // Добавление контакта компании
      public function add_prev_company(PrevCompanyRequest $request) {
          // Возвращение параметров
          $all = $request->all();

          PrevCompany::create($all);

          return response()->json(['success' => true]);

      }

      // Редактирование контакта компании
      public function edit_prev_company(PrevCompany $doc, Worker $worker) {
          return view('workers.prev_company_edit_form', compact('doc', 'worker'));
      }
  
      //Сохранение редактирования контакта компании
      public function update_prev_company(PrevCompany $doc, Request $request){
          $all = $request->all();
          $doc->update($all);
  
          return redirect()->route('worker.cabinet')->with('success', 'Вы успешно отредактировали запись');
      }

      // Удаление контакта предыдущей компании
      public function delete_prev_company(PrevCompany $doc) {
          $doc->delete();
          return redirect()->route('worker.cabinet')->with('success', 'Вы успешно удалили запись!');
      }

  }