Ultra File Manager

Edit: /home/u523034047/domains/eipcsindia.com/public_html/LoanApp/dashboard2.php

<?php
session_start();
include 'connection.php';

if (!isset($_SESSION['username'])) {
    header("Location: signin.php");
    exit();
}

$username = $_SESSION['username'];

// Step 1: Calculate total paid from transaction table
$sql_total_paid = "SELECT IFNULL(SUM(amount), 0) AS total_paid 
                   FROM transaction 
                   WHERE username = ? AND type = 'Credit'";
$stmt_total_paid = $conn->prepare($sql_total_paid);
$stmt_total_paid->bind_param("s", $username);
$stmt_total_paid->execute();
$stmt_total_paid->bind_result($total_paid);
$stmt_total_paid->fetch();
$stmt_total_paid->close();

// Step 2: Update loan_paid in user_reg table
$update_sql = "UPDATE user_reg SET loan_paid = ? WHERE username = ?";
$update_stmt = $conn->prepare($update_sql);
$update_stmt->bind_param("ds", $total_paid, $username);
$update_stmt->execute();
$update_stmt->close();

// Step 3: Fetch updated user details
$sql = "SELECT profile_image, loan_amount, loan_paid, name FROM user_reg WHERE username = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("s", $username);
$stmt->execute();
$result = $stmt->get_result();

if ($row = $result->fetch_assoc()) {
    $loan_amount = $row['loan_amount'];
    $loan_paid = $row['loan_paid'];
    $due_amount = $loan_amount - $loan_paid;
} else {
    echo "User not found.";
    exit();
}

// Step 4: Fetch last 10 transactions
$trans_sql = "SELECT amount, type, description, method, created_at 
              FROM transaction 
              WHERE username = ? 
              ORDER BY created_at DESC 
              LIMIT 10";
$trans_stmt = $conn->prepare($trans_sql);
$trans_stmt->bind_param("s", $username);
$trans_stmt->execute();
$trans_result = $trans_stmt->get_result();

// Close connections
$stmt->close();
$conn->close();
?>

<!doctype html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <meta name="description" content="">
    <meta name="author" content="">
    <meta name="generator" content="">
    <title>FiMobile V2.0 - Mobile HTML template</title>

<meta name="apple-mobile-web-app-capable" content="yes">
    <link rel="manifest" href="manifest.json" />

<link rel="apple-touch-icon" href="assets/img/favicon180.png" sizes="180x180">
    <link rel="icon" href="assets/img/favicon32.png" sizes="32x32" type="image/png">
    <link rel="icon" href="assets/img/favicon16.png" sizes="16x16" type="image/png">

<link rel="stylesheet" href="../../../../cdn.jsdelivr.net/npm/bootstrap-icons%401.5.0/font/bootstrap-icons.css">

<link rel="stylesheet" href="assets/vendor/swiperjs-6.6.2/swiper-bundle.min.css">

<link href="assets/css/style.css" rel="stylesheet" id="style">
</head>

<div class="container-fluid loader-wrap">
        <div class="row h-100">
            <div class="col-10 col-md-6 col-lg-5 col-xl-3 mx-auto text-center align-self-center">
                <div class="loader-cube-wrap loader-cube-animate mx-auto">
                    <img src="assets/img/logo.png" alt="Logo">
                </div>
                <p class="mt-4">It's time for track budget<br><strong>Please wait...</strong></p>
            </div>
        </div>
    </div>

<?php include('header.php'); ?>
    
    <main class="h-100">

<header class="header position-fixed">
            <div class="row">
                <div class="col-auto">
                    <a href="javascript:void(0)" target="_self" class="btn btn-light btn-44 menu-btn">
                        <i class="bi bi-list"></i>
                    </a>
                </div>
                <div class="col align-self-center text-center">
                    <div class="logo-small">
                        <img src="assets/img/logo.png" alt="">
                        <h5>Loan App</h5>
                    </div>
                </div>
                <div class="col-auto">
                    <a href="notifications.php" target="_self" class="btn btn-light btn-44">
                        <i class="bi bi-bell"></i>
                        <span class="count-indicator"></span>
                    </a>
                </div>
            </div>
        </header>

