@extends('Reports.template')

<!--Title-->
@section('title')
Cycle Count Stock Adjustment Report - Item Wise
@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 = "Cycle Count Stock Adjustment Report - Item Wise";
            @endphp
            <tr>
                <th colspan="10" class="th borderNone borderBottom reportTitle">Cycle Count Stock Adjustment Report - Item Wise </th>
                <th colspan="4" class="txtRight th borderNone borderBottom">Store : {{$storeName}}</th>
                <th colspan="7" class="txtRight th borderNone borderBottom borderTop">
                    Period : {{\Helper::getDisplayDate($fromDate)}} TO {{\Helper::getDisplayDate($toDate)}}
                </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">Cycle No</th>
                <th class="th noPadding alignTop borderTopBottom borderRightGray  borderRight">Cycle Date</th>
                <th class="th noPadding alignTop borderTopBottom borderRightGray">Batch</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">System Amount <br/> (Without GST)</th>
                <th class="th noPadding alignTop borderTopBottom borderRightGray txtRight">Physical Stock</th>
                <th class="th noPadding alignTop borderTopBottom borderRightGray txtRight">Physical Amount <br/> (Without GST)</th>
                <th class="th noPadding alignTop borderTopBottom borderRightGray txtRight">Stock Difference</th>
                <th class="th noPadding alignTop borderTopBottom borderRightGray txtRight">Stock Difference Amount <br/> (Without GST)</th>
                <th class="th noPadding alignTop borderTopBottom borderRightGray txtRight">Exp</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;
            $tempProductId = 0;
            $tempProductName = '';
            $tempMfg = '';
            $tempCat = '';
            $negativeBold = '';
            $systemStockAmount = 0;
            $physicalStockAmount = 0;
            $StockDiffStockAmount = 0;

            $totalSystemAmount = 0;
            $totalPhysicalAmount = 0;
            $totalStockDiffAmount = 0;

            $totalSystemQty = 0;
            $totalPhysicalQty = 0;
            $totalStockDiffQty = 0;

            $finalTotalSystemAmount = 0;
            $finalTotalPhysicalAmount = 0;
            $finalTotalStockDiffAmount = 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';
            }

            $systemStockAmount = floatval($stock->unit_price_wo_gst) * floatval($stock->system_stock);
            $physicalStockAmount = floatval($stock->unit_price_wo_gst) * floatval($stock->physical_stock);
            $StockDiffStockAmount = floatval($stock->unit_price_wo_gst) * floatval($stock->diff_stock);

            $finalTotalSystemAmount += $systemStockAmount;
            $finalTotalPhysicalAmount += $physicalStockAmount;
            $finalTotalStockDiffAmount += $StockDiffStockAmount;

            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

            @if($stock->product_id != $tempProductId && $tempProductId != 0)
            <tr>
                <td colspan="7" class="td bold borderTopBottomGray borderRightGray txtRight">{{"Total "}} &nbsp;&nbsp;</td>
                <td class="td bold borderTopBottomGray borderRightGray txtRight">{{$totalSystemQty}}</td>
                <td class="td bold borderTopBottomGray borderRightGray txtRight">{{\Helper::customAmountFormat2($totalSystemAmount)}}</td>
                <td class="td bold borderTopBottomGray borderRightGray txtRight">{{$totalPhysicalQty}}</td>
                <td class="td bold borderTopBottomGray borderRightGray txtRight">{{\Helper::customAmountFormat2($totalPhysicalAmount)}} </td>
                <td class="td bold borderTopBottomGray borderRightGray txtRight">{{$totalStockDiffQty}}</td>
                <td class="td bold borderTopBottomGray borderRightGray txtRight">{{\Helper::customAmountFormat2($totalStockDiffAmount)}} </td>
                <td colspan="8" class="td bold borderTopBottomGray borderRightGray txtLeft"></td>
            </tr>
            @php
            $totalSystemAmount = $systemStockAmount;
            $totalPhysicalAmount = $physicalStockAmount;
            $totalStockDiffAmount = $StockDiffStockAmount;  

            $totalSystemQty = $stock->system_stock;
            $totalPhysicalQty = $stock->physical_stock;
            $totalStockDiffQty = $stock->diff_stock;
            @endphp
            @else
            @php
            $totalSystemAmount += $systemStockAmount;
            $totalPhysicalAmount += $physicalStockAmount;
            $totalStockDiffAmount += $StockDiffStockAmount;    

            $totalSystemQty += $stock->system_stock;
            $totalPhysicalQty += $stock->physical_stock;
            $totalStockDiffQty += $stock->diff_stock;
            @endphp
            @endif

            <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">{{$stock->cc_trn_no}}</td>
                <td class="{{$srNoClass}} borderTopBottomGray borderRightGray">{{\Helper::getDisplayDate($stock->created_date)}}</td>
                <td class="td notBold alignTop borderTopBottomGray borderRightGray">{{strtoupper($stock->batch_no)}}</td>
                <td class="td notBold alignTop borderTopBottomGray borderRightGray">{{" 1x".$stock->conversion_factor}}</td>
                <td class="{{$negativeBold}} borderTopBottomGray  borderRightGray txtRight">{{$stock->system_stock}}</td>
                <td class="{{$negativeBold}} borderTopBottomGray  borderRightGray txtRight">{{\Helper::customAmountFormat2($systemStockAmount)}}</td>
                <td class="{{$negativeBold}} borderTopBottomGray borderRightGray">{{$stock->physical_stock}}</td>
                <td class="{{$negativeBold}} borderTopBottomGray borderRightGray">{{\Helper::customAmountFormat2($physicalStockAmount)}}</td>
                <td class="{{$negativeBold}} borderTopBottomGray borderRightGray">{{$stock->diff_stock}}</td>
                <td class="{{$negativeBold}} borderTopBottomGray borderRightGray">{{\Helper::customAmountFormat2($StockDiffStockAmount)}}</td>
                <td class="td notBold alignTop borderTopBottomGray borderRightGray txtRight">{{\Helper::getMonthYearFromDate($stock->batch_exp)}}</td>
                <td class="td notBold alignTop borderTopBottomGray borderRightGray">&nbsp;{{$stock->unit_abbrev}}</td>
                <td class="td notBold alignTop borderTopBottomGray borderRightGray">{{$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::customAmountFormat2($stock->mrp_per_unit)}}</td>
                <td class="{{$negativeBold}} borderTopBottomGray borderRightGray txtRight">{{\Helper::customAmountFormat2($stock->unit_price)}}</td>
                <td class="{{$negativeBold}} borderTopBottomGray borderRightGray txtRight">{{\Helper::customAmountFormat2($stock->unit_price_wo_gst)}}</td>
            </tr>

            @php
            $tempProductId = $stock->product_id;
            $tempProductName = $stock->product_name;
            $tempMfg = $stock->manufacturer_code;
            $tempCat = $stock->category_abbrev;
            @endphp

            @endforeach
            <tr>
                <td colspan="7" class="td bold borderTopBottomGray borderRightGray txtRight">{{"Total "}} &nbsp;&nbsp;</td>
                <td class="td bold borderTopBottomGray borderRightGray txtRight">{{$totalSystemQty}}</td>
                <td class="td bold borderTopBottomGray borderRightGray txtRight">{{\Helper::customAmountFormat2($totalSystemAmount)}}</td>
                <td class="td bold borderTopBottomGray borderRightGray txtRight">{{$totalPhysicalQty}}</td>
                <td class="td bold borderTopBottomGray borderRightGray txtRight">{{\Helper::customAmountFormat2($totalPhysicalAmount)}} </td>
                <td class="td bold borderTopBottomGray borderRightGray txtRight">{{$totalStockDiffQty}}</td>
                <td class="td bold borderTopBottomGray borderRightGray txtRight">{{\Helper::customAmountFormat2($totalStockDiffAmount)}} </td>
                <td colspan="8" class="td bold borderTopBottomGray borderRightGray txtLeft"></td>
            </tr>
            <tr>
                <td colspan="8" class="td bold borderTopBottomGray borderRightGray txtRight">{{"Final Total "}} &nbsp;&nbsp;</td>
                <td class="td bold borderTopBottomGray borderRightGray txtRight">{{\Helper::customAmountFormat2($finalTotalSystemAmount)}}</td>
                <td class="td bold borderTopBottomGray borderRightGray txtRight"></td>
                <td class="td bold borderTopBottomGray borderRightGray txtRight">{{\Helper::customAmountFormat2($finalTotalPhysicalAmount)}} </td>
                <td class="td bold borderTopBottomGray borderRightGray txtRight"></td>
                <td class="td bold borderTopBottomGray borderRightGray txtRight">{{\Helper::customAmountFormat2($finalTotalStockDiffAmount)}} </td>
                <td colspan="8" class="td bold borderTopBottomGray borderRightGray txtLeft"></td>
            </tr>
        </tbody>
        <tfoot>
        <td colspan="23" 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/stockCycleReportItemWise') }}" 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-->