@extends('layouts/microfin_layout')
@section('title', '| Savings Interest Provision Statement')
@section('content')

    <style type="text/css">
        .form-group,
        .form-control {
            font-size: 11px !important;
            color: black !important;
        }

        .form-control {
            padding: 5px !important;
        }

        #reportSubmit {
            font-size: 12px;
            margin-top: 20px;
        }
    </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">

                                {{--     <button id="btnExportExcel">Xls</button>  --}}
                                {{--   <li><a href="#" onClick="doExport('#printDiv', {type: 'xlsx'});">.XLSX</a></li> --}}
                                <button id="printIcon" class="btn btn-info pull-left print-icon" target="_blank"
                                    style="">
                                    <i class="fa fa-print fa-lg" aria-hidden="true">Print</i>
                                </button>
                                <button id="btnExportExcel" class="btn btn-info pull-center print-icon" target="_blank"
                                    style="">
                                    <i class="fa-file-excel-o fa-lg" aria-hidden="true"> Excel</i>
                                </button>

                                <button id="btnExportPdf" class="btn btn-info pull-right print-icon" target="_blank"
                                    style="">
                                    <i class="fa-file-excel-o fa-lg" aria-hidden="true"> Pdf</i>
                                </button>

                                {{-- <a id="download_link" download="my_exported_file.pdf" href=”” >Download as Text File</a> --}}
                                {{--  <button onclick="javascript:demoFromHTML();">Generate Pdf</button> --}}
                                {{--   <div class="download" style="width:90%;margin:30px auto ;max-width: 800px;background:#ededed;">
                               <div style="padding-top:1%;padding-left:1%;"><button class="btn btn-info" id="downloadButton" >Download</button></div>
                           </div> --}}
                                <div id="editor"></div>

                                {{--            <button id="cmd">Download Survey Report</button> --}}

                                {{--  <button onclick="javascript:demoFromHTML();">PDF</button> --}}

                            </div>
                            <h3 style=" text-align: center; font-family: Antiqua; letter-spacing: 2px; color: white;">
                                Savings Interest Provision Statement</h3>
                        </div>

                        <div class="panel-body panelBodyView">

                            <!-- Filtering Start-->
                            {!! Form::open([
                                'url' => '',
                                'role' => 'form',
                                'class' => 'form-horizontal form-groups',
                                'id' => 'filterFormId',
                                'method' => 'get',
                            ]) !!}
                            <div class="row">
                                <div class="col-md-12">

                                    @if (!in_array($userRoleId, Config('services.branch_level_user_roles')))
                                        <div class="col-md-1">
                                            <div class="form-group">
                                                <div class="col-md-12">
                                                    {!! Form::label('filReportLevel', 'Report Level:', ['class' => 'control-label pull-left']) !!}
                                                </div>
                                                <div class="col-md-12">
                                                    {!! Form::select('filReportLevel', $reportLevelList, null, [
                                                        'id' => 'filReportLevel',
                                                        'class' => 'form-control input-sm',
                                                        'autocomplete' => 'off',
                                                        'autofocus',
                                                    ]) !!}
                                                </div>
                                            </div>
                                        </div>

                                        <div class="col-md-2" id="areaDiv" style="display: none;">
                                            <div class="form-group">
                                                <div class="col-md-12">
                                                    {!! Form::label('filArea', 'Area:', ['class' => 'control-label pull-left']) !!}
                                                </div>
                                                <div class="col-md-12">
                                                    <select id="filArea" name="filArea" class="form-control input-sm">
                                                        <option value="">--Select Area--</option>
                                                        @foreach ($areaList as $area)
                                                            <option value="{{ $area->id }}">{{ $area->name }}</option>
                                                            @php
                                                                $barnchIds = str_replace(['"', '[', ']'], '', $area->branchId);
                                                                $barnchIds = explode(',', $barnchIds);
                                                                $branches = DB::table('gnr_branch')
                                                                    ->whereIn('id', $barnchIds)
                                                                    ->select(DB::raw("CONCAT ( LPAD(branchCode,3,0) ,' - ', name ) AS name"))
                                                                    ->get();
                                                            @endphp
                                                            @foreach ($branches as $branch)
                                                                <option value="" disabled="disabled">&nbsp
                                                                    {{ $branch->name }}</option>
                                                            @endforeach
                                                        @endforeach
                                                    </select>
                                                </div>
                                            </div>
                                        </div>

                                        <div class="col-md-2" id="zoneDiv" style="display: none;">
                                            <div class="form-group">
                                                <div class="col-md-12">
                                                    {!! Form::label('filZone', 'Zone:', ['class' => 'control-label pull-left']) !!}
                                                </div>
                                                <div class="col-md-12">
                                                    <select id="filZone" name="filZone" class="form-control input-sm">
                                                        <option value="">--Select Zone--</option>
                                                        @foreach ($zoneList as $zone)
                                                            <option value="{{ $zone->id }}">{{ $zone->name }}</option>
                                                            @php
                                                                $areaIds = str_replace(['"', '[', ']'], '', $zone->areaId);
                                                                $areaIds = explode(',', $areaIds);
                                                                $areas = DB::table('gnr_area')
                                                                    ->whereIn('id', $areaIds)
                                                                    ->select(DB::raw("CONCAT ( LPAD(code,3,0) ,' - ', name ) AS name"))
                                                                    ->get();
                                                            @endphp
                                                            @foreach ($areas as $area)
                                                                <option value="" disabled="disabled">&nbsp
                                                                    {{ $area->name }}</option>
                                                            @endforeach
                                                        @endforeach
                                                    </select>

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

                                        <div class="col-md-2" id="regionDiv" style="display: none;">
                                            <div class="form-group">
                                                <div class="col-md-12">
                                                    {!! Form::label('filRegion', 'Region:', ['class' => 'control-label pull-left']) !!}
                                                </div>
                                                <div class="col-md-12">
                                                    <select id="filRegion" name="filRegion" class="form-control input-sm">
                                                        <option value="">--Select Region--</option>
                                                        @foreach ($regionList as $region)
                                                            <option value="{{ $region->id }}">{{ $region->name }}</option>
                                                            @php
                                                                $zoneIds = str_replace(['"', '[', ']'], '', $region->zoneId);
                                                                $zoneIds = explode(',', $zoneIds);
                                                                $zones = DB::table('gnr_zone')
                                                                    ->whereIn('id', $zoneIds)
                                                                    ->select(DB::raw("CONCAT ( LPAD(code,3,0) ,' - ', name ) AS name"))
                                                                    ->get();
                                                            @endphp
                                                            @foreach ($zones as $zone)
                                                                <option value="" disabled="disabled">&nbsp
                                                                    {{ $zone->name }}</option>
                                                            @endforeach
                                                        @endforeach
                                                    </select>
                                                </div>
                                            </div>
                                        </div>

                                        <div class="col-md-2" id="branchDiv">
                                            <div class="form-group">
                                                <div class="col-md-12">
                                                    {!! Form::label('filBranchE', 'Branch:', ['class' => 'control-label pull-left']) !!}
                                                </div>
                                                <div class="col-md-12">
                                                    {!! Form::select('filBranch', ['' => '--All--'] + $branchList, null, [
                                                        'id' => 'filBranch',
                                                        'class' => 'form-control input-sm',
                                                        'autocomplete' => 'off',
                                                    ]) !!}
                                                    <p id='filBranchE' style="max-height:3px; color:red;"></p>
                                                </div>
                                            </div>
                                        </div>
                                    @endif

                                    @if (in_array($userRoleId, Config('services.branch_level_user_roles')))
                                        <div class="col-md-2" id="branchDiv">
                                            <div class="form-group">
                                                <div class="col-md-12">
                                                    {!! Form::label('filBranch', 'Branch:', ['class' => 'control-label pull-left']) !!}
                                                </div>
                                                <div class="col-md-12">
                                                    {!! Form::select('filBranch', $branchList, null, [
                                                        'id' => 'filBranch',
                                                        'class' => 'form-control input-sm',
                                                        'autocomplete' => 'off',
                                                    ]) !!}
                                                    <p id='filBranchE' style="max-height:3px; color:red;"></p>
                                                </div>
                                            </div>
                                        </div>
                                    @endif

                                    <div class="col-md-1">
                                        <div class="form-group">
                                            <div class="col-md-12">
                                                {!! Form::label('filType', 'Type:', ['class' => 'control-label pull-left']) !!}
                                            </div>
                                            <div class="col-md-12">
                                                <select id="filType" name="filType" class="form-control input-sm">
                                                    @foreach ($depositTypeList as $type)
                                                        <option value="{{ $type->id }}">{{ $type->name }}</option>
                                                    @endforeach
                                                </select>
                                            </div>
                                        </div>
                                    </div>

                                    <div class="col-md-1">
                                        <div class="form-group">
                                            <div class="col-md-12">
                                                {!! Form::label('filProduct', 'Product:', ['class' => 'control-label pull-left']) !!}
                                            </div>
                                            <div class="col-md-12">
                                                <select id="filProduct" name="filProduct" class="form-control input-sm">
                                                    {{-- @foreach ($productList as $product)
                                                <option value="{{$product->id}}" type="{{$product->depositTypeIdFk}}">{{$product->name}}</option>
                                            @endforeach --}}
                                                </select>
                                            </div>
                                        </div>
                                    </div>


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

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

                                    <div class="col-md-2">
                                        <div class="form-group">
                                            <div class="col-md-12">
                                                {!! Form::label('', 'Funding Org.:', ['class' => 'control-label pull-left']) !!}
                                            </div>
                                            <div class="col-md-12">
                                                {!! Form::select('filFundingOrg', ['' => '--All--', '-1' => 'PKSF & Others'] + $fundingOrgList, null, [
                                                    'id' => 'filFundingOrg',
                                                    'class' => 'form-control input-sm',
                                                    'autocomplete' => 'off',
                                                ]) !!}
                                                <p id='filMonthE' style="max-height:3px; color:red;"></p>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="row">
                                <div class="col-md-12">

                                    <div class="col-md-2">
                                        <div class="form-group">
                                            <div class="col-md-12">
                                                {!! Form::label('optionId', 'Report Opt:', ['class' => 'control-label pull-left']) !!}
                                            </div>
                                            <div class="col-md-12">
                                                {!! Form::select('optionId', ['0' => 'Summary', '1' => 'Details'], null, [
                                                    'id' => 'optionId',
                                                    'class' => 'form-control input-sm',
                                                    'autocomplete' => 'off',
                                                    'required' => 'required',
                                                ]) !!}
                                            </div>
                                        </div>
                                    </div>


                                    <div class="col-md-2">
                                        <div class="form-group">
                                            <div class="col-md-12">
                                                {!! Form::label('', 'Show Column:', ['class' => 'control-label pull-left']) !!}
                                            </div>
                                            <div class="col-md-12">
                                                {!! Form::select(
                                                    'showColumn[]',
                                                    ['1' => 'Member Old Code', '2' => 'NID', '3' => 'Mobile', '4' => 'Signature'],
                                                    null,
                                                    ['id' => 'showColumn', 'class' => 'form-control input-sm', 'multiple'],
                                                ) !!}
                                            </div>
                                        </div>
                                    </div>

                                    <div class="col-md-1">
                                        <div class="form-group">
                                            {!! Form::label('', '', ['class' => 'control-label col-md-12']) !!}
                                            <div class="col-md-12">
                                                {!! Form::submit('Show Report', ['id' => 'reportSubmit', 'class' => 'btn btn-primary btn-xs']) !!}
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>

                            {!! Form::close() !!}
                            <!-- filtering end-->


                            <div class="row">
                                <div class="col-md-12" id="reportingDiv">

                                </div>
                            </div>


                        </div> {{-- panel-body panelBodyView DIV --}}
                    </div>
                </div>
            </div>
        </div>
    </div>


    <script type="text/javascript">
        $('#showColumn').parents('.form-group').parent('div').hide('slow');
        $('#optionId').on('change', function() {
            var optionId = $(this).val();
            if (optionId == 1) {
                $('#showColumn').parents('.form-group').parent('div').show('slow');
            } else {
                $('#showColumn').parents('.form-group').parent('div').hide('slow');
            }
        });

        var csrf = "{{ csrf_token() }}";
        $("#filType").change(function(event) {
            var filType = $(this).val();
            $("#filProduct").empty("");
            $.ajax({
                    url: './provisionStatement/product',
                    type: 'POST',
                    dataType: 'json',
                    data: {
                        filType: filType,
                        _token: csrf
                    },
                })
                .done(function(data) {
                    if (data.length > 1) {
                        $("#filProduct").html("<option value=''>All</option>");
                    }
                    $.each(data, function(index, v) {
                        $("#filProduct").append("<option value='" + v.id + "'>" + v.name + "</option>");
                    });
                })
                .fail(function() {
                    console.log("error");
                });

        });
        $('#filType').trigger('change');

        /*on change filReportLevel hide/show contents*/
        $("#filReportLevel").change(function(event) {
            if ($(this).val() == "Branch") {
                $("#branchDiv").show();
                $("#areaDiv").hide();
                $("#zoneDiv").hide();
                $("#regionDiv").hide();

                //     $("#filArea").prop('required', false);
                //     $("#filZone").prop('required', false);
                //     $("#filRegion").prop('required', false); 
            } else if ($(this).val() == "Area") {
                $("#branchDiv").hide();
                $("#areaDiv").show();
                $("#zoneDiv").hide();
                $("#regionDiv").hide();

                //$("#filBranch").prop('required', false);
                // $("#filArea").prop('required', true);
                // $("#filZone").prop('required', false);
                // $("#filRegion").prop('required', false);
            } else if ($(this).val() == "Zone") {
                $("#branchDiv").hide();
                $("#areaDiv").hide();
                $("#zoneDiv").show();
                $("#regionDiv").hide();

                //$("#filBranch").prop('required', false);
                // $("#filArea").prop('required', false);
                // $("#filZone").prop('required', true);
                // $("#filRegion").prop('required', false);
            } else if ($(this).val() == "Region") {
                $("#branchDiv").hide();
                $("#areaDiv").hide();
                $("#zoneDiv").hide();
                $("#regionDiv").show();

                //$("#filBranch").prop('required', false);
                // $("#filArea").prop('required', false);
                // $("#filZone").prop('required', false);
                // $("#filRegion").prop('required', true);
            }
        });
        /*end on change filReportLevel hide/show contents*/

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

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

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

        // $('#filProduct').on('change', function(){
        //     $('#filPeriod, #filDateFrom, #filDateTo').parents('.form-group').parent('div').hide('slow');
        //     var deposit_type = $("#filProduct").find(':selected').attr('type');
        //     if(deposit_type == 1 || deposit_type == 3){
        //         $('#filPeriod').parents('.form-group').parent('div').show('slow');
        //     }else{
        //         $('#filDateFrom, #filDateTo').parents('.form-group').parent('div').show('slow');
        //     }
        // });

        $(document).ready(function() {
            //$('#filPeriod, #filDateFrom, #filDateTo').parents('.form-group').parent('div').hide('slow');

            $("#printIcon").click(function(event) {
                var mainContents = document.getElementById("printDiv").innerHTML;
                var headerContents = "";
                var printStyle =
                    '<style>#pomisOne1, #pomisOne2, #pomisOne3{float:left;height:auto;padding:0px;width:100% !important;font-size:11px;border:1pt ash;page-break-inside:auto;font-family:Arial;}  thead tr th{text-align:center;vertical-align: top;padding:3px;font-size:11px} #pomisOne1 thead tr th:nth-child(1){ width: 50px;} thead tr th:nth-child(10){ width: 40px;} tbody tr td:nth-child(10){ width: 40px;} tbody tr td.amount {border: 1px solid ash;text-align:right;vertical-align: middle;padding:3px;font-size:11px} tbody tr td {border: 1px solid ash;text-align:center;vertical-align: middle;padding:3px;font-size:11px} td:nth-child(1){text-align:left;} tr{ page-break-inside:avoid; page-break-after:auto } tr:last-child { font-weight: bold;} .name{text-align:left;vertical-align:left;}</style><style media="print">@page{margin:10mm 10mm;}</style><style>@media print {.element-that-contains-table { overflow: visible !important; }}</style><style>@page:first{#pomisOne1 tr:nth-of-type(10n){page-break-after: always;}} td.name{text-align:left;}</style>';
                var printContents = '<div id="order-details-wrapper">' + headerContents + printStyle +
                    mainContents + '</div>';
                var win = window.open('', 'printwindow');
                win.document.write(printContents);
                win.print();
                win.close();
            });

            $("form").submit(function(event) {
                event.preventDefault();
                var serializeValue = $(this).serialize();

                var filDateFrom = $('#filDateFrom').val();
                if (!filDateFrom) {
                    toastr.warning("Please select from date", "Message");
                    return false;
                }

                var filDateTo = $('#filDateTo').val();
                if (!filDateTo) {
                    toastr.warning("Please select to date", "Message");
                    return false;
                }
                $('#loadingModal').show();
                $("#reportingDiv").load('{{ URL::to('provisionStatement/report') }}' + '?' +
                    serializeValue);
            });

            $('#filDate').datepicker({
                dateFormat: 'dd-mm-yy',
                changeYear: true,
                changeMonth: true,
            });

            //$('#filProduct').trigger('change');
        });
    </script>
@endsection