{{-- {{$softwareDate}} --}}
{{-- @php
exit();
@endphp --}}
@extends('layouts/acc_layout')
@section('title', '| Register Report')
@section('content')

<style>
    .select2-container--default .select2-selection--single {
        border-radius: 0 !important;
        border: 1px solid #e4e4e4;
    }
    .select2-container, .select2-container .select2-selection--single {
        height: 30px !important;
    }
    .select2-container .select2-selection--single .select2-selection__rendered, .select2-container--default .select2-results>.select2-results__options {
        font-size: 11px !important;
    }
</style>


<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;">OTS Balance 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' => 'viewOtsRegisterBalanceReport','method' => 'get']) !!}


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



                                    <div class="col-md-2" style="display: none;">
                                        <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">
                                                    <option value="">All</option>
                                                    @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-2">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                            <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('', 'Branch Location:', ['class' => 'control-label pull-left']) !!}
                                            </div>

                                            <div class="col-sm-12">
                                                <select name="searchBranch" class="form-control input-sm custom-select2" id="searchBranch">
                                                    <option value="">All</option>
                                                    @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-2">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                            <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('searchAccNature', 'Account Nature:', ['class' => 'control-label pull-left']) !!}
                                            </div>

                                            <div class="col-sm-12">
                                            @php
                                                $accNature = array(''=>'All') + DB::table('acc_ots_period')->pluck('name','id')->toArray();
                                            @endphp
                                                {!! Form::select('searchAccNature',$accNature,$accNatureSelected,['id'=>'searchAccNature','class'=>'form-control']) !!}

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


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

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

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

                                  <br />
