<div class="row">
    <div class="col-sm-12">
        <p><a href="<?= base_url('admin/reseller_page'); ?>"><i class="fa fa-arrow-left" aria-hidden="true"></i> Kembali ke halaman Reseller</a></p>
        <h2>Administrasi Reseller</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><?= anchor('admin/resellers/add_reseller', '<i class="fa fa-plus" aria-hidden="true"></i> TAMBAH RESELLER BARU'); ?></p>
    </div><!-- end class="col-sm-12" -->
</div> <!-- end row -->

<div class="row">
    <div class="col-sm-12">
        <div class="table-responsive">
            <table class="table table-striped">
                <thead>
                    <tr>
                        <th>Nama Reseller</th>
                        <th>E-mail</th>
                        <th>Tanggal Bergabung</th>
                        <th>Total Beli (Rp)</th>
                        <th>Tipe Reseller</th>
                        <th>Dropship</th>
                        <th>Status</th>
                        <th>Edit Info</th>
                        <th>Hapus</th>

                    </tr>
                </thead>
                <tbody>
                    <?php if (count($customers)) : ?>
                        <?php foreach ($customers as $customer) : ?>
                            <tr>
                                <td><?= ucfirst($customer->name); ?></td>
                                <td><?= ucfirst($customer->email); ?></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, redeemed_voucher_amount, minus_reward_amount, shipping_fee, free_shipping_fee')->from('orders')->where('customer_id', $customer->id_customers)->where('(payment_status=5 or payment_status=8)');
                                    $purchases = $this->db->get()->result();


                                    foreach ($purchases as $purchase) {
                                        $grand_total = (($purchase->total_amount - $purchase->redeemed_voucher_amount - $purchase->minus_reward_amount) + ($purchase->shipping_fee - $purchase->free_shipping_fee));
                                        $total_purchase = $total_purchase + $grand_total;
                                    }
                                    echo number_format($total_purchase);
                                    ?>
                                    <a href="<?= base_url() . 'admin/orders_retailer/customer/' . $customer->id_customers; ?>" target="_blank">&nbsp;&nbsp;<i class="fa fa-eye" aria-hidden="true"></i> Lihat</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>
                                    <?php if ($customer->dropship == 'yes') : ?>
                                        Iya
                                    <?php else : ?>
                                        Tidak
                                    <?php endif; ?>
                                </td>
                                <td>
                                    <?php if ($customer->status == 1) : ?>
                                        Aktif
                                    <?php else : ?>
                                        Tidak Aktif
                                    <?php endif; ?>
                                </td>
                                <td><?= bt_edit('admin/resellers/edit_reseller/' . $customer->id_customers); ?></td>
                                <td><?= bt_delete('admin/resellers/delete_reseller/' . $customer->id_customers); ?></td>
                            </tr>
                        <?php endforeach; ?>
                    <?php else : ?>
                        <tr>
                            <td colspan="3">We could not find any reseller.</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 -->