@extends('layouts/microfin_layout')
@section('title', '| Regular Loan Transaction')
@section('content')

<style type="text/css">
    .form-group, .form-control{
        font-size: 11px !important;
        color: black !important;
    }
    .form-control{
        padding: 5px !important;
    }
    #searchButton{
        font-size: 12px;
        margin-top: 20px;
    }
    .not-active {
      pointer-events: none;
      cursor: default;
      text-decoration:none;
      color:black;
  }
</style>

@php
use \App\Http\Controllers\microfin\savings\MfnSavingsDepositTypeController as createForm;
$pageNo = isset($_GET['page']) ? (int) $_GET['page']: 1;
$branchSelected = isset($_GET['filBranch']) ? $_GET['filBranch'] : null;
$samitySelected = isset($_GET['filSamity']) ? $_GET['filSamity'] : null;
$memberCodeSelected = isset($_GET['filMemberCode']) ? $_GET['filMemberCode'] : null;
$loanProductSelected = isset($_GET['filLoanProduct']) ? $_GET['filLoanProduct'] : null;
$dateFromSelected = isset($_GET['filDateFrom']) ? $_GET['filDateFrom'] : null;
$dateToSelected = isset($_GET['filDateTo']) ? $_GET['filDateTo'] : null;

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$moneyRecNoSelected = isset($_GET['filMoneyRecNo']) ? $_GET['filMoneyRecNo'] : null;
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

@endphp

