@extends('layouts/microfin_layout')
@section('title', '|Periodic Collection Component Wise Report #Atiq')
@section('content')

<div class="container-fluid">
  <div class="row">
    <br>
    <br>
    <br>
    <br>
    <br>
  </div>
  <div class="row">
    <div class="col-md-8">
      <h3> <strong>Field officer weekly reports</strong> </h3>
      <strong>
        <table>
          <tr>
            <td>Branch Name & Code</td><td>: {{ $BName->name }} & {{ $BName->branchCode }} </td><td></td>
          </tr>
          <tr>
            <td>Branch Address</td><td>: {{$BName->address}}</td><td></td>
          </tr>
          <tr>
            {{-- @if ($CName>20)
              <td>Component</td><td>: All</td><td></td>
            @elseif ($CName<=20)
              <td>Component</td><td>: {{$CName->shortName}}</td><td></td>
            @endif --}}
          </tr>
          <tr>
            <td>Product</td><td>:</td><td></td>
          </tr>
          <tr>
            <td>Reporting Date</td><td>:</td><td></td>
          </tr>
        </table>
      </strong>
    </div>
    <div class="col-md-4">
      <strong>Print Date:</strong>
    </div>
  </div>

  <div class="row">
    <div class="col-md-12">
      <h4 align="center"><strong>Part A</strong></h4>
    </div>
  </div>

  <!-- Start of the "Beginning of the week: Part-A" -->
  <div class="row">
    <table class="table table-bordered" width="100%">
      <thead>
        <tr>
          <th colspan="4">
            <div align="center">Field Officer ID:
              {{ $fieldofficerInfos->emp_id }}
            </div>
          </th>
          <th colspan="22">
            <div align="center">Field Officer Name:
              {{ $fieldofficerInfos->emp_name_english }}
            </div>
          </th>
        </tr>
        <tr>
          <th rowspan="4" width="3%"> <div align="center">SL No. </div> </th>
          <th rowspan="4" width="5%"><div align="center">Samity ID </div></th>
          <th rowspan="4" width="5%"><div align="center">Samity Name </div></th>
          <th colspan="23"><div align="center">Beginning of the week </div></th>
        </tr>
        <tr>
          <th rowspan="3" width="4%"><div align="center">Member</div></th>
          <th rowspan="1" colspan="{{$DynamicRow1a}}%"><div align="center">Savings</div></th>
          <th rowspan="3" width="5%"><div align="center">Total Cum. Disburse No</div></th>
          <th rowspan="3" width="5%"><div align="center">Total Cum. Disbursement </div></th>
          <th rowspan="3" width="5%"><div align="center">Cum. Fully Paid No</div></th>
          <th rowspan="3" width="4%"><div align="center">Cum. Fully Paid Amount </div></th>
          <th rowspan="3" width="4%"><div align="center">Cum. Expired Loan No</div></th>
          <th rowspan="3" width="2%"><div align="center">Cum. Expired Loan Amount </div></th>
          <th rowspan="3" width="3%"><div align="center">Current Loan No</div></th>
          <th rowspan="3" width="3%"><div align="center">Current Loan Amount </div></th>
          <th colspan="4" rowspan="1" width="2%"><div align="center">Total Due</div></th>
          <th rowspan="3" width="3%"><div align="center">Outstanding</div></th>
          <th rowspan="3" width="3%"><div align="center">Loan security</div></th>
          <th rowspan="3" width="3%"><div align="center">Additional Fee Collection </div></th>
        </tr>
        <tr>
          @foreach ($ProductNames as $ProductName)
            <th rowspan="2" width="4%"> <div align="center">{{$ProductName->name}}</div> </th>
          @endforeach
          {{-- <th rowspan="2" width="4%"> <div align="center">Vol</div> </th> --}}
          {{-- <th rowspan="2" width="4%"> <div align="center">RS</div> </th>
          <th rowspan="2" width="4%"> <div align="center">VOL(M)</div> </th>
          <th rowspan="2" width="4%"> <div align="center">Samriddy</div> </th>
          <th rowspan="2" width="4%"> <div align="center">OTS </div> </th> --}}
          <th rowspan="2" width="4%"> <div align="center">Total </div> </th>
          <th colspan="2" rowspan="1" width="4%"> <div align="center">Current </div> </th>
          <th colspan="2" rowspan="1" width="4%"> <div align="center"></div>Expired </th>
        </tr>
        <tr>
          <th rowspan="1" width="4%"><div align="center">No.</div></th>
          <th rowspan="1" width="4%"><div align="center">Amount</div></th>
          <th rowspan="1" width="4%"><div align="center">No</div></th>
          <th rowspan="1" width="4%"><div align="center">Amount</div></th>
        </tr>
      </thead>
      <tbody>
                @foreach ($MemberInfos as $MemberInfo)
                  @endforeach

        @foreach ($ShamityInfos as $ShamityInfo)
                    <tr>
            <td>{{$countSL}}</td>
            <td>{{$ShamityInfo->code}}</td>
                        <td>{{$ShamityInfo->name}}</td>
            @foreach ($MemberInfos as $Memberinfo)
              @if ($countSL == $MemCount)
                <br />
