<?php

namespace App\Http\Controllers;

use DB;
use DataTables;
use App\Businesses;
use App\Address;
use App\BusinessCategory;
use App\Http\Controllers\Exports\BusinessExport;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Storage;
use App\Http\Controllers\UtilController;
use App\User;
use Illuminate\Support\Facades\Auth;
use Maatwebsite\Excel\Facades\Excel;

class BusinessController extends Controller
{
    private $util;
    private $ages;

    public function __construct()
    {
        $this->util = new UtilController();
        $this->ages = array(
            array(
                'id'    => '0-2',
                'name'  => 'De 0 a 2 años'
            ),
            array(
                'id'    => '2-5',
                'name'  => 'De 2 a 5 años'
            ),
            array(
                'id'    => '5+',
                'name'  => 'Más de 5 años'
            ),
        );
    }

    public function index()
    {
        $categoriesId   = Businesses::groupBy('category_id')->pluck('category_id');
        $categories     = BusinessCategory::select('id', 'name')->whereIn('id', $categoriesId)->where('active', true)->orderBy('name', 'ASC')->get();
        $ages           = Businesses::groupBy('age')->orderBy('age', 'ASC')->pluck('age');
        return view('business.list', compact('categories', 'ages'));
    }

    public function create()
    {
        $categories = BusinessCategory::select('id', 'name')->where('active', true)->orderBy('name', 'ASC')->get();
        $ages       = $this->ages;
        return view('business.create', compact('categories', 'ages'));
    }