<div class="row">
    <div class="col-md-12">
       <div class="panel panel-default" style="background-color:#708090;">
          <div class="panel-heading" style="padding-bottom:0px">
             <div class="panel-options">
                 <a href="{{ url('importRegularLoanTransaction') }}" class="btn btn-info pull-center addViewBtn">
                     <i class="glyphicon glyphicon-file addIcon"></i>
                     Import Transaction
                 </a>

                {{-- @php dd($userRoleId); @endphp --}}
                @if(in_array($userRoleId, Config('services.branch_level_user_roles')))
                    <a href="{{ url('addMfnRegularLoanTransaction/') }}" class="btn btn-info pull-right addViewBtn">
                    <i class="glyphicon glyphicon-plus-sign addIcon"></i>
                    Add Transaction
                </a>
               @endif
           </div>
           <h1 align="center" style="font-family: Antiqua;letter-spacing: 2px"><font color="white">REGULAR LOAN TRANSACTION LIST</font></h1>
       </div>
       <div class="panel-body panelBodyView">

        <!-- Filtering Start-->
        {!! Form::open(array('url' => 'viewMfnRegularLoanTransaction', 'role' => 'form', 'class'=>'form-horizontal form-groups', 'id' => 'filterFormId', 'method'=>'get')) !!}
        <div class="row">
            <div class="col-md-12">
                @if(!in_array($userRoleId, Config('services.branch_level_user_roles')))
                    <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', [''=>'--All--']+$branchList, $branchSelected ,['id'=>'filBranch','class'=>'form-control input-sm','autocomplete'=>'off']) !!}
                            </div>
                        </div>
                    </div>
                @endif

                <div class="col-md-2">
                  <div class="form-group">
                    <div class="col-md-12">
                      {!! Form::label('', 'Samity:', ['class' => 'control-label pull-left']) !!}
                  </div>
                  <div class="col-md-12">
                      {!! Form::select('filSamity', [''=>'--All--']+$samityList, $samitySelected ,['id'=>'filSamity','class'=>'form-control input-sm','autocomplete'=>'off']) !!}
                  </div>
              </div>
          </div>

          <div class="col-md-2">
              <div class="form-group">
                <div class="col-md-12">
                  {!! Form::label('', 'Member/Loan Code:', ['class' => 'control-label pull-left']) !!}
              </div>
              <div class="col-md-12">
                  {!! Form::text('filMemberCode', $memberCodeSelected ,['id'=>'filMemberCode','class'=>'form-control input-sm','autocomplete'=>'off']) !!}
              </div>
          </div>
      </div>
    {{-- --------//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////--------- --}}
      @if($moneyRecNoType != null)
      <div class="col-md-2">
        <div class="form-group">
            <div class="col-md-12">
                {!! Form::label('', 'Money Receipt No:', ['class' => 'control-label pull-left']) !!}
            </div>
            <div class="col-md-12">
                {!! Form::text('filMoneyRecNo', $moneyRecNoSelected,['id'=>'filMoneyRecNo','class'=>'form-control input-sm','autocomplete'=>'off']) !!}
            </div>
        </div>
      </div>
      @endif
      {{-- --------//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////--------- --}}

      <div class="col-md-1">
        <div class="form-group">
          <div class="col-md-12">
            {!! Form::label('', 'Loan Product:', ['class' => 'control-label pull-left']) !!}
        </div>
        <div class="col-md-12">
            {!! Form::select('filLoanProduct', [''=>'--All--']+$loanProductList, $loanProductSelected ,['id'=>'filLoanProduct','class'=>'form-control input-sm','autocomplete'=>'off']) !!}
        </div>
    </div>
</div>

<div class="col-md-1">
    <div class="form-group">
        <div class="col-md-12">
            {!! Form::label('', 'Date From:', ['class' => 'control-label pull-left']) !!}
        </div>
        <div class="col-md-12">
            {!! Form::text('filDateFrom', $dateFromSelected,['id'=>'filDateFrom','class'=>'form-control input-sm', 'autocomplete'=>'off','readonly','style'=>'cursor:pointer']) !!}
        </div>
    </div>
</div>

<div class="col-md-1">
    <div class="form-group">
        <div class="col-md-12">
            {!! Form::label('', 'Date To:', ['class' => 'control-label pull-left']) !!}
        </div>
        <div class="col-md-12">
            {!! Form::text('filDateTo', $dateToSelected,['id'=>'filDateTo','class'=>'form-control input-sm', 'autocomplete'=>'off','readonly','style'=>'cursor:pointer']) !!}
        </div>
    </div>
</div>

<div class="col-md-1">
    <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-->

@if($transactions->count()>0)
<table class="table table-striped table-bordered" id="areaListView">
    <thead>
       <tr>
        <th rowspan="2">SL#</th>
        <th rowspan="2">Member Name</th>
        <th rowspan="2">Member Code</th>
        <th rowspan="2">Loan Code</th>
        <th rowspan="2">Date</th>
        <th colspan="5">Transaction Amount</th>
        {{-- --------//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////--------- --}}
        @if($moneyRecNoType != null)
        <th rowspan="2">Money Receipt No</th>
        @endif
        {{-- ------------////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////----- --}}
        <th rowspan="2">Mode Of <br> Payment</th>
        <th rowspan="2">Entry By</th>
        <th rowspan="2">Status</th>
        <th rowspan="2">Action</th>
    </tr>
    <tr>
        <th>P</th>
        <th>I</th>
        <th>P+I</th>
        <th>Paid</th>
        <th>Outstanding</th>
    </tr>
</thead>
<tbody>
    @php $sl = 0; @endphp
    @foreach($transactions as $key => $transaction)
        @php
            $paidAmount = $transactions->where('loanIdFk', $transaction->loanIdFk)->where('collectionDate','<=',$transaction->collectionDate)->sum('amount');
            $paidAmount += $openingBalances->where('loanIdFk',$transaction->loanIdFk)->sum('paidLoanAmountOB');
            if ($transaction->paymentType == 'Waiver') {

                $loanWaiverss = DB::table('mfn_loan_waivers')->where('loanIdFk', $transaction->loanIdFk)->where('softDel', 0)->where('date','=',$transaction->collectionDate)->orderBy('date','desc')->get();

                foreach($loanWaiverss as $loanWaiver){

                    if($loanWaiver->date == $transaction->collectionDate){
                        $paidAmountBydate =  DB::table('mfn_loan_collection')->where('loanIdFk', $transaction->loanIdFk)->where('collectionDate','=',$transaction->collectionDate)->where('softDel', 0)->sum('amount');
                        $paidAmount += DB::table('mfn_loan_waivers')->where('loanIdFk', $transaction->loanIdFk)->where('date','=',$transaction->collectionDate)->where('softDel', 0)->sum('amount');
                        $paidAmountWaiver = DB::table('mfn_loan_waivers')->where('loanIdFk', $transaction->loanIdFk)->where('date','=',$transaction->collectionDate)->where('softDel', 0)->sum('amount');
                        $paidAmount = $paidAmount - $paidAmountBydate - $paidAmountWaiver;
                    }

                }

                $outstandingAmount = $transaction->totalRepayAmount - $paidAmount;

            } else if ($transaction->paymentType == 'Write Off') {

                $loanWriteOffs = DB::table('mfn_loan_write_off')->where('loanIdFk', $transaction->loanIdFk)->where('softDel', 0)->where('date','=',$transaction->collectionDate)->orderBy('date','desc')->get();

                foreach($loanWriteOffs as $loanWriteOff){

                    if($loanWriteOff->date == $transaction->collectionDate){
                        $paidAmountBydateWriteOff =  DB::table('mfn_loan_collection')->where('loanIdFk', $transaction->loanIdFk)->where('collectionDate','=',$transaction->collectionDate)->where('softDel', 0)->sum('amount');
                        $paidAmount += DB::table('mfn_loan_write_off')->where('loanIdFk', $transaction->loanIdFk)->where('date','=',$transaction->collectionDate)->where('softDel', 0)->sum('amount');
                        $paidAmountWriteOff = DB::table('mfn_loan_write_off')->where('loanIdFk', $transaction->loanIdFk)->where('date','=',$transaction->collectionDate)->where('softDel', 0)->sum('amount');
                        $paidAmount = $paidAmount - $paidAmountBydateWriteOff - $paidAmountWriteOff;
                    }

                }

                $outstandingAmount = $transaction->totalRepayAmount - $paidAmount;

            } else if ($transaction->paymentType == 'Rebate') {

                    $loanRebates = DB::table('mfn_loan_rebates')->where('loanIdFk', $transaction->loanIdFk)->where('softDel', 0)->where('date','=',$transaction->collectionDate)->orderBy('date','desc')->get();

                    foreach($loanRebates as $loanRebate){

                        if($loanRebate->date == $transaction->collectionDate){
                            $paidAmountBydateRebate =  DB::table('mfn_loan_collection')->where('loanIdFk', $transaction->loanIdFk)->where('collectionDate','=',$transaction->collectionDate)->where('softDel', 0)->sum('amount');
                            $paidAmount += DB::table('mfn_loan_rebates')->where('loanIdFk', $transaction->loanIdFk)->where('date','=',$transaction->collectionDate)->where('softDel', 0)->sum('amount');
                            $paidAmountRebate = DB::table('mfn_loan_rebates')->where('loanIdFk', $transaction->loanIdFk)->where('date','=',$transaction->collectionDate)->where('softDel', 0)->sum('amount');
                            $paidAmount = $paidAmount - $paidAmountBydateRebate - $paidAmountRebate;

                            if(Auth::user()->id == 1){
                                //dd($paidAmount, $paidAmountBydateRebate, $paidAmountRebate, $transaction->loanIdFk, $transaction->collectionDate);
                            }
                        }

                    }

                    $outstandingAmount = $transaction->totalRepayAmount - $paidAmount;

            } else if ($transaction->paymentType == 'Adjustment') {

                    $loanAdjustments = DB::table('mfn_loan_collection')->where('loanIdFk', $transaction->loanIdFk)->where('softDel', 0)->where('collectionDate','=',$transaction->collectionDate)->orderBy('collectionDate','desc')->get();

                    foreach($loanAdjustments as $loanAdjustment){

                        if($loanAdjustment->collectionDate == $transaction->collectionDate){
                            $paidAmounBydateAdjustment =  DB::table('mfn_loan_collection')->where('loanIdFk', $transaction->loanIdFk)->where('collectionDate','=',$transaction->collectionDate)->where('softDel', 0)->sum('amount');
                            $paidAmount += DB::table('mfn_loan_collection')->where('loanIdFk', $transaction->loanIdFk)->where('collectionDate','=',$transaction->collectionDate)->where('softDel', 0)->sum('amount');
                            $paidAmountAdjustment = DB::table('mfn_loan_collection')->where('loanIdFk', $transaction->loanIdFk)->where('collectionDate','=',$transaction->collectionDate)->where('softDel', 0)->sum('amount');
                            $paidAmount = $paidAmount - $paidAmounBydateAdjustment ;
                        }

                    }

                    $outstandingAmount = $transaction->totalRepayAmount - $paidAmount;

            } else if ($transaction->paymentType == 'Cash') {

                    $loanAdjustments = DB::table('mfn_loan_collection')->where('loanIdFk', $transaction->loanIdFk)->where('softDel', 0)->where('paymentType','=','Cash')->where('collectionDate','=',$transaction->collectionDate)->orderBy('collectionDate','desc')->get();

                    foreach($loanAdjustments as $loanAdjustment){

                        if($loanAdjustment->collectionDate == $transaction->collectionDate){
                            $paidAmounBydateAdjustment =  DB::table('mfn_loan_collection')->where('loanIdFk', $transaction->loanIdFk)->where('collectionDate','=',$transaction->collectionDate)->where('softDel', 0)->sum('amount');
                            $paidAmount += DB::table('mfn_loan_collection')->where('loanIdFk', $transaction->loanIdFk)->where('paymentType','=','Cash')->where('collectionDate','=',$transaction->collectionDate)->where('softDel', 0)->sum('amount');
                            $paidAmountAdjustment = DB::table('mfn_loan_collection')->where('loanIdFk', $transaction->loanIdFk)->where('paymentType','=','Cash')->where('collectionDate','=',$transaction->collectionDate)->where('softDel', 0)->sum('amount');
                            $paidAmount = $paidAmount - $paidAmounBydateAdjustment ;
                        }

                    }

                    $outstandingAmount = $transaction->totalRepayAmount - $paidAmount;

            } else {

                $outstandingAmount = $transaction->totalRepayAmount - $paidAmount;
            }
        @endphp
        <tr>
            {{-- <td>{{($pageNo-1)*50+($key+1)}}</td> --}}
            <td>{{$sl+1}}</td>
             <td class="name">{{$transaction->memberName}}</td>
            <td>{{$transaction->memberCode}}</td>
            <td>{{$transaction->loanCode}}</td>
            <td>{{date('d-m-Y',strtotime($transaction->collectionDate))}}</td>
            <td class="amount">{{number_format($transaction->principalAmount,2)}}</td>
            <td class="amount">{{number_format($transaction->interestAmount,2)}}</td>
            <td class="amount">{{number_format($transaction->amount,2)}}</td>
            <td class="amount">{{number_format($paidAmount,2)}}</td>
            <td class="amount">{{number_format($outstandingAmount,2)}}</td>
            {{-- ------------------/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////------------- --}}
            @if($moneyRecNoType != null)
            <td>{{$transaction->moneyReceiptNo ?? null}}{{$transaction->moneyReceiptAutoSerialNo ?? null}}</td>
            @endif
            {{-- ---------------------///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////---------- --}}
            <td>{{$transaction->paymentType}}</td>
            <td class="name">{{$transaction->entryBy}}</td>
            <td>
                @if ($transaction->isAuthorized==1)
                <i style="color:#72A230" class="fa fa-check" aria-hidden="true"></i>
                @else
                <i style="color:#F00" class="fa fa-times" aria-hidden="true"></i>
                @endif
            </td>
            <td>
                @if($transaction->paymentType != 'Waiver' && $transaction->paymentType != 'Rebate' && $transaction->paymentType != 'Write Off')
                <a href="javascript:;" class="showDetails" data-id="{{ $transaction->id }}">
                    <i class="fa fa-eye" aria-hidden="true"></i>
                </a>

                {{-- --------------//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////----------------- --}}
                @if($isMoneyReceiptPrintAllow == 1)
                <a href="{!! url('mfn/collection/printMoneyReceipt/'.$transaction->id)!!}">
                <i class="fa fa-print" aria-hidden="true"></i>
                </a>
                @endif
                {{-- -------------------////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////------------ --}}

                @php
                // if this loan follows reducing method then only last transaction can be edited.
                $sl++;
                @endphp

                @if($transaction->paymentType != 'Adjustment')

                    @if($transaction->canDeleteOrEdit==1)
                    <a href="javascript:;" class="showUpdateForm @if(!$transaction->canDeleteOrEdit){{'not-active'}}@endif" data-id="{{ $transaction->id }}" >
                        <i class="fa fa-pencil-square-o fa-lg" aria-hidden="true"></i>
                    </a>
                    <a href="javascript:;" class="deleteConfirmation @if(!$transaction->canDeleteOrEdit){{'not-active'}}@endif" data-id="{{ $transaction->id }}" >
                        <i class="fa fa-trash-o fa-lg" aria-hidden="true"></i>
                    </a>
                    @endif
                @endif
                @else
                    <p>Not Applicable</p>
                @endif
            </td>
        </tr>
    @endforeach
</tbody>
</table>
@endif

{{-- @if (!isset($_GET['filDateFrom'])) --}}
<div class="pull-right">
    {{-- {{ $transactions->appends(request()->input())->links() }} --}}
</div>
{{-- @endif --}}
</div>
</div>
</div>

</div>

{{-- View Modal --}}
<div class="modal fade" id="show-details-modal">
  <div class="modal-dialog" style="width:750px">
    <div class="modal-content">
      <div class="panel panel-color panel-black">
        <div class="panel-heading">
          <h4 class="panel-title">Collection Details</h4>
          <div class="panel-options">
            <a class="close" href="#" data-dismiss="modal">X</a>
        </div>
    </div>
    <div style="padding:0" class="panel-body">
      <div class="table-responsive" style="border:none!important;margin:0">
        <table id="detailsModalTable" cellspacing="0" cellpadding="0" class="table table-small-font table-striped samity-details-table-wrapper" style="color: black;">
          <tbody>

          </tbody>
      </table>


  </div>
</div>
</div>
</div>
</div>
</div>
{{-- End View Modal --}}

{{-- Edit Modal --}}
<div class="modal fade" id="show-update-modal">
  <div class="modal-dialog" style="width:1050px">
    {!! Form::open(array('url' => '', 'role' => 'form', 'class' => 'form-horizontal form-groups','id'=>'updateForm')) !!}
    <div class="modal-heading" style="background-color:#000;color:#FFF;padding:10px 15px!important;">
        <h4 class="modal-title">Collection Update</h4>
        <div class="panel-options">
          <a class="close" href="#" data-dismiss="modal">X</a>
      </div>
  </div>
  <div class="modal-content">
    <div class="modal-body">
      <div class="row">

          <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('collectionId',null,['id'=>'collectionId']) !!}
                        {!! Form::hidden('memberId',null,['id'=>'memberId']) !!}

                        {!! createForm::text('member','','Member:',['id'=>'member','autocomplete'=>'off','readonly'=>'readonly']) !!}
                        {!! createForm::text('loanCode','','Loan Code:',['id'=>'loanCode','autocomplete'=>'off','readonly'=>'readonly']) !!}
                        <input type="hidden", name="loanId", id="loanId" value="">

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

                        {!! createForm::select('paymentType',['Cash'=>'Cash','Bank'=>'Bank'],null,'Payment Type:',['id'=>'paymentType','autocomplete'=>'off']) !!}

                        <div class="bankDiv">
                            <div class="form-group">
                              {!! Form::label('bank', 'Bank:', ['class' => 'col-sm-4 control-label']) !!}
                              <div class="col-sm-8">
                               <select id="bank" name="bank" class="form-control">
                                 <option value="">Select</option>
                                 @foreach ($bankList as $bank)
                                 <option value="{{$bank->id}}">{{$bank->name.' ['.$bank->code.']'}}</option>
                                 @endforeach
                             </select>
                         </div>
                     </div>

                     {!! createForm::text('chequeNumber','','Cheque Number:',['id'=>'chequeNumber','autocomplete'=>'off']) !!}
                 </div>

                 {!! createForm::text('amount','','Amount:',['id'=>'amount','autocomplete'=>'off']) !!}

                {{-- -------------------////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////------------ --}}
                @if($moneyRecNoType == 'manual')
                {!! createForm::text('moneyRecNo','','Money Receipt No:',['id'=>'moneyRecNo','autocomplete'=>'off']) !!}
                @endif
                {{-- -----------------//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////-------------- --}}




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

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

                {!! createForm::text('due','','Due:',['id'=>'due','autocomplete'=>'off','readonly'=>'readonly']) !!}

                {!! createForm::text('advance','','Advance:',['id'=>'advance','autocomplete'=>'off','readonly'=>'readonly']) !!}

                {!! createForm::text('outStanding','','Out Standing:',['id'=>'outStanding','autocomplete'=>'off','readonly'=>'readonly']) !!}

                {!! createForm::text('installmentNo','','Installment No:',['id'=>'installmentNo','autocomplete'=>'off','readonly'=>'readonly']) !!}


            </div>
            {{-- End Second Coloum --}}

        </div>

    </div>
</div>
</div>

</div>

</div>
</div>
</div>
<div class="modal-footer" style="background-color:#FFF;color:#FFF;">
    {{-- <button id="submitButton" type="submit" class="btn btn-info animated slideInRight" style="margin-bottom:0!important;">Save</button> --}}

    {{-- ----------------------------------------------//////////////////////////////////////////////////////------------------------------------------------------------------ --}}
    <button type="submit" id="submit" class="btn btn-info animated slideInRight" style="margin-bottom:0!important;">Save</button>
    @if($isMoneyReceiptPrintAllow == 1)
    <button type="submit" id="submitAndPrint" class="btn btn-info animated slideInRight" style="margin-bottom:0!important;">Save & Print</button>
    @endif
    {{-- --------------------------------------------------/////////////////////////////////////////////////////--------------------------------------------------------------- --}}


    <button type="button" class="btn btn-white animated slideInRight" data-dismiss="modal" style="margin-bottom:0!important;">Close</button>
</div>
{!! Form::close() !!}
</div>
</div>
{{-- End Edit Modal --}}

{{-- Delete Modal --}}
<div class="modal fade" id="delete-confirmation-modal">
  <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 item?
    </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;" >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 --}}


<style type="text/css">

    #areaListView thead tr th{
        padding: 2px;
    }

    #detailsModalTable tbody tr td{
       width: 25%;
       text-align: left;
       padding-left: 5px;
   }

   .modal {
      text-align: center;
      padding: 0!important;
  }

  .modal:before {
      content: '';
      display: inline-block;
      height: 100%;
      vertical-align: middle;
      margin-right: -4px; /* Adjusts for spacing */
  }

  .modal-dialog {

      display: inline-block;
      text-align: left;
      vertical-align: middle;
  }


  .cbr-replaced {
    top: 8px!important;
}
table.samity-details-table-wrapper tbody tr td {
   padding: 0;
   border-bottom: none !important;
   /*vertical-align: top !important;*/
}
table.samity-details-table tbody tr td {
   text-align: left;
   padding: 3px 5px !important;
   font-size: 11px;
   border-bottom: 1px solid #EEE!important;
}
table.TTitleFirstTable tbody tr:last-child td,
table.TValueFirstTable tbody tr:last-child td,
table.TTitleSecondTable tbody tr:last-child td,
table.TValueSecondTable tbody tr:last-child td {
   border-bottom: none !important;
}
table.samity-details-table tbody tr th {
   text-align: left;
   padding: 3px 5px;
   font-weight: normal;
   font-size:11px;
}
table.samity-details-table-wrapper tr:nth-child(odd),
table.samity-details-table tr:nth-child(odd),
table#TTitleFirst tr:nth-child(odd),
table#TValueFirst tr:nth-child(odd),
table#TTitleSecond tr:nth-child(odd),
table#TValueSecond tr:nth-child(odd) {
   background-color: #f9f9f9 !important;
}
table.samity-details-table-wrapper tbody tr:nth-child(even):hover td,
table.samity-details-table tbody tr:nth-child(even):hover td
table#TTitleFirst tbody tr:nth-child(even):hover td,
table#TValueFirst tbody tr:nth-child(even):hover td,
table#TTitleSecond tbody tr:nth-child(even):hover td,
table#TValueSecond tbody tr:nth-child(even):hover td {
   background-color:#FFF !important;
}
table tbody tr td.name{
   text-align: left;
   padding-left: 5px;
}
</style>



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

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

     /*View Modal*/
     $(document).on('click', '.showDetails', function(event) {

         $.ajax({
            url: './mfnGetLoanCollectionDetails',
            type: 'POST',
            dataType: 'json',
            data: {
               '_token': "{{ csrf_token() }}",
               'id': $(this).data('id')
           },
       })
         .done(function(data) {
            $("#detailsModalTable tbody").empty();
            var markup = "";
            console.log(data);

            $.each(data.tFirst, function(index, value) {
                markup = markup + "<tr>"+
                "<td>"+index+"</td>"+
                "<td>"+value+"</td>"+
                "<td></td>"+
                "<td></td>"+
                "</tr>";
            });
            $("#detailsModalTable tbody").append(markup);

            var i = 0;
            $.each(data.tSecond, function(index, value) {
                $("#detailsModalTable tbody tr").eq(i).find('td:nth-child(3)').html(index);
                $("#detailsModalTable tbody tr").eq(i).find('td:nth-child(4)').html(value);
                i++;
            });


            jQuery('#show-details-modal').modal('show', {backdrop: 'fade'});
        })
         .fail(function() {
            alert("error");
        })

     });
     /*End View MOdal*/

     /*Edit Modal*/
     $(document).on('click', '.showUpdateForm', function() {
         $("#collectionId").val($(this).data('id'));
         $.ajax({
            url: './mfnGetLoanCollectionDetailsToUpdate',
            type: 'POST',
            dataType: 'json',
            data: {
               _token: "{{csrf_token()}}",
               id : $(this).data('id')
           },
       })
         .done(function(data) {

            $("#memberId").val(data['collection'].memberIdFk);
            $("#member").val(data['tFirst']['Member Name:'] + '-' + data['tFirst']['Member Code:']);
            $("#loanCode").val(data['tFirst']['Loan Code:']);
            $("#loanId").val(data['tFirst']['Loan Id:']);
            console.log(data['tFirst']['Loan Id:']);

            $("#transactionDate").val(data['tFirst']['Date:']);
            $("#transactionDate").datepicker('option','minDate',new Date(data['lastInstallmentDate']));
            $("#amount").val(data['collection'].amount);
            $("#amount").attr('initialAmount',data['collection'].amount);

            ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
            $("#moneyRecNo").val((data['collection'].moneyReceiptNo !== null ? data['collection'].moneyReceiptNo : '') + (data['collection'].moneyReceiptAutoSerialNo !== null ? data['collection'].moneyReceiptAutoSerialNo : ''));
            //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

            $("#paymentType").val(data['collection'].paymentType).trigger('change');
            $("#bank").val(data['collection'].ledgerIdFk);
            $("#chequeNumber").val(data['collection'].chequeNumber);


            $("#due").val(data['dueAmount']);
            $("#due").attr('initialDue',data['dueAmount']);

            $("#advance").val(data['advanceAmount']);
            $("#advance").attr('initialAdvance',data['advanceAmount']);

            $("#outStanding").val(data['outstandingAmount']);
            $("#outStanding").attr('initialOutStanding',data['outstandingAmount']);

            $("#installmentNo").val(data['collection'].installmentNo);

            jQuery('#show-update-modal').modal('show', {backdrop: 'static'});
        })
         .fail(function() {
            console.log("error");
        })


     });
     /*End Edit Modal*/

    ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
     /*Update Information*/
     $('#updateForm').submit(function(event){
        event.preventDefault();
            //alert($('form').serialize());

            var clickedButton = $(document.activeElement).attr('id');
			$("#submit, #submitAndPrint").prop('disabled', true);
            $('#loanId').removeAttr('disabled');
            $.ajax({
                type: 'post',
                url: './updateRegularLoanTransaction',
                data: $('#updateForm').serialize(),
                dataType: 'json',
                success: function(_response) {

                	//alert(JSON.stringify(_response));
                	$(".error").remove();
                    if(_response.errors) {
                    	$.each(_response.errors, function(name, error) {
                         $("#"+name).after("<p class='error' style='color:red;'>* "+_response.errors[name]+"</p>");
                     });
                    }
                    else {

                        if (_response.responseTitle=='Warning!') {
							$("#submit, #submitAndPrint").prop('disabled', false);
							toastr.warning(_response.responseText, _response.responseTitle, opts);
						}else{
							$("#submit, #submitAndPrint").prop('disabled', false);
							toastr.success(_response.responseText, _response.responseTitle, opts);

							setTimeout(function() {
								if(clickedButton == "submitAndPrint"){
									window.location.href = '{{ url("mfn/collection/printMoneyReceipt/") }}/' + _response.transactionId;
								}else{
									location.reload();
								}
							}, 2000);

						}
                    }
                },
                error: function(_response) {
                    alert("error");
                }
            });

        });/*form*/
     /*End Update Information*/
    ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////



		/*$("#transactionDate").datepicker({
            changeMonth: true,
            changeYear: true,
            yearRange : "c-10:c+10",
            maxDate: "dateToday",
            dateFormat: 'dd-mm-yy',
            onSelect: function(){
            	$(this).closest('div').find('.error').remove();
            }
        });*/




        /*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*/

        /*payment mode*/
        $("#paymentType").change(function(event) {

            if ($(this).val()=="Cash") {
              $(".bankDiv").hide('slow/400/fast');
          }
          else{
              $(".bankDiv").show('slow/400/fast');
          }
      });
        /*end payment mode*/




        /*Delete Modal*/
        $(document).on('click', '.deleteConfirmation', function() {
         $('#id').val($(this).data('id'));
         jQuery('#delete-confirmation-modal').modal('show', {backdrop: 'fade'});
     });
        /*End Delete Modal*/

        /*Delete Product*/
        $("#yesBtn").click(function(event) {
        	$.ajax({
        		url: './deleteRegularLoanTransaction',
        		type: 'POST',
        		dataType: 'json',
        		data: {
        			_token: "{{csrf_token()}}",
        			id: $('#id').val()
        		},
        	})
        	.done(function(data) {
                if (data.responseTitle=='Warning!') {
					toastr.warning(data.responseText, data.responseTitle, opts);
				}else{
                    toastr.success(data.responseText, data.responseTitle, opts);
                    setTimeout(function(){
                        location.reload();
                    }, 3000);
                }
           })
        	.fail(function() {
        		alert("error");
        	})


        });
        /*End Delete Product*/

        /*on change memberId get the loans*/
       /*$("#memberId").change(function(event) {
          var memberId = $(this).val();
          var csrf = "{{csrf_token()}}";

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

          $.ajax({
            url: './mfnGetRegularLoanAccountsOfParticularMember',
            type: 'POST',
            dataType: 'json',
            async: false,
            data: {memberId: memberId, _token: csrf},
          })
          .done(function(loanAccounts) {
            $("#loanId").find("option:gt(0)").remove();
            $.each(loanAccounts, function(index, loanAccount) {
               $("#loanId").append("<option value='"+loanAccount.id+"'>"+loanAccount.loanCode+"</option>");
            });
          })
          .fail(function() {
            alert("error");
          });

      });*/
      /*end on change memberId get the loans*/

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

           if (loanId=='' || loanId==null) {
            $("#due,#advance,#outStanding").val('');
            return false;
           }


           $.ajax({
            url: './mfnGetLoanInfoToUpdate',
            type: 'POST',
            dataType: 'json',
            data: {loanId: loanId, transactionDate: transactionDate, _token: csrf},
           })
           .done(function(data) {
                $("#due").val(num(data['dueAmount']));
                $("#advance").val(num(data['advanceAmount']));
                $("#outStanding").val(num(data['outStandingAmount']));
           })
           .fail(function() {
            alert("error");
           });

       });*/
       /*end get account balance info on change loan id*/

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


         var outStandingAmount = parseFloat($("#outStanding").attr('initialOutStanding')) + parseFloat($(this).attr('initialAmount'));

         if (this.value>outStandingAmount) {
          this.value = 0;
          alert("Amount can't be greater than Outstanding Amount.");
      }

      var initialAmount = parseFloat($(this).attr('initialAmount'));
      var currentAmount = 0;
      if (this.value!='') {
        currentAmount = parseFloat(this.value);
    }

    var dueAmount = parseFloat($("#due").attr('initialDue'));
    var advanceAmount = parseFloat($("#advance").attr('initialAdvance'));
    var outStandingAmount = parseFloat($("#outStanding").attr('initialOutStanding'));

    if (currentAmount==initialAmount) {
        $("#due").val(dueAmount);
        $("#advance").val(advanceAmount);
        $("#outStanding").val(outStandingAmount);
        return false;
    }


    var dueAdjust = 0;
    var addDue = 0;
    var advanceAdjust = 0;
    var addAdvance = 0;
    if (currentAmount>initialAmount) {

        $("#due").val(dueAmount);
        $("#advance").val(advanceAmount);
        $("#outStanding").val(outStandingAmount);

        if (dueAmount>0) {
            dueAdjust = currentAmount - initialAmount;
            dueAdjust = dueAdjust>dueAmount ? dueAmount:dueAdjust;
            $("#due").val(dueAmount - dueAdjust);
        }
        if ( (currentAmount - initialAmount) > dueAdjust) {
            addAdvance = currentAmount - initialAmount - dueAdjust;
            $("#advance").val(advanceAmount+addAdvance);
        }
        $("#outStanding").val(outStandingAmount - currentAmount + initialAmount);
    }

    else{
        $("#due").val(dueAmount);
        $("#advance").val(advanceAmount);
        $("#outStanding").val(outStandingAmount);
            // when currentAmount < initialAmount
            if (advanceAmount>0) {
                advanceAdjust = initialAmount - currentAmount;
                advanceAdjust = advanceAdjust>advanceAmount ? advanceAmount:advanceAdjust;
                $("#advance").val(advanceAmount-advanceAdjust);
            }
            if (initialAmount-currentAmount > advanceAdjust) {
                addDue = initialAmount-currentAmount - advanceAdjust;
                $("#due").val(dueAmount+addDue);
            }
            $("#outStanding").val(outStandingAmount + initialAmount - currentAmount);
        }



    });

       /*payment mode*/
       $("#paymentMode").change(function(event) {

       	if ($(this).val()=="Cash") {
       		$(".bankDiv").hide('slow/400/fast');
       	}
       	else{
       		$(".bankDiv").show('slow/400/fast');
       	}
       });
       /*end payment mode*/




       $('#filDateFrom').datepicker({
        dateFormat: 'dd-mm-yy',
        changeYear: true,
        changeMonth: true,
        onSelect: function(){
            thisDate = $("#filDateFrom").datepicker('getDate');
            $('#filDateTo').datepicker('option','minDate',thisDate);
        }
    });

       $('#filDateTo').datepicker({
        dateFormat: 'dd-mm-yy',
        changeYear: true,
        changeMonth: true,
        onSelect: function(){
            thisDate = $("#filDateTo").datepicker('getDate');
            $('#filDateFrom').datepicker('option','maxDate',thisDate);
        }
    });

       $('#filDateFrom,#filDateTo').click(function(event) {
           this.value = '';
       });

       /*on change branch get the samity list*/
       $("#filBranch").change(function(event) {
        var branchId = $(this).val();
        $.ajax({
          url: './getMfnBranchWiseSamityList',
          type: 'POST',
          dataType: 'json',
          data: {branchId: branchId},
      })
        .done(function(samityList) {
          $("#filSamity option:gt(0)").remove();
          $.each(samityList, function(index, val) {
           $("#filSamity").append("<option value='"+index+"'>"+val+"</option>");
       });
      })
        .fail(function() {
          alert("error");
      });

    });
       /*end on change branch get the samity list*/


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

@endsection