<?php if(empty($status)){ $status = 0; } ?>
<div class="row">
    <div class="col-sm-12">
        <p>
            <a href="<?= base_url('admin/pembelian'); ?>">
                <i class="fa fa-arrow-left" aria-hidden="true"></i> Kembali ..
            </a>
        </p><br>
        <h2>Daftar Faktur</h2>
        <?= $this->session->flashdata('success'); //to display success message ?> 
        <?= $this->session->flashdata('result'); //to display result message ?> 
    </div><!-- end class="col-sm-12" -->
</div> <!-- end row -->

<div>
    <!-- Tab panes -->
    <div class="tab-content">
        <div role="tabpanel" class="tab-pane active" id="search">
            <h3 style="margin: 0; padding: 0;">Cari Faktur</h3>
            <div class="row">
                <?= form_open('admin/pembelian/faktur_search'); ?>
                <div class="col-md-12 col-xs-12">
                    <div class="col-md-6 col-md-offset-right-6">
                        <div class="row">
                            <div class="col-md-12 col-xs-12"> 
                                <input class="form-control" type="text" placeholder="Enter Invoice Number" name="transaction"
                                <?php if (!empty($no_transaction)) : ?>
                                    value="<?= ucwords($no_transaction); ?>" 
                                <?php endif; ?>>
                            </div><!-- end class="col-sm-8" -->
                        </div>
                        <div class="row">
                            <div class="col-md-12 col-xs-12"> 
                                <select name="status" class="form-control">
                                    <option value="">Status Filter</option>
                                    <option value="1" <?php if($status == '1'){ echo 'selected'; } ?>>Open</option>
                                    <option value="2" <?php if($status == '2'){ echo 'selected'; } ?>>Sinkronisasi</option>
                                </select>
                            </div><!-- end class="col-sm-8" -->
                        </div>
                        <div class="row">
                            <div class="col-md-12 col-xs-12">
                                <input class="btn btn-primary form-control" type="submit" name="search_transaction" value="CARI FAKTUR">
                            </div><!-- end class="col-sm-6" -->
                        </div>
                    </div>
                </div>
                <?= form_close(); ?> 
            </div> <!-- end row -->
        </div>
    </div>
</div>

<div class="row">
    <div class="col-sm-12"><br>
        <p><a class="btn btn-success" href="<?= base_url('admin/pembelian/sync_all_faktur'); ?>">SINKRONISASI SEMUA FAKTUR KE JURNAL.ID</a></p>
        <p>Faktur yang akan di sinkronisasi adalah faktur dengan status OPEN.</p>
    </div><!-- end class="col-sm-12" -->
</div> <!-- end row --> 


<div class="row">
    <div class="col-sm-12"><br>
        <p><?= anchor('admin/pembelian/faktur_add', '<i class="fa fa-plus" aria-hidden="true"></i> TAMBAH FAKTUR BARU'); ?></p>
    </div><!-- end class="col-sm-12" -->
</div> <!-- end row --> 

<div class="row">
    <div class="col-sm-12">
        <div class="table-responsive">    
            <table class="table table-striped">
                <thead>
                    <tr>
                        <th>No. Faktur</th>
                        <th>Tgl. Faktur</th>
                        <th>Supplier</th>
                        <th>Tgl.Jatuh Tempo</th>
                        <th>Status Faktur</th>
                        <th>Total</th>
                        <th>Gudang</th>
                        <th>Dibuat Oleh</th>
                    </tr>
                </thead>
                <tbody>
                    <?php if($transaction != null): ?>
                        <?php foreach ($transaction as $item):?>
                            <tr>
                                <td><a href="<?= base_url('admin/pembelian/faktur_detail/').$item->id;?>"><?= $item->no_faktur;?></a></td>
                                <td><?= $item->tgl_faktur; ?></td>
                                <td>
                                    <?php 
                                        $transaction_id = $this->db->select('transaction_id')->from('transaction_receiving')->where('id',$item->transaction_receiving_id)->get()->row()->transaction_id;
                                        $supplier_id = $this->db->select('supplier_id')->from('transaction')->where('id_transaction',$transaction_id)->get()->row()->supplier_id;
                                        $supplier_name = $this->db->select('supplier_name')->from('supplier')->where('id',$supplier_id)->get()->row()->supplier_name;
                                        echo ucfirst($supplier_name);
                                    ?>
                                </td>
                                <td>
                                    <?php 
                                        $transaction_id = $this->db->select('transaction_id')->from('transaction_receiving')->where('id',$item->transaction_receiving_id)->get()->row()->transaction_id;
                                        $tgl_jth_tempo = $this->db->select('tgl_jth_tempo')->from('transaction')->where('id_transaction',$transaction_id)->get()->row()->tgl_jth_tempo;
                                        echo $tgl_jth_tempo;
                                    ?>
                                </td>
                                <td>
                                    <?php 
                                        $status_faktur  = $this->db->select('transaction_status')->from('transaction_status')->where('id',$item->status_faktur)->get()->row()->transaction_status;
                                        echo ucfirst($status_faktur)
                                    ?>
                                </td>
                                <td>
                                    <?= "Rp. ".number_format($item->total,2,",","."); ?>
                                </td>
                                <td>
                                    <?php 
                                        $transaction_id = $this->db->select('transaction_id')->from('transaction_receiving')->where('id',$item->transaction_receiving_id)->get()->row()->transaction_id;
                                        $warehouse_id   = $this->db->select('warehouse_id')->from('transaction')->where('id_transaction',$transaction_id)->get()->row()->warehouse_id; 
                                        $warehouse      = $this->db->select('name')->from('warehouse')->where('id',$warehouse_id)->get()->row()->name;
                                        echo ucfirst($warehouse);
                                    ?>
                                </td>
                                 <td>
                                    <?= $item->faktur_created_by; ?>
                                </td>
                            </tr>
                        <?php endforeach; ?>
                    <?php else: ?>
                        <tr>
                            <td colspan="8" style="text-align: center;">Transaksi Faktur Tidak Ditemukand</td>
                        </tr>
                    <?php endif; ?>
                </tbody> 
            </table>
        </div><!-- end class responsive-->
    </div><!-- end class="col-sm-12" -->
</div> <!-- end row -->