@extends('layouts.app')

@section('content')
<div class="content-header">
	<p class="title">Stock Opening</p>
</div>

<div class="content">

	@include('components.notifications')

	<!-- Warehouse Selection Form -->
	<form id="warehouseForm" method="GET" action="{{ route('stock-opening.index') }}">
		<table class="table table-borderless">
			<tbody>
				<tr>
					<th class="bg-light" width="33.33%"><label for="warehouse_id">Select Warehouse</label></th>
					<th class="bg-light" width="33.33%"><label for="category_id">Select Category</label></th>
					<th class="bg-light" width="33.33%"></th>
				</tr>
				<tr>
					<td>
						<select name="warehouse_id" id="warehouse_id" class="form-control select2" required>
							<option value="" {{ is_null(request('warehouse_id')) ? 'selected' : '' }}>Select Warehouse</option>
							@foreach($warehouses as $warehouse)
							<option value="{{ $warehouse->id }}" {{ request('warehouse_id') == $warehouse->id ? 'selected' : '' }}>
								{{ $warehouse->name }}
							</option>
							@endforeach
						</select>
					</td>
					<td>
						<select class="form-select select2 @error('category_id') is-invalid @enderror" id="category_id" name="category_id" style="width:100%">
							<option value="">None</option>
							@foreach ($categories as $category)
							@include('inventory.category._category_option', [
							'category' => $category,
							'level' => 0,
							'selectedCategoryId' => request('category_id')
							])
							@endforeach
						</select>
						@error('category_id')
						<div class="invalid-feedback">{{ $message }}</div>
						@enderror
					</td>
					<td>
						<button type="submit" class="btn btn-primary" style="float:right;">Show</button>
					</td>
				</tr>
			</tbody>
		</table>
	</form>

	@if(isset($warehouse_id))
	@if($items->isEmpty())
	<p class="text-danger text-center">No items found for the selected warehouse/Category</p>
	@else


	@if($opening)
	<form action="{{ route('stock-opening.store') }}" method="POST">
		@csrf
		<input type="hidden" name="warehouse_id" value="{{ $warehouse_id }}">
		<input type="text" id="itemSearch" class="form-control mb-1" placeholder="Search items by name" style="float:right;width:210px">

		<table id="myTable" class="table table-bordered table-striped table-hover">
			<thead>
				<tr>
					<th>SL</th>
					<th>Item Name</th>
					<th></th>
				</tr>
			</thead>
			<tbody>
				@php $serial = 1; @endphp
				@foreach($items as $item)
				<tr class="item-row">
					<td>{{ $serial++ }}</td>
					<td class="item-name">{{ $item->name }}</td>
					<td>
						@if($item->variations->isNotEmpty())
						<!-- Table for items with variations -->
						<table class="table table-sm" style="margin:0">
							<thead>
								<tr>
									<th width="15%">SKU</th>
									<th width="15%">Attributes</th>
									<th>Quantity</th>
									<th>Rate(cost)</th>
									<th>Amount(cost)</th>
								</tr>
							</thead>
							<tbody>
								@foreach($item->variations as $variation)
								@php
								$stock = $variation->stocks->firstWhere('warehouse_id', $warehouse_id); // Ensure $stock is defined
								@endphp
								<tr>
									<td>
										{{ $variation->sku }}
										<input type="hidden" name="stocks[{{ $variation->id }}][item_id]" value="{{ $item->id }}">
										<input type="hidden" name="stocks[{{ $variation->id }}][variation_id]" value="{{ $variation->id }}">
										<input type="hidden" name="stocks[{{ $variation->id }}][category_id]" value="{{ $item->category_id }}">
										<input type="hidden" name="stocks[{{ $variation->id }}][current_qty]" value="{{ $stock ? $stock->available_stock : 0 }}"> <!-- Hidden input -->
									</td>
									<td>
										@foreach($variation->variationAttributes as $attribute)
										{{ $attribute->attributeValue->value }}@if(!$loop->last), @endif
										@endforeach
									</td>
									<td>
										<input type="number" name="stocks[{{ $variation->id }}][qty]" class="form-control stock-qty" placeholder="Qty" min="0" step="0.0001" value="{{ $stock ? $stock->available_stock : 0 }}">
									</td>
									<td>
										<input type="number" name="stocks[{{ $variation->id }}][purchase_price]" class="form-control purchase-price" placeholder="Purchase Price" min="0" step="0.0001" value="{{ $stock ? $stock->rate : 0 }}">
									</td>
									<td>
										<input type="number" name="stocks[{{ $variation->id }}][amount]" class="form-control amount" placeholder="{{ $stock ? $stock->amount : 0 }}" step="0.0001" readonly value="{{ $stock ? $stock->amount : 0 }}">
									</td>
								</tr>
								@endforeach

							</tbody>
						</table>
						@else
						<!-- Table for items without variations -->
						<table class="table table-sm" style="margin:0">
							<thead>
								<tr>
									<th width="30%">SKU</th>
									<th>Quantity</th>
									<th>Rate(cost)</th>
									<th>Amount(cost)</th>
								</tr>
							</thead>
							<tbody>
								<tr>
									@php
									$stock = $item->stocks->firstWhere('warehouse_id', $warehouse_id);
									@endphp
									<td>
										{{ $item->unique_code }}
										<input type="hidden" name="stocks[no_variation_{{ $item->id }}][item_id]" value="{{ $item->id }}">
										<input type="hidden" name="stocks[no_variation_{{ $item->id }}][variation_id]" value="">
										<input type="hidden" name="stocks[no_variation_{{ $item->id }}][category_id]" value="{{ $item->category_id }}">
										<input type="hidden" name="stocks[no_variation_{{ $item->id }}][current_qty]" value="{{ $stock ? $stock->available_stock : 0 }}"> <!-- Hidden input -->
									</td>
									<td>
										<input type="number" name="stocks[no_variation_{{ $item->id }}][qty]" class="form-control stock-qty" placeholder="Qty" min="0" step="0.0001" value="{{ $stock ? $stock->available_stock : 0 }}">
									</td>
									<td>
										<input type="number" name="stocks[no_variation_{{ $item->id }}][purchase_price]" class="form-control purchase-price" placeholder="Purchase Price" min="0" step="0.0001" value="{{ $stock ? $stock->rate : 0 }}">
									</td>
									<td>
										<input type="number" name="stocks[no_variation_{{ $item->id }}][amount]" class="form-control amount" placeholder="Amount" step="0.0001" readonly value="{{ $stock ? $stock->amount : 0 }}">
									</td>
								</tr>
							</tbody>
						</table>
						@endif
					</td>
				</tr>
				@endforeach
			</tbody>
		</table>
		<div style="text-align: right;">
			<button type="submit" class="btn btn-primary text-center">Save</button>
		</div>
	</form>
	@endif

	<!-- New Table with Print and Export Functionalities -->
	<h3 class="mt-5">Printable Stock Overview</h3>

	<div style="text-align: right;">
		<div style="text-align: right;">
			<button id="printButton" class="btn btn-secondary">
				<i class="fas fa-print"></i> Print
			</button>
			<button id="exportCsvButton" class="btn btn-secondary">
				<i class="fas fa-file-csv"></i> Export CSV
			</button>
			<button id="exportExcelButton" class="btn btn-secondary">
				<i class="fas fa-file-excel"></i> Export Excel
			</button>
		</div>
	</div>

	<div id="printAll">

		<table id="printTable" class="table table-bordered table-striped mt-3">
			<p class="text-center">Opening Date: {{ settings('Inventory.opening-date') ?? 'Not set' }}</p>

			<thead>
				<tr>
					<th>SL</th>
					<th>Item Name</th>
					<th>SKU</th>
					<th>Attributes</th>
					<th>Quantity</th>
					<th>Cost Rate</th>
					<th>Cost Amount</th>
				</tr>
			</thead>
			<tbody>
				@php $serial = 1; @endphp
				@foreach($items as $item)
				@if($item->variations->isNotEmpty())
				<tr>
					<td rowspan="{{ $item->variations->count() }}">{{ $serial++ }}</td>
					<td rowspan="{{ $item->variations->count() }}">{{ $item->name }}</td>
					@foreach($item->variations as $index => $variation)
					@if ($index === 0) <!-- Display only for the first variation -->
					<td>{{ $variation->sku }}</td>
					<td>
						@foreach($variation->variationAttributes as $attribute)
						{{ $attribute->attributeValue->value }}@if(!$loop->last), @endif
						@endforeach
					</td>
					<td class="text-right">
						@php
						$stock = $variation->stocks->firstWhere('warehouse_id', $warehouse_id);
						@endphp
						{{ $stock ? $stock->available_stock : 0 }}
					</td>
					<td class="text-right">
						{{ $stock ? $stock->rate : 0 }}
					</td>
					<td class="text-right">
						{{ $stock ? $stock->amount : 0 }}
					</td>
					@else
				<tr>
					<td>{{ $variation->sku }}</td>
					<td>
						@foreach($variation->variationAttributes as $attribute)
						{{ $attribute->attributeValue->value }}@if(!$loop->last), @endif
						@endforeach
					</td>
					<td class="text-right">
						@php
						$stock = $variation->stocks->firstWhere('warehouse_id', $warehouse_id);
						@endphp
						{{ $stock ? $stock->available_stock : 0 }}
					</td>
					<td class="text-right">
						{{ $stock ? $stock->rate : 0 }}
					</td>
					<td class="text-right">
						{{ $stock ? $stock->amount : 0 }}
					</td>
				</tr>
				@endif
				@endforeach
				</tr>
				@else
				@php
				$stock = $item->stocks->firstWhere('warehouse_id', $warehouse_id);
				@endphp
				<tr>
					<td>{{ $serial++ }}</td>
					<td>{{ $item->name }}</td>
					<td>{{ $item->unique_code }}</td>
					<td></td> <!-- No attributes for single items -->
					<td class="text-right">{{ $stock ? $stock->available_stock : 0 }}</td>
					<td class="text-right">{{ $stock ? $stock->rate : 0 }}</td>
					<td class="text-right">{{ $stock ? $stock->amount : 0 }}</td>
				</tr>
				@endif
				@endforeach
			</tbody>
		</table>
		@endif
		@endif

	</div>
