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

  use App\Models\Category;

  use App\Models\Job_title;

  use App\Models\Positions;

  use Illuminate\Http\Request;
  
  class JobTitlesController extends Controller
  {
      /**
       * Display a listing of the resource.
       *
       * @return \Illuminate\Http\Response
       */

      public function index(Request $request)

      {

          if ($request->has('sort')) {

              $Jobs = Job_title::query()
                  ->where('is_remove', '0');
  
              if ($request->get('sort') == 'up') {

                  $Jobs = $Jobs->orderBy('sort')->orderBy('name')->paginate(15);

              } else {

                  $Jobs = $Jobs->orderByDesc('sort')->orderBy('name')->paginate(15);

              }

          } else {

              $Jobs = Job_title::query()->where('is_remove', '0')->

              orderByDesc('sort')->orderBy('name')->paginate(15);
          }

          return view('admin.job_titles.index', compact('Jobs'));
      }
  
      /**
       * Show the form for creating a new resource.
       *
       * @return \Illuminate\Http\Response
       */
      public function create()
      {
          /*$items = Job_title::query()->
                       orderByDesc('sort')->
                       orderBy('name')->
                       active()->
                       get();*/

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

          return view('admin.job_titles.add', compact('category'));

      }
  
      /**
       * Store a newly created resource in storage.
       *
       * @param  \Illuminate\Http\Request  $request
       * @return \Illuminate\Http\Response
       */
      public function store(JobTitlesRequest $request)
      {
          Job_title::create($request->all());
          return redirect()->route('admin.job-titles.index');
      }
  
      /**
       * Display the specified resource.
       *
       * @param  \App\Models\Job_title  $job_title
       * @return \Illuminate\Http\Response
       */
      public function show(Job_title $job_title)
      {
          //
      }
  
      /**
       * Show the form for editing the specified resource.
       *
       * @param  \App\Models\Job_title  $job_title
       * @return \Illuminate\Http\Response
       */
      public function edit(Job_title $job_title)
      {

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

          return view('admin.job_titles.edit', compact('job_title', 'category'));

      }
  
      /**
       * Update the specified resource in storage.
       *
       * @param  \Illuminate\Http\Request  $request
       * @param  \App\Models\Job_title  $job_title
       * @return \Illuminate\Http\Response
       */
      public function update(JobTitlesRequest $request, Job_title $job_title)
      {
          $job_title->update($request->all());
          return redirect()->route('admin.job-titles.index');
      }
  
      /**
       * Remove the specified resource from storage.
       *
       * @param  \App\Models\Job_title  $job_title
       * @return \Illuminate\Http\Response
       */
      public function destroy(Job_title $job_title)
      {
          $job_title->update(['is_remove' => 1]);
          return redirect()->route('admin.job-titles.index');
      }
  }