<?php

namespace App\Http\Controllers;

use DB;
use DataTables;
use Illuminate\Http\Request;
use App\MainDatasource;
use App\ManualDatasource;
use Illuminate\Support\Collection;

class MainDatasourcesController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        return view('mainDatasources.list');
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        return view('mainDatasources.create');
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        if (!MainDatasource::where('name', $request->input('name'))->first()) {
            if ($input = MainDatasource::create(array_slice($request->all(), 1))) {
                $list_manual = $request->input('list_manual');
                foreach ($list_manual as $item) {
                    ManualDatasource::create([
                        "value" => $item,
                        "main_datasource_id" => $input->id
                    ]);
                }
                return response(array("r" => true, "type" => "success", "title" => "", "m" => __('messages.created_successfully'), "data" => null));
            } 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));
        }
    }

    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
        return redirect()->back();
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        $main = MainDatasource::with('manual_datasources')->findOrFail($id);
        if ($main) {
            return view('mainDatasources.edit', compact('main'));
        } else {
            return redirect()->back();
        }
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        if (!MainDatasource::where([['id', '!=', $id], ['name', $request->input('name')]])->first()) {
            if (MainDatasource::where('id', $id)->update(array_slice($request->all(), 2))) {
                $list_manual = $request->input('list_manual');
                $current_manual = ManualDatasource::where('main_datasource_id', $id)->get();
                $delete_items = $current_manual->pluck('value')->diff($list_manual);
                $intersect = new Collection($list_manual);
                $create_items = $intersect->diff($current_manual->pluck('value'));
                foreach ($delete_items as $item) {
                    ManualDatasource::where([
                        ["value", $item],
                        ["main_datasource_id", $id]
                    ])->delete();
                }
                foreach ($create_items as $value) {
                    ManualDatasource::create([
                        "value" => $value,
                        "main_datasource_id" => $id
                    ]);
                }
                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));
        }
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        if (MainDatasource::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));
        }
    }

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

        return DataTables::of($obj)
            ->addColumn('actions', function ($obj) {
                return '
               <i class="fa fa-pencil iconMini" onClick="clickEdit(' . $obj->id . ')" data-id="' . $obj->id . '" data-toggle="tooltip" data-placement="bottom"  style="cursor:pointer;"></i>
               <i class="fa fa-trash iconMini" onClick="clickDelete(' . $obj->id . ')" data-id="' . $obj->id . '" data-toggle="tooltip" data-placement="bottom"  style="cursor:pointer;"></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>';
                }
            })
            ->rawColumns(['active', 'actions'])
            ->make(true);
    }

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

        $main = MainDatasource::find($id);
        $main->active = $state;
        $main->update();

        if ($main) {
            return array('r' => true, 'd' => null, 'm' => __('messages.updated_successfully'));
        } else {
            return array('r' => false, 'd' => null, 'm' => __('messages.error_updating'));
        }
    }
}