<?php

namespace App\Http\Controllers;

use DataTables;
use App\Term;
use App\TermClient;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\Cache;
use Illuminate\Support\Facades\Storage;

class TermConditionController extends Controller
{
    public function index()
    {
        return view('terms_conditions.list');
    }

    public function indexAdd()
    {
        $types = ['app', 'web'];
        return view('terms_conditions.create', compact('types'));
    }

    public function indexEdit($id)
    {
        $object = Term::findOrFail($id);
        $types = ['app', 'web'];
        return view('terms_conditions.edit', compact('object', 'types'));
    }

    public function tableFilter()
    {
        $obj = Term::select('id', 'url', 'version', 'active', 'created_at', 'type')->get();

        return DataTables::of($obj)
            ->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');
            })
            ->rawColumns(['actions', 'active'])
            ->make(true);
    }

    public function create(Request $request)
    {
        try {
            if (Term::where('version', $request->input('version'))->first()) {
                return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.already_exists', ['name' => $request->input('version')]), "data" => null));
            }
            $data = $request->all();
            if ($model = Term::create($data)) {
                Cache::forget('terms');
                $this->registerLog(Auth::user()->id, 'Crear términos y condiciones', json_encode($request->all()), "Create", $this->getModule($request));
                return response(array("r" => true, "type" => "success", "title" => "", "m" => __('messages.created_successfully'), "data" => $model->id));
            } else {
                return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.error_creating'), "data" => null));
            }
        } 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 (Term::where([['id', '!=', $id], ['version', $request->input('version')]])->first()) {
                return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.already_exists', ['name' => $request->input('version')]), "data" => null));
            }
            $data = $request->all();
            if (Term::where('id', $id)->update($data)) {
                Cache::forget('terms');
                $this->registerLog(Auth::user()->id, 'Editar términos y condiciones', 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 {
            $term = Term::find($id);
            if (Term::where('id', $id)->delete()) {
                Cache::forget('terms');
                $this->registerLog(Auth::user()->id, 'Eliminar términos y condiciones', json_encode($term), "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)
    {
        $termType = Term::find($request['id'])->type;
        try {
            $id = $request['id'];
            $state = $request['state'];
            if ($state && $termType == 'app') {
                $activeTerms = Term::where('active', true)
                    ->where('type', 'app')
                    ->count();
                if ($activeTerms) {
                    return array('r' => false, 'm' => __('messages.terms_conditions.error_active'));
                }
            }

            $term = Term::find($id);
            $term->active = $state;
            $term->update();
            Cache::forget('terms');

            $this->registerLog(Auth::user()->id, 'Activar/Desactivar términos y condiciones', json_encode($term), "Update", $this->getModule($request));
            return array('r' => true, 'm' => __('messages.updated_successfully'));
        } catch (\Throwable $th) {
            return array('r' => false, 'm' => __('messages.error_updating'));
        }
    }

    public function saveDocument(Request $request)
    {
        try {
            $extension = $this->extension($request->file('image')->getMimeType());
            if ($extension != 'pdf') {
                return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.error_file_pdf')));
            }
            $filenametostore = 'terminos_y_condiciones' . $request->id . '.' . $extension;

            Storage::disk('s3')->put(config('s3.default') . '/public/' . $filenametostore, fopen($request->file('image'), 'r+'), 'public');
            $url = config('filesystems.disks.s3.url') . '/public/' . $filenametostore;
            Term::where('id', $request->id)->update(['url' => $url]);
            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 getTermsActive()
    {
        if (!Cache::get('terms')) {
            $terms = Term::select('id', 'version', 'url', 'active')->where("active", 1)->where("type", "app")->orderBy('created_at', 'DESC')->first();
            Cache::put('terms', $terms, config('cache.time'));
        } else {
            $terms = Cache::get('terms');
        }
        return $terms;
    }

    public function validateTerms()
    {
        $userId = Auth::user()->id;
        $result = Term::select('terms.id', 'terms.version', 'terms.url')
            ->leftJoin('term_clients as tc', function ($join) use ($userId) {
                $join->on('tc.term_id', '=', 'terms.id')
                    ->where('tc.user_id', '=', $userId);
            })
            ->whereNull('terms.deleted_at')
            ->where('terms.active', true)
            ->whereNull('tc.id')
            ->where('terms.type', 'app')
            ->orderBy('terms.created_at', 'DESC')
            ->limit(1);

        $result = $result->get();
        return $result;
    }

    public function acceptTerms(Request $request)
    {
        $userId = Auth::user()->id;
        TermClient::updateOrCreate([
            'accepted'  => $request['accepted'] ?? true,
            'term_id'   => $request['id'] ?? $request['termId'],
            'user_id'   => $request['userId'] ?? $userId,
        ]);
        return array('r' => true, 'm' => __('messages.terms_conditions.accepted'));
    }

    public function view($id)
    {
        $term = Term::withTrashed()->find($id);
        return view('terms_conditions.view', compact('term'));
    }
}