@extends('layouts/microfin_layout')
@section('title', '| Opening Loan Information List')
@section('content')

@php  
    $branchSelected = isset($_GET['filBranch']) ? $_GET['filBranch'] : $userBranchId;
@endphp
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
	<div class="panel panel-default" style="background-color:#708090;">
		<div class="panel-heading" style="padding-bottom:0px">
			<div class="panel-options">
              <a href="{{ url('mfn/branchOpeningSavingsInformationAdd') }}" class="btn btn-info pull-right addViewBtn" autofocus><i class="glyphicon glyphicon-plus-sign addIcon" aria-hidden="true"></i> Add Data</a>
              
            </div>
			<h1 align="center" style="font-family: Antiqua;letter-spacing: 2px"><font color="white">SAVINGS INFORMATION LIST</font></h1>
		</div>
		<div class="panel-body panelBodyView">
       @if($userBranchId == 1)
      <!-- Filtering Start-->
      {!! Form::open(array('url' => 'mfn/branchOpeningSavingsInformation', 'role' => 'form', 'class'=>'form-horizontal form-groups', 'id' => 'filterFormId', 'method'=>'get')) !!}
        <div class="row">
          <div class="col-md-12">
            
            <div class="col-md-2">
              <div class="form-group">
                <div class="col-md-12">
                  {!! Form::label('', 'Branch:', ['class' => 'control-label pull-left']) !!}
                </div>
                <div class="col-md-12">
                  {!! Form::select('filBranch', [''=>'--Select--']+$branchList, $branchSelected ,['id'=>'filBranch','class'=>'form-control input-sm','autocomplete'=>'off']) !!}
                </div>
              </div>
            </div>               

            <div class="col-md-1" style="padding-top: 20px;">
              <div class="form-group">
                {!! Form::label('', '', ['class' => 'control-label col-md-12']) !!}
                <div class="col-md-12">                                    
                  {!! Form::submit('Search', ['id' => 'searchButton', 'class' => 'btn btn-primary btn-xs']); !!}
                </div>
              </div>
            </div>
              
          </div>
        </div>
              
      {!! Form::close()  !!}
      <!-- filtering end-->  

      @endif  

        <table class="table table-striped table-bordered" id="areaListView">

                <thead>
                    <tr>
                        <th width="80">SL#</th>
                        <th>Loan Product</th>
                        <th>Savings Product</th>
                        <th>Gender</th>
                        <th width="150">Action</th>
                    </tr>
                </thead>
                @php
                    $slNo = 0;
                @endphp
                <tbody>
                    @foreach ($branchInfos as $key => $branchId)
                        @php
                            $branchName = DB::table('gnr_branch')
                                ->where('id', '=', $branchId)
                                ->pluck('name')
                                ->toArray();

                            $branchCode = DB::table('gnr_branch')
                                ->where('id', '=', $branchId)
                                ->pluck('branchCode')
                                ->toArray();

                            $productInfos = DB::table('mfn_opening_info_savings')
                                ->where('branchIdFk', $branchId)
                                ->groupBy('productIdFk')
                                ->pluck('productIdFk')
                                ->toArray();
                        @endphp

                        <tr>
                            <td></td>

                            <td class="name" colspan="4">
                                <strong> Branch Name & Code : {{$branchName[0]}} - {{ str_pad($branchCode[0],3,0,STR_PAD_LEFT) }} </strong> 
                            </td>
                        </tr>

                        @foreach ($productInfos as $productId)
                            @php
                                $productName = DB::table('mfn_loans_product')
                                    ->where('id', $productId)
                                    ->pluck('name')
                                    ->toArray();

                                $savingsProduct = DB::table('mfn_opening_info_savings')
                                    ->where([['branchIdFk', $branchId], ['productIdFk', $productId]])
                                    ->groupBy('savingProductIdFk')
                                    ->pluck('savingProductIdFk')
                                    ->toArray();

                                $countLoanProduct = 0;
                            @endphp

                            

                            @foreach ($savingsProduct as $savingsProductId)
                                @php
                                    $savingsProductName = DB::table('mfn_saving_product')
                                        ->where('id', $savingsProductId)
                                        // ->groupBy('name')
                                        ->pluck('name')
                                        ->toArray();
                                @endphp

                                @if ($countLoanProduct == 0)
                                    <tr>
                                        <td rowspan="{{sizeof($savingsProduct) * 2}}">
                                            {{++$slNo}}
                                        </td>

                                        <td class="name" rowspan="{{sizeof($savingsProduct) * 2}}">
                                            {{$productName[0]}} 
                                        </td>

                                        <td class="name" rowspan="2" style="background-color: white !important; color: black !important;">
                                            {{$savingsProductName[0]}}
                                        </td>

                                        <td style="background-color: white !important; color: black !important;">
                                            Male
                                        </td>

                                        @php
                                            $infoId = $branchId.'-'.$productId.'-'.$savingsProductId.'-1';
                                        @endphp

                                        <td>
                                            <a href="{{ url('mfn/branchOpeningSavingsInformationDetails').'/'.encrypt($infoId) }}" data-id="{{$infoId }}">
                                                <i class="fa fa-eye" aria-hidden="true"></i>
                                            </a> &nbsp
                                            <a href="{{ url('mfn/branchOpeningSavingsInformationEdit').'/'.encrypt($infoId) }}" data-id="{{ $infoId }}">
                                                <i class="fa fa-pencil-square-o fa-lg" aria-hidden="true"></i>
                                            </a> &nbsp
                                            <a href="javascript:;" class="deleteConfirmation" data-id="{{ $infoId }}">
                                                <i class="fa fa-trash-o fa-lg" aria-hidden="true"></i>
                                            </a>
                                        </td>
                                    </tr>

                                    <tr>
                                        <td style="background-color: white !important; color: black !important;">
                                            Female
                                        </td>

                                        @php
                                            $infoId = $branchId.'-'.$productId.'-'.$savingsProductId.'-2';
                                        @endphp

                                        <td>
                                            <a href="{{ url('mfn/branchOpeningSavingsInformationDetails').'/'.encrypt($infoId) }}" data-id="{{ $infoId }}">
                                                <i class="fa fa-eye" aria-hidden="true"></i>
                                            </a> &nbsp
                                            <a href="{{ url('mfn/branchOpeningSavingsInformationEdit').'/'.encrypt($infoId) }}" data-id="{{ $infoId }}">
                                                <i class="fa fa-pencil-square-o fa-lg" aria-hidden="true"></i>
                                            </a> &nbsp
                                            <a href="javascript:;" class="deleteConfirmation" data-id="{{ $infoId }}">
                                                <i class="fa fa-trash-o fa-lg" aria-hidden="true"></i>
                                            </a>
                                        </td>
                                    </tr>
                                    @php
                                        ++$countLoanProduct;
                                    @endphp
                                @endif
                                
                                @if ($countLoanProduct > 1)
                                    <tr>
                                        <td class="name" rowspan="2" style="background-color: white !important; color: black !important;">
                                            {{$savingsProductName[0]}}
                                        </td>

                                        <td style="background-color: white !important; color: black !important;">
                                            Male
                                        </td>

                                        @php
                                            $infoId = $branchId.'-'.$productId.'-'.$savingsProductId.'-1';
                                        @endphp

                                        <td>
                                            <a href="{{ url('mfn/branchOpeningSavingsInformationDetails').'/'.encrypt($infoId) }}" data-id="{{ $infoId }}">
                                                <i class="fa fa-eye" aria-hidden="true"></i>
                                            </a> &nbsp
                                            <a href="{{ url('mfn/branchOpeningSavingsInformationEdit').'/'.encrypt($infoId) }}" data-id="{{ $infoId }}">
                                                <i class="fa fa-pencil-square-o fa-lg" aria-hidden="true"></i>
                                            </a> &nbsp
                                            <a href="javascript:;" class="deleteConfirmation" data-id="{{ $infoId }}">
                                                <i class="fa fa-trash-o fa-lg" aria-hidden="true"></i>
                                            </a>
                                        </td>
                                    </tr>

                                    <tr>
                                        <td style="background-color: white !important; color: black !important;">
                                            Female
                                        </td>

                                        @php
                                            $infoId = $branchId.'-'.$productId.'-'.$savingsProductId.'-2';
                                        @endphp

                                        <td>
                                            <a href="{{ url('mfn/branchOpeningSavingsInformationDetails').'/'.encrypt($infoId) }}" data-id="{{ $infoId }}">
                                                <i class="fa fa-eye" aria-hidden="true"></i>
                                            </a> &nbsp
                                            <a href="{{ url('mfn/branchOpeningSavingsInformationEdit').'/'.encrypt($infoId) }}" data-id="{{ $infoId }}">
                                                <i class="fa fa-pencil-square-o fa-lg" aria-hidden="true"></i>
                                            </a> &nbsp
                                            <a href="javascript:;" class="deleteConfirmation" data-id="{{ $infoId }}">
                                                <i class="fa fa-trash-o fa-lg" aria-hidden="true"></i>
                                            </a>
                                        </td>
                                    </tr>
                                @endif

                                @php
                                    ++$countLoanProduct;
                                @endphp
                                
                            @endforeach

                        @endforeach
                        
                    @endforeach

              {{-- @foreach ($openingData as $key => $opData)
                  <tr>
                      <td>{{ $key+1 }}</td>
                      <td class="name">{{ $loanProducts->where('id',$opData->productIdFk)->first()->name }}</td>  
                      <td class="name">{{ $genderList[$opData->genderTypeId] }}</td>
                      <td>
                        <a href="{{ url('mfn/viewDetailsBranchOpeningLoanInformation').'/'.encrypt($opData->id) }}" data-id="{{ $opData->id }}">
                          <i class="fa fa-eye" aria-hidden="true"></i>
                        </a> &nbsp
                        <a href="{{ url('mfn/updateDetailsBranchOpeningLoanInformation').'/'.encrypt($opData->id) }}" data-id="{{ $opData->id }}">
                          <i class="fa fa-pencil-square-o fa-lg" aria-hidden="true"></i>
                        </a> &nbsp
                        <a href="javascript:;" class="deleteConfirmation" data-id="{{ $opData->id }}">
                          <i class="fa fa-trash-o fa-lg" aria-hidden="true"></i>
                        </a>
                      </td>
                  </tr>
              @endforeach             --}}
          </tbody>
            </table>
			
			
		</div>
	</div>
