@extends('Reports.template')

<!--Title-->
@section('title')
IP Medicine Issue Lead Time 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="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(); 
        @endphp
        <tr>
            <th colspan="6" class="th borderNone borderBottom reportTitle">IP Medicine Issue Lead Time Report</th>
            <th colspan="4" class="txtRight th borderNone borderBottom">Period : {{\Helper::getDisplayDate($fromDate)}} TO {{\Helper::getDisplayDate($toDate)}}</th>
        </tr>
        @if($reportType == "D")
        <tr>
            <th width="4%" class="th noPadding alignTop borderTop borderBottomGray txtRight">Sr.&nbsp;&nbsp;</th>
            <th width="8%" class="th noPadding alignTop borderTop borderBottomGray">&nbsp;Indent No.</th>
            <th class="th noPadding alignTop borderTop borderBottomGray">IP ID</th>
            <th colspan="4" class="th noPadding alignTop borderTop borderBottomGray">Patient Details</th>
            <th colspan="3" class="noPadding alignTop borderTop borderBottomGray"></th>
        </tr>
        <tr>
            <th colspan="2" class="th noPadding alignTop borderTopBottom txtRight">Sr.&nbsp;&nbsp;</th>
            <th class="th noPadding alignTop borderTopBottom">&nbsp;Medicine Name</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">&nbsp;Requested Qty</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">&nbsp;Issued Qty</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">&nbsp;Indent By</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">&nbsp;Issued By</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">Indent DateTime</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">Issued DateTime</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">Lead Time</th>
        </tr>
        @else
        <tr>
            <th width="4%" class="th noPadding alignTop borderTopBottom txtRight">Sr.&nbsp;&nbsp;</th>
            <th width="8%" class="th noPadding alignTop borderTopBottom">&nbsp;Indent No.</th>
            <th class="th noPadding alignTop borderTopBottom">IP ID</th>
            <th colspan="2" class="th noPadding alignTop borderTopBottom">Patient Details</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Indent By</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Issued By</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">Min Indent DateTime</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">Max Issued DateTime</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">Avg Lead Time</th>
        </tr>
        @endif
    </thead>
    @if($reportType == "D")
    <tbody>
        @php
        $srHeader = 1;
        $oldIndentID = '';
        $leadTimeSeconds = 0;
        $count = 0;
        $avgLeadTime = 0;
        $totalLeadTimeSeconds = 0;
        $totalCount = 0;
        $totalAvgLeadTime = 0;
        @endphp
        @foreach($medicineTransactionData as $medicineTransaction)
        @php
        $patName = " ".$medicineTransaction->patient_id." / ".$medicineTransaction->patient_name;
        $ipID = "IP - ".$medicineTransaction->ipd_reg_id;
        $indentID = $medicineTransaction->trn_id;
        $leadTime = '';
        @endphp
        @if($indentID != $oldIndentID)
        @if($avgLeadTime != 0 || ($avgLeadTime == 0 && $oldIndentID != ''))
        @if($count != 0 && $leadTimeSeconds != 0)
        @php
        $startSecond = new DateTime("@0");
        $endSecond = new DateTime("@".ceil($leadTimeSeconds/$count));
        $diff = $endSecond->diff($startSecond);
        $avgLeadTime = $diff->format('%dd  %hh %im %ss');
        @endphp
        @else
        @php
        $avgLeadTime = '';
        @endphp
        @endif
        <tr>
            <td colspan="9" class="td bold noPadding alignTop borderTopBottom txtRight">Avg Lead Time : </td>
            <td class="th bold noPadding alignTop borderTopBottom txtRight">{{$avgLeadTime}}</td>
        </tr>
        @endif
        @php
        $sr = 1;
        $leadTimeSeconds = 0;
        $count = 0;
        $avgLeadTime = 0;
        @endphp
        <tr>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{$srHeader++}}&nbsp;&nbsp;</td>
            <td class="td bold noPadding alignTop borderTopBottom">&nbsp;{{$indentID}}</td>
            <td class="td bold noPadding alignTop borderTopBottom">{{$ipID}}</td>
            <td colspan="4" class="td bold noPadding alignTop borderTopBottom">{{$patName}}</td>
            <td colspan="3" class="td bold noPadding alignTop borderTopBottom"></td>
        </tr>
        @endif
        @if($medicineTransaction->leadTimeInSecond != 0)
        @php
        $count++;
        $leadTimeSeconds += $medicineTransaction->leadTimeInSecond;
        $startSecond = new DateTime("@0");
        $endSecond = new DateTime("@$medicineTransaction->leadTimeInSecond");
        $diff = $endSecond->diff($startSecond);
        $leadTime = $diff->format('%dd  %hh %im %ss');
        $totalLeadTimeSeconds += $medicineTransaction->leadTimeInSecond;
        $totalCount++;
        @endphp
        @else
        @php
        $leadTime = "****";   
        @endphp
        @endif
        @php
        $createdDateFormated = \Helper::getDisplayDate($medicineTransaction->created_date)." ".$medicineTransaction->created_time;    
        $issuedDateFormated = \Helper::getDisplayDate($medicineTransaction->issued_date)." ".$medicineTransaction->issued_time;    
        @endphp
        <tr>
            <td colspan="2" class="td noPadding alignTop borderBottomGray txtRight">{{$sr++}}&nbsp;&nbsp;</td>
            <td class="td noPadding alignTop borderBottomGray">&nbsp;{{$medicineTransaction->product_name}}</td>
            <td class="td noPadding alignTop borderBottomGray txtRight">&nbsp;{{$medicineTransaction->loose_quantity}}</td>
            <td class="td noPadding alignTop borderBottomGray txtRight">&nbsp;{{$medicineTransaction->issue_qty}}</td>
            <td class="td noPadding alignTop borderBottomGray txtRight">&nbsp;{{$medicineTransaction->createdBy}}</td>
            <td class="td noPadding alignTop borderBottomGray txtRight">&nbsp;{{$medicineTransaction->issuedBy}}</td>
            <td class="td noPadding alignTop borderBottomGray txtRight">{{$createdDateFormated}}</td>
            <td class="td noPadding alignTop borderBottomGray txtRight">{{$issuedDateFormated}}</td>
            <td class="td noPadding alignTop borderBottomGray txtRight">{{$leadTime}}</td>
        </tr>
        @php
        $oldIndentID = $indentID;
        $leadTime = ''; 
        @endphp
        @endforeach
        @if($count != 0 && $leadTimeSeconds != 0)
        @php
        $startSecond = new DateTime("@0");
        $endSecond = new DateTime("@".ceil($leadTimeSeconds/$count));
        $diff = $endSecond->diff($startSecond);
        $avgLeadTime = $diff->format('%dd  %hh %im %ss');
        @endphp
        @else
        @php
        $avgLeadTime = '';
        @endphp
        @endif
        <tr>
            <td colspan="9" class="td bold noPadding alignTop borderTopBottom txtRight">Avg Lead Time : </td>
            <td class="th bold noPadding alignTop borderTopBottom txtRight">{{$avgLeadTime}}</td>
        </tr>
        @if($totalCount != 0 && $totalLeadTimeSeconds != 0)
        @php
        $startSecond = new DateTime("@0");
        $endSecond = new DateTime("@".ceil($totalLeadTimeSeconds/$totalCount));
        $diff = $endSecond->diff($startSecond);
        $totalAvgLeadTime = $diff->format('%dd  %hh %im %ss');
        @endphp
        @else
        @php
        $totalAvgLeadTime = '';    
        @endphp
        @endif
        <tr>
            <td colspan="9" class="td bold alignTop borderTopBottom txtRight">Overall Lead Time : </td>
            <td class="td bold alignTop borderTopBottom txtRight">{{$totalAvgLeadTime}}</td>
        </tr>
    </tbody>
    @else
    <tbody>
        @php
        $srHeader = 1;
        $totalLeadTimeSeconds = 0;
        $totalCount = 0;
        $totalAvgLeadTime = 0;
        @endphp
        @foreach($medicineTransactionData as $medicineTransaction)
        @php
        $patName = " ".$medicineTransaction->patient_id." / ".$medicineTransaction->patient_name;
        $ipID = "IP - ".$medicineTransaction->ipd_reg_id;
        $indentID = $medicineTransaction->trn_id;
        $minCreatedDateFormated = \Helper::getDisplayDate($medicineTransaction->minCreatedDate)." ".$medicineTransaction->minCreatedTime;    
        $maxIssuedDateFormated = \Helper::getDisplayDate($medicineTransaction->maxIssuedDate)." ".$medicineTransaction->maxIssuedTime;    
        $count = $medicineTransaction->totalCount;
        $leadTimeSeconds = $medicineTransaction->totalLeadTimeInSecond;
        $totalCount += $medicineTransaction->totalCount;
        $totalLeadTimeSeconds += $medicineTransaction->totalLeadTimeInSecond;
        @endphp
        @if($count != 0 && $leadTimeSeconds != 0)
        @php
        $startSecond = new DateTime("@0");
        $endSecond = new DateTime("@".ceil($leadTimeSeconds/$count));
        $diff = $endSecond->diff($startSecond);
        $avgLeadTime = $diff->format('%dd  %hh %im %ss');
        @endphp
        @else
        @php
        $avgLeadTime = '';
        @endphp
        @endif
        <tr>
            <td class="td noPadding alignTop borderTopBottom txtRight">{{$srHeader++}}&nbsp;&nbsp;</td>
            <td class="td noPadding alignTop borderTopBottom">&nbsp;{{$indentID}}</td>
            <td class="td noPadding alignTop borderTopBottom">{{$ipID}}</td>
            <td colspan="2" class="td noPadding alignTop borderTopBottom">{{$patName}}</td>
            <td class="td noPadding alignTop borderTopBottom txtRight">{{$medicineTransaction->createdBy}}</td>
            <td class="td noPadding alignTop borderTopBottom txtRight">{{$medicineTransaction->issuedBy}}</td>
            <td class="td noPadding alignTop borderTopBottom txtRight">{{$minCreatedDateFormated}}</td>
            <td class="td noPadding alignTop borderTopBottom txtRight">{{$maxIssuedDateFormated}}</td>
            <td class="td noPadding alignTop borderTopBottom txtRight">{{$avgLeadTime}}</td>
        </tr>
        @endforeach
        @if($totalCount != 0 && $totalLeadTimeSeconds != 0)
        @php
        $startSecond = new DateTime("@0");
        $endSecond = new DateTime("@".ceil($totalLeadTimeSeconds/$totalCount));
        $diff = $endSecond->diff($startSecond);
        $totalAvgLeadTime = $diff->format('%dd  %hh %im %ss');
        @endphp
        @else
        @php
        $totalAvgLeadTime = '';    
        @endphp
        @endif
        <tr>
            <td colspan="9" class="td bold alignTop borderTopBottom txtRight">Overall Lead Time : </td>
            <td class="td bold alignTop borderTopBottom txtRight">{{$totalAvgLeadTime}}</td>
        </tr>
    </tbody>
    @endif
    <tfoot>
    <td colspan="10" 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="ipMedicineIssueLeadTime">
            <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/ipMedicineIssueLeadTimeReportInput') }}" 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-->