@extends('layouts/microfin_layout')
@section('title', '| Add Loan Rebate')
@section('content')

@php
  use \App\Http\Controllers\microfin\savings\MfnSavingsDepositTypeController as createForm;
@endphp

<div class="row add-data-form">
  <div class="col-md-12">
        <div class="col-md-10 col-md-offset-1 fullbody">
          <div class="viewTitle" style="border-bottom:1px solid white;">
                <a href="{{ url('viewMfnLoanRebates/') }}" class="btn btn-info pull-right addViewBtn">
                  <i class="glyphicon glyphicon-th-list viewIcon"></i>
                  Loan Rebate List
                </a>
            </div>
            <div class="panel panel-default panel-border">
              <div class="panel-heading">
                    <div class="panel-title">New Loan Rebate</div>
                </div>
                <div class="panel-body">
                  <div class="row">
            
            {!! Form::open(array('url' => '', 'role' => 'forl', 'id' => 'rootwizard', 'class' => 'form-horizontal form-groups', 'novalidate' => '')) !!}              
            
              <div class="tab-content no-margin">
                <div class="tab-pane with-bg active" id="fwv-1">
                  <div class="panel panel-default" style="padding:0!important;">
                    
                    <div class="panel-body" style="padding:5px 10px;">
                      <div class="row">
                        <div class="col-xs-6">

                        {!! Form::hidden('memberId',null,['id'=>'memberId']) !!}
                        {!! Form::hidden('branchId',null,['id'=>'branchId']) !!}
                        {!! Form::hidden('samityId',null,['id'=>'samityId']) !!}
                        {!! Form::hidden('workingAreaId',null,['id'=>'workingAreaId']) !!}

                        @if(!in_array($userRoleId, Config('services.branch_level_user_roles')))
                            {!! createForm::select('filBranch',$branchList,null,'Branch:',['id'=>'filBranch','autocomplete'=>'off']) !!}
                        @endif

                        {!! createForm::select('filSamity',$samityList,null,'Samity:',['id'=>'filSamity','autocomplete'=>'off']) !!}	

                        {!! createForm::text('member','','Member:',['id'=>'member','autocomplete'=>'off']) !!}          
                        {!! createForm::select('loanId',[''=>'Select'],null,'Loan Id:',['id'=>'loanId','autocomplete'=>'off']) !!}

                        {!! createForm::text('rebateDate',null,'Rebate Date:',['id'=>'rebateDate','autocomplete'=>'off','readonly'=>'readonly','style'=>'cursor:pointer']) !!}

                        {!! createForm::text('principalAmount','','Principal Amount:',['id'=>'principalAmount','autocomplete'=>'off','readonly'=>'readonly']) !!}
                        {!! createForm::text('interestAmount','','Interest Amount:',['id'=>'interestAmount','autocomplete'=>'off','readonly'=>'readonly']) !!}
                        {!! createForm::text('rebateAmount','','Rebate Amount:',['id'=>'rebateAmount','autocomplete'=>'off','amountLimit'=>0]) !!}

                        <div class="form-group">
                          {!! Form::label('notes', 'Notes:', ['class' => 'col-sm-4 control-label']) !!}
                            <div class="col-sm-8">
                             {!! Form::textarea('notes','',['class'=>'form-control','rows'=>4]) !!}
                            </div>                                            
                        </div>

                      </div>{{-- End First Column --}}

              {{-- Second Coloum --}}
              <div class="col-xs-6" >

                @php
                  $tableRows = ['Payable','Transaction','Outstanding','Installment','Advance','Due','Rebateable','Payable After Rebate'];
                @endphp

              <h4 id="loanInfoTableHeading">Loan Information</h4>
              <table id="loanInfoTable" class="table table-striped table-bordered">
                 <thead>
                   <tr>
                     <th>Loan</th>
                     <th>Total</th>
                     <th>Principal</th>
                     <th>Interest</th>
                   </tr>
                 </thead>
                 <tbody>
                  @foreach ($tableRows as $tableRow)
                    <tr class="{{$tableRow}}">
                     <td class="name">{{$tableRow}}</td>
                     <td class="amount"></td>
                     <td class="amount"></td>
                     <td class="amount"></td>
                    </tr>
                  @endforeach
                   
                 </tbody>
              </table>          

              
            </div>
            {{-- End Second Coloum --}}
                        
                      </div>
                      
                      <ul class="pager wizard pull-right">                    
                            {!! Form::submit('Submit', ['id' => 'submit', 'class' => 'btn btn-info']) !!}
                          </ul>
                      
                    </div>
                  </div>
                  
                
                </div>
                
                
              </div>
            {!! Form::close() !!}
                    </div>
                </div>
            </div>
        </div>
  </div>
