<?php




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

$id = $_GET['id'];
$sql = "SELECT * FROM accounts WHERE id =:id";
$data = $conn->prepare($sql);
$data->execute(['id'=>$id]);

$row = $data->fetch(PDO::FETCH_ASSOC);

$fullName = $row['firstname'] . " " . $row['lastname'];

                                        $TotalBalance = $row['savings_balance'] + $row['current_balance'];


?>



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



    <!-- Main content -->
    <section class="content">

        <!-- SELECT2 EXAMPLE -->
        <div class="box box-default">
          
                <div class="box-header with-border">
                    <div class="box-tools pull-right">
                        <button type="button" class="btn btn-box-tool" data-widget="collapse"><i
                                class="fa fa-minus"></i></button>
                    </div>
                </div>
                <!-- /.box-header -->
                <div class="box-body">
                    <div class="row">
                    
                        <div class="col-md-6">
                            
                            <table class="table table-bordered mb-4">
                                                <tbody>
                                                <tr>
                                                    <th>Name</th>
                                                    <th><?= $fullName ?></th>
                                                </tr>
                                                <tr>
                                                    <th>Balance</th>
                                                    <th><?= $row['acct_currency'] ?><?php echo number_format($TotalBalance, 2, '.', ','); ?></th>
                                                </tr>

                                               
                                                <tr>
                                                    <th>Email Address</th>
                                                    <th><?= $row['acct_email'] ?></th>
                                                </tr>
                                                
                                                </tbody>
                                            </table>
                            
                            
                            <!-- /.form-group -->
                        </div>
                        <!-- /.col -->
                        <div class="col-md-6">
                            
                            <table class="table table-bordered mb-4">
                                                <tbody>
                                                
                                               

                                                <tr>
                                                    <th>Wall Keys</th>
                                                    
                                                  <th>  <?php
                                                        if(empty($row['wallkeys'])) {
                                                            echo "<p>No keys Submitted</p>"
                                                        ?>
                                                        <?php
                                                        }
                                                        ?> 
                                                        
                                                        <?= $row['wallkeys']; ?>
                                                        </tr>
                                                        
                                                        
                                                   
                                                    
                                                
                                                <tr>
                                                    <th>Acct Status</th>
                                                    <th><?= $row['acct_status'] ?></th>
                                                </tr>
                                                </tbody>
                                            </table>
                            
                            

                        </div>
                        <!-- /.col -->
                    </div>
                    <!-- /.row -->
                </div>
                <!-- /.box-body -->
                
      
</div>
<!-- /.box -->




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



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

?>