@extends('layouts.app')

@section('content')
<div class="container-fluid">
    <div class="d-flex justify-content-between align-items-center mb-3">
        <h4 class="mb-0">Purchase & Sales Report</h4>
        <div>
            <a href="{{ url('/reseller/purchase-report') }}" class="btn btn-secondary btn-sm">Back to Purchase Report</a>
        </div>
    </div>

    <div class="card mb-3">
        <div class="card-body">
            <form method="get" action="">
                <div class="form-row align-items-end">
                    <div class="col-auto">
                        <label for="from_date" class="small mb-1">From</label>
                        <input type="date" class="form-control form-control-sm" id="from_date" name="from_date" value="{{ $from }}">
                    </div>
                    <div class="col-auto">
                        <label for="to_date" class="small mb-1">To</label>
                        <input type="date" class="form-control form-control-sm" id="to_date" name="to_date" value="{{ $to }}">
                    </div>
                    <div class="col-auto">
                        <button type="submit" class="btn btn-primary btn-sm">Apply</button>
                    </div>
                </div>
            </form>
        </div>
    </div>

    <div class="row mb-3">
        <div class="col-md-4 mb-2">
            <div class="card bg-info text-white">
                <div class="card-body">
                    <h6>Purchases</h6>
                    <div>Amount: BDT {{ number_format($purchaseAmount, 2) }}</div>
                    <div>Paid: BDT {{ number_format($purchasePaid, 2) }}</div>
                    <div>Due: BDT {{ number_format($purchaseDue, 2) }}</div>
                </div>
            </div>
        </div>
        <div class="col-md-4 mb-2">
            <div class="card bg-success text-white">
                <div class="card-body">
                    <h6>Sales</h6>
                    <div>Amount: BDT {{ number_format($salesAmount, 2) }}</div>
                    <div>Received: BDT {{ number_format($salesReceived, 2) }}</div>
                    <div>Due: BDT {{ number_format($salesDue, 2) }}</div>
                </div>
            </div>
        </div>
        <div class="col-md-4 mb-2">
            <div class="card bg-primary text-white">
                <div class="card-body">
                    <h6>Net (Sales - Purchases)</h6>
                    <div>Amount: BDT {{ number_format($salesAmount - $purchaseAmount, 2) }}</div>
                    <div>Cashflow (Received - Paid): BDT {{ number_format($salesReceived - $purchasePaid, 2) }}</div>
                </div>
            </div>
        </div>
    </div>

    <div class="card">
        <div class="card-header"><strong>Item-wise Summary</strong></div>
        <div class="table-responsive">
            <table class="table mb-0">
                <thead>
                    <tr>
                        <th>Item</th>
                        <th class="text-right">Purchased Qty</th>
                        <th class="text-right">Purchased Avg.</th>
                        <th class="text-right">Purchased Amount</th>
                        <th class="text-right">Sales Qty</th>
                        <th class="text-right">Sales Avg.</th>
                        <th class="text-right">Sales Amount</th>
                        <th class="text-right">Profit/Loss</th>
                    </tr>
                </thead>
                <tbody>
                    @php
                        $t_pq = 0; $t_pa = 0; $t_sq = 0; $t_sa = 0;
                    @endphp
                    @forelse(($itemWise ?? []) as $row)
                        @php
                            $t_pq += $row['purchase_qty'];
                            $t_pa += $row['purchase_amount'];
                            $t_sq += $row['sales_qty'];
                            $t_sa += $row['sales_amount'];
                            $p_avg = $row['purchase_qty'] > 0 ? $row['purchase_amount'] / $row['purchase_qty'] : 0;
                            $s_avg = $row['sales_qty'] > 0 ? $row['sales_amount'] / $row['sales_qty'] : 0;
                            $profit = $row['sales_amount'] - $row['purchase_amount'];
                        @endphp
                        <tr>
                            <td>{{ $row['item_name'] }}</td>
                            <td class="text-right">{{ number_format($row['purchase_qty'], 2) }}</td>
                            <td class="text-right">BDT {{ number_format($p_avg, 2) }}</td>
                            <td class="text-right">BDT {{ number_format($row['purchase_amount'], 2) }}</td>
                            <td class="text-right">{{ number_format($row['sales_qty'], 2) }}</td>
                            <td class="text-right">BDT {{ number_format($s_avg, 2) }}</td>
                            <td class="text-right">BDT {{ number_format($row['sales_amount'], 2) }}</td>
                            <td class="text-right">BDT {{ number_format($profit, 2) }}</td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="8" class="text-center text-muted">No data found for this date range.</td>
                        </tr>
                    @endforelse
                </tbody>
                <tfoot>
                    <tr class="font-weight-bold">
                        <td>Total</td>
                        <td class="text-right">{{ number_format($t_pq, 2) }}</td>
                        <td class="text-right">BDT {{ number_format(($t_pq>0 ? $t_pa/$t_pq : 0), 2) }}</td>
                        <td class="text-right">BDT {{ number_format($t_pa, 2) }}</td>
                        <td class="text-right">{{ number_format($t_sq, 2) }}</td>
                        <td class="text-right">BDT {{ number_format(($t_sq>0 ? $t_sa/$t_sq : 0), 2) }}</td>
                        <td class="text-right">BDT {{ number_format($t_sa, 2) }}</td>
                        <td class="text-right">BDT {{ number_format($t_sa - $t_pa, 2) }}</td>
                    </tr>
                </tfoot>
            </table>
        </div>
    </div>
</div>
@endsection