<b>Warning</b>:  Undefined variable $softwareDate in <b>/home/shikkhaplus/public_html/guk_bk/resources/views/accounting/registerReport/ots/otsRegisterBalanceReport.blade.php</b> on line <b>122</b><br />
<br />
<b>Deprecated</b>:  strtotime(): Passing null to parameter #1 ($datetime) of type string is deprecated in <b>/home/shikkhaplus/public_html/guk_bk/resources/views/accounting/registerReport/ots/otsRegisterBalanceReport.blade.php</b> on line <b>122</b><br />
                                    <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)

            @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;">OTS Balance 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($endDate))}}</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($startDate))." to ".date('d-m-Y',strtotime($endDate))}}
                         </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="registerReportTable" 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 rowspan="2">SL#</th>
                <th rowspan="2">Opening Date</th>
                <th rowspan="2">Account Name</th>
                <th rowspan="2">Account Number</th>
                <th rowspan="2">Branch</th>
                <th rowspan="2">Payment Nature</th>
                <th rowspan="2">Interest Rate (%)</th>
                <th rowspan="2">Principal Amount (Tk)</th>
                <th rowspan="2">Interest Gen. <br> Amount (Tk)</th>
                <th rowspan="2">Interest Payment <br> Amount (Tk)</th>
                <th colspan="3">OTS Encashment</th>
                <th colspan="3">Closing Balance (Pri. + Int.)</th>
              </tr>

              <tr>
                  <th width="70">Date</th>
                  <th>Principal</th>
                  <th>Interest</th>

                  <th>Principal</th>
                  <th>Interest</th>
                  <th>Total</th>
              </tr>


            </thead>
            <tbody>
            @php

              //$gTinterestPrevious = 0;
              $gTinterestCurrent = 0;
              //$gTinterestTotal = 0;

              //$gTpaymentPrevious = 0;
              $gTpaymentCurrent = 0;
              //$gTpaymentTotal = 0;

              $gTecashmentPrincipal = 0;
              $gTecashmentInterest = 0;

              $gTsavings = 0;
              $gTdueInterest = 0;
              $gTtotal = 0;
            @endphp

             @foreach($accounts as $key => $account)

             @php
               $memberName =  DB::table('acc_ots_member')->where('id',$account->memberId_fk)->value('name');
               $branchName =  DB::table('gnr_branch')->where('id',$account->branchId_fk)->value('name');
               $paymentNatureName =  DB::table('acc_ots_period')->where('id',$account->periodId_fk)->value('name');
               $memberName =  DB::table('acc_ots_member')->where('id',$account->memberId_fk)->value('name');

               $lastPaidInterestRate = DB::table('acc_ots_payment_details')->where('accId_fk',$account->id)->orderBy('id','desc')->value('interestRate');
                if ($lastPaidInterestRate==null) {
                  $lastPaidInterestRate = DB::table('acc_ots_period')->where('id',$account->periodId_fk)->value('interestRate');
                }
             /* $interestPrevious = DB::table('acc_ots_interest_details')->where('accId_fk',$account->id)->where('generateDate','<',$startDate)->sum('amount') + (float) DB::table('acc_ots_account')->where('id',$account->id)->where('openingBalanceDate','<',$startDate)->value('openingBalance');*/

              /*$interestTotal = $interestPrevious + $interestCurrent;*/

              /*$paymentPrevious = DB::table('acc_ots_payment_details')->where('accId_fk',$account->id)->where('paymentDate','<',$startDate)->sum('amount');*/
              if ($account->closingDate==$endDate) {
                $interestCurrent = 0;
                $paymentCurrent = 0;

                $encashmentDate = date('Y-m-d', strtotime($account->closingDate));
                $encashmentPrincipal = $account->amount;
                $encashmentInterest = DB::table('acc_ots_interest_details')->where('accId_fk',$account->id)->where('generateDate','>=',$startDate)->where('generateDate','<=',$endDate)->sum('amount') + (float) DB::table('acc_ots_account')->where('id',$account->id)->where('openingBalanceDate','>=',$startDate)->where('openingBalanceDate','<=',$endDate)->value('openingBalance');
                $closingPricipal = 0;
                $closingInterest = 0;
                $closingTotal = 0;
              }
              else{
                $interestCurrent = DB::table('acc_ots_interest_details')->where('accId_fk',$account->id)->where('generateDate','>=',$startDate)->where('generateDate','<=',$endDate)->sum('amount') + (float) DB::table('acc_ots_account')->where('id',$account->id)->where('openingBalanceDate','>=',$startDate)->where('openingBalanceDate','<=',$endDate)->value('openingBalance');
                 $paymentCurrent = DB::table('acc_ots_payment_details')->where('accId_fk',$account->id)->where('paymentDate','>=',$startDate)->where('paymentDate','<=',$endDate)->sum('amount');

                 $encashmentDate = '-';
                 $encashmentPrincipal = 0;
                 $encashmentInterest = 0;

                 $closingPricipal = $account->amount;
                 $closingInterest = $interestCurrent - $paymentCurrent;
                 $closingTotal = $account->amount + $interestCurrent - $paymentCurrent;
              }

              /*$paymentTotal = $paymentPrevious + $paymentCurrent;*/

              /*$dueInterest = $interestTotal - $paymentTotal;*/
              /*$dueInterest = $interestCurrent - $paymentCurrent;
              $total = $account->amount + $dueInterest;*/

             @endphp

             <tr>
             <td>{{$key+1}}</td>
             <td>{{date('d-m-Y',strtotime($account->openingDate))}}</td>
             <td class="name">{{$memberName}}</td>
             <td>{{$account->accNo}}</td>
             <td class="name">{{$branchName}}</td>
             <td>{{$paymentNatureName}}</td>
             <td>{{number_format($lastPaidInterestRate,2)}}</td>
             <td class="amount">{{number_format($account->amount,2,'.',',')}}</td>
             <td class="amount">{{number_format($interestCurrent,2,'.',',')}}</td>
             <td class="amount">{{number_format($paymentCurrent,2,'.',',')}}</td>

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

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

             </tr>

             @php
                /*$gTinterestPrevious = $gTinterestPrevious + $interestPrevious;*/
                $gTinterestCurrent = $gTinterestCurrent + $interestCurrent;
                /*$gTinterestTotal = $gTinterestTotal + $interestTotal;*/
                /*$gTpaymentPrevious = $gTpaymentPrevious + $paymentPrevious;*/
                $gTpaymentCurrent = $gTpaymentCurrent + $paymentCurrent;
                /*$gTpaymentTotal = $gTpaymentTotal + $paymentTotal;*/

                $gTecashmentPrincipal = $gTecashmentPrincipal + $encashmentPrincipal;
                $gTecashmentInterest = $gTecashmentInterest + $encashmentInterest;


                $gTsavings = $gTsavings + $closingPricipal;
                $gTdueInterest = $gTdueInterest + $closingInterest;
                $gTtotal = $gTtotal + $closingTotal;
             @endphp

             @endforeach

            </tbody>
            <tfoot>
                <tr>
                    <td colspan="7" class="name">Total</td>
                    <td class="amount">{{number_format($gTsavings,2,'.',',')}}</td>

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

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

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

                    <td class="amount">{{number_format($gTsavings,2,'.',',')}}</td>
                    <td class="amount">{{number_format($gTdueInterest,2,'.',',')}}</td>
                    <td class="amount">{{number_format($gTtotal,2,'.',',')}}</td>
                </tr>
            </tfoot>
          </table>
          </div>
          @endif
        </div>
      </div>
  </div>
  </div>
</div>
</div>


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

    #registerReportTable tfoot tr td.name{
        text-align: center;
        font-weight: bold;
    }
    #registerReportTable tfoot tr td.amount{
        text-align: right;
        padding-right: 5px;
        font-weight: bold;
    }
    #registerReportTable 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 softwareDate = "{{$softwareDate}}";
    var dt = new Date(softwareDate);
    // alert(softwareDate);


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

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

    /* 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) {
              maxDate = response.softwareMaxDate;
              // alert(minDate);
                $("#dateTo").datepicker("option","maxDate",new Date(toDate(maxDate)));
            })
            .fail(function() {
                console.log("error");
            })
            .always(function() {
                console.log("complete");
            });


        });

    var firstRequest = "{{$firstRequest}}";
    if (firstRequest==1) {
        // $("#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*/





    });
</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/guk_bk/resources/views/accounting/registerReport/ots/otsRegisterBalanceReport.blade.php:538
Stack trace:
#0 {main}
  thrown in <b>/home/shikkhaplus/public_html/guk_bk/resources/views/accounting/registerReport/ots/otsRegisterBalanceReport.blade.php</b> on line <b>538</b><br />