@extends('layouts/contentLayoutMaster')

@section('title', 'Payment Details')

@section('vendor-style')
    {{-- vendor css files --}}
    <link rel="stylesheet" href="{{ asset('vendors/css/forms/select/select2.min.css') }}">
    <link rel="stylesheet" href="{{ asset('vendors/css/tables/datatable/dataTables.bootstrap5.min.css') }}">
    <link rel="stylesheet" href="{{ asset('vendors/css/tables/datatable/buttons.bootstrap5.min.css') }}">
    <link rel="stylesheet" href="{{ asset('vendors/css/extensions/sweetalert2.min.css') }}">
    <link rel="stylesheet" href="{{ asset('/css/custom.css') }}">
@endsection
@section('content')

    <!-- Column Search -->
    <section id="column-search-datatable">
        <div class="row">
            <div class="col-12">
                <div class="card">
                    @if ($message = Session::get('success'))
                        <div class="demo-spacing-0 my-2">
                            <div class="alert alert-success alert-dismissible fade show" role="alert">
                                <div class="alert-body">{{ $message }}</div>
                                <button type="button" class="btn-close" data-bs-dismiss="alert"
                                    aria-label="Close"></button>
                            </div>
                        </div>
                    @endif
                    <div class="card-header border-bottom">
                        <h4 class="card-title">
                            Payment Calculation Details
                        </h4>
                       

                        <input type="hidden" name="payment_process_id" value="{{$paymentProcess->id}}" id="payment_process_id"/>
                        @if ($paymentProcess->status == 0)
                            <a class="add-new-btn btn btn-primary mt-2 mr_30px" href="#" data-bs-toggle="modal"
                                data-bs-target="#addModal">Add</a>
                        @endif
                    </div>
                    <div class="card-datatable table-responsive">
                        <table class="table" id="payments">
                            <thead>
                                <tr>
                                    <td colspan="1">
                                        <select class="select2 search-input" id="area_office">
                                            <option value="">Area Office</option>
                                            @foreach ($areaOffices as $areaOffice)
                                                <option value="{{ $areaOffice->id }}">{{ $areaOffice->name }}
                                                </option>
                                            @endforeach
                                        </select>
                                    </td>
                                    <td colspan="2">
                                        <select class="select2 search-input" id="supplier_id">
                                            <option value="" selected disabled>Supplier</option>
                                           
                                            @foreach ($payments as $payment)
                                            @if (!empty($payment['supplier']))
                                                <option value="{{ $payment['supplier']['_id'] }}">{{ $payment['supplier']['code'] . ' | '. $payment['supplier']['business_name'] }} 
                                                   
                                                </option>
                                                @endif
                                            @endforeach
                                        </select>
                                    </td>
                                    <td colspan="2">
                                        <select class="select2 search-input" id="source_type">
                                            <option value="">Supplier Type</option>
                                            @foreach ($sources as $source)
                                                <option value="{{ $source->id }}">{{ $source->name }}
                                                </option>
                                            @endforeach
                                        </select>
                                    </td>
                                    {{-- <td colspan="1">
                                        <select class="select2 search-input" id="collectionPoint">
                                            <option value="">Collection Point</option>
                                            @foreach ($payments as $payment)
                                                <option value="{{ $payment['collection_point'] }}">
                                                    {{ $payment['collection_point'] }}
                                                </option>
                                            @endforeach
                                        </select>
                                    </td> --}}
                                </tr>
                                <tr>
                                    <th>Supplier Code</th>
                                    <th>Supplier</th>
                                    <th>Supplier Type</th>
                                    <th>Area Office</th>
                                    <th>Total TS Volume</th>
                                    <th>Payable Without Incentives</th>
                                    <th>Volume Incentive Rate</th>
                                    <th>Total Volume Incentive</th>
                                    <th>Chilling Incentive Rate</th>
                                    <th>Total Chilling Incentive</th>
                                    <th>Haulage Incentive Rate</th>
                                    <th>Total Haulage Incentive</th>
                                    <th>Haulage Gate Incentive Rate</th>
                                    <th>Total Haulage Gate Incentive</th>
                                    <th>Loyalty Incentive Rate</th>
                                    <th>Total Loyalty Incentive</th>
                                    <th>AFM Incentive Rate</th>
                                    <th>Total AFM Incentive</th>
                                    <th>TPC Incentive Rate</th>
                                    <th>Total TPC Incentive</th>
                                    <th>Advance</th>
                                    <th>Agri Services 1</th>
                                    <th>Agri Services 2</th>
                                    <th>Other Deductions</th>
                                    <th>Other Incentives</th>
                                    <th>Other Incentive Deductions</th>
                                    <th>Gross Payable</th>
                                    <th>Remaining Dues</th>
                                    <th>Net Payable</th>
                                    <th>CNIC</th>
                                    <th>Collection Point</th>
                                    <th>Remarks</th>
                                    <th>Actions</th>
                                </tr>
                            </thead>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </section>
    <!--/ Column Search -->

    <div class="modal fade" id="editModal" tabindex="-1" aria-hidden="true">
        <div class="modal-dialog modal-dialog-centered">
            <div class="modal-content">
                <div class="modal-header bg-transparent">
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body px-sm-5 pb-5">
                    <div class="text-center mb-2">
                        <h1 class="mb-1">Update Payments</h1>
                    </div>

                    <form class="form" action="#" id="editForm" method="POST">
                        @csrf
                        <input type="hidden" name="id" id="edit_id">
                        <div class="col-12">
                            <div class="mb-1">
                                <label class="form-label" for="advance">Advance</label>
                                <input type="text" required id="advance" class="form-control" placeholder="advance"
                                    name="advance" value="" />
                                <span class="text-danger advance"></span>
                            </div>
                        </div>
                        <div class="col-12">
                            <div class="mb-1">
                                <label class="form-label" for="agri_Services_1">Agri Services 1</label>
                                <input type="text" required id="agri_Services_1" class="form-control"
                                    placeholder="agri_Services_1" name="agri_Services_1" value="" />
                                <span class="text-danger agri_Services_1"></span>
                            </div>
                        </div>
                        <div class="col-12">
                            <div class="mb-1">
                                <label class="form-label" for="agri_Services_2">Agri Services 2</label>
                                <input type="text" required id="agri_Services_2" class="form-control"
                                    placeholder="agri_Services_2" name="agri_Services_2" value="" />
                                <span class="text-danger agri_Services_2"></span>
                            </div>
                        </div>
                        <div class="col-12">
                            <div class="mb-1">
                                <label class="form-label" for="others">Other Deductions</label>
                                <input type="text" required id="others" class="form-control" placeholder="Others"
                                    name="others" value="" />
                                <span class="text-danger others"></span>
                            </div>
                        </div>
                        <div class="col-12">
                            <div class="mb-1">
                                <label class="form-label" for="others">Other Incentives</label>
                                <input type="text" required id="other_incentives" class="form-control"
                                    placeholder="other_incentives" name="other_incentives" value="" />
                                <span class="text-danger other_incentives"></span>
                            </div>
                        </div>
                        <div class="col-12">
                            <div class="mb-1">
                                <label class="form-label" for="others">Other Incentive Deductions</label>
                                <input type="text" required id="other_incentive_deductions" class="form-control"
                                    placeholder="other_incentive_deductions" name="other_incentive_deductions"
                                    value="" />
                                <span class="text-danger other_incentive_deductions"></span>
                            </div>
                        </div>
                        <div class="col-12">
                            <div class="mb-1">
                                <label class="form-label" for="others">remarks</label>
                                <input type="text" id="remarks" class="form-control" placeholder="remarks"
                                    name="remarks" value="" />
                                <span class="text-danger remarks"></span>
                            </div>
                        </div>
                        <div class="row">
                            <div class="col-12 text-center">
                                <button type="submit" id="updateForm" class="btn btn-primary me-1">Submit</button>
                                <button type="reset" class="btn btn-outline-secondary">Reset</button>
                            </div>
                        </div>
                    </form>
                </div>

            </div>
        </div>
    </div>

    <div class="modal fade" id="addModal" tabindex="-1" aria-hidden="true">
        <div class="modal-dialog modal-dialog-centered">
            <div class="modal-content">
                <div class="modal-header bg-transparent">
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body px-sm-5 pb-5">
                    <div class="text-center mb-2">
                        <h1 class="mb-1">Add Payment For Supplier</h1>
                    </div>

                    <form class="form" id="createForm" method="POST">
                        @csrf
                        <div class="row">
                            <input type="hidden" name="id" value="{{ $paymentProcess->id }}">
                            <div class="col-12">
                                <label class="form-label" for="supplier">Supplier</label>
                                <select name="supplier" class="form-select select2" required>
                                    <option value="" selected disabled>Select Supplier</option>
                                    @foreach ($suppliers as $supplier)
                                        <option value="{{ $supplier->id }}">
                                            {{ $supplier->code . ' ' . $supplier->business_name }}
                                        </option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="col-12">
                                <div>
                                    <label class="form-label" for="name-column">Other Incentives</label>
                                    <input type="text" required id="other_incentives-column" class="form-control"
                                        placeholder="Other Incentives" name="other_incentives" />
                                    <span class="text-danger create_name"></span>
                                </div>
                            </div>
                            <div class="col-12">
                                <div class="mb-1">
                                    <label class="form-label" for="name-column">Remarks</label>
                                    <input type="text" required id="remarks-column" class="form-control"
                                        placeholder="Remarks" name="remarks" />
                                    <span class="text-danger create_name"></span>

                                </div>
                            </div>
                            <div class="col-12 text-center">
                                <button type="submit" class="btn btn-primary me-1">Submit</button>
                                <button type="reset" class="btn btn-outline-secondary">Reset</button>
                            </div>
                        </div>
                    </form>
                </div>

            </div>
        </div>
    </div>
