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

<div class="content-header">
    <div class="container-fluid">
        <div class="row mb-2">
            <div class="col-sm-6">
                <h1 class="m-0">Pastoral Care Team Lead 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>
            </div>
            
            <div class="col-lg-3 col-6">
                <div class="small-box bg-warning">
                    <div class="inner">
                        <h3><?php echo getPendingTasks(); ?></h3>
                        <p>Pending Tasks</p>
                    </div>
                    
                </div>
            </div>
            
            <div class="col-lg-3 col-6">
                <div class="small-box bg-success">
                    <div class="inner">
                        <h3><?php echo getCompletedTasks(); ?></h3>
                        <p>Completed Tasks</p>
                    </div>
                    
                </div>
            </div>
            
        </div>

<div class="card">
            <div class="card-header">
                <h3 class="card-title">Members Table</h3>
            </div>
            
            <div class="card-body">
                <table id="membersTable" class="table table-bordered table-hover">
                    <thead>
                        <tr>
                        <th>ID</th>
                        <th>Name</th>
                        <th>O. Names</th>
                        <th>Mobile</th>
                        <th>Telephone</th>
                        <th>Email</th>
                        <th>DOB</th>
                        <th>Occupation</th>
                        <th>Next Of Kin</th>
                            
                        </tr>
                    </thead>
                    <tbody>
                        <?php echo getMembersTable(); ?>
                    </tbody>
                </table>
            </div>
            
        </div>

</div>
    
</section>

<?php
// Functions (replace with your actual database queries)

function getTotalMembers() {
    global $conn;

// Your query to get the total number of members
    $sql = "SELECT COUNT(*) AS total_members FROM members";
    $result = $conn->query($sql);

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

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

function getPendingTasks() {
    global $conn;

// Your query to get the total number of pending tasks
    $sql = "SELECT COUNT(*) AS pending_tasks FROM tasks WHERE task_status = 'Pending'";
    $result = $conn->query($sql);

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

return 0; // Return 0 if there are no pending tasks
}

function getCompletedTasks() {
    global $conn;

// Your query to get the total number of completed tasks
    $sql = "SELECT COUNT(*) AS completed_tasks FROM tasks WHERE task_status = 'Completed'";
    $result = $conn->query($sql);

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

return 0; // Return 0 if there are no completed tasks
}

function getMembersTable() {
    global $conn;

// Your query to get member data
    $sql = "SELECT * FROM members";
    $result = $conn->query($sql);

$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='3'>No members found</td></tr>";
    }

return $tableData;
}
?>

X7ROOT File Manager

Editing: 7_content.php

Upload File

Create Folder