@extends('Reports.template')
@php
    $reportTitle = 'IP Bill Wise DC/DCR Report';
@endphp

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

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

            .pageBreak {
                page-break-before: always;
            }
        }
    </style>
@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="3" 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="16" 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 . ' ' }}</th>
                <th colspan="6" class="txtRight th borderNone borderBottom"></th>
                <th colspan="7" class="txtRight th borderNone borderBottom">Period :
                    {{ \Helper::getDisplayDate($fromDate) }} TO {{ \Helper::getDisplayDate($toDate) }}</th>
            </tr>
        </thead>
        <tbody>
            @php
                $previous_ip_id = '';
                $previous_dc_no = '';
                $createdBy = '';
            @endphp

                @foreach ($trnDetails as $key => $details)
                <!-- Headers -->
                    @if ($details->IPID != $previous_ip_id)
                        
                        <tr>
                            <th class="th noPadding alignTop borderTop borderBottomGray txtLeft ">IP Bill No: {{ $details->IPBIll_no }}</th>
                            <th colspan="3" class="th noPadding alignTop borderTop borderBottomGray txtLeft "></th>
                            <th class="th noPadding alignTop borderTop borderBottomGray txtLeft ">UH ID: {{ $details->UHID }}</th>
                            <th colspan="6" class="th noPadding alignTop borderTop borderBottomGray txtLeft "></th>
                            <th class="th noPadding alignTop borderTop borderBottomGray txtLeft ">IP ID: {{ $details->IPID }}</th>
                            <th colspan="6" class="th noPadding alignTop borderTop borderBottomGray txtLeft "></th>
                            <th class="th noPadding alignTop borderTop borderBottomGray txtRight ">DOA: {{ \Helper::getDisplayDate($details->admit_date) }}</th>
                        </tr>
                        <tr>
                            <th colspan="2" class="th noPadding alignTop borderTop borderBottomGray txtLeft ">IP Bill Date: {{ \Helper::getDisplayDate($details->BILL_DT) }}</th>
                            <th colspan="2" class="th noPadding alignTop borderTop borderBottomGray txtLeft "></th>
                            <th colspan="5" class="th noPadding alignTop borderTop borderBottomGray txtLeft ">Patient: {{ $details->Patient . " " . $details->patient_gender . "/" . $details->patient_age }}</th>
                            <th colspan="2" class="th noPadding alignTop borderTop borderBottomGray txtLeft "></th>
                            <th colspan="4" class="th noPadding alignTop borderTop borderBottomGray txtLeft ">Admitting Doc: {{ $details->doctor_fname }}</th>
                            <th colspan="2" class="th noPadding alignTop borderTop borderBottomGray txtLeft "></th>
                            <th colspan="2" class="th noPadding alignTop borderTop borderBottomGray txtRight ">DOD: {{ \Helper::getDisplayDate($details->discharge_date) }}</th>
                        </tr>
                        <tr>
                            <th class="th noPadding alignTop borderTop borderBottomGray txtLeft">DC No</th>
                            <th class="th noPadding alignTop borderTop borderBottomGray txtLeft">DC Date</th>
                            <th colspan="7" class="th noPadding alignTop borderTop borderBottomGray txtLeft"></th>
                            <th class="th noPadding alignTop borderTop borderBottomGray txtRight">Gross</th>
                            <th colspan="2" class="th noPadding alignTop borderTop borderBottomGray txtRight">Disc</th>
                            <th class="th noPadding alignTop borderTop borderBottomGray txtRight">Net Tax</th>
                            <th class="th noPadding alignTop borderTop borderBottomGray txtRight">CGST</th>
                            <th class="th noPadding alignTop borderTop borderBottomGray txtRight">SGST</th>
                            <th class="th noPadding alignTop borderTop borderBottomGray txtRight">Invoice</th>
                            <th class="th noPadding alignTop borderTop borderBottomGray txtRight ">&nbsp;R.Off&nbsp;</th>
                            <th class="th noPadding alignTop borderTop borderBottomGray txtRight ">Net Amt</th>
                            <th class="th noPadding alignTop borderTop borderBottomGray txtRight ">Created By</th>
                        </tr>
                        @if ($reportType == 'D')
                            <tr>
                                <td class="td noPadding alignTop borderTop borderBottomGray txtLeft">Sr</td>
                                <td class="td noPadding alignTop borderTop borderBottomGray txtLeft"></td>
                                <td class="td noPadding alignTop borderTop borderBottomGray txtLeft">Medicine Name</td>
                                <td class="td noPadding alignTop borderTop borderBottomGray txtLeft">HSN Code</td>
                                <td class="td noPadding alignTop borderTop borderBottomGray txtLeft">Category</td>
                                <td class="td noPadding alignTop borderTop borderBottomGray txtLeft">P Size</td>
                                <td class="td noPadding alignTop borderTop borderBottomGray txtLeft">Batch</td>
                                <td class="td noPadding alignTop borderTop borderBottomGray txtLeft">Exp</td>
                                <td class="td noPadding alignTop borderTop borderBottomGray txtRight">Qty</td>
                                <td class="td noPadding alignTop borderTop borderBottomGray txtRight">MRP</td>
                                <td class="td noPadding alignTop borderTop borderBottomGray txtRight">Disc%</td>
                                <td class="td noPadding alignTop borderTop borderBottomGray txtRight">Disc</td>
                                <td class="td noPadding alignTop borderTop borderBottomGray txtRight">Taxable</td>
                                <td class="td noPadding alignTop borderTop borderBottomGray txtRight">GST%</td>
                                <td class="td noPadding alignTop borderTop borderBottomGray txtRight">GST Amt</td>
                                <td class="td noPadding alignTop borderTop borderBottomGray txtRight">Amount</td>
                                <td colspan="3" class="td noPadding alignTop borderTop borderBottomGray txtLeft"></td>
                            </tr>
                        @endif
                        
                    @endif
                <!-- End of Headers  -->
                <!-- Records -->
                    @if ($details->DCNO != $previous_dc_no)
                        @php
                            $sr = 0;
                            $items = explode('/', $details->DCNO);
                            $type = $items[0];
                            $dc = $items[1];
                        @endphp
                        @foreach ($headerDetails as $key => $header)
                            @if ($header->trn_id == $dc && $header->trn_type == $type)
                                <tr>
                                    <td class="td noPadding alignTop borderTop bold txtLeft">{{ $header->trn_type . '/' . $header->trn_fyear . '/' . $header->trn_id }}</td>
                                    <td class="td noPadding alignTop borderTop bold txtLeft">{{ $header->trn_date }}</td>
                                    <td colspan="7" class="td noPadding alignTop borderTop bold txtLeft"></td>
                                    <td class="td noPadding alignTop borderTop bold txtRight">{{ \Helper::customAmountFormat($header->gross_total) }}</td>
                                    <td colspan="2" class="td noPadding alignTop borderTop bold txtRight">{{ \Helper::customAmountFormat($header->discount) }}</td>
                                    <td class="td noPadding alignTop borderTop bold txtRight">{{ \Helper::customAmountFormat($header->net_taxable_amt) }}</td>
                                    <td class="td noPadding alignTop borderTop bold txtRight">{{ \Helper::customAmountFormat($header->cgst_amt) }}</td>
                                    <td class="td noPadding alignTop borderTop bold txtRight">{{ \Helper::customAmountFormat($header->sgst_amt) }}</td>
                                    <td class="td noPadding alignTop borderTop bold txtRight">{{ \Helper::customAmountFormat($header->invoice_amt) }}</td>
                                    <td class="td noPadding alignTop borderTop bold txtRight ">&nbsp;{{ \Helper::customAmountFormat($header->round_off) }}&nbsp;</td>
                                    <td class="td noPadding alignTop borderTop bold txtRight ">{{ \Helper::customAmountFormat($header->total) }}</td>
                                    <td class="td noPadding alignTop borderTop bold txtRight ">{{ $header->created_by }}</td>
                                </tr>
                            @endif
                        @endforeach
                    @endif
                    @if ($reportType == 'D')
                        <tr>
                            <td class="td noPadding alignTop borderTop borderBottomGray txtLeft">{{ ++$sr }}</td>
                            <td class="td noPadding alignTop borderTop borderBottomGray txtLeft"></td>
                            <td class="td noPadding alignTop borderTop borderBottomGray txtLeft">{{ $details->product_name }}</td>
                            <td class="td noPadding alignTop borderTop borderBottomGray txtLeft">{{ $details->HSN_CODE }}</td>
                            <td class="td noPadding alignTop borderTop borderBottomGray txtLeft">{{ $details->CATEGORY }}</td>
                            <td class="td noPadding alignTop borderTop borderBottomGray txtLeft">{{ $details->Pack_size }}</td>
                            <td class="td noPadding alignTop borderTop borderBottomGray txtLeft">{{ $details->batch_no }}</td>
                            <td class="td noPadding alignTop borderTop borderBottomGray txtLeft">{{ \Helper::getMonthYearFromDate($details->batch_exp) }}</td>
                            <td class="td noPadding alignTop borderTop borderBottomGray txtRight">{{ $details->QTY }}</td>
                            <td class="td noPadding alignTop borderTop borderBottomGray txtRight">{{ \Helper::customAmountFormat($details->MRP) }}</td>
                            <td class="td noPadding alignTop borderTop borderBottomGray txtRight">{{ $details->disc_per }}</td>
                            <td class="td noPadding alignTop borderTop borderBottomGray txtRight">{{ \Helper::customAmountFormat($details->disc_amt) }}</td>
                            <td class="td noPadding alignTop borderTop borderBottomGray txtRight">{{ \Helper::customAmountFormat($details->taxable_amt) }}</td>
                            <td class="td noPadding alignTop borderTop borderBottomGray txtRight">{{ $details->GST_PERCENT }}</td>
                            <td class="td noPadding alignTop borderTop borderBottomGray txtRight">{{ \Helper::customAmountFormat($details->GST) }}</td>
                            <td class="td noPadding alignTop borderTop borderBottomGray txtRight">{{ \Helper::customAmountFormat($details->total) }}</td>
                            <td colspan="3" class="td noPadding alignTop borderTop borderBottomGray txtLeft"></td>
                        </tr>
                    @endif
                    
                    <!-- Keeping track of same IP ID and same DC NO -->
                    @php
                        $previous_ip_id = $details->IPID;
                        $previous_dc_no = $details->DCNO;
                    @endphp
                    <!--  -->
                <!--  End of Records -->
                @endforeach
        </tbody>
        @php
            $currentTime = \Carbon\Carbon::now();
        @endphp
        <tfoot>
            <td colspan="9" class="th smallFont noPadding alignTop borderTopBottom"></td>
            <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>

    <!--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="{{ url('Item/IPBillWiseDcDcrReportInput') }}" 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-->