return new self(brn : $data->reference_code ?? '', buyer_first_name : strtoupper($data->profile->first_name ?? ''), buyer_middle_name : strtoupper($data->profile->middle_name ?? ''), buyer_last_name : strtoupper($data->profile->last_name ?? ''), buyer_name : strtoupper($data->profile->first_name . ' ' . $data->profile->middle_name . ' ' . $data->profile->last_name ?? ''), buyer_birthday : $data->profile->date_of_birth ?? '', buyer_civil_status : $data->profile->civil_status ?? '', buyer_civil_status_lower_case : strtolower($data->profile->civil_status ?? ''), buyer_civil_status_to : ($data->profile->civil_status) ? (strtoupper($data->profile->civil_status) == 'MARRIED') ? $data->profile->civil_status . ' to ' : $data->profile->civil_status : '', buyer_civil_status_to_lower_case : ($data->profile->civil_status) ? (strtoupper($data->profile->civil_status) == 'MARRIED') ? strtolower($data->profile->civil_status . ' to ') : strtolower($data->profile->civil_status) : '', both_of : ($data->profile->civil_status) ? (strtoupper($data->profile->civil_status) == 'MARRIED') ? 'both' : 'of' : 'of', buyer_spouse_name : strtoupper($data->spouse->first_name . ' ' . $data->spouse->middle_name . ' ' . $data->spouse->last_name ?? ''), buyer_nationality : $data->profile->nationality ?? '', buyer_tin : $data->employment?->toCollection( )->firstWhere('type', 'buyer')->id->tin ?? '', buyer_sss_gsis_number : $data->employment?->toCollection( )->firstWhere('type', 'buyer')->id->sss ?? '', buyer_pagibig_number : $data->employment?->toCollection( )->firstWhere('type', 'buyer')->id->pagibig ?? '', buyer_gender : $data->profile->sex ?? '', buyer_principal_email : $data->profile->email ?? '', buyer_primary_contact_number : $data->profile->mobile ?? '', buyer_other_contact_number : $data->profile->other_mobile ?? '', help_number : $data->profile->help_number ?? '', mothers_maiden_name : strtoupper($data->profile->mothers_maiden_name ?? ''), buyer_residence_landline : $data->profile->landline ?? '', buyer_fb_account_name : $data->profile->first_name . ' ' . $data->profile->middle_name . ' ' . $data->profile->last_name ?? '', buyer_company_email_address : $data->profile->email ?? '', buyer_spouse_first_name : strtoupper($data->spouse->first_name ?? ''), buyer_spouse_middle_name : strtoupper($data->spouse->middle_name ?? ''), buyer_spouse_last_name : $data->spouse->last_name ?? '', spouse_name : strtoupper($data->spouse->first_name . ' ' . $data->spouse->middle_name . ' ' . $data->spouse->last_name ?? ''), spouse_civil_status : $data->spouse->civil_status ?? '', spouse_civil_status_lower_case : strtolower($data->spouse->civil_status ?? ''), spouse_nationality : $data->spouse->nationality ?? '', spouse_gender : $data->spouse->sex ?? '', spouse_birthday : $data->spouse->date_of_birth ?? '', spouse_principal_email : $data->spouse->email ?? '', spouse_mobile : $data->spouse->mobile ?? '', client_id_spouse : $data->order->client_id_spouse ?? '', spouse_extension_name : strtoupper($data->spouse->name_suffix ?? ''), spouse_mothers_maiden_name : strtoupper($data->spouse->mothers_maiden_name ?? ''), spouse_primary_contact_number : $data->spouse->mobile ?? '', spouse_residence_landline : $data->spouse->landline ?? '', spouse_fb_account_name : $data->spouse->first_name . ' ' . $data->spouse->middle_name . ' ' . $data->spouse->last_name ?? '', spouse_age : $data->spouse->age ?? '', spouse_tin : $data->employment?->toCollection( )->firstWhere('type', 'spouse')->id->tin ?? '', spouse_pagibig_number : $data->employment?->toCollection( )->firstWhere('type', 'spouse')->id->pagibig ?? '', spouse_employer_name : strtoupper($data->employment?->toCollection( )->firstWhere('type', 'spouse')->employer->name ?? ''), spouse_employer_type : $data->employment?->toCollection( )->firstWhere('type', 'spouse')->employer->type ?? '', spouse_employer_status : $data->employment?->toCollection( )->firstWhere('type', 'spouse')->employer->status ?? '', spouse_employer_address : $data->employment?->toCollection( )->firstWhere('type', 'spouse')->employer->address->full_address ?? '', spouse_employer_contact_number : $data->employment?->toCollection( )->firstWhere('type', 'spouse')->employer->contact_no ?? '', spouse_company_email_address : $data->employment?->toCollection( )->firstWhere('type', 'spouse')->employer->email ?? '', spouse_position : $data->employment?->toCollection( )->firstWhere('type', 'spouse')->current_position ?? '', spouse_years_in_service : $data->employment?->toCollection( )->firstWhere('type', 'spouse')->years_in_service ?? '', spouse_salary_gross_income : $data->employment?->toCollection( )->firstWhere('type', 'spouse')->monthly_gross_income ?? 0, zip_code : $data->addresses?->toCollection( )->firstWhere('type', 'spouse')->postal_code ?? '', length_of_stay : $data->employment?->toCollection( )->firstWhere('type', 'spouse')->years_in_service ?? '', spouse_industry : $data->employment?->toCollection( )->firstWhere('type', 'spouse')->industry ?? '', buyer_address : $data->addresses?->toCollection( )->firstWhere('type', 'primary')->full_address ?? '', buyer_province : $data->addresses?->toCollection( )->firstWhere('type', 'primary')->administrative_area ?? '', buyer_residence_type : $data->addresses?->toCollection( )->firstWhere('type', 'primary')->type ?? '', buyer_ownership_type : $data->addresses?->toCollection( )->firstWhere('type', 'primary')->ownership ?? '', buyer_unit_lot : $data->addresses?->toCollection( )->firstWhere('type', 'primary')->unit ?? '', buyer_block : $data->addresses?->toCollection( )->firstWhere('type', 'primary')->block ?? '', buyer_street : $data->addresses?->toCollection( )->firstWhere('type', 'primary')->street ?? '', buyer_barangay : $data->addresses?->toCollection( )->firstWhere('type', 'primary')->sublocality ?? '', buyer_city : $data->addresses?->toCollection( )->firstWhere('type', 'primary')->locality ?? '', buyer_place_of_residency_1_city_of_residency : $data->addresses?->toCollection( )->firstWhere('type', 'primary')->address1 ?? '', buyer_place_of_residency_2_province_of_residency : $data->addresses?->toCollection( )->firstWhere('type', 'primary')->address2 ?? '', buyer_subdivision : $data->addresses?->toCollection( )->firstWhere('type', 'primary')->street ?? '', years_of_residency : $data->addresses?->toCollection( )->firstWhere('type', 'primary')->length_of_stay ?? '', present_buyer_unit_lot : $data->addresses?->toCollection( )->firstWhere('type', 'primary')->unit ?? '', present_buyer_street : $data->addresses?->toCollection( )->firstWhere('type', 'primary')->street ?? '', present_buyer_subdivision : $data->addresses?->toCollection( )->firstWhere('type', 'primary')->street ?? '', present_buyer_barangay : $data->addresses?->toCollection( )->firstWhere('type', 'primary')->sublocality ?? '', present_buyer_city : $data->addresses?->toCollection( )->firstWhere('type', 'primary')->locality ?? '', present_buyer_province : $data->addresses?->toCollection( )->firstWhere('type', 'primary')->administrative_area ?? '', present_buyer_ownership_type : $data->addresses?->toCollection( )->firstWhere('type', 'primary')->ownership ?? '', present_years_of_residency : $data->addresses?->toCollection( )->firstWhere('type', 'primary')->length_of_stay ?? '', building : $data->addresses?->toCollection( )->firstWhere('type', 'primary')->building ?? '', floor : $data->addresses?->toCollection( )->firstWhere('type', 'primary')->floor ?? '', unit : $data->addresses?->toCollection( )->firstWhere('type', 'primary')->unit ?? '', aif_address : $data->addresses?->toCollection( )->firstWhere('type', 'co_borrower')->full_address ?? '', company_name : $data->order->company_name ?? '', project_name : $data->order->project_name ?? '', project_code : $data->order->project_code ?? '', project_location : $data->order->project_location ?? '', project_address : $data->order->project_address ?? '', property_name : $data->order->property_name ?? '', phase : $data->order->phase ?? '', block : $data->order->block ?? '', lot : $data->order->lot ?? '', mrif_fee : number_format($data->order->mrif_fee ?? 0, 2), reservation_rate : $data->order->reservation_rate ?? '', lot_area : $data->order->lot_area ?? '', lot_area_in_words : str_replace('-', ' ', strtoupper(self::convertNumberToWords($data->order->lot_area ?? '0') . ' square meters')), floor_area : $data->order->floor_area ?? '', floor_area_in_words : strtoupper(self::convertNumberToWords($data->order->floor_area ?? '')), tcp : $data->order->tcp ?? '0', tcp_in_words : strtoupper(self::convertNumberToWords($data->order->payment_scheme->total_contract_price ?? '0')), loan_term : $data->order->loan_term ?? '', loan_term_in_years : (string) ((int) ($data->order->loan_term ?? 0) / 12), loan_interest_rate : $data->order->loan_interest_rate ?? '', tct_no : $data->order->tct_no ?? '', sku : $data->order->sku ?? '', promo_code : $data->order->promo_code ?? '', seller_commission_code : $data->order->seller_commission_code ?? '', property_code : $data->order->property_code ?? '', property_type : $data->order->property_type ?? '', baf_number : $data->order->baf_number ?? '', baf_date : $data->order->baf_date ?? '', client_id : $data->order->client_id_buyer ?? '', buyer_age : $data->order->buyer_age ?? '', os_status : $data->order->os_status ?? '', class_field : $data->order->class_field ?? '', segment_field : $data->order->segment_field ?? '', rebooked_id_form : $data->order->rebooked_id_form ?? '', cancellation_type : $data->order->cancellation_type ?? '', cancellation_reason : $data->order->cancellation_reason ?? '', cancellation_remarks : $data->order->cancellation_remarks ?? '', unit_type : $data->order->unit_type ?? '', unit_type_interior : $data->order->unit_type_interior ?? '', house_color : $data->order->house_color ?? '', construction_status : $data->order->construction_status ?? '', transaction_reference : $data->order->transaction_reference ?? '', date_created : $data->order->date_created ?? '', ra_date : $data->order->ra_date ?? '', date_approved : $data->order->date_approved ?? '', date_expiration : $data->order->date_expiration ?? '', os_month : $data->order->os_month ?? '', due_date : $data->order->due_date ?? '', total_payments_made : $data->order->total_payments_made ?? '', transaction_status : $data->order->transaction_status ?? '', staging_status : $data->order->staging_status ?? '', period_id : $data->order->period_id ?? '', date_closed : $data->order->date_closed ?? '', closed_reason : $data->order->closed_reason ?? '', date_cancellation : $data->order->date_cancellation ?? '', reservation_date : $data->order->reservation_date ?? '', payment_scheme : $data->order->payment_scheme->scheme ?? '', discount_rate : $data->order->payment_scheme->discount_rate ?? '', conditional_discount : number_format($data->order->payment_scheme->conditional_discount ?? 0, 2), evat_percentage : number_format($data->order->payment_scheme->evat_percentage ?? 0, 2), total_contract_price : number_format($data->order->payment_scheme->total_contract_price ?? 0, 2), evat_amount : number_format($data->order->payment_scheme->evat_amount ?? 0, 2), net_total_contract_price : number_format($data->order->payment_scheme->net_total_contract_price ?? 0, 2), payment_method_name : $data->order->payment_scheme->method ?? '', collectible_price : number_format($data->order->payment_scheme->collectible_price ?? 0, 2), commissionable_amount : number_format($data->order->payment_scheme->commissionable_amount ?? 0), transaction_sub_status : $data->order->payment_scheme->transaction_sub_status ?? '', payment_remarks : $data->order->payment_scheme->payment_remarks ?? '', transaction_remarks : $data->order->payment_scheme->transaction_remarks ?? '', pf_amount_paid : number_format($data->order->payment_scheme->payments?->toCollection( )->firstWhere('type', 'processing_fee')->amount_paid ?? 0), pf_payment_reference_number : $data->order->payment_scheme->payments?->toCollection( )->firstWhere('type', 'processing_fee')->reference_number ?? '', pf_payment_date : $data->order->payment_scheme->payments?->toCollection( )->firstWhere('type', 'processing_fee')->date ?? '', hucf_amount_paid : number_format($data->order->payment_scheme->payments?->toCollection( )->firstWhere('type', 'home_utility_connection_fee')->amount_paid ?? 0), hucf_payment_reference_number : $data->order->payment_scheme->payments?->toCollection( )->firstWhere('type', 'home_utility_connection_fee')->reference_number ?? '', hucf_payment_date : $data->order->payment_scheme->payments?->toCollection( )->firstWhere('type', 'home_utility_connection_fee')->date ?? '', balance_payment_amount_paid : number_format($data->order->payment_scheme->payments?->toCollection( )->firstWhere('type', 'balance')->amount_paid ?? 0), balance_payment_reference_number : $data->order->payment_scheme->payments?->toCollection( )->firstWhere('type', 'balance')->reference_number ?? '', balance_payment_date : $data->order->payment_scheme->payments?->toCollection( )->firstWhere('type', 'balance')->date ?? '', equity_payment_amount_paid : number_format($data->order->payment_scheme->payments?->toCollection( )->firstWhere('type', 'equity')->amount_paid ?? 0), equity_payment_reference_number : $data->order->payment_scheme->payments?->toCollection( )->firstWhere('type', 'equity')->reference_number ?? '', equity_payment_date : $data->order->payment_scheme->payments?->toCollection( )->firstWhere('type', 'equity')->date ?? '', rental_fee : number_format($data->order->payment_scheme->fees?->toCollection( )->firstWhere('name', 'rental')->amount ?? 0), present_rental_fee : number_format($data->order->payment_scheme->fees?->toCollection( )->firstWhere('name', 'present_rental_fee')->amount ?? 0), co_borrower_name : strtoupper(($data->co_borrowers[0]->first_name ?? '') . ' ' . ($data->co_borrowers[0]->middle_name ?? '') . ' ' . ($data->co_borrowers[0]->last_name ?? '')), co_borrower_address : $data->addresses?->toCollection( )->firstWhere('type', 'co_borrower')->full_address ?? '', co_borrower_civil_status : $data->co_borrowers[0]->civil_status ?? '', co_borrower_civil_status_lower_case : strtolower($data->co_borrowers[0]->civil_status ?? ''), co_borrower_civil_status_to : ($data->co_borrowers[0]->civil_status) ? (strtoupper($data->co_borrowers[0]->civil_status) == 'MARRIED') ? $data->co_borrowers[0]->civil_status . ' to ' : $data->co_borrowers[0]->civil_status : '', co_borrower_nationality : $data->co_borrowers[0]->nationality ?? '', co_borrower_spouse : $co_borrower_spouse_name, co_borrower_spouse_tin : $co_borrower_spouse_tin, co_borrower_tin : $data->employment?->toCollection( )->firstWhere('type', 'co_borrower')->id->tin ?? '', aif_name : $data->order->aif ? strtoupper("{$data->order->aif->first_name} {$data->order->aif->middle_name} {$data->order->aif->last_name} {$data->order->aif->name_suffix}") : '', aif_last_name : $data->order->aif ? strtoupper($data->order->aif->last_name ?? '') : '', aif_first_name : $data->order->aif ? strtoupper($data->order->aif->first_name ?? '') : '', aif_middle_name : $data->order->aif ? strtoupper($data->order->aif->middle_name ?? '') : '', aif_extension_name : $data->order->aif ? $data->order->aif->name_suffix ?? '' : '', aif_mobile : $data->order->aif ? $data->order->aif->mobile ?? '' : '', aif_other_mobile : $data->order->aif ? $data->order->aif->other_mobile ?? '' : '', aif_landline : $data->order->aif ? $data->order->aif->landline ?? '' : '', aif_email : $data->order->aif ? $data->order->aif->email ?? '' : '', aif_unit_lot : $data->addresses?->toCollection( )->firstWhere('type', 'co_borrower')->unit ?? '', aif_street : $data->addresses?->toCollection( )->firstWhere('type', 'co_borrower')->street ?? '', aif_subdivision : $data->addresses?->toCollection( )->firstWhere('type', 'co_borrower')->street ?? '', aif_barangay : $data->addresses?->toCollection( )->firstWhere('type', 'co_borrower')->sublocality ?? '', aif_city : $data->addresses?->toCollection( )->firstWhere('type', 'co_borrower')->locality ?? '', aif_province : $data->addresses?->toCollection( )->firstWhere('type', 'co_borrower')->administrative_area ?? '', aif_zip_code : $data->addresses?->toCollection( )->firstWhere('type', 'co_borrower')->postal_code ?? '', aif_length_of_stay : $data->addresses?->toCollection( )->firstWhere('type', 'co_borrower')->length_of_stay ?? '', aif_ownership_type : $data->addresses?->toCollection( )->firstWhere('type', 'co_borrower')->ownership ?? '', aif_birthday : $data->order->aif->date_of_birth ?? '', aif_age : $data->co_borrowers[0]->age ?? '', aif_gender : $data->order->aif->sex ?? '', aif_civil_status : $data->order->aif->civil_status ?? '', aif_civil_status_lower_case : strtolower($data->order->aif->civil_status ?? ''), aif_nationality : $data->order->aif->nationality ?? '', aif_residence_landline : $data->co_borrowers[0]->landline ?? '', aif_primary_contact_number : $data->co_borrowers[0]->mobile ?? '', aif_relationship_to_buyer : $data->co_borrowers[0]->relationship_to_buyer ?? '', aif_account_name : strtoupper(($data->co_borrowers[0]->first_name ?? '') . ($data->co_borrowers[0]->middle_name ?? '') . ($data->co_borrowers[0]->last_name ?? '')), aif_username_or_email : $data->co_borrowers[0]->email ?? '', aif_sss : $data->employment?->toCollection( )->firstWhere('type', 'co_borrower')->id->sss ?? '', aif_pagibig : $data->employment?->toCollection( )->firstWhere('type', 'co_borrower')->id->pagibig ?? '', aif_tin : $data->employment?->toCollection( )->firstWhere('type', 'co_borrower')->id->tin ?? '', aif_passport : $data->co_borrowers[0]->passport ?? '', aif_date_issued : $data->co_borrowers[0]->date_issued ?? '', aif_place_issued : $data->co_borrowers[0]->place_issued ?? '', aif_employer_name : strtoupper($data->employment?->toCollection( )->firstWhere('type', 'co_borrower')->employer->name ?? ''), aif_employer_address : $data->employment?->toCollection( )->firstWhere('type', 'co_borrower')->employer->address->full_address ?? '', aif_employer_type : $data->employment?->toCollection( )->firstWhere('type', 'co_borrower')->employer->type ?? '', aif_employment_status : $data->employment?->toCollection( )->firstWhere('type', 'co_borrower')->employment_status ?? '', aif_position : $data->employment?->toCollection( )->firstWhere('type', 'co_borrower')->current_position ?? '', aif_industry : $data->employment?->toCollection( )->firstWhere('type', 'co_borrower')->industry ?? '', aif_salary_gross_income : $data->employment?->toCollection( )->firstWhere('type', 'co_borrower')->monthly_gross_income ?? '', aif_company_phone_number : $data->employment?->toCollection( )->firstWhere('type', 'co_borrower')->employer->contact_no ?? '', aif_fax : $data->employment?->toCollection( )->firstWhere('type', 'co_borrower')->employer->fax ?? '', aif_company_email : $data->employment?->toCollection( )->firstWhere('type', 'co_borrower')->employer->email ?? '', buyer_years_in_service : $data->employment?->toCollection( )->firstWhere('type', 'buyer')->years_in_service ?? '', buyer_employer_type : $data->employment?->toCollection( )->firstWhere('type', 'buyer')->employment_type ?? '', buyer_employer_status : $data->employment?->toCollection( )->firstWhere('type', 'buyer')->employer->status ?? '', buyer_employer_year_established : $data->employment?->toCollection( )->firstWhere('type', 'buyer')->employer->year_established ?? '', buyer_employer_total_number_of_employees : $data->employment?->toCollection( )->firstWhere('type', 'buyer')->employer->total_number_of_employees ?? '', buyer_employer_name : strtoupper($data->employment?->toCollection( )->firstWhere('type', 'buyer')->employer->name ?? ''), buyer_employer_contact_number : $data->employment?->toCollection( )->firstWhere('type', 'buyer')->employer->contact_no ?? '', buyer_employer_address : $data->employment?->toCollection( )->firstWhere('type', 'buyer')->employer->address->full_address ?? '', buyer_employer_city : $data->employment?->toCollection( )->firstWhere('type', 'buyer')->employer->address->locality ?? '', buyer_employer_province : $data->employment?->toCollection( )->firstWhere('type', 'buyer')->employer->address->administrative_area ?? '', buyer_place_of_work_1_city_of_employer : $data->employment?->toCollection( )->firstWhere('type', 'buyer')->employer->address->address1 ?? '', buyer_place_of_work_2_city_of_employer : $data->employment?->toCollection( )->firstWhere('type', 'buyer')->employer->address->address2 ?? '', buyer_position : $data->employment?->toCollection( )->firstWhere('type', 'buyer')->current_position ?? '', buyer_salary_gross_income : number_format($data->employment?->toCollection( )->firstWhere('type', 'buyer')->monthly_gross_income ?? 0, 2), buyer_salary_range : $data->employment?->toCollection( )->firstWhere('type', 'buyer')->salary_range ?? '', industry : $data->employment?->toCollection( )->firstWhere('type', 'buyer')->employer->industry ?? '', selling_unit : $data->order->seller->unit ?? '', seller_id : $data->order->seller->id ?? '', seller_name : strtoupper($data->order->seller->name ?? ''), seller_superior : $data->order->seller->superior ?? '', sales_team_head : $data->order->seller->team_head ?? '', chief_seles_officer : $data->order->seller->chief_seller_officer ?? '', seller_type : $data->order->seller->type ?? '', cancellation_reason2 : $data->order->cancellation_reason2 ?? '', hucf_move_in_fee : number_format($data->order->hucf_move_in_fee ?? 0, 2), reservation_rate_processing_fee : number_format($data->order->reservation_rate ?? 0, 2), cash_outlay_1_amount : number_format($data->order->cash_outlay_1_amount ?? 0, 2), cash_outlay_1_percentage_rate : $data->order->cash_outlay_1_percentage_rate ?? 0, cash_outlay_1_interest_rate : $data->order->cash_outlay_1_interest_rate ?? 0, cash_outlay_1_terms : $data->order->cash_outlay_1_terms ?? 0, cash_outlay_1_monthly_payment : $data->order->cash_outlay_1_monthly_payment ?? 0, cash_outlay_1_effective_date : $data->order->cash_outlay_1_effective_date ?? '', cash_outlay_2_amount : number_format($data->order->cash_outlay_2_amount ?? 0), cash_outlay_2_percentage_rate : $data->order->cash_outlay_2_percentage_rate ?? 0, cash_outlay_2_interest_rate : $data->order->cash_outlay_2_interest_rate ?? 0, cash_outlay_2_terms : $data->order->cash_outlay_2_terms ?? 0, cash_outlay_2_monthly_payment : number_format($data->order->cash_outlay_2_monthly_payment ?? 0), cash_outlay_2_effective_date : $data->order->cash_outlay_2_effective_date ?? '', cash_outlay_3_amount : $data->order->cash_outlay_3_amount ?? '', cash_outlay_3_percentage_rate : $data->order->cash_outlay_3_percentage_rate ?? '', cash_outlay_3_interest_rate : $data->order->cash_outlay_3_interest_rate ?? '', cash_outlay_3_terms : $data->order->cash_outlay_3_terms ?? '', cash_outlay_3_monthly_payment : number_format($data->order->cash_outlay_3_monthly_payment ?? 0, 2), cash_outlay_3_effective_date : $data->order->cash_outlay_3_effective_date ?? '', equity_1_amount : number_format($data->order->equity_1_amount ?? 0), equity_1_percentage_rate : $data->order->equity_1_percentage_rate ?? '', equity_1_interest_rate : $data->order->equity_1_interest_rate ?? '', equity_1_terms : $data->order->equity_1_terms ?? '', equity_1_monthly_payment : number_format($data->order->equity_1_monthly_payment ?? 0), equity_1_effective_date : $data->order->equity_1_effective_date ?? '', equity_2_amount : number_format($data->order->equity_2_amount ?? 0), equity_2_percentage_rate : $data->order->equity_2_percentage_rate ?? '', equity_2_interest_rate : $data->order->equity_2_interest_rate ?? '', equity_2_terms : $data->order->equity_2_terms ?? '', equity_2_monthly_payment : number_format($data->order->equity_2_monthly_payment ?? 0), equity_2_effective_date : $data->order->equity_2_effective_date ?? '', bp_1_amount : number_format($data->order->bp_1_amount ?? 0), bp_1_percentage_rate : $data->order->bp_1_percentage_rate ?? '', bp_1_interest_rate : $data->order->bp_1_interest_rate ?? '', bp_1_terms : $data->order->bp_1_terms ?? '', bp_1_monthly_payment : number_format($data->order->bp_1_monthly_payment ?? 0), bp_1_effective_date : $data->order->bp_1_effective_date ?? '', bp_2_amount : $data->order->bp_2_amount ?? '', bp_2_terms : $data->order->bp_2_terms ?? '', bp_2_percentage_rate : $data->order->bp_2_percentage_rate ?? '', bp_2_interest_rate : $data->order->bp_2_interest_rate ?? '', bp_2_monthly_payment : number_format($data->order->bp_2_monthly_payment ?? 0), bp_2_effective_date : $data->order->bp_2_effective_date ?? '', circular_no_312_379 : $data->order->circular_no_312_379 ?? '', ltvr_slug : $data->order->ltvr_slug ?? '', interest : $data->order->interest ?? '', interest_in_words : $data->order->interest ? strtoupper(\NumberFormatter::create('en', \NumberFormatter::SPELLOUT)->format((int) $data->order->interest)) . ' AND ' . str_pad((int) (($data->order->interest - (int) $data->order->interest) * 1000), 3, '0', STR_PAD_LEFT) . '/1000' : '', logo : $data->order->logo ?? '', loan_period_months : $data->order->loan_period_months ?? '', term_1 : $data->order->term_1 ?? '', term_2 : $data->order->term_2 ?? '', term_3 : $data->order->term_3 ?? '', amort_mrisri1 : $data->order->amort_mrisri1 ?? '', amort_mrisri2 : $data->order->amort_mrisri2 ?? '', amort_mrisri3 : $data->order->amort_mrisri3 ?? '', amort_nonlife1 : $data->order->amort_nonlife1 ?? '', amort_nonlife2 : $data->order->amort_nonlife2 ?? '', amort_nonlife3 : $data->order->amort_nonlife3 ?? '', amort_princ_int1 : $data->order->amort_princ_int1 ?? '', amort_princ_int2 : $data->order->amort_princ_int2 ?? '', amort_princ_int3 : $data->order->amort_princ_int3 ?? '', monthly_amort1 : $data->order->monthly_amort1 ?? '', monthly_amort1_in_words : strtoupper(self::convertNumberToWords($data->order->monthly_amort1 ?? '')), monthly_amort2 : $data->order->monthly_amort2 ?? '', monthly_amort3 : $data->order->monthly_amort3 ?? '', cct : $data->order->cct ?? '', witness : 'WITNESS', witness1 : $data->order->witness1 ?? 'WITNESS', witness2 : $data->order->witness2 ?? 'WITNESS', page : $data->order->page ?? '', buyer_extension_name : $data->order->buyer_extension_name ?? '', exec_signatories : strtoupper($data->order->seller->chief_seller_officer ?? ''), exec_position : 'Chief Sales Officer', exec_tin_no : $data->order->exec_tin_no ?? '', board_resolution_date : $data->order->board_resolution_date ?? '', repricing_period : $data->order->repricing_period ?? 0, loan_terms_in_word : strtoupper(self::convertNumberToWords($data->order->loan_term ?? '')), loan_terms_in_years_in_word : strtoupper(self::convertNumberToWords((int) ($data->order->loan_term ?? 0) / 12)), repricing_period_in_words : strtoupper(self::convertNumberToWords($data->order->repricing_period ?? '')), registry_of_deeds_address : $data->order->registry_of_deeds_address ?? '', scheme : $data->order->payment_scheme->scheme ?? '', company_tin : $data->order->company_tin ?? '', company_address : $data->order->company_address ?? '', loan_value_after_downpayment : $data->order->loan_value_after_downpayment ?? '', loan_value_after_downpayment_in_words : strtoupper(self::convertNumberToWords($data->order->loan_value_after_downpayment ?? '')), company_acronym : $data->order->company_acronym ?? '', total_selling_price : number_format($data->order->total_selling_price ?? 0, 2), client_id_co_borrower : $data->order->client_id_co_borrower ?? '', client_id_aif : $data->order->client_id_aif ?? '', retention_fee : number_format($data->order->payment_scheme->fees?->toCollection( )->firstWhere('name', 'retention_fee')->amount ?? 0, 2), service_fee : number_format($data->order->payment_scheme->fees?->toCollection( )->firstWhere('name', 'service_fee')->amount ?? 0, 2), dslt_total : number_format($data->order->disclosure_statement_on_loan_transaction_total ?? 0, 2), dst : number_format($data->order->documentary_stamp ?? 0, 2), total_deductions_from_loan_proceeds : number_format($data->order->total_deductions_from_loan_proceeds ?? 0, 2), net_loan_proceeds : number_format($data->order->net_loan_proceeds ?? 0, 2), vsr_no : $data->order->verified_survey_return_no ?? '', technical_description : $data->order->technical_description ?? '', timothy_s_gobio_tin : '315-765-457-000', comencement_period : $data->order->comencement_period ?? '', non_life_insurance : $data->order->non_life_insurance ?? '', mrisri_docstamp_total : $data->order->mrisri_docstamp_total ?? '', repricing_period_affordable : $data->order->repricing_period_affordable ?? '', )

Issues