</div>
<div class="col-md-1"></div>
</div>

{{-- Delete Modal --}}
<div class="modal fade" id="delete-confirmation-modal" style="padding-top: 10%;">
  <div class="modal-dialog">
    <div class="modal-header">
      <h4 class="modal-title">Delete Confirmation</h4>
      <a class="close" href="#" data-dismiss="modal">X</a>
    </div>
    <div class="modal-content">
      <div class="modal-body">
        Are you sure to delete this record?
      </div>
    </div>
    <div class="modal-footer">
      <div class="form-group hidden">
        <div class="col-sm-6 col-sm-offset-2">
          {!! Form::text('id', null, ['class' => 'form-control', 'id' => 'id', 'type' => 'text', 'readonly']) !!}
        </div>
      </div>
      <button id="yesBtn" type="button" class="btn btn-info animated slideInRight" style="margin-bottom:0!important;" autofocus>Yes</button>
      <button id="noBtn" type="button" class="btn btn-white animated slideInRight" data-dismiss="modal" style="margin-bottom:0!important;">No</button>
    </div>
  </div>
</div>
{{-- End Delete Modal --}}

<script type="text/javascript">
  $(document).ready(function() {
     /*delete modal*/
      $(document).on('click', '.deleteConfirmation', function(event) {
          event.preventDefault();
          $('#id').val($(this).data('id'));
          $("#delete-confirmation-modal").modal('show');
      });
      /*end delete modal*/

      /*delete day end*/
        $("#yesBtn").click(function(event) {
            var id = $("#id").val();
            console.log('got it');
            $.ajax({
                url: './deleteBranchOpeningSavingsInformation',
                type: 'POST',
                dataType: 'json',
                data: {id: id},
            })
            .done(function(data) {
                if (data.responseTitle=='Success!') {
                    toastr.success(data.responseText, data.responseTitle, opts);     
                                     
                  setTimeout(function(){
                      location.reload();
                  }, 2000);
                }
                else if(data.responseTitle=='Warning!'){
                    toastr.warning(data.responseText, data.responseTitle, opts);                        
                }
            })
            .fail(function() {
                alert("error");
            });
            
        });
        /*end delete day end*/
  });
</script>

@endsection