@extends('layouts.app')
@section('title', __('Stock Mismatch Checker'))

@section('content')

<!-- Content Header (Page header) -->
<section class="content-header">
    <h1>@lang('Stock Mismatch Checker')
        <small>@lang('Identify products with incorrect stock values')</small>
    </h1>
</section>

<!-- Main content -->
<section class="content">
    <div class="row">
        <div class="col-md-12">
            <div class="box box-primary">
                <div class="box-header with-border">
                    <h3 class="box-title">@lang('Filter Stock Mismatches')</h3>
                </div>
                <div class="box-body">
                    <div class="row">
                        <div class="col-md-4">
                            <div class="form-group">
                                {!! Form::label('location_id', __('business.business_location') . ':') !!}
                                {!! Form::select('location_id', $business_locations, null, ['class' => 'form-control select2', 'placeholder' => __('messages.all'), 'id' => 'location_filter']); !!}
                            </div>
                        </div>
                        <div class="col-md-4">
                            <div class="form-group">
                                {!! Form::label('mismatch_type', __('Mismatch Type') . ':') !!}
                                {!! Form::select('mismatch_type', ['all' => 'All Mismatches', 'positive' => 'Stock Higher Than Expected', 'negative' => 'Stock Lower Than Expected'], 'all', ['class' => 'form-control select2', 'id' => 'mismatch_type_filter']); !!}
                            </div>
                        </div>
                        <div class="col-md-4">
                            <br>
                            <button type="button" class="btn btn-primary" id="check_stock_btn">
                                <i class="fa fa-search"></i> @lang('Check Stock')
                            </button>
                            <button type="button" class="btn btn-success" id="export_csv_btn" style="display:none;">
                                <i class="fa fa-download"></i> @lang('Export to CSV')
                            </button>
                            <button type="button" class="btn btn-danger" id="fix_all_btn" style="display:none;">
                                <i class="fa fa-wrench"></i> @lang('Fix All Mismatches')
                            </button>
                            <button type="button" class="btn btn-warning" id="recalculate_values_btn">
                                <i class="fa fa-calculator"></i> @lang('Recalculate Stock Values')
                            </button>
                        </div>
                    </div>
                </div>
            </div>

            <div class="box box-primary" id="results_box" style="display:none;">
                <div class="box-header with-border">
                    <h3 class="box-title">
                        @lang('Stock Mismatch Results')
                        <span id="mismatch_count" class="badge bg-red"></span>
                    </h3>
                </div>
                <div class="box-body">
                    <div class="alert alert-warning">
                        <strong><i class="fa fa-exclamation-triangle"></i> Note:</strong>
                        Products listed below have a difference between their current stock in the database and the calculated stock from transaction history.
                        <ul>
                            <li><strong>Positive Difference:</strong> Current stock is higher than expected (possible duplicate entries)</li>
                            <li><strong>Negative Difference:</strong> Current stock is lower than expected (possible missing transactions)</li>
                        </ul>
                    </div>
                    <div class="alert alert-info">
                        <strong><i class="fa fa-info-circle"></i> About Stock Value:</strong>
                        When you fix stock quantities, the system updates the <strong>Current Stock (quantity)</strong> based on transaction history. 
                        The <strong>Stock Value</strong> is calculated from remaining purchase line quantities.
                        <br><br>
                        <strong>If stock values show ₹0 after fixing quantities:</strong> Click the <strong>"Recalculate Stock Values"</strong> button to redistribute purchase line quantities using FIFO (First In, First Out) method.
                    </div>

                    <div class="table-responsive">
                        <table class="table table-bordered table-striped" id="stock_mismatch_table">
                            <thead>
                                <tr>
                                    <th>@lang('Product ID')</th>
                                    <th>@lang('Product Name')</th>
                                    <th>@lang('Location')</th>
                                    <th>@lang('Current Stock (DB)')</th>
                                    <th>@lang('Calculated Stock')</th>
                                    <th>@lang('Difference')</th>
                                    <th>@lang('Status')</th>
                                    <th>@lang('Actions')</th>
                                </tr>
                            </thead>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>

@endsection

