<?php

namespace App\Http\Controllers;

use DB;
use Datatables;
use Mapper;
use \Excel;
use App\City;
use App\Coverage;
use App\Parameter;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use App\Http\Controllers\Exports\ExportCoverage;
use App\Http\Controllers\Imports\ImportCoverage;



class CoverageController extends Controller
{
    public function index()
    {
        // $rol = Auth::user()->rol->id;
        // if ($rol == 1 || $rol == 6) {
        $coverages = Coverage::all();
        return view('coverages.coverages')->with('coverages', $coverages);
        // } else {
        //     return redirect()->back();
        // }
    }

    public function indexPending()
    {
        // $rol = Auth::user()->rol->id;
        // if ($rol == 1 ||  $rol == 6) {
        return view('coverages_pending.coverages_pending');
        // } else {
        //     return redirect()->back();
        // }
    }

    public function create()
    {
        $lat = Auth::user()->userInfo->sucursal->address->lat;
        $long = Auth::user()->userInfo->sucursal->address->long;
        $cities = City::where('active', true)->orderBy('name', 'ASC')->get();
        $parameters = Parameter::first();

        Mapper::map($lat, $long, [
            'zoom' => 15,
            'markers' => [
                'title' => Auth::user()->userInfo->sucursal->name,
                'animation' => 'DROP'
            ],
            'eventBeforeLoad' => 'initMapa(map);'
        ]);

        return view('coverages.addCoverages')
            ->with('cities', $cities)
            ->with('parameters', $parameters);
    }

    public function store(Request $request)
    {
        $obj = new Coverage;

        $obj->name = $request->name;
        $obj->cost_delivery = $request->cost_delivery;
        $obj->city_id = $request->city_id;
        $obj->coords = base64_encode(serialize($request->coords));

        $obj->save();

        $res[] = array('message' => 'Se ha creado la cobertura correctamente');
        $dres = json_encode($res);
        return json_decode($dres, true);
    }

    public function edit(Request $request)
    {
        $lat = Auth::user()->userInfo->sucursal->address->lat;
        $long = Auth::user()->userInfo->sucursal->address->long;
        $cities = City::where('active', true)->orderBy('name', 'ASC')->get();
        $parameters = Parameter::first();

        Mapper::map($lat, $long, [
            'zoom' => 15,
            'markers' => [
                'title' => Auth::user()->userInfo->sucursal->name,
                'animation' => 'DROP'
            ],
            'clusters' => [
                'size' => 10,
                'center' => true, 'zoom' => 20
            ],
            'eventBeforeLoad' => 'initMapa(map);'
        ]);

        $obj = Coverage::find($request->id);
        $coords = unserialize(base64_decode($obj->coords));
        $res = array('id' => $obj->id, 'name' => $obj->name, 'cost_delivery' => $obj->cost_delivery, 'coords' => base64_encode(json_encode($coords)), 'city_id' => $obj->city_id);

        return view('coverages.editCoverages')
            ->with('obj', $res)
            ->with('cities', $cities)
            ->with('parameters', $parameters);
    }

    public function update(Request $request)
    {
        $obj = Coverage::find($request->id);
        $obj->name = $request->name;
        $obj->cost_delivery = $request->cost_delivery;
        $obj->city_id = $request->city_id;
        $obj->coords = base64_encode(serialize($request->coords));

        $obj->save();

        $res[] = array('message' => 'Se ha modificado la cobertura correctamente');
        $dres = json_encode($res);
        return json_decode($dres, true);
    }

    public function getAll()
    {
        $coberturas = Coverage::join('sucursal', 'cobertura.id', '=', 'cobertura_id')->get();
        foreach ($coberturas as $key => $cobertura) {
            $cobertura->coords = unserialize(base64_decode($cobertura->coords));
        }

        $res[] = array('respuesta' => true, 'coberturas' => $coberturas);
        $dres = json_encode($res);
        return json_decode($dres, true);
    }

    public function stateCoverage(Request $request)
    {

        $id = $request['id'];
        $state = $request['state'];

        $coverage = Coverage::find($id);
        $coverage->active = $state;
        $coverage->save();

        return array('r' => true);
    }

    /**
     * Método para eliminar una cobertura
     * @param request[id] id de la cobertura
     * @param request[eliminar] (1) valor para indicar eliminado
     */
    public function eliminarCobertura(Request $request)
    {
        $id = $request['id'];
        $eliminar = $request['eliminar'];

        $cobertura = Coverage::where('id', '=', $id)->first();
        $cobertura->eliminar = $eliminar;
        $cobertura->save();

        $res[] = array('respuesta' => true);
        $dres = json_encode($res);
        return json_decode($dres, true);
    }

    public function tableFilter()
    {
        $obj = $obj = DB::table('coverages')
            ->select('coverages.id', 'coverages.name', 'coverages.cost_delivery', 'coverages.active')->whereNull('coverages.deleted_at');

        return Datatables::of($obj)
            ->addColumn('actions', function ($obj) {
                return '<i class="fa fa-pencil iconMini" onClick="editCoverage(' . $obj->id . ')" data-id="' . $obj->id . '"  title="Editar"></i>
            <i class="fa fa-trash iconMini" onClick="deleteCoverage(' . $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> No <input type="checkbox" onChange="chkCoverage(' . $obj->id . ')" data-id="' . $obj->id . '" id="Checkactive' . $obj->id . '" name="Checkactivo" /> <span></span>Si </label></div> </label> </div>';
                } else {
                    return '<div class="switch"><label> <div class="checkbox checbox-switch switch-success"> <label>   No <input type="checkbox" onChange="chkCoverage(' . $obj->id . ')" data-id="' . $obj->id . '" id="Checkactive' . $obj->id . '" name="Checkactivo" checked="" />
                <span></span> Si </label> </div>  </label> </div>';
                }
            })
            ->rawColumns(['active', 'actions'])
            ->make(true);
    }

    public function tableFilterP()
    {
        $obj = $obj = DB::table('coverage_pendings')
            ->join('cities', 'cities.id', '=', 'coverage_pendings.city_id')
            ->select('coverage_pendings.id', 'coverage_pendings.email', 'coverage_pendings.created_at', 'cities.name as city');

        return Datatables::of($obj)->make(true);
    }

    public function importCoverages(Request $request)
    {
        try {
            $file = new ImportCoverage;
            $file->request = $request;
            Excel::import($file, $request->archivo);
            return array('r' => true, 'd' => $file->answer, 'm' => trans('messages.screen_products_tag45') . ' ' . $file->edit['creados'] . ' creados.');
        } catch (\Exception $e) {
            return array('r' => false, 'd' => null, 'm' => trans('messages.screen_products_tag46') . $request->name_file . "  " . $e->getMessage());
        }
    }

    public function reportCoveragesAll()
    {
        return Excel::download(new ExportCoverage, trans('messages.coverages.title_2') . '.xlsx');
    }

    public function deleteCoverages()
    {
        try {
            DB::statement('SET FOREIGN_KEY_CHECKS=0;');
            Coverage::truncate();
            DB::statement('SET FOREIGN_KEY_CHECKS=1;');            
            return response(array("r" => true, "type" => "error", "title" => "Oops...", "m" => __('messages.deleted_successfully'), "data" => null));
        } catch (\Throwable $th) {
            return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.error_global'), "data" => $th->getMessage()));
        }
    }

}