@extends('Reports.template')

<!--Title-->
@section('title')
Material Reorder Report
@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="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="8" class="th borderNone borderBottom reportTitle">
                    {{"Material Reorder"}}
                </th>
                <th colspan="6" class="txtRight th borderNone borderBottom">
                    As on :{{$currentTime->format('d/m/Y H:i:s ')}}
                </th>
            </tr>
            <tr>
                <th colspan="6" class="txtleft th borderNone borderBottom">
                    Period Of {{$day}} Days From :{{$date2}} To {{$date1}}
                </th>
            </tr>

            <tr>
                <th width="4%" class="th noPadding alignTop borderTopBottom  txtRight">Sr No &nbsp;</th>
                <th width="15%" class="th noPadding alignTop borderTopBottom txtLeft">Item Name</th>
                <th colspan="2" width="10%" class="th noPadding alignTop borderTopBottom txtRight">Curr. Stock</th>
                <th width="15%" class="th noPadding alignTop borderTopBottom txtRight">Total Sale</th>
                <th colspan="2" width="10%" class="th noPadding alignTop borderTopBottom txtRight">Avg/Day Sale</th>
                <th width="15%" class="th noPadding alignTop borderTopBottom txtRight">Additional Rqd.</th>
                <th width="15%" class="th noPadding alignTop borderTopBottom txtRight">Order Qty.</th>
            </tr>

        </thead>
        <tbody>
            @php
            $sr = 1;
            $avgDay =0;
            $addReq =0;
            @endphp

            @foreach ($medicineReorderData as $key =>$product)


            @foreach($stockReorder as $key =>$stock)

            @if($product->product_id == $stock->product_id)
            @if($reorder != 'reorder')

            @php
            $avgDay=round($product->quantity/$day,2);
            $addReq=$product->quantity -$stock->current_stock_qty;
            @endphp

            @if($addReq<0)

            @php
            $addReq= '-';
            @endphp

            @endif
            @endif
            <tr>
                <td style="vertical-align: middle;" class="td notBold alignTop borderTop txtRight">{{$sr++}}&nbsp;</td>
                <td style="vertical-align: middle;" class="td notBold alignTop borderTop ">{{$product->product_name}}</td>
                <td colspan="2" style="vertical-align: middle;" class="td notBold alignTop borderTop txtRight">{{$stock->current_stock_qty}}</td>
                <td style="vertical-align: middle;" class="td notBold alignTop borderTop txtRight">{{$product->quantity}}</td>
                <td colspan="2" style="vertical-align: middle;" class="td notBold alignTop borderTop txtRight">{{\Helper::customAmountFormat($avgDay)}}</td>
                <td style="vertical-align: middle;" class="td notBold alignTop borderTop txtRight">{{$addReq}}</td>
                <td style="vertical-align: middle;" class="td notBold alignTop borderTop txtRight"></td>
            </tr>
            @endif
            @endforeach

            @endforeach

        </tbody>
    </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-info" id="btnexport" data-myval="{{Config::get('constants.reports.MEDICINE_REORDER')}}">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/medicinereorderInput') }}" 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')
<script src="{{ asset ("/js/export_to_excel.js") }}"></script>
@endsection
<!--External JS Close-->