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_expenses_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 Expenses</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 Expenses --> <div class="col-md-4 mb-2"> <button type="button" class="btn btn-primary btn-block" data-toggle="modal" data-target="#addExpensesModal"> Add Expense </button> </div> <!-- Edit Expense --> <div class="col-md-4 mb-2"> <button type="button" class="btn btn-success btn-block" data-toggle="modal" data-target="#editExpenseModal"> Edit Expense </button> </div> <!-- Delete Expense --> <div class="col-md-4 mb-2"> <button type="button" class="btn btn-danger btn-block" data-toggle="modal" data-target="#deleteExpenseModal"> Delete Expense </button> </div> </div> <!-- /.row --> <!-- Expenses Table --> <div class="card"> <div class="card-header"> <h3 class="card-title">Expenses Table</h3> </div> <!-- /.card-header --> <div class="card-body"> <div class="table-responsive" style="overflow-x: auto;"> <table id="expensesTable" class="table table-bordered table-hover"> <thead> <tr> <th>Expense ID</th> <th>Expense Type</th> <th>Amount</th> <th>Date</th> <!-- Add more columns as needed --> </tr> </thead> <tbody> <?php echo getExpensesTable(); ?> </tbody> </table> </div> </div> <!-- /.card-body --> </div> <!-- /.card --> </div> <!-- /.container-fluid --> </section> <!-- /.content --> <!-- Add Expense Modal --> <div class="modal fade" id="addExpensesModal" tabindex="-1" role="dialog" aria-labelledby="addExpensesModalLabel" aria-hidden="true"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title" id="addExpensesModalLabel">Add Expense</h5> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> <div class="modal-body"> <!-- Add Expense Form --> <form action="ajax/add_expenses.php" method="POST"> <div class="form-group"> <label for="expenseType">Expense Type</label> <input type="text" class="form-control" id="expenseType" name="expenseType" required> </div> <div class="form-group"> <label for="expenseAmount">Expense Amount</label> <input type="text" class="form-control" id="expenseAmount" name="expenseAmount"> </div> <div class="form-group"> <label for="expenseDate">Expense Date</label> <input type="date" class="form-control" id="expenseDate" name="expenseDate"> </div> <button type="submit" class="btn btn-primary">Add Expense</button> </form> </div> </div> </div> </div> <!-- Edit Expense Modal --> <div class="modal fade" id="editExpenseModal" tabindex="-1" role="dialog" aria-labelledby="editExpenseModalLabel" aria-hidden="true"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title" id="editExpenseModalLabel">Edit Expense</h5> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> <div class="modal-body"> <!-- Edit Expense Form --> <form action="ajax/edit_expenses.php" method="POST"> <div class="form-group"> <label for="editExpenseSelect">Select Expense</label> <select class="form-control" id="editExpenseSelect" name="editExpenseSelect"> <!-- Populate this dropdown with expense options dynamically from the database --> <?php echo getExpenseOptions(); ?> </select> </div> <div class="form-group"> <label for="editExpenseType">Expense Type</label> <input type="text" class="form-control" id="editExpenseType" value="<?php echo htmlspecialchars($expenseType); ?>" name="editExpenseType" required> </div> <div class="form-group"> <label for="editExpenseAmount">Expense Amount</label> <input type="text" class="form-control" id="editExpenseAmount" value="<?php echo htmlspecialchars($expenseAmount); ?>" name="editExpenseAmount"> </div> <div class="form-group"> <label for="editExpenseDate">Expense Date</label> <input type="date" class="form-control" id="editExpenseDate" value="<?php echo htmlspecialchars($expenseDate); ?>" name="editExpenseDate"> </div> <button type="submit" class="btn btn-primary">Save Changes</button> </form> </div> </div> </div> </div> <!-- Delete Expense Modal --> <div class="modal fade" id="deleteExpenseModal" tabindex="-1" role="dialog" aria-labelledby="deleteExpenseModalLabel" aria-hidden="true"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title" id="deleteExpenseModalLabel">Delete Expense</h5> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> <div class="modal-body"> <!-- Delete Expense Form --> <form action="ajax/delete_expenses.php" method="POST"> <div class="form-group"> <label for="deleteExpenseSelect">Select Expense to Delete</label> <select class="form-control" id="deleteExpenseSelect" name="deleteExpenseSelect"> <!-- Populate this dropdown with expense options dynamically from the database --> <?php echo getExpenseOptions(); ?> </select> </div> <p class="text-danger">Are you sure you want to delete this expense? This action cannot be undone.</p> <button type="submit" class="btn btn-danger">Delete Expense</button> </form> </div> </div> </div> </div> <?php // Function to fetch expenses table data (replace with your database query) function getExpensesTable() { global $conn; $query = "SELECT * FROM expenses"; // 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['expense_id']}</td> <td>{$row['expense_type']}</td> <td>{$row['amount']}</td> <td>{$row['expense_date']}</td> <!-- Add more columns as needed --> </tr>"; } } else { $tableData = "<tr><td colspan='4'>No expenses found</td></tr>"; } return $tableData; } // Function to fetch expense options for the dropdown (replace with your database query) function getExpenseOptions() { global $conn; $query = "SELECT expense_id, expense_type, amount FROM expenses"; $result = $conn->query($query); $options = ''; if ($result && $result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $options .= "<option value='{$row['expense_id']}'>{$row['expense_type']}{$row['amount']}</option>"; } } else { $options = "<option value=''>No expenses found</option>"; } return $options; } ?>
Upload File
Create Folder