<b>Warning</b>:  Undefined variable $MemberInfo in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/microfin/reports/mfnFieldOfficerReport/mfnFieldreport1_new_table.blade.php</b> on line <b>145</b><br />
                <td>{{$Memberinfo}}<td>
              @endif
                          @endforeach

            @foreach ($WeeklySavings as $WeeklySaving)
              @if ($countSL == $SavCount)
                @foreach ($WeeklySaving as $key => $value)
                  <br />
<b>Warning</b>:  Undefined variable $value in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/microfin/reports/mfnFieldOfficerReport/mfnFieldreport1_new_table.blade.php</b> on line <b>154</b><br />
<br />
<b>Warning</b>:  Attempt to read property "Total" on null in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/microfin/reports/mfnFieldOfficerReport/mfnFieldreport1_new_table.blade.php</b> on line <b>154</b><br />
                  {{$value->Total}}
                  @if ($SavCount == $ssCount)
                    <br />
<b>Warning</b>:  Undefined variable $value in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/microfin/reports/mfnFieldOfficerReport/mfnFieldreport1_new_table.blade.php</b> on line <b>157</b><br />
<br />
<b>Warning</b>:  Attempt to read property "Total" on null in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/microfin/reports/mfnFieldOfficerReport/mfnFieldreport1_new_table.blade.php</b> on line <b>157</b><br />
                  @endif
                @endforeach
              @endif
                          @endforeach

            @foreach ($MonthlySavings as $MonthlySaving)
              @if ($countSL == $SavCount1)
                @foreach ($MonthlySaving as $key => $ms)
                  @if ($ms->Total == null)
                                        <td>0</td>
                    @if ($SavCount1 == $ssCount)
                                          @endif
                  @elseif ($ms->Total != null)
                    <br />
<b>Warning</b>:  Undefined variable $ms in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/microfin/reports/mfnFieldOfficerReport/mfnFieldreport1_new_table.blade.php</b> on line <b>174</b><br />
<br />
<b>Warning</b>:  Attempt to read property "Total" on null in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/microfin/reports/mfnFieldOfficerReport/mfnFieldreport1_new_table.blade.php</b> on line <b>174</b><br />
                    <td>{{$ms->Total}}</td>
                    @if ($SavCount1 == $ssCount)
                      <br />
<b>Warning</b>:  Undefined variable $ms in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/microfin/reports/mfnFieldOfficerReport/mfnFieldreport1_new_table.blade.php</b> on line <b>177</b><br />
<br />
<b>Warning</b>:  Attempt to read property "Total" on null in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/microfin/reports/mfnFieldOfficerReport/mfnFieldreport1_new_table.blade.php</b> on line <b>177</b><br />
                    @endif
                  @endif
                @endforeach
              @endif
                          @endforeach

            @foreach ($SomriddhySavings as $SomriddhySaving)
              @if ($countSL == $SavCount2)
                @foreach ($SomriddhySaving as $key => $ss)
                  @if ($ss->Total == null)
                                        <td>0</td>
                    @if ($SavCount2 == $ssCount)
                                          @endif
                  @elseif ($ss->Total != null)
                    <br />
<b>Warning</b>:  Undefined variable $ss in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/microfin/reports/mfnFieldOfficerReport/mfnFieldreport1_new_table.blade.php</b> on line <b>195</b><br />
<br />
<b>Warning</b>:  Attempt to read property "Total" on null in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/microfin/reports/mfnFieldOfficerReport/mfnFieldreport1_new_table.blade.php</b> on line <b>195</b><br />
                    <td>{{$ss->Total}}</td>
                    @if ($SavCount2 == $ssCount)
                      <br />
