@extends('layouts.app')

@section('content')
<div class="content-header">
	<h2>Stock Report</h2>
	<button id="generate-report-btn" class="btn btn-sm btn-warning" onclick="generateReport()">
		<span id="button-text">Generate Real-Time Report</span>
		@include('components.loader')
	</button>
</div>



<div class="content">
	<!-- Filter Form -->
	<form method="GET" action="{{ route('stock-report.index') }}" class="mb-4">
		<div class="row">
			<div class="col-md-3">
				<label for="category_id">Category</label>
				<select name="category_id" id="category_id" class="form-control select2">
					<option value="">All Categories</option>
					@foreach($categories as $category)
					<option value="{{ $category->id }}" {{ request('category_id') == $category->id ? 'selected' : '' }}>{{ $category->name }}</option>
					@endforeach
				</select>
			</div>
			<div class="col-md-3">
				<label for="item_id">Item</label>
				<select name="item_id" id="item_id" class="form-control select2">
					<option value="">All Items</option>
					@foreach($items as $item)
					<option value="{{ $item->id }}" {{ request('item_id') == $item->id ? 'selected' : '' }}>{{ $item->name }}</option>
					@endforeach
				</select>
			</div>
			<div class="col-md-3">
				<label for="variation_id">Variation</label>
				<select name="variation_id" id="variation_id" class="form-control select2">
					<option value="">All Variations</option>
					@foreach($variations as $variation)
					<option value="{{ $variation->id }}" {{ request('variation_id') == $variation->id ? 'selected' : '' }}>{{ $variation->name }}</option>
					@endforeach
				</select>
			</div>
			<div class="col-md-3">
				<label for="batch_id">Batch</label>
				<input type="text" name="batch_id" id="batch_id" class="form-control" value="{{ request('batch_id') }}" disabled>
			</div>
		</div>
		<div class="row mt-2">
			<div class="col-md-3">
				<label for="warehouse_id">Warehouse</label>
				<select name="warehouse_id" id="warehouse_id" class="form-control select2">
					<option value="">All Warehouses</option>
					@foreach($warehouses as $warehouse)
					<option value="{{ $warehouse->id }}" {{ request('warehouse_id') == $warehouse->id ? 'selected' : '' }}>{{ $warehouse->name }}</option>
					@endforeach
				</select>
			</div>
			<div class="col-md-3">
				<label for="date">Date</label>
				<input type="date" name="date" id="date" class="form-control" value="{{ request('date') }}">
			</div>
			<div class="col-md-3">
				<label for="month">Month</label>
				<input type="month" name="month" id="month" class="form-control" value="{{ request('month') }}">
			</div>
			<div class="col-md-3">
				<label for="year">Year</label>
				<input type="number" name="year" id="year" class="form-control" placeholder="e.g., 2023" value="{{ request('year') }}">
			</div>
		</div>
		<div class="mt-3 text-right">
			<button type="submit" class="btn btn-primary">Search</button>
		</div>
	</form>

	<!-- Report Table -->
	<table class="table table-bordered table-striped">
		<thead>
			<tr>
				<th rowspan="2">SL</th>
				<th rowspan="2">Perticular</th>
				<th colspan="3">Opening Stock</th>
				<th colspan="3">Stock In</th>
				<th colspan="3">Stock Out</th>
				<th colspan="3">Closing Stock</th>
			</tr>
			<tr>
				<td>Qty</td>
				<td>C. Rate</td>
				<td>Value</td>

				<td>Qty</td>
				<td>C. Rate</td>
				<td>Value</td>

				<td>Qty</td>
				<td>S. Rate</td>
				<td>Value</td>

				<td>Qty</td>
				<td>C. Rate</td>
				<td>Value</td>
			</tr>
		</thead>
		<tbody>
			@foreach($stocks as $index => $stock)
			@php
			// Find the matching opening stock (yesterday's closing stock) or default to 0
			$opening_stock = $opening_stocks->where('item_id', $stock->item_id)->first()->closing_stock ?? 0;

			// Calculate opening amount (opening stock * average cost)
			$opening_amount = $opening_stock * $stock->average_cost;

			// Calculate today's amount (closing stock * average cost)
			$amount = $stock->closing_stock * $stock->average_cost;

			// Stock In values (assuming 'total_in_qty' and 'average_cost' exist in the model)
			$stock_in_qty = $stock->total_in_qty ?? 0; // Stock In quantity
			$stock_in_amount = $stock_in_qty * $stock->average_cost; // Stock In amount

			// Stock Out values (assuming 'total_out_qty' and 'average_cost' exist in the model)
			$stock_out_qty = $stock->total_out_qty ?? 0; // Stock Out quantity
			$stock_out_amount = $stock_out_qty * $stock->average_cost; // Stock Out amount
			@endphp
			<tr>
				<td>{{ $index + 1 }}</td>
				<td>{{ $stock->item->name }} ({{ $stock->variation->name ?? 'N/A' }})</td>

				<td class="text-right">{{ number_format($opening_stock, 2) }}</td> <!-- Opening stock (yesterday's closing stock) -->
				<td class="text-right">{{ number_format($opening_stock == 0 ? 0 : $stock->average_cost, 2) }}</td> <!-- Average cost -->
				<td class="text-right">{{ number_format($opening_amount, 2) }}</td> <!-- Placeholder for any other data -->

				<td class="text-right">{{ number_format($stock_in_qty, 2) }}</td> <!-- Stock In Quantity -->
				<td class="text-right">{{ number_format($stock_in_qty == 0 ? 0 : $stock->average_cost, 2) }}</td> <!-- Average Cost (0 if Stock In Qty is 0) -->
				<td class="text-right">{{ number_format($stock_in_amount, 2) }}</td> <!-- Stock In Amount -->

				<td class="text-right">{{ number_format($stock_out_qty, 2) }}</td> <!-- Placeholder for any other data -->
				<td class="text-right">{{ number_format($stock_out_qty== 0 ? 0 : $stock->average_cost, 2) }}</td> <!-- Placeholder for any other data -->
				<td class="text-right">{{ number_format($stock_out_amount, 2) }}</td> <!-- Placeholder for any other data -->

				<td class="text-right">{{ number_format($stock->closing_stock, 2) }}</td> <!-- Today's closing stock -->
				<td class="text-right">{{ number_format($stock->average_cost, 2) }}</td> <!-- Today's average cost -->
				<td class="text-right">{{ number_format($amount, 2) }}</td> <!-- Today's amount -->
			</tr>
			@endforeach
		</tbody>
	</table>
</div>
@endsection


<script>
	function generateReport() {
		// Show loader and change button text while processing
		showLoaderWithText('generate-report-btn');
		document.getElementById('button-text').innerText = "Generating Report...";

		// Make the AJAX request to run the stock schedule
		fetch("{{ route('stock-report.run-stock-schedule') }}")
			.then(response => response.json())
			.then(data => {
				// Hide the loader after response
				document.getElementById('button-text').innerText = "Generate Real-Time Report";
				alert(data.message); // Show success message
			})
			.catch(error => {
				// Hide the loader and show error message
				document.getElementById('button-text').innerText = "Generate Real-Time Report";
				console.error('Error:', error);
				alert('Failed to generate the report.');
			});

		setTimeout(() => {
			window.location.href = "{{ route('stock-report.index') }}";
		}, 100); // Slight delay to show loader
	}
</script>