@extends('admin::curd.index')
@section('heading')
@stop

@section('title')
    <img src="{!! URL::to('img/report/analytics.png') !!}"> &nbsp;{!! ucwords('Reports') !!}
@stop

@section('breadcrumb')
@stop

@section('entry')

@stop

@section('tools')
@stop

@section('content')
    <div class="box-body">
        <div class="nav-tabs-custom">

            <ul class="nav nav-tabs primary">

                <li class="active"><a href="{!! trans_url('admin/location/sub_location/report/download') !!}" class="active">Sub Location Listing </a></li>
            </ul>

            <div class="tab-content">

                <div class="tab-pane active clearfix" id="details">

                    {!! Form::horizondal_open()->id('SubLocationReportForm')->secure()->method('POST')->files('true')->enctype('multipart/form-data') !!}
                    <div class="col-md-5 col-lg-5">
                        {!! Form::select('search[company_id]')->options(Company::companies(), user('admin.web')->current_comp)->disabled()->addGroupClass('form-group-sm')->label('Company')->id('company_id')->placeholder('select company') !!}

                        {!! Form::select('search[division_id]')->options(Company::divisions())->addGroupClass('form-group-sm')->label('Division')->id('division_id')->placeholder('select Division') !!}

                        {!! Form::select('search[block_id]')->addGroupClass('form-group-sm')->label('Block')->placeholder('select Block')->id('block_id') !!}

                        {!! Form::select('search[section_id]')->addGroupClass('form-group-sm')->label('Section')->id('section_id')->placeholder('select section') !!}

                        {!! Form::select('search[location_id]')->id('location_id')->addGroupClass('form-group-sm')->label('Location')->placeholder('select Location') !!}

                    </div>
                    <div class="col-md-5 col-lg-5">
                        {!! Form::text('search[name]')->id('name')->addGroupClass('form-group-sm')->label('Sub Location')->placeholder('select Sub Location') !!}

                        {!! Form::select('search[status]')->id('status')->addGroupClass('form-group-sm')->label('Status')->placeholder('select Status')->options(trans('location::sub_location.options.status')) !!}

                        {!! Form::select('search[type]')
                        ->options(
                            ['' => 'Please select type'] +
                            trans('location::sub_location.options.type') +
                            (client_config('facility_booking.options.room_type') ?: trans('location::sub_location.options.room_type'))
                        )
                        -> label(trans('location::sub_location.label.type'))
                        -> addGroupClass('form-group-sm')!!}

                        <div class="form-group form-group-sm">
                            <label for="primary_view" class="control-label col-lg-3 col-md-6 col-sm-6">
                                Sub Location Created Date
                            </label>
                            <div class="col-lg-5 col-md-3 col-sm-3">

                                {!! Form::date('search[created_at][0]')->id('exp_date_from')->addClass('datepick')->addGroupClass('form-group-sm')->placeholder('From')->raw() !!}
                            </div>

                            <div class="col-lg-4 col-md-3 col-sm-3 m-l-0">
                                {!! Form::date('search[created_at][1]')->id('exp_date_to')->addClass('datepick_enddate')->addGroupClass('form-group-sm')->placeholder('To')->raw() !!}
                            </div>
                        </div>

                    </div>
                    <div class="col-md-2 col-lg-2">

                        <div class="m-b-20">
                            <i class="fa fa-file-excel-o" style="color:#000;"></i>&nbsp;
                            <a id="download_excel" class="headpicture" href="#">Download Excel</a>
                        </div>
                        <div class="m-b-20">                        
                            <i class="fa fa-qrcode" style="color:#000;"></i>&nbsp;
                            <a id="download_qr" class="headpicture" href="#">Download QR</a>
                        </div>

                        <div class="m-b-20">
                            <i class="fa fa-refresh" style="color:#000;"></i>&nbsp;
                            <a id="resetnow" class="headpicture" style="cursor:pointer;">Reset Filter</a>
                        </div>

                    </div>
                    <div class="col-md-10 col-lg-10">
                        <button type="button" id="gobutton" class="btn btn-success btn-sm" style="width:100%">Go</button>
                    </div>


                    {!! Form::close() !!}
                </div>
            </div>
        </div>
    </div>

    <div class="nav-tabs-custom">
        <ul class="nav nav-tabs primary">
            <li class="active"><a href="#tab-full-data" data-toggle="tab">Full Data Set</a></li>
        </ul>

        <div class="tab-content" style="width:100%">

            <div class="tab-pane" id="tab-graph">
                <div class="table-wrapper" style="margin-left: auto; margin-right: auto; overflow-x: auto;">
                    <table width="100%" align="center" cellpadding="0" cellspacing="0" id="table_1"
                        class="form_table table table-striped">
                        <tr>
                            <td colspan="2">
                                <table width="100%" bgcolor="#FFF" border="0" cellpadding="0" cellspacing="0"
                                    style="padding: 8px 0 0 0;">
                                    <tr></tr>
                                    <tr></tr>
                                    <tr>
                                        <td height="10" class="form_fields_table">&nbsp;</td>
                                        <td width="15%" height="10" colspan="-4" class="form_fields_table">&nbsp;
                                        </td>
                                        <td width="71%" height="10" colspan="-4" class="form_fields_table">&nbsp;
                                        </td>
                                    </tr>
                                    <tr>
                                        <td colspan="3" class="form_fields_table" style="padding: 10px;">
                                            <div id="chart_span" style="min-width: 100%; height: 350px; margin: 0 auto;">
                                            </div>
                                        </td>
                                    </tr>
                                </table>
                            </td>
                        </tr>
                    </table>
                </div>
            </div>

            <div class="tab-pane active" id="tab-summary">
                <div class="table-wrapper" style="margin-left: auto; margin-right: auto;overflow-x: auto;">
                    <table id="data_summary" border="0" align="center"
                        class="table table-striped display datatable data-table" cellpadding="0" cellspacing="0">
                    </table>
                </div>
            </div>
            <div class="tab-pane table-responsive active" id="tab-full-data" style="width:113%">
                <table id="full_listings" class="table table-striped data-table" width="90%">
                    <thead class="list_head">
                        <th>Company</th>
                        <th>Division</th>
                        <th>Block</th>
                        <th>Section</th>
                        <th>Location</th>
                        <th>Sub Location</th>
                        <th>Status</th>
                        <th>Type</th>
                        <th>Created Date</th>
                    </thead>
                </table>
            </div>
        </div>
    </div>

    <div class="modal fade" id="save-report">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header header">
                    <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                    <h3 class="modal-title">Save Report</h3>
                    <div class="popup_description">Type the name and save report for future use.</div>
                </div>
                <div class="modal-body" style="height:110px;">
                    <div class="form-horizontal">

                        <div class="col-md-12 col-lg-12 m-t-20">
                            {!! Form::horizontal_open()->id('report_save')->method('POST')->files('true')->action(trans_url('admin/save_report')) !!}

                            {!! Form::hidden('screen')->forceValue('sub_location') !!}

                            {!! Form::text('name')->placeholder('Enter Name')->label('Report Name')->required() !!}

                            {!! Form::close() !!}
                        </div>
                    </div>
                    <div id="resultofsave" class="searchoptiontext"> </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-primary" id="save-repot" name="Saverep" value="Send"
                        data-dismiss="modal">Save</button>
                </div>
            </div>
        </div>
    </div>

    <div class="modal fade" id="show_report">
        <div class="modal-dialog">
            <div class="modal-content" style="max-width:400px;">
                <div class="modal-header header">
                    <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                    <h4 class="modal-title">Recent Saved Searches</h4>
                </div>
                <div class="modal-body" style="height:210px; overflow-y: auto;">

                    <div id="saved-reports"></div>

                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-primary" name="Closerep" data-dismiss="modal">Close</button>
                </div>
            </div><!-- /.modal-content -->
        </div><!-- /.modal-dialog -->
    </div><!-- /.modal -->

