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: manage_member_content.php
<!-- Content Header (Page header) --> <div class="content-header"> <div class="container-fluid"> <div class="row mb-2"> <div class="col-sm-6"> <h1 class="m-0">Manage Members</h1> </div> <!-- /.col --> </div> <!-- /.row --> </div> <!-- /.container-fluid --> </div> <!-- /.content-header --> <!-- Main content --> <section class="content"> <div class="container-fluid"> <!-- Info Boxes --> <div class="row mb-2"> <!-- Add Members --> <div class="col-md-4 mb-2"> <button type="button" class="btn btn-primary btn-block" data-toggle="modal" data-target="#addMemberModal"> Add Member </button> </div> <!-- Edit Member --> <div class="col-md-4 mb-2"> <button type="button" class="btn btn-success btn-block" data-toggle="modal" data-target="#editMemberModal"> Edit Member Details </button> </div> <!-- Delete Member --> <div class="col-md-4 mb-2"> <button type="button" class="btn btn-danger btn-block" data-toggle="modal" data-target="#deleteMemberModal"> Delete Member </button> </div> </div> <!-- /.row --> <!-- Members Table --> <div class="card"> <div class="card-header"> <h3 class="card-title">Members Table</h3> </div> <!-- /.card-header --> <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>M. Addres1</th> <th>M. Address2</th> <th>M. Ci/CO</th> <th>N.O Kin</th> <th>N.O Mob</th> <th>N.Add 1</th> <th>N Add 2</th> <th>NCity/County</th> <th>NCountry</th> <th>S. Media</th> <th>Wkday C.T</th> <th>Wkend C.T</th> <th>Cont.Choice</th> <th>Connect as Family</th> <th>PartnerType</th> <th>volPartnership</th> <th>volOption</th> <th>minisOption</th> <th>OtherMinistryOpt</th> <th>Date</th> <!-- Add more columns as needed --> </tr> </thead> <tbody> <?php echo getMembersTable(); ?> </tbody> </table> </div> </div> <!-- /.card-body --> </div> <!-- /.card --> </div> <!-- /.container-fluid --> </section> <!-- /.content --> <!-- Add Member Modal --> <div class="modal fade" id="addMemberModal" tabindex="-1" role="dialog" aria-labelledby="addMemberModalLabel" aria-hidden="true"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title" id="addTaskModalLabel">Add Member</h5> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> <div class="modal-body"> <!-- Add Member Form --> <form action="ajax/add_member.php" method="POST"> <div class="form-group"> <h4>Member Details</h4> </div> <div class="form-group"> <label for="memberName" class="form-label">Full Name</label> <input type="text" class="form-control" id="memberName" name="memberName" required> </div> <div class="form-group"> <label for="memberOtherNames">Other Names</label> <input type="text" class="form-control" id="memberOtherNames" name="memberOtherNames"> </div> <div class="form-group"> <label for="memberMobile">Mobile</label> <input type="text" class="form-control" id="memberMobile" name="memberMobile"> </div> <div class="form-group"> <label for="memberTelephone">Telephone</label> <input type="text" class="form-control" id="memberTelephone" name="memberTelephone"> </div> <div class="form-group"> <label for="memberEmail">Email</label> <input type="email" class="form-control" id="memberEmail" name="memberEmail"> </div> <div class="form-group"> <label for="memberDOB">Date of Birth</label> <input type="date" class="form-control" id="memberDOB" name="memberDOB"> </div> <div class="form-group"> <label for="memberOccupation">Occupation</label> <input type="text" class="form-control" id="memberOccupation" name="memberOccupation"> </div> <div class="form-group"> <label for="memberAddress1">Address 1</label> <input type="text" class="form-control" id="memberAddress1" name="memberAddress1"> </div> <div class="form-group"> <label for="memberAddress2">Address 2</label> <input type="text" class="form-control" id="memberAddress2" name="memberAddress2"> </div> <div class="form-group"> <label for="memberCityCounty">City/County</label> <input type="text" class="form-control" id="memberCityCounty" name="memberCityCounty"> </div> <div class="form-group"> <label for="memberCountry">Country</label> <input type="text" class="form-control" id="memberCountry" name="memberCountry"> </div> <div class="form-group"> <h4>Next Of Kin Details</h4> </div> <div class="form-group"> <label for="memberNextOfKin">Next of Kin Name</label> <input type="text" class="form-control" id="memberNextOfKin" name="memberNextOfKin"> </div> <div class="form-group"> <label for="memberNextOfKinMobile">Next of Kin Mobile</label> <input type="text" class="form-control" id="memberNextOfKinMobile" name="memberNextOfKinMobile"> </div> <div class="form-group"> <label for="NOKAddress1">Address 1</label> <input type="text" class="form-control" id="NOKAddress1" name="NOKAddress1"> </div> <div class="form-group"> <label for="NOKAddress2">Address 2</label> <input type="text" class="form-control" id="NOKAddress2" name="NOKAddress2"> </div> <div class="form-group"> <label for="NOKCityCounty">City/County</label> <input type="text" class="form-control" id="NOKCityCounty" name="NOKCityCounty"> </div> <div class="form-group"> <label for="NOKCountry">Country</label> <input type="text" class="form-control" id="NOKCountry" name="NOKCountry"> </div> <div class="form-group"> <h4>Member Details Continues</h4> </div> <div class="form-group"> <h6>Best Social Contact</h6> </div> <div class="form-group"> <label for="socialMedia">Social Media</label> <select class="form-control" name="socialMedia"> <option value="whatsapp">WhatsApp</option> <option value="facebook">Facebook</option> <option value="telegram">Telegram</option> </select> </div> <div class="form-group"> <label for="weekdayCallTime">Weekday Call Time</label> <select class="form-control" name="weekdayCallTime"> <option value="morning">Morning</option> <option value="afternoon">Afternoon</option> <option value="evening">Evening</option> </select> </div> <div class="form-group"> <label for="weekEndCallTime">WeekEnd Call Time</label> <select class="form-control" name="weekEndCallTime"> <option value="morning">Morning</option> <option value="afternoon">Afternoon</option> <option value="evening">Evening</option> </select> </div> <div class="form-group"> <label for="contactChoice">Contact Choice</label> <select class="form-control" name="contactChoice"> <option value="email">Email</option> <option value="text">Text</option> </select> </div> <div class="form-group"> <label for="connectAsFamily">Connect As A Family Member</label> <select class="form-control" name="connectAsFamily"> <option value="yes">Yes</option> <option value="no">No</option> <option value="need time">Need Time</option> </select> </div> <div class="form-group"> <label>Do you want to partner?</label> <select class="form-control" name="partnerType" id="partnerType"> <option value="volunteer">Volunteer Partnership</option> <option value="donation">Partnership Donation</option> <option value="ministryDonation">Ministry Donations</option> </select> </div> <div class="form-group" id="volunteerPartnership" style="display: none;"> <label>Choose Volunteer Partnership:</label> <select class="form-control" name="volunteerPartnership"> <option value="Perfect Transformation Network">Perfect Transformation Network</option> <option value="Remnant Love Media Network">Remnant Love Media Network</option> <option value="The Evangelistic Love Missions">The Evangelistic Love Missions</option> <option value="Remnant Love Global Intercessors Network">Remnant Love Global Intercessors Network</option> <option value="Remnant Love Publications">Remnant Love Publications</option> </select> </div> <div class="form-group" id="donationOptions" style="display: none;"> <label>Choose Donation Option:</label> <select class="form-control" name="donationOption"> <option value="Perfect Transformation">Perfect Transformation</option> <option value="Remnant Love Media Network">Remnant Love Media Network</option> <option value="The Evangelistic Love Missions">The Evangelistic Love Missions</option> <option value="Remnant Love Global Intercessors Network">Remnant Love Global Intercessors Network</option> <option value="Remnant Love Publications">Remnant Love Publications</option> <option value="Remnant Love School of Ministry">Remnant Love School of Ministry</option> </select> </div> <div class="form-group" id="ministryDonationOptions" style="display: none;"> <label>Choose Ministry Donation:</label> <select class="form-control" name="ministryOption"> <option value="Tithe">Tithe</option> <option value="First Fruit">First Fruit</option> <option value="Seeds">Seeds</option> <option value="Offerings">Offerings</option> <option value="Programs">Programs</option> <option value="Projects">Projects</option> </select> <input type="text" class="form-control" name="otherMinistryDonation" placeholder="Other (Please specify)"> </div> <button type="submit" class="btn btn-dark">Add Member</button> </form> </div> </div> </div> </div> <!-- Edit Member Modal --> <div class="modal fade" id="editMemberModal" tabindex="-1" role="dialog" aria-labelledby="editMemberModalLabel" aria-hidden="true"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title" id="editMemberModalLabel">Edit Member</h5> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> <div class="modal-body"> <!-- Edit Member Form --> <form id="editMemberForm" method="POST"> <div class="form-group"> <label for="selectMember" class="form-label">Select Member</label> <select id="selectMember" class="form-control"> <!-- Options will be populated dynamically --> </select> </div> <div id="memberDetails"> <!-- Member details fields --> <div class="form-group"> <label for="memberName">Full Name</label> <input type="text" class="form-control" id="memberName" name="memberName" required> </div> <div class="form-group"> <label for="memberOtherNames">Other Names</label> <input type="text" class="form-control" id="memberOtherNames" name="memberOtherNames"> </div> <div class="form-group"> <label for="memberMobile">Mobile</label> <input type="text" class="form-control" id="memberMobile" name="memberMobile" required> </div> <div class="form-group"> <label for="memberTelephone">Telephone</label> <input type="text" class="form-control" id="memberTelephone" name="memberTelephone"> </div> <div class="form-group"> <label for="memberEmail">Email</label> <input type="email" class="form-control" id="memberEmail" name="memberEmail" required> </div> <div class="form-group"> <label for="memberDOB">Date of Birth</label> <input type="date" class="form-control" id="memberDOB" name="memberDOB"> </div> <div class="form-group"> <label for="memberOccupation">Occupation</label> <input type="text" class="form-control" id="memberOccupation" name="memberOccupation"> </div> <div class="form-group"> <label for="memberAddress1">Address 1</label> <input type="text" class="form-control" id="memberAddress1" name="memberAddress1"> </div> <div class="form-group"> <label for="memberAddress2">Address 2</label> <input type="text" class="form-control" id="memberAddress2" name="memberAddress2"> </div> <div class="form-group"> <label for="memberCityCounty">City/County</label> <input type="text" class="form-control" id="memberCityCounty" name="memberCityCounty"> </div> <div class="form-group"> <label for="memberCountry">Country</label> <input type="text" class="form-control" id="memberCountry" name="memberCountry"> </div> <div class="form-group"> <label for="memberNextOfKin">Next of Kin Name</label> <input type="text" class="form-control" id="memberNextOfKin" name="memberNextOfKin"> </div> <div class="form-group"> <label for="memberNextOfKinMobile">Next of Kin Mobile</label> <input type="text" class="form-control" id="memberNextOfKinMobile" name="memberNextOfKinMobile"> </div> <div class="form-group"> <label for="NOKAddress1">Next of Kin Address 1</label> <input type="text" class="form-control" id="NOKAddress1" name="NOKAddress1"> </div> <div class="form-group"> <label for="NOKAddress2">Next of Kin Address 2</label> <input type="text" class="form-control" id="NOKAddress2" name="NOKAddress2"> </div> <div class="form-group"> <label for="NOKCityCounty">Next of Kin City/County</label> <input type="text" class="form-control" id="NOKCityCounty" name="NOKCityCounty"> </div> <div class="form-group"> <label for="NOKCountry">Next of Kin Country</label> <input type="text" class="form-control" id="NOKCountry" name="NOKCountry"> </div> <div class="form-group"> <label for="socialMedia">Social Media</label> <select class="form-control" id="socialMedia" name="socialMedia"> <option value="whatsapp">WhatsApp</option> <option value="facebook">Facebook</option> <option value="telegram">Telegram</option> </select> </div> <div class="form-group"> <label for="weekdayCallTime">Weekday Call Time</label> <select class="form-control" id="weekdayCallTime" name="weekdayCallTime"> <option value="morning">Morning</option> <option value="afternoon">Afternoon</option> <option value="evening">Evening</option> </select> </div> <div class="form-group"> <label for="weekEndCallTime">Weekend Call Time</label> <select class="form-control" id="weekEndCallTime" name="weekEndCallTime"> <option value="morning">Morning</option> <option value="afternoon">Afternoon</option> <option value="evening">Evening</option> </select> </div> <div class="form-group"> <label for="contactChoice">Contact Choice</label> <select class="form-control" id="contactChoice" name="contactChoice"> <option value="email">Email</option> <option value="text">Text</option> </select> </div> <div class="form-group"> <label for="connectAsFamily">Connect As Family Member</label> <select class="form-control" id="connectAsFamily" name="connectAsFamily"> <option value="yes">Yes</option> <option value="no">No</option> <option value="need time">Need Time</option> </select> </div> <div class="form-group"> <label for="partnerType">Do you want to partner?</label> <select class="form-control" id="partnerType" name="partnerType"> <option value="volunteer">Volunteer Partnership</option> <option value="donation">Partnership Donation</option> <option value="ministryDonation">Ministry Donations</option> </select> </div> <div class="form-group" id="volunteerPartnership" style="display: none;"> <label>Choose Volunteer Partnership:</label> <select class="form-control" name="volunteerPartnership"> <option value="Perfect Transformation Network">Perfect Transformation Network</option> <option value="Remnant Love Media Network">Remnant Love Media Network</option> <option value="The Evangelistic Love Missions">The Evangelistic Love Missions</option> <option value="Remnant Love Global Intercessors Network">Remnant Love Global Intercessors Network</option> <option value="Remnant Love Publications">Remnant Love Publications</option> </select> </div> <div class="form-group" id="donationOptions" style="display: none;"> <label>Choose Donation Option:</label> <select class="form-control" name="donationOption"> <option value="Perfect Transformation">Perfect Transformation</option> <option value="Remnant Love Media Network">Remnant Love Media Network</option> <option value="The Evangelistic Love Missions">The Evangelistic Love Missions</option> <option value="Remnant Love Global Intercessors Network">Remnant Love Global Intercessors Network</option> <option value="Remnant Love Publications">Remnant Love Publications</option> <option value="Remnant Love School of Ministry">Remnant Love School of Ministry</option> </select> </div> <div class="form-group" id="ministryDonationOptions" style="display: none;"> <label>Choose Ministry Donation Option:</label> <select class="form-control" name="ministryOption"> <option value="Evangelism">Evangelism</option> <option value="Missions">Missions</option> <option value="Bibles">Bibles</option> <option value="Youths">Youths</option> <option value="Books">Books</option> </select> </div> <div class="form-group"> <label for="otherMinistryDonation">Any other Ministry Donations:</label> <input type="text" class="form-control" id="otherMinistryDonation" name="otherMinistryDonation"> </div> </div> </form> </div> <div class="modal-footer"> <button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button> <button type="button" class="btn btn-primary" id="saveChangesButton">Save changes</button> </div> </div> </div> </div> <!-- Delete Member Modal --> <div class="modal fade" id="deleteMemberModal" tabindex="-1" role="dialog" aria-labelledby="deleteMemberModalLabel" aria-hidden="true"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title" id="deleteMemberModalLabel">Delete Member</h5> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> <div class="modal-body"> <!-- Delete Member Form --> <form action="ajax/delete_member.php" method="POST"> <div class="form-group"> <label for="deleteMemberSelect">Select Member to Delete</label> <select class="form-control" id="deleteMemberSelect" name="deleteMemberSelect"> <!-- Populate this dropdown with member options dynamically from the database --> <?php echo getMemberOptions(); ?> </select> </div> <p class="text-danger">Are you sure you want to delete this member? This action cannot be undone.</p> <button type="submit" class="btn btn-danger">Delete Member</button> </form> </div> </div> </div> </div> <?php // Function to fetch members table data function getMembersTable() { global $conn; $query = "SELECT * FROM members"; // Update the table name if necessary $result = $conn->query($query); $tableData = ''; if ($result && $result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $tableData .= "<tr> <td>{$row['id']}</td> <td>{$row['memberName']}</td> <td>{$row['memberOtherNames']}</td> <td>{$row['memberMobile']}</td> <td>{$row['memberTelephone']}</td> <td>{$row['memberEmail']}</td> <td>{$row['memberDOB']}</td> <td>{$row['memberOccupation']}</td> <td>{$row['memberNextOfKin']}</td> <td>{$row['memberNextOfKinMobile']}</td> <td>{$row['memberAddress1']}</td> <td>{$row['memberAddress2']}</td> <td>{$row['memberCityCounty']}</td> <td>{$row['memberCountry']}</td> <td>{$row['memberNextOfKin']}</td> <td>{$row['memberNextOfKinMobile']}</td> <td>{$row['NOKAddress1']}</td> <td>{$row['NOKAddress2']}</td> <td>{$row['NOKCityCounty']}</td> <td>{$row['NOKCountry']}</td> <td>{$row['SocialMedia']}</td> <td>{$row['WeekdayCallTime']}</td> <td>{$row['WeekendCallTime']}</td> <td>{$row['ContactChoice']}</td> <td>{$row['ConnectAsFamily']}</td> <td>{$row['partnerType']}</td> <td>{$row['volunteerParnership']}</td> <td>{$row['donationOption']}</td> <td>{$row['ministryOption']}</td> <td>{$row['otherMinistryDonation']}</td> <td>{$row['created_at']}</td> <!-- Add more columns as needed --> </tr>"; } } else { $tableData = "<tr><td colspan='29'>No members found</td></tr>"; } return $tableData; } ?> <?php // Function to fetch member options for the dropdown (replace with your database query) function getMemberOptions() { global $conn; $query = "SELECT id, memberName FROM members"; $result = $conn->query($query); $options = ''; if ($result && $result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $options .= "<option value='{$row['id']}'>{$row['memberName']}</option>"; } } else { $options = "<option value=''>No members found</option>"; } return $options; } ?> <script> document.getElementById('partnerType').addEventListener('change', function() { var value = this.value; document.getElementById('volunteerPartnership').style.display = (value === 'volunteer') ? 'block' : 'none'; document.getElementById('donationOptions').style.display = (value === 'donation') ? 'block' : 'none'; document.getElementById('ministryDonationOptions').style.display = (value === 'ministryDonation') ? 'block' : 'none'; }); </script> <script> document.addEventListener('DOMContentLoaded', function() { $('#selectMember').select2({ ajax: { url: 'fetch_members.php', // PHP file to fetch members with pagination dataType: 'json', delay: 250, data: function(params) { return { search: params.term, // search term page: params.page || 1 }; }, processResults: function(data, params) { params.page = params.page || 1; return { results: data.items, pagination: { more: (params.page * 10) < data.total // if more records are available } }; }, cache: true }, placeholder: 'Select a member', minimumInputLength: 1, templateResult: formatMember, templateSelection: formatMemberSelection }); function formatMember(member) { if (member.loading) { return member.text; } var $container = $( "<div class='select2-result-member clearfix'>" + "<div class='select2-result-member__meta'>" + "<div class='select2-result-member__title'></div>" + "</div>" + "</div>" ); $container.find(".select2-result-member__title").text(member.text); return $container; } function formatMemberSelection(member) { return member.text || member.id; } $('#selectMember').on('select2:select', function(e) { var memberId = e.params.data.id; $.ajax({ url: 'get_member.php', type: 'GET', data: { memberId: memberId }, success: function(response) { var member = JSON.parse(response); $('#editMemberForm #memberName').val(member.memberName); $('#editMemberForm #memberOtherNames').val(member.memberOtherNames); $('#editMemberForm #memberMobile').val(member.memberMobile); $('#editMemberForm #memberTelephone').val(member.memberTelephone); $('#editMemberForm #memberEmail').val(member.memberEmail); $('#editMemberForm #memberDOB').val(member.memberDOB); $('#editMemberForm #memberOccupation').val(member.memberOccupation); $('#editMemberForm #memberAddress1').val(member.memberAddress1); $('#editMemberForm #memberAddress2').val(member.memberAddress2); $('#editMemberForm #memberCityCounty').val(member.memberCityCounty); $('#editMemberForm #memberCountry').val(member.memberCountry); $('#editMemberForm #memberNextOfKin').val(member.memberNextOfKin); $('#editMemberForm #memberNextOfKinMobile').val(member.memberNextOfKinMobile); $('#editMemberForm #NOKAddress1').val(member.NOKAddress1); $('#editMemberForm #NOKAddress2').val(member.NOKAddress2); $('#editMemberForm #NOKCityCounty').val(member.NOKCityCounty); $('#editMemberForm #NOKCountry').val(member.NOKCountry); $('#editMemberForm #socialMedia').val(member.socialMedia); $('#editMemberForm #weekdayCallTime').val(member.weekdayCallTime); $('#editMemberForm #weekEndCallTime').val(member.weekEndCallTime); $('#editMemberForm #contactChoice').val(member.contactChoice); $('#editMemberForm #connectAsFamily').val(member.connectAsFamily); $('#editMemberForm #partnerType').val(member.partnerType); $('#editMemberForm #volunteerPartnership').val(member.volunteerPartnership); $('#editMemberForm #donationOptions').val(member.donationOption); $('#editMemberForm #ministryDonationOptions').val(member.ministryOption); $('#editMemberForm #otherMinistryDonation').val(member.otherMinistryDonation); } }); }); $('#saveChangesButton').on('click', function() { var formData = $('#editMemberForm').serialize(); $.ajax({ url: 'edit_member.php', type: 'POST', data: formData, success: function(response) { if (response === 'success') { alert('Member details updated successfully.'); window.location.reload(); } else { alert('Failed to update member details. Please try again.'); } } }); }); }); </script>
Upload File
Create Folder