@extends('Reports.template')

<!--Title-->
@section('title')
@php
if ($priceType == "WO") {
$reportTitle = "Non / Slow Moving Product Report ( Rate : Without GST )";
} else if ($priceType == "W") {
$reportTitle = "Non / Slow Moving Product Report ( Rate : With GST )";
}else{
$reportTitle = "Non / Slow Moving Product Report ( Rate : MRP )";
}
@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="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="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="9" class="th borderNone borderBottom reportTitle">
                {{$reportTitle}}
            </th>
            <th colspan="3" class="th borderNone borderBottom txtRight">Store : {{$storeName}}</th>
            <th colspan="3" class="th borderNone borderBottom txtRight">As on : {{$currentTime}}</th>
        </tr>
        <tr>
            <th colspan="15" class="th borderNone borderBottom">
                Not Sold For Last {{$days}} Days
            </th>
        </tr>
        <tr>
            <th width="2%" class="th noPadding alignTop borderTopBottom txtRight">#</th>
            <th width="5%" class="th noPadding alignTop borderTopBottom">&nbsp;Req By.</th>
            <th width="6%" class="th noPadding alignTop borderTopBottom txtRight">Product ID&emsp;</th>
            <th width="19%" class="th noPadding alignTop borderTopBottom">Product Name</th>
            <th width="4%" class="th noPadding alignTop borderTopBottom">PUOM</th>
            <th width="3%" class="th noPadding alignTop borderTopBottom txtLeft">SUOM</th>
            <th width="3%" class="th noPadding alignTop borderTopBottom txtRight">Unit Price</th>
            <th width="5%" class="th noPadding alignTop borderTopBottom txtRight">Stock Qty</th>
            <th width="8%" class="th noPadding alignTop borderTopBottom txtRight">Stock Amt</th>
            <th width="8%" class="th noPadding alignTop borderTopBottom txtRight">Last Pur. Date</th>
            <th width="8%" class="th noPadding alignTop borderTopBottom txtRight">Last Pur. Vou. No</th>
            <th width="8%" class="th noPadding alignTop borderTopBottom txtRight">Not Pur. For <i>(days)</i></th>
            <th width="7%" class="th noPadding alignTop borderTopBottom txtRight">Last Sale Date</th>
            <th width="7%" class="th noPadding alignTop borderTopBottom txtRight">Last Sale Bill No</th>
            <th width="7%" class="th noPadding alignTop borderTopBottom txtRight">Not Sold For <i>(days)</i></th>
        </tr>
    </thead>
    <tbody>
        @php
        $sr = 1;
        $totalStockAmt = 0;
        @endphp
        @foreach ($deadStockData as $deadProduct)
        @php
        $totalStockAmt += $deadProduct->amount;    
        @endphp
        <tr>
            <td class="td notBold alignTop borderTopBottom txtRight">{{$sr++}}</td>
            <td class="td notBold alignTop borderTopBottom">&nbsp;{{$deadProduct->product_requested_by}}</td>
            <td class="td notBold alignTop borderTopBottom txtRight">{{$deadProduct->product_id}}&emsp;</td>
            <td class="td notBold alignTop borderTopBottom ">{{$deadProduct->product_name}}
            </td>
            <td class="td notBold alignTop borderTopBottom">{{$deadProduct->puom}}</td>
            <td class="td notBold alignTop borderTopBottom txtLeft">{{$deadProduct->suom}}</td>
            <td class="td notBold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($deadProduct->rate)}}</td>
            <td class="td notBold alignTop borderTopBottom txtRight">{{$deadProduct->current_stock}}</td>
            <td class="td notBold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($deadProduct->amount)}}</td>
            <td class="td notBold alignTop borderTopBottom txtRight">
                {{\Helper::getDisplayDate($deadProduct->last_purchase_date)}}</td>
            <td class="td notBold alignTop borderTopBottom txtRight">{{$deadProduct->last_purchase_voucher_no}}</td>
            <td class="td notBold alignTop borderTopBottom txtRight">{{$deadProduct->last_purchase_duration}}</td>
            <td class="td notBold alignTop borderTopBottom txtRight">{{\Helper::getDisplayDate($deadProduct->last_sale_date)}}
            </td>
            <td class="td notBold alignTop borderTopBottom txtRight">{{$deadProduct->last_sale_voucher_no}}</td>
            <td class="td notBold alignTop borderTopBottom txtRight">{{$deadProduct->last_sale_duration}}</td>
        </tr>
        @endforeach
        <tr>
            <td colspan="8" class="td bold alignTop borderTopBottom txtRight">Total : </td>
            <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalStockAmt)}}</td>
            <td colspan="6" class="td notBold alignTop borderTopBottom "></td>
        </tr>
    </tbody>
    <tfoot>
    <td colspan="8" class="th smallFont noPadding alignTop borderTopBottom txtLeft">
        {{"Purchase Details are shown from all stores."}}
    </td>
    <td colspan="6" 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>
        <a href="{{ url('Item/deadStockInput') }}" class="no-print btn btn-danger btn-sm">
            <span class="glyphicon glyphicon-arrow-left"></span> Back
        </a>
    </div>
</div>

@endsection

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

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