@extends('layouts.app')
@section('title', __('report.profit_loss_statement'))

@section('content')

<!-- Content Header (Page header) -->
<section class="content-header">
    <h1>@lang('report.profit_loss_statement')
        <small>{{ $business_details->name ?? session('business.name') }} - @lang('messages.for_the_period') {{ $start_date }} @lang('messages.to') {{ $end_date }}</small>
    </h1>
</section>

<!-- Main content -->
<section class="content">
    <div class="print_section" style="border: 2px solid #333; padding: 20px; margin-bottom: 20px; text-align: center; background-color: #f9f9f9;">
        <h2 style="margin: 5px 0; margin-bottom: 10px;"><strong>{{ session()->get('business.name') }}</strong></h2>
        <h3 style="margin: 5px 0; margin-bottom: 10px;"><strong>@lang('report.profit_loss_statement')</strong></h3>
        <p style="margin: 0;"><strong>@lang('messages.for_the_period') {{ $start_date }} @lang('messages.to') {{ $end_date }}</strong></p>
    </div>
    
    <!-- Filters Section -->
    <div class="row no-print">
        <div class="col-md-12 text-right">
            <div class="form-group">
                <button type="button" class="btn btn-primary" id="pl_statement_date_filter">
                    <i class="fa fa-calendar"></i> {{ __('messages.filter_by_date') }}
                    <i class="fa fa-caret-down"></i>
                </button>
            </div>
        </div>
    </div>

    <!-- P&L Statement Table -->
    <div class="row">
        <div class="col-md-12">
            @component('components.widget', ['class' => 'box-primary'])
            <table class="table table-bordered" style="width: 100%;">
                <thead>
                    <tr style="background-color: #f5f5f5;">
                        <th style="width: 60%; font-weight: bold;">@lang('report.particulars')</th>
                        <th style="width: 20%; text-align: right; font-weight: bold;">@lang('report.amount')</th>
                        <th style="width: 20%; text-align: right; font-weight: bold;">@lang('report.total')</th>
                    </tr>
                </thead>
                <tbody>
                    <!-- SALES SECTION -->
                    <tr style="background-color: #ecf0f1; font-weight: bold;">
                        <td colspan="3">@lang('report.sales')</td>
                    </tr>
                    <tr>
                        <td style="padding-left: 30px;">@lang('report.sales')</td>
                        <td style="text-align: right;"><span class="display_currency" data-currency_symbol="true">{{ $data['sales'] }}</span></td>
                        <td style="text-align: right;"></td>
                    </tr>
                    <tr>
                        <td style="padding-left: 30px;">@lang('report.sales_returns')</td>
                        <td style="text-align: right;"><span class="display_currency" data-currency_symbol="true">{{ $data['sales_returns'] }}</span></td>
                        <td style="text-align: right;"></td>
                    </tr>
                    <tr style="background-color: #f9f9f9; font-weight: bold;">
                        <td style="padding-left: 30px;">@lang('report.net_sales')</td>
                        <td style="text-align: right;"></td>
                        <td style="text-align: right;"><span class="display_currency" data-currency_symbol="true">{{ $data['net_sales'] }}</span></td>
                    </tr>

                    <!-- COST OF GOODS SOLD SECTION -->
                    <tr style="background-color: #ecf0f1; font-weight: bold;">
                        <td colspan="3">@lang('report.cost_of_goods_sold')</td>
                    </tr>
                    <tr>
                        <td style="padding-left: 30px;">@lang('report.opening_inventory')</td>
                        <td style="text-align: right;"><span class="display_currency" data-currency_symbol="true">{{ $data['opening_inventory'] }}</span></td>
                        <td style="text-align: right;"></td>
                    </tr>
                    <tr>
                        <td style="padding-left: 30px;">@lang('report.purchases')</td>
                        <td style="text-align: right;"><span class="display_currency" data-currency_symbol="true">{{ $data['purchases'] }}</span></td>
                        <td style="text-align: right;"></td>
                    </tr>
                    <tr>
                        <td style="padding-left: 30px;">@lang('report.less_purchase_returns')</td>
                        <td style="text-align: right;">(<span class="display_currency" data-currency_symbol="true">{{ $data['purchase_returns'] }}</span>)</td>
                        <td style="text-align: right;"></td>
                    </tr>
                    <tr>
                        <td style="padding-left: 30px;">@lang('report.less_purchase_discounts')</td>
                        <td style="text-align: right;">(<span class="display_currency" data-currency_symbol="true">{{ $data['purchase_discounts'] }}</span>)</td>
                        <td style="text-align: right;"></td>
                    </tr>
                    <tr style="background-color: #f9f9f9;">
                        <td style="padding-left: 30px;">@lang('report.goods_available_for_sale')</td>
                        <td style="text-align: right;"></td>
                        <td style="text-align: right;"><span class="display_currency" data-currency_symbol="true">{{ $data['goods_available'] }}</span></td>
                    </tr>
                    <tr>
                        <td style="padding-left: 30px;">@lang('report.less_closing_inventory')</td>
                        <td style="text-align: right;">(<span class="display_currency" data-currency_symbol="true">{{ $data['closing_inventory'] }}</span>)</td>
                        <td style="text-align: right;"></td>
                    </tr>
                    <tr style="background-color: #d4edda; font-weight: bold; border: 2px solid #28a745;">
                        <td style="padding-left: 30px;">@lang('report.cost_of_goods_sold')</td>
                        <td style="text-align: right;"></td>
                        <td style="text-align: right;"><span class="display_currency" data-currency_symbol="true">{{ $data['cogs'] }}</span></td>
                    </tr>

                    <!-- GROSS PROFIT SECTION -->
                    <tr style="background-color: #c3e6cb; font-weight: bold; border: 2px solid #28a745;">
                        <td style="padding-left: 30px;">@lang('report.gross_profit')</td>
                        <td style="text-align: right;"></td>
                        <td style="text-align: right;"><span class="display_currency" data-currency_symbol="true">{{ $data['gross_profit'] }}</span></td>
                    </tr>

                    <!-- OPERATING EXPENSES SECTION -->
                    <tr style="background-color: #ecf0f1; font-weight: bold;">
                        <td colspan="3">@lang('report.operating_expenses')</td>
                    </tr>
                    @if(!empty($data['expense_details']) && count($data['expense_details']) > 0)
                        @foreach($data['expense_details'] as $expense)
                        <tr>
                            <td style="padding-left: 30px;">{{ $expense['name'] }}</td>
                            <td style="text-align: right;"><span class="display_currency" data-currency_symbol="true">{{ $expense['amount'] }}</span></td>
                            <td style="text-align: right;"></td>
                        </tr>
                        @endforeach
                    @endif
                    <tr style="background-color: #f9f9f9; font-weight: bold;">
                        <td style="padding-left: 30px;">@lang('report.total_operating_expenses')</td>
                        <td style="text-align: right;"></td>
                        <td style="text-align: right;"><span class="display_currency" data-currency_symbol="true">{{ $data['total_operating_expenses'] }}</span></td>
                    </tr>

                    <!-- OPERATING INCOME SECTION -->
                    <tr style="background-color: #fff3cd; font-weight: bold; border: 2px solid #ffc107;">
                        <td style="padding-left: 30px;">@lang('report.operating_income')</td>
                        <td style="text-align: right;"></td>
                        <td style="text-align: right;"><span class="display_currency" data-currency_symbol="true">{{ $data['operating_income'] }}</span></td>
                    </tr>

                    <!-- NON-OPERATING INCOME SECTION -->
                    <tr style="background-color: #ecf0f1; font-weight: bold;">
                        <td colspan="3">
                            @lang('report.non_operating_income')
                            <a href="{{ route('finance.non-operating-entries.index') }}" class="btn btn-xs btn-info no-print" style="margin-left: 10px;" target="_blank" title="@lang('messages.manage_non_operating_income_entries')">
                                <i class="fa fa-cog"></i> @lang('messages.manage')
                            </a>
                        </td>
                    </tr>
                    <tr>
                        <td style="padding-left: 30px;">@lang('report.interest_income')</td>
                        <td style="text-align: right;"></td>
                        <td style="text-align: right;"><span class="display_currency" data-currency_symbol="true">{{ $data['non_operating_income'] }}</span></td>
                    </tr>
                    <tr>
                        <td style="padding-left: 30px;">@lang('report.interest_expenses')</td>
                        <td style="text-align: right;"></td>
                        <td style="text-align: right;">(<span class="display_currency" data-currency_symbol="true">{{ $data['non_operating_expenses'] }}</span>)</td>
                    </tr>
                    <tr style="background-color: #f9f9f9; font-weight: bold;">
                        <td style="padding-left: 30px;">@lang('report.total_non_operating_income')</td>
                        <td style="text-align: right;"></td>
                        <td style="text-align: right;"><span class="display_currency" data-currency_symbol="true">{{ $data['total_non_operating'] }}</span></td>
                    </tr>
                    @if($data['total_depreciation'] > 0)
                    <tr>
                        <td style="padding-left: 30px;">@lang('report.depreciation')</td>
                        <td style="text-align: right;"></td>
                        <td style="text-align: right;">(<span class="display_currency" data-currency_symbol="true">{{ $data['total_depreciation'] }}</span>)</td>
                    </tr>
                    @endif
                    @if($data['total_appreciation'] > 0)
                    <tr>
                        <td style="padding-left: 30px;">@lang('report.appreciation')</td>
                        <td style="text-align: right;"></td>
                        <td style="text-align: right;"><span class="display_currency" data-currency_symbol="true">{{ $data['total_appreciation'] }}</span></td>
                    </tr>
                    @endif

                    <!-- NET INCOME SECTION -->
                    <tr style="background-color: #d1ecf1; font-weight: bold; border: 2px solid #0c5460; font-size: 16px;">
                        <td style="padding-left: 30px;">@lang('report.net_income')</td>
                        <td style="text-align: right;"></td>
                        <td style="text-align: right;"><span class="display_currency" data-currency_symbol="true" id="net_income_display">{{ $data['net_income'] }}</span></td>
                    </tr>
                </tbody>
            </table>
            @endcomponent
        </div>
    </div>

    <!-- Print and Export Buttons -->
    <div class="row no-print">
        <div class="col-sm-12">
            <button type="button" class="btn btn-primary pull-right" 
            aria-label="Print" onclick="printProfitLoss()"
            ><i class="fa fa-print"></i> @lang('messages.print')</button>
            <button type="button" class="btn btn-info pull-right" style="margin-right: 5px;"
            id="export_to_excel"
            ><i class="fa fa-file-excel-o"></i> @lang('messages.export_to_excel')</button>
        </div>
    </div>

    <!-- SHORT SUMMARY SECTION (SEPARATE SECTION) -->
    <div class="row" style="margin-top: 30px;">
        <div class="col-md-12">
            @component('components.widget', ['class' => 'box-info'])
            <div style="padding: 20px; background-color: #f9f9f9;">
                <h3 style="margin-top: 0; text-align: center; border-bottom: 2px solid #333; padding-bottom: 10px;">
                    <strong>Short Summary</strong>
                </h3>
                <table class="table table-bordered" style="width: 100%; margin-top: 15px;">
                    <tbody>
                        <tr style="background-color: #f8f9fa;">
                            <td style="width: 60%; padding-left: 30px;">Net Sales</td>
                            <td style="width: 20%; text-align: right;"></td>
                            <td style="width: 20%; text-align: right;"><span class="display_currency" data-currency_symbol="true">{{ $data['net_sales'] }}</span></td>
                        </tr>
                        <tr style="background-color: #f8f9fa;">
                            <td style="padding-left: 30px;">Less: Cost of Goods</td>
                            <td style="text-align: right;"></td>
                            <td style="text-align: right;">(<span class="display_currency" data-currency_symbol="true">{{ $data['cogs'] }}</span>)</td>
                        </tr>
                        <tr style="background-color: #f8f9fa;">
                            <td style="padding-left: 30px;">Less: Operating Expenses</td>
                            <td style="text-align: right;"></td>
                            <td style="text-align: right;">(<span class="display_currency" data-currency_symbol="true">{{ $data['total_operating_expenses'] }}</span>)</td>
                        </tr>
                        <tr style="background-color: #fff3cd; font-weight: bold; border: 2px solid #ffc107;">
                            <td style="padding-left: 30px;">Operating Income</td>
                            <td style="text-align: right;"></td>
                            <td style="text-align: right;"><span class="display_currency" data-currency_symbol="true">{{ $data['operating_income'] }}</span></td>
                        </tr>
                        <tr style="background-color: #f8f9fa;">
                            <td style="padding-left: 30px;">Add: Non-Operating Income</td>
                            <td style="text-align: right;"></td>
                            <td style="text-align: right;"><span class="display_currency" data-currency_symbol="true">{{ $data['total_non_operating'] }}</span></td>
                        </tr>
                        @if($data['total_depreciation'] > 0)
                        <tr style="background-color: #f8f9fa;">
                            <td style="padding-left: 30px;">Less: Depreciation</td>
                            <td style="text-align: right;"></td>
                            <td style="text-align: right;">(<span class="display_currency" data-currency_symbol="true">{{ $data['total_depreciation'] }}</span>)</td>
                        </tr>
                        @endif
                        @if($data['total_appreciation'] > 0)
                        <tr style="background-color: #f8f9fa;">
                            <td style="padding-left: 30px;">Add: Appreciation</td>
                            <td style="text-align: right;"></td>
                            <td style="text-align: right;"><span class="display_currency" data-currency_symbol="true">{{ $data['total_appreciation'] }}</span></td>
                        </tr>
                        @endif
                        <tr style="background-color: #d1ecf1; font-weight: bold; border: 2px solid #0c5460; font-size: 14px;">
                            <td style="padding-left: 30px;">Net Income</td>
                            <td style="text-align: right;"></td>
                            <td style="text-align: right;"><span class="display_currency" data-currency_symbol="true">{{ $data['net_income'] }}</span></td>
                        </tr>
                    </tbody>
                </table>
            </div>
            @endcomponent
        </div>
    </div>

    <!-- Print and Export for Summary Section -->
    <div class="row no-print">
        <div class="col-sm-12">
            <button type="button" class="btn btn-primary pull-right" 
            aria-label="Print" onclick="printSummary()"
            ><i class="fa fa-print"></i> @lang('messages.print')</button>
            <button type="button" class="btn btn-info pull-right" style="margin-right: 5px;"
            id="export_summary_to_excel"
            ><i class="fa fa-file-excel-o"></i> @lang('messages.export_to_excel')</button>
        </div>
    </div>

