<?php

namespace App\Http\Controllers\Admin;

use App\Helpers\ImageSize;
use App\Http\Controllers\Controller;
use App\Http\Controllers\Traits\FileUploadTrait;
use App\Http\Requests\Admin\StorePlanningsRequest;
use App\Http\Requests\Admin\UpdatePlanningsRequest;
use App\Planning;
use App\ResidentialComplex;
use App\RoomCount;
use Illuminate\Http\JsonResponse;
use Illuminate\Http\Request;
use Illuminate\Http\Response;
use Illuminate\Support\Facades\File;
use Illuminate\Support\Facades\Gate;

class PlanningsController extends Controller
{
    use FileUploadTrait;

    /**
     * Display a listing of Planning.
     *
     * @param Request $request
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request)
    {
        if (!Gate::allows('planning_access')) {
            return abort(401);
        }

        $residental_complex_id = $request->query->get('residental_complex_id');
        $room_count_id = $request->query->get('room_count_id');
        $squera_meter = $request->query->get('squera_meter');
        if (request('show_deleted') == 1) {
            if (!Gate::allows('planning_delete')) {
                return abort(401);
            }
            $plannings = Planning::onlyTrashed()->get();
        } else {
            if (!empty($residental_complex_id) || !empty($room_count_id) || !empty($squera_meter)) {
                $plannings = Planning::query()
                    ->join('sections', 'plannings.section_id', '=', 'sections.id')
                    ->join('residential_complexes as rc', 'sections.residental_complex_id', '=', 'rc.id')
                    ->when(!empty($residental_complex_id), function ($query) use ($residental_complex_id) {
                        $query->where("rc.id", $residental_complex_id);
                    })

                    ->when(!empty($room_count_id), function ($query) use ($room_count_id) {
                        $query->where("plannings.room_id", $room_count_id);
                    })

                    ->when(!empty($squera_meter), function ($query) use ($squera_meter) {
                        $query->where("plannings.space", "=", $squera_meter);
                    })

                    ->select('plannings.*')
                    ->get();
            } else {
                $plannings = Planning::paginate(15);
            }
        }
        $residential_complexes = ResidentialComplex::get()->
            pluck('name', 'id')->prepend(trans('quickadmin.qa_residential_complex_filter'), '');
        $room_counts = RoomCount::get()
            ->pluck('name', 'id')->prepend(trans('quickadmin.qa_room_count_filter'), '');


        return view('admin.plannings.index', compact('plannings', 'residential_complexes',
            'residental_complex_id', 'room_count_id', 'squera_meter', 'room_counts'));
    }

    /**
     * Show the form for creating new Planning.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        if (!Gate::allows('planning_create')) {
            return abort(401);
        }
        $rooms = \App\RoomCount::get()->pluck('count', 'id')->prepend(trans('quickadmin.qa_please_select'), '');
        $room_types = \App\RoomType::get()->pluck('name', 'id')->prepend(trans('quickadmin.qa_please_select'), '');
        $floor_ids = \App\Floor::get()->pluck('name', 'id');
        $sections = \App\Section::get()->pluck('section_name', 'id')->prepend(trans('quickadmin.qa_please_select'), '');

        return view('admin.plannings.create', compact('rooms', 'room_types', 'floor_ids', 'sections'));
    }

    /**
     * Store a newly created Planning in storage.
     *
     * @param  StorePlanningsRequest $request
     * @return \Illuminate\Http\Response
     */
    public function store(StorePlanningsRequest $request)
    {
        if (!Gate::allows('planning_create')) {
            return abort(401);
        }

        $request = $this->saveFiles($request, ['planning' => true]);
        $planning = Planning::create($request->all());
        $planning->floor_id()->sync(array_filter((array)$request->input('floor_id')));

        return redirect()->route('admin.plannings.index');
    }