<b>Warning</b>:  Undefined variable $ss in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/microfin/reports/mfnFieldOfficerReport/mfnFieldreport1_new_table.blade.php</b> on line <b>198</b><br />
<br />
<b>Warning</b>:  Attempt to read property "Total" on null in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/microfin/reports/mfnFieldOfficerReport/mfnFieldreport1_new_table.blade.php</b> on line <b>198</b><br />
                    @endif
                  @endif
                @endforeach
              @endif
                          @endforeach

            @foreach ($OneTimeSavings as $OneTimeSaving)
              @if ($countSL == $SavCount3)
                @foreach ($OneTimeSaving as $key => $ots)
                  @if ($ots->Total == null)
                                        <td>0</td>
                    @if ($SavCount3 == $ssCount)
                                          @endif
                  @elseif ($ots->Total != null)
                    <br />
<b>Warning</b>:  Undefined variable $ots in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/microfin/reports/mfnFieldOfficerReport/mfnFieldreport1_new_table.blade.php</b> on line <b>216</b><br />
<br />
<b>Warning</b>:  Attempt to read property "Total" on null in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/microfin/reports/mfnFieldOfficerReport/mfnFieldreport1_new_table.blade.php</b> on line <b>216</b><br />
                    <td>{{$ots->Total}}</td>
                    @if ($SavCount3 == $ssCount)
                      <br />
