@extends('layouts/microfin_layout')
@section('title', '| Opening Savings Adjustment 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/openingAdjustment/savings/create') }}" 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 ADJUSTMENT LIST</font></h1>
		</div>
		<div class="panel-body panelBodyView">
       @if($userBranchId == 1)
      <!-- Filtering Start-->
      {!! Form::open(array('url' => 'mfn/openingAdjustment/savings', '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: 18px;">
              <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-sm']); !!}
                </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>
          <tbody>
          @php
          $productInfos = DB::table('mfn_opening_adjustment_savings')
              ->where('branchIdFk', $branchId)
              ->groupBy('productIdFk')
              ->pluck('productIdFk')
              ->toArray();
           @endphp   
              @foreach ($productInfos as $key => $productId)
                @php 
                $slLoanProduct = 1;
                $productName = DB::table('mfn_loans_product')
                  ->where('id', $productId)
                  ->value('name');

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

                @foreach ($savingsProduct as $savingsProductId)
                  @php
                    $savingsProductName = DB::table('mfn_saving_product')
                        ->where('id', $savingsProductId)
                        ->value('name');
                    
                    $genders = DB::table('mfn_opening_adjustment_savings')
                        ->where([
                            ['branchIdFk', $branchId],
                            ['productIdFk', $productId],
                            ['savingProductIdFk', $savingsProductId],
                          ])
                        ->pluck('genderTypeId')
                        ->toArray();
                    @endphp
                    @foreach($genders as $key => $gender)
                    @php 
                      $opData = DB::table('mfn_opening_adjustment_savings')
                        ->where([
                            ['branchIdFk', $branchId], 
                            ['productIdFk', $productId],
                            ['savingProductIdFk', $savingsProductId],
                            ['genderTypeId', $gender],
                          ])
                        ->first();
                    @endphp
                      <tr>
                          <td>{{ $key+1 }}</td>
                          @if($slLoanProduct == 1)<td class="name" rowspan="{{sizeof($savingsProduct)*sizeof($genders)}}">{{ $productName }}</td>  @endif
                          <td class="name">{{ $savingsProductName }}</td>
                          <td class="name">{{ $genderList[$opData->genderTypeId] }}</td>
                          <td>
                            <a href="{{ url('mfn/openingAdjustment/savings/view').'/'.$opData->id }}" data-id="{{ $opData->id }}">
                              <i class="fa fa-eye" aria-hidden="true"></i>
                            </a> &nbsp
                            <a href="{{ url('mfn/openingAdjustment/savings/edit').'/'.$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>
                      @php $slLoanProduct++; @endphp
                    @endforeach
                @endforeach            
              @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: "{{ url('mfn/openingAdjustment/savings/delete') }}",
                type: 'POST',
                dataType: 'json',
                data: {id: id},
            })
            .done(function(data) {
                // console.log('')
                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