@extends('layouts/acc_layout')
@section('title', '| Loan Register Report')
@section('content')


@php
    use Carbon\Carbon;
    $projectSelected = isset($_GET['searchProject']) ? $_GET['searchProject'] : null;
    $projectTypeSelected = isset($_GET['searchProjectType']) ? $_GET['searchProjectType'] : null;
    $branchSelected = isset($_GET['searchBranch']) ? $_GET['searchBranch'] : null;
    //$fdrTypeSelected = isset($_GET['searchFdrType']) ? $_GET['searchFdrType'] : null;
    $bankSelected = isset($_GET['searchBank']) ? $_GET['searchBank'] : null;
    $bankBranchSelected = isset($_GET['searchBankBranch']) ? $_GET['searchBankBranch'] : null;
    $dateFromSelected = isset($_GET['dateFrom']) ? $_GET['dateFrom'] : $softwareStartDate;
    $dateToSelected = isset($_GET['dateTo']) ? $_GET['dateTo'] : $softwareDate;
    $firstRequest = isset($_GET['firstRequest']) ? '1' : null;

    /*var_dump($bankBranchSelected);
    exit();*/
    $userBranchId = Auth::user()->branchId;

@endphp


<div class="row">
<div class="col-md-12">
<div class="" style="">
    <div class="">
      <div class="panel panel-default" style="background-color:#708090;">
        <div class="panel-heading" style="padding-bottom:0px">
          <div class="panel-options">
          <div class="panel-options">
                <a href="" class="btn btn-info pull-right addViewBtn" id="print"><i class="fa fa-print" aria-hidden="true"></i> Print</a>

            </div>

          </div>
          <h3  style=" text-align: center; font-family: Antiqua; letter-spacing: 2px; color: white;">Loan Register Report</h3>
        </div>
        {{-- <h5>kxghixd</h5> --}}

        <div class="panel-body panelBodyView">


            <!-- Filtering Start-->
           <div class="row" id="filtering-group">

                                <div class="form-horizontal form-groups" style="padding-right: 0px;">

                                    {!! Form::open(['url' => 'viewLoanRegisterReport','method' => 'get']) !!}


                                    {!! Form::hidden('firstRequest',0) !!}


                                    <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                             <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('', 'Project:', ['class' => 'control-label pull-left']) !!}
                                            </div>

                                            <div class="col-sm-12">
                                                <select name="searchProject" class="form-control input-sm" id="searchProject">
                                                   @if($userBranchId==1) <option value="">All</option>   @endif
                                                    @foreach($projects as $project)
                                                    <option value="{{$project->id}}" @if($project->id==$projectSelected){{"selected=selected"}}@endif>{{str_pad($project->projectCode,3,"0",STR_PAD_LEFT).'-'.$project->name}}</option>
                                                    @endforeach
                                                </select>

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

                                    <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                             <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('', 'Project Type:', ['class' => 'control-label pull-left']) !!}
                                            </div>

                                            <div class="col-sm-12">
                                                <select name="searchProjectType" class="form-control input-sm" id="searchProjectType">
                                                    @if($userBranchId==1) <option value="">All</option>   @endif
                                                    @foreach($projectTypes as $projectType)
                                                    <option value="{{$projectType->id}}" @if($projectType->id==$projectTypeSelected){{"selected=selected"}}@endif>{{str_pad($projectType->projectTypeCode,3,"0",STR_PAD_LEFT).'-'.$projectType->name}}</option>
                                                    @endforeach
                                                </select>

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


                                    {{--<div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                            <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('searchBranch', 'Branch:', ['class' => 'control-label pull-left']) !!}
                                            </div>

                                            <div class="col-sm-12">
                                                <select name="searchBranch" class="form-control input-sm" id="searchBranch">
                                                     @if($userBranchId==1)
                                                     <option value="">All</option>
                                                     <option value="0" @if($branchSelected=='0'){{"selected=selected"}}@endif>All Branches</option>
                                                     @endif
                                                    @foreach($branches as $branch)
                                                    <option value="{{$branch->id}}" @if($branch->id==$branchSelected){{"selected=selected"}}@endif>{{str_pad($branch->branchCode,3,"0",STR_PAD_LEFT).'-'.$branch->name}}</option>
                                                    @endforeach
                                                </select>

                                            </div>
                                        </div>
                                    </div>--}}


                                    {{--<div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                            <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('searchLoanType', 'LoanType Type:', ['class' => 'control-label pull-left']) !!}
                                            </div>

                                            <div class="col-sm-12">
                                            @php
                                                $loanTypes = array(''=>'All') + $fdrTypes;
                                            @endphp
                                               {!! Form::select('searchFdrType',$fdrTypes,$fdrTypeSelected,['id'=>'searchFdrType','class'=>'form-control input-sm']) !!}

                                            </div>
                                        </div>
                                    </div>--}}

                                    <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                            <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('searchBank', 'Bank Name:', ['class' => 'control-label pull-left']) !!}
                                            </div>

                                            @php
                                                $banks = array(''=>'All') + $banks;
                                            @endphp

                                            <div class="col-sm-12">
                                               {!! Form::select('searchBank',$banks,$bankSelected,['id'=>'searchBank','class'=>'form-control input-sm']) !!}

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

                                    <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                            <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('searchBankBranch', 'B.Branch:', ['class' => 'control-label pull-left']) !!}
                                            </div>
                                             @php
                                                //$bankBranches = array(''=>'All') + $bankBranches;
                                            @endphp

                                            <div class="col-sm-12">
                                              <select class="form-control input-sm" name="searchBankBranch" id="searchBankBranch">
                                                   <option value="">All</option>
                                                  @foreach($bankBranches as $bankBranch)
                                                      @php
                                                      $bankShortName = DB::table('gnr_bank')->where('id',$bankBranch->bankId_fk)->value('shortName');
                                                      @endphp
                                                  <option value="{{$bankBranch->id}}" @if($bankBranch->id==$bankBranchSelected){{"selected=selected"}}@endif >{{$bankBranch->name.'-'.$bankShortName}}</option>
                                                  @endforeach
                                              </select>
                                              {{--  {!! Form::select('searchBankBranch',$bankBranches,$bankBranchSelected,['id'=>'searchBankBranch','class'=>'form-control input-sm']) !!} --}}

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




                                    <div class="col-md-2" id="dateRangeDiv">
                                        <div class="form-group" style="font-size: 13px; color:black">
                                            <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('', ' ', ['class' => 'control-label']) !!}
                                            </div>
                                            <div class="col-sm-12" style="padding-top: 7px;">
                                                <div class="form-group">
                                                    <div class="col-sm-6">
                                                        {!! Form::text('dateFrom',$dateFromSelected,['id'=>'dateFrom','placeholder'=>'From','class'=>'form-control input-sm','readonly','style'=>'cursor:pointer']) !!}
                                                        <p id="dateFrome" style="color: red;display: none;">*Required</p>
                                                    </div>
                                                    <div class="col-sm-6" id="dateToDiv">
                                                        {!! Form::text('dateTo',$dateToSelected,['id'=>'dateTo','placeholder'=>'To','class'=>'form-control input-sm','readonly','style'=>'cursor:pointer']) !!}
                                                        <p id="dateToe" style="color: red;display: none;">*Required</p>
                                                    </div>
                                                </div>

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

                                    <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black">
                                            <div class="col-sm-12" style="padding-top: 25px;">
                                                {!! Form::submit('Search',['id'=>'search','class'=>'btn btn-primary btn-xs','style'=>'font-size:15px;']) !!}
                                            </div>
                                        </div>
                                        {!! Form::close() !!}
                                    </div>

                                </div>

                        </div> {{-- End Filtering Group --}}
            <!-- filtering end-->



            @if($firstRequest!=null)

            @php
               if($branchSelected=='0'){
                    $selectedBranchName = "All Branches";
                   }
               else{
                $selectedBranchName = DB::table('gnr_branch')->where('id',$branchSelected)->value('name');
               }
                $selectedProjectName = DB::table('gnr_project')->where('id',$projectSelected)->value('name');



            @endphp

            <div id="printingContent">

            <div style="display: none;text-align: center;" id="hiddenTitle">
                           <h3 style="text-align: center;padding: 0px;margin: 0px;">Ambala Foundation</h3>
                           <p style="text-align: center;padding: 0px;margin: 0px;font-size: 10px;">House # 62, Block # Ka, Piciculture Housing Society, Shyamoli, Dhaka-1207</p>
                           <h4 style="text-align: center;padding: 0px;margin: 0px;">Loan Register Report</h4>
                            {{-- <h5 style="text-align: center;">{{$selectedBranchName}}</h5>  --}}
                           <h5 style="text-align: center;font-size: 14;padding: 0px;margin: 0px;">{{date('F d, Y',strtotime($dateToSelected))}}</h5>
                        </div>
                        <div id="hiddenInfo" style="display: none;">

                       <p style="padding: 0px;margin: 0px;font-size: 11px;">Branch Name : @php
                            if($selectedBranchName==null){
                                echo "All";
                            }
                            else{
                                echo $selectedBranchName;
                            }
                        @endphp
                         <span style='float: right;'>
                             Reporting Peroid : {{date('d-m-Y',strtotime($dateFromSelected))." to ".date('d-m-Y',strtotime($dateToSelected))}}
                         </span>
                        </p>


                                    <p style="padding: 0px;margin: 0px;font-size: 11px;">Project Name : @php
                                        if($selectedProjectName==null){
                                            echo "All";
                                        }
                                        else{
                                            echo $selectedProjectName;
                                        }
                                    @endphp
                                    <span style='float: right;'>
                                    Print Date : {{date('F d,Y')}}
                                </span>

                                    </p>

                        </div>