@stop


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


        $(".datepick").pickadate({
            format: 'dd mmm, yyyy',
            formatSubmit: 'yyyy-mm-dd 00:00:00',
            hiddenSuffix: '',
            selectMonths: true,
            selectYears: true
        }).prop('type', 'text');

        $(".datepick_enddate").pickadate({
            format: 'dd mmm, yyyy',
            formatSubmit: 'yyyy-mm-dd 23:59:59',
            hiddenSuffix: '',
            selectMonths: true,
            selectYears: true
        }).prop('type', 'text');

        function formatRepo(repo) {
            if (repo.loading) return repo.name;
            var markup = "<div class='select2-result-repository clearfix'>" +
                "<div class='select2-result'><span>" + repo.name + "&nbsp;" + repo.rfc + "&nbsp;" + repo
                .bar_code + "</span></div>";

            return markup;
        }

        function formatRepoSelection(repo) {
            return repo.name;
        }


        @if (@$save_report['search']['companyid'] != '')
            $("select[name='search[divisionid]").load(
                '{{ URL::to('admin/company/division/employee') }}/{{ @$save_report['search']['companyid'] }}'
            );
        @endif

        @if (@$save_report['search']['divisionid'] != '')
            $("select[name='search[divisionid]").load(
                '{{ URL::to('admin/company/division/employee') }}/{{ @$save_report['search']['companyid'] }}/{{ @$save_report['search']['divisionid'] }}'
            );
        @endif

        $("#companyid").change(function() {
            var company = $("#companyid option:selected").val();
            $("#divisionid").load('{{ URL::to('admin/company/division/employee') }}' + '/' + company);
        });

        $('#view_report').click(function() {
            $('#saved-reports').load("{{ trans_url('admin/sub_location/save/save_report') }}");
            $('#show_report').modal("show");
        });

        $("#popup-save-report").click(function() {
            $("#name").val('');
            $("#save-report").modal('show');
        });

        $('input[id=exp_date_from]').change(function() {

            $("#exp_date_to").pickadate('picker').set({
                select: $('input[id=exp_date_from]').val(),
                min: new Date($('input[id=exp_date_from]').val())
            });
        });

        $('input[id=req_date_from]').change(function() {

            $("#req_date_to").pickadate('picker').set({
                select: $('input[id=req_date_from]').val(),
                min: new Date($('input[id=req_date_from]').val())
            });
        });

        $('input[id=work_due_from]').change(function() {

            $("#work_due_to").pickadate('picker').set({
                select: $('input[id=work_due_from]').val(),
                min: new Date($('input[id=work_due_from]').val())
            });
        });

        $('input[id=compl_date_from]').change(function() {

            $("#compl_date_to").pickadate('picker').set({
                select: $('input[id=compl_date_from]').val(),
                min: new Date($('input[id=compl_date_from]').val())
            });
        });


        $('#resetnow').click(function() {
            $("input[name='search[created_at][0]']").val('');
            $("input[name='search[created_at][1]']").val('');
            $('#SubLocationReportForm')[0].reset();
            // $('#status').val(Object.keys(defaultOptions));
            $('.select2-selection__rendered').html('');

            var filter = $("#SubLocationReportForm").serialize();
            plotGraph("{{ URL::to('admin/location/report/graph') }}" + '/' + filter);

            $('#group_by_label').html('');
            oTable.api().draw();

            $('#status').trigger('change');
            // togglesubwork();
        });

        $('#download_excel').click(function() {
            var filter = $("#SubLocationReportForm").serialize();
            $('#download_excel').attr('href',
                "{{ URL::to('admin/location/sub_location/report/download/graph/excel') }}" + "/" +
                filter);
            $('#download_excel').attr("target", "_blank");
        });
        $('#download_qr').click(function() {
            var filter = $("#SubLocationReportForm").serialize();
            $('#download_qr').attr('href',
                "{{ URL::to('admin/location/sub_location/report/download/graph/qr') }}" + "/" +
                filter);
            $('#download_qr').attr("target", "_blank");
        });


        $('#save-repot').click(function(e) {
            if ($("#report_save").valid() == false) {
                toastr.error('Please enter valid information.', 'Error');
                return false;
            }
            var postData = $("#report_save").serialize();
            var chartData = $("#SubLocationReportForm").serialize();
            var formURL = "{{ trans_url('admin/save_report') }}";
            $.ajax({
                url: formURL,
                type: "POST",
                data: {
                    data: postData,
                    data1: chartData
                },
                success: function(data, textStatus, jqXHR) {},
                error: function(jqXHR, textStatus, errorThrown) {
                    toastr.error('An error occurred while saving.', 'Error');
                    console.log(jqXHR);
                    console.log(textStatus);
                    console.log(errorThrown);
                }
            });

            e.preventDefault();
        });

        // chart = new Highcharts.Chart({
        //     chart: {
        //         renderTo: 'chart_span',
        //         type: 'column'
        //     },
        //     title: {
        //         text: ''
        //     },
        //     credits: {
        //         enabled: false
        //     },
        //     xAxis: {
        //         categories: [],
        //         labels: {
        //             rotation: -55,
        //             align: 'right',
        //             style: {
        //                 fontSize: '11px',
        //                 fontFamily: 'Roboto, sans-serif'
        //             }
        //         }
        //     },
        //     yAxis: {
        //         title: {
        //             text: 'Value'
        //         },
        //         plotLines: [{
        //             value: 0,
        //             width: 2,
        //             color: '#808080'
        //         }]
        //     },
        //     tooltip: {
        //         formatter: function() {
        //             return '' +
        //                 this.series.name + ': ' + this.y + '';
        //         }
        //     },
        //     credits: {
        //         enabled: false
        //     },
        //     exporting: {
        //         enabled: true
        //     },
        //     series: [{
        //             name: 'Pending',
        //             data: []
        //         },
        //         {
        //             name: 'Assigned',
        //             data: []
        //         },
        //         {
        //             name: 'Accepted',
        //             data: []
        //         },
        //         {
        //             name: 'WIP',
        //             data: []
        //         },
        //         {
        //             name: 'Cancelled By User',
        //             data: []
        //         },
        //         {
        //             name: 'Completed',
        //             data: []
        //         }, {
        //             name: 'All',
        //             data: []
        //         }
        //     ]
        // });


        oTable = $('#full_listings').dataTable({
            "bProcessing": true,
            "sDom": 'R<>rt<ilp><"clear">',
            "bServerSide": true,
            "sAjaxSource": '{!! trans_url('admin') !!}/location/sub_location/report/download',
            "fnServerData": function(sSource, aoData, fnCallback) {

                $('#full_listings .search_bar input, #full_listings .search_bar select').each(
                    function() {

                        aoData.push({
                            'name': $(this).attr('name'),
                            'value': $(this).val()
                        });
                    }
                );
                $('#SubLocationReportForm select, #SubLocationReportForm input').each(
                    function() {
                        if ($(this).val() == null || $(this).val() == '') {
                            return;
                        }
                        aoData.push({
                            'name': $(this).attr('name'),
                            'value': $(this).val()
                        });
                    }
                );

                app.dataTable(aoData);
                $.ajax({
                    'dataType': 'json',
                    'data': aoData,
                    'type': 'GET',
                    'url': sSource,
                    'success': fnCallback
                });
            },

            "columns": [

                {
                    data: 'company_id'
                },
                {
                    data: 'division_code'
                },

                {
                    data: 'block_code'
                },
                {
                    data: 'section_code'
                },
                {
                    data: 'location_code'
                },
                {
                    data: 'sub_location_code'
                },
                {
                    data: 'status'
                },
                {
                    data: 'type'
                },
                {
                    data: 'created_at'
                },

            ],

            "pageLength": 25
        });

        $("#company_id").change(function(){
            var company = $("#company_id option:selected").val();
            $("#division_id").load('{{URL::to("/admin/company/accessible_divisions/employee")}}'+'/'+company);
        });

        $("#company_id,#division_id").change(function() {
            if ($("#company_id").val() != '' && $("#division_id option:selected").val() != '') {
                var company = $("#company_id").val();
                var division = $("#division_id option:selected").val();
                $("#section_id").empty().append('<option value="">Select Section</option>');
                $("#block_id").load('{{ URL::to('admin/block/all/block/block') }}' + '/' + company + '/' +
                    division);
            } else {
                $("#location_id").val('');
                $("#block_id").val('');
                var company = 0;
                var division = 0;
            }
        });
        
        $("#block_id").change(function() {
            var block = $("#block_id option:selected").val();
            $("#section_id").empty().append('<option value="">Select Section</option>');
            if(block){
                $("#section_id").load('{{ URL::to('admin/block/all/section/block') }}' + '/' + block);
            }
        });
        

        $("#company_id,#division_id,#block_id,#section_id").change(function() {
            if ($("#company_id").val() != '' && $("#division_id option:selected").val() != '' && $(
                    "#block_id option:selected").val() != '' && $("#section_id option:selected")
                .val() != '') {
                var company = $("#company_id").val();
                var division = $("#division_id option:selected").val();
                var block = $("#block_id option:selected").val();
                var section = $("#section_id option:selected").val();
                $("#location_id").load('{{ URL::to('admin/location/all/location/location') }}' + '/' +
                    company + '/' + division + '/' + block + '/' + section);
            } else {
                $("#location_id").val('');
                var company = 0;
                var division = 0;
            }
        });
        $("#location_id").change(function(){
    var location = $("#location_id option:selected").val();
    $("#name").load('{{URL::to("admin/location/sub_location/location")}}'+'/'+location);
    }); 

        $(document.body).on('click', "#gobutton", function(e) {
            e.preventDefault();
            // chart.showLoading();
            var filter = $("#SubLocationReportForm").serialize();
            var filter_label = '';
            var comma = '';
            $("#SubLocationReportForm select, #SubLocationReportForm input").each(function() {
                if ($(this).val() != '' || $(this).val() != null) {
                    filter_label += comma + ' ' + $('#' + $(this).attr('id') + ' :selected')
                        .text();
                    comma = ',';
                }
            });

            plotGraph("{{ URL::to('admin/location/sub_location/report/graph') }}" + '/' + filter +
                '');
            $('#full_listings .search_bar').find("." + $(this).attr('id')).prop('disabled', true);
            oTable.api().draw();
        });
    });

    function plotGraph(url) {

        $(".datepick").pickadate({
            format: 'dd mmm, yyyy',
            formatSubmit: 'yyyy-mm-dd',
            hiddenSuffix: '',
            selectMonths: true,
            selectYears: true
        }).prop('type', 'text');

    }
</script>

<style type="text/css">
    .header {
        background: #3c8dbc;
        color: white;
    }

</style>