@extends('dashboard.includes.partial.base')
@section('content')
<div class="page-content">
<div class="container-fluid">
<!-- Page Header -->
<div class="row">
<div class="col-12">
<div class="page-title-box d-sm-flex align-items-center justify-content-between">
<h4 class="mb-sm-0">Milk Sales Report</h4>
</div>
</div>
</div>
<!-- Filters -->
<div class="row mb-3">
<div class="col-12">
<div class="card">
<div class="card-body">
<form method="GET" action="{{ route('reports.sales') }}" class="row g-3 align-items-end">
<div class="col-md-2">
<label for="start_date" class="form-label">Start Date</label>
<input type="date" class="form-control" id="start_date" name="start_date"
value="{{ $startDate }}">
</div>
<div class="col-md-2">
<label for="end_date" class="form-label">End Date</label>
<input type="date" class="form-control" id="end_date" name="end_date"
value="{{ $endDate }}">
</div>
@if (isset($farms) && count($farms) > 0)
<div class="col-md-3">
<label for="farm_id" class="form-label">Farm</label>
<select class="form-select" name="farm_id" id="farm_id">
<option value="">All Farms</option>
@foreach ($farms as $farm)
<option value="{{ $farm->id }}"
{{ isset($filterFarmId) && $filterFarmId == $farm->id ? 'selected' : '' }}>
{{ $farm->name }}
</option>
@endforeach
</select>
</div>
@endif
<div class="col-md-3">
<label for="vendor_id" class="form-label">Vendor</label>
<select class="form-select" name="vendor_id" id="vendor_id">
<option value="">All Vendors</option>
@foreach ($vendors as $vendor)
<option value="{{ $vendor->id }}"
{{ $vendorId == $vendor->id ? 'selected' : '' }}>{{ $vendor->name }}
</option>
@endforeach
</select>
</div>
<div class="col-md-2">
<button type="submit" class="btn btn-primary">Filter</button>
<a href="{{ route('reports.sales') }}" class="btn btn-secondary">Reset</a>
</div>
</form>
</div>
</div>
</div>
</div>
<!-- Stats -->
<div class="row">
<div class="col-xl-4 col-md-6">
<!-- card -->
<div class="card card-animate">
<div class="card-body">
<div class="d-flex align-items-center">
<div class="flex-grow-1 overflow-hidden">
<p class="text-uppercase fw-medium text-muted text-truncate mb-0">Total Sold</p>
</div>
</div>
<div class="d-flex align-items-end justify-content-between mt-4">
<div>
<h4 class="fs-22 fw-semibold ff-secondary mb-4">{{ number_format($totalSold, 2) }}
<span class="text-muted fs-13">Liters</span>
</h4>
</div>
</div>
</div><!-- end card body -->
</div><!-- end card -->
</div><!-- end col -->
<div class="col-xl-4 col-md-6">
<!-- card -->
<div class="card card-animate">
<div class="card-body">
<div class="d-flex align-items-center">
<div class="flex-grow-1 overflow-hidden">
<p class="text-uppercase fw-medium text-muted text-truncate mb-0">Total Revenue</p>
</div>
</div>
<div class="d-flex align-items-end justify-content-between mt-4">
<div>
<h4 class="fs-22 fw-semibold ff-secondary mb-4">{{ number_format($totalRevenue, 2) }}
<span class="text-muted fs-13">PKR</span>
</h4>
</div>
</div>
</div><!-- end card body -->
</div><!-- end card -->
</div><!-- end col -->
<div class="col-xl-4 col-md-6">
<!-- card -->
<div class="card card-animate">
<div class="card-body">
<div class="d-flex align-items-center">
<div class="flex-grow-1 overflow-hidden">
<p class="text-uppercase fw-medium text-muted text-truncate mb-0">Avg Price</p>
</div>
</div>
<div class="d-flex align-items-end justify-content-between mt-4">
<div>
<h4 class="fs-22 fw-semibold ff-secondary mb-4">{{ number_format($avgPrice, 2) }} <span
class="text-muted fs-13">/ Liter</span></h4>
</div>
</div>
</div><!-- end card body -->
</div><!-- end card -->
</div><!-- end col -->
</div>
<!-- Table -->
<div class="row">
<div class="col-12">
<div class="card">
<div class="card-header">
<h5 class="card-title mb-0">Sales Records</h5>
</div>
<div class="card-body">
<div class="table-responsive">
<table class="table table-bordered table-striped dt-responsive nowrap">
<thead>
<tr>
<th>Date</th>
<th>Vendor</th>
<th>Quantity (L)</th>
<th>Price Unit</th>
<th>Total</th>
<th>Notes</th>
</tr>
</thead>
<tbody>
@forelse($salesData as $item)
<tr>
<td>{{ $item->sold_at->format('Y-m-d') }}</td>
<td>{{ $item->vendor ? $item->vendor->name : 'N/A' }}</td>
<td>{{ $item->quantity }}</td>
<td>{{ $item->price_per_unit }}</td>
<td>{{ $item->total_amount }}</td>
<td>{{ $item->notes }}</td>
</tr>
@empty
<tr>
<td colspan="6" class="text-center">No records found.</td>
</tr>
@endforelse
</tbody>
</table>
<div class="mt-3">
{{ $salesData->withQueryString()->links() }}
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
@endsection