<?php

namespace App\Http\Controllers\Admin;

use App\Http\Controllers\Controller;
use App\Models\Static_worker;
use App\Models\User;
use App\Models\Worker;
use Illuminate\Http\Request;

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

        $users = User::where('is_worker', '1')->paginate(15);

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

    public function form_update_worker(Worker $worker) {
        return view('admin.worker.edit');
    }

    // кабинет - статистика работников
    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'));

    }

}