</div>

@php
  
  // if (Auth::user()->branchId==1) {
  //   $memberIdsFromLoan = DB::table('mfn_loan')->where('softDel',0)->pluck('memberIdFk')->toArray();
  //   dd($memberIdsFromLoan);
  //   $members = DB::table('mfn_member_information')->where('softDel',0)->whereIn('id',$memberIdsFromLoan)->where('status',1)->orderBy('code')->select('id','name','code','branchId','samityId')->get();
  // }
  // else{
  //   $memberIdsFromLoan = DB::table('mfn_loan')->where('softDel',0)->where('branchIdFk',Auth::user()->branchId)->pluck('memberIdFk')->toArray();
  //   dd($memberIdsFromLoan);
  //   $members = DB::table('mfn_member_information')->where('softDel',0)->whereIn('id',$memberIdsFromLoan)->where('status',1)->where('branchId',Auth::user()->branchId)->where('admissionDate','<=',$softDate)->select('id','name','code','branchId','samityId')->get();
  // }
  $members = [];
@endphp
{{-- <div id="memberList" class="container" style="display: none;position: absolute;">
    <table id="memberListTable" class="table table-fixed" style="font-size: 10px;">
      <tbody id="memberListTableBody" style=" display:block;height: 120px;overflow-y: auto !important;overflow-x: hidden;float:left;">
      @foreach ($members as $member)
      @php
        $branchName = DB::table('gnr_branch')->where('id',$member->branchId)->value('name');
        $samity = DB::table('mfn_samity')->where('id',$member->samityId)->select('name','workingAreaId')->first();
        $workingAreaName = DB::table('gnr_working_area')->where('id',$samity->workingAreaId)->value('name');
      @endphp
      <tr>
        <td memberId="{{$member->id}}" branchId="{{$member->branchId}}" samityId="{{$member->samityId}}" workingAreaId="{{$samity->workingAreaId}}" style="text-align: left;">
          <span class="memberName" style="font-size: 11;font-weight: bold;">{{$member->name}}</span> - 
          <span class="memberCode" style="font-size: 11;font-weight: bold;">{{$member->code}}</span><br>
          {{'Branch: '.$branchName}}<br>
          {{'Samity: '.$samity->name}}<br>
          {{'Working Area: '.$workingAreaName}}
        </td>
      </tr>   
      @endforeach
    </tbody>
    </table>
  </div> --}}

  <div id="memberList" class="container" style="display: none;position: absolute;">
		<table id="memberListTable" class="table table-fixed" style="font-size: 10px;">
			<tbody id="memberListTableBody" style=" display:block;height: 120px;overflow-y: auto !important;overflow-x: hidden;float:left;">
			@foreach ($members as $member)
			@php
				$branchName = DB::table('gnr_branch')->where('id',$member->branchId)->value('name');
				$samity = DB::table('mfn_samity')->where('id',$member->samityId)->select('name','workingAreaId')->first();
				$workingAreaName = DB::table('gnr_working_area')->where('id',$samity->workingAreaId)->value('name');
			@endphp
			<tr>
				<td memberId="{{$member->id}}" branchId="{{$member->branchId}}" samityId="{{$member->samityId}}" workingAreaId="{{$samity->workingAreaId}}" style="text-align: left;">
					<span class="memberName" style="font-size: 11;font-weight: bold;">{{$member->name}}</span> - 
					<span class="memberCode" style="font-size: 11;font-weight: bold;">{{$member->code}}</span><br>
					{{'Branch: '.$branchName}}<br>
					{{'Samity: '.$samity->name}}<br>
					{{'Working Area: '.$workingAreaName}}
				</td>
			</tr>		
			@endforeach
		</tbody>
		</table>
	</div>


