@extends('admin.layouts.app')
@section('title', 'Negative Stock Closing Report')
@push('styles')
@endpush
@section('container')
    <!-- Page-Title -->
    <div class="row">
        <div class="col-sm-12">
            <div class="page-title-box">
                <div class="float-end">

                </div>
                <h4 class="page-title">Negative Stock Closing Report</h4>
            </div>
            <!--end page-title-box-->
        </div>
        <!--end col-->
    </div>
    <!-- end page title end breadcrumb -->

    <div class="row">
        @if (session('success'))
            <div class="alert alert-info">
                {{ session('success') }}
            </div>
        @endif
        @if (session('error'))
            <div class="alert alert-danger">
                {{ session('error') }}
            </div>
        @endif
    </div>
    <div class="row">
        <div class="col-md-12">
            <div class="card">
                <div class="card-header">
                    <form action="">
                        <div class="row">
                            <div class="col-md-3">
                                <div class="mb-3">
                                    <label class="col-form-label text-end">Warehouse</label>
                                    <div class="form-group">
                                        <select class="form-select" name="warehouse" aria-label="Default select example">
                                            <option value="">select warehouse</option>
                                            <option value="0" {{request()->warehouse ==  0?'selected':''}}>Live Stock</option>
                                            @foreach ($warehouses as $warehouse)
                                                <option {{request()->warehouse ==  $warehouse->id?'selected':''}} value="{{ $warehouse->id }}">{{ $warehouse->name }}</option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-2">
                                <div class="mb-3">
                                    <label class="col-form-label text-end"> Date</label>
                                    <div class=form-group">
                                        <input type="date" name="date" id="date" value="{{ old('date', request()->date??date('Y-m-d')) }}" class="form-control">
                                    </div>
                                </div>
                            </div>
                            <div class="col-2">
                                <div class="text-start">
                                    <button class="btn btn-primary" style="margin-top: 35px;" type="submit">Search</button>
                                </div>
                            </div>
                        </div>
                    </form>
                </div>


            </div>
            <!--end card-header-->
            @if(count($stocks)>0)
                <div class="row">
                    <div class="col-md-12">
                        <div class="card">
                            <div class="card-header with-border">
                                <button class="pull-right btn btn-primary" onclick="getprint('prinarea')">Print</button>
                            </div>
                        </div>
                    </div>
                </div>
                <div id="prinarea">
                    <div class="card-body">
                        <div class="card-header with-border text-center">
                            <h1 class="card-title" style="font-size: 25px;">Negative Stock Closing Report</h1>
                            <h3 class="card-title" style="font-size: 15px;">Warehouse: {{ $selected_warehouse }}</h3>
                            <h3 class="card-title" style="font-size: 15px;">Date: {{ date('d-m-Y',strtotime(request('date'))) }}</h3>
                        </div>
                        <table class="table table-bordered">
                            <tr>
                                <th>SL</th>
                                <th>Product Type</th>
                                <th>Product Sub Type</th>
                                <th>Product</th>
                                <th class="text-end d-none">Stock In</th>
                                <th class="text-end d-none">Stock Out</th>
                                <th class="text-end">Last Pur Price</th>
                                <th class="text-end">Average Pur Price</th>
                                <th class="text-end">Last Pur Stock Price</th>
                                <th class="text-end">Average Pur Stock Price</th>
                                <th class="text-end">Closing Stock(Pcs)</th>
                            </tr>
                            @php
                                $totalUnitSetStock =  0;
                                $totalLastPurPrice =  0;
                                $totalAvgPrice =  0;
                                $totalLastPurStockPrice =  0;
                                $totalAvgStockPrice =  0;
                            @endphp
                            @foreach($stocks as $index=>$stock)
                                <tr>
                                    <td>{{ $index+1 }}</td>
                                    <td>{{ $stock->product->productCategory->name??'' }}</td>
                                    <td>{{ $stock->product->productSubCategory->name??'' }}</td>
                                    <td>{{ $stock->product->name??'' }}</td>
                                    <td class="text-end d-none">{{ $stock->s_stock_in }}</td>
                                    <td class="text-end d-none">{{ $stock->s_stock_out }}</td>
                                    <td class="text-end">{{ number_format($stock->product->last_buying_price ?? '0',2)}}</td>
                                    <td class="text-end">{{ number_format($stock->product->average_buying_price ?? '0',2) }}</td>
                                    <td class="text-end">{{ number_format(($stock->product->last_buying_price*($stock->s_stock_in - $stock->s_stock_out)),2)}}</td>
                                    <td class="text-end">{{ number_format($stock->product->average_buying_price *($stock->s_stock_in - $stock->s_stock_out),2)}}</td>
                                    <td class="text-end">{{ $stock->s_stock_in - $stock->s_stock_out }}</td>
                                </tr>
                                @php
                                    $totalUnitSetStock += ($stock->s_stock_in - $stock->s_stock_out)/$stock->product->unit->quantity??1;
                                    $totalLastPurPrice += $stock->product->last_buying_price ?? 0 ;
                                    $totalAvgPrice += $stock->product->average_buying_price ?? 0 ;
                                    $totalLastPurStockPrice += $stock->product->last_buying_price * ($stock->s_stock_in - $stock->s_stock_out) ;
                                    $totalAvgStockPrice += $stock->product->average_buying_price * ($stock->s_stock_in - $stock->s_stock_out);
                                @endphp
                            @endforeach
                            <tr>
                                <th class="text-end" colspan="4">Total</th>
                                <th class="text-end d-none">{{ $stocks->sum('s_stock_in') }}</th>
                                <th class="text-end d-none">{{ $stocks->sum('s_stock_out') }}</th>
                                <th class="text-end">{{ number_format($totalLastPurPrice,2) }}</th>
                                <th class="text-end">{{ number_format($totalAvgPrice,2)}}</th>
                                <th class="text-end">{{ number_format($totalLastPurStockPrice,2) }}</th>
                                <th class="text-end">{{ number_format($totalAvgStockPrice,2)}}</th>
                                <th class="text-end">{{ $stocks->sum('s_stock_in')-$stocks->sum('s_stock_out') }}</th>
                            </tr>
                        </table>
                    </div>
                </div>
            @endif
            <!--end card-body-->
        </div>
        <!--end card-->
    </div> <!-- end col -->


    </div> <!-- end row -->
@endsection
@push('scripts')
    <script>
        var APP_URL = '{!! url()->full()  !!}';
        function getprint(print) {

            $('body').html($('#'+print).html());
            window.print();
            window.location.replace(APP_URL)
        }
        $(function () {
            $('.select2').select2();
        });
    </script>
@endpush