@extends('layouts.app') @section('title', 'Add Fcs Data') @section('content')
@csrf

FCS for Lead id {{$lead_id}}

Add one more
@csrf
@php $months = [ 'January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December' ]; $selectedBankId = 1; @endphp @foreach ($months as $month) @php // Check if any bank record exists for the current month $record = null; $fcs_data = collect($fcs_data); // Convert to Collection if it's an array // Check if fcs_data is not empty if ($fcs_data->isNotEmpty()) { // Filter by bank_id first and then by month $record = $fcs_data->filter(function ($bank) use ($selectedBankId, $month) { // Ensure bank_id is not null and matches the selectedBankId return !empty($bank->records) && collect($bank->records)->contains(function ($data) use ($selectedBankId, $month) { return isset($data->bank_id) && $data->bank_id == $selectedBankId && $data->month === $month; }); })->flatMap(function ($bank) use ($month, $selectedBankId) { // Now filter by both bank_id and month return collect($bank->records)->filter(function ($data) use ($selectedBankId, $month) { return isset($data->bank_id) && $data->bank_id == $selectedBankId && $data->month === $month; }); })->first(); } @endphp @endforeach
Month Deposits Adjustment Revenue ADB No of Deposits NSFs Negatives Ending Balance
{{ $month }} {{ $record ? $record->deposits : '' }} {{ $record ? $record->adjustment : '' }} {{ $record ? $record->revenue : '' }} {{ $record ? $record->adb : '' }} {{ $record ? $record->deposits2 : '' }} {{ $record ? $record->nsfs : '' }} {{ $record ? $record->negatives : '' }} {{ $record ? $record->ending_balance : '' }}
Totals 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Averages 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Find Eligible Lender @foreach ($months as $month) @endforeach

@php // Initialize average revenue $averageBankRevenue = 0; // Find the bank data that matches the selected bank ID foreach ($fcs_data as $bankData) { // Get records for the matched bank $records = $bankData->records; // Check if there are any records and calculate the average revenue if (!empty($records)) { $totalRevenue = 0; $count = 0; // Loop through each record to check for a matching bank_id foreach ($records as $record) { // Check if the bank_id of the record matches the selected bank ID if ($record->bank_id == $selectedBankId) { // Only add to total revenue if revenue is not null if ($record->revenue !== null) { $totalRevenue += $record->revenue; // Sum up the revenue $count++; // Count the number of valid records } } } // Calculate average revenue only if there are valid records $averageBankRevenue = $count > 0 ? $totalRevenue / $count : 0; break; // Exit loop once the average is calculated } } // Debugging: Output the average revenue //dd($averageBankRevenue); @endphp
@csrf @foreach($lender_data as $event) @if($event->bank_id == $selectedBankId) @endif @endforeach
Lender Funding Date Net Funding Funding Factor Payback Weekly Daily Balance Days Withhold End Date Transfer Accounts Notes
{{ $event->lender_name }} {{ $event->funding_date }} {{ $event->net }} {{ $event->funding }} {{ $event->funding_factor }} {{ $event->weekly }} {{ $event->daily }} {{ $event->balance }} {{ $event->days }} {{ $event->withhold }} {{ $event->end_date }} {{ $event->transfer_accounts }} {{ $event->notes }}
Daily Payment Total
Monthly Payment Withhold Total Balance 0

@endsection