@extends('Reports.template')


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

@section('Content')
    @php
        $fromDate = \Carbon\Carbon::parse($fromDate);
        $fromDate = $fromDate->format('d/m/Y');
        $toDate = \Carbon\Carbon::parse($toDate);
        $toDate = $toDate->format('d/m/Y');
        if($trnType == 'I') {
            $reportTitle = 'Sales Amendment Report';
        } elseif( $trnType == 'IR') {
            $reportTitle = 'Sale Return Amendment Report';
        } elseif($trnType == 'P') {
            $reportTitle = 'Purchase Amendment Report';
        } elseif($trnType == 'PR') {
            $reportTitle = 'Purchase Return Amendment Report';
        }
    @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="5" 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="21" 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="4" class="th borderNone borderBottom">Report Type : {{ $reportType }}</th>
                    <th colspan="16" class="txtRight th borderNone borderBottom ">Period : {{ $fromDate }} TO {{ $toDate }}</th>
                </tr>
                @if($trnType == "I" || $trnType == "IR")
                    <tr>
                        <th class="th noPadding alignTop txtLeft">Store</th>
                        <th width="4%" class="th noPadding alignTop txtRight">Bill No</th>
                        <th class="th alignTop txtRight">&emsp;AmNo&emsp;</th>
                        <th class="th noPadding alignTop">Bill Date</th>
                        <th colspan="3" class="th noPadding alignTop">Patient / Customer Name</th>
                        <th width="6%" colspan="2" class="th noPadding alignTop txtRight">Gross</th>
                        <th class="th noPadding alignTop "></th>
                        <th class="th noPadding alignTop txtRight">Disc%</th>
                        <th width="6%" class="th noPadding alignTop txtRight">Net Taxable&emsp;</th>
                        <th class="th noPadding alignTop txtRight">CGST&emsp;</th>
                        <th class="th noPadding alignTop txtRight">SGST&emsp;</th>
                        <th width="5%" class="th noPadding alignTop txtRight">R.Off</th>
                        <th colspan="3" class="th noPadding alignTop txtRight">Net Amount</th>
                        <th class="th noPadding alignTop txtRight">Created By</th>
                        <th class="th noPadding alignTop txtRight">Created Date</th>
                    </tr>
                @elseif($trnType == "P" || $trnType == "PR")
                    <tr>
                        <th class="th noPadding alignTop txtLeft">Store</th>
                        <th width="4%" class="th noPadding alignTop txtRight">Vou No</th>
                        <th class="th alignTop txtRight">AmNo&emsp;</th>
                        <th width="6%" class="th noPadding alignTop ">&emsp;Vou Date</th>
                        <th class="th alignTop txtRight">Supp Bill No</th>
                        <th width="7%" class="th noPadding alignTop">&emsp;Supp Bill Date</th>
                        <th class="th noPadding alignTop">PO No&emsp;</th>
                        <th colspan="3" class="th noPadding alignTop">Supp Name</th>
                        <th width="6%" colspan="2" class="th noPadding alignTop txtRight">Gross</th>
                        <th width="4%" class="td noPadding alignTop "></th>
                        <th class="th noPadding alignTop txtRight">Disc%</th>
                        <th width="6%" class="th noPadding alignTop txtRight">Net Taxable&emsp;</th>
                        <th class="th noPadding alignTop txtRight">CGST&emsp;</th>
                        <th class="th noPadding alignTop txtRight">SGST&emsp;</th>
                        <th class="th noPadding alignTop txtRight">IGST&emsp;</th>
                        <th class="th noPadding alignTop txtRight">Sch Amt&emsp;</th>
                        <th class="th noPadding alignTop txtRight">R.Off</th>
                        <th colspan="3" class="th noPadding alignTop txtRight">Net Amt</th>
                        <th class="th noPadding alignTop txtRight">Created By</th>
                        <th class="th noPadding alignTop txtRight">Created Date</th>
                    </tr>
                @endif
                @if($reportType == "Detailed")
                    @if($trnType == 'I' || $trnType == 'IR')
                        <tr>
                            <td class="td noPadding alignTop txtRight">Sr&emsp;</td>
                            <td colspan="3" class="td noPadding alignTop">Medicine Name</td>
                            <td colspan="2" width="5%" class="td alignTop   txtLeft">Batch No&emsp;</td>
                            <td colspan="3" class="td noPadding alignTop txtRight"></td>
                            <td class="td noPadding alignTop txtRight">Qty</td>
                            <td class="td noPadding alignTop txtRight">Disc%</td>
                            <td width="6%" class="td noPadding alignTop txtRight">Net Taxable&emsp;</td>
                            <td class="td noPadding alignTop txtRight">CGST&emsp;</td>
                            <td class="td noPadding alignTop txtRight">SGST&emsp;</td>
                            <td width="5%" class="td noPadding alignTop txtRight">Total</td>
                            <td colspan="6" class="td noPadding alignTop txtRight"></td>
                        </tr>
                    @elseif($trnType == 'P' || $trnType == 'PR')
                        <tr>
                            <td class="td noPadding alignTop txtRight">Sr&emsp;</td>
                            <td colspan="3" class="td noPadding alignTop">Medicine Name</td>
                            <td class="td noPadding alignTop txtRight">Qty</td>
                            <td class="td noPadding alignTop txtRight">FQty</td>
                            <td colspan="2" width="5%" class="td alignTop txtLeft">&emsp;Batch No</td>
                            <td colspan="2" class="td noPadding alignTop txtLeft">Exp</td>
                            <td width = "5%" class="td noPadding alignTop txtRight">Sch Amt&emsp;</td>
                            <td class="td noPadding alignTop txtRight">MRP</td>
                            <td class="td noPadding alignTop txtRight">Rate&emsp;</td>
                            <td class="td noPadding alignTop txtRight">Disc%</td>
                            <td width="6%" class="td noPadding alignTop txtRight">Net Taxable&emsp;</td>
                            <td class="td noPadding alignTop txtRight">CGST&emsp;</td>
                            <td class="td noPadding alignTop txtRight">SGST&emsp;</td>
                            <td class="td noPadding alignTop txtRight">IGST&emsp;</td>
                            <td width="5%" class="td noPadding alignTop txtRight">Total&emsp;</td>
                            <td colspan="6" class="td noPadding alignTop txtRight"></td>
                        </tr>
                    @endif
                @endif
        </thead>
        <tbody>
        @php
            $previousTrnTypeTrnId = null;
        @endphp

        @foreach($headerData as $headerItem)
            @php
                $trnDate = \Carbon\Carbon::parse($headerItem->trn_date);
                $headerDate = $trnDate->format('d/m/Y');
                if($trnType == "P" && $headerItem->purchase_order_no > 0) {
                    $po = "PO" . $headerItem->purchase_order_no;
                }
            @endphp
            <tr>
                @if ($headerItem->trn_type . $headerItem->trn_id !== $previousTrnTypeTrnId)

                    <td width="6%" class="td bold alignTop noPadding borderTop txtLeft ">{{ $headerItem->gm_description }}</td>
                    <td width="4%" class="td bold alignTop noPadding borderTop txtRight ">{{ $headerItem->trn_type."/".$headerItem->trn_fyear."/" . $headerItem->trn_id }}</td>
                    @if($trnType == "I" || $trnType == "IR")
                        <td class="td bold alignTop noPadding borderTop txtRight ">&emsp;{{ $headerItem->bill_amendment }}&emsp;</td>
                        <td class="td bold alignTop noPadding borderTop ">{{ $headerDate }}</td>
                        <td colspan="3" class="td bold alignTop noPadding borderTop ">{{ $headerItem->patient_id }} / {{ $headerItem->patient_name }}</td>
                    @elseif($trnType == "P" || $trnType == "PR")
                        <td class="td bold alignTop noPadding borderTop txtRight ">{{ $headerItem->bill_amendment }}&emsp;</td>
                        <td width="6%" class="td bold alignTop noPadding borderTop ">&emsp;{{ $headerItem->trn_date }}</td>
                        <td class="td bold alignTop noPadding borderTop txtRight ">{{ $headerItem->purchase_bill_no }}</td>
                        <td width="7%" class="td bold  alignTop noPadding borderTop ">&emsp;{{ $headerItem->purchase_bill_date }}</td>
                        <td class="td bold  alignTop noPadding borderTop ">{{ $po ?? '' }}</td>
                        <td colspan="3" class="td bold  alignTop noPadding borderTop ">{{ $headerItem->supplier_name }}</td>
                    @endif
                    <td width="6%" colspan="2" class="td bold alignTop noPadding borderTop txtRight ">{{ $headerItem->gross_total }}</td>
                    <td width="4%" class="td  alignTop noPadding borderTop "></td>
                    <td class="td bold alignTop noPadding borderTop txtRight ">{{ $headerItem->discount_amt }}</td>
                    <td class="td bold alignTop noPadding borderTop txtRight ">{{ $headerItem->net_taxable_amt }}&emsp;</td>
                    <td class="td bold alignTop noPadding borderTop txtRight ">{{ $headerItem->cgst_amt }}&emsp;</td>
                    <td class="td bold alignTop noPadding borderTop txtRight ">{{ $headerItem->sgst_amt }}&emsp;</td>
                    @if($trnType == "P" || $trnType == "PR")
                        <td class="td bold  alignTop noPadding borderTop  txtRight">{{ $headerItem->igst_amt }}&emsp;</td>
                        <td class="td bold  alignTop noPadding borderTop  txtRight">{{ $headerItem->sch_amount }}&emsp;</td>
                    @endif
                    <td class="td bold alignTop noPadding borderTop txtRight ">{{ $headerItem->round_off }}</td>
                    <td colspan="3" class="td bold alignTop noPadding borderTop txtRight ">{{ $headerItem->total }}</td>
                    <td class="td bold alignTop noPadding borderTop txtRight ">{{ $headerItem->created_by }}</td>
                    <td class="td bold alignTop noPadding borderTop txtRight ">{{ $headerItem->created_date }}</td>

                @else
                    <td width="6%" class="td bold alignTop noPadding  txtLeft "></td>
                    <td class="td bold alignTop noPadding  txtRight "></td>
                    @if($trnType == "I" || $trnType == "IR")
                        <td class="td bold alignTop noPadding  txtRight ">&emsp;{{ $headerItem->bill_amendment }}&emsp;</td>
                        <td class="td bold alignTop noPadding  ">{{ $headerDate }}</td>
                    @elseif($trnType == "P" || $trnType == "PR")
                        <td class="td bold alignTop noPadding txtRight ">{{ $headerItem->bill_amendment }}&emsp;</td>
                        <td width="6%" class="td bold alignTop noPadding txtRight "></td>
                        <td class="td bold alignTop noPadding txtRight "></td>
                        <td class="td bold alignTop noPadding  ">&emsp;{{ $headerItem->purchase_bill_date }}</td>
                        <td class="td bold alignTop noPadding  "></td>
                    @endif
                    <td colspan="3" class="td bold alignTop noPadding txtLeft "></td>
                    <td width="6%" colspan="2" class="td bold alignTop noPadding  txtRight ">{{ $headerItem->gross_total }}</td>
                    <td class="td  alignTop noPadding "></td>
                    <td class="td bold alignTop noPadding  txtRight ">{{ $headerItem->discount_amt }}</td>
                    <td class="td bold alignTop noPadding  txtRight  ">{{ $headerItem->net_taxable_amt }}&emsp;</td>
                    <td class="td bold alignTop noPadding  txtRight ">{{ $headerItem->cgst_amt }}&emsp;</td>
                    <td class="td bold alignTop noPadding  txtRight ">{{ $headerItem->sgst_amt }}&emsp;</td>
                    @if($trnType == "P" || $trnType == "PR")
                        <td class="td bold alignTop noPadding  txtRight ">{{ $headerItem->igst_amt }}&emsp;</td>
                        <td class="td bold alignTop noPadding  txtRight ">{{ $headerItem->sch_amount }}&emsp;</td>
                    @endif
                    <td class="td bold alignTop noPadding  txtRight ">{{ $headerItem->round_off }}</td>
                    <td colspan="3" class="td bold alignTop noPadding  txtRight ">{{ $headerItem->total }}</td>
                    <td class="td bold alignTop noPadding  txtRight ">{{ $headerItem->created_by }}</td>
                    <td class="td bold alignTop noPadding  txtRight ">{{ $headerItem->created_date }}</td>
                @endif
            </tr>

            @if($reportType == "Detailed")
                @foreach($trn_data as $trn_dataItem)
                    @if($trnType == 'I' || $trnType == 'IR')
                        @if($trn_dataItem->trn_id == $headerItem->trn_id && $trn_dataItem->bill_amendment == $headerItem->bill_amendment)
                            <tr>
                                <td class="td  alignTop noPadding txtRight">{{$trn_dataItem->trn_sr_no}}&emsp;</td>
                                <td colspan="3" class="td  alignTop noPadding">{{$trn_dataItem->product_name}}</td>
                                <td colspan="2" width="5%" class="td alignTop noPadding txtLeft">{{$trn_dataItem->batch_no}}&emsp;</td>
                                <td colspan="3" class="td  alignTop noPadding txtRight"></td>
                                <td class="td  alignTop noPadding txtRight">{{$trn_dataItem->quantity}}</td>
                                <td class="td  alignTop noPadding txtRight">{{$trn_dataItem->discount_amt}}</td>
                                <td width="6%" class="td  alignTop noPadding txtRight">{{$trn_dataItem->taxable_amt}}&emsp;</td>
                                <td class="td  alignTop noPadding txtRight">{{$trn_dataItem->cgst_value}}&emsp;</td>
                                <td class="td  alignTop noPadding txtRight">{{$trn_dataItem->sgst_value}}&emsp;</td>
                                <td width="5%" class="td  alignTop noPadding txtRight">{{$trn_dataItem->total}}</td>
                                <td colspan="6" class="td  alignTop noPadding txtRight"></td>
                            </tr>
                        @endif
                    @elseif($trnType == 'P' || $trnType == 'PR')
                        @if($trn_dataItem->trn_id == $headerItem->trn_id && $trn_dataItem->bill_amendment == $headerItem->bill_amendment)
                            <tr>
                                <td class="td  alignTop noPadding txtRight">{{$trn_dataItem->trn_sr_no}}&emsp;</td>
                                <td colspan="3" class="td  alignTop noPadding">{{$trn_dataItem->product_name}}</td>
                                <td class="td  alignTop noPadding txtRight">{{$trn_dataItem->quantity}}</td>
                                <td class="td  alignTop noPadding txtRight">{{$trn_dataItem->free_quantity}}</td>
                                <td colspan="2" width="5%" class="td alignTop noPadding   txtLeft">&emsp;{{$trn_dataItem->batch_no}}</td>
                                <td colspan="2" class="td  alignTop noPadding txtLeft">{{ $trn_dataItem->batch_exp  }}</td>
                                <td width = "5%" class="td  alignTop noPadding txtRight">{{$trn_dataItem->sch_amt}}&emsp;</td>
                                <td class="td  alignTop noPadding txtRight">{{$trn_dataItem->mrp}}</td>
                                <td class="td  alignTop noPadding txtRight">{{$trn_dataItem->net_rate}}&emsp;</td>
                                <td class="td  alignTop noPadding txtRight">{{$trn_dataItem->discount_amt}}</td>
                                <td width="6%" class="td  alignTop noPadding txtRight">{{$trn_dataItem->taxable_amt}}&emsp;</td>
                                <td class="td  alignTop noPadding txtRight">{{$trn_dataItem->cgst_value}}&emsp;</td>
                                <td class="td  alignTop noPadding txtRight">{{$trn_dataItem->sgst_value}}&emsp;</td>
                                <td class="td  alignTop noPadding txtRight">{{$trn_dataItem->igst_value}}&emsp;</td>
                                <td width="5%" class="td  alignTop noPadding txtRight">{{$trn_dataItem->total}}&emsp;</td>
                                <td colspan="6" class="td  alignTop noPadding txtRight"></td>
                            </tr>
                        @endif
                    @endif
                @endforeach
            @endif

            @php
                $previousTrnTypeTrnId = $headerItem->trn_type . $headerItem->trn_id;
            @endphp
        @endforeach
        </tbody>
        @php
            $currentTime = \Carbon\Carbon::now();
        @endphp
        <tfoot>
            <th colspan="11" class="th smallFont noPadding alignTop borderTopBottom"></th>
            <td colspan="15" 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/SalesAmendmentView') }}" class="no-print btn btn-danger btn-sm">
                <span class="glyphicon glyphicon-arrow-left"></span> Back
            </a>
        </div>
    </div>
    @endsection