<?php

namespace App\Http\Controllers\Admin;

use App\Http\Controllers\Controller;
use App\Models\Message;
use App\Models\User;
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() {
        $Msgs = Message::query()->orderByDesc('created_at')->paginate(25);

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

    public function admin_messages(Request $request) {
        $id_admin = Auth::user()->id;
        $users = User::query()->OrderBy('name')->get();

        $Msgs = Message::query()->where('user_id', '=', $id_admin)
                                ->orWhere('to_user_id', '=', $id_admin)
                                ->orderByDesc('created_at')->paginate(5);

        return view('admin.message.index', compact('Msgs', 'id_admin', 'users'));
    }

    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');
        }
    }
}