@extends('operations.layout.mainlayout')

@section('content')
<link href="/css/operations.css?v={{ filemtime(public_path('css/operations.css')) }}" rel="stylesheet">
<style>
body {
    overflow-x: hidden;
}

.providers-page {
    color: #333333;
    font-size: 15px;
    max-width: 100%;
    overflow-x: hidden;
}

.providers-page .container-fluid,
.providers-header,
.summary-grid,
.providers-panel {
    max-width: 100%;
    min-width: 0;
}

.providers-header {
    background: #ffffff;
    border: 1px solid #ececec;
    border-radius: 8px;
    padding: 18px 20px;
    margin-bottom: 16px;
    display: flex;
    justify-content: space-between;
    align-items: center;
    gap: 12px;
    flex-wrap: wrap;
}

.providers-title {
    margin: 0;
    font-size: 24px;
    font-weight: 700;
}

.providers-subtitle {
    margin: 4px 0 0;
    color: #6c757d;
    font-size: 15px;
}

.btn-medinsure {
    background: var(--blazma-primary);
    border: 1px solid var(--blazma-primary);
    color: #ffffff !important;
    border-radius: 24px;
    padding: 8px 18px;
    min-height: 38px;
}

.btn-medinsure:hover {
    background: #ffffff;
    color: #000000 !important;
    border-color: var(--blazma-primary);
}

.btn-medinsure-light {
    background: #ffffff;
    border: 1px solid var(--blazma-primary);
    color: var(--blazma-primary) !important;
    border-radius: 24px;
    padding: 7px 14px;
    min-height: 36px;
}

.btn-medinsure-light:hover {
    background: var(--blazma-primary);
    color: #ffffff !important;
}

.summary-grid {
    display: grid;
    grid-template-columns: repeat(auto-fit, minmax(220px, 1fr));
    gap: 12px;
    margin-bottom: 16px;
}

.summary-card {
    position: relative;
    display: flex;
    align-items: center;
    justify-content: space-between;
    gap: 12px;
    border: 1px solid #ececec;
    border-radius: 8px;
    padding: 16px 18px;
    background: #ffffff;
    box-shadow: 0 6px 14px rgba(36, 41, 50, 0.035);
    min-height: 92px;
}

.summary-card::before {
    content: "";
    position: absolute;
    left: 0;
    top: 0;
    width: 100%;
    height: 3px;
    background: var(--blazma-primary);
}

.summary-card-active::before {
    background: #2f9e59;
}

.summary-card-expiring::before {
    background: #f0ad2c;
}

.summary-card-blocked::before {
    background: var(--blazma-primary);
}

.summary-card-content {
    position: relative;
    z-index: 1;
}

.summary-card span {
    display: block;
    color: #6c757d;
    font-size: 13px;
    text-transform: uppercase;
    letter-spacing: 0;
    font-weight: 700;
}

.summary-card strong {
    display: block;
    margin-top: 6px;
    font-size: 28px;
    line-height: 1;
    color: #242932;
}

.summary-card small {
    display: block;
    margin-top: 7px;
    color: #7b8290;
    font-size: 13px;
}

.providers-panel {
    background: #ffffff;
    border: 1px solid #ececec;
    border-radius: 8px;
    padding: 18px;
}

.filters-row {
    display: grid;
    grid-template-columns: 190px 220px 1fr;
    gap: 10px;
    align-items: center;
    margin-bottom: 14px;
}

.providers-counter {
    justify-self: end;
    color: #5d6672;
    font-weight: 700;
}

.provider-cell {
    display: flex;
    align-items: center;
    gap: 10px;
    min-height: 46px;
    text-align: left;
}

.provider-avatar {
    flex: 0 0 38px;
    width: 38px;
    height: 38px;
    border-radius: 50%;
    background: #f8edf1;
    color: var(--blazma-primary);
    display: inline-flex;
    align-items: center;
    justify-content: center;
    font-weight: 800;
}

.provider-text {
    display: flex;
    flex-direction: column;
    justify-content: center;
    min-height: 38px;
}

.provider-name {
    font-weight: 700;
    line-height: 1.2;
}

