Excel CSV PDF
@php $total_contract = 0; $total_gov_fee = 0; $total_vat = 0; $total_net = 0; $total_amount = 0; $total_received = 0; @endphp @foreach ($company->quotations as $quotation ) @if ($quotation->status) @php $total_contract += $quotation->amount; @endphp @endif @endforeach
@lang('models/reports.company.quotation') @lang('models/reports.company.lpo') @lang('models/reports.company.ref_no') @lang('models/reports.company.type') @lang('models/reports.company.invoice_no') @lang('models/reports.company.due_date') @lang('models/reports.company.contract_value') @lang('models/reports.company.net') @lang('models/reports.company.vat') @lang('models/reports.company.cd_govt_fee') @lang('models/reports.company.total_amount') @lang('models/reports.company.payment_received') @lang('models/reports.company.payment_type') @lang('models/reports.company.payment_date') @lang('models/reports.company.chq_ref') @lang('models/reports.company.chq_date') @lang('models/reports.company.note')
{{$quotation->name}} {{$quotation->lpoins->ref_no}} {{$quotation->ref_no}} @php $total=count($quotation->invoices); @endphp @foreach ($quotation->invoices as $invoice) @php $total_vat += $invoice->vat; $total_gov_fee += $invoice->invoice_service_details->sum('amount'); $total_net += $invoice->amount - $invoice->invoice_service_details->sum('amount'); $total_amount += $invoice->total_amount; $total_received = $invoice->transaction ? $total_received + $invoice->transaction->total : $total_received; @endphp @endforeach
{{$invoice->invoice_type->name}} {{$invoice->invoice_no}} {{$invoice->end_date}}
{{$quotation->amount}} @foreach ($quotation->invoices as $invoice) @endforeach
{{$invoice->amount - $invoice->invoice_service_details->sum('amount')}} {{$invoice->vat}} {{ $invoice->invoice_service_details->sum('amount') }} {{$invoice->total_amount}} {{ $invoice->transaction->total ?? ''}} {{ $invoice->transaction->transaction_payment_type->name ?? ''}} {{ $invoice->transaction->date_time ?? ''}} @if($invoice->transaction && $invoice->transaction->transaction_payment_type->name == 'Cash') {{ "" }} @elseif($invoice->transaction && $invoice->transaction->transaction_payment_type->name == 'Cheque') {{ $invoice->transaction->payment_no }} @endif @if($invoice->transaction && $invoice->transaction->transaction_payment_type->name == 'Cheque') {{ $invoice->transaction->clearance_date }} @endif {{ $invoice->transaction->note ?? '' }}
{{ $total_contract }} {{ $total_net }} {{ $total_vat }} {{ $total_gov_fee }} {{ $total_amount }} {{ $total_received }}
Total Contract Value {{ $total_contract }}
Total Unbilled Contract Balance, Net Amount {{ $total_contract - $total_net }}
Total Billed Amount {{ $total_amount }}
Total Payment Received {{ $total_received }}
Total Outstanding Amount {{ $total_amount - $total_received }}
{{-- @section('scripts') --}} {{-- @parent @endsection --}}