@extends('layouts/microfin_layout')
@section('title', '| MRA LLP Report-01')
@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;
        }

        .ui-datepicker-calendar {
            display: none;
        }
    </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;">
                                Loan Classification Chart-5
                            </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 (count($branchList) > 1)
                                        <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>
                                    @endif

                                    <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 required']) !!}
                                            </div>
                                            <div class="col-md-12">
                                                {!! Form::select('filBranch', ['' => 'All'] + $branchList, null, [
                                                    'id' => 'filBranch',
                                                    'class' => 'form-control input-sm',
                                                    'autocomplete' => 'off',
                                                ]) !!}
                                            </div>
                                        </div>
                                    </div>

                                    <div class="col-md-2">
                                        <div class="form-group">
                                            <div class="col-md-12">
                                                {!! Form::label('scTypes', 'Service Charge:', ['class' => 'control-label pull-left required']) !!}
                                            </div>
                                            <div class="col-md-12">
                                                <select id="scTypes" name="scTypes" class="form-control input-sm">
                                                    @foreach ($scTypes as $k => $scType)
                                                        <option value="{{ $k }}">{{ $scType }}</option>
                                                    @endforeach
                                                </select>
                                            </div>
                                        </div>
                                    </div>


                                    <div class="col-md-2">
                                        <div class="form-group">
                                            <div class="col-md-12">
                                                {!! Form::label('loanTypes', 'Loan Type:', ['class' => 'control-label pull-left']) !!}
                                            </div>
                                            <div class="col-md-12">
                                                {!! Form::select('loanTypes', $loanTypes, null, [
                                                    'id' => 'loanTypes',
                                                    'class' => 'form-control input-sm',
                                                    'autocomplete' => 'off',
                                                ]) !!}
                                            </div>
                                        </div>
                                    </div>


                                    <div class="col-md-1">
                                        <div class="form-group">
                                            <div class="col-md-12">
                                                {!! Form::label('filFund', 'Fund:', ['class' => 'control-label pull-left']) !!}
                                            </div>
                                            <div class="col-md-12">
                                                {!! Form::select('filFund', $fundingOrgList, null, [
                                                    'id' => 'filFund',
                                                    'class' => 'form-control input-sm',
                                                    'autocomplete' => 'off',
                                                ]) !!}
                                            </div>
                                        </div>
                                    </div>

                                    <div class="col-md-2">
                                        <div class="form-group">
                                            <div class="col-md-12">
                                                {!! Form::label('filMonth', 'Select Month:*', ['class' => 'control-label pull-left']) !!}
                                            </div>
                                            <div class="col-md-12">
                                                {!! Form::text('filMonth', null, [
                                                    'id' => 'filMonth',
                                                    'class' => 'form-control input-sm',
                                                    'autocomplete' => 'off',
                                                    'readonly',
                                                    'style' => 'cursor:pointer',
                                                ]) !!}
                                                <p id='filMonthE' style="max-height:3px; color:red;"></p>
                                            </div>
                                        </div>
                                    </div>



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

                                    <div class="col-md-1">
                                        <div class="form-group">
                                            <div class="col-md-12">
                                                {!! Form::label('', '0(Zero) Amount:', ['class' => 'control-label pull-left']) !!}
                                            </div>
                                            <div class="col-md-12">
                                                {!! Form::select('fillWithZero', ['1' => 'Yes', '2' => 'No'], null, [
                                                    'id' => 'fillWithZero',
                                                    'class' => 'form-control input-sm',
                                                    'autocomplete' => 'off',
                                                    'required',
                                                ]) !!}
                                            </div>
                                        </div>
                                    </div>

                                    <div class="col-md-1">
                                        <div class="form-group">
                                            <div class="col-md-12">
                                                {!! Form::label('', 'Is Round Up?:', ['class' => 'control-label pull-left']) !!}
                                            </div>
                                            <div class="col-md-12">
                                                {!! Form::select('filRoundUup', ['1' => 'Yes', '2' => 'No'], null, [
                                                    'id' => 'filRoundUup',
                                                    'class' => 'form-control input-sm',
                                                    'autocomplete' => 'off',
                                                    'required',
                                                ]) !!}
                                            </div>
                                        </div>
                                    </div>


                                </div>

                                <div class="col-md-12">
                                    <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' => 'LLP(Required)', '2' => 'Branch Code'], [1,2], [
                                                    '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">
        var csrf = "{{ csrf_token() }}";
        $("#filMonth").datepicker({
            dateFormat: 'mm-yy',
            changeMonth: true,
            changeYear: true,
            showButtonPanel: true,
            onClose: function(dateText, inst) {
                var month = $("#ui-datepicker-div .ui-datepicker-month :selected").val();
                var year = $("#ui-datepicker-div .ui-datepicker-year :selected").val();
                $(this).val($.datepicker.formatDate('mm-yy', new Date(year, month, 1)));
            }
        });

        $(document).ready(function() {

            $("#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="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 filMonth = $('#filMonth').val();

                if (!filMonth) {
                    toastr.warning("Please select month", "Message");
                    return false;
                }
                $('#loadingModal').show();
                $("#reportingDiv").load('{{ URL::to('mfn/mraLlpFive/report') }}' + '?' + serializeValue);
            });

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

            //$('#filProduct').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*/
    </script>
@endsection