.provider-meta {
    color: #6c757d;
    font-size: 13px;
    line-height: 1.2;
    margin-top: 3px;
}

.status-badge {
    display: inline-flex;
    align-items: center;
    border-radius: 18px;
    padding: 5px 11px;
    font-size: 13px;
    font-weight: 700;
}

.status-active,
.rate-low {
    background: #e9f6ee;
    color: #247a3d;
}

.status-inactive,
.status-expired {
    background: #eceff3;
    color: #5d6672;
}

.status-blocked,
.rate-high {
    background: #fde8e8;
    color: #a51d2d;
}

.status-expiring,
.status-pending,
.rate-mid {
    background: #fff6de;
    color: #8a6500;
}

#insurances-table {
    width: 100% !important;
    font-size: 15px;
}

.providers-table-wrap {
    overflow-x: hidden;
    width: 100%;
}

.providers-panel div.dataTables_wrapper {
    width: 100%;
}

#insurances-table thead th {
    background-color: var(--blazma-primary);
    color: #ffffff;
    font-weight: 600;
    white-space: nowrap;
}

#insurances-table tbody td {
    vertical-align: middle;
}

#insurances-table_wrapper .page-item.previous .page-link,
#insurances-table_wrapper .page-item.next .page-link,
#insurances-table_wrapper .page-item:first-child .page-link,
#insurances-table_wrapper .page-item:last-child .page-link,
#modal-price-list-table_wrapper .page-item.previous .page-link,
#modal-price-list-table_wrapper .page-item.next .page-link,
#modal-price-list-table_wrapper .page-item:first-child .page-link,
#modal-price-list-table_wrapper .page-item:last-child .page-link {
    width: auto !important;
    min-width: 82px;
    padding-left: 14px !important;
    padding-right: 14px !important;
    white-space: nowrap;
}

.table-actions {
    display: flex;
    gap: 6px;
    flex-wrap: wrap;
}

#modal-price-list-table {
    width: 100% !important;
}

#modal-price-list .modal-dialog {
    margin-top: 24px;
}

#modal-price-list .modal-content {
    background: #f4f6f9;
    border: 0;
    border-radius: 18px;
    overflow: hidden;
    padding: 0;
}

#modal-price-list .modal-header {
    align-items: center;
    border-bottom: 0;
    min-height: 64px;
    padding: 16px 24px;
}

#modal-price-list .modal-title {
    line-height: 1.2;
    margin: 0;
}

#modal-price-list .close {
    margin: 0;
    padding: 0;
    opacity: 1;
    text-shadow: none;
}

#modal-price-list .modal-body {
    padding: 18px 24px 12px;
}

#modal-price-list input[type="checkbox"] {
    accent-color: var(--blazma-primary);
}

.modal-xl {
    max-width: 1140px;
}

#modal-price-list-table th {
    white-space: nowrap;
    padding: 10px 8px;
}

#modal-price-list-table td {
    vertical-align: middle;
    padding: 10px;
}

@media (max-width: 992px) {
    .filters-row {
        grid-template-columns: 1fr;
    }

    .providers-counter {
        justify-self: start;
    }
}
</style>

