@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')


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


                <li class="active"><a href="" class="active"> {!! trans('assets::asset_condemnation.name') !!} Details</a></li>
            </ul>

            <div class="tab-content">

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

                    {!! Form::horizondal_open()->id('assetCondemnationReportForm')->secure()->method('POST')->files('true')->enctype('multipart/form-data') !!}
                    <div class="col-md-5 col-lg-5">

                        {!! Form::select('search[asset_condemnations.condemn_type]')->options(trans('assets::asset_condemnation.options.condemntype'))->addGroupClass('form-group-sm')->label('Condemnation Type')->placeholder('Condemnation Type')->id('condemntype_id') !!}
                        {!! Form::select('search[asset_condemnations.company_id]')->options(Company::companies(), user('admin.web')->current_comp)->disabled()->id('company_id')->addGroupClass('form-group-sm')->label('Company')->placeholder('Select Company') !!}

                        {!! Form::select('search[asset_condemnations.division_id]')->options([])->id('division_id')->addGroupClass('form-group-sm')->label('Divsion')->placeholder('Select Division') !!}
                        {!! Form::select('search[asset_condemnations.block_id]')->options([])->addGroupClass('form-group-sm')->label('Block')->placeholder('Block')->id('block_id') !!}

                        {!! Form::select('search[asset_condemnations.section_id]')->options([])->addGroupClass('form-group-sm')->label('Section')->placeholder('Section')->id('section_id') !!}
                    </div>
                    <div class="col-md-5 col-lg-5">

                        {!! Form::select('search[asset_condemnations.department_id]')->id('department_id')->options(Department::allDepartments())->placeholder(trans('assets::asset.placeholder.department_id'))->label(trans('assets::asset.label.department_id'))->addGroupClass('form-group-sm') !!}

                        {!! Form::select('search[asset_condemnations.work_department_id]')->id('work_department_id')->options(WorkDepartment::allWorkDepartments())->label(trans('assets::asset.label.work_department_id'))->placeholder(trans('assets::asset.placeholder.work_department_id'))->addGroupClass('form-group-sm') !!}

                        {!! Form::select('search[category_id]')->options(Category::allCategories())->id('category_id')->addGroupClass('form-group-sm')->label('Category')->placeholder('Category') !!}

                        {!! Form::select('search[trans_status]')->options(trans('assets::asset_condemnation.options.trans_status'))->label(trans('assets::asset_condemnation.label.trans_status'))->placeholder(trans('assets::asset_condemnation.placeholder.trans_status'))->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">
                                Ref Date
                            </label>
                            <div class="col-lg-5 col-md-3 col-sm-3">

                                {!! Form::date('search[asset_condemnations.created_at][0]')->id('report_date_from')->addClass('report_date_from')->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[asset_condemnations.created_at][1]')->id('report_date_to')->addClass('report_date_to')->addGroupClass('form-group-sm')->placeholder('To')->raw() !!}
                            </div>
                        </div>

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

                                {!! Form::date('search[asset_condemnations.condem_date][0]')->id('condemnations_date_from')->addClass('report_date_from')->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[asset_condemnations.condem_date][1]')->id('condemnations_date_to')->addClass('report_date_to')->addGroupClass('form-group-sm')->placeholder('To')->raw() !!}
                            </div>
                        </div>



                    </div>
                    <div class="col-md-2 col-lg-2">
                        <div class="m-b-20">
                            <img src="{!! URL::to('img/report/order.png') !!}">&nbsp;
                            <a id="download_report" class="headpicture" href="#">Download Report</a>
                        </div>
                        <div class="m-b-20">
                            <i class="fa fa-file-excel-o" style="color:#000;"></i>&nbsp;
                            <a id="download_csv" class="headpicture" href="#">Download Csv</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 ><a href="#tab-graph" data-toggle="tab">Graph</a></li>-->
            <!--<li><a href="#tab-summary" data-toggle="tab">Data Summary</a></li>-->
            <li class="active"><a href="#tab-full-data" data-toggle="tab">Full Data Set</a></li>
        </ul>

        <div class="tab-content">
            <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="30" colspan="3" class="form_fields_table" style="padding:5px;"><b>Filters:</b><span style="padding-left:30px;" id="filters_label"></span></td>
                        </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: 400px; height: 350px; margin: 0 auto">
                                            </div>
                                        </td>
                                    </tr>
                                </table>
                            </td>
                        </tr>
                    </table>
                </div>
            </div>
            <div style="overflow-y: scroll;">
                <div class="tab-pane" id="tab-summary">
                    <div class="table-wrapper" style="margin-left: auto; margin-right: auto;overflow-x: auto;">
                        <table width="100%" 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 active" id="tab-full-data">
                    <table id="full_listings" class="table table-striped data-table" width="100%">
                        <thead class="list_head">

                            <th>Reference No</th>
                            <th> Ref Date</th>
                            <th> Type</th>
                            <th> Condemnation Date</th>
                            <th> Asset ID</th>
                            <th> Item</th>
                            <th> Reason</th>
                            <th> Recommendation</th>
                            <th>{!! trans('assets::asset_condemnation.label.trans_status') !!}</th>
                            <th> Status Date</th>
                            <th> Company</th>
                            <th> Division</th>
                            <th> Block</th>
                            <th> Section</th>
                            <th> Department</th>
                            <th> Work Department</th>
                            <th> Category</th>
                            <th> Level 1</th>
                            <th> Level 2</th>
                            <th> Level 3</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('assets/condemnation') !!}

                                {!! 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');


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

            $('.datepick').change(function() {
                var name = $(this).attr('name');
                var end_date = name.replace('[0]', '[1]');
                var start_date = $(this).val();
                $('input[name="' + end_date + '"]')
                    .pickadate('picker')
                    .set({
                        min: new Date(start_date + ' 23:59:59'),
                        select: new Date(start_date + ' 23:59:59'),
                    })
            });


  @if(@$save_report['search']['company_id'] <> "")
    $("select[name='search[division_id]").load('{{URL::to("admin/company/accessible_divisions/employee")}}/{{@$save_report['search']['company_id']}}');
    @endif

    @if(@$save_report['search']['division_id'] <> "")
    $("select[name='search[division_id]").load('{{URL::to("admin/company/accessible_divisions/employee")}}/{{@$save_report['search']['company_id']}}/{{@$save_report['search']['division_id']}}');
    @endif

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

    $("#company_id").change(function() {
            if ($("#company_id option:selected").val() != '') {
                var company = $("#company_id option:selected").val();

            } else {
                $("#division_id").val('');
                oTable.api().draw();
                var company = 0;
            }
            $("#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();
                    $("#section_id").empty().append('<option value="">Select Section</option>');
                    var division = $("#division_id option:selected").val();
                    // $("#location_id").load('{{ URL::to('admin/location/location/location') }}'+'/'+company+'/'+division);
                    $("#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();
                if(block){
                    $("#section_id").load('{{ URL::to('admin/block/all/section/block') }}' + '/' + block);
                }
            });


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

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

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

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

            $('#resetnow').click(function() {
                $("input[name='search[work_due][0]']").val('');
                $("input[name='search[work_due][1]']").val('');
                $("input[name='search[asset_condemnations.created_at][0]']").val('');
                $("input[name='search[asset_condemnations.created_at][1]']").val('');
                $("input[name='search[status_date][0]']").val('');
                $("input[name='search[status_date][1]']").val('');
                $("input[name='search[asset_condemnations.created_at][0]']").val('');
                $("input[name='search[asset_condemnations.created_at][1]']").val('');
                $("input[name='search[asset_condemnations.condem_date][0]']").val('');
                $("input[name='search[asset_condemnations.condem_date][1]']").val('');
                $('#assetCondemnationReportForm')[0].reset();
                var filter = $("#assetCondemnationReportForm").serialize();
                //  plotGraph("{{ URL::to('admin/assets/condemnation/report/graph') }}" +'/' + filter + '');          
                $('#group_by_label').html('');
                oTable.api().draw();
            });

            

            $('#download_report').click(function() {
                var filter = $("#assetCondemnationReportForm").serialize();
                $('#download_report').attr('href',
                    "{{ URL::to('admin/assets/condemnation/report/graph/pdf') }}" + "/" + filter);
                $('#download_report').attr("target", "_blank");
            });

            $('#download_csv').click(function() {
                var filter = $("#assetCondemnationReportForm").serialize();
                $('#download_csv').attr('href',
                    "{{ URL::to('admin/assets/condemnation/report/graph/csv') }}" + "/" + filter);
                $('#download_csv').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 = $("#assetCondemnationReportForm").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: false
                },
                series: [{
                    name: 'Assigned',
                    data: []
                }, {
                    name: 'Closed',
                    data: []
                }, {
                    name: 'Completed',
                    data: []
                }, {
                    name: 'Pending',
                    data: []
                }, {
                    name: 'All',
                    data: []
                }]
            });


            oTable = $('#full_listings').dataTable({
                "bProcessing": true,
                "sDom": 'R<>rt<ilp><"clear">',
                "bServerSide": true,
                "sAjaxSource": '{!! trans_url('admin') !!}/assets/condemnation/report',
                "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()
                            });
                        }
                    );
                    $('#assetCondemnationReportForm select, #assetCondemnationReportForm 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: 'id',
                        render: function(data, type, row) {
                            return row.ref;
                            }
                    },
                    {
                        data: 'created_at'
                    },
                    {
                        data: 'condemn_type'
                    },
                    {
                        data: 'condem_date'
                    },
                    {
                        data: 'asset_rfcs'
                    },
                    {
                        data: 'item_details'
                    },
                    {
                        data: 'reasons'
                    },
                    {
                        data: 'recommendation'
                    },
                    {
                        data: 'trans_status'
                    },
                    {
                        data: 'updated_at'
                    },
                    {
                        data: 'company_id'
                    },
                    {
                        data: 'division_id'
                    },
                    {
                        data: 'block_id'
                    },
                    {
                        data: 'section_id'
                    },
                    {
                        data: 'department_id'
                    },
                    {
                        data: 'work_department_id'
                    },
                    {
                        data: 'categoryname'
                    },
                    {
                        data: 'lvl1'
                    },
                    {
                        data: 'lvl2'
                    },
                    {
                        data: 'lvl3'
                    },
                ],

                "pageLength": 25,
                "order": [[1, 'desc']]
            });

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

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

            $('.report_date_from').change(function() {
                var name = $(this).attr('name');
                var end_date = name.replace('[0]', '[1]');
                var start_date = $(this).val();
                $('input[name="' + end_date + '"]')
                    .pickadate('picker')
                    .set({
                        min: new Date(start_date + ' 23:59:59'),
                        select: new Date(start_date + ' 23:59:59'),
                    })
            });



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

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

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