@extends('layouts.app')
@section('title', __('advancedreports::lang.tax_compliance_report'))

@php
// Get currency settings from session
$currency_symbol = session('currency')['symbol'] ?? '$';
$currency_precision = session('business.currency_precision') ?? 2;
$currency_placement = session('business.currency_symbol_placement') ?? 'before';
@endphp

@section('content')
<!-- Content Header -->
<section class="content-header">
    <h1 class="tw-text-xl md:tw-text-3xl tw-font-bold tw-text-black">
        <i class="fas fa-receipt"></i> {{ __('advancedreports::lang.tax_compliance_report') }}
        <small class="text-muted">{{ __('advancedreports::lang.multi_tax_jurisdiction_support') }}</small>
    </h1>
</section>

<!-- Main content -->
<section class="content">
    <!-- Summary Cards -->
    <div class="row" id="tax-summary-cards">
        <div class="col-lg-3 col-xs-6">
            <div class="small-box bg-blue">
                <div class="inner">
                    <h3 id="total-tax-collected">
                        @if($currency_placement === 'before')
                            {{ $currency_symbol }}0
                        @else
                            0{{ $currency_symbol }}
                        @endif
                    </h3>
                    <p style="color: white !important;">{{ __('advancedreports::lang.total_tax_collected') }}</p>
                </div>
                <div class="icon">
                    <i class="fas fa-coins"></i>
                </div>
            </div>
        </div>
        <div class="col-lg-3 col-xs-6">
            <div class="small-box bg-yellow">
                <div class="inner">
                    <h3 id="tax-liability">
                        @if($currency_placement === 'before')
                            {{ $currency_symbol }}0
                        @else
                            0{{ $currency_symbol }}
                        @endif
                    </h3>
                    <p style="color: white !important;">{{ __('advancedreports::lang.net_tax_liability') }}</p>
                </div>
                <div class="icon">
                    <i class="fas fa-file-invoice-dollar"></i>
                </div>
            </div>
        </div>
        <div class="col-lg-3 col-xs-6">
            <div class="small-box bg-green">
                <div class="inner">
                    <h3 id="compliance-score">0%</h3>
                    <p style="color: white !important;">{{ __('advancedreports::lang.compliance_score') }}</p>
                </div>
                <div class="icon">
                    <i class="fas fa-check-circle"></i>
                </div>
            </div>
        </div>
        <div class="col-lg-3 col-xs-6">
            <div class="small-box bg-purple">
                <div class="inner">
                    <h3 id="potential-savings">
                        @if($currency_placement === 'before')
                            {{ $currency_symbol }}0
                        @else
                            0{{ $currency_symbol }}
                        @endif
                    </h3>
                    <p style="color: white !important;">{{ __('advancedreports::lang.potential_savings') }}</p>
                </div>
                <div class="icon">
                    <i class="fas fa-piggy-bank"></i>
                </div>
            </div>
        </div>
    </div>

    <!-- Charts Row -->
    <div class="row">
        <div class="col-md-8">
            <div class="box box-info">
                <div class="box-header with-border">
                    <h3 class="box-title">{{ __('advancedreports::lang.monthly_tax_liability_trend') }}</h3>
                    <div class="box-tools pull-right">
                        <button type="button" class="btn btn-box-tool" data-widget="collapse">
                            <i class="fa fa-minus"></i>
                        </button>
                    </div>
                </div>
                <div class="box-body">
                    <canvas id="tax-trend-chart" style="height: 300px;"></canvas>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="box box-primary">
                <div class="box-header with-border">
                    <h3 class="box-title">{{ __('advancedreports::lang.tax_by_jurisdiction') }}</h3>
                </div>
                <div class="box-body">
                    <canvas id="jurisdiction-chart" style="height: 250px;"></canvas>
                </div>
            </div>
        </div>
    </div>

    <!-- Audit Risk Assessment -->
    <div class="row">
        <div class="col-md-12">
            <div class="box box-warning">
                <div class="box-header with-border">
                    <h3 class="box-title">{{ __('advancedreports::lang.tax_audit_risk_assessment') }}</h3>
                </div>
                <div class="box-body">
                    <div class="row">
                        <div class="col-md-3">
                            <div class="info-box">
                                <span class="info-box-icon bg-yellow">
                                    <i class="fas fa-exclamation-triangle"></i>
                                </span>
                                <div class="info-box-content">
                                    <span class="info-box-text">@lang('advancedreports::lang.risk_level')</span>
                                    <span class="info-box-number" id="risk-level">@lang('advancedreports::lang.low_risk')</span>
                                    <div class="progress">
                                        <div class="progress-bar" id="risk-progress" style="width: 0%"></div>
                                    </div>
                                    <span class="progress-description" id="risk-percentage">0% @lang('advancedreports::lang.risk_score_label')</span>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-9">
                            <div id="risk-factors-list"></div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Tax Optimization Insights -->
    <div class="row">
        <div class="col-md-12">
            <div class="box box-success">
                <div class="box-header with-border">
                    <h3 class="box-title">{{ __('advancedreports::lang.tax_optimization_insights') }}</h3>
                </div>
                <div class="box-body">
                    <div id="optimization-insights" class="row"></div>
                </div>
            </div>
        </div>
    </div>

    <!-- Upcoming Filing Deadlines -->
    <div class="row">
        <div class="col-md-12">
            <div class="box box-info">
                <div class="box-header with-border">
                    <h3 class="box-title">{{ __('advancedreports::lang.upcoming_filing_deadlines') }}</h3>
                </div>
                <div class="box-body">
                    <div class="table-responsive">
                        <table class="table table-bordered" id="deadlines-table">
                            <thead>
                                <tr>
                                    <th>{{ __('advancedreports::lang.period') }}</th>
                                    <th>{{ __('advancedreports::lang.filing_deadline') }}</th>
                                    <th>{{ __('advancedreports::lang.days_remaining') }}</th>
                                    <th>{{ __('advancedreports::lang.status') }}</th>
                                    <th>{{ __('advancedreports::lang.action') }}</th>
                                </tr>
                            </thead>
                            <tbody id="deadlines-tbody"></tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Filters -->
    <div class="row">
        <div class="col-md-12">
            @component('components.filters', ['title' => __('advancedreports::lang.tax_compliance_filters')])
                <div class="col-md-3">
                    <div class="form-group">
                        {!! Form::label('tax_date_filter', __('report.date_range') . ':') !!}
                        {!! Form::text('tax_date_filter', null, ['placeholder' => __('lang_v1.select_a_date_range'), 'class' => 'form-control', 'readonly']) !!}
                    </div>
                </div>
                <div class="col-md-2">
                    <div class="form-group">
                        {!! Form::label('tax_jurisdiction', __('advancedreports::lang.jurisdiction') . ':') !!}
                        {!! Form::select('tax_jurisdiction', ['all' => __('lang_v1.all'), 'federal' => __('advancedreports::lang.federal'), 'state' => __('advancedreports::lang.state_local'), 'other' => __('advancedreports::lang.other')], null, ['class' => 'form-control select2', 'style' => 'width:100%']) !!}
                    </div>
                </div>
                <div class="col-md-2">
                    <div class="form-group">
                        {!! Form::label('tax_period', __('advancedreports::lang.filing_period') . ':') !!}
                        {!! Form::select('tax_period', $tax_periods, null, ['class' => 'form-control select2', 'style' => 'width:100%']) !!}
                    </div>
                </div>
                <div class="col-md-2">
                    <div class="form-group">
                        {!! Form::label('report_type', __('advancedreports::lang.report_type') . ':') !!}
                        {!! Form::select('report_type', ['liability' => __('advancedreports::lang.tax_liability'), 'filing' => __('advancedreports::lang.filing_assistance'), 'optimization' => __('advancedreports::lang.optimization')], 'liability', ['class' => 'form-control select2', 'style' => 'width:100%']) !!}
                    </div>
                </div>
                <div class="col-md-3">
                    <div class="form-group">
                        <label>&nbsp;</label><br>
                        <button type="button" class="btn btn-success" id="export-tax-compliance">
                            <i class="fas fa-download"></i> {{ __('advancedreports::lang.export_report') }}
                        </button>
                        <button type="button" class="btn btn-primary" id="refresh-data">
                            <i class="fas fa-sync"></i> {{ __('advancedreports::lang.refresh') }}
                        </button>
                    </div>
                </div>
            @endcomponent
        </div>
    </div>

    <!-- Tax Liability Details Table -->
    <div class="row">
        <div class="col-md-12">
            <div class="box box-primary">
                <div class="box-header with-border">
                    <h3 class="box-title">{{ __('advancedreports::lang.tax_liability_details') }}</h3>
                    <div class="box-tools pull-right">
                        <button type="button" class="btn btn-success btn-sm" id="export-liability">
                            <i class="fas fa-file-excel"></i> {{ __('advancedreports::lang.export_excel') }}
                        </button>
                    </div>
                </div>
                <div class="box-body">
                    <div class="table-responsive">
                        <table class="table table-bordered table-striped" id="tax_liability_table">
                            <thead>
                                <tr>
                                    <th>{{ __('advancedreports::lang.tax_name') }}</th>
                                    <th>{{ __('advancedreports::lang.tax_rate') }}</th>
                                    <th>{{ __('advancedreports::lang.output_tax') }}</th>
                                    <th>{{ __('advancedreports::lang.input_tax_credit') }}</th>
                                    <th>{{ __('advancedreports::lang.net_liability') }}</th>
                                    <th>{{ __('advancedreports::lang.sales_trans') }}</th>
                                    <th>{{ __('advancedreports::lang.purchase_trans') }}</th>
                                </tr>
                            </thead>
                            <tbody id="liability-tbody"></tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>
