@extends('layouts/microfin_layout')
@section('title', '| Loan Collection Adjustment')
@section('content')

<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('mfn/addMfnLoanAdjustment/') }}" class="btn btn-info pull-right addViewBtn">
                      <i class="glyphicon glyphicon-plus-sign addIcon"></i>
                      Add New Adjustment
                    </a>
                </div>

                {!! Form::open(array('name' => 'searchForm', 'class' => 'searchForm', 'url' => /*'#'*/'mfn/viewLoanCollectionAdjustment/', 'method' => 'GET')) !!}
                <div class="row">
                    @if(Auth::user()->branchId==1 || count($branchIdArray)>1)
                    <div class="col-xs-1">
                        {!! Form::label('branch', 'Branch:', ['class' => 'control-label']) !!} <br/>
                        {!! Form::select('branchId', array('' => 'Select') + $branchList, null, array('class'=>'form-control', 'id' => 'branchId')) !!}
                        <p id="branchRequired" style="font-size: 9px !important; color: #b01004 !important;"></p>
                    </div>
                    @endif
                    <div class="col-xs-2">
                        {!! Form::label('samity', 'Samity:', ['class' => 'control-label']) !!} <br/>
                        {!! Form::select('samityId', array('' => 'Select') + $samity, null, array('class'=>'form-control', 'id' => 'samityId')) !!}
                        <p id="samityRequired" style="font-size: 9px !important; color: #b01004 !important;"></p>
                    </div>

                    <div class="col-xs-2">
                        {!! Form::label('status', 'Status:', ['class' => 'control-label']) !!} <br/>
                        {!! Form::select('status', array('' => 'All', 'False' => 'Pending', 'True' => 'Approved'), null, array('class'=>'form-control', 'id' => 'status')) !!}                        
                    </div>

                    <div class="col-xs-2">
                        {!! Form::label('loan code', 'Mamer Code:', ['class' => 'control-label']) !!} <br/>
                        {!! Form::text('memberCode', $value = null, ['class' => 'form-control', 'id' => 'memberCode', 'type' => 'text']) !!}
                    </div>
                    
                    <div class="col-xs-1">
                        {!! Form::label('date from', 'Date From:', ['class' => 'control-label']) !!} <br/>
                        {!! Form::text('dateFrom',  request()->all('dateFrom')['dateFrom'] ?? '', ['class' => 'form-control datepicker', 'id' => 'dateFrom', 'type' => 'text', 'readonly' => 'readonly']) !!}
                    </div>
                    <div class="col-xs-1">
                        {!! Form::label('date to', 'Date To:', ['class' => 'control-label']) !!} <br/>
                        {!! Form::text('dateTo', request()->all('dateTo')['dateTo'] ?? '', ['class' => 'form-control datepicker', 'id' => 'dateTo', 'type' => 'text', 'readonly' => 'readonly']) !!}
                    </div>

                    <div class="col-xs-1">
                        {!! Form::label('', '', ['class' => 'control-label']) !!} <br/>
                        {!! Form::submit('Search', ['id' => 'submit', 'class' => 'btn btn-search', 'style' => 'float:right;color:white']) !!}
                    </div>
                </div>
                {!! Form::close() !!}

                <h1 align="center" style="font-family: Antiqua;letter-spacing: 2px"><font color="white">Loan & Saving Adjustment List</font></h1>
            </div>

            <div id="dialog_approve" title="Message" style="display: none !important;">
                <p>Approved Successfully</p>
            </div>
            <div id="dialog_delete" title="Message" style="display: none !important;">
                <p>Deleted Successfully</p>
            </div>

            <div class="row">
                <div class="col-md-12">
                    <table class="table table-striped table-bordered">
                        <tr style="background-color: #696969!important; text-transform: uppercase;">
                            <th rowspan="2">#SL</th>
                            <th rowspan="2">Date</th>
                            <th rowspan="2">Branch</th>
                            <th rowspan="1" colspan="2">Member Information</th>
                            <th rowspan="1" colspan="2">Adjustment Information</th>
                            <th rowspan="2">Adjusted Amount</th>
                            <th rowspan="2">Present Due</th>
                            <th rowspan="2">Entry By</th>
                            <th rowspan="2">Authorized By</th>
                            <th rowspan="2">Status</th>
                            <th rowspan="2">Action</th>
                        </tr>
                        <tr style="background-color: #696969!important; text-transform: uppercase;">
                            <th rowspan="1">Member Code</th>
                            <th rowspan="1">Member Name</th>
                            <th rowspan="1">Loan Code</th>
                            <th rowspan="1">Savings Account</th>
                        </tr>

                        @php
                            // $sl = 0;
                            $sl = ($getAdjustmentData->currentPage() - 1) * $getAdjustmentData->perPage() + 1;
                        @endphp

                        <tbody style="color: black">
                            @if(sizeof($getAdjustmentData) > 0)

                            @foreach($getAdjustmentData as $getAdjustmentValue)
                            <tr>
                                <td>{{$sl++}}</td>
                                {{-- <td>{{$loop->iteration}}</td> --}}
                                @php
                                $date = date_create($getAdjustmentValue->adjusted_at);
                                $date = date_format($date, 'd-m-Y');
                                @endphp
                                <td>{{$date}}</td>
                                <td>{{$getAdjustmentValue->branch_name}}</td>
                                <td>{{$getAdjustmentValue->member_code}}</td>
                                <td>{{$getAdjustmentValue->member_name}}</td>
                                <td>{{$getAdjustmentValue->loan_code}}</td>
                                <td>
                                    @php
                                        $adjustedSavingsInfo = json_decode($getAdjustmentValue->adjusted_savings_account);
                                    @endphp

                                    @foreach($adjustedSavingsInfo as $adjustedSavingsValue)
                                    @php
                                        $savingsAccountCode = DB::table('mfn_savings_account')->where('id', $adjustedSavingsValue->id)->value('savingsCode');
                                    @endphp
                                    {{$savingsAccountCode}}
                                    @endforeach
                                </td>
                                <td style="text-align: right;">{{number_format($getAdjustmentValue->adjusted_amount, 2)}}</td>
                                
                                <td style="text-align: right;">{{number_format($getAdjustmentValue->present_due, 2)}}</td>
                                
                                @php
                                    $checkAuthorize = 0;
                                    $employeeName   = '';
                                    $authorizePersonName = '';
                                    
                                    if ($getAdjustmentValue->user_id != 1) {
                                        $employeeName = DB::table('users')
                                        ->join('hr_emp_general_info', 'users.emp_id_fk', '=', 'hr_emp_general_info.id')
                                        ->where('users.id', $getAdjustmentValue->user_id)
                                        ->value('hr_emp_general_info.emp_name_english');
                                    }
                                    else {
                                        $employeeName = $getAdjustmentValue->entry_by;
                                    }
                                    
                                @endphp
                                
                                <td>{{$employeeName}}</td>
                                
                                @if (sizeof($authorizedPersonsUserIds) > 0)
                                    @foreach ($authorizedPersonsUserIds as $key => $authorizedPersonsValue)
                                        @if ($key == $getAdjustmentValue->authorized_by)
                                        
                                        @php
                                        if ($getAdjustmentValue->authorized_by != 1) {
                                            $authorizePersonName = DB::table('users')
                                            ->join('hr_emp_general_info', 'users.emp_id_fk', '=', 'hr_emp_general_info.id')
                                            ->where('users.id', $authorizedPersonsValue)
                                            ->value('hr_emp_general_info.emp_name_english');
                                        }
                                        else {
                                            $authorizePersonName = 'superadmin';
                                        }
                                        @endphp
                                        
                                        <td>{{ $authorizePersonName }}</td>
                                        
                                        @php
                                        ++$checkAuthorize;
                                        @endphp
                                        
                                        @endif
                                    @endforeach
                                    @if ($checkAuthorize == 0)
                                        <td></td>
                                        @php
                                        $checkAuthorize = 0;
                                        @endphp
                                    @endif
                                @else
                                <td></td>
                                @endif

                                <td>
                                    @if($getAdjustmentValue->is_authorized == 'False') 
                                    <i class="fas fa-times" style="color: red !important;"></i> 
                                    @else 
                                    <i class="fas fa-check" style="color: green !important;"></i> 
                                    @endif
                                </td>

                                <td>
                                    @if($getAdjustmentValue->is_authorized == 'False')
                                        @if ($isApprovalAllowed == true)
                                            <i class="fa fa-check-square-o" aria-hidden="true" style="color: green !important; cursor: pointer !important;" data-id="{{$getAdjustmentValue->id}}" id="approval" title="Approve"></i>
                                        @elseif (Auth::user()->id == 1)
                                            <i class="fa fa-check-square-o" aria-hidden="true" style="color: green !important; cursor: pointer !important;" data-id="{{$getAdjustmentValue->id}}" id="approval" title="Approve"></i>
                                        @endif

                                        @php
                                            $url = 'mfn/editMfnLoanAdjustment/'.$getAdjustmentValue->id;
                                        @endphp

                                        <a href="{{ url($url) }}">
                                            <i class="fas fa-edit" aria-hidden="true" style="color: blue !important; cursor: pointer !important;"  title="Edit"></i>
                                        </a>
                                    @endif
                                    
                                    @if (Auth::user()->branchId == 1)
                                        <i class="fa fa-trash" aria-hidden="true" style="color: red !important; cursor: pointer !important;" data-id="{{$getAdjustmentValue->id}}" id="deleteAdjustment"></i>
                                    @endif
                                </td>
                            </tr>
                            @endforeach

                            @endif
                        </tbody>
                    </table>
                    {{ $getAdjustmentData->appends(request()->input())->render() }}
                </div>
            </div>
            
        </div>
    </div>
  