    public function store(Request $request)
    {
        $userId = auth()->user()->id;
        $request['user_id'] = $userId;
        $this->validate($request, [
            'address' => 'required',
        ]);

        try {
            $address = new Address();
            $address->user_id = $userId;
            $address->direction = $request["address"];
            $address->lat = $request["address_lat"];
            $address->long = $request["address_lng"];
            $address->active = 1;
            $address->tag = 'business';
            $address->save();
            $request['address_id'] = $address->id;
            if ($business = Businesses::create($request->all())) {
                $this->registerLog(Auth::user()->id, 'Crear negocio', json_encode($request->all()), "Create", $this->getModule($request));
                return response(array("r" => true, "type" => "success", "title" => "", "m" => __('messages.created_successfully'), "data" => $business->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 edit($id)
    {
        $business   = Businesses::findOrFail($id);
        $categories = BusinessCategory::select('id', 'name')->where('active', true)->orderBy('name', 'ASC')->get();
        $address    = Address::where('id', $business->address_id)->with('user')->withTrashed()->first();
        $user       = User::withTrashed()->find($business->user_id);
        $ages       = $this->ages;
        return view('business.edit', compact('business', 'address', 'categories', 'ages', 'user'));
    }
    public function update(Request $request, $id)
    {
        $address = Address::find($request["address_id"]);
        $this->validate($request, [
            'address' => 'required',
        ]);

        try {
            $address->direction = $request["address"];
            $address->lat = $request["address_lat"];
            $address->long = $request["address_lng"];
            $address->user_id = $request["user_id"];
            $address->update();

            // Actualizar otros campos en la entidad Business
            $business = Businesses::find($id);

            if (!$business) {
                return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.not_found'), "data" => null));
            }

            if (!Businesses::where([['id', '!=', $id], ['name', $request->input('name')]])->first()) {
                $business->update(array_slice($request->except('image'), 1));
                $this->registerLog(Auth::user()->id, 'Editar negocio', json_encode($request->all()), "Update", $this->getModule($request));
                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.already_exists', ['name' => $request->input('name')]), "data" => null));
            }
        } catch (\Exception $e) {
            return response(
                array(
                    "r" => false,
                    "type" => "error",
                    "title" => "Oops...",
                    "m" => __($e->getMessage()),
                    "data" => null
                )
            );
        }
    }

    public function destroy(Request $request, $id)
    {
        $business = Businesses::find($id);
        try {
            if ($business) {
                Storage::disk('s3')->delete(config('s3.business') . $business->image);
                Businesses::where('id', $id)->delete();
                $this->registerLog(Auth::user()->id, 'Eliminar negocio', json_encode($business), "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 tableFilter(Request $request)
    {
        $categories = $request->categories;
        $ages = $request->ages;
        $from_date = $request->from_date;
        $to_date = $request->to_date;
        DB::statement("SET sql_mode = ''");
        $obj = $obj = DB::table('businesses')
            ->select(
                'businesses.id',
                'businesses.name',
                'businesses.image',
                'businesses.description',
                'businesses.phone',
                'businesses.age',
                'businesses.instagram',
                'businesses.facebook',
                'businesses.created_at',
                'businesses.approved',
                'businesses.active',
                DB::raw('CONCAT(addresses.direction, " ", COALESCE(addresses.district,"")) AS addressesClient'),
                'users.email AS emailClient',
                'business_categories.name AS category'
            )
            ->join('users', 'users.id', '=', 'businesses.user_id')
            ->join('addresses', 'addresses.id', '=', 'businesses.address_id')
            ->join('business_categories', 'business_categories.id', '=', 'businesses.category_id')
            ->groupBy('businesses.id');
        DB::statement("SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'");

        if (!is_null($categories)) {
            $obj->whereIn('businesses.category_id', $categories);
        }

        if (!is_null($ages)) {
            $ages = array_filter($ages, function ($item) {
                return $item !== null;
            });
            if (count($ages)) {
                $obj->whereIn('businesses.age', $ages);
            }
        }
        if (!is_null($from_date)) {
            $obj->whereDate('businesses.created_at', '>=', $from_date);
        }

        if (!is_null($to_date)) {
            $obj->whereDate('businesses.created_at', '<=', $to_date);
        }

        \DB::enableQueryLog();
        $dataTable = 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('image', function ($obj) {
                if (!$obj->image) {
                    return $this->util->generateEmptyImageColumn();
                } else {
                    return $this->util->generateImageColumn(config('filesystems.disks.s3.url') . '/business/' . $obj->image, $obj->name, 'logo' . $obj->id);
                }
            })
            ->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('approved', function ($obj) {
                if ($obj->approved == 0) {
                    return '<div class="switch"><label><div class="checkbox checbox-switch switch-success"> <label> ' . __('messages.no') . ' <input type="checkbox" onChange="chkApprove(' . $obj->id . ')" data-id="' . $obj->id . '" id="CheckactivoApprove' . $obj->id . '" name="CheckactivoApprove" /> <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="chkApprove(' . $obj->id . ')" data-id="' . $obj->id . '" id="CheckactivoApprove' . $obj->id . '" name="CheckactivoApprove" 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', 'image', 'active', 'approved']);

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

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

            $business = Businesses::find($id);
            $business->approved = $state;
            $business->update();

            $this->registerLog(Auth::user()->id, 'Aprobar/Desaprobar negocio', json_encode($business), "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 activate(Request $request)
    {
        try {
            $id     = $request['id'];
            $state  = $request['state'];

            $business = Businesses::find($id);
            $business->active = $state;
            $business->update();

            $this->registerLog(Auth::user()->id, 'Activar/Desactivar negocio', json_encode($business), "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 saveImage(Request $request)
    {
        try {
            $extension = $request->file('image')->getClientOriginalExtension();
            $filenametostore = $request->id . '.' . $extension;

            Storage::disk('s3')->put(config('s3.business') . $filenametostore, fopen($request->file('image'), 'r+'), 'public');

            $business_image = Businesses::find($request->id);
            $business_image->image = $filenametostore;
            $business_image->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 autocompleteCategory(Request $request)
    {
        $term = $request->input('term');
        $results = array();

        $queries = DB::table('business_categories')
            ->where('name', 'LIKE', '%' . $term . '%')
            ->where('active', 1)->get();

        foreach ($queries as $query) {
            $results[] = [
                'id' => $query->id,
                'name' => $query->name,
                'value' => $query->name,
            ];
        }
        return json_encode($results);
    }

    public function validateExport(Request $request)
    {
        if ($request['query']) {
            $results = $this->util->getGenericData($request["query"], $request["bindings"]);
            if (count($results) > 0) {
                $name = 'ReporteNegocios' . time() . '.xlsx';
                Excel::store(new BusinessExport($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);
    }
}