@extends('Reports.template')

<!--Title-->
@section('title')
Stock / Cycle Count Report
@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 = "Stock / Cycle Count Report";
            @endphp
            <tr>
                <th colspan="8" class="th borderNone borderBottom reportTitle">Stock / Cycle Count Report (Transaction : {{$trnNo}}) </th>
                <th colspan="5" class="txtRight th borderNone borderBottom">Store : {{$storeName}}</th>
                <th colspan="2" class="txtRight th borderNone borderBottom">As on: {{$currentTime->format('d/m/Y H:i:s ')}}</th>
            </tr>
            <tr>
                <th width="4%" class="th noPadding alignTop borderTopBottom  borderRightGray txtRight">Sr</th>
                <th class="th noPadding alignTop borderTopBottom borderRightGray  borderRight">&nbsp;Item</th>
                <th class="th noPadding alignTop borderTopBottom borderRightGray  borderRight">Product ID</th>
                <th class="th noPadding alignTop borderTopBottom borderRightGray  borderRight">&nbsp;Sr No.</th>
                <th class="th noPadding alignTop borderTopBottom borderRightGray">Pkg</th>
                <th class="th noPadding alignTop borderTopBottom borderRightGray txtRight">System Stock</th>
                <th class="th noPadding alignTop borderTopBottom borderRightGray txtRight">Physical Stock</th>
                <th class="th noPadding alignTop borderTopBottom borderRightGray txtRight">Stock Difference</th>
                <th class="th noPadding alignTop borderTopBottom borderRightGray">&nbsp;&nbsp;UOM</th>
                <th class="th noPadding alignTop borderTopBottom borderRightGray">Bin Location </th>
                <th class="th noPadding alignTop borderTopBottom borderRightGray">Cat</th>
                <th class="th noPadding alignTop borderTopBottom borderRightGray">Mfg</th>
                <th class="th noPadding alignTop borderTopBottom borderRightGray txtRight">&nbsp;&nbsp;Mrp</th>
                <th class="th noPadding alignTop borderTopBottom borderRightGray txtRight">&nbsp;&nbsp;Unit Price <br/> (With GST)</th>
                <th class="th noPadding alignTop borderTopBottom borderRightGray txtRight">&nbsp;&nbsp;Unit Price <br/> (Without GST)</th>
            </tr>
        </thead>
        <tbody>
            @php
            $sr = 1;
            $sr_no = 1;
            $tempProductName = '';
            $tempMfg = '';
            $tempCat = '';
            $negativeBold = '';
            $totalUnitPrice = 0;
            $totalUnitPriceWoGst = 0;
            $totalMrp = 0;
            $totalStockQty = 0;
            @endphp

            @foreach ($stockData as $key =>$stock)
            @php
            $srNoClass = 'td notBold alignTop borderTop txtRight';
            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++;
            $srNoValue = $sr_no++;
            $productNameValue = $stock->product_name;
            $productIDValue = $stock->product_id;

            $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 = '';
            $srNoValue = $sr_no++;
            $productNameValue = '';
            $productIDValue = '';

            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}} borderTopBottomGray borderRightGray">{{$srValue}}</td>
                <td class="{{$productNameClass}} borderTopBottomGray borderRightGray">{{$productNameValue}}</td>
                <td class="{{$srNoClass}} borderTopBottomGray borderRightGray">{{$productIDValue}}</td>
                <td class="{{$srNoClass}} borderTopBottomGray borderRightGray">{{$srNoValue}}</td>
                <td class="td notBold alignTop borderTopBottomGray borderRightGray">{{"1 x ".$stock->conversion_factor}}</td>
                <td class="{{$negativeBold}} borderTopBottomGray  borderRightGray txtRight">{{\Helper::zeroValueToNbspSpace($stock->current_stock_qty)}}</td>
                <td class="{{$negativeBold}} borderTopBottomGray borderRightGray"></td>
                <td class="{{$negativeBold}} borderTopBottomGray borderRightGray"></td>
                <td class="td notBold alignTop borderTopBottomGray borderRightGray">&nbsp;{{$stock->unit_abbrev}}</td>
                <td class="td notBold alignTop borderTopBottomGray borderRightGray">{{\Helper::zeroValueToNbspSpace($stock->product_bin_location)}}</td>
                <td class="{{$catClass}} borderTopBottomGray borderRightGray">{{$catValue}}</td>
                <td class="{{$mfgClass}} borderTopBottomGray borderRightGray">{{$mfgValue}}</td>
                <td class="{{$negativeBold}} borderTopBottomGray borderRightGray txtRight">{{\Helper::customAmountFormat($stock->mrp_per_unit)}}</td>
                <td class="{{$negativeBold}} borderTopBottomGray borderRightGray txtRight">{{\Helper::customAmountFormat($stock->price_per_unit)}}</td>
                <td class="{{$negativeBold}} borderTopBottomGray borderRightGray txtRight">{{\Helper::customAmountFormat($stock->price_per_unit_wo_gst)}}</td>
            </tr>
            @php
            $totalMrp += $stock->mrp_per_unit;
            $totalUnitPrice += $stock->price_per_unit;
            $totalUnitPriceWoGst += $stock->price_per_unit_wo_gst;
            $totalStockQty += $stock->current_stock_qty;

            $tempProductName = $stock->product_name;
            $tempMfg = $stock->manufacturer_code;
            $tempCat = $stock->category_abbrev;
            @endphp
            @endforeach
            <tr>
                <td colspan="5" class="td bold borderTopGray borderRightGray txtRight">Total </td>
                <td class="td bold borderTopGray borderRightGray txtRight">{{\Helper::zeroValueToNbspSpace($totalStockQty)}}</td>
                <td class="td bold borderTopGray borderRightGray txtLeft"></td>
                <td class="td bold borderTopGray borderRightGray txtLeft"></td>
                <td class="td bold borderTopGray borderRightGray txtLeft"></td>
                <td class="td bold borderTopGray borderRightGray txtLeft"></td>
                <td class="td bold borderTopGray borderRightGray txtLeft"></td>
                <td class="td bold borderTopGray borderRightGray txtLeft"></td>
                <td class="td bold borderTopGray borderRightGray txtRight">{{\Helper::customAmountFormat($totalMrp)}}</td>
                <td class="td bold borderTopGray borderRightGray txtRight">{{\Helper::customAmountFormat($totalUnitPrice)}}</td>
                <td class="td bold borderTopGray borderRightGray txtRight">{{\Helper::customAmountFormat($totalUnitPriceWoGst)}}</td>
            </tr>
        </tbody>
        <tfoot>
        <td colspan="19" 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/stockCycleReport') }}" 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-->