<?php

namespace App\Http\Controllers\Admin;

use App\Http\Controllers\Controller;
use Illuminate\Http\Request;
use Illuminate\Support\Arr;
use App\Consultation;
use App\Helpers\Helper;
use App\Http\Resources\Admin\ConsultationResource;
use App\Http\Resources\Admin\ConsultationListResource;
use Validator;
use DB;

/**
 * Class ConsultationController
 *
 * @package App\Http\Controllers
 */
class ConsultationController extends Controller
{
    const ITEM_PER_PAGE = 20;

    public function index(Request $request)
    {
        $searchParams = $request->all();
        $list = Consultation::notDeleted();
        $limit = Arr::get($searchParams, 'limit', static::ITEM_PER_PAGE);
        $keyword = Arr::get($searchParams, 'keyword', '');
        $status = Arr::get($searchParams, 'status', '');

        if (!empty($keyword)) {
            $list->where('name', 'LIKE', '%' . $keyword . '%');
        }
        if ($status != '') {
            $list->where('is_activated', $status);
        }
        $list->orderBy('id');

        return ConsultationResource::collection($list->paginate($limit));
    }

    public function listOrder(Request $request)
    {
        $searchParams = $request->all();
        $limit = Arr::get($searchParams, 'limit', static::ITEM_PER_PAGE);
        $list = Consultation::select('consultations.id', 'consultations.name', 'consultation_details.consultation_id', DB::raw('COUNT(consultations.id) as total'))
            ->leftJoin('consultation_details', 'consultations.id', '=', 'consultation_details.consultation_id')
            ->where('consultations.is_deleted', false)
            ->groupBy('consultations.id')
            ->orderByRaw('COUNT(consultations.id) desc')
            ->orderBy('consultations.id', 'DESC')
            ->paginate($limit);

        return ConsultationListResource::collection($list);
    }

    public function all()
    {
        $list = Consultation::select('id', 'name', 'slug')->notDeleted()->orderBy('id');

        return ConsultationResource::collection($list->get());
    }

    public function show($id = 0)
    {
        $consultation = Consultation::notDeleted()->where('id', $id)->first();
        if (!isset($consultation)) return response()->json(['errors' => 'Consultation is not valid'], 403);

        return new ConsultationResource($consultation);
    }

    public function store(Request $request)
    {
        $validator = Validator::make($request->all(), ['name' => ['required'], 'is_activated' => ['required']]);
        if ($validator->fails()) return response()->json(['errors' => $validator->errors()], 403);
        $params = $request->all();
        $consultation = Consultation::create([
            'name'         => $params['name'],
            'slug'         => Helper::slug($params['name']),
            'description'  => $params['description'],
            'is_activated' => ($params['is_activated'] === true) ? 1 : 0,
            'created_at'   => date('Y-m-d H:i:s'),
            'updated_at'   => date('Y-m-d H:i:s')
        ]);

        return new ConsultationResource($consultation);
    }

    public function update($id = 0, Request $request)
    {
        $validator = Validator::make($request->all(), ['name' => ['required'], 'is_activated' => ['required']]);
        if ($validator->fails()) return response()->json(['errors' => $validator->errors()], 403);
        $consultation = Consultation::notDeleted()->where('id', $id)->first();
        if (!isset($consultation)) return response()->json(['errors' => 'Consultation is not valid'], 403);
        $params = $request->all();
        $consultation->update([
            'name'         => $params['name'],
            'slug'         => Helper::slug($params['name']),
            'description'  => $params['description'],
            'is_activated' => ($params['is_activated'] === true) ? 1 : 0,
            'updated_at'   => date('Y-m-d H:i:s')
        ]);

        return response()->json(null, 204);
    }

    public function destroy($id = 0)
    {
        $consultation = Consultation::notDeleted()->where('id', $id)->first();
        if (!isset($consultation)) response()->json(['error' => 'Ehhh! Can not delete this category'], 403);

        try {
            $consultation->update(['is_deleted' => true]);
        } catch (\Exception $ex) {
            response()->json(['error' => $ex->getMessage()], 403);
        }

        return response()->json(null, 204);
    }

    public function destroyMultiple(Request $request) {
        $validator = Validator::make($request->all(), ['ids' => 'required']);
        if ($validator->fails()) return response()->json(['errors' => $validator->errors()], 403);
        $listIds = $request->get('ids', []);
        $consultationList = Consultation::notDeleted()->whereIn('id', $listIds)->get();
        if ($consultationList->count() <= 0) response()->json(['error' => 'Consultation is not valid.'], 403);
        try {
            Consultation::notDeleted()->whereIn('id', $listIds)->update(['is_deleted' => true]);
        } catch (\Exception $ex) {
            response()->json(['error' => $ex->getMessage()], 403);
        }

        return response()->json(null, 204);
    }

    public function activateMultiple(Request $request) {
        $validator = Validator::make($request->all(), ['ids' => 'required']);
        if ($validator->fails()) return response()->json(['errors' => $validator->errors()], 403);
        $listIds = $request->get('ids', []);
        $consultationList = Consultation::notDeleted()->whereIn('id', $listIds)->get();
        if ($consultationList->count() <= 0) response()->json(['error' => 'Consultation is not valid.'], 403);
        try {
            Consultation::notDeleted()->whereIn('id', $listIds)->update(['is_activated' => true]);
        } catch (\Exception $ex) {
            response()->json(['error' => $ex->getMessage()], 403);
        }

        return response()->json(null, 204);
    }

    public function deactivateMultiple(Request $request) {
        $validator = Validator::make($request->all(), ['ids' => 'required']);
        if ($validator->fails()) return response()->json(['errors' => $validator->errors()], 403);
        $listIds = $request->get('ids', []);
        $consultationList = Consultation::notDeleted()->whereIn('id', $listIds)->get();
        if ($consultationList->count() <= 0) response()->json(['error' => 'Consultation is not valid.'], 403);
        try {
            Consultation::notDeleted()->whereIn('id', $listIds)->update(['is_activated' => false]);
        } catch (\Exception $ex) {
            response()->json(['error' => $ex->getMessage()], 403);
        }

        return response()->json(null, 204);
    }
}