@extends('Reports.template')

<!--Title-->
@section('title')
Stock Ledger Report
@endsection
<!--Title Close-->

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

@section('Content')
<!-- Your Page Content Here -->
<table class="table table-responsive" border='0' style="border-top:none; border-bottom:1px solid #000; font-size:12px;">
    <thead>
        <tr>
            <th colspan="3" 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="16" class="borderNone borderBottom">
                <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
        if($priceType=="WO"){
        $title=" ( Rate : Without GST )";
        }else if($priceType=="W"){
        $title=" ( Rate : With GST )";
        }else{
        $title=" ( Rate : MRP )";
        }
        @endphp
        <tr>
            <th colspan="9" class="th borderNone borderBottom reportTitle">
                {{Config::get('constants.reports.STOCK_LEDGER')}}{{$title}}
            </th>
            <th colspan="5" class="txtRight th borderNone borderBottom">
                Store : {{$storeName}}
            </th>
            <th colspan="5" class="txtRight th borderNone borderBottom">
                Period : {{ \Helper::getDisplayDate($fromDate) }} TO {{ \Helper::getDisplayDate($toDate) }}
            </th>
        </tr>
        <tr>
            <th width="4%" class="th noPadding alignTop borderTop borderBottomGray txtRight">Sr.&nbsp;&nbsp;</th>
            <th class="noPadding alignTop borderTop borderBottomGray">Product Id.</th>
            <th class="th noPadding alignTop borderTop borderBottomGray">&nbsp;Item Name</th>
            <th class="noPadding alignTop borderTop borderBottomGray">Category</th>
            <th class="noPadding alignTop borderTop borderBottomGray">UOM</th>
            <th class="noPadding alignTop borderTop borderBottomGray">Bin Loc.</th>
            <th colspan="10" class="noPadding alignTop borderTop borderBottomGray txtRight"></th>
            <th class="noPadding alignTop borderTop borderBottomGray txtRight">Stock Qty</th>
            <th class="noPadding alignTop borderTop borderBottomGray txtRight">Stock Rt</th>
            <th class="th noPadding alignTop borderTop borderBottomGray txtRight">Stock Amt</th>
        </tr>
        @if($productTransactionCount >= 1)
        <tr>
            <th class="th noPadding alignTop borderTopBottom txtRight">Sr.</th>
            <th class="th noPadding alignTop borderTopBottom txtRight"></th>
            <th class="th noPadding alignTop borderTopBottom">&nbsp;{{Config::get('constants.reports.TRN_DATE')}}</th>
            <th class="th noPadding alignTop borderTopBottom"></th>
            <th class="th noPadding alignTop borderTopBottom"></th>
            <th class="th noPadding alignTop borderTopBottom"></th>
            <th class="th noPadding alignTop borderTopBottom">&nbsp;{{Config::get('constants.reports.TRN_NO')}}#</th>
            <th class="th noPadding alignTop borderTopBottom ">&nbsp;Ref No#</th>
            <th class="th noPadding alignTop borderTopBottom ">&nbsp;Batch</th>
            <th class="th noPadding alignTop borderTopBottom">Exp</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Pur Qty</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Pur Rt</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Pur Amt</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Issue Qty</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Issue Rt</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Issue Amt</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Balance Qty</th>
            <th colspan="2" class="th noPadding alignTop borderTopBottom"></th>
        </tr>
        @endif
    </thead>
    <tbody>
        @php
        $counterHeaderSr = 1;
        $counterTransactionSr = 1;

        $oldProductId = '';
        $totalPurQty = 0;
        $totalIssueQty = 0;
        $totalPurPrice = 0;
        $totalIssuePrice = 0;
        $totalOpeningStock = 0;
        $totalStockQty = 0;
        $totalStockAmt = 0;
        $totalStockRate = 0;

        $balanceQty = 0;

        @endphp
        @foreach ($productTransactionHeaderData as $key =>$productTransactionHeader)

        @php
        $counterTransactionSr = 1;
        @endphp

        @if($productTransactionHeader->h_product_id != $oldProductId)

        @if($productTransactionCount >= 1)

        @if($totalPurQty != '0' || $totalIssueQty != '0')
        <tr>
            <td colspan="11" class="td bold alignTop borderTopBottomGray txtRight">Total : {{ \Helper::zeroValueToNbspSpace($totalPurQty) }}</td>
            <td colspan="2" class="td bold alignTop  borderTopBottomGray txtRight">{{ \Helper::customAmountFormat4($totalPurPrice) }}</td>
            <td class="td bold alignTop borderTopBottomGray txtRight">{{ \Helper::zeroValueToNbspSpace($totalIssueQty) }}</td>
            <td colspan="2" class="td bold alignTop borderTopBottomGray txtRight">{{ \Helper::customAmountFormat4($totalIssuePrice) }}</td>
            <td colspan="4" class="td bold alignTop borderTopBottomGray"></td>
        </tr>
        @endif

        @if($totalStockQty != '0' || $totalStockRate != '0' || $totalStockAmt != '0')
        <tr>
            <td colspan="14" class="td bold alignTop borderTopGray"></td>
            <td colspan="2" class="td bold alignTop borderTopGray txtCenter">Closing Balance : </td>
            <td colspan="1" class="td bold alignTop borderTopGray txtRight">{{ \Helper::zeroValueToNbspSpace($totalStockQty) }}</td>
            <td colspan="1" class="td bold alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat4($totalStockRate) }}</td>
            <td colspan="1" class="td bold alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat4($totalStockAmt) }}</td>
        </tr>
        @endif

        @endif

        @php
        $transactionSr = 1;
        $totalPurQty = 0;
        $totalIssueQty = 0;
        $totalPurPrice = 0;
        $totalIssuePrice = 0;
        $totalOpeningStock = 0;
        $totalStockQty = 0;
        $totalStockAmt = 0;
        $totalStockRate = 0;

        @endphp

        <tr>
            <td colspan="1" class="td bold alignTop borderTopBottom txtRight">{{$counterHeaderSr++}}&nbsp;&nbsp;</td>
            <td class="td bold alignTop borderTopBottom txtLeft">&nbsp;{{ $productTransactionHeader->h_product_id }}</td>
            <td class="td bold alignTop borderTopBottom txtLeft">&nbsp;{{ $productTransactionHeader->h_product_name }}</td>
            <td class="td bold alignTop borderTopBottom">{{ $productTransactionHeader->h_category}}</td>
            <td class="td bold alignTop borderTopBottom">{{ $productTransactionHeader->h_suom}}</td>
            <td class="td bold alignTop borderTopBottom">{{ $productTransactionHeader->product_bin_location}}</td>
            <td colspan="8" class="td bold alignTop borderTopBottom txtCenter"></td>
            <td colspan="2" class="td bold alignTop borderTopBottom txtCenter">Opening Balance : </td>
            <td class="td alignTop borderTopBottom txtRight">{{ $productTransactionHeader->h_opening_stock}}</td>
            <td class="td alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat4($productTransactionHeader->h_opening_rate) }}</td>
            <td class="td alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat4($productTransactionHeader->h_opening_price) }}</td>
        </tr>

        @php
        $balanceQty = floatval($productTransactionHeader->h_opening_stock);
        @endphp

        @endif
        @foreach ($productTransactionData as $key =>$productTransaction)
        @if ($productTransactionHeader->h_product_id == $productTransaction->product_id)

        @if ($productTransaction->pur_qty > 0)
        @php
        $balanceQty += floatval($productTransaction->pur_qty);       
        @endphp
        @elseif ($productTransaction->issue_qty > 0)
        @php
        $balanceQty -= floatval($productTransaction->issue_qty);       
        @endphp
        @endif
        <tr>
            <td class="td notBold alignTop borderTopGray txtRight">{{ $counterTransactionSr++ }}</td>
            <td class="td notBold alignTop borderTopGray"></td>
            <td class="td notBold alignTop borderTopGray">&nbsp;{{ \Helper::getDisplayDate($productTransaction->trn_date) }}</td>
            <td class="td notBold alignTop borderTopGray"></td>
            <td class="td notBold alignTop borderTopGray"></td>
            <td class="td notBold alignTop borderTopGray"></td>
            <td class="td notBold alignTop borderTopGray">{{ $productTransaction->trn_type."/".$productTransaction->trn_fyear."/".$productTransaction->trn_id }}</td>
            <td class="td notBold alignTop borderTopGray">{{ $productTransaction->reference_no }}</td>
            <td class="td notBold alignTop borderTopGray">{{ $productTransaction->batch_no }}</td>
            <td class="td notBold alignTop borderTopGray">{{ \Helper::getMonthYearFromDate($productTransaction->batch_exp) }}</td>
            <td class="td notBold alignTop borderTopGray txtRight">{{ $productTransaction->pur_qty }}</td>
            <td class="td notBold alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat4($productTransaction->pur_rate) }}</td>
            <td class="td notBold alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat4($productTransaction->pur_price) }}</td>
            <td class="td notBold alignTop borderTopGray txtRight">{{ \Helper::zeroValueToNbspSpace($productTransaction->issue_qty) }}</td>
            <td class="td notBold alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat4($productTransaction->issue_rate) }}</td>
            <td class="td notBold alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat4($productTransaction->issue_price) }}</td>
            <td class="td notBold alignTop borderTopGray txtRight">{{ $balanceQty }}</td>
            <td colspan="2" class="td notBold alignTop borderTopGray txtRight"></td>
        </tr>
        @php
        $totalPurQty += floatval($productTransaction->pur_qty);
        $totalIssueQty += floatval($productTransaction->issue_qty);
        $totalPurPrice += floatval($productTransaction->pur_price);
        $totalIssuePrice += floatval($productTransaction->issue_price);
        $totalOpeningStock = floatval($productTransactionHeader->h_opening_stock);
        $totalStockQty = $totalOpeningStock + $totalPurQty - $totalIssueQty;

        $totalStockRate = $productTransactionHeader->stock_avg_rate;
        $totalStockAmt = $totalStockRate * $totalStockQty;

        $oldProductId = $productTransactionHeader->h_product_id;

        @endphp
        @endif
        @endforeach
        @endforeach

        @if($productTransactionCount >= 1)

        @if($totalPurQty != '0' || $totalIssueQty != '0')
        <tr>
            <td colspan="11" class="td bold alignTop borderTopBottom txtRight">Total : {{ $totalPurQty }}</td>
            <td colspan="2" class="td bold alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat4($totalPurPrice) }}</td>
            <td class="td bold alignTop borderTopBottom txtRight">{{ $totalIssueQty }}</td>
            <td colspan="2" class="td bold alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat4($totalIssuePrice) }}</td>
            <td colspan="4" class="td bold alignTop borderTopBottom"></td>
        </tr>
        @endif

        @if($totalStockQty != '0' || $totalStockRate != '0' || $totalStockAmt != '0')
        <tr>
            <td colspan="14" class="td bold alignTop borderTopGray"></td>
            <td colspan="2" class="td bold alignTop borderTopGray txtCenter">Closing Balance : </td>
            <td colspan="1" class="td bold alignTop borderTopGray txtRight">{{ $totalStockQty }}</td>
            <td colspan="1" class="td bold alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat4($totalStockRate) }}</td>
            <td colspan="1" class="td bold alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat4($totalStockAmt) }}</td>
        </tr>
        @endif

        @endif
    </tbody>
    <tfoot>
        @php 
        $currentTime  = \Carbon\Carbon::now(); 
        @endphp
    <td colspan="19" class="th smallFont noPadding alignTop borderTop 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="{{Config::get('constants.reports.STOCK_LEDGER')}}">
            <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>
        @if($freezeOption == 1)
        <a href="{{ url('StoreItem/storeStockLedgerInputWithFreeze') }}" class="no-print btn btn-danger btn-sm">
            <span class="glyphicon glyphicon-arrow-left"></span> Back
        </a>
        @else
        <a href="{{ url('StoreItem/storeStockLedgerInput') }}" class="no-print btn btn-danger btn-sm">
            <span class="glyphicon glyphicon-arrow-left"></span> Back
        </a>
        @endif
    </div>
</div>

@endsection

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

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