@extends('layout.admin')

@section('head')
    @extends('layout.header')
    @section('header_title', 'Supplier')
@endsection

@section('content')



<!-- Content Header (Page header) -->

<div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-6">
                    <h1>Customer Credit</h1>
                </div>
                <div class="col-sm-6">
                    <ol class="breadcrumb float-sm-right">
                        <li class="breadcrumb-item"><a href="#">Home</a></li>
                        <li class="breadcrumb-item active">Customer Credit</li>
                    </ol>
                </div>
            </div>
        </div><!-- /.container-fluid -->
    </section>



    <section class="content">
        <div class="container-fluid">
            <div class="row">
                <div class="col-12">
                    <div class="card">
                        <div class="card-header">
                            <h3 class="card-title">View Customer Credit Details</h3>
                        </div>
                        <!-- /.card-header -->
                        <div class="card-body">
                            <table id="example2" class="table table-bordered table-hover">
                                <thead>
                                <tr>
                                    <th>Full Name</th>
                                    <th>Contact Number</th>
                                    <th>Date Time</th>
                                    <th>Balance</th>
                                    <th>History</th>
                                    <th>Payment</th>
                                </tr>
                                </thead>
                                <tbody>
                                @php
                                    $totalBalance = 0;
                                @endphp
                                @foreach ($lastLogs as $item)
                                    @php
                                        $totalBalance += $item->Balance;
                                    @endphp
                                    <tr>
                                        <td>{{ $item->Full_Name }}</td>
                                        <td>{{ $item->Contact_No }}</td>
                                        <td>{{ $item->Date_Time }}</td>
                                        <td>{{ number_format($item->Balance, 2, '.', '') }}</td>
                                        <td>
                                            <input type="button" class="btn btn-primary" value="View Log"
                                                   onclick="view_log('{{ $item->cus_id }}')">
                                        </td>
                                        <td>
                                            <input type="button" class="btn btn-danger" value="Payment"
                                                   data-toggle="modal" data-target="#supplier_details"
                                                   onclick="payment('{{ $item->cus_id }}', '{{ $item->Balance }}')">
                                        </td>
                                    </tr>
                                @endforeach
                                </tbody>
                                <tfoot>
                                <tr>
                                    <th colspan="4" class="text-right">Total Balance:</th>
                                    <th>{{ number_format($totalBalance, 2, '.', '') }}</th>
                                    <th colspan="2"></th>
                                </tr>
                                </tfoot>
                            </table>
                        </div>
                        <!-- /.card-body -->
                    </div>
                </div>

            </div>
        </div>
    </section>
    <!-- /.content -->
</div>

<!-- Customer Log Modal -->
<div class="modal fade" id="customerLogModal" tabindex="-1" role="dialog" aria-labelledby="customerLogModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-lg" role="document">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="customerLogModalLabel">Customer Payment Log</h5>

                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                    <button type="button" class="btn btn-success" onclick="exportToExcel('customerLogsBody', 'Customer_Payment_Log')">Download Excel</button>
                </button>

            </div>
            <div class="modal-body">
                <table class="table table-bordered">
                    <thead>
                    <tr>
                        <th>Date Time</th>
                        <th>Type</th>
                        <th>Credit</th>
                        <th>Debit</th>
                        <th>Balance</th>
                    </tr>
                    </thead>
                    <tbody id="customerLogsBody">
                    <!-- Logs will be populated here by JavaScript -->
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>

<!-- Payment Modal -->
<div class="modal fade" id="paymentModal" tabindex="-1" role="dialog" aria-labelledby="paymentModalLabel" aria-hidden="true">
    <div class="modal-dialog" role="document">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="paymentModalLabel">Payment</h5>
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">&times;</span>
                </button>
            </div>
            <div class="modal-body">
                <form id="paymentForm">
                    <div class="form-group">
                        <label for="paymentAmount">Amount</label>
                        <input type="number" class="form-control" id="paymentAmount" name="amount" required>
                        <small id="balanceInfo" class="form-text text-muted">Max: <span id="maxBalance"></span></small>
                    </div>
                    <input type="hidden" id="cusId" name="cus_id">
                    <button type="submit" class="btn btn-primary">Pay</button>
                </form>
            </div>
        </div>
    </div>
</div>
@endsection

@section('script')
<!-- jQuery -->
<script src="../plugins/jquery/jquery.min.js"></script>


