<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>
        <h2>Customers Administration</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 --> 

<div class="row">
    <?= form_open('admin/customers'); ?> 
    <div class="col-sm-5 col-xs-6"> 
        <input class="form-control" type="text" placeholder="Enter Customer Name" name="customer" 
        <?php if (isset($keyword)) : ?>
            value="<?= ucwords($keyword); ?>" 
        <?php endif; ?>>
    </div><!-- end class="col-sm-8" -->   

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

<div class="row">
    <div class="col-sm-12">
        <p><?= anchor('admin/customers/add', '<i class="fa fa-plus" aria-hidden="true"></i> ADD A NEW CUSTOMER'); ?></p> 
    </div><!-- end class="col-sm-12" -->
</div> <!-- end row -->  

<div class="row">
    <div class="col-sm-12">
        <table class="table table-striped"> 
    <thead>
        <tr>
            <th>ID</th>
            <th>Customer Name</th>
            <th>Email</th>
            <th>Phone</th>
            <th>Join Date</th>  
            <th>Total Purchases (Rp)</th>
            <th>Reseller Type</th>
            <th>Dropship</th>
            <th>Status</th>
            <th>Edit Info</th>
            <th>Delete</th>
            
        </tr>
    </thead>
    <tbody>
    	<?php if(count($customers)) : ?> 
        <?php foreach($customers as $customer): ?>
        	<tr>
                <td><?= $customer->id_customers; ?></td>
            	<td><?= ucfirst($customer->name); ?></td>
                <td><a href="mailto:<?= $customer->email; ?>"><?= ucfirst($customer->email); ?></a></td>
                <td><?= ucfirst($customer->phone); ?></td>
                <td>
                    <?php
                        $join_date = date('d M Y', strtotime($customer->join_date)); 
                        echo $join_date;
                    ?>
                 </td>
                <td>
                    <?php
                        //get total purchase
                        $total_purchase = 0;
                        $this->db->select('total_amount')->from('orders')->where('customer_id', $customer->id_customers)->where('(payment_status=1 or payment_status=3)');
                        $purchases = $this->db->get()->result();
                        foreach($purchases as $purchase) {
                            $total_purchase = $total_purchase + $purchase->total_amount;
                        }
                        echo number_format($total_purchase);
                    ?>  
                    <a href="<?= base_url() . 'admin/orders/customer/' . $customer->id_customers; ?>" target="_blank">&nbsp;&nbsp;<i class="fa fa-eye" aria-hidden="true"></i> view</a>
                </td>
                <td>
                    <?php if($customer->reseller_id == NULL) : ?>
                        Regular Customer
                    <?php else : ?>
                        <?php
                            //get reseller type
                            $this->db->select('reseller_name')->from('resellers')->where('id_resellers', $customer->reseller_id);
                            $reseller_name = $this->db->get()->row()->reseller_name;
                            echo ucwords($reseller_name); 
                        ?>   
                    <?php endif; ?>
                </td>
                <td><?= ucfirst($customer->dropship); ?></td>
                <td>
                    <?php if($customer->status == 1) : ?>
                        Active
                    <?php else : ?>
                        Not Active  
                    <?php endif; ?>    
                </td>
                <td><?= bt_edit('admin/customers/edit/' . $customer->id_customers); ?></td>
                <td><?= bt_delete('admin/customers/delete/' . $customer->id_customers); ?></td>
            </tr>
        <?php endforeach; ?>
        <?php else: ?>
        	<tr>
            <td colspan="3">We could not find any customer.</td>
            </tr>
        <?php endif; ?>

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