@extends('admin.layouts.app')

@section('title', 'Purchase Vs Sales Report')
@section('page_title', 'Purchase Vs Sales Report')

@section('content')
<div class="card">
    <div class="card-header">
        <h5 class="mb-0">Purchase Vs Sales Report</h5>
    </div>
    <div class="card-body">
        <form action="{{ route('purchase-vs-sales') }}" method="GET" class="mb-4">
            <div class="row">
                <div class="col-md-2">
                    <label class="form-label">From Date</label>
                    <input type="date" name="from_date" class="form-control" value="{{ $from_date }}">
                </div>
                <div class="col-md-2">
                    <label class="form-label">To Date</label>
                    <input type="date" name="to_date" class="form-control" value="{{ $to_date }}">
                </div>
                <div class="col-md-3">
                    <label class="form-label">Shipment Number</label>
                    <select name="shipment_number" class="form-select">
                        <option value="">All Shipments</option>
                        @foreach($allShipments as $shipment)
                            <option value="{{ $shipment }}" {{ $shipment_number == $shipment ? 'selected' : '' }}>{{ $shipment }}</option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-5 d-flex align-items-end">
                    <button type="submit" class="btn btn-primary">Filter</button>
                    <a href="{{ route('purchase-vs-sales') }}" class="btn btn-secondary ms-2">Reset</a>
                    <a href="{{ route('purchase-vs-sales.print', ['from_date' => $from_date, 'to_date' => $to_date, 'shipment_number' => $shipment_number]) }}" class="btn btn-danger ms-2" target="_blank"><i class="fas fa-file-pdf"></i> Print</a>
                </div>
            </div>
        </form>

        <div class="row mb-4">
            <div class="col-md-4">
                <div class="card bg-primary text-white">
                    <div class="card-body text-center">
                        <h6>Total Purchase</h6>
                        <h3>{{ number_format($totalPurchaseAmount, 2) }}</h3>
                    </div>
                </div>
            </div>
            <div class="col-md-4">
                <div class="card bg-success text-white">
                    <div class="card-body text-center">
                        <h6>Total Sales</h6>
                        <h3>{{ number_format($totalSaleAmount, 2) }}</h3>
                    </div>
                </div>
            </div>
            <div class="col-md-4">
                <div class="card bg-info text-white">
                    <div class="card-body text-center">
                        <h6>Gross Profit</h6>
                        <h3>{{ number_format($grossProfit, 2) }}</h3>
                    </div>
                </div>
            </div>
        </div>

        <style>
    .report-table { font-size: 11px; }
    .report-table th, .report-table td { padding: 3px 5px; }
</style>

<div class="table-responsive">
            <table class="table table-bordered table-striped report-table">
                <thead class="table-dark">
                    <tr>
                        <th style="width: 50px;">Sl No</th>
                        <th>Product Name</th>
                        <th class="text-center">Shipment No</th>
                        <th class="text-center">Purchase Qty</th>
                        <th class="text-center">Sale Qty</th>
                        <th class="text-center">Wastage Qty</th>
                        <th class="text-center">Purchase Return</th>
                        <th class="text-center">Sales Return</th>
                        <th class="text-center">Stock in Hand</th>
                        <th class="text-center">Purchase Amount</th>
                        <th class="text-center">Sale Amount</th>
                        <th class="text-center">Profit/Loss</th>
                    </tr>
                </thead>
                <tbody>
                    @php $sl = 1; @endphp
                    @forelse($reportData as $row)
                        <tr>
                            <td>{{ $sl++ }}</td>
                            <td><strong>{{ $row['product_name'] }}</strong></td>
                            <td class="text-center">{{ $row['shipment_number'] }}</td>
                            <td class="text-center">{{ number_format($row['purchase_qty'], 2) }}</td>
                            <td class="text-center">{{ number_format($row['sale_qty'], 2) }}</td>
                            <td class="text-center text-danger">{{ number_format($row['wastage_qty'], 2) }}</td>
                            <td class="text-center text-info">{{ number_format($row['purchase_return_qty'], 2) }}</td>
                            <td class="text-center text-success">{{ number_format($row['sale_return_qty'], 2) }}</td>
                            <td class="text-center"><strong>{{ number_format($row['stock_in_hand'], 2) }}</strong></td>
                            <td class="text-end">{{ number_format($row['purchase_amount'], 2) }}</td>
                            <td class="text-end">{{ number_format($row['sale_amount'], 2) }}</td>
                            <td class="text-end">
                                <span class="text-{{ $row['profit'] >= 0 ? 'success' : 'danger' }}">
                                    {{ number_format($row['profit'], 2) }}
                                </span>
                            </td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="9" class="text-center">No data found for selected date range</td>
                        </tr>
                    @endforelse
                </tbody>
                <tfoot class="table-secondary">
                    <tr>
                        <th colspan="2" class="text-end">Total:</th>
                        <th></th>
                        <th class="text-center">{{ number_format($totalPurchaseQty, 2) }}</th>
                        <th class="text-center">{{ number_format($totalSaleQty, 2) }}</th>
                        <th class="text-center">{{ number_format($totalWastageQty, 2) }}</th>
                        <th class="text-center">{{ number_format($totalPurchaseReturnQty, 2) }}</th>
                        <th class="text-center">{{ number_format($totalSaleReturnQty, 2) }}</th>
                        <th class="text-center">{{ number_format($totalStockInHand, 2) }}</th>
                        <th class="text-end">{{ number_format($totalPurchaseAmount, 2) }}</th>
                        <th class="text-end">{{ number_format($totalSaleAmount, 2) }}</th>
                        <th class="text-end">{{ number_format($grossProfit, 2) }}</th>
                    </tr>
                </tfoot>
            </table>
        </div>
    </div>
</div>
@endsection