</div>

<script>
	document.addEventListener('DOMContentLoaded', function() {
		// Calculate the amount dynamically based on quantity and purchase price
		document.addEventListener('input', function(event) {
			if (event.target.classList.contains('stock-qty') || event.target.classList.contains('purchase-price')) {
				let row = event.target.closest('tr');
				let qty = parseFloat(row.querySelector('.stock-qty').value) || 0;
				let purchasePrice = parseFloat(row.querySelector('.purchase-price').value) || 0;
				let amount = qty * purchasePrice;
				row.querySelector('.amount').value = amount.toFixed(2);
			}
		});

		// Dynamic Search Functionality
		document.getElementById('itemSearch').addEventListener('keyup', function() {
			const searchTerm = this.value.toLowerCase();
			document.querySelectorAll('.item-row').forEach(function(row) {
				const itemName = row.querySelector('.item-name').textContent.toLowerCase();
				row.style.display = itemName.includes(searchTerm) ? '' : 'none';
			});
		});

		// Print functionality
		document.getElementById('printButton').addEventListener('click', function() {
			const printContents = document.getElementById('printAll').outerHTML;
			const win = window.open('', '', 'height=500,width=800');
			win.document.write('<html><head><title>Print</title>');
			win.document.write('<style>@media print { html, body { margin: 0; padding: 0; width: 100%; } } #printTable { width: 100%; border-collapse: collapse; } #printTable th, #printTable td { border: 1px solid #000; padding: 8px;} #printTable td.text-right{text-align:right}}</style>');
			win.document.write('</head><body >');
			win.document.write(printContents);
			win.document.write('</body></html>');
			win.document.close();
			win.print();
		});

		// Export to CSV functionality
		document.getElementById('exportCsvButton').addEventListener('click', function() {
			let csvContent = "data:text/csv;charset=utf-8,";
			csvContent += "SL,Item Name,SKU,Quantity,Cost Rate,Cost Amount\n";

			const rows = document.querySelectorAll('#printTable tbody tr');
			rows.forEach(row => {
				const cols = row.querySelectorAll('td');
				const data = Array.from(cols).map((col, index) => {
					if (index === 3 || index === 4 || index === 5) {
						// Format quantity, rate, and amount to have two decimal points
						return parseFloat(col.textContent.trim()).toFixed(4); // Adjust the number of decimal points as necessary
					}
					return col.textContent.trim();
				}).join(',');
				csvContent += data + "\n";
			});

			const encodedUri = encodeURI(csvContent);
			const link = document.createElement("a");
			link.setAttribute("href", encodedUri);
			link.setAttribute("download", "stock_overview.csv");
			document.body.appendChild(link);
			link.click();
			document.body.removeChild(link);
		});

		// Export to Excel functionality (using a similar approach to CSV)
		document.getElementById('exportExcelButton').addEventListener('click', function() {
			let table = document.getElementById('printTable');
			let html = table.outerHTML.replace(/<td[^>]*>(\d+(\.\d+)?)<\/td>/g, function(match, number) {
				return match.replace(number, parseFloat(number).toFixed(4)); // Adjust the number of decimal points as necessary
			});
			let blob = new Blob([html], {
				type: 'application/vnd.ms-excel'
			});
			let url = URL.createObjectURL(blob);
			let a = document.createElement('a');
			a.href = url;
			a.download = 'stock_overview.xls';
			document.body.appendChild(a);
			a.click();
			document.body.removeChild(a);
		});

	});
</script>
@endsection