@extends('Reports.template')

<!--Title-->
@section('title')
    Store Product Stock Statement
@endsection
<!--Title Close-->

<!--External CSS-->
@section('ExternalCss')
    @parent
    <style>
        @media print {
            @page {
                size: A4 landscape;
            }

            table,
            th,
            td {
                font-size: 10px !important;
            }
        }
    </style>
@endsection
<!--External CSS Close-->

@section('Content')
    <!-- Your Page Content Here -->
    <div class="col-md-12 table-responsive">
        <table class="table table-responsive" style="border-top:none; border-bottom:1px solid #000; font-size:12px;">
            <thead>
                <tr>
                    <th colspan="4" class="borderNone borderBottom" style="vertical-align:center;">
                        @if ($businessEntityMasterData[0]->logo != null)
                            <!--Image-->
                            <img class="img-responsive" alt="Pharmacy Logo"
                                src="{{ 'data:image/jpeg;base64,' . base64_encode($businessEntityMasterData[0]->logo) }}" />
                        @endif
                    </th>
                    <th colspan="11" class="borderNone borderBottom txtLeft">
                        <div style="line-height:1.0;" class="heading">{{ $businessEntityMasterData[0]->name }}</div>
                        <div style="line-height:1.0;">
                            {{ $businessEntityMasterData[0]->add1 . ' ' . $businessEntityMasterData[0]->add2 . ' ' . $businessEntityMasterData[0]->city . ' : ' . $businessEntityMasterData[0]->pincode }}
                        </div>
                        <div style="line-height:1.0;">{{ 'Phone : ' . $businessEntityMasterData[0]->tel1 }}</div>
                    </th>
                </tr>
                @php
                    $currentTime = \Carbon\Carbon::now();
                    $priceHeader = 'Unit Price';
                    $stockTitle = $productstock == 'All' ? Config::get('store_constants.reports.STORE_STOCK_STATEMENT') : Config::get('store_constants.reports.STORE_NEGATIVE_STOCK_STATEMENT');
                    
                    if($productRequestedBy == "Y"){
                        $stockTitle .= ' -- Requested By ';
                    }
                    
                    if ($priceType == 'W') {
                        $stockTitle .= ' (With GST)';
                    } elseif ($priceType == 'WO') {
                        $stockTitle .= ' (Without GST)';
                    } else {
                        $stockTitle .= ' (MRP)';
                        $priceHeader = 'Unit MRP';
                    }
                @endphp
                <tr>

                    <th colspan="7" class="th borderNone borderBottom reportTitle">{{ $stockTitle }}</th>
                    <th colspan="4" class="txtRight th borderNone borderBottom">Store : {{ $storeName }}</th>
                    <th colspan="4" class="txtRight th borderNone borderBottom">As on:
                        {{ $currentTime->format('d/m/Y H:i:s ') }}</th>
                </tr>
                <tr>
                    <th width="3%" class="th noPadding alignTop borderTopBottom txtRight">Sr</th>
                    @if($productRequestedBy == "Y")
                        <th width="4%" class="th noPadding alignTop borderTopBottom txtRight">Req By</th>
                    @else 
                    <th style="width:0%;" class="th noPadding alignTop borderTopBottom txtRight"></th>
                    @endif
                    <th width="4%" class="th noPadding alignTop borderTopBottom txtRight">Pro. ID</th>
                    <th width="20%" class="th noPadding alignTop borderTopBottom">&nbsp;Product Name</th>
                    <th width="7%" class="th noPadding alignTop borderTopBottom">Mfg</th>
                    <th width="3%" class="th noPadding alignTop borderTopBottom">Cat</th>
                    <th width="5%" class="th noPadding alignTop borderTopBottom">Bin Location </th>
                    <th width="3%" class="th noPadding alignTop borderTopBottom">Batch</th>
                    <th width="3%" class="th noPadding alignTop borderTopBottom txtRight">Exp</th>
                    <th width="5%" class="th noPadding alignTop borderTopBottom">&nbsp;&nbsp;UOM</th>
                    @if($priceType != 'MRP')
                        <th width="5%" class="th noPadding alignTop borderTopBottom txtRight">&nbsp;&nbsp;MRP</th>
                    @else
                        <th width="5%" class="th noPadding alignTop borderTopBottom txtRight">&nbsp;&nbsp;</th>
                    @endif


                    <th width="5%" class="th noPadding alignTop borderTopBottom txtRight">{{ $priceHeader }}</th>
