@extends('Reports.template')

@php
$reportTitle = ($trnType === 'P') ? 'Purchase Register Report' : 'Purchase Return Register Report';
@endphp
<!--Title-->
@section('title')
{{$reportTitle}}
@endsection
<!--Title Close-->

<!--External CSS-->
@section('ExternalCss')
@parent
<style>
    @media print {
        @page { size: A4 landscape; margin:0;}
        .table{page-break-before:always; }
    }
</style>
@endsection
<!--External CSS Close-->

@section('Content')
@php
$reportTitle = ($trnType === 'P' || $trnType === 'CSN') ? 'Purchase Voucher' : 'Purchase Return Voucher';
if($trnStatus === 'P'){
$trnStatusMessage =  Config::get('constants.reports.TRN_PARTIAL');
}else if($trnStatus === 'T'){
$trnStatusMessage =  Config::get('constants.reports.TRN_CANCELLED');
}else if($trnStatus === 'C'){
$trnStatusMessage =  Config::get('constants.reports.TRN_COMPLETED');
}else{
$trnStatusMessage =  'ALL';
}
@endphp
<!-- Your Page Content Here -->

@php
$oldPhTrnId = '';
$createdBy = '';

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

@endphp
@foreach ($productTransactionData as $key =>$productTransaction)
@if($trnStatus == $productTransaction->ph_trn_status || $trnStatus == 'A' || $trnStatus == '')
@if($productTransaction->ph_trn_id != $oldPhTrnId)

@if($productTransaction->ph_trn_status == 'T')
@php
$strike = 'strike';
@endphp
@elseif($productTransaction->ph_trn_status == 'P')
@php
$symbol = '*';
@endphp
@endif
@if($key > 0)
<tr>
    <td colspan="5" class="td borderNone {{$strike}}">
        @if($remark != '')
        Remarks : <span class="notBold ">{{$remark}}</span>
        @endif
    </td>
    <td width="7%" class="td bold alignTop txtRight borderTopBottom {{$strike}}">Total Qty : </td>
    <td class="td bold alignTop txtRight borderTopBottom {{$strike}}">{{ \Helper::zeroValueToNbspSpace($totalQty)}}</td>
    <td class="td bold alignTop borderTopBottom txtRight {{$strike}}">{{\Helper::zeroValueToNbspSpace($totalFreeQty)}}</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
@php
$transactionSr = 1;
$totalQty = 0;
$remark = '';
$datetime =0;
$totalFreeQty = 0;
$totalAmount = 0;
$strike = 'noStrike';
$symbol = '';
@endphp

