@include('admin.layouts.header')
@include('admin.layouts.sidebar')
<style>
    /* Filter & Form Typography */
    .filter-form label {
        font-size: 0.8rem !important;
        font-weight: 500 !important;
        color: #575962 !important;
        margin-bottom: 0.3rem !important;
    }
    .filter-form .form-control {
        font-size: 0.8rem !important;
        height: 32px !important;
        padding: 0.3rem 0.6rem !important;
    }
    .filter-form .btn {
        font-size: 0.8rem !important;
        height: 32px !important;
        padding: 0.3rem 0.85rem !important;
    }

    /* Main Table Typography - Compact Metronic Standard */
    .table-jvs {
        font-size: 0.82rem !important;
    }
    .table-jvs thead th {
        font-size: 0.78rem !important;
        font-weight: 600 !important;
        text-transform: uppercase !important;
        letter-spacing: 0.03em !important;
        color: #575962 !important;
        padding: 0.6rem 0.75rem !important;
        background-color: #f7f8fa !important;
        border-bottom: 1px solid #ebedf2 !important;
        vertical-align: middle !important;
    }
    .table-jvs tbody tr.accordion-toggle td {
        font-size: 0.82rem !important;
        padding: 0.55rem 0.75rem !important;
        vertical-align: middle !important;
        color: #3f4047 !important;
    }
    .table-jvs .toggle-icon {
        font-size: 1.05rem !important;
        vertical-align: middle !important;
    }

    /* Collapsible Detail Drawer Typography */
    .jv-collapse-wrapper {
        background-color: #f8f9fa;
        padding: 16px 20px;
    }
    .jv-collapse-header {
        background-color: #f1f3f8 !important;
        padding: 8px 14px !important;
        border-bottom: 1px solid #ebedf2 !important;
    }
    .jv-collapse-header-title {
        font-size: 0.82rem !important;
        font-weight: 600 !important;
        color: #212529 !important;
    }
    .jv-month-filter, .jv-year-filter {
        font-size: 0.78rem !important;
        height: 28px !important;
        padding: 2px 8px !important;
    }
    .jv-steps-container {
        font-size: 0.8rem !important;
    }
    .jv-section-heading {
        font-size: 0.76rem !important;
        font-weight: 700 !important;
        text-transform: uppercase !important;
        letter-spacing: 0.05em !important;
        color: #5867dd !important;
    }
    .jv-voucher-badge {
        font-size: 0.74rem !important;
        padding: 3px 7px !important;
    }
    .jv-status-badge {
        font-size: 0.72rem !important;
        padding: 3px 8px !important;
    }
    .jv-steps-table {
        font-size: 0.78rem !important;
    }
    .jv-steps-table td, .jv-steps-table th {
        font-size: 0.78rem !important;
        padding: 0.35rem 0.6rem !important;
        vertical-align: middle !important;
    }
    .jv-steps-container .btn-sm {
        font-size: 0.74rem !important;
        padding: 0.22rem 0.55rem !important;
        line-height: 1.25 !important;
    }
    .pagination {
        font-size: 0.82rem !important;
    }
    .pagination .page-link {
        font-size: 0.82rem !important;
        padding: 0.35rem 0.65rem !important;
    }
</style>

