@extends('layouts.master')

@section('page_title', 'Stock Report')
@section('title', 'Stock Report')
@section('main_item', 'Reports')
@section('sub_item', 'Stock Report')

@section('content')

<div class="col-12">
    <div class="card">
        <div id="accordion">

            <div class="border-bottom card-header" style="background-color: white; cursor: pointer;" data-toggle="collapse" data-target="#collapseOne" aria-expanded="true" aria-controls="collapseOne">
                <h4 class="mb-0 header-title">
                    Filter
                </h4>
            </div>


            <div id="collapseOne" class="collapse show mt-3" aria-labelledby="headingOne" data-parent="#accordion">
                <div class="card-body">
                    <form action="{{ url('reports/new/stocks/page') }}" method="get" id="filter_form">
                        <div class="row">
                            <div class="col-md-3" @if ($setting->business_location != '1') style="display: none" @endif>
                                <div class="form-group">
                                    <label class="required" style="font-weight: bold">Business Location</label>
                                    <select class="form-control select2" id="business_location_id" name="business_location_id">
                                        <option value="">All</option>
                                        @if (Auth::user()->role_id == '1')
                                        @foreach ($users_access_location as $business_location)
                                        @if ($business_location->is_active == '1')
                                        <option value="{{ $business_location->id }}" @if (request('business_location_id')==$business_location->id) selected @endif>
                                            {{ $business_location->name }}
                                        </option>
                                        @endif
                                        @endforeach
                                        @else
                                        @foreach ($users_access_location as $business_location)
                                        @if ($business_location->is_active == '1')
                                        <option value="{{ $business_location->business_location_id }}" @if (request('business_location_id')==$business_location->business_location_id) selected @endif>
                                            {{ $business_location->name }}
                                        </option>
                                        @endif
                                        @endforeach
                                        @endif
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="form-group">
                                    <label style="font-weight: bold" for="product">Product</label>
                                    <select class="form-control select2" id="product" name="product">
                                        <option value="" selected>All</option>
                                        @foreach ($products as $product)
                                        <option value="{{ $product->id }}" @if (request('product')==$product->id) selected @endif>{{ $product->product_name }}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="form-group">
                                    <label style="font-weight: bold" for="category">Category</label>
                                    <select class="form-control select2" id="product_list_filter_category_id" name="category">
                                        <option value="" selected>All</option>
                                        @foreach ($categories as $category)
                                        <option value="{{ $category->id }}" @if (request('category')==$category->id) selected @endif>{{ $category->category_name }}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="form-group">
                                    <label style="font-weight: bold" for="unit">Unit</label>
                                    <select class="form-control select2" id="product_list_filter_unit_id" name="unit">
                                        <option value="">All</option>
                                        @foreach ($units as $unit)
                                        <option value="{{ $unit->id }}" @if (request('unit')==$unit->id) selected @endif>
                                            {{ $unit->actual_name . ' (' . $unit->short_name . ')' }}
                                        </option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                        </div>
                        <!-- <div class="row">
                            <div class="col-md-3">
                                <div class="form-group">
                                    <label style="font-weight: bold" for="start_date">Start Date</label>
                                    <input type="date" class="form-control" id="start_date" name="start_date" value="{{ request('start_date') }}">
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="form-group">
                                    <label style="font-weight: bold" for="end_date">End Date</label>
                                    <input type="date" class="form-control" id="end_date" name="end_date" value="{{ request('end_date') }}">
                                </div>
                            </div>
                        </div> -->
                        <div class="row">
                            <div class="col-md-12">
                                <button type="" class="btn btn-primary px-5 py-2 submit-filters">Filter</button>
                                <a href="{{ url('reports/new/stocks/page') }}" class="btn btn-danger px-5 py-2">Reset</a>
                            </div>
                        </div>
                        <input type="hidden" name="data_type" id="data_type" value="">
                        <input type="hidden" name="login_user_id" id="login_user_id" value="{{ Auth::user()->id }}">
                    </form>
                </div>
            </div>
        </div>
    </div>
