@php
    // $loanCollectionId = DB::table('mfn_loan_collection')
    //     ->where('softDel', '=', 0)
    //     ->groupBy('loanIdFk')
    //     ->pluck('loanIdFk')
    //     ->toArray();

    
    // foreach ($loanCollectionId as $key => $loanId) {
    //     $loanCollectionAmountWIthId[$loanId] = DB::table('mfn_loan_collection')
    //         ->where([['loanIdFk', $loanId], ['softDel', '=', 0]])
    //         ->sum('amount');
    // }

    // foreach ($loanCollectionAmountWIthId as $loanId => $loanCollectionAmount) {
    //     // dd($loanId, $loanAmount);
    //     $loanNotCompletedButTotalRepaymentIsEqual[] = DB::table('mfn_loan')
    //         ->where([['id', $loanId], ['totalRepayAmount', '=', $loanCollectionAmount], ['loanCompletedDate', '=', '0000-00-00']])
    //         ->select('id')
    //         ->first();

    //     $loanCompletedButTotalRepaymentIsNotEqual[] = DB::table('mfn_loan')
    //         ->where([['id', $loanId], ['totalRepayAmount', '!=', $loanCollectionAmount], ['loanCompletedDate', '>', '0000-00-00']])
    //         ->select('id')
    //         ->first();
    // }

    // dd($loanNotCompletedButTotalRepaymentIsEqual, $loanCompletedButTotalRepaymentIsNotEqual);
@endphp