<!--                    <th width="5%" class="th noPadding alignTop borderTopBottom txtRight">Pur Qty</th>
                    <th width="7%" class="th noPadding alignTop borderTopBottom txtRight">Pur Amt</th>
                    <th width="5%" class="th noPadding alignTop borderTopBottom txtRight">Issue Qty</th>
                    <th width="7%" class="th noPadding alignTop borderTopBottom txtRight">Issue Amt</th>-->
                    <th width="5%" class="th noPadding alignTop borderTopBottom txtRight">Stock Qty</th>
                    <th width="7%" class="th noPadding alignTop borderTopBottom txtRight">Stock Amt</th>
                    <th width="5%" class="th noPadding alignTop borderTopBottom txtRight">Re-Order Qty</th>
                </tr>
            </thead>
            <tbody>
                @php
                    $sr = 1;
                    $tempProductName = '';
                    $tempMfg = '';
                    $tempCat = '';
                    $negativeBold = '';
                    $totalUnitPrice = 0;
                    $totalPurQty = 0;
                    $totalPurAmt = 0;
                    $totalSaleQty = 0;
                    $totalSaleAmt = 0;
                    $totalStockQty = 0;
                    $totalStocAmt = 0;
                    $productWiseTotalStockQty = 0;
                    $productWiseTotalStockAmt = 0;
                    $reorder_count;
                @endphp

                @foreach ($stockData as $key => $stock)
                    @if ($stock->current_stock_qty != '0')
                        @php
                            if ($stock->current_stock_qty < '0') {
                                $negativeBold = 'td bold alignTop borderTopBottom txtRight';
                            } else {
                                $negativeBold = 'td notBold alignTop borderTopBottom txtRight';
                            }
                            $productRequestedByUser = $stock->product_requested_by;
                            if ($stock->product_name != $tempProductName) {
                                $reorder_count = 1;
                                $srClass = 'td notBold alignTop borderTop txtRight';
                                $productNameClass = 'td notBold alignTop borderTop';
                            
                                $srValue = $sr++;
                                $productNameValue = $stock->product_name;
                            
                                $mfgClass = 'td notBold alignTop borderTop';
                                $mfgValue = $stock->manufacturer_code;
                            
                                $catClass = 'td notBold alignTop borderTop';
                                $catValue = $stock->category_abbrev;
                            
                                $productId = $stock->product_id;
                            } else {
                                $srClass = 'td borderNone';
                                $productNameClass = 'td borderNone';
                            
                                $srValue = '';
                                $productNameValue = '';
                                $productId = '';
                                $productRequestedByUser = '';
                            
                                if ($stock->manufacturer_code != $tempMfg) {
                                    $mfgClass = 'td notBold alignTop borderTop';
                                    $mfgValue = $stock->manufacturer_code;
                                } else {
                                    $mfgClass = 'td borderNone';
                                    $mfgValue = '';
                                }
                            
                                if ($stock->category_abbrev != $tempCat) {
                                    $catClass = 'td notBold alignTop borderTop';
                                    $catValue = $stock->category_abbrev;
                                } else {
                                    $catClass = 'td borderNone';
                                    $catValue = '';
                                }
                            }
                            $cumPurchaseQty = 0;
                            $cumSaleQty = 0;
                            $currentStockQty = 0;
                            $price = 0;
                            $cumPurchaseAmt = 0;
                            $cumSaleAmt = 0;
                            $currentStockAmt = 0;
                            
                            $cumPurchaseQty = $stock->cum_purchase_qty;
                            $cumSaleQty = $stock->cum_sale_qty;
                            $currentStockQty = $stock->current_stock_qty;
                            
                            if ($priceType == 'W') {
                                $price = $stock->price_per_unit;
                            } elseif ($priceType == 'WO') {
                                $price = $stock->price_per_unit_wo_gst;
                            } else {
                                $price = $stock->mrp_per_unit;
                            }
                            
                            $cumPurchaseAmt = $price * $cumPurchaseQty;
                            $cumSaleAmt = $price * $cumSaleQty;
                            $currentStockAmt = $price * $currentStockQty;
                        @endphp
                        
                        @if ($stock->product_name != $tempProductName && $tempProductName != '')
                            <tr>
                                <td class="th bold alignTop borderNone txtRight" colspan="12">Total</td>
                                <td class="th bold alignTop borderTopBottom txtRight"> {{ $productWiseTotalStockQty }} </td>
                                <td class="th bold alignTop borderTopBottom txtRight"> {{ \Helper::customAmountFormat4($productWiseTotalStockAmt) }}</td>
                                <td class="th bold alignTop borderTopBottom"></td>
                            </tr>
                            @php
                                $productWiseTotalStockAmt = 0;
                                $productWiseTotalStockQty = 0;
                            @endphp
                        @endif
                        <tr>
                            <td class="{{ $srClass }}">{{ $srValue }}</td>
                            @if($productRequestedBy == "Y")
                                <td class="{{ $srClass }}">{{ $productRequestedByUser }}</td>
                            @else 
                                <td style="width:0%;" class="{{ $srClass }}"></td>
                            @endif
                            <td class="{{ $srClass }}">{{ $productId }}</td>
                            <td class="{{ $productNameClass }}">{{ $productNameValue }}</td>
                            <td class="{{ $mfgClass }}">{{ $mfgValue }}</td>
                            <td class="{{ $catClass }}">{{ $catValue }}</td>
                            <td class="td notBold alignTop borderTopBottom">
                                {{ \Helper::zeroValueToNbspSpace($stock->product_bin_location) }}</td>
                            <td class="td notBold alignTop borderTopBottom">{{ strtoupper($stock->batch_no) }}</td>
                            <td class="td notBold alignTop borderTopBottom txtRight">
                                {{ \Helper::getMonthYearFromDate($stock->batch_exp) }}</td>
                            <td class="td notBold alignTop borderTopBottom">&nbsp;{{ $stock->unit_abbrev }}</td>
                            @if($priceType != 'MRP') 
                                <td class="{{ $negativeBold }}">{{ \Helper::customAmountFormat4($stock->mrp_per_unit) }}</td>
                            @else
                                <td class="{{ $negativeBold }}"></td>
                            @endif
                            <td class="{{ $negativeBold }}">{{ \Helper::customAmountFormat4($price) }}</td>
                            <!--<td class="{{ $negativeBold }}">{{ \Helper::zeroValueToNbspSpace($cumPurchaseQty) }}</td>-->
                            <!--<td class="{{ $negativeBold }}">{{ \Helper::customAmountFormat4($cumPurchaseAmt) }}</td>-->
                            <!--<td class="{{ $negativeBold }}">{{ \Helper::zeroValueToNbspSpace($cumSaleQty) }}</td>-->
                            <!--<td class="{{ $negativeBold }}">{{ \Helper::customAmountFormat4($cumSaleAmt) }}</td>-->
                            <td class="{{ $negativeBold }}">{{ \Helper::zeroValueToNbspSpace($currentStockQty) }}</td>
                            <td class="{{ $negativeBold }}">{{ \Helper::customAmountFormat4($currentStockAmt) }}</td>
                            @if($reorder_count > 0)
                                <td class="{{ $negativeBold }}">
                                {{ \Helper::zeroValueToNbspSpace($stock->product_reorder_level) }}
                                </td>
                                @php
                                    $reorder_count=0;
                                @endphp
                            @else
                            <td class="{{ $negativeBold }}"></td>
                            @endif
                        </tr>
                        @php
                            $totalUnitPrice += $price;
                            $totalPurQty += $cumPurchaseQty;
                            $totalPurAmt += $cumPurchaseAmt;
                            $totalSaleQty += $cumSaleQty;
                            $totalSaleAmt += $cumSaleAmt;
                            $totalStockQty += $currentStockQty;
                            $totalStocAmt += $currentStockAmt;
                            $productWiseTotalStockQty += $currentStockQty;
                            $productWiseTotalStockAmt += $currentStockAmt;
                            
                            $tempProductName = $stock->product_name;
                            $tempMfg = $stock->manufacturer_code;
                            $tempCat = $stock->category_abbrev;
                        @endphp
                    @endif
                @endforeach
                <tr>
                    <td class="th bold alignTop borderNone txtRight" colspan="12">Total</td>
                    <td class="th bold alignTop borderTopBottom txtRight"> {{ $productWiseTotalStockQty }} </td>
                    <td class="th bold alignTop borderTopBottom txtRight"> {{ \Helper::customAmountFormat4($productWiseTotalStockAmt) }}</td>
                    <td class="th bold alignTop borderTopBottom"></td>
                </tr>
                <tr>
                    <td colspan="10" class="td bold borderTopBottom txtLeft"></td>
                    <td class="td bold borderTopBottom txtLeft"></td>
                    <td class="td bold borderTopBottom txtRight"></td>
