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_invoices_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 Invoices</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="#addInvoiceModal"> Add Invoices </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="#editInvoiceModal"> Edit Invoices </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="#deleteInvoiceModal"> Delete Invoices </button> </div> </div> <!-- /.row --> <!-- Expenses Table --> <div class="card"> <div class="card-header"> <h3 class="card-title">Invoices 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>Invoice ID</th> <th>Invoice Date</th> <th>Invoice Description</th> <th>Invoice Amount</th> <!-- Add more columns as needed --> </tr> </thead> <tbody> <?php echo getInvoiceTable(); ?> </tbody> </table> </div> </div> <!-- /.card-body --> </div> <!-- /.card --> </div> <!-- /.container-fluid --> </section> <!-- /.content --> <!-- Add Donation Modal --> <div class="modal fade" id="addInvoiceModal" tabindex="-1" role="dialog" aria-labelledby="addInvoiceModalLabel" aria-hidden="true"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title" id="addInvoiceModalLabel">Add Invoice</h5> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> <div class="modal-body"> <!-- Add Invoice Form --> <form action="ajax/add_invoice.php" method="POST"> <div class="form-group"> <label for="invoiceDate">Invoice Date</label> <input type="date" class="form-control" id="invoice_date" name="invoice_date" required> </div> <div class="form-group"> <label for="invoiceDescription">Invoice Description</label> <input type="text" class="form-control" id="invoice_description" name="invoice_description" required> </div> <div class="form-group"> <label for="invoiceAamount">Invoice Amount</label> <input type="text" class="form-control" id="invoice_amount" name="invoice_amount" required> </div> <button type="submit" class="btn btn-primary">Add Invoice</button> </form> </div> </div> </div> </div> <!-- Edit Invoices Modal --> <div class="modal fade" id="editInvoiceModal" tabindex="-1" role="dialog" aria-labelledby="editInvoiceModalLabel" aria-hidden="true"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title" id="editInvoiceModalLabel">Edit Invoice</h5> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> <div class="modal-body"> <!-- Edit Invoices Form --> <form action="ajax/edit_invoice.php" method="POST"> <div class="form-group"> <label for="editInvoiceSelect">Select Invoice to Edit</label> <select class="form-control" id="editInvoiceSelect" name="editInvoiceSelect"> <!-- Populate this dropdown with expense options dynamically from the database --> <?php echo getInvoiceOptions(); ?> </select> </div> <div class="form-group"> <label for="invoiceDate">Invoice Date</label> <input type="date" class="form-control" id="editinvoice_date" name="editinvoice_date" required> </div> <div class="form-group"> <label for="invoiceDescription">Invoice Description</label> <input type="text" class="form-control" id="editinvoice_description" name="editinvoice_description" required> </div> <div class="form-group"> <label for="invoiceAamount">Invoice Amount</label> <input type="text" class="form-control" id="editinvoice_amount" name="editinvoice_amount" required> </div> <button type="submit" class="btn btn-primary">Save Changes</button> </form> </div> </div> </div> </div> <!-- Delete Invoices Modal --> <div class="modal fade" id="deleteInvoiceModal" tabindex="-1" role="dialog" aria-labelledby="deleteInvoicesModalLabel" aria-hidden="true"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title" id="deleteInvoiceModalLabel">Delete Invoices</h5> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> <div class="modal-body"> <!-- Delete Invoices Form --> <form action="ajax/delete_invoice.php" method="POST"> <div class="form-group"> <label for="deleteInvoiceSelect">Select Invoice to Delete</label> <select class="form-control" id="deleteInvoiceSelect" name="deleteInvoiceSelect"> <!-- Populate this dropdown with expense options dynamically from the database --> <?php echo getInvoiceOptions(); ?> </select> </div> <p class="text-danger">Are you sure you want to delete this invoice? This action cannot be undone.</p> <button type="submit" class="btn btn-danger">Delete Invoice</button> </form> </div> </div> </div> </div> <?php // Function to fetch expenses table data (replace with your database query) function getInvoiceTable() { global $conn; $query = "SELECT * FROM invoices"; // 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['invoice_id']}</td> <td>{$row['invoice_date']}</td> <td>{$row['invoice_description']}</td> <td>{$row['invoice_amount']}</td> <!-- Add more columns as needed --> </tr>"; } } else { $tableData = "<tr><td colspan='4'>No Invoices found</td></tr>"; } return $tableData; } // Function to fetch expense options for the dropdown (replace with your database query) function getInvoiceOptions() { global $conn; $query = "SELECT invoice_id,invoice_amount FROM invoices"; $result = $conn->query($query); $options = ''; if ($result && $result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $options .= "<option value='{$row['invoice_id']}'>{$row['invoice_amount']}</option>"; } } else { $options = "<option value=''>No invoices found</option>"; } return $options; } ?>
Upload File
Create Folder