<div class="m-grid__item m-grid__item--fluid m-wrapper">
    <div class="m-subheader ">
        <div class="d-flex align-items-center justify-content-between">
            <div class="mr-auto">
                <div class="d-flex align-items-center mb-1">
                    <h3 class="m-subheader__title m-subheader__title--separator mb-0 mr-3">
                        Odoo JVs
                    </h3>
                    @if(isset($userOdooRole) && $userOdooRole)
                        <span class="m-badge m-badge--brand m-badge--wide" style="font-size: 0.78rem; padding: 3px 9px;">
                            <i class="la la-user"></i> Role: {{ $userOdooRole === 'checker_l1' ? 'L1 Checker' : ($userOdooRole === 'checker_l2' ? 'L2 Checker' : ucfirst($userOdooRole)) }}
                        </span>
                    @else
                        <span class="m-badge m-badge--secondary m-badge--wide text-muted" style="font-size: 0.78rem; padding: 3px 9px;">
                            <i class="la la-eye"></i> View Only
                        </span>
                    @endif
                </div>
                <ul class="m-subheader__breadcrumbs m-nav m-nav--inline">
                    <li class="m-nav__item m-nav__item--home">
                        <a href="{{ url('admin/registry') }}" class="m-nav__link m-nav__link--icon">
                            <i class="m-nav__link-icon la la-home"></i>
                        </a>
                    </li>
                    <li class="m-nav__separator">-</li>
                    <li class="m-nav__item">
                        <span class="m-nav__link-text">Odoo JVs</span>
                    </li>
                </ul>
            </div>
            <div>
                <a href="{{ url('admin/odoo/execution') }}" class="btn btn-outline-primary btn-sm mr-2">
                    <i class="la la-check-square-o"></i> Maker-Checker Queue
                </a>
                <a href="{{ url('admin/odoo/dashboard') }}" class="btn btn-outline-info btn-sm">
                    <i class="la la-sliders"></i> JV Config
                </a>
            </div>
        </div>
    </div>
    <div class="m-content">
        @if(Session::has('success'))
            <div class="alert alert-success alert-dismissible fade show" role="alert">
                <button type="button" class="close" data-dismiss="alert" aria-label="Close"></button>
                {{ Session::get('success') }}
            </div>
        @endif
        @if(Session::has('error'))
            <div class="alert alert-danger alert-dismissible fade show" role="alert">
                <button type="button" class="close" data-dismiss="alert" aria-label="Close"></button>
                {{ Session::get('error') }}
            </div>
        @endif

        <div class="m-portlet m-portlet--mobile">
            <div class="m-portlet__head">
                <div class="m-portlet__head-caption">
                    <div class="m-portlet__head-title">
                        <h3 class="m-portlet__head-text">
                            Disbursed Applications
                        </h3>
                    </div>
                </div>
            </div>
            <div class="m-portlet__body">
                <!-- Filters -->
                <form method="GET" action="{{ url('/admin/odoo/jvs') }}" class="filter-form mb-4">
                    <div class="row align-items-end">
                        <div class="col-md-2 mb-2">
                            <label>Business Name</label>
                            <select class="form-control" name="system" id="filter-system">
                                @if(isset($systems) && count($systems) > 0)
                                    @foreach($systems as $sys)
                                        <option value="{{ $sys->slug }}" {{ ($systemSlug ?? 'da') == $sys->slug ? 'selected' : '' }}>{{ $sys->name }}</option>
                                    @endforeach
                                @else
                                    <option value="da" selected>DA</option>
                                @endif
                            </select>
                        </div>
                        <div class="col-md-3 mb-2">
                            <label>Partner <small class="text-muted">(Optional - for partner-specific config)</small></label>
                            <select class="form-control" name="partner_id" id="filter-partner">
                                <option value="">-- All Partners (System Default) --</option>
                                @if(isset($partners) && count($partners) > 0)
                                    @foreach($partners as $partner)
                                        @php
                                            $displayName = $partner->name;
                                            if (!empty($partner->sub_partner_id)) {
                                                $parentPartner = \DB::table('partner_data')->where('id', $partner->sub_partner_id)->first();
                                                if ($parentPartner) {
                                                    $displayName = $parentPartner->name . ' → ' . $partner->name;
                                                }
                                            }
                                        @endphp
                                        <option value="{{ $partner->id }}">{{ $displayName }}</option>
                                    @endforeach
                                @endif
                            </select>
                        </div>
                        <div class="col-md-2 mb-2">
                            <label>From Date</label>
                            <input type="date" class="form-control" name="from_date" value="{{ $fromDate ?? '' }}">
                        </div>
                        <div class="col-md-2 mb-2">
                            <label>To Date</label>
                            <input type="date" class="form-control" name="to_date" value="{{ $toDate ?? '' }}">
                        </div>
                        <div class="col-md-3 mb-2">
                            <button type="submit" class="btn btn-primary btn-sm px-3"><i class="la la-filter"></i> Filter</button>
                            <a href="{{ url('/admin/odoo/jvs') }}" class="btn btn-secondary btn-sm px-3"><i class="la la-refresh"></i> Reset</a>
                        </div>
                    </div>
                </form>

                <!-- Data Table -->
                <div class="table-responsive">
                    <table class="table table-bordered table-hover mb-0 table-jvs">
                        <thead>
                            <tr>
                                <th style="width: 40px;" class="text-center"></th>
                                <th style="width: 180px;">Loan No.</th>
                                <th>Member Name</th>
                                <th>Partner Name</th>
                            </tr>
                        </thead>
                        <tbody id="jvs-accordion">
                            @forelse($applications as $app)
                                <!-- Main Row -->
                                <tr class="accordion-toggle" style="cursor: pointer;" data-toggle="collapse" data-target="#collapse-{{ $app->id }}" aria-expanded="false">
                                    <td class="text-center align-middle">
                                        <i class="la la-plus-circle toggle-icon text-primary"></i>
                                    </td>
                                    <td class="align-middle font-weight-bold text-dark">{{ $app->loan_no ?? $app->id }}</td>
                                    <td class="align-middle">{{ $app->member_name ?? '—' }}</td>
                                    <td class="align-middle text-muted">{{ $app->partner->name ?? $app->partner_id ?? '—' }}</td>
                                </tr>

                                <!-- Collapsible Detail Row -->
                                <tr>
                                    <td colspan="4" class="p-0 border-0">
                                        <div id="collapse-{{ $app->id }}" class="collapse jv-collapse" data-app-id="{{ $app->id }}" data-parent="#jvs-accordion">
                                            <div class="jv-collapse-wrapper">
                                                <div class="card border shadow-sm mb-0">
                                                    <div class="card-header jv-collapse-header py-2 d-flex justify-content-between align-items-center">
                                                        <span class="jv-collapse-header-title">
                                                            <i class="la la-tasks mr-1 text-primary"></i> JV Steps Summary &mdash; Loan No: <strong>{{ $app->loan_no ?? $app->id }}</strong>
                                                        </span>
                                                        <div class="d-flex align-items-center">
                                                            <select class="form-control form-control-sm mr-2 jv-month-filter" style="width: 120px;">
                                                                <option value="">Select Month</option>
                                                                <option value="01">January</option>
                                                                <option value="02">February</option>
                                                                <option value="03">March</option>
                                                                <option value="04">April</option>
                                                                <option value="05">May</option>
                                                                <option value="06">June</option>
                                                                <option value="07">July</option>
                                                                <option value="08">August</option>
                                                                <option value="09">September</option>
                                                                <option value="10">October</option>
                                                                <option value="11">November</option>
                                                                <option value="12">December</option>
                                                            </select>
                                                            <select class="form-control form-control-sm jv-year-filter" style="width: 90px;">
                                                                <option value="">Select Year</option>
                                                                <option value="2024">2024</option>
                                                                <option value="2025">2025</option>
                                                                <option value="2026">2026</option>
                                                                <option value="2027">2027</option>
                                                                <option value="2028">2028</option>
                                                            </select>
                                                        </div>
                                                    </div>
                                                    <div class="card-body p-0 jv-steps-container" style="overflow-y: scroll;height: 310px;">
                                                        <div class="d-flex justify-content-center align-items-center" style="height: 100%; min-height: 200px;">
                                                            <div class="text-center py-4">
                                                                <div class="spinner-border text-primary" role="status">
                                                                    <span class="sr-only">Loading...</span>
                                                                </div>
                                                                <p class="mt-2 text-muted" style="font-size: 0.8rem;">Loading JV steps...</p>
                                                            </div>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="4" class="text-center py-4 text-muted" style="font-size: 0.85rem;">
                                        <i class="la la-inbox fa-3x d-block mb-2 text-muted"></i>
                                        No disbursed applications found.
                                    </td>
                                </tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>

                <div class="mt-3">
                    {{ $applications->appends(request()->query())->links() }}
                </div>
            </div>
        </div>

    </div>
