@extends('admin.layouts.app')

@section('title', 'Profit & Loss Report')
@section('page_title', 'Profit & Loss Report')

@section('content')
<style>
    .report-table { font-size: 12px; }
    .report-table th, .report-table td { padding: 4px 6px; white-space: nowrap; }
    .compact-card { padding: 8px 12px; }
    .compact-card h6 { font-size: 11px; margin-bottom: 2px; }
    .compact-card h4 { font-size: 16px; margin: 0; }
</style>

<div class="card">
    <div class="card-header">
        <div class="d-flex justify-content-between align-items-center">
            <h5 class="mb-0">Profit & Loss Report</h5>
            <div>
                <a href="{{ route('profit-loss.print', request()->query()) }}" target="_blank" class="btn btn-success btn-sm">
                    <i class="bi bi-printer"></i> Print
                </a>
            </div>
        </div>
    </div>
    <div class="card-body p-2">
        <form method="GET" action="{{ route('profit-loss') }}" class="mb-3">
            <div class="row g-2">
                <div class="col-md-2">
                    <select name="year" class="form-select form-select-sm">
                        @for($y = date('Y'); $y >= date('Y') - 5; $y--)
                            <option value="{{ $y }}" {{ date('Y', strtotime($from_date)) == $y ? 'selected' : '' }}>{{ $y }}</option>
                        @endfor
                    </select>
                </div>
                <div class="col-md-2">
                    <select name="month" class="form-select form-select-sm">
                        <option value="">All Months</option>
                        @foreach(['01'=>'Jan','02'=>'Feb','03'=>'Mar','04'=>'Apr','05'=>'May','06'=>'Jun','07'=>'Jul','08'=>'Aug','09'=>'Sep','10'=>'Oct','11'=>'Nov','12'=>'Dec'] as $m => $mname)
                            <option value="{{ $m }}" {{ date('m', strtotime($from_date)) == $m ? 'selected' : '' }}>{{ $mname }}</option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-2">
                    <input type="date" name="from_date" class="form-control form-control-sm" value="{{ $from_date }}">
                </div>
                <div class="col-md-2">
                    <input type="date" name="to_date" class="form-control form-control-sm" value="{{ $to_date }}">
                </div>
                <div class="col-md-4">
                    <button type="submit" class="btn btn-primary btn-sm">Filter</button>
                    <a href="{{ route('profit-loss') }}" class="btn btn-secondary btn-sm">Reset</a>
                </div>
            </div>
        </form>

        <div class="row g-2 mb-3">
            <div class="col-md-4">
                <div class="card bg-primary text-white compact-card">
                    <div class="text-center">
                        <h6>Total Purchase</h6>
                        <h4>{{ number_format($totalPurchase, 2) }}</h4>
                    </div>
                </div>
            </div>
            <div class="col-md-3">
                <div class="card bg-success text-white compact-card">
                    <div class="text-center">
                        <h6>Total Sales</h6>
                        <h4>{{ number_format($totalSales, 2) }}</h4>
                    </div>
                </div>
            </div>
            <div class="col-md-2">
                <div class="card bg-warning text-dark compact-card">
                    <div class="text-center">
                        <h6>Total TDS/VDS</h6>
                        <h4>{{ number_format($totalTdsVds, 2) }}</h4>
                    </div>
                </div>
            </div>
            <div class="col-md-3">
                <div class="card {{ $totalProfit >= 0 ? 'bg-success' : 'bg-danger' }} text-white compact-card">
                    <div class="text-center">
                        <h6>Net {{ $totalProfit >= 0 ? 'Profit' : 'Loss' }}</h6>
                        <h4>{{ $totalProfit >= 0 ? number_format($totalProfit, 2) : '('.number_format(abs($totalProfit), 2).')' }}</h4>
                    </div>
                </div>
            </div>
        </div>

        <div class="table-responsive">
            <table class="table table-bordered table-striped table-sm report-table mb-0">
                <thead class="table-dark">
                    <tr>
                        <th style="width: 40px;">Sl</th>
                        <th style="width: 75px;">Date</th>
                        <th>Shipment</th>
                        <th>Supplier</th>
                        <th class="text-end">Purchase</th>
                        <th class="text-end">Sales</th>
                        <th class="text-end">TDS/VDS</th>
                        <th class="text-end">Profit/Loss</th>
                        <th style="width: 50px;"></th>
                    </tr>
                </thead>
                <tbody>
                    @php $sl = 1; @endphp
                    @forelse($reportData as $row)
                        @php
                            $rowProfit = $row['sales_amount'] - $row['purchase_amount'] - $row['tds_vds_other'];
                        @endphp
                        <tr>
                            <td>{{ $sl++ }}</td>
                            <td>{{ $row['purchase_date'] ? \Carbon\Carbon::parse($row['purchase_date'])->format('d-m-y') : '-' }}</td>
                            <td><strong>{{ $row['shipment_number'] }}</strong></td>
                            <td>{{ $row['supplier_name'] }}</td>
                            <td class="text-end">{{ number_format($row['purchase_amount'], 2) }}</td>
                            <td class="text-end">{{ number_format($row['sales_amount'], 2) }}</td>
                            <td class="text-end">{{ number_format($row['tds_vds_other'], 2) }}</td>
                            <td class="text-end {{ $rowProfit >= 0 ? 'text-success' : 'text-danger' }}">
                                <strong>{{ $rowProfit >= 0 ? number_format($rowProfit, 2) : '('.number_format(abs($rowProfit), 2).')' }}</strong>
                            </td>
                            <td class="text-center">
                                <button type="button" class="btn btn-xs btn-primary py-0 px-1" onclick="openTdsModal('{{ $row['shipment_number'] }}', '{{ $row['tds_vds_other'] }}')">
                                    <i class="bi bi-pencil"></i>
                                </button>
                            </td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="9" class="text-center">No transactions found</td>
                        </tr>
                    @endforelse
                </tbody>
                <tfoot class="table-secondary">
                    <tr>
                        <th colspan="4">Grand Total</th>
                        <th class="text-end">{{ number_format($totalPurchase, 2) }}</th>
                        <th class="text-end">{{ number_format($totalSales, 2) }}</th>
                        <th class="text-end">{{ number_format(array_sum(array_column($reportData, 'tds_vds_other')), 2) }}</th>
                        <th class="text-end {{ $totalProfit >= 0 ? 'text-success' : 'text-danger' }}">
                            {{ $totalProfit >= 0 ? number_format($totalProfit, 2) : '('.number_format(abs($totalProfit), 2).')' }}
                        </th>
                        <th></th>
                    </tr>
                </tfoot>
            </table>
        </div>
        
        <div class="mt-4">
            <h6 class="mb-2">Expenses Summary</h6>
            <table class="table table-bordered table-striped table-sm report-table mb-0">
                <thead class="table-secondary">
                    <tr>
                        <th>Category</th>
                        <th class="text-end">Amount</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($expensesByCategory as $exp)
                        <tr>
                            <td>{{ $exp['category'] ?: 'Other' }}</td>
                            <td class="text-end">{{ number_format($exp['total'], 2) }}</td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="2" class="text-center">No expenses found</td>
                        </tr>
                    @endforelse
                </tbody>
                <tfoot class="table-light">
                    <tr>
                        <th>Total Expenses</th>
                        <th class="text-end">{{ number_format($totalExpenses, 2) }}</th>
                    </tr>
                </tfoot>
            </table>
        </div>
        
        <div class="mt-4">
            <div class="row">
                <div class="col-md-6"></div>
                <div class="col-md-6">
                    <table class="table table-bordered table-sm mb-0">
                        <thead class="table-dark">
                            <tr>
                                <th colspan="2" class="text-center">Net Profit Calculation</th>
                            </tr>
                        </thead>
                        <tbody>
                            <tr>
                                <td>Gross Profit (Total Profit/Loss)</td>
                                <td class="text-end {{ $totalProfit >= 0 ? 'text-success' : 'text-danger' }}">
                                    {{ $totalProfit >= 0 ? number_format($totalProfit, 2) : '('.number_format(abs($totalProfit), 2).')' }}
                                </td>
                            </tr>
                            <tr>
                                <td>Less: Total Expenses</td>
                                <td class="text-end text-danger">(-) {{ number_format($totalExpenses, 2) }}</td>
                            </tr>
                        </tbody>
                        @php
                            $netProfit = $totalProfit - $totalExpenses;
                        @endphp
                        <tfoot class="table-{{ $netProfit >= 0 ? 'success' : 'danger' }}">
                            <tr>
                                <th>{{ $netProfit >= 0 ? 'Net Profit' : 'Net Loss' }}</th>
                                <th class="text-end {{ $netProfit >= 0 ? 'text-success' : 'text-danger' }}">
                                    {{ $netProfit >= 0 ? number_format($netProfit, 2) : '('.number_format(abs($netProfit), 2).')' }}
                                </th>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>

