Document

@inject('carbon', '\Carbon') @inject('constant', '\App\Util\Constant') @php if ($data->confirmationAt != null) { $tglKonfirmasi = $data->confirmationAt; } else { $tglKonfirmasi = $data->activeAt; } @endphp Document

PT Duha Madani Syariah

Kino Tower Lantai 5

Jl. Jalur Sutera Boulevard No.1 Alam Sutera

Tangerang 15143

Telp: 021-30265454

Fax: 021-29333457

INTERNAL MEMO

Kepada	:	Finance
Tanggal	:	{{ parseDateToIndonesian($carbon::parse($tglKonfirmasi)->format('d M Y')) }}
Perihal	:	Pembayaran Invoice Financing - {{ parseDateToIndonesian($carbon::parse($tglKonfirmasi)->format('M Y')) }}

No Invoince	:	{{ $data->invoiceNumber }}
Borrower	:	{{ $data->customerDetail->mostRecentCreditApplication->creditApplicationBusiness->businessName }}
		Via {{ $data->customerDetail->mostRecentCreditApplication->creditApplicationBusiness->bankAccountOwner }}
		Bank {{ $data->customerDetail->mostRecentCreditApplication->creditApplicationBusiness->bankName }}
		Nomor Rekening : {{ $data->customerDetail->mostRecentCreditApplication->creditApplicationBusiness->bankAccountNumber }}
Nilai Invoince	:	Rp {{ getPriceNumber($data->invoiceValue) }}
Nilai Pembiayaan	:	Rp {{ getPriceNumber($data->submissionValue) }}
Tanggal Penyaluran Pembiayaan	:	{{ parseDateToIndonesian($carbon::parse($tglKonfirmasi)->format('d M Y')) }}
Tenor	:	{{ $data->period > 0 ? getPriceNumber($data->period) . ' bulan' : getPriceNumber($data->periodDay) . ' hari' }}
Ujroh/Fee	:	{{ number_format((float)$data->monthlyMarginRate, 2, '.', '') }}% flat per bulan
Nilai Ujroh/Fee	:	Rp {{ getPriceNumber($data->totalMarginAmount) }}
Tanggal Pencairan	:	{{ empty($data->emailDueDate) ? "" : parseDateToIndonesian($carbon::parse($data->emailDueDate)->format('d M Y')) }}
Payor	:	{{ $data->payorName }}
Total Repayment dari Borrower	:	Rp {{ getPriceNumber($data->submissionValue + $data->totalMarginAmount) }}

@php $no = 1; $totalPokok = 0; $totalUjroh = 0; $totalUjrohLenderGross = 0; $totalUjrohDuhaGross = 0; $totalPph23Lender = 0; $totalUjrohLenderNet = 0; $totalRepaymentLender = 0; @endphp @if (!empty($data->completedPayments)) @foreach ($data->completedPayments as $item) @php $period = !isset($data->period) || $data->period == 0 ? 1 : $data->period; $printUjrohLenderGross = round(($item->amount/$data->fundingValue) * (($data->totalMarginAmount - $data->pph23Amount) * ($data->investorMarginRate/100))); $printUjrohDuhaGross = round(($item->amount/$data->fundingValue) * (($data->totalMarginAmount - $data->pph23Amount) * ($data->duhaMarginRate/100))); $printTotalUjroh = ($printUjrohLenderGross) + ($printUjrohDuhaGross); // id 95 = Black Swan Capital Indonesia , field picCompanyName di table investorapplication if ($item->investorPicDetail->mostRecentInvestorApplication->picCompanyEconomySector == Constant::ECONOMIC_SECTOR_FINANCIAL) { $printPph23Lender = 0; }elseif ($item->investorPicDetail->mostRecentInvestorApplication->id = 95) { $printPph23Lender = $printUjrohLenderGross * (15 / 100); } else { $printPph23Lender = $printUjrohLenderGross * (15 / 100);; } $printUjrohLenderNet = $printUjrohLenderGross - $printPph23Lender; $printRepaymentLender = $item->amount + $printUjrohLenderNet; $totalPokok += $item->amount; $totalUjroh += $printTotalUjroh; $totalUjrohLenderGross += $printUjrohLenderGross; $totalUjrohDuhaGross += $printUjrohDuhaGross; $totalPph23Lender += $printPph23Lender; $totalUjrohLenderNet += $printUjrohLenderNet; $totalRepaymentLender += $printRepaymentLender; @endphp {{-- id 95 = Black Swan Capital Indonesia , field picCompanyName di table investorapplication --}} @if ($item->investorPicDetail->mostRecentInvestorApplication->picCompanyEconomySector == Constant::ECONOMIC_SECTOR_FINANCIAL) @elseif($item->investorPicDetail->mostRecentInvestorApplication->id) @else @endif @endforeach @endif

No	Nama Lender	No. VA Lender	Total Pokok	Total Ujroh	Ujroh Lender Gross	Ujroh Duha Gross	PPH 23% Lender	Ujroh Lender Net	Repayment ke Lender
{{ $no++ }}	{{ $item->investorPicDetail->mostRecentInvestorApplication->type == Constant::CREDIT_APPLICATION_CREDIT_TYPE_COMPANY ? @Constant::BUSINESS_TYPE_LABELS[$item->investorPicDetail->mostRecentInvestorApplication->picCompanyType].' '.$item->investorPicDetail->mostRecentInvestorApplication->picCompanyName : $item->investorPicDetail->mostRecentInvestorApplication->fullName }}	{{ empty($item->vaNumber) ? "0" : $item->vaNumber }}	Rp {{ getPriceNumber($item->amount) }}	RP {{ getPriceNumber($printTotalUjroh) }}	RP {{ getPriceNumber($printUjrohLenderGross) }}	RP {{ getPriceNumber($printUjrohDuhaGross) }}	-	RP {{ getPriceNumber($printPph23Lender) }}	RP {{ getPriceNumber($printPph23Lender) }}	RP {{ getPriceNumber($printUjrohLenderNet) }}	RP {{ getPriceNumber($printRepaymentLender) }}
	Total		Rp {{ getPriceNumber($totalPokok) }}	Rp {{ getPriceNumber($totalUjroh) }}	Rp {{ getPriceNumber($totalUjrohLenderGross) }}	Rp {{ getPriceNumber($totalUjrohDuhaGross) }}	Rp {{ getPriceNumber($totalPph23Lender) }}	Rp {{ getPriceNumber($totalUjrohLenderNet) }}	Rp {{ getPriceNumber($totalRepaymentLender) }}