<br>

          <table id="fdrRegisterTable" class="table table-striped table-bordered" style="color: black;font-size:11px;border-collapse: collapse;margin-bottom:50px;" border= "1px solid black;" cellpadding="0" cellspacing="0" width="100%">
            <thead>
              <tr>
                <th width="60" rowspan="2">SL#</th>
                <th rowspan="2" width="75">Loan Received <br> Date</th>
                <th rowspan="2">Account No</th>
                <th rowspan="2">Account Name</th>
                <th rowspan="2" width="80">Loan <br>Duration</th>
                <!-- <th rowspan="2">Mature Date</th> -->
                <th rowspan="2">Interest <br>Rate (%)</th>
                <th rowspan="2">Loan Amount (Tk)</th>


                <th rowspan="2">Opening Balance</th>
                <th colspan="3">Addition</th>
                <!-- <th colspan="2">Deduction</th> -->
                <th colspan="3">Payment</th>
                <th rowspan="2">Closing Balance</th>


               {{--  <th>Interest</th>
                <th>Bank Charge</th>
                <th>Tax</th>
                <th>Net Interest</th>
                <th>Receiveable Amount</th>

                <th>Closing Date</th>
                <th>Closing Amount</th>
                <th>Balance</th> --}}

              </tr>


              <tr>
                  <th width="100px">Principal</th>
                  <th width="100px">Interest</th>
                  <!-- <th>Tax</th> -->
                  <th>Bank Charge</th>
                  <!-- <th width="75">Date</th> -->
                  <th width="100px">Principal</th>
                  <th width="100px">Interest</th>
                  <th>Bank Charge</th>
              </tr>

            </thead>


            </thead>
            <tbody>
            @php
                $gtLoanAmount = 0;
                $gtLoanOpeningBalance = 0;
                $gtLoanAditionPrincipal = 0;
                $gtLoanAditionInterest = 0;
                $gtLoanPaymentPrincipal = 0;
                $gtLoanPaymentInterest = 0;
                $gtClosingBalance = 0;
                $rowNumbers = 0;

                $bankBranchHavingAccount = DB::table('gnr_bank_branch')->whereIn('id',$bankBranchList)->get();
            @endphp

            <tbody>

            @foreach($bankBranchHavingAccount as $branch)
                @php
                  $bankName = DB::table('gnr_bank')->where('id',$branch->bankId_fk)->value('name');
              @endphp


                <tr>
                    <td colspan="16" class="bankName">{{$bankName.', '.$branch->name}}</td>
                </tr>

                            @php
                                $index = 1;
                                $sLoanAmount = 0;
                                $sOpeingBalance = 0;
                                $sAditionPrincipal = 0;
                                $sAditionInterest = 0;
                                $sPaymentPrincipal = 0;
                                $sPaymentInterest = 0;
                                $sClosingBalance = 0;
                                //$tClosingBalance = 0;
                            @endphp

                              @foreach($loanAccounts as $loanAccount)

                              @if($loanAccount->bankBranchId_fk==$branch->id)

                              @php
                               /*$poeningBalance = DB::table('acc_loan_register_account')->where('id',$loanAccount->id)->select('');*/

                              $totalPayment  = DB::table('acc_loan_register_payments')->where('accId_fk',$loanAccount->id)->where('paymentDate','>=',$startDate)->where('paymentDate','<=',$endDate)->sum('totalAmount');
                              $loanInterestPayment = DB::table('acc_loan_register_payment_schedule')->where('accId_fk',$loanAccount->id)->where('paymentDate','>=',$startDate)->where('paymentDate','<=',$endDate)->sum('totalAmount');
                               $loanInterest =  $loanInterestPayment- $totalPayment;

                              $aditionPrincipleAmount = DB::table('acc_loan_register_payment_schedule')->where('accId_fk',$loanAccount->id)->where('paymentDate','>=',$startDate)->where('paymentDate','<=',$endDate)->sum('principalAmount');
                               $aditionInterestAmount = DB::table('acc_loan_register_payment_schedule')->where('accId_fk',$loanAccount->id)->where('paymentDate','>=',$startDate)->where('paymentDate','<=',$endDate)->sum('interestAmount');

                                $paymentPrincipalAmount = DB::table('acc_loan_register_payments')->where('accId_fk',$loanAccount->id)->where('paymentDate','>=',$startDate)->where('paymentDate','<=',$endDate)->sum('principalAmount');

                                $paymentInterestAmount = DB::table('acc_loan_register_payments')->where('accId_fk',$loanAccount->id)->where('paymentDate','>=',$startDate)->where('paymentDate','<=',$endDate)->sum('interestAmount');
                               $loan = $loanAccount->loanAmount +$aditionPrincipleAmount+$aditionInterestAmount-$paymentPrincipalAmount+$paymentInterestAmount;

                              //$loanInterest =$loanAccount->
                                /* $bankChange = DB::table('acc_fdr_interest')->where('fdrAccId_fk',$loanAccounts->id)->where('receiveDate','>=',$startDate)->where('receiveDate','<=',$endDate)->sum('bankCharge');
                                 $taxAmount = DB::table('acc_fdr_interest')->where('fdrAccId_fk',$loanAccounts->id)->where('receiveDate','>=',$startDate)->where('receiveDate','<=',$endDate)->sum('taxAmount');
                                  $netInterest = DB::table('acc_fdr_interest')->where('fdrAccId_fk',$loanAccounts->id)->where('receiveDate','>=',$startDate)->where('receiveDate','<=',$endDate)->sum('netInterestAmount');

                                  $receiveAbleAmount = $loanAccounts->principalAmount + $netInterest;

                                  $closingDate = DB::table('acc_fdr_close')->where('accId_fk',$loanAccounts->id)->where('closingDate','<=',$endDate)->value('closingDate');
                                  if ($closingDate!=null &&  $closingDate!='') {

                                       $interestTillNow = DB::table('acc_fdr_interest')->where('fdrAccId_fk',$loanAccounts->id)->sum('netInterestAmount');

                                      $closingAmount = $loanAccounts->principalAmount + $interestTillNow;
                                  }
                                  else{
                                   $closingAmount = 0;
                                  }

                                  ////////

                                  $principaAmount = 0;
                                  $accOpeningDate = Carbon::parse($loanAccounts->openingDate);
                                  if ($accOpeningDate->gte($startDate)) {

                                      $principaAmount = $loanAccounts->principalAmount;
                                  }

                                  $openingNetInterest = DB::table('acc_fdr_interest')->where('fdrAccId_fk',$loanAccounts->id)->where('receiveDate','<',$startDate)->sum('netInterestAmount');


                                  $openingBalance = 0;
                                  if ($accOpeningDate->lt($startDate)) {
                                      $openingBalance = $loanAccounts->principalAmount;
                                  }


                                  $openingBalance = $openingBalance + $openingNetInterest;


                                  $balance = $openingBalance + $principaAmount + $interest - $bankChange - $taxAmount - $closingAmount;*/

                                  //$openingBalance = $openingBalance + $loanInterest;


                             @endphp


                             <tr>
                                <td>{{$index}}</td>
                                <td>{{date('d-m-Y',strtotime($loanAccount->loanDate))}}</td>
                                <td>{{$loanAccount->accNo}}</td>
                                <td class="name"></td>
                                <td>{{$loanAccount->loanDuration}}</td>
                                <td class="amount">{{$loanAccount->interestRate}}</td>
                                 <td class="amount">{{number_format($loanAccount->loanAmount,2)}}</td>


                                 <td class="amount">{{number_format($loanInterest,2,'.',',')}}</td>
                                <td class="amount">{{number_format($aditionPrincipleAmount,2)}}</td>
                                 <td class="amount">{{number_format($aditionInterestAmount,2,'.',',')}}</td>
                                <td class="amount"></td>
                                <td class="amount">{{number_format($paymentPrincipalAmount,2,'.',',')}}</td>
                                <td class="amount">{{number_format($paymentInterestAmount,2,'.',',')}}</td>
                                <td class="amount"></td>
                                 <td class="amount">{{number_format($loan,2,'.',',')}}</td>
                                {{--<td class="amount">{{number_format($bankChange,2,'.',',')}}</td>

                                <td>
                                    @if($closingDate==null)
                                        {{"-"}}
                                    @else
                                        {{date('d-m-Y',strtotime($closingDate))}}
                                    @endif

                                </td>

                                <td class="amount">
                                    @if($closingDate==null)
                                        {{"-"}}
                                    @else
                                        {{number_format($closingAmount,2,'.',',')}}
                                    @endif

                                </td>

                                <td class="amount">{{number_format($balance,2,'.',',')}}</td>--}}

                             </tr>

                              @php
                                $sLoanAmount = $sLoanAmount + $loanAccount->loanAmount;
                                $sOpeingBalance = $sOpeingBalance + $loanInterest;
                                $sAditionPrincipal = $sAditionPrincipal + $aditionPrincipleAmount;
                                $sAditionInterest = $sAditionInterest + $aditionInterestAmount;
                                $sPaymentPrincipal = $sPaymentPrincipal + $paymentPrincipalAmount;
                                $sPaymentInterest = $sPaymentInterest + $paymentInterestAmount;
                                $sClosingBalance = $sClosingBalance + $loan;
                                $rowNumbers++;
                                $index++;
                              @endphp

                             @endif

                             @endforeach {{-- Account --}}

                         <tr class="subTotalRow">
                            <td colspan="6" rowspan="" style="font-weight: bold;">Sub Total</td>
                            <td class="amount">{{number_format($sLoanAmount,2,'.',',')}}</td>
                            <td class="amount">{{number_format($sOpeingBalance,2,'.',',')}}</td>
                            <td class="amount">{{number_format($sAditionPrincipal,2,'.',',')}}</td>
                            <td class="amount">{{number_format($sAditionInterest,2,'.',',')}}</td>

                           <td class="amount"></td>
                           <td class="amount">{{number_format($sPaymentPrincipal,2,'.',',')}}</td>
                            <td class="amount">{{number_format($sPaymentInterest,2,'.',',')}}</td>
                            <td class="amount"></td>

                            <td class="amount">{{number_format($sClosingBalance,2,'.',',')}}</td>
                        </tr>

                        @php
                            $gtLoanAmount = $gtLoanAmount + $sLoanAmount;
                            $gtLoanOpeningBalance = $gtLoanOpeningBalance + $sOpeingBalance;
                            $gtLoanAditionPrincipal = $gtLoanAditionPrincipal + $sAditionPrincipal;
                            $gtLoanAditionInterest = $gtLoanAditionInterest + $sAditionInterest;
                            $gtLoanPaymentPrincipal = $gtLoanPaymentPrincipal + $sPaymentPrincipal;
                            $gtLoanPaymentInterest = $gtLoanPaymentInterest + $sPaymentInterest;
                            $gtClosingBalance = $gtClosingBalance + $sClosingBalance;
                        @endphp



                    @endforeach {{-- Branch --}}


            </tbody>
            <tfoot>
               <tr>
                    <td colspan="6" class="name">Total {{'('.$rowNumbers.')'}}</td>
                    <td class="amount">{{number_format($gtLoanAmount,2,'.',',')}}</td>
                    <td class="amount">{{number_format($gtLoanOpeningBalance,2,'.',',')}}</td>
                    <td class="amount">{{number_format($gtLoanAditionPrincipal,2,'.',',')}}</td>

                    <td class="amount">{{number_format($gtLoanAditionInterest,2,'.',',')}}</td>
                    <td></td>
                    <td class="amount">{{number_format($gtLoanPaymentPrincipal,2,'.',',')}}</td>

                    <td class="amount">{{number_format($gtLoanPaymentInterest,2,'.',',')}}</td>

                    <td class="amount"></td>
                    <td class="amount">{{number_format($gtClosingBalance,2,'.',',')}}</td>

                </tr>
            </tfoot>
          </table>
          </div>
          @endif {{-- End First Request --}}
        </div>
      </div>
  </div>
  </div>
