<?php
  
  namespace App\Http\Controllers;

  use App\Classes\RusDate;

  use App\Classes\Tools;

  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\Employer;
  use App\Models\EmployerAutoliftOption;

  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 App\Models\WorkerAutoliftOption;

  use Barryvdh\DomPDF\Facade\Pdf;

  use Carbon\Carbon;

  use Illuminate\Auth\Events\Registered;

  use Illuminate\Database\Eloquent\Builder;

  use Illuminate\Http\RedirectResponse;

  use Illuminate\Http\Request;

  use Illuminate\Pagination\LengthAwarePaginator;

  use Illuminate\Support\Facades\Auth;

  use Illuminate\Support\Facades\DB;

  use Illuminate\Support\Facades\Hash;

  use Illuminate\Support\Facades\Storage;

  use Illuminate\Support\Facades\Validator;

  use Illuminate\View\View;
  use JsonException;

  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)

      {

  
          if (!Auth::check()) {
  
              return redirect()->route('page', ['pages' => "Usloviya-razmescheniya"])->withErrors(['errors' => ['Вы не можете просматривать базу резюме. Подробнее в меню: "Условия размещения"']]);

          }

              if ((Auth::user()->is_worker) || (!Auth()->user()->is_lookin))
                  return redirect()->route('page', ['pages' => "Usloviya-razmescheniya"])->withErrors(['errors' => ['Вы не можете просматривать базу резюме. Подробнее в меню: "Условия размещения"']]);

          $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');
          });
  
          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')
              ->orderByDesc('sort')
              ->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;

              }

          }

          $resumes = $resumes->get()->filter(function ($worker) {
              return Tools::getWorkerProfilePercent($worker) >= 50;

          });
  
          $res_count = $resumes->count();

  
          $currentPage = $_GET['page'] ?? 1;
          $resumes = new LengthAwarePaginator(
              items: $resumes->slice(4 * ($currentPage - 1), 4),
              total: $res_count,
              perPage: 4,
          );
          $resumes->setPath('bd-resume');

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

              }
          } else {

              return view('resume', compact('resumes', 'status_work', 'res_count', 'Job_title'));

          }

      }

      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->download();

      }

      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 колонку для экспорта.');
          }

          $jobIds = $request->input('job_title_list', []);

          /* //query for mysql ver 8.0 or higher
            $users = DB::select(

              "select `job_titles`.`name`, `users`.`surname`, `users`.`name_man`, `users`.`surname2`, `users`.`email`, `users`.`telephone`
              from users
                  join workers on `users`.`id` = `workers`.`user_id`
                  join `job_titles`
              where `users`.`is_bd` = 1
                  and (`workers`.`position_work` = `job_titles`.`id`
                  or exists (select 1
                      from JSON_TABLE(
                          workers.positions_work,
                          '$[*]' COLUMNS (id INT PATH '$')) pw
                      where pw.id = job_titles.id)
                  )". ((!empty($jobIds)) ? 'and job_titles.id in ('. implode(',', $jobIds).')' : '')

          );*/

          $selectFields = implode(',', $columns);
  
          $users = DB::select("SELECT $selectFields FROM users

                      JOIN workers ON `users`.`id` = `workers`.`user_id`
                      JOIN job_titles ON (`workers`.`position_work` = `job_titles`.`id`
                          OR JSON_CONTAINS(`workers`.`positions_work`, JSON_QUOTE(CAST(`job_titles`.`id` AS CHAR)), '$'))
                      WHERE `users`.`is_bd` = 1 " . ((!empty($jobIds)) ? 'AND job_titles.id IN (' . implode(',', $jobIds) . ')' : '') . "");

  
          $users = collect($users);
  
          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', 'sertificate', 'prev_company', 'infobloks', 'place_worker'])
              ->WhereHas('users', function (Builder $query) use ($id) {
                  $query->Where('id', $id);

              })->first();

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

          $persent = Tools::getWorkerProfilePercent($Worker);

          $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: Недостаточная длина пароля! Увеличьте себе длину пароля!"));
          }

          if (($request->has('politik')) && ($request->get('politik') == 1)) {

              $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('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) {

          $Arr = Like_vacancy::Query()
              ->select('code_record')
              ->where('user_id', Auth::user()->id)
              ->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', 'cat', '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.*');
  
          if ($request->get('search') !== null) {
              $search = $request->get('search');
              $Query->where('name', 'LIKE', "%$search%");
          }
  
          //dd($Query->get());

  
          $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('chat_id_to', '=', $chat->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['user_from'];

          Message::add_message(

              $request,

              $params['user_from'],
              $params['user_to'],
              [
                  'text' => $params['comment'] ?? null,
                  'ad_employer_id' => $params['vacancy'],
                  'flag_new' => 1
              ],

              file_store_path: "worker/$id"
          );

          if ($request->ajax()) {
              return response([]);
          }
          return redirect()->back();

      }

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

  
          $rules = [

              'text' => 'nullable|required_without:file|min:1|max:150000',
              'file' => 'nullable|file|mimes:doc,docx,xlsx,csv,txt,xlx,xls,pdf|max:150000'

          ];
          $messages = [

              'required_without' => 'Поле «:attribute» обязательно, если файл не прикреплен',

              '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()) {

              $chat = Chat::where('user_id', $user1)
                  ->where('to_user_id', $user2)
                  ->where('is_removed', 0)

                  ->first();

  
              if ($chat->id){
                  return redirect()->route('worker.dialog', ['chat' => $chat->id])->withErrors($validator);
              } else {
                  return redirect()->route('cabinet.messages', ['type_message' => 'input'])->withErrors($validator);
              }

          } else {

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

              //dd('new message', $new_message);

              return redirect()->route('worker.dialog', ['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', 'Вы успешно удалили запись!');
      }

  
      public function autoresponder()
      {
          $user = Auth::user();
          return view('workers.autoresponder', compact('user'));
      }
  
      public function autoresponderSave(Request $request): RedirectResponse
      {
          /** @var Employer $employer */
          $employer = Auth::user();
          $employer->autoresponder = $request->get('autoresponder', false) === 'on';
          $employer->autoresponder_message = $request->get('autoresponder_message');
          $employer->save();
  
          return redirect(route('worker.autoresponder'));
      }
      /**
       * @throws JsonException
       */
      public function resumeAutoLiftForm(): View
      {
          $worker = Auth::user()->workers[0];
  
          $options = $worker->autoliftOptions ?? new WorkerAutoliftOption();
  
          return view('workers.resume_autolift', compact('worker', 'options'));
      }
  
      /**
       * @throws JsonException
       */
      public function resumeAutoLiftSave(Request $request)
      {
          $worker = Auth::user()->workers[0];
  
          $worker->autoliftOptions()->updateOrCreate(
              [
                  'worker_id' => $worker->id,
              ],
              [

                  'is_enabled' => $request->get('is_enabled') === 'true',

                  'times_per_day' => $request->get('times_per_day'),
                  'days_repeat' => $request->get('days_repeat'),
                  'time_send_first' => $request->get('time_send_first'),
                  'time_send_second' => $request->get('time_send_second'),
                  'time_send_third' => $request->get('time_send_third'),
                  'time_send_tg' => $request->get('time_send_tg'),
                  'autolift_site' => $request->get('autolift_site') === 'on',
              ]
          );
  
          return response()->json(['success' => true]);
      }

  }