@extends('Reports.template')

<!--Title-->
@section('title')
Cycle Report
@endsection
<!--Title Close-->

<!--External CSS-->
@section('ExternalCss')
@parent
@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="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="13" 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="8" class="th borderNone borderBottom reportTitle">Cycle Summary Report</th>
            <th colspan="8" class="txtRight th borderNone borderBottom">
                Period : {{\Helper::getDisplayDate($fromDate)}} TO {{\Helper::getDisplayDate($toDate)}}
            </th>
        </tr>
        <tr>
            <th width="3%" class="th noPadding alignTop borderTopBottom txtRight">Sr No</th>
            <th width="6%" class="th noPadding alignTop borderTopBottom txtCenter">Cycle No</th>
            <th class="th noPadding alignTop borderTopBottom">Cycle Date Time</th>
            <th class="th noPadding alignTop borderTopBottom">Store</th>
            <th class="th noPadding alignTop borderTopBottom">Cycle By</th>
            <th class="th noPadding alignTop borderTopBottom">Product/Category</th>
            <th class="th noPadding alignTop borderTopBottom">Cycle Detail</th>
            <th class="th noPadding alignTop borderTopBottom">Zero Qty</th>
            <th class="th noPadding alignTop borderTopBottom">Cycle Status</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Product Count</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Sys Stock</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Updated Product Count</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Updated Sys Stock</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Updated Phy Stock</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Updated Diff Stock</th>
            <th width="5%" class="th noPadding alignTop borderTopBottom txtRight">Created By</th>
        </tr>
    </thead>
    <tbody>
        @php
            $i = 1;
            $sysStockTotal = $phyStockTotal = $diffStockTotal = 0;
        @endphp
                @foreach ($cycleData as $key => $cycleList)
                    @php 
                        $productWise = $cycleList->product_wise;
                        $productID = $cycleList->product_id;
                        $productName = $cycleList->product_name;
                        $categoryWise = $cycleList->category_wise;
                        $productCategoryID = $cycleList->product_category;
                        $productCategoryName = $cycleList->category_name;
                        $ptrFrom = $cycleList->ptr_from;
                        $ptrTo = $cycleList->ptr_to;
                        $product_range_from = $cycleList->product_range_from;
                        $product_range_to = $cycleList->product_range_to;
                        $cycleDetail = "";
                        $categoryOrProduct = "";
                        if($categoryWise == "Y"){
                            $cycleBy = "Category";
                            if($ptrFrom != NULL){
                                $cycleDetail = $ptrFrom."-".$ptrTo.", ";
                            }
                            $cycleDetail .= strtoupper($product_range_from."-".$product_range_to);
                            $categoryOrProduct = $productCategoryID == 0 ? "ALL" : $productCategoryName;
                        } else if($productWise == "Y"){
                            $cycleBy = "Product";
                            $cycleDetail = "";
                            $categoryOrProduct = $productName;
                        }
                        $stockDiff = "";
                        $product_with_zero_qty = $cycleList->product_with_zero_qty;
                        $system_stock_amt = $cycleList->system_stock_amt;
                        $physical_stock_amt = $cycleList->physical_stock_amt;
                        $total_product_count = $cycleList->total_product_count;
                        $status = "";
                        if($cycleList->updatedProductCount == 0){
                            $cycleStatus = "Not Submited";
                            $class = 'danger';
                            $status = "PA";
                        } else if($cycleList->pendingProductCount == 0) {
                            $cycleStatus = "Submited";
                            $class = 'success';
                            $status = "CO";
                        } else {
                            $cycleStatus = "Partial Submited";
                            $class = 'info';
                            $status = "PE";
                        }
                        
                        $sysStockTotal += $cycleList->updatedProductSysStock;
                        $phyStockTotal += $cycleList->updatedProductPhyStock;
                        
                        if($cycleList->updatedProductPhyStock != NULL){
                            $stockDiff = $cycleList->updatedProductPhyStock - $cycleList->updatedProductSysStock;
                            $diffStockTotal += $stockDiff;
                        }
                    @endphp
                    <tr>
                        <td class="td txtRight borderTopBottom">{{ $i++ }}</td>
                        <td class="td borderTopBottom txtRight"> {{ $cycleList->cc_trn_no }} &emsp;</td>
                        <td class="td borderTopBottom"> {{ \Helper::getDisplayDateTime($cycleList->created_date) }} </td>
                        <td class="td borderTopBottom"> {{ $cycleList->storeName }} </td>
                        <td class="td borderTopBottom"> {{ $cycleBy }} </td>
                        <td class="td borderTopBottom"> {{ $categoryOrProduct }} </td>
                        <td class="td borderTopBottom"> {{ $cycleDetail }} </td>
                        <td class="td borderTopBottom"> {{ $product_with_zero_qty }} </td>
                        <td class="td borderTopBottom"> {{ $cycleStatus }} </td>
                        <td class="td borderTopBottom txtRight"> {{ $total_product_count }} </td>
                        <td class="td borderTopBottom txtRight"> {{ \Helper::customAmountFormat($system_stock_amt) }} </td>
                        <td class="td borderTopBottom txtRight"> {{ $cycleList->updatedProductCount }} </td>
                        <td class="td borderTopBottom txtRight"> {{ \Helper::customAmountFormat($cycleList->updatedProductSysStock) }} </td>
                        <td class="td borderTopBottom txtRight"> {{ \Helper::customAmountFormat($cycleList->updatedProductPhyStock) }} </td>
                        <td class="td borderTopBottom txtRight"> {{ \Helper::customAmountFormat($stockDiff) }} </td>
                        <td class="td borderTopBottom txtRight"> {{ strtoupper($cycleList->created_by) }} </td>
                    </tr>
                @endforeach
                <tr>
                    <th colspan="12" class="th noPadding alignTop borderTopBottom txtRight">Total</th>
                    <th class="th noPadding alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat($sysStockTotal) }}</th>
                    <th class="th noPadding alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat($phyStockTotal) }}</th>
                    <th class="th noPadding alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat($diffStockTotal) }}</th>
                    <th class="th noPadding alignTop borderTopBottom"></th>
                </tr>
    </tbody>
    <tfoot>
    <td colspan="16" class="th smallFont noPadding alignTop borderTopBottom txtRight">{{ strtoupper(Session::get('userId'))." # ".$currentTime->format('d/m/Y H:i:s ')}}</td>    
</tfoot>
</table>
<br/><br/>
<!--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="Receipt Report">
            <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/cycleReportInput') }}" 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')
<script src="{{ asset ("/js/export_to_excel.js?$releaseVersion") }}"></script>
@endsection
<!--External JS Close-->