<?= $this->extend('admin/layout/report/admin_report_blank') ?>
<?= $this->section('content') ?>
    <!-- ============================================================== -->
    <!-- Page Content -->
    <!-- ============================================================== -->

    <!-- ============================================================== -->
    <!-- Different data widgets -->
    <!-- ============================================================== -->
        
    <?php echo form_open($url_action_table['main']); ?>
    <div class="row">
        <div class="col-md-6">
            <div class="row">
                <div class="col-md-6">
                    <div class="fv-row mb-5">
                        <label class="form-label fw-bold">Start</label>
                        <?= input_field('start', 'form-control form-control-md', 'start', 'date', 'Start', $start); ?>
                    </div>
                </div>
                <div class="col-md-6">
                    <div class="fv-row mb-5">
                        <label class="form-label fw-bold">End</label>
                        <?= input_field('end', 'form-control form-control-md', 'end', 'date', 'End', $end); ?>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-6">
        <label class="form-label fw-bold">&nbsp;</label>
            <div class="fv-row mb-5">
                
                <?php if($show) { ?>
                    <?= button_button('', 'btn btn-light-primary', 'rpt', 'submit','value="export"', '', 'Export Excel'); ?>
                    <?= button_button('', 'btn btn-light-primary', 'rpt', 'submit','value="exportpdf"', '', 'Export PDF'); ?>
                <?php } ?>
                <?= button_button('', 'btn btn-light-primary', 'rpt', 'submit','value="show"', '', 'Tampilkan Data'); ?>
            </div>
        </div>
    </div>
    <?= form_close() ?>
    <!-- ============================================================== -->  
    <div class="overflow-auto report-data">   
     <?php if($show){
        $session = service('session');
        echo form_content_table_tag_open('table', 'table align-middle table-row-dashed fs-6 gy-5 responsive nowrap', '', $session->get('trash')) ?>
            <thead>
                <tr class="text-center text-muted fw-bolder fs-7 text-capitalize gs-0">
                    <th rowspan="2">No</th>
                    <th colspan="2">BC 2.4</th>
                    <th rowspan="2">Kode Barang</th>
                    <th rowspan="2">Nama Barang</th>
                    <th rowspan="2">Satuan</th>
                    <th rowspan="2">Jumlah</th>
                    <th rowspan="2">Mata Uang</th>
                    <th rowspan="2">Nilai</th>
                    <th rowspan="2">Alasan</th>
                </tr>
                <tr class="text-center text-muted">
                    <th>Nomor</th>
                    <th>Tanggal</th>
                </tr>
            </thead>
            <tbody class="text-gray-600 fw-bold">
                <?php 
                    $i = 1;
                    foreach ($data as $d) { 
                        $json = json_decode($d->pb_ic_item);
                        $sum = 0;
                    ?>
                            <?php
                            foreach($json as $j){
                                $o = $j->item;
                                $q = $j->qty;
                                $a = $j->alasan;
                                // $n = $j->nilai;
                                // $nd = $j->no_dok;
                                // $td = $j->tgl_dok;

                                $barang = new  \App\Models\MasterBarang();
                                $_barang = $barang->find($o);
                                $mb_kode = '';
                                $mb_name = '';
                                $mb_satuan = '';
                                if(isset($_barang)){
                                    $mb_kode = $_barang->mb_kode;
                                    $mb_name = $_barang->mb_name;
                                    $mb_satuan = $_barang->mb_satuan;

                                }
                                ?>
                                <tr> 
                                    <td><?= $i ?></td>
                                    <td><?= $d->pb_bc24_no ?></td>
                                    <td>
                                        <?php if($d->pb_bc24_tgl == '0000-00-00' || $d->pb_bc24_tgl == '') { ?>
                                            -
                                        <?php } else { ?>
                                            <?= date("d/m/Y", strtotime($d->pb_bc24_tgl ?? '')) ?>
                                        <?php } ?>    
                                    </td>
                                    <td><?= $_barang->mb_kode ?></td>
                                    <td style="white-space: nowrap;"><?= $_barang->mb_name ?></td>
                                    <td><?= $_barang->mb_satuan ?></td>
                                    <td class="formatted-number"><?= $q ?></td>
                                    <td>Rupiah</td>
                                    <td align="right" class="formatted-currency"><?= $d->pb_nilai_barang ?></td>
                                    <td><?= $a ?></td>
                                </tr>
                                <?php
                        $i++;
                            }
                        ?>
                        <?php
                    }
                ?>
            </tbody>
        <?= form_content_table_tag_close(); ?>
    <?php } ?>
</div>
<?= $this->endSection('content') ?>