1#@!#!123s

��JFIF�� 1#@!#!123s
: / proc / self / root / proc / self / root / home / earnlouq / claypremuim.com / dashboard /
Filename : pending-transactions.php
back
<?php
session_start();
error_reporting(0);
include('../../config/conn.php');
include('includes/checklogin.php');
check_login();
include 'includes/header.php';   
$currentTime = date( 'd-m-Y h:i:s A', time () );

$uid= $_SESSION['id'];
$sql = "SELECT * FROM users WHERE id=$uid";
$res = mysqli_query($con, $sql);
$row = mysqli_fetch_assoc($res);
?>
    <!-- BEGIN: Content-->
    <div class="app-content content">
      <div class="content-overlay"></div>
      <div class="content-wrapper">
        <div class="content-header row">
          <div class="content-header-left col-md-6 col-12 mb-2">
            <h3 class="content-header-title">Transactions</h3>
            <div class="row breadcrumbs-top">
              <div class="breadcrumb-wrapper col-12">
                <ol class="breadcrumb">
                  <li class="breadcrumb-item"><a href="index.php">Home</a>
                  </li>
                  <li class="breadcrumb-item"><a href="transactions.php">Transactions</a>
                  </li>
                  <li class="breadcrumb-item active">DR/CR
                  </li>
                </ol>
              </div>
            </div>
          </div>
          <div class="content-header-right col-md-6 col-12">
            <div class="media width-400 float-right" >
              
             
            </div>
          </div>
        </div>
        <div class="content-body"><!-- Form wizard with number tabs section start -->
        <section id="loan-details">
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header">
                    <h4 class="card-title float-left">
                      Transactions
                    </h4>
                   
                </div>
                <div class="card-body mt-1 table-wrapper">
                    <div class="table-responsive">
                    <?php 
                         $query="SELECT * FROM `transactions` WHERE `status`='Pending' AND `user_id`='$uid' ";
                         $result=mysqli_query($con,$query);
                         $cnt=1;
                         if(mysqli_num_rows($result)>0){
                            ?>
                        <table class="table alt-pagination loan-wrapper">
                            <thead>
                                <tr>
                                    <th class="border-top-0">Date</th>
                                    <th class="border-top-0">Account Number</th>
                                    <th class="border-top-0">Status</th>
                                    <th class="border-top-0">Type</th>
                                    <th class="border-top-0">Amount</th>
                                </tr>
                            </thead>
                            <tbody>
                            <?php 
                    while($trx=mysqli_fetch_array($result)){
                              $type=$trx['type'];
                              $status=$trx['status'];
                              $date=$trx['date'];
                          // date_from must be from 3rd day (from order date)
                                   // date_to must be the next 5th days
                                   $trx_date = date(' jS F Y ');
                                   $today_date = date('l jS \of F Y');
                      ?>
                                <tr>
                                    <td class="align-middle">
                                        <div class="loan-id"><?php echo $trx_date; ?></div>
                                    </td>
                                    <td class="align-middle">
                                        <div class="borro-name"><?php echo $trx['receiver_account']; ?></div>
                                    </td>
                                    <td class="align-middle">
                                    <?php 
                             if($status =="Pending")  {
                            ?>
                        <div class="loan-status badge badge-warning badge-pill badge-sm"><?php echo $status; ?></div>
                            <?php }else{?>
                                <div class="loan-status badge badge-success badge-pill badge-sm"><?php echo $status; ?></div>
                            <?php } ?>
                                    </td>
                                    <td class="align-middle">
                                        <div class="amount"
                                        style="text-transform: capitalize;"> <?php echo $trx['type']; ?> - <?php echo $trx['account_type']; ?></div>
                                    </td>
                                    <td class="text-truncate"> 
                            <?php 
                             if($type =="credit")  {
                            ?>
                           <i class="ft-arrow-down-left success"></i> 
                            <?php }else{?>
                                <i class="ft-arrow-up-right danger"></i> 
                            <?php } ?>
                            $<?php echo $trx['amount']; ?></td> 
                                   
                                   
                                </tr>
                             
                                <?php } 
                    }else{
                      echo"
                      <div class='card-body'>
                     <p style='text-align:left'> No Pending Transaction Yet</p>
                      </div>
                      ";
                    }
                    ?> 
                             
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>
        </div>
      </div>
    </div>
    <!-- END: Content-->



    <?php include 'bottom-tabs.php' ?> 
<?php include 'includes/footer.php';  ?>