<?php

namespace App\Http\Controllers;

use App\Models\User;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Hash;

class ClassroomController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $data['mainSuperAdminMenu'] = 'AdminUser';
        $data['superadminSubMenu'] = 'classroomList';
        if (isset($_GET['query']) && strlen($_GET['query']) > 1) {
            $search_text = $_GET['query'];

            $data['users'] = DB::table('users')->select('users.*', 'users_classroom_tb.created as date')
                ->Join('users_classroom_tb', 'users_classroom_tb.user_unique_id', '=', 'users.user_unique_id')
                ->where('users.user_unique_id', 'LIKE', '%' . $search_text . '%')
                ->orwhere('users.phone', 'LIKE', '%' . $search_text . '%')
                ->orwhere('users.email', 'LIKE', '%' . $search_text . '%')
                ->orderBy('users.id', 'desc')
                ->paginate(10);
            return view('superadmin.classroom.list', $data);
        } else {
            $data['users'] = DB::table('users')->select('users.*', 'users_classroom_tb.created as date')->Join('users_classroom_tb', 'users_classroom_tb.user_unique_id', '=', 'users.user_unique_id')->orderBy('users.id', 'desc')->paginate(10);
            return view('superadmin.classroom.list', $data);
        }
    }
    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function add()
    {
        $data['mainSuperAdminMenu'] = 'AdminUser';
        $data['superadminSubMenu'] = 'classroomList';
        $data['users'] = User::where(['status' => '1'])->orderBy('name', 'asc')->get();
        return view('superadmin.classroom.map', $data);
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function map(Request $request)
    {
        $admin_id = $request->session()->get('loggedIn')['id'];
        $request->validate([
            'user_unique_id' => 'required'
        ]);

        $data = array(
            'admin_id' => $admin_id,
            'user_unique_id' => $request->user_unique_id
        );

        $checkInClassroom = DB::table('users_classroom_tb')->where('user_unique_id', $request->user_unique_id)->first();
        if (empty($checkInClassroom)) {
            DB::table('users_classroom_tb')->insert($data);
            return back()
                ->with('success', 'User ID Added Successfully!.');
        }
        return back()
            ->with('warning', 'User ID already added!.');
    }

    public function delete(Request $request, $user_unique_id)
    {
        if (!empty($user_unique_id)) {

            $checkInClassroom = DB::table('users_classroom_tb')->where('user_unique_id', $user_unique_id)->delete();
            if ($checkInClassroom) {
                return back()
                    ->with('success', 'User ID deleted from classroom successfully!.');
            }
            return back()
                ->with('warning', 'User ID not found in Classroom!.');
        }
        return back()
            ->with('warning', 'User ID Required!.');
    }
}