<?php

namespace App\Http\Controllers;

use App\Http\Requests\KlasifikasiMenu\RequestKlasifikasiMenu;
use App\Http\Requests\KlasifikasiMenu\RequestUpdateKlasifikasiMenu;
use App\Models\KlasifikasiMenu;
use Carbon\Carbon;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

class KlasifikasiMenuController extends Controller
{
    /**
     * Display a listing of the resource.
     */
    public function index()
    {
        $payload = [
            'title' => 'Master Klasifikasi Menu'
        ];
        return view('dashboard.klasifikasi_menu.index', $payload);
    }

    /**
     * Show the form for creating a new resource.
     */
    public function create()
    {
        //
    }

    /**
     * Store a newly created resource in storage.
     */
    public function store(RequestKlasifikasiMenu $request)
    {
        DB::connection('dbOrderGizi')->beginTransaction();
        try {
             $request->validated();
             $datas = $request->input('data');
             foreach ($datas as $data) {
               $payload = [
                'pegawai_id_entry' => auth()->user()->id,
                'pegawai_nama_entry' => auth()->user()->full_name,
                'nama_kategori_diet' => $data['nama_kategori_diet']
               ];
               KlasifikasiMenu::create($payload);
            };
            DB::connection('dbOrderGizi')->commit();
            return response()->json([
                'status' => true,
                'message' => 'Berhasil menambahkan data'
            ], 201);
        } catch (\Throwable $th) {
            DB::connection('dbOrderGizi')->rollBack();
            return response()->json([
                'status' => false,
                'message' => 'Gagal menambahkan data'
            ], 500);
        }
    }

    /**
     * Display the specified resource.
     */
    public function show(string $id)
    {
        //
    }

    /**
     * Show the form for editing the specified resource.
     */
    public function edit(string $id)
    {
        //
    }

    /**
     * Update the specified resource in storage.
     */
    public function update(RequestUpdateKlasifikasiMenu $request, string $id)
    {
       $request->validated();
       try {
            $km = KlasifikasiMenu::where('kategori_diet_id', $id)->first();
            $payload = [
                'nama_kategori_diet' => $request->input('nama_kategori_diet'),
                'pegawai_id_entry' => auth()->user()->id,
                'pegawai_nama_entry' => auth()->user()->full_name,
                'modified_at' => Carbon::now()
            ];
            $km->update($payload);
            return response()->json([
                'status' => true,
                'message' => 'Berhasil memperbarui data'
            ], 200);
       } catch (\Throwable $th) {
            return response()->json([
                    'status' => false,
                    'message' => 'Gagal memperbarui data'
                ], 500);
       }
    }

    /**
     * Remove the specified resource from storage.
     */
    public function destroy(string $id)
    {
       $data = KlasifikasiMenu::where(['statusenabled' => true, 'kategori_diet_id' => $id])->first();
          $payload = [
                'statusenabled' => false,
                'pegawai_id_entry' => auth()->user()->id,
                'pegawai_nama_entry' => auth()->user()->full_name,
                'modified_at' => Carbon::now()
            ];
       $data->update($payload);
       return response()->json([
            'status' => true,
            'message' => 'Berhasil menghapus data'
        ], 200);
    }

    public function datatable(){
        return KlasifikasiMenu::where('statusenabled', true)->get();
    }

    public function optionKlasifikasi(){
        $search =  request('search');
        $query = KlasifikasiMenu::where('statusenabled', true);

        if(!empty($search)){
            $query->where('nama_kategori_diet', 'ILIKE', '%' . $search . '%');
        }else{
            $query->take(30);
        }
        $data = $query->select('kategori_diet_id', 'nama_kategori_diet')->get();
        return response()->json([
            'error' => 0,
            'data' => $data
        ]);
    }
}