@extends('Reports.template')

<!--Title-->
@section('title')
@php
$reportTitle = "Product Expiry Report With Supplier Detail";
@endphp
{{$reportTitle}}
@endsection
<!--Title Close-->

<!--External CSS-->
@section('ExternalCss')
@parent
@endsection
@section('Content')
<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(); 
        @endphp
        <tr>
            <th colspan="3" class="th borderNone borderBottom reportTitle">{{$reportTitle}}</th>
            <th colspan="3" class="txtRight th borderNone borderBottom">Store : {{$storeName}}</th>
            @if($reportType == "all")
            <th colspan="3" class="txtRight th borderNone borderBottom">As on : {{\Helper::getDisplayDate($toDate)}}</th>
            @else
            <th colspan="3" class="txtRight th borderNone borderBottom">Period : {{\Helper::getDisplayDate($fromDate)}} TO {{\Helper::getDisplayDate($toDate)}}</th>
            @endif
        </tr>
        <tr>
            <th width="4%" class="th noPadding alignTop borderBottomGray txtRight">Sr No.&emsp;</th>
            <th class="th noPadding alignTop borderBottomGray">&emsp;Item Name</th>     
            <th class="th noPadding alignTop borderBottomGray">Cat</th>
            <th class="th noPadding alignTop borderBottomGray">Batch</th>
            <th class="th noPadding alignTop borderBottomGray txtRight">Exp</th>
            <th class="th noPadding alignTop borderBottomGray txtRight">SUOM</th>
            <th class="th noPadding alignTop borderBottomGray txtRight">Stock Qty&emsp;&emsp;&emsp;&emsp;</th>
            <th class="th noPadding alignTop borderBottomGray txtRight">Stock Rate (WO GST)</th>
            <th class="th noPadding alignTop borderBottomGray txtRight">Stock Amt</th>
        </tr>
        <tr>
            <th width="4%" class="th noPadding alignTop borderTopBottom txtRight">Sr No.</th>
            <th class="th noPadding alignTop borderTopBottom">&emsp;Supplier Name</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Vou No&emsp;&emsp;</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Vou Date&emsp;&emsp;</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Supp Bill No&emsp;&emsp;</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Supp Bill Date&emsp;&emsp;</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Qty</th>
            <th colspan="2" class="th noPadding alignTop borderTopBottom txtRight"></th>
        </tr>
    </thead>
    <tbody>
        @php
        $srHeader = 1;
        $oldUniqueID = '';
        $totalQty = 0;
        $totalStockAmt = 0;
        @endphp
        @foreach($productStockExpData as $stock)
        @php
        $uniqueID = $stock->product_id." ".$stock->batch_no;
        @endphp
        @if($uniqueID != $oldUniqueID)
        @if($totalQty != 0 && $oldUniqueID != '')
        <tr>
            <td colspan="6" class="td bold noPadding alignTop borderTopBottom txtRight">Total Qty : </td>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">&emsp;&emsp;{{$totalQty}}</td>
            <td colspan="2" class="td bold noPadding alignTop borderTopBottom txtRight"></td>
        </tr>
        @endif
        @php
        $sr = 1;
        $totalQty = 0;
        $stockAmt = $stock->current_stock_qty * $stock->price_per_unit_wo_gst;
        $totalStockAmt += $stockAmt;
        @endphp
        <tr>
            <td width="4%" class="td bold noPadding alignTop borderTopBottom txtRight">{{$srHeader++}}&emsp;</td>
            <td class="td bold noPadding alignTop borderTopBottom">&emsp;{{$stock->product_name}}</td>     
            <td class="td bold noPadding alignTop borderTopBottom">{{$stock->category_abbrev}}</td>
            <td class="td bold noPadding alignTop borderTopBottom">{{strtoupper($stock->batch_no)}}</td>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::getMonthYearFromDate($stock->batch_exp)}}</td>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{$stock->unit_abbrev}}</td>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::zeroValueToNbspSpace($stock->current_stock_qty)}}&emsp;&emsp;&emsp;&emsp;</td>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat4($stock->price_per_unit_wo_gst)}}</td>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($stockAmt)}}</td>
        </tr>
        @endif
        @if($stock->supplier_name != null)
        @php
        $totalQty += $stock->quantity_per_unit_suom;
        @endphp
        <tr>
            <td width="4%" class="td noPadding alignTop borderBottomGray txtRight">{{$sr++}}</td>
            <td class="td noPadding alignTop borderBottomGray">&emsp;{{$stock->supplier_name}}</td>
            <td class="td noPadding alignTop borderBottomGray txtRight">{{$trnType.($stock->trn_id ? "/" : "").$stock->trn_fyear.($stock->trn_id ? "/" : "").$stock->trn_id}}&emsp;&emsp;</td>
            <td class="td noPadding alignTop borderBottomGray txtRight">{{\Helper::getDisplayDate($stock->trn_date)}}&emsp;&emsp;</td>
            <td class="td noPadding alignTop borderBottomGray txtRight">{{$stock->purchase_bill_no}}&emsp;&emsp;</td>
            <td class="td noPadding alignTop borderBottomGray txtRight">{{\Helper::getDisplayDate($stock->purchase_bill_date)}}&emsp;&emsp;</td>
            <td class="td noPadding alignTop borderBottomGray txtRight">&emsp;&emsp;{{$stock->quantity_per_unit_suom}}</td>
            <td colspan="2" class="td noPadding alignTop borderBottomGray txtRight"></td>
        </tr>
        @endif
        @php
        $oldUniqueID = $uniqueID; 
        @endphp
        @endforeach
        @if($totalQty != 0)
        <tr>
            <td colspan="6" class="td bold noPadding alignTop borderTopBottom txtRight">Total Qty : </td>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">&emsp;&emsp;{{$totalQty}}</td>
            <td colspan="2" class="td bold noPadding alignTop borderTopBottom txtRight"></td>
        </tr>
        @endif
        <tr>
            <td colspan="8" class="td bold alignTop borderTopBottom txtRight">Total Amt : </td>
            <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalStockAmt)}}</td>
        </tr>
    </tbody>
    <tfoot>
    <td colspan="9" 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="{{$reportTitle}}">
            <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($trnType == "P")
        <a href="{{ url('Item/productExpiryInput') }}" class="no-print btn btn-danger btn-sm">
            <span class="glyphicon glyphicon-arrow-left"></span> Back
        </a>
        @else
        <a href="{{ url('StoreItem/productExpiryInput') }}" 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')
<script src="{{ asset ("/js/export_to_excel.js?$releaseVersion") }}"></script>
@endsection
<!--External JS Close-->