EVOLUTION-NINJA
Edit File: customer_payments.php
<!--<?//php echo view('includes/sidebar'); ?>--> <?php echo view('includes/headerSidebar'); ?> <script type="text/javascript" src="<?php echo base_url('public/assets/js/jquery-3.6.0.min.js'); ?>"></script> <script src="<?php echo base_url('public/assets/toastr/toastr.min.js');?>"></script> <link rel="stylesheet" href="<?php echo base_url('public/assets/toastr/toastr.min.css');?>"> <link rel="stylesheet" href="https://cdn.datatables.net/1.11.5/css/jquery.dataTables.min.css"> <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script> <script src="https://cdn.datatables.net/1.11.5/js/jquery.dataTables.min.js"></script> <link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.4/css/all.min.css" rel="stylesheet"> <script src="https://code.jquery.com/ui/1.13.2/jquery-ui.min.js"></script> <link rel="stylesheet" href="https://code.jquery.com/ui/1.13.2/themes/base/jquery-ui.css"> <style> /* Reduce table margin and padding */ .dataTables_wrapper { margin: 10px auto; /* Smaller margin */ width: 95%; /* Adjust width for a compact layout */ } /* Style table */ #datatable { border: 1px solid #ddd; border-radius: 5px; font-size: 14px; /* Adjust font size */ background-color: #fff; } /* Header styling */ #datatable thead { background-color: #f4f4f4; color: #333; font-weight: bold; border-bottom: 2px solid #ccc; } /* Row styling */ #datatable tbody tr { border-bottom: 1px solid #ddd; } #datatable tbody tr:hover { background-color: #f9f9f9; /* Highlight on hover */ } /* Action buttons */ .crud--buttons .btn { margin: 0 5px; /* Small spacing between buttons */ font-size: 12px; /* Smaller font for buttons */ padding: 5px 10px; /* Compact button size */ border-radius: 3px; } /* Eye icon button */ .view--butt { color: #fff; background-color: #17a2b8; /* Bootstrap 'info' color */ border: none; } /* Menu icon button */ .menu--butt { color: #fff; background-color: #6c757d; /* Bootstrap 'secondary' color */ border: none; } /* Icon sizes */ .fas { font-size: 14px; vertical-align: middle; } /* Serial number column */ #datatable td:first-child { text-align: center; font-weight: bold; } </style> <div id="main" class="p-4"> <section class="home-section fullpage"> <div class="home-content"> <i class='bx bx-menu'></i> </div> <!-- heading row --> <br> <div class="row m-0"> <div class="col-sm-12"> <h1 class="crt-pjt">Customer Payments</h1> </div> </div> <br> <form id="payment-form"> <div class="row"> <div class="col-sm-4"> <label for="scheme">SCHEME</label> <select class="form-control" id="scheme" name="scheme"> <option value="">Select Scheme</option> </select> </div> <div class="col-sm-4"> <label for="user">Select User</label> <input type="text" class="form-control" id="user" name="user" placeholder="Search by name"> <input type="hidden" id="user_id" name="user_id"> </div> <div class="col-sm-4"> <label for="amount">Amount</label> <input type="text" class="form-control" value="" name="amount" readonly> </div> </div> <br> <div class="row"> <div class="col-sm-4"> <label for="date">Payment Date</label> <input type="date" class="form-control" placeholder="date" name="date"> </div> <div class="col-sm-4"> <label for="remarks">REMARKS</label> <input type="text" class="form-control" placeholder="Transaction No" name="remarks"> </div> </div> <br><br> <div class="row"> <div style="float:left;margin-left:10px;"> <button type="submit" class="btn btn-primary">Submit</button> <button type="button" class="btn btn-danger" data-bs-dismiss="modal">Cancel</button> </div> </div> </form> <br><br> <br><br> <div class="row"> <div class="col-sm-12"> <div class="container deptable"> <table id="datatable" class="table table-striped table-bordered"> <thead> <tr> <th>SL No</th> <th>ID</th> <th>Scheme</th> <th>Payment date</th> <th>Amount</th> <th>user</th> </tr> </thead> <tbody> </tbody> </table> </div> </div> </div> </div> </section> </div> </body> <script src="https://cdn.jsdelivr.net/npm/sweetalert2@11.10.8/dist/sweetalert2.all.min.js"></script> <link href="https://cdn.jsdelivr.net/npm/sweetalert2@11.10.8/dist/sweetalert2.min.css" rel="stylesheet"> <script> $(document).ready(function () { $('#payment-form').submit(function (e) { e.preventDefault() formdata = new FormData($(this)[0]); $.ajax({ type: 'post', url: '<?php echo base_url("payment");?>', data: formdata, contentType: false, processData: false, success: function (response) { if (response.result == 1) { Swal.fire({ icon: "success", title: response.message, }); $('#payment-form')[0].reset(); } else if (response.result == 0) { Swal.fire({ icon: "error", title: response.message }); } else { Swal.fire({ icon: "error", title: response.message }); } }, error: function (xhr, textStatus, errorThrown) { console.error(xhr.responseText); } }) }) }) </script> <script> document.addEventListener("DOMContentLoaded", function () { const schemeSelect = document.getElementById("scheme"); const amountInput = document.querySelector("input[name='amount']"); schemeSelect.addEventListener("change", function () { if (this.value) { amountInput.value = "1000.00"; amountInput.readOnly = true; } else { amountInput.value = ""; amountInput.readOnly = false; } }); }); </script> <script> $(document).ready(function () { $.ajax({ url: '<?php echo base_url("fetch-scheme"); ?>', method: 'GET', success: function (response) { if (response.length > 0) { var options = '<option value="">Select Scheme</option>'; $.each(response, function (key, value) { options += `<option value="${value.id}">${value.scheme}</option>`; }); $('#scheme').html(options); } else { // alert('No funds found'); } }, error: function (xhr, status, error) { console.error("Error fetching scheme:", error); } }); }); </script> <script> $(document).ready(function () { var table = $('#datatable').DataTable({ pageLength: 20, ajax: { url: '<?php echo base_url("payment-details"); ?>', type: 'POST', data: function (d) { d.user_id = $('#user_id').val(); }, dataSrc: function (json) { if (!$('#user_id').val() || !json.data) { return []; } return json.data; }, error: function (xhr, status, error) { console.error('Error fetching data:', error); alert('Failed to load data. Please try again later.'); } }, columns: [ { data: null }, { data: 'id', visible: false }, { data: 'scheme_name' }, { data: 'payment_date' }, { data: 'amount' }, { data: 'user_id' } ], rowCallback: function (row, data, index) { $('td:eq(0)', row).html(index + 1); }, language: { emptyTable: "No data available" } }); $('#user_id').on('change', function () { table.ajax.reload(); }); }); </script> <script> $(document).ready(function () { $("#user").autocomplete({ source: function (request, response) { $.ajax({ url: "<?php echo base_url('getUsers'); ?>", type: "GET", data: { query: request.term }, success: function (data) { response(data.map(user => ({ label: user.user_id, value: user.user_id, id: user.user_id, }))); }, error: function () { console.error("Error fetching user data"); } }); }, minLength: 2, select: function (event, ui) { $("#user_id").val(ui.item.id); $("#user").val(ui.item.value); $('#datatable').DataTable().ajax.reload(); return false; } }); }); </script> <script> let arrow = document.querySelectorAll(".arrow"); for (var i = 0; i < arrow.length; i++) { arrow[i].addEventListener("click", (e) => { let arrowParent = e.target.parentElement.parentElement; arrowParent.classList.toggle("showMenu"); }); } let sidebar = document.querySelector(".sidebar"); let sidebarBtn = document.querySelector(".bx-menu"); console.log(sidebarBtn); sidebarBtn.addEventListener("click", () => { sidebar.classList.toggle("close"); }); </script> </html>