@extends('layouts.app')

@section('content')

<!-- start page title -->
<div class="row">
    <div class="col-12">
        <div class="page-title-box d-sm-flex align-items-center justify-content-between">
            <h4 class="mb-sm-0 font-size-18">Stock Detailed Statement </h4> 

            <div class="page-title-right">
                <ol class="breadcrumb m-0">
                    <li class="breadcrumb-item"><a href="{{ route('dashboard') }}">Dashboards</a></li> 
                    <li class="breadcrumb-item">Reports</li>
                    <li class="breadcrumb-item active">Stock Detailed Statement</li>
                </ol>
            </div>

        </div>
    </div>
</div>
<!-- end page title -->
@include('validate')
<div class="row">

    <div class="col-md-12">

        <div class="card">
            <div class="card-body">
                <h4 class="card-title mb-4">Product Detailed Statement </h4>


                <form method="POST" action="{{ route('report.productreport') }}">
                <div class="row mb-4 mt-4"> 

                    <div class="col-md-3">
                        <div class="mb-3">
                             <div class="input-group" id="from_date">
                                <input type="text" name="from_date" class="form-control" data-date-format="{{ js_app_date_format() }}" data-date-container='#from_date' data-provide="datepicker" placeholder="From Date" value="{{ $startDate }}" required>
                                <span class="input-group-text"><i class="mdi mdi-calendar"></i></span>
                            </div><!-- input-group --> 
                        </div>
                    </div>

                    <div class="col-md-3">
                        <div class="mb-3">
                              <div class="input-group" id="to_date">
                                <input type="text" name="to_date" class="form-control" data-date-format="{{ js_app_date_format() }}" data-date-container='#to_date' data-provide="datepicker" placeholder="To Date" value="{{ $endDate }}" required>
                                <span class="input-group-text"><i class="mdi mdi-calendar"></i></span>
                            </div><!-- input-group --> 
                        </div>
                    </div>

                    <div class="col-md-4">
                        <div class="mb-3">
                        <select class="form-control select2" name="branch_id" id="branch_id" data-width="100%">
                            <option value="">Branch</option>
                            @foreach ($branchData as $branch)
                            <option value="{{ $branch->id }}" @if($branch_id == $branch->id) @selected(true) @endif>{{ $branch->branch_name }}</option>
                            @endforeach
                        </select>
                        </div>
                      </div> 

                       

                      <div class="col-md-2">
                        @csrf
                        <button class="btn btn-info" type="submit">SEARCH</button>
                      </div>


                </div>
            </form>


                <div class="table-responsive">

                    <table class="table table-bordered">
                       <thead>
                        <tr>
                          <th>Product</th>
                          <th>Op Qty.</th>
                          <th class="leftclr">Pur. Qty</th>
                          <th class="leftclr">SalRet. Qty</th>
                          <th class="leftclr">Stk Trs. Qty</th> 
                          <th class="leftclr">Stk Ajd. Qty</th>
                          <th class="leftclr">Stk Con. Qty</th>
                          <th class="rightclr">Pur Retn. Qty</th>
                          <th class="rightclr">Sal. Qty</th>
                          <th class="rightclr">Stk Tran. Qty</th>
                          <th class="rightclr">Stk Con. Qty</th> 
                          <th class="rightclr">Stk Ajd. Qty</th>
                          <th>Clo. Qty.</th>
                        </tr>
                       </thead>
                       <tbody>

                        @php
$startDate=date('Y-m-d',strtotime($startDate));

$endDate=date('Y-m-d',strtotime($endDate));

                        @endphp
                        
                        @forelse ($productList as $product)
                        @php $clobal=0; @endphp 
                            <tr>
                                 <td>{{ $product->product_name ?? '' }}</td> 
                                 <td> @php $op=$product->getOpenningBalance($startDate,$branch_id); $clobal+=$op; @endphp  {{ round($op,2) }}</td>
                                 <td class="leftclr"> @php $pqty=$product->getRepPurchaseQty($startDate,$endDate,$branch_id);  $clobal+=$pqty; @endphp {{ round($pqty,2) }}</td>
                                 <td class="leftclr"> @php $srqty=$product->getRepSaleReturnQty($startDate,$endDate,$branch_id); $clobal+=$srqty; @endphp {{ round($srqty,2) }}</td>
                                 <td class="leftclr"> @php $plustktrnsqty=$product->getRepStkTransferQty($startDate,$endDate,$branch_id,'stock_in'); $clobal+=$plustktrnsqty; @endphp {{ round($plustktrnsqty,2) }}</td>
                                 <td class="leftclr"> @php $plusstkadjuqty=$product->getRepStkAdjustQty($startDate,$endDate,$branch_id,'stock_in'); $clobal+=$plusstkadjuqty; @endphp {{ round($plusstkadjuqty,2) }}</td>
                                 <td class="leftclr"> @php $plusstkconqty=$product->getRepStkConverQty($startDate,$endDate,$branch_id,'stock_in'); $clobal+=$plusstkconqty; @endphp {{ round($plusstkconqty,2) }}</td>
                                 <td class="rightclr"> @php $prqty=$product->getRepPurRetnrQty($startDate,$endDate,$branch_id);  $clobal-=$prqty; @endphp {{ round($prqty,2) }}</td>
                                 <td class="rightclr"> @php $salqty=$product->getRepSaleQty($startDate,$endDate,$branch_id); $clobal-=$salqty; @endphp {{ round($salqty,2) }}</td>
                                 <td class="rightclr"> @php $minstkTrsnqty=$product->getRepStkTransferQty($startDate,$endDate,$branch_id,'stock_out'); $clobal-=$minstkTrsnqty; @endphp {{ round($minstkTrsnqty,2) }}</td>
                                 <td class="rightclr"> @php $minstkConqty=$product->getRepStkConverQty($startDate,$endDate,$branch_id,'stock_out');  $clobal-=$minstkConqty; @endphp {{ round($minstkConqty,2) }}</td>
                                 <td class="rightclr"> @php $minStkAdjustQty=$product->getRepStkAdjustQty($startDate,$endDate,$branch_id,'stock_out'); $clobal-=$minStkAdjustQty; @endphp {{ round($minStkAdjustQty,2) }}</td>
                                 <td>{{ round($clobal,2) }}</td>
                            </tr>
                        @empty
                        <tr>
                            <td colspan="5">@lang('general.no_details_found')</td>
                         </tr>
                        @endforelse
                         
                       </tbody>

                    </table>


                </div>

                
            </div>
            <!-- end card body -->
        </div>

    </div>

</div>


@endsection