@endsection

@section('javascript')
<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.full.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){
    let taxTrendChart, jurisdictionChart;
    
    // Currency formatting function
    const currency_symbol = '{{ $currency_symbol }}';
    const currency_placement = '{{ $currency_placement }}';
    const currency_precision = {{ $currency_precision }};
    const riskScoreLabel = @json(__('advancedreports::lang.risk_score_label'));
    const riskAssessmentSummary = @json(__('advancedreports::lang.risk_assessment_summary'));
    const recommendationLabel = @json(__('advancedreports::lang.recommendation'));
    const riskMessageTemplate = @json(__('advancedreports::lang.tax_risk_assessment_message', ['risk_level' => '__risk_level__', 'risk_factors' => '__risk_factors__', 'total_factors' => '__total_factors__']));
    const recommendationHigh = @json(__('advancedreports::lang.tax_recommendation_high'));
    const recommendationMedium = @json(__('advancedreports::lang.tax_recommendation_medium'));
    const recommendationLow = @json(__('advancedreports::lang.tax_recommendation_low'));
    const highRiskLabel = @json(__('advancedreports::lang.high_risk'));
    const mediumRiskLabel = @json(__('advancedreports::lang.medium_risk'));
    const lowRiskLabel = @json(__('advancedreports::lang.low_risk'));
    const overdueLabel = @json(__('advancedreports::lang.overdue'));
    const urgentLabel = @json(__('advancedreports::lang.urgent'));
    const upcomingLabel = @json(__('advancedreports::lang.upcoming'));
    const generateReportLabel = @json(__('advancedreports::lang.generate_report'));

    function formatCurrency(amount) {
        const formattedAmount = parseFloat(amount).toLocaleString(undefined, {
            minimumFractionDigits: currency_precision,
            maximumFractionDigits: currency_precision
        });
        if (currency_placement === 'before') {
            return currency_symbol + formattedAmount;
        } else {
            return formattedAmount + currency_symbol;
        }
    }

    // Initialize date range picker
    $('#tax_date_filter').daterangepicker(
        dateRangeSettings,
        function(start, end) {
            $('#tax_date_filter').val(start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format));
            loadTaxData();
        }
    );

    $('#tax_date_filter').on('cancel.daterangepicker', function(ev, picker) {
        $('#tax_date_filter').val('');
        loadTaxData();
    });

    // Filter change handlers
    $(document).on('change', '#tax_jurisdiction, #tax_period, #report_type', function(){
        loadTaxData();
    });

    // Refresh button
    $('#refresh-data').click(function(){
        loadTaxData();
    });

    // Load tax compliance data
    function loadTaxData() {
        let start_date = '';
        let end_date = '';
        
        if ($('#tax_date_filter').val()) {
            start_date = $('input#tax_date_filter').data('daterangepicker').startDate.format('YYYY-MM-DD');
            end_date = $('input#tax_date_filter').data('daterangepicker').endDate.format('YYYY-MM-DD');
        }

        $.ajax({
            url: '{{ route("advancedreports.tax-compliance.summary") }}',
            method: 'GET',
            data: {
                start_date: start_date,
                end_date: end_date,
                jurisdiction: $('#tax_jurisdiction').val(),
                period: $('#tax_period').val()
            },
            success: function(data) {
                // Update summary cards
                $('#total-tax-collected').text(formatCurrency(data.total_tax_collected));
                $('#tax-liability').text(formatCurrency(data.tax_liability));
                $('#compliance-score').text(Number(data.compliance_score).toFixed(window.getAdvancedReportsCurrencyPrecision ? window.getAdvancedReportsCurrencyPrecision(1) : 1) + '%');
                $('#potential-savings').text(formatCurrency(data.potential_savings));

                // Update charts
                updateTaxTrendChart(data.monthly_tax_trend);
                updateJurisdictionChart(data.tax_by_jurisdiction);

                // Update risk assessment
                updateRiskAssessment(data.audit_risk);

                // Update optimization insights
                updateOptimizationInsights(data.optimization_insights);

                // Update filing deadlines
                updateFilingDeadlines(data.upcoming_deadlines);
            },
            error: function(xhr, status, error) {
                console.error('Error loading tax data:', error);
            }
        });

        // Load liability details
        loadLiabilityDetails();
    }

    // Load tax liability details
    function loadLiabilityDetails() {
        let start_date = '';
        let end_date = '';
        
        if ($('#tax_date_filter').val()) {
            start_date = $('input#tax_date_filter').data('daterangepicker').startDate.format('YYYY-MM-DD');
            end_date = $('input#tax_date_filter').data('daterangepicker').endDate.format('YYYY-MM-DD');
        }

        $.ajax({
            url: '{{ route("advancedreports.tax-compliance.liability-details") }}',
            method: 'GET',
            data: {
                start_date: start_date,
                end_date: end_date
            },
            success: function(data) {
                let tbody = $('#liability-tbody');
                tbody.empty();
                
                data.forEach(function(row) {
                    let tr = `
                        <tr>
                            <td>${row.tax_name}</td>
                            <td>${parseFloat(row.tax_rate).toFixed(window.getAdvancedReportsCurrencyPrecision ? window.getAdvancedReportsCurrencyPrecision(2) : 2)}%</td>
                            <td>${formatCurrency(row.output_tax)}</td>
                            <td>${formatCurrency(row.input_tax_credit)}</td>
                            <td class="${row.net_liability >= 0 ? 'text-red' : 'text-green'}">${formatCurrency(row.net_liability)}</td>
                            <td>${row.sales_transactions}</td>
                            <td>${row.purchase_transactions}</td>
                        </tr>
                    `;
                    tbody.append(tr);
                });
            }
        });
    }

    // Chart update functions
    function updateTaxTrendChart(data) {
        if (taxTrendChart) {
            taxTrendChart.destroy();
        }

        const ctx = document.getElementById('tax-trend-chart').getContext('2d');
        taxTrendChart = new Chart(ctx, {
            type: 'line',
            data: {
                labels: data.map(item => item.month),
                datasets: [{
                    label: @json(__('advancedreports::lang.tax_liability')),
                    data: data.map(item => item.tax_amount),
                    borderColor: '#3498db',
                    backgroundColor: 'rgba(52, 152, 219, 0.1)',
                    fill: true,
                    tension: 0.4
                }]
            },
            options: {
                responsive: true,
                maintainAspectRatio: false,
                scales: {
                    y: {
                        beginAtZero: true,
                        ticks: {
                            callback: function(value) {
                                return formatCurrency(value);
                            }
                        }
                    }
                }
            }
        });
    }

    function updateJurisdictionChart(data) {
        if (jurisdictionChart) {
            jurisdictionChart.destroy();
        }

        const ctx = document.getElementById('jurisdiction-chart').getContext('2d');
        jurisdictionChart = new Chart(ctx, {
            type: 'doughnut',
            data: {
                labels: data.map(item => item.jurisdiction),
                datasets: [{
                    data: data.map(item => item.tax_amount),
                    backgroundColor: ['#e74c3c', '#f39c12', '#27ae60', '#3498db', '#9b59b6']
                }]
            },
            options: {
                responsive: true,
                maintainAspectRatio: false,
                plugins: {
                    legend: {
                        position: 'bottom'
                    }
                }
            }
        });
    }

    function updateRiskAssessment(riskData) {
        const riskLevelRaw = (riskData.risk_level || '').toLowerCase();
        const riskLevelDisplay = riskLevelRaw === 'high'
            ? highRiskLabel
            : riskLevelRaw === 'medium'
                ? mediumRiskLabel
                : lowRiskLabel;

        $('#risk-level').text(riskLevelDisplay);
        $('#risk-percentage').text(riskData.risk_percentage.toFixed(window.getAdvancedReportsCurrencyPrecision ? window.getAdvancedReportsCurrencyPrecision(1) : 1) + '% ' + riskScoreLabel);
        
        let progressBar = $('#risk-progress');
        progressBar.css('width', riskData.risk_percentage + '%');
        
        if (riskLevelRaw === 'high') {
            progressBar.removeClass('progress-bar-success progress-bar-warning').addClass('progress-bar-danger');
        } else if (riskLevelRaw === 'medium') {
            progressBar.removeClass('progress-bar-success progress-bar-danger').addClass('progress-bar-warning');
        } else {
            progressBar.removeClass('progress-bar-warning progress-bar-danger').addClass('progress-bar-success');
        }

        // Update risk factors
        const riskMessage = riskMessageTemplate
            .replace('__risk_level__', riskLevelDisplay)
            .replace('__risk_factors__', riskData.risk_factors)
            .replace('__total_factors__', riskData.total_factors);

        const recommendationText = riskLevelRaw === 'high'
            ? recommendationHigh
            : riskLevelRaw === 'medium'
                ? recommendationMedium
                : recommendationLow;

        let factorsList = $('#risk-factors-list');
        factorsList.html(`
            <h4>${riskAssessmentSummary}</h4>
            <p>${riskMessage}</p>
            <div class="alert alert-info">
                <strong>${recommendationLabel}:</strong> ${recommendationText}
            </div>
        `);
    }

    function updateOptimizationInsights(insights) {
        let container = $('#optimization-insights');
        container.empty();
        
        insights.forEach(function(insight, index) {
            let card = `
                <div class="col-md-4">
                    <div class="info-box bg-aqua">
                        <span class="info-box-icon">
                            <i class="fas fa-lightbulb"></i>
                        </span>
                        <div class="info-box-content">
                            <span class="info-box-text">${insight.title}</span>
                            <span class="info-box-number">${insight.description}</span>
                            <div class="progress">
                                <div class="progress-bar" style="width: ${Math.random() * 100}%"></div>
                            </div>
                            <span class="progress-description">${insight.recommendation}</span>
                        </div>
                    </div>
                </div>
            `;
            container.append(card);
        });
    }

    function updateFilingDeadlines(deadlines) {
        let tbody = $('#deadlines-tbody');
        tbody.empty();
        
        deadlines.forEach(function(deadline) {
            let statusBadge = '';
            if (deadline.status === 'overdue') {
                statusBadge = '<span class="label label-danger">' + overdueLabel + '</span>';
            } else if (deadline.status === 'urgent') {
                statusBadge = '<span class="label label-warning">' + urgentLabel + '</span>';
            } else {
                statusBadge = '<span class="label label-info">' + upcomingLabel + '</span>';
            }
            
            let tr = `
                <tr>
                    <td>${deadline.period}</td>
                    <td>${deadline.deadline}</td>
                    <td>${deadline.days_remaining}</td>
                    <td>${statusBadge}</td>
                    <td>
                        <button class="btn btn-sm btn-primary" onclick="generateFilingReport('${deadline.period}')">
                            <i class="fas fa-file-alt"></i> ${generateReportLabel}
                        </button>
                    </td>
                </tr>
            `;
            tbody.append(tr);
        });
    }

    // Export functionality
    $('#export-tax-compliance').click(function(e) {
        e.preventDefault();

        var $btn = $(this);
        var originalText = $btn.html();
        $btn.html('<i class="fa fa-spinner fa-spin"></i> {{ __("advancedreports::lang.exporting") }}').prop('disabled', true);

        let params = {
            report_type: $('#report_type').val(),
            jurisdiction: $('#tax_jurisdiction').val(),
            period: $('#tax_period').val(),
            _token: '{{ csrf_token() }}'
        };

        if ($('#tax_date_filter').val()) {
            params.start_date = $('input#tax_date_filter').data('daterangepicker').startDate.format('YYYY-MM-DD');
            params.end_date = $('input#tax_date_filter').data('daterangepicker').endDate.format('YYYY-MM-DD');
        }

        $.ajax({
            url: '{{ route("advancedreports.tax-compliance.export") }}',
            type: 'POST',
            data: params,
            xhrFields: { responseType: 'blob' },
            success: function(data, status, xhr) {
                var blob = new Blob([data], {
                    type: xhr.getResponseHeader('Content-Type') || 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
                });
                var link = document.createElement('a');
                link.href = window.URL.createObjectURL(blob);
                var filename = 'tax-compliance-report.xlsx';
                var disposition = xhr.getResponseHeader('Content-Disposition');
                if (disposition && disposition.indexOf('attachment') !== -1) {
                    var filenameRegex = /filename[^;=\n]*=((['"]).*?\2|[^;\n]*)/;
                    var matches = filenameRegex.exec(disposition);
                    if (matches != null && matches[1]) {
                        filename = matches[1].replace(/['"]/g, '');
                    }
                }
                link.download = filename;
                document.body.appendChild(link);
                link.click();
                document.body.removeChild(link);
                window.URL.revokeObjectURL(link.href);
            },
            error: function(xhr, status, error) {
                alert('@lang("advancedreports::lang.export_failed_with_error") ' + error);
            },
            complete: function() {
                setTimeout(function() {
                    $btn.html(originalText).prop('disabled', false);
                }, 1000);
            }
        });
    });

    // Export liability details to Excel
    $('#export-liability').click(function() {
        let data = [];
        $('#tax_liability_table tbody tr').each(function() {
            let row = [];
            $(this).find('td').each(function() {
                row.push($(this).text().replace(new RegExp('[' + currency_symbol.replace(/[.*+?^${}()|[\]\\]/g, '\\$&') + ',]', 'g'), ''));
            });
            data.push(row);
        });

        let headers = [
            @json(__('advancedreports::lang.tax_name')),
            @json(__('advancedreports::lang.tax_rate')),
            @json(__('advancedreports::lang.output_tax')),
            @json(__('advancedreports::lang.input_tax_credit')),
            @json(__('advancedreports::lang.net_liability')),
            @json(__('advancedreports::lang.sales_trans')),
            @json(__('advancedreports::lang.purchase_trans'))
        ];
        data.unshift(headers);

        let ws = XLSX.utils.aoa_to_sheet(data);
        let wb = XLSX.utils.book_new();
        XLSX.utils.book_append_sheet(wb, ws, @json(__('advancedreports::lang.tax_liability')));
        XLSX.writeFile(wb, 'tax_liability_' + new Date().getTime() + '.xlsx');
    });

    // Generate filing report function
    window.generateFilingReport = function(period) {
        let params = {
            report_type: 'filing',
            period: period
        };

        const queryString = new URLSearchParams(params).toString();
        window.open('{{ route("advancedreports.tax-compliance.filing-assistance") }}?' + queryString, '_blank');
    };

    // Initial load
    loadTaxData();
});
</script>
@endsection