<section class="content providers-page">
    <div class="container-fluid">
        <div class="providers-header">
            <div>
                <h1 class="providers-title">Insurance Providers</h1>
                <p class="providers-subtitle">Manage provider contracts, coverage plans, claims health, and local sync state</p>
            </div>
            <a href="/operations/insurance/create" class="btn btn-medinsure">
                <i class="fas fa-plus"></i> Add New Insurance
            </a>
        </div>

        <div class="summary-grid">
            <div class="summary-card">
                <div class="summary-card-content">
                    <span>Total Providers</span>
                    <strong>{{ $providerSummary['total'] }}</strong>
                    <small>All configured networks</small>
                </div>
            </div>
            <div class="summary-card summary-card-active">
                <div class="summary-card-content">
                    <span>Active</span>
                    <strong>{{ $providerSummary['active'] }}</strong>
                    <small>Available for billing</small>
                </div>
            </div>
            <div class="summary-card summary-card-expiring">
                <div class="summary-card-content">
                    <span>Expiring Soon</span>
                    <strong>{{ $providerSummary['expiring_soon'] }}</strong>
                    <small>Needs contract review</small>
                </div>
            </div>
            <div class="summary-card summary-card-blocked">
                <div class="summary-card-content">
                    <span>Blocked</span>
                    <strong>{{ $providerSummary['blocked'] }}</strong>
                    <small>Temporarily restricted</small>
                </div>
            </div>
        </div>

        <div class="providers-panel">
            <div class="filters-row">
                <select id="status-filter" class="form-control">
                    <option value="">All Statuses</option>
                    <option value="active">Active</option>
                    <option value="inactive">Inactive</option>
                    <option value="blocked">Blocked</option>
                </select>
                <select id="group-filter" class="form-control">
                    <option value="">All Groups</option>
                    @foreach($groups as $group)
                        <option value="{{ $group->ID }}">{{ $group->NAME }}</option>
                    @endforeach
                </select>
                <div id="providers-counter" class="providers-counter">{{ $insurances->count() }} providers</div>
            </div>

            <div class="providers-table-wrap">
                <table id="insurances-table" class="table table-bordered table-striped">
                    <thead>
                        <tr>
                            <th>ID</th>
                            <th>Provider</th>
                            <th>Group</th>
                            <th>Contact</th>
                            <th>Claims</th>
                            <th>Denial Rate</th>
                            <th>Contract</th>
                            <th>Status</th>
                            <th>Actions</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($insurances as $insurance)
                            @php
                                $providerCode = 'INS-' . str_pad($insurance->ID, 5, '0', STR_PAD_LEFT);
                                $displayStatus = $insurance->IS_BLOCKED == 1 ? 'blocked' : ($insurance->IS_ACTIVE == 1 ? 'active' : 'inactive');
                                $displayStatusLabel = ucfirst($displayStatus);
                                $contractStatus = $insurance->CONTRACT_STATUS_DISPLAY;
                                $contractClass = $insurance->IS_EXPIRING_SOON ? 'status-expiring' : ($contractStatus == 'ACTIVE' ? 'status-active' : ($contractStatus == 'EXPIRED' ? 'status-expired' : 'status-pending'));
                                $contractLabel = $insurance->IS_EXPIRING_SOON ? 'Expiring' : ucfirst(strtolower($contractStatus));
                                $rateClass = $insurance->DENIAL_RATE < 3 ? 'rate-low' : ($insurance->DENIAL_RATE <= 6 ? 'rate-mid' : 'rate-high');
                            @endphp
                            <tr data-status="{{ $displayStatus }}" data-group="{{ $insurance->GROUP_ID }}" data-search="{{ strtolower($providerCode . ' ' . $insurance->NAME . ' ' . $insurance->EMAIL) }}">
                                <td>{{ $providerCode }}</td>
                                <td>
                                    <div class="provider-cell">
                                        <span class="provider-avatar">{{ strtoupper(substr($insurance->NAME, 0, 1)) }}</span>
                                        <div class="provider-text">
                                            <div class="provider-name">{{ $insurance->NAME }}</div>
                                            @if($insurance->NAME_AR)
                                                <div class="provider-meta">{{ $insurance->NAME_AR }}</div>
                                            @endif
                                        </div>
                                    </div>
                                </td>
                                <td>{{ optional($insurance->group)->NAME ?: '-' }}</td>
                                <td>
                                    <div>{{ $insurance->EMAIL ?: '-' }}</div>
                                    <div class="provider-meta">{{ $insurance->MOBILE_NUMBER ?: '-' }}</div>
                                </td>
                                <td>{{ $insurance->CLAIMS_COUNT }}</td>
                                <td><span class="status-badge {{ $rateClass }}">{{ number_format($insurance->DENIAL_RATE, 2) }}%</span></td>
                                <td>
                                    <span class="status-badge {{ $contractClass }}">{{ $contractLabel }}</span>
                                    @if($insurance->DAYS_UNTIL_EXPIRY !== null)
                                        <div class="provider-meta">{{ $insurance->DAYS_UNTIL_EXPIRY }} days</div>
                                    @endif
                                </td>
                                <td><span class="status-badge status-{{ $displayStatus }}">{{ $displayStatusLabel }}</span></td>
                                <td>
                                    <div class="table-actions">
                                        <a href="/operations/insurance/details/{{ $insurance->ID }}" class="btn btn-sm btn-medinsure-light">
                                            <i class="fas fa-edit"></i> Edit
                                        </a>
                                        <a href="#" class="btn btn-sm btn-medinsure-light price-list-btn" data-id="{{ $insurance->ID }}">
                                            <i class="fas fa-list"></i> Price List
                                        </a>
                                        <button type="button" class="btn btn-sm btn-medinsure-light block-provider-btn" data-id="{{ $insurance->ID }}" data-blocked="{{ $insurance->IS_BLOCKED == 1 ? 1 : 0 }}">
                                            <i class="fas {{ $insurance->IS_BLOCKED == 1 ? 'fa-unlock' : 'fa-ban' }}"></i> {{ $insurance->IS_BLOCKED == 1 ? 'Unblock' : 'Block' }}
                                        </button>
                                    </div>
                                </td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</section>

