{{-- <style>
    .table tbody tr td {
        padding: 3px 3px;
        white-space: nowrap;
        font-size: 8px !important;
    }

    .table thead tr th {
        font-size: 9px !important;

    }
</style> --}}
<div id="printView">

    @include('partials.reportHead.index')

    <div class="table-responsive">
        <table id="loanWriteOffReport" class="table table-striped table-bordered" width="100%"
            style="color:black; border-collapse: collapse;" border= "1px solid ash;">
            <thead>
                <tr>
                    <th rowspan="3">SL. No</th>
                    <th colspan="2">Samity</th>
                    <th colspan="3">Member</th>
                    <th colspan="3">Loan Disbursement</th>
                    <th colspan="3">Loan Recovery Before Loan Write Off</th>
                    <th rowspan="3">Date Of Loan Recovery (Cash/Bank) Before Loan Write Off</th>
                    <th rowspan="3">Savings Balance</th>
                    <th colspan="4">Write Off Amount</th>
                    <th colspan="2">Details Of Loan Recovery After Loan Write Off</th>

                </tr>

                <tr>
                    <th rowspan="2">Name</th>
                    <th rowspan="2">Code</th>

                    <th rowspan="2">Code</th>
                    <th rowspan="2">Name</th>
                    <th rowspan="2">Spouce/</br>Father Name</th>

                    <th rowspan="2">Loan Code</th>
                    <th rowspan="2">Date</th>
                    <th rowspan="2">Amount</th>

                    <th rowspan="2">Cash/</br>Bank</th>
                    <th rowspan="2">Adjustment</br>With Savings</th>
                    <th rowspan="2">Total Amount</th>

                    <th rowspan="2">Date</th>
                    <th colspan="3">Amount</th>

                    <th rowspan="2">Date Of Last Recovery</br>After Loan Write Off</th>
                    <th rowspan="2">Recovery Amount After Loan Write Off</th>
                </tr>

                <tr>
                    <th>Principal</th>
                    <th>Interest</th>
                    <th>Total</th>
                </tr>
            </thead>

            <tbody>

                
                @foreach ($branchesGroupBy as $branch)
                    @php
                        // Filter write-off information by branch ID
                        $writeOffInfoBranchWise = $writeOffInfos->where('writeOffBranchId', $branch->id);
                    @endphp

                    <tr>
                        <td colspan="20" style="background-color: #F7F7F7; text-align: left !important;">
                            <strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{{ $branch->branchCodeWith0 }}
                                - {{ $branch->branchName }}</strong>
                        </td>
                    </tr>


                    
                    @foreach ($writeOffInfoBranchWise as $writeOffInfo)
                        <br />
