<?php

namespace App\Http\Controllers;

use Datatables;
use App\PaymentMethod;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

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

  public function indexAdd()
  {
    return view('payment_methods.create');
  }

  public function indexEdit($id)
  {
    $object = PaymentMethod::find($id);
    return view('payment_methods.edit', compact('object'));
  }

  public function tableFilter()
  {
    DB::statement("SET sql_mode = ''");
    $obj = PaymentMethod::select(
      'id',
      'name',
      'code',
      'active',
      'created_at'
    )
      ->groupBy('id');
    DB::statement("SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'");

    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('created_at', function ($obj) {
        return \Carbon\Carbon::parse($obj->created_at)->format('Y-m-d h:i:s A');
      })
      ->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" class="chk" onChange="chk(' . $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" class="chk" onChange="chk(' . $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 create(Request $request)
  {
    try {
      if (PaymentMethod::where('name', $request->input('name'))->first()) {
        return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.already_exists', ['name' => $request->input('name')]), "data" => null));
      }
      if ($model = PaymentMethod::create($request->all())) {
        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 (PaymentMethod::where([['id', '!=', $id], ['name', $request->input('name')]])->first()) {
        return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.already_exists', ['name' => $request->input('name')]), "data" => null));
      }
      if (PaymentMethod::where('id', $id)->update($request->all())) {
        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($id)
  {
    try {
      if (PaymentMethod::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));
      }
    } 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)
  {
    try {
      $id     = $request['id'];
      $state  = $request['state'];

      $paymentMethod          = PaymentMethod::find($id);
      $paymentMethod->active  = $state;
      $paymentMethod->update();

      return array('r' => true, 'd' => null, 'm' => __('messages.updated_successfully'));
    } catch (\Throwable $th) {
      return array('r' => false, 'd' => null, 'm' => __('messages.error_updating'));
    }
  }
}