<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><!-- end class="col-sm-12" --> 
</div> <!-- end row -->    

<?= form_open('admin/sales_report'); ?>
<div class="row">
    <div class="col-sm-12">
        <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; ?>"> <input  class="btn btn-primary form-control" type="submit" name="submit" value="Submit Date"></p>
        <h4>Total Sales : 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>Order ID</th>
            <th>Order Date</th>
            <th>Customer</th>
            <th>Phone</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><?= ucwords($order->recipient_name); ?></td>
                    <td><?= $order->phone; ?></td>
                    <td><?= number_format($order->total_amount); ?></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><!-- 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 -->