<script src="../plugins/datatables/jquery.dataTables.min.js"></script>
<script src="../plugins/datatables-bs4/js/dataTables.bootstrap4.min.js"></script>
<script src="../plugins/datatables-responsive/js/dataTables.responsive.min.js"></script>
<script src="../plugins/datatables-responsive/js/responsive.bootstrap4.min.js"></script>
<script src="../plugins/datatables-buttons/js/dataTables.buttons.min.js"></script>
<script src="../plugins/datatables-buttons/js/buttons.bootstrap4.min.js"></script>
<script src="../plugins/jszip/jszip.min.js"></script>
<script src="../plugins/pdfmake/pdfmake.min.js"></script>
<script src="../plugins/pdfmake/vfs_fonts.js"></script>
<script src="../plugins/datatables-buttons/js/buttons.html5.min.js"></script>
<script src="../plugins/datatables-buttons/js/buttons.print.min.js"></script>
<script src="../plugins/datatables-buttons/js/buttons.colVis.min.js"></script>
<!-- Bootstrap 4 -->
<script src="../plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<script src="../plugins/select2/js/select2.full.min.js"></script>
<!-- jquery-validation -->
<script src="../plugins/jquery-validation/jquery.validate.min.js"></script>
<script src="../plugins/jquery-validation/additional-methods.min.js"></script>
<!-- AdminLTE App -->
<script src="../dist/js/adminlte.min.js"></script>

<!-- AdminLTE for demo purposes -->
<script src="../dist/js/demo.js"></script>
<script src="../JS/validate.js"></script>
<script src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.17.0/xlsx.full.min.js"></script>

<script>
    $(function () {
        $('#example2').DataTable({
            "paging": true,
            "lengthChange": false,
            "searching": true,
            "ordering": true,
            "info": true,
            "autoWidth": false,
            "responsive": true,
        });
    })

</script>
<script>
    function view_log(cus_id) {
        // AJAX request to get the customer logs
        $.get('/customer/logs/' + cus_id, function(data) {
            let logsBody = $('#customerLogsBody');
            logsBody.empty();
            data.forEach(function(log) {
                logsBody.append(`
                    <tr>
                        <td>${log.Date_Time}</td>
                        <td>${log.type}</td>
                      <td>${parseFloat(log.credit).toFixed(2)}</td>
                    <td>${parseFloat(log.debit).toFixed(2)}</td>
                    <td>${parseFloat(log.Balance).toFixed(2)}</td>
                    </tr>
                `);
            });
            $('#customerLogModal').modal('show');
        });
    }

    function payment(cus_id,balance) {
        $('#cusId').val(cus_id);
        $('#maxBalance').text(parseFloat(balance).toFixed(2));
        $('#paymentAmount').attr('max', balance);
        $('#paymentModal').modal('show');
    }

    $('#paymentForm').submit(function(e) {
        e.preventDefault();

        // Confirmation prompt
        Swal.fire({
            title: 'Are you sure?',
            text: "Do you want to proceed with the payment?",
            icon: 'warning',
            showCancelButton: true,
            confirmButtonColor: '#3085d6',
            cancelButtonColor: '#d33',
            confirmButtonText: 'Yes, pay it!'
        }).then((result) => {
            if (result.isConfirmed) {
                let formData = $(this).serialize();
                $.ajax({
                    url: '/customer/payment',
                    type: 'POST',
                    data: formData,
                    headers: {
                        "X-CSRF-TOKEN": $('meta[name="csrf-token"]').attr("content"),
                    },
                    success: function(response) {
                        Swal.fire({
                            title: 'Payment Successful!',
                            text: response.message,
                            icon: 'success',
                            confirmButtonText: 'OK'
                        }).then(() => {
                            $('#paymentModal').modal('hide');
                            location.reload(); // Reload the page
                        });
                    },
                    error: function(response) {
                        Swal.fire({
                            title: 'Error!',
                            text: 'Failed to process payment. Please try again.',
                            icon: 'error',
                            confirmButtonText: 'OK'
                        });
                    }
                });
            }
        });
    });
    function exportToExcel(tableID, filename = '') {
        // Get the table element
        var table = document.getElementById(tableID);

        // Convert the table to a workbook
        var wb = XLSX.utils.table_to_book(table, { sheet: "Sheet1" });

        // Generate Excel file
        var wbout = XLSX.write(wb, { bookType: 'xlsx', type: 'binary' });

        // Convert the binary string to an octet string
        function s2ab(s) {
            var buf = new ArrayBuffer(s.length);
            var view = new Uint8Array(buf);
            for (var i = 0; i < s.length; i++) view[i] = s.charCodeAt(i) & 0xFF;
            return buf;
        }

        // Trigger the download
        saveAs(new Blob([s2ab(wbout)], { type: "application/octet-stream" }), filename + ".xlsx");
    }


</script>
@endsection