</div>

@include("admin.layouts.footer")

<script>
    $(document).ready(function() {
        var isMaker = {{ (isset($isMaker) && $isMaker) ? 'true' : 'false' }};

        // Load partners dynamically when system filter changes
        $('#filter-system').on('change', function() {
            var systemSlug = $(this).val();
            loadPartnersForSystem(systemSlug);
            
            // Reload open drawer when system filter changes
            var openCollapse = $('#jvs-accordion .collapse.show');
            if (openCollapse.length) {
                openCollapse.data('loaded', false);
                loadJvSteps(openCollapse);
            }
        });

        function loadPartnersForSystem(systemSlug) {
            var partnerDropdown = $('#filter-partner');
            partnerDropdown.html('<option value="">-- Loading... --</option>').prop('disabled', true);

            $.ajax({
                url: '/admin/odoo/systems/' + systemSlug + '/partners',
                type: 'GET',
                success: function(response) {
                    if (response.status === 'success') {
                        var options = '<option value="">-- All Partners (System Default) --</option>';
                        response.data.forEach(function(partner) {
                            options += '<option value="' + partner.id + '">' + partner.display_name + '</option>';
                        });
                        partnerDropdown.html(options).prop('disabled', false);
                    } else {
                        partnerDropdown.html('<option value="">-- Error loading partners --</option>').prop('disabled', false);
                    }
                },
                error: function() {
                    partnerDropdown.html('<option value="">-- Error loading partners --</option>').prop('disabled', false);
                }
            });
        }

        // Enforce only one open row at a time by hiding all other open collapse drawers
        $('#jvs-accordion').on('click', '.accordion-toggle', function() {
            var targetId = $(this).data('target');
            $('#jvs-accordion .collapse').not(targetId).collapse('hide');
        });

        // Handle accordion icon state changes when rows expand/collapse and load steps via AJAX
        $('#jvs-accordion').on('show.bs.collapse', '.collapse', function() {
            // Reset all toggle icons in accordion to plus-circle
            $('#jvs-accordion .toggle-icon').removeClass('la-minus-circle text-danger').addClass('la-plus-circle text-primary');
            // Change current expanding row toggle icon to minus-circle
            var targetId = $(this).attr('id');
            $('tr[data-target="#' + targetId + '"]').find('.toggle-icon').removeClass('la-plus-circle text-primary').addClass('la-minus-circle text-danger');

            var collapseDiv = $(this);
            if (collapseDiv.data('loaded') === true) {
                return;
            }
            loadJvSteps(collapseDiv);
        }).on('hide.bs.collapse', '.collapse', function() {
            var targetId = $(this).attr('id');
            $('tr[data-target="#' + targetId + '"]').find('.toggle-icon').removeClass('la-minus-circle text-danger').addClass('la-plus-circle text-primary');
        });

        function loadJvSteps(collapseDiv) {
            var appId = collapseDiv.data('app-id');
            var container = collapseDiv.find('.jv-steps-container');
            var monthVal = collapseDiv.find('.jv-month-filter').val();
            var yearVal = collapseDiv.find('.jv-year-filter').val();

            if (collapseDiv.data('loading') === true) {
                return;
            }

            collapseDiv.data('loading', true);
            container.html(`
                <div class="d-flex justify-content-center align-items-center" style="height: 100%; min-height: 200px;">
                    <div class="text-center py-4">
                        <div class="spinner-border text-primary" role="status">
                            <span class="sr-only">Loading...</span>
                        </div>
                        <p class="mt-2 text-muted">Loading JV steps...</p>
                    </div>
                </div>
            `);

            var systemVal = $('#filter-system').val() || 'da';
            var partnerVal = $('#filter-partner').val() || ''; // Get selected partner

            $.ajax({
                url: '/admin/odoo/get_jv_steps',
                type: 'GET',
                data: {
                    application_id: appId,
                    month: monthVal,
                    year: yearVal,
                    system: systemVal,
                    partner_id: partnerVal // Pass partner ID
                },
                success: function(response) {
                    collapseDiv.data('loading', false);
                    if (response.status === 'success') {
                        collapseDiv.data('loaded', true);
                        renderJvSteps(container, response.data, appId);
                    } else {
                        container.html('<div class="p-3 text-danger">Failed to load JV steps.</div>');
                    }
                },
                error: function(xhr) {
                    collapseDiv.data('loading', false);
                    var errorMsg = 'Failed to load JV steps';
                    if (xhr.responseJSON && xhr.responseJSON.message) {
                        errorMsg = xhr.responseJSON.message;
                    }
                    container.html('<div class="p-3 text-danger">Error: ' + errorMsg + '</div>');
                }
            });
        }

        // Handle filter selection change inside the collapsible title bar
        $('#jvs-accordion').on('change', '.jv-month-filter, .jv-year-filter', function(e) {
            e.stopPropagation();
            var collapseDiv = $(this).closest('.collapse');
            collapseDiv.data('loaded', false);
            loadJvSteps(collapseDiv);
        });

        // Reload open drawer when partner filter changes
        $('#filter-partner').on('change', function() {
            var openCollapse = $('#jvs-accordion .collapse.show');
            if (openCollapse.length) {
                openCollapse.data('loaded', false);
                loadJvSteps(openCollapse);
            }
        });

        // Prevent collapse state toggle when clicking on select filters inside the card header
        $('#jvs-accordion').on('click', '.jv-month-filter, .jv-year-filter', function(e) {
            e.stopPropagation();
        });

        function renderJvSteps(container, data, appId) {
            let html = '';
            
            if (!data || data.length === 0) {
                container.html('<div class="p-3 text-muted">No JV steps found for this period.</div>');
                return;
            }

            var totalRenderedSteps = 0;
            
            data.forEach(function(section) {
                var visibleSteps = (section.steps || []).filter(function(step) {
                    return !step.is_zero && !(step.total_debit === 0 && step.total_credit === 0);
                });

                if (visibleSteps.length === 0) {
                    return;
                }

                totalRenderedSteps += visibleSteps.length;

                html += `
                    <div class="px-3 pt-3 pb-1">
                        <h6 class="jv-section-heading mb-2">
                            <i class="la la-folder-open mr-1"></i>${section.section}
                        </h6>
                    </div>
                `;
                
                visibleSteps.forEach(function(step) {
                    let actionHtml = '';
                    
                    if (step.is_completed) {
                        actionHtml = `
                            <span class="m-badge m-badge--success m-badge--wide mr-2 jv-status-badge">Completed</span>
                            <button class="btn btn-sm btn-success" disabled>
                                <i class="la la-check"></i> Completed
                            </button>
                        `;
                    } else if (step.is_initiated) {
                        actionHtml = `
                            <span class="m-badge m-badge--warning m-badge--wide mr-2 jv-status-badge">${step.execution_status || 'In Review'}</span>
                            <button class="btn btn-sm btn-warning" disabled>
                                <i class="la la-clock-o"></i> Initiated
                            </button>
                        `;
                    } else if (step.is_mismatch) {
                        actionHtml = `
                            <span class="text-danger font-weight-bold mr-3" style="font-size: 0.78rem;"><i class="la la-exclamation-triangle"></i> Amount mismatch</span>
                            <span class="m-badge m-badge--secondary m-badge--wide mr-2 jv-status-badge">Pending</span>
                            <button class="btn btn-sm btn-danger" disabled>
                                <i class="la la-ban"></i> Mismatch
                            </button>
                        `;
                    } else {
                        if (isMaker) {
                            actionHtml = `
                                <span class="m-badge m-badge--secondary m-badge--wide mr-2 jv-status-badge">Pending</span>
                                <button class="btn btn-sm btn-info btn-initiate-jv"
                                        data-id="${appId}"
                                        data-step="${step.id}"
                                        data-jvid="${step.id}">
                                    <i class="la la-play"></i> Initiate
                                </button>
                            `;
                        } else {
                            actionHtml = `
                                <span class="m-badge m-badge--secondary m-badge--wide mr-2 jv-status-badge">Pending</span>
                                <span class="badge badge-light text-muted border py-1 px-2" style="font-size: 0.72rem;" title="Only an assigned Odoo Maker can initiate JV entries">
                                    <i class="la la-lock"></i> Maker only
                                </span>
                            `;
                        }
                    }
                    
                    html += `
                        <div class="px-3 pb-3">
                            <div class="d-flex justify-content-between align-items-center mb-1">
                                <span class="badge badge-secondary jv-voucher-badge">${step.voucher_type}</span>
                                <div class="d-flex align-items-center">
                                    ${actionHtml}
                                </div>
                            </div>
                            
                            <table class="table table-sm table-bordered mb-0 jv-steps-table">
                                <tbody>
                    `;
                    
                    step.entries.forEach(function(entry) {
                        let typeColor = entry.type === 'Dr' ? '#1a6fc4' : '#c41a1a';
                        let debitFormatted = entry.debit > 0 ? entry.debit.toLocaleString('en-IN', { minimumFractionDigits: 2, maximumFractionDigits: 2 }) : '-';
                        let creditFormatted = entry.credit > 0 ? entry.credit.toLocaleString('en-IN', { minimumFractionDigits: 2, maximumFractionDigits: 2 }) : '-';
                        let summaryHtml = entry.summary ? `<i class="la la-info-circle text-info ml-1" data-toggle="tooltip" data-placement="top" title="${entry.summary}" style="cursor: pointer; font-size: 0.85rem;"></i>` : '';
                        
                        html += `
                                    <tr>
                                        <td class="text-center font-weight-bold" style="width: 36px; color: ${typeColor};">
                                             ${entry.type}
                                        </td>
                                        <td>${entry.account}${summaryHtml}</td>
                                        <td class="text-right font-weight-bold" style="width: 130px;">${debitFormatted}</td>
                                        <td class="text-right font-weight-bold" style="width: 130px;">${creditFormatted}</td>
                                    </tr>
                        `;
                    });
                    
                    html += `
                                </tbody>
                            </table>
                        </div>
                    `;
                });
            });
            
            if (totalRenderedSteps === 0) {
                container.html('<div class="p-3 text-muted">No JV steps found for this period.</div>');
                return;
            }

            container.html(html);
            container.find('[data-toggle="tooltip"]').tooltip();
        }

        // Handle Initiate button click to trigger JV API call with jv id
        // Uses event delegation so buttons added dynamically are also captured
        $('#jvs-accordion').on('click', '.btn-initiate-jv', function(e) {
            e.preventDefault();
            e.stopPropagation(); // prevent row collapse toggle when clicking initiate
            if (!isMaker) {
                alert('Unauthorized: Only an assigned Odoo Maker can initiate JV entries.');
                return;
            }
            var btn = $(this);
            var appId  = btn.data('id');
            var stepKey = btn.data('step');
            var jvId   = btn.data('jvid');
            var statusBadge = btn.closest('.d-flex').find('.jv-status-badge');
            
            var monthVal = btn.closest('.collapse').find('.jv-month-filter').val();
            var yearVal = btn.closest('.collapse').find('.jv-year-filter').val();

            btn.addClass('m-loader m-loader--right m-loader--light').attr('disabled', true);

            var systemVal = $('#filter-system').val() || 'da';
            var partnerVal = $('#filter-partner').val() || ''; // Get selected partner

            $.ajax({
                url: '/admin/odoo/create_jv',
                type: 'POST',
                data: {
                    _token: '{{ csrf_token() }}',
                    application_id: appId,
                    step_key: stepKey,
                    jv_id: jvId,
                    month: monthVal,
                    year: yearVal,
                    system: systemVal,
                    partner_id: partnerVal // Pass partner ID
                },
                success: function(response) {
                    alert(response.message || 'JV initiated successfully! The entry has landed on /admin/odoo/execution for Checker review.');
                    btn.removeClass('btn-info btn-danger m-loader m-loader--right m-loader--light')
                       .addClass('btn-warning')
                       .html('<i class="la la-clock-o"></i> Initiated')
                       .attr('disabled', true);
                    if (statusBadge.length) {
                        statusBadge.removeClass('m-badge--secondary m-badge--danger')
                                   .addClass('m-badge--warning')
                                   .text('L1 Review Pending');
                    }
                },
                error: function(xhr) {
                    var errorMsg = 'Failed to create JV';
                    if (xhr.responseJSON && xhr.responseJSON.message) {
                        errorMsg = xhr.responseJSON.message;
                    } else if (xhr.responseJSON && xhr.responseJSON.error) {
                        errorMsg = typeof xhr.responseJSON.error === 'string' ? xhr.responseJSON.error : JSON.stringify(xhr.responseJSON.error);
                    }
                    alert('Error: ' + errorMsg);
                    btn.removeClass('m-loader m-loader--right m-loader--light').attr('disabled', false);
                }
            });
        });
    });
</script>