<?php
  
  namespace App\Http\Controllers\Admin;
  
  use App\Http\Controllers\Controller;

  use App\Models\Company;
  use App\Models\Job_title;

  use App\Models\Static_worker;

  use App\Models\User;

  use App\Models\Worker;

  use Illuminate\Database\Eloquent\Builder;

  use Illuminate\Http\Request;

  use Illuminate\Support\Facades\DB;

  use Illuminate\Support\Facades\Storage;
  use Illuminate\Support\Facades\Validator;

  
  class WorkersController extends Controller
  {
      public function index(Request $request) {
          if ($request->ajax()) {
              $user = User::find($request->id);
              $request->offsetUnset('id');
              $user->update($request->all());
          }

          $status_work = Job_title::query()->active()->orderBy('name')->get();
          $users = User::with('jobtitles')->where('is_worker', '1');
  
          $find_status_work = "";
          if (isset($request->status_work)) {
              $find_status_work = $request->status_work;
              //$users = $users->where('position_work', '=', $find_status_work);
  
              /*if ($request->status_work > 0)
                  $users = $users->with(['workers' => function($query) use ($find_status_work){
                      $query->where('position_work', $find_status_work);
                  }]);
              else
                  $users = $users->with('workers');*/
  
              /*$users = $users->where(function($query) use($find_status_work) {
                  $query->with(['workers' => function($query1) use ($find_status_work){
                      $query1->where('position_work', $find_status_work);
                  }]);
              });*/
              if ($request->status_work > 0) {
                  $users = $users->with('workers')->
                  whereHas('workers',
                      function (Builder $query) use ($find_status_work) {
                          $query->where('position_work', $find_status_work);
                      }
                  );
              } else {
                  $users = $users->with('workers');
              }
  
          } else {
              $users = $users->with('workers');
          }

          $find_key = "";
          if (isset($request->find)) {
              $find_key = $request->find;
              $users = $users->where(function($query) use($find_key) {
                  $query->Where('name_man', 'LIKE', "%$find_key%")
                      ->orWhere('email', 'LIKE', "%$find_key%")

                      ->orWhere('telephone', 'LIKE', "%$find_key%")
                      ->orWhere('surname', 'LIKE', "%$find_key%")
                      ->orWhere('surname2', 'LIKE', "%$find_key%");

              });
          }
  
          $users = $users->paginate(15);

          /*
          $Arr = array();
          $where = '';
          $find_status_work = "";
          if (isset($request->status_work)) {
              $find_status_work = $request->status_work;
              //$users = $users->where('position_work', '=', $find_status_work);
              $where.= ' and (w.position_work = :uid1)';
              $Arr['uid1'] = $find_status_work;
          }
  
          $find_key = "";
          if (isset($request->find)) {
              $find_key = $request->find;
              /*$users = $users->where(function($query) use($find_key) {
                  $query->Where('name_man', 'LIKE', "%$find_key%")
                      ->orWhere('email', 'LIKE', "%$find_key%")
                      ->orWhere('telephone', 'LIKE', "%$find_key%");
              });*/
              /*$where.= " and ((u.name_man LIKE %:uid2%) or (w.email LIKE %:uid2%) or (w.telephone LIKE %:uid2%))";
              $Arr['uid2'] = $find_key;
          }
  
          //$users = $users->paginate(15);
  
          //DB::enableQueryLog();
          $users = DB::select('SELECT u.*, w.*, j.*
                                      FROM workers w
                                      JOIN users u ON u.id = w.user_id
                                      JOIN job_titles j ON j.id = w.position_work
                                      Where (u.is_worker = 1)
                                      '.$where, $Arr);
          //dump(DB::getQueryLog());
          dd($users);
          */

          if ($request->ajax()) {
              return view('admin.worker.index_ajax', compact('users'));
          } else {

              return view('admin.worker.index', compact('users', 'find_key', 'find_status_work', 'status_work'));

          }
      }

      public function form_edit_worker(Worker $worker) {
          $job_titles = Job_title::query()->active()->orderBy('name')->get();
  
          $time_end_anketa = 'Бессрочно';
          if (!empty($worker->updated_at)) {
              $long_days = Company::find(1)->time_resume;
              $time_end_anketa = date("d.m.Y H:i:s", strtotime($worker->updated_at . "+$long_days days"));
          }
          return view('admin.worker.edit', compact('worker', 'job_titles', 'time_end_anketa'));
      }
  
      public function form_update_worker(Request $request, Worker $worker)
      {
          $params = $request->all();
  
          $rules = [
              'email' => 'email|string|max:255',
              //'photo' => 'mimes:jpeg,jpg,png|max:15000',
          ];
  
          $messages = [
              'required' => 'Укажите обязательное поле «:attribute»',
              'confirmed' => 'Пароли не совпадают',
              'email' => 'Введите корректный email',
              'min' => [
                  'string' => 'Поле «:attribute» должно быть не меньше :min символов',
                  'file' => 'Файл «:attribute» должен быть не меньше :min Кбайт'
              ],
              'max' => [
                  'string' => 'Поле «:attribute» должно быть не больше :max символов',
                  'file' => 'Файл «:attribute» должен быть не больше :max Кбайт'
              ],
          ];
  
          $validator = Validator::make($params, $rules, $messages);
  
          if ($validator->fails()) {
              return back()->withErrors($validator)->withInput();
          } else {
              $user_id = $worker->user_id;
              if ($request->has('photo')) {
                  if (!empty($worker->photo)) {
                      Storage::delete($worker->photo);
                  }
                  if (!empty($request->photo))
                     $params['photo'] = $request->file('photo')->store("workers/$user_id", 'public');
              }
              $worker->update($params);
  
              return redirect()->route('admin.workers');
          }

      }

  
      // кабинет - статистика работников

      public function static_workers(Request $request) {
          $stat = Static_worker::with('users');
              //->join('users', 'users.id', '=', 'static_workers.user_id');
          $users = User::query()->active()->OrderBy('id')->get();
          $periods = Static_worker::query()->distinct('year_month')->select('year_month')->get();
          if ($request->ajax()) {
              if (isset($request->user_id))
                  if (!$request->user_id == "0")
                      $stat = $stat->Where('user_id', '=', $request->user_id);
              if (isset($request->year_month)) {
                  if (!$request->year_month == "0")
                      $stat = $stat->Where('year_month', '=', $request->year_month);
              }
          }
  
          $stat = $stat->OrderByDesc('year_month');
              //->OrderBy('users.name');
          //OrderBy('users.name')->
          /*$stat->implode() loadMissing(['users' => function (Builder $query) {
              $query->orderBy('name', 'asc');
          }]);*/
  
          $stat = $stat->paginate(15);
  
          if ($request->ajax())
              return view('admin.static.index_workers_ajax', compact('stat'));
           else
              return view('admin.static.index_workers', compact('stat', 'users', 'periods'));

      }

  }