@extends('layouts.app')

@section('title', __('accounting-reports::lang.integrity_tools'))

@section('content')
<section class="content-header">
    <h1>@lang('accounting-reports::lang.integrity_tools')</h1>
</section>

<section class="content">
    <!-- Validation Tools -->
    <div class="row">
        <div class="col-md-12">
            <div class="box box-primary">
                <div class="box-header with-border">
                    <h3 class="box-title"><i class="fa fa-check-circle"></i> Validation Tools</h3>
                </div>
                <div class="box-body">
                    <div class="row">
                        <div class="col-md-6">
                            <div class="info-box bg-green">
                                <span class="info-box-icon"><i class="fa fa-balance-scale"></i></span>
                                <div class="info-box-content">
                                    <span class="info-box-text">Journal Entry Balance Check</span>
                                    <span class="info-box-number" id="je-balance-status">Not Run</span>
                                    <div class="progress">
                                        <div class="progress-bar" style="width: 0%"></div>
                                    </div>
                                    <button type="button" class="btn btn-sm btn-default" id="validate-je-balance">
                                        <i class="fa fa-play"></i> Run Check
                                    </button>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="info-box bg-blue">
                                <span class="info-box-icon"><i class="fa fa-file-o"></i></span>
                                <div class="info-box-content">
                                    <span class="info-box-text">Opening Balance Check</span>
                                    <span class="info-box-number" id="opening-balance-status">Not Run</span>
                                    <div class="progress">
                                        <div class="progress-bar" style="width: 0%"></div>
                                    </div>
                                    <button type="button" class="btn btn-sm btn-default" id="validate-opening-balance">
                                        <i class="fa fa-play"></i> Run Check
                                    </button>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="row" style="margin-top: 10px;">
                        <div class="col-md-6">
                            <div class="info-box bg-yellow">
                                <span class="info-box-icon"><i class="fa fa-exchange"></i></span>
                                <div class="info-box-content">
                                    <span class="info-box-text">AR/AP Control Reconcile</span>
                                    <span class="info-box-number" id="ar-ap-status">Not Run</span>
                                    <div class="progress">
                                        <div class="progress-bar" style="width: 0%"></div>
                                    </div>
                                    <button type="button" class="btn btn-sm btn-default" id="validate-ar-ap">
                                        <i class="fa fa-play"></i> Run Check
                                    </button>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="info-box bg-red">
                                <span class="info-box-icon"><i class="fa fa-calculator"></i></span>
                                <div class="info-box-content">
                                    <span class="info-box-text">COGS Reconcile</span>
                                    <span class="info-box-number" id="cogs-status">Not Run</span>
                                    <div class="progress">
                                        <div class="progress-bar" style="width: 0%"></div>
                                    </div>
                                    <button type="button" class="btn btn-sm btn-default" id="validate-cogs">
                                        <i class="fa fa-play"></i> Run Check
                                    </button>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="row" style="margin-top: 10px;">
                        <div class="col-md-12">
                            <button type="button" class="btn btn-primary btn-lg" id="run-all-validation">
                                <i class="fa fa-check-double"></i> Run All Validations
                            </button>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Rebuild Tools -->
    <div class="row">
        <div class="col-md-12">
            <div class="box box-success">
                <div class="box-header with-border">
                    <h3 class="box-title"><i class="fa fa-refresh"></i> Rebuild Tools</h3>
                </div>
                <div class="box-body">
                    <div class="row">
                        <div class="col-md-4">
                            <div class="info-box bg-aqua">
                                <span class="info-box-icon"><i class="fa fa-book"></i></span>
                                <div class="info-box-content">
                                    <span class="info-box-text">Rebuild Ledgers</span>
                                    <span class="info-box-number" id="rebuild-ledgers-status">Ready</span>
                                    <div class="progress">
                                        <div class="progress-bar" style="width: 0%"></div>
                                    </div>
                                    <button type="button" class="btn btn-sm btn-default" id="rebuild-ledgers">
                                        <i class="fa fa-play"></i> Rebuild
                                    </button>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-4">
                            <div class="info-box bg-purple">
                                <span class="info-box-icon"><i class="fa fa-cubes"></i></span>
                                <div class="info-box-content">
                                    <span class="info-box-text">Rebuild FIFO Layers</span>
                                    <span class="info-box-number" id="rebuild-fifo-status">Ready</span>
                                    <div class="progress">
                                        <div class="progress-bar" style="width: 0%"></div>
                                    </div>
                                    <button type="button" class="btn btn-sm btn-default" id="rebuild-fifo">
                                        <i class="fa fa-play"></i> Rebuild
                                    </button>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-4">
                            <div class="info-box bg-maroon">
                                <span class="info-box-icon"><i class="fa fa-database"></i></span>
                                <div class="info-box-content">
                                    <span class="info-box-text">Rebuild Rollups</span>
                                    <span class="info-box-number" id="rebuild-rollups-status">Ready</span>
                                    <div class="progress">
                                        <div class="progress-bar" style="width: 0%"></div>
                                    </div>
                                    <button type="button" class="btn btn-sm btn-default" id="rebuild-rollups">
                                        <i class="fa fa-play"></i> Rebuild
                                    </button>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="row" style="margin-top: 10px;">
                        <div class="col-md-12">
                            <div class="alert alert-warning">
                                <i class="fa fa-exclamation-triangle"></i> 
                                <strong>Warning:</strong> Rebuild operations may take several minutes and will regenerate data from transactions. 
                                Ensure you have a backup before running rebuild operations.
                            </div>
                            <button type="button" class="btn btn-success btn-lg" id="rebuild-all">
                                <i class="fa fa-refresh"></i> Rebuild All
                            </button>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Results Panel -->
    <div class="row" id="results-panel" style="display:none;">
        <div class="col-md-12">
            <div class="box box-info">
                <div class="box-header with-border">
                    <h3 class="box-title"><i class="fa fa-list"></i> Results</h3>
                </div>
                <div class="box-body">
                    <div id="results-content"></div>
                </div>
            </div>
        </div>
    </div>

    <!-- Loading Overlay -->
    <div id="loading-overlay" style="display:none; position:fixed; top:0; left:0; width:100%; height:100%; background:rgba(0,0,0,0.5); z-index:9999;">
        <div style="position:absolute; top:50%; left:50%; transform:translate(-50%, -50%); text-align:center; color:#fff;">
            <i class="fa fa-spinner fa-spin fa-3x"></i>
            <p style="margin-top:20px; font-size:18px;" id="loading-message">Processing...</p>
        </div>
    </div>
