<?php

namespace App\Http\Controllers\Admin;

use App\Http\Controllers\Controller;
use App\Models\Message;
use App\Models\User;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Validator;

class MsgAnswersController extends Controller
{
    public function messages(Request $request) {
        $find_key = "";
        $find_cat = "";
        $Msgs = Message::with('user_from')->with('user_to'); //->with('response');

        $Msgs = $this->filter($Msgs, $request, $find_key, $find_cat);

        $Msgs = $Msgs->orderByDesc('created_at')->paginate(25);

        return view('admin.messages', compact('Msgs', 'find_key', 'find_cat'));
    }

    public function read_message(Message $message) {
        return view('admin.message-read', compact('message'));
    }

    public function filter($Msgs, Request $request, &$find_key, &$find_cat)  {
        if (isset($request->find)) {
            $find_key = $request->find;
            $Msgs = $Msgs->where(function($q) use ($find_key) {
                $q->whereHas('user_from',
                    function (Builder $query) use ($find_key) {
                        $query->where('name', 'LIKE', "%$find_key%");
                    }
                )->
                orWhereHas('user_to',
                    function (Builder $query) use ($find_key) {
                        $query->where('name', 'LIKE', "%$find_key%");
                    }
                );
            });
        }

        if (isset($request->category)) {
            $find_cat = $request->category;

            switch ($find_cat) {
                case 'Работодатели':
                    $Msgs = $Msgs->where(function($q) {
                        $q->whereHas('user_to',
                            function (Builder $query) {
                                $query->where('is_worker', '0');
                            }
                        )->orwhereHas('user_from',
                            function (Builder $query) {
                                $query->where('is_worker', '0');
                            }
                        );
                    });
                    break;
                case 'Соискатели':
                    $Msgs = $Msgs->where(function($q) {
                        $q->whereHas('user_to',
                            function (Builder $query) {
                                $query->where('is_worker', '1');
                            }
                        )->orwhereHas('user_from',
                            function (Builder $query) {
                                $query->where('is_worker', '1');
                            }
                        );
                    });
                    break;
                case 'Администраторы':
                    $Msgs = $Msgs->where(function($q) {
                        $q->whereHas('user_to',
                            function (Builder $query) {
                                $query->where('admin', '1');
                            }
                        )->orwhereHas('user_from',
                            function (Builder $query) {
                                $query->where('admin', '1');
                            }
                        );
                    });
                    break;
                default:break;
            }
        }

        return $Msgs;

    }

    public function admin_messages(Request $request) {
        if ($request->ajax()) {
            $msg = Message::find($request->id);
            $msg->flag_new = !($request->flag_new);
            $msg->save();
        }

        $id_admin = Auth::user()->id;
        $users = User::query()->OrderBy('name')->where('is_bd', '=', '0')->get();

        $Msgs = Message::with('user_from')->with('user_to')->with('response')
                                ->where(function($query) use ($id_admin) {
                                    $query->where('user_id', '=', $id_admin)
                                        ->orWhere('to_user_id', '=', $id_admin);
                                });

        $find_key = '';
        $find_cat = '';

        $Msgs = $this->filter($Msgs, $request, $find_key, $find_cat);

        $Msgs = $Msgs->orderByDesc('created_at')->paginate(5);

        if ($request->ajax())
            return view('admin.message.index_ajax', compact('Msgs', 'id_admin', 'users'));
        else
            return view('admin.message.index', compact('Msgs', 'id_admin', 'users', 'find_key', 'find_cat'));
    }

    public function messages_sql(Request $request) {
        $id = Auth::user()->id;
        DB::enableQueryLog();
        //$query = DB::select('select * from users where id = :id', ['id' => 1]);
        $query = DB::select(DB::raw('SELECT u1.name as "To-user", u2.name as "From-user", m1.`text`, m1.created_at
                                    FROM messages m1
                                    JOIN (SELECT MAX(id) id FROM messages
                                              GROUP BY LEAST(user_id, to_user_id),
                                              GREATEST(user_id, to_user_id)
                                        ) m2 USING (id)
                                    JOIN users u1 ON u1.id = m1.user_id
                                    JOIN users u2 ON u2.id = m1.to_user_id
                                    Where ((m1.user_id = :uid) or (m1.to_user_id = :uid2))
                                    '), ['uid' => $id, 'uid2' => $id]);
        //dump(DB::getQueryLog());
        dd($query);
        return;
    }

    public function admin_messages_post(Request $request) {
        $rules = [
            'title' => 'required|min:3|max:255',
            'text' => 'required|min:1'
            ];

        $messages = [
            'required' => 'Поле не может быть пустым!',
        ];

        $validator = Validator::make($request->all(), $rules, $messages);

        if ($validator->fails()) {
            return redirect()->route('admin.admin-messages')->withErrors($validator);
        } else {
            $params = $request->all();
            $id_admin = Auth::user()->id;
            if ($request->has('file')) {
                $params['file'] = $request->file('file')->store("upload/".$id_admin, 'public');
            }
            Message::create($params);
            return  redirect()->route('admin.admin-messages');
        }
    }
}