<?php

namespace App\Http\Controllers;

use DataTables;
use App\AcademySchedule;
use App\AcademySchedulesCoach;
use App\AcademyCategoriesSchedule;
use App\AcademyLocationUser;
use App\Http\Controllers\Exports\AcademyCoachsExport;
use App\User;
use Illuminate\Http\Request;
use App\Http\Controllers\UtilController;
use App\Services\AcademyLocationsService;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\DB;
use Maatwebsite\Excel\Facades\Excel;

class AcademyCoachController extends Controller
{
    private $__TRAINER_ROL = 14;
    private $util;

    public function __construct()
    {
        $this->util = new UtilController();
    }

    public function index()
    {
        return view('academy.coaches.list');
    }

    public function indexAdd()
    {
        $schedules = AcademySchedule::select('id', 'name')->with(
            'academy_schedules_coaches',
            'academy_schedules_coaches.user',
            'academy_categories_schedules',
            'academy_categories_schedules.academy_category',
            'academy_categories_schedules.academy_category.academy_location'
        )->where('active', 1)
            ->orderBy('name', 'ASC');

        $academyLocationsService = new AcademyLocationsService;
        if (!$academyLocationsService->validateAuthorizedLocations()) {
            $authorizedLocations = $academyLocationsService->getAuthorizedLocations();
            $schedules->whereHas('academy_categories_schedules.academy_category.academy_location', function ($query) use ($authorizedLocations) {
                $query->whereIn('academy_locations.id', $authorizedLocations);
            });
        }

        $schedules = $schedules->get();

        foreach ($schedules as $schedule) {
            $categories = '';
            $categoriesSchedule = AcademyCategoriesSchedule::select('academy_category_id')->with('academy_category', 'academy_category.academy_location')->where('academy_schedule_id', $schedule->id)->get();
            $results = array();
            foreach ($categoriesSchedule as $item) {
                $category = $item->academy_category->academy_location ? (config('app.location') . ' ' . $item->academy_category->academy_location->name . ', Categoría ' . $item->academy_category->name) : ('Categoría ' . $item->academy_category->name);
                $results[] = $category;
            }
            $categories = implode(', ', $results);
            $schedule->categories = $categories;
        }
        return view('academy.coaches.create', compact('schedules'));
    }

    public function indexEdit($id)
    {
        $object = User::with('academy_schedules_coaches')->findOrFail($id);
        $academy_schedules_coaches = array();
        foreach ($object->academy_schedules_coaches as $item) {
            $academy_schedules_coaches[] = $item->academy_schedule_id;
        }
        $object->assignedSchedules = $academy_schedules_coaches;

        $schedules = AcademySchedule::select('id', 'name')->with(
            'academy_schedules_coaches',
            'academy_schedules_coaches.user',
            'academy_categories_schedules',
            'academy_categories_schedules.academy_category',
            'academy_categories_schedules.academy_category.academy_location'
        )->where('active', 1)
            ->orderBy('name', 'ASC');

        $academyLocationsService = new AcademyLocationsService;
        if (!$academyLocationsService->validateAuthorizedLocations()) {
            $authorizedLocations = $academyLocationsService->getAuthorizedLocations();
            $schedules->whereHas('academy_categories_schedules.academy_category.academy_location', function ($query) use ($authorizedLocations) {
                $query->whereIn('academy_locations.id', $authorizedLocations);
            });
        }

        $schedules = $schedules->get();

        foreach ($schedules as $schedule) {
            $categories = '';
            $categoriesSchedule = AcademyCategoriesSchedule::select('academy_category_id')->with('academy_category', 'academy_category.academy_location')->where('academy_schedule_id', $schedule->id)->get();
            $results = array();
            foreach ($categoriesSchedule as $item) {
                $category = $item->academy_category->academy_location ? (config('app.location') . ' ' . $item->academy_category->academy_location->name . ', Categoría ' . $item->academy_category->name) : ('Categoría ' . $item->academy_category->name);
                $results[] = $category;
            }
            $categories = implode(', ', $results);
            $schedule->categories = $categories;
        }
        return view('academy.coaches.edit', compact('object', 'schedules'));
    }

    public function tableFilter()
    {
        $obj = $this->tableFilterQuery();

        \DB::enableQueryLog();
        $dataTable = DataTables::of($obj);
        $this->tableFilterCustomColumns($dataTable);


        $response = $dataTable->make(true);
        $data = $response->getData();
        $data = json_decode(json_encode($data), true);
        $queries = \DB::getQueryLog();
        $data['queries'] = $queries;
        return $data;
    }

    public function create(Request $request)
    {
        try {
            if (User::where('email', $request->input('email'))->first()) {
                return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.already_exists', ['name' => $request->input('tag')]), "data" => null));
            } else if (!$request->input('tags') || !count($request->input('tags'))) {
                return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.academy_schedules.required_select')));
            }
            $data = $request->except(['generalMultiselect', 'tags']);
            $data['rol_id'] = $this->__TRAINER_ROL;
            $userController = new OtherUsersController();
            $requestUser = new Request($data);
            $response = $userController->create($requestUser);
            if (!$response['r']) {
                return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => $response['m'], "data" => null));
            }
            $id = $response['d'];
            foreach ($request->input('tags') as $schedule) {
                $data = new AcademySchedulesCoach;
                $data->academy_schedule_id = $schedule;
                $data->user_id = $id;
                $data->save();
            }