</div>
</div>


<style type="text/css">
    #fdrRegisterTable tbody tr td.amount{
        text-align: right;
        padding-right: 5px;
    }
     #fdrRegisterTable tbody tr td.name{
        text-align: left;
        padding-left: 5px;
    }

    #fdrRegisterTable tfoot tr td.name{
        text-align: center;
        font-weight: bold;
    }
    #fdrRegisterTable tfoot tr td.amount{
        text-align: right;
        padding-right: 5px;
        font-weight: bold;
    }
    #fdrRegisterTable tfoot tr td{
        background-color: #8b8d91;
        line-height: 10px;
    }
</style>



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




        function toDate(dateStr) {
    var parts = dateStr.split("-");
    return new Date(parts[2], parts[1] - 1, parts[0]);
}

    //getting software date from controller in string format and converting into date format
    var maxDate = "{{$softwareDate}}";
    var dt = new Date(maxDate);
    // alert(dt);

    /* Date Range From */
$("#dateFrom").datepicker({
       changeMonth: true,
       changeYear: true,
       yearRange : "2010:c",
       minDate: new Date(2010, 07 - 1, 01),
       maxDate: "dateToday",
       dateFormat: 'dd-mm-yy',
       onSelect: function () {
           $('#dateFrome').hide();
           $("#dateTo").datepicker("option","minDate",new Date(toDate($(this).val())));
       }
   });