<div class="modal fade" id="modal-price-list">
    <div class="modal-dialog modal-xl">
        <div class="modal-content">
            <div class="modal-header" style="background: var(--blazma-primary); color: #ffffff;">
                <h3 class="modal-title">Insurance Price List</h3>
                <button type="button" class="close text-white" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">&times;</span>
                </button>
            </div>
            <div class="modal-body">
                <div class="row">
                    <div class="col" style="text-align: center;">
                        <div class="alert alert-danger alert-danger-price-list" role="alert" style="display: none;"></div>
                    </div>
                </div>

                <div class="row mb-3">
                    <div class="col-md-6">
                        <input type="hidden" id="insurance_id" value="">
                        <input type="hidden" id="hospital-select" value="0">
                        <h4 id="insurance-name" class="mt-2"></h4>
                    </div>
                    <div class="col-md-6 text-right">
                        <button id="bulk-upload-btn" class="btn btn-medinsure-light" style="margin-top: 32px;">
                            <i class="fas fa-upload"></i> Import Price List
                        </button>
                        <button id="show-export-modal" class="btn btn-medinsure-light" style="margin-top: 32px; margin-left: 10px;">
                            <i class="fas fa-file-export"></i> Download Price List
                        </button>
                    </div>
                </div>

                <div class="row">
                    <div class="col-12">
                        <table id="modal-price-list-table" class="table table-bordered table-striped">
                            <thead>
                                <tr>
                                    <th>Test Name</th>
                                    <th>Service Type</th>
                                    <th>Type</th>
                                    <th>Price (without tax)</th>
                                    <th>Cost Price</th>
                                    <th>Requires Approval</th>
                                    <th>Is Excluded</th>
                                </tr>
                            </thead>
                            <tbody></tbody>
                        </table>
                    </div>
                </div>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-medinsure-light" data-dismiss="modal">Close</button>
            </div>
        </div>
    </div>
</div>

<div class="modal fade" id="bulk-upload-modal" tabindex="-1" role="dialog" aria-labelledby="bulkUploadModalLabel" aria-hidden="true">
    <div class="modal-dialog" role="document">
        <div class="modal-content">
            <div class="modal-header" style="background: var(--blazma-primary); color: #ffffff;">
                <h5 class="modal-title" id="bulkUploadModalLabel">Import Price List</h5>
                <button type="button" class="close text-white" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">&times;</span>
                </button>
            </div>
            <div class="modal-body">
                <div class="alert alert-danger alert-danger-bulk-upload" role="alert" style="display: none;"></div>
                <div class="alert alert-info">
                    <p>Please download the template file, fill in the prices, and upload it back.</p>
                    <p>Format: CSV file with columns: TEST_ID, TEST_NAME, PRICE, COST_PRICE, REQUIRES_APPROVAL, IS_EXCLUDED, TYPE</p>
                    <p>Note: TEST_NAME is for reference only. REQUIRES_APPROVAL and IS_EXCLUDED should be 0 or 1. TYPE should be 1 for Normal or 2 for Home Visit.</p>
                </div>
                <div class="mb-3">
                    <a href="#" id="download-template-btn" class="btn btn-medinsure-light">
                        <i class="fas fa-download"></i> Download Template
                    </a>
                </div>
                <form id="bulk-upload-form" enctype="multipart/form-data">
                    <div class="form-group">
                        <label for="bulk-file">Upload CSV File</label>
                        <div class="custom-file">
                            <input type="file" class="custom-file-input" id="bulk-file" name="bulk_file" accept=".csv" required>
                            <label class="custom-file-label" for="bulk-file">Choose file</label>
                        </div>
                    </div>
                </form>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-medinsure-light" data-dismiss="modal">Close</button>
                <button type="button" class="btn btn-medinsure" id="upload-bulk-btn">Upload</button>
            </div>
        </div>
    </div>
