<?php

namespace App\Models;

use CodeIgniter\Model;

class AdminMenuModel extends Model
{
    protected $DBGroup = 'posDB';

    public function getAllMenuDataAdmin()
    {
        try {
            $db = \Config\Database::connect('posDB');
            $targetKategori = ['J01', 'J02', 'J03', 'J04', 'J07', 'J10', 'J11'];

            // Coba ambil data kategori
            $kategoriData = $db->table('jenismenu')->whereIn('kdjenis', $targetKategori)->get()->getResultArray();
            
            // Coba ambil data menu
            $menuData = $db->table('tabel_menu')->whereIn('jenismenu', $targetKategori)->orderBy('jenismenu', 'ASC')->orderBy('no_urut', 'ASC')->get()->getResultArray();

            $hasil = [];
            foreach ($kategoriData as $kat) {
                $hasil[$kat['kdjenis']] = ['keterangan' => $kat['keterangan'], 'items' => []];
            }

            foreach ($menuData as $menu) {
                $kdjenis = $menu['jenismenu'];
                if (isset($hasil[$kdjenis])) {
                    $hasil[$kdjenis]['items'][] = $menu;
                }
            }

            return $hasil;

        } catch (\Exception $e) {
            
            die("<div style='background:#ffcccc; padding:20px; border:2px solid red; font-family:sans-serif;'>
                    <h2>🚨 Error di AdminMenuModel!</h2>
                    <p><b>Pesan Error:</b> " . $e->getMessage() . "</p>
                 </div>");
        }
    }
}