<div class="modal fade" id="tdsModal" tabindex="-1">
    <div class="modal-dialog modal-sm">
        <div class="modal-content">
            <div class="modal-header py-1">
                <h6 class="modal-title">Update TDS/VDS</h6>
                <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
            </div>
            <form action="{{ route('profit-loss.update-tds') }}" method="POST">
                @csrf
                <div class="modal-body py-2">
                    <div class="mb-2">
                        <label class="form-label small">Shipment</label>
                        <input type="text" id="tds_shipment" name="shipment_number" class="form-control form-control-sm" readonly>
                    </div>
                    <div class="mb-0">
                        <label class="form-label small">Amount</label>
                        <input type="number" step="0.01" id="tds_amount" name="tds_vds_other" class="form-control form-control-sm" required>
                    </div>
                </div>
                <div class="modal-footer py-1">
                    <button type="button" class="btn btn-secondary btn-sm" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" class="btn btn-primary btn-sm">Save</button>
                </div>
            </form>
        </div>
    </div>
</div>

<script>
function openTdsModal(shipment, currentAmount) {
    document.getElementById('tds_shipment').value = shipment;
    document.getElementById('tds_amount').value = currentAmount;
    new bootstrap.Modal(document.getElementById('tdsModal')).show();
}
</script>
@endsection