<!--                    <td class="td bold borderTopBottom txtRight"></td>
                    <td class="td bold borderTopBottom txtRight"></td>
                    <td class="td bold borderTopBottom txtRight"></td>
                    <td class="td bold borderTopBottom txtRight"></td>-->
                    <td class="td bold borderTopBottom txtLeft">{{ 'Total : ' }}</td>
                    <td class="td bold borderTopBottom txtRight">{{ \Helper::customAmountFormat4($totalStocAmt) }}</td>
                    <td class="td bold borderTopBottom txtRight"></td>
                </tr>
            </tbody>
            <tfoot>
                <td colspan="15" class="th smallFont noPadding alignTop borderTopBottom txtRight">
                    {{ strtoupper(Session::get('userId')) . ' # ' . $currentTime->format('d/m/Y H:i:s ') }}</td>
            </tfoot>
        </table>
        @php
            if($productRequestedBy == "Y")
                $url = url('StoreItem/storeStockStatementReqByInput');
            else 
                $url = url('StoreItem/storeStockStatementInput');
        @endphp
        
        <!--Print-->
        <div class="col-xs-12" style="margin-bottom:15px;">
            <div class="col-xs-5 col-lg-offset-5 no-print">
                <button class="btn btn-sm btn-info" id="btnexport" data-myval="{{ $stockTitle }}">
                    <span class="glyphicon glyphicon-download-alt"></span> Excel
                </button>
                <button onclick="print()" class="btn btn-sm btn-success no-print">
                    <span class="glyphicon glyphicon-print"></span> Print
                </button>
                <a href="{{ $url }}" class="no-print btn btn-danger btn-sm">
                    <span class="glyphicon glyphicon-arrow-left"></span> Back
                </a>
            </div>
        </div>

    </div>
@endsection

<!--Bootstrap Modals-->
@section('BootstrapModals')
@endsection
<!--Bootstrap Modals Close-->

<!--External JS-->
@section('ExternalJs')
@endsection
<!--External JS Close-->