<div class="main-container container">
            
            <div class="row mb-4">
                <div class="col-auto">
                    <div class="avatar avatar-50 shadow rounded-10">
                    <?php if (!empty($row['profile_image'])): ?>
    <img src="admin/user_photos/<?php echo htmlspecialchars($row['profile_image']); ?>" alt="Profile Image" >
<?php else: ?>
    <img src="assets/img/user-placeholder.png" alt="No Image" >
<?php endif; ?>
                    </div>
                </div>
                <div class="col align-self-center ps-0">
                    <h4 class="text-color-theme"><span class="fw-normal">Hi</span>, <?php echo htmlspecialchars($row['name']); ?></h4>
                   
                </div>
            </div>

<div class="row mb-3">
                <div class="col-12 px-0">
                   <div class="row g-3">
    
    <div class="col-md-4 col-sm-6 col-12">
        <div class="card">
            <div class="card-body">
                <div class="d-flex justify-content-between align-items-center mb-3">
                    <img src="assets/img/masterocard.png" alt="" class="me-2">
                    <p class="mb-0 text-end">Total Loan Amount</p>
                </div>
                <h4 class="fw-normal mb-0">
                    <?php echo number_format($loan_amount, 2); ?>
                    <span class="small text-muted"> ₹</span>
                </h4>
            </div>
        </div>
    </div>

<div class="col-md-4 col-sm-6 col-12">
        <div class="card">
            <div class="card-body">
                <div class="d-flex justify-content-between align-items-center mb-3">
                    <img src="assets/img/masterocard.png" alt="" class="me-2">
                    <p class="mb-0 text-end">Submitted Amount</p>
                </div>
                <h4 class="fw-normal mb-0">
                    <?php echo number_format($loan_paid, 2); ?>
                    <span class="small text-muted"> ₹</span>
                </h4>
            </div>
        </div>
    </div>

<div class="col-md-4 col-sm-6 col-12">
        <div class="card">
            <div class="card-body">
                <div class="d-flex justify-content-between align-items-center mb-3">
                    <img src="assets/img/masterocard.png" alt="" class="me-2">
                    <p class="mb-0 text-end">Due Amount</p>
                </div>
                <h4 class="fw-normal mb-0">
                    <?php echo number_format($due_amount, 2); ?>
                    <span class="small text-muted"> ₹</span>
                </h4>
            </div>
        </div>
    </div>

<?php if($due_amount <= 0): ?>
    <div class="col-12 text-center mt-3">
        <a href="new-loan-apply.php" class="btn btn-success btn-lg shadow-sm">
            Apply New Loan
        </a>
    </div>
    <?php endif; ?>
</div>

</div>
            </div>
<script>
document.addEventListener('DOMContentLoaded', function () {
    var swiper = new Swiper('.cardswiper', {
        slidesPerView: 1,
        spaceBetween: 10,
        loop: true,
        pagination: {
            el: '.swiper-pagination',
            clickable: true,
        }
    });
});
</script>
           <div class="swiper-container cardswiper">
  <div class="swiper-wrapper">
 
  </div>
  
  <div class="swiper-pagination"></div>
</div>

<div class="row mb-3">
                 <div class="col">
    <h6 class="title">
        Transactions<br>
        <small class="fw-normal text-muted">Today, <span id="todayDate"></span></small>
    </h6>
</div>

</div>
            </div>

</div>

</main>
    
<?php include('footer.php'); ?>

<script src="assets/js/jquery-3.3.1.min.js"></script>
    <script src="assets/js/popper.min.js"></script>
    <script src="assets/vendor/bootstrap-5/js/bootstrap.bundle.min.js"></script>

<script src="assets/js/jquery.cookie.js"></script>

<script src="assets/js/main.js"></script>
    <script src="assets/js/color-scheme.js"></script>

<script src="assets/js/pwa-services.js"></script>

<script src="assets/vendor/chart-js-3.3.1/chart.min.js"></script>

<script src="assets/vendor/progressbar-js/progressbar.min.js"></script>

<script src="assets/vendor/swiperjs-6.6.2/swiper-bundle.min.js"></script>

<script src="assets/js/app.js"></script>

</body>

</html>

Ukuran: 11.4 KB