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

  use App\Http\Requests\BaseUserRequest;

  use App\Models\ContentRoles;

  use App\Models\Job_title;

  use App\Models\User;

  use App\Models\Worker;

  use App\Models\worker_jobs;
  use Illuminate\Database\Eloquent\Model;

  use Illuminate\Http\Request;

  use Illuminate\Support\Facades\Auth;

  use Illuminate\Support\Facades\Storage;

  use PhpOffice\PhpSpreadsheet\Spreadsheet;
  use PhpOffice\PhpSpreadsheet\Style\Alignment;
  use PhpOffice\PhpSpreadsheet\Style\Border;
  use PhpOffice\PhpSpreadsheet\Style\Font;
  use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

  
  class UsersController extends Controller
  {
      public function index(Request $request) {

          $title = 'Админка - Пользователи системы';

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

          if ($request->ajax()) {
              $user = User::find($request->id);
              $request->offsetUnset('id');
              $user->update($request->all());
          }

          $find_key = "";
          $users = User::query();
          if (isset($request->find)) {
             $find_key = $request->find;
             $users = $users->where('name', 'LIKE', "%$find_key%")
                          ->orWhere('email', 'LIKE', "%$find_key%");
          }

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

  
          if ($request->ajax()) {

             return view('admin.users.index_ajax', compact('users', 'id_admin'));

          } else {

              return view('admin.users.index', compact('users', 'title', 'id_admin', 'find_key'));

          }
      }

      public function user_delete(User $user) {
          $id = $user->delete();
  
          return redirect()->route('admin.users')->with('Пользователь был удален из системы');
      }

      public function index_bd(Request $request) {
          $title = 'Админка - Пользователи базы данных';
  
          $find_key = "";
          $users = User::query();
          if (isset($request->find)) {
              $find_key = $request->find;
              $users = $users->where('name', 'LIKE', "%$find_key%")
                  ->orWhere('email', 'LIKE', "%$find_key%")
                  ->orWhere('telephone', 'LIKE', "%$find_key%");
          }

          $users = $users->Baseuser()
              ->orderByDesc(Worker::select('created_at')->whereColumn('workers.user_id', 'users.id'))
              ->paginate(15);

  
          if ($request->ajax()) {
              return view('admin.users.index_bd_ajax', compact('users'));
          } else {
              return view('admin.users.index_bd', compact('users', 'title', 'find_key'));
          }
      }
  
      public function add_bd() {

          $list_job_titles = Job_title::query()->active()->where('is_bd', '=' , '2')->
          orderBy('name', 'asc')->get();

          return view('admin.users.add', compact('list_job_titles'));

      }
  
      public function add_store_bd(BaseUserRequest $request) {

          $params = $request->all();

          //dd($params);

          if ($request->has('file')) {
              $params['file'] = $request->file('file')->store('basedata', 'public');
          }

          if (isset($request->name)) {
              $params['name'] = $request->surname." ".$request->name_man." ".$request->surname2;
          }

          try {
              $user = User::create($params);
          } finally {
              $worker = new Worker();
              $worker->positions_work = isset($params['positions_work']) ? json_encode($params['positions_work']) : [];
              $worker->user_id = $user->id;
              $worker->comment = isset($params['comment']) ? $params['comment'] : null;
              $worker->save();
  
              /* Отказ от рефакторинга из-за сжатых сроков! Ларионов
               * if (is_array($params['positions_work']))
                  foreach ($params['positions_work'] as $it) {
                      $worker_job = new worker_jobs();
                      $worker_job->user_id = $user->id;
                      $worker_job->job_id = $it;
                      $worker_job->save();
                  }
              */
          }

          return redirect()->route('admin.basedata');

      }
  
      public function edit_bd(User $user) {

          $list_job_titles = Job_title::query()
              ->active()
              ->where('is_bd', '=' , '2')
              ->orderByDesc('sort')
              ->orderBy('name', 'asc')
              ->get();

          return view('admin.users.edit', compact('user', 'list_job_titles'));

      }
  
      public function update_bd(BaseUserRequest $request, User $user) {
          $params = $request->all();

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

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

          if (isset($request->name)) {
              $params['name'] = $request->surname." ".$request->name_man." ".$request->surname2;
          }

          try {
              $user->update($params);
  
          } finally {
              if (isset($user->workers[0]->id)) {
                  $worker = Worker::find($user->workers[0]->id);
                  $worker->positions_work = $positions_work;
                  $worker->comment = isset($params['comment']) ? $params['comment'] : null;
                  $worker->save();
              } else {
                  $worker = new Worker();
                  $worker->user_id = $user->id;
                  $worker->positions_work = $positions_work;
                  $worker->comment = isset($params['comment']) ? $params['comment'] : null;
                  $worker->save();
              }
              /*
               * Отказ от рефакторинга структуры БД из-за сжатых сроков сдачи. Ларионов.
               if (is_array($params['positions_work']))
                  foreach ($params['positions_work'] as $it) {
                      worker_jobs::updateOrCreate(
                          ['user_id' => $user->id],
                          ['job_id' => $it]
                      );
                  }
              */

          }

          return redirect()->route('admin.basedata');
      }
  
      public function destroy_bd(User $user) {
          $user->delete();
          return redirect()->route('admin.basedata');
      }

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

          $users = User::query()->Realuser()->paginate(15);

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

      }

      public function admin_roles(Request $request) {
  
          if ($request->ajax()) {

              $id = $request->id;
              $request->offsetUnset('id');
              ContentRoles::where('id', '=', $id)->update($request->all());

          }

          $roles = ContentRoles::query()->OrderBy('id')->paginate(25);

  
  
          if ($request->ajax()) {
             return view('admin.content.roles_index_ajax', compact('roles'));
          } else {
              return view('admin.content.roles_index', compact('roles'));
          }
      }

      public function doc_bd(User $user) {
          $id = $user->id;
          $spreadsheet = new Spreadsheet();
          $activeWorksheet = $spreadsheet->getActiveSheet();
          $activeWorksheet->setCellValue('A1', 'Отчет по соискателю');
          $activeWorksheet->getStyle('A1')->applyFromArray([
              'font' => [
                  'name' => 'Arial',
                  'bold' => true,
                  'italic' => false,
                  'underline' => Font::UNDERLINE_DOUBLE,
                  'strikethrough' => false,
                  'color' => [
                      'rgb' => '808080'
                  ]
              ],
              'borders' => [
                  'allBorders' => [
                      'borderStyle' => Border::BORDER_THIN,
                      'color' => [
                          'rgb' => '808080'
                      ]
                  ],

                  'outline' => array(
                      'style' => Border::BORDER_THIN,
                      'color' => array('rgb' => '000000')
                  ),

              ],

              'alignment' => [
                  'horizontal' => Alignment::HORIZONTAL_CENTER,
                  'vertical' => Alignment::VERTICAL_CENTER,
                  'wrapText' => true,
              ]
          ]);
  
          $activeWorksheet->setCellValue('A2', "Псевдоним/имя: ".$user->name);
          $activeWorksheet->setCellValue('A3', "Фамилия: ".$user->surname);
          $activeWorksheet->setCellValue('A4', "Имя: ".$user->name_man);
          $activeWorksheet->setCellValue('A5', "Отчество: ".$user->surname2);
          $activeWorksheet->setCellValue('A6', "Телефон: ".$user->telephone);
          $activeWorksheet->setCellValue('A7', "Емайл: ".$user->email);
  
          if (isset($user->workers[0]->id)) {
              $activeWorksheet->setCellValue('A9', "Анкета: ");
              $activeWorksheet->setCellValue('A10', "Телефон: " . $user->workers[0]->telephone);
              $activeWorksheet->setCellValue('A11', "Емайл: " . $user->workers[0]->email);
          }
  
          if (isset($user->jobtitles[0]->id)) {
              $activeWorksheet->setCellValue('A12', "Должность: " . $user->jobtitles[0]->name);
          }

          $activeWorksheet->getColumnDimension("A")->setWidth(100);

          $writer = new Xlsx($spreadsheet);
  
          header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
          header('Content-Disposition: attachment; filename="user'.$id.'.xlsx"');
          header('Cache-Control: no-cache');
  
          $writer->save('php://output');
          $writer->save(storage_path("app/public/export/user$id.xlsx"));
  
          //$spreadsheet->disconnectWorksheets();
          return redirect()->route('admin.basedata');
  
      }

  }