</section>
<!-- /.content -->
@stop

@section('javascript')
<script type="text/javascript">
    // Helper: build printable HTML (heading + table)
    function getPrintableHtml() {
        var table = document.querySelector('table');
        var exportTable = table.cloneNode(true);
        // remove buttons/controls that shouldn't be exported/printed
        exportTable.querySelectorAll('.no-print').forEach(function(el) { el.remove(); });
        var heading = document.querySelector('.print_section').innerHTML;
        var headingHtml = '<div style="text-align: center; margin-bottom: 20px;">' + heading + '</div>';
        return '<div>' + headingHtml + exportTable.outerHTML + '</div>';
    }

    // Print function: open new window with printable content and trigger print
    function printProfitLoss() {
        console.log('printProfitLoss called');
        var html = getPrintableHtml();
        var printWindow = window.open('', '_blank');
        if (!printWindow) {
            alert('Please disable pop-up blocker for this site');
            return;
        }
        printWindow.document.open();
        printWindow.document.write('<!doctype html><html><head><title>Profit and Loss Statement</title>');
        printWindow.document.write('<meta charset="UTF-8">');
        // Add inline critical styles for print
        printWindow.document.write('<style>');
        printWindow.document.write('body { margin: 0; padding: 10px; font-family: Arial, sans-serif; }');
        printWindow.document.write('table { width: 100%; border-collapse: collapse; }');
        printWindow.document.write('th, td { border: 1px solid #333; padding: 8px; text-align: left; }');
        printWindow.document.write('th { background-color: #f5f5f5; font-weight: bold; }');
        printWindow.document.write('.print_section { text-align: center; margin-bottom: 20px; }');
        printWindow.document.write('@page { margin: 0; size: A4; }');
        printWindow.document.write('@media print { body { margin: 0; padding: 10px; } * { color-adjust: exact !important; -webkit-print-color-adjust: exact !important; print-color-adjust: exact !important; } }');
        printWindow.document.write('</style>');
        printWindow.document.write('</head><body>');
        printWindow.document.write(html);
        printWindow.document.write('</body></html>');
        printWindow.document.close();
        // give the new window some time to load then print
        setTimeout(function() {
            try { 
                printWindow.focus(); 
                printWindow.print(); 
                console.log('print dialog opened');
            } catch (e) { 
                console.error('print error', e); 
            } 
        }, 800);
    }

    // Export to Excel functionality (uses Blob for reliability)
    function exportToExcel() {
        console.log('export_to_excel clicked');
        var fullHtml = getPrintableHtml();
        // Wrap in Excel-compatible HTML and add UTF-8 BOM
        var template = '\uFEFF' + '<html xmlns:x="urn:schemas-microsoft-com:office:excel"><head><meta charset="UTF-8"></head><body>' + fullHtml + '</body></html>';
        var blob = new Blob([template], { type: 'application/vnd.ms-excel' });
        var url = URL.createObjectURL(blob);
        var link = document.createElement('a');
        link.href = url;
        link.download = 'Profit_Loss_Statement_{{ date("Y-m-d_H-i-s") }}.xls';
        document.body.appendChild(link);
        try { 
            link.click(); 
            console.log('Excel export triggered');
        } catch (e) { 
            console.error('export click error', e); 
        }
        setTimeout(function() {
            document.body.removeChild(link);
            URL.revokeObjectURL(url);
        }, 100);
    }

    // Print Summary Section function
    function printSummary() {
        console.log('printSummary called');
        var heading = document.querySelector('.print_section').innerHTML;
        var headingHtml = '<div style="text-align: center; margin-bottom: 20px;">' + heading + '</div>';
        var summaryTable = document.querySelectorAll('table')[1]; // Get the summary table
        if (!summaryTable) {
            alert('Summary table not found');
            return;
        }
        var exportTable = summaryTable.cloneNode(true);
        var html = '<div>' + headingHtml + '<h3 style="text-align: center;">Short Summary</h3>' + exportTable.outerHTML + '</div>';
        
        var printWindow = window.open('', '_blank');
        if (!printWindow) {
            alert('Please disable pop-up blocker for this site');
            return;
        }
        printWindow.document.open();
        printWindow.document.write('<!doctype html><html><head><title>Profit and Loss Summary</title>');
        printWindow.document.write('<meta charset="UTF-8">');
        printWindow.document.write('<style>');
        printWindow.document.write('body { margin: 0; padding: 10px; font-family: Arial, sans-serif; }');
        printWindow.document.write('table { width: 100%; border-collapse: collapse; }');
        printWindow.document.write('th, td { border: 1px solid #333; padding: 8px; text-align: left; }');
        printWindow.document.write('th { background-color: #f5f5f5; font-weight: bold; }');
        printWindow.document.write('.print_section { text-align: center; margin-bottom: 20px; }');
        printWindow.document.write('@page { margin: 0; size: A4; }');
        printWindow.document.write('@media print { body { margin: 0; padding: 10px; } * { color-adjust: exact !important; -webkit-print-color-adjust: exact !important; print-color-adjust: exact !important; } }');
        printWindow.document.write('</style>');
        printWindow.document.write('</head><body>');
        printWindow.document.write(html);
        printWindow.document.write('</body></html>');
        printWindow.document.close();
        setTimeout(function() {
            try { 
                printWindow.focus(); 
                printWindow.print(); 
                console.log('summary print dialog opened');
            } catch (e) { 
                console.error('print error', e); 
            } 
        }, 800);
    }

    // Export Summary to Excel
    function exportSummaryToExcel() {
        console.log('export_summary_to_excel clicked');
        var heading = document.querySelector('.print_section').innerHTML;
        var headingHtml = '<div style="text-align: center; margin-bottom: 20px;">' + heading + '</div>';
        var summaryTable = document.querySelectorAll('table')[1]; // Get the summary table
        if (!summaryTable) {
            alert('Summary table not found');
            return;
        }
        var exportTable = summaryTable.cloneNode(true);
        var fullHtml = '<div>' + headingHtml + '<h3 style="text-align: center;">Short Summary</h3>' + exportTable.outerHTML + '</div>';
        
        var template = '\uFEFF' + '<html xmlns:x="urn:schemas-microsoft-com:office:excel"><head><meta charset="UTF-8"></head><body>' + fullHtml + '</body></html>';
        var blob = new Blob([template], { type: 'application/vnd.ms-excel' });
        var url = URL.createObjectURL(blob);
        var link = document.createElement('a');
        link.href = url;
        link.download = 'Profit_Loss_Summary_{{ date("Y-m-d_H-i-s") }}.xls';
        document.body.appendChild(link);
        try { 
            link.click(); 
            console.log('Summary Excel export triggered');
        } catch (e) { 
            console.error('export click error', e); 
        }
        setTimeout(function() {
            document.body.removeChild(link);
            URL.revokeObjectURL(url);
        }, 100);
    }

    $(document).ready(function() {
        console.log('profit_loss_statement: script loaded');
        // Store the original operating income value for Net Income calculation
        var operating_income_value = 0;
        var operating_income_text = $('td').filter(function() {
            return $(this).text().trim() === 'Operating Income';
        }).closest('tr').find('span.display_currency:last').text();
        operating_income_value = parseFloat(operating_income_text.replace(/,/g, '').replace(/[$]/g, '')) || 0;
        
        // Load saved non-operating values from localStorage
        var savedRevenueFromInterest = localStorage.getItem('pl_revenue_from_interest');
        var savedInterestExpenses = localStorage.getItem('pl_interest_expenses');
        
        if (savedRevenueFromInterest) {
            $('#revenue_from_interest').val(savedRevenueFromInterest);
        }
        if (savedInterestExpenses) {
            $('#interest_expenses').val(savedInterestExpenses);
        }
        
        // Recalculate on page load if values were restored
        if (savedRevenueFromInterest || savedInterestExpenses) {
            calculateNonOperatingIncome();
        }
        
        // Initialize date range picker with existing dates
        var startDate = '{{ $start_date }}';
        var endDate = '{{ $end_date }}';
        
        var drp = $('#pl_statement_date_filter').daterangepicker({
            startDate: moment(startDate, 'YYYY-MM-DD'),
            endDate: moment(endDate, 'YYYY-MM-DD'),
            locale: {
                format: 'YYYY-MM-DD'
            }
        });

        // Date filter change event - fire on apply
        drp.on('apply.daterangepicker', function(ev, picker) {
            var start_date = picker.startDate.format('YYYY-MM-DD');
            var end_date = picker.endDate.format('YYYY-MM-DD');
            window.location.href = '/reports/profit-loss-statement?start_date=' + start_date + '&end_date=' + end_date;
        });

        // Bind export button to global function
        $('#export_to_excel').on('click', exportToExcel);
        $('#export_summary_to_excel').on('click', exportSummaryToExcel);
    });
</script>
@endsection