@extends('layouts/acc_layout')
@section('title', '| OTS Bank Advice Letter')
@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>
                                {{-- <a href="" class="btn btn-info pull-right addViewBtn" id="printWithSignature"><i class="fa fa-print" aria-hidden="true"></i> Print With Signature</a> --}}

                            </div>

                        </div>
                        <h3 style=" text-align: center; font-family: Antiqua; letter-spacing: 2px; color: white;">OTS Bank Advice Letter</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' => 'otsBankAdviceLetter','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('searchInterestPayment', 'Interest Payment Id:', ['class' => 'control-label pull-left']) !!}
                                        </div>

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

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

                        @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 Interest Payment, {{date('F d, Y',strtotime($endDate))}}</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="interestPaymentReportTable" 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>SL#</th>
                                        <th style="width: 100px">Account ID</th>
                                        <th>Account Holder Name</th>
                                        <th>Account Number</th>
                                        <th>Routing No</th>
                                        <th>Bank Name</th>
                                        <th>Branch Name</th>
                                        <th>Amount (Tk)</th>
                                    </tr>


                                </thead>
                                <tbody>
                                    @php
                                    $totalAmount = 0;

                                    @endphp

                                    @foreach($payments as $key => $payment)

                                    <tr>
                                        <td>{{$key+1}}</td>
                                        {{-- <td>{{date('d-m-Y',strtotime($payment->paymentDate))}}</td>
                                        <td class="name">{{$memberName[$key]}}</td> --}}
                                        <td>&nbsp;{{explode('-', $accNo[$key])[0]}}</td>
                                        <td class="name">{{$accHolderName[$key]}}</td>
                                        <td>&nbsp;{{$bankAccountNo[$key]}}</td>
                                        <td>&nbsp;{{$routingNo[$key]}}</td>
                                        <td class="name">{{$bankName[$key]}}</td>
                                        <td class="name">{{$branchName[$key]}}</td>
                                        {{-- <td>{{$interestRate[$key]}}</td> --}}
                                        {{-- <td class="amount">{{number_format($principalAmount[$key],2,'.',',')}}</td> --}}
                                        <td class="amount">{{number_format($interestPayment[$key],2,'.',',')}}</td>
                                    </tr>

                                    @php
                                    $totalAmount = $totalAmount + (float) $interestPayment[$key];
                                    @endphp

                                    @endforeach

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


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

    #interestPaymentReportTable tbody tr td.name {
        text-align: left;
        padding-left: 5px;
    }

    #interestPaymentReportTable tfoot tr td.name {
        text-align: center;
        font-weight: bold;
    }

    #interestPaymentReportTable tfoot tr td.amount {
        text-align: right;
        padding-right: 5px;
        font-weight: bold;
    }

    #interestPaymentReportTable 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]);
        }
        /* 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 */

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