<?php

namespace App\Models;

use CodeIgniter\Model;

class MenuModel extends Model
{
    protected $DBGroup = 'posDB'; // Murni kasir

    public function getMenuData()
    {
        $db = \Config\Database::connect('posDB');
        $targetKategori = ['J01', 'J02', 'J03', 'J04', 'J07', 'J10', 'J11'];

        $kategoriData = $db->table('jenismenu')->whereIn('kdjenis', $targetKategori)->get()->getResultArray();
        $menuData = $db->table('tabel_menu')->whereIn('jenismenu', $targetKategori)->where('stat', 1)->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;
    }
}