<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 Orders</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 -->

<h3 style="display: none;">Generate Multiple Invoices</h3>
<div class="row" style="display: none;">
    <?= form_open('admin/orders/generate_multiple_invoices'); ?>
    <div class="col-sm-2 col-xs-6">
        <input class="form-control datepicker" type="text" placeholder="Enter Start Date" name="start_date" required>
    </div><!-- end class="col-sm-8" -->
     <div class="col-sm-2 col-xs-6">
        <input class="form-control datepicker" type="text" placeholder="Enter End Date" name="end_date" required>
    </div><!-- end class="col-sm-8" -->
    <div class="col-sm-1 col-xs-6" style="text-align:right;">
        <label>Include<br>Unpaid Orders</label>
    </div><!-- end class="col-sm-8" -->

    <div class="col-sm-2 col-xs-6">
       <select class="form-control" name="include_unpaid_orders">
            <option value="no">No</option>
            <option value="yes">Yes</option>
       </select>
    </div><!-- end class="col-sm-8" -->

    <div class="col-sm-3 col-xs-6">
        <input class="btn btn-primary form-control" type="submit" name="generate_invoices" value="GENERATE INVOICES">
    </div><!-- end class="col-sm-6" -->
    <?= form_close(); ?>
</div> <!-- end row -->

<h3 style="display: none;">Generate Multiple Delivery Slips</h3>
<div class="row" style="display: none;">
    <?= form_open('admin/orders/generate_multiple_deliveryslips'); ?>
    <div class="col-sm-2 col-xs-6">
        <input class="datepicker form-control" type="text" placeholder="Enter Start Date" name="start_date" required>
    </div><!-- end class="col-sm-8" -->
     <div class="col-sm-2 col-xs-6">
        <input class="datepicker form-control" type="text" placeholder="Enter End Date" name="end_date" required>
    </div><!-- end class="col-sm-8" -->

    <div class="col-sm-1 col-xs-6" style="text-align:right;">
        <label>Include<br>Unpaid Orders</label>
    </div><!-- end class="col-sm-8" -->

    <div class="col-sm-2 col-xs-6">
       <select class="form-control" name="include_unpaid_orders">
            <option value="no">No</option>
            <option value="yes">Yes</option>
       </select>
    </div><!-- end class="col-sm-8" -->

    <div class="col-sm-3 col-xs-6">
        <input class="btn btn-primary form-control" type="submit" name="generate_deliveryslips" value="GENERATE DELIVERY SLIPS">
    </div><!-- end class="col-sm-6" -->
    <?= form_close(); ?>
</div> <!-- end row -->

<?= form_open('admin/orders/excel_export'); ?> 
<p>Export Excel, include order status of Paid, Process, In Delivery</p>
<div class="row">
    <div class="col-sm-2">
        <p>Sales Date from <input class="datepicker form-control" type="text" name="sales_start" /></p>
    </div>
    <div class="col-sm-2">
        <p>Sales Date to <input class="datepicker form-control" type="text" name="sales_end" /></p>
    </div>
    <div class="col-sm-2">
        <p>Export to Excel<input class="form-control btn btn-success" type="submit" name="exportExcel" value="EXPORT" /></p>
    </div>
</div>
<?= form_close(); ?>

<?= form_open('admin/orders/filter_order_by'); ?> 
    <div class="row">
        <div class="col-sm-6"> 
            <select class="form-control" name="filter_key" id="filter_key">
                <option value="order_id">Filter by Id Order</option>
                <option value="voucher">Filter by Voucher</option>
                <option value="payment_status">Filter by Payment Status</option>
                <option value="payment_type">Filter by Payment Type</option>
                <option value="flashsale">Filter by Flashsale</option>
                <option value="sale">Filter by Sale</option>
                <option value="date">Filter by Date</option>
                <option value="totalorder">Filter by Total Order</option>	 
            </select>
        </div><!-- end class="col-sm-8" -->   
    </div> <!-- end row --> 
    <div class="row">
        <div class="col-sm-6" id="order_id"> 
            <input class="form-control" type="text" placeholder="Enter " name="order_id">
        </div><!-- end class="col-sm-8" -->   
        <div class="col-sm-6" id="payment_status" style="display: none;"> 
            <select class="form-control" name="payment_status">
                <option value="0">Pending</option>
                <option value="1">Not Paid</option>
                <option value="2">Cancel</option>
                <option value="3">Paid</option>
                <option value="4">Process</option>
                <option value="5">In Delivery</option>
            </select>
        </div><!-- end class="col-sm-8" --> 
        <div class="col-sm-6" id="payment_type" style="display: none;"> 
            <select class="form-control" name="payment_type">
                <option value="bank transfer BCA">BCA</option>
                <option value="bank transfer MANDIRI">MANDIRI</option>
                <option value="midtrans">MIDTRANS</option>
            </select>
        </div><!-- end class="col-sm-8" -->   
        <div class="col-sm-6" id="date" style="display: none;">
                From<input class="form-control datepicker" type="text" name="start_date">To
                <input class="form-control datepicker" type="text" name="end_date">
        </div><!-- end class="col-sm-8" -->
        <div class="col-sm-6" id="totalorder" style="display: none;">
                From<input class="form-control" type="number" name="start_amt">To
                <input class="form-control" type="number" name="end_amt">
        </div><!-- end class="col-sm-8" -->		   
    </div> <!-- end row --> 
    <div class="row">
        <div class="col-sm-6">
            <input class="btn btn-primary form-control" type="submit" value="FILTER ORDER">
        </div><!-- end class="col-sm-6" -->    
        <div class="col-sm-6">
            <a href="<?= base_url('admin/orders');?>"><p style="margin-top: 6px;">Clear Filter</p></a>
        </div>
    </div>