<b>Warning</b>:  Undefined variable $writeOffInfo in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/microfin/reports/loanWriteOffReportViews/LoanWriteOffReportView.blade.php</b> on line <b>116</b><br />
<br />
<b>Warning</b>:  Attempt to read property "mfnLoanCollectionAmount" on null in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/microfin/reports/loanWriteOffReportViews/LoanWriteOffReportView.blade.php</b> on line <b>116</b><br />
<br />
<b>Warning</b>:  Undefined variable $writeOffInfo in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/microfin/reports/loanWriteOffReportViews/LoanWriteOffReportView.blade.php</b> on line <b>116</b><br />
<br />
<b>Warning</b>:  Attempt to read property "mfnLoanAdjustmentAmount" on null in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/microfin/reports/loanWriteOffReportViews/LoanWriteOffReportView.blade.php</b> on line <b>116</b><br />
<br />
<b>Warning</b>:  Undefined variable $writeOffInfo in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/microfin/reports/loanWriteOffReportViews/LoanWriteOffReportView.blade.php</b> on line <b>117</b><br />
<br />
<b>Warning</b>:  Attempt to read property "mfnLoanAdjustmentAmount" on null in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/microfin/reports/loanWriteOffReportViews/LoanWriteOffReportView.blade.php</b> on line <b>117</b><br />
<br />
<b>Warning</b>:  Undefined variable $writeOffInfo in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/microfin/reports/loanWriteOffReportViews/LoanWriteOffReportView.blade.php</b> on line <b>119</b><br />
<br />
<b>Warning</b>:  Attempt to read property "principal_amount" on null in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/microfin/reports/loanWriteOffReportViews/LoanWriteOffReportView.blade.php</b> on line <b>119</b><br />
<br />
<b>Warning</b>:  Undefined variable $writeOffInfo in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/microfin/reports/loanWriteOffReportViews/LoanWriteOffReportView.blade.php</b> on line <b>119</b><br />
<br />
<b>Warning</b>:  Attempt to read property "interest_amount" on null in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/microfin/reports/loanWriteOffReportViews/LoanWriteOffReportView.blade.php</b> on line <b>119</b><br />
<br />
<b>Warning</b>:  Undefined variable $writeOffInfo in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/microfin/reports/loanWriteOffReportViews/LoanWriteOffReportView.blade.php</b> on line <b>121</b><br />
<br />
<b>Warning</b>:  Attempt to read property "loanAmount" on null in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/microfin/reports/loanWriteOffReportViews/LoanWriteOffReportView.blade.php</b> on line <b>121</b><br />
<br />
<b>Warning</b>:  Undefined variable $writeOffInfo in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/microfin/reports/loanWriteOffReportViews/LoanWriteOffReportView.blade.php</b> on line <b>125</b><br />
<br />
<b>Warning</b>:  Attempt to read property "principal_amount" on null in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/microfin/reports/loanWriteOffReportViews/LoanWriteOffReportView.blade.php</b> on line <b>125</b><br />
<br />
<b>Warning</b>:  Undefined variable $writeOffInfo in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/microfin/reports/loanWriteOffReportViews/LoanWriteOffReportView.blade.php</b> on line <b>126</b><br />
<br />
<b>Warning</b>:  Attempt to read property "savingsBalance" on null in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/microfin/reports/loanWriteOffReportViews/LoanWriteOffReportView.blade.php</b> on line <b>126</b><br />
<br />
<b>Warning</b>:  Undefined variable $writeOffInfo in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/microfin/reports/loanWriteOffReportViews/LoanWriteOffReportView.blade.php</b> on line <b>127</b><br />
<br />
<b>Warning</b>:  Attempt to read property "interest_amount" on null in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/microfin/reports/loanWriteOffReportViews/LoanWriteOffReportView.blade.php</b> on line <b>127</b><br />
<br />
<b>Warning</b>:  Undefined variable $writeOffInfo in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/microfin/reports/loanWriteOffReportViews/LoanWriteOffReportView.blade.php</b> on line <b>130</b><br />
<br />
<b>Warning</b>:  Attempt to read property "loanAmount" on null in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/microfin/reports/loanWriteOffReportViews/LoanWriteOffReportView.blade.php</b> on line <b>130</b><br />
<br />
<b>Warning</b>:  Undefined variable $writeOffInfo in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/microfin/reports/loanWriteOffReportViews/LoanWriteOffReportView.blade.php</b> on line <b>134</b><br />
<br />
<b>Warning</b>:  Attempt to read property "savingsBalance" on null in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/microfin/reports/loanWriteOffReportViews/LoanWriteOffReportView.blade.php</b> on line <b>134</b><br />
<br />
<b>Warning</b>:  Undefined variable $writeOffInfo in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/microfin/reports/loanWriteOffReportViews/LoanWriteOffReportView.blade.php</b> on line <b>135</b><br />
<br />
<b>Warning</b>:  Attempt to read property "principal_amount" on null in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/microfin/reports/loanWriteOffReportViews/LoanWriteOffReportView.blade.php</b> on line <b>135</b><br />
<br />
<b>Warning</b>:  Undefined variable $writeOffInfo in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/microfin/reports/loanWriteOffReportViews/LoanWriteOffReportView.blade.php</b> on line <b>136</b><br />
<br />
<b>Warning</b>:  Attempt to read property "interest_amount" on null in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/microfin/reports/loanWriteOffReportViews/LoanWriteOffReportView.blade.php</b> on line <b>136</b><br />
                        <tr class="item{{ $no + 1 }}">
                            <td class="text-center slNo" style="text-align: center;">{{ ++$no }}</td>

                            <td style="text-align: left; ">{{ $writeOffInfo->samity_name }}</td>
                            <td style="text-align: middle;">{{ $writeOffInfo->samity_code }}</td>

                            <td style="text-align: middle;">{{ $writeOffInfo->member_code }}</td>
                            <td style="text-align: left; ">{{ $writeOffInfo->member_name }}</td>

                            @if ($writeOffInfo->fatherName == null)
                                <td calss="name" style="text-align: left; ">{{ $writeOffInfo->spouseName }}</td>
                            @else($writeOffInfo->spouseName == NULL)
                                <td calss="name" style="text-align: left; ">{{ $writeOffInfo->fatherName }}</td>
                            @endif

                            <td style="text-align: middle;">{{ $writeOffInfo->loanCode }}</td>
                            <td style="text-align: middle;">
                                {{ date('d-m-Y', strtotime($writeOffInfo->disbursementDate)) }}</td>
                            <td class="amount" style="text-align: right; ">
                                {{ number_format($writeOffInfo->loanAmount, 2) }}</td>

                            <td class="amount" style="text-align: right; ">
                                {{ number_format($loanRecoBefLoanWriteOffCashBank, 2) }}</td>
                            <td class="amount" style="text-align: right; ">
                                {{ number_format($loanRecoBefWriteOffTotalAmount, 2) }}</td>
                            <td class="amount" style="text-align: right; ">
                                {{ number_format($totalLoanRecoBefWriteOffAmount, 2) }}</td>

                            @if ($writeOffInfo->lastCollDateBefWritOff == null)
                                <td style="text-align: middle;">-</td>
                            @else
                                <td style="text-align: middle;">
                                    {{ date('d-m-Y', strtotime($writeOffInfo->lastCollDateBefWritOff)) }}</td>
                            @endif
                            <td class="amount" style="text-align: right;">
                                {{ number_format($writeOffInfo->savingsBalance, 2) }} </td>

                            <td style="text-align: middle;">
                                {{ date('d-m-Y', strtotime($writeOffInfo->write_off_date)) }}</td>

                            <td class="amount" style="text-align: right; ">
                                {{ number_format($writeOffInfo->principal_amount, 2) }}</td>
                            <td class="amount" style="text-align: right; ">
                                {{ number_format($writeOffInfo->interest_amount, 2) }}</td>
                            <td class="amount" style="text-align: right; ">{{ number_format($toWriteOffAmount, 2) }}
                            </td>
                            <td style="text-align: center;">
                                @if($writeOffInfo->lastWriteOfCollectionDate)
                                    {{ \Carbon\Carbon::parse($writeOffInfo->lastWriteOfCollectionDate)->format('d-M-Y') }}
                                @endif
                                    
                            </td>                            
                            <td style="text-align: middle; ">
                                 {{ number_format($writeOffInfo->totalWriteOfCollectionAmount, 2) }}
                            </td>
                        </tr>
                    @endforeach

                    <tr>
                        <td colspan="8" style="text-align: center; background-color: #9cb1d3; ">Sub Total:</td>
                        <td class="amount" style="text-align: right; background-color: #9cb1d3; ">{{number_format($STloanDisTotal, 2)}}</td>
                        <td class="amount" style="text-align: right; background-color: #9cb1d3; ">{{number_format($STLoanRecCashBank, 2)}}</td>
                        <td class="amount" style="text-align: right; background-color: #9cb1d3; ">{{number_format($STLoanRecAdjTotal, 2)}}</td>
                        <td class="amount" style="text-align: right; background-color: #9cb1d3; ">{{number_format($STLoanRecAdjTotalTotal, 2)}}</td>
                        <td style="text-align: right; background-color: #9cb1d3; "></td>
                        <td class="amount" style="text-align: right; background-color: #9cb1d3; ">{{number_format($SavingsTotal, 2)}}</td>
                        <td style="text-align: right; background-color: #9cb1d3; "></td>
                        <td class="amount" style="text-align: right; background-color: #9cb1d3; ">{{number_format($STwriteoffPrincipalTotal, 2)}}</td>
                        <td class="amount" style="text-align: right; background-color: #9cb1d3; ">{{number_format($STwriteoffIntTotal, 2)}}</td>
                        <td class="amount" style="text-align: right; background-color: #9cb1d3; ">{{number_format($STwriteoffIntTotalTotal, 2)}}</td>
                        <td style="text-align: right; background-color: #9cb1d3; "></td>
                        <td style="text-align: right; background-color: #9cb1d3; "></td>

                    </tr>

                @endforeach

                 <tr>
                    <td colspan="8" style="text-align: center; background-color: #9cb1d3; font-weight: bold; ">Grand Total:</td>
                    <td class="amount" style="text-align: right; background-color: #9cb1d3; ">{{number_format($GTloanDisTotal, 2)}}</td>
                    <td class="amount" style="text-align: right; background-color: #9cb1d3; ">{{number_format($GTLoanRecCashBank, 2)}}</td>
                    <td class="amount" style="text-align: right; background-color: #9cb1d3; ">{{number_format($GTLoanRecAdjTotal, 2)}}</td>
                    <td class="amount" style="text-align: right; background-color: #9cb1d3; ">{{number_format($GTLoanRecAdjTotalTotal, 2)}}</td>
                    <td style="text-align: right; background-color: #9cb1d3; "></td>
                    <td class="amount" style="text-align: right; background-color: #9cb1d3; ">{{number_format($GTsavingsTotal, 2)}}</td>
                    <td style="text-align: right; background-color: #9cb1d3; "></td>
                    <td class="amount" style="text-align: right; background-color: #9cb1d3; ">{{number_format($GTwriteoffPrincipalTotal, 2)}}</td>
                    <td class="amount" style="text-align: right; background-color: #9cb1d3; ">{{number_format($GTwriteoffIntTotal, 2)}}</td>
                    <td class="amount" style="text-align: right; background-color: #9cb1d3; ">{{number_format($GTwriteoffIntTotalTotal, 2)}}</td>
                    <td style="text-align: right; background-color: #9cb1d3; "></td>
                    <td style="text-align: right; background-color: #9cb1d3; "></td>
                 </tr>
            </tbody>
        </table>
    </div>
    <div class="row print-div" style="text-align: center; padding-top: 25px;">
        <div class="col-md-5" style="float: left;">
            <table style="font-size:11px;">
                <tr>
                    <td>Prepared By</td>
                    <td><strong>:</strong></td>
                    <td></td>
                </tr>
                <tr>
                    <td>Signature</td>
                    <td><strong>:</strong></td>
                    <td></td>
                </tr>
                <tr>
                    <td>Designation</td>
                    <td><strong>:</strong></td>
                    <td></td>
                </tr>
            </table>
        </div>

        <div class="col-md-4" style="text-align:left; margin:0 auto !important; display:inline-block;">
            <table style="font-size:11px;">
                <tr>
                    <td>Verified By</td>
                    <td><strong>:</strong></td>
                    <td></td>
                </tr>
                <tr>
                    <td>Signature</td>
                    <td><strong>:</strong></td>
                    <td></td>
                </tr>
                <tr>
                    <td>Designation</td>
                    <td><strong>:</strong></td>
                    <td></td>
                </tr>
            </table>
        </div>

        <div class="col-md-2" style="float: right; padding-right: 400;">
            <table style="font-size:10px;">
                <tr>
                    <td>Approved By</td>
                    <td><strong>:</strong></td>
                    <td></td>
                </tr>
                <tr>
                    <td>Signature</td>
                    <td><strong>:</strong></td>
                    <td></td>
                </tr>
                <tr>
                    <td>Designation</td>
                    <td><strong>:</strong></td>
                    <td></td>
                </tr>
            </table>
        </div>
    </div>
</div>
<script type="text/javascript">
    $(document).ready(function() {

        // replace with -
        $('.amount').each(function() {
            if ($(this).text() == 0) {
                $(this).text('-');
            }
        });
        // replace with -
        $('.name').each(function() {
            if ($(this).text() == '') {
                $(this).text('-');
            }
        });

    });
</script>