@php use App\Models\stocktransfer; @endphp
@extends('backend.layouts.app')

@section('content')

    <div class="aiz-titlebar text-left mt-2 mb-3">
        <div class="row align-items-center">
            <div class="col-md-12">
                <h1 class="h3">{{__('Stock Report')}}</h1>
            </div>
        </div>
    </div>
    <div class="row">

        <div class="col-md-10 mx-auto">
            <div class="card">

                <div class="card-body">

                    <p class="text-center"><b>Stock Rules:</b> Stock= purchase - (stock transfer + sell + supplier +
                        Stock transfer pending
                        return) + customer return + stock receive</p>

                    <table class="table table-bordered aiz-table mb-0">

                        <thead>

                        <tr>
                            <th>{{__('Product Name')}}</th>
                            <th>{{__('Purchase')}}</th>
                            <th>{{__('Stock transfer')}}</th>
                            <th>{{__('Stock Receive')}}</th>
                            <th>{{__('Stock Transfer Pending')}}</th>
                            <th>{{__('Sell')}}</th>
                            <th>{{__('Customer Return')}}</th>
                            <th>{{__('Supplier Return')}}</th>
                            <th>{{__('Current Stock')}}</th>
                        </tr>
                        </thead>
                        <tbody>

                        @foreach($products as $product )
                            <tr>
                                <td>{{$product->getTranslation('name') }}  </td>

                                @php
                                    $qty = 0;
                                    foreach ($product->stocks as $key => $stock) {
                                        if ($stock->warehouse_id==auth()->user()->warehouse_id){
                                                  $qty += $stock->qty;
                                            }
                                    }

                                    $stock_transfer=stocktransfer::where('product_id',$stock->product_id)->where('status',2)->where('from',auth()->user()->warehouse_id)->sum('qty');
                                    $stock_receive=stocktransfer::where('product_id',$stock->product_id)->where('status',2)->where('to',auth()->user()->warehouse_id)->sum('qty');
                                    $stock_pending=stocktransfer::where('product_id',$stock->product_id)->where('status',0)->where('to',auth()->user()->warehouse_id)->sum('qty');
                                   $purchase_qty = App\Models\Purchase::where('product_id',$stock->product_id)->sum('stock');
                                    $return_stock=\App\Models\RefundRequest::where('product_id',$stock->product_id)->where('refund_status',1)->sum('product_qty');
                                    $supplier_return=\App\Models\StockReturn::where('product_id',$stock->product_id)->sum('return_stock');
                                     $sell = App\Models\OrderDetail::where('product_id',$stock->product_id)->where('warehouse_id',auth()->user()->warehouse_id)->where('delivery_status','!=','cancelled')->sum('quantity');


                                @endphp


                                <td class="text-center">
                                    {{ $purchase_qty }}
                                </td>
                                <td class="text-center">{{$stock_transfer}}</td>
                                <td class="text-center">{{$stock_receive}}</td>
                                <td class="text-center">{{$stock_pending}}</td>
                                <td class="text-center">
                                    {{$sell}}

                                </td>
                                <td class="text-center">{{$return_stock}}</td>
                                <td class="text-center">{{$supplier_return}}</td>
                                <td class="text-center">
                                    {{$qty}}
                                </td>
                            </tr>

                        @endforeach

                        </tbody>
                    </table>
                    <button class="btn btn-primary float-right mt-3 print-button" onclick="window.print()"><i
                            class="las la-print"></i></button>
                </div>
            </div>
        </div>

    </div>

@endsection