<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>Customer Wishlists</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">
    <div class="col-sm-12">
        <p><a href="<?= base_url('admin/wishlist_excel_export'); ?>"><img src="<?= base_url('assets/admin/img/excel-icon.png'); ?>"> EXPORT KE MS EXCEL</a></p>
        <p>(Export File Excel)</p>
    </div>
</div>

<section>

   <div>
   <table class="table table-striped">
    <thead>
        <tr>
            <th>Customer</th>
            <th>Wishlist Product Name</th>
        </tr>
    </thead>
    <tbody>
    	<?php if(count($wishlists)) : ?> 
        <?php foreach($wishlists as $wishlist): ?>
        	<tr>
                <td>
                    <ul style="list-style:none; margin-left:0;">
                        <?php
                            //get customer lists
                            $this->db->select('name, email, phone')->from('customers')->where('id_customers', $wishlist->customer_id);
                            $customer = $this->db->get()->row();
                        ?>
                        <li><?= ucwords($customer->name); ?>. E: <?= ucwords($customer->email); ?> P: <?= ucwords($customer->phone); ?></li>
                    </ul>
                </td>
            	<td>
                    <?php
                        //get product name and product links
                        $this->db->select('title, alias')->from('products')->where('id_products', $wishlist->product_id);
                        $product = $this->db->get()->row();
                    ?>
                    <p><a href="<?= base_url() . 'product/' . $product->alias; ?>" target="_blank"><?= ucwords($product->title); ?></a></p>
                </td>
            	
            </tr>
        <?php endforeach; ?>
        <?php else: ?>
        	<tr>
            <td colspan="3">No wishlist at the moment.</td>
            </tr>
        <?php endif; ?>

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