<?php

namespace App\Http\Controllers;

use App\Parameter;
use App\ReportPower;
use Illuminate\Http\Request;

class BIController extends Controller
{
    public function index()
    {
        $obj = Parameter::first();
        $url = $obj->url_bi;
        return view('bi.bi')->with('url', $url);
    }

    public function showBI()
    {
        $reports = ReportPower::all();
        return view('bi.powerBI', compact('reports'));
    }

    public function settings()
    {
        $reports = ReportPower::all();
        return view('bi.settings.list', compact('reports'));
    }

    public function indexSettingsEdit($id)
    {
        $object = ReportPower::findOrFail($id);
        return view('bi.settings.edit', compact('object'));
    }

    public function indexSettingsAdd()
    {
        return view('bi.settings.create');
    }

    public function create(Request $request)
    {
        try {
            if (ReportPower::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));
            }
            $data = $request->all();
            if ($model = ReportPower::create($data)) {
                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 (ReportPower::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));
            }
            $data = $request->all();
            if (ReportPower::where('id', $id)->update($data)) {
                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 (ReportPower::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));
        }
    }

}