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: 2_content.php

<div class="content-header">
    <div class="container-fluid">
        <div class="row mb-2">
            <div class="col-sm-6">
                <h1 class="m-0">Pastor 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 getTotalMembers(); ?></h3>
                        <p>Total Members</p>
                    </div>
                    <div class="icon">
                        <i class="ion ion-person"></i>
                    </div>
                    <a href="#" class="small-box-footer">More info <i class="fas fa-arrow-circle-right"></i></a>
                </div>
            </div>
            
            <div class="col-lg-3 col-6">
                <div class="small-box bg-success">
                    <div class="inner">
                        <h3><?php echo getTotalExpenses(); ?></h3>
                        <p>Total Expenses</p>
                    </div>
                    <div class="icon">
                        <i class="ion ion-cash"></i>
                    </div>
                    <a href="#" class="small-box-footer">More info <i class="fas fa-arrow-circle-right"></i></a>
                </div>
            </div>
            
            <div class="col-lg-3 col-6">
                <div class="small-box bg-warning">
                    <div class="inner">
                        <h3><?php echo getTotalDonations(); ?></h3>
                        <p>Total Donations</p>
                    </div>
                    <div class="icon">
                        <i class="ion ion-social-usd"></i>
                    </div>
                    <a href="#" class="small-box-footer">More info <i class="fas fa-arrow-circle-right"></i></a>
                </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 class="icon">
                        <i class="ion ion-flag"></i>
                    </div>
                    <a href="#" class="small-box-footer">More info <i class="fas fa-arrow-circle-right"></i></a>
                </div>
            </div>
        </div>

<div class="card">
            <div class="card-header">
                <h3 class="card-title">Members Table</h3>
            </div>
            
            <div class="card-body" >
                        <div class="table-responsive" style="overflow-x: auto;">
                <table id="membersTable" class="table table-bordered table-hover">
                    <thead>
                    <tr>
                        <th>Member ID</th>
                        <th>Name</th>
                        <th>O. Names</th>
                        <th>Mob.</th>
                        <th>Tel.</th>
                        <th>Email</th>
                        <th>DOB</th>
                        <th>Occup.</th>
                        <th>N.O Kin</th>
                        <th>N.O Mob</th>
                        <th>Address 1</th>
                        <th>Address 2</th>
                        <th>City/County</th>
                        <th>Country</th>
                        <th>B.C Method</th>
                        <th>Soc. Media</th>
                        <th>Weekday C.T</th>
                        <th>Weekend C.T</th>
                        <th>Email Cont</th>
                        <th>Text Cont</th>
                        <th>Connect as Family</th>
                        
                    </tr>
                    </thead>
                    <tbody>
                    <?php echo getMembersTable(); ?>
                    </tbody>
                </table>
                </div>
            </div>
            
        </div>

</div>
    
</section>

<?php
// ...

// Function to fetch total members (replace with your database query)
function getTotalMembers() {
    global $conn;
    $query = "SELECT COUNT(*) AS totalMembers FROM members";
    $result = $conn->query($query);

if ($result) {
        $row = $result->fetch_assoc();
        return $row['totalMembers'];
    } else {
        return "Error fetching total members";
    }
}

// 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 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 members table data (replace with your database query)
function getMembersTable() {
    global $conn;
    $query = "SELECT * FROM members";
    $result = $conn->query($query);

$tableData = '';

if ($result && $result->num_rows > 0) {
        while ($row = $result->fetch_assoc()) {
            $tableData .= "<tr>
            <td>{$row['member_id']}</td>
            <td>{$row['name']}</td>
            <td>{$row['other_names']}</td>
            <td>{$row['mobile']}</td>
            <td>{$row['telephone']}</td>
            <td>{$row['email']}</td>
            <td>{$row['dob']}</td>
            <td>{$row['occupation']}</td>
            <td>{$row['next_of_kin']}</td>
            <td>{$row['next_of_kin_mobile']}</td>
            <td>{$row['address1']}</td>
            <td>{$row['address2']}</td>
            <td>{$row['city_county']}</td>
            <td>{$row['country']}</td>
            <td>{$row['best_contact_method']}</td>
            <td>{$row['social_media']}</td>
            <td>{$row['weekday_call_time']}</td>
            <td>{$row['weekend_call_time']}</td>
            <td>{$row['email_contact']}</td>
            <td>{$row['text_contact']}</td>
            <td>{$row['connect_as_family']}</td>
                            
                          </tr>";
        }
    } else {
        $tableData = "<tr><td colspan='4'>No members found</td></tr>";
    }

return $tableData;
}
// ...
?>

X7ROOT File Manager

Editing: 2_content.php

Upload File

Create Folder