    /**
     * Show the form for editing Planning.
     *
     * @param  int $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        if (!Gate::allows('planning_edit')) {
            return abort(401);
        }
        $rooms = \App\RoomCount::get()->pluck('count', 'id')->prepend(trans('quickadmin.qa_please_select'), '');
        $room_types = \App\RoomType::get()->pluck('name', 'id')->prepend(trans('quickadmin.qa_please_select'), '');
        $floor_ids = \App\Floor::get()->pluck('name', 'id');
        $sections = \App\Section::get()->pluck('section_name', 'id')->prepend(trans('quickadmin.qa_please_select'), '');
        $planning = Planning::findOrFail($id);

        return view('admin.plannings.edit', compact('planning', 'rooms', 'room_types', 'floor_ids', 'sections'));
    }

    /**
     * Update Planning in storage.
     *
     * @param  UpdatePlanningsRequest $request
     * @param  int $id
     * @return Response
     */
    public function update(UpdatePlanningsRequest $request, $id)
    {
        $data = $request->all();

        if (!Gate::allows('planning_edit')) {
            return abort(401);
        }
        $planning = Planning::findOrFail($id);

        $imageName = $planning->image;
        if ((isset($data['image_remove']) && !empty($imageName)) || ($request->hasFile('image') && !empty($imageName))) {
            $planningPath = public_path(env('UPLOAD_PATH') . '/' . ImageSize::PLANNING);
            $planningFull = public_path(env('UPLOAD_PATH') . '/' . ImageSize::PLANNING_FULL);
            $planningWEBP = public_path(env('UPLOAD_PATH') . '/' . ImageSize::PLANNING_WEBP);
            $planningFullWEBP = public_path(env('UPLOAD_PATH') . '/' . ImageSize::PLANNING_FULL_WEBP);
            File::delete($planningPath .'/'. $imageName);
            File::delete($planningFull .'/'. $imageName);
            File::delete($planningWEBP .'/'. $imageName . '.webp');
            File::delete($planningFullWEBP .'/'. $imageName . '.webp');

            $planning->image = "";
        }

        $request = $this->saveFiles($request, ['planning' => true]);

        $planning->update($request->all());
        $planning->floor_id()->sync(array_filter((array)$request->input('floor_id')));

        return redirect()->route('admin.plannings.index');
    }

    /**
     * Display Planning.
     *
     * @param  int $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
        if (!Gate::allows('planning_view')) {
            return abort(401);
        }
        $rooms = \App\RoomCount::get()->pluck('count', 'id')->prepend(trans('quickadmin.qa_please_select'), '');
        $room_types = \App\RoomType::get()->pluck('name', 'id')->prepend(trans('quickadmin.qa_please_select'), '');
        $floor_ids = \App\Floor::get()->pluck('name', 'id');
        $sections = \App\Section::get()->pluck('name', 'id')->prepend(trans('quickadmin.qa_please_select'), '');
        $planning_flors = \App\PlanningFloor::where('plannig_id', $id)->get();

        $planning = Planning::findOrFail($id);

        return view('admin.plannings.show', compact('planning', 'planning_flors'));
    }

    /**
     * Remove Planning from storage.
     *
     * @param  int $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        if (!Gate::allows('planning_delete')) {
            return abort(401);
        }
        $planning = Planning::findOrFail($id);
        $planning->delete();

        return redirect()->route('admin.plannings.index');
    }

    /**
     * Delete all selected Planning at once.
     *
     * @param Request $request
     */
    public function massDestroy(Request $request)
    {
        if (!Gate::allows('planning_delete')) {
            return abort(401);
        }
        if ($request->input('ids')) {
            $entries = Planning::whereIn('id', $request->input('ids'))->get();
            foreach ($entries as $entry) {
                $entry->delete();
            }
        }
    }

    /**
     * Restore Planning from storage.
     *
     * @param  int $id
     * @return \Illuminate\Http\Response
     */
    public function restore($id)
    {
        if (!Gate::allows('planning_delete')) {
            return abort(401);
        }
        $planning = Planning::onlyTrashed()->findOrFail($id);
        $planning->restore();

        return redirect()->route('admin.plannings.index');
    }

    /**
     * Permanently delete Planning from storage.
     *
     * @param  int $id
     * @return \Illuminate\Http\Response
     */
    public function perma_del($id)
    {
        if (!Gate::allows('planning_delete')) {
            return abort(401);
        }
        $planning = Planning::onlyTrashed()->findOrFail($id);
        $planning->forceDelete();

        return redirect()->route('admin.plannings.index');
    }

    public function changeStatus(Request $request, $id)
    {
        $value = $request->get('value');

        $planning = Planning::query()->find($id);
        if ($planning) {
            $planning->is_sold = (int)$value;
            $planning->save();
        }

        return new JsonResponse(['data' => $planning]);
    }
}