<div class="row">
    <div class="col-sm-12">
         <p><a href="<?= base_url('admin/dashboard'); ?>"><i class="fa fa-arrow-left" aria-hidden="true"></i> Kembali ke Dashboard</a></p><br>
        <h2>Laporan penjualan</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 -->    

<?= form_open('admin/sales_report'); ?>
<div class="row">
    <div class="col-sm-12">
        <p>Filter Tanggal Penjualan dari <input class="datepicker form-control" type="text" name="sales_start" value="<?= $sales_start; ?>">Tanggal Penjualan ke <input class="datepicker form-control" type="text" name="sales_end" value="<?= $sales_end; ?>"> <input  class="btn btn-primary form-control" type="submit" name="submit" value="Tanggal Pengiriman"></p>
        <h4>Total Penjualan : IDR <?= number_format($total_sales_amount); ?></h4> 
    </div><!-- end class="col-sm-12" --> 
</div> <!-- end row -->   
 <?= form_close(); ?>

<div class="row">
    <div class="col-sm-12">
    <div class="table-responsive">
        <table class="table table-striped"> 
    <thead>
        <tr>
            <th>Pemesanan ID</th>
            <th>Tanggal Pemesanan</th>
            <th>Pelanggan</th>
            <th>Telepon</th>
            <th>Jumlah (Rp)</th> 
            <th>Tipe Pembayaran</th>
            <th>Lihat Detail</th>    
        </tr>
    </thead>
    <tbody>
        <?php if(count($orders)) : ?>     

            <?php foreach($orders as $order): ?> 
                <tr>
                    <td><?= $order->id_orders; ?></td>
                    <td><?= date('j M Y', strtotime($order->order_date)); ?></td>
                    <td><?= ucwords($order->recipient_name); ?></td>
                    <td><?= $order->phone; ?></td>
                    <td>
                        <?php 
                            $final_grand_total = 0;
                            $grand_total =  ($order->total_amount - $order->redeemed_voucher_amount - $order->minus_reward_amount)+($order->shipping_fee - $order->free_shipping_fee);
                            if($grand_total > 0){
                                $final_grand_total = $order->total_amount;
                            }
                            echo number_format($final_grand_total);
                        ?>
                    </td>
                    <td><?= ucwords($order->payment_type); ?></td>
                    <td><a target="_blank" style="text-decoration: underline;" href="<?= base_url('admin/orders/view') . '/' . $order->id_orders ; ?>">Lihat</a></td>    
                </tr>
            <?php endforeach; ?>

        <?php else: ?>
            <tr>
            <td colspan="3">Kami tidak dapat menemukan pesanan apa pun.</td>
            </tr>
        <?php endif; ?>

    </tbody> 
    </table>
    </div>
    </div><!-- end class="col-sm-12" -->
</div> <!-- end row -->   

<div class="row">
    <div class="col-sm-12">
        <?php
        //create pagination...
        echo '<p style="text-align:center;">' . $this->pagination->create_links() . '</p>';
        ?>
    </div><!-- end class="col-sm-12" -->
</div> <!-- end row -->