<b>Warning</b>:  Undefined variable $ots in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/microfin/reports/mfnFieldOfficerReport/mfnFieldreport1_new_table.blade.php</b> on line <b>219</b><br />
<br />
<b>Warning</b>:  Attempt to read property "Total" on null in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/microfin/reports/mfnFieldOfficerReport/mfnFieldreport1_new_table.blade.php</b> on line <b>219</b><br />
                    @endif
                  @endif
                @endforeach
              @endif
                          @endforeach
                                                                                    <td>
              {{$ssTotalValue}}
                                        </td>
            {{-- <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td> --}}
          </tr>
        @endforeach
        <tr>
          <td>Total</td>
          <td colspan="2">{{$TotalSamityCount}}</td>
          <td>{{$TotalMemberCount}}</td>
          <td>{{$TotalWeeklySavingsCount}}</td>
          <td>{{$TotalMonthlySavingsCount}}</td>
          <td>{{$TotalSomriddhySavingsCount}}</td>
          <td>{{$TotalOneTimeSavingsCount}}</td>
          <td>{{$ssAllTotalValue}}</td>
        </tr>
      </tbody>
    </table>
  </div>
  <!-- End of the "Beginning of the week: Part-A" -->

  <div class="row">
    <h4 align="center"><strong>Part B</strong></h4>
  </div>

  <!-- Start of the "For The Week: Part-B" -->
  <div class="row">
    <table class="table table-bordered">
      <thead>
        <tr>
          <th colspan="4"><div align="center">Field Officer ID:</div></th>
          <th colspan="22"><div align="center">Field Officer Name:</div></th>
        </tr>
        <tr>
          <th colspan="26"> <div class="">For The Week</div> </th>
        </tr>
        <tr>
          <th rowspan="3" width="4%"><div align="center">Samity ID </div></th>
          <th rowspan="3" width="4%"><div align="center">Member Admission </div></th>
          <th rowspan="3" width="3%"><div align="center">Member Dropout </div></th>
          <th colspan="5" rowspan="1" width="{{$DynamicRow1a}}%"><div align="center">Savings Collection </div></th>
          <th colspan="5" rowspan="1" width="{{$DynamicRow1a}}%"><div align="center">Savings Refund </div></th>
          <th  rowspan="3" width="4%"><div align="center">Disbursement No. </div></th>
          <th  rowspan="3" width="4%"><div align="center">Disburs Amount </div></th>
          <th  rowspan="3" width="5%"><div align="center">Fully Paid Loan No. </div></th>
          <th  rowspan="3" width="4%"><div align="center">Fully Paid Amount </div></th>
          <th  rowspan="3" width="3%"><div align="center">Expired Loan No. </div></th>
          <th  rowspan="3" width="3%"><div align="center">Expired Loan Amount</div></th>
          <th  rowspan="3" width="4%"><div align="center">Regular Recoverable </div></th>
          <th  colspan="5" width="3%"><div align="center">Recovery</div></th>
          <th  rowspan="3" width="3%"><div align="center">This Week New Due/Less Rec. </div></th>
        </tr>
        <tr>
          <!-- Savings Collection . We need to use loop -->
          @foreach ($ProductNames as $ProductName)
            <th rowspan="2" width="4%"> <div align="center">{{$ProductName->name}}</div> </th>
          @endforeach
          <th rowspan="2" width="4%"> <div align="center">Total</div> </th>
          @foreach ($ProductNames as $ProductName)
            <th rowspan="2" width="4%"> <div align="center">{{$ProductName->name}}</div> </th>
          @endforeach
          <th rowspan="2" width="4%"> <div align="center">Total</div> </th>
          <th rowspan="2" width="3%"><div align="center">Regular</div></th>
          <th colspan="2" width="3%"><div align="center">Due</div></th>
          <th rowspan="2" width="3%"><div align="center">Advance</div></th>
        </tr>
      </thead>
      <tbody>
                @foreach ($MemberInfos as $MemberInfo)
                  @endforeach
        @foreach ($ShamityInfos as $ShamityInfo)
                    <tr>
            <td>{{$ShamityInfo->code}}</td>

            {{-- <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td> --}}
          </tr>
        @endforeach
      </tbody>
    </table>
  </div>
  <!-- End of the "For the week: Part-B" -->

  <div class="row">
    <h4 align="center"><strong>Part C</strong></h4>
  </div>

  <!-- Start of the "End of The Week" -->
  <div class="row">
    <table class="table table-bordered" width="100%">
      <thead>
        <tr>
          <th colspan="4"><div align="center">Field Officer ID:</div></th>
          <th colspan="22"><div align="center">Field Officer Name:</div></th>
        </tr>
        <tr>
          <th rowspan="4" width="5%"><div align="center">Samity ID </div></th>
          <th colspan="25"><div align="center">Beginning of the week </div></th>
        </tr>
        <tr>
          <th rowspan="3" width="4%"><div align="center">Member</div></th>
          <th rowspan="1" colspan="{{$DynamicRow1a}}%"><div align="center">Savings</div></th>
          <th rowspan="3" width="5%"><div align="center">Total Cum. Disburse No</div></th>
          <th rowspan="3" width="5%"><div align="center">Total Cum. Disbursement </div></th>
          <th rowspan="3" width="5%"><div align="center">Cum. Fully Paid No</div></th>
          <th rowspan="3" width="4%"><div align="center">Cum. Fully Paid Amount </div></th>
          <th rowspan="3" width="4%"><div align="center">Cum. Expired Loan No</div></th>
          <th rowspan="3" width="2%"><div align="center">Cum. Expired Loan Amount </div></th>
          <th rowspan="3" width="3%"><div align="center">Current Loan No</div></th>
          <th rowspan="3" width="3%"><div align="center">Current Loan Amount </div></th>
          <th colspan="6" rowspan="1" width="2%"><div align="center">Total Due</div></th>
          <th rowspan="3" width="3%"><div align="center">Outstanding</div></th>
          <th rowspan="3" width="3%"><div align="center">Loan security</div></th>
          <th rowspan="3" width="3%"><div align="center">Additional Fee Collection </div></th>
        </tr>
        <tr>
          @foreach ($ProductNames as $ProductName)
            <th rowspan="2" width="4%"> <div align="center">{{$ProductName->name}}</div> </th>
          @endforeach
          <th rowspan="2" width="4%"> <div align="center">Total</div> </th>
          {{-- <th rowspan="2" width="4%"> <div align="center">Vol</div> </th>
          <th rowspan="2" width="4%"> <div align="center">RS</div> </th>
          <th rowspan="2" width="4%"> <div align="center">VOL(M)</div> </th>
          <th rowspan="2" width="4%"> <div align="center">Samriddy</div> </th>
          <th rowspan="2" width="4%"> <div align="center">OTS </div> </th>
          <th rowspan="2" width="4%"> <div align="center">Total </div> </th> --}}
          <th colspan="2" rowspan="1" width="4%"> <div align="center">Current </div> </th>
          <th colspan="2" rowspan="1" width="4%"> <div align="center"></div>Expired </th>
          <th colspan="2" rowspan="1" width="4%"> <div align="center"></div>Total </th>
        </tr>
        <tr>
          <th rowspan="1" width="4%"><div align="center">No.</div></th>
          <th rowspan="1" width="4%"><div align="center">Amount</div></th>
          <th rowspan="1" width="4%"><div align="center">No</div></th>
          <th rowspan="1" width="4%"><div align="center">Amount</div></th>
          <th rowspan="1" width="4%"><div align="center">No</div></th>
          <th rowspan="1" width="4%"><div align="center">Amount</div></th>
        </tr>
      </thead>
      <tbody>
                @foreach ($MemberInfos as $MemberInfo)
                  @endforeach
        @foreach ($ShamityInfos as $ShamityInfo)
                    <tr>
            <td>{{$ShamityInfo->code}}</td>
            @foreach ($MemberInfos as $Memberinfo)
              @if ($countSL == $MemCount)
                <td>{{$Memberinfo}}<td>
              @endif
                          @endforeach
            
            {{-- <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td> --}}
          </tr>
        @endforeach
      </tbody>
    </table>
  </div>
  <!-- End of the "End of the week: Part-C" -->

</div>