<?= form_close(); ?>

<?php if($role == 'apoteker') : ?>
    <?php
        //get warehouse id for this apoteker
        $this->db->select('warehouse_id')->from('users')->where('id', $this->session->userdata('admin')['id']);
        $apoteker_warehouse_id = $this->db->get()->row()->warehouse_id;
    ?>
<?php endif; ?>

<?php if(($role == 'apoteker') || $role == 'super admin' || $role == 'admin' || $role == 'kepala apoteker') : ?>
    <div class="row" style="display: none;">
        <div class="col-sm-12">
            <p><?= anchor('admin/orders/add_order', '<i class="fa fa-plus" aria-hidden="true"></i> ADD MARKETPLACE ORDER'); ?></p>
        </div><!-- end class="col-sm-12" -->
    </div> <!-- end row -->
<?php endif; ?>

<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>Amount (Rp)</th>
            <th>Payment type</th>
            <th>Order Status</th>
            <th>Additional Info</th>
            <th>View Details</th>
        </tr>
    </thead>
    
    <tbody>
        <?php if(count($orders)) : ?>

            <?php if($role == 'apoteker') : ?>

                <?php foreach($orders as $order): ?>

                    <?php
                        //check if current order details contain apoteker warehouse id
                        //get warehouse_id from order_details
                        $this->db->select('warehouse_id')->from('orders_detail')->where('orders_id', $order->id_orders);
                        $warehouse_ids = $this->db->get()->result_array(); ?>


                    <?php if(in_array($apoteker_warehouse_id, array_column($warehouse_ids, 'warehouse_id'))) : ?>
                        <tr>
                        <td><?= $order->id_orders; ?></td>
                        <td><?= date('j M Y H:i:s', strtotime($order->order_date)); ?></td>
                        <td><?= ucwords($order->recipient_name); ?></td>
                        <td>
                            <?php 
                                $final_grand_total = 0;
                                $grand_total =  ($order->total_amount - $order->redeemed_voucher_amount - $order->minus_reward_amount - $order->birthday_promo_amount)+($order->shipping_fee - $order->free_shipping_fee) + $order->ppn;
                                if($grand_total > 0){
                                    $final_grand_total = $grand_total;
                                }
                                echo number_format($final_grand_total);
                            ?>
                        </td>
                        <td><?= ucwords($order->payment_type); ?></td>
                        <td>
                        <?php
                            switch ($order->payment_status) {
                                case 0:
                                    echo '<span style="color:black; font-weight:bold;">Pending</span>';
                                    break;
                                case 1:
                                    echo '<span style="color:brown; font-weight:bold;">Not Paid</span>';
                                    break;
                                case 2:
                                    echo '<span style="color:red; font-weight:bold;">Cancel</span>';
                                    break;
                                case 3:
                                    echo '<span style="color:green; font-weight:bold;">Paid</span>';
                                    break;
                                case 4:
                                    echo '<span style="color:blue; font-weight:bold;">Process</span>';
                                    break;
                                case 5:
                                    echo '<span style="color:blue; font-weight:bold;">In Delivery</span>';
                                    break;
                            }
                        ?>
                        </td>
                        <td>
                        <?php if($order->payment_type == 'bank transfer BCA') : ?>
                            <?php
                                if($order->payment_confirm == 1 ) {
                                    echo 'cust pay confirm: Yes';
                                } else {
                                    echo 'Cust pay confirm: Not Yet';
                                }
                            ?>
                        <?php elseif($order->payment_type == 'bank transfer MANDIRI') : ?>
                            <?php
                                if($order->payment_confirm == 1 ) {
                                    echo 'cust pay confirm: Yes';
                                } else {
                                    echo 'Cust pay confirm: Not Yet';
                                }
                            ?>
                        <?php elseif($order->payment_type == 'midtrans') : ?>
                            <?= $order->payment_status_message; ?>
                        <?php endif; ?>
                        </td>
                        <td><a target="_blank" style="text-decoration: underline;" href="<?= base_url('admin/orders/view') . '/' . $order->id_orders ; ?>">View</a></td>
                    </tr>

                     <?php endif; ?>


                <?php endforeach; ?>

            <?php else : ?>

                <?php foreach($orders as $order): ?>
                    <tr>
                        <td><?= $order->id_orders; ?></td>
                        <td><?= date('j M Y H:i:s', strtotime($order->order_date)); ?></td>
                        <td><?= ucwords($order->recipient_name); ?></td>
                        <td>
                            <?php 
                                $final_grand_total = 0;
                                $grand_total =  ($order->total_amount - $order->redeemed_voucher_amount - $order->minus_reward_amount - $order->birthday_promo_amount)+($order->shipping_fee - $order->free_shipping_fee) + $order->ppn;
                                if($grand_total > 0){
                                    $final_grand_total = $grand_total;
                                }
                                echo number_format($final_grand_total);
                            ?>
                        </td>
                        <td><?= ucwords($order->payment_type); ?></td>
                        <td>
                        <?php
                            switch ($order->payment_status) {
                                case 0:
                                    echo '<span style="color:black; font-weight:bold;">Pending</span>';
                                    break;
                                case 1:
                                    echo '<span style="color:brown; font-weight:bold;">Not Paid</span>';
                                    break;
                                case 2:
                                    echo '<span style="color:red; font-weight:bold;">Cancel</span>';
                                    break;
                                case 3:
                                    echo '<span style="color:green; font-weight:bold;">Paid</span>';
                                    break;
                                case 4:
                                    echo '<span style="color:blue; font-weight:bold;">Process</span>';
                                    break;
                                case 5:
                                    echo '<span style="color:blue; font-weight:bold;">In Delivery</span>';
                                    break;
                            }
                        ?>
                        </td>
                        <td>
                        <?php if($order->payment_type == 'bank transfer BCA') : ?>
                            <?php
                                if($order->payment_confirm == 1 ) {
                                    echo 'cust pay confirm: Yes';
                                } else {
                                    echo 'Cust pay confirm: Not Yet';
                                }
                            ?>
                        <?php elseif($order->payment_type == 'bank transfer MANDIRI') : ?>
                            <?php
                                if($order->payment_confirm == 1 ) {
                                    echo 'cust pay confirm: Yes';
                                } else {
                                    echo 'Cust pay confirm: Not Yet';
                                }
                            ?>
                        <?php elseif($order->payment_type == 'midtrans') : ?>
                            <?= $order->payment_status_message; ?>
                        <?php endif; ?>
                        </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 endif; ?>

        <?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 -->

