<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> Back to Dashboard</a></p><br>
        <h2>Sales Report</h2>
        <?= $this->session->flashdata('success'); //to display success message ?> 
        <?= $this->session->flashdata('result'); //to display result message ?> 
    </div> 
</div>     

<?= form_open('admin/sales_report'); ?>
<div class="row">
    <div class="col-sm-6">
        <p>Filter Sales Date from 
        <input class="datepicker form-control" type="text" name="sales_start" value="<?= $sales_start; ?>">Sales Date To 
        <input class="datepicker form-control" type="text" name="sales_end" value="<?= $sales_end; ?>"> 
        <br />
        <input  class="btn btn-primary form-control" type="submit" name="submit" value="Submit Date"></p>
        <p style="display:flex; justify-content:space-between"><a href="<?= base_url(). 'admin/sales_report/excel_export' ?>"><img src="https://www.indolok.id/new/assets/admin/img/excel-icon.png"> EXPORT TO MS EXCEL</a>
        <a href="<?= base_url('admin/sales_report'); ?>">RESET</a></p>
        <br />
        <h4>Total Sales : IDR <?= number_format($total_sales_amount); ?></h4> 
        <p><strong>Included order status: Paid, Process, Delivered<br>
        Total sales include shipping fee, free shipping and voucher.</strong></p>
    </div> 
</div>    
 <?= form_close(); ?>

<div class="row">
    <div class="col-sm-12">
    <div class="table-responsive">
        <table class="table table-striped"> 
    <thead>
        <tr>
            <th>Order ID</th>
            <th>Order Date</th>
            <th>Customer</th>
            <th>Products</th>
            <th>Amount (Rp)</th> 
            <th>Payment type</th>
            <th>View Details</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>
                        <strong><?= ucwords($order->recipient_name); ?></strong>
                    </td>
                    <td>
                    <?php
                    //get item details
                    $items = $this->db->select('item_name')->from('orders_detail')->where('orders_id', $order->id_orders)->get()->result();
                    foreach($items as $item) : ?>
                        <?= $item->item_name . '<br />'; ?>
                    <?php endforeach; ?>
                    </td>
                    <td> 
                        <?php  
                            $grand_total = $order->total_amount;
                            $grand_total += $order->ppn;
                            $grand_total += $order->shipping_fee;
                            $grand_total -= $order->free_shipping_fee;
                            $grand_total -= $order->redeemed_voucher_amount;
                            $grand_total -= $order->minus_reward_amount; 
                        ?> 
                        <?php echo number_format($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 ; ?>">View</a></td>    
                </tr>
            <?php endforeach; ?>

        <?php else: ?>
            <tr>
            <td colspan="3">We could not find any order.</td>
            </tr>
        <?php endif; ?>

    </tbody> 
    </table>
    </div>
    </div>
</div>    

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