</div>
<div class="col-12">
    <div class="card">
        <div class="card-body">
            <div><button type="submit" class="btn btn-primary" id="export_export_image">Export Excel </button>
                </form>
                <a href="{{ url('orders/new_index/page') }}"
                        class="btn btn-primary float-right px-5 py-2 submit-filters" data-type="excel"
                        style="margin-right: 10px";>Download
                        Excel</a>
            </div><br class="col-md-4">
            <form action="{{ route('stock.download') }}" method="post" target="__blank">
                @csrf
                <div class="table-responsive dash-social">
                    <table id="laravel_datatable_stock" class="table table-hover">
                        <thead class="thead-dark">
                            <tr>
                                <th>SKU</th>
                                <th>Business Location</th>
                                <th>Product Name</th>
                                <th>Product Image</th>
                                <th style="text-align: center;">Attribute <br> value And Qty</th>
                                <th>Current Stock</th>
                                <th>Purchase Price</th>
                                <th>Selling Price</th>
                                <th>Current Stock Value <br> (by purchase price)</th>
                                <th>Current Stock Value <br> (by sale price)</th>
                                <th>Potential Profit</th>
                                <th>Total Unit Sold</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php
                            $total_current_stock = 0;
                            $total_purchase_value = 0;
                            $total_sale_value = 0;
                            $total_potential_profit = 0;
                            $total_units_sold = 0;
                            @endphp

                            @foreach($products as $product)
                            @php
                            $current_stock = 0;
                            $purchase_value = 0;
                            $sale_value = 0;

                            // Calculate current stock
                            $current_stock += $product->stocks->sum('qty');
                            $parent_products = App\Product::where('parent_product_id', $product->id)->get();
                            foreach ($parent_products as $parent_product) {
                            $current_stock += $parent_product->stocks->sum('qty');
                            }

                            // Calculate costs and selling prices
                            foreach ($product->stocks as $stock) {
                            $purchase_value += $stock->qty * $stock->unit_cost;
                            $sale_value += $stock->qty * $stock->unit_price;
                            }

                            $potential_profit = $sale_value - $purchase_value;

                            $min_price = $product->stocks->min('unit_price');
                            $max_price = $product->stocks->max('unit_price');
                            $selling_price = $min_price == $max_price ? number_format($min_price, 2) : number_format($min_price, 2) . ' - ' . number_format($max_price, 2);

                            $min_cost = $product->stocks->min('unit_cost');
                            $max_cost = $product->stocks->max('unit_cost');
                            $purchase_price = $min_cost == $max_cost ? number_format($min_cost, 2) : number_format($min_cost, 2) . ' - ' . number_format($max_cost, 2);

                            // Query attributes and quantities
                            $stocks = DB::table('stocks')
                            ->leftJoin('products', 'stocks.product_id', '=', 'products.id')
                            ->where('products.id', '=', $product->id)
                            ->orWhere('products.parent_product_id', $product->id)
                            ->select('stocks.qty', 'products.attribute_value')
                            ->get();

                            // Update total values
                            $total_current_stock += $current_stock;
                            $total_purchase_value += $purchase_value;
                            $total_sale_value += $sale_value;
                            $total_potential_profit += $potential_profit;
                            $total_units_sold += $product->saleItems->sum('qty');
                            @endphp
                            <tr>
                                <td>{{ $product->sku ?? 'N/A' }}</td>
                                <td>{{ $product->productHasBusinessLocations->map(function ($location) { return $location->locationDeatils->name; })->implode(', ') }}</td>
                                <td>{{ $product->product_name }}</td>
                                <td>
                                    <img style="width: 50px;height: 50px;object-fit: cover" src="{{ $product->image ? asset($product->image) : asset('img/placeholder.jpg') }}" alt="">
                                </td>
                                <td style="text-align: center;">
                                    <div class="-responsive dash-social">
                                        <table class="table table-hover">
                                            <thead class="thead-dark">
                                                <tr style="background:black; color:white;">
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach ($stocks as $stock)
                                                <tr style="text-align: center;">
                                                    <td><b>{{ $stock->attribute_value }}</b></td>
                                                    <td>{{ $stock->qty }}</td>
                                                </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                    </div>
                                </td>
                                <td>{{ $current_stock }}</td>
                                <td>{{ $purchase_price }}</td>
                                <td>{{ $selling_price }}</td>
                                <td>{{ number_format($purchase_value, 2) }}</td>
                                <td>{{ number_format($sale_value, 2) }}</td>
                                <td>{{ number_format($potential_profit, 2) }}</td>
                                <td>{{ $product->saleItems->sum('qty') }}</td>
                            </tr>
                            @endforeach
                        </tbody>
                        <tfoot style="background:rgb(232, 232, 232);">
                            <tr>
                                <td colspan="5">Total</td>
                                <td>{{ $total_current_stock }}</td>
                                <td></td>
                                <td></td>
                                <td>{{ number_format($total_purchase_value, 2) }}</td>
                                <td>{{ number_format($total_sale_value, 2) }}</td>
                                <td>{{ number_format($total_potential_profit, 2) }}</td>
                                <td>{{ $total_units_sold }}</td>
                            </tr>
                        </tfoot>
                    </table>
                </div>
                <div class="d-flex justify-content-center">
                    {!! $products->links() !!}
                </div>
        </div>
        <!--end card-body-->
    </div>
    <!--end card-->
</div>
@endsection
@section('scripts')
<script>
       $(document).on('click', '.submit-filters', function(e) {
                e.preventDefault()
                let data_type = $(this).data('type');
                $('#data_type').val(data_type);
                $('#filter_form').submit();
            });
</script>

@endsection