<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="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="9" 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="6" class="txtRight th borderNone borderBottom">
                Period : {{\Helper::getDisplayDate($fromDate)}} TO {{\Helper::getDisplayDate($toDate)}}
            </th>
        </tr>
        <tr>
            <th width="5%" class="th noPadding alignTop borderTop borderBottomGray txtCenter">{{Config::get('constants.reports.TRN_NO')}}</th>
            <th width="4%" class="th noPadding alignTop borderTop borderBottomGray">{{Config::get('constants.reports.TRN_DATE')}}</th>
            <th class="th noPadding alignTop borderTop borderBottomGray">{{Config::get('constants.reports.SUPPLIER_BILL_NO')}}</th>
            <th width="8%" class="th noPadding alignTop borderTop borderBottomGray">{{Config::get('constants.reports.SUPPLIER_BILL_DATE')}}</th>
            <th colspan="4" class="th noPadding alignTop borderTop borderBottomGray">{{Config::get('constants.reports.SUPPLIER_NAME')}}</th>
            <th colspan="5" class="th noPadding alignTop borderTop borderBottomGray">Supplier Address</th>
            <th colspan="4" class="th noPadding alignTop borderTop borderBottomGray">GST NO</th>
            <th colspan="2" class="th noPadding alignTop borderTop borderBottomGray">Credit Bill</th>
            <th class="th noPadding alignTop borderTop borderBottomGray">PO No.</th>
        </tr>
        <tr>
            <th class="th bold alignTop borderTopBottom txtRight {{$strike}}"><span class="fontsize10">{{ $symbol }}</span> {{ $productTransaction->trn_type.'/'.$productTransaction->trn_fyear.'/'.$productTransaction->ph_trn_id }}</th>
            <th class="th bold alignTop borderTopBottom {{$strike}}">{{ \Helper::getDisplayDate($productTransaction->ph_trn_date) }}</th>
            <th class="th bold alignTop borderTopBottom {{$strike}}">{{ $productTransaction->ph_purchase_bill_no }}</th>
            <th class="th bold alignTop borderTopBottom {{$strike}}">{{ \Helper::getDisplayDate($productTransaction->ph_purchase_bill_date) }}</th>
            <th colspan="4" class="th bold alignTop borderTopBottom {{$strike}}">{{ $productTransaction->supplier_name }}</th>
            <th colspan="5" class="th bold alignTop borderTopBottom {{$strike}}">{{ $productTransaction->supplier_address1." ".$productTransaction->supplier_address2 }}</th>
            <th colspan="4" class="th bold alignTop borderTopBottom {{$strike}}">{{ $productTransaction->supplier_gstin_no }}</th>
            <th colspan="2" class="th bold alignTop borderTopBottom {{$strike}}">@if($productTransaction->is_credit_bill == 'Y'){{ "Yes" }}@else{{ "No" }}@endif</th>
            <th class="th bold alignTop borderTopBottom {{$strike}}">@if($productTransaction->ph_trn_type == "P" && $productTransaction->purchase_order_no > 0){{ "PO".$productTransaction->purchase_order_no }}@else{{ " " }}@endif</th>
        </tr>
        <tr>
            <th colspan="7" 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">Scheme Amount</th>
            <th class="th noPadding alignTop borderTop borderBottomGray txtRight">TCS Amount</th>
            <th width="5%" class="th noPadding alignTop borderTop borderBottomGray txtRight">R. Off</th>
            <th colspan="4" class="th noPadding alignTop borderTop borderBottomGray txtRight">Net Amount</th>
        </tr>
        <tr>
            <th colspan="7" class="th bold alignTop borderTopBottom txtRight {{$strike}}">{{ \Helper::customAmountFormat($productTransaction->ph_gross_total) }}</th>
            <th class="th bold alignTop borderTopBottom txtRight {{$strike}}">{{ \Helper::customAmountFormat($productTransaction->ph_discount_amt) }}</th>
            <th class="th bold alignTop borderTopBottom txtRight {{$strike}}">{{ \Helper::customAmountFormat($productTransaction->ph_net_taxable_amt) }}</th>
            <th class="th bold alignTop borderTopBottom txtRight {{$strike}}">{{ \Helper::customAmountFormat($productTransaction->ph_cgst_amt) }}</th>
            <th class="th bold alignTop borderTopBottom txtRight {{$strike}}">{{ \Helper::customAmountFormat($productTransaction->ph_sgst_amt) }}</th>
            <th class="th bold alignTop borderTopBottom txtRight {{$strike}}">{{ \Helper::customAmountFormat($productTransaction->ph_igst_amt) }}</th>
            <th class="th bold alignTop borderTopBottom txtRight {{$strike}}">{{ \Helper::customAmountFormat($productTransaction->ph_invoice_amt) }}</th>
            <th class="th bold alignTop borderTopBottom txtRight {{$strike}}">{{ \Helper::customAmountFormat($productTransaction->ph_sch_amount) }}</th>
            <th class="th bold alignTop borderTopBottom txtRight {{$strike}}">{{ \Helper::customAmountFormat($productTransaction->ph_tcs_amount) }}</th>
            <th class="th bold alignTop borderTopBottom txtRight {{$strike}}">{{ \Helper::customAmountFormat($productTransaction->ph_round_off) }}</th>
            <th colspan="4" class="th bold alignTop borderTopBottom txtRight {{$strike}}">{{ \Helper::customAmountFormat($productTransaction->ph_total) }}</th>
        </tr>
        <tr>
            <th class="th notBold noPadding alignTop borderTopBottom txtRight">Sr</th>
            <th width="15%" 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">Pack Size</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</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
        $refTrnNo = 0;
        @endphp
        @if($productTransaction->trn_type != "P" && $productTransaction->ref_trn_id != 0)
        @php
        $refTrnNo = "P" . $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 txtRight {{$strike}}">{{ \Helper::zeroValueToNbspSpace($productTransaction->conversion_factor) }}</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) }}</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>
        @php
        $createdBy = ($productTransaction->ph_modified_by) ? strtoupper($productTransaction->ph_modified_by) : strtoupper($productTransaction->ph_created_by);
        $totalQty += $productTransaction->quantity;
        $remark = $productTransaction->ph_remarks;
        $totalFreeQty += $productTransaction->free_quantity;
        $totalAmount += $productTransaction->total;
        $datetime =$productTransaction->created_date;
        $oldPhTrnId = $productTransaction->ph_trn_id;

        @endphp
        @endif
        @endforeach
        <tr>
            <td colspan="6" class="td borderNone {{$strike}}">
                @if($remark != '')
                Remarks : <span class="notBold ">{{$remark}}</span>
                @endif
            </td>
            <td width="7%" class="td bold alignTop txtRight borderTopBottom {{$strike}}">Total Qty : </td>
            <td class="td bold alignTop txtRight borderTopBottom {{$strike}}">{{ \Helper::zeroValueToNbspSpace($totalQty)}}</td>
            <td class="td bold alignTop borderTopBottom txtRight {{$strike}}">{{\Helper::zeroValueToNbspSpace($totalFreeQty)}}</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>
    </tbody>
</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" accesskey="E" id="btnexport" data-myval="{{$reportTitle}}">
            <span class="glyphicon glyphicon-download-alt"></span> Excel
        </button>
        <button onclick="print()" accesskey="P" class="btn btn-sm btn-success no-print">
            <span class="glyphicon glyphicon-print"></span> Print
        </button>
        <a href="