/* Date Range From */

// triggering minimum date in date to
$('.ui-datepicker-current-day').click();

/* Date Range To */
$("#dateTo").datepicker({
       changeMonth: true,
       changeYear: true,
       yearRange : "2010:c",
       minDate: new Date(2010, 07 - 1, 01),
       maxDate: "dateToday",
       dateFormat: 'dd-mm-yy',
       onSelect: function () {
           $('#dateToe').hide();
           $("#dateFrom").datepicker("option","maxDate",new Date(toDate($(this).val())));
       }
   });

/* End Date Range To */

    //Getting software starting date according to branch

    $("#searchBranch").change(function(event) {
        /* Act on the event */
        var branchId = $(this).val();
        alert(branchId);
        $.ajax({
            url: './getSoftwareDateByBranch',
            type: 'POST',
            dataType: 'json',
            data: {branchId: branchId},
        })
        .done(function(response) {
          minDate = response.softwareDate;
          // alert(minDate);
            $("#dateFrom").datepicker("option","minDate",new Date(toDate(minDate)));
        })
        .fail(function() {
            console.log("error");
        })
        .always(function() {
            console.log("complete");
        });


    });

    var firstRequest = "{{$firstRequest}}";
    if (firstRequest=='') {
        // $("#dateFrom").datepicker().datepicker("setDate", new Date());
        // $("#dateTo").datepicker().datepicker("setDate", new Date());
    }


    /*Validation*/
    $("#search").click(function(event) {
    var searchInterestPayment = $("#searchInterestPayment").val();
    if ($("#dateFrom").val()=="" && searchInterestPayment=="") {
            event.preventDefault();
            $("#dateFrome").show();
        }
    if ($("#dateTo").val()=="" && searchInterestPayment=="") {
        event.preventDefault();
        $("#dateToe").show();
    }
});
    /*End Validation*/


     /*Filter Branch Location On selecting Bank*/
         $("#searchBank").on('change', function() {
             var bank = $("#searchBank option:selected").val();

             var csrf = "{{csrf_token()}}";

             $.ajax({
                 url: './accFdrGetBranchLocationBaseOnBank',
                 type: 'POST',
                 dataType: 'json',
                 data: {bank: bank, _token: csrf},
             })
             .done(function(branches) {

                //$("#searchBankBranch").empty();
                $("#searchBankBranch").append("<option value=''>All</option>");
                $.each(branches, function(index, branch) {
                     $("#searchBankBranch").append("<option value='"+branch.id+"'>"+branch.name+"-"+branch.bankName+"</option>");
                });


                 console.log("success");
             })
             .fail(function() {
                 console.log("error");
             })
             .always(function() {
                 console.log("complete");
             });

         });
         /*End Filter Branch Location On selecting Bank*/





    });
</script>


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

        function pad (str, max) {
              str = str.toString();
              return str.length < max ? pad("0" + str, max) : str;
            }

         /* Change Project*/
         $("#searchProject").change(function(){

            var projectId = $(this).val();
            var branchId = $("#searchBranch option:selected").val();

            var csrf = "<br />
<b>Fatal error</b>:  Uncaught Error: Call to undefined function csrf_token() in /home/shikkhaplus/public_html/resources/views/accounting/registerReport/loanRegister/loanRegisterReport.blade.php:724
Stack trace:
#0 {main}
  thrown in <b>/home/shikkhaplus/public_html/resources/views/accounting/registerReport/loanRegister/loanRegisterReport.blade.php</b> on line <b>724</b><br />