</div>

<script>
    $(document).ready(function() {
        
        $(".datepicker").datepicker({
            changeMonth: true,
            changeYear: true,
            dateFormat: 'dd-mm-yy',
            yearRange: '2010:2022',
        });
        
        $(document).on('click', '#approval', function() {
            console.log('approval : ', $(this).attr("data-id"));

            if (confirm('Are you sure to approve this transaction?')) {
                $.ajax({
                    type: 'post',
                    url: './reqLoanAdjustmentApproval',
                    dataType: 'json',
                    data: {
                    'id': $(this).attr("data-id"),
                    },
                    success: function(_response) {
                         if (_response == false) {
                                alert('Something went wrong');
                            } else if (_response.responseTitle == 'Warning!') {
                                toastr.warning(_response.responseText, _response
                                    .responseTitle, opts);
                            } else {
                                $(function() {
                                    $("#dialog_approve").dialog();
                                });

                            setTimeout(function() {
                                $( "#dialog_approve" ).dialog( "close" )
                                window.location.href = '{{ url('mfn/viewLoanCollectionAdjustment/') }}';
                            }, 3000);
                        }
                    },
                    error: function(_response) {
                        alert(_response.errors);
                    }
                });
            }
            
        });

        // $(document).on('click', '#edit', function() {
        //     console.log('edit');
        //     $.ajax({
        //         type: 'get',
        //         url: './editMfnLoanAdjustment',
        //         dataType: 'json',
        //         data: {
        //         'id': $(this).attr("data-id"),
        //         },
        //         success: function(_response) {
        //             console.log('Success')
                    
        //         },
        //         error: function(_response) {
        //             alert('Something went wrong !');
        //         }
        //     });
        // });

        // $(document).on('click', '#deleteAdjustment', function() {
        //     if (confirm('Are you sure to delete this transaction?')) {
        //         $.ajax({
        //             type: 'post',
        //             url: './reqLoanAdjustmentDelete',
        //             dataType: 'json',
        //             data: {
        //             'id': $(this).attr("data-id"),
        //             },
        //             success: function(_response) {
        //                 console.log('Success')
        //                 if(_response == false) {
        //                     alert('Something went wrong');
        //                 } else {
        //                     $(function() {
        //                         $( "#dialog_delete" ).dialog();
        //                     });

        //                     setTimeout(function() {
        //                         $( "#dialog_delete" ).dialog( "close" );
        //                         window.location.href = '{{ url('mfn/viewLoanCollectionAdjustment/') }}';
        //                     }, 3000);
        //                 }
        //             },
        //             error: function(_response) {
        //                 alert(_response.errors);
        //             }
        //         });
        //     }
        // });
        
         $(document).on('click', '#deleteAdjustment', function() {
            if (confirm('Are you sure to delete this transaction?')) {
                $.ajax({
                    type: 'post',
                    url: './reqLoanAdjustmentDelete',
                    dataType: 'json',
                    data: {
                    'id': $(this).attr("data-id"),
                    },
                    success: function(_response) {
                        if(_response == false) {
                            alert('Something went wrong');
                        } else {

                            if (_response.responseTitle=='Warning!') {
                                toastr.warning(_response.responseText, _response.responseTitle, opts);
                            }else{

                                $(function() {
                                    $( "#dialog_delete" ).dialog();
                                });

                                toastr.success(_response.responseText, _response.responseTitle, opts);
                                setTimeout(function() {
                                    $( "#dialog_delete" ).dialog( "close" );
                                    window.location.href = '{{ url('mfn/viewLoanCollectionAdjustment/') }}';
                                }, 3000);
                            }
                        }
                    },
                    error: function(_response) {
                        alert(_response.errors);
                    }
                });
            }
        });


        $(document).on('change', '#branchId', function() {

            $.ajax({
                type: 'post',
                url: './reqSamityAccordingToBranch',
                dataType: 'json',
                data: {
                'branchId': $('#branchId').val(),
                },
                success: function(_response) {
                    console.log('Success')
                    if(_response.errors) {
                        alert(_response.errors);
                    } else {
                        $('#samityId').empty();
                        $('#samityId').append('<option value="" selected="selected">Select</option>');

                        $.each(_response.samity, function(index, value) {
                            console.log(value)
                        $('#samityId').append('<option value="'+ index +'">' + value + '</option>');
                        });

                        // $('#primaryProductId').empty();
                        // $('#primaryProductId').append('<option value="" selected="selected">Select</option>');

                        // $.each(_response.primaryProduct, function(index, value) {
                        // $('#primaryProductId').append('<option value="'+ index +'">' + value + '</option>');
                        // });
                    }
                },
                error: function(_response) {
                    alert(_response.errors);
                }
            });
        });
        
        $(document).on('keyup', '#memberCode', function() {
            console.log('got it', $('#memberCode').val());
            console.log('got it 2 : ', $('#branchId').val());

            if ( $('#branchId').val() != '' && $('#samityId').val() != '') {
              document.getElementById('branchRequired').innerHTML = '';
              document.getElementById('samityRequired').innerHTML = '';
              $.ajax({
                  type: 'post',
                  url: './reqMemberAccordingToSamity',
                  dataType: 'json',
                  data: {
                  'branchId': $('#branchId').val(),
                  'samityId': $('#samityId').val(),
                  'memberValue': $('#memberCode').val(),
                  },
                  success: function(_response) {
                      console.log('Success')
                      if(_response.errors) {
                          alert(_response.errors);
                      } else {

                          console.log(_response);

                          var _result = Object.keys(_response).map(function(key) {
                              return _response[key];
                          });

                          console.log(_result);

                          $( "#memberCode" ).autocomplete({
                              source: _result,
                              minLength:2
                          });
                      }
                  },
                  error: function(_response) {
                      alert(_response.errors);
                  }
              });
            }
            else {
              document.getElementById('branchRequired').innerHTML = '*Branch is required';
              document.getElementById('samityRequired').innerHTML = '*Samity is required';
            }

        });

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

@endsection