@extends('Reports.template') @php $reportTitle = ($trnType === 'GRN') ? 'Goods Receipt Note Report' : 'Goods Receipt Note Return Report'; @endphp @section('title') {{__($reportTitle)}} @endsection @section('ExternalCss') @parent @endsection @section('Content') @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) @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 @php if($productTransaction->ph_trn_status === 'P'){ $voucherStatus = Config::get('constants.reports.TRN_PARTIAL'); }else if($productTransaction->ph_trn_status === 'T'){ $voucherStatus = Config::get('constants.reports.TRN_CANCELLED'); }else if($productTransaction->ph_trn_status === 'C'){ $voucherStatus = Config::get('constants.reports.TRN_COMPLETED'); }else{ $voucherStatus = 'ALL'; } @endphp @endif @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
@if($businessEntityMasterData[0]->logo != null) Pharmacy Logologo )}}"/> @endif
{{ $businessEntityMasterData[0]->name }}
{{$businessEntityMasterData[0]->add1. " " .$businessEntityMasterData[0]->add2 ." ".$businessEntityMasterData[0]->city." : " .$businessEntityMasterData[0]->pincode }}
{{"Phone : ".$businessEntityMasterData[0]->tel1}}
{{__($reportTitle)}} {{__('Period')}} : {{\Helper::getDisplayDate($fromDate)}} {{__('TO')}} {{\Helper::getDisplayDate($toDate)}}
{{__(Config::get('constants.reports.TRN_NO'))}} {{__(Config::get('constants.reports.TRN_DATE'))}} {{__(Config::get('constants.reports.SUPPLIER_BILL_NO'))}} {{__(Config::get('constants.reports.SUPPLIER_BILL_DATE'))}} {{__(Config::get('constants.reports.SUPPLIER_NAME'))}} {{__('Supplier Address')}} {{__('GST NO')}} {{__('PO No.')}}
{{ $symbol }} {{ $productTransaction->trn_type.$productTransaction->ph_trn_id }} {{ \Helper::getDisplayDate($productTransaction->ph_trn_date) }} {{ $productTransaction->ph_purchase_bill_no }} {{ \Helper::getDisplayDate($productTransaction->ph_purchase_bill_date) }} {{ $productTransaction->supplier_name }} {{ $productTransaction->supplier_address1." ".$productTransaction->supplier_address2 }} {{ $productTransaction->supplier_gstin_no }} @if($productTransaction->ph_trn_type == "GRN" && $productTransaction->purchase_order_no > 0){{ "PO".$productTransaction->purchase_order_no }}@else{{ " " }}@endif
{{__('Gross')}} {{__('Disc')}} {{__('Net Taxable')}} {{__('CGST')}} {{__('SGST')}} {{__('IGST')}} {{__('Invoice')}} {{__('Scheme Amount')}} {{__('R. Off')}} {{__('Net Amount')}}
{{ \Helper::customAmountFormat($productTransaction->ph_gross_total) }} {{ \Helper::customAmountFormat($productTransaction->ph_discount_amt) }} {{ \Helper::customAmountFormat($productTransaction->ph_net_taxable_amt) }} {{ \Helper::customAmountFormat($productTransaction->ph_cgst_amt) }} {{ \Helper::customAmountFormat($productTransaction->ph_sgst_amt) }} {{ \Helper::customAmountFormat($productTransaction->ph_igst_amt) }} {{ \Helper::customAmountFormat($productTransaction->ph_invoice_amt) }} {{ \Helper::customAmountFormat($productTransaction->ph_sch_amount) }} {{ \Helper::customAmountFormat($productTransaction->ph_round_off) }} {{ \Helper::customAmountFormat($productTransaction->ph_total) }}
{{__('Sr')}}  {{__('Name')}} {{__('Mfg')}} {{__('Category')}} {{__('Unit')}} {{__('Qty')}} {{__('FQty')}}   {{__('Batch')}} {{__('Exp')}} {{__('Sch Amt')}} {{__('MRP')}} {{__('Rate')}} {{__('Disc')}}% {{__('Net Rate')}} {{__('Taxable')}} {{__('GST')}}% {{__('GST')}} {{__('Amount')}}
{{$transactionSr++}} {{ \Helper::zeroValueToNbspSpace($productTransaction->product_name) }} {{ \Helper::zeroValueToNbspSpace(strtoupper($productTransaction->manufacturer_code)) }} {{ \Helper::zeroValueToNbspSpace($productTransaction->category_abbrev) }} {{ \Helper::zeroValueToNbspSpace($productTransaction->unit_abbrev) }} {{ \Helper::zeroValueToNbspSpace($productTransaction->quantity) }} {{ \Helper::zeroValueToNbspSpace($productTransaction->free_quantity) }} {{ \Helper::zeroValueToNbspSpace($productTransaction->batch_no) }} {{ \Helper::getMonthYearFromDate($productTransaction->batch_exp) }} {{ \Helper::customAmountFormat($productTransaction->sch_amt) }} {{ \Helper::customAmountFormat($productTransaction->mrp) }} {{ \Helper::customAmountFormat4($productTransaction->price) }} {{ \Helper::customAmountFormat($productTransaction->discount) }} {{ \Helper::customAmountFormat($productTransaction->net_rate) }} {{ \Helper::customAmountFormat($productTransaction->taxable_amt) }} {{ \Helper::customAmountFormat(floatval($productTransaction->sgst_percentage) + floatval($productTransaction->cgst_percentage) + floatval($productTransaction->igst_percentage)) }} {{ \Helper::customAmountFormat(floatval($productTransaction->sgst_value) + floatval($productTransaction->cgst_value) + floatval($productTransaction->igst_value)) }} {{ \Helper::customAmountFormat($productTransaction->total) }}
@if($remark != '') {{__('Remarks')}} : {{$remark}} @endif {{__('Total')}} {{ \Helper::zeroValueToNbspSpace($totalQty)}} {{\Helper::zeroValueToNbspSpace($totalFreeQty)}} {{__("Created By")}}: @if($createdBy) {{$createdBy ." ".Carbon\Carbon::parse($datetime)->format('d-m-Y h:i:s')}} @endif
{{__('Back')}}
@endsection @section('BootstrapModals') @endsection @section('ExternalJs') @endsection