@extends('Reports.template')

@if($trnType === 'GIN')
@php
$reportTitle = 'Material Issue Note Register Report';
@endphp
@else
@php
$reportTitle = 'Material Issue Note Return Register Report';
@endphp
@endif

<!--Title-->
@section('title')
{{$reportTitle}}
@endsection
<!--Title Close-->

<!--External CSS-->
@section('ExternalCss')
@parent
<style>
    @media print {
        @page { size: A4 landscape;}
    }
</style>
@endsection
<!--External CSS Close--> 

@section('Content')
@php
if($trnStatus === 'P'){
$trnStatusMessage =  "Partial";
}else if($trnStatus === 'T'){
$trnStatusMessage =  "Cancelled";
}else if($trnStatus === 'C'){
$trnStatusMessage =  "Completed";
}else{
$trnStatusMessage =  "ALL";
}
@endphp
<!-- 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="10" class="borderNone borderBottom">
                <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>
        <tr>
            <th colspan="6" class="th borderNone borderBottom reportTitle">
                {{$reportTitle." "}}<label class="fontsize12 bold"> (Status : {{$trnStatusMessage}})</label>
            </th>
            <th colspan="2" class="txtRight th borderNone borderBottom">
                Store : {{ $storeName }}
            </th>
            <th colspan="4" class="txtRight th borderNone borderBottom">
                Period : {{ \Helper::getDisplayDate($fromDate) }} TO {{ \Helper::getDisplayDate($toDate) }}
            </th>
        </tr>
        @if($reportType === 'B')
        <tr>
            <th width="2%" class="th noPadding alignTop borderTop borderBottomGray txtCenter">Bill No</th>
            <th class="th noPadding alignTop borderTop borderBottomGray">&nbsp;Bill Date</th>
            <th colspan="2" class="th noPadding alignTop borderTop borderBottomGray">Department / Patient Name</th>
            <th colspan="8" class="th noPadding alignTop borderTop borderBottomGray"></th>
        </tr>
        <tr>
            <th class="th notBold noPadding alignTop borderTopBottom txtRight">Sr</th>
            <th class="th notBold noPadding alignTop borderTopBottom">&nbsp;&nbsp;Item Name</th>
            <th class="th notBold noPadding alignTop borderTopBottom">Mfg</th>
            <th class="th notBold noPadding alignTop borderTopBottom">Category </th>
            <th class="th notBold noPadding alignTop borderTopBottom">Unit</th>
            <th class="th notBold noPadding alignTop borderTopBottom">&nbsp;Batch</th>
            <th class="th notBold noPadding alignTop borderTopBottom">Exp</th>
            <th class="th notBold noPadding alignTop borderTopBottom txtRight">Qty</th>
            <th width="5%" class="th notBold noPadding alignTop borderTopBottom txtRight">MRP</th>
            <th width="7%" class="th notBold noPadding alignTop borderTopBottom txtRight">MRP Value</th>
            <th width="5%" class="th notBold noPadding alignTop borderTopBottom txtRight">PTR</th>            
            <th width="7%" class="th notBold noPadding alignTop borderTopBottom txtRight">PTR Value</th>            
        </tr>
        @else
        <tr>
            <th width="2%" class="th noPadding alignTop borderTopBottom txtCenter">Bill No</th>
            <th class="th noPadding alignTop borderTopBottom">&nbsp;Bill Date</th>
            <th colspan="2" class="th noPadding alignTop borderTopBottom">Department / Patient Name</th>
            <th colspan="8" class="th noPadding alignTop borderTopBottom txtRight">Total PTR Value</th>
        </tr>
        @endif
    </thead>
    @if($reportType === 'B')
    <tbody>
        @php
        $oldPhTrnId = '';
        $headerSr = 1;
        $transactionSr = 1;
        $totalQty = 0;
        $mrpTotal = 0;
        $ptrTotal = 0;
        $mrpGrandTotal = 0;
        $ptrGrandTotal = 0;
        $remark = '';
        $createdBy = '';
        $datetime = '';
        @endphp
        @foreach ($productTransactionData as $key =>$productTransaction)

        @if($productTransaction->ph_trn_id != $oldPhTrnId)

        @if($totalQty != 0)
        <tr>
            <td colspan="4" class="td borderNone">
                @if($remark != '')
                Remarks : <span class="notBold ">{{$remark}}</span>
                @endif
            </td>

            <td colspan="4" class="td smallFont notBold alignTop borderTopBottom txtRight">
                <i>{{"Created By : "}}</i>
                @if($createdBy)
                {{$createdBy ."  ".Carbon\Carbon::parse($datetime)->format('d-m-Y h:i:s')}}
                @endif
            </td>

            <td class="td bold borderTopBottom txtRight">
                Total : 
            </td>

            <td class="td bold borderTopBottom txtRight">
                {{\Helper::customAmountFormat2($mrpTotal)}}
            </td>

            <td colspan="2" class="td bold borderTopBottom txtRight">
                {{\Helper::customAmountFormat4($ptrTotal)}}
            </td>
        </tr>
        @endif

        @php
        $transactionSr = 1;
        $totalQty = 0;
        $mrpTotal = 0;
        $ptrTotal = 0;
        $remark = '';
        if($productTransaction->department_name != null){
        $patDepName = $productTransaction->department_name;
        }else{
        $patDepName = $productTransaction->patient_name;
        }
        @endphp

        <tr>
            <td class="td bold alignTop borderTopBottom txtRight">{{ $productTransaction->trn_type.$productTransaction->ph_trn_id }}</td>
            <td class="td bold alignTop borderTopBottom">&nbsp;&nbsp;{{ \Helper::getDisplayDate($productTransaction->trn_date) }}</td>
            <td colspan="2" class="td bold alignTop borderTopBottom">{{$patDepName}}</td>
            <td colspan="8" class="td bold alignTop borderTopBottom"></td>
        </tr>
        @endif

        @php
        $mrpValue = round($productTransaction->quantity*$productTransaction->mrp,2);
        $rateValue = round($productTransaction->quantity*$productTransaction->price_per_unit_suom,4);
        $mrpTotal += $mrpValue;
        $ptrTotal += $rateValue;
        $mrpGrandTotal += $mrpValue;
        $ptrGrandTotal += $rateValue;
        @endphp
        <tr>
            <td class="td notBold alignTop borderTopGray txtRight">{{$transactionSr++}}</td>
            <td class="td notBold alignTop borderTopGray">&nbsp;&nbsp;{{ \Helper::zeroValueToDash($productTransaction->product_name) }}</td>
            <td class="td notBold alignTop borderTopGray">{{ \Helper::zeroValueToDash($productTransaction->manufacturer_name) }}</td>
            <td class="td notBold alignTop borderTopGray">{{ \Helper::zeroValueToDash($productTransaction->category_abbrev) }}</td>
            <td class="td notBold alignTop borderTopGray">{{ \Helper::zeroValueToDash($productTransaction->unit_abbrev) }}</td>
            <td class="td notBold alignTop borderTopGray">{{ $productTransaction->batch_no }}</td>
            <td class="td notBold alignTop borderTopGray">{{ \Helper::getMonthYearFromDate($productTransaction->batch_exp) }}</td>
            <td class="td notBold alignTop borderTopGray txtRight">{{ $productTransaction->quantity }}</td>
            <td class="td notBold alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat2($productTransaction->mrp) }}</td>
            <td class="td notBold alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat2($mrpValue) }}</td>
            <td class="td notBold alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat4($productTransaction->price_per_unit_suom) }}</td>
            <td class="td notBold alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat4($rateValue) }}</td>

        </tr>
        @php
        $totalQty += $productTransaction->quantity;
        $remark = $productTransaction->ph_remarks;
        $datetime = $productTransaction->created_date;
        $createdBy = ($productTransaction->ph_modified_by) ? strtoupper($productTransaction->ph_modified_by) : strtoupper($productTransaction->ph_created_by); 
        $oldPhTrnId = $productTransaction->ph_trn_id;
        @endphp
        @endforeach
        <tr>
            <td colspan="4" class="td bold borderNone">
                @if($remark != '')
                Remarks : <span class="notBold ">{{$remark}}</span>
                @endif
            </td>

            <td colspan="4" class="td smallFont notBold alignTop borderTopBottom txtRight">
                <i>{{"Created By : "}}</i>
                @if($createdBy)
                {{$createdBy ."  ".Carbon\Carbon::parse($datetime)->format('d-m-Y h:i:s')}}
                @endif
            </td>

            <td class="td bold borderTopBottom txtRight">
                Total : 
            </td>

            <td class="td bold borderTopBottom txtRight">
                {{\Helper::customAmountFormat2($mrpTotal)}}
            </td>

            <td colspan="2" class="td bold borderTopBottom txtRight">
                {{\Helper::customAmountFormat4($ptrTotal)}}
            </td>
        </tr>
        <tr>
            <td colspan="9" class="td bold borderTopBottom txtRight">
                Grand Total : 
            </td>

            <td class="td bold borderTopBottom txtRight">
                {{\Helper::customAmountFormat2($mrpGrandTotal)}}
            </td>

            <td colspan="2" class="td bold borderTopBottom txtRight">
                {{\Helper::customAmountFormat4($ptrGrandTotal)}}
            </td>
        </tr>
    </tbody>
    @else
    <tbody>
        @php
        $oldPhTrnId = '';
        $headerSr = 1;
        $totalQty = 0;

        $lastTrnId = '';
        $lastTrnDate = '';
        $lastPatOrDeptName = '';
        $ptrTotal = 0;
        $ptrGrandTotal = 0;
        @endphp
        @foreach ($productTransactionData as $key =>$productTransaction)

        @if($productTransaction->ph_trn_id != $oldPhTrnId)

        @if($totalQty != 0 && $headerSr >= 1)
        <tr>
            <td class="td bold alignTop borderTopBottom txtRight">{{ $lastTrnId }}</td>
            <td class="td bold alignTop borderTopBottom">&nbsp;&nbsp;{{ \Helper::getDisplayDate($lastTrnDate) }}</td>
            <td colspan="2" class="td bold alignTop borderTopBottom">{{$lastPatOrDeptName}}</td>
            <td colspan="8" class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat4($ptrTotal)}}</td>
        </tr>
        @endif

        @php
        $ptrTotal = 0;
        if($productTransaction->department_name != null){
        $patDepName = $productTransaction->department_name;
        }else{
        $patDepName = $productTransaction->patient_name;
        }
        @endphp

        @endif

        @php
        $rateValue = round($productTransaction->quantity*$productTransaction->price_per_unit_suom,4);
        $ptrTotal += $rateValue;
        $ptrGrandTotal += $rateValue;

        $totalQty += $productTransaction->quantity;
        $oldPhTrnId = $productTransaction->ph_trn_id;

        $lastTrnId = $productTransaction->trn_type.$productTransaction->ph_trn_id;
        $lastTrnDate = $productTransaction->trn_date;
        $lastPatOrDeptName = $patDepName;
        @endphp
        @endforeach
        <tr>
            <td class="td bold alignTop borderTopBottom txtRight">{{ $lastTrnId }}</td>
            <td class="td bold alignTop borderTopBottom">&nbsp;&nbsp;{{ \Helper::getDisplayDate($lastTrnDate) }}</td>
            <td colspan="2" class="td bold alignTop borderTopBottom">{{$lastPatOrDeptName}}</td>
            <td colspan="8" class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat4($ptrTotal)}}</td>
        </tr>
        <tr>
            <td colspan="11" class="td bold borderTopBottom txtRight">
                Grand Total : 
            </td>
            <td class="td bold borderTopBottom txtRight">
                {{\Helper::customAmountFormat4($ptrGrandTotal)}}
            </td>
        </tr>
    </tbody>
    @endif
    @php 
    $currentTime  = \Carbon\Carbon::now(); 
    @endphp
    <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" 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="#" onclick="return history.back();" 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')
@endsection
<!--External JS Close-->