@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') !!}/asset_audit/report" class="active">Asset Audits</a></li>
            </ul>

            <div class="tab-content">

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

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

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

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

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

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

                        {!! Form::select('search[assets.sublocation_id]')->options([])->addGroupClass('form-group-sm')->label('Sublocation')->placeholder('Sublocation')->id('sublocation_id') !!}

                        {!! Form::select('search[asset_audit_histories.sublocation_id]')->options([])->addGroupClass('form-group-sm')->label('Audited Sublocation')->placeholder('Sublocation')->id('asset_audited_sublocation_id') !!}

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

                        {!! Form::select('search[assets.subcategory_id]')->id('subcategory_id')->options([])->addGroupClass('form-group-sm')->label('Subcategory')->placeholder('Subcategory') !!}

                        <div id="subclass" style="display:block">
                            {!! Form::select('search[assets.subclass_id]')->options(Category::subclasses())->id('subclass_id')->addGroupClass('form-group-sm')->label('Subclass')->placeholder('select Subclass') !!}
                        </div>

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

                                {!! Form::date('search[assets.purchase_date][0]')->id('purchase_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[assets.purchase_date][1]')->id('purchase_date_to')->addClass('datepick_enddate')->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">
                                Invoice Date
                            </label>
                            <div class="col-lg-5 col-md-3 col-sm-3">

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

                        {!! Form::text('search[assets.po_number]')->id('po_number')->placeholder(trans('Enter P.O number'))->label('P.O number')-> addGroupClass('form-group-sm') !!}

                    </div>
                    <div class="col-md-5 col-lg-5">
                        {{-- {!! Form::select('search[groupby]')->options([
                                'user_id' => 'Audited User',
                                'asset_audit_id' => 'Asset Audit',
                                'department_id' => 'Department',
                                'custodian_id' => 'Custodian',
                                'used_by' => 'Used By',
                                'po_number' => 'PO Number',
                                'purchase_jvno' => 'PV Number',
                                'category_id' => 'Category',
                                'subcategory_id' => 'Subcategory',
                                'division_id' => 'Division',
                                'block_id'=> 'Block',
                                'section_id' => 'Section',
                                'location_id' => 'Location',
                                'sublocation_id' => 'Sublocation'
                            ])->addGroupClass('form-group-sm')->select('assets.subcategory_id')->label('Group By')->placeholder('Select') !!} --}}
                            
                        {!! Form::select('search[assets.supplier_id]')->options([])->id('supplier_id')->addGroupClass('form-group-sm')->label('Supplier')->placeholder('Supplier') !!}

                        {!! Form::select('search[assets.used_by]')->options([])->id('employee_id')->addGroupClass('form-group-sm')->label('Used By')->placeholder('Used By') !!}

                        {!! Form::select('search[assets.manufacturer_id]')->options(Manufacturer::manufacturer())->addGroupClass('form-group-sm')->label('Manufacturer')->placeholder('Select Manufacturer')->id('manufacturer_id') !!}

                        {!! Form::text('search[assets.model_make]')->id('model_make')->label('Model Make')->placeholder('Enter Model Make')->addGroupClass('form-group-sm') !!}

                        {!! Form::select('search[assets.custodian_id]')->options([])->id('custodian_id')->addGroupClass('form-group-sm')->label('Custodian')->placeholder('Custodian') !!}

                        {!! Form::select('search[assets.department_id]')->options(Department::allDepartments())->addGroupClass('form-group-sm')->label('Department')->placeholder('Department')->id('department_id') !!}
                        {!! Form::select('search[assets.work_department_id]')->options(WorkDepartment::allWorkDepartments())->addGroupClass('form-group-sm')->label('Work Department')->placeholder('Work Department')->id('work_department_id') !!}
                       
                        {!! Form::select('search[assets.category_id]')->options(Category::allCategories())->id('asset_category_id')->addGroupClass('form-group-sm')->label('Asset Category')->placeholder('Asset Category') !!}
                       
                        {!! Form::select('search[asset_audit_id]')->options(AssetAudit::assetauditsref())->id('asset_audit_id')->placeholder(trans('Audit ref no'))->label('Audit ref no')-> 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">
                                Audited Date
                            </label>
                            <div class="col-lg-5 col-md-3 col-sm-3">

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

                        {!! Form::text('search[assets.name]')->id('name')->label('Asset Name')->placeholder('Enter Asset Name')->addGroupClass('form-group-sm') !!}
                        {!! Form::text('search[assets.bar_code]')->id('barcode')->label('Barcode')->placeholder('Enter Barcode')->addGroupClass('form-group-sm') !!}
                        {!! Form::text('search[assets.rfc]')->id('rfc')->label('Asset ID')->placeholder('Enter Asset ID')->addGroupClass('form-group-sm') !!}
                    </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;&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 class="active"><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 active" 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 table-responsive active" id="tab-full-data">
                <table id="full_listings" class="table table-striped data-table" width="100%">
                    <thead class="list_head">
                        <th>Ref</th>
                        <th>Audit Name</th>
                        <th>Start Date</th>
                        <th>End Date</th>
                        <th>Audited At</th>
                        <th>Audited Category</th>
                        <th>Audited User</th>
                        <th>Asset Category</th>
                        <th>Asset Name</th>
                        <th>Barcode</th>
                        <th>Asset ID</th>
                        <th>Division</th>
                        <th>Block</th>
                        <th>Section</th>
                        <th>Location</th>
                        <th>Sublocation</th>
                        <th>Department</th>
                        <th>Audited Sublocation</th>
                        <th>Custodian</th>
                        <th>Used By</th>
                        <th>PO Number</th>
                        <th>Serial Number</th>
                        <th>JV Number</th>
                        <th>Invoice Number</th>
                        <th>Invoice 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('asset') !!}

                            {!! 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 Reports</h4>
                </div>
                <div class="modal-body" style="height:210px; overflow-y: auto;">
                    <div id="saved-reports">
                        <p class="text-muted">Processing ....</p>
                    </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).ajaxComplete(function() {
        $("form[id$='-create2'] :input").prop("disabled", false);
        $("form[id$='-create3'] :input").prop("disabled", false);
        $(".del-btn").prop("disabled", false);
    });
    $(document).ready(function() {
        var originalOptions = $('#subclass_id').html();
        $("#employee_id").select2({
            ajax: {
                url: "{{ trans_url('admin/company/list/division/employee/all') }}",
                dataType: 'json',
                delay: 250,
                data: function(params) {
                    return {
                        q: params.term, // search term
                        companyId: {!! user('admin.web')->current_comp !!},
                        page: params.page
                    };
                },
                processResults: function(data, params) {

                    params.page = params.page || 1;
                    return {
                        results: data.items,
                        pagination: {
                            more: (params.page * 30) < data.total_count
                        }
                    };
                },
                cache: false,
            },
            escapeMarkup: function(markup) {
                return markup;
            }, // let our custom formatter work

            templateResult: formatRepo5, // omitted for brevity, see the source of this page
            templateSelection: formatRepo5Selection // omitted for brevity, see the source of this page
        });

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

            return markup;
        }


        function formatRepo5Selection(repo) {
            return repo.name ? repo.name : repo.text;

        }

        $("#supplier_id").select2({
            // minimumInputLength: 2,
            allowClear: true,
            placeholder: 'Select Supplier',
            ajax: {
                url: "{{ trans_url('admin/supplier/allSelect2') }}",
                dataType: 'json',
                delay: 250,
                data: function(params) {
                    return {
                        q: params.term, // search term
                        companyId: {!! user('admin.web')->current_comp !!},
                        page: params.page
                    };
                },
                processResults: function(data, params) {

                    params.page = params.page || 1;
                    return {
                        results: data.items,
                        pagination: {
                            more: (params.page * 30) < data.total_count
                        }
                    };
                },
                cache: true
            },
            escapeMarkup: function(markup) {
                return markup;
            }, // let our custom formatter work
            initSelection: function(element, callback) {
                callback({
                    id: "{{ @$asset->supplier_id }}",
                    name: "{{ @$asset->supplier->name }}"
                });
            },
            templateResult: formatRepo5, // omitted for brevity, see the source of this page
            templateSelection: formatRepo5Selection // omitted for brevity, see the source of this page
        });

        $("#custodian_id").select2({
            ajax: {
                url: "{{ trans_url('admin/company/list/division/employee/all') }}",
                dataType: 'json',
                delay: 250,
                data: function(params) {
                    return {
                        q: params.term, // search term
                        companyId: {!! user('admin.web')->current_comp !!},
                        page: params.page
                    };
                },
                processResults: function(data, params) {

                    params.page = params.page || 1;
                    return {
                        results: data.items,
                        pagination: {
                            more: (params.page * 30) < data.total_count
                        }
                    };
                },
                cache: false,
            },
            escapeMarkup: function(markup) {
                return markup;
            }, // let our custom formatter work

            templateResult: formatRepo5, // omitted for brevity, see the source of this page
            templateSelection: formatRepo5Selection // omitted for brevity, see the source of this page
        });

        $("#sublocation_id").select2({
            // minimumInputLength: 2,
            allowClear: true,
            placeholder: 'Select Sub Location',
            ajax: {
                url: "{{ trans_url('admin/location/all/sub_location/select2/location') }}",
                dataType: 'json',
                delay: 250,
                data: function(params) {
                    return {
                        q: params.term, // search term
                        companyId: $('#company_id').val(),
                        divisionId: $('#division_id').val(),
                        blockId: $('#block_id').val(),
                        sectionId: $('#section_id').val(),
                        locationId: $('#location_id').val(),
                        page: params.page
                    };
                },
                processResults: function(data, params) {

                    params.page = params.page || 1;
                    return {
                        results: data.items,
                        pagination: {
                            more: (params.page * 30) < data.total_count
                        }
                    };
                },
                cache: false,
            },
            escapeMarkup: function(markup) {
                return markup;
            }, // let our custom formatter work

            templateResult: formatRepo3, // omitted for brevity, see the source of this page
            templateSelection: formatRepo3Selection // omitted for brevity, see the source of this page
        });

        function formatRepo3(repo) {
            if (repo.loading) {
                return repo.name;
            }
            var markup = '';
            var section = $('#section_id').val();
            if (!section) {
                markup = "<div class='select2-result-repository clearfix'>" +
                    "<div class='select2-result'><span class='badge' style='white-space: initial;'>" +
                    repo.block_name + '->' + repo.section_name + '->' + repo.location_name +
                    "</span></br><span>" +
                    repo.name + "&nbsp;" + repo.code + "</span></div>";

            } else {
                markup = "<div class='select2-result-repository clearfix'>" +
                    "<div class='select2-result'><span>" + repo.name + "&nbsp;(" + repo.code + ")</span></div>";
            }

            return markup;
        }


        function formatRepo3Selection(repo) {
            return repo.name ? repo.name : repo.text;
        }

        $("#asset_audited_sublocation_id").select2({
            // minimumInputLength: 2,
            allowClear: true,
            placeholder: 'Select Sub Location',
            ajax: {
                url: "{{ trans_url('admin/location/sub_location/select2/location') }}",
                dataType: 'json',
                delay: 250,
                data: function(params) {
                    return {
                        q: params.term, // search term
                        page: params.page
                    };
                },
                processResults: function(data, params) {

                    params.page = params.page || 1;
                    return {
                        results: data.items,
                        pagination: {
                            more: (params.page * 30) < data.total_count
                        }
                    };
                },
                cache: false,
            },
            escapeMarkup: function(markup) {
                return markup;
            }, // let our custom formatter work

            templateResult: formatRepo4, // omitted for brevity, see the source of this page
            templateSelection: formatRepo4Selection // omitted for brevity, see the source of this page
        });

        function formatRepo4(repo) {
            if (repo.loading) {
                return repo.name;
            }
            var markup = '';
            markup = "<div class='select2-result-repository clearfix'>" +
                    "<div class='select2-result'><span class='badge' style='white-space: initial;'>" +
                    repo.block_name + '->' + repo.section_name + '->' + repo.location_name +
                    "</span></br><span>" +
                    repo.name + "&nbsp;" + repo.code + "</span></div>";

            return markup;
        }


        function formatRepo4Selection(repo) {
            return repo.name ? repo.name : repo.text;
        }


        $('#sublocation_id').change(function() {

            if ($('#division_id').children(
                    ":selected")
                .val() === "" || $('#block_id').children(":selected").val() === "" || $('#section_id')
                .children(
                    ":selected").val() === "" || $('#location_id').children(":selected").val() === "") {
                var id = $(this).val();
                $.ajax({
                    type: 'POST',
                    url: "{{ URL::to('admin/location/sub_location/sub_location/data') }}",
                    data: "id=" + id,
                    dataType: 'html',
                    success: function(data, textStatus, jqXHR) {
                        var result = JSON.parse(data);

                        $("#division_id").load(
                            '{{ URL::to('/admin/company/accessible_divisions/employee') }}/' +
                            result.company_id + '/' + result.division_id);
                        $("#block_id").load('{{ URL::to('admin/block/block/block') }}/' +
                            result
                            .company_id + '/' + result.division_id + '/' + result
                            .block_id);
                        $("#section_id").load(
                            '{{ URL::to('admin/block/section/block') }}/' + result
                            .block_id + '/' + result.section_id);

                        $("#location_id").load(
                            '{{ URL::to('admin/location/location/location') }}/' +
                            result.company_id + '/' + result.division_id + '/' + result
                            .block_id +
                            '/' + result.section_id + '/' + result.location_id);

                    },
                    error: function(jqXHR, textStatus, errorThrown) {

                    }
                });
            }
            var jqThis = $(this);
            if (jqThis.data("prev") != jqThis.val() && typeof jqThis.data("prev") !== "undefined") {
                $('#asset_id').empty();

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

        var filter = $("#assetAuditReportForm").serialize();
        // plotGraph("{{ URL::to('admin/asset_audit/report/graph') }}" + '/' + filter + '');
        
        $('#resetnow').click(function() {
            $("input[name='search[assets.invoice_date][0]']").val('');
            $("input[name='search[assets.invoice_date][1]']").val('');

            $("input[name='search[assets.purchase_date][0]']").val('');
            $("input[name='search[assets.purchase_date][1]']").val('');

            $("input[name='search[asset_audit_histories.created_at][0]']").val('');
            $("input[name='search[asset_audit_histories.created_at][1]']").val('');

            $('.select2-selection__rendered').html('');

            $('#assetAuditReportForm')[0].reset();
            $('#division_id').val('').trigger('change');
            $('#block_id').empty().append('<option value="" disabled selected>Block</option>');
            $('#section_id').empty().append('<option value="" disabled selected>Section</option>');
            $('#location_id').empty().append('<option value="" disabled selected>Location</option>');
            $('#sublocation_id').empty().append('<option value="" disabled selected>Select Sublocation</option>');
            $('#asset_audited_sublocation_id').empty().append('<option value="" disabled selected>Select Sublocation</option>');
            $('#subcategory_id').empty().append('<option value="" disabled selected> Subcategory</option>');
      
            $('#subclass_id').html(originalOptions).val(null).trigger('change');
            var filter = $("#assetAuditReportForm").serialize();
            // plotGraph("{{ URL::to('admin/asset_audit/report/report/graph') }}" + '/' + filter +
            //     '');
            oTable.api().draw();
        });

        $('#download_report').click(function() {
            var filter = $("#assetAuditReportForm").serialize().replaceAll("%2F", "%252F");
            $('#download_report').attr('href',
                "{{ URL::to('admin/asset_audit/report/graph/pdf') }}" + "/" + filter);
            $('#download_report').attr("target", "_blank");
        });

        $('#download_csv').click(function() {
            var filter = $("#assetAuditReportForm").serialize().replaceAll("%2F", "%252F");
            $('#download_csv').attr('href',
                "{{ URL::to('admin/asset_audit/report/graph/csv') }}" + "/" + filter);
            $('#download_csv').attr("target", "_blank");
        });

        oTable = $('#full_listings').dataTable({
            "bProcessing": true,
            "sDom": 'R<>rt<ilp><"clear">',
            "bServerSide": true,
            "sAjaxSource": '{!! trans_url('admin') !!}/asset_audit/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()
                        });
                    }
                );
                $('#assetAuditReportForm select, #assetAuditReportForm 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: 'asset_audit_id'
                },
                {
                    data: 'asset_audits.name',
                    render: function(data, type, row) {
                    return row.audit_name;
                    }
                },
                {
                    data: 'start_date'
                },
                {
                    data: 'end_date'
                },
                {
                    data: 'created_at'
                },
                {
                    data: 'asset_audits.category_id',
                    render: function(data, type, row) {
                    return row.category_id;
                    }
                },
                {
                    data: 'user_id'
                },
                {
                    data: 'asset_category_name'
                },
                {
                    data: 'asset_name'
                },
                {
                    data: 'bar_code'
                },
                {
                    data: 'rfc'
                },
                {
                    data: 'assets.division_id',
                    render: function(data, type, row) {
                    return row.division_name;
                    }
                },
                {
                    data: 'assets.block_id',
                    render: function(data, type, row) {
                    return row.block_name;
                    }
                },
                {
                    data: 'assets.section_id',
                    render: function(data, type, row) {
                    return row.section_name;
                    }
                },
                {
                    data: 'location_id'
                },
                {
                    data: 'assets.sublocation_id',
                    render: function(data, type, row) {
                        return row.asset_sublocation_id;
                    }
                },
                {
                    data: 'department_id'
                },
                {
                    data: 'sublocation_id',
                    render: function(data, type, row) {
                    return row.audit_sublocation_id;
                    }
                },
                {
                    data: 'custodian_id'
                },
                {
                    data: 'used_by'
                },
                {
                    data: 'po_number'
                },
                {
                    data: 'serial_no'
                },
                {
                    data: 'purchase_jvno'
                },
                {
                    data: 'invoice_number'
                },
                {
                    data: 'invoice_date'
                }
            ],
            "columnDefs": [{
                "orderable": false,
            }],

            "pageLength": 25,
            aaSorting: [[4, 'desc']]
        });


        $(document.body).on('click', "#gobutton", function(e) {
            e.preventDefault();
            // chart.showLoading();
            var filter = $("#assetAuditReportForm").serialize().replaceAll("%2F", "%252F");

            var filter_label = '';
            var comma = '';
            $("#assetAuditReportForm select, #assetAuditReportForm input").each(function() {
                if ($(this).val() != '' || $(this).val() != null) {
                    filter_label += comma + ' ' + $('#' + $(this).attr('id') + ' :selected')
                        .text();
                    comma = ',';
                }
            });

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

        $(".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');
        var company = {{ user('admin.web')->current_comp }}
        var division = {{user('admin.web')->division_id}}
      
        // on change .datepick change .datepick_enddate min date for that date field only check by name
        $('.datepick').change(function(){
            var name = $(this).attr('name');
            // name will be search[created_at][0] and we need to change search[created_at][1]
            var end_date = name.replace('[0]','[1]');
            // get the value of start date
            var start_date = $(this).val();
            // set the min date for end date and set it also add 23:59:59 to it
            $('input[name="'+end_date+'"]')
            .pickadate('picker')
            .set({ 
            min: new Date(start_date + ' 23:59:59'),
            select: new Date(start_date + ' 23:59:59'),
            })
        });

        $("#category_id").change(function(){		
            $("#subclass_id").empty().append('<option value="">Select Subclass</option>');
            var category = $("#category_id option:selected").val();
            $("#subcategory_id").load('{{URL::to("admin/category/all/subcategory")}}'+'/'+category);
        });    

        $("#subcategory_id").change(function(){
            $("#subclass_id").empty().append('<option value="">Select Subclass</option>');
            var subcategory = $("#subcategory_id option:selected").val();  
            if (subcategory)
            {         
                $("#subclass_id").load('{{URL::to('admin/category/all/subclass')}}'+'/'+subcategory);
            }
        });  

        $("#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()!=''){
                $("#section_id").empty().append('<option value="">Select Section</option>');
                $("#sublocation_id").empty().append('<option value="">Select Sublocation</option>');
                var company = $("#company_id").val();
                var division = $("#division_id option:selected").val();
                $("#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);
            }
        });

        $("#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()!='')
            {
                // alert("changed");
                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();
            $("#sublocation_id").load('{{URL::to("admin/location/all/sub_location/location")}}'+'/'+location);
        });  
    });

</script>

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