@endsection

@section('vendor-script')
    {{-- vendor files table data --}}
    <script src="{{ asset('vendors/js/tables/datatable/jquery.dataTables.min.js') }}"></script>
    <script src="{{ asset('vendors/js/tables/datatable/dataTables.bootstrap5.min.js') }}"></script>
    <script src="{{ asset('vendors/js/forms/select/select2.full.min.js') }}"></script>
    <script src="{{ asset('vendors/js/tables/datatable/datatables.buttons.min.js') }}"></script>
    <script src="{{ asset('vendors/js/tables/datatable/buttons.bootstrap5.min.js') }}"></script>
    <script src="{{ asset('vendors/js/extensions/sweetalert2.all.min.js') }}"></script>
@endsection

@section('page-script')
    <script src="{{ asset('/js/custom.js') }}"></script>
    <script>
        $(".select2").select2({});
        $("#supplier").select2({});
        $(".select2").select2({
            dropdownParent: $('#addModal .modal-content')
        });



        var table;
        $(document).ready(function() {
            $(".select2").select2({});
           
            var ppid= $("#payment_process_id").val();

            table = $('#payments').DataTable({
               
                processing: true,
                serverSide: true,
                paging: true,
                searching: false,
                ajax: {
                    headers: {
                        'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                    },
                    type: "POST",
                    url: "{{ route('get.payment.calculations') }}",
                    data: function(d) {
                         _token: '{{ csrf_token() }}';
                        d.page = (d.start / d.length) + 1; // DataTables calculates the page number based on start
                        d.length = d.length; // Page length (number of rows per page)
                        d.area_office_id = $('#area_office option:selected').val();
                        d.supplier_id = $('#supplier_id option:selected').val();
                        d.source_type_id = $('#source_type option:selected').val();

                        
                        d.ppid= ppid;
                       
                    }
                },
                columns: [{
                        data: 'supplier_code',
                        name: 'supplier_code'
                    },
                    {
                        data: 'supplier_name',
                        name: 'supplier_name'
                    },
                  
                    {
                        data: 'supplier_type',
                        name: 'supplier_type'
                    },
                    {
                        data: 'area_office',
                        name: 'area_office'
                    },  
                   
                    {
                        data: 'ts_vol',
                        name: 'ts_vol',
                        render: function(data, type, row) {
                            if (data !== null && !isNaN(data)) {
                                return parseFloat(data).toLocaleString(undefined, {
                                    minimumFractionDigits: 2,
                                    maximumFractionDigits: 2
                                });
                            }
                            return '0.00';
                        },
                        className: 'text-end'
                    },
                    {
                        data: 'payable_without_incentives',
                        name: 'payable_without_incentives',
                        render: function(data, type, row) {
                            if (data !== null && !isNaN(data)) {
                                return parseFloat(data).toLocaleString(undefined, {
                                    minimumFractionDigits: 2,
                                    maximumFractionDigits: 2
                                });
                            }
                            return '0.00';
                        },
                        className: 'text-end'
                    },
                    {
                        data: 'volume_incentive_rate',
                        name: 'volume_incentive_rate',
                        render: function(data, type, row) {
                            if (data !== null && !isNaN(data)) {
                                return parseFloat(data).toLocaleString(undefined, {
                                    minimumFractionDigits: 2,
                                    maximumFractionDigits: 2
                                });
                            }
                            return '0.00';
                        },
                        className: 'text-end'
                    },
                    {
                        data: 'total_volume_incentive',
                        name: 'total_volume_incentive',
                        render: function(data, type, row) {
                            if (data !== null && !isNaN(data)) {
                                return parseFloat(data).toLocaleString(undefined, {
                                    minimumFractionDigits: 2,
                                    maximumFractionDigits: 2
                                });
                            }
                            return '0.00';
                        },
                        className: 'text-end'
                    },
                    {
                        data: 'chilling_incentive_rate',
                        name: 'chilling_incentive_rate',
                        render: function(data, type, row) {
                            if (data !== null && !isNaN(data)) {
                                return parseFloat(data).toLocaleString(undefined, {
                                    minimumFractionDigits: 2,
                                    maximumFractionDigits: 2
                                });
                            }
                            return '0.00';
                        },
                        className: 'text-end'
                    },
                    {
                        data: 'total_chilling_incentive',
                        name: 'total_chilling_incentive',
                        render: function(data, type, row) {
                            if (data !== null && !isNaN(data)) {
                                return parseFloat(data).toLocaleString(undefined, {
                                    minimumFractionDigits: 2,
                                    maximumFractionDigits: 2
                                });
                            }
                            return '0.00';
                        },
                        className: 'text-end'
                    },
                    {
                        data: 'haulage_incentive_rate',
                        name: 'haulage_incentive_rate',
                        render: function(data, type, row) {
                            if (data !== null && !isNaN(data)) {
                                return parseFloat(data).toLocaleString(undefined, {
                                    minimumFractionDigits: 2,
                                    maximumFractionDigits: 2
                                });
                            }
                            return '0.00';
                        },
                        className: 'text-end'
                    },
                    {
                        data: 'total_haulage_incentive',
                        name: 'total_haulage_incentive',
                        render: function(data, type, row) {
                            if (data !== null && !isNaN(data)) {
                                return parseFloat(data).toLocaleString(undefined, {
                                    minimumFractionDigits: 2,
                                    maximumFractionDigits: 2
                                });
                            }
                            return '0.00';
                        },
                        className: 'text-end'
                    },




                    {
                        data: 'haulage_gate_incentive_rate',
                        name: 'haulage_gate_incentive_rate',
                        render: function(data, type, row) {
                            if (data !== null && !isNaN(data)) {
                                return parseFloat(data).toLocaleString(undefined, {
                                    minimumFractionDigits: 2,
                                    maximumFractionDigits: 2
                                });
                            }
                            return '0.00';
                        },
                        className: 'text-end'
                    },{
                        data: 'total_haulage_gate_incentive',
                        name: 'total_haulage_gate_incentive',
                        render: function(data, type, row) {
                            if (data !== null && !isNaN(data)) {
                                return parseFloat(data).toLocaleString(undefined, {
                                    minimumFractionDigits: 2,
                                    maximumFractionDigits: 2
                                });
                            }
                            return '0.00';
                        },
                        className: 'text-end'
                    },{
                        data: 'loyalty_incentive_rate',
                        name: 'loyalty_incentive_rate',
                        render: function(data, type, row) {
                            if (data !== null && !isNaN(data)) {
                                return parseFloat(data).toLocaleString(undefined, {
                                    minimumFractionDigits: 2,
                                    maximumFractionDigits: 2
                                });
                            }
                            return '0.00';
                        },
                        className: 'text-end'
                    },{
                        data: 'total_loyalty_incentive',
                        name: 'total_loyalty_incentive',
                        render: function(data, type, row) {
                            if (data !== null && !isNaN(data)) {
                                return parseFloat(data).toLocaleString(undefined, {
                                    minimumFractionDigits: 2,
                                    maximumFractionDigits: 2
                                });
                            }
                            return '0.00';
                        },
                        className: 'text-end'
                    },{
                        data: 'afm_incentive_rate',
                        name: 'afm_incentive_rate',
                        render: function(data, type, row) {
                            if (data !== null && !isNaN(data)) {
                                return parseFloat(data).toLocaleString(undefined, {
                                    minimumFractionDigits: 2,
                                    maximumFractionDigits: 2
                                });
                            }
                            return '0.00';
                        },
                        className: 'text-end'
                    },{
                        data: 'total_afm_incentive',
                        name: 'total_afm_incentive',
                        render: function(data, type, row) {
                            if (data !== null && !isNaN(data)) {
                                return parseFloat(data).toLocaleString(undefined, {
                                    minimumFractionDigits: 2,
                                    maximumFractionDigits: 2
                                });
                            }
                            return '0.00';
                        },
                        className: 'text-end'
                    },
                    {
                        data: 'tpc_incentive_rate',
                        name: 'tpc_incentive_rate',
                        render: function(data, type, row) {
                            if (data !== null && !isNaN(data)) {
                                return parseFloat(data).toLocaleString(undefined, {
                                    minimumFractionDigits: 2,
                                    maximumFractionDigits: 2
                                });
                            }
                            return '0.00';
                        },
                        className: 'text-end'
                    },
                    {
                        data: 'total_tpc_incentive',
                        name: 'total_tpc_incentive',
                        render: function(data, type, row) {
                            if (data !== null && !isNaN(data)) {
                                return parseFloat(data).toLocaleString(undefined, {
                                    minimumFractionDigits: 2,
                                    maximumFractionDigits: 2
                                });
                            }
                            return '0.00';
                        },
                        className: 'text-end'
                    },
                    {
                        data: 'advance',
                        name: 'advance',
                        render: function(data, type, row) {
                            if (data !== null && !isNaN(data)) {
                                return parseFloat(data).toLocaleString(undefined, {
                                    minimumFractionDigits: 2,
                                    maximumFractionDigits: 2
                                });
                            }
                            return '0.00';
                        },
                        className: 'text-end'
                    },
                    {
                        data: 'agri_Services_1',
                        name: 'agri_Services_1',
                        className: 'text-end'
                    },
                    {
                        data: 'agri_Services_2',
                        name: 'agri_Services_2',
                        className: 'text-end'
                    },
                    {
                        data: 'others',
                        name: 'others',
                        render: function(data, type, row) {
                            if (data !== null && !isNaN(data)) {
                                return parseFloat(data).toLocaleString(undefined, {
                                    minimumFractionDigits: 2,
                                    maximumFractionDigits: 2
                                });
                            }
                            return '0.00';
                        },
                        className: 'text-end'
                    },
                    {
                        data: 'other_incentives',
                        name: 'other_incentives',
                        render: function(data, type, row) {
                            if (data !== null && !isNaN(data)) {
                                return parseFloat(data).toLocaleString(undefined, {
                                    minimumFractionDigits: 2,
                                    maximumFractionDigits: 2
                                });
                            }
                            return '0.00';
                        },
                        className: 'text-end'
                    },
                    {
                        data: 'other_incentive_deductions',
                        name: 'other_incentive_deductions',
                        render: function(data, type, row) {
                            if (data !== null && !isNaN(data)) {
                                return parseFloat(data).toLocaleString(undefined, {
                                    minimumFractionDigits: 2,
                                    maximumFractionDigits: 2
                                });
                            }
                            return '0.00';
                        },
                        className: 'text-end'
                    },
                    {
                        data: 'gross_payable',
                        name: 'gross_payable',
                        render: function(data, type, row) {
                            if (data !== null && !isNaN(data)) {
                                return parseFloat(data).toLocaleString(undefined, {
                                    minimumFractionDigits: 2,
                                    maximumFractionDigits: 2
                                });
                            }
                            return '0.00';
                        },
                        className: 'text-end'
                    },
                    {
                        data: 'remaining_Dues',
                        name: 'remaining_Dues',
                        render: function(data, type, row) {
                            if (data !== null && !isNaN(data)) {
                                return parseFloat(data).toLocaleString(undefined, {
                                    minimumFractionDigits: 2,
                                    maximumFractionDigits: 2
                                });
                            }
                            return '0.00';
                        },
                        className: 'text-end'
                    }, {
                        data: 'net_payable',
                        name: 'net_payable',
                        render: function(data, type, row) {
                            if (data !== null && !isNaN(data)) {
                                return parseFloat(data).toLocaleString(undefined, {
                                    minimumFractionDigits: 2,
                                    maximumFractionDigits: 2
                                });
                            }
                            return '0.00';
                        },
                        className: 'text-end'
                    }, {
                        data: 'cnic',
                        name: 'cnic'
                    },
                    {
                        data: 'collection_point_name',
                        name: 'collection_point_name'
                    },
                    {
                        data: 'remarks',
                        name: 'remarks'
                    },
                    {
                        data: 'action_buttons',
                        name: 'action_buttons'
                    },
                   
                ],
                dom: '<"d-flex justify-content-between align-items-center header-actions text-nowrap mx-1 row mt-75"' +
                    '<"col-sm-12 col-lg-4 d-flex justify-content-center justify-content-lg-start" l>' +
                    '<"col-sm-12 col-lg-8"<"dt-action-buttons d-flex align-items-center justify-content-lg-end justify-content-center flex-md-nowrap flex-wrap"<"me-1"f>>>' +
                    '><"text-nowrap" t>' +
                    '<"d-flex justify-content-between mx-2 row mb-1"' +
                    '<"col-sm-12 col-md-6"i>' +
                    '<"col-sm-12 col-md-6"p>' +
                    '>',
                language: {
                    paginate: {
                        previous: '&nbsp;',
                        next: '&nbsp;'
                    }
                }
            });
            $(".search-input").on('change', function() {
                table.ajax.reload();
            });
          
        });

     
        

        $(document).on('submit', '#editForm', function(e) {
            var dataTable = $('#payments').DataTable();
            $('.text-danger').text('')
            e.preventDefault();
            var selectedId = $('#edit_id').val();
           
            let formData = $(this).serialize();
            formData += '&id=' + selectedId
            $.ajax({
                url: '{{ route('payment.update') }}',
                method: 'POST',
                data: formData,
                success: function(response) {
                    if (response.success) {
                        $('#editModal').modal('toggle');
                        Swal.fire(
                            'Done!',
                            response.message,
                            'success'
                        )
                      
                        // var row = dataTable.page();
                        var row = dataTable.row('#row-' + selectedId);  // Ensure row has an ID selector
                        if (row.length) {

                            row.data({
                        advance: response.payment.advance,
                        agri_Services_1: response.payment.agri_Services_1,
                        agri_Services_2: response.payment.agri_Services_2,
                        others: response.payment.others,
                        other_incentives: response.payment.other_incentives,
                        other_incentive_deductions: response.payment.other_incentive_deductions,
                        net_payable: response.payment.net_payable,
                        remarks: response.payment.remarks,
                        gross_payable: response.payment.gross_payable
                    }).draw();
                } else {
                    dataTable.ajax.reload(null, false); // Reload full table if row not found
                }
                      
                        
                    } else {
                        Swal.fire(
                            'Done!',
                            response.message,
                            'error'
                        )
                        $('.edit_' + response.key).text(response.message)
                    }
                }
            });
        });

        function editRecord(id, advance, agri_Services_1, agri_Services_2, others, other_incentives) {
           
            $("#edit_id").val(id);
            $("#advance").val(advance);
            $("#agri_Services_1").val(agri_Services_1);
            $("#agri_Services_2").val(agri_Services_2);
            $("#others").val(others);
            $("#other_incentives").val(other_incentives);
            var row = dataTable.row($(this).closest('tr'));
            var rowIndex = row.index();
        }
        $(document).on('click', '#payments tbody .editable', function() {
            var dataTable = $('#payments').DataTable(); 
    var row = dataTable.row($(this).closest('tr')); 
            var rowData = row.data();          
            
            var id = rowData['DT_RowId'];
            
            var advance = rowData['advance'];
            var agri_Services_1 = rowData['agri_Services_1'];
            var agri_Services_2 = rowData['agri_Services_2'];
            var others = rowData['others'];
            var other_incentives = rowData['other_incentives'];
            var other_incentive_deductions = rowData['other_incentive_deductions'];
            var remarks = rowData['remarks'];

            $("#edit_id").val(id);
            $("#advance").val(advance);
            $("#agri_Services_1").val(agri_Services_1);
            $("#agri_Services_2").val(agri_Services_2);
            $("#others").val(others);
            $("#other_incentives").val(other_incentives);
            $("#other_incentive_deductions").val(other_incentive_deductions);
            $("#remarks").val(remarks);
        });

        $('#area_office').on('change', function() {
            var dataTable = $('#payments').DataTable();
            var areaOfficeId = $(this).val();
            console.log(areaOfficeId);
            dataTable.column(3).search(areaOfficeId).draw(); 
        });

        // Event listener for Plant filter
        $('#source').on('change', function() {
            var sourceId = $(this).val();
            dataTable.column(2).search(sourceId).draw(); 
        });

        $('#collectionPoint').on('change', function() {
            var collectionPointId = $(this).val();
            dataTable.column(18).search(collectionPointId).draw(); 
        });

        // Event listener for Supplier filter
        $('#supplier').on('change', function() {
            var supplierId = $(this).val();
            dataTable.column(1).search(supplierId).draw(); 
        });

        $(document).on('submit', '#createForm', function(e) {
            $('.text-danger').text('')
            e.preventDefault();
            var dataTable = $('#payments').DataTable();
            let data = $(this).serialize();
            $.ajax({
                url: '{{ route('payment-calculation.store') }}',
                method: 'POST',
                data: data,
                success: function(response) {
                    if (response.success) {
                        $('#supplier').val('');
                        $('#other_incentives-column').val('');
                        $('#remarks-column').val('');

                        $('#addModal').modal('toggle');
                        Swal.fire(
                            'Done!',
                            response.message,
                            'success'
                        )
                        dataTable.ajax.reload(null, false);
                    } else {
                        $('.create_' + response.key).text(response.message)
                    }
                }
            });
        });
    </script>
@endsection