@php
$printData['start_date']=Request()->start_date?date('d-M-Y',strtotime(Request()->start_date)):date('d-M-Y');
$printData['end_date']=Request()->end_date?date('d-M-Y',strtotime(Request()->end_date)):date('d-M-Y');
$routeName=Route::currentRouteName();
$printData=getPrintData($routeName,$printData);
@endphp
{!!$printData['head']!!}
| {{__('obs.particulars')}} |
{{__('obs.balance')}} {{__('obs.before')}}
{{ date('d-m-y',strtotime(Request()->start_date))}} |
{{__('obs.transaction')}}
{{ date('d-m-y',strtotime(Request()->start_date)).' To '.date('d-m-y',strtotime(Request()->end_date))}} |
{{__('obs.balance')}}
{{ 'AT '.date('d-m-y',strtotime(Request()->end_date))}} |
| {{__('obs.sl')}} |
{{__('obs.account')}} {{__('obs.no')}} |
{{__('obs.account')}} {{__('obs.name')}} |
{{__('obs.debit')}} |
{{__('obs.credit')}} |
{{__('obs.debit')}} |
{{__('obs.credit')}} |
{{__('obs.debit')}} |
{{__('obs.credit')}} |
@php
$total_b_dr_amount=0;
$total_b_cr_amount=0;
$total_dr_amount=0;
$total_cr_amount=0;
$total_e_dr_amount=0;
$total_e_cr_amount=0;
$counter=1;
// $parent_show=0;
@endphp
@forelse ($ledgers->groupBy('parent_id') as $parent_id=>$searchedLedgers)
@php
$parent_show=1;
@endphp
@forelse ($searchedLedgers as $k=>$ledger)
@if(array_key_exists($ledger->id,$ledgerWiseBeginningBalanced) || array_key_exists($ledger->id,$ledgerWiseBalance) || array_key_exists($ledger->id,$ledgerWiseEndingBalance))
@php
$b_dr_amount=0;
$b_cr_amount=0;
$dr_amount=0;
$cr_amount=0;
$e_dr_amount=0;
$e_cr_amount=0;
if(array_key_exists($ledger->id,$ledgerWiseBeginningBalanced)){
$name=$ledgerWiseBeginningBalanced[$ledger->id]['name'];
if($ledgerWiseBeginningBalanced[$ledger->id]['amount']>0){
$b_dr_amount=$ledgerWiseBeginningBalanced[$ledger->id]['amount'];
}else{
$b_cr_amount=abs($ledgerWiseBeginningBalanced[$ledger->id]['amount']);
}
}
if(array_key_exists($ledger->id,$ledgerWiseBalance)){
$name=$ledgerWiseBalance[$ledger->id]['name'];
if($ledgerWiseBalance[$ledger->id]['amount']>0){
$dr_amount=$ledgerWiseBalance[$ledger->id]['amount'];
}else{
$cr_amount=abs($ledgerWiseBalance[$ledger->id]['amount']);
}
}
if(array_key_exists($ledger->id,$ledgerWiseEndingBalance)){
$name=$ledgerWiseEndingBalance[$ledger->id]['name'];
if($ledgerWiseEndingBalance[$ledger->id]['amount']>0){
$e_dr_amount=$ledgerWiseEndingBalance[$ledger->id]['amount'];
}else{
$e_cr_amount=abs($ledgerWiseEndingBalance[$ledger->id]['amount']);
}
}
$total_b_dr_amount+=$b_dr_amount;
$total_b_cr_amount+=$b_cr_amount;
$total_dr_amount+=$dr_amount;
$total_cr_amount+=$cr_amount;
$total_e_dr_amount+=$e_dr_amount;
$total_e_cr_amount+=$e_cr_amount;
@endphp
@if($parent_show)
{{-- @if($parent_show!=$ledger->parent_id) --}}
| {{$ledger->parent?$ledger->parent->auto_code.' - '.$ledger->parent->name:'N/A'}} |
@endif
| {{ $counter++ }} |
{{$ledger->auto_code}} |
{{$name}}
|
{{ number_format($b_dr_amount??0,2) }} |
{{ number_format($b_cr_amount??0,2) }} |
{{ number_format($dr_amount??0,2) }} |
{{ number_format($cr_amount??0,2) }} |
{{ number_format($e_dr_amount??0,2) }} |
{{ number_format($e_cr_amount??0,2) }} |
@php
$parent_show=0;//$ledger->parent_id;
@endphp
@endif
@empty
@endforelse
@empty
@endforelse
| {{__('obs.total')}} {{__('obs.transaction')}} |
{{ number_format($total_b_dr_amount??0,2) }} |
{{ number_format($total_b_cr_amount??0,2) }} |
{{ number_format($total_dr_amount??0,2) }} |
{{ number_format($total_cr_amount??0,2) }} |
{{ number_format($total_e_dr_amount??0,2) }} |
{{ number_format($total_e_cr_amount??0,2) }} |