<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\SizingUnit;
use Illuminate\Support\Facades\Auth;

use DB;
use Datatables;

class SizingUnitController extends Controller
{    public function __construct(Request $request)
    {
        $this->middleware('auth');
        // $this->middleware(function ($request, $next) {
        //     $this->user = Auth::user();
        //     if (Auth::user()->rol->id == 1 || Auth::user()->rol->id == 6) {
        //         $this->changeDbDefault($request);
        //     }
        //     return $next($request);
        // });
    }
    public function index(){
        // $rol = Auth::user()->rol->id;
        // if ($rol == 1 ||  $rol == 6) {
            $sizing = SizingUnit::orderBy('name','ASC')->get();
            return view('sizing.sizing')->with('sizing',$sizing);
        // }else{
        //     return redirect()->back();
        // }
    }

    public function indexAdd(){

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

    public function indexEdit($id){
        // $rol = Auth::user()->rol->id;
        // if ($rol == 1 || $rol == 6) {
            $sizing = SizingUnit::find($id);
            return view('sizing.editSizing')->with('sizing',$sizing);
        // }else{
        //     return redirect()->back();
        // }
    }

    public function create(Request $request)
    {

        $r = SizingUnit::where("name",$request["name"])->orWhere("abbreviation",$request["abbreviation"])->first();

        if ($r) {
           return array('r' => false, 'm'=> trans('messages.controller_sizing_tag1'));

        } else {

            $sizing = new SizingUnit();
            $sizing->name = $request["name"];
            $sizing->abbreviation = $request["abbreviation"];

            $sizing->save();
            $logObj = $sizing;

            $this->registerLog(Auth::user()->id, 'Creó unidad de medida', json_encode($logObj)
           ,"Create", 6);

           return array('r' => true, 'm'=> trans('messages.controller_sizing_tag2'));
        }
  }

  public function update(Request $request)
    {
        $sizing =SizingUnit::find($request["id"]);
        $logObj = $sizing;
        $r = SizingUnit::where("name",$request["name"])->first();

        if ($r && $r->id != $sizing->id) {

           return array('r' => false, 'm'=> trans('messages.controller_sizing_tag1'));

        } else {

            $sizing =SizingUnit::find($request["id"]);
            $logObj = $sizing;
            $sizing->name = $request["name"];
            $sizing->abbreviation = $request["abbreviation"];

            $sizing->update();


            $this->registerLog(Auth::user()->id, 'Editó unidad de medida', json_encode($logObj)
           ,"Update", 6);

           return array('r' => true, 'm'=> trans('messages.controller_sizing_tag3'));

        }

    }

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


        return Datatables::of($obj)
        ->addColumn('actions', function ($obj) {
            return '<i class="fa fa-pencil iconMini " onClick="clickEditSizing('.$obj->id.')" data-id="'.$obj->id.'"  title="Editar"></i>
            <i class="fa fa-trash iconMini " onClick="clickDeleteSizing('.$obj->id.')" data-id="'.$obj->id.'"  title="Eliminar"></i>';

        })

        ->rawColumns([ 'active','actions'])
        ->make(true);


    }

    public function delete(Request $request)
    {
        $sizing = SizingUnit::find($request['id']);
        $logObj = $sizing;
        $sizing->delete();

        $this->registerLog(Auth::user()->id, 'Eliminó unidad de medida', json_encode($logObj)
        ,"Delete", 6);

        return array('r' => true, 'm'=> trans('messages.controller_sizing_tag4'));
    }
}