<script>
    $(document).ready(function() {
        $('#filter_key').change(function() {
            var filter_key      = $(this).val();
            if(filter_key == 'order_id'){
                $('#order_id').show();
                $('#payment_status').hide();
                $('#payment_type').hide();
                $('#date').hide();
                $('#totalorder').hide();
            }
            if((filter_key == 'voucher') || (filter_key == 'flashsale') || (filter_key == 'sale')){
                $('#order_id').hide();
                $('#payment_status').hide();
                $('#payment_type').hide();
                $('#date').hide();
                $('#totalorder').hide();
            }
            if(filter_key == 'payment_status'){
                $('#order_id').hide();
                $('#payment_status').show();
                $('#payment_type').hide();
                $('#date').hide();
                $('#totalorder').hide();
            }
            if(filter_key == 'payment_type'){
                $('#order_id').hide();
                $('#payment_status').hide();
                $('#payment_type').show();
                $('#date').hide();
                $('#totalorder').hide();
            }
            if(filter_key == 'date'){
                $('#order_id').hide();
                $('#payment_status').hide();
                $('#payment_type').hide();
                $('#date').show();
                $('#totalorder').hide();
            }if(filter_key == 'totalorder'){
                $('#order_id').hide();
                $('#payment_status').hide();
                $('#payment_type').hide();
                $('#date').hide();
                $('#totalorder').show();
            }
        });
    });
</script>