</div>
@endsection

@section('footer-scripts')
<script>
$(document).ready(function () {
    $.fn.dataTable.ext.search.push(function (settings, data, dataIndex) {
        if (settings.nTable.id !== 'insurances-table') {
            return true;
        }

        var row = $(settings.aoData[dataIndex].nTr);
        var statusFilter = $('#status-filter').val();
        var groupFilter = $('#group-filter').val();

        if (statusFilter && row.data('status') !== statusFilter) {
            return false;
        }

        if (groupFilter && String(row.data('group')) !== groupFilter) {
            return false;
        }

        return true;
    });

    var table = $('#insurances-table').DataTable({
        pageLength: 25,
        lengthChange: false,
        responsive: true,
        autoWidth: false,
        order: [[0, 'desc']],
        language: {
            searchPlaceholder: 'Search by name, ID, or email...',
            info: 'Showing _END_ of _TOTAL_ providers',
            infoEmpty: 'Showing 0 of 0 providers',
            infoFiltered: '(filtered from _MAX_ total providers)'
        }
    });

    function updateProvidersCounter() {
        var count = table.rows({ filter: 'applied' }).count();
        $('#providers-counter').text(count + (count === 1 ? ' provider' : ' providers'));
    }

    table.on('draw', updateProvidersCounter);
    updateProvidersCounter();

    $('#status-filter, #group-filter').on('change', function () {
        table.draw();
    });

    $('.price-list-btn').on('click', function(e) {
        e.preventDefault();

        var insuranceId = $(this).data('id');
        var insuranceName = $(this).closest('tr').find('.provider-name').text();

        $('#insurance_id').val(insuranceId);
        $('#insurance-name').text('Provider: ' + insuranceName);
        $('.alert-danger-price-list').hide();
        $('#modal-price-list').modal('show');

        initializePriceListTable(insuranceId);
    });

    function initializePriceListTable(insuranceId) {
        if ($.fn.DataTable.isDataTable('#modal-price-list-table')) {
            $('#modal-price-list-table').DataTable().destroy();
        }

        $('#modal-price-list-table').DataTable({
            processing: true,
            serverSide: true,
            autoWidth: false,
            responsive: true,
            ajax: {
                url: '/operations/insurance/' + insuranceId + '/hospital/{{ session()->has('hospital_id') ? session('hospital_id') : 0 }}/pricelist',
                data: function(d) {
                    if (d.search && d.search.value) {
                        d.search_name = d.search.value;
                        d.search.value = '';
                    }
                },
                error: function(xhr) {
                    var errorMsg = 'An error occurred while loading data';
                    if (xhr.responseJSON && xhr.responseJSON.message) {
                        errorMsg = xhr.responseJSON.message;
                    }
                    $('.alert-danger-price-list').text(errorMsg).show();
                }
            },
            columns: [
                { data: 'NAME_EN', name: 'NAME_EN' },
                { data: 'SERVICE_TYPE', name: 'SERVICE_TYPE' },
                { data: 'TYPE_TITLE', name: 'TYPE_TITLE' },
                {
                    data: 'PRICE',
                    name: 'PRICE',
                    render: function(data, type, row) {
                        return '<a href="#" class="editable-price" data-pk="' + row.ID + '" data-name="PRICE" data-type="number" data-step="0.01" data-insurance-id="' + $('#insurance_id').val() + '">' + (data || 0) + '</a>';
                    }
                },
                {
                    data: 'COST_PRICE',
                    name: 'COST_PRICE',
                    render: function(data, type, row) {
                        return '<a href="#" class="editable-cost-price" data-pk="' + row.ID + '" data-name="COST_PRICE" data-type="number" data-step="0.01" data-insurance-id="' + $('#insurance_id').val() + '">' + (data || 0) + '</a>';
                    }
                },
                {
                    data: 'REQUIRES_APPROVAL',
                    name: 'REQUIRES_APPROVAL',
                    render: function(data, type, row) {
                        var checked = data === 0 ? '' : 'checked';
                        return '<input type="checkbox" class="approval-checkbox" data-pk="' + row.ID + '" data-insurance-id="' + $('#insurance_id').val() + '" ' + checked + '>';
                    }
                },
                {
                    data: 'IS_EXCLUDED',
                    name: 'IS_EXCLUDED',
                    render: function(data, type, row) {
                        var checked = data == 1 ? 'checked' : '';
                        return '<input type="checkbox" class="excluded-checkbox" data-pk="' + row.ID + '" data-insurance-id="' + $('#insurance_id').val() + '" ' + checked + '>';
                    }
                }
            ],
            order: [[0, 'asc']],
            drawCallback: function() {
                $('.editable-price').editable({
                    type: 'number',
                    step: 0.01,
                    url: '/operations/insurance/test-price/save',
                    title: 'Enter price',
                    params: function(params) {
                        params.INSURANCE_ID = $(this).data('insurance-id');
                        return params;
                    },
                    success: function(response) {
                        if (response && response.success) {
                            toastr.success('Price updated successfully');
                        } else {
                            return response.message || 'An error occurred';
                        }
                    }
                });

                $('.editable-cost-price').editable({
                    type: 'number',
                    step: 0.01,
                    url: '/operations/insurance/test-price/save',
                    title: 'Enter cost price',
                    params: function(params) {
                        params.INSURANCE_ID = $(this).data('insurance-id');
                        return params;
                    },
                    success: function(response) {
                        if (response && response.success) {
                            toastr.success('Cost price updated successfully');
                        } else {
                            return response.message || 'An error occurred';
                        }
                    }
                });

                $('.approval-checkbox').off('change').on('change', function() {
                    updatePriceFlag($(this), 'REQUIRES_APPROVAL', $(this).prop('checked') ? 1 : 0, 'Approval status updated');
                });

                $('.excluded-checkbox').off('change').on('change', function() {
                    updatePriceFlag($(this), 'IS_EXCLUDED', $(this).prop('checked') ? 1 : 0, 'Exclusion status updated');
                });
            }
        });
    }

    function updatePriceFlag(element, fieldName, value, successMessage) {
        $.ajax({
            url: '/operations/insurance/test-price/save',
            type: 'POST',
            data: {
                pk: element.data('pk'),
                name: fieldName,
                value: value,
                INSURANCE_ID: element.data('insurance-id')
            },
            success: function(response) {
                if (response && response.success) {
                    toastr.success(successMessage);
                } else {
                    toastr.error(response.message || 'An error occurred');
                }
            },
            error: function() {
                toastr.error('An error occurred');
            }
        });
    }

    $('#bulk-upload-btn').on('click', function() {
        $('#bulk-upload-modal').modal('show');
    });

    $('#download-template-btn').click(function(e) {
        e.preventDefault();
        var button = $(this);
        var insuranceId = $('#insurance_id').val();

        if (!insuranceId) {
            toastr.error('Please select an insurance first');
            return;
        }

        $('.alert-danger-bulk-upload').hide();
        button.html('<span class="spinner-border spinner-border-sm mr-2" role="status" aria-hidden="true"></span>Loading...').attr('disabled', true);

        $.ajax({
            type: 'GET',
            url: '/operations/insurance/' + insuranceId + '/hospital/{{ session()->has('hospital_id') ? session('hospital_id') : 0 }}/pricelist/export',
            contentType: 'application/json; charset=utf-8'
        }).done(function(data) {
            var a = document.createElement('a');
            a.href = data.file;
            a.download = data.name;
            document.body.appendChild(a);
            a.click();
            a.remove();
        }).fail(function(jqXHR) {
            $('.alert-danger-bulk-upload').html(jqXHR.responseJSON && jqXHR.responseJSON.errorMessage ? jqXHR.responseJSON.errorMessage : 'Error downloading template').show();
        }).always(function() {
            button.html('<i class="fas fa-download"></i> Download Template').attr('disabled', false);
        });
    });

    $('#upload-bulk-btn').on('click', function() {
        var insuranceId = $('#insurance_id').val();
        var file = $('#bulk-file')[0].files[0];

        if (!file) {
            toastr.error('Please select a file to upload');
            return;
        }

        var formData = new FormData();
        formData.append('file', file);
        formData.append('insurance_id', insuranceId);

        $(this).prop('disabled', true).html('<i class="fas fa-spinner fa-spin"></i> Uploading...');

        $.ajax({
            url: '/operations/insurance/test-price/bulk-upload',
            type: 'POST',
            data: formData,
            contentType: false,
            processData: false,
            success: function(response) {
                if (response.success) {
                    initializePriceListTable(insuranceId);
                    $('#bulk-upload-modal').modal('hide');
                    toastr.success(response.message || 'Prices uploaded successfully');
                } else {
                    toastr.error(response.errorMessage || 'An error occurred during upload');
                }
            },
            error: function(xhr) {
                var errorMsg = 'An error occurred during upload';
                if (xhr.responseJSON && xhr.responseJSON.errorMessage) {
                    errorMsg = xhr.responseJSON.errorMessage;
                }
                toastr.error(errorMsg);
            },
            complete: function() {
                $('#upload-bulk-btn').prop('disabled', false).html('Upload');
            }
        });
    });

    $('#bulk-file').on('change', function() {
        var fileName = $(this).val().split('\\').pop();
        $(this).next('.custom-file-label').html(fileName || 'Choose file');
    });

    $('#show-export-modal').click(function() {
        var button = $(this);
        var insuranceId = $('#insurance_id').val();

        if (!insuranceId) {
            toastr.error('Please select an insurance first');
            return;
        }

        $('.alert-danger-price-list').hide();
        button.html('<span class="spinner-border spinner-border-sm mr-2" role="status" aria-hidden="true"></span>Loading...').attr('disabled', true);

        $.ajax({
            type: 'GET',
            url: '/operations/insurance/' + insuranceId + '/hospital/{{ session()->has('hospital_id') ? session('hospital_id') : 0 }}/pricelist/export',
            contentType: 'application/json; charset=utf-8'
        }).done(function(data) {
            var a = document.createElement('a');
            a.href = data.file;
            a.download = data.name;
            document.body.appendChild(a);
            a.click();
            a.remove();
        }).fail(function(jqXHR) {
            $('.alert-danger-price-list').html(jqXHR.responseJSON && jqXHR.responseJSON.errorMessage ? jqXHR.responseJSON.errorMessage : 'Error downloading file').show();
        }).always(function() {
            button.html('<i class="fas fa-file-export"></i> Download Price List').attr('disabled', false);
        });
    });

    $(document).on('click', '.block-provider-btn', function () {
        var button = $(this);
        var isBlocked = button.data('blocked') == 1;
        var targetValue = isBlocked ? 0 : 1;
        var message = isBlocked ? 'Are you sure you want to unblock this provider?' : 'Are you sure you want to block this provider?';

        if (!confirm(message)) {
            return;
        }

        button.prop('disabled', true);

        $.ajax({
            url: '/operations/insurance/status/save',
            type: 'POST',
            data: {
                ID: button.data('id'),
                IS_BLOCKED: targetValue
            },
            success: function (response) {
                if (response.success) {
                    toastr.success(response.message);
                    window.location.reload();
                } else {
                    toastr.error(response.message);
                }
            },
            error: function () {
                toastr.error('Provider status could not be updated');
            },
            complete: function () {
                button.prop('disabled', false);
            }
        });
    });
});
</script>
@endsection