<style type="text/css">
#rootwizard .panel-body .row {
    margin-bottom: 10px;
  }
  #rootwizard, 
  #rootwizard .form-control {
    font-size: 11px !important;
    padding: 5px !important;
  }
  /*#rootwizard input[type='text']{
    height: 18px !important;
  }*/
  #rootwizard label {
    margin-bottom: 0 !important;
    color: #555 !important;
  }
  .validate-has-error {
    color: #FF0000;
  }
  .error{
    color: red;
  }
  #loanInfoTable,#loanInfoTableHeading {
    color: black;
  }
  #loanInfoTable tbody{
    width: 100px !important;
  }

  #loanInfoTable tbody tr.Rebateable td{
    color: red;
  }
  
</style>

<script type="text/javascript">
  $(document).ready(function() {

    $("#filBranch").change(function(event) {
      var branchId = $(this).val();
      $("#filSamity option:gt(0)").remove();
      $("#memberListTableBody").empty();

      if (branchId=='') {
      return false;
      }

      $.ajax({
        url: './getMfnBranchWiseSamityList',
        type: 'POST',
        dataType: 'json',
        data: {branchId: branchId},
      })
      .done(function(samityList) {
        $.each(samityList, function(index, val) {
          $("#filSamity").append("<option value='"+index+"'>"+val+"</option>");
      });
      })
      .fail(function() {
        alert("response error");
      });
      
    });

    $("#filSamity").change(function(event) {
    var samityId = $(this).val();
    $("#memberListTableBody").empty();
    if (branchId!='') {
        $.ajax({
            url: './getSamityWiseMemeberDropDownList',
            type: 'POST',
            dataType: 'json',
            data: {samityId: samityId},
          })
          .done(function(concatString) {
            $("#memberListTableBody").append(concatString);
            setMemberListTableSize();
          })
          .fail(function() {
            console.log("error");
          });
      }   
    });

    function num(argument){
      return argument.toLocaleString('en-US', { minimumFractionDigits: 2, maximumFractionDigits: 2 });
    }

    $("#rebateAmount").on('input', function() {         
          this.value = this.value.replace(/[^0-9.]/g, '').replace(/(\..*)\./g, '$1');
    });        

    /*Form*/
    $('form').submit(function(event){
            event.preventDefault();

            $("#submit").prop('disabled',true);

            $.ajax({
                type: 'post',
                url: './storeMfnLoanRebate',
                data: $('form').serialize(),
                dataType: 'json',
                success: function(_response) {
                  
                  $(".error").remove();
                    if(_response.errors) {
                      $("#submit").prop('disabled',false);
                      $.each(_response.errors, function(name, error) {
                         $("#"+name).after("<p class='error'>* "+_response.errors[name]+"</p>");
                      });
                    } 
                    else { 
                      if (_response.responseTitle=='Warning!') {
                        toastr.warning(_response.responseText, _response.responseTitle, opts);
                      }
                      else{
                        toastr.success(_response.responseText, _response.responseTitle, opts);
                        
                        setTimeout(function(){
                            window.location.href = '{{ url('viewMfnLoanRebates/') }}';
                        }, 3000);

                      }                
                        
                    }
                },
                error: function(_response) {
                  $("#submit").prop('disabled',false);
                    alert('Response Error');
                }
            });

        });
        /* End Form*/

        /*Hide Errors On Filed input or Change*/
        $(document).on('input', 'input', function() {
          $(this).closest('div').find('.error').remove();
        });
        $(document).on('change', 'select', function() {
          $(this).closest('div').find('.error').remove();
        });
        /*End Hide Errors On Filed input or Change*/

        /*show the member list table on double click the member text field*/
       $("#member").click(function(event) {
        $("#memberList").show('slow/400/fast');
       });
       /*end show the member list table on double click the member text field*/

       /*on select td set the valus of hidden field for the member*/
      //  $("#memberListTable tbody tr td").on('click', function(event) {
      //     $("#memberId").val($(this).attr('memberId'));
      //     $("#branchId").val($(this).attr('branchId'));
      //     $("#samityId").val($(this).attr('samityId'));
      //     $("#workingAreaId").val($(this).attr('workingAreaId'));
          
      //     $("#member").val($(this).find('.memberName').text() + ' - '+$(this).find('.memberCode').text());

      //     $("#memberList").hide('slow/400/fast');   

      //     $("#product").trigger('change');
      //     $("#memberId").trigger('change');
      //  });
      $(document).on('click', '#memberListTable tbody tr td',function(event) {
       		$("#memberId").val($(this).attr('memberId'));
       		$("#branchId").val($(this).attr('branchId'));
       		$("#samityId").val($(this).attr('samityId'));
       		$("#workingAreaId").val($(this).attr('workingAreaId'));
       		
       		$("#member").val($(this).find('.memberName').text() + ' - '+$(this).find('.memberCode').text());

       		$("#memberList").hide('slow/400/fast');   

       		$("#product").trigger('change');
          $("#memberId").trigger('change');
       });
       /*end on select td set the valus of hidden field for the member*/

       /*set the memberList position*/
        function setMemberListTableSize(){
           var top = $('#member').offset().top - 48;
         var left = $('#member').offset().left - 15;
         var width = $('#member').width() + 13;       

         $("#memberList").css({ top: top });
         $("#memberList").css({ left: left });
         $("#memberList").width(width);
         $("#memberListTable tbody tr td").width(width);
        }

        setMemberListTableSize();

        $(window).resize(function() {
          setMemberListTableSize();
        });
       
       /*end set the memberList position*/

       var matchedIndex = new Array();
       /*make search throgh table of member*/
        $("#member").on('input',  function(event) {

        // Reset the values
        $("#memberId").val('');
        $("#branchId").val('');
        $("#samityId").val('');


        var inputValue = $(this).val().toLowerCase();

        $("#memberList").show('slow/400/fast');

        matchedIndex = [];        

        $("#memberListTable tbody tr td").each(function(index, el) {
          var memberName = $(el).find('.memberName').text().toLowerCase();
          var memberCode = $(el).find('.memberCode').text().toLowerCase();
          var fullText = memberName+' - '+memberCode;
          
          if(memberName.indexOf(inputValue) !== -1 || memberCode.indexOf(inputValue)!== -1 || fullText.indexOf(inputValue) !== -1){
            $(el).show();             
            matchedIndex.push($(el).closest('tr').index());   
          }
          else{
            $(el).hide();
          }

        });
        /* Act on the event */
       });
       /*end make search throgh table of member*/

       $(document).keydown(function(e) {
        
        //Enter key
        if (e.keyCode==13 && matchedIndex.length==1) {
          e.preventDefault();
          $("#memberListTable tbody tr").eq(matchedIndex[0]).find('td').trigger('click');
        }
        
       });


       /*on change memberId get the loans*/
       $("#memberId").change(function(event) {
          console.log('oko got it' + $("#memberId").val());
          $("#rebateAmount").val('');

          var memberId = $(this).val();
          console.log(memberId);

          if (memberId=='' || memberId==null) {
            $("#savingsCode").find("option:gt(0)").remove();
            return false;
          }

          $.ajax({
            url: './getMfnActiveLoanAccountsOfParticularMember',
            type: 'POST',
            dataType: 'json',
            data: {memberId: memberId},
          })
          .done(function(loanAccounts) {
            $("#loanId").find("option:gt(0)").remove();
            $.each(loanAccounts, function(index, loanCode) {
               $("#loanId").append("<option value='"+index+"'>"+loanCode+"</option>");
            });
          })
          .fail(function() {
            alert("error");
          });
          
       });
       
        $("#memberId").change(function(event) {
           console.log('check adjustment');

           // only to check the loan collection adjustment is authorized or not so operation does not matter...
           var memberId = $(this).val();
           
           $.ajax({
             url: './mfnGetRegularLoanAccountsOfParticularMember',
             type: 'POST',
             dataType: 'json',
             data: {memberId: memberId, operation: 'waiver'},
           })
           .done(function(loanAccounts) {
              console.log('check adhustment : ', loanAccounts);
             if (loanAccounts.isAdjustmentAuthorized > 0) {
                $("#loanId").find("option:gt(0)").remove();
                alert('Please authorize the loan collection adjustment at first!')
             }
           })
           .fail(function() {
             alert("error");
           });
       });
       /*end on change memberId get the loans*/

       /*get account balance info on change loan id*/
       $("#loanId").change(function(event) {
            $("#rebateAmount").val('');
           var loanId = $(this).val();

           if (loanId=='' || loanId==null) {
            $("#rebateAmount,#waiverType").val('');
            return false;
           }            

           var rebateDate = $("#rebateDate").val();           

           $.ajax({
            url: './mfnGetLoanInfoForRebate',
            type: 'POST',
            dataType: 'json',
            data: {loanId: loanId},
            async: false,
           })
           .done(function(data) {
                $("#principalAmount").val(data['principalAmount']);
                $("#interestAmount").val(data['interestAmount']);
                $("#outstandingAmount").val(data['outStandingAmount']);
                $("#rebateDate").val(data['rebateDate']);

                $("#rebateAmount").attr('amountLimit',data['interestAmount'].replace(',',''));

                var element = $("#loanInfoTable tbody").find('.Payable');
                element.find('td').eq(1).html(data['payableTotal']);
                element.find('td').eq(2).html(data['payablePricipal']);
                element.find('td').eq(3).html(data['payableInterest']);

                var element = $("#loanInfoTable tbody").find('.Transaction');
                element.find('td').eq(1).html(data['traTotal']);
                element.find('td').eq(2).html(data['traPrincipal']);
                element.find('td').eq(3).html(data['traInterest']);

                var element = $("#loanInfoTable tbody").find('.Outstanding');
                element.find('td').eq(1).html(data['outStandingAmount']);
                element.find('td').eq(2).html(data['principalAmount']);
                element.find('td').eq(3).html(data['interestAmount']);

                var element = $("#loanInfoTable tbody").find('.Installment');
                element.find('td').eq(1).html(data['installmentTotal']);
                element.find('td').eq(2).html(data['installmentPrincipal']);
                element.find('td').eq(3).html(data['installmentInterest']);

                var element = $("#loanInfoTable tbody").find('.Advance');
                element.find('td').eq(1).html(data['advanceTotal']);
                element.find('td').eq(2).html(data['advancePricipal']);
                element.find('td').eq(3).html(data['advanceInterest']);
                
                var element = $("#loanInfoTable tbody").find('.Due');
                element.find('td').eq(1).html(data['dueTotal']);
                element.find('td').eq(2).html(data['duePricipal']);
                element.find('td').eq(3).html(data['dueInterest']);

                var element = $("#loanInfoTable tbody").find('.Rebateable');
                element.find('td').eq(1).html(data['interestAmount']);
                element.find('td').eq(2).html(0);
                element.find('td').eq(3).html(data['interestAmount']);
                
           })
           .fail(function() {
            alert("error");
           });

           $('#waiverType').trigger('change');
           
       });
       /*end get account balance info on change loan id*/


       $(document).mouseup(function(e){
          var container = $("#memberList");
          // if the target of the click isn't the container nor a descendant of the container
          if (!container.is(e.target) && container.has(e.target).length === 0) 
          {
              container.hide('slow/400/fast');
          }
      });


       /*check the amount limit of waiver amount*/
       $("#rebateAmount").on('input', function(event) {
        $(".amountLimit").remove();
         var amountLimit = parseFloat($(this).attr('amountlimit'));
         var inputAmount = 0;
         if (this.value!='') {
          inputAmount = parseFloat(this.value);
         }
         if (inputAmount>amountLimit) {
          this.value = '';
          $(this).after("<p class='amountLimit' style='color:red;'>* Amount can not be greater than the Outstanding Interest Amount.</p>");

          var element = $("#loanInfoTable tbody tr:last");
          element.find('td').eq(1).html('');
          element.find('td').eq(2).html('');
          element.find('td').eq(3).html('');
         }
         else{
          calculatePayableAmountAfterRebate(inputAmount);
         }
         
       });
       /*end check the amount limit of waiver amount*/

       /*calculate payable amount after rebate*/
       function calculatePayableAmountAfterRebate(rebateAmount) {
        var rebateAmount = parseFloat(rebateAmount);
          var principalAmount = 0;
          var interestAmount = 0;
          if ($("#principalAmount").val().replace(',','')!='') {
            var principalAmount = parseFloat($("#principalAmount").val().replace(',',''));            
          }
          if ($("#interestAmount").val().replace(',','')!='') {
            var interestAmount = parseFloat($("#interestAmount").val().replace(',',''));            
          }
          var element = $("#loanInfoTable tbody tr:last");
          element.find('td').eq(1).html(num(principalAmount+interestAmount-rebateAmount));
          element.find('td').eq(2).html(num(principalAmount));
          element.find('td').eq(3).html(num(interestAmount-rebateAmount));
        }
        /*end calculating payable amount after rebate*/

  }); /*End Ready*/
</script>

@endsection