</section>
@endsection

@section('javascript')
<script>
$(document).ready(function() {
    // Validation buttons
    $('#validate-je-balance').click(function() {
        runValidation('je_balance', '#je-balance-status');
    });
    
    $('#validate-opening-balance').click(function() {
        runValidation('opening_balance', '#opening-balance-status');
    });
    
    $('#validate-ar-ap').click(function() {
        runValidation('ar_ap', '#ar-ap-status');
    });
    
    $('#validate-cogs').click(function() {
        runValidation('cogs', '#cogs-status');
    });
    
    $('#run-all-validation').click(function() {
        runValidation('all', null);
    });
    
    // Rebuild buttons
    $('#rebuild-ledgers').click(function() {
        runRebuild('ledgers', '#rebuild-ledgers-status');
    });
    
    $('#rebuild-fifo').click(function() {
        runRebuild('fifo', '#rebuild-fifo-status');
    });
    
    $('#rebuild-rollups').click(function() {
        runRebuild('rollups', '#rebuild-rollups-status');
    });
    
    $('#rebuild-all').click(function() {
        if (!confirm('Are you sure you want to rebuild all data? This may take several minutes.')) {
            return;
        }
        runRebuild('all', null);
    });
    
    function runValidation(type, statusElement) {
        showLoading('Running validation...');
        
        $.ajax({
            url: "{{ route('accounting-reports.integrity.validate') }}",
            method: 'POST',
            data: {
                type: type,
                _token: '{{ csrf_token() }}'
            },
            success: function(response) {
                hideLoading();
                
                if (response.success) {
                    displayValidationResults(response.results, statusElement);
                    toastr.success('Validation completed successfully');
                } else {
                    toastr.error(response.error || 'Validation failed');
                }
            },
            error: function(xhr) {
                hideLoading();
                var errorMsg = 'Error running validation';
                if (xhr.responseJSON && xhr.responseJSON.error) {
                    errorMsg = xhr.responseJSON.error;
                }
                toastr.error(errorMsg);
            }
        });
    }
    
    function runRebuild(type, statusElement) {
        if (type === 'all' && !confirm('Are you sure you want to rebuild all data? This may take several minutes.')) {
            return;
        }
        
        showLoading('Rebuilding data... This may take several minutes.');
        
        $.ajax({
            url: "{{ route('accounting-reports.integrity.rebuild') }}",
            method: 'POST',
            data: {
                type: type,
                _token: '{{ csrf_token() }}'
            },
            success: function(response) {
                hideLoading();
                
                if (response.success) {
                    displayRebuildResults(response.results, statusElement);
                    toastr.success('Rebuild completed successfully');
                } else {
                    toastr.error(response.error || 'Rebuild failed');
                }
            },
            error: function(xhr) {
                hideLoading();
                var errorMsg = 'Error running rebuild';
                if (xhr.responseJSON && xhr.responseJSON.error) {
                    errorMsg = xhr.responseJSON.error;
                }
                toastr.error(errorMsg);
            }
        });
    }
    
    function displayValidationResults(results, statusElement) {
        var html = '<div class="table-responsive"><table class="table table-bordered">';
        html += '<thead><tr><th>Check</th><th>Status</th><th>Details</th></tr></thead><tbody>';
        
        $.each(results, function(key, result) {
            var statusClass = result.status === 'passed' ? 'success' : (result.status === 'failed' ? 'danger' : 'warning');
            var statusText = result.status === 'passed' ? '✓ Passed' : (result.status === 'failed' ? '✗ Failed' : '⚠ Warning');
            
            html += '<tr>';
            html += '<td><strong>' + getCheckName(key) + '</strong></td>';
            html += '<td><span class="label label-' + statusClass + '">' + statusText + '</span></td>';
            html += '<td>' + formatValidationDetails(key, result) + '</td>';
            html += '</tr>';
            
            // Update status element if provided
            if (statusElement) {
                $(statusElement).text(statusText).parent().find('.progress-bar').css('width', result.status === 'passed' ? '100%' : '50%');
            }
        });
        
        html += '</tbody></table></div>';
        
        $('#results-content').html(html);
        $('#results-panel').show();
    }
    
    function displayRebuildResults(results, statusElement) {
        var html = '<div class="table-responsive"><table class="table table-bordered">';
        html += '<thead><tr><th>Operation</th><th>Status</th><th>Details</th></tr></thead><tbody>';
        
        $.each(results, function(key, result) {
            var statusClass = result.status === 'success' ? 'success' : 'danger';
            var statusText = result.status === 'success' ? '✓ Success' : '✗ Error';
            
            html += '<tr>';
            html += '<td><strong>' + getRebuildName(key) + '</strong></td>';
            html += '<td><span class="label label-' + statusClass + '">' + statusText + '</span></td>';
            html += '<td>' + formatRebuildDetails(key, result) + '</td>';
            html += '</tr>';
            
            // Update status element if provided
            if (statusElement) {
                $(statusElement).text(statusText).parent().find('.progress-bar').css('width', result.status === 'success' ? '100%' : '0%');
            }
        });
        
        html += '</tbody></table></div>';
        
        $('#results-content').html(html);
        $('#results-panel').show();
    }
    
    function getCheckName(key) {
        var names = {
            'je_balance': 'Journal Entry Balance Check',
            'opening_balance': 'Opening Balance Check',
            'ar_ap': 'AR/AP Control Reconcile',
            'cogs': 'COGS Reconcile'
        };
        return names[key] || key;
    }
    
    function getRebuildName(key) {
        var names = {
            'ledgers': 'Rebuild Ledgers',
            'fifo': 'Rebuild FIFO Layers',
            'rollups': 'Rebuild Rollups'
        };
        return names[key] || key;
    }
    
    function formatValidationDetails(key, result) {
        var details = [];
        
        if (key === 'je_balance') {
            details.push('Total Checked: ' + (result.total_checked || 0));
            details.push('Unbalanced: ' + (result.unbalanced_count || 0));
            if (result.unbalanced_entries && result.unbalanced_entries.length > 0) {
                details.push('<br><strong>Unbalanced Entries:</strong><ul>');
                $.each(result.unbalanced_entries.slice(0, 5), function(i, entry) {
                    details.push('<li>' + entry.voucher_no + ' - Diff: ' + formatCurrency(entry.balance_diff) + '</li>');
                });
                if (result.unbalanced_entries.length > 5) {
                    details.push('<li>... and ' + (result.unbalanced_entries.length - 5) + ' more</li>');
                }
                details.push('</ul>');
            }
        } else if (key === 'opening_balance') {
            details.push('Orphan Count: ' + (result.orphan_count || 0));
            details.push('Accounts with only opening: ' + (result.accounts_with_only_opening || 0));
        } else if (key === 'ar_ap') {
            details.push('AR Control: ' + formatCurrency(result.ar_control_balance || 0));
            details.push('AR Actual: ' + formatCurrency(result.ar_actual_due || 0));
            details.push('AR Diff: ' + formatCurrency(result.ar_difference || 0));
            details.push('<br>AP Control: ' + formatCurrency(result.ap_control_balance || 0));
            details.push('AP Actual: ' + formatCurrency(result.ap_actual_due || 0));
            details.push('AP Diff: ' + formatCurrency(result.ap_difference || 0));
        } else if (key === 'cogs') {
            details.push(result.message || 'Check completed');
        }
        
        return details.join('<br>');
    }
    
    function formatRebuildDetails(key, result) {
        var details = [];
        
        if (key === 'ledgers') {
            if (result.message) {
                details.push('<strong>' + result.message + '</strong>');
            }
            details.push('Posted: ' + (result.posted || 0));
            details.push('Failed: ' + (result.failed || 0));
            if (result.errors && result.errors.length > 0) {
                details.push('<br><strong>Errors:</strong><ul>');
                $.each(result.errors.slice(0, 5), function(i, error) {
                    var errorMsg = error.error || error.message || 'Unknown error';
                    details.push('<li>' + errorMsg + '</li>');
                });
                if (result.errors.length > 5) {
                    details.push('<li>... and ' + (result.errors.length - 5) + ' more</li>');
                }
                details.push('</ul>');
            }
        } else if (key === 'fifo') {
            details.push('Layers Created: ' + (result.layers_created || 0));
            if (result.message) {
                details.push(result.message);
            }
        } else if (key === 'rollups') {
            details.push('Rollups Created: ' + (result.rollups_created || 0));
            if (result.message) {
                details.push(result.message);
            }
        }
        
        return details.join('<br>');
    }
    
    function formatCurrency(amount) {
        if (typeof amount === 'undefined' || amount === null) {
            return '0.00';
        }
        var num = parseFloat(amount);
        if (isNaN(num)) {
            return '0.00';
        }
        return num.toLocaleString('en-IN', {
            minimumFractionDigits: 2,
            maximumFractionDigits: 2
        });
    }
    
    function showLoading(message) {
        $('#loading-message').text(message || 'Processing...');
        $('#loading-overlay').show();
    }
    
    function hideLoading() {
        $('#loading-overlay').hide();
    }
});
</script>
@endsection