<?php

namespace App\Http\Controllers;

use DB;
use DataTables;
use App\Form;
use App\Field;
use App\FormField;
use Illuminate\Http\Request;

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

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create($form_id)
    {
        $forms = Form::where('active', 1)->get();
        $fields = Field::where('active', 1)->get();
        $formField = Form::with('fields')->findOrFail($form_id);
        return view('formFields.create', compact('fields', 'forms', 'formField'));
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        if ($form = Form::findOrFail($request->input('form_id'))) {
            try {
                $form->fields()->sync($request->input('field_id'));
                return response(array("r" => true, "type" => "success", "title" => "", "m" => __('messages.created_successfully'), "data" => null));
            } catch (\Throwable $th) {
                return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.error_sync_form_field'), "data" => null));
            }
        } else {
            return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.error_creating'), "data" => null));
        }
    }

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

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        //
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        //
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        //
    }

    public function statusFormField(Request $request)
    {
        if (FormField::where([['form_id', $request->input('form_id')], ['field_id', $request->input('field_id')]])->update(array_slice($request->all(), 2))) {
            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));
        }
    }

    public function tableFilter($form_id)
    {
        // $obj = FormField::where('form_id', $form_id)->with(['form','field']);
        $obj = $obj = DB::table('form_fields')
            ->where('form_id', $form_id)
            ->join('forms', 'form_fields.form_id', '=', 'forms.id')
            ->join('fields', 'form_fields.field_id', '=', 'fields.id')
            ->select('fields.name');
        return DataTables::of($obj)
            ->make(true);
    }
}