<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', 'class="form-horizontal"'); ?>
<div class="row">
    <!-- <div class="col-sm-12"> -->
    <div class="form-group">
      <label class="control-label col-sm-2" for="email">Penjualan dari tanggal :</label>
      <div class="col-sm-3">
        <input required placeholder="Tanggal awal penjualan" class="datepicker form-control" type="date" name="sales_start" value="<?= $sales_start; ?>">
      </div>
      <label class="control-label col-sm-2" for="email">Sampai tanggal :</label>
      <div class="col-sm-3">
        <input required placeholder="Tanggal ahir penjualan" class="datepicker form-control" type="date" name="sales_end" value="<?= $sales_end; ?>"> 
      </div>
    </div>
    <div class="form-group">
      <label class="control-label col-sm-2" for="email">Metode Pembayaran :</label>
      <div class="col-sm-8">
        <select required class="form-control" name="payment_type" >
            <!-- <option disabled selected value="" >Pilih metode pembayaran...</option> -->
            <option selected value="all">All payment method</option>
            <?php foreach($options as $option): ?>
            <?php if ($option->payment_type =="not yet") continue; ?>
            <option <?php echo ($payment==$option->payment_type) ? "selected" : "" ; ?> value="<?= $option->payment_type ?>"><?= $option->payment_type ?></option>
            <?php endforeach; ?>
        </select>
      </div>
    </div>

    <div class="form-group">        
      <div class="col-sm-offset-2 col-sm-4">
        <input  class="btn btn-primary form-control" type="submit" name="submit" value="Filter">
      </div>
      <div class=" col-sm-4">
        <!-- <input  class="btn btn-danger form-control" type="submit" name="submit" value="Reset filter"> -->
        <a  class="btn btn-danger form-control" href="<?php echo base_url('admin/sales_report'); ?>" >Reset Filter</a>
      </div>
    </div>

    <div class="form-group">
      <label class="control-label col-sm-2" for="email">Total Penjualan : IDR</label>
        <div class="col-sm-4">
            <input  class="form-control" value="<?= number_format($total_sales_amount); ?>" disabled>
        </div>
        
    </div>
    
    <!-- </div> -->
    <!-- <div class="col-sm-12"> -->
      
    <!-- </div> -->
        
    
</div> <!-- end row -->   
 <?= form_close(); ?>

 <div class="row">
    <div class="col-sm-12">
    <div class="table-responsive">
    <table id="example" 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 -->  
<br><br><br>

<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<link rel="stylesheet" href="https://cdn.datatables.net/1.10.21/css/dataTables.bootstrap.min.css">
<link rel="stylesheet" href="https://cdn.datatables.net/buttons/1.6.2/css/buttons.bootstrap.min.css">
<script src="https://code.jquery.com/jquery-3.5.1.js"></script>
<script src="https://cdn.datatables.net/1.10.21/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/1.10.21/js/dataTables.bootstrap.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.6.2/js/dataTables.buttons.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.6.2/js/buttons.bootstrap.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
<script src="https://cdn.datatables.net/buttons/1.6.2/js/buttons.html5.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.6.2/js/buttons.print.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.6.2/js/buttons.colVis.min.js"></script>
<script>
$(document).ready(function() {
    var table = $('#example').DataTable( {
        ordering:false,
        buttons: [ 'copy', 'excel', 'pdf', 'print' ]
    } );
 
    table.buttons().container()
        .appendTo( '#example_wrapper .col-sm-6:eq(0)' );
} );
</script>
<!-- <script type="text/javascript" src="https://www.tokodaku.com/store-shared/assets/admin/js/jquery.dataTables.js"></script>
<script type="text/javascript" src="https://www.tokodaku.com/store-shared/assets/admin/js/dataTables.bootstrap.js"></script>  -->

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