@extends('Reports.template')

@if($trnType == "CSN")
@php
$reportTitle = 'Consignment Purchase Register Report';
@endphp
@elseif($trnType == "CSNR")
@php
$reportTitle = 'Consignment Purchase Return Register Report';
@endphp
@else
@php
$reportTitle = 'Consignment Purchase & Consignment Purchase 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="17" 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="7" class="th borderNone borderBottom reportTitle">{{__($reportTitle)." "}}<label class="fontsize12 bold"> ({{__('Status')}} : {{__($trnStatusMessage)}})</label></th>
            <th colspan="4" class="txtRight th borderNone borderBottom">{{__('Store')}} : {{$storeName}}</th>
            <th colspan="8" class="txtRight th borderNone borderBottom">{{__('Period')}} : {{\Helper::getDisplayDate($fromDate)}} {{__('TO')}} {{\Helper::getDisplayDate($toDate)}}</th>
        </tr>
        <tr>
            <th width="8%" class="th noPadding alignTop borderTop borderBottomGray txtCenter">{{__('Vou No')}}</th>
            <th width="4%" class="th noPadding alignTop borderTop borderBottomGray txtCenter">{{__('Vou Date')}}</th>
            <th class="th noPadding alignTop borderTop borderBottomGray">{{__('Supp Bill No')}}</th>
            <th width="8%" class="th noPadding alignTop borderTop borderBottomGray">{{__('Supp Bill Date')}}</th>
            <th class="th noPadding alignTop borderTop borderBottomGray">{{__('Credit Bill')}}</th>
            <th colspan="2" class="th noPadding alignTop borderTop borderBottomGray">{{__('Supp Name')}}</th>
            <th class="th noPadding alignTop borderTop borderBottomGray txtRight">{{__('Gross')}}</th>
            <th class="th noPadding alignTop borderTop borderBottomGray txtRight">{{__('Disc')}}</th>
            <th width="6%" class="th noPadding alignTop borderTop borderBottomGray txtRight">{{__('Net Taxable')}}</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">{{__('IGST')}}</th>
            <th class="th noPadding alignTop borderTop borderBottomGray txtRight">{{__('Invoice')}}</th>
            <th class="th noPadding alignTop borderTop borderBottomGray txtRight">&emsp;{{__('Sch Amt')}}</th>
            <th class="th noPadding alignTop borderTop borderBottomGray txtRight">&emsp;{{__('TCS Amt')}}</th>
            <th width="5%" class="th noPadding alignTop borderTop borderBottomGray txtRight">{{__('R. Off')}}</th>
            <th colspan="2" class="th noPadding alignTop borderTop borderBottomGray txtRight">{{__('Net Amount')}}</th>
        </tr>
        @if($reportType === 'B')
        <tr>
            <th class="th notBold noPadding alignTop borderTopBottom txtRight">{{__('Sr')}}</th>
            <th class="th notBold noPadding alignTop borderTopBottom">&nbsp;{{__('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">{{__('Ref No.')}}</th>
            <th class="th notBold noPadding alignTop borderTopBottom txtRight">{{__('Qty')}}</th>
            <th class="th notBold noPadding alignTop borderTopBottom txtRight">{{__('FQty')}}&emsp;</th>
            <th class="th notBold noPadding alignTop borderTopBottom">&nbsp;&nbsp;{{__('Batch')}}</th>
            <th class="th notBold noPadding alignTop borderTopBottom">{{__('Exp')}}</th>
            <th class="th notBold noPadding alignTop borderTopBottom txtRight">{{__('Sch Amt')}}</th>
            <th class="th notBold noPadding alignTop borderTopBottom txtRight">{{__('MRP')}}</th>
            <th class="th notBold noPadding alignTop borderTopBottom txtRight">{{__('Rate')}}</th>
            <th class="th notBold noPadding alignTop borderTopBottom txtRight">{{__('Disc')}}%</th>
            <th class="th notBold noPadding alignTop borderTopBottom txtRight">{{__('Net Rate')}}</th>
            <th class="th notBold noPadding alignTop borderTopBottom txtRight">{{__('Taxable')}}</th>
            <th class="th notBold noPadding alignTop borderTopBottom txtRight">{{__('GST')}}%</th>
            <th class="th notBold noPadding alignTop borderTopBottom txtRight">{{__('GST')}}</th>
            <th class="th notBold noPadding alignTop borderTopBottom txtRight">{{__('Amount')}}</th>
        </tr>
        @endif
    </thead>
    <tbody>
        @php
        $oldPhTrnType = '';
        $oldPhTrnId = '';
        $createdBy = '';

        $headerSr = 1;
        $transactionSr = 1;
        $datetime = 0;
        $totalQty = 0;
        $remark = '';
        $totalFreeQty = 0;
        $totalAmount = 0;
        $strike = 'noStrike';
        $symbol = '';

        $summaryBills = 0;
        $summaryGrossTotal = 0;
        $summaryDiscount = 0;
        $summaryNetTaxableAmt = 0;
        $summaryCgstAmt = 0;
        $summarySgstAmt = 0;
        $summaryIgstAmt = 0;
        $summaryInvoiceAmt = 0;
        $summarySchAmt = 0;
        $summaryTcsAmt = 0;
        $summaryRoundOff = 0;
        $summaryTotal = 0;
        @endphp
        @foreach ($productTransactionData as $key =>$productTransaction)
        @if($productTransaction->ph_trn_id != $oldPhTrnId || $productTransaction->ph_trn_type != $oldPhTrnType)

        @if($totalQty != 0)
        @if($reportType === 'B')
        <tr>
            <td colspan="5" class="td borderNone {{$strike}}">
                @if($remark != '')
                {{__('Remarks')}} : <span class="notBold ">{{$remark}}</span>
                @endif
            </td>
            <td colspan="1" class="td bold alignTop txtRight borderTopBottom {{$strike}}">{{__('Total Qty')}} : </td>
            <td colspan="1" class="td bold alignTop txtRight borderTopBottom {{$strike}}">{{ \Helper::zeroValueToNbspSpace($totalQty)}}</td>
            <td colspan="1" class="td bold alignTop borderTopBottom txtRight {{$strike}}">{{\Helper::zeroValueToNbspSpace($totalFreeQty)}}&emsp;</td>
            <td colspan="11" class="td notBold alignTop borderTopBottom smallFont txtRight {{$strike}}"> 
                <i>{{__("Created By")}}:</i>
                @if($createdBy)
                {{$createdBy ."  ".Carbon\Carbon::parse($datetime)->format('d-m-Y h:i:s')}}
                @endif
            </td>
        </tr>
        @endif
        @endif

        @php
        $transactionSr = 1;
        $totalQty = 0;
        $remark = '';
        $datetime = 0;
        $totalFreeQty = 0;
        $totalAmount = 0;
        $strike = 'noStrike';
        $symbol = '';
        @endphp

        @if($productTransaction->ph_trn_status == 'T')
        @php
        $strike = 'strike';
        @endphp
        @elseif($productTransaction->ph_trn_status == 'P')
        @php
        $symbol = '*';
        @endphp
        @endif

        @if($productTransaction->trn_type == "CSN")
        @php
        $phGrossTotal = $productTransaction->ph_gross_total;
        $phDiscountAmt = $productTransaction->ph_discount_amt;
        $phNetTaxableAmt = $productTransaction->ph_net_taxable_amt;
        $phCgstAmt = $productTransaction->ph_cgst_amt;
        $phSgstAmt = $productTransaction->ph_sgst_amt;
        $phIgstAmt = $productTransaction->ph_igst_amt;
        $phInvoiceAmt = $productTransaction->ph_invoice_amt;
        $phSchAmount = $productTransaction->ph_sch_amount;
        $phTcsAmount = $productTransaction->ph_tcs_amount;
        $phRoundOff = $productTransaction->ph_round_off;
        $phTotal = $productTransaction->ph_total;
        @endphp
        @else
        @php
        $phGrossTotal = -1 * $productTransaction->ph_gross_total;
        $phDiscountAmt = -1 * $productTransaction->ph_discount_amt;
        $phNetTaxableAmt = -1 * $productTransaction->ph_net_taxable_amt;
        $phCgstAmt = -1 * $productTransaction->ph_cgst_amt;
        $phSgstAmt = -1 * $productTransaction->ph_sgst_amt;
        $phIgstAmt = -1 * $productTransaction->ph_igst_amt;
        $phInvoiceAmt = -1 * $productTransaction->ph_invoice_amt;
        $phSchAmount = -1 * $productTransaction->ph_sch_amount;
        $phTcsAmount = -1 * $productTransaction->ph_tcs_amount;
        $phRoundOff = -1 * $productTransaction->ph_round_off;
        $phTotal = -1 * $productTransaction->ph_total;
        @endphp
        @endif

        <tr>
            <td width="8%" class="td bold alignTop borderTopBottom txtRight {{$strike}}"><span class="fontsize10">{{ $symbol }}</span> {{ $productTransaction->trn_type." / ".$productTransaction->trn_fyear." / ".$productTransaction->ph_trn_id }}</td>
            <td class="td bold alignTop borderTopBottom {{$strike}}">{{ \Helper::getDisplayDate($productTransaction->ph_trn_date) }}</td>
            <td class="td bold alignTop borderTopBottom {{$strike}}">{{ $productTransaction->ph_purchase_bill_no }}</td>
            <td class="td bold alignTop borderTopBottom {{$strike}}">{{ \Helper::getDisplayDate($productTransaction->ph_purchase_bill_date) }}</td>
            <td class="td bold alignTop borderTopBottom {{$strike}}">@if($productTransaction->is_credit_bill == "Y"){{ "Yes" }}@else{{ "No" }}@endif</td>
            <td colspan="2" class="td bold alignTop borderTopBottom {{$strike}}">{{ $productTransaction->supplier_name }}</td>
            <td class="td bold alignTop borderTopBottom txtRight {{$strike}}">{{ \Helper::customAmountFormat($phGrossTotal) }}</td>
            <td class="td bold alignTop borderTopBottom txtRight {{$strike}}">{{ \Helper::customAmountFormat($phDiscountAmt) }}</td>
            <td class="td bold alignTop borderTopBottom txtRight {{$strike}}">{{ \Helper::customAmountFormat($phNetTaxableAmt) }}</td>
            <td class="td bold alignTop borderTopBottom txtRight {{$strike}}">{{ \Helper::customAmountFormat($phCgstAmt) }}</td>
            <td class="td bold alignTop borderTopBottom txtRight {{$strike}}">{{ \Helper::customAmountFormat($phSgstAmt) }}</td>
            <td class="td bold alignTop borderTopBottom txtRight {{$strike}}">{{ \Helper::customAmountFormat($phIgstAmt) }}</td>
            <td class="td bold alignTop borderTopBottom txtRight {{$strike}}">{{ \Helper::customAmountFormat($phInvoiceAmt) }}</td>
            <td class="td bold alignTop borderTopBottom txtRight {{$strike}}">&emsp;{{ \Helper::customAmountFormat($phSchAmount) }}</td>
            <td class="td bold alignTop borderTopBottom txtRight {{$strike}}">&emsp;{{ \Helper::customAmountFormat($phTcsAmount) }}</td>
            <td class="td bold alignTop borderTopBottom txtRight {{$strike}}">{{ \Helper::customAmountFormat($phRoundOff) }}</td>
            <td colspan="4" class="td bold alignTop borderTopBottom txtRight {{$strike}}">{{ \Helper::customAmountFormat($phTotal) }}</td>
        </tr>
        @endif
        @if($reportType === 'B')
        @php
        $refTrnNo = 0;
        @endphp
        @if($productTransaction->trn_type != "CSN" && $productTransaction->ref_trn_id != 0)
        @php
        $refTrnNo = "CSN" . $productTransaction->ref_trn_id;
        @endphp
        @endif
        <tr>
            <td class="td notBold alignTop borderTopGray txtRight {{$strike}}">{{$transactionSr++}}</td>
            <td class="td notBold alignTop borderTopGray {{$strike}}">{{ \Helper::zeroValueToNbspSpace($productTransaction->product_name) }}</td>
            <td class="td notBold alignTop borderTopGray {{$strike}}">{{ \Helper::zeroValueToNbspSpace(strtoupper($productTransaction->manufacturer_code)) }}</td>
            <td class="td notBold alignTop borderTopGray {{$strike}}">{{ \Helper::zeroValueToNbspSpace($productTransaction->category_abbrev) }}</td>
            <td class="td notBold alignTop borderTopGray {{$strike}}">{{ \Helper::zeroValueToNbspSpace($productTransaction->unit_abbrev) }}</td>
            <td class="td notBold alignTop borderTopGray {{$strike}}">{{ \Helper::zeroValueToNbspSpace($refTrnNo) }}</td>
            <td class="td notBold alignTop borderTopGray txtRight {{$strike}}">{{ \Helper::zeroValueToNbspSpace($productTransaction->quantity) }}</td>
            <td class="td notBold alignTop borderTopGray txtRight {{$strike}}">{{ \Helper::zeroValueToNbspSpace($productTransaction->free_quantity) }}&emsp;</td>
            <td class="td notBold alignTop borderTopGray {{$strike}}">{{ \Helper::zeroValueToNbspSpace($productTransaction->batch_no) }}</td>
            <td class="td notBold alignTop borderTopGray {{$strike}}">{{ \Helper::getMonthYearFromDate($productTransaction->batch_exp) }}</td>
            <td class="td notBold alignTop borderTopGray txtRight {{$strike}}">{{ \Helper::customAmountFormat($productTransaction->sch_amt) }}</td>
            <td class="td notBold alignTop borderTopGray txtRight {{$strike}}">{{ \Helper::customAmountFormat($productTransaction->mrp) }}</td>
            <td class="td notBold alignTop borderTopGray txtRight {{$strike}}">{{ \Helper::customAmountFormat($productTransaction->price) }}</td>
            <td class="td notBold alignTop borderTopGray txtRight {{$strike}}">{{ \Helper::customAmountFormat($productTransaction->discount) }}</td>
            <td class="td notBold alignTop borderTopGray txtRight {{$strike}}">{{ \Helper::customAmountFormat($productTransaction->net_rate) }}</td>
            <td class="td notBold alignTop borderTopGray txtRight {{$strike}}">{{ \Helper::customAmountFormat($productTransaction->taxable_amt) }}</td>
            <td class="td notBold alignTop borderTopGray txtRight {{$strike}}">{{ \Helper::customAmountFormat(floatval($productTransaction->sgst_percentage) + floatval($productTransaction->cgst_percentage) + floatval($productTransaction->igst_percentage)) }}</td>
            <td class="td notBold alignTop borderTopGray txtRight {{$strike}}">{{ \Helper::customAmountFormat(floatval($productTransaction->sgst_value) + floatval($productTransaction->cgst_value) + floatval($productTransaction->igst_value)) }}</td>
            <td class="td notBold alignTop borderTopGray txtRight {{$strike}}">{{ \Helper::customAmountFormat($productTransaction->total) }}</td>
        </tr>
        @endif
        @php
        $createdBy = strtoupper($productTransaction->ph_created_by); 
        $totalQty += $productTransaction->quantity;
        $remark = $productTransaction->ph_remarks;
        $totalFreeQty += $productTransaction->free_quantity;
        $totalAmount += $productTransaction->total;
        $datetime =$productTransaction->created_date;
        $oldPhTrnType = $productTransaction->ph_trn_type;
        $oldPhTrnId = $productTransaction->ph_trn_id;

        @endphp
        @endforeach
        @if($reportType === 'B')
        <tr>
            <td colspan="5" class="td borderNone {{$strike}}">
                @if($remark != '')
                {{__('Remarks')}} : <span class="notBold ">{{$remark}}</span>
                @endif
            </td>
            <td colspan="1" class="td bold alignTop txtRight borderTopBottom {{$strike}}">{{__('Total Qty')}} : </td>
            <td colspan="1" class="td bold alignTop txtRight borderTopBottom {{$strike}}">{{ \Helper::zeroValueToNbspSpace($totalQty)}}</td>
            <td colspan="1" class="td bold alignTop borderTopBottom txtRight {{$strike}}">{{\Helper::zeroValueToNbspSpace($totalFreeQty)}}&emsp;</td>
            <td colspan="11" class="td smallFont notBold alignTop borderTopBottom txtRight {{$strike}}">
                <i>{{__("Created By")}}:</i>
                @if($createdBy)
                {{$createdBy ."  ".Carbon\Carbon::parse($datetime)->format('d-m-Y h:i:s')}}
                @endif
            </td>
        </tr>
        @endif
        @foreach ($productSummary as $key =>$summary)
        @if($summary->trn_type == "CSN")
        @php
        $footerHeading = "Total Consignment Purchase Bills :"    
        @endphp
        @else
        @php
        $footerHeading = "Total Consignment Purchase Return Bills :"    
        @endphp
        @endif
        @php
        $summaryBills += $summary->Bills;
        $summaryGrossTotal += $summary->gross_total;
        $summaryDiscount += $summary->discount;
        $summaryNetTaxableAmt += $summary->net_taxable_amt;
        $summaryCgstAmt += $summary->cgst_amt;
        $summarySgstAmt += $summary->sgst_amt;
        $summaryIgstAmt += $summary->igst_amt;
        $summaryInvoiceAmt += $summary->invoice_amt;
        $summarySchAmt += $summary->sch_amount;
        $summaryTcsAmt += $summary->tcs_amount;
        $summaryRoundOff += $summary->round_off;
        $summaryTotal += $summary->total;
        @endphp
        <tr>
            <td colspan="6" class="td bold alignTop txtRight borderTopBottom">{{__($footerHeading)." ".\Helper::zeroValueToNbspSpace($summary->Bills)}}</td>
            <td colspan="2" class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($summary->gross_total)}}</td>
            <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($summary->discount)}}</td>
            <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($summary->net_taxable_amt)}}</td>
            <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($summary->cgst_amt)}}</td>
            <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($summary->sgst_amt)}}</td>
            <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($summary->igst_amt)}}</td>
            <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($summary->invoice_amt)}}</td>
            <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($summary->sch_amount)}}</td>
            <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($summary->tcs_amount)}}</td>
            <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($summary->round_off)}}</td>
            <td colspan="2" class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($summary->total)}}</td>
        </tr>
        @endforeach
        @if(!empty($productSummary))
        <tr>
            <td colspan="6" class="td bold alignTop txtRight borderTopBottom">{{__('Total Bills')}} : {{\Helper::zeroValueToNbspSpace($summaryBills)}}</td>
            <td colspan="2" class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($summaryGrossTotal)}}</td>
            <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($summaryDiscount)}}</td>
            <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($summaryNetTaxableAmt)}}</td>
            <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($summaryCgstAmt)}}</td>
            <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($summarySgstAmt)}}</td>
            <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($summaryIgstAmt)}}</td>
            <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($summaryInvoiceAmt)}}</td>
            <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($summarySchAmt)}}</td>
            <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($summaryTcsAmt)}}</td>
            <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($summaryRoundOff)}}</td>
            <td colspan="2" class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($summaryTotal)}}</td>
        </tr>
        @endif
    </tbody>
    @php 
    $currentTime  = \Carbon\Carbon::now(); 
    @endphp
    <tfoot>
    <td colspan="11" class="th smallFont noPadding alignTop borderTopBottom"><span class="fontsize10">&#10033;</span> {{__('Partially save')}}</td>
    <td colspan="8" 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/ConsignmentRegisterInput') }}" 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-->