@extends('Reports.template')

<!--Title-->
@section('title')
{{$reportTitle}}
@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" 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="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">
                {{$reportTitle}}{{$title}}
            </th>
            <th colspan="4" 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 borderBottom txtRight">Sr.&nbsp;&nbsp;</th>
            <th width="5%" class="th noPadding alignTop borderTop borderBottom txtRight">Product Id &nbsp;&nbsp;&nbsp;</th>
            <th width="15%" colspan="3" class="th noPadding alignTop borderTop borderBottom">&nbsp;Product Name</th>
            <th class="th noPadding alignTop borderTop borderBottom">Category</th>
            <th class="th noPadding alignTop borderTop borderBottom txtRight">UOM</th>
            <th class="th noPadding alignTop borderTop borderBottom txtRight">Bin Loc.</th>
            <th class="th noPadding alignTop borderTop borderBottom txtRight">Op Stock Qty</th>
            <th class="th noPadding alignTop borderTop borderBottom txtRight">Op Stock Rt</th>
            <th class="th noPadding alignTop borderTop borderBottom txtRight">Op Stock Amt</th>
            <th class="th noPadding alignTop borderTop borderBottom txtRight">Pur Qty</th>
            <th class="th noPadding alignTop borderTop borderBottom txtRight">Pur Amt</th>
            <th class="th noPadding alignTop borderTop borderBottom txtRight">Issue Qty</th>
            <th class="th noPadding alignTop borderTop borderBottom txtRight">Issue Amt</th>
            <th class="th noPadding alignTop borderTop borderBottom txtRight">Cl Stock Qty</th>
            <th class="th noPadding alignTop borderTop borderBottom txtRight">Cl Stock Rt</th>
            <th class="th noPadding alignTop borderTop borderBottom txtRight">Cl Stock Amt</th>
        </tr>
    </thead>
    <tbody>
        @php
        $counterHeaderSr = 1;
        $finalTotalOpeningStockQty = 0;
        $finalTotalOpeningStockRate = 0;
        $finalTotalOpeningStockAmt = 0;
        $finalTotalPurQty = 0;
        $finalTotalIssueQty = 0;
        $finalTotalPurPrice = 0;
        $finalTotalIssuePrice = 0;
        $finalTotalOpeningStock = 0;
        $finalTotalStockQty = 0;
        $finalTotalStockRate = 0;
        $finalTotalStockAmt = 0;
        @endphp
        @foreach ($productTransactionHeaderData as $key =>$productTransactionHeader)
        @php
        $totalStockQty = $productTransactionHeader->h_opening_stock + ($productTransactionHeader->h_total_pur_qty - $productTransactionHeader->h_total_issue_qty);
        $totalStockRate = $productTransactionHeader->stock_avg_rate;
        if($productTransactionHeader->stock_avg_rate == 0){
        $totalStockRate = $productTransactionHeader->h_opening_rate; 
        }
        $totalStockAmt = $totalStockRate * $totalStockQty;
        @endphp
        <tr>
            <td class="td alignTop borderTopGray txtRight">{{$counterHeaderSr++}}&nbsp;&nbsp;</td>
            <td class="td alignTop borderTopGray txtRight">{{ $productTransactionHeader->h_product_id }}&nbsp;&nbsp;</td>
            <td colspan="3" class="td alignTop borderTopGray">{{ $productTransactionHeader->h_product_name }}</td>
            <td class="td alignTop borderTopGray">{{ $productTransactionHeader->h_category }}</td>
            <td class="td alignTop borderTopGray txtRight">{{ $productTransactionHeader->h_suom }}</td>
            <td class="td alignTop borderTopGray txtRight">{{ $productTransactionHeader->product_bin_location }}</td>
            <td class="td alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat4($productTransactionHeader->h_opening_stock) }}</td>
            <td class="td alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat4($productTransactionHeader->h_opening_rate) }}</td>
            <td class="td alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat4($productTransactionHeader->h_opening_price) }}</td>
            <td class="td alignTop borderTopGray txtRight">{{ \Helper::zeroValueToNbspSpace($productTransactionHeader->h_total_pur_qty) }}</td>
            <td class="td alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat4($productTransactionHeader->h_total_pur_amt) }}</td>
            <td class="td alignTop borderTopGray txtRight">{{ \Helper::zeroValueToNbspSpace($productTransactionHeader->h_total_issue_qty) }}</td>
            <td class="td alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat4($productTransactionHeader->h_total_issue_amt) }}</td>
            <td class="td alignTop borderTopGray txtRight">{{ \Helper::zeroValueToNbspSpace($totalStockQty) }}</td>
            <td class="td alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat4($totalStockRate) }}</td>
            <td class="td alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat4($totalStockAmt) }}</td>
        </tr>
        @php
        $finalTotalOpeningStockQty += $productTransactionHeader->h_opening_stock;
        $finalTotalOpeningStockRate += $productTransactionHeader->h_opening_rate;
        $finalTotalOpeningStockAmt += $productTransactionHeader->h_opening_price;

        $finalTotalPurQty += $productTransactionHeader->h_total_pur_qty;
        $finalTotalIssueQty += $productTransactionHeader->h_total_issue_qty;
        $finalTotalPurPrice += $productTransactionHeader->h_total_pur_amt;
        $finalTotalIssuePrice += $productTransactionHeader->h_total_issue_amt;

        $finalTotalStockQty += $totalStockQty;
        $finalTotalStockRate +=  $totalStockRate;
        $finalTotalStockAmt += $totalStockAmt;
        @endphp
        @endforeach

        <tr>
            <td colspan="8" class="td bold alignTop borderTopGray txtRight">&nbsp;{{ "Total : " }}</td>
            <td class="td bold alignTop borderTopGray txtRight"></td>
            <td class="td bold alignTop borderTopGray txtRight"></td>
            <td class="td bold alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat4($finalTotalOpeningStockAmt) }}</td>
            <td class="td bold alignTop borderTopGray txtRight"></td>
            <td class="td bold alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat4($finalTotalPurPrice) }}</td>
            <td class="td bold alignTop borderTopGray txtRight"></td>
            <td class="td bold alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat4($finalTotalIssuePrice) }}</td>
            <td class="td bold alignTop borderTopGray txtRight"></td>
            <td class="td bold alignTop borderTopGray txtRight"></td>
            <td class="td bold alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat4($finalTotalStockAmt) }}</td>
        </tr>

    </tbody>
    <tfoot>
        @php 
        $currentTime  = \Carbon\Carbon::now(); 
        @endphp
    <td colspan="18" class="th smallFont noPadding alignTop borderTop txtRight">{{ strtoupper(Session::get('userId'))." # ".$currentTime->format('d/m/Y H:i:s ')}}</td>
