@extends('Reports.template')

<!--Title-->
@section('title')
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="2" 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="14" 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(); 

            $stockTitle = ($productstock =='All') ? Config::get('constants.reports.STOCK_STATEMENT') : Config::get('constants.reports.NEGATIVE_STOCK');
            @endphp
            <tr>

                <th colspan="6" class="th borderNone borderBottom reportTitle">{{$stockTitle}}</th>

                <th colspan="10" class="txtRight th borderNone borderBottom">As on: {{$currentTime->format('d/m/Y H:i:s ')}}</th>
            </tr>
            <tr>
                <th width="3.5%" class="th noPadding alignTop borderTopBottom txtRight">Sr</th>
                <th width="20%" class="th noPadding alignTop borderTopBottom">&nbsp;Item</th>
                <th width="7%" class="th noPadding alignTop borderTopBottom">Mfg</th>
                <th width="3%" class="th noPadding alignTop borderTopBottom">Cat</th>
                <th width="8%" 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>
                <th width="5%" class="th noPadding alignTop borderTopBottom txtRight">Unit Price (Inc. GST)</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">Sale Qty</th>
                <th width="7%" class="th noPadding alignTop borderTopBottom txtRight">Sale 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 (Inc. GST)</th>
                <th width="5%" class="th noPadding alignTop borderTopBottom txtRight">Re-Order</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;
            @endphp

            @foreach ($stockData as $key =>$stock)
            @php
            if($stock->current_stock_qty < '0')
            {
            $negativeBold = 'td bold alignTop borderTopBottom txtRight';
            }
            else
            {
            $negativeBold = 'td notBold alignTop borderTopBottom txtRight';
            }
            if($stock->product_name != $tempProductName){

            $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;

            }else{

            $srClass = 'td borderNone';
            $productNameClass = 'td borderNone';

            $srValue = '';
            $productNameValue = '';

            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 = '';
            }

            }
            @endphp
            <tr>
                <td class="{{$srClass}}">{{$srValue}}</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>
                <td class="{{$negativeBold}}">{{\Helper::customAmountFormat($stock->price_per_unit)}}</td>
                <td class="{{$negativeBold}}">{{\Helper::zeroValueToNbspSpace($stock->cum_purchase_qty)}}</td>
                <td class="{{$negativeBold}}">{{\Helper::customAmountFormat($stock->cum_purchase_amt)}}</td>
                <td class="{{$negativeBold}}">{{\Helper::zeroValueToNbspSpace($stock->cum_sale_qty)}}</td>
                <td class="{{$negativeBold}}">{{\Helper::customAmountFormat($stock->cum_sale_amt)}}</td>
                <td class="{{$negativeBold}}">{{\Helper::zeroValueToNbspSpace($stock->current_stock_qty)}}</td>
                <td class="{{$negativeBold}}">{{\Helper::customAmountFormat($stock->current_stock_amt)}}</td>
                <td class="{{$negativeBold}}">{{\Helper::zeroValueToNbspSpace($stock->product_reorder_level)}}</td>
            </tr>
            @php
            $totalUnitPrice += $stock->price_per_unit;
            $totalPurQty += $stock->cum_purchase_qty;
            $totalPurAmt += $stock->cum_purchase_amt;
            $totalSaleQty += $stock->cum_sale_qty;
            $totalSaleAmt += $stock->cum_sale_amt;
            $totalStockQty += $stock->current_stock_qty;
            $totalStocAmt += $stock->current_stock_amt;

            $tempProductName = $stock->product_name;
            $tempMfg = $stock->manufacturer_code;
            $tempCat = $stock->category_abbrev;
            @endphp
            @endforeach
            <tr>
                <td colspan="7" class="td bold borderTopBottom txtLeft"></td>
                <td class="td bold borderTopBottom txtLeft">{{"Total : "}}</td>
                <td class="td bold borderTopBottom txtRight"></td>
                <td class="td bold borderTopBottom txtRight">{{\Helper::zeroValueToNbspSpace($totalPurQty)}}</td>
                <td class="td bold borderTopBottom txtRight">{{\Helper::customAmountFormat($totalPurAmt)}}</td>
                <td class="td bold borderTopBottom txtRight">{{\Helper::zeroValueToNbspSpace($totalSaleQty)}}</td>
                <td class="td bold borderTopBottom txtRight">{{\Helper::customAmountFormat($totalSaleAmt)}}</td>
                <td class="td bold borderTopBottom txtRight">{{\Helper::zeroValueToNbspSpace($totalStockQty)}}</td>
                <td class="td bold borderTopBottom txtRight">{{\Helper::customAmountFormat($totalStocAmt)}}</td>
                <td class="td bold borderTopBottom txtRight"></td>
            </tr>
        </tbody>
        <tfoot>
        <td colspan="16" class="th smallFont noPadding alignTop borderTopBottom txtRight">{{ strtoupper(Session::get('userId'))." # ".$currentTime->format('d/m/Y H:i:s ')}}</td>
        </tfoot>
    </table>

    <!--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('Item/stockStamentReport') }}" 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-->