@php
    use App\Models\RequestBarangDetail;

    $RequestBarang = RequestBarangDetail::join('hrd_request_barang', 'hrd_request_barang.id_hrd_request', 'hrd_request_barang_detail.id_hrd_request')
        ->select(
                'hrd_request_barang_detail.*',
                'hrd_request_barang.id_hrd_request',
                'hrd_request_barang.no_surat',
                'hrd_request_barang.tgl_request',
                'hrd_request_barang.kategori_po',

                DB::raw("(SELECT nama_rekening FROM acc_rekening WHERE acc_rekening.id_acc_rekening=hrd_request_barang_detail.id_acc_rekening) as nama_rek_barang"),
                DB::raw("(SELECT nama_rekening FROM acc_rekening WHERE acc_rekening.id_acc_rekening=hrd_request_barang_detail.id_acc_rekening_hutang) as nama_rek_piutang"),
            )
    ->whereYear('hrd_request_barang.tgl_request', 2025)
    ->get();
@endphp


<table>
    <thead>
        <tr>
            <td>id_hrd_request_barang_detail</td>
            <td>No PO</td>
            <td>nama_barang</td>
            <td>keterangan</td>
            <td>Kategori PO</td>
            <td>Rekening Barang</td>
            <td>Rekening Hutang</td>
        </tr>
    </thead>
    <tbody>
        @foreach ($RequestBarang as $row)
            <tr>
                <td>{{ $row->id_hrd_request }}</td>
                <td>{{ $row->no_surat }}</td>
                <td>{{ $row->nama_barang }}</td>
                <td>{{ $row->keterangan }}</td>                
                <td>{{ $row->kategori_po }}</td>
                <td>{{ $row->id_acc_rekening }}</td>
                <td>{{ $row->id_acc_rekening_hutang }}</td>
            </tr>
        @endforeach
    </tbody>
</table>