            $academyLocationsService = new AcademyLocationsService;
            if (!$academyLocationsService->validateAuthorizedLocations()) {
                $authorizedLocations = $academyLocationsService->getAuthorizedLocations();
                foreach ($authorizedLocations as $location) {
                    $data = new AcademyLocationUser;
                    $data->academy_location_id = $location;
                    $data->user_id = $id;
                    $data->save();
                }
            }

            $this->registerLog(Auth::user()->id, 'Crear entrenador academia', json_encode($request->all()), "Create", $this->getModule($request));
            return response(array("r" => true, "type" => "success", "title" => "", "m" => __('messages.created_successfully'), "data" => $id));
        } catch (\Exception $e) {
            return response(
                array(
                    "r" => false,
                    "type" => "error",
                    "title" => "Oops...",
                    "m" => __($e->getMessage()),
                    "data" => null
                )
            );
        }
    }

    public function update(Request $request, $id)
    {
        try {
            $request['id'] = $id;
            if (User::where([['id', '!=', $id], ['email', $request->input('email')]])->first()) {
                return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.already_exists', ['name' => $request->input('email')]), "data" => null));
            } else if (!$request->input('tags') || !count($request->input('tags'))) {
                return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.academy_schedules.required_select')));
            }
            $data = $request->except(['generalMultiselect', 'tags']);
            if (!$data['password']) {
                $data = $request->except(['password', 'generalMultiselect', 'tags']);
            } else {
                $data['password'] = \Hash::make($data['password']);
            }

            if (User::where('id', $id)->update($data)) {
                AcademySchedulesCoach::where('user_id', $id)->delete();
                foreach ($request->input('tags') as $schedule) {
                    $data = new AcademySchedulesCoach();
                    $data->academy_schedule_id = $schedule;
                    $data->user_id = $id;
                    $data->save();
                }

                $academyLocationsService = new AcademyLocationsService;
                if (!$academyLocationsService->validateAuthorizedLocations()) {
                    AcademyLocationUser::where('user_id', $id)->delete();
                    $authorizedLocations = $academyLocationsService->getAuthorizedLocations();
                    foreach ($authorizedLocations as $location) {
                        $data = new AcademyLocationUser;
                        $data->academy_location_id = $location;
                        $data->user_id = $id;
                        $data->save();
                    }
                }

                $this->registerLog(Auth::user()->id, 'Actualizar entrenador academia', json_encode($request->all()), "Update", $this->getModule($request));
                return response(array("r" => true, "type" => "success", "title" => "", "m" => __('messages.updated_successfully'), "data" => $id));
            } else {
                return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.error_updating'), "data" => null));
            }
        } catch (\Exception $e) {
            return response(
                array(
                    "r" => false,
                    "type" => "error",
                    "title" => "Oops...",
                    "m" => __($e->getMessage()),
                    "data" => null
                )
            );
        }
    }

    public function delete(Request $request, $id)
    {
        try {
            $coach = User::find($id);
            if (User::where('id', $id)->delete()) {
                $this->registerLog(Auth::user()->id, 'Eliminar entrenador academia', json_encode($coach), "Delete", $this->getModule($request));
                return response(array("r" => true, "type" => "success", "title" => "", "m" => __('messages.deleted_successfully'), "data" => null));
            } else {
                return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.error_removing'), "data" => null));
            }
        } catch (\Illuminate\Database\QueryException $e) {
            return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.delete_relation_data'), "data" => null));
        }
    }

    public function activate(Request $request)
    {
        try {
            $id = $request['id'];
            $state = $request['state'];

            $coach = User::find($id);
            $coach->active = $state;
            $coach->update();

            $this->registerLog(Auth::user()->id, 'Activar/desactivar entrenador academia', json_encode($request->all()), "Update", $this->getModule($request));
            return array('r' => true, 'd' => null, 'm' => __('messages.updated_successfully'));
        } catch (\Throwable $th) {
            return array('r' => false, 'd' => null, 'm' => __('messages.error_updating'));
        }
    }

    public function validateExport(Request $request)
    {
        if ($request['query']) {
            $results = $this->util->getGenericData($request["query"], $request["bindings"]);
            if (count($results) > 0) {
                $name = 'ReporteEntrenadores' . time() . '.xlsx';
                Excel::store(new AcademyCoachsExport($results), $name, 'public');
                return response()->json(['success' => true, 'message' => 'Validación OK', 'data' => $name]);
            }
        }
        return response()->json(['success' => false, 'message' => 'No existen datos a exportar']);
    }

    public function export($name)
    {
        return $this->util->export($name);
    }

    private function tableFilterQuery()
    {
        DB::statement("SET sql_mode = ''");
        $obj = DB::table('users')
            ->select(
                'users.id',
                'users.first_name',
                'users.last_name',
                'users.email',
                'users.phone',
                'users.document',
                'users.created_at',
                'users.active',
                DB::raw('GROUP_CONCAT(DISTINCT(CONCAT(academy_schedules.name))) AS schedules'),
                DB::raw('GROUP_CONCAT(DISTINCT(CONCAT(academy_categories.name))) AS categories'),
                DB::raw('GROUP_CONCAT(DISTINCT(CONCAT(academy_locations.name))) AS locations'),
            )
            ->leftjoin('academy_schedules_coaches', 'academy_schedules_coaches.user_id', '=', 'users.id')
            ->leftjoin('academy_schedules', 'academy_schedules.id', '=', 'academy_schedules_coaches.academy_schedule_id')
            ->leftjoin('academy_categories_schedules', 'academy_categories_schedules.academy_schedule_id', '=', 'academy_schedules.id')
            ->leftjoin('academy_categories', 'academy_categories.id', '=', 'academy_categories_schedules.academy_category_id')
            ->leftjoin('academy_locations', 'academy_locations.id', '=', 'academy_categories.academy_location_id')
            ->where('users.rol_id', $this->__TRAINER_ROL)
            ->whereNull('users.deleted_at');

        $academyLocationsService = new AcademyLocationsService;
        if (!$academyLocationsService->validateAuthorizedLocations()) {
            $authorizedLocations = $academyLocationsService->getAuthorizedLocations();
            $obj->whereIn('academy_locations.id', $authorizedLocations);
        }

        $obj = $obj->groupBy('users.id');

        DB::statement("SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'");
        return $obj;
    }

    private function tableFilterCustomColumns($dataTable)
    {
        $dataTable->addColumn('actions', function ($obj) {
            return '
                <i class="fa fa-pencil iconMini" onClick="clickEdit(' . $obj->id . ')" data-id="' . $obj->id . '" title="Editar"></i>
                <i class="fa fa-trash iconMini" onClick="clickDelete(' . $obj->id . ')" data-id="' . $obj->id . '" title="Eliminar"></i>
            ';
        })
            ->editColumn('active', function ($obj) {
                if ($obj->active == 0) {
                    return '<div class="switch"><label><div class="checkbox checbox-switch switch-success"> <label> ' . __('messages.no') . ' <input type="checkbox" onChange="chk(' . $obj->id . ')" data-id="' . $obj->id . '" id="Checkactive' . $obj->id . '" name="Checkactivo" /> <span></span>' . __('messages.yes') . ' </label></div> </label> </div>';
                } else {
                    return '<div class="switch"><label> <div class="checkbox checbox-switch switch-success"> <label>   ' . __('messages.no') . ' <input type="checkbox" onChange="chk(' . $obj->id . ')" data-id="' . $obj->id . '" id="Checkactive' . $obj->id . '" name="Checkactivo" checked="" />
                    <span></span> ' . __('messages.yes') . ' </label> </div>  </label> </div>';
                }
            })
            ->editColumn('created_at', function ($obj) {
                return \Carbon\Carbon::parse($obj->created_at)->format('Y-m-d h:i:s A');
            })
            ->editColumn('schedules', function ($obj) {
                if ($obj->schedules) {
                    $schedules = explode(',', $obj->schedules);
                    $data = '';
                    foreach ($schedules as $schedule) {
                        $data .= ('<li>' . $schedule . '</li>');
                    }
                    return $data;
                }
                return '';
            })
            ->editColumn('categories', function ($obj) {
                if ($obj->categories) {
                    $categories = explode(',', $obj->categories);
                    $data = '';
                    foreach ($categories as $category) {
                        $data .= ('<li>' . $category . '</li>');
                    }
                    return $data;
                }
                return '';
            })
            ->editColumn('locations', function ($obj) {
                if ($obj->locations) {
                    $locations = explode(',', $obj->locations);
                    $data = '';
                    foreach ($locations as $location) {
                        $data .= ('<li>' . $location . '</li>');
                    }
                    return $data;
                }
                return '';
            })
            ->rawColumns(['actions', 'active', 'schedules', 'categories', 'locations']);
    }

    public function get(Request $request)
    {
        $query = User::select('users.id', 'users.first_name', 'users.last_name')
            ->where('users.active', 1)
            ->where('users.rol_id', $this->__TRAINER_ROL)
            ->whereNull('users.deleted_at');

        if ($request['categories'] || $request['locations']) {
            $query->join('academy_schedules_coaches', 'academy_schedules_coaches.user_id', '=', 'users.id')
                ->join('academy_categories_schedules', 'academy_categories_schedules.academy_schedule_id', '=', 'academy_schedules_coaches.academy_schedule_id');

            if ($request['categories']) {
                $query->whereIn('academy_categories_schedules.academy_category_id', $request['categories']);
            } else if ($request['locations']) {
                $query->join('academy_categories', 'academy_categories.id', '=', 'academy_categories_schedules.academy_category_id')
                    ->whereIn('academy_categories.academy_location_id', $request['locations']);
            }
        }

        return $query->groupBy('users.id', 'users.first_name', 'users.last_name')->get();
    }
}