<?php

namespace App\Http\Controllers;

use DataTables;
use App\Tournament;
use App\TournamentOrganizer;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Storage;
use App\Http\Controllers\UtilController;

class TournamentsController extends Controller
{
    private $util;

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

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

    public function create()
    {
        $tournamentOrganizers = TournamentOrganizer::where('active', true)->orderByRaw("CASE WHEN display_name IS NULL THEN 0 ELSE 1 END ASC")->orderBy('name', 'ASC')->get();
        return view('tournaments.create', compact('tournamentOrganizers'));
    }

    public function store(Request $request)
    {
        if (!Tournament::where('name', $request->input('name'))->first()) {
            if ($tournament = Tournament::create($request->except('logo'))) {
                return response(array("r" => true, "type" => "success", "title" => "", "m" => __('messages.created_successfully'), "data" => $tournament->id));
            } else {
                return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.error_creating'), "data" => null));
            }
        } else {
            return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.already_exists', ['name' => $request->input('name')]), "data" => null));
        }
    }

    public function show($id)
    {
        return redirect()->back();
    }

    public function edit($id)
    {
        $tournament = Tournament::findOrFail($id);
        $tournamentOrganizers = TournamentOrganizer::where('active', true)->orderByRaw("CASE WHEN display_name IS NULL THEN 0 ELSE 1 END ASC")->orderBy('name', 'ASC')->get();
        return view('tournaments.edit', compact('tournament', 'tournamentOrganizers'));
    }

    public function update(Request $request, $id)
    {
        if (!Tournament::where([['id', '!=', $id], ['name', $request->input('name')]])->first()) {
            if (Tournament::where('id', $id)->update(array_slice($request->except('logo'), 1))) {
                return response(array("r" => true, "type" => "success", "title" => "", "m" => __('messages.updated_successfully'), "data" => null));
            } else {
                return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.error_updating'), "data" => null));
            }
        } else {
            return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.already_exists', ['name' => $request->input('name')]), "data" => null));
        }
    }

    public function destroy($id)
    {
        try {
            if (Tournament::where('id', $id)->delete()) {
                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 tableFilter()
    {
        $obj = Tournament::select('id', 'name', 'logo', 'footer_sponsors', 'ticket_background', 'active');

        return DataTables::of($obj)
            ->addColumn('actions', function ($obj) {
                if ($this->validateRolePermissions('ticketing', 'administrator') || $this->validateRolePermissions('ticketing', 'supervisor'))
                    return '
                            <i class="fa fa-table iconMini" onClick="goToSeasons(' . $obj->id . ')" data-id="' . $obj->id . '" title="Temporadas"></i>
                            <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>
                            ';
                else if ($this->validateRolePermissions('ticketing', 'seller'))
                    return '<i class="fa fa-table iconMini" onClick="goToSeasons(' . $obj->id . ')" data-id="' . $obj->id . '" title="Temporadas"></i>';
                else
                    return '';
            })
            ->editColumn('logo', function ($obj) {
                if (!$obj->logo) {
                    return $this->util->generateEmptyImageColumn();
                } else {
                    return $this->util->generateImageColumn(config('filesystems.disks.s3.url') . '/tournaments/' . $obj->logo, 'Logo - ' . $obj->name, 'logo' . $obj->id);
                }
            })
            ->editColumn('footer_sponsors', function ($obj) {
                if (!$obj->footer_sponsors) {
                    return $this->util->generateEmptyImageColumn();
                } else {
                    return $this->util->generateImageColumnLarge(config('filesystems.disks.s3.url') . '/tournaments/' . $obj->footer_sponsors, 'Patrocinador - ' . $obj->name, 'footer' . $obj->id);
                }
            })
            ->editColumn('ticket_background', function ($obj) {
                if (!$obj->ticket_background) {
                    return $this->util->generateEmptyImageColumn();
                } else {
                    return $this->util->generateImageColumn(config('filesystems.disks.s3.url') . '/tournaments/' . $obj->ticket_background, 'Fondo - ' . $obj->name, 'background' . $obj->id);
                }
            })
            ->editColumn('active', function ($obj) {
                if ($this->validateRolePermissions('ticketing', 'administrator') || $this->validateRolePermissions('ticketing', 'supervisor'))
                    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>';
                    }
                else
                    return $obj->active ? 'SI' : 'NO';
            })
            ->rawColumns(['active', 'actions', 'logo', 'footer_sponsors', 'ticket_background'])
            ->make(true);
    }

    public function saveImage(Request $request)
    {
        try {
            if ($request->hasFile('logo')) {
                $extension = $request->file('logo')->getClientOriginalExtension();
                $filenametostore = $request->id . '.' . $extension;
            }
            if ($request->hasFile('ticket_background')) {
                $extension_background = $request->file('ticket_background')->getClientOriginalExtension();
                $filenametostore_background = $request->id . '_background.' . $extension_background;
            }
            if ($request->hasFile('footer_sponsors')) {
                $extension_footer = $request->file('footer_sponsors')->getClientOriginalExtension();
                $filenametostore_footer = $request->id . '_footer.' . $extension_footer;
            }


            if (isset($filenametostore)) {
                Storage::disk('s3')->put(config('s3.tournaments') . $filenametostore, fopen($request->file('logo'), 'r+'), 'public');
            };
            if (isset($filenametostore_background)) {
                Storage::disk('s3')->put(config('s3.tournaments') . $filenametostore_background, fopen($request->file('ticket_background'), 'r+'), 'public');
            };
            if (isset($filenametostore_footer)) {
                Storage::disk('s3')->put(config('s3.tournaments') . $filenametostore_footer, fopen($request->file('footer_sponsors'), 'r+'), 'public');
            };

            $tournament = Tournament::find($request->id);
            if (isset($filenametostore)) {
                $tournament->logo = $filenametostore;
            };
            if (isset($filenametostore_background)) {
                $tournament->ticket_background = $filenametostore_background;
            };
            if (isset($filenametostore_footer)) {
                $tournament->footer_sponsors = $filenametostore_footer;
            };
            $tournament->update();

            return response(array("r" => true, "type" => "success", "title" => "", "m" => __('messages.updated_successfully'), "data" => null));
        } catch (\Throwable $th) {
            return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.error_updating'), "data" => $th->getMessage()));
        }
    }

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

            $tournament = Tournament::find($id);
            $tournament->active = $state;
            $tournament->update();

            return array('r' => true, 'd' => null, 'm' => __('messages.updated_successfully'));
        } catch (\Throwable $th) {
            return array('r' => false, 'd' => null, 'm' => __('messages.error_updating'));
        }
    }
}