@extends('Reports.template')

<!--Title-->
@section('title')
@if($reportType == "reorder")
@php
$reportTitle = "Medicine Reorder Report (Product Reorder Value Wise)";
@endphp
@else
@php
$reportTitle = "Medicine Reorder Report (Product Consumption Wise)";
@endphp
@endif
{{__($reportTitle)}}
@endsection
<!--Title Close-->

<!--External CSS-->
@section('ExternalCss')
@parent
<style>
    @media print {
        @page { size: A4 portrait;}
        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"  id="data">
    <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;">
                    <!--Image--> 
                    <img class="img-responsive" alt="Pharmacy Logo" src="{{"data:image/jpeg;base64,".base64_encode( $businessEntityMasterData[0]->logo )}}"/>
                </th>
                <th colspan="15" 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">
                    {{__($reportTitle)}}
                </th>
                <th colspan="3" class="txtRight th borderNone borderBottom">
                    {{__('Store')}} : {{$storeName}}
                </th>
                @if($reportType == "reorder")
                <th colspan="6" class="txtRight th borderNone borderBottom">
                    {{__('As on')}} : {{$currentTime->format('d/m/Y H:i:s ')}}
                </th>
                @else
                <th colspan="6" class="txtRight th borderNone borderBottom">
                    {{__('Period Of')}} {{$day}} {{__('Days From')}} : {{\Helper::getDisplayDate($fromDate)}} {{__('To')}} {{\Helper::getDisplayDate($toDate)}}
                </th>
                @endif
            </tr>
            <tr>
                <th width="4%" class="th noPadding alignTop borderTopBottom">{{__('Sr No')}}</th>
                <th colspan="2" class="th noPadding alignTop borderTopBottom txtLeft">{{__('Item Name')}}</th>
                <th colspan="2" class="th noPadding alignTop borderTopBottom txtLeft">{{__('Generic Drug')}}</th>
                <th width="3%" class="th noPadding alignTop borderTopBottom">{{__('Pack')}}</th>
                <th colspan="2" class="th noPadding alignTop borderTopBottom">{{__('Last Supp Name')}}</th>
                <th class="th noPadding alignTop borderTopBottom">{{__('Last Voucher No')}}</th>
                <th class="th noPadding alignTop borderTopBottom txtRight">{{__('Last MRP')}}</th>
                <th class="th noPadding alignTop borderTopBottom txtRight">{{__('Last Rate')}}</th>
                <th class="th noPadding alignTop borderTopBottom txtRight">{{__('Curr. Stock')}}</th>
                <th class="th noPadding alignTop borderTopBottom txtRight">{{__('Reorder Value')}}</th>
                <th class="th noPadding alignTop borderTopBottom txtRight">{{__('Total Sale')}}</th>
                <th class="th noPadding alignTop borderTopBottom txtRight">{{__('Avg/Day Sale')}}</th>
                <th class="th noPadding alignTop borderTopBottom txtRight">{{__('Stock for # Days')}}</th>
                <th class="th noPadding alignTop borderTopBottom txtRight">{{__('Reorder Qty')}}</th>
            </tr>
        </thead>
        <tbody>
            @php
            $sr = 1;
            $qty = 0;
            $avgDay = 0;
            $addReq = 0;
            $productArray = array();
            $reorderQtyArray = array();
            @endphp

            @foreach($medicineReorderData as $product)
            @foreach($stockReorder as $stock)

            @if($product->product_id == $stock->product_id)

            @if($reportType != 'reorder')
            @php
            $qty = $product->quantity;
            $avgDay = round($product->quantity/$day,2);
            $qtyForDays = '-';
            if ($avgDay > 0) {
            if ($stock->current_stock_qty <= 0) {
            $qtyForDays = 0;    
            } else {
            $qtyForDays = round($stock->current_stock_qty/$avgDay);
            }
            }
            $addReq = $product->quantity - $stock->current_stock_qty;
            if ($addReq > 0) {
            array_push($productArray, $product->product_id);
            array_push($reorderQtyArray, $addReq);
            }
            @endphp
            @if($addReq < 0)
            @php
            $addReq= '-';
            @endphp
            @endif

            @else
            @php
            $checkDiff = $stock->product_reorder_level - $stock->current_stock_qty;
            if($checkDiff > 0){
                array_push($productArray, $product->product_id);
                array_push($reorderQtyArray, $stock->product_reorder_level);
                $addReq = $stock->product_reorder_level;
            } else {
                $addReq = '';
            }
            $qty = '';
            $avgDay = '';
            $qtyForDays = '';
            @endphp
            @endif

            @if($reportType != 'reorder' && $reportListType != "A")
            @if($addReq > 0)
            <tr>
                <td width="4%" class="td notBold alignTop borderTopBottom">{{$sr++}}</td>
                <td colspan="2" class="td notBold alignTop borderTopBottom ">{{$product->product_name}}</td>
                <td colspan="2" class="td notBold alignTop borderTopBottom ">{{$product->generic_drug_name}}</td>
                <td class="td notBold alignTop borderTopBottom">{{"1x".$product->conversion_factor}}</td>
                @if(isset($ratemrp[$product->product_id]["trn_type"]))
                <td colspan="2" class="td notBold alignTop borderTopBottom">{{$ratemrp[$product->product_id]["supplierName"]}}</td>
                <td class="td notBold alignTop borderTopBottom txtRight">{{$ratemrp[$product->product_id]["trn_type"]."/".$ratemrp[$product->product_id]["trn_fyear"]."/".$ratemrp[$product->product_id]["trn_id"]}}</td>
                <td class="td notBold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($ratemrp[$product->product_id]["mrp"])}}</td>
                <td class="td notBold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat4($ratemrp[$product->product_id]["price"])}}</td>
                @else
                <td colspan="2" class="td notBold alignTop borderTopBottom"></td>
                <td class="td notBold alignTop borderTopBottom txtRight"></td>
                <td class="td notBold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat(0)}}</td>
                <td class="td notBold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat(0)}}</td>
                @endif
                <td class="td notBold alignTop borderTopBottom txtRight">{{$stock->current_stock_qty}}</td>
                <td class="td notBold alignTop borderTopBottom txtRight">{{$stock->product_reorder_level}}</td>
                <td class="td notBold alignTop borderTopBottom txtRight">{{$qty}}</td>
                <td class="td notBold alignTop borderTopBottom txtRight">{{$avgDay}}</td>
                <td class="td notBold alignTop borderTopBottom txtRight">{{$qtyForDays}}</td>
                <td class="td notBold alignTop borderTopBottom txtRight">{{$addReq}}</td>
            </tr>
            @endif
            @else
            <tr>
                <td width="4%" class="td notBold alignTop borderTopBottom">{{$sr++}}</td>
                <td colspan="2" class="td notBold alignTop borderTopBottom ">{{$product->product_name}}</td>
                <td colspan="2" class="td notBold alignTop borderTopBottom ">{{$product->generic_drug_name}}</td>
                <td class="td notBold alignTop borderTopBottom">{{"1x".$product->conversion_factor}}</td>
                @if(isset($ratemrp[$product->product_id]["trn_type"]))
                <td colspan="2" class="td notBold alignTop borderTopBottom">{{$ratemrp[$product->product_id]["supplierName"]}}</td>
                <td class="td notBold alignTop borderTopBottom txtRight">{{$ratemrp[$product->product_id]["trn_type"]."/".$ratemrp[$product->product_id]["trn_fyear"]."/".$ratemrp[$product->product_id]["trn_id"]}}</td>
                <td class="td notBold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($ratemrp[$product->product_id]["mrp"])}}</td>
                <td class="td notBold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat4($ratemrp[$product->product_id]["price"])}}</td>
                @else
                <td colspan="2" class="td notBold alignTop borderTopBottom"></td>
                <td class="td notBold alignTop borderTopBottom txtRight"></td>
                <td class="td notBold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat(0)}}</td>
                <td class="td notBold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat(0)}}</td>
                @endif
                <td class="td notBold alignTop borderTopBottom txtRight">{{$stock->current_stock_qty}}</td>
                <td class="td notBold alignTop borderTopBottom txtRight">{{$stock->product_reorder_level}}</td>
                <td class="td notBold alignTop borderTopBottom txtRight">{{$qty}}</td>
                <td class="td notBold alignTop borderTopBottom txtRight">{{$avgDay}}</td>
                <td class="td notBold alignTop borderTopBottom txtRight">{{$qtyForDays}}</td>
                <td class="td notBold alignTop borderTopBottom txtRight">{{$addReq}}</td>
            </tr>
            @endif

            @endif
            @endforeach
            @endforeach
            @php
            $productArray = array_unique($productArray);
            $productIds = implode(',', $productArray);
            $reorderQtys = implode(',', $reorderQtyArray);    
            @endphp
        </tbody>
        <tfoot>
        <td colspan="17" class="th smallFont noPadding alignTop borderTopBottom txtRight">{{ strtoupper(Session::get('userId'))." # ".$currentTime->format('d/m/Y H:i:s ')}}</td>    
        </tfoot>
    </table>

    <input type="hidden" id="storeCode" name="storeCode" value="{{$storeCode}}"/>
    <input type="hidden" id="productIds" name="productIds" value="{{$productIds}}"/>
    <input type="hidden" id="reorderQtys" name="reorderQtys" value="{{$reorderQtys}}"/>

    <!--Print--> 
    <div class="col-xs-12 txtCenter no-print" style="margin-bottom:15px;">
        <button class="btn btn-sm btn-info no-print" id="btnexport" data-myval="{{$reportTitle}}">{{__('Excel')}}</button>
        <button onclick="print()" class="btn btn-sm btn-success no-print">
            <span class="glyphicon glyphicon-print"></span> {{__('Print')}}
        </button>
        <button id="btnGenerateRequest" class="btn btn-sm btn-primary no-print">
            <span class="glyphicon glyphicon-list-alt"></span> {{__('Generate Requirement')}}
        </button>
        @if($trnType == "P")
        <a href="{{ url('Item/medicinereorderInput') }}" class="no-print btn btn-danger btn-sm">
            <span class="glyphicon glyphicon-arrow-left"></span> {{__('Back')}}
        </a>
        @else
        <a href="{{ url('StoreItem/medicinereorderInput') }}" 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')
@include('Components/Bootstrap Modals/processing_modal')
@endsection
<!--Bootstrap Modals Close-->

<!--External JS-->
@section('ExternalJs')
<script src="{{ asset ("/js/export_to_excel.js") }}"></script>
<script src="{{ asset ("/js/medicinereorder_report.js") }}"></script>
@endsection
<!--External JS Close-->