@section('javascript')
<script type="text/javascript">
    // Base URL for stock history
    var stockHistoryBase = @json(url('/products/stock-history'));
    
    $(document).ready(function() {
        var stock_mismatch_table;
        
        // Handle Stock History button click
        $(document).on('click', '.btn-view-stock-history', function(e) {
            e.preventDefault();
            var product_id = $(this).data('product-id');
            var location_id = $(this).data('location-id');
            var url = stockHistoryBase + '/' + product_id;
            if (location_id) {
                url += '?location_id=' + location_id;
            }
            window.open(url, '_blank');
        });

        // Check stock button click
        $('#check_stock_btn').click(function() {
            var location_id = $('#location_filter').val();
            var mismatch_type = $('#mismatch_type_filter').val();
            
            $('#check_stock_btn').prop('disabled', true).html('<i class="fa fa-spinner fa-spin"></i> Checking...');
            
            loadStockMismatches(location_id, mismatch_type);
        });

        function loadStockMismatches(location_id, mismatch_type) {
            if (stock_mismatch_table) {
                stock_mismatch_table.destroy();
            }

            stock_mismatch_table = $('#stock_mismatch_table').DataTable({
                processing: true,
                serverSide: true,
                ajax: {
                    url: '{{ action('StockMismatchController@getMismatches') }}',
                    data: function(d) {
                        d.location_id = location_id;
                    }
                },
                columns: [
                    { data: 'product_id', name: 'p.id' },
                    { data: 'full_product_name', name: 'full_product_name' },
                    { data: 'location_name', name: 'bl.name' },
                    { 
                        data: 'current_stock', 
                        name: 'current_stock',
                        render: function(data) {
                            return parseFloat(data).toFixed(2);
                        }
                    },
                    { 
                        data: 'calculated_stock', 
                        name: 'calculated_stock',
                        render: function(data) {
                            return parseFloat(data).toFixed(2);
                        }
                    },
                    { 
                        data: 'difference', 
                        name: 'difference',
                        render: function(data, type, row) {
                            var diff = parseFloat(data);
                            var color = diff > 0 ? 'red' : (diff < 0 ? 'orange' : 'green');
                            return '<span style="color:' + color + '; font-weight:bold;">' + diff.toFixed(2) + '</span>';
                        }
                    },
                    {
                        data: 'difference',
                        render: function(data) {
                            var diff = parseFloat(data);
                            if (diff > 0) {
                                return '<span class="label label-danger">Higher</span>';
                            } else if (diff < 0) {
                                return '<span class="label label-warning">Lower</span>';
                            } else {
                                return '<span class="label label-success">Match</span>';
                            }
                        },
                        orderable: false
                    },
                    {
                        data: 'variation_id',
                        render: function(data, type, row) {
                            var base = '{{ url('/products/stock-history') }}';
                            var html = '<button type="button" class="btn btn-xs btn-primary btn-view-stock-history" data-product-id="' + row.product_id + '" data-location-id="' + row.location_id + '"><i class="fa fa-history"></i> Stock History</button> ';
                            html += '<button class="btn btn-xs btn-warning fix-single-btn" data-variation-id="' + row.variation_id + '" data-location-id="' + row.location_id + '" data-product-name="' + row.full_product_name + '"><i class="fa fa-wrench"></i> Fix</button> ';
                            html += '<button class="btn btn-xs btn-success fix-recalculate-btn" data-variation-id="' + row.variation_id + '" data-location-id="' + row.location_id + '" data-product-name="' + row.full_product_name + '"><i class="fa fa-wrench"></i> <i class="fa fa-calculator"></i></button>';
                            return html;
                        },
                        orderable: false
                    }
                ],
                drawCallback: function(settings) {
                    var api = this.api();
                    var data = api.rows({page: 'current'}).data();
                    
                    // Filter based on mismatch type
                    var mismatch_type = $('#mismatch_type_filter').val();
                    var count = 0;
                    
                    api.rows().every(function() {
                        var rowData = this.data();
                        var diff = parseFloat(rowData.difference);
                        var show = true;
                        
                        if (diff == 0) {
                            show = false;
                        } else if (mismatch_type == 'positive' && diff <= 0) {
                            show = false;
                        } else if (mismatch_type == 'negative' && diff >= 0) {
                            show = false;
                        }
                        
                        if (show) {
                            count++;
                            $(this.node()).show();
                        } else {
                            $(this.node()).hide();
                        }
                    });
                    
                    $('#mismatch_count').text(count);
                    $('#results_box').show();
                    $('#export_csv_btn').show();
                    if (count > 0) {
                        $('#fix_all_btn').show();
                    }
                    $('#check_stock_btn').prop('disabled', false).html('<i class="fa fa-search"></i> Check Stock');
                },
                order: [[5, 'desc']]
            });
        }

        // Export CSV button
        $('#export_csv_btn').click(function() {
            var location_id = $('#location_filter').val();
            var url = '{{ action('StockMismatchController@exportCsv') }}';
            if (location_id) {
                url += '?location_id=' + location_id;
            }
            window.location.href = url;
        });

        // Mismatch type filter change
        $('#mismatch_type_filter').change(function() {
            if (stock_mismatch_table) {
                stock_mismatch_table.draw();
            }
        });

        // Fix single stock
        $(document).on('click', '.fix-single-btn', function() {
            var btn = $(this);
            var variation_id = btn.data('variation-id');
            var location_id = btn.data('location-id');
            var product_name = btn.data('product-name');
            
            if (!confirm('Are you sure you want to fix stock for:\n' + product_name + '?')) {
                return;
            }
            
            btn.prop('disabled', true).html('<i class="fa fa-spinner fa-spin"></i> Fixing...');
            
            $.ajax({
                url: '{{ action('StockMismatchController@fixStock') }}',
                method: 'POST',
                data: {
                    variation_id: variation_id,
                    location_id: location_id,
                    _token: '{{ csrf_token() }}'
                },
                success: function(response) {
                    if (response.success) {
                        toastr.success(response.msg);
                        stock_mismatch_table.ajax.reload();
                    } else {
                        toastr.error(response.msg);
                        btn.prop('disabled', false).html('<i class="fa fa-wrench"></i> Fix');
                    }
                },
                error: function() {
                    toastr.error('Failed to fix stock');
                    btn.prop('disabled', false).html('<i class="fa fa-wrench"></i> Fix');
                }
            });
        });

        // Fix all stocks
        $('#fix_all_btn').click(function() {
            var location_id = $('#location_filter').val();
            var location_name = $('#location_filter option:selected').text();
            
            var msg = 'Are you sure you want to fix ALL mismatched stocks';
            if (location_id) {
                msg += ' for location: ' + location_name;
            }
            msg += '?\n\nThis will update the stock values based on transaction history.';
            
            if (!confirm(msg)) {
                return;
            }
            
            $(this).prop('disabled', true).html('<i class="fa fa-spinner fa-spin"></i> Fixing All...');
            
            $.ajax({
                url: '{{ action('StockMismatchController@fixAllStocks') }}',
                method: 'POST',
                data: {
                    location_id: location_id,
                    _token: '{{ csrf_token() }}'
                },
                success: function(response) {
                    if (response.success) {
                        toastr.success(response.msg);
                        $('#fix_all_btn').prop('disabled', false).html('<i class="fa fa-wrench"></i> Fix All Mismatches');
                        stock_mismatch_table.ajax.reload();
                        setTimeout(function() {
                            $('#check_stock_btn').click();
                        }, 1000);
                    } else {
                        toastr.error(response.msg);
                        $('#fix_all_btn').prop('disabled', false).html('<i class="fa fa-wrench"></i> Fix All Mismatches');
                    }
                },
                error: function() {
                    toastr.error('Failed to fix stocks');
                    $('#fix_all_btn').prop('disabled', false).html('<i class="fa fa-wrench"></i> Fix All Mismatches');
                }
            });
        });

        // Fix & Recalculate single stock
        $(document).on('click', '.fix-recalculate-btn', function() {
            var btn = $(this);
            var variation_id = btn.data('variation-id');
            var location_id = btn.data('location-id');
            var product_name = btn.data('product-name');
            
            if (!confirm('Are you sure you want to fix stock AND recalculate values for:\n' + product_name + '?\n\nThis will:\n1. Fix the stock quantity based on transaction history\n2. Recalculate stock values using FIFO method')) {
                return;
            }
            
            btn.prop('disabled', true).html('<i class="fa fa-spinner fa-spin"></i> Processing...');
            
            // Step 1: Fix stock
            $.ajax({
                url: '{{ action('StockMismatchController@fixStock') }}',
                method: 'POST',
                data: {
                    variation_id: variation_id,
                    location_id: location_id,
                    _token: '{{ csrf_token() }}'
                },
                success: function(response) {
                    if (response.success) {
                        toastr.success('Stock fixed successfully. Now recalculating values...');
                        
                        // Step 2: Recalculate stock values for this location
                        $.ajax({
                            url: '{{ action('StockMismatchController@recalculatePurchaseLines') }}',
                            method: 'POST',
                            data: {
                                location_id: location_id,
                                _token: '{{ csrf_token() }}'
                            },
                            success: function(recalcResponse) {
                                if (recalcResponse.success) {
                                    toastr.success('Stock fixed and values recalculated successfully!');
                                    stock_mismatch_table.ajax.reload();
                                } else {
                                    toastr.warning('Stock fixed but recalculation failed: ' + recalcResponse.msg);
                                    btn.prop('disabled', false).html('<i class="fa fa-wrench"></i> <i class="fa fa-calculator"></i>');
                                }
                            },
                            error: function() {
                                toastr.warning('Stock fixed but recalculation failed');
                                btn.prop('disabled', false).html('<i class="fa fa-wrench"></i> <i class="fa fa-calculator"></i>');
                            }
                        });
                    } else {
                        toastr.error(response.msg);
                        btn.prop('disabled', false).html('<i class="fa fa-wrench"></i> <i class="fa fa-calculator"></i>');
                    }
                },
                error: function() {
                    toastr.error('Failed to fix stock');
                    btn.prop('disabled', false).html('<i class="fa fa-wrench"></i> <i class="fa fa-calculator"></i>');
                }
            });
        });

        // Recalculate stock values button
        $('#recalculate_values_btn').click(function() {
            var location_id = $('#location_filter').val();
            var location_name = $('#location_filter option:selected').text();
            
            var msg = 'This will recalculate stock values by redistributing purchase line quantities using FIFO method.\n\n';
            msg += 'This will:';
            msg += '\n• Reset quantity_sold, quantity_adjusted, quantity_returned in purchase_lines';
            msg += '\n• Redistribute based on current stock quantities';
            msg += '\n• Fix the "Stock Value by Purchase Price" issue';
            msg += '\n\n';
            
            if (location_id) {
                msg += 'Location: ' + location_name + '\n\n';
            } else {
                msg += 'All Locations\n\n';
            }
            
            msg += 'Are you sure you want to proceed?';
            
            if (!confirm(msg)) {
                return;
            }
            
            $(this).prop('disabled', true).html('<i class="fa fa-spinner fa-spin"></i> Recalculating...');
            
            $.ajax({
                url: '{{ action('StockMismatchController@recalculatePurchaseLines') }}',
                method: 'POST',
                data: {
                    location_id: location_id,
                    _token: '{{ csrf_token() }}'
                },
                success: function(response) {
                    if (response.success) {
                        toastr.success(response.msg);
                        $('#recalculate_values_btn').prop('disabled', false).html('<i class="fa fa-calculator"></i> Recalculate Stock Values');
                        alert('Stock values recalculated successfully!\n\nPlease check your stock reports to verify the values are now correct.');
                    } else {
                        toastr.error(response.msg);
                        $('#recalculate_values_btn').prop('disabled', false).html('<i class="fa fa-calculator"></i> Recalculate Stock Values');
                    }
                },
                error: function(xhr) {
                    var msg = 'Failed to recalculate stock values';
                    if (xhr.responseJSON && xhr.responseJSON.msg) {
                        msg += ': ' + xhr.responseJSON.msg;
                    }
                    toastr.error(msg);
                    $('#recalculate_values_btn').prop('disabled', false).html('<i class="fa fa-calculator"></i> Recalculate Stock Values');
                }
            });
        });
    });
</script>
@endsection