@extends('Reports.template')

<!--Title-->
@section('title')
@php
$reportTitle = "Reorder Request Report";
@endphp
{{$reportTitle}}
@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="2" class="borderNone borderBottom" style="vertical-align:center;">
                <!--Image--> 
                @if($businessEntityMasterData[0]->logo != null)
                <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();
        if($requestStatus === 'Y'){
        $requestStatusMessage =  "Closed";
        }else if($requestStatus === 'N'){
        $requestStatusMessage =  "Open";
        }else{
        $requestStatusMessage =  "ALL";
        }
        @endphp
        <tr>
            <th colspan="6" class="th borderNone borderBottom reportTitle">
                {{$reportTitle}} <label class="fontsize12 bold">{{ " (Status : ".$requestStatusMessage." )"}}</label>
            </th>
            <th colspan="3" class="txtRight th borderNone borderBottom">
                Store : {{$storeName}}
            </th>
            <th colspan="3" class="txtRight th borderNone borderBottom">
                Period : {{\Helper::getDisplayDate($fromDate)}} TO {{\Helper::getDisplayDate($toDate)}}
            </th>
        </tr>
        <tr>
            <th width="5%" class="th noPadding alignTop borderTopBottom txtRight">Sr No</th>
            <th class="th noPadding alignTop borderTopBottom">&emsp;Request Date</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Product ID&emsp;</th>
            <th colspan="2" class="th noPadding alignTop borderTopBottom">Product Name</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Reorder Level at request time</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Stock Qty at request time&emsp;</th>
            <th class="th noPadding alignTop borderTopBottom">Ref No.</th>
            <th class="th noPadding alignTop borderTopBottom">Request Close Date</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Lead Time&emsp;</th>
            <th class="th noPadding alignTop borderTopBottom">Status</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Requested By</th>
        </tr>
    </thead>
    <tbody>
        @php
        $sr = 1;
        @endphp
        @foreach ($reorderRequestData as $reorderRequest)
        @php
        $leadTime = 0;
        $reorderRequestStatus = "Open";
        if($reorderRequest->is_order_done === 'Y'){
        $reorderRequestStatus =  "Closed";
        }
        if($reorderRequest->ref_trn_date != null){
        $startDate = new DateTime($reorderRequest->reorder_request_date);
        $endDate = new DateTime($reorderRequest->ref_trn_date);
        $diff = $startDate->diff($endDate);
        $leadTime = $diff->d . " days";
        }
        @endphp
        <tr>
            <td class="td notBold alignTop borderTopBottom txtRight">{{$sr++}}</td>
            <td class="td notBold alignTop borderTopBottom">&emsp;{{ \Helper::getDisplayDate($reorderRequest->reorder_request_date) }}</td>
            <td class="td notBold alignTop borderTopBottom txtRight">{{ $reorderRequest->product_id }}&emsp;</td>
            <td colspan="2" class="td notBold alignTop borderTopBottom">{{ $reorderRequest->product_name }}</td>
            <td class="td notBold alignTop borderTopBottom txtRight">{{ $reorderRequest->product_reorder_level }}</td>
            <td class="td notBold alignTop borderTopBottom txtRight">{{ $reorderRequest->current_stock_qty }}&emsp;</td>
            <td class="td notBold alignTop borderTopBottom">{{\Helper::nullToEmpty($reorderRequest->ref_trn_id)}}</td>
            <td class="td notBold alignTop borderTopBottom">{{\Helper::getDisplayDate($reorderRequest->ref_trn_date)}}</td>
            <td class="td notBold alignTop borderTopBottom txtRight">{{\Helper::zeroValueToSpace($leadTime)}}&emsp;</td>
            <td class="td notBold alignTop borderTopBottom">{{$reorderRequestStatus}}</td>
            <td class="td notBold alignTop borderTopBottom txtRight">{{$reorderRequest->created_by}}</td>
        </tr>
        @endforeach
    </tbody>
    <tfoot>
    <td colspan="12" 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 no-print" 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="{{$reportTitle}}">
            <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/ReorderRequestReportInput') }}" class="no-print btn btn-danger btn-sm">
            <span class="glyphicon glyphicon-arrow-left"></span> Back
        </a>
    </div>
</div>
@endsection

<!--External JS-->
@section('ExternalJs')
@endsection
<!--External JS Close-->