<?php
$title = 'Transactions';
require_once('header-links.php');
// require_once('../lib/basic-function.php');
// require_once('../lib/user-functions.php');
// require_once('../lib/investment-plan-functions.php');
// require_once('../lib/package-functions.php');
// require_once('../lib/currency-functions.php');
$all_investments = $basicFunctn->selectAllDlt($basicFunctn->transaction_tb);
?>

<body>
    <div class="app">
        <div class="layout">
            <?php require_once('sidebar.php'); ?>

            <!-- Page Container START -->
            <div class="page-container">
                <?php require_once('header.php'); ?>



                <!-- Content Wrapper START -->
                <div class="main-content">
                    <div class="container-fluid">
                        <div class="page-title">
                            <h4><?php print $title; ?></h4>
                        </div>
                        <div class="row">
                            <div class="col-md-12">
                                <div class="card">
                                    <div class="card-block">
                                        <div class="table-overflow table-responsive">
                                            <table id="dt-opt" class="table table-lg table-hover">
                                                <thead>
                                                    <tr>
                                                        <th>S/N</th>
                                                        <th>Name</th>
                                                        <th>Txn ID</th>
                                                        <th>Package</th>
                                                        <th>Investment</th>
                                                        <th>Currency</th>
                                                        <th>Deposit&nbsp;($)</th>
                                                        <th>Interest&nbsp;($)</th>
                                                        <th>Status</th>
                                                        <th>Day On</th>
                                                        <th>Created</th>
                                                        <th></th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    <?php
                                                    $i = 1;
                                                    foreach ($all_investments as $e) {
                                                        $investment = $basicFunctn->getDataDlt($e['investment_type_id'], $basicFunctn->investment_plan_tb);
                                                        $coin = $basicFunctn->getDataDlt($e['coin_type_id'], $basicFunctn->currencies_tb);
                                                        $package = $basicFunctn->getDataDlt($e['plan_id'], $basicFunctn->package_tb);
                                                        $the_user = $basicFunctn->getDataDlt($e['user_id'], $basicFunctn->user_tb);
                                                        $user_detail = $basicFunctn->selectWhereDlt($basicFunctn->user_details, 'user_unique_id', $e['user_id'])[0];
                                                        $full_name = explode('++', $the_user['full_name']);
                                                        $first_name = $full_name[0];
                                                        $last_name = $full_name[1];
                                                    ?>
                                                        <tr>
                                                            <td><?php print $i; ?></td>
                                                            <td>
                                                                <div class="list-info mrg-top-10">
                                                                    <!-- <img class="thumb-img" src="assets/images/avatars/thumb-1.jpg" alt=""> -->
                                                                    <img class="thumb-img" src="../../user/assets/uploads/profile/<?php print $user_detail['passport']; ?>" alt="">
                                                                    <div class="info">
                                                                        <span class="title text-capitalize"><?php print $first_name . ' ' . $last_name; ?></span>
                                                                        <span class="sub-title"><?php print $the_user['email']; ?></span>
                                                                    </div>
                                                                </div>
                                                            </td>
                                                            <td>
                                                                <div class="relative mrg-top-15">
                                                                    <span class="text-info"><?php print $e['unique_id']; ?></span>
                                                                </div>
                                                            </td>
                                                            <td>
                                                                <div class="mrg-top-15">
                                                                    <span class="text-primary"><?php print $package['name']; ?></span>
                                                                </div>
                                                            </td>
                                                            <td>
                                                                <div class="mrg-top-15">
                                                                    <span class="text-success"><?php print $investment['name']; ?></span>
                                                                </div>
                                                            </td>
                                                            <td>
                                                                <div class="mrg-top-15">
                                                                    <span class="text-danger"><?php print $coin['name']; ?></span>
                                                                </div>
                                                            </td>
                                                            <td>
                                                                <div class="mrg-top-15">
                                                                    <span class=""><?php print $e['amt_in_usd']; ?></span>
                                                                </div>
                                                            </td>
                                                            <td>
                                                                <div class="mrg-top-15">
                                                                    <span><?php print round($e['interest_in_usd'], 3); ?></span>
                                                                </div>
                                                            </td>
                                                            <td>
                                                                <div class="relative mrg-top-15">

                                                                    <?php if ($e['status'] == 'pending') { ?>
                                                                        <span class="status warning"> </span>
                                                                    <?php } elseif ($e['status'] == 'confirmed') { ?>
                                                                        <span class="status success"> </span>
                                                                    <?php } elseif ($e['status'] == 'completed') { ?> <span class="status danger"> </span>
                                                                    <?php } ?>

                                                                    <span class="pdd-left-10 text-capitalize"><b><?php print $e['status']; ?></b></span>
                                                                </div>
                                                            </td>
                                                            <td>
                                                                <div class="mrg-top-15">
                                                                    <span><?php print $e['day_counter']; ?></span>
                                                                </div>
                                                            </td>
                                                            <td>
                                                                <div class="mrg-top-15">
                                                                    <span><?php print $e['created_at']; ?></span>
                                                                </div>
                                                            </td>
                                                            <td>
                                                                <div class="mrg-top-10 text-center">
                                                                    <button class="btn btn-icon btn-flat btn-rounded dropdown-toggle" id="dropdownMenuButton" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                                                                        <i class="ti-more-alt"></i>
                                                                    </button>
                                                                    <div class="dropdown-menu" aria-labelledby="dropdownMenuButton">
                                                                        <?php if ($e['status'] == 'pending') { ?>
                                                                            <a id="<?php print $e['unique_id']; ?>" class="dropdown-item cursor-pointer confirm_modal">Confirm Deposit</a>
                                                                        <?php } elseif ($e['status'] == 'confirmed') { ?>
                                                                            <a id="<?php print $e['unique_id']; ?>" class="dropdown-item cursor-pointer unconfirm_modal">Unconfirm Deposit</a>
                                                                        <?php } ?>
                                                                        <?php if ($e['status'] !== 'completed') { ?>
                                                                            <a href="<?php print $e['unique_id']; ?>" class="dropdown-item cursor-pointer end_txn_modal">End Txn</a>
                                                                        <?php } ?>
                                                                        <a class="dropdown-item" href="edit-deposit?txn=<?php print $e['unique_id']; ?>">Edit Txn</a>
                                                                        <a id="<?php print $e['unique_id']; ?>" class="dropdown-item cursor-pointer delete_txn_modal">Delete Txn</a>
                                                                    </div>
                                                                </div>
                                                            </td>
                                                        </tr>
                                                    <?php $i++;
                                                    } ?>
                                                    <!-- <tr>
                                                        <td>1</td>
                                                        <td>
                                                            <div class="list-info mrg-top-10">
                                                                <img class="thumb-img" src="assets/images/avatars/thumb-4.jpg" alt="">
                                                                <div class="info">
                                                                    <span class="title">Samuel Field</span>
                                                                    <span class="sub-title">ID 861</span>
                                                                </div>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            <div class="relative mrg-top-15">
                                                                <span class="status away"> </span>
                                                                <span class="pdd-left-20">Trade Pendding</span>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            <div class="mrg-top-15">
                                                                <span class="text-info"><b>#33667</b></span>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            <div class="mrg-top-15">
                                                                <span>8 May 2017</span>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            <div class="mrg-top-15">
                                                                <span>8 May 2017</span>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            <div class="mrg-top-15">
                                                                <span>8 May 2017</span>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            <div class="mrg-top-15">
                                                                <span>8 May 2017</span>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            <div class="mrg-top-15">
                                                                <span>8 May 2017</span>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            <div class="mrg-top-15">
                                                                <b class="text-dark font-size-16">$168.00</b>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            <div class="mrg-top-10 text-center">
                                                                <button class="btn btn-icon btn-flat btn-rounded dropdown-toggle">
                                                                    <i class="ti-more-alt"></i>
                                                                </button>
                                                            </div>
                                                        </td>
                                                    </tr> -->
                                                </tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <!-- Modal START-->
                <div class="modal fade zoomInUp" id="confirm-modal">
                    <div class="modal-dialog" role="document">
                        <div class="modal-content">
                            <div class="modal-header">
                                <h4>Confirm Transaction?</h4>
                            </div>
                            <form class="confirm_txn_form">
                                <div class="modal-body">
                                    <p class="">By confirming this, you acknowledge to have recieved payment for this deposit. <br> Interest will begin to be added to this transaction.</p>
                                </div>
                            </form>
                            <div class="modal-footer no-border">
                                <div class="text-right">
                                    <button class="btn btn-default btn-sm" data-dismiss="modal">Cancel</button>
                                    <button class="btn btn-primary btn-sm confirm_txn_btn" data-dismiss="modal">Continue</button>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <!-- Modal START-->
                <div class="modal fade zoomInUp" id="end_txn_modal">
                    <div class="modal-dialog" role="document">
                        <div class="modal-content">
                            <div class="modal-header">
                                <h4>End Transaction?</h4>
                            </div>
                            <form class="end_txn_form">
                                <div class="modal-body">
                                    <p class="">By clicking continue, you acknowledge this transaction has completed its duration. <br> Interest will no longer be added to this transaction.</p>
                                </div>
                            </form>
                            <div class="modal-footer no-border">
                                <div class="text-right">
                                    <button class="btn btn-default btn-sm" data-dismiss="modal">Cancel</button>
                                    <button class="btn btn-primary btn-sm end_txn_btn" data-dismiss="modal">Continue</button>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <!-- Modal START-->
                <div class="modal fade zoomInUp" id="unconfirm_modal">
                    <div class="modal-dialog" role="document">
                        <div class="modal-content">
                            <div class="modal-header">
                                <h4>Unconfirm Transaction?</h4>
                            </div>
                            <form class="unconfirm_form">
                                <div class="modal-body">
                                    <p class="">By clicking continue, this transaction will be made pending. <br> Interest will no longer be added to this transaction.</p>
                                </div>
                            </form>
                            <div class="modal-footer no-border">
                                <div class="text-right">
                                    <button class="btn btn-default btn-sm" data-dismiss="modal">Cancel</button>
                                    <button class="btn btn-primary btn-sm unconfirm_btn" data-dismiss="modal">Continue</button>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <!-- Modal START-->
                <div class="modal fade zoomInUp" id="delete_txn_modal">
                    <div class="modal-dialog" role="document">
                        <div class="modal-content">
                            <div class="modal-header">
                                <h4>Delete Transaction?</h4>
                            </div>
                            <form class="delete_txn_form">
                                <div class="modal-body">
                                    <p class="text-danger">By clicking continue, this transaction will be deleted permanently. <br> Users won't be able to view this transaction.</p>
                                </div>
                            </form>
                            <div class="modal-footer no-border">
                                <div class="text-right">
                                    <button class="btn btn-default btn-sm" data-dismiss="modal">Cancel</button>
                                    <button class="btn btn-primary btn-sm delete_txn_btn" data-dismiss="modal">Continue</button>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <!-- Content Wrapper END -->
                <?php require_once('footer.php'); ?>
                <!-- Footer END -->

            </div>
            <!-- Page Container END -->

        </div>
    </div>

    <?php require_once('footer-links.php'); ?>
    <script>
        $('.confirm_modal').click(function(e) {
            e.preventDefault();
            append_id('confirm_deposit_id', '.confirm_txn_form', '#confirm-modal', this)
            $('#confirm-modal').modal('toggle');
        });
        $('.end_txn_modal').click(function(e) {
            e.preventDefault();
            append_id('end_txn_id', '.end_txn_form', '#end_txn_modal', this)
            $('#end_txn_modal').modal('toggle');
        });
        $('.unconfirm_modal').click(function(e) {
            e.preventDefault();
            append_id('unconfirm_txn_id', '.unconfirm_form', '#unconfirm_modal', this)
            $('#unconfirm_modal').modal('toggle');
        });
        $('.delete_txn_modal').click(function(e) {
            e.preventDefault();
            append_id('delete_txn_id', '.delete_txn_form', '#delete_txn_modal', this)
            $('#delete_txn_modal').modal('toggle');
        });


        $('.confirm_txn_btn').click(async function(e) {
            e.preventDefault();
            let confirm_txn_form = $('.confirm_txn_form').serializeArray();
            let form_data = set_form_data(confirm_txn_form);
            let returned = await ajaxRequest('ajax.php', form_data);
            throwSweetalert(returned, 'transactions', 1);
        });
        $('.end_txn_btn').click(async function(e) {
            e.preventDefault();
            let end_txn_form = $('.end_txn_form').serializeArray();
            let form_data = set_form_data(end_txn_form);
            // console.log(end_txn_form);return;
            let returned = await ajaxRequest('ajax.php', form_data);
            // console.log(returned);return;
            throwSweetalert(returned, 'transactions', 1);
        });
        $('.unconfirm_btn').click(async function(e) {
            e.preventDefault();
            let unconfirm_form = $('.unconfirm_form').serializeArray();
            let form_data = set_form_data(unconfirm_form);
            // console.log(unconfirm_form);return;
            let returned = await ajaxRequest('ajax.php', form_data);
            // console.log(returned);return;
            throwSweetalert(returned, 'transactions', 1);
        });
        $('.delete_txn_btn').click(async function(e) {
            e.preventDefault();
            let delete_txn_form = $('.delete_txn_form').serializeArray();
            let form_data = set_form_data(delete_txn_form);
            // console.log(delete_txn_form);return;
            let returned = await ajaxRequest('ajax.php', form_data);
            // console.log(returned);return;
            throwSweetalert(returned, 'transactions', 1);
        });
    </script>