| @if(!empty($data->first()) && !empty($branch_id)) {{trans_choice('core::general.branch',1)}}: {{$data->first()->branch}} @endif | @if(!empty($data->first()) && !empty($loan_product_id)) {{trans_choice('loan::general.product',1)}}: {{$data->first()->loan_product}} @endif | @if(!empty($data->first()) && !empty($loan_officer_id)) {{trans_choice('loan::general.officer',1)}}: {{$data->first()->loan_officer}} @endif | {{trans_choice('core::general.start_date',1)}}: {{$start_date}} | {{trans_choice('core::general.end_date',1)}}: {{$end_date}} | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| {{trans_choice('loan::general.expected',1)}} | {{trans_choice('loan::general.actual',1)}} | ||||||||||
| {{trans_choice('core::general.branch',1)}} | {{trans_choice('loan::general.principal',1)}} | {{ trans_choice('loan::general.interest',1) }} | {{trans_choice('loan::general.fee',2)}} | {{ trans_choice('loan::general.penalty',2) }} | {{ trans_choice('loan::general.total',1) }} | {{trans_choice('loan::general.principal',1)}} | {{ trans_choice('loan::general.interest',1) }} | {{trans_choice('loan::general.fee',2)}} | {{ trans_choice('loan::general.penalty',2) }} | {{ trans_choice('loan::general.total',1) }} | {{ trans_choice('loan::general.balance',1) }} |
| {{ $key->branch }} | {{ number_format( $key->principal,2) }} | {{ number_format( $key->interest,2) }} | {{ number_format( $key->fees,2) }} | {{ number_format( $key->penalties,2) }} | {{ number_format( $key->principal+$key->interest+$key->fees+$key->penalties,2) }} | {{ number_format( $key->principal_repaid_derived,2) }} | {{ number_format( $key->interest_repaid_derived,2) }} | {{ number_format( $key->fees_repaid_derived,2) }} | {{ number_format( $key->penalties_repaid_derived,2) }} | {{ number_format( $key->principal_repaid_derived+$key->interest_repaid_derived+$key->fees_repaid_derived+$key->penalties_repaid_derived,2) }} | {{ number_format( ($key->principal+$key->interest+$key->fees+$key->penalties)-($key->principal_repaid_derived+$key->interest_repaid_derived+$key->fees_repaid_derived+$key->penalties_repaid_derived),2) }} |
| {{trans_choice('core::general.total',1)}} | {{number_format($total_expected_principal,2)}} | {{number_format($total_expected_interest,2)}} | {{number_format($total_expected_fees,2)}} | {{number_format($total_expected_penalties,2)}} | {{number_format($total_expected_principal+$total_expected_interest+$total_expected_fees+$total_expected_penalties,2)}} | {{number_format($total_actual_principal,2)}} | {{number_format($total_actual_interest,2)}} | {{number_format($total_actual_fees,2)}} | {{number_format($total_actual_penalties,2)}} | {{number_format($total_actual_principal+$total_actual_interest+$total_actual_fees+$total_actual_penalties,2)}} | {{number_format(($total_expected_principal+$total_expected_interest+$total_expected_fees+$total_expected_penalties)-($total_actual_principal+$total_actual_interest+$total_actual_fees+$total_actual_penalties),2)}} |