</tfoot>
</table>

@php
$summaryPurQty = 0;
$summaryPurAmt = 0;
$summaryIssueQty = 0;
$summaryIssueAmt = 0;
@endphp
<div class="col-md-7 col-md-offset-2">
    <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="6" 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>
            <tr>
                <th colspan="3" class="th borderNone borderBottom reportTitle">
                    {{'Transaction Wise Stock Summary'}}
                </th>
                <th colspan="2" class="txtRight th borderNone borderBottom">
                    Store : {{$storeName}}
                </th>
                <th colspan="2" class="txtRight th borderNone borderBottom">
                    Period : {{ \Helper::getDisplayDate($fromDate) }} TO {{ \Helper::getDisplayDate($toDate) }}
                </th>
            </tr>
            <tr>
                <th class="th noPadding alignTop borderTop borderBottom">Trn Type</th>
                <th class="th noPadding alignTop borderTop borderBottom">&nbsp;Store Name</th>
                <th class="th noPadding alignTop borderTop borderBottom">Ledger Type</th>
                <th class="th noPadding alignTop borderTop borderBottom txtRight">Pur Qty</th>
                <th class="th noPadding alignTop borderTop borderBottom txtRight">Pur Amt</th>
                <th class="th noPadding alignTop borderTop borderBottom txtRight">Issue Qty</th>
                <th class="th noPadding alignTop borderTop borderBottom txtRight">Issue Amt</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($trnWiseSummaryData as $key =>$trnWiseSummary)
            @php
            $summaryPurQty += $trnWiseSummary->total_pur_qty;
            $summaryPurAmt += $trnWiseSummary->total_pur_amt;
            $summaryIssueQty += $trnWiseSummary->total_issue_qty;
            $summaryIssueAmt += $trnWiseSummary->total_issue_amt;
            @endphp
            <tr>
                <td class="td alignTop borderTopGray">{{$trnWiseSummary->trn_type}}</td>
                <td class="td alignTop borderTopGray">{{$trnWiseSummary->gm_description}}</td>
                <td class="td alignTop borderTopGray">{{$trnWiseSummary->ledger_type}}</td>
                <td class="td alignTop borderTopGray txtRight">{{ \Helper::zeroValueToNbspSpace($trnWiseSummary->total_pur_qty) }}</td>
                <td class="td alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat4($trnWiseSummary->total_pur_amt) }}</td>
                <td class="td alignTop borderTopGray txtRight">{{ \Helper::zeroValueToNbspSpace($trnWiseSummary->total_issue_qty) }}</td>
                <td class="td alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat4($trnWiseSummary->total_issue_amt) }}</td>
            </tr>
            @endforeach
            <tr>
                <td class="td bold alignTop borderTopGray"></td>
                <td class="td bold alignTop borderTopGray"></td>
                <td class="td bold alignTop borderTopGray"></td>
                <td class="td bold alignTop borderTopGray txtRight">{{ \Helper::zeroValueToNbspSpace($summaryPurQty) }}</td>
                <td class="td bold alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat4($summaryPurAmt) }}</td>
                <td class="td bold alignTop borderTopGray txtRight">{{ \Helper::zeroValueToNbspSpace($summaryIssueQty) }}</td>
                <td class="td bold alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat4($summaryIssueAmt) }}</td>
            </tr>
        </tbody>
        <tfoot>
            @php 
            $currentTime  = \Carbon\Carbon::now(); 
            @endphp
        <td colspan="15" class="th smallFont noPadding alignTop borderTop txtRight">{{ strtoupper(Session::get('userId'))." # ".$currentTime->format('d/m/Y H:i:s ')}}</td>
        </tfoot>
    </table>
</div>

<!--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-->