@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="" class="active"> Expense Report</a></li>
            </ul>

            <div class="tab-content">

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


                    {!! Form::horizondal_open()->id('vehiclebookingreportform')->secure()->method('POST')->files('true')->enctype('multipart/form-data') !!}


                    <div class="col-md-5 col-lg-5">
                        {!! Form::select('search[vehicle_bookings.vehicle_id]')->options([])->id('vehicle_id')->addGroupClass('form-group-sm')->label('Vehicle')->placeholder('select Vehicle') !!}
                        {!! Form::select('search[vehicle_booking_expenses.supplier_id]')->options([])->label(trans('Supplier'))->id('supplier_id')->required()->placeholder('Please select supplier')->addGroupClass('form-group-sm') !!}
                        {!! Form::select('search[assets.subcategory_id]')->options(Category::motorSubcategories())->label(trans('Sub Categories'))->id('subcategory_id')->required()->placeholder('Please select subcategory')->addGroupClass('form-group-sm') !!}
                        {!! Form::select('search[expense_type]')->options(trans('vehicle_booking::vehicle_booking.options.expense_types'))->required()->addGroupClass('form-group-sm')->label('Expense Type')->placeholder('Select Expense Type') !!}
                    </div>

                    <div class="col-md-5 col-lg-5">
                        {!! Form::select('search[vehicle_booking_expenses.driver_id]')->options([])->id('user_id')->placeholder('Driver Name')->label(trans('Driver Name'))->addGroupClass('form-group-sm') !!}
                        @if (user('admin.web')->currentCompany->requirement_type == 1)		
                            {!! Form::select('search[vehicle_bookings.requirement_type]')->options(trans('vehicle_booking::vehicle_booking.options.requirement_type'))->id('requirement_type')->addGroupClass('form-group-sm')->label('Requirement Type')->placeholder('Select Requirement Type') !!}
                        @endif
                        <div class="form-group form-group-sm">
                            <label for="primary_view" class="control-label col-lg-3 col-md-6 col-sm-6">
                                Quantity
                            </label>
                            <div class="col-lg-5 col-md-3 col-sm-3">

                                {!! Form::numeric('search[vehicle_booking_expenses.qty][0]')->id('qty_from')->addGroupClass('form-group-sm')->placeholder('From')->raw() !!}
                            </div>

                            <div class="col-lg-4 col-md-3 col-sm-3 m-l-0">
                                {!! Form::numeric('search[vehicle_booking_expenses.qty][1]')->id('qty_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">
                                From Date
                            </label>
                            <div class="col-lg-4 col-md-2 col-sm-6 p-b-10">
                                {!! Form::date('search[vehicle_booking_expenses.created_at][0]')->id('date_from')->addGroupClass('form-group-sm')->placeholder('Date')->label('From Date')->raw()->addClass('start_datepick') !!}
                            </div>
                            <label for="primary_view" class="control-label col-lg-1 col-md-2 col-sm-6">
                                To
                            </label>
                            <div class="col-lg-4 col-md-2 col-sm-6 m-l-0">
                                {!! Form::date('search[vehicle_booking_expenses.created_at][1]')->id('date_to')->addGroupClass('form-group-sm')->placeholder('To Date')->label('To Date')->raw()->addClass('date_to end_datepick') !!}
                            </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_pdf" class="headpicture" href="#">Download PDF</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>
            </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 table-responsive">
            <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: 400px; height: 350px; margin: 0 auto">
                                            </div>
                                        </td>
                                    </tr>
                                </table>
                            </td>
                        </tr>
                    </table>
                </div>
            </div>
            <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>Ref No</th>
                        <th>Date & Time</th>
                        <th>Vehicle</th>
                        <th>Plate No.</th>
                        <th>Expense Type</th>
                        <th>Utility Type</th>
                        <th>Supplier</th>
                        <th>Starting KM</th>
                        <th>Closing KM</th>
                        <th>Total KM</th>
                        <th>Quantity</th>
                        <th>Rate</th>
                        <th>Amount</th>
                        <th>Intent</th>
                        <th>Reference No.</th>
                        <th>Driver</th>                    
                        @if (user('admin.web')->currentCompany->requirement_type == 1)		
                            <th>Requirement Type</th>
                        @endif
                        <th>Remarks</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('vehicle_booking') !!}

                            {!! 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
<style>
    .select2-container {
        width: 100% !important;
    }

    label.radio-inline {
        font-size: 12px;
    }
</style>

<script type="text/javascript">
    var chart;


    $(document).ready(function() {

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

        $(".end_datepick").pickadate({
            format: 'dd mmm, yyyy',
            formatSubmit: 'yyyy-mm-dd 23:59:59',
            hiddenSuffix: '',
            selectMonths: true,
            selectYears: true
        }).prop('type', 'text');
        $('#resetnow').click(function() {
            $("input[name='search[vehicle_booking_expenses.created_at][0]']").val('');
            $("input[name='search[vehicle_booking_expenses.created_at][1]']").val('');
            $('#vehiclebookingreportform')[0].reset();
            $('#group_by_label').html('');
            $("#vehicle_id").empty();
            $("#supplier_id").empty();
            $("#user_id").empty();
            oTable.api().draw();
        });

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

        $('#download_csv').click(function() {
            var filter = $("#vehiclebookingreportform").serialize();
            $('#download_csv').attr('href', "{{ URL::to('admin/vehicle_booking/report/graph/csv') }}" +
                "/" + filter);
            $('#download_csv').attr("target", "_blank");
        });


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




        oTable = $('#full_listings').dataTable({
            "bProcessing": true,
            "sDom": 'R<>rt<ilp><"clear">',
            "bServerSide": true,
            "sAjaxSource": '{!! trans_url('admin') !!}/vehicle_booking/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()
                        });
                    }
                );
                $('#vehiclebookingreportform select, #vehiclebookingreportform 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: 'ref'
                },
                {
                    data: 'created_at'
                },
                {
                    data: 'vehicle_name'
                },
                {
                    data: 'vehicle_rfc'
                },
                {
                    data: 'expense_type'
                },
                {
                    data: 'utility_type'
                },
                {
                    data: 'supplier_id'
                },
                {
                    data: 'start_odometer'
                },
                {
                    data: 'closing_odometer'
                },
                {
                    data: 'total_km'
                },
                {
                    data: 'qty'
                },
                {
                    data: 'rate'
                },
                {
                    data: 'amount'
                },
                {
                    data: 'intent'
                },
                {
                    data: 'reference_no'
                },
                {
                    data: 'driver_name'
                },
                @if (user('admin.web')->currentCompany->requirement_type == 1)		
                {
                    data: 'requirement_type'
                },
                @endif
                {
                    data: 'remarks'
                },
            ],

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


        $(document.body).on('click', "#gobutton", function(e) {
            if ($('#date_to').val() != '') {
                var from = $("#date_from").val();
                var to = $("#date_to").val();
                var fromdate = new Date(from);
                var todate = new Date(to);
                if (todate < fromdate) {
                    $("#date_to").addClass("error");
                    toastr.error('Check the date range', 'Error');
                    return false;
                }
            }

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

            $('#full_listings .search_bar').find("." + $(this).attr('id')).prop('disabled', true);
            oTable.api().draw();
        });
        // $('#supplier_id').select2();

        $("#supplier_id").select2({            
            allowClear: true,
            placeholder: 'Select Supplier',
            ajax: {
                url: "{{ trans_url('admin/supplier/select2') }}",
                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: 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 = "<div class='select2-result-repository clearfix'>" +
                "<div class='select2-result'><span>" + repo.name + "</span></div>";

            return markup;
        }


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

        $("#user_id").select2({
            ajax: {
                url: "{{ trans_url('admin/company/drivers/select2') }}",
                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.map(function(obj) {
                            return {
                                id: obj.id,
                                text: obj.name
                            };
                        }),
                        // results: data.items,
                        pagination: {
                            more: (params.page * 30) < data.total_count
                        }
                    };
                },
                cache: false
            },
        });

     
        $("#vehicle_id").select2({
            ajax: {
                url: "{{ trans_url('admin/assets/select-vehicle/asset') }}",
                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: formatRepo, // omitted for brevity, see the source of this page
            templateSelection: formatRepoSelection // omitted for brevity, see the source of this page
        });

        function formatRepo3(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 formatRepo3Selection(repo) {
            return repo.name?repo.name:repo.text;
        }
          


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

            return markup;
        }

        function formatRepoSelection(repo) {
            return repo.name;
        }
    });
</script>

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