{{-- left table --}}
{{-- @dd($company->bankLedger) --}}
| Our Bank Details |
| Bank Name : {{ $company->bankLedger->name ?? '' }} |
| Branch : {{ $company->bankLedger->branch ?? '' }} |
{{-- @if ($company->bankLedger->account_holder_name != null)
Account Holder Name : {{ $company->bankLedger->account_holder_name }}
@endif --}}
| A/C No : {{ $company->bankLedger->account_number ?? '' }} |
|
{{-- right table --}}
@php
$summary = $accountingVoucher
->items()
->join('stock_items', 'accounting_voucher_items.stock_item_id', '=', 'stock_items.id')
->where('stock_items.gst', '>', 0)
->select(
\DB::raw('stock_items.gst'),
\DB::raw('SUM(accounting_voucher_items.cgst) as cgst'),
\DB::raw('SUM(accounting_voucher_items.sgst) as sgst'),
\DB::raw('SUM(accounting_voucher_items.igst) as igst'),
\DB::raw('SUM(accounting_voucher_items.taxable_value) as taxable_value'),
)->groupBy( 'stock_items.gst')
->get();
@endphp
@foreach ($summary as $s)
| [Add] SGST Amount {{number_format($s->gst/2) }}% : {{ $s->sgst }} |
| [Add] CGST Amount {{number_format($s->gst/2) }}% : {{ $s->cgst }} |
@endforeach
|
|
|
{{-- bill calculation --}}
| BILL AMOUNT |
:{{ round($accountingVoucher->items()->sum('taxable_value'), 2) }} |
| ADD GST 18% |
: {{$accountingVoucher->items()->sum('igst') + $accountingVoucher->items()->sum('cgst') + $accountingVoucher->items()->sum('sgst')}} |
|
|
| NET AMOUNT |
: {{ $accountingVoucher->amount }} |
|